	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

134 COLUMNS | 25 INDEXES | 812 | 00 | F0911 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
00: Foundation Environment
1	812	F0911	GL	134	25	Account Ledger	Transaction Files	09: General Accounting	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 GLKCO, GLDCT, GLDOC, GLDGJ, GLJELN, GLEXTL, GLPOST, GLICU, GLICUT, GLDICJ, GLDSYJ, GLTICU, GLCO, GLANI, GLAM, GLAID, GLMCU, GLOBJ, GLSUB, GLSBL, GLSBLT, GLLT, GLPN, GLCTRY, GLFY, GLFQ, GLCRCD, GLCRR, GLHCRR, GLHDGJ, GLAA, GLU, GLUM, GLGLC, GLRE, GLEXA, GLEXR, GLR1, GLR2, GLR3, GLSFX, GLODOC, GLODCT, GLOSFX, GLPKCO, GLOKCO, GLPDCT, GLAN8, GLCN, GLDKJ, GLDKC, GLASID, GLBRE, GLRCND, GLSUMM, GLPRGE, GLTNN, GLALT1, GLALT2, GLALT3, GLALT4, GLALT5, GLALT6, GLALT7, GLALT8, GLALT9, GLALT0, GLALTT, GLALTU, GLALTV, GLALTW, GLALTX, GLALTZ, GLDLNA, GLCFF1, GLCFF2, GLASM, GLBC, GLVINV, GLIVD, GLWR01, GLPO, GLPSFX, GLDCTO, GLLNID, GLWY, GLWN, GLFNLP, GLOPSQ, GLJBCD, GLJBST, GLHMCU, GLDOI, GLALID, GLALTY, GLDSVJ, GLTORG, GLREG#, GLPYID, GLUSER, GLPID, GLJOBN, GLUPMJ, GLUPMT, GLABR1, GLABR2, GLABR3, GLABR4, GLABT1, GLABT2, GLABT3, GLABT4, GLITM, GLPM01, GLPM02, GLPM03, GLPM04, GLPM05, GLPM06, GLPM07, GLPM08, GLPM09, GLPM10, GLBCRC, GLCRRM, GLPRGF, GLTXA1, GLEXR1, GLTXITM, GLACTB, GLGPF1, GLACR, GLDLNID, GLCKNU FROM F0911

