CUACCT FILE
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 AP30.4
AR129 AR130 AR131 AR135 AR196 AR30.1
AR30.2 AR30.3 AR30.4 AR30.8 AR31.6 AR35.1
AR44.3 AR48.3 AR504 DT170 DT180 DT181
DT185 GL191 CU203 IFCU.1
UPDATED BY
GL110 CU03.1 GL10.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CUA-COMPANY Numeric 4 CU03.1 GL110
Company The company number you are defining
currencies for.
CUA-FR-CURR-CODE Alpha 5 CU03.1
From Currency Code This is the name of the currency code
you are converting from. It must be a
defined code in the Currency
Relationships file.
CUA-TO-CURR-CODE Alpha 5 CU03.1
To Currency Code This is the name of the currency code
you are converting to. It must be a
defined code in the Currency
Relationships file.
CUA-SYSTEM Alpha 2 CU03.1
System Code 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.
CUA-CURRENCY-TABLE Alpha 12 CU03.1 GL10.1
Currency Table This is the currency table, a table of
currency relationships, currency
exchange rates, and translation rates
for one or more companies.
CUA-REAL-GAIN-ACU Alpha 15 CU03.1
Realized Gain A negative variance is posted to this
Accounting Unit 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.
CUA-REAL-GAIN-ACT Numeric 6 CU03.1
Realized Gain A negative variance is posted to this
Account 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.
CUA-REAL-GAIN-ACS Numeric 4 CU03.1
Realized Gain A negative variance is posted to this
Subaccount 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.
CUA-UNRL-GAIN-ACU Alpha 15 CU03.1
Unrealized Gain A negative variance is posted to this
Accting Unit 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.
CUA-UNRL-GAIN-ACT Numeric 6 CU03.1
Unrealized Gain A negative variance is posted to this
Account 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.
CUA-UNRL-GAIN-ACS Numeric 4 CU03.1
Unrealized Gain A negative variance is posted to this
Subaccount 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.
CUA-REAL-LOSS-ACU Alpha 15 CU03.1
Realized Loss A positive variance is posted to this
Accounting Unit 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.
CUA-REAL-LOSS-ACT Numeric 6 CU03.1
Realized Loss A positive variance is posted to this
Account 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.
CUA-REAL-LOSS-ACS Numeric 4 CU03.1
Realized Loss A positive variance is posted to this
Subaccount 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.
CUA-UNRL-LOSS-ACU Alpha 15 CU03.1
Unrealized Loss A positive variance is posted to this
Account Unit 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.
CUA-UNRL-LOSS-ACT Numeric 6 CU03.1
Unrealized Loss A positive variance is posted to this
Account 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.
CUA-UNRL-LOSS-ACS Numeric 4 CU03.1
Unrealized Loss A positive variance is posted to this
Subaccount 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.
CUACCT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CUASET1 COMPANY This path is used to retrieve the AP170 AP180
FR-CURR-CODE gain/loss accounts for a company by AP181 AP190
TO-CURR-CODE "From/To" currency and system. AP191 AP30.4
SYSTEM AR129 AR130
AR131 AR135
AR196 AR30.1
AR30.2 AR30.3
AR30.4 AR30.8
AR31.6 AR35.1
AR44.3 AR48.3
AR504 DT170
DT180 DT181
DT185 GL110
GL191 CU03.1
CU203 GL10.1
...
CUASET2 CURRENCY-TABLEKeyChange
FR-CURR-CODE
TO-CURR-CODE
COMPANY
SYSTEM
CUACCT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
|
