	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

82 COLUMNS | 14 INDEXES | 812 | 09 | F0901 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
09: General Accounting
1	812	F0901	GM	82	14	Account Master	Master 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 GMCO, GMAID, GMMCU, GMOBJ, GMSUB, GMANS, GMDL01, GMLDA, GMBPC, GMPEC, GMBILL, GMCRCD, GMUM, GMR001, GMR002, GMR003, GMR004, GMR005, GMR006, GMR007, GMR008, GMR009, GMR010, GMR011, GMR012, GMR013, GMR014, GMR015, GMR016, GMR017, GMR018, GMR019, GMR020, GMR021, GMR022, GMR023, GMOBJA, GMSUBA, GMWCMP, GMCCT, GMERC, GMHTC, GMQLDA, GMCCC, GMFMOD, GMUSER, GMPID, GMJOBN, GMUPMJ, GMUPMT, GMCEC1, GMCEC2, GMCEC3, GMCEC4, GMIEC, GMFPEC, GMSTPC, GMTXGL, GMTOBJ, GMTSUB, GMPRGF, GMTXA1, GMR024, GMR025, GMR026, GMR027, GMR028, GMR029, GMR030, GMR031, GMR032, GMR033, GMR034, GMR035, GMR036, GMR037, GMR038, GMR039, GMR040, GMR041, GMR042, GMR043 FROM F0901

