	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

196 COLUMNS | 2 INDEXES | 812 | 04 | F0411Z3 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
04: Accounts Payable
1	812	F0411Z3	SZ	196	2	F0411 Interoperability Table	Batch Input Files	04: Accounts Payable	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, SZEDTY, SZEDSQ, SZEDTS, SZEDER, SZEDTC, SZEDTR, SZEDGL, SZEDDH, SZEDAN, SZKCO, SZDOC, SZDCT, SZSFX, SZSFXE, SZDCTA, SZAN8, SZPYE, SZSNTO, SZDIVJ, SZDSVJ, SZDDJ, SZDDNJ, SZDGJ, SZFY, SZCTRY, SZPN, SZCO, SZICU, SZICUT, SZDICJ, SZBALJ, SZPST, SZAG, SZAAP, SZADSC, SZADSA, SZATXA, SZATXN, SZSTAM, SZTXA1, SZEXR1, SZCRRM, SZCRCD, SZCRDC, SZCRR, SZACR, SZFAP, SZCDS, SZCDSA, SZCTXA, SZCTXN, SZCTAM, SZGLC, SZGLBA, SZPOST, SZAM, SZAID2, SZMCU, SZOBJ, SZSUB, SZSBLT, SZSBL, SZBAID, SZPTC, SZVOD, SZOKCO, SZODCT, SZODOC, SZOSFX, SZCRC, SZVINV, SZPKCO, SZPO, SZPDCT, SZLNID, SZSFXO, SZOPSQ, SZVR01, SZUNIT, SZMCU2, SZRMK, SZRF, SZDRF, SZCTL, SZFNLP, SZU, SZUM, SZPYIN, SZTXA3, SZEXR3, SZRP1, SZRP2, SZRP3, SZAC07, SZTNN, SZDMCD, SZITM, SZHCRR, SZHDGJ, SZDIM, SZDID, SZDIY, SZDI#, SZDSVM, SZDSVD, SZDSVY, SZDSY#, SZDDM, SZDDD, SZDDY, SZDD#, SZDDNM, SZDDND, SZDDNY, SZDDN#, SZDGM, SZDGD, SZDGY, SZDG#, SZDICM, SZDICD, SZDICY, SZDIC#, SZHDGM, SZHDGD, SZHDGY, SZHDG#, SZDOCM, SZURC1, SZUPMT, SZURCD, SZURDT, SZURAT, SZURAB, SZURRF, SZTORG, SZUSER, SZPID, SZJOBN, SZUPMJ, SZTDAY, SZTNST, SZYC01, SZYC02, SZYC03, SZYC04, SZYC05, SZYC06, SZYC07, SZYC08, SZYC09, SZYC10, SZDTXS, SZBCRC, SZATAD, SZCTAD, SZNRTA, SZFNRT, SZTAXP, SZPRGF, SZGFL5, SZGFL6, SZGAM1, SZGAM2, SZGEN4, SZGEN5, SZWTAD, SZWTAF, SZSMMF, SZPYWP, SZPWPG, SZNETTCID, SZNETDOC, SZNETRC5, SZNETST, SZCNTRTID, SZCNTRTCD, SZWVID, SZBLSCD2, SZHARPER, SZHARSFX, SZDDRL, SZSEQN FROM F0411Z3

