	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 | 20 INDEXES | 812 | 48S | F4812HS TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
48S: Service Billing
1	812	F4812HS	WD	199	20	Billing Workfile History Purged Save	History Files	48S: Service Billing	Business Data

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, WDBUF, WDAA3, WDACR FROM F4812HS

TOP 812 | 48S | F4812HS 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	WDBUF	Burdening Used Flag	Character	Generic Edit	1	0	Allow NULL?
198	WDAA3	Amount	Numeric	Generic Edit	15	2	Allow NULL?
199	WDACR	Amount - Currency	Numeric	Generic Edit	15	2	Allow NULL?

TOP 812 | 48S | F4812HS INDEXES

Number

Description

Billing Control 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	PRSQ	Parent Sequence Number	Ascending
4	SBSQ	Sequence Number	Ascending
5	SCSQ	Secondary Sequence Number	Ascending
6	SLNK	Split Link	Ascending
7	CLNK	Component Link	Ascending
8	CCOD	Component Code	Ascending

Billing Cntl ID G/L Date +

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	SLNK	Split Link	Ascending
5	CLNK	Component Link	Ascending

Billing Control ID Seq No. +

Element	Alias	Description	Sequence
1	BCI	Billing Control ID	Ascending
2	SBSQ	Sequence Number	Ascending
3	SCSQ	Secondary Sequence Number	Ascending

Active Batch Number

Element	Alias	Description	Sequence
1	ICUA	Batch Number - Active	Ascending

Batch Number Inv 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 Last Seq. +

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	LSSQ	Process Complete	Ascending

Address No. Transaction No. +

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	PRTR	Transaction No. - Payroll	Ascending
3	DSVJ	Date - Service/Tax	Ascending
4	TCLS	Transaction Classification	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

Customer 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

Contract Number 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	OBJ	Object Account	Ascending
8	SUB	Subsidiary	Ascending

Invoice Number 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

Split Link Component Link +

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

Address Number 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

Component Link Comp Code +

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

Subledger Subledger Type +

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

Contract Contract 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

Split Link Comp Link +

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

Batch Number Doc 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

Doc Type Trans No. +

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

Batch Number Contract No +A

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

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 | 20 INDEXES | 812 | 48S | F4812HS TABLE

TOP 812 | 48S | F4812HS COLUMNS

TOP 812 | 48S | F4812HS 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 | 20 INDEXES | 812 | 48S | F4812HS TABLE

TOP812 | 48S | F4812HS COLUMNS

TOP812 | 48S | F4812HS INDEXES

TOP 812 | 48S | F4812HS COLUMNS

TOP 812 | 48S | F4812HS INDEXES