	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 | 2 INDEXES | 812 | 09 | F0902B TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
09: General Accounting
1	812	F0902B	GB	82	2	Account Balances - 52 Period Accounting	Extra Features 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 GBAID, GBCTRY, GBFY, GBFQ, GBLT, GBSBL, GBCO, GBAPYC, GBAN01, GBAN02, GBAN03, GBAN04, GBAN05, GBAN06, GBAN07, GBAN08, GBAN09, GBAN10, GBAN11, GBAN12, GBAN13, GBAN14, GBAN15, GBAN16, GBAN17, GBAN18, GBAN19, GBAN20, GBAN21, GBAN22, GBAN23, GBAN24, GBAN25, GBAN26, GBAN27, GBAN28, GBAN29, GBAN30, GBAN31, GBAN32, GBAN33, GBAN34, GBAN35, GBAN36, GBAN37, GBAN38, GBAN39, GBAN40, GBAN41, GBAN42, GBAN43, GBAN44, GBAN45, GBAN46, GBAN47, GBAN48, GBAN49, GBAN50, GBAN51, GBAN52, GBAN53, GBAN54, GBAPYN, GBAWTD, GBBORG, GBPOU, GBPC, GBTKER, GBBREQ, GBBAPR, GBMCU, GBOBJ, GBSUB, GBUSER, GBPID, GBUPMJ, GBJOBN, GBSBLT, GBUPMT, GBCRCD, GBCRCX, GBPRGF FROM F0902B

