	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

133 COLUMNS | 4 INDEXES | 920 | 42 | F42019 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
42: Sales Management
1	920	F42019	SH	133	4	Sales Order Header History File	History Files	42: Sales Management	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 SHKCOO, SHDOCO, SHDCTO, SHSFXO, SHMCU, SHCO, SHOKCO, SHOORN, SHOCTO, SHRKCO, SHRORN, SHRCTO, SHAN8, SHSHAN, SHPA8, SHDRQJ, SHTRDJ, SHPDDJ, SHOPDJ, SHADDJ, SHCNDJ, SHPEFJ, SHPPDJ, SHVR01, SHVR02, SHDEL1, SHDEL2, SHINMG, SHPTC, SHRYIN, SHASN, SHPRGP, SHTRDC, SHPCRT, SHTXA1, SHEXR1, SHTXCT, SHATXT, SHPRIO, SHBACK, SHSBAL, SHHOLD, SHPLST, SHINVC, SHNTR, SHANBY, SHCARS, SHMOT, SHCOT, SHROUT, SHSTOP, SHZON, SHCNID, SHFRTH, SHAFT, SHFUF1, SHFRTC, SHMORD, SHRCD, SHFUF2, SHOTOT, SHTOTC, SHWUMD, SHVUMD, SHAUTN, SHCACT, SHCEXP, SHSBLI, SHCRMD, SHCRRM, SHCRCD, SHCRR, SHLNGP, SHFAP, SHFCST, SHORBY, SHTKBY, SHURCD, SHURDT, SHURAT, SHURAB, SHURRF, SHUSER, SHPID, SHJOBN, SHUPMJ, SHTDAY, SHIR01, SHIR02, SHIR03, SHIR04, SHIR05, SHVR03, SHSOOR, SHPMDT, SHRSDT, SHRQSJ, SHPSTM, SHPDTT, SHOPTT, SHDRQT, SHADTM, SHADLJ, SHPBAN, SHITAN, SHFTAN, SHDVAN, SHDOC1, SHDCT4, SHCORD, SHBSC, SHBCRC, SHAUFT, SHAUFI, SHOPBO, SHOPTC, SHOPLD, SHOPBK, SHOPSB, SHOPPS, SHOPPL, SHOPMS, SHOPSS, SHOPBA, SHOPLL, SHPRAN8, SHOPPID, SHSDATTN, SHSPATTN, SHOTIND, SHPRCIDLN, SHCCIDLN, SHSHCCIDLN FROM F42019

