	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	F4102	IB	Item Branch File
7	F9671	SD	Software Update Detail Table
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	F4311	PD	Purchase Order Detail File
10	F4111	IL	Item Ledger File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0411	RP	Accounts Payable Ledger
5	F0006	MC	Business Unit Master
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

193 COLUMNS | 4 INDEXES | 910 | 09 | F0911Z1 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
09: General Accounting
1	910	F0911Z1	VN	193	4	Journal Entry Transactions - Batch File	Batch Input Files	09: General Accounting	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 VNEDUS, VNEDTY, VNEDSQ, VNEDTN, VNEDCT, VNEDLN, VNEDTS, VNEDFT, VNEDDT, VNEDER, VNEDDL, VNEDSP, VNEDTC, VNEDTR, VNEDBT, VNEDGL, VNEDAN, VNKCO, VNDCT, VNDOC, VNDGJ, VNJELN, VNEXTL, VNPOST, VNICU, VNICUT, VNDICJ, VNDSYJ, VNTICU, VNCO, VNANI, VNAM, VNAID, VNMCU, VNOBJ, VNSUB, VNSBL, VNSBLT, VNLT, VNPN, VNCTRY, VNFY, VNFQ, VNCRCD, VNCRR, VNHCRR, VNHDGJ, VNAA, VNU, VNUM, VNGLC, VNRE, VNEXA, VNEXR, VNR1, VNR2, VNR3, VNSFX, VNODOC, VNODCT, VNOSFX, VNPKCO, VNOKCO, VNPDCT, VNAN8, VNCN, VNDKJ, VNDKC, VNASID, VNBRE, VNRCND, VNSUMM, VNPRGE, VNTNN, VNALT1, VNALT2, VNALT3, VNALT4, VNALT5, VNALT6, VNALT7, VNALT8, VNALT9, VNALT0, VNALTT, VNALTU, VNALTV, VNALTW, VNALTX, VNALTZ, VNDLNA, VNCFF1, VNCFF2, VNASM, VNBC, VNVINV, VNIVD, VNWR01, VNPO, VNPSFX, VNDCTO, VNLNID, VNWY, VNWN, VNFNLP, VNOPSQ, VNJBCD, VNJBST, VNHMCU, VNDOI, VNALID, VNALTY, VNDSVJ, VNTORG, VNREG#, VNPYID, VNUSER, VNPID, VNJOBN, VNUPMJ, VNUPMT, VNCRRM, VNACR, VNDGM, VNDGD, VNDGY, VNDG#, VNDICM, VNDICD, VNDICY, VNDIC#, VNDSYM, VNDSYD, VNDSYY, VNDSY#, VNDKM, VNDKD, VNDKY, VNDK#, VNDSVM, VNDSVD, VNDSVY, VNDSV#, VNHDGM, VNHDGD, VNHDGY, VNHDG#, VNDKCM, VNDKCD, VNDKCY, VNDKC#, VNIVDM, VNIVDD, VNIVDY, VNIVD#, VNABR1, VNABR2, VNABR3, VNABR4, VNABT1, VNABT2, VNABT3, VNABT4, VNITM, VNPM01, VNPM02, VNPM03, VNPM04, VNPM05, VNPM06, VNPM07, VNPM08, VNPM09, VNPM10, VNBCRC, VNEXR1, VNTXA1, VNTXITM, VNACTB, VNSTAM, VNCTAM, VNAG, VNAGF, VNTKTX, VNDLNID, VNCKNU, VNBUPC, VNAHBU, VNEPGC, VNJPGC, VNRC5, VNSFXE, VNOFM FROM F0911Z1

