	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

116 COLUMNS | 3 INDEXES | 920 | 42 | F42UI800 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
42: Sales Management
1	920	F42UI800	SD	116	3	Sales Detail Work File - Sales Update	Regular Work 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 SDCTID, SDJOBS, SDMCU, SDDOCO, SDDCTO, SDKCOO, SDLNID, SDDOC, SDDCT, SDKCO, SDEMCU, SDITM, SDLITM, SDAITM, SDCRR, SDCRDC, SDCRCD, SDCRCA, SDAEXP, SDECST, SDFUP, SDFEA, SDFUC, SDFEC, SDXEXP, SDXCST, SDXFEC, SDNXTR, SDLTTR, SDQTYT, SDPQOR, SDPN, SDFY, SDDGL, SDSO02, SDAN8, SDSHAN, SDIVD, SDALPH, SDLOTN, SDLOCN, SDPRGR, SDCLVL, SDUORG, SDSOQS, SDSOCN, SDSOBK, SDCOMM, SDOTQY, SDRCD, SDUOM, SDUNCS, SDGLC, SDTCST, SDTRDJ, SDLNTY, SDSRP1, SDSRP2, SDSRP3, SDSRP4, SDSRP5, SDFRTH, SDPROV, SDATXT, SDEV01, SDAC01, SDAC02, SDAC03, SDAC04, SDAC05, SDWRTH, SDRYIN, SDCO, SDMPSP, SDANUM, SDSO09, SDITWT, SDWUOM, SDSIDT, SDINCY, SDPDDJ, SDUSER, SDJOBN, SDPID, SDUPMJ, SDTDAY, SDPSR, SDPSRY, SDDTO, SDDMCT, SDDMCS, SDSEQ, SDDEFF, SDDREV, SDFDRV, SDFDUC, SDDUNC, SDPSR1, SDPSY2, SDDTO2, SDDMT1, SDDMS1, SDSEQ5, SDUOM2, SDSQOR, SDSO16, SDDRQJ, SDN1FU, SDN2FU, SDN3FU, SDC1FU, SDC2FU, SDD1FU, SDD2FU, SDS1FU, SDS2FU FROM F42UI800