TOP 812 | 00 | F0911 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	GLKCO	Document Company	String	Generic Edit	5	0	Allow NULL?
2	GLDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
3	GLDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
4	GLDGJ	Date - For G/L (and Voucher) - Julian	Date	Generic Edit	6	0
5	GLJELN	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
6	GLEXTL	Line Extension Code	String	Generic Edit	2	0	Allow NULL?
7	GLPOST	G/L Posted Code	Character	Generic Edit	1	0	Allow NULL?
8	GLICU	Batch Number	Numeric	Generic Edit	8	0	Allow NULL?
9	GLICUT	Batch Type	String	UDC (98 IT)	2	0	Allow NULL?
10	GLDICJ	Date - Batch (Julian)	Date	Generic Edit	6	0
11	GLDSYJ	Date - Batch System Date	Date	Generic Edit	6	0
12	GLTICU	Batch Time	Numeric	Generic Edit	6	0	Allow NULL?
13	GLCO	Company	String	Generic Edit	5	0	Allow NULL?
14	GLANI	Account Number - Input (Mode Unknown)	String	Generic Edit	29	0	Allow NULL?
15	GLAM	Account Mode - G/L	Character	UDC (H09 AM)	1	0	Allow NULL?
16	GLAID	Account ID	String	Generic Edit	8	0	Allow NULL?
17	GLMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
18	GLOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
19	GLSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
20	GLSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
21	GLSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
22	GLLT	Ledger Types	String	UDC (09 LT)	2	0	Allow NULL?
23	GLPN	Period Number - General Ledger	Numeric	Generic Edit	2	0	Allow NULL?
24	GLCTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
25	GLFY	Fiscal Year	Numeric	Generic Edit	2	0	Allow NULL?
26	GLFQ	Fiscal Quarter (Obsolete)	String	UDC (H09 FQ)	4	0	Allow NULL?
27	GLCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
28	GLCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
29	GLHCRR	Historical Currency Conversion Rate	Numeric	Generic Edit	15	0	Allow NULL?
30	GLHDGJ	Historical Date - Julian	Date	Generic Edit	6	0
31	GLAA	Amount	Numeric	Generic Edit	15	2	Allow NULL?
32	GLU	Units	Numeric	Generic Edit	15	2	Allow NULL?
33	GLUM	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
34	GLGLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
35	GLRE	Reverse or Void (R/V)	Character	UDC (H09 RE)	1	0	Allow NULL?
36	GLEXA	Name - Alpha Explanation	String	Generic Edit	30	0	Allow NULL?
37	GLEXR	Name - Remark Explanation	String	Generic Edit	30	0	Allow NULL?
38	GLR1	Reference 1 - JE Voucher Invoice etc.	String	Generic Edit	8	0	Allow NULL?
39	GLR2	Reference 2	String	Generic Edit	8	0	Allow NULL?
40	GLR3	Reference 3 - Account Reconciliation	String	Generic Edit	8	0	Allow NULL?
41	GLSFX	Document Pay Item	String	Generic Edit	3	0	Allow NULL?
42	GLODOC	Document - Original	Numeric	Generic Edit	8	0	Allow NULL?
43	GLODCT	Document Type - Original	String	UDC (00 DT)	2	0	Allow NULL?
44	GLOSFX	Document Pay Item - Original	String	Generic Edit	3	0	Allow NULL?
45	GLPKCO	Document Company (Purchase Order)	String	Generic Edit	5	0	Allow NULL?
46	GLOKCO	Document Company (Original Order)	String	Generic Edit	5	0	Allow NULL?
47	GLPDCT	Document Type - Purchase Order	String	UDC (00 DT)	2	0	Allow NULL?
48	GLAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
49	GLCN	Payment Number	String	Generic Edit	8	0	Allow NULL?
50	GLDKJ	Date - Check - Julian	Date	Generic Edit	6	0
51	GLDKC	Date - Check Cleared	Date	Generic Edit	6	0
52	GLASID	Serial Number	String	Generic Edit	25	0	Allow NULL?
53	GLBRE	Batch Rear End Posted Code	Character	UDC (09 BR)	1	0	Allow NULL?
54	GLRCND	Reconciled Code	Character	UDC (09 RC)	1	0	Allow NULL?
55	GLSUMM	Summarized Code	Character	Generic Edit	1	0	Allow NULL?
56	GLPRGE	Purge Code	Character	Generic Edit	1	0	Allow NULL?
57	GLTNN	Flag for 1099	Character	Generic Edit	1	0	Allow NULL?
58	GLALT1	G/L Posting Code - Alternate 1	Character	Generic Edit	1	0	Allow NULL?
59	GLALT2	G/L Posting Code - Alternate 2	Character	Generic Edit	1	0	Allow NULL?
60	GLALT3	G/L Posting Code - Alternate 3	Character	Generic Edit	1	0	Allow NULL?
61	GLALT4	G/L Posting Code - Alternate 4	Character	Generic Edit	1	0	Allow NULL?
62	GLALT5	G/L Posting Code - Alternate 5	Character	Generic Edit	1	0	Allow NULL?
63	GLALT6	G/L Posting Code - Cash Basis Acct	Character	Generic Edit	1	0	Allow NULL?
64	GLALT7	Commitment Relief Flag	Character	Generic Edit	1	0	Allow NULL?
65	GLALT8	Billing Control	Character	Generic Edit	1	0	Allow NULL?
66	GLALT9	Currency Update	Character	Generic Edit	1	0	Allow NULL?
67	GLALT0	G/L Posting Code - Alternate 0	Character	Generic Edit	1	0	Allow NULL?
68	GLALTT	G/L Posting Code - Alternate T	Character	Generic Edit	1	0	Allow NULL?
69	GLALTU	G/L Posting Code - Alternate U	Character	Generic Edit	1	0	Allow NULL?
70	GLALTV	Stocked Inventory Commitment	Character	Generic Edit	1	0	Allow NULL?
71	GLALTW	G/L Posting Code - Alternate W	Character	Generic Edit	1	0	Allow NULL?
72	GLALTX	Consumption Tax Cross Reference	Character	Generic Edit	1	0	Allow NULL?
73	GLALTZ	G/L Posting Code - Account Debit Balance	Character	Generic Edit	1	0	Allow NULL?
74	GLDLNA	Delete Not Allowed	Character	Generic Edit	1	0	Allow NULL?
75	GLCFF1	Client Free Form - Alternate 1	Character	Generic Edit	1	0	Allow NULL?
76	GLCFF2	Client Free Form - Alternate 2	Character	Generic Edit	1	0	Allow NULL?
77	GLASM	Lease Cost Ledger Posted Code	Character	Generic Edit	1	0	Allow NULL?
78	GLBC	Bill Code	Character	UDC (98 BC)	1	0	Allow NULL?
79	GLVINV	Supplier Invoice Number	String	Generic Edit	25	0	Allow NULL?
80	GLIVD	Date - Invoice	Date	Generic Edit	6	0
81	GLWR01	Categories - Work Order 01	String	UDC (00 W1)	4	0	Allow NULL?
82	GLPO	Purchase Order	String	Generic Edit	8	0	Allow NULL?
83	GLPSFX	Purchase Order Suffix	String	Generic Edit	3	0	Allow NULL?
84	GLDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
85	GLLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
86	GLWY	Fiscal Year - Weekly	Numeric	Generic Edit	2	0	Allow NULL?
87	GLWN	Fiscal Period - Weekly	Numeric	Generic Edit	2	0	Allow NULL?
88	GLFNLP	Closed Item - As Of Processing	Character	Generic Edit	1	0	Allow NULL?
89	GLOPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2	Allow NULL?
90	GLJBCD	Job Type (Craft) Code	String	UDC (06 G)	6	0	Allow NULL?
91	GLJBST	Job Step	String	UDC (06 GS)	4	0	Allow NULL?
92	GLHMCU	Business Unit - Home	String	Generic Edit	12	0	Allow NULL?
93	GLDOI	DOI Sub	Numeric	Generic Edit	2	0	Allow NULL?
94	GLALID	Outsider Lease or Well ID	String	Generic Edit	25	0	Allow NULL?
95	GLALTY	ID Type	String	UDC (00 AL)	2	0	Allow NULL?
96	GLDSVJ	Date - Service/Tax	Date	Generic Edit	6	0
97	GLTORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
98	GLREG#	Registration Number	Numeric	Generic Edit	8	0	Allow NULL?
99	GLPYID	Payment ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
100	GLUSER	User ID	String	Generic Edit	10	0	Allow NULL?
101	GLPID	Program ID	String	Generic Edit	10	0	Allow NULL?
102	GLJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
103	GLUPMJ	Date - Updated	Date	Generic Edit	6	0
104	GLUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
105	GLABR1	Managerial Analysis Code 1	String	Generic Edit	12	0	Allow NULL?
106	GLABR2	Managerial Analysis Code 2	String	Generic Edit	12	0	Allow NULL?
107	GLABR3	Managerial Analysis Code 3	String	Generic Edit	12	0	Allow NULL?
108	GLABR4	Managerial Analysis Code 4	String	Generic Edit	12	0	Allow NULL?
109	GLABT1	Managerial Analysis Type 1	Character	UDC	1	0	Allow NULL?
110	GLABT2	Managerial Analysis Type 2	Character	UDC	1	0	Allow NULL?
111	GLABT3	Managerial Analysis Type 3	Character	UDC	1	0	Allow NULL?
112	GLABT4	Managerial Analysis Type 4	Character	UDC	1	0	Allow NULL?
113	GLITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
114	GLPM01	Posting Code 1 - Managerial Accounting .	Character	Generic Edit	1	0	Allow NULL?
115	GLPM02	Posting Code 2 - Managerial Accounting .	Character	Generic Edit	1	0	Allow NULL?
116	GLPM03	Posting Code 3 - Managerial Accounting .	Character	Generic Edit	1	0	Allow NULL?
117	GLPM04	Posting Code 4 - Managerial Accounting .	Character	Generic Edit	1	0	Allow NULL?
118	GLPM05	Posting Code 5 - Managerial Accounting .	Character	Generic Edit	1	0	Allow NULL?
119	GLPM06	Posting Code 6 - Managerial Accounting .	Character	Generic Edit	1	0	Allow NULL?
120	GLPM07	Posting Code 7 - Managerial Accounting .	Character	Generic Edit	1	0	Allow NULL?
121	GLPM08	Posting Code 8 - Managerial Accounting .	Character	Generic Edit	1	0	Allow NULL?
122	GLPM09	Posting Code 9 - Managerial Accounting .	Character	Generic Edit	1	0	Allow NULL?
123	GLPM10	Posting Code 10- Managerial Accounting .	Character	Generic Edit	1	0	Allow NULL?
124	GLBCRC	Currency Code - Base	String	Generic Edit	3	0	Allow NULL?
125	GLCRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
126	GLPRGF	Purge Flag	Character	Generic Edit	1	0	Allow NULL?
127	GLTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
128	GLEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
129	GLTXITM	Tax - Short Item Number	Numeric	Generic Edit	8	0	Allow NULL?
130	GLACTB	Activity-Based Costing Activity Code	String	Generic Edit	10	0	Allow NULL?
131	GLGPF1	Future Use Flag	Character	Generic Edit	1	0	Allow NULL?
132	GLACR	Amount - Currency	Numeric	Generic Edit	15	2	Allow NULL?
133	GLDLNID	DistributionLine Number	Numeric	Generic Edit	6	3	Allow NULL?
134	GLCKNU	Receipt Number	String	Generic Edit	25	0	Allow NULL?

