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