	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

104 COLUMNS | 2 INDEXES | 812 | 09 | F09UI015 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
09: General Accounting
1	812	F09UI015	GL	104	2	Indexed Computations Multi-Tiered Entries	Work Files	09: General Accounting	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 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, GLREG#, GLPYID, GLUSER, GLPID, GLJOBN, GLUPMJ, GLUPMT, GLYST FROM F09UI015

TOP 812 | 09 | F09UI015 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	GLREG#	Registration Number	Numeric	Generic Edit	8	0	Allow NULL?
98	GLPYID	Payment ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
99	GLUSER	User ID	String	Generic Edit	10	0	Allow NULL?
100	GLPID	Program ID	String	Generic Edit	10	0	Allow NULL?
101	GLJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
102	GLUPMJ	Date - Updated	Date	Generic Edit	6	0
103	GLUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
104	GLYST	Processed Code	Character	UDC (07 YW)	1	0	Allow NULL?

TOP 812 | 09 | F09UI015 INDEXES

Number

Description

F09UI015_1 (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	Ascending
5	LT	Ledger Types	Ascending
6	EXTL	Line Extension Code	Ascending
7	JELN	Journal Entry Line Number	Ascending

F09UI015_2

Element	Alias	Description	Sequence
1	ICU	Batch 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

104 COLUMNS | 2 INDEXES | 812 | 09 | F09UI015 TABLE

TOP 812 | 09 | F09UI015 COLUMNS

TOP 812 | 09 | F09UI015 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

104 COLUMNS | 2 INDEXES | 812 | 09 | F09UI015 TABLE

TOP812 | 09 | F09UI015 COLUMNS

TOP812 | 09 | F09UI015 INDEXES

TOP 812 | 09 | F09UI015 COLUMNS

TOP 812 | 09 | F09UI015 INDEXES