	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

155 COLUMNS | 3 INDEXES | 920 | 42 | F42UI12 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
42: Sales Management
1	920	F42UI12	ZD	155	3	Sales Order Detail Cache 2 (MBF)	Regular Work Files	42B: Sales Order Entry	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 ZDCTID, ZDJOBS, ZDLNIX, ZDKCOO, ZDDOCO, ZDDCTO, ZDLNID, ZDOPDJ, ZDPPDJ, ZDTHGD, ZDTHRP, ZDFRGD, ZDFRMP, ZDEMCU, ZDSRP1, ZDSRP2, ZDSRP3, ZDSRP4, ZDSRP5, ZDPRP1, ZDPRP2, ZDPRP3, ZDPRP4, ZDPRP5, ZDINMG, ZDPTC, ZDDTBS, ZDRYIN, ZDTRDC, ZDPRGR, ZDCADC, ZDKCO, ZDDOC, ZDDCT, ZDTXA1, ZDEXR1, ZDPRIO, ZDBACK, ZDSBAL, ZDLOB, ZDEUSE, ZDDTYS, ZDNTR, ZDCARS, ZDMOT, ZDROUT, ZDSTOP, ZDZON, ZDAFT, ZDFRTH, ZDSHCM, ZDSHCN, ZDSERN, ZDGLC, ZDACOM, ZDRCD, ZDGWUM, ZDSBL, ZDSBLT, ZDLCOD, ZDSWMS, ZDUNCD, ZDCRMD, ZDURCD, ZDURDT, ZDURAT, ZDURAB, ZDURRF, ZDFRAT, ZDMCU, ZDITM, ZDLOCN, ZDLOTN, ZDUOM, ZDSOQS, ZDSOBK, ZDSONE, ZDOTQY, ZDFFG1, ZDFFG2, ZDFFU2, ZDSHPN, ZDRSDT, ZDOSEQ, ZDMERL, ZDHDBU, ZDDMBU, ZDBCRC, ZDDEID, ZDPSIG, ZDPMDT, ZDRLTM, ZDRLDJ, ZDADTM, ZDOPTT, ZDPDTT, ZDPSTM, ZDXDCK, ZDXPTY, ZDXKCO, ZDXORN, ZDXCTO, ZDXLLN, ZDXSFX, ZDANBY, ZDPMTN, ZDOPOL, ZDOPBO, ZDOPID, ZDOPCS, ZDOPLL, ZDOPMS, ZDOPSS, ZDOPBA, ZDOPMG, ZDOPSG, ZDOPYN, ZDOPSU, ZDFXSR, ZDEDCK, ZDSBCK, ZDBBCK, ZDCMDM, ZDDUAL, ZDSOEF, ZDSOEG, ZDPSJOBNO, ZDJOBSQ, ZDDELBATCH, ZDCARDNO, ZDALLOC, ZDFULPID, ZDALLSTS, ZDOSCORE, ZDOSCOREO, ZDCMCO, ZDKITID, ZDKITAMTDOM, ZDKITAMTFOR, ZDKITDIRTY, ZDOCITT, ZDOCCARDNO, ZDTUPRC, ZDUTA, ZDTAEXP, ZDETA, ZDTFUP, ZDFUTA, ZDTFEA, ZDFETA, ZDTPROV, ZDDTXJ, ZDTKITAMTD, ZDTKITAMTF, ZDCRCD FROM F42UI12

