CURELAT

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
AC191 AC197 AC198 AC20.1 AC20.2 AC20.3
AC20.4 AC20.5 AC20.6 AC20.7 AC247 AC27.1
AC298 AC32.1 AC37.1 AC40.1 AC40.4 AC41.1
AC41.4 AC42.1 AC42.2 AC45.1 AC47.2 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 AM22.1
AM22.2 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 AP255 AP26.1 AP265 AP27.1
AP271 AP30.2 AP30.3 AP30.4 AP300 AP305
AP510 AP520 AP80.1 AP81.1 AP90.1 AP90.5
AP91.1 AP95.1 API1.1 API2.1 API3.1 API4.1
API5.1 API6.2 AR08.1 AR09.1 AR10.1 AR12.1
AR12.2 AR15.4 AR301 AR501 AR550 ARLL.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 BR40.4
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 CB10.5 CB145
CB15.1 CB15.2 CB150 CB180 CB185 CB186
CB187 CB190 CB191 CB20.1 CB20.6 CB222
CB25.1 CB30.1 CB43.1 CB44.1 CB45.1 CB46.1
CB50.1 CB500 CB54.1 CB543 CB544 CB55.1
CB554 CB80.1 CB82.1 CB90.2 CBOP.1 CX05.1
CX05.2 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 CX805 CXCP.1
EE05.1 EE11.1 EE135 EE20.3 EE35.1 EE35.2
EE52.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 GL100
GL110 GL111 GL120 GL122 GL135 GL146
GL148 GL165 GL167 GL170 GL190 GL191
GL195 GL196 GL197 GL199 GL270 GL330
GL40.1 GL40.2 GL40.3 GL40.6 GL40.7 GL40.8
GL44.1 GL45.1 GL500 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
IC140 IC141 IC142 IC145 IC20.1 IC20.2
IC21.1 IC21.2 IC22.1 IC22.2 IC222 IC23.1
IC23.2 IC233 IC234 IC24.1 IC24.2 IC243
IC247 IC25.1 IC330 IC500 IC64.1 IC64.2
IC64.3 IC64.4 IC64.5 IC64.6 IC64.7 IC64.8
IC64.9 IC66.1 IC802 IC81.1 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 EX175 EX542 GL00.1 GL00.2
GL00.3 GL00.6 GL00.7 GL00.8 GL00.9 GL02.1
GL02.2 GL02.3 GL02.6 GL03.2 GL03.4 GL03.6
GL10.1 GL10.2 GL121 GL124 GL125 GL160
GL161 GL20.1 GL20.2 GL20.4 GLAV.1 GLCV.1
GLVW.1 IFAC.1 IFCU.1 IFGT.1 MX123 MX500
LP198 MA08.1 MA126 MA180 MA208 MA26.1
MA278 MA279 MA41.1 MA41.2 MA41.4 MA41.7
MA42.1 MA42.2 MA43.1 MA43.2 MA43.3 MA43.4
MA43.6 MA43.7 MA44.1 MA44.2 MA53.1 MA530
MA531 MA540 MA60.2 MA60.3 MA60.5 MA61.1
MA63.1 MA64.9 MA65.1 MA66.2 MA66.3 MA67.2
MA67.3 MA68.2 MA68.3 MA68.5 MA69.1 MA70.1
MA75.1 MA80.1 MAED.1 MAI1.1 ML146 ML165
ML167 ML170 ML190 ML191 ML195 ML196
ML199 ML270 ML330 ML40.1 ML40.2 ML40.3
ML40.6 ML40.7 ML40.8 ML44.1 ML45.1 ML65.1
ML70.1 ML70.2 ML70.3 ML70.5 ML70.6 ML75.1
MLIT.1 PD10.1 PD10.2 PD130 PD20.1 PD20.2
PD20.3 PD21.1 PD22.1 PD235 PD570 PO04.1
PO04.2 PO10.1 PO10.2 PO100 PO101 PO115
PO120 PO122 PO130 PO131 PO132 PO135
PO136 PO15.1 PO15.2 PO15.4 PO150 PO17.1
PO190 PO192 PO195 PO20.1 PO20.6 PO20.9
PO204 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO22.2 PO22.3 PO22.4 PO22.5 PO220
PO222 PO223 PO224 PO225 PO229 PO23.1
PO230 PO233 PO234 PO24.1 PO25.1 PO25.5
PO25.6 PO25.7 PO251 PO253 PO254 PO26.1
PO26.2 PO26.3 PO26.4 PO26.5 PO26.6 PO26.7
PO26.9 PO27.2 PO27.3 PO27.4 PO275 PO276
PO277 PO278 PO28.2 PO280 PO29.1 PO295
PO30.1 PO30.2 PO30.3 PO30.4 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 PO529 PO53.4
PO536 PO54.1 PO54.2 PO54.3 PO54.4 PO54.5
POCP.1 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 PR582 PR82.1 PR85.1
MM280 MM80.1 MM80.2 RQ01.1 RQ10.1 RQ10.2
RQ10.3 RQ10.4 RQ10.5 RQ11.1 RQ11.3 RQ11.4
RQ11.5 RQ12.1 RQ13.1 RQ13.2 RQ260 RQ35.1
RQ44.1 RQ500 RQ810 RQIB.1 RQIC.1 RQID.1
RQIF.1 RQIG.1 RQII.1 RQIJ.1 SL40.1 SLVW.1
SN40.1 SNOP.1 SNRP.1 SNSP.1 TE01.3 TEI1.1
IN20.1 TX04.1 TX100 TX140 TX804 TXI1.1
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
WH32.5 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
Element: Currency Table
Alpha 12
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.
CU02.1 CU02.2
CU162
CRL-FR-CURR-CODE
Element: From Currency Code
Alpha 5
This is the name of the currency code you are converting from. It must be a valid code in the Currency Codes file.
CU02.1 CU02.2
CU162
CRL-TO-CURR-CODE
Element: To Currency Code
Alpha 5
This is the name of the currency code you are converting to. It must be a valid code in the Currency Codes file.
CU02.1 CU02.2
CU162
CRL-MULT-DIV
Element: Mult Div
Alpha 1
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
CU02.1 CU02.2
CU162
CRL-OVD-TOLERANCE
Element: Override Tolerance
Numeric 3
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
CU02.1 CU02.2
CU162
CRL-CONV-STATUS
Element: Conversion Status
Alpha 1
This field indicates currency exchange 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
CU02.1 CU02.2
CU03.1 CU162
CRL-TRANSL-STATUS
Element: Translation Status
Alpha 1
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
CU02.1 CU02.2
CU162
CRL-FR-CURR-ND
From Currency Nbr
of Decimals
Numeric 1
This is the currency number of decimal positions for the From currency.
CU02.1 CU02.2
CU162
CRL-TO-CURR-ND
To Currency Nbr of
Decimals
Numeric 1
This is the currency number of decimal positions for the To currency.
CU02.1 CU02.2
CU162
CRL-TRNGLT-IND
Element: Trnglt Ind
Alpha 1
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.
CU02.1 CU02.2
CU162
CRL-TRNGLT-CURR-CD
Element: Currency Code
Alpha 5
The currency code of the language used to triangulate a conversion. For European Union (EU) currencies, the triangulation currency must be the Euro.
CU02.1 CU02.2
CU162
CRL-OVD-PROT-IND
Element: Ovd Prot Ind
Alpha 1
Yes indicates that the conversion rates cannot be overridden. The default is No. Yes is required when the Triangulate indicator is set to Yes.
CU02.1 CU02.2
CU162


CURELAT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CRLSET1 CURRENCY-TABLE
FR-CURR-CODE
TO-CURR-CODE
...
AC121 AC123
AC127 AC130
AC160 AC190
AC191 AC197
AC198 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC247 AC27.1
AC298 AC32.1
AC37.1 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC42.2 AC45.1
AC47.2 AC490


CURELAT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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
Curelatau CURELATAU
CRL-CURRENCY-TABLE->CRA-CURRENCY-TABLE
CRL-FR-CURR-CODE->CRA-FR-CURR-CODE
CRL-TO-CURR-CODE->CRA-TO-CURR-CODE
  CRA-ACTION
  CRA-DATE
  CRA-TIME
  CRA-UNIQUE-I-D
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


File created: Thu Jun 09 02:20:27 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.