CUACCT – Currency Gain and Loss Account

System
General Ledger Setup (IF)
Prefix
CUA
Primary key
COMPANY, FR-CURR-CODE, TO-CURR-CODE, SYSTEM
Fields
17
Updated by
3 programs
Referenced by
122 programs

CUACCT is the Currency Gain and Loss Account table in Lawson General Ledger Setup (prefix CUA). It is indexed by COMPANY, FR-CURR-CODE, TO-CURR-CODE, SYSTEM (CUASET1); alternate indexes: CUASET2. It is related 1:1 to CURELAT, GLCHARTDTL, GLCODES, GLMASTER and GLSYSTEM. It is updated by CU03.1, GL10.1 and GL110 and referenced by AC191, AP125, AP126, AP170, AP180, AP181, AP190, AP191 and 114 more. The table has 17 fields, 2 indexes and 11 documented relations.

About CUACCT

This file contains account numbers that variance amounts are posted to when a timing difference occurs between the beginning and the completion of a transaction. CU03.1 (Currency Gain Loss Accounts) is the primary program that updates this file.

Fields (17)

Column = COBOL field name without the CUA- 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
#CUA-COMPANY PK
COMPANY		Numeric 4The company number you are defining currencies for.CU03.1, GL110
#CUA-FR-CURR-CODE PK
FR_CURR_CODE		Alpha 5This is the name of the currency code you are converting from. It must be a defined code in the Currency Relationships file.CU03.1
#CUA-TO-CURR-CODE PK
TO_CURR_CODE		Alpha 5This is the name of the currency code you are converting to. It must be a defined code in the Currency Relationships file.CU03.1
#CUA-SYSTEM PK
SYSTEM		Alpha 2A system code is a unique two-character code identifying a Lawson application system. A blank system code must first exist before a record can be added with a valid system code. The system code must be defined in the General Ledger file and source code. If you enter a system code in this field, the currency gain and loss accounts are used for that system only.CU03.1
#CUA-CURRENCY-TABLE SET2
CURRENCY_TABLE		Alpha 12This is the currency table, a table of currency relationships, currency exchange rates, and translation rates for one or more companies.CU03.1, GL10.1
#CUA-REAL-GAIN-ACU
REAL_GAIN_ACU		Alpha 15A negative variance is posted to this accounting unit if conversion rates differ in the opening and closing of a transaction. The accounting unit must be defined in the General Ledger Account Master file.CU03.1
#CUA-REAL-GAIN-ACT
REAL_GAIN_ACT		Numeric 6A negative variance is posted to this account if conversion rates differ in the opening and closing of a transaction. The account must be defined in the General Ledger Account Master file.CU03.1
#CUA-REAL-GAIN-ACS
REAL_GAIN_ACS		Numeric 4A negative variance is posted to this subaccount if conversion rates differ in the opening and closing of a transaction. The subaccount must be defined in the General Ledger Account Master file.CU03.1
#CUA-UNRL-GAIN-ACU
UNRL_GAIN_ACU		Alpha 15A negative variance is posted to this accounting unit if one exists when the conversion rate is revalued at the end of a period. The accounting unit must be defined in the General Ledger Account Master file.CU03.1
#CUA-UNRL-GAIN-ACT
UNRL_GAIN_ACT		Numeric 6A negative variance is posted to this account if one exists when the conversion rate is revalued at the end of a period. The account must be defined in the General Ledger Account Master file.CU03.1
#CUA-UNRL-GAIN-ACS
UNRL_GAIN_ACS		Numeric 4A negative variance is posted to this subaccount if one exists when the conversion rate is revalued at the end of a period. The subaccount must be defined in the General Ledger Account Master file.CU03.1
#CUA-REAL-LOSS-ACU
REAL_LOSS_ACU		Alpha 15A positive variance is posted to this accounting unit if conversion rates differ in the opening and closing of a transaction. The accounting unit must be defined in the General Ledger Account Master file.CU03.1
#CUA-REAL-LOSS-ACT
REAL_LOSS_ACT		Numeric 6A positive variance is posted to this account if conversion rates differ in the opening and closing of a transaction. The account must be defined in the General Ledger Account Master file.CU03.1
#CUA-REAL-LOSS-ACS
REAL_LOSS_ACS		Numeric 4A positive variance is posted to this subaccount if conversion rates differ in the opening and closing of a transaction. The subaccount must be defined in the General Ledger Account Master file.CU03.1
#CUA-UNRL-LOSS-ACU
UNRL_LOSS_ACU		Alpha 15A positive variance is posted to this accounting unit if one exists when the conversion rate is revalued at the end of a period. The accounting unit must be defined in the General Ledger Account Master file.CU03.1
#CUA-UNRL-LOSS-ACT
UNRL_LOSS_ACT		Numeric 6A positive variance is posted to this account if one exists when the conversion rate is revalued at the end of a period. The account must be defined in the General Ledger Account Master file.CU03.1
#CUA-UNRL-LOSS-ACS
UNRL_LOSS_ACS		Numeric 4A positive variance is posted to this subaccount if one exists when the conversion rate is revalued at the end of a period. The subaccount must be defined in the General Ledger Account Master file.CU03.1