TOP 812 | 09 | F0901 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	GMCO	Company	String	Generic Edit	5	Allow NULL?
2	GMAID	Account ID	String	Generic Edit	8	Allow NULL?
3	GMMCU	Business Unit	String	Generic Edit	12	Allow NULL?
4	GMOBJ	Object Account	String	Generic Edit	6	Allow NULL?
5	GMSUB	Subsidiary	String	Generic Edit	8	Allow NULL?
6	GMANS	Account Number - 3rd	String	Generic Edit	25	Allow NULL?
7	GMDL01	Description	String	Generic Edit	30	Allow NULL?
8	GMLDA	Account Level of Detail	Character	Generic Edit	1	Allow NULL?
9	GMBPC	Budget Pattern Code	String	Generic Edit	3	Allow NULL?
10	GMPEC	Posting Edit	Character	UDC (H00 PE)	1	Allow NULL?
11	GMBILL	Billable (Y/N)	Character	UDC (H00 BI)	1	Allow NULL?
12	GMCRCD	Currency Code - From	String	Generic Edit	3	Allow NULL?
13	GMUM	Unit of Measure	String	UDC (00 UM)	2	Allow NULL?
14	GMR001	Category Code - G/L1	String	UDC (09 01)	3	Allow NULL?
15	GMR002	Category Code - G/L2	String	UDC (09 02)	3	Allow NULL?
16	GMR003	Category Code - G/L3	String	UDC (09 03)	3	Allow NULL?
17	GMR004	Category Code - G/L4	String	UDC (09 04)	3	Allow NULL?
18	GMR005	Category Code - G/L5	String	UDC (09 05)	3	Allow NULL?
19	GMR006	Category Code - G/L6	String	UDC (09 06)	3	Allow NULL?
20	GMR007	Category Code - G/L7	String	UDC (09 07)	3	Allow NULL?
21	GMR008	Category Code - G/L8	String	UDC (09 08)	3	Allow NULL?
22	GMR009	Category Code - G/L9	String	UDC (09 09)	3	Allow NULL?
23	GMR010	Category Code - G/L10	String	UDC (09 10)	3	Allow NULL?
24	GMR011	Category Code - G/L11	String	UDC (09 11)	3	Allow NULL?
25	GMR012	Category Code - G/L12	String	UDC (09 12)	3	Allow NULL?
26	GMR013	Category Code - G/L13	String	UDC (09 13)	3	Allow NULL?
27	GMR014	Category Code - G/L14	String	UDC (09 14)	3	Allow NULL?
28	GMR015	Category Code - G/L15	String	UDC (09 15)	3	Allow NULL?
29	GMR016	Category Code - G/L16	String	UDC (09 16)	3	Allow NULL?
30	GMR017	Category Code - G/L17	String	UDC (09 17)	3	Allow NULL?
31	GMR018	Category Code - G/L18	String	UDC (09 18)	3	Allow NULL?
32	GMR019	Category Code - G/L19	String	UDC (09 19)	3	Allow NULL?
33	GMR020	Category Code - G/L20	String	UDC (09 20)	3	Allow NULL?
34	GMR021	Category Code - G/L 021	String	UDC (09 21)	10	Allow NULL?
35	GMR022	Category Code - G/L 022	String	UDC (09 22)	10	Allow NULL?
36	GMR023	Category Code - G/L 023	String	UDC (09 23)	10	Allow NULL?
37	GMOBJA	Object Account - Alternate	String	Generic Edit	6	Allow NULL?
38	GMSUBA	Subsidiary - Alternate	String	Generic Edit	8	Allow NULL?
39	GMWCMP	Worker's Comp. Insurance Code	String	UDC (00 W)	4	Allow NULL?
40	GMCCT	Method of Computation	Character	UDC (51 MC)	1	Allow NULL?
41	GMERC	Equipment Rate Code	String	UDC (00 RC)	2	Allow NULL?
42	GMHTC	Header Type Code	Character	UDC (H00 HT)	1	Allow NULL?
43	GMQLDA	Quantity Roll-Up Level	Character	Generic Edit	1	Allow NULL?
44	GMCCC	Cost Code Complete (Y/N)	Character	Generic Edit	1	Allow NULL?
45	GMFMOD	Model Accounts and Consolidation Flag	Character	UDC (H09 MD)	1	Allow NULL?
46	GMUSER	User ID	String	Generic Edit	10	Allow NULL?
47	GMPID	Program ID	String	Generic Edit	10	Allow NULL?
48	GMJOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
49	GMUPMJ	Date - Updated	Date	Generic Edit	6
50	GMUPMT	Time - Last Updated	Numeric	Generic Edit	6	Allow NULL?
51	GMCEC1	Cost Object Edit Code 01	Character	Generic Edit	1	Allow NULL?
52	GMCEC2	Cost Object Edit Code 02	Character	Generic Edit	1	Allow NULL?
53	GMCEC3	Cost Object Edit Code 03	Character	Generic Edit	1	Allow NULL?
54	GMCEC4	Cost Object Edit Code 04	Character	Generic Edit	1	Allow NULL?
55	GMIEC	Item Edit Code	Character	Generic Edit	1	Allow NULL?
56	GMFPEC	Fixed Asset Posting Edit Code	Character	Generic Edit	1	Allow NULL?
57	GMSTPC	Type Code	Character	Generic Edit	1	Allow NULL?
58	GMTXGL	GL Account Taxable Flag . . . . . . . .	Character	Generic Edit	1	Allow NULL?
59	GMTOBJ	Target Object Account	String	Generic Edit	6	Allow NULL?
60	GMTSUB	Target Subsidiary	String	Generic Edit	8	Allow NULL?
61	GMPRGF	Purge Flag	Character	Generic Edit	1	Allow NULL?
62	GMTXA1	Tax Rate/Area	String	Generic Edit	10	Allow NULL?
63	GMR024	Category Code - G/L 024	String	UDC (09 24)	10	Allow NULL?
64	GMR025	Category Code - G/L 025	String	UDC (09 25)	10	Allow NULL?
65	GMR026	Category Code - G/L 026	String	UDC (09 26)	10	Allow NULL?
66	GMR027	Category Code - G/L 027	String	UDC (09 27)	10	Allow NULL?
67	GMR028	Category Code - G/L 028	String	UDC (09 28)	10	Allow NULL?
68	GMR029	Category Code - G/L 029	String	UDC (09 29)	10	Allow NULL?
69	GMR030	Category Code - G/L 030	String	UDC (09 30)	10	Allow NULL?
70	GMR031	Category Code - G/L 031	String	UDC (09 31)	10	Allow NULL?
71	GMR032	Category Code - G/L 032	String	UDC (09 32)	10	Allow NULL?
72	GMR033	Category Code - G/L 033	String	UDC (09 33)	10	Allow NULL?
73	GMR034	Category Code - G/L 034	String	UDC (09 34)	10	Allow NULL?
74	GMR035	Category Code - G/L 035	String	UDC (09 35)	10	Allow NULL?
75	GMR036	Category Code - G/L 036	String	UDC (09 36)	10	Allow NULL?
76	GMR037	Category Code - G/L 037	String	UDC (09 37)	10	Allow NULL?
77	GMR038	Category Code - G/L 038	String	UDC (09 38)	10	Allow NULL?
78	GMR039	Category Code - G/L 039	String	UDC (09 39)	10	Allow NULL?
79	GMR040	Category Code - G/L 040	String	UDC (09 40)	10	Allow NULL?
80	GMR041	Category Code - G/L 041	String	UDC (09 41)	10	Allow NULL?
81	GMR042	Category Code - G/L 042	String	UDC (09 42)	10	Allow NULL?
82	GMR043	Category Code - G/L 043	String	UDC (09 43)	10	Allow NULL?