TOP 812 | 00 | F0911 INDEXES

Number

Description

Doc Type Number + (Primary/Unique)

Element	Alias	Description	Sequence
1	DCT	Document Type	Ascending
2	DOC	Document (Voucher Invoice etc.)	Ascending
3	KCO	Document Company	Ascending
4	DGJ	Date - For G/L (and Voucher) - Julian	Descending
5	JELN	Journal Entry Line Number	Ascending
6	LT	Ledger Types	Ascending
7	EXTL	Line Extension Code	Ascending

Post Code Batch Type +

Element	Alias	Description	Sequence
1	POST	G/L Posted Code	Ascending
2	ICUT	Batch Type	Ascending
3	ICU	Batch Number	Ascending
4	LT	Ledger Types	Ascending
5	DGJ	Date - For G/L (and Voucher) - Julian	Ascending
6	DOC	Document (Voucher Invoice etc.)	Ascending
7	KCO	Document Company	Ascending
8	DCT	Document Type	Ascending
9	JELN	Journal Entry Line Number	Ascending
10	EXTL	Line Extension Code	Ascending

Reconcile Account ID +

Element	Alias	Description	Sequence
1	RCND	Reconciled Code	Ascending
2	AID	Account ID	Ascending
3	LT	Ledger Types	Ascending
4	DCT	Document Type	Ascending
5	DGJ	Date - For G/L (and Voucher) - Julian	Ascending