Indexes (2)

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
CUASET1
  1. COMPANY
  2. FR-CURR-CODE
  3. TO-CURR-CODE
  4. SYSTEM
PrimaryAC191, AP125, AP126, AP170, AP180, AP181, AP190, AP191 +22 more (list truncated in source)
CUASET2
  1. CURRENCY-TABLE
  2. FR-CURR-CODE
  3. TO-CURR-CODE
  4. COMPANY
  5. SYSTEM
KeyChange—

Relations

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

One to one (11) — lookups and parents

RelationTableRulesConditionField map
CurelatCURELATRequired
CUA-CURRENCY-TABLE→CRL-CURRENCY-TABLE (CRLSET1)
CUA-FR-CURR-CODE→CRL-FR-CURR-CODE
CUA-TO-CURR-CODE→CRL-TO-CURR-CODE
Gdt Real GainGLCHARTDTLRequired
GLS-CHART-NAME→GDT-CHART-NAME
CUA-REAL-GAIN-ACT→GDT-ACCOUNT
CUA-REAL-GAIN-ACS→GDT-SUB-ACCOUNT
Gdt Real LossGLCHARTDTLRequired
GLS-CHART-NAME→GDT-CHART-NAME
CUA-REAL-LOSS-ACT→GDT-ACCOUNT
CUA-REAL-LOSS-ACS→GDT-SUB-ACCOUNT
Gdt Unrl GainGLCHARTDTLRequired
GLS-CHART-NAME→GDT-CHART-NAME
CUA-UNRL-GAIN-ACT→GDT-ACCOUNT
CUA-UNRL-GAIN-ACS→GDT-SUB-ACCOUNT
Gdt Unrl LossGLCHARTDTLRequired
GLS-CHART-NAME→GDT-CHART-NAME
CUA-UNRL-LOSS-ACT→GDT-ACCOUNT
CUA-UNRL-LOSS-ACS→GDT-SUB-ACCOUNT
GlcodesGLCODESRequiredWhen CUA-SYSTEM != Spaces
CUA-COMPANY→GCD-COMPANY
CUA-SYSTEM→GCD-SYSTEM
Glm Real GainGLMASTERRequired
CUA-COMPANY→GLM-COMPANY
CUA-REAL-GAIN-ACU→GLM-ACCT-UNIT
CUA-REAL-GAIN-ACT→GLM-ACCOUNT
CUA-REAL-GAIN-ACS→GLM-SUB-ACCOUNT
Glm Real LossGLMASTERRequired
CUA-COMPANY→GLM-COMPANY
CUA-REAL-LOSS-ACU→GLM-ACCT-UNIT
CUA-REAL-LOSS-ACT→GLM-ACCOUNT
CUA-REAL-LOSS-ACS→GLM-SUB-ACCOUNT
Glm Unrl GainGLMASTERRequired
CUA-COMPANY→GLM-COMPANY
CUA-UNRL-GAIN-ACU→GLM-ACCT-UNIT
CUA-UNRL-GAIN-ACT→GLM-ACCOUNT
CUA-UNRL-GAIN-ACS→GLM-SUB-ACCOUNT
Glm Unrl LossGLMASTERRequired
CUA-COMPANY→GLM-COMPANY
CUA-UNRL-LOSS-ACU→GLM-ACCT-UNIT
CUA-UNRL-LOSS-ACT→GLM-ACCOUNT
CUA-UNRL-LOSS-ACS→GLM-SUB-ACCOUNT
GlsystemGLSYSTEMRequired
CUA-COMPANY→GLS-COMPANY

Programs

Updated by (3)

Referenced by (122)