CUCONVREL – Curr Exchange Rate Interface

System
General Ledger Setup (IF)
Prefix
CUR
Primary key
CURRENCY-TABLE, SEQ-NUMBER
Fields
7
Updated by
2 programs
Referenced by
1 program

CUCONVREL is the Curr Exchange Rate Interface table in Lawson General Ledger Setup (prefix CUR). It is indexed by CURRENCY-TABLE, SEQ-NUMBER (CURSET1); alternate indexes: CURSET2. It is updated by CU160 and CU60.1 and referenced by CU260. The table has 7 fields, 2 indexes and 0 documented relations.

About CUCONVREL

The Currency Rate Conversion (CUCONVREL) file stores currency exchange rate information you are converting from a non-Lawson system to the Lawson Currency system using CU60, CU160, and CU260.

Fields (7)

Column = COBOL field name without the CUR- 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
#CUR-CURRENCY-TABLE PK
CURRENCY_TABLE		Alpha 12The currency table stores interface information. It is similar to a run group.CU60.1
#CUR-SEQ-NUMBER PK
SEQ_NUMBER		Numeric 6A unique number assigned to each transaction to be interfaced into the Lawson system.CU60.1
#CUR-FR-CURR-CODE SET2
FR_CURR_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).CU60.1
#CUR-TO-CURR-CODE SET2
TO_CURR_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).CU60.1
#CUR-SYSTEM SET2
SYSTEM		Alpha 2A two-character code representing an application used within the Lawson system. (i.e.: GL = General Ledger, AP = Accounts Payable, etc.)CU60.1
#CUR-EFFECT-DATE SET2
EFFECT_DATE		Numeric 8 (yyyymmdd)The effective date identifies when the exchange rate can be used.CU60.1
#CUR-SELL-RATE
SELL_RATE		Signed 14.7This is the exchange rate you converted to the Lawson system from your non-Lawson system.CU60.1

Indexes (2)

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
CURSET1
  1. CURRENCY-TABLE
  2. SEQ-NUMBER
PrimaryCU160, CU60.1
CURSET2
  1. CURRENCY-TABLE
  2. FR-CURR-CODE
  3. TO-CURR-CODE
  4. SYSTEM
  5. EFFECT-DATE
  6. SEQ-NUMBER
KeyChangeCU260, CU60.1

Programs

Updated by (2)

Referenced by (1)