CUTRANSL – Currency Translation

System
General Ledger Setup (IF)
Prefix
CTR
Primary key
CURRENCY-TABLE, FR-CURR-CODE, TO-CURR-CODE, FISCAL-YEAR, COMPANY, BUDGET-NBR, TRANSL-CODE
Fields
9
Updated by
8 programs
Referenced by
129 programs

CUTRANSL is the Currency Translation table in Lawson General Ledger Setup (prefix CTR). It is indexed by CURRENCY-TABLE, FR-CURR-CODE, TO-CURR-CODE, FISCAL-YEAR, COMPANY, BUDGET-NBR, TRANSL-CODE (CTRSET1); alternate indexes: CTRSET2, CTRSET3, CTRSET4 and CTRSET5. It is related 1:1 to CURELAT, CUCODES, GLSYSTEM and TRCODES and 1:M to CUTRANSBOD. It is updated by CU161, CU20.1, CU20.2, CU20.3, CU20.4, CU300, GL110 and GL500 and referenced by AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 121 more. The table has 9 fields, 5 indexes and 6 documented relations.

About CUTRANSL

This file maintains translation rates for each currency relationship by company or currency table. CU20.1 (Company Translation Rates) and CU20.3 (Currency Table Translation Rates) are the primary programs that update this file.

Fields (9)

Column = COBOL field name without the CTR- 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
#CTR-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.CU161, CU20.1, CU20.2, GL500
#CTR-FR-CURR-CODE PK
FR_CURR_CODE		Alpha 5Type or select the company base currency code you are translating balances from. A currency relationship must exist between the From and To Currency in CU02.1 (Currency Relationship).CU161, CU20.1, CU20.2, CU20.3, CU20.4, GL500
#CTR-TO-CURR-CODE PK
TO_CURR_CODE		Alpha 5Type or select the company base currency code you are translating balances from. A currency relationship must exist between the From and To Currency in CU02.1 (Currency Relationship).CU161, CU20.1, CU20.2, CU20.3, CU20.4, GL500
#CTR-FISCAL-YEAR PK
FISCAL_YEAR		Numeric 4Rates are entered in this year, the current fiscal year. The year must be greater than 1900. 1901 9999CU161, CU20.1, CU20.2, CU20.3, CU20.4, GL500
#CTR-COMPANY PK
COMPANY		Numeric 4This is the From company the translation rates apply to. If the record is for a currency table, this field is zero.CU161, CU20.1, CU20.3, CU20.4, GL110, GL500
#CTR-BUDGET-NBR PK
BUDGET_NBR		Numeric 3This is the budget number the currency rates apply to.CU161, CU20.1, CU20.2, CU20.3, CU20.4, GL500
#CTR-TRANSL-CODE PK
TRANSL_CODE		Alpha 2This field determines how the currency code is translated. This translation code must be a valid code in the Translation Codes file.CU161, CU20.1, CU20.2, CU20.3, CU20.4, GL500
#CTR-RATE-VALUE
RATE_VALUE		Signed 14.7 Occurs 13 Times ×13The rates in this field are applied to actual and budget amounts.CU161, CU20.1, CU20.2, CU20.3, CU20.4, FB195, GL195, GL500 +1 more
#CTR-RATE-BEG-BAL
RATE_BEG_BAL		Signed 14.7This is the beginning balance rate, which applies to the beginning balance of any budgets to be translated.CU161, CU20.1, CU20.3, FB195, GL500

Indexes (5)

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
CTRSET1
  1. CURRENCY-TABLE
  2. FR-CURR-CODE
  3. TO-CURR-CODE
  4. FISCAL-YEAR
  5. COMPANY
  6. BUDGET-NBR
  7. TRANSL-CODE
PrimaryAC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
CTRSET2
  1. CURRENCY-TABLE
  2. COMPANY
  3. FISCAL-YEAR
  4. BUDGET-NBR
  5. TRANSL-CODE
  6. FR-CURR-CODE
  7. TO-CURR-CODE
CU20.2, CU300
CTRSET3
  1. TRANSL-CODE
  2. CURRENCY-TABLE
  3. COMPANY
  4. FR-CURR-CODE
  5. TO-CURR-CODE
  6. FISCAL-YEAR
  7. BUDGET-NBR
CU05.1, CU05.2
CTRSET4
  1. COMPANY
  2. FR-CURR-CODE
  3. TO-CURR-CODE
  4. FISCAL-YEAR
  5. BUDGET-NBR
  6. TRANSL-CODE
SubsetWhere COMPANY != ZeroesFB145, FB190, FB195, FB40.1, FB40.2, FB40.3, FB45.1, GL135 +16 more
CTRSET5
  1. COMPANY
  2. FISCAL-YEAR
  3. BUDGET-NBR
  4. TRANSL-CODE
  5. FR-CURR-CODE
  6. TO-CURR-CODE
SubsetWhere COMPANY != ZeroesCU20.4

Relations

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

One to one (5) — lookups and parents

RelationTableRulesConditionField map
CurelatCURELATRequired
CTR-CURRENCY-TABLE→CRL-CURRENCY-TABLE
CTR-FR-CURR-CODE→CRL-FR-CURR-CODE
CTR-TO-CURR-CODE→CRL-TO-CURR-CODE
Fr CucodesCUCODESRequired
CTR-FR-CURR-CODE→CUC-CURRENCY-CODE
GlsystemGLSYSTEMRequired
CTR-COMPANY→GLS-COMPANY
To CucodesCUCODESRequired
CTR-TO-CURR-CODE→CUC-CURRENCY-CODE
TrcodesTRCODESRequired
CTR-TRANSL-CODE→TRC-TRANSL-CODE

One to many (1) — child tables

RelationTableRulesConditionField map
CutransbodCUTRANSBOD
CTR-CURRENCY-TABLE→YBN-CURRENCY-TABLE
CTR-FR-CURR-CODE→YBN-FR-CURR-CODE
CTR-TO-CURR-CODE→YBN-TP-CURR-CODE
CTR-FISCAL-YEAR→YBN-FISCAL-YEAR
CTR-COMPANY→YBN-COMPANY
CTR-BUDGET-NBR→YBN-BUDGET-NBR
CTR-TRANSL-CODE→YBN-TRANSL-CODE
—→YBN-ACCT-PERIOD

Programs

Updated by (8)

Referenced by (129)