CURELAT – Currency Relationships

System
General Ledger Setup (IF)
Prefix
CRL
Primary key
CURRENCY-TABLE, FR-CURR-CODE, TO-CURR-CODE
Fields
12
Updated by
4 programs
Referenced by
683 programs

CURELAT is the Currency Relationships table in Lawson General Ledger Setup (prefix CRL). It is indexed by CURRENCY-TABLE, FR-CURR-CODE, TO-CURR-CODE (CRLSET1). It is related 1:1 to CUCODES and 1:M to CUACCT, CUCONV, CURELATAU, CUTRANSL and GLSYSTEM. It is updated by CU02.1, CU02.2, CU03.1 and CU162 and referenced by AC121, AC123, AC127, AC130, AC160, AC190, AC191, AC197 and 675 more. The table has 12 fields, 1 index and 9 documented relations.

About CURELAT

This file contains the valid currency relationships used for a specific currency table. CU02.1 (Currency Relationship) is the primary program that updates this file.

Fields (12)

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

Field / columnTypeDescription & valuesUpdated by
CRL-CURRENCY-TABLE PK
CURRENCY_TABLE
Alpha 12This is a table of currency relationships, exchange rates, and translation rates used by one or more companies. If multiple companies share rates, each company can be linked to the same currency table, eliminating the need to set up rates for each company individually.CU02.1, CU02.2, CU162
CRL-FR-CURR-CODE PK
FR_CURR_CODE
Alpha 5This is the name of the currency code you are converting from. It must be a valid code in the Currency Codes file.CU02.1, CU02.2, CU162
CRL-TO-CURR-CODE PK
TO_CURR_CODE
Alpha 5This is the name of the currency code you are converting to. It must be a valid code in the Currency Codes file.CU02.1, CU02.2, CU162
CRL-MULT-DIV
MULT_DIV
Alpha 1The Multiply/Divide field determines how rates are applied during conversion and translation. Use Multiply, the default value, to multiply the From currency amount by the rate to calculate the To currency amount. Use Divide to divide the From currency amount by the rate to calculate the To currency amount.
  • M Multiply
  • D Divide
CU02.1, CU02.2, CU162
CRL-OVD-TOLERANCE
OVD_TOLERANCE
Numeric 3This field determines the override tolerance of an exchange rate. Values from 0 to 100 are acceptable. A value of 0 is the default and means any override rate is acceptable. Any other value indicates the percentage (tolerance) the override rate can be over the table rate. 000 100CU02.1, CU02.2, CU162
CRL-CONV-STATUS
CONV_STATUS
Alpha 1This field indicates currency exchange relationship status. Use Active, the default value, to let conversion activity take place for the relationship. Use Inactive to prevent conversion activity.
  • A Active
  • I Inactive
CU02.1, CU02.2, CU03.1, CU162
CRL-TRANSL-STATUS
TRANSL_STATUS
Alpha 1This field indicates currency translation status. Use Active, the default value, to let translation activity take place for the relationship. Use Inactive to prevent translation activity.
  • A Active
  • I Inactive
CU02.1, CU02.2, CU162
CRL-FR-CURR-ND
FR_CURR_ND
Numeric 1This is the currency number of decimal positions for the From currency.CU02.1, CU02.2, CU162
CRL-TO-CURR-ND
TO_CURR_ND
Numeric 1This is the currency number of decimal positions for the To currency.CU02.1, CU02.2, CU162
CRL-TRNGLT-IND
TRNGLT_IND
Alpha 1Indicates whether the currencies in a conversion need to be converted by way of a third currency. Required for member currencies of the European Union.CU02.1, CU02.2, CU162
CRL-TRNGLT-CURR-CD
TRNGLT_CURR_CD
Alpha 5The currency code of the language used to triangulate a conversion. For European Union (EU) currencies, the triangulation currency must be the Euro.CU02.1, CU02.2, CU162
CRL-OVD-PROT-IND
OVD_PROT_IND
Alpha 1Yes indicates that the conversion rates cannot be overridden. The default is No. Yes is required when the Triangulate indicator is set to Yes.CU02.1, CU02.2, CU162

Indexes (1)

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

IndexKeysFlagsConditionUsed in
CRLSET1CURRENCY-TABLE, FR-CURR-CODE, TO-CURR-CODEPrimaryAC121, AC123, AC127, AC130, AC160, AC190, AC191, AC197 +22 more (list truncated in source)

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
Fr CucodesCUCODESRequiredCRL-FR-CURR-CODECUC-CURRENCY-CODE
To CucodesCUCODESRequiredCRL-TO-CURR-CODECUC-CURRENCY-CODE
Via CucodesCUCODESNot RequiredCRL-TRNGLT-CURR-CDCUC-CURRENCY-CODE

One to many (6) — child tables

RelationTableRulesConditionField map
CuacctCUACCTCRL-CURRENCY-TABLECUA-CURRENCY-TABLE, CRL-FR-CURR-CODECUA-FR-CURR-CODE, CRL-TO-CURR-CODECUA-TO-CURR-CODE, CUA-COMPANY, CUA-SYSTEM
CuconvCUCONVDelete RestrictedCRL-CURRENCY-TABLECCN-CURRENCY-TABLE, CRL-FR-CURR-CODECCN-FR-CURR-CODE, CRL-TO-CURR-CODECCN-TO-CURR-CODE, CCN-SYSTEM, CCN-EFFECT-DATE
Cuconv DecCUCONVCRL-CURRENCY-TABLECCN-CURRENCY-TABLE, CRL-FR-CURR-CODECCN-FR-CURR-CODE, CRL-TO-CURR-CODECCN-TO-CURR-CODE, CCN-SYSTEM, CCN-EFFECT-DATE
CurelatauCURELATAUCRL-CURRENCY-TABLECRA-CURRENCY-TABLE, CRL-FR-CURR-CODECRA-FR-CURR-CODE, CRL-TO-CURR-CODECRA-TO-CURR-CODE, CRA-ACTION, CRA-DATE, CRA-TIME, CRA-UNIQUE-I-D
CutranslCUTRANSLCRL-CURRENCY-TABLECTR-CURRENCY-TABLE, CRL-FR-CURR-CODECTR-FR-CURR-CODE, CRL-TO-CURR-CODECTR-TO-CURR-CODE, CTR-FISCAL-YEAR, CTR-COMPANY, CTR-BUDGET-NBR, CTR-TRANSL-CODE
GlsystemGLSYSTEMCRL-CURRENCY-TABLEGLS-CURRENCY-TABLE, GLS-COMPANY

Programs

Updated by (4)

Referenced by (683)