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