CUCONV

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
AC581 AM125 AM135 AM30.1 AM502 AM92.1
AM98.1 AP151 AP175 AP191 AP80.1 AR12.1
AR12.2 GL146 GL165 GL167 GL170 GL190
GL197 GL40.1 GL40.2 GL40.3 GL40.6 GL40.7
GL40.8 GL44.1 GL45.1 GL65.1 GL75.1 IC20.1
IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC23.1
IC23.2 IC233 IC234 IC24.1 IC24.2 IC247
IC25.1 IC500 CU01.1 CU01.2 GL00.1 GL00.2
GL00.3 GL00.6 GL00.7 GL00.8 GL00.9 GL02.1
GL02.2 GL02.3 GL02.6 GL03.2 GL03.4 GL10.1
GL20.1 GL20.2 GL20.4 IFGT.1 LP198 ML146
ML165 ML40.1 ML40.2 ML40.3 ML40.6 ML40.7
ML40.8 ML44.1 ML45.1 ML65.1 PD21.1 PD22.1
PO53.4 PR195 PR197 PR582 PR82.1 PR85.1
AC127 AC27.1 AC47.2 AC81.1 ACVW.1 ATVW.1
BN190 BR570 BR65.1 BR65.2 CBOP.1 CA190
FB100 FB195 FB20.1 FB20.6 FB20.7 FB21.1
GL191 GL195 GL270 CU202 CU210 GLAV.1
GLCV.1 GLVW.1 ML167 ML170 ML190 ML191
ML195 ML196 ML270 ML70.1 ML70.2 ML70.3
ML70.5 ML70.6 ML75.1 MLIT.1 SL40.1 SLVW.1
TE01.3 IN20.1


