	Table	Prefix	Description
1	F4211	SD	Sales Order Detail File
2	F0101	AB	Address Book Master
3	F4101	IM	Item Master
4	F0911	GL	Account Ledger
5	F4311	PD	Purchase Order Detail File
6	F9671	SD	Software Update Detail Table
7	F4102	IB	Item Branch File
8	F0411	RP	Accounts Payable Ledger
9	F0006	MC	Business Unit Master
10	F41021	LI	Item Location File

	Table	Prefix	Description
1	F0011W	IC	F0011W - WF - Batch To Detail
2	F76AUI46	WF	CERG A/R -Work File - ARG - 03B - 76A
3	F4211	SD	Sales Order Detail File
4	F4101	IM	Item Master
5	F0101	AB	Address Book Master
6	F0911	GL	Account Ledger
7	F4102	IB	Item Branch File
8	F03B11	RP	Customer Ledger
9	F4111	IL	Item Ledger File
10	F4311	PD	Purchase Order Detail File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0006	MC	Business Unit Master
5	F0411	RP	Accounts Payable Ledger
6	F4211	SD	Sales Order Detail File
7	F42119	SD	Sales Order History File
8	F03012	AI	Customer Master by Line of Business
9	F0902	GB	Account Balances
10	F4801	WA	Work Order Master File

104 COLUMNS | 11 INDEXES | 812 | 48S | F4822 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
48S: Service Billing
1	812	F4822	W4	104	11	Invoice Summary Work File	Transaction Files	48S: Service Billing	No

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns. For Create statements, use Allow Null checkboxes and default values inputs to tailor query as required.

SELECT W4DOCO, W4DCTO, W4KCOO, W4PCTN, W4PCTT, W4PCKO, W4APPL, W4ADJN, W4COCH, W4LNID, W4OPIM, W4PRTP, W4BLSP, W4AN8O, W4AN8J, W4PTC, W4CO, W4MCU, W4SBL, W4SBLT, W4GLC, W4BTFR, W4BTDT, W4DGL, W4DDJ, W4DSVJ, W4ICU, W4DOCZ, W4DCTI, W4KCOI, W4SFX, W4APDT, W4APPO, W4VOID, W4INVF, W4INTY, W4U, W4UM, W4UP, W4FUP, W4PUHP, W4AA, W4ACR, W4THPD, W4FHPD, W4RTHP, W4PTHP, W4FTHP, W4TXA1, W4EXR1, W4STAM, W4CTAM, W4PTAM, W4FPTA, W4ATXA, W4CTXA, W4PATX, W4FATX, W4ATXN, W4CTXN, W4RTRE, W4RGLC, W4PRET, W4RTNR, W4RCTL, W4RTNG, W4FTNG, W4RTNP, W4FTNP, W4DDTR, W4FDTR, W4STML, W4FTML, W4PSMA, W4FSMA, W4RTN1, W4SMRT, W4SMRF, W4SMRP, W4SMPF, W4TLAB, W4FLAB, W4TBUR, W4FBUR, W4ADSC, W4CDS, W4CRRM, W4CRCD, W4CRCF, W4CRR, W4CRRD, W4RMK, W4MIVL, W4MISM, W4PID, W4JOBN, W4USER, W4MUPM, W4UPMT, W4VGCSF, W4VGCOA, W4VVTY, W4VVTC, W4PYWP FROM F4822

