	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

160 COLUMNS | 3 INDEXES | 812 | 40 | F49211Z1 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
40: Inventory/OP Base
1	812	F49211Z1	S1	160	3	Sales Order Detail Tag Unedited Transaction File	Extra Features Files	42: Sales Management	No

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 S1EDUS, S1EDBT, S1EDTN, S1EDLN, S1EDCT, S1TYTN, S1EDFT, S1EDDT, S1DRIN, S1EDDL, S1EDSP, S1PNID, S1TNAC, S1DOCO, S1DCTO, S1KCOO, S1LNID, S1VMCU, S1TRP, S1LOAD, S1DSGP, S1BPFG, S1DSTN, S1UM, S1DEFF, S1DUNC, S1FDUC, S1DREV, S1FDRV, S1ANUM, S1SIDT, S1INCY, S1LDDT, S1LDTM, S1DCDT, S1PCQY, S1UOMC, S1TEMP, S1STPU, S1DNTY, S1DNTP, S1DETP, S1DTPU, S1VCF, S1PRAS, S1CP01, S1IQTY, S1STUM, S1BUM6, S1AMBR, S1BUM3, S1WGTR, S1BUM5, S1FRTV, S1FRTD, S1FRCC, S1FRVC, S1PVEH, S1RLNO, S1MCUR, S1FLTN, S1DSNN, S1ARCT, S1SORG, S1ELTM, S1PTNR, S1IAN8, S1PTC, S1DOC, S1DCT, S1KCO, S1CRR, S1CRCD, S1TXA1, S1EXR1, S1FRDM, S1FUPT, S1RINO, S1GLOC, S1AUTA, S1ALPH, S1MET1, S1OPN1, S1PNR1, S1MET2, S1OPN2, S1PNR2, S1MET3, S1OPN3, S1PNR3, S1ARDT, S1ARTM, S1DPDT, S1DETM, S1DSTJ, S1STM, S1END, S1ETM, S1TV01, S1TV02, S1TV03, S1TV04, S1TV05, S1TVCD, S1TVQT, S1TVDT, S1TVUM, S1URCD, S1URDT, S1URAT, S1URAB, S1URRF, S1TORG, S1USER, S1PID, S1JOBN, S1UPMJ, S1TDAY, S1SBCK, S1EDCK, S1CMDM, S1BBCK, S1RQSJ, S1PSDJ, S1ADLJ, S1SUB, S1STTS, S1RATT, S1FUF1, S1FRTC, S1FRAT, S1AFT, S1OMCU, S1OBJ, S1LT, S1FAPP, S1DSPR, S1DSFT, S1DMT1, S1DMS1, S1COT, S1CMGL, S1BALU, S1APOT, S1ACGD, S1ANI, S1AID, S1OPOL, S1OPBO, S1OPID, S1OPCS, S1OPLL, S1OPMS, S1OPSS, S1OPBA, S1FXSR, S1PSJOBNO, S1JOBSQ, S1CARDNO, S1DELBATCH FROM F49211Z1

