	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

199 COLUMNS | 28 INDEXES | 812 | 48S | F4812 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
48S: Service Billing
1	812	F4812	WD	199	28	Billing Detail Workfile	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 WDDCT, WDDOC, WDKCO, WDDGL, WDJELN, WDAID, WDMCU, WDRP11, WDOBJ, WDSUB, WDSBL, WDSBLT, WDOPSQ, WDWR01, WDWR07, WDLT, WDCTRY, WDFY, WDPN, WDCO, WDODCT, WDOSFX, WDODOC, WDOKCO, WDPO, WDPDCT, WDPKCO, WDPSFX, WDOGNO, WDR001, WDR002, WDR003, WDPRTR, WDJBCD, WDJBST, WDPDBA, WDPTAX, WDEQCG, WDEQWO, WDACL0, WDERC, WDAN8, WDDC, WDHMCU, WDJMCU, WDRP12, WDDSVJ, WDDAGO, WDAGS, WDEXA, WDEXR, WDPCFG, WDPRIC, WDU, WDUM, WDAA, WDDOCM, WDDOCO, WDDCTO, WDKCOO, WDCOCH, WDLNID, WDOPIM, WDPCTN, WDPCTT, WDPCKO, WDPRSQ, WDSBSQ, WDSCSQ, WDBCI, WDLSSQ, WDPMSQ, WDLSPM, WDTCLS, WDELGC, WDJRST, WDICUJ, WDIVD, WDHLD, WDRDJ, WDVOID, WDICUA, WDJRSP, WDBDPN, WDSLNK, WDCLNK, WDCCOD, WDCCR, WDCINR, WDCRVR, WDSBAR, WDTBDT, WDCAP, WDBRT, WDPERT, WDADCR, WDCAPI, WDBRTI, WDPCIM, WDADCI, WDTX, WDTOG, WDEXR1, WDTXA1, WDDCP, WDJTAX, WDJTXF, WDBTOL, WDCRCD, WDCRR, WDCRRM, WDFTOL, WDITOL, WDITXA, WDITAM, WDIDSC, WDCITL, WDCITA, WDCITX, WDCIDS, WDIJST, WDPRTF, WDICU, WDAN8O, WDVINV, WDDI, WDDOCZ, WDDCTI, WDKCOI, WDSFX, WDSBSK, WDBLKK, WDAID5, WDSBL5, WDSBT5, WDAID6, WDSBL6, WDSBT6, WDAREX, WDGLC, WDRGLC, WDPRET, WDRTNG, WDRTPS, WDFRTN, WDDWNL, WDCBLC, WDDEJ, WDCRRD, WDCRCE, WDCRCF, WDAA2, WDTYKY, WDDGJ, WDIDGJ, WDPTFG, WDITM, WDPAID, WDFEA, WDERDB, WDERDT, WDSUBA, WDBCTK, WDPARS, WDPRGR, WDCPGP, WDBBF, WDMKRP, WDFBAS, WDRFBS, WDTKM1, WDTKM2, WDTKM3, WDTKA1, WDTKA2, WDTKA3, WDTKG1, WDTKT1, WDHBTL, WDHITL, WDHITX, WDHTAM, WDPRIF, WDNCTL, WDUSER, WDJOBN, WDPID, WDUPMJ, WDUPMT, WDVGCSF, WDVGCOA, WDVVTY, WDVVTC, WDRAS, WDRAG, WDJPGC, WDAA3, WDACR, WDBUF FROM F4812

