|
|
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 AC190 AC192 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 AC54.2 AC54.3 AC540 AC541 AC542
AC581 AC81.1 AC98.2 ACAC.1 ACVW.1 AM115
AM125 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 AM500 AM51.1 AM551 AM97.1
AM98.1 AP00.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 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 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
BN190 BR00.2 BR10.1 BR10.2 BR11.1 BR120
BR121 BR122 BR123 BR124 BR130 BR15.2
BR151 BR152 BR153 BR154 BR156 BR16.1
BR40.3 BR400 BR41.1 BR41.4 BR420 BR43.1
BR51.1 BR51.2 BR52.1 BR52.5 BR521 BR530
BR65.1 BR65.2 BRCC.1 BRIP.1 BRPI.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 MA41.7 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 MA75.1 MA80.1 MAI1.1
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 PO229
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 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 RQ10.1 RQ10.2
RQ10.3 RQ11.1 RQ12.1 RQ13.1 RQ35.1 RQ500
RQIB.1 RQIC.1 RQID.1 RQIE.1 RQIF.1 RQIG.1
RQIJ.1 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.)
The exchange rate will be valid for the
specific system code you define.
If this field is blank, the rate is
valid for all system codes.
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 12.6 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 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 AC190
SYSTEM AC192 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
AC54.2 AC54.3
...
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
|
