|
|
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 AC160 AC190
AC197 AC198 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 AC56.1
AC560 AC581 AC81.1 AC98.2 ACAC.1 ACVW.1
ATVW.1 AM115 AM117 AM125 AM135 AM15.1
AM15.2 AM15.3 AM15.4 AM180 AM19.1 AM19.2
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 AP00.4
AP03.3 AP10.1 AP10.2 AP10.5 AP10.6 AP110
AP115 AP125 AP126 AP131 AP150 AP151
AP170 AP175 AP180 AP181 AP190 AP191
AP193 AP20.1 AP20.2 AP20.3 AP20.4 AP20.5
AP20.6 AP20.7 AP20.8 AP21.1 AP210 AP220
AP23.1 AP25.1 AP25.2 AP26.1 AP27.1 AP30.2
AP30.3 AP30.4 AP305 AP510 AP520 AP80.1
AP90.1 AP91.1 AP95.1 API1.1 API2.1 API3.1
API4.1 API5.1 AR08.1 AR09.1 AR10.1 AR100
AR115 AR12.1 AR12.2 AR120 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 AR237 AR239 AR24.1 AR250 AR251
AR255 AR258 AR271 AR275 AR29.2 AR296
AR30.1 AR30.2 AR30.3 AR30.6 AR30.7 AR30.8
AR301 AR32.1 AR32.3 AR33.1 AR33.3 AR33.5
AR33.6 AR34.1 AR34.2 AR34.3 AR34.4 AR35.1
AR35.2 AR36.1 AR38.1 AR39.1 AR39.2 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 BR123
BR124 BR130 BR140 BR151 BR152 BR153
BR154 BR156 BR16.1 BR165 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 BR48.1 BR51.1 BR51.2 BR515
BR516 BR52.1 BR52.5 BR521 BR530 BR570
BR65.1 BR65.2 BR70.1 BR70.2 BRIP.1 CB03.2
CB06.1 CB06.2 CB10.1 CB10.3 CB145 CB15.1
CB15.2 CB150 CB180 CB185 CB191 CB20.1
CB30.1 CB43.1 CB44.1 CB45.1 CB46.1 CB50.1
CB500 CB54.1 CB543 CB544 CB55.1 CB554
CB90.2 CBOP.1 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 ET175
ET530 ET540 ET542 ET700 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 IC02.1 IC11.1
IC12.1 IC130 IC330 IC811 IC812 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 MX123
MX500 LP198 MA08.1 MA180 MA208 MA279
MA310 MA41.1 MA41.2 MA41.4 MA41.7 MA43.1
MA43.2 MA43.3 MA43.4 MA43.6 MA43.7 MA530
MA531 MA540 MA60.2 MA60.3 MA60.5 MA61.1
MA63.1 MA65.1 MA66.2 MA66.3 MA67.2 MA67.3
MA68.2 MA68.3 MA68.5 MA70.1 MA75.1 MA80.1
MAI1.1 PD10.1 PD10.2 PD130 PD20.1 PD20.2
PD20.3 PD21.1 PD22.1 PD235 PO10.1 PO100
PO101 PO120 PO122 PO130 PO131 PO132
PO135 PO136 PO190 PO20.1 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO220 PO223
PO229 PO23.1 PO233 PO24.1 PO25.1 PO25.5
PO25.6 PO25.7 PO253 PO254 PO26.1 PO27.2
PO278 PO29.1 PO295 PO30.1 PO30.2 PO30.3
PO300 PO31.1 PO31.2 PO32.1 PO32.2 PO32.4
PO33.1 PO34.1 PO35.1 PO36.1 PO36.2 PO38.1
PO39.1 PO39.2 PO44.1 PO50.1 PO52.1 PO520
PO53.4 PO536 PO54.1 PO54.2 PO54.3 PO54.4
POED.1 POI3.1 POI7.1 POID.1 POIF.1 POIG.1
POII.1 POIJ.1 POIM.1 POIT.1 PR05.1 PR05.3
PR195 PR197 PR198 PR226 PR247 PR26.1
PR47.1 PR514 PR82.1 PR85.1 UK47.1 PW110
PW550 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 SB15.1 SB515
SL40.1 SLVW.1 SN40.1 SNOP.1 SNRP.1 SNSP.1
TE01.3 IN20.1 TX04.1 TX140 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
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
Element: Mult Div The Multiply/Divide field determines CU162
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-TABLE AC121 AC123
FR-CURR-CODE AC127 AC130
TO-CURR-CODE AC160 AC190
AC197 AC198
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 AC56.1
...
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
|
