Currency Rate Interface
The Currency Translation Interface file contains translation rates for a currency table or company. The records are imported from a non-Lawson file into this file to be interfaced to the Lawson Currency system, using CU61 and CU161. Once records in this file are interfaced to the Currency system, they are deleted from this file.
REFERENCED BY
| CU261 |
| CU161 | CU61.1 | CU61.2 |
| FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||
|---|---|---|---|---|---|---|
| CUL-CURRENCY-TABLE Element: Currency Table | Alpha 12 This field contains the name of the currency table for which the rates are interfaced. |
|
||||
| CUL-SEQ-NUMBER Element: Seq Number | Numeric 6 This unique number is assigned by the system to keep the records unique. |
|
||||
| CUL-FR-CURR-CODE Element: Currency Code | Alpha 5 This is the currency code from which the company balances are translated.. |
|
||||
| CUL-TO-CURR-CODE Element: Currency Code | Alpha 5 This is the currency code to which the company balances are translated. |
|
||||
| CUL-FISCAL-YEAR Element: Year | Numeric 4 This is the fiscal year for which the rates are valid. |
|
||||
| CUL-BUDGET-NBR Element: Budget Nbr | Numeric 3 This is the budget to which the rates apply. |
|
||||
| CUL-COMPANY Element: Company | Numeric 4 This is the company to which the rates apply. Where applicable, company rates override currency table rates. |
|
||||
| CUL-TRANS-CODE Element: Trans Code | Alpha 2 This is the translation code for the currency translation. |
|
||||
| CUL-RATE-VALUE Element: Curr Rate | Signed 14.7 Occurs 13 Times This is the translation rate used - one for each period in the fiscal year. |
|
||||
| CUL-RATE-BEG-BAL Element: Curr Rate | Signed 14.7 This is the beginning translation rate used for the fiscal year. |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CULSET1 |
CURRENCY-TABLE SEQ-NUMBER COMPANY |
|
| ||||||||||
| CULSET2 |
COMPANY SEQ-NUMBER CURRENCY-TABLE |
|
| ||||||||||
| CULSET3 |
CURRENCY-TABLE FR-CURR-CODE TO-CURR-CODE FISCAL-YEAR BUDGET-NBR TRANS-CODE SEQ-NUMBER COMPANY |
|
| ||||||||||
| CULSET4 |
COMPANY FR-CURR-CODE TO-CURR-CODE FISCAL-YEAR BUDGET-NBR TRANS-CODE SEQ-NUMBER CURRENCY-TABLE |
|
| ||||||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Current | CURELAT |
Required
| |||||||||
| Fr Cucodes | CUCODES |
Required
| |||||||||
| To Cucodes | CUCODES |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.