TOP 812 | 48S | F4812 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	WDDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
2	WDDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
3	WDKCO	Document Company	String	Generic Edit	5	0	Allow NULL?
4	WDDGL	Date - For G/L (and Voucher)	Date	Generic Edit	6	0
5	WDJELN	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
6	WDAID	Account ID	String	Generic Edit	8	0	Allow NULL?
7	WDMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
8	WDRP11	Category Code - Business Unit 11	String	UDC (00 11)	3	0	Allow NULL?
9	WDOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
10	WDSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
11	WDSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
12	WDSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
13	WDOPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2	Allow NULL?
14	WDWR01	Categories - Work Order 01	String	UDC (00 W1)	4	0	Allow NULL?
15	WDWR07	EnterpriseOne Consulting - Service Type	String	UDC (00 W7)	3	0	Allow NULL?
16	WDLT	Ledger Types	String	UDC (09 LT)	2	0	Allow NULL?
17	WDCTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
18	WDFY	Fiscal Year	Numeric	Generic Edit	2	0	Allow NULL?
19	WDPN	Period Number - General Ledger	Numeric	Generic Edit	2	0	Allow NULL?
20	WDCO	Company	String	Generic Edit	5	0	Allow NULL?
21	WDODCT	Document Type - Original	String	UDC (00 DT)	2	0	Allow NULL?
22	WDOSFX	Document Pay Item - Original	String	Generic Edit	3	0	Allow NULL?
23	WDODOC	Document - Original	Numeric	Generic Edit	8	0	Allow NULL?
24	WDOKCO	Document Company (Original Order)	String	Generic Edit	5	0	Allow NULL?
25	WDPO	Purchase Order	String	Generic Edit	8	0	Allow NULL?
26	WDPDCT	Document Type - Purchase Order	String	UDC (00 DT)	2	0	Allow NULL?
27	WDPKCO	Document Company (Purchase Order)	String	Generic Edit	5	0	Allow NULL?
28	WDPSFX	Purchase Order Suffix	String	Generic Edit	3	0	Allow NULL?
29	WDOGNO	Original Line Number	Numeric	Generic Edit	7	3	Allow NULL?
30	WDR001	Category Code - G/L1	String	UDC (09 01)	3	0	Allow NULL?
31	WDR002	Category Code - G/L2	String	UDC (09 02)	3	0	Allow NULL?
32	WDR003	Category Code - G/L3	String	UDC (09 03)	3	0	Allow NULL?
33	WDPRTR	Transaction No. - Payroll	Numeric	Generic Edit	9	0	Allow NULL?
34	WDJBCD	Job Type (Craft) Code	String	UDC (06 G)	6	0	Allow NULL?
35	WDJBST	Job Step	String	UDC (06 GS)	4	0	Allow NULL?
36	WDPDBA	DBA Code	Numeric	Generic Edit	5	0	Allow NULL?
37	WDPTAX	Tax Type	String	UDC (06 TX)	2	0	Allow NULL?
38	WDEQCG	Equipment Worked	String	Generic Edit	9	0	Allow NULL?
39	WDEQWO	Equipment Worked On	String	Generic Edit	9	0	Allow NULL?
40	WDACL0	Category Code - F/A 10 (Rate Group)	String	UDC (12 C0)	3	0	Allow NULL?
41	WDERC	Equipment Rate Code	String	UDC (00 RC)	2	0	Allow NULL?
42	WDAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
43	WDDC	Description - Compressed	String	Generic Edit	40	0	Allow NULL?
44	WDHMCU	Business Unit - Home	String	Generic Edit	12	0	Allow NULL?
45	WDJMCU	Business Unit - Host	String	Generic Edit	12	0	Allow NULL?
46	WDRP12	Category Code - Business Unit 12	String	UDC (00 12)	3	0	Allow NULL?
47	WDDSVJ	Date - Service/Tax	Date	Generic Edit	6	0
48	WDDAGO	Date - Age Override	Date	Generic Edit	6	0
49	WDAGS	Suspend Aging	Character	Generic Edit	1	0	Allow NULL?
50	WDEXA	Name - Alpha Explanation	String	Generic Edit	30	0	Allow NULL?
51	WDEXR	Name - Remark Explanation	String	Generic Edit	30	0	Allow NULL?
52	WDPCFG	Burden Flag	Character	UDC (48 PC)	1	0	Allow NULL?
53	WDPRIC	Unit Price per Primary	Numeric	Generic Edit	15	4	Allow NULL?
54	WDU	Units	Numeric	Generic Edit	15	2	Allow NULL?
55	WDUM	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
56	WDAA	Amount	Numeric	Generic Edit	15	2	Allow NULL?
57	WDDOCM	Document - Matching(Payment or Item)	Numeric	Generic Edit	8	0	Allow NULL?
58	WDDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
59	WDDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
60	WDKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
61	WDCOCH	Contract Change Number	String	Generic Edit	3	0	Allow NULL?
62	WDLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
63	WDOPIM	Owner Pay Item	String	Generic Edit	15	0	Allow NULL?
64	WDPCTN	Parent Contract Number	Numeric	Generic Edit	8	0	Allow NULL?
65	WDPCTT	Parent Contract Type	String	UDC (00 DT)	2	0	Allow NULL?
66	WDPCKO	Parent Contract Document Company	String	Generic Edit	5	0	Allow NULL?
67	WDPRSQ	Parent Sequence Number	Numeric	Generic Edit	3	0	Allow NULL?
68	WDSBSQ	Sequence Number	Numeric	Generic Edit	3	0	Allow NULL?
69	WDSCSQ	Secondary Sequence Number	Numeric	Generic Edit	3	0	Allow NULL?
70	WDBCI	Billing Control ID	Numeric	Generic Edit	8	0	Allow NULL?
71	WDLSSQ	Process Complete	Character	UDC (48 LQ)	1	0	Allow NULL?
72	WDPMSQ	Payment Sequence Number	Numeric	Generic Edit	3	0	Allow NULL?
73	WDLSPM	Revenue Completed	Character	UDC (48 LS)	1	0	Allow NULL?
74	WDTCLS	Transaction Classification	Character	UDC (48 TC)	1	0	Allow NULL?
75	WDELGC	Eligibility Code	Character	UDC (48 EL)	1	0	Allow NULL?
76	WDJRST	Journal Status Code	Character	UDC (48 JR)	1	0	Allow NULL?
77	WDICUJ	Batch Number - Revenue	Numeric	Generic Edit	8	0	Allow NULL?
78	WDIVD	Date - Invoice	Date	Generic Edit	6	0
79	WDHLD	Hold Code - Service Billing Transaction	Character	UDC (48 HL)	1	0	Allow NULL?
80	WDRDJ	Date - Released (Julian)	Date	Generic Edit	6	0
81	WDVOID	Void (V)	Character	UDC (H09 VO)	1	0	Allow NULL?
82	WDICUA	Batch Number - Active	Numeric	Generic Edit	8	0	Allow NULL?
83	WDJRSP	Journal Status Code - Previous	Character	UDC (48 JR)	1	0	Allow NULL?
84	WDBDPN	Burden Pending	Character	UDC (48 BE)	1	0	Allow NULL?
85	WDSLNK	Split Link	Numeric	Generic Edit	11	0	Allow NULL?
86	WDCLNK	Component Link	Numeric	Generic Edit	11	0	Allow NULL?
87	WDCCOD	Component Code	String	UDC (48 CM)	5	0	Allow NULL?
88	WDCCR	Component Cost Rate Table	String	Generic Edit	10	0	Allow NULL?
89	WDCINR	Component Invoice Rate Table	String	Generic Edit	10	0	Allow NULL?
90	WDCRVR	Component Revenue Rate Table	String	Generic Edit	10	0	Allow NULL?
91	WDSBAR	Adjustment Reason Code	String	UDC (48 AR)	2	0	Allow NULL?
92	WDTBDT	Date - Table Basis (Julian)	Date	Generic Edit	6	0
93	WDCAP	Cap or Override Rate	Character	UDC (48 CA)	1	0	Allow NULL?
94	WDBRT	Revenue Rate Markup Override	Numeric	Generic Edit	15	2	Allow NULL?
95	WDPERT	Percentage - Revenue Markup	Numeric	Generic Edit	7	3	Allow NULL?
96	WDADCR	Amount - Revenue Markup	Numeric	Generic Edit	15	2	Allow NULL?
97	WDCAPI	Cap or Override Rate - Invoice	Character	UDC (48 CB)	1	0	Allow NULL?
98	WDBRTI	Invoice Markup Rate Override	Numeric	Generic Edit	15	2	Allow NULL?
99	WDPCIM	Percentage - Invoice Markup	Numeric	Generic Edit	7	3	Allow NULL?
100	WDADCI	Amount - Invoice Markup	Numeric	Generic Edit	15	2	Allow NULL?
101	WDTX	Purchasing Taxable (Y/N)	Character	UDC (H00 TV)	1	0	Allow NULL?
102	WDTOG	Taxable or Gross	Character	UDC (48 TO)	1	0	Allow NULL?
103	WDEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
104	WDTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
105	WDDCP	Discount % - Payment Terms	Numeric	Generic Edit	5	0	Allow NULL?
106	WDJTAX	Amount - Journaled Tax	Numeric	Generic Edit	15	2	Allow NULL?
107	WDJTXF	Amount - Journaled Tax - Foreign	Numeric	Generic Edit	15	2	Allow NULL?
108	WDBTOL	Amount - Revenue	Numeric	Generic Edit	15	2	Allow NULL?
109	WDCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
110	WDCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
111	WDCRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
112	WDFTOL	Amount - Foreign Total Billed	Numeric	Generic Edit	15	2	Allow NULL?
113	WDITOL	Amount - Invoice	Numeric	Generic Edit	15	2	Allow NULL?
114	WDITXA	Amount - Invoice taxable	Numeric	Generic Edit	15	2	Allow NULL?
115	WDITAM	Amount - Invoice Tax	Numeric	Generic Edit	15	2	Allow NULL?
116	WDIDSC	Amount - Invoice Discount Available	Numeric	Generic Edit	15	2	Allow NULL?
117	WDCITL	Amount - Foreign Invoiced	Numeric	Generic Edit	15	2	Allow NULL?
118	WDCITA	Amount - Foreign invoice taxable	Numeric	Generic Edit	15	2	Allow NULL?
119	WDCITX	Amount - Foreign Invoice Tax	Numeric	Generic Edit	15	2	Allow NULL?
120	WDCIDS	Amount - Foreign Invoice Discount Avail	Numeric	Generic Edit	15	2	Allow NULL?
121	WDIJST	Invoice Journal Status Code	Character	UDC (48 IJ)	1	0	Allow NULL?
122	WDPRTF	Printed Flag	Character	UDC (48 PS)	1	0	Allow NULL?
123	WDICU	Batch Number	Numeric	Generic Edit	8	0	Allow NULL?
124	WDAN8O	Address Number - Job A/R	Numeric	Generic Edit	8	0	Allow NULL?
125	WDVINV	Supplier Invoice Number	String	Generic Edit	25	0	Allow NULL?
126	WDDI	Date - Invoice	Date	Generic Edit	6	0
127	WDDOCZ	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
128	WDDCTI	Document Type - Invoice Only	String	UDC (00 DI)	2	0	Allow NULL?
129	WDKCOI	Document Company (Invoice)	String	Generic Edit	5	0	Allow NULL?
130	WDSFX	Document Pay Item	String	Generic Edit	3	0	Allow NULL?
131	WDSBSK	Summarization Key - Service Billing	String	Generic Edit	4	0	Allow NULL?
132	WDBLKK	Composite Key Block	String	Generic Edit	80	0	Allow NULL?
133	WDAID5	Account ID	String	Generic Edit	8	0	Allow NULL?
134	WDSBL5	Subledger	String	Generic Edit	8	0	Allow NULL?
135	WDSBT5	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
136	WDAID6	Account ID	String	Generic Edit	8	0	Allow NULL?
137	WDSBL6	Subledger	String	Generic Edit	8	0	Allow NULL?
138	WDSBT6	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
139	WDAREX	Override Bill When Paid Rule	Character	UDC (52 OR)	1	0	Allow NULL?
140	WDGLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
141	WDRGLC	Retention G/L Offset	String	Generic Edit	4	0	Allow NULL?
142	WDPRET	Percent Retainage	Numeric	Generic Edit	5	2	Allow NULL?
143	WDRTNG	Retainage	Numeric	Generic Edit	15	2	Allow NULL?
144	WDRTPS	Retainage - Prior - Stored Material	Numeric	Generic Edit	15	2	Allow NULL?
145	WDFRTN	Foreign Retainage	Numeric	Generic Edit	15	2	Allow NULL?
146	WDDWNL	Download Flag - Service Billing	Character	UDC (48 DW)	1	0	Allow NULL?
147	WDCBLC	Coding Block Change	Character	UDC (48 CO)	1	0	Allow NULL?
148	WDDEJ	Date - Transaction Entered	Date	Generic Edit	6	0
149	WDCRRD	Currency Conversion Rate - Divisor	Numeric	Generic Edit	15	0	Allow NULL?
150	WDCRCE	Currency Code - Source	String	Generic Edit	3	0	Allow NULL?
151	WDCRCF	Currency Code - Origin	String	Generic Edit	3	0	Allow NULL?
152	WDAA2	Amount	Numeric	Generic Edit	15	2	Allow NULL?
153	WDTYKY	Key Type	Character	UDC (48 TY)	1	0	Allow NULL?
154	WDDGJ	Date - For G/L (and Voucher) - Julian	Date	Generic Edit	6	0
155	WDIDGJ	Date - Invoice Journal Date - Julian	Date	Generic Edit	6	0
156	WDPTFG	Pay When Paid Flag	Character	Generic Edit	1	0	Allow NULL?
157	WDITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
158	WDPAID	Amount - Extended Cost/Price	Numeric	Generic Edit	15	2	Allow NULL?
159	WDFEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
160	WDERDB	Date - Exchange Rate Date Basis	Character	Generic Edit	1	0	Allow NULL?
161	WDERDT	Date - Exchange Rate	Date	Generic Edit	6	0
162	WDSUBA	Subsidiary - Alternate	String	Generic Edit	8	0	Allow NULL?
163	WDBCTK	Batch Control Key	String	Generic Edit	10	0	Allow NULL?
164	WDPARS	Number - Parent WO Number	String	Generic Edit	8	0	Allow NULL?
165	WDPRGR	Item Price Group	String	UDC (40 PI)	8	0	Allow NULL?
166	WDCPGP	Customer Price Group	String	UDC (40 PC)	8	0	Allow NULL?
167	WDBBF	Billing Basis Flag	Character	Generic Edit	1	0	Allow NULL?
168	WDMKRP	% Fee	Numeric	Generic Edit	9	4	Allow NULL?
169	WDFBAS	Invoice Fee Basis	Character	UDC (H50 FB)	1	0	Allow NULL?
170	WDRFBS	Revenue Fee Basis	Character	UDC (H50 RF)	1	0	Allow NULL?
171	WDTKM1	Key Type - Markup Table Type 1	Character	UDC (48 TY)	1	0	Allow NULL?
172	WDTKM2	Key Type - Markup Table Type 2	Character	UDC (48 TY)	1	0	Allow NULL?
173	WDTKM3	Key Type - Markup Table Type 3	Character	UDC (48 TY)	1	0	Allow NULL?
174	WDTKA1	Key Type - Acct Derivation Table 1	Character	UDC (48 TY)	1	0	Allow NULL?
175	WDTKA2	Key Type - Acct Derivation Table 2	Character	UDC (48 TY)	1	0	Allow NULL?
176	WDTKA3	Key Type - Acct Derivation Table 3	Character	UDC (48 TY)	1	0	Allow NULL?
177	WDTKG1	Key Type - G/L Offset Table	Character	UDC (48 TY)	1	0	Allow NULL?
178	WDTKT1	Key Type - Tax Derivation Table	Character	UDC (48 TY)	1	0	Allow NULL?
179	WDHBTL	Amount - Revenue - Historical	Numeric	Generic Edit	15	2	Allow NULL?
180	WDHITL	Amount - Invoice - Historical	Numeric	Generic Edit	15	2	Allow NULL?
181	WDHITX	Amount - Invoice Taxable- Historical	Numeric	Generic Edit	15	2	Allow NULL?
182	WDHTAM	Amount - Invoice Taxable- Historical	Numeric	Generic Edit	15	2	Allow NULL?
183	WDPRIF	Unit Price per Primary-Foreign	Numeric	Generic Edit	15	4	Allow NULL?
184	WDNCTL	NTE Control Flag	Character	Generic Edit	1	0	Allow NULL?
185	WDUSER	User ID	String	Generic Edit	10	0	Allow NULL?
186	WDJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
187	WDPID	Program ID	String	Generic Edit	10	0	Allow NULL?
188	WDUPMJ	Date - Updated	Date	Generic Edit	6	0
189	WDUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
190	WDVGCSF	GeoCode Ship From	String	Generic Edit	10	0	Allow NULL?
191	WDVGCOA	GeoCode Order Accept	String	Generic Edit	10	0	Allow NULL?
192	WDVVTY	Vertex Transaction Type	String	UDC (73 TY)	6	0	Allow NULL?
193	WDVVTC	Vertex Product Category	String	UDC (73 PC)	10	0	Allow NULL?
194	WDRAS	Retro Adjustment Status	Character	UDC (48S RS)	1	0	Allow NULL?
195	WDRAG	Retro Adjustment Group	Numeric	Generic Edit	8	0	Allow NULL?
196	WDJPGC	Job Pool Grouping Code	String	UDC (00 12)	3	0	Allow NULL?
197	WDAA3	Amount	Numeric	Generic Edit	15	2	Allow NULL?
198	WDACR	Amount - Currency	Numeric	Generic Edit	15	2	Allow NULL?
199	WDBUF	Burdening Used Flag	Character	Generic Edit	1	0	Allow NULL?

