Currency Exhange Rate
This file maintains rate tables for each defined currency relationship. CU10.1 (Exchange Rates) is the primary program that updates this file. It creates a single currency relationship with all of the rates sequenced by effective date. Rates can be maintained as often as once a day.
REFERENCED BY
CU10.1 | CU10.2 | CU160 | CU300 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||
---|---|---|---|---|---|---|
CCN-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. |
|
||||
CCN-FR-CURR-CODE Element: From Currency Code | Alpha 5 This is the name of the currency code you are converting from. It must be defined in the Currency Codes file. |
|
||||
CCN-TO-CURR-CODE Element: To Currency Code | Alpha 5 The name of the currency code you are converting to. It must be defined in the Currency Codes file. |
|
||||
CCN-SYSTEM Element: System | Alpha 2 The system code is a two-character code representing an application used within the Lawson system. (For example, GL = General Ledger, AP = Accounts Payable, etc.) |
|
||||
CCN-EFFECT-DATE Element: Effective Date | Numeric 8 (yyyymmdd) The effective date is the date the exchange rate is effective. This date is used until a new exchange rate is defined with a later date. |
|
||||
CCN-SELL-RATE Element: Selling Rate | Signed 14.7 This field contains the rate the From currency amount to the To currency amount is converted at. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CCNSET1 |
CURRENCY-TABLE FR-CURR-CODE TO-CURR-CODE SYSTEM EFFECT-DATE |
|
| ||||||||||||||||||||||||||||||||||||
CCNSET2 |
CURRENCY-TABLE* FR-CURR-CODE TO-CURR-CODE SYSTEM EFFECT-DATE* |
|
|||||||||||||||||||||||||||||||||||||
CCNSET3 |
CURRENCY-TABLE EFFECT-DATE* FR-CURR-CODE TO-CURR-CODE SYSTEM |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Cuconvbod | CUCONVBOD |
Not Required, Delete Cascades
| |||||||||||||||
Curelat | CURELAT |
Required
| |||||||||||||||
Fr Cucodes | CUCODES |
Required
| |||||||||||||||
To Cucodes | CUCODES |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||
---|---|---|---|---|---|---|---|---|
Glsystem | GLSYSTEM |
|
All trademarks and registered trademarks are the property of their
respective owners.