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 AC750 CU02.1 CU02.2 AC121 AC123
AC127 AC130 AC131 AC190 AC20.1 AC20.2
AC20.3 AC20.4 AC20.5 AC20.6 AC20.7 AC27.1
AC298 AC30.2 AC30.3 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
AC742 AC81.1 AC98.2 ACAC.1 ACVW.1 GR742
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 AP150 AP151 AP170
AP180 AP181 AP190 AP191 AP193 AP210
AP220 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 AR100 AR105 AR110
AR115 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
BL01.1 BL02.1 BL09.1 BL125 BL140 BL202
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 BL80.1 BL802 BL85.1 BL85.2 BL90.1
BL91.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 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 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 IC330 IC500 IC811 IC812
IC83.1 CU202 CU210 GLAV.1 GLCV.1 GLVW.1
IFCU.1 IFGT.1 MA08.1 MA126 MA208 MA63.1
MA65.1 MA68.1 PO130 PO132 PO135 PO136
PO220 PO26.1 PO295 POED.1 POI7.1 POIF.1
POIJ.1 POIT.1 PR195 PR197 PR198 PR82.1
PR85.1 RQ11.1 RQ12.1 RQ13.1 SLVW.1 TE01.3
IN20.1 TX04.1 TX804 WH130 WH33.1 WH33.2
WH33.3 WH33.4 WH33.5 WH33.6 WH33.8 WH33.9
WH34.1 WH34.2 WH34.3 WH34.4
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 AC750
FR-CURR-CODE conversion rates by "From/To" currency CU02.1 CU02.2
TO-CURR-CODE and effective date (ascending). CU10.1 CU10.2
SYSTEM CU160
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 AC190
SYSTEM AC20.1 AC20.2
EFFECT-DATE* AC20.3 AC20.4
AC20.5 AC20.6
AC20.7 AC27.1
AC298 AC30.2
AC30.3 AC32.1
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC42.2
AC45.1 AC490
AC54.1 AC54.2
AC54.3 AC540
...
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
|