Currency Relationships
This file contains the valid currency relationships used for a specific currency table. CU02.1 (Currency Relationship) is the primary program that updates this file.
REFERENCED BY
CU02.1 | CU02.2 | CU03.1 | CU162 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||
---|---|---|---|---|---|---|
CRL-CURRENCY-TABLE Element: Currency Table | Alpha 12 This is a table of currency relationships, exchange rates, and translation rates used by one or more companies. If multiple companies share rates, each company can be linked to the same currency table, eliminating the need to set up rates for each company individually. |
|
||||
CRL-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 valid code in the Currency Codes file. |
|
||||
CRL-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 valid code in the Currency Codes file. |
|
||||
CRL-MULT-DIV Element: Mult Div | Alpha 1 The Multiply/Divide field determines how rates are applied during conversion and translation. Use Multiply, the default value, to multiply the From currency amount by the rate to calculate the To currency amount. Use Divide to divide the From currency amount by the rate to calculate the To currency amount. M = Multiply D = Divide |
|
||||
CRL-OVD-TOLERANCE Element: Override Tolerance | Numeric 3 This field determines the override tolerance of an exchange rate. Values from 0 to 100 are acceptable. A value of 0 is the default and means any override rate is acceptable. Any other value indicates the percentage (tolerance) the override rate can be over the table rate. 000 100 |
|
||||
CRL-CONV-STATUS Element: Conversion Status | Alpha 1 This field indicates currency exchange relationship status. Use Active, the default value, to let conversion activity take place for the relationship. Use Inactive to prevent conversion activity. A = Active I = Inactive |
|
||||
CRL-TRANSL-STATUS Element: Translation Status | Alpha 1 This field indicates currency translation status. Use Active, the default value, to let translation activity take place for the relationship. Use Inactive to prevent translation activity. A = Active I = Inactive |
|
||||
CRL-FR-CURR-ND From Currency Nbr of Decimals | Numeric 1 This is the currency number of decimal positions for the From currency. |
|
||||
CRL-TO-CURR-ND To Currency Nbr of Decimals | Numeric 1 This is the currency number of decimal positions for the To currency. |
|
||||
CRL-TRNGLT-IND Element: Trnglt Ind | Alpha 1 Indicates whether the currencies in a conversion need to be converted by way of a third currency. Required for member currencies of the European Union. |
|
||||
CRL-TRNGLT-CURR-CD Element: Currency Code | Alpha 5 The currency code of the language used to triangulate a conversion. For European Union (EU) currencies, the triangulation currency must be the Euro. |
|
||||
CRL-OVD-PROT-IND Element: Ovd Prot Ind | Alpha 1 Yes indicates that the conversion rates cannot be overridden. The default is No. Yes is required when the Triangulate indicator is set to Yes. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||
---|---|---|---|---|---|---|---|---|---|
CRLSET1 |
CURRENCY-TABLE FR-CURR-CODE TO-CURR-CODE |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||
---|---|---|---|---|---|
Fr Cucodes | CUCODES |
Required
| |||
To Cucodes | CUCODES |
Required
| |||
Via Cucodes | CUCODES |
Not Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Cuacct | CUACCT |
| |||||||||||||||||||||
Cuconv | CUCONV |
Delete Restricted
| |||||||||||||||||||||
Cuconv Dec | CUCONV |
| |||||||||||||||||||||
Curelatau | CURELATAU |
| |||||||||||||||||||||
Cutransl | CUTRANSL |
| |||||||||||||||||||||
Glsystem | GLSYSTEM |
|
All trademarks and registered trademarks are the property of their
respective owners.