GLAMOUNTSX FILE
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
UPDATED BY
GL110 GL120 GL146 GL167 GL190 GL300
GL326 GL45.1 GL500
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GAX-COMPANY Numeric 4 GL110 GL146
Company The Company field contains the company GL167 GL190
number this is used in the Organization GL326 GL45.1
dimension.
GAX-DATE Numeric 8 (yyyymmdd) GL146 GL167
Date The Date field contains the system date GL190 GL326
this was created. The Date format used GL45.1
is YYYYMMDD.
GAX-ACCT-UNIT Alpha 15 GL146 GL167
Accounting Unit The Accounting Unit field contains the GL190 GL326
name of the accounting unit that is used GL45.1
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 Numeric 6 GL146 GL167
Account This field along with the accounting GL190 GL326
unit and subaccount make up the location GL45.1
(account) where amounts and other
account information is stored.
GAX-SUB-ACCOUNT Numeric 4 GL146 GL167
Subaccount This field along with the accounting GL190 GL326
unit and subaccount make up the location GL45.1
(account) where amounts and other
account information is stored.
GAX-VAR-LEVELS Alpha 30 GL120 GL146
Variable Levels A level that represents the location of GL167 GL190
an accounting unit in an organization's GL326 GL45.1
level structure.
GAX-CHART-NAME Alpha 12 GL146 GL167
Chart Name The Chart of Accounts Name field GL190 GL326
contains the name of the chart of GL45.1
accounts that is used by the
Organization dimension. This name can
contain up to 12 alphabetic characters.
GAX-DB-AMOUNT Currency 15.2 GL110 GL146
Debit Amount The Debit Amount field contains the GL167 GL190
debit amount. GL326 GL45.1
GAX-CR-AMOUNT Currency 15.2 GL110 GL146
Credit Amount The Credit Amount field contains the GL167 GL190
credit amount. GL326 GL45.1
GAX-FISCAL-YEAR Numeric 4 GL146 GL167
Fiscal Year The Fiscal Year field contains the GL190 GL326
numeric fiscal year. This field can GL45.1 GL500
contain up to four numeric characters.
GAX-ACCT-PERIOD Numeric 2 GL146 GL167
Account Period This is the current accounting period. GL190 GL326
This field is updated by GL199 (Period GL45.1 GL500
Closing).
GAX-MAINT-DATE Numeric 8 (yyyymmdd) GL120 GL146
Maintenance Date The Maintenance Date field contains the GL167 GL190
date that this file was last updated. GL326 GL45.1
The date format used is YYYYMMDD. GL500
GAX-MAINT-TIME Numeric 6 (hhmmss) GL120 GL146
Maintenance Time The Maintenance Time field contains the GL167 GL190
time that this file was last updated. GL326 GL45.1
The time format used is HHMMSS. GL500
GAX-NET-AMOUNT Derived
Net Amount 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 GL146 GL167
DATE GL190 GL326
ACCT-UNIT GL45.1 GL500
ACCOUNT GLOP.1
SUB-ACCOUNT
GAXSET2 MAINT-DATE KeyChange GLOP.1
MAINT-TIME
COMPANY
DATE
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
GAXSET3 COMPANY KeyChange GL110 GL300
FISCAL-YEAR
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
DATE
GAXSET4 COMPANY GL120 GL243
ACCT-UNIT GL43.1
ACCOUNT
SUB-ACCOUNT
DATE
GLAMOUNTSX FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME 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
|