TOP 812 | 09 | F0902B COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	GBAID	Account ID	String	Generic Edit	8	0	Allow NULL?
2	GBCTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
3	GBFY	Fiscal Year	Numeric	Generic Edit	2	0	Allow NULL?
4	GBFQ	Fiscal Quarter (Obsolete)	String	UDC (H09 FQ)	4	0	Allow NULL?
5	GBLT	Ledger Types	String	UDC (09 LT)	2	0	Allow NULL?
6	GBSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
7	GBCO	Company	String	Generic Edit	5	0	Allow NULL?
8	GBAPYC	Amount - Beginning Balance/PYE Forward	Numeric	Generic Edit	15	2	Allow NULL?
9	GBAN01	Amount - Net Posting 01	Numeric	Generic Edit	15	2	Allow NULL?
10	GBAN02	Amount - Net Posting 02	Numeric	Generic Edit	15	2	Allow NULL?
11	GBAN03	Amount - Net Posting 03	Numeric	Generic Edit	15	2	Allow NULL?
12	GBAN04	Amount - Net Posting 04	Numeric	Generic Edit	15	2	Allow NULL?
13	GBAN05	Amount - Net Posting 05	Numeric	Generic Edit	15	2	Allow NULL?
14	GBAN06	Amount - Net Posting 06	Numeric	Generic Edit	15	2	Allow NULL?
15	GBAN07	Amount - Net Posting 07	Numeric	Generic Edit	15	2	Allow NULL?
16	GBAN08	Amount - Net Posting 08	Numeric	Generic Edit	15	2	Allow NULL?
17	GBAN09	Amount - Net Posting 09	Numeric	Generic Edit	15	2	Allow NULL?
18	GBAN10	Amount - Net Posting 10	Numeric	Generic Edit	15	2	Allow NULL?
19	GBAN11	Amount - Net Posting 11	Numeric	Generic Edit	15	2	Allow NULL?
20	GBAN12	Amount - Net Posting 12	Numeric	Generic Edit	15	2	Allow NULL?
21	GBAN13	Amount - Net Posting 13	Numeric	Generic Edit	15	2	Allow NULL?
22	GBAN14	Amount - Net Posting 14	Numeric	Generic Edit	15	2	Allow NULL?
23	GBAN15	Amount - Net Posting 15	Numeric	Generic Edit	15	2	Allow NULL?
24	GBAN16	Amount - Net Posting 16	Numeric	Generic Edit	15	2	Allow NULL?
25	GBAN17	Amount - Net Posting 17	Numeric	Generic Edit	15	2	Allow NULL?
26	GBAN18	Amount - Net Posting 18	Numeric	Generic Edit	15	2	Allow NULL?
27	GBAN19	Amount - Net Posting 19	Numeric	Generic Edit	15	2	Allow NULL?
28	GBAN20	Amount - Net Posting 20	Numeric	Generic Edit	15	2	Allow NULL?
29	GBAN21	Amount - Net Posting 21	Numeric	Generic Edit	15	2	Allow NULL?
30	GBAN22	Amount - Net Posting 22	Numeric	Generic Edit	15	2	Allow NULL?
31	GBAN23	Amount - Net Posting 23	Numeric	Generic Edit	15	2	Allow NULL?
32	GBAN24	Amount - Net Posting 24	Numeric	Generic Edit	15	2	Allow NULL?
33	GBAN25	Amount - Net Posting 25	Numeric	Generic Edit	15	2	Allow NULL?
34	GBAN26	Amount - Net Posting 26	Numeric	Generic Edit	15	2	Allow NULL?
35	GBAN27	Amount - Net Posting 27	Numeric	Generic Edit	15	2	Allow NULL?
36	GBAN28	Amount - Net Posting 28	Numeric	Generic Edit	15	2	Allow NULL?
37	GBAN29	Amount - Net Posting 29	Numeric	Generic Edit	15	2	Allow NULL?
38	GBAN30	Amount - Net Posting 30	Numeric	Generic Edit	15	2	Allow NULL?
39	GBAN31	Amount - Net Posting 31	Numeric	Generic Edit	15	2	Allow NULL?
40	GBAN32	Amount - Net Posting 32	Numeric	Generic Edit	15	2	Allow NULL?
41	GBAN33	Amount - Net Posting 33	Numeric	Generic Edit	15	2	Allow NULL?
42	GBAN34	Amount - Net Posting 34	Numeric	Generic Edit	15	2	Allow NULL?
43	GBAN35	Amount - Net Posting 35	Numeric	Generic Edit	15	2	Allow NULL?
44	GBAN36	Amount - Net Posting 36	Numeric	Generic Edit	15	2	Allow NULL?
45	GBAN37	Amount - Net Posting 37	Numeric	Generic Edit	15	2	Allow NULL?
46	GBAN38	Amount - Net Posting 38	Numeric	Generic Edit	15	2	Allow NULL?
47	GBAN39	Amount - Net Posting 39	Numeric	Generic Edit	15	2	Allow NULL?
48	GBAN40	Amount - Net Posting 40	Numeric	Generic Edit	15	2	Allow NULL?
49	GBAN41	Amount - Net Posting 41	Numeric	Generic Edit	15	2	Allow NULL?
50	GBAN42	Amount - Net Posting 42	Numeric	Generic Edit	15	2	Allow NULL?
51	GBAN43	Amount - Net Posting 43	Numeric	Generic Edit	15	2	Allow NULL?
52	GBAN44	Amount - Net Posting 44	Numeric	Generic Edit	15	2	Allow NULL?
53	GBAN45	Amount - Net Posting 45	Numeric	Generic Edit	15	2	Allow NULL?
54	GBAN46	Amount - Net Posting 46	Numeric	Generic Edit	15	2	Allow NULL?
55	GBAN47	Amount - Net Posting 47	Numeric	Generic Edit	15	2	Allow NULL?
56	GBAN48	Amount - Net Posting 48	Numeric	Generic Edit	15	2	Allow NULL?
57	GBAN49	Amount - Net Posting 49	Numeric	Generic Edit	15	2	Allow NULL?
58	GBAN50	Amount - Net Posting 50	Numeric	Generic Edit	15	2	Allow NULL?
59	GBAN51	Amount - Net Posting 51	Numeric	Generic Edit	15	2	Allow NULL?
60	GBAN52	Amount - Net Posting 52	Numeric	Generic Edit	15	2	Allow NULL?
61	GBAN53	Amount - Net Posting 53	Numeric	Generic Edit	15	2	Allow NULL?
62	GBAN54	Amount - Net Posting 54	Numeric	Generic Edit	15	2	Allow NULL?
63	GBAPYN	Amount - Prior Year Net Postings	Numeric	Generic Edit	15	2	Allow NULL?
64	GBAWTD	Amount - Week-to-Date	Numeric	Generic Edit	15	2	Allow NULL?
65	GBBORG	Amount - Original/Beginning Budget	Numeric	Generic Edit	15	2	Allow NULL?
66	GBPOU	Amount - Memo Budget Changes	Numeric	Generic Edit	15	2	Allow NULL?
67	GBPC	Percent Complete	Numeric	Generic Edit	5	0	Allow NULL?
68	GBTKER	Amount - Memo Commitment Changes	Numeric	Generic Edit	15	2	Allow NULL?
69	GBBREQ	Budget - Requested	Numeric	Generic Edit	15	2	Allow NULL?
70	GBBAPR	Budget - Approved	Numeric	Generic Edit	15	2	Allow NULL?
71	GBMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
72	GBOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
73	GBSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
74	GBUSER	User ID	String	Generic Edit	10	0	Allow NULL?
75	GBPID	Program ID	String	Generic Edit	10	0	Allow NULL?
76	GBUPMJ	Date - Updated	Date	Generic Edit	6	0
77	GBJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
78	GBSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
79	GBUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
80	GBCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
81	GBCRCX	Currency Code - Denominated In	String	Generic Edit	3	0	Allow NULL?
82	GBPRGF	Purge Flag	Character	Generic Edit	1	0	Allow NULL?

TOP 812 | 09 | F0902B INDEXES

Number

Description

Account ID Century +A (Primary/Unique)

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

Business Unit Object +A

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

TOP 812 | 09 | F0902B COLUMNS

TOP 812 | 09 | F0902B 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 | 2 INDEXES | 812 | 09 | F0902B TABLE

TOP812 | 09 | F0902B COLUMNS

TOP812 | 09 | F0902B INDEXES

TOP 812 | 09 | F0902B COLUMNS

TOP 812 | 09 | F0902B INDEXES