CUTRANSL

Currency Translation

This file maintains translation rates for each currency relationship by company or currency table. CU20.1 (Company Translation Rates) and CU20.3 (Currency Table Translation Rates) are the primary programs that update this file.

REFERENCED BY
FB145 FB190 FB195 FB40.1 FB40.2 FB40.3
FB45.1 GL135 GL191 GL195 GL196 GL197
GL199 SNCU.1 SNOP.1 SNRP.1 SNSP.1


UPDATED BY
GL110 GL500 CU161 CU20.1 CU20.2 CU20.3
CU20.4 CU300 CU02.1 CU02.2 CU202 CU220
CU05.1 CU05.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CTR-CURRENCY-TABLE
Element: Currency Table
Alpha 12
This is a table of currency relationships, exchange rates, and translation rates used by one or more companies. If multiple companies share rates, each company can be linked to the same currency table, eliminating the need to set up rates for each company individually.
CU161 CU20.1
CU20.2 GL500
CTR-FR-CURR-CODE
Element: From Currency Code
Alpha 5
Type or select the company base currency code you are translating balances from. A currency relationship must exist between the From and To Currency in CU02.1 (Currency Relationship).
CU161 CU20.1
CU20.2 CU20.3
CU20.4 GL500
CTR-TO-CURR-CODE
Element: To Currency Code
Alpha 5
Type or select the company base currency code you are translating balances from. A currency relationship must exist between the From and To Currency in CU02.1 (Currency Relationship).
CU161 CU20.1
CU20.2 CU20.3
CU20.4 GL500
CTR-FISCAL-YEAR
Element: Fiscal Year
Numeric 4
Rates are entered in this year, the current fiscal year. The year must be greater than 1900.
1901
9999
CU161 CU20.1
CU20.2 CU20.3
CU20.4 GL500
CTR-COMPANY
Element: Company
Numeric 4
This is the From company the translation rates apply to. If the record is for a currency table, this field is zero.
CU161 CU20.1
CU20.3 CU20.4
GL110 GL500
CTR-BUDGET-NBR
Element: Budget
Numeric 3
This is the budget number the currency rates apply to.
CU161 CU20.1
CU20.2 CU20.3
CU20.4 GL500
CTR-TRANSL-CODE
Element: Translation Code
Alpha 2
This field determines how the currency code is translated. This translation code must be a valid code in the Translation Codes file.
CU161 CU20.1
CU20.2 CU20.3
CU20.4 GL500
CTR-RATE-VALUE
Element: Rate Value
Signed 14.7 Occurs 13 Times
The rates in this field are applied to actual and budget amounts.
CU161 CU20.1
CU20.2 CU20.3
CU20.4 FB195
GL195 GL500
CTR-RATE-BEG-BAL
Rate Beginning
Balance
Signed 14.7
This is the beginning balance rate, which applies to the beginning balance of any budgets to be translated.
CU161 CU20.1
CU20.3 FB195
GL500


CUTRANSL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CTRSET1 CURRENCY-TABLE
FR-CURR-CODE
TO-CURR-CODE
FISCAL-YEAR
COMPANY
BUDGET-NBR
TRANSL-CODE
FB145 FB190
FB195 FB40.1
FB40.2 FB40.3
FB45.1 GL110
GL135 GL191
GL195 GL196
GL197 GL199
CU02.1 CU02.2
CU161 CU20.1
CU20.2 CU202
CU220 SNCU.1
SNOP.1 SNRP.1
SNSP.1
CTRSET2 CURRENCY-TABLE
COMPANY
FISCAL-YEAR
BUDGET-NBR
TRANSL-CODE
FR-CURR-CODE
TO-CURR-CODE
CU20.2 CU300
CTRSET3 TRANSL-CODE
CURRENCY-TABLE
COMPANY
FR-CURR-CODE
TO-CURR-CODE
FISCAL-YEAR
BUDGET-NBR
CU05.1 CU05.2
CTRSET4 COMPANY
FR-CURR-CODE
TO-CURR-CODE
FISCAL-YEAR
BUDGET-NBR
TRANSL-CODE
Subset
WhereCOMPANY !=Zeroes
FB145 FB190
FB195 FB40.1
FB40.2 FB40.3
FB45.1 GL135
GL191 GL195
GL196 GL197
GL199 GL500
CU161 CU20.3
CU20.4 CU220
SNOP.1 SNRP.1
SNSP.1
CTRSET5 COMPANY
FISCAL-YEAR
BUDGET-NBR
TRANSL-CODE
FR-CURR-CODE
TO-CURR-CODE
Subset
WhereCOMPANY !=Zeroes
CU20.4


CUTRANSL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Curelat CURELAT Required
CTR-CURRENCY-TABLE->CRL-CURRENCY-TABLE
CTR-FR-CURR-CODE->CRL-FR-CURR-CODE
CTR-TO-CURR-CODE->CRL-TO-CURR-CODE
Fr Cucodes CUCODES Required
CTR-FR-CURR-CODE->CUC-CURRENCY-CODE
Glsystem GLSYSTEM Required
CTR-COMPANY->GLS-COMPANY
To Cucodes CUCODES Required
CTR-TO-CURR-CODE->CUC-CURRENCY-CODE
Trcodes TRCODES Required
CTR-TRANSL-CODE->TRC-TRANSL-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.