TOP 812 | 48S | F4812 INDEXES

Number

Description

Billing Cntl ID G/L Date + (Primary/Unique)

Element	Alias	Description	Sequence
1	BCI	Billing Control ID	Ascending
2	DGL	Date - For G/L (and Voucher)	Ascending
3	SBSQ	Sequence Number	Ascending
4	PRSQ	Parent Sequence Number	Ascending
5	SCSQ	Secondary Sequence Number	Ascending
6	SLNK	Split Link	Ascending
7	CLNK	Component Link	Ascending
8	CCOD	Component Code	Ascending

Batch Number Order 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
5	SFX	Document Pay Item	Ascending

Business Unit Object +

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	OBJ	Object Account	Ascending
3	SUB	Subsidiary	Ascending
4	DGL	Date - For G/L (and Voucher)	Ascending
5	SBL	Subledger - G/L	Ascending
6	SBLT	Subledger Type	Ascending
7	JBCD	Job Type (Craft) Code	Ascending
8	JBST	Job Step	Ascending

Rev. Batch Customer Number +

Element	Alias	Description	Sequence
1	ICUJ	Batch Number - Revenue	Ascending
2	AN8O	Address Number - Job A/R	Ascending
3	MCU	Business Unit	Ascending
4	OBJ	Object Account	Ascending
5	SUB	Subsidiary	Ascending
6	SBL	Subledger - G/L	Ascending
7	SBLT	Subledger Type	Ascending
8	JBCD	Job Type (Craft) Code	Ascending
9	JBST	Job Step	Ascending
10	DGL	Date - For G/L (and Voucher)	Ascending

