CURELATREL – Currency Relation Interface

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

CURELATREL is the Currency Relation Interface table in Lawson General Ledger Setup (prefix CRI). It is indexed by CURRENCY-TABLE, SEQ-NUMBER (CRISET1); alternate indexes: CRISET2. It is updated by CU162 and CU62.1 and referenced by CU262. The table has 9 fields, 2 indexes and 0 documented relations.

About CURELATREL

No description in the Lawson data dictionary.

Fields (9)

Column = COBOL field name without the CRI- 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
#CRI-CURRENCY-TABLE PK
CURRENCY_TABLE		Alpha 12This field contains the name of the currency table for which the relations are interfaced.CU62.1
#CRI-SEQ-NUMBER PK
SEQ_NUMBER		Numeric 6A unique number assigned to each transaction to be interfaced into the Lawson system.CU62.1
#CRI-FR-CURR-CODE SET2
FR_CURR_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).CU62.1
#CRI-TO-CURR-CODE SET2
TO_CURR_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).CU62.1
#CRI-MULT-DIV
MULT_DIV		Alpha 1This indicates whether the rate will be multiplied or divided.CU162, CU62.1
#CRI-OVD-TOLERANCE
OVD_TOLERANCE		Numeric 3This field indicates by what percentage you can override the exchange rate. The default is blank which indicates that no tolerance editing takes place. This field is ignored if Overrride Protection is set to Yes.CU62.1
#CRI-TRNGLT-IND
TRNGLT_IND		Alpha 1This field indicates whether the currency relationship is triangulated, that is whether the currencies in the relationship must use a third currency to convert.
  • Y Yes
  • N No
CU62.1
#CRI-TRNGLT-CURR-CD
TRNGLT_CURR_CD		Alpha 5If you selected Y (Yes) in the Triangulate field, select the currency used to triangulate the conversion. For members of the European Union, this should be the Euro.CU62.1
#CRI-OVD-PROT-IND
OVD_PROT_IND		Alpha 1This field determines if the translation rate should be protected from being overridden in a journal entry. The default is N (No).CU62.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
CRISET1
  1. CURRENCY-TABLE
  2. SEQ-NUMBER
PrimaryCU162, CU262, CU62.1
CRISET2
  1. CURRENCY-TABLE
  2. FR-CURR-CODE
  3. TO-CURR-CODE
  4. SEQ-NUMBER
CU162, CU62.1

Programs

Updated by (2)

Referenced by (1)