TOP 812 | 48S | F4822 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	W4DOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
2	W4DCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
3	W4KCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
4	W4PCTN	Parent Contract Number	Numeric	Generic Edit	8	0	Allow NULL?
5	W4PCTT	Parent Contract Type	String	UDC (00 DT)	2	0	Allow NULL?
6	W4PCKO	Parent Contract Document Company	String	Generic Edit	5	0	Allow NULL?
7	W4APPL	Application Number	Numeric	Generic Edit	5	0	Allow NULL?
8	W4ADJN	Adjustment Number	Numeric	Generic Edit	3	0	Allow NULL?
9	W4COCH	Contract Change Number	String	Generic Edit	3	0	Allow NULL?
10	W4LNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
11	W4OPIM	Owner Pay Item	String	Generic Edit	15	0	Allow NULL?
12	W4PRTP	Pricing Type - Contracts	Character	UDC (52 PT)	1	0	Allow NULL?
13	W4BLSP	Bill Suspend	Character	UDC (52 BS)	1	0	Allow NULL?
14	W4AN8O	Address Number - Job A/R	Numeric	Generic Edit	8	0	Allow NULL?
15	W4AN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0	Allow NULL?
16	W4PTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
17	W4CO	Company	String	Generic Edit	5	0	Allow NULL?
18	W4MCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
19	W4SBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
20	W4SBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
21	W4GLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
22	W4BTFR	Date - Bill From	Date	Generic Edit	6	0
23	W4BTDT	Billed Through	Date	Generic Edit	6	0
24	W4DGL	Date - For G/L (and Voucher)	Date	Generic Edit	6	0
25	W4DDJ	Date - Net Due	Date	Generic Edit	6	0
26	W4DSVJ	Date - Service/Tax	Date	Generic Edit	6	0
27	W4ICU	Batch Number	Numeric	Generic Edit	8	0	Allow NULL?
28	W4DOCZ	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
29	W4DCTI	Document Type - Invoice Only	String	UDC (00 DI)	2	0	Allow NULL?
30	W4KCOI	Document Company (Invoice)	String	Generic Edit	5	0	Allow NULL?
31	W4SFX	Document Pay Item	String	Generic Edit	3	0	Allow NULL?
32	W4APDT	Application Date	Date	Generic Edit	6	0
33	W4APPO	Application Posted Code	Character	Generic Edit	1	0	Allow NULL?
34	W4VOID	Void (V)	Character	UDC (H09 VO)	1	0	Allow NULL?
35	W4INVF	Invoice Format Code	String	Generic Edit	10	0	Allow NULL?
36	W4INTY	Invoice Type	Character	UDC (48 IT)	1	0	Allow NULL?
37	W4U	Units	Numeric	Generic Edit	15	2	Allow NULL?
38	W4UM	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
39	W4UP	Amount - Price per Unit	Numeric	Generic Edit	15	4	Allow NULL?
40	W4FUP	Amount - Foreign Price per Unit	Numeric	Generic Edit	15	4	Allow NULL?
41	W4PUHP	Previous Billed This Period - Units	Numeric	Generic Edit	15	2	Allow NULL?
42	W4AA	Amount	Numeric	Generic Edit	15	2	Allow NULL?
43	W4ACR	Amount - Currency	Numeric	Generic Edit	15	2	Allow NULL?
44	W4THPD	This Period	Numeric	Generic Edit	15	2	Allow NULL?
45	W4FHPD	This Period - Foreign	Numeric	Generic Edit	15	2	Allow NULL?
46	W4RTHP	This Period - Restated	Numeric	Generic Edit	15	2	Allow NULL?
47	W4PTHP	Previous Billed This Period	Numeric	Generic Edit	15	2	Allow NULL?
48	W4FTHP	Previous Billed This Period - Foreign	Numeric	Generic Edit	15	2	Allow NULL?
49	W4TXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
50	W4EXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
51	W4STAM	Amount - Tax	Numeric	Generic Edit	15	2	Allow NULL?
52	W4CTAM	Amount - Foreign Tax	Numeric	Generic Edit	15	2	Allow NULL?
53	W4PTAM	Amount - Tax - Prior	Numeric	Generic Edit	15	2	Allow NULL?
54	W4FPTA	Amount - Tax - Prior - Foreign	Numeric	Generic Edit	15	2	Allow NULL?
55	W4ATXA	Amount - Taxable	Numeric	Generic Edit	15	2	Allow NULL?
56	W4CTXA	Amount - Foreign Taxable	Numeric	Generic Edit	15	2	Allow NULL?
57	W4PATX	Amount - Taxable - Previous	Numeric	Generic Edit	15	2	Allow NULL?
58	W4FATX	Amount - Taxable - Previous Foreign	Numeric	Generic Edit	15	2	Allow NULL?
59	W4ATXN	Amount - Non-Taxable	Numeric	Generic Edit	15	2	Allow NULL?
60	W4CTXN	Amount - Foreign Non-Taxable	Numeric	Generic Edit	15	2	Allow NULL?
61	W4RTRE	Retainage Release Only	Character	UDC (48 RR)	1	0	Allow NULL?
62	W4RGLC	Retention G/L Offset	String	Generic Edit	4	0	Allow NULL?
63	W4PRET	Percent Retainage	Numeric	Generic Edit	5	2	Allow NULL?
64	W4RTNR	Retainage Rule	String	Generic Edit	3	0	Allow NULL?
65	W4RCTL	Retainage Control Flag	Character	UDC (48S RC)	1	0	Allow NULL?
66	W4RTNG	Retainage	Numeric	Generic Edit	15	2	Allow NULL?
67	W4FTNG	Retainage - Foreign	Numeric	Generic Edit	15	2	Allow NULL?
68	W4RTNP	Retainage - Prior	Numeric	Generic Edit	15	2	Allow NULL?
69	W4FTNP	Retainage - Prior - Foreign	Numeric	Generic Edit	15	2	Allow NULL?
70	W4DDTR	Deferred Tax - Domestic	Numeric	Generic Edit	15	2	Allow NULL?
71	W4FDTR	Deferred Tax - Foreign	Numeric	Generic Edit	15	2	Allow NULL?
72	W4STML	Accrual/Deferral (Stored Materials)	Numeric	Generic Edit	15	2	Allow NULL?
73	W4FTML	Acc/Def (Stored Materials) - Foreign	Numeric	Generic Edit	15	2	Allow NULL?
74	W4PSMA	Previous Billed Stored Material	Numeric	Generic Edit	15	2	Allow NULL?
75	W4FSMA	Prev. Billed Stored Material - Foreign	Numeric	Generic Edit	15	2	Allow NULL?
76	W4RTN1	Retainage Rule - Stored Material	String	Generic Edit	3	0	Allow NULL?
77	W4SMRT	Stored Materials Retainage	Numeric	Generic Edit	15	2	Allow NULL?
78	W4SMRF	Stored Materials Retainage - Foreign	Numeric	Generic Edit	15	2	Allow NULL?
79	W4SMRP	Stored Materials Retainage - Prior Amt	Numeric	Generic Edit	15	2	Allow NULL?
80	W4SMPF	Stored Materials Retainage - Prior-For	Numeric	Generic Edit	15	2	Allow NULL?
81	W4TLAB	Amount - Total Labor	Numeric	Generic Edit	15	2	Allow NULL?
82	W4FLAB	Amount - Foreign Total Labor	Numeric	Generic Edit	15	2	Allow NULL?
83	W4TBUR	Amount - Total Burden	Numeric	Generic Edit	15	2	Allow NULL?
84	W4FBUR	Amount - Foreign Total Burden	Numeric	Generic Edit	15	2	Allow NULL?
85	W4ADSC	Discount Available	Numeric	Generic Edit	15	2	Allow NULL?
86	W4CDS	Amount - Foreign Discount Available	Numeric	Generic Edit	15	2	Allow NULL?
87	W4CRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
88	W4CRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
89	W4CRCF	Currency Code - Origin	String	Generic Edit	3	0	Allow NULL?
90	W4CRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
91	W4CRRD	Currency Conversion Rate - Divisor	Numeric	Generic Edit	15	0	Allow NULL?
92	W4RMK	Name - Remark	String	Generic Edit	30	0	Allow NULL?
93	W4MIVL	Mode of Input - Values	Character	Generic Edit	1	0	Allow NULL?
94	W4MISM	Mode of Input - SM	Character	Generic Edit	1	0	Allow NULL?
95	W4PID	Program ID	String	Generic Edit	10	0	Allow NULL?
96	W4JOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
97	W4USER	User ID	String	Generic Edit	10	0	Allow NULL?
98	W4MUPM	Date - Updated	Date	Generic Edit	6	0
99	W4UPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
100	W4VGCSF	GeoCode Ship From	String	Generic Edit	10	0	Allow NULL?
101	W4VGCOA	GeoCode Order Accept	String	Generic Edit	10	0	Allow NULL?
102	W4VVTY	Vertex Transaction Type	String	UDC (73 TY)	6	0	Allow NULL?
103	W4VVTC	Vertex Product Category	String	UDC (73 PC)	10	0	Allow NULL?
104	W4PYWP	Pay When Paid	Character	Generic Edit	1	0	Allow NULL?