UPDATED BY
AC121 AC123 AC130 AC160 AC190 AC197
AC198 AC20.1 AC20.2 AC20.3 AC20.4 AC20.5
AC247 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 AC98.2 ACAC.1
AM115 AM117 AM15.1 AM15.2 AM15.3 AM15.4
AM180 AM19.1 AM19.2 AM20.1 AM20.3 AM21.1
AM21.3 AM22.1 AM500 AM51.1 AM551 AM97.1
AP00.3 AP00.4 AP03.3 AP10.1 AP10.2 AP10.5
AP10.6 AP110 AP115 AP125 AP126 AP131
AP150 AP170 AP180 AP181 AP190 AP193
AP20.1 AP20.2 AP20.3 AP20.4 AP20.5 AP20.6
AP20.7 AP21.1 AP210 AP220 AP23.1 AP25.1
AP25.2 AP255 AP26.1 AP265 AP27.1 AP271
AP30.2 AP30.4 AP300 AP305 AP510 AP520
AP81.1 AP90.1 AP90.5 AP91.1 AP95.1 API1.1
API2.1 API3.1 API4.1 API5.1 AR08.1 AR09.1
AR10.1 AR15.4 AR301 AR501 AR550 ARLL.1
BR00.1 BR00.2 BR02.3 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 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 BR70.1 BR70.2 BRIP.1 CB03.2 CB06.2
CB10.1 CB10.3 CB10.5 CB145 CB15.1 CB15.2
CB150 CB180 CB185 CB186 CB187 CB190
CB191 CB20.1 CB20.6 CB25.1 CB30.1 CB43.1
CB44.1 CB45.1 CB46.1 CB50.1 CB500 CB54.1
CB543 CB544 CB55.1 CB554 CB80.1 CB82.1
CB90.2 CX05.1 CX05.2 CX100 CX20.1 CX20.2
CX20.4 CX20.5 CX220 CX30.1 CX300 CX506
CX805 CXCP.1 EE05.1 EE11.1 EE135 EE20.3
EE35.1 EE35.2 EE520 CA10.5 CA110 GL196
GL70.2 RW100 DR100 IC02.1 IC10.1 IC10.2
IC11.1 IC12.1 IC130 IC140 IC141 IC142
IC330 IC64.1 IC64.2 IC64.3 IC64.4 IC64.5
IC64.6 IC64.7 IC64.8 IC64.9 IC66.1 IC802
IC81.1 IC811 IC812 IC83.1 IC840 CU02.1
CU02.2 CU03.1 CU10.1 CU10.2 CU160 CU300
EX175 EX542 IFCU.1 MX123 MX500 MA08.1
MA180 MA208 MA26.1 MA279 MA310 MA41.1
MA41.2 MA41.4 MA41.7 MA42.1 MA42.2 MA43.1
MA43.2 MA43.3 MA43.4 MA43.6 MA43.7 MA44.1
MA44.2 MA530 MA531 MA540 MA60.2 MA60.3
MA60.5 MA61.1 MA63.1 MA64.9 MA65.1 MA66.2
MA66.3 MA67.2 MA67.3 MA68.2 MA68.3 MA68.5
MA69.1 MA70.1 MA75.1 MA80.1 MAED.1 MAI1.1
PD10.1 PD10.2 PD130 PD20.1 PD20.2 PD20.3
PD235 PO10.1 PO100 PO101 PO120 PO122
PO130 PO131 PO132 PO135 PO136 PO150
PO190 PO20.1 PO20.6 PO20.9 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO22.2 PO22.3
PO22.4 PO22.5 PO220 PO223 PO229 PO23.1
PO233 PO24.1 PO25.1 PO25.5 PO25.6 PO25.7
PO253 PO254 PO26.1 PO26.2 PO26.3 PO26.4
PO26.5 PO26.6 PO26.7 PO26.9 PO27.2 PO278
PO28.2 PO29.1 PO295 PO30.1 PO30.2 PO30.3
PO30.4 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 PO536 PO54.1 PO54.2 PO54.3 PO54.4
PO54.5 POCP.1 POED.1 POI3.1 POI7.1 POID.1
POIF.1 POIG.1 POII.1 POIJ.1 POIM.1 POIT.1
PR05.1 PR05.3 PR198 PR226 PR247 PR26.1
PR47.1 PR514 UK47.1 MM280 MM80.1 MM80.2
RQ01.1 RQ10.1 RQ10.2 RQ10.3 RQ10.4 RQ11.1
RQ12.1 RQ13.1 RQ13.2 RQ260 RQ35.1 RQ500
RQIB.1 RQIC.1 RQID.1 RQIF.1 RQIG.1 RQIJ.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 WH32.5 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 ZW130

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CCN-CURRENCY-TABLE
Element: Currency Table		Alpha 12
This is the currency table, a table of currency relationships, currency exchange rates, and translation rates for one or more companies.
CU10.1 CU10.2
CU160
CCN-FR-CURR-CODE
Element: From Currency Code		Alpha 5
This is the name of the currency code you are converting from. It must be defined in the Currency Codes file.
CU10.1 CU10.2
CU160
CCN-TO-CURR-CODE
Element: To Currency Code		Alpha 5
The name of the currency code you are converting to. It must be defined in the Currency Codes file.
CU10.1 CU10.2
CU160
CCN-SYSTEM
Element: System		Alpha 2
The system code is a two-character code representing an application used within the Lawson system. (For example, GL = General Ledger, AP = Accounts Payable, etc.)
CU10.1 CU10.2
CU160
CCN-EFFECT-DATE
Element: Effective Date		Numeric 8 (yyyymmdd)
The effective date is the date the exchange rate is effective. This date is used until a new exchange rate is defined with a later date.
CU10.1 CU10.2
CU160
CCN-SELL-RATE
Element: Selling Rate		Signed 14.7
This field contains the rate the From currency amount to the To currency amount is converted at.
CU10.1 CU10.2
CU160


CUCONV FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CCNSET1 CURRENCY-TABLE
FR-CURR-CODE
TO-CURR-CODE
SYSTEM
EFFECT-DATE
CU01.1 CU01.2
CU02.1 CU02.2
CU03.1 CU10.1
CU10.2 CU160
GL00.1 GL00.2
GL00.3 GL00.6
GL00.7 GL00.8
GL00.9 GL02.1
GL02.2 GL02.3
GL02.6 GL03.2
GL03.4 GL10.1
GL20.1 GL20.2
GL20.4
CCNSET2 CURRENCY-TABLE*
FR-CURR-CODE
TO-CURR-CODE
SYSTEM
EFFECT-DATE*
...
AC121 AC123
AC127 AC130
AC160 AC190
AC197 AC198
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.6
AC20.7 AC247
AC27.1 AC298
AC32.1 AC37.1
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC42.2
AC45.1 AC47.2
AC490 AC54.1
CCNSET3 CURRENCY-TABLE
EFFECT-DATE*
FR-CURR-CODE
TO-CURR-CODE
SYSTEM
CU10.2 CU300


CUCONV FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Glsystem GLSYSTEM
CCN-CURRENCY-TABLE->GLS-CURRENCY-TABLE
  GLS-COMPANY

File created: Thu Jun 09 11:18:26 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.