CUAMOUNTX – Currency Amount-Daily

System
General Ledger (GL)
Prefix
CAX
Primary key
COMPANY, AMT-TYPE, DATE, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT
Fields
20
Updated by
18 programs
Referenced by
3 programs

CUAMOUNTX is the Currency Amount-Daily table in Lawson General Ledger (prefix CAX). It is indexed by COMPANY, AMT-TYPE, DATE, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT (CAXSET1); alternate indexes: CAXSET3 and CAXSET4. It is related 1:M to GLTRANS. It is updated by GL110, GL120, GL146, GL148, GL167, GL190, GL197, GL300 and 10 more and referenced by GL243, GL43.1 and GLOP.1. The table has 20 fields, 3 indexes and 1 documented relation.

About CUAMOUNTX

The Daily Report Currency (CUAMOUNTX) file stores daily account balances for report currencies.

Fields (20)

Column = COBOL field name without the CAX- 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
#CAX-COMPANY PK
COMPANY		Numeric 4The company number assigned to the report currencies in GL10.1 (Company).GL110, GL146, GL148, GL167, GL190, GL197, GL328, GL40.1 +6 more
#CAX-DATE PK
DATE		Numeric 8 (yyyymmdd)This field displays the system date when this reocrd was created.GL146, GL148, GL167, GL190, GL197, GL328, GL40.1, GL40.2 +5 more
#CAX-AMT-TYPE PK
AMT_TYPE		Numeric 1The amount type indicates whether the record is currency one or currency two.
  • 3 Currency One Balance
  • 4 Currency Two Balance
GL146, GL148, GL167, GL190, GL197, GL328, GL40.1, GL40.2 +5 more
#CAX-VAR-LEVELS
VAR_LEVELS		Alpha 30A level that represents the location of an accounting unit in an organization's level structure.GL120, GL148, GL167, GL190, GL328
#CAX-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, GL328, GL40.1, GL40.2 +5 more
#CAX-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, GL328, GL40.1, GL40.2 +5 more
#CAX-ACCT-UNIT PK
ACCT_UNIT		Alpha 15The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.GL146, GL148, GL167, GL190, GL197, GL328, GL40.1, GL40.2 +5 more
#CAX-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).GL146, GL148, GL167, GL190, GL197, GL328, GL40.1, GL40.2 +5 more
#CAX-CHART-NAME
CHART_NAME		Alpha 12This is the name you assigned to the chart of accounts when you defined your company structure in the General Ledger system.GL146, GL148, GL167, GL190, GL197, GL328, GL40.1, GL40.2 +5 more
#CAX-CURR-ND
CURR_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.GL146, GL148, GL190, GL197, GL328, GL40.1, GL40.2, GL40.3 +4 more
#CAX-BASE-ND
BASE_ND		Numeric 1The number of decimal positions defined for the company base currency.GL146, GL148, GL190, GL197, GL328, GL40.1, GL40.2, GL40.3 +4 more
#CAX-DB-AMOUNT
DB_AMOUNT		Signed 18.2—GL110, GL146, GL148, GL167, GL190, GL197, GL328, GL40.1 +6 more
#CAX-CR-AMOUNT
CR_AMOUNT		Signed 18.2—GL110, GL146, GL148, GL167, GL190, GL197, GL328, GL40.1 +6 more
#CAX-BASE-DB-AMT
BASE_DB_AMT		Signed 18.2The base currency debit amount.GL146, GL148, GL190, GL197, GL328, GL40.1, GL40.2, GL40.3 +4 more
#CAX-BASE-CR-AMT
BASE_CR_AMT		Signed 18.2The base currency credit amount.GL146, GL148, GL190, GL197, GL328, GL40.1, GL40.2, GL40.3 +4 more
#CAX-ACCT-PERIOD
ACCT_PERIOD		Numeric 2This is the current accounting period. This field is updated by GL199 (Period Closing).GL146, GL148, GL167, GL190, GL197, GL328, GL40.1, GL40.2 +6 more
#CAX-FISCAL-YEAR SET3
FISCAL_YEAR		Numeric 4Contains the fiscal year for the data stored on this record.GL146, GL148, GL167, GL190, GL197, GL328, GL40.1, GL40.2 +6 more
#CAX-MAINT-DATE
MAINT_DATE		Numeric 8 (yyyymmdd)The date last changed.GL146, GL148, GL167, GL190, GL197, GL328, GL40.1, GL40.2 +6 more
#CAX-MAINT-TIME
MAINT_TIME		Numeric 6 (hhmmss)—GL146, GL148, GL167, GL190, GL197, GL328, GL40.1, GL40.2 +6 more
#CAX-NET-AMOUNT
NET_AMOUNT		DerivedThe net daily report currency amount. This amount is the debit amount added to the credit amount.—

Indexes (3)

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
CAXSET1
  1. COMPANY
  2. AMT-TYPE
  3. DATE
  4. ACCT-UNIT
  5. ACCOUNT
  6. SUB-ACCOUNT
PrimaryGL120, GL146, GL148, GL167, GL190, GL197, GL310, GL328 +9 more
CAXSET3
  1. COMPANY
  2. AMT-TYPE
  3. FISCAL-YEAR
  4. ACCT-UNIT
  5. ACCOUNT
  6. SUB-ACCOUNT
  7. DATE
KeyChangeGL110, GL300
CAXSET4
  1. COMPANY
  2. AMT-TYPE
  3. ACCT-UNIT
  4. ACCOUNT
  5. SUB-ACCOUNT
  6. 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)
GLTRANSCUAMOUNTX

One to many (1) — child tables

RelationTableRulesConditionField map
GltransGLTRANS
CAX-COMPANY→GLT-TO-COMPANY
CAX-FISCAL-YEAR→GLT-FISCAL-YEAR
CAX-ACCT-PERIOD→GLT-ACCT-PERIOD
CAX-ACCT-UNIT→GLT-ACCT-UNIT
CAX-ACCOUNT→GLT-ACCOUNT
CAX-SUB-ACCOUNT→GLT-SUB-ACCOUNT
CAX-DATE→GLT-POSTING-DATE
—→GLT-SYSTEM
—→GLT-CONTROL-GROUP
—→GLT-JE-TYPE
—→GLT-LINE-NBR
—→GLT-COMPANY
—→GLT-JE-SEQUENCE

Programs

Updated by (18)

Referenced by (3)