|
|
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 AC32.1 AC37.1 AC40.1
AC40.4 AC41.1 AC41.4 AC42.1 AC42.2 AC45.1
AC490 AC54.1 AC540 AC581 AC81.1 AC98.2
ACAC.1 ACVW.1 AM115 AM117 AM125 AM135
AM15.1 AM15.2 AM15.3 AM15.4 AM180 AM20.1
AM20.2 AM20.3 AM20.4 AM21.1 AM21.2 AM21.3
AM21.4 AM30.1 AM500 AM502 AM51.1 AM551
AM92.1 AM97.1 AM98.1 AP00.3 AP10.1 AP10.2
AP10.5 AP10.6 AP110 AP115 AP125 AP126
AP131 AP150 AP151 AP170 AP180 AP181
AP190 AP191 AP193 AP210 AP220 AP25.1
AP25.2 AP26.1 AP27.1 AP30.2 AP30.3 AP30.4
AP305 AP510 AP520 AP80.1 AP95.1 API1.1
API2.1 API3.1 API4.1 API5.1 AR08.1 AR09.1
AR10.1 AR100 AR105 AR115 AR12.1 AR12.2
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.6 AR30.7 AR30.8
AR301 AR31.1 AR31.5 AR31.6 AR33.1 AR33.3
AR33.5 AR33.6 AR34.1 AR34.2 AR34.3 AR34.4
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
ARLL.1 BL01.1 BL02.1 BL09.1 BL120 BL122
BL123 BL125 BL130 BL140 BL20.1 BL20.3
BL20.5 BL20.6 BL202 BL21.2 BL21.5 BL29.1
BL29.2 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 BL520 BL80.1 BL802 BL820
BL85.1 BL85.2 BL90.1 BL91.1 BL92.1 BN190
BR00.1 BR00.2 BR02.3 BR10.1 BR10.2 BR11.1
BR120 BR121 BR122 BR130 BR140 BR16.1
BR190 BR20.1 BR20.2 BR20.3 BR20.4 BR20.5
BR20.6 BR40.3 BR41.1 BR41.4 BR420 BR43.1
BR44.1 BR46.1 BR46.2 BR46.4 BR515 BR516
BR521 BR530 BR65.1 BR65.2 BRCC.1 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 FB145 FB190 FB195 FB20.1
FB20.6 FB20.7 FB21.1 FB40.1 FB40.2 FB40.3
FB45.1 GL135 GL146 GL165 GL167 GL170
GL190 GL191 GL195 GL196 GL197 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 IC28.1 IC330 IC500 IC811
IC812 IC83.1 IC840 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 MA180
MA208 MA530 MA531 MA540 MA60.2 MA60.3
MA60.5 MA61.1 MA63.1 MA65.1 MA66.2 MA66.3
MA67.1 MA67.2 MA68.1 MA70.1 MA75.1 MA80.1
MAI1.1 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5
OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8
OE11.9 OE110 OE111 OE112 OE113 OE114
OE116 OE129 OE13.2 OE13.3 OE13.5 OE13.6
OE14.1 OE14.2 OE14.4 OE229 OE283 OE291
OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6
OE30.7 OE30.9 OE310 OE510 OE530 OE80.1
OE80.2 OE80.3 OE80.4 OE80.5 OE81.1 OE810
OE830 OE90.1 OE90.2 PBIP.1 PO100 PO101
PO122 PO130 PO131 PO132 PO135 PO136
PO20.1 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO220 PO23.1 PO25.1 PO25.5 PO25.6
PO25.7 PO26.1 PO27.2 PO29.1 PO295 PO30.1
PO30.2 PO30.3 PO300 PO31.1 PO31.2 PO32.1
PO32.2 PO33.1 PO34.1 PO35.1 PO36.1 PO36.2
PO38.1 PO39.1 PO39.2 PO44.1 PO50.1 PO52.1
PO520 PO536 POED.1 POI3.1 POI7.1 POIE.1
POIF.1 POIG.1 POII.1 POIJ.1 POIM.1 POIT.1
PR05.1 PR05.3 PR197 PR198 PR226 PR247
PR26.1 PR47.1 PR82.1 PR85.1 UK47.1 RQ10.1
RQ10.2 RQ10.3 RQ11.1 RQ12.1 RQ13.1 RQ13.2
RQ35.1 RQ500 RQIB.1 RQIC.1 RQID.1 RQIF.1
RQIG.1 RQIJ.1 SA100 SL40.1 SLVW.1 TE01.3
IN20.1 TX04.1 TX804 WH130 WH132 WH190
WH20.2 WH20.7 WH222 WH30.1 WH30.2 WH30.3
WH30.4 WH31.1 WH31.2 WH31.3 WH31.4 WH32.1
WH32.2 WH32.3 WH32.4 WH33.1 WH33.2 WH33.3
WH33.4 WH33.5 WH33.6 WH33.8 WH33.9 WH34.1
WH34.2 WH34.3 WH34.4 WH40.1 WH40.2 WH520
WH830 WO132 WO140
UPDATED BY
CU02.1 CU02.2 CU03.1 CU162
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CRL-CURRENCY-TABLE Alpha 12 CU02.1 CU02.2
Element: Currency TableThis is a table of currency CU162
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
Element: From Currency This is the name of the currency code CU162
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
Element: To Currency CoThis is the name of the currency code CU162
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 CU162
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
Element: Override TolerThis field determines the override CU162
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
Element: Conversion StaThis field indicates currency exchange CU03.1 CU162
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
Element: Translation StThis field indicates currency CU162
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 CU162
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 CU162
Decimals positions for the To currency.
CRL-TRNGLT-IND Alpha 1 CU02.1 CU02.2
Element: Trnglt Ind Indicates whether the currencies in a CU162
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
Element: Currency Code The currency code of the language used CU162
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
Element: Ovd Prot Ind Yes indicates that the conversion rates CU162
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 AC32.1
AC37.1 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC42.2 AC45.1
AC490 AC54.1
AC540 AC581
AC81.1 AC98.2
...
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
|
