General Ledger Amounts Daily
The General Ledger Amounts-Daily file contains daily account balances by accounting unit, account, and subaccount for the date specified.
REFERENCED BY
GLOP.1 | GL243 | GL43.1 |
GL110 | GL120 | GL146 | GL148 | GL167 | GL190 |
GL197 | GL300 | GL326 | GL40.1 | GL40.2 | GL40.3 |
GL40.7 | GL40.8 | GL44.1 | GL45.1 | GL500 |
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. |
|
||||||||||||||||
GAX-DATE Element: Date | Numeric 8 (yyyymmdd) The Date field contains the system date this was created. The Date format used is YYYYMMDD. |
|
||||||||||||||||
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. |
|
||||||||||||||||
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. |
|
||||||||||||||||
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. |
|
||||||||||||||||
GAX-VAR-LEVELS Element: Var Levels | Alpha 30 A level that represents the location of an accounting unit in an organization's level structure. |
|
||||||||||||||||
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. |
|
||||||||||||||||
GAX-DB-AMOUNT Element: Intl Amt | Signed 18.2 The Debit Amount field contains the debit amount. |
|
||||||||||||||||
GAX-CR-AMOUNT Element: Intl Amt | Signed 18.2 The Credit Amount field contains the credit amount. |
|
||||||||||||||||
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. |
|
||||||||||||||||
GAX-ACCT-PERIOD Element: Acct Period | Numeric 2 This is the current accounting period. This field is updated by GL199 (Period Closing). |
|
||||||||||||||||
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. |
|
||||||||||||||||
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. |
|
||||||||||||||||
GAX-NET-AMOUNT Element: Net Amount | Derived The net daily base amount. This amount is the debit amount added to the credit amount. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
GAXSET1 |
COMPANY DATE ACCT-UNIT ACCOUNT SUB-ACCOUNT |
|
| ||||||||||||||||||||||
GAXSET2 |
MAINT-DATE MAINT-TIME COMPANY DATE ACCT-UNIT ACCOUNT SUB-ACCOUNT |
|
| ||||||||||||||||||||||
GAXSET3 |
COMPANY FISCAL-YEAR ACCT-UNIT ACCOUNT SUB-ACCOUNT DATE |
|
| ||||||||||||||||||||||
GAXSET4 |
COMPANY ACCT-UNIT ACCOUNT SUB-ACCOUNT DATE |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Gltrans | GLTRANS |
|
All trademarks and registered trademarks are the property of their
respective owners.