GLAMOUNTSX – General Ledger Amounts Daily

System
General Ledger (GL)
Prefix
GAX
Primary key
COMPANY, DATE, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT
Fields
14
Updated by
17 programs
Referenced by
3 programs

GLAMOUNTSX is the General Ledger Amounts Daily table in Lawson General Ledger (prefix GAX). It is indexed by COMPANY, DATE, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT (GAXSET1); alternate indexes: GAXSET2, GAXSET3 and GAXSET4. It is related 1:M to GLTRANS. It is updated by GL110, GL120, GL146, GL148, GL167, GL190, GL197, GL300 and 9 more and referenced by GL243, GL43.1 and GLOP.1. The table has 14 fields, 4 indexes and 1 documented relation.

About GLAMOUNTSX

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

Fields (14)

Column = COBOL field name without the GAX- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#GAX-COMPANY PK
COMPANY		Numeric 4The Company field contains the company number this is used in the Organization dimension.GL110, GL146, GL148, GL167, GL190, GL197, GL326, GL40.1 +6 more
#GAX-DATE PK
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 +5 more
#GAX-ACCT-UNIT PK
ACCT_UNIT		Alpha 15The 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 +5 more
#GAX-ACCOUNT PK
ACCOUNT		Numeric 6This 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 +5 more
#GAX-SUB-ACCOUNT PK
SUB_ACCOUNT		Numeric 4This 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 +5 more
#GAX-VAR-LEVELS
VAR_LEVELS		Alpha 30A level that represents the location of an accounting unit in an organization's level structure.GL120, GL146, GL148, GL167, GL190, GL197, GL326, GL40.1 +6 more
#GAX-CHART-NAME
CHART_NAME		Alpha 12The 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 +5 more
#GAX-DB-AMOUNT
DB_AMOUNT		Signed 18.2The Debit Amount field contains the debit amount.GL110, GL146, GL148, GL167, GL190, GL197, GL326, GL40.1 +6 more
#GAX-CR-AMOUNT
CR_AMOUNT		Signed 18.2The Credit Amount field contains the credit amount.GL110, GL146, GL148, GL167, GL190, GL197, GL326, GL40.1 +6 more
#GAX-FISCAL-YEAR SET3
FISCAL_YEAR		Numeric 4The 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 +6 more
#GAX-ACCT-PERIOD
ACCT_PERIOD		Numeric 2This is the current accounting period. This field is updated by GL199 (Period Closing).GL146, GL148, GL167, GL190, GL197, GL326, GL40.1, GL40.2 +6 more
#GAX-MAINT-DATE SET2
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 +7 more
#GAX-MAINT-TIME SET2
MAINT_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 +7 more
#GAX-NET-AMOUNT
NET_AMOUNT		DerivedThe net daily base amount. This amount is the debit amount added to the credit amount.—

Indexes (4)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
GAXSET1
  1. COMPANY
  2. DATE
  3. ACCT-UNIT
  4. ACCOUNT
  5. SUB-ACCOUNT
PrimaryGL120, GL146, GL148, GL167, GL190, GL197, GL326, GL40.1 +8 more
GAXSET2
  1. MAINT-DATE
  2. MAINT-TIME
  3. COMPANY
  4. DATE
  5. ACCT-UNIT
  6. ACCOUNT
  7. SUB-ACCOUNT
KeyChangeGLOP.1
GAXSET3
  1. COMPANY
  2. FISCAL-YEAR
  3. ACCT-UNIT
  4. ACCOUNT
  5. SUB-ACCOUNT
  6. DATE
KeyChangeGL110, GL300
GAXSET4
  1. COMPANY
  2. ACCT-UNIT
  3. ACCOUNT
  4. SUB-ACCOUNT
  5. DATE
GL120, GL243, GL43.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
GLTRANSGLAMOUNTSX

One to many (1) — child tables

RelationTableRulesConditionField map
GltransGLTRANS
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

Programs

Updated by (17)

Referenced by (3)