Active Batch Subledger +

Element	Alias	Description	Sequence
1	ICUA	Batch Number - Active	Ascending
2	SBL	Subledger - G/L	Ascending
3	SBLT	Subledger Type	Ascending
4	DOCO	Document (Order No Invoice etc.)	Ascending
5	DCTO	Order Type	Ascending
6	KCOO	Order Company (Order Number)	Ascending
7	AN8	Address Number	Ascending
8	MCU	Business Unit	Ascending
9	OBJ	Object Account	Ascending
10	SUB	Subsidiary	Ascending
11	BCI	Billing Control ID	Ascending
12	SLNK	Split Link	Ascending
13	CLNK	Component Link	Ascending
14	TBDT	Date - Table Basis (Julian)	Ascending
15	HMCU	Business Unit - Home	Ascending
16	CCOD	Component Code	Ascending

Batch Number Summ Key +

Element	Alias	Description	Sequence
1	ICU	Batch Number	Ascending
2	SBSK	Summarization Key - Service Billing	Ascending
3	BLKK	Composite Key Block	Ascending
4	GLC	G/L Offset	Ascending
5	EXR1	Tax Expl Code 1	Ascending
6	TXA1	Tax Rate/Area	Ascending
7	CRCD	Currency Code - From	Ascending

Contract Number Cont. Type +

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	TCLS	Transaction Classification	Ascending
7	MCU	Business Unit	Ascending
8	SUB	Subsidiary	Ascending
9	OBJ	Object Account	Ascending

