|
|
CUTRATEREL FILE
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
UPDATED BY
CU161 CU61.1 CU61.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CUL-CURRENCY-TABLE Alpha 12 CU161 CU61.1
Element: Currency TableThis field contains the name of the CU61.2
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
Element: 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
Element: 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
Element: Last Closed YeThis is the fiscal year for which the
rates are valid.
CUL-BUDGET-NBR Numeric 3 CU161 CU61.1
Element: Budget Number This is the budget to which the rates CU61.2
apply.
CUL-COMPANY Numeric 4 CU161 CU61.2
Element: 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
Element: 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
Element: Account Rate 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
Element: Account Rate 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
|