Post Code Acct ID +A

Element	Alias	Description	Sequence
1	POST	G/L Posted Code	Ascending
2	AID	Account ID	Ascending
3	LT	Ledger Types	Ascending
4	CTRY	Century	Ascending
5	FY	Fiscal Year	Ascending
6	PN	Period Number - General Ledger	Ascending
7	SBL	Subledger - G/L	Ascending
8	SBLT	Subledger Type	Ascending
9	CRCD	Currency Code - From	Ascending
10	DGJ	Date - For G/L (and Voucher) - Julian	Ascending

Post Code Acct ID +B

Element	Alias	Description	Sequence
1	POST	G/L Posted Code	Ascending
2	AID	Account ID	Ascending
3	LT	Ledger Types	Ascending
4	CTRY	Century	Ascending
5	FY	Fiscal Year	Ascending
6	PN	Period Number - General Ledger	Ascending
7	SBL	Subledger - G/L	Ascending
8	SBLT	Subledger Type	Ascending
9	DGJ	Date - For G/L (and Voucher) - Julian	Ascending
10	ASID	Serial Number	Ascending
11	BRE	Batch Rear End Posted Code	Ascending

Post Code Acct ID +C

Element	Alias	Description	Sequence
1	POST	G/L Posted Code	Ascending
2	AID	Account ID	Ascending
3	LT	Ledger Types	Ascending
4	CTRY	Century	Ascending
5	FY	Fiscal Year	Ascending
6	PN	Period Number - General Ledger	Ascending
7	CRCD	Currency Code - From	Ascending
8	DGJ	Date - For G/L (and Voucher) - Julian	Ascending

