Lawson - Lawson Software Technical Library

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

AM125 AM135 AM30.1 AM502 AM92.1 AM98.1

AP151 AP175 AP191 AP80.1 AR12.1 AR12.2

BN190 CBOP.1 CA190 GL146 GL165 GL167

GL170 GL190 GL197 GL270 GL40.1 GL40.2

GL40.3 GL40.6 GL40.7 GL40.8 GL44.1 GL45.1

GL65.1 GL75.1 IFGT.1 LP198 PO53.4 PR195

PR197 PR582 PR82.1 PR85.1 SL40.1 IN20.1

UPDATED BY

CU10.1 CU10.2 CU160 CU300 CU02.1 CU02.2

ACAC.1 ACVW.1 AM115 AM117 AM15.1 AM15.2

AM15.3 AM15.4 AM180 AM19.1 AM19.2 AM20.1

AM20.3 AM21.1 AM21.3 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

AP30.2 AP30.4 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 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 EE05.1 EE11.1 EE135 EE20.3 EE35.1

EE35.2 EE520 CA10.5 CA110 FB100 FB195

FB20.1 FB20.6 FB20.7 FB21.1 GL191 GL195

GL196 GL70.2 RW100 CU202 CU210 EX175

EX542 GLAV.1 GLCV.1 GLVW.1 IFCU.1 MX123

MX500 MA08.1 MA208 MA41.1 MA41.2 MA41.4

MA41.7 MA43.1 MA43.2 MA43.3 MA43.4 MA43.6

MA43.7 MA540 MAED.1 MAI1.1 PO10.1 PO136

PO190 PO300 PO520 POCP.1 POED.1 POI3.1

POI7.1 POIF.1 POIG.1 POII.1 POIJ.1 POIM.1

PR05.1 PR05.3 PR198 PR226 PR247 PR26.1

PR47.1 PR514 UK47.1 MM280 RQ01.1 SLVW.1

TE01.3 TX04.1 TX140 TX804

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

CU02.1	CU02.2
CU10.1	CU10.2
CU160

CCNSET2

CURRENCY-TABLE*
FR-CURR-CODE
TO-CURR-CODE
SYSTEM
EFFECT-DATE*

...

ACAC.1	ACVW.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