	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

68 COLUMNS | 3 INDEXES | 920 | 05T | F063951 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
05T: Time Entry
1	920	F063951	GL	68	3	Payroll Journal (Compressed) File	Work Files	05T: Time Entry	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 GLPOST, GLUSER, GLANI, GLCTRY, GLFY, GLCO, GLLT, GLSBL, GLAM, GLR1, GLR2, GLDCT, GLAN8, GLASID, GLDGJ, GLPN, GLEXA, GLEXR, GLAA, GLU, GLJELN, GLMCU, GLOBJ, GLSUB, GLSBLT, GLWR01, GLJBCD, GLJBST, GLHMCU, GLCRCD, GLCRR, GLPID, GLUPMJ, GLKCO, GLICU, GLLNID, GLCRDC, GLACR, GLCRRM, GLLDED, GLEPGC, GLJPGC, GLPJRDT01, GLPJRDT02, GLPJRDT03, GLPJRMN01, GLPJRMN02, GLPJRMN03, GLPJRMN04, GLPJRST01, GLPJRST02, GLPJRST03, GLPJRST04, GLPJRST05, GLPJRST06, GLPJRCH01, GLPJRCH02, GLPJRCH03, GLPJRCH04, GLACTB, GLABR1, GLABR2, GLABR3, GLABR4, GLABT1, GLABT2, GLABT3, GLABT4 FROM F063951

TOP 920 | 05T | F063951 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	GLPOST	G/L Posted Code	Character	Generic Edit	1	0	Allow NULL?
2	GLUSER	User ID	String	Generic Edit	10	0	Allow NULL?
3	GLANI	Account Number - Input (Mode Unknown)	String	Generic Edit	29	0	Allow NULL?
4	GLCTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
5	GLFY	Fiscal Year	Numeric	Generic Edit	2	0	Allow NULL?
6	GLCO	Company	String	Generic Edit	5	0	Allow NULL?
7	GLLT	Ledger Types	String	UDC (09 LT)	2	0	Allow NULL?
8	GLSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
9	GLAM	Account Mode - G/L	Character	UDC (H09 AM)	1	0	Allow NULL?
10	GLR1	Reference 1 - JE Voucher Invoice etc.	String	Generic Edit	8	0	Allow NULL?
11	GLR2	Reference 2	String	Generic Edit	8	0	Allow NULL?
12	GLDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
13	GLAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
14	GLASID	Serial Number	String	Generic Edit	25	0	Allow NULL?
15	GLDGJ	Date - For G/L (and Voucher) - Julian	Date	Generic Edit	6	0
16	GLPN	Period Number - General Ledger	Numeric	Generic Edit	2	0	Allow NULL?
17	GLEXA	Name - Alpha Explanation	String	Generic Edit	30	0	Allow NULL?
18	GLEXR	Name - Remark Explanation	String	Generic Edit	30	0	Allow NULL?
19	GLAA	Amount	Numeric	Generic Edit	15	2	Allow NULL?
20	GLU	Units	Numeric	Generic Edit	15	2	Allow NULL?
21	GLJELN	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
22	GLMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
23	GLOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
24	GLSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
25	GLSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
26	GLWR01	Categories - Work Order 01	String	UDC (00 W1)	4	0	Allow NULL?
27	GLJBCD	Job Type (Craft) Code	String	UDC (06 G)	6	0	Allow NULL?
28	GLJBST	Job Step	String	UDC (06 GS)	4	0	Allow NULL?
29	GLHMCU	Business Unit - Home	String	Generic Edit	12	0	Allow NULL?
30	GLCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
31	GLCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
32	GLPID	Program ID	String	Generic Edit	10	0	Allow NULL?
33	GLUPMJ	Date - Updated	Date	Generic Edit	6	0
34	GLKCO	Document Company	String	Generic Edit	5	0	Allow NULL?
35	GLICU	Batch Number	Numeric	Generic Edit	8	0	Allow NULL?
36	GLLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
37	GLCRDC	Currency Code - To	String	Generic Edit	3	0	Allow NULL?
38	GLACR	Amount - Currency	Numeric	Generic Edit	15	2	Allow NULL?
39	GLCRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
40	GLLDED	Labor Period Ending Date	Date	Generic Edit	6	0
41	GLEPGC	Employee Pool Grouping Code	String	UDC (00 12)	3	0	Allow NULL?
42	GLJPGC	Job Pool Grouping Code	String	UDC (00 12)	3	0	Allow NULL?
43	GLPJRDT01	Payroll Journal Generic Date 01	Date	Generic Edit	6	0
44	GLPJRDT02	Payroll Journal Generic Date 02	Date	Generic Edit	6	0
45	GLPJRDT03	Payroll Journal Generic Date 03	Date	Generic Edit	6	0
46	GLPJRMN01	Journal Entry Payroll Transaction Number	Numeric	Generic Edit	15	2	Allow NULL?
47	GLPJRMN02	Payroll Journal Generic Math Numeric 02	Numeric	Generic Edit	15	2	Allow NULL?
48	GLPJRMN03	Payroll Journal Generic Math Numeric 03	Numeric	Generic Edit	15	2	Allow NULL?
49	GLPJRMN04	Payroll Journal Generic Math Numeric 04	Numeric	Generic Edit	15	2	Allow NULL?
50	GLPJRST01	Recharge Currency Code Sequencer	String	Generic Edit	10	0	Allow NULL?
51	GLPJRST02	Payroll Journal Generic String 02	String	Generic Edit	10	0	Allow NULL?
52	GLPJRST03	Payroll Journal Generic String 03	String	Generic Edit	10	0	Allow NULL?
53	GLPJRST04	Payroll Journal Generic String 04	String	Generic Edit	10	0	Allow NULL?
54	GLPJRST05	Payroll Journal Generic String 05	String	Generic Edit	20	0	Allow NULL?
55	GLPJRST06	Payroll Journal Generic String 06	String	Generic Edit	20	0	Allow NULL?
56	GLPJRCH01	Payroll Journal Generic Character 01	Character	Generic Edit	1	0	Allow NULL?
57	GLPJRCH02	Payroll Journal Generic Character 02	Character	Generic Edit	1	0	Allow NULL?
58	GLPJRCH03	Payroll Journal Generic Character 03	Character	Generic Edit	1	0	Allow NULL?
59	GLPJRCH04	Payroll Journal Generic Character 04	Character	Generic Edit	1	0	Allow NULL?
60	GLACTB	Activity-Based Costing Activity Code	String	Generic Edit	10	0	Allow NULL?
61	GLABR1	Managerial Analysis Code 1	String	Generic Edit	12	0	Allow NULL?
62	GLABR2	Managerial Analysis Code 2	String	Generic Edit	12	0	Allow NULL?
63	GLABR3	Managerial Analysis Code 3	String	Generic Edit	12	0	Allow NULL?
64	GLABR4	Managerial Analysis Code 4	String	Generic Edit	12	0	Allow NULL?
65	GLABT1	Managerial Analysis Type 1	Character	UDC	1	0	Allow NULL?
66	GLABT2	Managerial Analysis Type 2	Character	UDC	1	0	Allow NULL?
67	GLABT3	Managerial Analysis Type 3	Character	UDC	1	0	Allow NULL?
68	GLABT4	Managerial Analysis Type 4	Character	UDC	1	0	Allow NULL?

