General Ledger Amounts-Daily

The General Ledger Amounts-Daily file contains daily account balances by accounting unit, account, and subaccount for the date specified.
UPDATED BY

GL110	GL120	GL146	GL148	GL167	GL190
GL197	GL300	GL326	GL40.1	GL40.2	GL40.3
GL40.7	GL40.8	GL44.1	GL45.1	GL500	GLOP.1
GL243	GL43.1

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
GAX-COMPANY Element: Company	Numeric 4 The Company field contains the company number this is used in the Organization dimension.	GL110 GL146 GL148 GL167 GL190 GL197 GL326 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1
GAX-DATE Element: Date	Numeric 8 (yyyymmdd) The Date field contains the system date this was created. The Date format used is YYYYMMDD.	GL146 GL148 GL167 GL190 GL197 GL326 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1
GAX-ACCT-UNIT Element: Acct Unit	Alpha 15 The Accounting Unit field contains the name of the accounting unit that is used in the Organization dimension. If this field is blank, all accounting units are included as members in the dimension outline. This name can contain up to 15 alphabetic characters.	GL146 GL148 GL167 GL190 GL197 GL326 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1
GAX-ACCOUNT Element: Account	Numeric 6 This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.	GL146 GL148 GL167 GL190 GL197 GL326 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1
GAX-SUB-ACCOUNT Element: Sub Acct	Numeric 4 This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.	GL146 GL148 GL167 GL190 GL197 GL326 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1
GAX-VAR-LEVELS Element: Var Levels	Alpha 30 A level that represents the location of an accounting unit in an organization's level structure.	GL120 GL146 GL148 GL167 GL190 GL197 GL326 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1
GAX-CHART-NAME Element: Chart Name	Alpha 12 The Chart of Accounts Name field contains the name of the chart of accounts that is used by the Organization dimension. This name can contain up to 12 alphabetic characters.	GL146 GL148 GL167 GL190 GL197 GL326 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1
GAX-DB-AMOUNT Element: Intl Amt	Signed 18.2 The Debit Amount field contains the debit amount.	GL110 GL146 GL148 GL167 GL190 GL197 GL326 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1
GAX-CR-AMOUNT Element: Intl Amt	Signed 18.2 The Credit Amount field contains the credit amount.	GL110 GL146 GL148 GL167 GL190 GL197 GL326 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1
GAX-FISCAL-YEAR Element: Year	Numeric 4 The Fiscal Year field contains the numeric fiscal year. This field can contain up to four numeric characters.	GL146 GL148 GL167 GL190 GL197 GL326 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 GL500
GAX-ACCT-PERIOD Element: Acct Period	Numeric 2 This is the current accounting period. This field is updated by GL199 (Period Closing).	GL146 GL148 GL167 GL190 GL197 GL326 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 GL500
GAX-MAINT-DATE Element: Maint Date	Numeric 8 (yyyymmdd) The Maintenance Date field contains the date that this file was last updated. The date format used is YYYYMMDD.	GL120 GL146 GL148 GL167 GL190 GL197 GL326 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 GL500
GAX-MAINT-TIME Element: Sys Time	Numeric 6 (hhmmss) The Maintenance Time field contains the time that this file was last updated. The time format used is HHMMSS.	GL120 GL146 GL148 GL167 GL190 GL197 GL326 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 GL500
GAX-NET-AMOUNT Element: Net Amount	Derived The net daily base amount. This amount is the debit amount added to the credit amount.

GLAMOUNTSX FILE INDEX

GLAMOUNTSX FILE RELATIONS

ONE TO MANY RELATIONS

All trademarks and registered trademarks are the property of their respective owners.