TOP 812 | 04 | F0411Z3 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	SZEDTY	Type Record	Character	UDC (00 RD)	1	0	Allow NULL?
15	SZEDSQ	Record Sequence	Numeric	Generic Edit	2	0	Allow NULL?
16	SZEDTS	EDI - Transaction Set Number	String	Generic Edit	6	0	Allow NULL?
17	SZEDER	EDI - Send/Receive Indicator	Character	UDC (H00 ED)	1	0	Allow NULL?
18	SZEDTC	EDI - Transaction Action	Character	Generic Edit	1	0	Allow NULL?
19	SZEDTR	EDI - Transaction Type	Character	Generic Edit	1	0	Allow NULL?
20	SZEDGL	Batch File Create G/L Record	Character	Generic Edit	1	0	Allow NULL?
21	SZEDDH	Batch File Discount Handling Flag	Character	Generic Edit	1	0	Allow NULL?
22	SZEDAN	User Address Number	Numeric	Generic Edit	8	0	Allow NULL?
23	SZKCO	Document Company	String	Generic Edit	5	0	Allow NULL?
24	SZDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
25	SZDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
26	SZSFX	Document Pay Item	String	Generic Edit	3	0	Allow NULL?
27	SZSFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0	Allow NULL?
28	SZDCTA	Document Type - Adjusting	String	UDC (00 DT)	2	0	Allow NULL?
29	SZAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
30	SZPYE	Payee Address Number	Numeric	Generic Edit	8	0	Allow NULL?
31	SZSNTO	Address Number - Approver	Numeric	Generic Edit	8	0	Allow NULL?
32	SZDIVJ	Date - Invoice - Julian	Date	Generic Edit	6	0
33	SZDSVJ	Date - Service/Tax	Date	Generic Edit	6	0
34	SZDDJ	Date - Net Due	Date	Generic Edit	6	0
35	SZDDNJ	Date - Discount Due - Julian	Date	Generic Edit	6	0
36	SZDGJ	Date - For G/L (and Voucher) - Julian	Date	Generic Edit	6	0
37	SZFY	Fiscal Year	Numeric	Generic Edit	2	0	Allow NULL?
38	SZCTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
39	SZPN	Period Number - General Ledger	Numeric	Generic Edit	2	0	Allow NULL?
40	SZCO	Company	String	Generic Edit	5	0	Allow NULL?
41	SZICU	Batch Number	Numeric	Generic Edit	8	0	Allow NULL?
42	SZICUT	Batch Type	String	UDC (98 IT)	2	0	Allow NULL?
43	SZDICJ	Date - Batch (Julian)	Date	Generic Edit	6	0
44	SZBALJ	Balanced - Journal Entries	Character	UDC (H00 BB)	1	0	Allow NULL?
45	SZPST	Pay Status Code	Character	UDC (00 PS)	1	0	Allow NULL?
46	SZAG	Amount - Gross	Numeric	Generic Edit	15	2	Allow NULL?
47	SZAAP	Amount Open	Numeric	Generic Edit	15	2	Allow NULL?
48	SZADSC	Discount Available	Numeric	Generic Edit	15	2	Allow NULL?
49	SZADSA	Discount Taken	Numeric	Generic Edit	15	2	Allow NULL?
50	SZATXA	Amount - Taxable	Numeric	Generic Edit	15	2	Allow NULL?
51	SZATXN	Amount - Non-Taxable	Numeric	Generic Edit	15	2	Allow NULL?
52	SZSTAM	Amount - Tax	Numeric	Generic Edit	15	2	Allow NULL?
53	SZTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
54	SZEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
55	SZCRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
56	SZCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
57	SZCRDC	Currency Code - To	String	Generic Edit	3	0	Allow NULL?
58	SZCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
59	SZACR	Amount - Currency	Numeric	Generic Edit	15	2	Allow NULL?
60	SZFAP	Amount - Foreign Open	Numeric	Generic Edit	15	2	Allow NULL?
61	SZCDS	Amount - Foreign Discount Available	Numeric	Generic Edit	15	2	Allow NULL?
62	SZCDSA	Amount - Foreign Discount Taken	Numeric	Generic Edit	15	2	Allow NULL?
63	SZCTXA	Amount - Foreign Taxable	Numeric	Generic Edit	15	2	Allow NULL?
64	SZCTXN	Amount - Foreign Non-Taxable	Numeric	Generic Edit	15	2	Allow NULL?
65	SZCTAM	Amount - Foreign Tax	Numeric	Generic Edit	15	2	Allow NULL?
66	SZGLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
67	SZGLBA	G/L Bank Account	String	Generic Edit	8	0	Allow NULL?
68	SZPOST	G/L Posted Code	Character	Generic Edit	1	0	Allow NULL?
69	SZAM	Account Mode - G/L	Character	UDC (H09 AM)	1	0	Allow NULL?
70	SZAID2	Account ID	String	Generic Edit	8	0	Allow NULL?
71	SZMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
72	SZOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
73	SZSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
74	SZSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
75	SZSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
76	SZBAID	Bank Transit Short ID	String	Generic Edit	8	0	Allow NULL?
77	SZPTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
78	SZVOD	Void Flag	Character	Generic Edit	1	0	Allow NULL?
79	SZOKCO	Document Company (Original Order)	String	Generic Edit	5	0	Allow NULL?
80	SZODCT	Document Type - Original	String	UDC (00 DT)	2	0	Allow NULL?
81	SZODOC	Document - Original	Numeric	Generic Edit	8	0	Allow NULL?
82	SZOSFX	Document Pay Item - Original	String	Generic Edit	3	0	Allow NULL?
83	SZCRC	Payment Handling Code	String	UDC (00 HC)	3	0	Allow NULL?
84	SZVINV	Supplier Invoice Number	String	Generic Edit	25	0	Allow NULL?
85	SZPKCO	Document Company (Purchase Order)	String	Generic Edit	5	0	Allow NULL?
86	SZPO	Purchase Order	String	Generic Edit	8	0	Allow NULL?
87	SZPDCT	Document Type - Purchase Order	String	UDC (00 DT)	2	0	Allow NULL?
88	SZLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
89	SZSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
90	SZOPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2	Allow NULL?
91	SZVR01	Reference	String	Generic Edit	25	0	Allow NULL?
92	SZUNIT	Unit	String	Generic Edit	8	0	Allow NULL?
93	SZMCU2	Business Unit 2	String	Generic Edit	12	0	Allow NULL?
94	SZRMK	Name - Remark	String	Generic Edit	30	0	Allow NULL?
95	SZRF	Frequency - Recurring	String	UDC (H00 RF)	2	0	Allow NULL?
96	SZDRF	Recurring Frequency # of Payments	Numeric	Generic Edit	3	0	Allow NULL?
97	SZCTL	Control/Statement Field	String	Generic Edit	13	0	Allow NULL?
98	SZFNLP	Closed Item - As Of Processing	Character	Generic Edit	1	0	Allow NULL?
99	SZU	Units	Numeric	Generic Edit	15	2	Allow NULL?
100	SZUM	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
101	SZPYIN	Payment Instrument	Character	UDC (00 PY)	1	0	Allow NULL?
102	SZTXA3	Tax Rate/Area 3 - Withholding	String	Generic Edit	10	0	Allow NULL?
103	SZEXR3	Tax Expl Code 3 - Withholding	String	UDC (00 EX)	2	0	Allow NULL?
104	SZRP1	A/R - A/P - Miscellaneous Code 1	Character	Generic Edit	1	0	Allow NULL?
105	SZRP2	A/R - A/P - Miscellaneous Code 2	Character	Generic Edit	1	0	Allow NULL?
106	SZRP3	A/R - A/P - Cash Rcpts/Inv Reg Code	Character	Generic Edit	1	0	Allow NULL?
107	SZAC07	Category Code - Address Book 07	String	UDC (01 07)	3	0	Allow NULL?
108	SZTNN	Flag for 1099	Character	Generic Edit	1	0	Allow NULL?
109	SZDMCD	Domestic Entry w/Mult Currency Distr	Character	Generic Edit	1	0	Allow NULL?
110	SZITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
111	SZHCRR	Historical Currency Conversion Rate	Numeric	Generic Edit	15	0	Allow NULL?
112	SZHDGJ	Historical Date - Julian	Date	Generic Edit	6	0
113	SZDIM	Date - Invoice - MO	Numeric	Generic Edit	2	0	Allow NULL?
114	SZDID	Date - Invoice - DA	Numeric	Generic Edit	2	0	Allow NULL?
115	SZDIY	Date - Invoice - YR	Numeric	Generic Edit	2	0	Allow NULL?
116	SZDI#	Date - Invoice - CTRY	Numeric	Generic Edit	2	0	Allow NULL?
117	SZDSVM	Date - Service/Tax - MO	Numeric	Generic Edit	2	0	Allow NULL?
118	SZDSVD	Date - Service/Tax - DA	Numeric	Generic Edit	2	0	Allow NULL?
119	SZDSVY	Date - Service/Tax - YR	Numeric	Generic Edit	2	0	Allow NULL?
120	SZDSY#	Date - Batch System Date - CTRY	Numeric	Generic Edit	2	0	Allow NULL?
121	SZDDM	Date - Net Due - MO	Numeric	Generic Edit	2	0	Allow NULL?
122	SZDDD	Date - Net Due - DA	Numeric	Generic Edit	2	0	Allow NULL?
123	SZDDY	Date - Net Due - YR	Numeric	Generic Edit	2	0	Allow NULL?
124	SZDD#	Date - Net Due - CTRY	Numeric	Generic Edit	2	0	Allow NULL?
125	SZDDNM	Date - Discount Due - MO	Numeric	Generic Edit	2	0	Allow NULL?
126	SZDDND	Date - Discount Due -DA	Numeric	Generic Edit	2	0	Allow NULL?
127	SZDDNY	Date - Discount Due - YR	Numeric	Generic Edit	2	0	Allow NULL?
128	SZDDN#	Date - Discount Due - CTRY	Numeric	Generic Edit	2	0	Allow NULL?
129	SZDGM	Date - For G/L (and Voucher) - MO	Numeric	Generic Edit	2	0	Allow NULL?
130	SZDGD	Date - For G/L (and Voucher) - DA	Numeric	Generic Edit	2	0	Allow NULL?
131	SZDGY	Date - For G/L (and Voucher) - YR	Numeric	Generic Edit	2	0	Allow NULL?
132	SZDG#	Date - For G/L (and Voucher) - CTRY	Numeric	Generic Edit	2	0	Allow NULL?
133	SZDICM	Date - Batch - MO	Numeric	Generic Edit	2	0	Allow NULL?
134	SZDICD	Date - Batch - DA	Numeric	Generic Edit	2	0	Allow NULL?
135	SZDICY	Date - Batch - YR	Numeric	Generic Edit	2	0	Allow NULL?
136	SZDIC#	Date - Batch - CTRY	Numeric	Generic Edit	2	0	Allow NULL?
137	SZHDGM	Historical Date - MO	Numeric	Generic Edit	2	0	Allow NULL?
138	SZHDGD	Historical Date - DA	Numeric	Generic Edit	2	0	Allow NULL?
139	SZHDGY	Historical Date - YR	Numeric	Generic Edit	2	0	Allow NULL?
140	SZHDG#	Historical Date - CTRY	Numeric	Generic Edit	2	0	Allow NULL?
141	SZDOCM	Document - Matching(Payment or Item)	Numeric	Generic Edit	8	0	Allow NULL?
142	SZURC1	User Reserved Code	String	Generic Edit	3	0	Allow NULL?
143	SZUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
144	SZURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
145	SZURDT	User Reserved Date	Date	Generic Edit	6	0
146	SZURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
147	SZURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
148	SZURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
149	SZTORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
150	SZUSER	User ID	String	Generic Edit	10	0	Allow NULL?
151	SZPID	Program ID	String	Generic Edit	10	0	Allow NULL?
152	SZJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
153	SZUPMJ	Date - Updated	Date	Generic Edit	6	0
154	SZTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
155	SZTNST	Transit Number - Bank	String	Generic Edit	20	0	Allow NULL?
156	SZYC01	Category Code - A/P Ledger 01	String	Generic Edit	3	0	Allow NULL?
157	SZYC02	Category Code - A/P Ledger 02	String	Generic Edit	3	0	Allow NULL?
158	SZYC03	Category Code - A/P Ledger 03	String	Generic Edit	3	0	Allow NULL?
159	SZYC04	Category Code - A/P Ledger 04	String	Generic Edit	3	0	Allow NULL?
160	SZYC05	Category Code - A/P Ledger 05	String	Generic Edit	3	0	Allow NULL?
161	SZYC06	Category Code - A/P Ledger 06	String	Generic Edit	3	0	Allow NULL?
162	SZYC07	Category Code - A/P Ledger 07	String	Generic Edit	3	0	Allow NULL?
163	SZYC08	Category Code - A/P Ledger 08	String	Generic Edit	3	0	Allow NULL?
164	SZYC09	Category Code - A/P Ledger 09	String	Generic Edit	3	0	Allow NULL?
165	SZYC10	Category Code - A/P Ledger 10	String	Generic Edit	3	0	Allow NULL?
166	SZDTXS	Deferred Tax Status - VAT	Character	Generic Edit	1	0	Allow NULL?
167	SZBCRC	Currency Code - Base	String	Generic Edit	3	0	Allow NULL?
168	SZATAD	Amount - To Distribute	Numeric	Generic Edit	15	2	Allow NULL?
169	SZCTAD	Amount - Currency To Distribute	Numeric	Generic Edit	15	2	Allow NULL?
170	SZNRTA	Non-Recoverable Tax Amount	Numeric	Generic Edit	15	2	Allow NULL?
171	SZFNRT	Foreign Non-Recoverable Tax	Numeric	Generic Edit	15	2	Allow NULL?
172	SZTAXP	Purchasing Taxable Y/N	Character	Generic Edit	1	0	Allow NULL?
173	SZPRGF	Purge Flag	Character	Generic Edit	1	0	Allow NULL?
174	SZGFL5	Generic Flag 5	Character	Generic Edit	1	0	Allow NULL?
175	SZGFL6	Generic Flag 6	Character	Generic Edit	1	0	Allow NULL?
176	SZGAM1	Generic Amount 1	Numeric	Generic Edit	15	2	Allow NULL?
177	SZGAM2	Generic Amount 2	Numeric	Generic Edit	15	2	Allow NULL?
178	SZGEN4	Generic String 4	String	Generic Edit	25	0	Allow NULL?
179	SZGEN5	Generic String 5	String	Generic Edit	25	0	Allow NULL?
180	SZWTAD	Future - Withholding Tax Amount Domestic	Numeric	Generic Edit	15	2	Allow NULL?
181	SZWTAF	Future - Withholding Tax Amount Foreign	Numeric	Generic Edit	15	2	Allow NULL?
182	SZSMMF	Summarized Flag	Character	Generic Edit	1	0	Allow NULL?
183	SZPYWP	Pay When Paid	Character	Generic Edit	1	0	Allow NULL?
184	SZPWPG	Pay When Paid Group Number	Numeric	Generic Edit	15	0	Allow NULL?
185	SZNETTCID	Netting Transaction ID	Numeric	Generic Edit	15	0	Allow NULL?
186	SZNETDOC	Netting Document Number	Numeric	Generic Edit	15	0	Allow NULL?
187	SZNETRC5	Netting Line ID	Numeric	Generic Edit	6	0	Allow NULL?
188	SZNETST	Netting Status Code	Character	UDC (00 NS)	1	0	Allow NULL?
189	SZCNTRTID	Contract ID	Numeric	Generic Edit	8	0	Allow NULL?
190	SZCNTRTCD	Contract Code	String	Generic Edit	12	0	Allow NULL?
191	SZWVID	Vessel ID	Numeric	Generic Edit	8	0	Allow NULL?
192	SZBLSCD2	Block Code	String	Generic Edit	10	0	Allow NULL?
193	SZHARPER	Harvest Period	String	Generic Edit	6	0	Allow NULL?
194	SZHARSFX	Harvest Suffix	String	Generic Edit	10	0	Allow NULL?
195	SZDDRL	Due Date Rule	String	Generic Edit	5	0	Allow NULL?
196	SZSEQN	Sequence Number	Numeric	Generic Edit	7	0	Allow NULL?

TOP 812 | 04 | F0411Z3 INDEXES

Number

Description

User ID Batch Number + (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	DOC	Document (Voucher Invoice etc.)	Ascending
2	DCT	Document Type	Ascending
3	KCO	Document Company	Ascending
4	SFX	Document Pay Item	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

196 COLUMNS | 2 INDEXES | 812 | 04 | F0411Z3 TABLE

TOP 812 | 04 | F0411Z3 COLUMNS

TOP 812 | 04 | F0411Z3 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

196 COLUMNS | 2 INDEXES | 812 | 04 | F0411Z3 TABLE

TOP812 | 04 | F0411Z3 COLUMNS

TOP812 | 04 | F0411Z3 INDEXES

TOP 812 | 04 | F0411Z3 COLUMNS

TOP 812 | 04 | F0411Z3 INDEXES