	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

199 COLUMNS | 1 INDEXES | 812 | 43 | F43121Z1 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
43: Procurement
1	812	F43121Z1	SZ	199	1	Receipts Unedited Transaction Table	Transaction Files	43: Procurement	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 SZEDUS, SZEDBT, SZEDTN, SZEDLN, SZEDCT, SZTYTN, SZEDFT, SZEDDT, SZDRIN, SZEDDL, SZEDSP, SZPNID, SZTNAC, SZTPUR, SZLSTS, SZRATY, SZRECOPT, SZMATC, SZAN8, SZKCOO, SZDOCO, SZDCTO, SZSFXO, SZLNID, SZNLIN, SZALIN, SZRTBY, SZDMCT, SZDMCS, SZBALU, SZITM, SZLITM, SZAITM, SZIMCU, SZLOCN, SZLOTN, SZLOTG, SZLOTP, SZVRMK, SZCNID, SZNXTR, SZLTTR, SZTRDJ, SZRCDJ, SZDRQJ, SZPDDJ, SZOPDJ, SZRCD, SZVINV, SZPTC, SZPST, SZLAND, SZPRP5, SZLVLA, SZILOG, SZDLOG, SZRTGC, SZRCPF, SZAVCH, SZLNTY, SZGLC, SZMCU, SZCO, SZAID, SZANI, SZOMCU, SZOBJ, SZSUB, SZASID, SZSBL, SZSBLT, SZKCO, SZDOC, SZDCT, SZSFX, SZDGL, SZJELN, SZVANI, SZTX, SZEXR1, SZTXA1, SZUOM, SZUORG, SZUPTD, SZUOPN, SZUREC, SZUCLO, SZQTYS, SZQTYR, SZQTYW, SZQTYC, SZQTYJ, SZQTYA, SZUOM3, SZPRRC, SZECST, SZAPTD, SZAOPN, SZAREC, SZACLO, SZAVCO, SZVARC, SZCRCD, SZCRR, SZFRRC, SZFEC, SZFAP, SZFAPT, SZFREC, SZFCLO, SZADDJ, SZSHAN, SZCITM, SZDSC1, SZDSC2, SZVR01, SZVR02, SZLDSC, SZMMEJ, SZLOTS, SZRLOT, SZLOT1, SZLOT2, SZAMBR, SZBUM3, SZSTOK, SZBUM4, SZWGTR, SZBUM5, SZTEMP, SZSTPU, SZDEND, SZDNTP, SZDETP, SZDTPU, SZRCTM, SZABR1, SZABT1, SZABR2, SZABT2, SZABR3, SZABT3, SZABR4, SZABT4, SZMOT, SZANCR, SZURET, SZUDMG, SZDGCD, SZUREJ, SZRJCD, SZUIQ1, SZU1CD, SZUIQ2, SZU2CD, SZUIQ3, SZU3CD, SZURCD, SZURDT, SZURAT, SZURAB, SZURRF, SZTORG, SZUSER, SZPID, SZJOBN, SZUPMJ, SZTDAY, SZVR05, SZVR04, SZUPUM, SZUPQT, SZUPCN, SZUOM2, SZUKID, SZSTAM, SZSQOR, SZSHPN, SZSCUM, SZSCCQ, SZSCCN, SZPLT, SZPAK, SZMERL, SZMACT, SZLDNM, SZKTLN, SZFUF6, SZFUF5, SZFUF4, SZFUF3, SZDUAL, SZCTAM, SZXDCK, SZCPNT, SZBCRC, SZLOTC, SZPOE, SZVR03 FROM F43121Z1