TOP 812 | 40 | F49211Z1 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	S1EDUS	EDI - User ID	String	Generic Edit	10	0	Allow NULL?
2	S1EDBT	EDI - Batch Number	String	Generic Edit	15	0	Allow NULL?
3	S1EDTN	EDI - Transaction Number	String	Generic Edit	22	0	Allow NULL?
4	S1EDLN	EDI - Line Number	Numeric	Generic Edit	7	3	Allow NULL?
5	S1EDCT	EDI - Document Type	String	Generic Edit	2	0	Allow NULL?
6	S1TYTN	Type - Transaction	String	UDC (00 TT)	8	0	Allow NULL?
7	S1EDFT	EDI - Translation Format	String	Generic Edit	10	0	Allow NULL?
8	S1EDDT	EDI - Transmission Date	Date	Generic Edit	6	0
9	S1DRIN	Direction Indicator	Character	UDC (00 DN)	1	0	Allow NULL?
10	S1EDDL	EDI - Detail Lines Processed	Numeric	Generic Edit	5	0	Allow NULL?
11	S1EDSP	EDI - Successfully Processed	Character	Generic Edit	1	0	Allow NULL?
12	S1PNID	Trading Partner ID	String	Generic Edit	15	0	Allow NULL?
13	S1TNAC	Transaction Action	String	UDC (00 TA)	2	0	Allow NULL?
14	S1DOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
15	S1DCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
16	S1KCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
17	S1LNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
18	S1VMCU	Depot - Trip	String	Generic Edit	12	0	Allow NULL?
19	S1TRP	Trip Number	Numeric	Generic Edit	8	0	Allow NULL?
20	S1LOAD	Date - Scheduled Load	Date	Generic Edit	6	0
21	S1DSGP	Dispatch Group	String	UDC (41B DG)	3	0	Allow NULL?
22	S1BPFG	Bulk/Packed Flag	Character	UDC (41B BF)	1	0	Allow NULL?
23	S1DSTN	Distance	Numeric	Generic Edit	5	0	Allow NULL?
24	S1UM	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
25	S1DEFF	Deferred Entries Flag	Character	Generic Edit	1	0	Allow NULL?
26	S1DUNC	Amount - Deferred Cost	Numeric	Generic Edit	15	4	Allow NULL?
27	S1FDUC	Amount - Foreign Deferred Cost	Numeric	Generic Edit	15	4	Allow NULL?
28	S1DREV	Amount - Deferred Revenue	Numeric	Generic Edit	15	4	Allow NULL?
29	S1FDRV	Amount - Foreign Deferred Revenue	Numeric	Generic Edit	15	4	Allow NULL?
30	S1ANUM	Number - AAI Table Number	Numeric	Generic Edit	4	0	Allow NULL?
31	S1SIDT	Scheduled Invoice Date	Date	Generic Edit	6	0
32	S1INCY	Invoice Cycle Code	String	UDC (40 CY)	3	0	Allow NULL?
33	S1LDDT	Load Confirm Date	Date	Generic Edit	6	0
34	S1LDTM	Time - Load	Numeric	Generic Edit	6	0	Allow NULL?
35	S1DCDT	Delivery Confirm Date	Date	Generic Edit	6	0
36	S1PCQY	Units - Primary Committed Quantity	Numeric	Generic Edit	15	2	Allow NULL?
37	S1UOMC	Unit of Measure - Committed Quantity	String	UDC (00 UM)	2	0	Allow NULL?
38	S1TEMP	Temperature	Numeric	Generic Edit	7	2	Allow NULL?
39	S1STPU	Temperature Type	Character	UDC (41B TP)	1	0	Allow NULL?
40	S1DNTY	Density	Numeric	Generic Edit	7	2	Allow NULL?
41	S1DNTP	Density Type - At Standard Temperature	Character	UDC (41B DT)	1	0	Allow NULL?
42	S1DETP	Density Temperature	Numeric	Generic Edit	7	2	Allow NULL?
43	S1DTPU	Temperature Type	Character	UDC (41B TP)	1	0	Allow NULL?
44	S1VCF	Volume Correction Factor	Numeric	Generic Edit	7	4	Allow NULL?
45	S1PRAS	Price at Ambient/Standard/Weight (A S W)	Character	UDC (38 PR)	1	0	Allow NULL?
46	S1CP01	Sales Price Based On Date	Character	UDC (40 DB)	1	0	Allow NULL?
47	S1IQTY	Units - Invoice Quantity	Numeric	Generic Edit	15	2	Allow NULL?
48	S1STUM	Quantity - Primary Stock Accounting Unit	Numeric	Generic Edit	15	2	Allow NULL?
49	S1BUM6	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
50	S1AMBR	Volume - Ambient	Numeric	Generic Edit	15	2	Allow NULL?
51	S1BUM3	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
52	S1WGTR	Weight Result	Numeric	Generic Edit	15	2	Allow NULL?
53	S1BUM5	Unit of Measure 5	String	UDC (00 UM)	2	0	Allow NULL?
54	S1FRTV	Supplier Freight Calculated	Character	Generic Edit	1	0	Allow NULL?
55	S1FRTD	Customer Freight Calculated	Character	Generic Edit	1	0	Allow NULL?
56	S1FRCC	Amount - Customer Freight Charge	Numeric	Generic Edit	15	4	Allow NULL?
57	S1FRVC	Amount - Supplier Freight Charge	Numeric	Generic Edit	15	4	Allow NULL?
58	S1PVEH	Primary Vehicle Id	String	Generic Edit	12	0	Allow NULL?
59	S1RLNO	Registration/License Number	String	Generic Edit	13	0	Allow NULL?
60	S1MCUR	Business Unit - A/R Default	String	Generic Edit	12	0	Allow NULL?
61	S1FLTN	Flight Number	String	Generic Edit	8	0	Allow NULL?
62	S1DSNN	Destination	String	Generic Edit	5	0	Allow NULL?
63	S1ARCT	Aircraft Type	String	Generic Edit (49 AT)	5	0	Allow NULL?
64	S1SORG	Origin	String	Generic Edit	15	0	Allow NULL?
65	S1ELTM	Time - Elapsed	Numeric	Generic Edit	6	0	Allow NULL?
66	S1PTNR	Shipment Number	Numeric	Generic Edit	8	0	Allow NULL?
67	S1IAN8	Address Number - Bond Issued	Numeric	Generic Edit	8	0	Allow NULL?
68	S1PTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
69	S1DOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
70	S1DCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
71	S1KCO	Document Company	String	Generic Edit	5	0	Allow NULL?
72	S1CRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
73	S1CRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
74	S1TXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
75	S1EXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
76	S1FRDM	International/Domestic Flag	Character	Generic Edit	1	0	Allow NULL?
77	S1FUPT	Fueling Port	String	UDC (49 FP)	3	0	Allow NULL?
78	S1RINO	Registration/Identification Number	String	Generic Edit	15	0	Allow NULL?
79	S1GLOC	Delivery Location	String	Generic Edit	15	0	Allow NULL?
80	S1AUTA	Authorization Name	String	Generic Edit	30	0	Allow NULL?
81	S1ALPH	Name - Alpha	String	Generic Edit	40	0	Allow NULL?
82	S1MET1	Meter Ticket 1	String	Generic Edit	10	0	Allow NULL?
83	S1OPN1	Units - Beginning Throughput Qty. 1	Numeric	Generic Edit	15	0	Allow NULL?
84	S1PNR1	Closing Reading 1	Numeric	Generic Edit	15	0	Allow NULL?
85	S1MET2	Meter Ticket 2	String	Generic Edit	10	0	Allow NULL?
86	S1OPN2	Units - Beginning Throughput Qty. 2	Numeric	Generic Edit	15	0	Allow NULL?
87	S1PNR2	Closing Reading 2	Numeric	Generic Edit	15	0	Allow NULL?
88	S1MET3	Meter Ticket 3	String	Generic Edit	10	0	Allow NULL?
89	S1OPN3	Units - Beginning Throughput Qty. 3	Numeric	Generic Edit	15	0	Allow NULL?
90	S1PNR3	Closing Reading 3	Numeric	Generic Edit	15	0	Allow NULL?
91	S1ARDT	Date - Arrival	Date	Generic Edit	6	0
92	S1ARTM	Time - Arrival	Numeric	Generic Edit	6	0	Allow NULL?
93	S1DPDT	Date - Departure	Date	Generic Edit	6	0
94	S1DETM	Time - Departure	Numeric	Generic Edit	6	0	Allow NULL?
95	S1DSTJ	Date - Start Job(Julian)	Date	Generic Edit	6	0
96	S1STM	Time - Start (HH/MM)	Numeric	Generic Edit	4	0	Allow NULL?
97	S1END	Date - Ending	Date	Generic Edit	6	0
98	S1ETM	Time - End (HH/MM)	Numeric	Generic Edit	4	0	Allow NULL?
99	S1TV01	Sales Detail Line Origin	Character	Generic Edit	1	0	Allow NULL?
100	S1TV02	Future Use 02	Character	Generic Edit	1	0	Allow NULL?
101	S1TV03	Future Use 03	Character	Generic Edit	1	0	Allow NULL?
102	S1TV04	Future Use 04	Character	Generic Edit	1	0	Allow NULL?
103	S1TV05	Future Use 05	Character	Generic Edit	1	0	Allow NULL?
104	S1TVCD	Future Use Code	String	Generic Edit	2	0	Allow NULL?
105	S1TVQT	Future Use Quantity	Numeric	Generic Edit	15	0	Allow NULL?
106	S1TVDT	Future Use Date	Date	Generic Edit	6	0
107	S1TVUM	Future Use Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
108	S1URCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
109	S1URDT	User Reserved Date	Date	Generic Edit	6	0
110	S1URAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
111	S1URAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
112	S1URRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
113	S1TORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
114	S1USER	User ID	String	Generic Edit	10	0	Allow NULL?
115	S1PID	Program ID	String	Generic Edit	10	0	Allow NULL?
116	S1JOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
117	S1UPMJ	Date - Updated	Date	Generic Edit	6	0
118	S1TDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
119	S1SBCK	Check Sell By Date	Character	Generic Edit	1	0	Allow NULL?
120	S1EDCK	Check Expiration Date	Character	Generic Edit	1	0	Allow NULL?
121	S1CMDM	Commitment Date Method	Character	UDC (H40 CD)	1	0	Allow NULL?
122	S1BBCK	Check Best Before Date	Character	Generic Edit	1	0	Allow NULL?
123	S1RQSJ	Date - Requested Ship	Date	Generic Edit	6	0
124	S1PSDJ	Date - Future Date 2	Date	Generic Edit	6	0
125	S1ADLJ	Date - Actual Delivery	Date	Generic Edit	6	0
126	S1SUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
127	S1STTS	Line Status	String	Generic Edit	2	0	Allow NULL?
128	S1RATT	Rate Type - Freight/Misc	Character	Generic Edit	1	0	Allow NULL?
129	S1FUF1	AIA Document Flag	Character	UDC (H40 FU)	1	0	Allow NULL?
130	S1FRTC	Freight Calculated (Y/N)	Character	Generic Edit	1	0	Allow NULL?
131	S1FRAT	Rate Code - Frieght/Misc	String	UDC (41 RT)	10	0	Allow NULL?
132	S1AFT	Apply Freight - Y/N	Character	Generic Edit	1	0	Allow NULL?
133	S1OMCU	Project Business Unit	String	Generic Edit	12	0	Allow NULL?
134	S1OBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
135	S1LT	Ledger Types	String	UDC (09 LT)	2	0	Allow NULL?
136	S1FAPP	Discount Application Type	Character	Generic Edit	1	0	Allow NULL?
137	S1DSPR	Discount Factor	Numeric	Generic Edit	7	4	Allow NULL?
138	S1DSFT	Discount Factor Type - $ or % (D/P)	Character	UDC (H41 DS)	1	0	Allow NULL?
139	S1DMT1	Agreement Number - Distr. (secondary)	String	Generic Edit	12	0	Allow NULL?
140	S1DMS1	Agreement Supplement - Dist. (Secondary)	Numeric	Generic Edit	3	0	Allow NULL?
141	S1COT	Conditions of Transport	String	UDC (00 TC)	3	0	Allow NULL?
142	S1CMGL	Commitment Method	Character	UDC (H40 CM)	1	0	Allow NULL?
143	S1BALU	Contract Balances Updated Y/N	Character	Generic Edit	1	0	Allow NULL?
144	S1APOT	Actual Potency	Numeric	Generic Edit	7	3	Allow NULL?
145	S1ACGD	Actual Grade	String	UDC (40 LG)	3	0	Allow NULL?
146	S1ANI	Account Number - Input (Mode Unknown)	String	Generic Edit	29	0	Allow NULL?
147	S1AID	Account ID	String	Generic Edit	8	0	Allow NULL?
148	S1OPOL	OP Original Line Number	Numeric	Generic Edit	6	3	Allow NULL?
149	S1OPBO	OP Business Objective	String	UDC (34A BO)	30	0	Allow NULL?
150	S1OPID	OP Scenario ID	String	Generic Edit	30	0	Allow NULL?
151	S1OPCS	OP Cost	Numeric	Generic Edit	15	4	Allow NULL?
152	S1OPLL	OP Partial Ship Line Items	Character	Generic Edit	1	0	Allow NULL?
153	S1OPMS	OP Allow Multi Source	Character	Generic Edit	1	0	Allow NULL?
154	S1OPSS	OP Allow Substitutes	Character	Generic Edit	1	0	Allow NULL?
155	S1OPBA	OP Allow Backorders	Character	Generic Edit	1	0	Allow NULL?
156	S1FXSR	Fix Source Location	Character	Generic Edit	1	0	Allow NULL?
157	S1PSJOBNO	Production Sequencing Job Number	String	Generic Edit	15	0	Allow NULL?
158	S1JOBSQ	Job Sequence Number	String	Generic Edit	15	0	Allow NULL?
159	S1CARDNO	Card Number	String	UDC (40R CD)	4	0	Allow NULL?
160	S1DELBATCH	Delivery Batch Number	String	Generic Edit	6	0	Allow NULL?

TOP 812 | 40 | F49211Z1 INDEXES

Number

Description

UserID BatchNumber +A (Primary/Unique)

Element	Alias	Description	Sequence
1	EDUS	EDI - User ID	Ascending
2	EDBT	EDI - Batch Number	Ascending
3	EDTN	EDI - Transaction Number	Ascending
4	EDLN	EDI - Line Number	Ascending

Doc Number Doc 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	EDUS	EDI - User ID	Ascending
5	LNID	Line Number	Ascending

Doc Number Line Number +

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	LNID	Line Number	Ascending
5	EDUS	EDI - User ID	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

160 COLUMNS | 3 INDEXES | 812 | 40 | F49211Z1 TABLE

TOP 812 | 40 | F49211Z1 COLUMNS

TOP 812 | 40 | F49211Z1 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

160 COLUMNS | 3 INDEXES | 812 | 40 | F49211Z1 TABLE

TOP812 | 40 | F49211Z1 COLUMNS

TOP812 | 40 | F49211Z1 INDEXES

TOP 812 | 40 | F49211Z1 COLUMNS

TOP 812 | 40 | F49211Z1 INDEXES