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 |
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | |||||||
---|---|---|---|---|---|---|---|---|---|---|
CUASET1 |
COMPANY FR-CURR-CODE TO-CURR-CODE SYSTEM |
|
||||||||
CUASET2 |
CURRENCY-TABLE FR-CURR-CODE TO-CURR-CODE COMPANY SYSTEM |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Curelat | CURELAT |
Required
| ||||||||||||
Gdt Real Gain | GLCHARTDTL |
Required
| ||||||||||||
Gdt Real Loss | GLCHARTDTL |
Required
| ||||||||||||
Gdt Unrl Gain | GLCHARTDTL |
Required
| ||||||||||||
Gdt Unrl Loss | GLCHARTDTL |
Required
| ||||||||||||
Glcodes | GLCODES |
Required
| ||||||||||||
Glm Real Gain | GLMASTER |
Required
| ||||||||||||
Glm Real Loss | GLMASTER |
Required
| ||||||||||||
Glm Unrl Gain | GLMASTER |
Required
| ||||||||||||
Glm Unrl Loss | GLMASTER |
Required
| ||||||||||||
Glsystem | GLSYSTEM |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.