|
|
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
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 AC32.1
AC37.1 AC40.1 AC40.4 AC41.1 AC41.4 AC42.1
AC42.2 AC45.1 AC490 AC54.1 AC540 AC581
AC81.1 AC98.2 ACAC.1 ACVW.1 AM115 AM117
AM125 AM135 AM15.1 AM15.2 AM15.3 AM15.4
AM180 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
AP10.1 AP10.2 AP10.5 AP10.6 AP110 AP115
AP125 AP126 AP131 AP150 AP151 AP170
AP180 AP181 AP190 AP191 AP193 AP210
AP220 AP25.1 AP25.2 AP26.1 AP27.1 AP30.2
AP30.3 AP30.4 AP305 AP510 AP520 AP80.1
AP95.1 API1.1 API2.1 API3.1 API4.1 API5.1
AR08.1 AR09.1 AR10.1 AR100 AR105 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.6
AR30.7 AR30.8 AR301 AR31.1 AR31.5 AR31.6
AR33.1 AR33.3 AR33.5 AR33.6 AR34.1 AR34.2
AR34.3 AR34.4 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 ARLL.1 BL01.1 BL02.1 BL09.1
BL120 BL122 BL123 BL125 BL130 BL140
BL20.1 BL20.3 BL20.5 BL20.6 BL202 BL21.2
BL21.5 BL29.1 BL29.2 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 BL520 BL80.1
BL802 BL820 BL85.1 BL85.2 BL90.1 BL91.1
BL92.1 BN190 BR00.1 BR00.2 BR02.3 BR10.1
BR10.2 BR11.1 BR120 BR121 BR122 BR130
BR140 BR16.1 BR190 BR20.1 BR20.2 BR20.3
BR20.4 BR20.5 BR20.6 BR40.3 BR41.1 BR41.4
BR420 BR43.1 BR44.1 BR46.1 BR46.2 BR46.4
BR515 BR516 BR521 BR530 BR65.1 BR65.2
BRCC.1 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 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
MA75.1 MA80.1 MAI1.1 OE10.1 OE10.2 OE10.3
OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1
OE11.4 OE11.8 OE11.9 OE110 OE111 OE112
OE113 OE114 OE116 OE129 OE13.2 OE13.3
OE13.5 OE13.6 OE14.1 OE14.2 OE14.4 OE229
OE283 OE291 OE30.1 OE30.2 OE30.3 OE30.4
OE30.5 OE30.6 OE30.7 OE30.9 OE310 OE510
OE530 OE80.1 OE80.2 OE80.3 OE80.4 OE80.5
OE81.1 OE810 OE830 OE90.1 OE90.2 PBIP.1
PO100 PO101 PO122 PO130 PO131 PO132
PO135 PO136 PO20.1 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO220 PO23.1 PO25.1
PO25.5 PO25.6 PO25.7 PO26.1 PO27.2 PO29.1
PO295 PO30.1 PO30.2 PO30.3 PO300 PO31.1
PO31.2 PO32.1 PO32.2 PO33.1 PO34.1 PO35.1
PO36.1 PO36.2 PO38.1 PO39.1 PO39.2 PO44.1
PO50.1 PO52.1 PO520 PO536 POED.1 POI3.1
POI7.1 POIE.1 POIF.1 POIG.1 POII.1 POIJ.1
POIM.1 POIT.1 PR05.1 PR05.3 PR197 PR198
PR226 PR247 PR26.1 PR47.1 PR82.1 PR85.1
UK47.1 RQ10.1 RQ10.2 RQ10.3 RQ11.1 RQ12.1
RQ13.1 RQ13.2 RQ35.1 RQ500 RQIB.1 RQIC.1
RQID.1 RQIF.1 RQIG.1 RQIJ.1 SA100 SL40.1
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 WO132 WO140
UPDATED BY
CU10.1 CU10.2 CU160 CU300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CCN-CURRENCY-TABLE Alpha 12 CU10.1 CU10.2
Element: Currency TableThis 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
Element: From Currency 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
Element: To Currency CoThe 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
Element: 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
Element: Effective DateThe 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 14.7 CU10.1 CU10.2
Element: 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 CU02.1 CU02.2
FR-CURR-CODE conversion rates by "From/To" currency CU10.1 CU10.2
TO-CURR-CODE and effective date (ascending). 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 AC190
SYSTEM AC20.1 AC20.2
EFFECT-DATE* AC20.3 AC20.4
AC20.5 AC20.6
AC20.7 AC27.1
AC298 AC32.1
AC37.1 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC42.2 AC45.1
AC490 AC54.1
AC540 AC581
AC81.1 AC98.2
...
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
|
