	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

267 COLUMNS | 1 INDEXES | 920 | 47 | F47012 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
47: Electronic Commerce
1	920	F47012	SZ	267	1	EDI Purchase Order Detail - Inbound	Batch Input 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 SZEDTY, SZEDSQ, SZEKCO, SZEDOC, SZEDCT, SZEDLN, SZEDST, SZEDFT, SZEDDT, SZEDER, SZEDDL, SZEDSP, SZEDBT, SZPNID, SZKCOO, SZDOCO, SZDCTO, SZLNID, SZSFXO, SZMCU, SZCO, SZOKCO, SZOORN, SZOCTO, SZOGNO, SZRKCO, SZRORN, SZRCTO, SZRLLN, SZDMCT, SZDMCS, SZAN8, SZSHAN, SZPA8, SZDRQJ, SZTRDJ, SZPDDJ, SZOPDJ, SZADDJ, SZIVD, SZCNDJ, SZDGL, SZRSDJ, SZPEFJ, SZPPDJ, SZPSDJ, SZVR01, SZVR02, SZITM, SZLITM, SZAITM, SZCITM, SZLOCN, SZLOTN, SZFRGD, SZTHGD, SZFRMP, SZTHRP, SZEXDP, SZDSC1, SZDSC2, SZLNTY, SZNXTR, SZLTTR, SZEMCU, SZRLIT, SZKTLN, SZCPNT, SZRKIT, SZKTP, SZSRP1, SZSRP2, SZSRP3, SZSRP4, SZSRP5, SZPRP1, SZPRP2, SZPRP3, SZPRP4, SZPRP5, SZUOM, SZUORG, SZSOQS, SZSOBK, SZSOCN, SZSONE, SZUOPN, SZQTYT, SZQRLV, SZCOMM, SZOTQY, SZUPRC, SZAEXP, SZAOPN, SZPROV, SZTPC, SZAPUM, SZLPRC, SZUNCS, SZECST, SZCSTO, SZTCST, SZINMG, SZPTC, SZRYIN, SZDTBS, SZTRDC, SZFUN2, SZASN, SZPRGR, SZCLVL, SZDSPR, SZDSFT, SZFAPP, SZCADC, SZKCO, SZDOC, SZDCT, SZODOC, SZODCT, SZOKC, SZPSN, SZDELN, SZTAX1, SZTXA1, SZEXR1, SZATXT, SZPRIO, SZRESL, SZBACK, SZSBAL, SZAPTS, SZLOB, SZEUSE, SZDTYS, SZNTR, SZVEND, SZANBY, SZCARS, SZMOT, SZCOT, SZROUT, SZSTOP, SZZON, SZCNID, SZFRTH, SZAFT, SZFUF1, SZFRTC, SZFRAT, SZRATT, SZSHCM, SZSHCN, SZSERN, SZUOM1, SZPQOR, SZUOM2, SZSQOR, SZUOM4, SZITWT, SZWTUM, SZITVL, SZVLUM, SZRPRC, SZORPR, SZORP, SZCMGP, SZCMGL, SZGLC, SZCTRY, SZFY, SZSTTS, SZSO01, SZSO02, SZSO03, SZSO04, SZSO05, SZSO06, SZSO07, SZSO08, SZSO09, SZSO10, SZSO11, SZSO12, SZSO13, SZSO14, SZSO15, SZACOM, SZCMCG, SZRCD, SZGRWT, SZGWUM, SZANI, SZAID, SZOMCU, SZOBJ, SZSUB, SZLT, SZSBL, SZSBLT, SZLCOD, SZUPC1, SZUPC2, SZUPC3, SZSWMS, SZUNCD, SZCRMD, SZCRCD, SZCRR, SZFPRC, SZFUP, SZFEA, SZFUC, SZFEC, SZURCD, SZURDT, SZURAT, SZURAB, SZURRF, SZTORG, SZUSER, SZPID, SZJOBN, SZUPMJ, SZTDAY, SZIR01, SZIR02, SZIR03, SZIR04, SZIR05, SZSOOR, SZDEID, SZPSIG, SZRLNU, SZPMDT, SZRLTM, SZRLDJ, SZDRQT, SZADTM, SZOPTT, SZPDTT, SZPSTM, SZPMTN, SZBSC, SZCBSC, SZDVAN, SZRFRV, SZSHPN, SZPRJM, SZHOLD, SZPMTO, SZDUAL, SZPODC01, SZPODC02, SZPODC03, SZPODC04, SZJBCD, SZSRQTY, SZSRUOM, SZCFGFL, SZGAN8, SZGSHAN, SZGPA8, SZGVEND, SZGCARS, SZGDVAN, SZPMPN FROM F47012

