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
AC191 AP125 AP126 AP170 AP180 AP181
AP190 AP191 AP20.1 AP20.2 AP20.3 AP20.4
AP20.5 AP20.7 AP21.1 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.4 API1.1 API2.1 AR01.1
BR44.1 CB145 CB222 FB45.1 GL100 GL111
GL120 GL122 GL135 GL146 GL148 GL167
GL190 GL191 GL195 GL196 GL197 GL199
GL330 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8
GL44.1 GL45.1 GL500 DR100 IC141 IC142
IC222 IC83.1 CU00.1 CU01.1 CU01.2 CU02.1
CU02.2 CU10.1 CU10.2 CU20.1 CU20.2 CU20.3
CU203 GL00.2 GL00.3 GL00.6 GL00.7 GL00.9
GL02.1 GL02.2 GL02.3 GL02.6 GL03.6 GL121
GL124 GL125 GL160 GL161 GL20.1 GL20.2
GL20.4 IFAC.1 IFCU.1 MA180 MA41.1 MA41.2
MA41.4 MA41.7 MA42.2 MA43.2 MA44.1 MA44.2
MA61.1 MAI1.1 ML146 ML167 ML190 ML191
ML195 ML196 ML199 ML330 ML40.1 ML40.2
ML40.3 ML40.7 ML40.8 ML44.1 ML45.1 RQ10.1
RQ10.3 RQ11.1 RQ13.2 RQ35.1 RQ500 RQIB.1
RQIF.1 RQIJ.1


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
...
AC191 AP125
AP126 AP170
AP180 AP181
AP190 AP191
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
API2.1 AR01.1
BR44.1 CB145
CB222 FB45.1
GL100 GL110
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 02:20:23 2016

Home
Contact Us



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