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.

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

IndexKeysFlagsConditionUsed in
CAXSET1COMPANY, AMT-TYPE, DATE, ACCT-UNIT, ACCOUNT, SUB-ACCOUNTPrimaryGL120, GL146, GL148, GL167, GL190, GL197, GL310, GL328 +9 more
CAXSET3COMPANY, AMT-TYPE, FISCAL-YEAR, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, DATEKeyChangeGL110, GL300
CAXSET4COMPANY, AMT-TYPE, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, DATEGL120, GL243, GL43.1

Relations

One to many (1) — child tables

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