TOP 812 | 48S | F4822 INDEXES

Number

Description

Invoice Number Invoice Type + (Primary/Unique)

Element	Alias	Description	Sequence
1	DOCZ	Document (Order # Invoice etc.)	Ascending
2	DCTI	Document Type - Invoice Only	Ascending
3	KCOI	Document Company (Invoice)	Ascending
4	SFX	Document Pay Item	Ascending

Batch Number Invoice Number +

Element	Alias	Description	Sequence
1	ICU	Batch Number	Ascending
2	DOCZ	Document (Order # Invoice etc.)	Ascending
3	DCTI	Document Type - Invoice Only	Ascending
4	KCOI	Document Company (Invoice)	Ascending

Invoice Number Doc Type +

Element	Alias	Description	Sequence
1	DOCZ	Document (Order # Invoice etc.)	Ascending
2	DCTI	Document Type - Invoice Only	Ascending
3	KCOI	Document Company (Invoice)	Ascending
4	ICU	Batch Number	Ascending
5	SFX	Document Pay Item	Ascending

Contract Number Type +A

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	DCTO	Order Type	Ascending
3	KCOO	Order Company (Order Number)	Ascending
4	COCH	Contract Change Number	Ascending
5	LNID	Line Number	Ascending

Contract Number Type +B

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	DCTO	Order Type	Ascending
3	KCOO	Order Company (Order Number)	Ascending
4	APPL	Application Number	Ascending
5	ADJN	Adjustment Number	Ascending
6	COCH	Contract Change Number	Ascending
7	LNID	Line Number	Ascending

Contract Number Type +C

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	DCTO	Order Type	Ascending
3	KCOO	Order Company (Order Number)	Ascending
4	COCH	Contract Change Number	Ascending
5	LNID	Line Number	Ascending
6	APPL	Application Number	Ascending
7	ADJN	Adjustment Number	Ascending

Contract Number Type +D

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	DCTO	Order Type	Ascending
3	KCOO	Order Company (Order Number)	Ascending
4	APPO	Application Posted Code	Ascending

Batch Number Address Number +

Element	Alias	Description	Sequence
1	ICU	Batch Number	Ascending
2	AN8O	Address Number - Job A/R	Ascending
3	KCOI	Document Company (Invoice)	Ascending
4	DOCZ	Document (Order # Invoice etc.)	Ascending
5	DCTI	Document Type - Invoice Only	Ascending

Contract Number Type +E

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	DCTO	Order Type	Ascending
3	KCOO	Order Company (Order Number)	Ascending
4	APPL	Application Number	Descending
5	ADJN	Adjustment Number	Descending
6	COCH	Contract Change Number	Ascending
7	LNID	Line Number	Ascending

Contract Number Type +F

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	DCTO	Order Type	Ascending
3	KCOO	Order Company (Order Number)	Ascending
4	COCH	Contract Change Number	Ascending
5	LNID	Line Number	Ascending
6	APPL	Application Number	Descending
7	ADJN	Adjustment Number	Descending

Contract Number Type +G

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	DCTO	Order Type	Ascending
3	KCOO	Order Company (Order Number)	Ascending

JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

JDE TABLESv3

920: Top 10 requests

910: Top 10 requests

812: Top 10 requests

104 COLUMNS | 11 INDEXES | 812 | 48S | F4822 TABLE

TOP 812 | 48S | F4822 COLUMNS

TOP 812 | 48S | F4822 INDEXES

JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

JDE TABLESv3

920: Top 10 requests

910: Top 10 requests

812: Top 10 requests

104 COLUMNS | 11 INDEXES | 812 | 48S | F4822 TABLE

TOP812 | 48S | F4822 COLUMNS

TOP812 | 48S | F4822 INDEXES

TOP 812 | 48S | F4822 COLUMNS

TOP 812 | 48S | F4822 INDEXES