ERPRef.com

56 COLUMNS | 9 INDICIES 920 | 00 | F0902 Account Balances

Schema	Name	Prefix	Columns	Indicies	Description	Type	Report	Category
920	F0902	GB	56	9	Account Balances	Balance Files	09: General Accounting	Business Data

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.

56 COLUMNS | TOP 920 | 00 | F0902 Account Balances

	Col#	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement

9 INDICIES | TOP 920 | 00 | F0902 Account Balances

1: Account ID Century + (Primary/Unique)

Element	Alias	Description	Sequence
8	CRCD	Currency Code - From	Ascending
7	SBLT	Subledger Type	Ascending
6	SBL	Subledger - G/L	Ascending
5	LT	Ledger Types	Ascending
4	FQ	Fiscal Quarter (Obsolete)	Ascending
3	FY	Fiscal Year	Ascending
2	CTRY	Century	Ascending
1	AID	Account ID	Ascending

2: Account ID Century +B

Element	Alias	Description	Sequence
6	CRCD	Currency Code - From	Ascending
5	LT	Ledger Types	Ascending
4	FQ	Fiscal Quarter (Obsolete)	Ascending
3	FY	Fiscal Year	Ascending
2	CTRY	Century	Ascending
1	AID	Account ID	Ascending

3: Subledger Subledger Type +

Element	Alias	Description	Sequence
10	CRCD	Currency Code - From	Ascending
9	FQ	Fiscal Quarter (Obsolete)	Ascending
8	FY	Fiscal Year	Ascending
7	CTRY	Century	Ascending
6	SUB	Subsidiary	Ascending
5	OBJ	Object Account	Ascending
4	MCU	Business Unit	Ascending
3	LT	Ledger Types	Ascending
2	SBLT	Subledger Type	Ascending
1	SBL	Subledger - G/L	Ascending

4: LF CO MCU OBJ SUB SBL SBLT CTR

Element	Alias	Description	Sequence
11	CRCD	Currency Code - From	Ascending
10	LT	Ledger Types	Ascending
9	FQ	Fiscal Quarter (Obsolete)	Ascending
8	FY	Fiscal Year	Ascending
7	CTRY	Century	Ascending
6	SBLT	Subledger Type	Ascending
5	SBL	Subledger - G/L	Ascending
4	SUB	Subsidiary	Ascending
3	OBJ	Object Account	Ascending
2	MCU	Business Unit	Ascending
1	CO	Company	Ascending

5: Cost Center Object +A

Element	Alias	Description	Sequence
11	CRCD	Currency Code - From	Ascending
10	CRCX	Currency Code - Denominated In	Ascending
9	SBLT	Subledger Type	Ascending
8	SBL	Subledger - G/L	Ascending
7	LT	Ledger Types	Ascending
6	FQ	Fiscal Quarter (Obsolete)	Ascending
5	FY	Fiscal Year	Ascending
4	CTRY	Century	Ascending
3	SUB	Subsidiary	Ascending
2	OBJ	Object Account	Ascending
1	MCU	Business Unit	Ascending

6: Cost Center Object +B

Element	Alias	Description	Sequence
11	SBLT	Subledger Type	Ascending
10	SBL	Subledger - G/L	Ascending
9	CRCD	Currency Code - From	Ascending
8	CRCX	Currency Code - Denominated In	Ascending
7	LT	Ledger Types	Ascending
6	FQ	Fiscal Quarter (Obsolete)	Ascending
5	FY	Fiscal Year	Ascending
4	CTRY	Century	Ascending
3	SUB	Subsidiary	Ascending
2	OBJ	Object Account	Ascending
1	MCU	Business Unit	Ascending

7: Company Business Unit +

Element	Alias	Description	Sequence
8	FY	Fiscal Year	Ascending
7	CTRY	Century	Ascending
6	SBLT	Subledger Type	Ascending
5	SBL	Subledger - G/L	Ascending
4	LT	Ledger Types	Ascending
3	AID	Account ID	Ascending
2	MCU	Business Unit	Ascending
1	CO	Company	Ascending

8: Account ID Century +C

Element	Alias	Description	Sequence
8	CRCD	Currency Code - From	Ascending
7	SBL	Subledger - G/L	Ascending
6	SBLT	Subledger Type	Ascending
5	LT	Ledger Types	Ascending
4	FQ	Fiscal Quarter (Obsolete)	Ascending
3	FY	Fiscal Year	Ascending
2	CTRY	Century	Ascending
1	AID	Account ID	Ascending

9: Account ID Ledger Subledger+

Element	Alias	Description	Sequence
4	SBL	Subledger - G/L	Ascending
3	SBLT	Subledger Type	Ascending
2	LT	Ledger Types	Ascending
1	AID	Account ID	Ascending