TOP 812 | 43 | F43121Z1 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	SZEDUS	EDI - User ID	String	Generic Edit	10	0	Allow NULL?
2	SZEDBT	EDI - Batch Number	String	Generic Edit	15	0	Allow NULL?
3	SZEDTN	EDI - Transaction Number	String	Generic Edit	22	0	Allow NULL?
4	SZEDLN	EDI - Line Number	Numeric	Generic Edit	7	3	Allow NULL?
5	SZEDCT	EDI - Document Type	String	Generic Edit	2	0	Allow NULL?
6	SZTYTN	Type - Transaction	String	UDC (00 TT)	8	0	Allow NULL?
7	SZEDFT	EDI - Translation Format	String	Generic Edit	10	0	Allow NULL?
8	SZEDDT	EDI - Transmission Date	Date	Generic Edit	6	0
9	SZDRIN	Direction Indicator	Character	UDC (00 DN)	1	0	Allow NULL?
10	SZEDDL	EDI - Detail Lines Processed	Numeric	Generic Edit	5	0	Allow NULL?
11	SZEDSP	EDI - Successfully Processed	Character	Generic Edit	1	0	Allow NULL?
12	SZPNID	Trading Partner ID	String	Generic Edit	15	0	Allow NULL?
13	SZTNAC	Transaction Action	String	UDC (00 TA)	2	0	Allow NULL?
14	SZTPUR	Transaction Set Purpose	String	UDC (47 PU)	2	0	Allow NULL?
15	SZLSTS	Line Item Status Code	String	UDC (47 LS)	2	0	Allow NULL?
16	SZRATY	Receiving Advice Type	Character	Generic Edit	1	0	Allow NULL?
17	SZRECOPT	Receipts Options	Character	UDC (43 PR)	1	0	Allow NULL?
18	SZMATC	Type - Match Record Type	Character	Generic Edit	1	0	Allow NULL?
19	SZAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
20	SZKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
21	SZDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
22	SZDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
23	SZSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
24	SZLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
25	SZNLIN	Number of Lines	Numeric	Generic Edit	5	0	Allow NULL?
26	SZALIN	Line - Associated	Numeric	Generic Edit	5	0	Allow NULL?
27	SZRTBY	Written By Program	String	Generic Edit	2	0	Allow NULL?
28	SZDMCT	Agreement Number - Distribution	String	Generic Edit	12	0	Allow NULL?
29	SZDMCS	Agreement Supplement - Distribution	Numeric	Generic Edit	3	0	Allow NULL?
30	SZBALU	Contract Balances Updated Y/N	Character	Generic Edit	1	0	Allow NULL?
31	SZITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
32	SZLITM	2nd Item Number	String	Generic Edit	25	0	Allow NULL?
33	SZAITM	3rd Item Number	String	Generic Edit	25	0	Allow NULL?
34	SZIMCU	Item Business Unit	String	Generic Edit	12	0	Allow NULL?
35	SZLOCN	Location	String	Generic Edit	20	0	Allow NULL?
36	SZLOTN	Lot/Serial Number	String	Generic Edit	30	0	Allow NULL?
37	SZLOTG	Lot Grade	String	UDC (40 LG)	3	0	Allow NULL?
38	SZLOTP	Lot Potency	Numeric	Generic Edit	15	3	Allow NULL?
39	SZVRMK	Supplier Remark	String	Generic Edit	30	0	Allow NULL?
40	SZCNID	Container I.D.	String	Generic Edit	20	0	Allow NULL?
41	SZNXTR	Status Code - Next	String	UDC (40 AT)	3	0	Allow NULL?
42	SZLTTR	Status Code - Last	String	UDC (40 AT)	3	0	Allow NULL?
43	SZTRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
44	SZRCDJ	Date - Received	Date	Generic Edit	6	0
45	SZDRQJ	Date - Requested	Date	Generic Edit	6	0
46	SZPDDJ	Date - Scheduled Pick	Date	Generic Edit	6	0
47	SZOPDJ	Date - Original Promised Delivery	Date	Generic Edit	6	0
48	SZRCD	Reason Code	String	UDC (42 RC)	3	0	Allow NULL?
49	SZVINV	Supplier Invoice Number	String	Generic Edit	25	0	Allow NULL?
50	SZPTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
51	SZPST	Pay Status Code	Character	UDC (00 PS)	1	0	Allow NULL?
52	SZLAND	Code - Landed Cost	Character	Generic Edit	1	0	Allow NULL?
53	SZPRP5	Purchasing Category Code 5	String	UDC (41 P5)	3	0	Allow NULL?
54	SZLVLA	Level Cost	String	UDC (40 CA)	3	0	Allow NULL?
55	SZILOG	Code - Invoice Logging	Character	Generic Edit	1	0	Allow NULL?
56	SZDLOG	Final Receipt Flag (Y or BLANK)	Character	Generic Edit	1	0	Allow NULL?
57	SZRTGC	Routing Process (Y/N)	Character	Generic Edit	1	0	Allow NULL?
58	SZRCPF	Leadtime Recalculated (Y/N)	Character	Generic Edit	1	0	Allow NULL?
59	SZAVCH	Code - Evaluated Receipt Settlement	Character	UDC (40 ER)	1	0	Allow NULL?
60	SZLNTY	Line Type	String	Generic Edit	2	0	Allow NULL?
61	SZGLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
62	SZMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
63	SZCO	Company	String	Generic Edit	5	0	Allow NULL?
64	SZAID	Account ID	String	Generic Edit	8	0	Allow NULL?
65	SZANI	Account Number - Input (Mode Unknown)	String	Generic Edit	29	0	Allow NULL?
66	SZOMCU	Project Business Unit	String	Generic Edit	12	0	Allow NULL?
67	SZOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
68	SZSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
69	SZASID	Serial Number	String	Generic Edit	25	0	Allow NULL?
70	SZSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
71	SZSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
72	SZKCO	Document Company	String	Generic Edit	5	0	Allow NULL?
73	SZDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
74	SZDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
75	SZSFX	Document Pay Item	String	Generic Edit	3	0	Allow NULL?
76	SZDGL	Date - For G/L (and Voucher)	Date	Generic Edit	6	0
77	SZJELN	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
78	SZVANI	Account Number - Received Not Vouchered	String	Generic Edit	29	0	Allow NULL?
79	SZTX	Purchasing Taxable (Y/N)	Character	UDC (H00 TV)	1	0	Allow NULL?
80	SZEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
81	SZTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
82	SZUOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
83	SZUORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2	Allow NULL?
84	SZUPTD	Units - Paid to Date	Numeric	Generic Edit	15	2	Allow NULL?
85	SZUOPN	Units - Open	Numeric	Generic Edit	15	2	Allow NULL?
86	SZUREC	Units - Received	Numeric	Generic Edit	15	2	Allow NULL?
87	SZUCLO	Units - Closed	Numeric	Generic Edit	15	2	Allow NULL?
88	SZQTYS	Units - Stocked	Numeric	Generic Edit	15	2	Allow NULL?
89	SZQTYR	Units - Returned	Numeric	Generic Edit	15	2	Allow NULL?
90	SZQTYW	Units - Reworked	Numeric	Generic Edit	15	2	Allow NULL?
91	SZQTYC	Units - Scrapped	Numeric	Generic Edit	15	2	Allow NULL?
92	SZQTYJ	Units - Rejected	Numeric	Generic Edit	15	2	Allow NULL?
93	SZQTYA	Units - Adjusted	Numeric	Generic Edit	15	2	Allow NULL?
94	SZUOM3	Unit of Measure - Purchasing	String	UDC (00 UM)	2	0	Allow NULL?
95	SZPRRC	Amount - Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
96	SZECST	Amount - Extended Cost	Numeric	Generic Edit	15	2	Allow NULL?
97	SZAPTD	Amount - Paid to Date	Numeric	Generic Edit	15	2	Allow NULL?
98	SZAOPN	Amount - Open	Numeric	Generic Edit	15	2	Allow NULL?
99	SZAREC	Amount - Received	Numeric	Generic Edit	15	2	Allow NULL?
100	SZACLO	Amount - Closed	Numeric	Generic Edit	15	2	Allow NULL?
101	SZAVCO	Amount - Average Cost Difference	Numeric	Generic Edit	15	2	Allow NULL?
102	SZVARC	Amount - Cost Variance	Numeric	Generic Edit	15	2	Allow NULL?
103	SZCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
104	SZCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
105	SZFRRC	Amount - Foreign Unit Price	Numeric	Generic Edit	15	4	Allow NULL?
106	SZFEC	Amount - Foreign Extended Cost	Numeric	Generic Edit	15	2	Allow NULL?
107	SZFAP	Amount - Foreign Open	Numeric	Generic Edit	15	2	Allow NULL?
108	SZFAPT	Amount - Foreign Amount Paid to Date	Numeric	Generic Edit	15	2	Allow NULL?
109	SZFREC	Amount - Received Foreign	Numeric	Generic Edit	15	2	Allow NULL?
110	SZFCLO	Amount - Foreign Closed	Numeric	Generic Edit	15	2	Allow NULL?
111	SZADDJ	Date - Actual Ship Date	Date	Generic Edit	6	0
112	SZSHAN	Address Number - Ship To	Numeric	Generic Edit	8	0	Allow NULL?
113	SZCITM	Item Number - Customer/Supplier	String	Generic Edit	25	0	Allow NULL?
114	SZDSC1	Description	String	Generic Edit	30	0	Allow NULL?
115	SZDSC2	Description - Line 2	String	Generic Edit	30	0	Allow NULL?
116	SZVR01	Reference	String	Generic Edit	25	0	Allow NULL?
117	SZVR02	Reference 2	String	Generic Edit	25	0	Allow NULL?
118	SZLDSC	Description - Lot	String	Generic Edit	30	0	Allow NULL?
119	SZMMEJ	Date - Lot Expiration	Date	Generic Edit	6	0
120	SZLOTS	Lot Status Code	Character	UDC (41 L)	1	0	Allow NULL?
121	SZRLOT	Supplier Lot Number	String	Generic Edit	30	0	Allow NULL?
122	SZLOT1	Memo Lot 1	String	Generic Edit	30	0	Allow NULL?
123	SZLOT2	Memo Lot 2	String	Generic Edit	30	0	Allow NULL?
124	SZAMBR	Volume - Ambient	Numeric	Generic Edit	15	2	Allow NULL?
125	SZBUM3	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
126	SZSTOK	Volume - Standard	Numeric	Generic Edit	15	2	Allow NULL?
127	SZBUM4	Unit of Measure 4	String	UDC (00 UM)	2	0	Allow NULL?
128	SZWGTR	Weight Result	Numeric	Generic Edit	15	2	Allow NULL?
129	SZBUM5	Unit of Measure 5	String	UDC (00 UM)	2	0	Allow NULL?
130	SZTEMP	Temperature	Numeric	Generic Edit	7	2	Allow NULL?
131	SZSTPU	Temperature Type	Character	UDC (41B TP)	1	0	Allow NULL?
132	SZDEND	Display Density	Numeric	Generic Edit	10	4	Allow NULL?
133	SZDNTP	Density Type - At Standard Temperature	Character	UDC (41B DT)	1	0	Allow NULL?
134	SZDETP	Density Temperature	Numeric	Generic Edit	7	2	Allow NULL?
135	SZDTPU	Temperature Type	Character	UDC (41B TP)	1	0	Allow NULL?
136	SZRCTM	Time - Receipt	Numeric	Generic Edit	6	0	Allow NULL?
137	SZABR1	Managerial Analysis Code 1	String	Generic Edit	12	0	Allow NULL?
138	SZABT1	Managerial Analysis Type 1	Character	UDC	1	0	Allow NULL?
139	SZABR2	Managerial Analysis Code 2	String	Generic Edit	12	0	Allow NULL?
140	SZABT2	Managerial Analysis Type 2	Character	UDC	1	0	Allow NULL?
141	SZABR3	Managerial Analysis Code 3	String	Generic Edit	12	0	Allow NULL?
142	SZABT3	Managerial Analysis Type 3	Character	UDC	1	0	Allow NULL?
143	SZABR4	Managerial Analysis Code 4	String	Generic Edit	12	0	Allow NULL?
144	SZABT4	Managerial Analysis Type 4	Character	UDC	1	0	Allow NULL?
145	SZMOT	Mode of Transport	String	UDC (00 TM)	3	0	Allow NULL?
146	SZANCR	Carrier Number	Numeric	Generic Edit	8	0	Allow NULL?
147	SZURET	Units - Returned	Numeric	Generic Edit	15	2	Allow NULL?
148	SZUDMG	Units - Damaged	Numeric	Generic Edit	15	2	Allow NULL?
149	SZDGCD	Damaged Goods Code	String	Generic Edit	2	0	Allow NULL?
150	SZUREJ	Units - Rejected	Numeric	Generic Edit	15	2	Allow NULL?
151	SZRJCD	Rejection Code	String	Generic Edit	2	0	Allow NULL?
152	SZUIQ1	Units - In Question 1	Numeric	Generic Edit	15	2	Allow NULL?
153	SZU1CD	Units in Question 1 Code	String	Generic Edit	2	0	Allow NULL?
154	SZUIQ2	Units - In Question 2	Numeric	Generic Edit	15	2	Allow NULL?
155	SZU2CD	Units in Question 2 Code	String	Generic Edit	2	0	Allow NULL?
156	SZUIQ3	Units - In Question 3	Numeric	Generic Edit	15	2	Allow NULL?
157	SZU3CD	Units in Question 3 Code	String	Generic Edit	2	0	Allow NULL?
158	SZURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
159	SZURDT	User Reserved Date	Date	Generic Edit	6	0
160	SZURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
161	SZURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
162	SZURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
163	SZTORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
164	SZUSER	User ID	String	Generic Edit	10	0	Allow NULL?
165	SZPID	Program ID	String	Generic Edit	10	0	Allow NULL?
166	SZJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
167	SZUPMJ	Date - Updated	Date	Generic Edit	6	0
168	SZTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
169	SZVR05	Outside Reference 2	String	Generic Edit	25	0	Allow NULL?
170	SZVR04	Outside Reference 1	String	Generic Edit	25	0	Allow NULL?
171	SZUPUM	UPC Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
172	SZUPQT	UPC Quantity	Numeric	Generic Edit	15	2	Allow NULL?
173	SZUPCN	UPC Number	String	Generic Edit	13	0	Allow NULL?
174	SZUOM2	Unit of Measure - Secondary	String	UDC (00 UM)	2	0	Allow NULL?
175	SZUKID	Unique Key ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
176	SZSTAM	Amount - Tax	Numeric	Generic Edit	15	2	Allow NULL?
177	SZSQOR	Units - Secondary Quantity Ordered	Numeric	Generic Edit	15	2	Allow NULL?
178	SZSHPN	Shipment Number	Numeric	Generic Edit	8	0	Allow NULL?
179	SZSCUM	SCC Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
180	SZSCCQ	SCC Quantity	Numeric	Generic Edit	15	2	Allow NULL?
181	SZSCCN	SCC Number	String	Generic Edit	14	0	Allow NULL?
182	SZPLT	SSCC Number - Tare Level	String	Generic Edit	18	0	Allow NULL?
183	SZPAK	SSCC Number - Pack Level	String	Generic Edit	18	0	Allow NULL?
184	SZMERL	Item Revision Level	String	Generic Edit	3	0	Allow NULL?
185	SZMACT	Multiple Accounts	Character	UDC (40 MU)	1	0	Allow NULL?
186	SZLDNM	Load Number	Numeric	Generic Edit	8	0	Allow NULL?
187	SZKTLN	Kit Master Line Number	Numeric	Generic Edit	6	3	Allow NULL?
188	SZFUF6	Future Use	String	Generic Edit	1	0	Allow NULL?
189	SZFUF5	Future Use	String	Generic Edit	1	0	Allow NULL?
190	SZFUF4	Future Use	String	Generic Edit	1	0	Allow NULL?
191	SZFUF3	Future Use	String	Generic Edit	1	0	Allow NULL?
192	SZDUAL	Dual Unit Of Measure Item	Character	Generic Edit	1	0	Allow NULL?
193	SZCTAM	Amount - Foreign Tax	Numeric	Generic Edit	15	2	Allow NULL?
194	SZXDCK	Cross-Docking Flag	Character	Generic Edit	1	0	Allow NULL?
195	SZCPNT	Component Line Number	Numeric	Generic Edit	4	1	Allow NULL?
196	SZBCRC	Currency Code - Base	String	Generic Edit	3	0	Allow NULL?
197	SZLOTC	Lot Status Code Expanded	String	Generic Edit	3	0	Allow NULL?
198	SZPOE	Port of Entry or Exit	String	UDC (40 PE)	6	0	Allow NULL?
199	SZVR03	Reference	String	Generic Edit	25	0	Allow NULL?

TOP 812 | 43 | F43121Z1 INDEXES

Number

Description

UserId BatchNo TransNo + (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

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

199 COLUMNS | 1 INDEXES | 812 | 43 | F43121Z1 TABLE

TOP 812 | 43 | F43121Z1 COLUMNS

TOP 812 | 43 | F43121Z1 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

199 COLUMNS | 1 INDEXES | 812 | 43 | F43121Z1 TABLE

TOP812 | 43 | F43121Z1 COLUMNS

TOP812 | 43 | F43121Z1 INDEXES

TOP 812 | 43 | F43121Z1 COLUMNS

TOP 812 | 43 | F43121Z1 INDEXES