|
|
CUTRANSL FILE
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
FB195 GL135 GL191 GL195 GL196 CU02.1
CU02.2 CU202 CU220 CU05.1 CU05.2
UPDATED BY
GL110 GL500 CU20.1 CU20.2 CU20.3 CU20.4
CU300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CTR-CURRENCY-TABLE Alpha 12 CU20.1 CU20.2
Currency Table This is a table of currency GL500
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.
CTR-FR-CURR-CODE Alpha 5 CU20.1 CU20.2
From Currency Code Type or select the company base CU20.3 CU20.4
currency code you are translating GL500
balances from. A currency relationship
must exist between the From and To
Currency in CU02.1 (Currency
Relationship).
CTR-TO-CURR-CODE Alpha 5 CU20.1 CU20.2
Through Currency Type or select the company base CU20.3 CU20.4
Code currency code you are translating GL500
balances from. A currency relationship
must exist between the From and To
Currency in CU02.1 (Currency
Relationship).
CTR-FISCAL-YEAR Numeric 4 CU20.1 CU20.2
Fiscal Year Rates are entered in this year, the CU20.3 CU20.4
current fiscal year. The year must be GL500
greater than 1900.
1901
9999
CTR-COMPANY Numeric 4 CU20.1 CU20.3
Company This is the From company the CU20.4 GL110
translation rates apply to. If the GL500
record is for a currency table, this
field is zero.
CTR-BUDGET-NBR Numeric 3 CU20.1 CU20.2
Budget This is the budget number the currency CU20.3 CU20.4
rates apply to. GL500
CTR-TRANSL-CODE Alpha 2 CU20.1 CU20.2
Translation Code This field determines how the currency CU20.3 CU20.4
code is translated. This translation GL500
code must be a valid code in the
Translation Codes file.
CTR-RATE-VALUE Signed 12.6 Occurs 13 Times CU20.1 CU20.2
Rate Value The rates in this field are applied to CU20.3 CU20.4
actual and budget amounts. FB195 GL500
CTR-RATE-BEG-BAL Signed 12.6 CU20.1 CU20.3
Rate Beginning This is the beginning balance rate, FB195 GL500
Balance which applies to the beginning balance
of any budgets to be translated.
CUTRANSL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CTRSET1 CURRENCY-TABLEThis path is used to retrieve a FB195 GL110
FR-CURR-CODE translation in company "From/To" GL135 GL191
TO-CURR-CODE currency code order. GL195 GL196
FISCAL-YEAR CU02.1 CU02.2
COMPANY CU20.1 CU20.2
BUDGET-NBR CU202 CU220
TRANSL-CODE
CTRSET2 CURRENCY-TABLEThis path is used to retrieve a CU20.2 CU300
COMPANY translation in company, fiscal year,
FISCAL-YEAR etc. order.
BUDGET-NBR
TRANSL-CODE
FR-CURR-CODE
TO-CURR-CODE
CTRSET3 TRANSL-CODE CU05.1 CU05.2
CURRENCY-TABLE
COMPANY
FR-CURR-CODE
TO-CURR-CODE
FISCAL-YEAR
BUDGET-NBR
CTRSET4 COMPANY Subset FB195 GL135
FR-CURR-CODE Where COMPANY != Zeroes GL191 GL195
TO-CURR-CODE GL196 GL500
FISCAL-YEAR CU20.3 CU20.4
BUDGET-NBR CU220
TRANSL-CODE
CTRSET5 COMPANY Subset CU20.4
FISCAL-YEAR Where COMPANY != Zeroes
BUDGET-NBR
TRANSL-CODE
FR-CURR-CODE
TO-CURR-CODE
CUTRANSL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
|