TOP 920 | 42 | F42019 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	SHKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
2	SHDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
3	SHDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
4	SHSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
5	SHMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
6	SHCO	Company	String	Generic Edit	5	0	Allow NULL?
7	SHOKCO	Document Company (Original Order)	String	Generic Edit	5	0	Allow NULL?
8	SHOORN	Original Order Number	String	Generic Edit	8	0	Allow NULL?
9	SHOCTO	Original Order Type	String	UDC (00 DT)	2	0	Allow NULL?
10	SHRKCO	Company - Key (Related Order)	String	Generic Edit	5	0	Allow NULL?
11	SHRORN	Related PO/SO/WO Number	String	Generic Edit	8	0	Allow NULL?
12	SHRCTO	Related PO/SO/WO Order Type	String	UDC (00 DT)	2	0	Allow NULL?
13	SHAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
14	SHSHAN	Address Number - Ship To	Numeric	Generic Edit	8	0	Allow NULL?
15	SHPA8	Address Number - Parent	Numeric	Generic Edit	8	0	Allow NULL?
16	SHDRQJ	Date - Requested	Date	Generic Edit	6	0
17	SHTRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
18	SHPDDJ	Date - Scheduled Pick	Date	Generic Edit	6	0
19	SHOPDJ	Date - Original Promised Delivery	Date	Generic Edit	6	0
20	SHADDJ	Date - Actual Ship Date	Date	Generic Edit	6	0
21	SHCNDJ	Date - Cancel	Date	Generic Edit	6	0
22	SHPEFJ	Date - Price Effective Date	Date	Generic Edit	6	0
23	SHPPDJ	Date - Promised Shipment	Date	Generic Edit	6	0
24	SHVR01	Reference	String	Generic Edit	25	0	Allow NULL?
25	SHVR02	Reference 2	String	Generic Edit	25	0	Allow NULL?
26	SHDEL1	Delivery Instructions Line 1	String	Generic Edit	30	0	Allow NULL?
27	SHDEL2	Delivery Instructions Line 2	String	Generic Edit	30	0	Allow NULL?
28	SHINMG	Print Message	String	UDC (40 PM)	10	0	Allow NULL?
29	SHPTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
30	SHRYIN	Payment Instrument	Character	UDC (00 PY)	1	0	Allow NULL?
31	SHASN	Price and Adjustment Schedule	String	UDC (40 AS)	8	0	Allow NULL?
32	SHPRGP	Pricing Group	String	UDC (40 PC)	8	0	Allow NULL?
33	SHTRDC	Discount - Trade	Numeric	Generic Edit	7	3	Allow NULL?
34	SHPCRT	Percent - Retainage	Numeric	Generic Edit	7	3	Allow NULL?
35	SHTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
36	SHEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
37	SHTXCT	Certificate Tax Exemption	String	Generic Edit	20	0	Allow NULL?
38	SHATXT	Associated Text	Character	Generic Edit	1	0	Allow NULL?
39	SHPRIO	Priority - Processing	Character	UDC (H40 PR)	1	0	Allow NULL?
40	SHBACK	Backorders Allowed (Y/N)	Character	Generic Edit	1	0	Allow NULL?
41	SHSBAL	Substitutes Allowed (Y/N)	Character	Generic Edit	1	0	Allow NULL?
42	SHHOLD	Hold Orders Code	String	UDC (42 HC)	2	0	Allow NULL?
43	SHPLST	Price Pick List (Y/N)	Character	Generic Edit	1	0	Allow NULL?
44	SHINVC	Invoice Copies	Numeric	Generic Edit	2	0	Allow NULL?
45	SHNTR	Nature of Transaction	String	UDC (00 NT)	2	0	Allow NULL?
46	SHANBY	Buyer Number	Numeric	Generic Edit	8	0	Allow NULL?
47	SHCARS	Carrier Number	Numeric	Generic Edit	8	0	Allow NULL?
48	SHMOT	Mode of Transport	String	UDC (00 TM)	3	0	Allow NULL?
49	SHCOT	Conditions of Transport	String	UDC (00 TC)	3	0	Allow NULL?
50	SHROUT	Route Code	String	UDC (42 RT)	3	0	Allow NULL?
51	SHSTOP	Stop Code	String	UDC (42 SP)	3	0	Allow NULL?
52	SHZON	Zone Number	String	UDC (40 ZN)	3	0	Allow NULL?
53	SHCNID	Container I.D.	String	Generic Edit	20	0	Allow NULL?
54	SHFRTH	Freight Handling Code	String	UDC (42 FR)	3	0	Allow NULL?
55	SHAFT	Apply Freight - Y/N	Character	Generic Edit	1	0	Allow NULL?
56	SHFUF1	AIA Document Flag	Character	UDC (H40 FU)	1	0	Allow NULL?
57	SHFRTC	Freight Calculated (Y/N)	Character	Generic Edit	1	0	Allow NULL?
58	SHMORD	Merge Orders (Y/N)	Character	Generic Edit	1	0	Allow NULL?
59	SHRCD	Reason Code	String	UDC (42 RC)	3	0	Allow NULL?
60	SHFUF2	Post Quantities	Character	Generic Edit	1	0	Allow NULL?
61	SHOTOT	Amount - Order Gross	Numeric	Generic Edit	15	2	Allow NULL?
62	SHTOTC	Amount - Total Cost	Numeric	Generic Edit	15	2	Allow NULL?
63	SHWUMD	Unit of Measure - Weight Display	String	UDC (00 UM)	2	0	Allow NULL?
64	SHVUMD	Unit of Measure - Volume Display	String	UDC (00 UM)	2	0	Allow NULL?
65	SHAUTN	Authorization Number - Credit Approval	String	Generic Edit	10	0	Allow NULL?
66	SHCACT	Account Number - Credit/Bank	String	Generic Edit	25	0	Allow NULL?
67	SHCEXP	Date - Expired (Julian)	Date	Generic Edit	6	0
68	SHSBLI	Subledger Inactive Code	Character	UDC (00 SI)	1	0	Allow NULL?
69	SHCRMD	Send Method	Character	UDC (00 SM)	1	0	Allow NULL?
70	SHCRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
71	SHCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
72	SHCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
73	SHLNGP	Language	String	UDC (01 LP)	2	0	Allow NULL?
74	SHFAP	Amount - Foreign Open	Numeric	Generic Edit	15	2	Allow NULL?
75	SHFCST	Amount - Foreign Total Cost	Numeric	Generic Edit	15	2	Allow NULL?
76	SHORBY	Ordered By	String	Generic Edit	10	0	Allow NULL?
77	SHTKBY	Order Taken By	String	Generic Edit	10	0	Allow NULL?
78	SHURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
79	SHURDT	User Reserved Date	Date	Generic Edit	6	0
80	SHURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
81	SHURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
82	SHURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
83	SHUSER	User ID	String	Generic Edit	10	0	Allow NULL?
84	SHPID	Program ID	String	Generic Edit	10	0	Allow NULL?
85	SHJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
86	SHUPMJ	Date - Updated	Date	Generic Edit	6	0
87	SHTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
88	SHIR01	Integration Reference 01	String	Generic Edit	30	0	Allow NULL?
89	SHIR02	Integration Reference 02	String	Generic Edit	30	0	Allow NULL?
90	SHIR03	Integration Reference 03	String	Generic Edit	30	0	Allow NULL?
91	SHIR04	Integration Reference 04	String	Generic Edit	30	0	Allow NULL?
92	SHIR05	Integration Reference 05	String	Generic Edit	30	0	Allow NULL?
93	SHVR03	Reference	String	Generic Edit	25	0	Allow NULL?
94	SHSOOR	Source of Order	Integer	Generic Edit	11	0	Allow NULL?
95	SHPMDT	Scheduled Shipment Time	Numeric	Generic Edit	6	0	Allow NULL?
96	SHRSDT	Promised Delivery Time	Numeric	Generic Edit	6	0	Allow NULL?
97	SHRQSJ	Date - Requested Ship	Date	Generic Edit	6	0
98	SHPSTM	Time - Future Time 2	Numeric	Generic Edit	6	0	Allow NULL?
99	SHPDTT	Time - Scheduled Pick	Numeric	Generic Edit	6	0	Allow NULL?
100	SHOPTT	Time - Original Promised Delivery	Numeric	Generic Edit	6	0	Allow NULL?
101	SHDRQT	Requested Delivery Time	Numeric	Generic Edit	6	0	Allow NULL?
102	SHADTM	Actual Shipment Time	Numeric	Generic Edit	6	0	Allow NULL?
103	SHADLJ	Date - Actual Delivery	Date	Generic Edit	6	0
104	SHPBAN	Address Number - Paid By	Numeric	Generic Edit	8	0	Allow NULL?
105	SHITAN	Address Number - Invoiced To	Numeric	Generic Edit	8	0	Allow NULL?
106	SHFTAN	Address Number - Forwarded To	Numeric	Generic Edit	8	0	Allow NULL?
107	SHDVAN	Address Number - Deliver To	Numeric	Generic Edit	8	0	Allow NULL?
108	SHDOC1	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
109	SHDCT4	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
110	SHCORD	Change Order Number	Numeric	Generic Edit	3	0	Allow NULL?
111	SHBSC	Buying Segment Code	String	UDC (42B BS)	10	0	Allow NULL?
112	SHBCRC	Currency Code - Base	String	Generic Edit	3	0	Allow NULL?
113	SHAUFT	Address Number to use for Tax	Character	UDC (42B UA)	1	0	Allow NULL?
114	SHAUFI	Address Number to use for Transportation	Character	UDC (42B UA)	1	0	Allow NULL?
115	SHOPBO	OP Business Objective	String	UDC (34A BO)	30	0	Allow NULL?
116	SHOPTC	OP Total Cost	Numeric	Generic Edit	15	4	Allow NULL?
117	SHOPLD	OP Latest Line Date	Date	Generic Edit	6	0
118	SHOPBK	OP Number of Backorders	Numeric	Generic Edit	15	0	Allow NULL?
119	SHOPSB	OP Number of Substitutes	Numeric	Generic Edit	15	0	Allow NULL?
120	SHOPPS	OP Promised Status	String	Generic Edit	30	0	Allow NULL?
121	SHOPPL	OP Partial Order Shipment	Character	Generic Edit	1	0	Allow NULL?
122	SHOPMS	OP Allow Multi Source	Character	Generic Edit	1	0	Allow NULL?
123	SHOPSS	OP Allow Substitutes	Character	Generic Edit	1	0	Allow NULL?
124	SHOPBA	OP Allow Backorders	Character	Generic Edit	1	0	Allow NULL?
125	SHOPLL	OP Partial Ship Line Items	Character	Generic Edit	1	0	Allow NULL?
126	SHPRAN8	Partner Address Number	Numeric	Generic Edit	8	0	Allow NULL?
127	SHOPPID	Opportunity Number	Numeric	Generic Edit	15	0	Allow NULL?
128	SHSDATTN	Sold To Attention	String	Generic Edit	50	0	Allow NULL?
129	SHSPATTN	Ship To Attention	String	Generic Edit	50	0	Allow NULL?
130	SHOTIND	Order Type Indicator	Character	Generic Edit	1	0	Allow NULL?
131	SHPRCIDLN	Partner Contact Line Number ID	Numeric	Generic Edit	5	0	Allow NULL?
132	SHCCIDLN	Customer Contact Line Number ID	Numeric	Generic Edit	5	0	Allow NULL?
133	SHSHCCIDLN	Ship To Cust Contact Line Num ID	Numeric	Generic Edit	5	0	Allow NULL?

TOP 920 | 42 | F42019 INDEXES

Number

Description

Order Number Order Type + (Primary/Unique)

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

Cust PO Sold To

Element	Alias	Description	Sequence
1	VR01	Reference	Ascending
2	AN8	Address Number	Ascending

Order Type

Element	Alias	Description	Sequence
1	DCTO	Order Type	Ascending

Addr Num Trans Date Ordr Num

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	TRDJ	Date - Order/Transaction	Descending
3	DOCO	Document (Order No Invoice etc.)	Descending

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

133 COLUMNS | 4 INDEXES | 920 | 42 | F42019 TABLE

TOP 920 | 42 | F42019 COLUMNS

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

133 COLUMNS | 4 INDEXES | 920 | 42 | F42019 TABLE

TOP920 | 42 | F42019 COLUMNS

TOP920 | 42 | F42019 INDEXES

TOP 920 | 42 | F42019 COLUMNS

TOP 920 | 42 | F42019 INDEXES