CUACCT

Currency Gain and Loss Account

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.

REFERENCED BY
AP170 AP180 AP181 AP190 AP191 AP20.1
AP20.2 AP20.3 AP20.4 AP20.5 AP20.7 AP21.1
AP23.1 AP30.4 AR01.1 CB145 IFCU.1 MA180
MA41.1 MA41.2 MA41.4 MA41.7 MA42.2 MA43.2
MA44.1 MA44.2 GL191 CU203 ML191


UPDATED BY
GL110 CU03.1 GL10.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CUA-COMPANY
Element: Company
Numeric 4
The company number you are defining currencies for.
CU03.1 GL110
CUA-FR-CURR-CODE
Element: From currency Code
Alpha 5
This 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
Element: To Currency Code
Alpha 5
This 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
Element: System
Alpha 2
A 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
Element: Currency Table
Alpha 12
This 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
Realized Gain
Accounting Unit
Alpha 15
A 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
Realized Gain
Account
Numeric 6
A 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
Realized Gain
Subaccount
Numeric 4
A 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
Unrealized Gain
Accting Unit
Alpha 15
A 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
Unrealized Gain
Account
Numeric 6
A 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
Unrelized Gain
Subaccount
Numeric 4
A 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
Realized Loss
Accounting Unit
Alpha 15
A 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
Realized Loss
Account
Numeric 6
A 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
Realized Loss
Subaccount
Numeric 4
A 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
Unrealized Loss
Acct Unit
Alpha 15
A 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
Unrealized Loss
Account
Numeric 6
A 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
Unrealized Loss
Subaccount
Numeric 4
A 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


CUACCT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CUASET1 COMPANY
FR-CURR-CODE
TO-CURR-CODE
SYSTEM
...
AP170 AP180
AP181 AP190
AP191 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP30.4
AR01.1 CB145
GL110 GL191
CU03.1 CU203
GL10.1 IFCU.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
CUASET2 CURRENCY-TABLE
FR-CURR-CODE
TO-CURR-CODE
COMPANY
SYSTEM
KeyChange


CUACCT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Curelat CURELAT Required
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 Gain GLCHARTDTL Required
GLS-CHART-NAME->GDT-CHART-NAME
CUA-REAL-GAIN-ACT->GDT-ACCOUNT
CUA-REAL-GAIN-ACS->GDT-SUB-ACCOUNT
Gdt Real Loss GLCHARTDTL Required
GLS-CHART-NAME->GDT-CHART-NAME
CUA-REAL-LOSS-ACT->GDT-ACCOUNT
CUA-REAL-LOSS-ACS->GDT-SUB-ACCOUNT
Gdt Unrl Gain GLCHARTDTL Required
GLS-CHART-NAME->GDT-CHART-NAME
CUA-UNRL-GAIN-ACT->GDT-ACCOUNT
CUA-UNRL-GAIN-ACS->GDT-SUB-ACCOUNT
Gdt Unrl Loss GLCHARTDTL Required
GLS-CHART-NAME->GDT-CHART-NAME
CUA-UNRL-LOSS-ACT->GDT-ACCOUNT
CUA-UNRL-LOSS-ACS->GDT-SUB-ACCOUNT
Glcodes GLCODES Required
When CUA-SYSTEM !=Spaces
CUA-COMPANY->GCD-COMPANY
CUA-SYSTEM->GCD-SYSTEM
Glm Real Gain GLMASTER Required
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 Loss GLMASTER Required
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 Gain GLMASTER Required
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 Loss GLMASTER Required
CUA-COMPANY->GLM-COMPANY
CUA-UNRL-LOSS-ACU->GLM-ACCT-UNIT
CUA-UNRL-LOSS-ACT->GLM-ACCOUNT
CUA-UNRL-LOSS-ACS->GLM-SUB-ACCOUNT
Glsystem GLSYSTEM Required
CUA-COMPANY->GLS-COMPANY


File created: Thu Jun 09 11:18:25 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.