TOP 812 | 09 | F0901 INDEXES

Number

Description

Business Unit Object + (Unique)

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	OBJ	Object Account	Ascending
3	SUB	Subsidiary	Ascending

Account Id (Primary/Unique)

Element	Alias	Description	Sequence
1	AID	Account ID	Ascending

Account Number 3rd

Element	Alias	Description	Sequence
1	ANS	Account Number - 3rd	Ascending

Company Object +

Element	Alias	Description	Sequence
1	CO	Company	Ascending
2	OBJ	Object Account	Ascending
3	SUB	Subsidiary	Ascending
4	MCU	Business Unit	Ascending

Company Business Unit +

Element	Alias	Description	Sequence
1	CO	Company	Ascending
2	MCU	Business Unit	Ascending
3	OBJ	Object Account	Ascending
4	SUB	Subsidiary	Ascending

Object Subsidiary + (Unique)

Element	Alias	Description	Sequence
1	OBJ	Object Account	Ascending
2	SUB	Subsidiary	Ascending
3	MCU	Business Unit	Ascending

Subsidiary Object +

Element	Alias	Description	Sequence
1	SUB	Subsidiary	Ascending
2	OBJ	Object Account	Ascending
3	CO	Company	Ascending

Subsidiary Company +

Element	Alias	Description	Sequence
1	SUB	Subsidiary	Ascending
2	CO	Company	Ascending
3	OBJ	Object Account	Ascending

Business Unit Sub Object (Unique)

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	SUB	Subsidiary	Ascending
3	OBJ	Object Account	Ascending

Code 1 Sub +

Element	Alias	Description	Sequence
1	R001	Category Code - G/L1	Ascending
2	SUB	Subsidiary	Ascending
3	OBJ	Object Account	Ascending
4	MCU	Business Unit	Ascending

Code 2 Sub +

Element	Alias	Description	Sequence
1	R002	Category Code - G/L2	Ascending
2	SUB	Subsidiary	Ascending
3	OBJ	Object Account	Ascending
4	MCU	Business Unit	Ascending

Code 3 Sub +

Element	Alias	Description	Sequence
1	R003	Category Code - G/L3	Ascending
2	SUB	Subsidiary	Ascending
3	OBJ	Object Account	Ascending
4	MCU	Business Unit	Ascending

Code A Sub +

Element	Alias	Description	Sequence
1	SUBA	Subsidiary - Alternate	Ascending
2	SUB	Subsidiary	Ascending
3	OBJ	Object Account	Ascending
4	MCU	Business Unit	Ascending

Code C Obj +

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

82 COLUMNS | 14 INDEXES | 812 | 09 | F0901 TABLE

TOP 812 | 09 | F0901 COLUMNS

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

82 COLUMNS | 14 INDEXES | 812 | 09 | F0901 TABLE

TOP812 | 09 | F0901 COLUMNS

TOP812 | 09 | F0901 INDEXES

TOP 812 | 09 | F0901 COLUMNS

TOP 812 | 09 | F0901 INDEXES