|
|
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
AC15.1 AC160 AC20.1 AC20.2 AC20.3 AC20.4
AC22.1 AC30.2 AC30.3 AC32.1 AC40.1 AC41.1
AC42.1 AC45.1 AC54.1 AC540 AC70.3 ACAC.1
ACVW.1 AM115 AM15.1 AM15.2 AM15.3 AM15.4
AM20.1 AM20.3 AM500 AM97.1 AP00.3 AP10.1
AP10.2 AP10.5 AP10.6 AP110 AP125 AP126
AP150 AP151 AP170 AP180 AP181 AP190
AP191 AP193 AP20.1 AP20.2 AP20.5 AP20.6
AP20.7 AP20.8 AP210 AP225 AP226 AP23.1
AP25.1 AP25.2 AP26.1 AP30.2 AP30.3 AP30.4
AP32.2 AP510 AP520 AP80.1 AR08.1 AR10.1
AR100 AR105 AR110 AR115 AR12.1 AR12.2
AR124 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 AR50.1 AR501 AR502
AR503 AR504 AR507 AR53.1 AR550 AR560
AR570 AR575 AR580 AR70.1 AR70.2 AR72.1
AR73.1 AR75.1 AR82.1 AR90.1 AR970 AR973
BL02.1 BL08.1 BL09.1 BL120 BL122 BL130
BL140 BL20.1 BL20.3 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 BL902 BL91.1
BL92.1 BL940 CB03.2 CB06.1 CB06.2 CB10.1
CB10.3 CB15.1 CB15.2 CB180 CB191 CB20.1
CB30.1 CB500 CB733 CB90.2 CX05.1 CX05.2
CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220
CX30.1 CX300 CX506 CX805 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.3 EE135 EE20.3 EE35.1 EE35.2
EE520 CA10.5 CA110 CA190 FB100 FB20.1
FB20.6 FB20.7 FB21.1 GL146 GL165 GL170
GL190 GL191 GL195 GL196 GL199 GL270
GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL40.9
GL44.1 GL45.1 GL65.1 GL70.1 GL70.2 GL70.3
GL70.6 GL70.7 GL75.1 RW100 DR100 IC02.1
IC10.1 IC10.2 IC11.1 IC12.1 IC130 IC140
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 IC50.2 IC500 IC522
IC523 IC524 IC525 IC526 IC811 IC812
IC83.1 PC120 PC20.1 PC540 CU202 CU210
GLCV.1 GLVW.1 IFCU.1 IFGT.1 IN20.1 MA08.1
MA140 MA208 MA40.1 MA40.2 MA41.1 MA41.2
MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3
MA43.4 MA52.1 MA520 MA530 MA540 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
OE112 OE113 OE114 OE129 OE14.1 OE14.2
OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5
OE15.7 OE283 OE291 OE30.1 OE30.2 OE30.3
OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE310
OE510 OE80.1 OE80.2 OE80.3 OE80.4 OE80.5
OE810 OE830 OE90.2 OE920 OE950 PBIP.1
PO100 PO120 PO121 PO122 PO123 PO130
PO132 PO135 PO150 PO180 PO20.1 PO21.1
PO21.2 PO21.3 PO21.5 PO21.6 PO216 PO22.1
PO22.2 PO22.3 PO220 PO225 PO227 PO25.1
PO25.2 PO25.3 PO25.4 PO25.7 PO26.1 PO274
PO28.3 PO28.6 PO28.8 PO30.1 PO31.1 PO32.1
PO33.1 PO34.1 PO35.1 PO530 PO820 PO821
PO990 PR150 PR195 PR199 PR82.1 PR85.1
RQ10.1 RQ10.2 RQ10.3 RQ11.1 RQ12.1 RQ13.1
RQ20.1 RQ20.2 RQ20.3 RQ20.4 RQ35.1 RQ500
RQ990 SEA3.1 SA100 SL40.1 TE01.3 TX04.1
TX804 TX904 WH130 WH132 WH190 WH20.2
WH20.7 WH222 WH30.1 WH30.2 WH30.3 WH31.1
WH31.2 WH31.3 WH32.1 WH32.2 WH32.3 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
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 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). AC15.1 AC160
SYSTEM AC20.1 AC20.2
EFFECT-DATE* AC20.3 AC20.4
AC22.1 AC30.2
AC30.3 AC32.1
AC40.1 AC41.1
AC42.1 AC45.1
AC54.1 AC540
AC70.3 ACAC.1
ACVW.1 AM115
AM15.1 AM15.2
AM15.3 AM15.4
AM20.1 AM20.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
|