|
|
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
AC192 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 AC54.2 AC54.3
AC540 AC541 AC542 AC550 AC581 AC81.1
AC98.2 ACAC.1 ACVW.1 AM115 AM125 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
AM500 AM51.1 AM551 AM97.1 AM98.1 AP00.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 AP210 AP220 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 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 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.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 BN190 BR00.2
BR10.1 BR10.2 BR11.1 BR120 BR121 BR122
BR123 BR124 BR130 BR15.2 BR151 BR152
BR153 BR154 BR156 BR16.1 BR40.3 BR400
BR41.1 BR41.4 BR420 BR43.1 BR51.1 BR51.2
BR52.1 BR52.5 BR521 BR530 BR65.1 BR65.2
BRCC.1 BRIP.1 BRPI.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 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 MA41.1 MA41.2
MA41.4 MA41.7 MA43.1 MA43.2 MA43.3 MA43.4
MA43.5 MA43.7 MA43.8 MA43.9 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 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 PO229 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 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 RQ10.1 RQ10.2 RQ10.3 RQ11.1
RQ12.1 RQ13.1 RQ35.1 RQ500 RQIB.1 RQIC.1
RQID.1 RQIE.1 RQIF.1 RQIG.1 RQIJ.1 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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CRL-CURRENCY-TABLE Alpha 12 CU02.1 CU02.2
Element: Currency TableThis 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
Element: From Currency 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
Element: To Currency CoThis 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
Element: Override TolerThis 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
Element: Conversion StaThis 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
Element: Translation StThis 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
Element: 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
Element: Trnglt Curr CdThe 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
Element: 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
AC192 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
AC54.2 AC54.3
...
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
|
