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
AC191 AP125 AP126 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 API1.1 API2.1 BR44.1
CB222 FB145 FB190 FB195 FB40.1 FB40.2
FB40.3 FB45.1 GL100 GL111 GL120 GL122
GL135 GL146 GL148 GL167 GL190 GL191
GL195 GL196 GL197 GL199 GL330 GL40.1
GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1
DR100 IC141 IC142 IC222 IC83.1 CU00.1
CU01.1 CU01.2 CU02.1 CU02.2 CU03.1 CU10.1
CU10.2 CU202 CU220 GL00.1 GL00.2 GL00.3
GL00.6 GL00.7 GL00.8 GL00.9 GL02.1 GL02.2
GL02.3 GL02.6 GL03.2 GL03.4 GL03.6 GL10.1
GL10.2 GL121 GL124 GL125 GL160 GL161
GL20.1 GL20.2 GL20.4 IFAC.1 IFBD.2 MA41.1
MA41.2 MA41.4 MA41.7 MA42.2 MA43.2 MA44.1
MA44.2 MA61.1 MAI1.1 ML146 ML167 ML190
ML191 ML195 ML196 ML199 ML330 ML40.1
ML40.2 ML40.3 ML40.7 ML40.8 ML44.1 ML45.1
RQ10.1 RQ10.3 RQ11.1 RQ13.2 RQ35.1 RQ500
RQIB.1 RQIF.1 RQIJ.1 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
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
ML195
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
...
AC191 AP125
AP126 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
API2.1 BR44.1
CB222 FB145
FB190 FB195
FB40.1 FB40.2
FB40.3 FB45.1
GL100 GL110
GL111 GL120
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
ML191 ML195
ML196 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


CUTRANSL FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Cutransbod CUTRANSBOD
CTR-CURRENCY-TABLE->YBN-CURRENCY-TABLE
CTR-FR-CURR-CODE->YBN-FR-CURR-CODE
CTR-TO-CURR-CODE->YBN-TP-CURR-CODE
CTR-FISCAL-YEAR->YBN-FISCAL-YEAR
CTR-COMPANY->YBN-COMPANY
CTR-BUDGET-NBR->YBN-BUDGET-NBR
CTR-TRANSL-CODE->YBN-TRANSL-CODE
  YBN-ACCT-PERIOD

File created: Thu Jun 09 02:20:29 2016

Home
Contact Us



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