	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

253 COLUMNS | 1 INDEXES | 812 | 47 | F47072 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
47: Electronic Commerce
1	812	F47072	SZ	253	1	EDI Receiving Advice Detail - Inbound	Batch Input Files	43: Procurement	AS400 Coexistence Tables

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, SZLSTS, SZKCOO, SZDOCO, SZDCTO, SZSFXO, SZLNID, SZMCU, SZCO, SZOKCO, SZOORN, SZOCTO, SZOGNO, SZRKCO, SZRORN, SZRCTO, SZRLLN, SZDMCT, SZDMCS, SZAN8, SZSHAN, SZDRQJ, SZTRDJ, SZPDDJ, SZOPDJ, SZADDJ, SZCNDJ, SZPEFJ, SZPPDJ, SZPSDJ, SZDSVJ, SZDGL, SZPN, SZVR01, SZVR02, SZITM, SZLITM, SZAITM, SZCITM, SZLOCN, SZLOTN, SZFRGD, SZTHGD, SZFRMP, SZTHRP, SZDSC1, SZDSC2, SZLNTY, SZNXTR, SZLTTR, SZRLIT, SZPDS1, SZPDS2, SZPDS3, SZPDS4, SZPDS5, SZPDP1, SZPDP2, SZPDP3, SZPDP4, SZPDP5, SZUOM, SZUORG, SZUCHG, SZUOPN, SZUREC, SZCREC, SZURLV, SZOTQY, SZPRRC, SZAEXP, SZACHG, SZAOPN, SZAREC, SZARLV, SZFTN1, SZTRLV, SZPROV, SZAMC3, SZECST, SZCSTO, SZCSMP, SZINMG, SZASN, SZPRGR, SZCLVL, SZCATN, SZDSPR, SZPTC, SZTX, SZEXR1, SZTXA1, SZATXT, SZCNID, SZCDCD, SZNTR, SZFRTH, SZFRTC, SZZON, SZFRAT, SZRATT, SZANBY, SZANCR, SZMOT, SZCOT, SZSHCM, SZSHCN, SZUOM1, SZPQOR, SZUOM2, SZSQOR, SZUOM3, SZITWT, SZWTUM, SZITVL, SZVLUM, SZGLC, SZCTRY, SZFY, SZSTTS, SZRCD, SZFUF1, SZFUF2, SZGRWT, SZGWUM, SZLT, SZANI, SZAID, SZOMCU, SZOBJ, SZSUB, SZSBLT, SZSBL, SZASID, SZCCMP, SZTAG, SZWR01, SZPL, SZELEV, SZR001, SZRTNR, SZLCOD, SZPURG, SZPROM, SZFNLP, SZAVCH, SZPRPY, SZUNCD, SZMATY, SZRTGC, SZRCPF, SZARTG, SZCORD, SZCHDT, SZDOCC, SZCHLN, SZCRCD, SZCRR, SZFRRC, SZFEA, SZFUC, SZFEC, SZFCHG, SZFAP, SZFREC, SZURET, SZUDMG, SZDGCD, SZUREJ, SZRJCD, SZUIQ1, SZU1CD, SZUIQ2, SZU2CD, SZUIQ3, SZU3CD, SZURCD, SZURDT, SZURAT, SZURAB, SZURRF, SZTORG, SZUSER, SZPID, SZJOBN, SZUPMJ, SZTDAY, SZBALU, SZMERL, SZKTLN, SZCPNT, SZBCRC, SZSHPN, SZPS01, SZPS02, SZPS03, SZPS04, SZPS05, SZPS06, SZPS07, SZPS08, SZPS09, SZPS10, SZCRMD, SZCHID, SZCHMJ, SZCHT, SZCTAM, SZFTRL, SZMACT, SZDCD, SZDCP, SZNDTP, SZPXDD, SZPXDM, SZDRQT, SZRSHT, SZPLT, SZPAK, SZSCCN, SZSCCQ, SZSCUM, SZUPCN, SZUPQT, SZUPUM, SZVRMK, SZLOT1, SZLOT2, SZRLOT, SZLOTS, SZMMEJ, SZLDSC, SZDUAL, SZXDCK, SZLOTC, SZVR03, SZLDNM, SZMKFR, SZBTAN, SZCTSN FROM F47072