TOP 920 | 42 | F42UI800 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	SDCTID	Computer ID	String	Generic Edit	15	0	Allow NULL?
2	SDJOBS	Job Number	Numeric	Generic Edit	8	0	Allow NULL?
3	SDMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
4	SDDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
5	SDDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
6	SDKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
7	SDLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
8	SDDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
9	SDDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
10	SDKCO	Document Company	String	Generic Edit	5	0	Allow NULL?
11	SDEMCU	Business Unit - Header	String	Generic Edit	12	0	Allow NULL?
12	SDITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
13	SDLITM	2nd Item Number	String	Generic Edit	25	0	Allow NULL?
14	SDAITM	3rd Item Number	String	Generic Edit	25	0	Allow NULL?
15	SDCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
16	SDCRDC	Currency Code - To	String	Generic Edit	3	0	Allow NULL?
17	SDCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
18	SDCRCA	Currency Code - A/B Amounts	String	Generic Edit	3	0	Allow NULL?
19	SDAEXP	Amount - Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
20	SDECST	Amount - Extended Cost	Numeric	Generic Edit	15	2	Allow NULL?
21	SDFUP	Amount - Foreign Price per Unit	Numeric	Generic Edit	15	4	Allow NULL?
22	SDFEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
23	SDFUC	Amount - Foreign Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
24	SDFEC	Amount - Foreign Extended Cost	Numeric	Generic Edit	15	2	Allow NULL?
25	SDXEXP	Amount - Recalculated Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
26	SDXCST	Amount - Recalculated Extended Cost	Numeric	Generic Edit	15	2	Allow NULL?
27	SDXFEC	Amount - Recalc Foreign Extended Cost	Numeric	Generic Edit	15	2	Allow NULL?
28	SDNXTR	Status Code - Next	String	UDC (40 AT)	3	0	Allow NULL?
29	SDLTTR	Status Code - Last	String	UDC (40 AT)	3	0	Allow NULL?
30	SDQTYT	Units - Shipped to Date	Numeric	Generic Edit	15	0	Allow NULL?
31	SDPQOR	Units - Primary Quantity Ordered	Numeric	Generic Edit	15	0	Allow NULL?
32	SDPN	Period Number - General Ledger	Numeric	Generic Edit	2	0	Allow NULL?
33	SDFY	Fiscal Year	Numeric	Generic Edit	2	0	Allow NULL?
34	SDDGL	Date - For G/L (and Voucher)	Date	Generic Edit	6	0
35	SDSO02	On Hand Updated	Character	Generic Edit	1	0	Allow NULL?
36	SDAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
37	SDSHAN	Address Number - Ship To	Numeric	Generic Edit	8	0	Allow NULL?
38	SDIVD	Date - Invoice	Date	Generic Edit	6	0
39	SDALPH	Name - Alpha	String	Generic Edit	40	0	Allow NULL?
40	SDLOTN	Lot/Serial Number	String	Generic Edit	30	0	Allow NULL?
41	SDLOCN	Location	String	Generic Edit	20	0	Allow NULL?
42	SDPRGR	Item Price Group	String	UDC (40 PI)	8	0	Allow NULL?
43	SDCLVL	Pricing Category Level	String	Generic Edit	3	0	Allow NULL?
44	SDUORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	0	Allow NULL?
45	SDSOQS	Quantity Shipped	Numeric	Generic Edit	15	0	Allow NULL?
46	SDSOCN	Units - Quantity Canceled/Scrapped	Numeric	Generic Edit	15	0	Allow NULL?
47	SDSOBK	Units - Qty Backordered/Held	Numeric	Generic Edit	15	0	Allow NULL?
48	SDCOMM	Committed (H/S)	Character	UDC (H42 CP)	1	0	Allow NULL?
49	SDOTQY	Other Quantity (1/2)	Character	UDC	1	0	Allow NULL?
50	SDRCD	Reason Code	String	UDC (42 RC)	3	0	Allow NULL?
51	SDUOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
52	SDUNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
53	SDGLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
54	SDTCST	Extended Cost - Transfer	Numeric	Generic Edit	15	4	Allow NULL?
55	SDTRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
56	SDLNTY	Line Type	String	Generic Edit	2	0	Allow NULL?
57	SDSRP1	Sales Catalog Section	String	UDC (41 S1)	3	0	Allow NULL?
58	SDSRP2	Sub Section	String	UDC (41 S2)	3	0	Allow NULL?
59	SDSRP3	Sales Category Code 3	String	UDC (41 S3)	3	0	Allow NULL?
60	SDSRP4	Sales Category Code 4	String	UDC (41 S4)	3	0	Allow NULL?
61	SDSRP5	Sales Category Code 5	String	UDC (41 S5)	3	0	Allow NULL?
62	SDFRTH	Freight Handling Code	String	UDC (42 FR)	3	0	Allow NULL?
63	SDPROV	Price Override Code	Character	Generic Edit	1	0	Allow NULL?
64	SDATXT	Associated Text	Character	Generic Edit	1	0	Allow NULL?
65	SDEV01	J.D. EnterpriseOne Event Point 01	Character	Generic Edit	1	0	Allow NULL?
66	SDAC01	Category Code - Address Book 01	String	UDC (01 01)	3	0	Allow NULL?
67	SDAC02	Category Code - Address Book 02	String	UDC (01 02)	3	0	Allow NULL?
68	SDAC03	Category Code - Address Book 03	String	UDC (01 03)	3	0	Allow NULL?
69	SDAC04	Category Code - Address Book 04	String	UDC (01 04)	3	0	Allow NULL?
70	SDAC05	Category Code - Address Book 05	String	UDC (01 05)	3	0	Allow NULL?
71	SDWRTH	Flag - Write Ledger Record (Y/N)	Character	Generic Edit	1	0	Allow NULL?
72	SDRYIN	Payment Instrument	Character	UDC (00 PY)	1	0	Allow NULL?
73	SDCO	Company	String	Generic Edit	5	0	Allow NULL?
74	SDMPSP	Planning Time Fence Rule	Character	UDC (34 TF)	1	0	Allow NULL?
75	SDANUM	Number - AAI Table Number	Numeric	Generic Edit	4	0	Allow NULL?
76	SDSO09	Price Adj. History Indicator	Character	Generic Edit	1	0	Allow NULL?
77	SDITWT	Unit Weight	Numeric	Generic Edit	15	4	Allow NULL?
78	SDWUOM	Unit of Measure - Weight	String	UDC (00 UM)	2	0	Allow NULL?
79	SDSIDT	Scheduled Invoice Date	Date	Generic Edit	6	0
80	SDINCY	Invoice Cycle Code	String	UDC (40 CY)	3	0	Allow NULL?
81	SDPDDJ	Date - Scheduled Pick	Date	Generic Edit	6	0
82	SDUSER	User ID	String	Generic Edit	10	0	Allow NULL?
83	SDJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
84	SDPID	Program ID	String	Generic Edit	10	0	Allow NULL?
85	SDUPMJ	Date - Updated	Date	Generic Edit	6	0
86	SDTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
87	SDPSR	Source	String	Generic Edit	12	0	Allow NULL?
88	SDPSRY	Source Type	String	UDC (38 DY)	2	0	Allow NULL?
89	SDDTO	Due To	Character	UDC (38 DT)	1	0	Allow NULL?
90	SDDMCT	Agreement Number - Distribution	String	Generic Edit	12	0	Allow NULL?
91	SDDMCS	Agreement Supplement - Distribution	Numeric	Generic Edit	3	0	Allow NULL?
92	SDSEQ	Sequence Number	Numeric	Generic Edit	6	0	Allow NULL?
93	SDDEFF	Deferred Entries Flag	Character	Generic Edit	1	0	Allow NULL?
94	SDDREV	Amount - Deferred Revenue	Numeric	Generic Edit	15	4	Allow NULL?
95	SDFDRV	Amount - Foreign Deferred Revenue	Numeric	Generic Edit	15	4	Allow NULL?
96	SDFDUC	Amount - Foreign Deferred Cost	Numeric	Generic Edit	15	4	Allow NULL?
97	SDDUNC	Amount - Deferred Cost	Numeric	Generic Edit	15	4	Allow NULL?
98	SDPSR1	Source	String	Generic Edit	12	0	Allow NULL?
99	SDPSY2	Source Type	String	UDC (38 DY)	2	0	Allow NULL?
100	SDDTO2	Due To	Character	UDC (38 DT)	1	0	Allow NULL?
101	SDDMT1	Agreement Number - Distr. (secondary)	String	Generic Edit	12	0	Allow NULL?
102	SDDMS1	Agreement Supplement - Dist. (Secondary)	Numeric	Generic Edit	3	0	Allow NULL?
103	SDSEQ5	Sequence Number	Numeric	Generic Edit	6	0	Allow NULL?
104	SDUOM2	Unit of Measure - Secondary	String	UDC (00 UM)	2	0	Allow NULL?
105	SDSQOR	Units - Secondary Quantity Ordered	Numeric	Generic Edit	15	0	Allow NULL?
106	SDSO16	Manufacturing Variance Accounting Flag	Character	Generic Edit	1	0	Allow NULL?
107	SDDRQJ	Date - Requested	Date	Generic Edit	6	0
108	SDN1FU	Future Use - Math Numeric 1	Numeric	Generic Edit	15	2	Allow NULL?
109	SDN2FU	Future Use - Math Numeric 2	Numeric	Generic Edit	15	8	Allow NULL?
110	SDN3FU	Futrue Use Math Numeric 3	Numeric	Generic Edit	15	8	Allow NULL?
111	SDC1FU	Future Use - Character 1	Character	Generic Edit	1	0	Allow NULL?
112	SDC2FU	Future Use - Character 1	Character	Generic Edit	1	0	Allow NULL?
113	SDD1FU	Future Use - Date 1	Date	Generic Edit	6	0
114	SDD2FU	Future Use - Date 2	Date	Generic Edit	6	0
115	SDS1FU	Future Use String 1	String	Generic Edit	30	0	Allow NULL?
116	SDS2FU	Future Use String 2	String	Generic Edit	30	0	Allow NULL?

TOP 920 | 42 | F42UI800 INDEXES

Number

Description

ComputerID JOB# +A (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
6	LNID	Line Number	Ascending

Computer ID Job Number

Element	Alias	Description	Sequence
1	CTID	Computer ID	Ascending
2	JOBS	Job Number	Ascending

ComputerID Job# B

Element	Alias	Description	Sequence
1	CTID	Computer ID	Ascending
2	JOBS	Job Number	Ascending
3	DOC	Document (Voucher Invoice etc.)	Ascending
4	DCT	Document Type	Ascending
5	KCO	Document Company	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

116 COLUMNS | 3 INDEXES | 920 | 42 | F42UI800 TABLE

TOP 920 | 42 | F42UI800 COLUMNS

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

116 COLUMNS | 3 INDEXES | 920 | 42 | F42UI800 TABLE

TOP920 | 42 | F42UI800 COLUMNS

TOP920 | 42 | F42UI800 INDEXES

TOP 920 | 42 | F42UI800 COLUMNS

TOP 920 | 42 | F42UI800 INDEXES