TOP 920 | 42 | F42UI12 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	ZDCTID	Computer ID	String	Generic Edit	15	0	Allow NULL?
2	ZDJOBS	Job Number	Numeric	Generic Edit	8	0	Allow NULL?
3	ZDLNIX	Line Number - X-REF	Numeric	Generic Edit	6	3	Allow NULL?
4	ZDKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
5	ZDDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
6	ZDDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
7	ZDLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
8	ZDOPDJ	Date - Original Promised Delivery	Date	Generic Edit	6	0
9	ZDPPDJ	Date - Promised Shipment	Date	Generic Edit	6	0
10	ZDTHGD	Thru Grade	String	UDC (40 LG)	3	0	Allow NULL?
11	ZDTHRP	Thru Potency	Numeric	Generic Edit	7	3	Allow NULL?
12	ZDFRGD	From Grade	String	UDC (40 LG)	3	0	Allow NULL?
13	ZDFRMP	From Potency	Numeric	Generic Edit	7	3	Allow NULL?
14	ZDEMCU	Business Unit - Header	String	Generic Edit	12	0	Allow NULL?
15	ZDSRP1	Sales Catalog Section	String	UDC (41 S1)	3	0	Allow NULL?
16	ZDSRP2	Sub Section	String	UDC (41 S2)	3	0	Allow NULL?
17	ZDSRP3	Sales Category Code 3	String	UDC (41 S3)	3	0	Allow NULL?
18	ZDSRP4	Sales Category Code 4	String	UDC (41 S4)	3	0	Allow NULL?
19	ZDSRP5	Sales Category Code 5	String	UDC (41 S5)	3	0	Allow NULL?
20	ZDPRP1	Commodity Class	String	UDC (41 P1)	3	0	Allow NULL?
21	ZDPRP2	Commodity Sub Class	String	UDC (41 P2)	3	0	Allow NULL?
22	ZDPRP3	Supplier Rebate Code	String	UDC (41 P3)	3	0	Allow NULL?
23	ZDPRP4	Master Planning Family	String	UDC (41 P4)	3	0	Allow NULL?
24	ZDPRP5	Purchasing Category Code 5	String	UDC (41 P5)	3	0	Allow NULL?
25	ZDINMG	Print Message	String	UDC (40 PM)	10	0	Allow NULL?
26	ZDPTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
27	ZDDTBS	Based on Date	Character	UDC (42 BD)	1	0	Allow NULL?
28	ZDRYIN	Payment Instrument	Character	UDC (00 PY)	1	0	Allow NULL?
29	ZDTRDC	Discount - Trade	Numeric	Generic Edit	7	3	Allow NULL?
30	ZDPRGR	Item Price Group	String	UDC (40 PI)	8	0	Allow NULL?
31	ZDCADC	Discount % - Cash	Numeric	Generic Edit	7	3	Allow NULL?
32	ZDKCO	Document Company	String	Generic Edit	5	0	Allow NULL?
33	ZDDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
34	ZDDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
35	ZDTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
36	ZDEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
37	ZDPRIO	Priority - Processing	Character	UDC (H40 PR)	1	0	Allow NULL?
38	ZDBACK	Backorders Allowed (Y/N)	Character	Generic Edit	1	0	Allow NULL?
39	ZDSBAL	Substitutes Allowed (Y/N)	Character	Generic Edit	1	0	Allow NULL?
40	ZDLOB	Line of Business	String	UDC (40 LB)	3	0	Allow NULL?
41	ZDEUSE	End Use	String	UDC (40 EU)	3	0	Allow NULL?
42	ZDDTYS	Duty Status	String	UDC (40 DS)	2	0	Allow NULL?
43	ZDNTR	Nature of Transaction	String	UDC (00 NT)	2	0	Allow NULL?
44	ZDCARS	Carrier Number	Numeric	Generic Edit	8	0	Allow NULL?
45	ZDMOT	Mode of Transport	String	UDC (00 TM)	3	0	Allow NULL?
46	ZDROUT	Route Code	String	UDC (42 RT)	3	0	Allow NULL?
47	ZDSTOP	Stop Code	String	UDC (42 SP)	3	0	Allow NULL?
48	ZDZON	Zone Number	String	UDC (40 ZN)	3	0	Allow NULL?
49	ZDAFT	Apply Freight - Y/N	Character	Generic Edit	1	0	Allow NULL?
50	ZDFRTH	Freight Handling Code	String	UDC (42 FR)	3	0	Allow NULL?
51	ZDSHCM	Shipping Commodity Class	String	UDC (41 E)	3	0	Allow NULL?
52	ZDSHCN	Shipping Conditions Code	String	UDC (41 C)	3	0	Allow NULL?
53	ZDSERN	Serial Number - Lot	String	Generic Edit	30	0	Allow NULL?
54	ZDGLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
55	ZDACOM	Apply Commission (Y/N)	Character	Generic Edit	1	0	Allow NULL?
56	ZDRCD	Reason Code	String	UDC (42 RC)	3	0	Allow NULL?
57	ZDGWUM	Gross Weight Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
58	ZDSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
59	ZDSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
60	ZDLCOD	Code - Location Tax Status	String	UDC (46 LT)	2	0	Allow NULL?
61	ZDSWMS	Status - In Warehouse	Character	Generic Edit	1	0	Allow NULL?
62	ZDUNCD	Work Order Freeze Code	Character	UDC (H00 UN)	1	0	Allow NULL?
63	ZDCRMD	Send Method	Character	UDC (00 SM)	1	0	Allow NULL?
64	ZDURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
65	ZDURDT	User Reserved Date	Date	Generic Edit	6	0
66	ZDURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
67	ZDURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
68	ZDURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
69	ZDFRAT	Rate Code - Frieght/Misc	String	UDC (41 RT)	10	0	Allow NULL?
70	ZDMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
71	ZDITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
72	ZDLOCN	Location	String	Generic Edit	20	0	Allow NULL?
73	ZDLOTN	Lot/Serial Number	String	Generic Edit	30	0	Allow NULL?
74	ZDUOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
75	ZDSOQS	Quantity Shipped	Numeric	Generic Edit	15	0	Allow NULL?
76	ZDSOBK	Units - Qty Backordered/Held	Numeric	Generic Edit	15	0	Allow NULL?
77	ZDSONE	Units - Future Quantity Committed	Numeric	Generic Edit	15	0	Allow NULL?
78	ZDOTQY	Other Quantity (1/2)	Character	UDC	1	0	Allow NULL?
79	ZDFFG1	Flag for Future 01	Character	Generic Edit	1	0	Allow NULL?
80	ZDFFG2	Flag for Future 02	Character	Generic Edit	1	0	Allow NULL?
81	ZDFFU2	Flag	Character	Generic Edit	1	0	Allow NULL?
82	ZDSHPN	Shipment Number	Numeric	Generic Edit	8	0	Allow NULL?
83	ZDRSDT	Promised Delivery Time	Numeric	Generic Edit	6	0	Allow NULL?
84	ZDOSEQ	Sequence Number	Numeric	Generic Edit	4	0	Allow NULL?
85	ZDMERL	Item Revision Level	String	Generic Edit	3	0	Allow NULL?
86	ZDHDBU	Business Unit - Header	String	Generic Edit	12	0	Allow NULL?
87	ZDDMBU	Business Unit - Demand	String	Generic Edit	12	0	Allow NULL?
88	ZDBCRC	Currency Code - Base	String	Generic Edit	3	0	Allow NULL?
89	ZDDEID	Demand Unique Key ID	Numeric	Generic Edit	15	0	Allow NULL?
90	ZDPSIG	Pull Signal	String	Generic Edit	30	0	Allow NULL?
91	ZDPMDT	Scheduled Shipment Time	Numeric	Generic Edit	6	0	Allow NULL?
92	ZDRLTM	Time - Release	Numeric	Generic Edit	6	0	Allow NULL?
93	ZDRLDJ	Date - Release	Date	Generic Edit	6	0
94	ZDADTM	Actual Shipment Time	Numeric	Generic Edit	6	0	Allow NULL?
95	ZDOPTT	Time - Original Promised Delivery	Numeric	Generic Edit	6	0	Allow NULL?
96	ZDPDTT	Time - Scheduled Pick	Numeric	Generic Edit	6	0	Allow NULL?
97	ZDPSTM	Time - Future Time 2	Numeric	Generic Edit	6	0	Allow NULL?
98	ZDXDCK	Cross-Docking Flag	Character	Generic Edit	1	0	Allow NULL?
99	ZDXPTY	Cross Docking Priority for Sales Orders	Numeric	Generic Edit	15	0	Allow NULL?
100	ZDXKCO	Cross Dock Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
101	ZDXORN	Cross Dock Order No	Numeric	Generic Edit	8	0	Allow NULL?
102	ZDXCTO	Cross Dock Order Type	String	UDC (00 DT)	2	0	Allow NULL?
103	ZDXLLN	Cross Dock Line Number	Numeric	Generic Edit	6	3	Allow NULL?
104	ZDXSFX	Cross Dock Order Suffix	String	Generic Edit	3	0	Allow NULL?
105	ZDANBY	Buyer Number	Numeric	Generic Edit	8	0	Allow NULL?
106	ZDPMTN	Promotion ID	String	Generic Edit	12	0	Allow NULL?
107	ZDOPOL	OP Original Line Number	Numeric	Generic Edit	6	3	Allow NULL?
108	ZDOPBO	OP Business Objective	String	UDC (34A BO)	30	0	Allow NULL?
109	ZDOPID	OP Scenario ID	String	Generic Edit	30	0	Allow NULL?
110	ZDOPCS	OP Cost	Numeric	Generic Edit	15	4	Allow NULL?
111	ZDOPLL	OP Partial Ship Line Items	Character	Generic Edit	1	0	Allow NULL?
112	ZDOPMS	OP Allow Multi Source	Character	Generic Edit	1	0	Allow NULL?
113	ZDOPSS	OP Allow Substitutes	Character	Generic Edit	1	0	Allow NULL?
114	ZDOPBA	OP Allow Backorders	Character	Generic Edit	1	0	Allow NULL?
115	ZDOPMG	OP Multi Source Group	String	Generic Edit	30	0	Allow NULL?
116	ZDOPSG	OP Shipping Group	String	Generic Edit	30	0	Allow NULL?
117	ZDOPYN	OP Promise Line (Y/N)	Character	Generic Edit	1	0	Allow NULL?
118	ZDOPSU	OP Allow Split UOM	Character	Generic Edit	1	0	Allow NULL?
119	ZDFXSR	Fix Source Location	Character	Generic Edit	1	0	Allow NULL?
120	ZDEDCK	Check Expiration Date	Character	Generic Edit	1	0	Allow NULL?
121	ZDSBCK	Check Sell By Date	Character	Generic Edit	1	0	Allow NULL?
122	ZDBBCK	Check Best Before Date	Character	Generic Edit	1	0	Allow NULL?
123	ZDCMDM	Commitment Date Method	Character	UDC (H40 CD)	1	0	Allow NULL?
124	ZDDUAL	Dual Unit Of Measure Item	Character	Generic Edit	1	0	Allow NULL?
125	ZDSOEF	Sales Order Entry MBF Internal Flags	String	Generic Edit	30	0	Allow NULL?
126	ZDSOEG	Sales Order Entry MBF Internal Flags2	String	Generic Edit	30	0	Allow NULL?
127	ZDPSJOBNO	Production Sequencing Job Number	String	Generic Edit	15	0	Allow NULL?
128	ZDJOBSQ	Job Sequence Number	String	Generic Edit	15	0	Allow NULL?
129	ZDDELBATCH	Delivery Batch Number	String	Generic Edit	6	0	Allow NULL?
130	ZDCARDNO	Card Number	String	UDC (40R CD)	4	0	Allow NULL?
131	ZDALLOC	Allocation Process Flag	Character	Generic Edit	1	0	Allow NULL?
132	ZDFULPID	Fulfillment Plan ID	Integer	Generic Edit	11	0	Allow NULL?
133	ZDALLSTS	Allocation Status Number	String	UDC (42 AS)	30	0	Allow NULL?
134	ZDOSCORE	Sales Order Score	Numeric	Generic Edit	15	3	Allow NULL?
135	ZDOSCOREO	Order Score Override	Character	Generic Edit	1	0	Allow NULL?
136	ZDCMCO	Customer Master Company	String	Generic Edit	5	0	Allow NULL?
137	ZDKITID	Kit Identifier	Numeric	Generic Edit	15	0	Allow NULL?
138	ZDKITAMTDOM	Accumulated Amount Invoiced (Domestic)	Numeric	Generic Edit	15	2	Allow NULL?
139	ZDKITAMTFOR	Accumulated Amount Invoiced (Foreign)	Numeric	Generic Edit	15	2	Allow NULL?
140	ZDKITDIRTY	Kit Component Dirty Flag	Character	Generic Edit	1	0	Allow NULL?
141	ZDOCITT	OC In-Transit Flag	Character	Generic Edit	1	0	Allow NULL?
142	ZDOCCARDNO	OC Kanban Card No	Numeric	Generic Edit	8	0	Allow NULL?
143	ZDTUPRC	Taxed Unit Price	Numeric	Generic Edit	15	4	Allow NULL?
144	ZDUTA	Unit Tax Amount	Numeric	Generic Edit	15	4	Allow NULL?
145	ZDTAEXP	Taxed Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
146	ZDETA	Extended Tax Amount	Numeric	Generic Edit	15	2	Allow NULL?
147	ZDTFUP	Foreign Taxed Unit Price	Numeric	Generic Edit	15	4	Allow NULL?
148	ZDFUTA	Foreign Unit Tax Amount	Numeric	Generic Edit	15	4	Allow NULL?
149	ZDTFEA	Foreign Taxed Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
150	ZDFETA	Foreign Extended Tax Amount	Numeric	Generic Edit	15	2	Allow NULL?
151	ZDTPROV	Taxed Price Override Code	Character	Generic Edit	1	0	Allow NULL?
152	ZDDTXJ	Internal SO Tax Date	Date	Generic Edit	6	0
153	ZDTKITAMTD	Kit Taxed Price Invoiced	Numeric	Generic Edit	15	2	Allow NULL?
154	ZDTKITAMTF	Foreign Kit Taxed Price Invoiced	Numeric	Generic Edit	15	2	Allow NULL?
155	ZDCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?

