	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

173 COLUMNS | 3 INDEXES | 920 | 42 | F42UI01 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
42: Sales Management
1	920	F42UI01	ZH	173	3	SO Header Cache File (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 ZHCTID, ZHJOBS, ZHPEID, ZHTCID, ZHACTN, ZHKCOO, ZHDOCO, ZHDCTO, ZHSFXO, ZHMCU, ZHCO, ZHOKCO, ZHOORN, ZHOCTO, ZHRKCO, ZHRORN, ZHRCTO, ZHAN8, ZHSHAN, ZHPA8, ZHDRQJ, ZHTRDJ, ZHPDDJ, ZHOPDJ, ZHADDJ, ZHCNDJ, ZHPEFJ, ZHPPDJ, ZHVR01, ZHVR02, ZHDEL1, ZHDEL2, ZHINMG, ZHPTC, ZHRYIN, ZHASN, ZHPRGP, ZHTRDC, ZHPCRT, ZHTXA1, ZHEXR1, ZHTXCT, ZHATXT, ZHPRIO, ZHBACK, ZHSBAL, ZHHOLD, ZHPLST, ZHINVC, ZHNTR, ZHANBY, ZHCARS, ZHMOT, ZHCOT, ZHROUT, ZHSTOP, ZHZON, ZHCNID, ZHFRTH, ZHAFT, ZHFUF1, ZHFRTC, ZHMORD, ZHRCD, ZHFUF2, ZHOTOT, ZHTOTC, ZHWUMD, ZHVUMD, ZHAUTN, ZHCACT, ZHCEXP, ZHSBLI, ZHCRMD, ZHCRRM, ZHCRCD, ZHCRR, ZHLNGP, ZHFAP, ZHFCST, ZHORBY, ZHTKBY, ZHURCD, ZHURDT, ZHURAT, ZHURAB, ZHURRF, ZHUSER, ZHPID, ZHJOBN, ZHUPMJ, ZHTDAY, ZHAPTS, ZHEDF2, ZHMAXO, ZHMINO, ZHSI01, ZHEDSP, ZHDTE, ZHADVP, ZHCP01, ZHUMB1, ZHBUMC, ZHCRDC, ZHCRRD, ZHCPGP, ZHLNIX, ZHORNN, ZHAPRC, ZHAOPN, ZHFY, ZHCTRY, ZHTRR1, ZHTRR2, ZHCRCM, ZHTRD1, ZHTRD2, ZHDCFL, ZHRCUP, ZHLNID, ZHVVTX, ZHTRAR, ZHEXR0, ZHCRCE, ZHIAN8, ZHIR01, ZHIR02, ZHIR03, ZHIR04, ZHIR05, ZHVR03, ZHSOOR, ZHPMDT, ZHRSDT, ZHRQSJ, ZHPSTM, ZHPDTT, ZHOPTT, ZHDRQT, ZHADTM, ZHADLJ, ZHPBAN, ZHITAN, ZHFTAN, ZHDVAN, ZHDOC1, ZHDCT4, ZHCORD, ZHBSC, ZHBCRC, ZHAUFT, ZHAUFI, ZHOPBO, ZHOPTC, ZHOPLD, ZHOPBK, ZHOPSB, ZHOPPS, ZHOPPL, ZHOPMS, ZHOPSS, ZHOPBA, ZHOPLL, ZHSOEF, ZHPRAN8, ZHOPPID, ZHSDATTN, ZHSPATTN, ZHOTIND, ZHPRCIDLN, ZHCCIDLN, ZHSHCCIDLN, ZHUTP FROM F42UI01

TOP 920 | 42 | F42UI01 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	ZHCTID	Computer ID	String	Generic Edit	15	0	Allow NULL?
2	ZHJOBS	Job Number	Numeric	Generic Edit	8	0	Allow NULL?
3	ZHPEID	Process ID	Numeric	Generic Edit	15	0	Allow NULL?
4	ZHTCID	Transaction ID	Numeric	Generic Edit	15	0	Allow NULL?
5	ZHACTN	Action Code	Character	Generic Edit	1	0	Allow NULL?
6	ZHKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
7	ZHDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
8	ZHDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
9	ZHSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
10	ZHMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
11	ZHCO	Company	String	Generic Edit	5	0	Allow NULL?
12	ZHOKCO	Document Company (Original Order)	String	Generic Edit	5	0	Allow NULL?
13	ZHOORN	Original Order Number	String	Generic Edit	8	0	Allow NULL?
14	ZHOCTO	Original Order Type	String	UDC (00 DT)	2	0	Allow NULL?
15	ZHRKCO	Company - Key (Related Order)	String	Generic Edit	5	0	Allow NULL?
16	ZHRORN	Related PO/SO/WO Number	String	Generic Edit	8	0	Allow NULL?
17	ZHRCTO	Related PO/SO/WO Order Type	String	UDC (00 DT)	2	0	Allow NULL?
18	ZHAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
19	ZHSHAN	Address Number - Ship To	Numeric	Generic Edit	8	0	Allow NULL?
20	ZHPA8	Address Number - Parent	Numeric	Generic Edit	8	0	Allow NULL?
21	ZHDRQJ	Date - Requested	Date	Generic Edit	6	0
22	ZHTRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
23	ZHPDDJ	Date - Scheduled Pick	Date	Generic Edit	6	0
24	ZHOPDJ	Date - Original Promised Delivery	Date	Generic Edit	6	0
25	ZHADDJ	Date - Actual Ship Date	Date	Generic Edit	6	0
26	ZHCNDJ	Date - Cancel	Date	Generic Edit	6	0
27	ZHPEFJ	Date - Price Effective Date	Date	Generic Edit	6	0
28	ZHPPDJ	Date - Promised Shipment	Date	Generic Edit	6	0
29	ZHVR01	Reference	String	Generic Edit	25	0	Allow NULL?
30	ZHVR02	Reference 2	String	Generic Edit	25	0	Allow NULL?
31	ZHDEL1	Delivery Instructions Line 1	String	Generic Edit	30	0	Allow NULL?
32	ZHDEL2	Delivery Instructions Line 2	String	Generic Edit	30	0	Allow NULL?
33	ZHINMG	Print Message	String	UDC (40 PM)	10	0	Allow NULL?
34	ZHPTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
35	ZHRYIN	Payment Instrument	Character	UDC (00 PY)	1	0	Allow NULL?
36	ZHASN	Price and Adjustment Schedule	String	UDC (40 AS)	8	0	Allow NULL?
37	ZHPRGP	Pricing Group	String	UDC (40 PC)	8	0	Allow NULL?
38	ZHTRDC	Discount - Trade	Numeric	Generic Edit	7	3	Allow NULL?
39	ZHPCRT	Percent - Retainage	Numeric	Generic Edit	7	3	Allow NULL?
40	ZHTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
41	ZHEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
42	ZHTXCT	Certificate Tax Exemption	String	Generic Edit	20	0	Allow NULL?
43	ZHATXT	Associated Text	Character	Generic Edit	1	0	Allow NULL?
44	ZHPRIO	Priority - Processing	Character	UDC (H40 PR)	1	0	Allow NULL?
45	ZHBACK	Backorders Allowed (Y/N)	Character	Generic Edit	1	0	Allow NULL?
46	ZHSBAL	Substitutes Allowed (Y/N)	Character	Generic Edit	1	0	Allow NULL?
47	ZHHOLD	Hold Orders Code	String	UDC (42 HC)	2	0	Allow NULL?
48	ZHPLST	Price Pick List (Y/N)	Character	Generic Edit	1	0	Allow NULL?
49	ZHINVC	Invoice Copies	Numeric	Generic Edit	2	0	Allow NULL?
50	ZHNTR	Nature of Transaction	String	UDC (00 NT)	2	0	Allow NULL?
51	ZHANBY	Buyer Number	Numeric	Generic Edit	8	0	Allow NULL?
52	ZHCARS	Carrier Number	Numeric	Generic Edit	8	0	Allow NULL?
53	ZHMOT	Mode of Transport	String	UDC (00 TM)	3	0	Allow NULL?
54	ZHCOT	Conditions of Transport	String	UDC (00 TC)	3	0	Allow NULL?
55	ZHROUT	Route Code	String	UDC (42 RT)	3	0	Allow NULL?
56	ZHSTOP	Stop Code	String	UDC (42 SP)	3	0	Allow NULL?
57	ZHZON	Zone Number	String	UDC (40 ZN)	3	0	Allow NULL?
58	ZHCNID	Container I.D.	String	Generic Edit	20	0	Allow NULL?
59	ZHFRTH	Freight Handling Code	String	UDC (42 FR)	3	0	Allow NULL?
60	ZHAFT	Apply Freight - Y/N	Character	Generic Edit	1	0	Allow NULL?
61	ZHFUF1	AIA Document Flag	Character	UDC (H40 FU)	1	0	Allow NULL?
62	ZHFRTC	Freight Calculated (Y/N)	Character	Generic Edit	1	0	Allow NULL?
63	ZHMORD	Merge Orders (Y/N)	Character	Generic Edit	1	0	Allow NULL?
64	ZHRCD	Reason Code	String	UDC (42 RC)	3	0	Allow NULL?
65	ZHFUF2	Post Quantities	Character	Generic Edit	1	0	Allow NULL?
66	ZHOTOT	Amount - Order Gross	Numeric	Generic Edit	15	2	Allow NULL?
67	ZHTOTC	Amount - Total Cost	Numeric	Generic Edit	15	2	Allow NULL?
68	ZHWUMD	Unit of Measure - Weight Display	String	UDC (00 UM)	2	0	Allow NULL?
69	ZHVUMD	Unit of Measure - Volume Display	String	UDC (00 UM)	2	0	Allow NULL?
70	ZHAUTN	Authorization Number - Credit Approval	String	Generic Edit	10	0	Allow NULL?
71	ZHCACT	Account Number - Credit/Bank	String	Generic Edit	25	0	Allow NULL?
72	ZHCEXP	Date - Expired (Julian)	Date	Generic Edit	6	0
73	ZHSBLI	Subledger Inactive Code	Character	UDC (00 SI)	1	0	Allow NULL?
74	ZHCRMD	Send Method	Character	UDC (00 SM)	1	0	Allow NULL?
75	ZHCRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
76	ZHCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
77	ZHCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
78	ZHLNGP	Language	String	UDC (01 LP)	2	0	Allow NULL?
79	ZHFAP	Amount - Foreign Open	Numeric	Generic Edit	15	2	Allow NULL?
80	ZHFCST	Amount - Foreign Total Cost	Numeric	Generic Edit	15	2	Allow NULL?
81	ZHORBY	Ordered By	String	Generic Edit	10	0	Allow NULL?
82	ZHTKBY	Order Taken By	String	Generic Edit	10	0	Allow NULL?
83	ZHURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
84	ZHURDT	User Reserved Date	Date	Generic Edit	6	0
85	ZHURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
86	ZHURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
87	ZHURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
88	ZHUSER	User ID	String	Generic Edit	10	0	Allow NULL?
89	ZHPID	Program ID	String	Generic Edit	10	0	Allow NULL?
90	ZHJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
91	ZHUPMJ	Date - Updated	Date	Generic Edit	6	0
92	ZHTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
93	ZHAPTS	Partial Line Shipments Allowed (Y/N)	Character	Generic Edit	1	0	Allow NULL?
94	ZHEDF2	Item Restrictions	Character	UDC (H40 ED)	1	0	Allow NULL?
95	ZHMAXO	Maximum Order Value	Numeric	Generic Edit	15	0	Allow NULL?
96	ZHMINO	Minimum Order Value	Numeric	Generic Edit	15	0	Allow NULL?
97	ZHSI01	Partial Order Shipments Allowed (Y/N)	Character	Generic Edit	1	0	Allow NULL?
98	ZHEDSP	EDI - Successfully Processed	Character	Generic Edit	1	0	Allow NULL?
99	ZHDTE	Date	Date	Generic Edit	6	0
100	ZHADVP	Advanced Sales Pricing (Y/N)	Character	Generic Edit	1	0	Allow NULL?
101	ZHCP01	Sales Price Based On Date	Character	UDC (40 DB)	1	0	Allow NULL?
102	ZHUMB1	Sales Price Retrieval UOM	Character	UDC (40 SU)	1	0	Allow NULL?
103	ZHBUMC	Process UOM Conversions by Branch	Character	Generic Edit	1	0	Allow NULL?
104	ZHCRDC	Currency Code - To	String	Generic Edit	3	0	Allow NULL?
105	ZHCRRD	Currency Conversion Rate - Divisor	Numeric	Generic Edit	15	0	Allow NULL?
106	ZHCPGP	Customer Price Group	String	UDC (40 PC)	8	0	Allow NULL?
107	ZHLNIX	Line Number - X-REF	Numeric	Generic Edit	6	3	Allow NULL?
108	ZHORNN	Order Type Next Number	Numeric	Generic Edit	2	0	Allow NULL?
109	ZHAPRC	Amount - Open Order	Numeric	Generic Edit	15	2	Allow NULL?
110	ZHAOPN	Amount - Open	Numeric	Generic Edit	15	2	Allow NULL?
111	ZHFY	Fiscal Year	Numeric	Generic Edit	2	0	Allow NULL?
112	ZHCTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
113	ZHTRR1	Triangulation Rate - From Currency	Numeric	Generic Edit	15	0	Allow NULL?
114	ZHTRR2	Triangulation Rate - To Currency	Numeric	Generic Edit	15	0	Allow NULL?
115	ZHCRCM	Currency Conversion Y/Z	Character	Generic Edit	1	0	Allow NULL?
116	ZHTRD1	Triangulation Rate - From Currency	Numeric	Generic Edit	15	0	Allow NULL?
117	ZHTRD2	Triangulation Rate - To Currency	Numeric	Generic Edit	15	0	Allow NULL?
118	ZHDCFL	Exchange Rate Override - Dual Currency	Character	Generic Edit	1	0	Allow NULL?
119	ZHRCUP	Unedited record flag	Character	Generic Edit	1	0	Allow NULL?
120	ZHLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
121	ZHVVTX	Activate Vertex Tax Compliance System	Character	Generic Edit	1	0	Allow NULL?
122	ZHTRAR	Payment Terms - A/R	String	Generic Edit	3	0	Allow NULL?
123	ZHEXR0	Tax Expl Code	String	UDC (00 EX)	2	0	Allow NULL?
124	ZHCRCE	Currency Code - Source	String	Generic Edit	3	0	Allow NULL?
125	ZHIAN8	Address Number - Bond Issued	Numeric	Generic Edit	8	0	Allow NULL?
126	ZHIR01	Integration Reference 01	String	Generic Edit	30	0	Allow NULL?
127	ZHIR02	Integration Reference 02	String	Generic Edit	30	0	Allow NULL?
128	ZHIR03	Integration Reference 03	String	Generic Edit	30	0	Allow NULL?
129	ZHIR04	Integration Reference 04	String	Generic Edit	30	0	Allow NULL?
130	ZHIR05	Integration Reference 05	String	Generic Edit	30	0	Allow NULL?
131	ZHVR03	Reference	String	Generic Edit	25	0	Allow NULL?
132	ZHSOOR	Source of Order	Integer	Generic Edit	11	0	Allow NULL?
133	ZHPMDT	Scheduled Shipment Time	Numeric	Generic Edit	6	0	Allow NULL?
134	ZHRSDT	Promised Delivery Time	Numeric	Generic Edit	6	0	Allow NULL?
135	ZHRQSJ	Date - Requested Ship	Date	Generic Edit	6	0
136	ZHPSTM	Time - Future Time 2	Numeric	Generic Edit	6	0	Allow NULL?
137	ZHPDTT	Time - Scheduled Pick	Numeric	Generic Edit	6	0	Allow NULL?
138	ZHOPTT	Time - Original Promised Delivery	Numeric	Generic Edit	6	0	Allow NULL?
139	ZHDRQT	Requested Delivery Time	Numeric	Generic Edit	6	0	Allow NULL?
140	ZHADTM	Actual Shipment Time	Numeric	Generic Edit	6	0	Allow NULL?
141	ZHADLJ	Date - Actual Delivery	Date	Generic Edit	6	0
142	ZHPBAN	Address Number - Paid By	Numeric	Generic Edit	8	0	Allow NULL?
143	ZHITAN	Address Number - Invoiced To	Numeric	Generic Edit	8	0	Allow NULL?
144	ZHFTAN	Address Number - Forwarded To	Numeric	Generic Edit	8	0	Allow NULL?
145	ZHDVAN	Address Number - Deliver To	Numeric	Generic Edit	8	0	Allow NULL?
146	ZHDOC1	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
147	ZHDCT4	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
148	ZHCORD	Change Order Number	Numeric	Generic Edit	3	0	Allow NULL?
149	ZHBSC	Buying Segment Code	String	UDC (42B BS)	10	0	Allow NULL?
150	ZHBCRC	Currency Code - Base	String	Generic Edit	3	0	Allow NULL?
151	ZHAUFT	Address Number to use for Tax	Character	UDC (42B UA)	1	0	Allow NULL?
152	ZHAUFI	Address Number to use for Transportation	Character	UDC (42B UA)	1	0	Allow NULL?
153	ZHOPBO	OP Business Objective	String	UDC (34A BO)	30	0	Allow NULL?
154	ZHOPTC	OP Total Cost	Numeric	Generic Edit	15	4	Allow NULL?
155	ZHOPLD	OP Latest Line Date	Date	Generic Edit	6	0
156	ZHOPBK	OP Number of Backorders	Numeric	Generic Edit	15	0	Allow NULL?
157	ZHOPSB	OP Number of Substitutes	Numeric	Generic Edit	15	0	Allow NULL?
158	ZHOPPS	OP Promised Status	String	Generic Edit	30	0	Allow NULL?
159	ZHOPPL	OP Partial Order Shipment	Character	Generic Edit	1	0	Allow NULL?
160	ZHOPMS	OP Allow Multi Source	Character	Generic Edit	1	0	Allow NULL?
161	ZHOPSS	OP Allow Substitutes	Character	Generic Edit	1	0	Allow NULL?
162	ZHOPBA	OP Allow Backorders	Character	Generic Edit	1	0	Allow NULL?
163	ZHOPLL	OP Partial Ship Line Items	Character	Generic Edit	1	0	Allow NULL?
164	ZHSOEF	Sales Order Entry MBF Internal Flags	String	Generic Edit	30	0	Allow NULL?
165	ZHPRAN8	Partner Address Number	Numeric	Generic Edit	8	0	Allow NULL?
166	ZHOPPID	Opportunity Number	Numeric	Generic Edit	15	0	Allow NULL?
167	ZHSDATTN	Sold To Attention	String	Generic Edit	50	0	Allow NULL?
168	ZHSPATTN	Ship To Attention	String	Generic Edit	50	0	Allow NULL?
169	ZHOTIND	Order Type Indicator	Character	Generic Edit	1	0	Allow NULL?
170	ZHPRCIDLN	Partner Contact Line Number ID	Numeric	Generic Edit	5	0	Allow NULL?
171	ZHCCIDLN	Customer Contact Line Number ID	Numeric	Generic Edit	5	0	Allow NULL?
172	ZHSHCCIDLN	Ship To Cust Contact Line Num ID	Numeric	Generic Edit	5	0	Allow NULL?
173	ZHUTP	Use Taxed Prices	Character	Generic Edit	1	0	Allow NULL?

TOP 920 | 42 | F42UI01 INDEXES

Number

Description

ComputerID Job No (Primary/Unique)

Element	Alias	Description	Sequence
1	CTID	Computer ID	Ascending
2	JOBS	Job Number	Ascending
3	DOCO	Document (Order No Invoice etc.)	Ascending
4	DCTO	Order Type	Ascending
5	KCOO	Order Company (Order Number)	Ascending

AddressNo BrPlnt A

Element	Alias	Description	Sequence
1	CTID	Computer ID	Ascending
2	PEID	Process ID	Ascending
3	TCID	Transaction ID	Ascending
4	AN8	Address Number	Ascending
5	MCU	Business Unit	Ascending
6	CRCD	Currency Code - From	Ascending
7	SHAN	Address Number - Ship To	Ascending

ComputerID OrderNo

Element	Alias	Description	Sequence
1	CTID	Computer ID	Ascending
2	DOCO	Document (Order No Invoice etc.)	Ascending
3	DCTO	Order Type	Ascending
4	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

173 COLUMNS | 3 INDEXES | 920 | 42 | F42UI01 TABLE

TOP 920 | 42 | F42UI01 COLUMNS

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

173 COLUMNS | 3 INDEXES | 920 | 42 | F42UI01 TABLE

TOP920 | 42 | F42UI01 COLUMNS

TOP920 | 42 | F42UI01 INDEXES

TOP 920 | 42 | F42UI01 COLUMNS

TOP 920 | 42 | F42UI01 INDEXES