Batch Type Number +

Element	Alias	Description	Sequence
1	ICUT	Batch Type	Ascending
2	ICU	Batch Number	Ascending
3	DCT	Document Type	Ascending
4	DOC	Document (Voucher Invoice etc.)	Ascending
5	KCO	Document Company	Ascending
6	DGJ	Date - For G/L (and Voucher) - Julian	Ascending

Post Code Acct ID +D

Element	Alias	Description	Sequence
1	POST	G/L Posted Code	Ascending
2	AID	Account ID	Ascending
3	LT	Ledger Types	Ascending
4	CTRY	Century	Ascending
5	FY	Fiscal Year	Ascending
6	PN	Period Number - General Ledger	Ascending
7	DGJ	Date - For G/L (and Voucher) - Julian	Ascending

Doc Type Number +B

Element	Alias	Description	Sequence
1	DCT	Document Type	Ascending
2	DOC	Document (Voucher Invoice etc.)	Ascending
3	KCO	Document Company	Ascending
4	DGJ	Date - For G/L (and Voucher) - Julian	Ascending
5	LT	Ledger Types	Ascending
6	EXTL	Line Extension Code	Ascending
7	JELN	Journal Entry Line Number	Descending

LC DCT EXA DOC KCO

Element	Alias	Description	Sequence
1	DCT	Document Type	Ascending
2	EXA	Name - Alpha Explanation	Ascending
3	DOC	Document (Voucher Invoice etc.)	Ascending
4	KCO	Document Company	Ascending

LD AID LT DGJ CRCD

Element	Alias	Description	Sequence
1	AID	Account ID	Ascending
2	LT	Ledger Types	Ascending
3	DGJ	Date - For G/L (and Voucher) - Julian	Descending
4	CRCD	Currency Code - From	Ascending
5	SBL	Subledger - G/L	Ascending
6	SBLT	Subledger Type	Ascending

Type Number +C ascending

Element	Alias	Description	Sequence
1	DCT	Document Type	Ascending
2	DOC	Document (Voucher Invoice etc.)	Ascending
3	KCO	Document Company	Ascending
4	DGJ	Date - For G/L (and Voucher) - Julian	Ascending
5	LT	Ledger Types	Ascending
6	EXTL	Line Extension Code	Ascending
7	JELN	Journal Entry Line Number	Ascending

Asset No Account ID +

Element	Alias	Description	Sequence
1	ASID	Serial Number	Ascending
2	AID	Account ID	Ascending
3	LT	Ledger Types	Ascending
4	DGJ	Date - For G/L (and Voucher) - Julian	Ascending
5	DCT	Document Type	Ascending

Bill Code Ledger Type +

Element	Alias	Description	Sequence
1	BC	Bill Code	Ascending
2	LT	Ledger Types	Ascending
3	MCU	Business Unit	Ascending
4	OBJ	Object Account	Ascending
5	SUB	Subsidiary	Ascending
6	SBL	Subledger - G/L	Ascending
7	SBLT	Subledger Type	Ascending
8	DGJ	Date - For G/L (and Voucher) - Julian	Ascending

Company Business Unit +

Element	Alias	Description	Sequence
1	CO	Company	Ascending
2	MCU	Business Unit	Ascending
3	SUB	Subsidiary	Ascending
4	OBJ	Object Account	Ascending
5	DGJ	Date - For G/L (and Voucher) - Julian	Ascending
6	LT	Ledger Types	Ascending
7	SBL	Subledger - G/L	Ascending
8	SBLT	Subledger Type	Ascending
9	POST	G/L Posted Code	Ascending
10	DCT	Document Type	Ascending
11	AN8	Address Number	Ascending