TOP 920 | 05T | F063951 INDEXES

Number

Description

Batch Number Line Number (Primary/Unique)

Element	Alias	Description	Sequence
1	ICU	Batch Number	Ascending
2	LNID	Line Number	Ascending

Cost Center Object

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	OBJ	Object Account	Ascending
3	SUB	Subsidiary	Ascending
4	SBL	Subledger - G/L	Ascending
5	WR01	Categories - Work Order 01	Ascending
6	SBLT	Subledger Type	Ascending
7	CTRY	Century	Ascending
8	FY	Fiscal Year	Ascending
9	PN	Period Number - General Ledger	Ascending
10	DGJ	Date - For G/L (and Voucher) - Julian	Ascending
11	DCT	Document Type	Ascending
12	JBCD	Job Type (Craft) Code	Ascending
13	JBST	Job Step	Ascending
14	AN8	Address Number	Ascending
15	HMCU	Business Unit - Home	Ascending
16	LNID	Line Number	Ascending

Cost Center Object A

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	OBJ	Object Account	Ascending
3	SUB	Subsidiary	Ascending
4	SBL	Subledger - G/L	Ascending
5	SBLT	Subledger Type	Ascending
6	WR01	Categories - Work Order 01	Ascending
7	CTRY	Century	Ascending
8	FY	Fiscal Year	Ascending
9	PN	Period Number - General Ledger	Ascending
10	DGJ	Date - For G/L (and Voucher) - Julian	Ascending
11	DCT	Document Type	Ascending
12	R2	Reference 2	Ascending
13	AN8	Address Number	Ascending
14	JBCD	Job Type (Craft) Code	Ascending
15	JBST	Job Step	Ascending
16	HMCU	Business Unit - Home	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

68 COLUMNS | 3 INDEXES | 920 | 05T | F063951 TABLE

TOP 920 | 05T | F063951 COLUMNS

TOP 920 | 05T | F063951 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

68 COLUMNS | 3 INDEXES | 920 | 05T | F063951 TABLE

TOP920 | 05T | F063951 COLUMNS

TOP920 | 05T | F063951 INDEXES

TOP 920 | 05T | F063951 COLUMNS

TOP 920 | 05T | F063951 INDEXES