TOP 910 | 09 | F0911Z1 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	VNEDUS	EDI - User ID	String	Generic Edit	10	0	Allow NULL?
2	VNEDTY	Type Record	Character	UDC (00 RD)	1	0	Allow NULL?
3	VNEDSQ	Record Sequence	Numeric	Generic Edit	2	0	Allow NULL?
4	VNEDTN	EDI - Transaction Number	String	Generic Edit	22	0	Allow NULL?
5	VNEDCT	EDI - Document Type	String	Generic Edit	2	0	Allow NULL?
6	VNEDLN	EDI - Line Number	Numeric	Generic Edit	7	3	Allow NULL?
7	VNEDTS	EDI - Transaction Set Number	String	Generic Edit	6	0	Allow NULL?
8	VNEDFT	EDI - Translation Format	String	Generic Edit	10	0	Allow NULL?
9	VNEDDT	EDI - Transmission Date	Date	Generic Edit	6	0
10	VNEDER	EDI - Send/Receive Indicator	Character	UDC (H00 ED)	1	0	Allow NULL?
11	VNEDDL	EDI - Detail Lines Processed	Numeric	Generic Edit	5	0	Allow NULL?
12	VNEDSP	EDI - Successfully Processed	Character	Generic Edit	1	0	Allow NULL?
13	VNEDTC	EDI - Transaction Action	Character	Generic Edit	1	0	Allow NULL?
14	VNEDTR	EDI - Transaction Type	Character	Generic Edit	1	0	Allow NULL?
15	VNEDBT	EDI - Batch Number	String	Generic Edit	15	0	Allow NULL?
16	VNEDGL	Batch File Create G/L Record	Character	Generic Edit	1	0	Allow NULL?
17	VNEDAN	User Address Number	Numeric	Generic Edit	8	0	Allow NULL?
18	VNKCO	Document Company	String	Generic Edit	5	0	Allow NULL?
19	VNDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
20	VNDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
21	VNDGJ	Date - For G/L (and Voucher) - Julian	Date	Generic Edit	6	0
22	VNJELN	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
23	VNEXTL	Line Extension Code	String	Generic Edit	2	0	Allow NULL?
24	VNPOST	G/L Posted Code	Character	Generic Edit	1	0	Allow NULL?
25	VNICU	Batch Number	Numeric	Generic Edit	8	0	Allow NULL?
26	VNICUT	Batch Type	String	UDC (98 IT)	2	0	Allow NULL?
27	VNDICJ	Date - Batch (Julian)	Date	Generic Edit	6	0
28	VNDSYJ	Date - Batch System Date	Date	Generic Edit	6	0
29	VNTICU	Batch Time	Numeric	Generic Edit	6	0	Allow NULL?
30	VNCO	Company	String	Generic Edit	5	0	Allow NULL?
31	VNANI	Account Number - Input (Mode Unknown)	String	Generic Edit	29	0	Allow NULL?
32	VNAM	Account Mode - G/L	Character	UDC (H09 AM)	1	0	Allow NULL?
33	VNAID	Account ID	String	Generic Edit	8	0	Allow NULL?
34	VNMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
35	VNOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
36	VNSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
37	VNSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
38	VNSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
39	VNLT	Ledger Types	String	UDC (09 LT)	2	0	Allow NULL?
40	VNPN	Period Number - General Ledger	Numeric	Generic Edit	2	0	Allow NULL?
41	VNCTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
42	VNFY	Fiscal Year	Numeric	Generic Edit	2	0	Allow NULL?
43	VNFQ	Fiscal Quarter (Obsolete)	String	UDC (H09 FQ)	4	0	Allow NULL?
44	VNCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
45	VNCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
46	VNHCRR	Historical Currency Conversion Rate	Numeric	Generic Edit	15	0	Allow NULL?
47	VNHDGJ	Historical Date - Julian	Date	Generic Edit	6	0
48	VNAA	Amount	Numeric	Generic Edit	15	2	Allow NULL?
49	VNU	Units	Numeric	Generic Edit	15	2	Allow NULL?
50	VNUM	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
51	VNGLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
52	VNRE	Reverse or Void (R/V)	Character	UDC (H09 RE)	1	0	Allow NULL?
53	VNEXA	Name - Alpha Explanation	String	Generic Edit	30	0	Allow NULL?
54	VNEXR	Name - Remark Explanation	String	Generic Edit	30	0	Allow NULL?
55	VNR1	Reference 1 - JE Voucher Invoice etc.	String	Generic Edit	8	0	Allow NULL?
56	VNR2	Reference 2	String	Generic Edit	8	0	Allow NULL?
57	VNR3	Reference 3 - Account Reconciliation	String	Generic Edit	8	0	Allow NULL?
58	VNSFX	Document Pay Item	String	Generic Edit	3	0	Allow NULL?
59	VNODOC	Document - Original	Numeric	Generic Edit	8	0	Allow NULL?
60	VNODCT	Document Type - Original	String	UDC (00 DT)	2	0	Allow NULL?
61	VNOSFX	Document Pay Item - Original	String	Generic Edit	3	0	Allow NULL?
62	VNPKCO	Document Company (Purchase Order)	String	Generic Edit	5	0	Allow NULL?
63	VNOKCO	Document Company (Original Order)	String	Generic Edit	5	0	Allow NULL?
64	VNPDCT	Document Type - Purchase Order	String	UDC (00 DT)	2	0	Allow NULL?
65	VNAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
66	VNCN	Payment Number	String	Generic Edit	8	0	Allow NULL?
67	VNDKJ	Date - Check - Julian	Date	Generic Edit	6	0
68	VNDKC	Date - Check Cleared	Date	Generic Edit	6	0
69	VNASID	Serial Number	String	Generic Edit	25	0	Allow NULL?
70	VNBRE	Batch Rear End Posted Code	Character	UDC (09 BR)	1	0	Allow NULL?
71	VNRCND	Reconciled Code	Character	UDC (09 RC)	1	0	Allow NULL?
72	VNSUMM	Summarized Code	Character	Generic Edit	1	0	Allow NULL?
73	VNPRGE	Purge Code	Character	Generic Edit	1	0	Allow NULL?
74	VNTNN	Flag for 1099	Character	Generic Edit	1	0	Allow NULL?
75	VNALT1	G/L Posting Code - Alternate 1	Character	Generic Edit	1	0	Allow NULL?
76	VNALT2	G/L Posting Code - Alternate 2	Character	Generic Edit	1	0	Allow NULL?
77	VNALT3	G/L Posting Code - Alternate 3	Character	Generic Edit	1	0	Allow NULL?
78	VNALT4	G/L Posting Code - Alternate 4	Character	Generic Edit	1	0	Allow NULL?
79	VNALT5	G/L Posting Code - Alternate 5	Character	Generic Edit	1	0	Allow NULL?
80	VNALT6	G/L Posting Code - Cash Basis Acct	Character	Generic Edit	1	0	Allow NULL?
81	VNALT7	Commitment Relief Flag	Character	Generic Edit	1	0	Allow NULL?
82	VNALT8	Billing Control	Character	Generic Edit	1	0	Allow NULL?
83	VNALT9	Currency Update	Character	Generic Edit	1	0	Allow NULL?
84	VNALT0	G/L Posting Code - Alternate 0	Character	Generic Edit	1	0	Allow NULL?
85	VNALTT	G/L Posting Code - Alternate T	Character	Generic Edit	1	0	Allow NULL?
86	VNALTU	G/L Posting Code - Alternate U	Character	Generic Edit	1	0	Allow NULL?
87	VNALTV	Stocked Inventory Commitment	Character	Generic Edit	1	0	Allow NULL?
88	VNALTW	G/L Posting Code - Alternate W	Character	Generic Edit	1	0	Allow NULL?
89	VNALTX	Consumption Tax Cross Reference	Character	Generic Edit	1	0	Allow NULL?
90	VNALTZ	G/L Posting Code - Account Debit Balance	Character	Generic Edit	1	0	Allow NULL?
91	VNDLNA	Delete Not Allowed	Character	Generic Edit	1	0	Allow NULL?
92	VNCFF1	Client Free Form - Alternate 1	Character	Generic Edit	1	0	Allow NULL?
93	VNCFF2	Client Free Form - Alternate 2	Character	Generic Edit	1	0	Allow NULL?
94	VNASM	Lease Cost Ledger Posted Code	Character	Generic Edit	1	0	Allow NULL?
95	VNBC	Bill Code	Character	UDC (98 BC)	1	0	Allow NULL?
96	VNVINV	Supplier Invoice Number	String	Generic Edit	25	0	Allow NULL?
97	VNIVD	Date - Invoice	Date	Generic Edit	6	0
98	VNWR01	Categories - Work Order 01	String	UDC (00 W1)	4	0	Allow NULL?
99	VNPO	Purchase Order	String	Generic Edit	8	0	Allow NULL?
100	VNPSFX	Purchase Order Suffix	String	Generic Edit	3	0	Allow NULL?
101	VNDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
102	VNLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
103	VNWY	Fiscal Year - Weekly	Numeric	Generic Edit	2	0	Allow NULL?
104	VNWN	Fiscal Period - Weekly	Numeric	Generic Edit	2	0	Allow NULL?
105	VNFNLP	Closed Item - As Of Processing	Character	Generic Edit	1	0	Allow NULL?
106	VNOPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2	Allow NULL?
107	VNJBCD	Job Type (Craft) Code	String	UDC (06 G)	6	0	Allow NULL?
108	VNJBST	Job Step	String	UDC (06 GS)	4	0	Allow NULL?
109	VNHMCU	Business Unit - Home	String	Generic Edit	12	0	Allow NULL?
110	VNDOI	DOI Sub	Numeric	Generic Edit	2	0	Allow NULL?
111	VNALID	Outsider Lease or Well ID	String	Generic Edit	25	0	Allow NULL?
112	VNALTY	ID Type	String	UDC (00 AL)	2	0	Allow NULL?
113	VNDSVJ	Date - Service/Tax	Date	Generic Edit	6	0
114	VNTORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
115	VNREG#	Registration Number	Numeric	Generic Edit	8	0	Allow NULL?
116	VNPYID	Payment ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
117	VNUSER	User ID	String	Generic Edit	10	0	Allow NULL?
118	VNPID	Program ID	String	Generic Edit	10	0	Allow NULL?
119	VNJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
120	VNUPMJ	Date - Updated	Date	Generic Edit	6	0
121	VNUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
122	VNCRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
123	VNACR	Amount - Currency	Numeric	Generic Edit	15	2	Allow NULL?
124	VNDGM	Date - For G/L (and Voucher) - MO	Numeric	Generic Edit	2	0	Allow NULL?
125	VNDGD	Date - For G/L (and Voucher) - DA	Numeric	Generic Edit	2	0	Allow NULL?
126	VNDGY	Date - For G/L (and Voucher) - YR	Numeric	Generic Edit	2	0	Allow NULL?
127	VNDG#	Date - For G/L (and Voucher) - CTRY	Numeric	Generic Edit	2	0	Allow NULL?
128	VNDICM	Date - Batch - MO	Numeric	Generic Edit	2	0	Allow NULL?
129	VNDICD	Date - Batch - DA	Numeric	Generic Edit	2	0	Allow NULL?
130	VNDICY	Date - Batch - YR	Numeric	Generic Edit	2	0	Allow NULL?
131	VNDIC#	Date - Batch - CTRY	Numeric	Generic Edit	2	0	Allow NULL?
132	VNDSYM	Date - Batch System Date - MO	Numeric	Generic Edit	2	0	Allow NULL?
133	VNDSYD	Date - Batch System Date - DA	Numeric	Generic Edit	2	0	Allow NULL?
134	VNDSYY	Date - Batch System Date - YR	Numeric	Generic Edit	2	0	Allow NULL?
135	VNDSY#	Date - Batch System Date - CTRY	Numeric	Generic Edit	2	0	Allow NULL?
136	VNDKM	Date - Check - MO	Numeric	Generic Edit	2	0	Allow NULL?
137	VNDKD	Date - Check - DA	Numeric	Generic Edit	2	0	Allow NULL?
138	VNDKY	Date - Check - YR	Numeric	Generic Edit	2	0	Allow NULL?
139	VNDK#	Date - Check - CTRY	Numeric	Generic Edit	2	0	Allow NULL?
140	VNDSVM	Date - Service/Tax - MO	Numeric	Generic Edit	2	0	Allow NULL?
141	VNDSVD	Date - Service/Tax - DA	Numeric	Generic Edit	2	0	Allow NULL?
142	VNDSVY	Date - Service/Tax - YR	Numeric	Generic Edit	2	0	Allow NULL?
143	VNDSV#	Date - Service/Tax - CTRY	Numeric	Generic Edit	2	0	Allow NULL?
144	VNHDGM	Historical Date - MO	Numeric	Generic Edit	2	0	Allow NULL?
145	VNHDGD	Historical Date - DA	Numeric	Generic Edit	2	0	Allow NULL?
146	VNHDGY	Historical Date - YR	Numeric	Generic Edit	2	0	Allow NULL?
147	VNHDG#	Historical Date - CTRY	Numeric	Generic Edit	2	0	Allow NULL?
148	VNDKCM	Date - Check Cleared - MO	Numeric	Generic Edit	2	0	Allow NULL?
149	VNDKCD	Date - Check Cleared - DA	Numeric	Generic Edit	2	0	Allow NULL?
150	VNDKCY	Date - Check Cleared - YR	Numeric	Generic Edit	2	0	Allow NULL?
151	VNDKC#	Date - Check Cleared - CTRY	Numeric	Generic Edit	2	0	Allow NULL?
152	VNIVDM	Date - Invoice - MO	Numeric	Generic Edit	2	0	Allow NULL?
153	VNIVDD	Date - Invoice - DA	Numeric	Generic Edit	2	0	Allow NULL?
154	VNIVDY	Date - Invoice - YR	Numeric	Generic Edit	2	0	Allow NULL?
155	VNIVD#	Date - Invoice - CTRY	Numeric	Generic Edit	2	0	Allow NULL?
156	VNABR1	Managerial Analysis Code 1	String	Generic Edit	12	0	Allow NULL?
157	VNABR2	Managerial Analysis Code 2	String	Generic Edit	12	0	Allow NULL?
158	VNABR3	Managerial Analysis Code 3	String	Generic Edit	12	0	Allow NULL?
159	VNABR4	Managerial Analysis Code 4	String	Generic Edit	12	0	Allow NULL?
160	VNABT1	Managerial Analysis Type 1	Character	UDC	1	0	Allow NULL?
161	VNABT2	Managerial Analysis Type 2	Character	UDC	1	0	Allow NULL?
162	VNABT3	Managerial Analysis Type 3	Character	UDC	1	0	Allow NULL?
163	VNABT4	Managerial Analysis Type 4	Character	UDC	1	0	Allow NULL?
164	VNITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
165	VNPM01	Posting Code 1 - Managerial Accounting .	Character	Generic Edit	1	0	Allow NULL?
166	VNPM02	Posting Code 2 - Managerial Accounting .	Character	Generic Edit	1	0	Allow NULL?
167	VNPM03	Posting Code 3 - Managerial Accounting .	Character	Generic Edit	1	0	Allow NULL?
168	VNPM04	Posting Code 4 - Managerial Accounting .	Character	Generic Edit	1	0	Allow NULL?
169	VNPM05	Posting Code 5 - Managerial Accounting .	Character	Generic Edit	1	0	Allow NULL?
170	VNPM06	Posting Code 6 - Managerial Accounting .	Character	Generic Edit	1	0	Allow NULL?
171	VNPM07	Posting Code 7 - Managerial Accounting .	Character	Generic Edit	1	0	Allow NULL?
172	VNPM08	Posting Code 8 - Managerial Accounting .	Character	Generic Edit	1	0	Allow NULL?
173	VNPM09	Posting Code 9 - Managerial Accounting .	Character	Generic Edit	1	0	Allow NULL?
174	VNPM10	Posting Code 10- Managerial Accounting .	Character	Generic Edit	1	0	Allow NULL?
175	VNBCRC	Currency Code - Base	String	Generic Edit	3	0	Allow NULL?
176	VNEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
177	VNTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
178	VNTXITM	Tax - Short Item Number	Numeric	Generic Edit	8	0	Allow NULL?
179	VNACTB	Activity-Based Costing Activity Code	String	Generic Edit	10	0	Allow NULL?
180	VNSTAM	Amount - Tax	Numeric	Generic Edit	15	2	Allow NULL?
181	VNCTAM	Amount - Foreign Tax	Numeric	Generic Edit	15	2	Allow NULL?
182	VNAG	Amount - Gross	Numeric	Generic Edit	15	2	Allow NULL?
183	VNAGF	Amount - Foreign Gross	Numeric	Generic Edit	15	2	Allow NULL?
184	VNTKTX	Track Taxes Flag	Character	Generic Edit	1	0	Allow NULL?
185	VNDLNID	DistributionLine Number	Numeric	Generic Edit	6	3	Allow NULL?
186	VNCKNU	Receipt Number	String	Generic Edit	25	0	Allow NULL?
187	VNBUPC	Burdening Posted Code	Character	Generic Edit	1	0	Allow NULL?
188	VNAHBU	Alternate Home Business Unit	String	Generic Edit	12	0	Allow NULL?
189	VNEPGC	Employee Pool Grouping Code	String	UDC (00 12)	3	0	Allow NULL?
190	VNJPGC	Job Pool Grouping Code	String	UDC (00 12)	3	0	Allow NULL?
191	VNRC5	File Line Identifier 5.0	Numeric	Generic Edit	5	0	Allow NULL?
192	VNSFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0	Allow NULL?
193	VNOFM	Auto Offset Method (S Y or B)	Character	Generic Edit	1	0	Allow NULL?

