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.

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
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
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
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
GAXSET1COMPANY, DATE, ACCT-UNIT, ACCOUNT, SUB-ACCOUNTPrimaryGL120, GL146, GL148, GL167, GL190, GL197, GL326, GL40.1 +8 more
GAXSET2MAINT-DATE, MAINT-TIME, COMPANY, DATE, ACCT-UNIT, ACCOUNT, SUB-ACCOUNTKeyChangeGLOP.1
GAXSET3COMPANY, FISCAL-YEAR, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, DATEKeyChangeGL110, GL300
GAXSET4COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, DATEGL120, GL243, GL43.1

Relations

One to many (1) — child tables

RelationTableRulesConditionField map
GltransGLTRANSGAX-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)