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
AC191 AP125 AP126 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP20.6 AP20.8 AP21.1
AP23.1 AP25.1 AP25.2 AP26.1 AP27.1 API1.1
API2.1 BR44.1 CB222 FB45.1 GL100 GL110
GL111 GL120 GL122 GL135 GL146 GL148
GL167 GL190 GL195 GL196 GL197 GL199
GL330 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8
GL40.6 GL44.1 GL45.1 GL500 DR100 IC02.1
IC10.2 IC10.1 IC11.1 IC12.1 IC141 IC142
IC15.2 IC175 IC183 IC20.1 IC20.2 IC21.1
IC21.2 IC22.1 IC22.2 IC222 IC223 IC23.1
IC23.2 IC24.1 IC24.2 IC25.1 IC320 IC330
IC331 IC500 IC503 IC524 IC58.1 IC62.1
IC64.2 IC64.1 IC64.3 IC64.4 IC64.5 IC64.6
IC64.7 IC64.8 IC64.9 IC81.1 IC811 IC812
IC82.1 IC83.1 IC840 CU00.1 CU01.1 CU01.2
CU02.1 CU02.2 CU03.1 CU20.1 CU20.2 CU20.3
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 GL03.6 GL10.1 GL10.2 GL121 GL124
GL125 GL160 GL161 GL20.1 GL20.2 GL20.4
IFAC.1 IFBD.2 MA41.1 MA41.2 MA41.4 MA41.7
MA42.2 MA42.1 MA43.2 MA43.1 MA43.3 MA43.4
MA43.6 MA43.7 MA44.1 MA44.2 MA61.1 MAI1.1
ML146 ML167 ML190 ML195 ML196 ML199
ML330 ML40.1 ML40.2 ML40.3 ML40.7 ML40.8
ML40.6 ML44.1 ML45.1 PO150 PO25.6 PO25.7
PO25.1 PO25.5 PO26.4 PO26.5 PO26.1 PO26.2
PO26.3 PO26.6 PO26.7 PO26.9 PO28.2 PO36.2
PO36.1 PO536 RQ10.1 RQ10.3 RQ10.2 RQ10.4
RQ10.5 RQ11.1 RQ11.3 RQ11.4 RQ11.5 RQ13.2
RQ13.1 RQ35.1 RQ500 RQIB.1 RQIF.1 RQIJ.1
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
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 AM22.1 AM22.2
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 AP131
AP150 AP151 AP170 AP175 AP180 AP181
AP190 AP191 AP193 AP210 AP220 AP255
AP265 AP271 AP30.2 AP30.3 AP30.4 AP300
AP305 AP510 AP520 AP80.1 AP81.1 AP90.1
AP90.5 AP91.1 AP95.1 API3.1 API4.1 API5.1
API6.2 AR08.1 AR09.1 AR10.1 AR12.1 AR12.2
AR15.4 AR301 AR501 AR550 ARLL.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 BR40.4 BR41.1
BR41.4 BR420 BR43.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 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 CBOP.1 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 EE52.2 EE520 CA10.5
CA110 CA190 FB100 FB195 FB20.1 FB20.6
FB20.7 FB21.1 GL165 GL170 GL191 GL270
GL65.1 GL70.1 GL70.2 GL70.3 GL70.5 GL70.6
GL75.1 RW100 IC130 IC140 IC145 IC233
IC234 IC243 IC247 IC66.1 IC802 CU202
CU210 EX175 EX542 GLAV.1 GLCV.1 GLVW.1
IFCU.1 IFGT.1 MX123 MX500 LP198 MA08.1
MA126 MA180 MA208 MA26.1 MA278 MA279
MA53.1 MA530 MA531 MA540 MA60.2 MA60.3
MA60.5 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 ML165 ML170
ML191 ML270 ML65.1 ML70.1 ML70.2 ML70.3
ML70.5 ML70.6 ML75.1 MLIT.1 PD10.1 PD10.2
PD130 PD20.1 PD20.2 PD20.3 PD21.1 PD22.1
PD235 PD570 PO04.1 PO04.2 PO10.1 PO10.2
PO100 PO101 PO115 PO120 PO122 PO130
PO131 PO132 PO135 PO136 PO15.1 PO15.2
PO15.4 PO17.1 PO190 PO192 PO195 PO20.1
PO20.6 PO20.9 PO204 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO22.2 PO22.3 PO22.4
PO22.5 PO220 PO222 PO223 PO224 PO225
PO229 PO23.1 PO230 PO233 PO234 PO24.1
PO251 PO253 PO254 PO27.2 PO27.3 PO27.4
PO275 PO276 PO277 PO278 PO280 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 PO38.1 PO39.1 PO39.2 PO44.1
PO50.1 PO52.1 PO520 PO529 PO53.4 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 PR195
PR197 PR198 PR226 PR247 PR26.1 PR47.1
PR514 PR582 PR82.1 PR85.1 MM280 MM80.1
MM80.2 RQ01.1 RQ12.1 RQ260 RQ44.1 RQ810
RQIC.1 RQID.1 RQIG.1 RQII.1 SL40.1 SLVW.1
TE01.3 TEI1.1 IN20.1 TX04.1 TX100 TX140
TX804 TXI1.1 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


UPDATED BY
CU10.1 CU10.2 CU160 CU300

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
...
AC191 AP125
AP126 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
API2.1 BR44.1
CB222 FB45.1
GL100 GL110
GL111 GL120
GL122 GL135
GL146 GL148
GL167 GL190
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
Cuconvbod CUCONVBOD Not Required, Delete Cascades
CCN-CURRENCY-TABLE->YBO-CURRENCY-TABLE
CCN-FR-CURR-CODE->YBO-FR-CURR-CODE
CCN-TO-CURR-CODE->YBO-TO-CURR-CODE
CCN-SYSTEM->YBO-SYSTEM
CCN-EFFECT-DATE->YBO-EFFECT-DATE
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 02:20:25 2016

Home
Contact Us



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