TOP 812 | 47 | F47072 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	SZLSTS	Line Item Status Code	String	UDC (47 LS)	2	0	Allow NULL?
16	SZKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
17	SZDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
18	SZDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
19	SZSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
20	SZLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
21	SZMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
22	SZCO	Company	String	Generic Edit	5	0	Allow NULL?
23	SZOKCO	Document Company (Original Order)	String	Generic Edit	5	0	Allow NULL?
24	SZOORN	Original Order Number	String	Generic Edit	8	0	Allow NULL?
25	SZOCTO	Original Order Type	String	UDC (00 DT)	2	0	Allow NULL?
26	SZOGNO	Original Line Number	Numeric	Generic Edit	7	3	Allow NULL?
27	SZRKCO	Company - Key (Related Order)	String	Generic Edit	5	0	Allow NULL?
28	SZRORN	Related PO/SO/WO Number	String	Generic Edit	8	0	Allow NULL?
29	SZRCTO	Related PO/SO/WO Order Type	String	UDC (00 DT)	2	0	Allow NULL?
30	SZRLLN	Related PO/SO Line Number	Numeric	Generic Edit	7	3	Allow NULL?
31	SZDMCT	Agreement Number - Distribution	String	Generic Edit	12	0	Allow NULL?
32	SZDMCS	Agreement Supplement - Distribution	Numeric	Generic Edit	3	0	Allow NULL?
33	SZAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
34	SZSHAN	Address Number - Ship To	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	SZCNDJ	Date - Cancel	Date	Generic Edit	6	0
41	SZPEFJ	Date - Price Effective Date	Date	Generic Edit	6	0
42	SZPPDJ	Date - Promised Shipment	Date	Generic Edit	6	0
43	SZPSDJ	Date - Future Date 2	Date	Generic Edit	6	0
44	SZDSVJ	Date - Service/Tax	Date	Generic Edit	6	0
45	SZDGL	Date - For G/L (and Voucher)	Date	Generic Edit	6	0
46	SZPN	Period Number - General Ledger	Numeric	Generic Edit	2	0	Allow NULL?
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	SZDSC1	Description	String	Generic Edit	30	0	Allow NULL?
60	SZDSC2	Description - Line 2	String	Generic Edit	30	0	Allow NULL?
61	SZLNTY	Line Type	String	Generic Edit	2	0	Allow NULL?
62	SZNXTR	Status Code - Next	String	UDC (40 AT)	3	0	Allow NULL?
63	SZLTTR	Status Code - Last	String	UDC (40 AT)	3	0	Allow NULL?
64	SZRLIT	Item Number - Related (Kit)	String	Generic Edit	8	0	Allow NULL?
65	SZPDS1	Reporting Code 1 - Sales	String	Generic Edit	3	0	Allow NULL?
66	SZPDS2	Reporting Code 2 - Sales	String	Generic Edit	3	0	Allow NULL?
67	SZPDS3	Reporting Code 3 - Sales	String	Generic Edit	3	0	Allow NULL?
68	SZPDS4	Reporting Code 4 - Sales	String	Generic Edit	3	0	Allow NULL?
69	SZPDS5	Reporting Code 5 - Sales	String	Generic Edit	3	0	Allow NULL?
70	SZPDP1	Reporting Code 1 - Purchasing	String	UDC (41 P1)	3	0	Allow NULL?
71	SZPDP2	Reporting Code 2 - Purchasing	String	UDC (41 P2)	3	0	Allow NULL?
72	SZPDP3	Reporting Code 3 - Purchasing	String	UDC (41 P3)	3	0	Allow NULL?
73	SZPDP4	Reporting Code 4 - Purchasing	String	UDC (41 P4)	3	0	Allow NULL?
74	SZPDP5	Reporting Code 5 - Purchasing	String	UDC (41 P5)	3	0	Allow NULL?
75	SZUOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
76	SZUORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2	Allow NULL?
77	SZUCHG	Units - On Hold	Numeric	Generic Edit	15	2	Allow NULL?
78	SZUOPN	Units - Open	Numeric	Generic Edit	15	2	Allow NULL?
79	SZUREC	Units - Received	Numeric	Generic Edit	15	2	Allow NULL?
80	SZCREC	Units - Cumulative Received	Numeric	Generic Edit	15	2	Allow NULL?
81	SZURLV	Units - Relieved	Numeric	Generic Edit	15	2	Allow NULL?
82	SZOTQY	Other Quantity (1/2)	Character	UDC	1	0	Allow NULL?
83	SZPRRC	Amount - Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
84	SZAEXP	Amount - Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
85	SZACHG	Amount - On Hold	Numeric	Generic Edit	15	2	Allow NULL?
86	SZAOPN	Amount - Open	Numeric	Generic Edit	15	2	Allow NULL?
87	SZAREC	Amount - Received	Numeric	Generic Edit	15	2	Allow NULL?
88	SZARLV	Amount - Relieved	Numeric	Generic Edit	15	2	Allow NULL?
89	SZFTN1	Amount - Tax Commitment	Numeric	Generic Edit	15	2	Allow NULL?
90	SZTRLV	Amount - Tax Relieved	Numeric	Generic Edit	15	2	Allow NULL?
91	SZPROV	Price Override Code	Character	Generic Edit	1	0	Allow NULL?
92	SZAMC3	Unit Cost - Purchasing	Numeric	Generic Edit	15	4	Allow NULL?
93	SZECST	Amount - Extended Cost	Numeric	Generic Edit	15	2	Allow NULL?
94	SZCSTO	Cost Override Code	Character	Generic Edit	1	0	Allow NULL?
95	SZCSMP	Costing Method - Purchasing	Character	Generic Edit	1	0	Allow NULL?
96	SZINMG	Print Message	String	UDC (40 PM)	10	0	Allow NULL?
97	SZASN	Price and Adjustment Schedule	String	UDC (40 AS)	8	0	Allow NULL?
98	SZPRGR	Item Price Group	String	UDC (40 PI)	8	0	Allow NULL?
99	SZCLVL	Pricing Category Level	String	Generic Edit	3	0	Allow NULL?
100	SZCATN	Catalog	String	UDC (40 CN)	8	0	Allow NULL?
101	SZDSPR	Discount Factor	Numeric	Generic Edit	7	4	Allow NULL?
102	SZPTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
103	SZTX	Purchasing Taxable (Y/N)	Character	UDC (H00 TV)	1	0	Allow NULL?
104	SZEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
105	SZTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
106	SZATXT	Associated Text	Character	Generic Edit	1	0	Allow NULL?
107	SZCNID	Container I.D.	String	Generic Edit	20	0	Allow NULL?
108	SZCDCD	Commodity Code	String	Generic Edit	15	0	Allow NULL?
109	SZNTR	Nature of Transaction	String	UDC (00 NT)	2	0	Allow NULL?
110	SZFRTH	Freight Handling Code	String	UDC (42 FR)	3	0	Allow NULL?
111	SZFRTC	Freight Calculated (Y/N)	Character	Generic Edit	1	0	Allow NULL?
112	SZZON	Zone Number	String	UDC (40 ZN)	3	0	Allow NULL?
113	SZFRAT	Rate Code - Frieght/Misc	String	UDC (41 RT)	10	0	Allow NULL?
114	SZRATT	Rate Type - Freight/Misc	Character	Generic Edit	1	0	Allow NULL?
115	SZANBY	Buyer Number	Numeric	Generic Edit	8	0	Allow NULL?
116	SZANCR	Carrier Number	Numeric	Generic Edit	8	0	Allow NULL?
117	SZMOT	Mode of Transport	String	UDC (00 TM)	3	0	Allow NULL?
118	SZCOT	Conditions of Transport	String	UDC (00 TC)	3	0	Allow NULL?
119	SZSHCM	Shipping Commodity Class	String	UDC (41 E)	3	0	Allow NULL?
120	SZSHCN	Shipping Conditions Code	String	UDC (41 C)	3	0	Allow NULL?
121	SZUOM1	Unit of Measure - Primary	String	UDC (00 UM)	2	0	Allow NULL?
122	SZPQOR	Units - Primary Quantity Ordered	Numeric	Generic Edit	15	2	Allow NULL?
123	SZUOM2	Unit of Measure - Secondary	String	UDC (00 UM)	2	0	Allow NULL?
124	SZSQOR	Units - Secondary Quantity Ordered	Numeric	Generic Edit	15	2	Allow NULL?
125	SZUOM3	Unit of Measure - Purchasing	String	UDC (00 UM)	2	0	Allow NULL?
126	SZITWT	Unit Weight	Numeric	Generic Edit	15	4	Allow NULL?
127	SZWTUM	Weight Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
128	SZITVL	Unit Volume	Numeric	Generic Edit	15	4	Allow NULL?
129	SZVLUM	Volume Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
130	SZGLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
131	SZCTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
132	SZFY	Fiscal Year	Numeric	Generic Edit	2	0	Allow NULL?
133	SZSTTS	Line Status	String	Generic Edit	2	0	Allow NULL?
134	SZRCD	Reason Code	String	UDC (42 RC)	3	0	Allow NULL?
135	SZFUF1	AIA Document Flag	Character	UDC (H40 FU)	1	0	Allow NULL?
136	SZFUF2	Post Quantities	Character	Generic Edit	1	0	Allow NULL?
137	SZGRWT	Gross Weight	Numeric	Generic Edit	15	4	Allow NULL?
138	SZGWUM	Gross Weight Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
139	SZLT	Ledger Types	String	UDC (09 LT)	2	0	Allow NULL?
140	SZANI	Account Number - Input (Mode Unknown)	String	Generic Edit	29	0	Allow NULL?
141	SZAID	Account ID	String	Generic Edit	8	0	Allow NULL?
142	SZOMCU	Project Business Unit	String	Generic Edit	12	0	Allow NULL?
143	SZOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
144	SZSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
145	SZSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
146	SZSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
147	SZASID	Serial Number	String	Generic Edit	25	0	Allow NULL?
148	SZCCMP	Cost Component Number	Numeric	Generic Edit	3	0	Allow NULL?
149	SZTAG	Tag - Reference	String	Generic Edit	8	0	Allow NULL?
150	SZWR01	Categories - Work Order 01	String	UDC (00 W1)	4	0	Allow NULL?
151	SZPL	Plan Number	String	Generic Edit	4	0	Allow NULL?
152	SZELEV	Elevation	String	Generic Edit	3	0	Allow NULL?
153	SZR001	Category Code - G/L1	String	UDC (09 01)	3	0	Allow NULL?
154	SZRTNR	Retainage Rule	String	Generic Edit	3	0	Allow NULL?
155	SZLCOD	Code - Location Tax Status	String	UDC (46 LT)	2	0	Allow NULL?
156	SZPURG	Purge Code	Character	Generic Edit	1	0	Allow NULL?
157	SZPROM	Processing Mode	Character	UDC (H40 PQ)	1	0	Allow NULL?
158	SZFNLP	Closed Item - As Of Processing	Character	Generic Edit	1	0	Allow NULL?
159	SZAVCH	Code - Evaluated Receipt Settlement	Character	UDC (40 ER)	1	0	Allow NULL?
160	SZPRPY	Pre-Payment (Y/N)	Character	Generic Edit	1	0	Allow NULL?
161	SZUNCD	Work Order Freeze Code	Character	UDC (H00 UN)	1	0	Allow NULL?
162	SZMATY	Type - Match Type	Character	UDC (H40 MB)	1	0	Allow NULL?
163	SZRTGC	Routing Process (Y/N)	Character	Generic Edit	1	0	Allow NULL?
164	SZRCPF	Leadtime Recalculated (Y/N)	Character	Generic Edit	1	0	Allow NULL?
165	SZARTG	Code - Approval Routing	String	Generic Edit	12	0	Allow NULL?
166	SZCORD	Change Order Number	Numeric	Generic Edit	3	0	Allow NULL?
167	SZCHDT	Change Order Type	String	UDC (00 DT)	2	0	Allow NULL?
168	SZDOCC	Document (Change Order #)	Numeric	Generic Edit	8	0	Allow NULL?
169	SZCHLN	Change Order Line Number	Numeric	Generic Edit	7	3	Allow NULL?
170	SZCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
171	SZCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
172	SZFRRC	Amount - Foreign Unit Price	Numeric	Generic Edit	15	4	Allow NULL?
173	SZFEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
174	SZFUC	Amount - Foreign Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
175	SZFEC	Amount - Foreign Extended Cost	Numeric	Generic Edit	15	2	Allow NULL?
176	SZFCHG	Amount - Foreign Changed Amount	Numeric	Generic Edit	15	2	Allow NULL?
177	SZFAP	Amount - Foreign Open	Numeric	Generic Edit	15	2	Allow NULL?
178	SZFREC	Amount - Received Foreign	Numeric	Generic Edit	15	2	Allow NULL?
179	SZURET	Units - Returned	Numeric	Generic Edit	15	2	Allow NULL?
180	SZUDMG	Units - Damaged	Numeric	Generic Edit	15	2	Allow NULL?
181	SZDGCD	Damaged Goods Code	String	Generic Edit	2	0	Allow NULL?
182	SZUREJ	Units - Rejected	Numeric	Generic Edit	15	2	Allow NULL?
183	SZRJCD	Rejection Code	String	Generic Edit	2	0	Allow NULL?
184	SZUIQ1	Units - In Question 1	Numeric	Generic Edit	15	2	Allow NULL?
185	SZU1CD	Units in Question 1 Code	String	Generic Edit	2	0	Allow NULL?
186	SZUIQ2	Units - In Question 2	Numeric	Generic Edit	15	2	Allow NULL?
187	SZU2CD	Units in Question 2 Code	String	Generic Edit	2	0	Allow NULL?
188	SZUIQ3	Units - In Question 3	Numeric	Generic Edit	15	2	Allow NULL?
189	SZU3CD	Units in Question 3 Code	String	Generic Edit	2	0	Allow NULL?
190	SZURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
191	SZURDT	User Reserved Date	Date	Generic Edit	6	0
192	SZURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
193	SZURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
194	SZURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
195	SZTORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
196	SZUSER	User ID	String	Generic Edit	10	0	Allow NULL?
197	SZPID	Program ID	String	Generic Edit	10	0	Allow NULL?
198	SZJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
199	SZUPMJ	Date - Updated	Date	Generic Edit	6	0
200	SZTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
201	SZBALU	Contract Balances Updated Y/N	Character	Generic Edit	1	0	Allow NULL?
202	SZMERL	Item Revision Level	String	Generic Edit	3	0	Allow NULL?
203	SZKTLN	Kit Master Line Number	Numeric	Generic Edit	6	3	Allow NULL?
204	SZCPNT	Component Line Number	Numeric	Generic Edit	4	1	Allow NULL?
205	SZBCRC	Currency Code - Base	String	Generic Edit	3	0	Allow NULL?
206	SZSHPN	Shipment Number	Numeric	Generic Edit	8	0	Allow NULL?
207	SZPS01	Transfer/Direct Ship Flag	Character	Generic Edit	1	0	Allow NULL?
208	SZPS02	Purchase Order Status 02	Character	Generic Edit	1	0	Allow NULL?
209	SZPS03	Purchase Order Status 03	Character	Generic Edit	1	0	Allow NULL?
210	SZPS04	Purchase Order Status 04	Character	Generic Edit	1	0	Allow NULL?
211	SZPS05	Purchase Order Status 05	Character	Generic Edit	1	0	Allow NULL?
212	SZPS06	Purchase Order Status 06	Character	Generic Edit	1	0	Allow NULL?
213	SZPS07	Purchase Order Status 07	Character	Generic Edit	1	0	Allow NULL?
214	SZPS08	Purchase Order Status 08	Character	Generic Edit	1	0	Allow NULL?
215	SZPS09	Purchase Order Status 09	Character	Generic Edit	1	0	Allow NULL?
216	SZPS10	Purchase Order Status 10	Character	UDC (00 XS)	1	0	Allow NULL?
217	SZCRMD	Send Method	Character	UDC (00 SM)	1	0	Allow NULL?
218	SZCHID	Change Order Program ID	String	Generic Edit	10	0	Allow NULL?
219	SZCHMJ	Change Order Date - Updated	Date	Generic Edit	6	0
220	SZCHT	Change Order Time of Day	Numeric	Generic Edit	7	0	Allow NULL?
221	SZCTAM	Amount - Foreign Tax	Numeric	Generic Edit	15	2	Allow NULL?
222	SZFTRL	Amount - Foreign Tax Relieved	Numeric	Generic Edit	15	2	Allow NULL?
223	SZMACT	Multiple Accounts	Character	UDC (40 MU)	1	0	Allow NULL?
224	SZDCD	Discount Days	Numeric	Generic Edit	3	0	Allow NULL?
225	SZDCP	Discount % - Payment Terms	Numeric	Generic Edit	5	0	Allow NULL?
226	SZNDTP	Net Days to Pay	Numeric	Generic Edit	3	0	Allow NULL?
227	SZPXDD	Date - Due Date - DA	Numeric	Generic Edit	2	0	Allow NULL?
228	SZPXDM	Date - Due Date - MO	Numeric	Generic Edit	2	0	Allow NULL?
229	SZDRQT	Requested Delivery Time	Numeric	Generic Edit	6	0	Allow NULL?
230	SZRSHT	Requested Ship Time	Numeric	Generic Edit	6	0	Allow NULL?
231	SZPLT	SSCC Number - Tare Level	String	Generic Edit	18	0	Allow NULL?
232	SZPAK	SSCC Number - Pack Level	String	Generic Edit	18	0	Allow NULL?
233	SZSCCN	SCC Number	String	Generic Edit	14	0	Allow NULL?
234	SZSCCQ	SCC Quantity	Numeric	Generic Edit	15	2	Allow NULL?
235	SZSCUM	SCC Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
236	SZUPCN	UPC Number	String	Generic Edit	13	0	Allow NULL?
237	SZUPQT	UPC Quantity	Numeric	Generic Edit	15	2	Allow NULL?
238	SZUPUM	UPC Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
239	SZVRMK	Supplier Remark	String	Generic Edit	30	0	Allow NULL?
240	SZLOT1	Memo Lot 1	String	Generic Edit	30	0	Allow NULL?
241	SZLOT2	Memo Lot 2	String	Generic Edit	30	0	Allow NULL?
242	SZRLOT	Supplier Lot Number	String	Generic Edit	30	0	Allow NULL?
243	SZLOTS	Lot Status Code	Character	UDC (41 L)	1	0	Allow NULL?
244	SZMMEJ	Date - Lot Expiration	Date	Generic Edit	6	0
245	SZLDSC	Description - Lot	String	Generic Edit	30	0	Allow NULL?
246	SZDUAL	Dual Unit Of Measure Item	Character	Generic Edit	1	0	Allow NULL?
247	SZXDCK	Cross-Docking Flag	Character	Generic Edit	1	0	Allow NULL?
248	SZLOTC	Lot Status Code Expanded	String	Generic Edit	3	0	Allow NULL?
249	SZVR03	Reference	String	Generic Edit	25	0	Allow NULL?
250	SZLDNM	Load Number	Numeric	Generic Edit	8	0	Allow NULL?
251	SZMKFR	Address Number - Mark-for	Numeric	Generic Edit	8	0	Allow NULL?
252	SZBTAN	Address Number - Bill To	Numeric	Generic Edit	8	0	Allow NULL?
253	SZCTSN	Container Serial Number	String	Generic Edit	40	0	Allow NULL?

TOP 812 | 47 | F47072 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

253 COLUMNS | 1 INDEXES | 812 | 47 | F47072 TABLE

TOP 812 | 47 | F47072 COLUMNS

TOP 812 | 47 | F47072 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

253 COLUMNS | 1 INDEXES | 812 | 47 | F47072 TABLE

TOP812 | 47 | F47072 COLUMNS

TOP812 | 47 | F47072 INDEXES

TOP 812 | 47 | F47072 COLUMNS

TOP 812 | 47 | F47072 INDEXES