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 AC130 AC160 AC190 AC197
AC198 AC20.1 AC20.2 AC20.3 AC20.4 AC20.5
AC20.6 AC20.7 AC247 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 AC98.2 ACAC.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 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 AR08.1
AR09.1 AR10.1 AR12.1 AR12.2 AR15.4 AR301
AR501 AR550 ARLL.1 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 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 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 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 EE520 CA10.5 CA110
FB145 FB190 FB40.1 FB40.2 FB40.3 FB45.1
GL146 GL165 GL167 GL170 GL190 GL196
GL197 GL199 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 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 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
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 GL10.1 GL20.1 GL20.2
GL20.4 IFCU.1 IFGT.1 MX123 MX500 LP198
MA08.1 MA180 MA208 MA26.1 MA279 MA310
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 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 ML40.1 ML40.2 ML40.3
ML40.6 ML40.7 ML40.8 ML44.1 ML45.1 ML65.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 PO150 PO190 PO20.1 PO20.6 PO20.9
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO22.2 PO22.3 PO22.4 PO22.5 PO220 PO223
PO229 PO23.1 PO233 PO24.1 PO25.1 PO25.5
PO25.6 PO25.7 PO253 PO254 PO26.1 PO26.2
PO26.3 PO26.4 PO26.5 PO26.6 PO26.7 PO26.9
PO27.2 PO278 PO28.2 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 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 UK47.1 MM280
MM80.1 MM80.2 RQ01.1 RQ10.1 RQ10.2 RQ10.3
RQ10.4 RQ11.1 RQ12.1 RQ13.1 RQ13.2 RQ260
RQ35.1 RQ500 RQIB.1 RQIC.1 RQID.1 RQIF.1
RQIG.1 RQIJ.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 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 ZW130 AC127
AC27.1 AC47.2 AC81.1 ACVW.1 ATVW.1 BN190
BR570 BR65.1 BR65.2 CBOP.1 CA190 FB100
FB195 FB20.1 FB20.6 FB20.7 FB21.1 GL135
GL191 GL195 GL270 CU00.1 CU160 CU161
CU20.1 CU20.2 CU20.3 CU20.4 CU202 CU210
CU220 CU261 CU60.1 CU61.1 CU61.2 GLAV.1
GLCV.1 GLVW.1 ML167 ML170 ML190 ML191
ML195 ML196 ML270 ML70.1 ML70.2 ML70.3
ML70.5 ML70.6 ML75.1 MLIT.1 SL40.1 SLVW.1
SN40.1 SNOP.1 SNRP.1 SNSP.1 TE01.3 IN20.1


UPDATED BY
CU01.1 CU01.2 CU02.1 CU02.2 CU03.1 CU10.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
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


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
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 11:18:26 2016

Home
Contact Us



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