	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

89 COLUMNS | 6 INDEXES | 920 | 09 | F0911R TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
09: General Accounting
1	920	F0911R	GL	89	6	WF - Account Ledger Reconciliation	Regular Work 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 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, GLAA, GLU, GLUM, GLGLC, GLRE, GLEXA, GLEXR, GLR1, GLR2, GLR3, GLSFX, GLAN8, GLCN, GLDKJ, GLASID, GLBRE, GLRCND, GLSUMM, GLPRGE, GLTNN, GLBC, GLPO, GLPSFX, GLDOI, GLALID, GLALTY, GLDSVJ, GLUSER, GLTORG, GLRRNO, GLAA1, GLBCRC, GLABR1, GLABT1, GLABR2, GLABT2, GLABR3, GLABT3, GLABR4, GLABT4, GLITM, GLCRRM, GLTXA1, GLEXR1, GLTXITM, GLACTB, GLGPF1, GLACR, GLCKNU, GLRC5, GLSFXE, GLOFM, GLDKC, GLLNID, GLPKCO, GLPDCT, GLOSFX, GLALT5, GLPID, GLJOBN, GLUPMJ, GLUPMT FROM F0911R

TOP 920 | 09 | F0911R 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	GLAA	Amount	Numeric	Generic Edit	15	2	Allow NULL?
29	GLU	Units	Numeric	Generic Edit	15	2	Allow NULL?
30	GLUM	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
31	GLGLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
32	GLRE	Reverse or Void (R/V)	Character	UDC (H09 RE)	1	0	Allow NULL?
33	GLEXA	Name - Alpha Explanation	String	Generic Edit	30	0	Allow NULL?
34	GLEXR	Name - Remark Explanation	String	Generic Edit	30	0	Allow NULL?
35	GLR1	Reference 1 - JE Voucher Invoice etc.	String	Generic Edit	8	0	Allow NULL?
36	GLR2	Reference 2	String	Generic Edit	8	0	Allow NULL?
37	GLR3	Reference 3 - Account Reconciliation	String	Generic Edit	8	0	Allow NULL?
38	GLSFX	Document Pay Item	String	Generic Edit	3	0	Allow NULL?
39	GLAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
40	GLCN	Payment Number	String	Generic Edit	8	0	Allow NULL?
41	GLDKJ	Date - Check - Julian	Date	Generic Edit	6	0
42	GLASID	Serial Number	String	Generic Edit	25	0	Allow NULL?
43	GLBRE	Batch Rear End Posted Code	Character	UDC (09 BR)	1	0	Allow NULL?
44	GLRCND	Reconciled Code	Character	UDC (09 RC)	1	0	Allow NULL?
45	GLSUMM	Summarized Code	Character	Generic Edit	1	0	Allow NULL?
46	GLPRGE	Purge Code	Character	Generic Edit	1	0	Allow NULL?
47	GLTNN	Flag for 1099	Character	Generic Edit	1	0	Allow NULL?
48	GLBC	Bill Code	Character	UDC (98 BC)	1	0	Allow NULL?
49	GLPO	Purchase Order	String	Generic Edit	8	0	Allow NULL?
50	GLPSFX	Purchase Order Suffix	String	Generic Edit	3	0	Allow NULL?
51	GLDOI	DOI Sub	Numeric	Generic Edit	2	0	Allow NULL?
52	GLALID	Outsider Lease or Well ID	String	Generic Edit	25	0	Allow NULL?
53	GLALTY	ID Type	String	UDC (00 AL)	2	0	Allow NULL?
54	GLDSVJ	Date - Service/Tax	Date	Generic Edit	6	0
55	GLUSER	User ID	String	Generic Edit	10	0	Allow NULL?
56	GLTORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
57	GLRRNO	Relative Record Number	Numeric	Generic Edit	15	0	Allow NULL?
58	GLAA1	Amount	Numeric	Generic Edit	15	2	Allow NULL?
59	GLBCRC	Currency Code - Base	String	Generic Edit	3	0	Allow NULL?
60	GLABR1	Managerial Analysis Code 1	String	Generic Edit	12	0	Allow NULL?
61	GLABT1	Managerial Analysis Type 1	Character	UDC	1	0	Allow NULL?
62	GLABR2	Managerial Analysis Code 2	String	Generic Edit	12	0	Allow NULL?
63	GLABT2	Managerial Analysis Type 2	Character	UDC	1	0	Allow NULL?
64	GLABR3	Managerial Analysis Code 3	String	Generic Edit	12	0	Allow NULL?
65	GLABT3	Managerial Analysis Type 3	Character	UDC	1	0	Allow NULL?
66	GLABR4	Managerial Analysis Code 4	String	Generic Edit	12	0	Allow NULL?
67	GLABT4	Managerial Analysis Type 4	Character	UDC	1	0	Allow NULL?
68	GLITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
69	GLCRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
70	GLTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
71	GLEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
72	GLTXITM	Tax - Short Item Number	Numeric	Generic Edit	8	0	Allow NULL?
73	GLACTB	Activity-Based Costing Activity Code	String	Generic Edit	10	0	Allow NULL?
74	GLGPF1	Inventory Flag	Character	Generic Edit	1	0	Allow NULL?
75	GLACR	Amount - Currency	Numeric	Generic Edit	15	2	Allow NULL?
76	GLCKNU	Receipt Number	String	Generic Edit	25	0	Allow NULL?
77	GLRC5	File Line Identifier 5.0	Numeric	Generic Edit	5	0	Allow NULL?
78	GLSFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0	Allow NULL?
79	GLOFM	Auto Offset Method (S Y or B)	Character	Generic Edit	1	0	Allow NULL?
80	GLDKC	Date - Check Cleared	Date	Generic Edit	6	0
81	GLLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
82	GLPKCO	Document Company (Purchase Order)	String	Generic Edit	5	0	Allow NULL?
83	GLPDCT	Document Type - Purchase Order	String	UDC (00 DT)	2	0	Allow NULL?
84	GLOSFX	Document Pay Item - Original	String	Generic Edit	3	0	Allow NULL?
85	GLALT5	G/L Posting Code - Alternate 5	Character	Generic Edit	1	0	Allow NULL?
86	GLPID	Program ID	String	Generic Edit	10	0	Allow NULL?
87	GLJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
88	GLUPMJ	Date - Updated	Date	Generic Edit	6	0
89	GLUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?