EQ Worked Customer +

Element	Alias	Description	Sequence
1	EQCG	Equipment Worked	Ascending
2	AN8O	Address Number - Job A/R	Ascending
3	MCU	Business Unit	Ascending
4	OBJ	Object Account	Ascending
5	SUB	Subsidiary	Ascending

Address Number Cust. Number +

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	AN8O	Address Number - Job A/R	Ascending
3	MCU	Business Unit	Ascending
4	OBJ	Object Account	Ascending
5	SUB	Subsidiary	Ascending
6	JBCD	Job Type (Craft) Code	Ascending
7	JBST	Job Step	Ascending
8	DGL	Date - For G/L (and Voucher)	Ascending

Invoice Number Inv. 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	SFX	Document Pay Item	Ascending
5	MCU	Business Unit	Ascending
6	OBJ	Object Account	Ascending
7	SUB	Subsidiary	Ascending
8	JBCD	Job Type (Craft) Code	Ascending

Active Batch No. Cntr No. +

Element	Alias	Description	Sequence
1	ICUA	Batch Number - Active	Ascending
2	DOCO	Document (Order No Invoice etc.)	Ascending
3	DCTO	Order Type	Ascending
4	KCOO	Order Company (Order Number)	Ascending
5	COCH	Contract Change Number	Ascending
6	LNID	Line Number	Ascending
7	ELGC	Eligibility Code	Ascending