TOP 910 | 09 | F0911Z1 INDEXES

Number

Description

User Batch # + (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

Batch # Trans +

Element	Alias	Description	Sequence
1	EDBT	EDI - Batch Number	Ascending
2	EDTN	EDI - Transaction Number	Ascending
3	EDSP	EDI - Successfully Processed	Ascending

User Batch # Trans G/L Date +

Element	Alias	Description	Sequence
1	EDUS	EDI - User ID	Ascending
2	EDBT	EDI - Batch Number	Ascending
3	EDTN	EDI - Transaction Number	Ascending
4	DGJ	Date - For G/L (and Voucher) - Julian	Ascending
5	EDLN	EDI - Line Number	Ascending

EDUS EDBT EDTN EDLN Des

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	Descending

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

193 COLUMNS | 4 INDEXES | 910 | 09 | F0911Z1 TABLE

TOP 910 | 09 | F0911Z1 COLUMNS

TOP 910 | 09 | F0911Z1 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

193 COLUMNS | 4 INDEXES | 910 | 09 | F0911Z1 TABLE

TOP910 | 09 | F0911Z1 COLUMNS

TOP910 | 09 | F0911Z1 INDEXES

TOP 910 | 09 | F0911Z1 COLUMNS

TOP 910 | 09 | F0911Z1 INDEXES