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.

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

IndexKeysFlagsConditionUsed in
CUASET1COMPANY, FR-CURR-CODE, TO-CURR-CODE, SYSTEMPrimaryAC191, AP125, AP126, AP170, AP180, AP181, AP190, AP191 +22 more (list truncated in source)
CUASET2CURRENCY-TABLE, FR-CURR-CODE, TO-CURR-CODE, COMPANY, SYSTEMKeyChange—

Relations

One to one (11) — lookups and parents

RelationTableRulesConditionField map
CurelatCURELATRequiredCUA-CURRENCY-TABLE → CRL-CURRENCY-TABLE (CRLSET1), CUA-FR-CURR-CODE → CRL-FR-CURR-CODE, CUA-TO-CURR-CODE → CRL-TO-CURR-CODE
Gdt Real GainGLCHARTDTLRequiredGLS-CHART-NAME → GDT-CHART-NAME, CUA-REAL-GAIN-ACT → GDT-ACCOUNT, CUA-REAL-GAIN-ACS → GDT-SUB-ACCOUNT
Gdt Real LossGLCHARTDTLRequiredGLS-CHART-NAME → GDT-CHART-NAME, CUA-REAL-LOSS-ACT → GDT-ACCOUNT, CUA-REAL-LOSS-ACS → GDT-SUB-ACCOUNT
Gdt Unrl GainGLCHARTDTLRequiredGLS-CHART-NAME → GDT-CHART-NAME, CUA-UNRL-GAIN-ACT → GDT-ACCOUNT, CUA-UNRL-GAIN-ACS → GDT-SUB-ACCOUNT
Gdt Unrl LossGLCHARTDTLRequiredGLS-CHART-NAME → GDT-CHART-NAME, CUA-UNRL-LOSS-ACT → GDT-ACCOUNT, CUA-UNRL-LOSS-ACS → GDT-SUB-ACCOUNT
GlcodesGLCODESRequiredWhen CUA-SYSTEM != SpacesCUA-COMPANY → GCD-COMPANY, CUA-SYSTEM → GCD-SYSTEM
Glm Real GainGLMASTERRequiredCUA-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 LossGLMASTERRequiredCUA-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 GainGLMASTERRequiredCUA-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 LossGLMASTERRequiredCUA-COMPANY → GLM-COMPANY, CUA-UNRL-LOSS-ACU → GLM-ACCT-UNIT, CUA-UNRL-LOSS-ACT → GLM-ACCOUNT, CUA-UNRL-LOSS-ACS → GLM-SUB-ACCOUNT
GlsystemGLSYSTEMRequiredCUA-COMPANY → GLS-COMPANY

Programs

Updated by (3)

Referenced by (122)