TOP 920 | 42 | F42UI12 INDEXES

Number

Description

Computer ID Job No (Primary/Unique)

Element	Alias	Description	Sequence
1	CTID	Computer ID	Ascending
2	JOBS	Job Number	Ascending
3	LNIX	Line Number - X-REF	Ascending
4	DOCO	Document (Order No Invoice etc.)	Ascending
5	DCTO	Order Type	Ascending
6	KCOO	Order Company (Order Number)	Ascending
7	LNID	Line Number	Ascending

Computer ID Job No Item

Element	Alias	Description	Sequence
1	CTID	Computer ID	Ascending
2	JOBS	Job Number	Ascending
3	LNIX	Line Number - X-REF	Ascending

Computer ID Job No Company

Element	Alias	Description	Sequence
1	CTID	Computer ID	Ascending
2	JOBS	Job Number	Ascending
3	KCOO	Order Company (Order Number)	Ascending
4	DOCO	Document (Order No Invoice etc.)	Ascending
5	DCTO	Order Type	Ascending
6	LNID	Line 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

155 COLUMNS | 3 INDEXES | 920 | 42 | F42UI12 TABLE

TOP 920 | 42 | F42UI12 COLUMNS

TOP 920 | 42 | F42UI12 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

155 COLUMNS | 3 INDEXES | 920 | 42 | F42UI12 TABLE

TOP920 | 42 | F42UI12 COLUMNS

TOP920 | 42 | F42UI12 INDEXES

TOP 920 | 42 | F42UI12 COLUMNS

TOP 920 | 42 | F42UI12 INDEXES