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

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 SET3 SET4
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 SET3 SET4
TO_CURR_CODE		Alpha 5This is the currency code to which the company balances are translated.CU161, CU61.1, CU61.2
#CUL-FISCAL-YEAR SET3 SET4
FISCAL_YEAR		Numeric 4This is the fiscal year for which the rates are valid.CU61.1, CU61.2
#CUL-BUDGET-NBR SET3 SET4
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 SET3 SET4
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 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
CULSET1
  1. CURRENCY-TABLE
  2. SEQ-NUMBER
  3. COMPANY
PrimaryCU161, CU61.1
CULSET2
  1. COMPANY
  2. SEQ-NUMBER
  3. CURRENCY-TABLE
CU161, CU61.2
CULSET3
  1. CURRENCY-TABLE
  2. FR-CURR-CODE
  3. TO-CURR-CODE
  4. FISCAL-YEAR
  5. BUDGET-NBR
  6. TRANS-CODE
  7. SEQ-NUMBER
  8. COMPANY
KeyChangeCU161, CU261, CU61.1
CULSET4
  1. COMPANY
  2. FR-CURR-CODE
  3. TO-CURR-CODE
  4. FISCAL-YEAR
  5. BUDGET-NBR
  6. TRANS-CODE
  7. SEQ-NUMBER
  8. CURRENCY-TABLE
KeyChangeCU161, CU261, CU61.2

Relations

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

One to one (3) — lookups and parents

RelationTableRulesConditionField map
CurrentCURELATRequired
CUL-CURRENCY-TABLE→CRL-CURRENCY-TABLE
CUL-FR-CURR-CODE→CRL-FR-CURR-CODE
CUL-TO-CURR-CODE→CRL-TO-CURR-CODE
Fr CucodesCUCODESRequired
CUL-FR-CURR-CODE→CUC-CURRENCY-CODE
To CucodesCUCODESRequired
CUL-TO-CURR-CODE→CUC-CURRENCY-CODE

Programs

Updated by (3)

Referenced by (1)