|
|
CUCONV FILE
Currency Exhange Rate
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
ET700 CU02.1 CU02.2 AC121 AC123 AC127
AC130 AC160 AC190 AC197 AC198 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 AC56.1 AC560 AC581 AC81.1
AC98.2 ACAC.1 ACVW.1 ATVW.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
AP26.1 AP27.1 AP30.2 AP30.3 AP30.4 AP305
AP510 AP520 AP80.1 AP90.1 AP91.1 AP95.1
API1.1 API2.1 API3.1 API4.1 API5.1 AR08.1
AR09.1 AR10.1 AR100 AR115 AR12.1 AR12.2
AR120 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 AR237 AR239
AR24.1 AR250 AR251 AR255 AR258 AR271
AR275 AR29.2 AR296 AR30.1 AR30.2 AR30.3
AR30.6 AR30.7 AR30.8 AR301 AR32.1 AR32.3
AR33.1 AR33.3 AR33.5 AR33.6 AR34.1 AR34.2
AR34.3 AR34.4 AR35.1 AR35.2 AR36.1 AR38.1
AR39.1 AR39.2 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 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 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 BR570 BR65.1 BR65.2 BR70.1
BR70.2 BRIP.1 CB03.2 CB06.1 CB06.2 CB10.1
CB10.3 CB145 CB15.1 CB15.2 CB150 CB180
CB185 CB191 CB20.1 CB30.1 CB43.1 CB44.1
CB45.1 CB46.1 CB50.1 CB500 CB54.1 CB543
CB544 CB55.1 CB554 CB90.2 CBOP.1 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 ET175 ET530 ET540 ET542
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 IC02.1
IC11.1 IC12.1 IC130 IC330 IC811 IC812
CU202 CU210 GLAV.1 GLCV.1 GLVW.1 IFCU.1
IFGT.1 MX123 MX500 LP198 MA08.1 MA180
MA208 MA279 MA310 MA41.1 MA41.2 MA41.4
MA41.7 MA43.1 MA43.2 MA43.3 MA43.4 MA43.6
MA43.7 MA530 MA531 MA540 MA60.2 MA60.3
MA60.5 MA61.1 MA63.1 MA65.1 MA66.2 MA66.3
MA67.2 MA67.3 MA68.2 MA68.3 MA68.5 MA70.1
MA75.1 MA80.1 MAI1.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 PO190 PO20.1
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO220 PO223 PO229 PO23.1 PO233 PO24.1
PO25.1 PO25.5 PO25.6 PO25.7 PO253 PO254
PO26.1 PO27.2 PO278 PO29.1 PO295 PO30.1
PO30.2 PO30.3 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 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 PR82.1 PR85.1
UK47.1 PW110 PW550 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
SB15.1 SB515 SL40.1 SLVW.1 TE01.3 IN20.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 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
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-TABLE ET700 CU02.1
FR-CURR-CODE CU02.2 CU10.1
TO-CURR-CODE CU10.2 CU160
SYSTEM
EFFECT-DATE
CCNSET2 CURRENCY-TABLE* AC121 AC123
FR-CURR-CODE AC127 AC130
TO-CURR-CODE AC160 AC190
SYSTEM AC197 AC198
EFFECT-DATE* 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 AC56.1
...
CCNSET3 CURRENCY-TABLE CU10.2 CU300
EFFECT-DATE*
FR-CURR-CODE
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
|