Post LedgerType +

Element	Alias	Description	Sequence
1	POST	G/L Posted Code	Ascending
2	LT	Ledger Types	Ascending
3	AID	Account ID	Ascending
4	DGJ	Date - For G/L (and Voucher) - Julian	Descending

AccountID Reference1

Element	Alias	Description	Sequence
1	AID	Account ID	Ascending
2	R1	Reference 1 - JE Voucher Invoice etc.	Ascending

AccountID Century FiscalYr +

Element	Alias	Description	Sequence
1	AID	Account ID	Ascending
2	CTRY	Century	Ascending
3	FY	Fiscal Year	Ascending
4	FQ	Fiscal Quarter (Obsolete)	Ascending
5	LT	Ledger Types	Ascending
6	SBL	Subledger - G/L	Ascending
7	SBLT	Subledger Type	Ascending
8	CRCD	Currency Code - From	Ascending

Post Batch+ DescendingDCT +

Element	Alias	Description	Sequence
1	POST	G/L Posted Code	Ascending
2	ICUT	Batch Type	Ascending
3	ICU	Batch Number	Ascending
4	LT	Ledger Types	Ascending
5	DGJ	Date - For G/L (and Voucher) - Julian	Ascending
6	DOC	Document (Voucher Invoice etc.)	Ascending
7	KCO	Document Company	Descending
8	DCT	Document Type	Descending
9	JELN	Journal Entry Line Number	Ascending
10	EXTL	Line Extension Code	Ascending

SBL SBLT LT

Element	Alias	Description	Sequence
1	SBL	Subledger - G/L	Ascending
2	SBLT	Subledger Type	Ascending
3	LT	Ledger Types	Ascending

AccountID Century FiscalYr +A

Element	Alias	Description	Sequence
1	AID	Account ID	Ascending
2	CTRY	Century	Ascending
3	FY	Fiscal Year	Ascending
4	FQ	Fiscal Quarter (Obsolete)	Ascending
5	LT	Ledger Types	Ascending
6	SBLT	Subledger Type	Ascending
7	SBL	Subledger - G/L	Ascending
8	CRCD	Currency Code - From	Ascending

Batch Line_Ext Post_Code

Element	Alias	Description	Sequence
1	ICUT	Batch Type	Ascending
2	ICU	Batch Number	Ascending
3	EXTL	Line Extension Code	Ascending
4	POST	G/L Posted Code	Ascending

AID LT DGJ DCT DOC KCO SBL

Element	Alias	Description	Sequence
1	AID	Account ID	Ascending
2	LT	Ledger Types	Ascending
3	DGJ	Date - For G/L (and Voucher) - Julian	Ascending
4	DCT	Document Type	Ascending
5	DOC	Document (Voucher Invoice etc.)	Ascending
6	KCO	Document Company	Ascending
7	SBL	Subledger - G/L	Ascending
8	SBLT	Subledger Type	Ascending

DCT DOC KCO DGJ LT DISTINCT

Element	Alias	Description	Sequence
1	DCT	Document Type	Ascending
2	DOC	Document (Voucher Invoice etc.)	Ascending
3	KCO	Document Company	Ascending
4	DGJ	Date - For G/L (and Voucher) - Julian	Descending
5	LT	Ledger Types	Ascending

OBJ SUB MCU

Element	Alias	Description	Sequence
1	OBJ	Object Account	Ascending
2	SUB	Subsidiary	Ascending
3	MCU	Business Unit	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

134 COLUMNS | 25 INDEXES | 812 | 00 | F0911 TABLE

TOP 812 | 00 | F0911 COLUMNS

TOP 812 | 00 | F0911 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

134 COLUMNS | 25 INDEXES | 812 | 00 | F0911 TABLE

TOP812 | 00 | F0911 COLUMNS

TOP812 | 00 | F0911 INDEXES

TOP 812 | 00 | F0911 COLUMNS

TOP 812 | 00 | F0911 INDEXES