Contract Number Cntr Type +

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	OPIM	Owner Pay Item	Ascending
6	DOCZ	Document (Order # Invoice etc.)	Ascending
7	DCTI	Document Type - Invoice Only	Ascending
8	KCOI	Document Company (Invoice)	Ascending
9	TCLS	Transaction Classification	Ascending

Batch No. Contract Number +

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

Address No. P/R Trans. No. +

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	PRTR	Transaction No. - Payroll	Ascending
3	PDBA	DBA Code	Ascending
4	PTAX	Tax Type	Ascending

Contr Number Cont Type +

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	MCU	Business Unit	Ascending
7	SUB	Subsidiary	Ascending
8	OBJ	Object Account	Ascending

Account ID Billing Cntl ID +

Element	Alias	Description	Sequence
1	AID	Account ID	Ascending
2	BCI	Billing Control ID	Ascending
3	DGL	Date - For G/L (and Voucher)	Ascending
4	SBSQ	Sequence Number	Ascending
5	SCSQ	Secondary Sequence Number	Ascending

Batch Number Subledger +

Element	Alias	Description	Sequence
1	ICU	Batch Number	Ascending
2	SBL	Subledger - G/L	Ascending
3	SBLT	Subledger Type	Ascending
4	MCU	Business Unit	Ascending
5	DOCO	Document (Order No Invoice etc.)	Ascending
6	DCTO	Order Type	Ascending
7	KCOO	Order Company (Order Number)	Ascending
8	AN8	Address Number	Ascending
9	OBJ	Object Account	Ascending
10	SUB	Subsidiary	Ascending
11	TBDT	Date - Table Basis (Julian)	Ascending

Split Link Component Link +

Element	Alias	Description	Sequence
1	SLNK	Split Link	Ascending
2	CLNK	Component Link	Ascending
3	CCOD	Component Code	Ascending

Split Link Comp Link +

Element	Alias	Description	Sequence
1	SLNK	Split Link	Ascending
2	CLNK	Component Link	Ascending
3	BCI	Billing Control ID	Ascending

Component Link Comp. Code +

Element	Alias	Description	Sequence
1	CLNK	Component Link	Ascending
2	CCOD	Component Code	Ascending

Customer No. Business Unit +

Element	Alias	Description	Sequence
1	AN8O	Address Number - Job A/R	Ascending
2	MCU	Business Unit	Ascending
3	OBJ	Object Account	Ascending
4	SUB	Subsidiary	Ascending
5	SBL	Subledger - G/L	Ascending
6	SBLT	Subledger Type	Ascending
7	JBCD	Job Type (Craft) Code	Ascending
8	JBST	Job Step	Ascending
9	DGL	Date - For G/L (and Voucher)	Ascending

Batch Number Document Number +

Element	Alias	Description	Sequence
1	ICU	Batch Number	Ascending
2	DOC	Document (Voucher Invoice etc.)	Ascending
3	DCT	Document Type	Ascending
4	KCO	Document Company	Ascending

Doc Type Address Number +

Element	Alias	Description	Sequence
1	DCT	Document Type	Ascending
2	AN8	Address Number	Ascending
3	PRTR	Transaction No. - Payroll	Ascending
4	TCLS	Transaction Classification	Ascending

Batch Number Contract No +B

Element	Alias	Description	Sequence
1	ICU	Batch Number	Descending
2	DOCO	Document (Order No Invoice etc.)	Descending
3	DCTO	Order Type	Ascending
4	KCOO	Order Company (Order Number)	Ascending
5	COCH	Contract Change Number	Ascending
6	LNID	Line Number	Ascending
7	CCR	Component Cost Rate Table	Ascending

Trans Class Invoice No. +

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

Rev Batch No Component Code

Element	Alias	Description	Sequence
1	ICUJ	Batch Number - Revenue	Ascending
2	CCOD	Component Code	Ascending

G/L Date BCI +

Element	Alias	Description	Sequence
1	DGL	Date - For G/L (and Voucher)	Ascending
2	PRSQ	Parent Sequence Number	Ascending
3	SBSQ	Sequence Number	Ascending
4	SCSQ	Secondary Sequence Number	Ascending
5	BCI	Billing Control ID	Ascending
6	SLNK	Split Link	Ascending
7	CCOD	Component Code	Ascending

Retro Adjustment Group

Element	Alias	Description	Sequence
1	RAG	Retro Adjustment Group	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

199 COLUMNS | 28 INDEXES | 812 | 48S | F4812 TABLE

TOP 812 | 48S | F4812 COLUMNS

TOP 812 | 48S | F4812 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

199 COLUMNS | 28 INDEXES | 812 | 48S | F4812 TABLE

TOP812 | 48S | F4812 COLUMNS

TOP812 | 48S | F4812 INDEXES

TOP 812 | 48S | F4812 COLUMNS

TOP 812 | 48S | F4812 INDEXES