CUCONV – Currency Exhange Rate

System
General Ledger Setup (IF)
Prefix
CCN
Primary key
CURRENCY-TABLE, FR-CURR-CODE, TO-CURR-CODE, SYSTEM, EFFECT-DATE
Fields
6
Updated by
4 programs
Referenced by
679 programs

CUCONV is the Currency Exhange Rate table in Lawson General Ledger Setup (prefix CCN). It is indexed by CURRENCY-TABLE, FR-CURR-CODE, TO-CURR-CODE, SYSTEM, EFFECT-DATE (CCNSET1); alternate indexes: CCNSET2 and CCNSET3. It is related 1:1 to CUCONVBOD, CURELAT and CUCODES and 1:M to GLSYSTEM. It is updated by CU10.1, CU10.2, CU160 and CU300 and referenced by AC121, AC123, AC127, AC130, AC160, AC190, AC191, AC197 and 671 more. The table has 6 fields, 3 indexes and 5 documented relations.

About CUCONV

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.

Fields (6)

Column = COBOL field name without the CCN- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
CCN-CURRENCY-TABLE PK
CURRENCY_TABLE		Alpha 12This 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 PK
FR_CURR_CODE		Alpha 5This 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 PK
TO_CURR_CODE		Alpha 5The 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 PK
SYSTEM		Alpha 2The 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 PK
EFFECT_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
SELL_RATE		Signed 14.7This field contains the rate the From currency amount to the To currency amount is converted at.CU10.1, CU10.2, CU160

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CCNSET1CURRENCY-TABLE, FR-CURR-CODE, TO-CURR-CODE, SYSTEM, EFFECT-DATEPrimaryAC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
CCNSET2CURRENCY-TABLE*, FR-CURR-CODE, TO-CURR-CODE, SYSTEM, EFFECT-DATE*AC121, AC123, AC127, AC130, AC160, AC190, AC197, AC198 +22 more (list truncated in source)
CCNSET3CURRENCY-TABLE, EFFECT-DATE*, FR-CURR-CODE, TO-CURR-CODE, SYSTEMCU10.2, CU300

Relations

One to one (4) — lookups and parents

RelationTableRulesConditionField map
CuconvbodCUCONVBODNot Required, Delete CascadesCCN-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
CurelatCURELATRequiredCCN-CURRENCY-TABLE → CRL-CURRENCY-TABLE, CCN-FR-CURR-CODE → CRL-FR-CURR-CODE, CCN-TO-CURR-CODE → CRL-TO-CURR-CODE
Fr CucodesCUCODESRequiredCCN-FR-CURR-CODE → CUC-CURRENCY-CODE
To CucodesCUCODESRequiredCCN-TO-CURR-CODE → CUC-CURRENCY-CODE

One to many (1) — child tables

RelationTableRulesConditionField map
GlsystemGLSYSTEMCCN-CURRENCY-TABLE → GLS-CURRENCY-TABLE, → GLS-COMPANY

Programs

Updated by (4)

Referenced by (679)