CURELAT FILE
Currency Relationships
This file contains the valid currency relationships used for a specific
currency table. CU02.1 (Currency Relationship) is the primary program that
updates this file.
REFERENCED BY
AC121 AC123 AC127 AC130 AC131 AC190
AC20.1 AC20.2 AC20.3 AC20.4 AC20.5 AC20.6
AC20.7 AC27.1 AC298 AC30.2 AC30.3 AC32.1
AC40.1 AC40.4 AC41.1 AC41.4 AC42.1 AC42.2
AC45.1 AC490 AC54.1 AC54.2 AC54.3 AC540
AC542 AC550 AC581 AC742 AC750 AC81.1
AC98.2 ACAC.1 ACVW.1 GR742 AM115 AM15.1
AM15.2 AM15.3 AM15.4 AM180 AM20.1 AM20.3
AM21.1 AM21.3 AM500 AM51.1 AM551 AM97.1
AP00.3 AP10.1 AP10.2 AP10.5 AP10.6 AP110
AP115 AP150 AP151 AP170 AP180 AP181
AP190 AP191 AP193 AP210 AP220 AP30.2
AP30.3 AP30.4 AP305 AP32.2 AP510 AP520
AP80.1 API1.1 API2.1 API3.1 API4.1 API5.1
AR08.1 AR100 AR105 AR110 AR115 AR124
AR129 AR130 AR131 AR135 AR137 AR15.4
AR150 AR160 AR161 AR170 AR190 AR191
AR196 AR20.1 AR21.1 AR21.2 AR21.3 AR21.4
AR230 AR232 AR24.1 AR25.1 AR250 AR251
AR255 AR258 AR271 AR275 AR29.2 AR30.1
AR30.2 AR30.3 AR30.4 AR30.6 AR30.7 AR30.8
AR30.9 AR31.1 AR31.5 AR31.6 AR35.1 AR35.2
AR36.1 AR42.1 AR42.2 AR42.6 AR42.7 AR42.8
AR43.1 AR44.3 AR45.1 AR48.3 AR50.1 AR501
AR502 AR503 AR504 AR507 AR53.1 AR550
AR560 AR570 AR575 AR580 AR70.1 AR70.2
AR72.1 AR75.1 AR82.1 AR90.1 BL01.1 BL02.1
BL09.1 BL125 BL140 BL202 BL30.1 BL30.2
BL30.3 BL30.5 BL31.1 BL31.2 BL31.3 BL31.5
BL31.7 BL32.1 BL32.2 BL32.3 BL32.4 BL80.1
BL802 BL85.1 BL85.2 BL90.1 BL91.1 BN190
BR00.2 BR10.1 BR10.2 BR11.1 BR120 BR121
BR40.3 BR400 BR41.1 BR420 BRIP.1 CB03.2
CB06.1 CB06.2 CB10.1 CB10.3 CB15.1 CB15.2
CB180 CB191 CB20.1 CB30.1 CB500 CB90.2
CXCP.1 DT150 DT155 DT160 DT161 DT165
DT166 DT170 DT180 DT181 DT185 DT30.1
DT30.2 DT40.1 DT45.1 DT520 DT60.1 DT60.2
DT70.1 DT70.3 DT80.1 DT80.4 DT85.1 DT85.2
DT90.1 DT90.3 DT92.1 EE05.1 EE135 EE20.3
EE35.1 EE35.2 EE520 CA10.5 CA110 CA190
FB100 FB195 FB20.1 FB20.6 FB20.7 FB21.1
GL135 GL146 GL165 GL167 GL170 GL190
GL191 GL195 GL196 GL199 GL270 GL40.1
GL40.2 GL40.3 GL40.6 GL40.7 GL40.8 GL44.1
GL45.1 GL65.1 GL70.1 GL70.2 GL70.3 GL70.5
GL70.6 GL75.1 RW100 DR100 IC02.1 IC10.1
IC10.2 IC11.1 IC12.1 IC130 IC141 IC142
IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2
IC23.1 IC23.2 IC233 IC234 IC24.1 IC24.2
IC25.1 IC330 IC500 IC811 IC812 IC83.1
CU00.1 CU01.1 CU01.2 CU10.1 CU10.2 CU160
CU161 CU20.1 CU20.2 CU20.3 CU20.4 CU202
CU210 CU220 CU261 CU60.1 CU61.1 CU61.2
GL10.1 GLAV.1 GLCV.1 GLVW.1 IFCU.1 IFGT.1
MA08.1 MA126 MA208 MA63.1 MA65.1 MA68.1
PO130 PO132 PO135 PO136 PO220 PO26.1
PO295 POED.1 POI7.1 POIF.1 POIJ.1 POIT.1
PR195 PR197 PR198 PR82.1 PR85.1 RQ11.1
RQ12.1 RQ13.1 SLVW.1 TE01.3 IN20.1 TX04.1
TX804 WH130 WH33.1 WH33.2 WH33.3 WH33.4
WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2
WH34.3 WH34.4
UPDATED BY
CU02.1 CU02.2 CU03.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CRL-CURRENCY-TABLE Alpha 12 CU02.1 CU02.2
Currency Table 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.
CRL-FR-CURR-CODE Alpha 5 CU02.1 CU02.2
From Currency Code This is the name of the currency code
you are converting from. It must be a
valid code in the Currency Codes file.
CRL-TO-CURR-CODE Alpha 5 CU02.1 CU02.2
To Currency Code This is the name of the currency code
you are converting to. It must be a
valid code in the Currency Codes file.
CRL-MULT-DIV Alpha 1 CU02.1 CU02.2
Multiply/Divide The Multiply/Divide field determines
Option how rates are applied during conversion
and translation.
Use Multiply, the default value, to
multiply the From currency amount by the
rate to calculate the To currency
amount.
Use Divide to divide the From currency
amount by the rate to calculate the To
currency amount.
M = Multiply
D = Divide
CRL-OVD-TOLERANCE Numeric 3 CU02.1 CU02.2
Override Tolerance This field determines the override
tolerance of an exchange rate. Values
from 0 to 100 are acceptable. A value of
0 is the default and means any override
rate is acceptable. Any other value
indicates the percentage (tolerance) the
override rate can be over the table
rate.
000
100
CRL-CONV-STATUS Alpha 1 CU02.1 CU02.2
Conversion Status This field indicates currency exchange CU03.1
relationship status.
Use Active, the default value, to let
conversion activity take place for the
relationship.
Use Inactive to prevent conversion
activity.
A = Active
I = Inactive
CRL-TRANSL-STATUS Alpha 1 CU02.1 CU02.2
Translation Status This field indicates currency
translation status.
Use Active, the default value, to let
translation activity take place for the
relationship.
Use Inactive to prevent translation
activity.
A = Active
I = Inactive
CRL-FR-CURR-ND Numeric 1 CU02.1 CU02.2
From Currency Nbr This is the currency number of decimal
of Decimals positions for the From currency.
CRL-TO-CURR-ND Numeric 1 CU02.1 CU02.2
To Currency Nbr of This is the currency number of decimal
Decimals positions for the To currency.
CRL-TRNGLT-IND Alpha 1 CU02.1 CU02.2
Trnglt Ind Indicates whether the currencies in a
conversion need to be converted by way
of a third currency. Required for
member currencies of the European Union.
CRL-TRNGLT-CURR-CD Alpha 5 CU02.1 CU02.2
Trnglt Curr Cd The currency code of the language used
to triangulate a conversion. For
European Union (EU) currencies, the
triangulation currency must be the
Euro.
CRL-OVD-PROT-IND Alpha 1 CU02.1 CU02.2
Ovd Prot Ind Yes indicates that the conversion rates
cannot be overridden. The default is No.
Yes is required when the Triangulate
indicator is set to Yes.
CURELAT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CRLSET1 CURRENCY-TABLEThis path is used to retrieve AC121 AC123
FR-CURR-CODE relationships by "From" currency. AC127 AC130
TO-CURR-CODE AC131 AC190
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.6
AC20.7 AC27.1
AC298 AC30.2
AC30.3 AC32.1
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC42.2
AC45.1 AC490
AC54.1 AC54.2
AC54.3 AC540
...
CURELAT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Fr Cucodes CUCODES Required
CRL-FR-CURR-CODE -> CUC-CURRENCY-CODE
To Cucodes CUCODES Required
CRL-TO-CURR-CODE -> CUC-CURRENCY-CODE
Via Cucodes CUCODES Not Required
CRL-TRNGLT-CURR-CD -> CUC-CURRENCY-CODE
CURELAT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Cuacct CUACCT
CRL-CURRENCY-TABLE -> CUA-CURRENCY-TABLE
CRL-FR-CURR-CODE -> CUA-FR-CURR-CODE
CRL-TO-CURR-CODE -> CUA-TO-CURR-CODE
CUA-COMPANY
CUA-SYSTEM
Cuconv CUCONV Delete Restricted
CRL-CURRENCY-TABLE -> CCN-CURRENCY-TABLE
CRL-FR-CURR-CODE -> CCN-FR-CURR-CODE
CRL-TO-CURR-CODE -> CCN-TO-CURR-CODE
CCN-SYSTEM
CCN-EFFECT-DATE
Cuconv Dec CUCONV
CRL-CURRENCY-TABLE -> CCN-CURRENCY-TABLE
CRL-FR-CURR-CODE -> CCN-FR-CURR-CODE
CRL-TO-CURR-CODE -> CCN-TO-CURR-CODE
CCN-SYSTEM
CCN-EFFECT-DATE
Cutransl CUTRANSL
CRL-CURRENCY-TABLE -> CTR-CURRENCY-TABLE
CRL-FR-CURR-CODE -> CTR-FR-CURR-CODE
CRL-TO-CURR-CODE -> CTR-TO-CURR-CODE
CTR-FISCAL-YEAR
CTR-COMPANY
CTR-BUDGET-NBR
CTR-TRANSL-CODE
Glsystem GLSYSTEM
CRL-CURRENCY-TABLE -> GLS-CURRENCY-TABLE
GLS-COMPANY
|
