CUTRATEREL – Currency Rate Interface

System
General Ledger Setup (IF)
Prefix
CUL
Primary key
CURRENCY-TABLE, SEQ-NUMBER, COMPANY
Fields
10
Updated by
3 programs
Referenced by
1 program

CUTRATEREL is the Currency Rate Interface table in Lawson General Ledger Setup (prefix CUL). It is indexed by CURRENCY-TABLE, SEQ-NUMBER, COMPANY (CULSET1); alternate indexes: CULSET2, CULSET3 and CULSET4. It is related 1:1 to CURELAT and CUCODES. It is updated by CU161, CU61.1 and CU61.2 and referenced by CU261. The table has 10 fields, 4 indexes and 3 documented relations.

About CUTRATEREL

The Currency Translation Interface file contains translation rates for a currency table or company. The records are imported from a non-Lawson file into this file to be interfaced to the Lawson Currency system, using CU61 and CU161. Once records in this file are interfaced to the Currency system, they are deleted from this file.

Fields (10)

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

Field / columnTypeDescription & valuesUpdated by
CUL-CURRENCY-TABLE PK
CURRENCY_TABLE		Alpha 12This field contains the name of the currency table for which the rates are interfaced.CU161, CU61.1, CU61.2
CUL-SEQ-NUMBER PK
SEQ_NUMBER		Numeric 6This unique number is assigned by the system to keep the records unique.CU161, CU61.1, CU61.2
CUL-FR-CURR-CODE
FR_CURR_CODE		Alpha 5This is the currency code from which the company balances are translated..CU161, CU261, CU61.1, CU61.2
CUL-TO-CURR-CODE
TO_CURR_CODE		Alpha 5This is the currency code to which the company balances are translated.CU161, CU61.1, CU61.2
CUL-FISCAL-YEAR
FISCAL_YEAR		Numeric 4This is the fiscal year for which the rates are valid.CU61.1, CU61.2
CUL-BUDGET-NBR
BUDGET_NBR		Numeric 3This is the budget to which the rates apply.CU161, CU61.1, CU61.2
CUL-COMPANY PK
COMPANY		Numeric 4This is the company to which the rates apply. Where applicable, company rates override currency table rates.CU161, CU61.2
CUL-TRANS-CODE
TRANS_CODE		Alpha 2This is the translation code for the currency translation.CU161, CU61.1, CU61.2
CUL-RATE-VALUE
RATE_VALUE		Signed 14.7 Occurs 13 Times ×13This is the translation rate used - one for each period in the fiscal year.CU61.1, CU61.2
CUL-RATE-BEG-BAL
RATE_BEG_BAL		Signed 14.7This is the beginning translation rate used for the fiscal year.CU61.1, CU61.2

Indexes (4)

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

IndexKeysFlagsConditionUsed in
CULSET1CURRENCY-TABLE, SEQ-NUMBER, COMPANYPrimaryCU161, CU61.1
CULSET2COMPANY, SEQ-NUMBER, CURRENCY-TABLECU161, CU61.2
CULSET3CURRENCY-TABLE, FR-CURR-CODE, TO-CURR-CODE, FISCAL-YEAR, BUDGET-NBR, TRANS-CODE, SEQ-NUMBER, COMPANYKeyChangeCU161, CU261, CU61.1
CULSET4COMPANY, FR-CURR-CODE, TO-CURR-CODE, FISCAL-YEAR, BUDGET-NBR, TRANS-CODE, SEQ-NUMBER, CURRENCY-TABLEKeyChangeCU161, CU261, CU61.2

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
CurrentCURELATRequiredCUL-CURRENCY-TABLE → CRL-CURRENCY-TABLE, CUL-FR-CURR-CODE → CRL-FR-CURR-CODE, CUL-TO-CURR-CODE → CRL-TO-CURR-CODE
Fr CucodesCUCODESRequiredCUL-FR-CURR-CODE → CUC-CURRENCY-CODE
To CucodesCUCODESRequiredCUL-TO-CURR-CODE → CUC-CURRENCY-CODE

Programs

Updated by (3)

Referenced by (1)