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
ACAC.1 ACVW.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 AP255 AP26.1
AP265 AP27.1 AP30.2 AP30.3 AP30.4 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 BN190 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 CBOP.1 EE05.1 EE11.1
EE135 EE20.3 EE35.1 EE35.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 GL135 GL146 GL165 GL167
GL170 GL190 GL191 GL195 GL196 GL197
GL199 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
CU160 CU161 CU20.1 CU20.2 CU20.3 CU20.4
CU210 CU220 CU60.1 CU61.1 CU61.2 EX175
EX542 GL10.1 GLAV.1 GLCV.1 GLVW.1 IFCU.1
IFGT.1 MX123 MX500 LP198 MA08.1 MA208
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MA540 MAED.1
MAI1.1 PO10.1 PO136 PO190 PO300 PO520
PO53.4 POCP.1 POED.1 POI3.1 POI7.1 POIF.1
POIG.1 POII.1 POIJ.1 POIM.1 PR05.1 PR05.3
PR195 PR197 PR198 PR226 PR247 PR26.1
PR47.1 PR514 PR582 PR82.1 PR85.1 UK47.1
MM280 RQ01.1 SL40.1 SLVW.1 SNOP.1 SNRP.1
SNSP.1 TE01.3 IN20.1 TX04.1 TX140 TX804


UPDATED BY
CU02.1 CU02.2 CU03.1 CU162 CU00.1 CU01.1
CU01.2 CU10.1 CU202 CU261 SN40.1

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
...
ACAC.1 ACVW.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


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: Wed Jun 08 20:49:42 2016

Home
Contact Us



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