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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CCNSET1
  1. CURRENCY-TABLE
  2. FR-CURR-CODE
  3. TO-CURR-CODE
  4. SYSTEM
  5. EFFECT-DATE
PrimaryAC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
CCNSET2
  1. CURRENCY-TABLE ↓
  2. FR-CURR-CODE
  3. TO-CURR-CODE
  4. SYSTEM
  5. EFFECT-DATE ↓
AC121, AC123, AC127, AC130, AC160, AC190, AC197, AC198 +22 more (list truncated in source)
CCNSET3
  1. CURRENCY-TABLE
  2. EFFECT-DATE ↓
  3. FR-CURR-CODE
  4. TO-CURR-CODE
  5. SYSTEM
CU10.2, CU300

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
CUCONVBODCURELATCUCODESGLSYSTEMCUCONV

One to one (4) — lookups and parents

RelationTableRulesConditionField map
CuconvbodCUCONVBODNot 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
CurelatCURELATRequired
CCN-CURRENCY-TABLE→CRL-CURRENCY-TABLE
CCN-FR-CURR-CODE→CRL-FR-CURR-CODE
CCN-TO-CURR-CODE→CRL-TO-CURR-CODE
Fr CucodesCUCODESRequired
CCN-FR-CURR-CODE→CUC-CURRENCY-CODE
To CucodesCUCODESRequired
CCN-TO-CURR-CODE→CUC-CURRENCY-CODE

One to many (1) — child tables

RelationTableRulesConditionField map
GlsystemGLSYSTEM
CCN-CURRENCY-TABLE→GLS-CURRENCY-TABLE
—→GLS-COMPANY

Programs

Updated by (4)

Referenced by (679)