CUTRATEREL

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.
UPDATED BY
CU161 CU61.1 CU61.2 CU261

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.
CU161 CU61.1
CU61.2
CUL-SEQ-NUMBER
Element: Seq Number
Numeric 6
This unique number is assigned by the system to keep the records unique.
CU161 CU61.1
CU61.2
CUL-FR-CURR-CODE
Element: Currency Code
Alpha 5
This is the currency code from which the company balances are translated..
CU161 CU261
CU61.1 CU61.2
CUL-TO-CURR-CODE
Element: Currency Code
Alpha 5
This is the currency code to which the company balances are translated.
CU161 CU61.1
CU61.2
CUL-FISCAL-YEAR
Element: Year
Numeric 4
This is the fiscal year for which the rates are valid.
CU61.1 CU61.2
CUL-BUDGET-NBR
Element: Budget Nbr
Numeric 3
This is the budget to which the rates apply.
CU161 CU61.1
CU61.2
CUL-COMPANY
Element: Company
Numeric 4
This is the company to which the rates apply. Where applicable, company rates override currency table rates.
CU161 CU61.2
CUL-TRANS-CODE
Element: Trans Code
Alpha 2
This is the translation code for the currency translation.
CU161 CU61.1
CU61.2
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.
CU61.1 CU61.2
CUL-RATE-BEG-BAL
Element: Curr Rate
Signed 14.7
This is the beginning translation rate used for the fiscal year.
CU61.1 CU61.2


CUTRATEREL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CULSET1 CURRENCY-TABLE
SEQ-NUMBER
COMPANY
CU161 CU61.1
CULSET2 COMPANY
SEQ-NUMBER
CURRENCY-TABLE
CU161 CU61.2
CULSET3 CURRENCY-TABLE
FR-CURR-CODE
TO-CURR-CODE
FISCAL-YEAR
BUDGET-NBR
TRANS-CODE
SEQ-NUMBER
COMPANY
KeyChange
CU161 CU261
CU61.1
CULSET4 COMPANY
FR-CURR-CODE
TO-CURR-CODE
FISCAL-YEAR
BUDGET-NBR
TRANS-CODE
SEQ-NUMBER
CURRENCY-TABLE
KeyChange
CU161 CU261
CU61.2


CUTRATEREL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


File created: Wed Jun 08 20:49:43 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.