TOP 920 | 47 | F47012 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	SZEDTY	Type Record	Character	UDC (00 RD)	1	0	Allow NULL?
2	SZEDSQ	Record Sequence	Numeric	Generic Edit	2	0	Allow NULL?
3	SZEKCO	Company - Key (EDI - Document Key Co)	String	Generic Edit	5	0	Allow NULL?
4	SZEDOC	EDI - Document Number	Numeric	Generic Edit	9	0	Allow NULL?
5	SZEDCT	EDI - Document Type	String	Generic Edit	2	0	Allow NULL?
6	SZEDLN	EDI - Line Number	Numeric	Generic Edit	7	3	Allow NULL?
7	SZEDST	EDI - Transaction Set Number	String	UDC (40 ST)	6	0	Allow NULL?
8	SZEDFT	EDI - Translation Format	String	Generic Edit	10	0	Allow NULL?
9	SZEDDT	EDI - Transmission Date	Date	Generic Edit	6	0
10	SZEDER	EDI - Send/Receive Indicator	Character	UDC (H00 ED)	1	0	Allow NULL?
11	SZEDDL	EDI - Detail Lines Processed	Numeric	Generic Edit	5	0	Allow NULL?
12	SZEDSP	EDI - Successfully Processed	Character	Generic Edit	1	0	Allow NULL?
13	SZEDBT	EDI - Batch Number	String	Generic Edit	15	0	Allow NULL?
14	SZPNID	Trading Partner ID	String	Generic Edit	15	0	Allow NULL?
15	SZKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
16	SZDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
17	SZDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
18	SZLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
19	SZSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
20	SZMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
21	SZCO	Company	String	Generic Edit	5	0	Allow NULL?
22	SZOKCO	Document Company (Original Order)	String	Generic Edit	5	0	Allow NULL?
23	SZOORN	Original Order Number	String	Generic Edit	8	0	Allow NULL?
24	SZOCTO	Original Order Type	String	UDC (00 DT)	2	0	Allow NULL?
25	SZOGNO	Original Line Number	Numeric	Generic Edit	7	3	Allow NULL?
26	SZRKCO	Company - Key (Related Order)	String	Generic Edit	5	0	Allow NULL?
27	SZRORN	Related PO/SO/WO Number	String	Generic Edit	8	0	Allow NULL?
28	SZRCTO	Related PO/SO/WO Order Type	String	UDC (00 DT)	2	0	Allow NULL?
29	SZRLLN	Related PO/SO Line Number	Numeric	Generic Edit	7	3	Allow NULL?
30	SZDMCT	Agreement Number - Distribution	String	Generic Edit	12	0	Allow NULL?
31	SZDMCS	Agreement Supplement - Distribution	Numeric	Generic Edit	3	0	Allow NULL?
32	SZAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
33	SZSHAN	Address Number - Ship To	Numeric	Generic Edit	8	0	Allow NULL?
34	SZPA8	Address Number - Parent	Numeric	Generic Edit	8	0	Allow NULL?
35	SZDRQJ	Date - Requested	Date	Generic Edit	6	0
36	SZTRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
37	SZPDDJ	Date - Scheduled Pick	Date	Generic Edit	6	0
38	SZOPDJ	Date - Original Promised Delivery	Date	Generic Edit	6	0
39	SZADDJ	Date - Actual Ship Date	Date	Generic Edit	6	0
40	SZIVD	Date - Invoice	Date	Generic Edit	6	0
41	SZCNDJ	Date - Cancel	Date	Generic Edit	6	0
42	SZDGL	Date - For G/L (and Voucher)	Date	Generic Edit	6	0
43	SZRSDJ	Date - Promised Delivery	Date	Generic Edit	6	0
44	SZPEFJ	Date - Price Effective Date	Date	Generic Edit	6	0
45	SZPPDJ	Date - Promised Shipment	Date	Generic Edit	6	0
46	SZPSDJ	Date - Future Date 2	Date	Generic Edit	6	0
47	SZVR01	Reference	String	Generic Edit	25	0	Allow NULL?
48	SZVR02	Reference 2	String	Generic Edit	25	0	Allow NULL?
49	SZITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
50	SZLITM	2nd Item Number	String	Generic Edit	25	0	Allow NULL?
51	SZAITM	3rd Item Number	String	Generic Edit	25	0	Allow NULL?
52	SZCITM	Item Number - Customer/Supplier	String	Generic Edit	25	0	Allow NULL?
53	SZLOCN	Location	String	Generic Edit	20	0	Allow NULL?
54	SZLOTN	Lot/Serial Number	String	Generic Edit	30	0	Allow NULL?
55	SZFRGD	From Grade	String	UDC (40 LG)	3	0	Allow NULL?
56	SZTHGD	Thru Grade	String	UDC (40 LG)	3	0	Allow NULL?
57	SZFRMP	From Potency	Numeric	Generic Edit	7	3	Allow NULL?
58	SZTHRP	Thru Potency	Numeric	Generic Edit	7	3	Allow NULL?
59	SZEXDP	Days Before Expiration	Numeric	Generic Edit	5	0	Allow NULL?
60	SZDSC1	Description	String	Generic Edit	30	0	Allow NULL?
61	SZDSC2	Description - Line 2	String	Generic Edit	30	0	Allow NULL?
62	SZLNTY	Line Type	String	Generic Edit	2	0	Allow NULL?
63	SZNXTR	Status Code - Next	String	UDC (40 AT)	3	0	Allow NULL?
64	SZLTTR	Status Code - Last	String	UDC (40 AT)	3	0	Allow NULL?
65	SZEMCU	Business Unit - Header	String	Generic Edit	12	0	Allow NULL?
66	SZRLIT	Item Number - Related (Kit)	String	Generic Edit	8	0	Allow NULL?
67	SZKTLN	Kit Master Line Number	Numeric	Generic Edit	6	3	Allow NULL?
68	SZCPNT	Component Line Number	Numeric	Generic Edit	4	1	Allow NULL?
69	SZRKIT	Related Kit Component	Numeric	Generic Edit	8	0	Allow NULL?
70	SZKTP	Number of Component Per Parent	Numeric	Generic Edit	15	0	Allow NULL?
71	SZSRP1	Sales Catalog Section	String	UDC (41 S1)	3	0	Allow NULL?
72	SZSRP2	Sub Section	String	UDC (41 S2)	3	0	Allow NULL?
73	SZSRP3	Sales Category Code 3	String	UDC (41 S3)	3	0	Allow NULL?
74	SZSRP4	Sales Category Code 4	String	UDC (41 S4)	3	0	Allow NULL?
75	SZSRP5	Sales Category Code 5	String	UDC (41 S5)	3	0	Allow NULL?
76	SZPRP1	Commodity Class	String	UDC (41 P1)	3	0	Allow NULL?
77	SZPRP2	Commodity Sub Class	String	UDC (41 P2)	3	0	Allow NULL?
78	SZPRP3	Supplier Rebate Code	String	UDC (41 P3)	3	0	Allow NULL?
79	SZPRP4	Master Planning Family	String	UDC (41 P4)	3	0	Allow NULL?
80	SZPRP5	Purchasing Category Code 5	String	UDC (41 P5)	3	0	Allow NULL?
81	SZUOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
82	SZUORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	0	Allow NULL?
83	SZSOQS	Quantity Shipped	Numeric	Generic Edit	15	0	Allow NULL?
84	SZSOBK	Units - Qty Backordered/Held	Numeric	Generic Edit	15	0	Allow NULL?
85	SZSOCN	Units - Quantity Canceled/Scrapped	Numeric	Generic Edit	15	0	Allow NULL?
86	SZSONE	Units - Future Quantity Committed	Numeric	Generic Edit	15	0	Allow NULL?
87	SZUOPN	Units - Open	Numeric	Generic Edit	15	0	Allow NULL?
88	SZQTYT	Units - Shipped to Date	Numeric	Generic Edit	15	0	Allow NULL?
89	SZQRLV	Units - Relieved	Numeric	Generic Edit	15	0	Allow NULL?
90	SZCOMM	Committed (H/S)	Character	UDC (H42 CP)	1	0	Allow NULL?
91	SZOTQY	Other Quantity (1/2)	Character	UDC	1	0	Allow NULL?
92	SZUPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4	Allow NULL?
93	SZAEXP	Amount - Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
94	SZAOPN	Amount - Open	Numeric	Generic Edit	15	2	Allow NULL?
95	SZPROV	Price Override Code	Character	Generic Edit	1	0	Allow NULL?
96	SZTPC	Temporary Price (Y/N)	Character	Generic Edit	1	0	Allow NULL?
97	SZAPUM	Unit of Measure - Entered for Unit Price	String	UDC (00 UM)	2	0	Allow NULL?
98	SZLPRC	Amount - List Price	Numeric	Generic Edit	15	4	Allow NULL?
99	SZUNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
100	SZECST	Amount - Extended Cost	Numeric	Generic Edit	15	2	Allow NULL?
101	SZCSTO	Cost Override Code	Character	Generic Edit	1	0	Allow NULL?
102	SZTCST	Extended Cost - Transfer	Numeric	Generic Edit	15	4	Allow NULL?
103	SZINMG	Print Message	String	UDC (40 PM)	10	0	Allow NULL?
104	SZPTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
105	SZRYIN	Payment Instrument	Character	UDC (00 PY)	1	0	Allow NULL?
106	SZDTBS	Based on Date	Character	UDC (42 BD)	1	0	Allow NULL?
107	SZTRDC	Discount - Trade	Numeric	Generic Edit	7	3	Allow NULL?
108	SZFUN2	Trade Discount (Old)	Numeric	Generic Edit	15	4	Allow NULL?
109	SZASN	Price and Adjustment Schedule	String	UDC (40 AS)	8	0	Allow NULL?
110	SZPRGR	Item Price Group	String	UDC (40 PI)	8	0	Allow NULL?
111	SZCLVL	Pricing Category Level	String	Generic Edit	3	0	Allow NULL?
112	SZDSPR	Discount Factor	Numeric	Generic Edit	7	4	Allow NULL?
113	SZDSFT	Discount Factor Type - $ or % (D/P)	Character	UDC (H41 DS)	1	0	Allow NULL?
114	SZFAPP	Discount Application Type	Character	Generic Edit	1	0	Allow NULL?
115	SZCADC	Discount % - Cash	Numeric	Generic Edit	7	3	Allow NULL?
116	SZKCO	Document Company	String	Generic Edit	5	0	Allow NULL?
117	SZDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
118	SZDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
119	SZODOC	Document - Original	Numeric	Generic Edit	8	0	Allow NULL?
120	SZODCT	Document Type - Original	String	UDC (00 DT)	2	0	Allow NULL?
121	SZOKC	Document Company - Original	String	Generic Edit	5	0	Allow NULL?
122	SZPSN	Pick Slip Number	Numeric	Generic Edit	8	0	Allow NULL?
123	SZDELN	Delivery Number	Numeric	Generic Edit	8	0	Allow NULL?
124	SZTAX1	Sales Taxable (Y/N)	Character	UDC (H00 TV)	1	0	Allow NULL?
125	SZTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
126	SZEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
127	SZATXT	Associated Text	Character	Generic Edit	1	0	Allow NULL?
128	SZPRIO	Priority - Processing	Character	UDC (H40 PR)	1	0	Allow NULL?
129	SZRESL	Printed Code	Character	Generic Edit	1	0	Allow NULL?
130	SZBACK	Backorders Allowed (Y/N)	Character	Generic Edit	1	0	Allow NULL?
131	SZSBAL	Substitutes Allowed (Y/N)	Character	Generic Edit	1	0	Allow NULL?
132	SZAPTS	Partial Line Shipments Allowed (Y/N)	Character	Generic Edit	1	0	Allow NULL?
133	SZLOB	Line of Business	String	UDC (40 LB)	3	0	Allow NULL?
134	SZEUSE	End Use	String	UDC (40 EU)	3	0	Allow NULL?
135	SZDTYS	Duty Status	String	UDC (40 DS)	2	0	Allow NULL?
136	SZNTR	Nature of Transaction	String	UDC (00 NT)	2	0	Allow NULL?
137	SZVEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0	Allow NULL?
138	SZANBY	Buyer Number	Numeric	Generic Edit	8	0	Allow NULL?
139	SZCARS	Carrier Number	Numeric	Generic Edit	8	0	Allow NULL?
140	SZMOT	Mode of Transport	String	UDC (00 TM)	3	0	Allow NULL?
141	SZCOT	Conditions of Transport	String	UDC (00 TC)	3	0	Allow NULL?
142	SZROUT	Route Code	String	UDC (42 RT)	3	0	Allow NULL?
143	SZSTOP	Stop Code	String	UDC (42 SP)	3	0	Allow NULL?
144	SZZON	Zone Number	String	UDC (40 ZN)	3	0	Allow NULL?
145	SZCNID	Container I.D.	String	Generic Edit	20	0	Allow NULL?
146	SZFRTH	Freight Handling Code	String	UDC (42 FR)	3	0	Allow NULL?
147	SZAFT	Apply Freight - Y/N	Character	Generic Edit	1	0	Allow NULL?
148	SZFUF1	AIA Document Flag	Character	UDC (H40 FU)	1	0	Allow NULL?
149	SZFRTC	Freight Calculated (Y/N)	Character	Generic Edit	1	0	Allow NULL?
150	SZFRAT	Rate Code - Frieght/Misc	String	UDC (41 RT)	10	0	Allow NULL?
151	SZRATT	Rate Type - Freight/Misc	Character	Generic Edit	1	0	Allow NULL?
152	SZSHCM	Shipping Commodity Class	String	UDC (41 E)	3	0	Allow NULL?
153	SZSHCN	Shipping Conditions Code	String	UDC (41 C)	3	0	Allow NULL?
154	SZSERN	Serial Number - Lot	String	Generic Edit	30	0	Allow NULL?
155	SZUOM1	Unit of Measure - Primary	String	UDC (00 UM)	2	0	Allow NULL?
156	SZPQOR	Units - Primary Quantity Ordered	Numeric	Generic Edit	15	0	Allow NULL?
157	SZUOM2	Unit of Measure - Secondary	String	UDC (00 UM)	2	0	Allow NULL?
158	SZSQOR	Units - Secondary Quantity Ordered	Numeric	Generic Edit	15	0	Allow NULL?
159	SZUOM4	Unit of Measure - Pricing	String	UDC (00 UM)	2	0	Allow NULL?
160	SZITWT	Unit Weight	Numeric	Generic Edit	15	4	Allow NULL?
161	SZWTUM	Weight Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
162	SZITVL	Unit Volume	Numeric	Generic Edit	15	4	Allow NULL?
163	SZVLUM	Volume Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
164	SZRPRC	Reprice (Basket Price) Category	String	UDC (40 PI)	8	0	Allow NULL?
165	SZORPR	Order Reprice Category	String	UDC (40 PI)	8	0	Allow NULL?
166	SZORP	Order Repriced Indicator	Character	Generic Edit	1	0	Allow NULL?
167	SZCMGP	Costing Method - Inventory	String	Generic Edit	2	0	Allow NULL?
168	SZCMGL	Commitment Method	Character	UDC (H40 CM)	1	0	Allow NULL?
169	SZGLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
170	SZCTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
171	SZFY	Fiscal Year	Numeric	Generic Edit	2	0	Allow NULL?
172	SZSTTS	Line Status	String	Generic Edit	2	0	Allow NULL?
173	SZSO01	Inter Branch Sales	Character	Generic Edit	1	0	Allow NULL?
174	SZSO02	On Hand Updated	Character	Generic Edit	1	0	Allow NULL?
175	SZSO03	Configurator Print Flag	Character	Generic Edit	1	0	Allow NULL?
176	SZSO04	Sales Order Status 04	Character	Generic Edit	1	0	Allow NULL?
177	SZSO05	Substitute Item Indicator	Character	Generic Edit	1	0	Allow NULL?
178	SZSO06	Preference Commitment Indicator	Character	Generic Edit	1	0	Allow NULL?
179	SZSO07	Ship date (PDDJ) overridden	Character	Generic Edit	1	0	Allow NULL?
180	SZSO08	Price Adjustment Line Indicator	Character	Generic Edit	1	0	Allow NULL?
181	SZSO09	Price Adj. History Indicator	Character	Generic Edit	1	0	Allow NULL?
182	SZSO10	Preference Production Allocation	Character	Generic Edit	1	0	Allow NULL?
183	SZSO11	Transfer/Direct Ship/Intercompany Flag	Character	Generic Edit	1	0	Allow NULL?
184	SZSO12	Deferred entries flag	Character	Generic Edit	1	0	Allow NULL?
185	SZSO13	Euro Conversion Status Flag	Character	Generic Edit	1	0	Allow NULL?
186	SZSO14	Sales Order Status 14	Character	Generic Edit	1	0	Allow NULL?
187	SZSO15	Sales Order Status 15	Character	Generic Edit	1	0	Allow NULL?
188	SZACOM	Apply Commission (Y/N)	Character	Generic Edit	1	0	Allow NULL?
189	SZCMCG	Commission Category	String	Generic Edit	8	0	Allow NULL?
190	SZRCD	Reason Code	String	UDC (42 RC)	3	0	Allow NULL?
191	SZGRWT	Gross Weight	Numeric	Generic Edit	15	4	Allow NULL?
192	SZGWUM	Gross Weight Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
193	SZANI	Account Number - Input (Mode Unknown)	String	Generic Edit	29	0	Allow NULL?
194	SZAID	Account ID	String	Generic Edit	8	0	Allow NULL?
195	SZOMCU	Project Business Unit	String	Generic Edit	12	0	Allow NULL?
196	SZOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
197	SZSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
198	SZLT	Ledger Types	String	UDC (09 LT)	2	0	Allow NULL?
199	SZSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
200	SZSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
201	SZLCOD	Code - Location Tax Status	String	UDC (46 LT)	2	0	Allow NULL?
202	SZUPC1	Price Code 1	String	UDC (40 P1)	2	0	Allow NULL?
203	SZUPC2	Price Code 2	String	UDC (40 P2)	2	0	Allow NULL?
204	SZUPC3	Price Code 3	String	UDC (40 P3)	2	0	Allow NULL?
205	SZSWMS	Status - In Warehouse	Character	Generic Edit	1	0	Allow NULL?
206	SZUNCD	Work Order Freeze Code	Character	UDC (H00 UN)	1	0	Allow NULL?
207	SZCRMD	Send Method	Character	UDC (00 SM)	1	0	Allow NULL?
208	SZCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
209	SZCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
210	SZFPRC	Amount - List Price per Unit	Numeric	Generic Edit	15	4	Allow NULL?
211	SZFUP	Amount - Foreign Price per Unit	Numeric	Generic Edit	15	4	Allow NULL?
212	SZFEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
213	SZFUC	Amount - Foreign Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
214	SZFEC	Amount - Foreign Extended Cost	Numeric	Generic Edit	15	2	Allow NULL?
215	SZURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
216	SZURDT	User Reserved Date	Date	Generic Edit	6	0
217	SZURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
218	SZURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
219	SZURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
220	SZTORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
221	SZUSER	User ID	String	Generic Edit	10	0	Allow NULL?
222	SZPID	Program ID	String	Generic Edit	10	0	Allow NULL?
223	SZJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
224	SZUPMJ	Date - Updated	Date	Generic Edit	6	0
225	SZTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
226	SZIR01	Integration Reference 01	String	Generic Edit	30	0	Allow NULL?
227	SZIR02	Integration Reference 02	String	Generic Edit	30	0	Allow NULL?
228	SZIR03	Integration Reference 03	String	Generic Edit	30	0	Allow NULL?
229	SZIR04	Integration Reference 04	String	Generic Edit	30	0	Allow NULL?
230	SZIR05	Integration Reference 05	String	Generic Edit	30	0	Allow NULL?
231	SZSOOR	Source of Order	Integer	Generic Edit	11	0	Allow NULL?
232	SZDEID	Demand Unique Key ID	Numeric	Generic Edit	15	0	Allow NULL?
233	SZPSIG	Pull Signal	String	Generic Edit	30	0	Allow NULL?
234	SZRLNU	Release Number	String	Generic Edit	10	0	Allow NULL?
235	SZPMDT	Scheduled Shipment Time	Numeric	Generic Edit	6	0	Allow NULL?
236	SZRLTM	Time - Release	Numeric	Generic Edit	6	0	Allow NULL?
237	SZRLDJ	Date - Release	Date	Generic Edit	6	0
238	SZDRQT	Requested Delivery Time	Numeric	Generic Edit	6	0	Allow NULL?
239	SZADTM	Actual Shipment Time	Numeric	Generic Edit	6	0	Allow NULL?
240	SZOPTT	Time - Original Promised Delivery	Numeric	Generic Edit	6	0	Allow NULL?
241	SZPDTT	Time - Scheduled Pick	Numeric	Generic Edit	6	0	Allow NULL?
242	SZPSTM	Time - Future Time 2	Numeric	Generic Edit	6	0	Allow NULL?
243	SZPMTN	Promotion ID	String	Generic Edit	12	0	Allow NULL?
244	SZBSC	Buying Segment Code	String	UDC (42B BS)	10	0	Allow NULL?
245	SZCBSC	Current Buying Segment Code	String	UDC (42B BS)	10	0	Allow NULL?
246	SZDVAN	Address Number - Deliver To	Numeric	Generic Edit	8	0	Allow NULL?
247	SZRFRV	Revision Reason	String	UDC (42 RR)	3	0	Allow NULL?
248	SZSHPN	Shipment Number	Numeric	Generic Edit	8	0	Allow NULL?
249	SZPRJM	Project Number	Numeric	Generic Edit	8	0	Allow NULL?
250	SZHOLD	Hold Orders Code	String	UDC (42 HC)	2	0	Allow NULL?
251	SZPMTO	Payment Terms Override Code	Character	Generic Edit	1	0	Allow NULL?
252	SZDUAL	Dual Unit Of Measure Item	Character	Generic Edit	1	0	Allow NULL?
253	SZPODC01	Purchase Line Code 01	String	UDC (43 C7)	3	0	Allow NULL?
254	SZPODC02	Purchase Line Code 02	String	UDC (43 C8)	3	0	Allow NULL?
255	SZPODC03	Purchase Line Code 03	String	UDC (43 L7)	10	0	Allow NULL?
256	SZPODC04	Purchase Line Code 04	String	UDC (43 L8)	10	0	Allow NULL?
257	SZJBCD	Job Type (Craft) Code	String	UDC (06 G)	6	0	Allow NULL?
258	SZSRQTY	Service Quantity	Numeric	Generic Edit	15	4	Allow NULL?
259	SZSRUOM	Service Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
260	SZCFGFL	Created By Configurator Flag	Character	Generic Edit	1	0	Allow NULL?
261	SZGAN8	Global Location Number	Numeric	Generic Edit	13	0	Allow NULL?
262	SZGSHAN	Ship To GLN	Numeric	Generic Edit	13	0	Allow NULL?
263	SZGPA8	Parent Address GLN	Numeric	Generic Edit	13	0	Allow NULL?
264	SZGVEND	Vendor GLN	Numeric	Generic Edit	13	0	Allow NULL?
265	SZGCARS	Carrier Number GLN	Numeric	Generic Edit	13	0	Allow NULL?
266	SZGDVAN	Deliver To Address GLN	Numeric	Generic Edit	13	0	Allow NULL?
267	SZPMPN	Production Number	String	Generic Edit	30	0	Allow NULL?

TOP 920 | 47 | F47012 INDEXES

Number

Description

EdiDocNum EdiDocType + (Primary/Unique)

Element	Alias	Description	Sequence
1	EDOC	EDI - Document Number	Ascending
2	EDCT	EDI - Document Type	Ascending
3	EKCO	Company - Key (EDI - Document Key Co)	Ascending
4	EDLN	EDI - 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

267 COLUMNS | 1 INDEXES | 920 | 47 | F47012 TABLE

TOP 920 | 47 | F47012 COLUMNS

TOP 920 | 47 | F47012 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

267 COLUMNS | 1 INDEXES | 920 | 47 | F47012 TABLE

TOP920 | 47 | F47012 COLUMNS

TOP920 | 47 | F47012 INDEXES

TOP 920 | 47 | F47012 COLUMNS

TOP 920 | 47 | F47012 INDEXES