ERPRef.com

82 COLUMNS | 2 INDICIES 910 | 09 | F0902B Account Balances - 52 Period Accounting

Schema	Name	Prefix	Columns	Indicies	Description	Type	Report	Category
910	F0902B	GB	82	2	Account Balances - 52 Period Accounting	Extra Features 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.

82 COLUMNS | TOP 910 | 09 | F0902B Account Balances - 52 Period Accounting

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

2 INDICIES | TOP 910 | 09 | F0902B Account Balances - 52 Period Accounting

1: 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

2: Business Unit Object +A

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