CUCONV FILE
Currency Conversion
This file maintains rate tables for each defined currency relationship.
CU10.1 (Exchange Rates) is the primary program that updates this file. It
creates a single currency relationship with all of the rates sequenced by
effective date. Rates can be maintained as often as once a day.
REFERENCED BY
AC550 CU02.1 CU02.2 AC121 AC123 AC127
AC130 AC131 AC192 AC20.1 AC20.2 AC20.3
AC20.4 AC20.5 AC20.6 AC20.7 AC27.1 AC298
AC32.1 AC40.1 AC40.4 AC41.1 AC41.4 AC42.1
AC42.2 AC45.1 AC490 AC54.1 AC54.2 AC54.3
AC540 AC542 AC581 AC81.1 AC98.2 ACAC.1
ACVW.1 AM115 AM15.1 AM15.2 AM15.3 AM15.4
AM180 AM20.1 AM20.3 AM21.1 AM21.3 AM500
AM51.1 AM551 AM97.1 AP00.3 AP10.1 AP10.2
AP10.5 AP10.6 AP110 AP115 AP125 AP126
AP131 AP150 AP151 AP170 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 AR110
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 DA90.1 DA91.1 BN190 BR00.2
BR10.1 BR10.2 BR11.1 BR120 BR121 BR40.3
BR400 BR41.1 BR420 BRIP.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 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
CU202 CU210 GLAV.1 GLCV.1 GLVW.1 IFCU.1
IFGT.1 MA08.1 MA126 MA180 MA208 MA41.1
MA41.2 MA41.4 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 MAI1.1 PBIP.1 PO100 PO101 PO122
PO130 PO131 PO132 PO135 PO136 PO20.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO220
PO23.1 PO25.2 PO25.6 PO25.7 PO25.8 PO26.1
PO27.3 PO29.1 PO295 PO30.1 PO30.2 PO30.3
PO300 PO31.1 PO31.2 PO32.1 PO32.2 PO33.1
PO34.1 PO35.1 PO38.1 PO39.1 PO39.2 PO44.1
PO50.1 PO52.1 PO520 POED.1 POI3.1 POI7.1
POIE.1 POIF.1 POIG.1 POII.1 POIJ.1 POIT.1
PR195 PR197 PR198 PR82.1 PR85.1 RQ10.1
RQ10.2 RQ10.3 RQ11.1 RQ12.1 RQ13.1 RQ35.1
RQ500 RQIB.1 RQIC.1 RQIF.1 RQIG.1 SL195
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
UPDATED BY
CU10.1 CU10.2 CU160 CU300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CCN-CURRENCY-TABLE Alpha 12 CU10.1 CU10.2
Currency Table This is the currency table, a table of CU160
currency relationships, currency
exchange rates, and translation rates
for one or more companies.
CCN-FR-CURR-CODE Alpha 5 CU10.1 CU10.2
From Currency Code This is the name of the currency code CU160
you are converting from. It must be
defined in the Currency Codes file.
CCN-TO-CURR-CODE Alpha 5 CU10.1 CU10.2
To Currency Code The name of the currency code you are CU160
converting to. It must be defined in the
Currency Codes file.
CCN-SYSTEM Alpha 2 CU10.1 CU10.2
System The system code is a two-character code CU160
representing an application used within
the Lawson system. (For example, GL =
General Ledger, AP = Accounts Payable,
etc.)
CCN-EFFECT-DATE Numeric 8 (yyyymmdd) CU10.1 CU10.2
Effective Date The effective date is the date the CU160
exchange rate is effective. This date is
used until a new exchange rate is
defined with a later date.
CCN-SELL-RATE Signed 12.6 CU10.1 CU10.2
Selling Rate This field contains the rate the From CU160
currency amount to the To currency
amount is converted at.
CUCONV FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CCNSET1 CURRENCY-TABLEThis path is used to retrieve AC550 CU02.1
FR-CURR-CODE conversion rates by "From/To" currency CU02.2 CU10.1
TO-CURR-CODE and effective date (ascending). CU10.2 CU160
SYSTEM
EFFECT-DATE
CCNSET2 CURRENCY-TABLEThis path is used to retrieve AC121 AC123
FR-CURR-CODE conversion rates by "From/To" currency AC127 AC130
TO-CURR-CODE and effective date (descending). AC131 AC192
SYSTEM AC20.1 AC20.2
EFFECT-DATE* AC20.3 AC20.4
AC20.5 AC20.6
AC20.7 AC27.1
AC298 AC32.1
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC42.2
AC45.1 AC490
AC54.1 AC54.2
AC54.3 AC540
AC542 AC581
...
CCNSET3 CURRENCY-TABLEThis path is used to retrieve CU10.2 CU300
EFFECT-DATE* conversion rates by "From/To" currency
FR-CURR-CODE and effective date (descending).
TO-CURR-CODE
SYSTEM
CUCONV FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Curelat CURELAT Required
CCN-CURRENCY-TABLE -> CRL-CURRENCY-TABLE
CCN-FR-CURR-CODE -> CRL-FR-CURR-CODE
CCN-TO-CURR-CODE -> CRL-TO-CURR-CODE
Fr Cucodes CUCODES Required
CCN-FR-CURR-CODE -> CUC-CURRENCY-CODE
To Cucodes CUCODES Required
CCN-TO-CURR-CODE -> CUC-CURRENCY-CODE
CUCONV FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Glsystem GLSYSTEM
CCN-CURRENCY-TABLE -> GLS-CURRENCY-TABLE
GLS-COMPANY
|