GLAMOUNTSX

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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GAXSET1 COMPANY
DATE
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
GL120 GL146
GL148 GL167
GL190 GL197
GL326 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500 GLOP.1
GAXSET2 MAINT-DATE
MAINT-TIME
COMPANY
DATE
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
KeyChange
GLOP.1
GAXSET3 COMPANY
FISCAL-YEAR
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
DATE
KeyChange
GL110 GL300
GAXSET4 COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
DATE
GL120 GL243
GL43.1


GLAMOUNTSX FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Gltrans GLTRANS
GAX-COMPANY->GLT-TO-COMPANY
GAX-FISCAL-YEAR->GLT-FISCAL-YEAR
GAX-ACCT-PERIOD->GLT-ACCT-PERIOD
GAX-ACCT-UNIT->GLT-ACCT-UNIT
GAX-ACCOUNT->GLT-ACCOUNT
GAX-SUB-ACCOUNT->GLT-SUB-ACCOUNT
GAX-DATE->GLT-POSTING-DATE
  GLT-SYSTEM
  GLT-CONTROL-GROUP
  GLT-JE-TYPE
  GLT-LINE-NBR
  GLT-COMPANY
  GLT-JE-SEQUENCE


File created: Wed Jun 08 20:48:38 2016

Home
Contact Us



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