TOP 920 | 09 | F0911R INDEXES

Number

Description

Document Company Type + (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

Account ID

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

RCND LT AID ICUT DCT DOC JELN+

Element	Alias	Description	Sequence
1	RCND	Reconciled Code	Ascending
2	LT	Ledger Types	Ascending
3	AID	Account ID	Ascending
4	ICUT	Batch Type	Ascending
5	DCT	Document Type	Ascending
6	DOC	Document (Voucher Invoice etc.)	Ascending
7	JELN	Journal Entry Line Number	Ascending
8	ALT5	G/L Posting Code - Alternate 5	Ascending
9	OFM	Auto Offset Method (S Y or B)	Ascending

RCND LT DCT DOC SFX ICUT ICU+

Element	Alias	Description	Sequence
1	RCND	Reconciled Code	Ascending
2	LT	Ledger Types	Ascending
3	DCT	Document Type	Ascending
4	DOC	Document (Voucher Invoice etc.)	Ascending
5	SFX	Document Pay Item	Ascending
6	ICUT	Batch Type	Ascending
7	ICU	Batch Number	Ascending
8	KCO	Document Company	Ascending
9	SFXE	Pay Item Extension Number	Ascending
10	RC5	File Line Identifier 5.0	Ascending

AUDIT+ AID R3 DKC DGJ DOC+

Element	Alias	Description	Sequence
1	PID	Program ID	Ascending
2	USER	User ID	Ascending
3	JOBN	Work Station ID	Ascending
4	UPMJ	Date - Updated	Ascending
5	UPMT	Time - Last Updated	Ascending
6	AID	Account ID	Ascending
7	R3	Reference 3 - Account Reconciliation	Ascending
8	DKC	Date - Check Cleared	Ascending
9	DGJ	Date - For G/L (and Voucher) - Julian	Ascending
10	DOC	Document (Voucher Invoice etc.)	Ascending
11	JELN	Journal Entry Line Number	Ascending

RCND LT AID DCT DOC KCO ALT5

Element	Alias	Description	Sequence
1	RCND	Reconciled Code	Ascending
2	LT	Ledger Types	Ascending
3	AID	Account ID	Ascending
4	DCT	Document Type	Ascending
5	DOC	Document (Voucher Invoice etc.)	Ascending
6	KCO	Document Company	Ascending
7	ALT5	G/L Posting Code - Alternate 5	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

89 COLUMNS | 6 INDEXES | 920 | 09 | F0911R TABLE

TOP 920 | 09 | F0911R COLUMNS

TOP 920 | 09 | F0911R 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

89 COLUMNS | 6 INDEXES | 920 | 09 | F0911R TABLE

TOP920 | 09 | F0911R COLUMNS

TOP920 | 09 | F0911R INDEXES

TOP 920 | 09 | F0911R COLUMNS

TOP 920 | 09 | F0911R INDEXES