|
|
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 AC15.1 AC160
AC20.1 AC20.2 AC20.3 AC20.4 AC22.1 AC30.2
AC30.3 AC32.1 AC40.1 AC41.1 AC42.1 AC45.1
AC54.1 AC540 AC70.3 ACAC.1 ACVW.1 AM115
AM15.1 AM15.2 AM15.3 AM15.4 AM20.1 AM20.3
AM500 AM97.1 AP00.3 AP10.1 AP10.2 AP10.5
AP10.6 AP110 AP125 AP126 AP150 AP151
AP170 AP180 AP181 AP190 AP191 AP193
AP20.1 AP20.2 AP20.5 AP20.6 AP20.7 AP20.8
AP210 AP225 AP226 AP23.1 AP25.1 AP25.2
AP26.1 AP30.2 AP30.3 AP30.4 AP32.2 AP510
AP520 AP80.1 AR08.1 AR10.1 AR100 AR105
AR110 AR115 AR12.1 AR12.2 AR124 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 AR50.1 AR501 AR502 AR503 AR504
AR507 AR53.1 AR550 AR560 AR570 AR575
AR580 AR70.1 AR70.2 AR72.1 AR73.1 AR75.1
AR82.1 AR90.1 AR970 AR973 BL02.1 BL08.1
BL09.1 BL120 BL122 BL130 BL140 BL20.1
BL20.3 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 BL902 BL91.1 BL92.1 BL940
CB03.2 CB06.1 CB06.2 CB10.1 CB10.3 CB15.1
CB15.2 CB180 CB191 CB20.1 CB30.1 CB500
CB733 CB90.2 CX05.1 CX05.2 CX100 CX20.1
CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300
CX506 CX805 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.3
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 GL170
GL190 GL191 GL195 GL196 GL199 GL270
GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL40.9
GL44.1 GL45.1 GL65.1 GL70.1 GL70.2 GL70.3
GL70.6 GL70.7 GL75.1 RW100 DR100 IC02.1
IC10.1 IC10.2 IC11.1 IC12.1 IC130 IC140
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 IC50.2 IC500 IC522
IC523 IC524 IC525 IC526 IC811 IC812
IC83.1 PC120 PC20.1 PC540 CU00.1 CU01.1
CU01.2 CU10.1 CU10.2 CU160 CU20.1 CU20.2
CU20.3 CU20.4 CU202 CU210 CU220 CU60.1
GL10.1 GLCV.1 GLVW.1 IFCR.1 IFCU.1 IFGT.1
IN20.1 MA08.1 MA140 MA208 MA40.1 MA40.2
MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1
MA43.2 MA43.3 MA43.4 MA52.1 MA520 MA530
MA540 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 OE112 OE113 OE114 OE129
OE14.1 OE14.2 OE14.4 OE15.1 OE15.2 OE15.3
OE15.4 OE15.5 OE15.7 OE283 OE291 OE30.1
OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7
OE30.9 OE310 OE510 OE80.1 OE80.2 OE80.3
OE80.4 OE80.5 OE810 OE830 OE90.2 OE920
OE950 PBIP.1 PO100 PO120 PO121 PO122
PO123 PO130 PO132 PO135 PO150 PO180
PO20.1 PO21.1 PO21.2 PO21.3 PO21.5 PO21.6
PO216 PO22.1 PO22.2 PO22.3 PO220 PO225
PO227 PO25.1 PO25.2 PO25.3 PO25.4 PO25.7
PO26.1 PO274 PO28.3 PO28.6 PO28.8 PO30.1
PO31.1 PO32.1 PO33.1 PO34.1 PO35.1 PO530
PO820 PO821 PO990 PR150 PR195 PR199
PR82.1 PR85.1 RQ10.1 RQ10.2 RQ10.3 RQ11.1
RQ12.1 RQ13.1 RQ20.1 RQ20.2 RQ20.3 RQ20.4
RQ35.1 RQ500 RQ990 SEA3.1 SA100 SL40.1
TE01.3 TX04.1 TX804 TX904 WH130 WH132
WH190 WH20.2 WH20.7 WH222 WH30.1 WH30.2
WH30.3 WH31.1 WH31.2 WH31.3 WH32.1 WH32.2
WH32.3 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
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 or Divide The Multiply/Divide field determines
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
Triangulate Indicates whether the currencies in a
Indicator conversion need to be converted by way
of a third currency. Required for
member currencies of the European Union.
" " = No
Y = Yes
N = No
CRL-TRNGLT-CURR-CD Alpha 5 CU02.1 CU02.2
Triangulate The currency code of the language used
Currency Code 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
Override Protection Yes indicates that the conversion rates
Indicator cannot be overridden. The default is No.
Yes is required when the Triangulate
indicator is set to Yes.
" " = No
Y = Yes
N = No
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 AC15.1 AC160
AC20.1 AC20.2
AC20.3 AC20.4
AC22.1 AC30.2
AC30.3 AC32.1
AC40.1 AC41.1
AC42.1 AC45.1
AC54.1 AC540
AC70.3 ACAC.1
ACVW.1 AM115
AM15.1 AM15.2
AM15.3 AM15.4
AM20.1 AM20.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
|