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.

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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CTRSET1CURRENCY-TABLE, FR-CURR-CODE, TO-CURR-CODE, FISCAL-YEAR, COMPANY, BUDGET-NBR, TRANSL-CODEPrimaryAC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
CTRSET2CURRENCY-TABLE, COMPANY, FISCAL-YEAR, BUDGET-NBR, TRANSL-CODE, FR-CURR-CODE, TO-CURR-CODECU20.2, CU300
CTRSET3TRANSL-CODE, CURRENCY-TABLE, COMPANY, FR-CURR-CODE, TO-CURR-CODE, FISCAL-YEAR, BUDGET-NBRCU05.1, CU05.2
CTRSET4COMPANY, FR-CURR-CODE, TO-CURR-CODE, FISCAL-YEAR, BUDGET-NBR, TRANSL-CODESubsetWhere COMPANY != ZeroesFB145, FB190, FB195, FB40.1, FB40.2, FB40.3, FB45.1, GL135 +16 more
CTRSET5COMPANY, FISCAL-YEAR, BUDGET-NBR, TRANSL-CODE, FR-CURR-CODE, TO-CURR-CODESubsetWhere COMPANY != ZeroesCU20.4

Relations

One to one (5) — lookups and parents

RelationTableRulesConditionField map
CurelatCURELATRequiredCTR-CURRENCY-TABLE → CRL-CURRENCY-TABLE, CTR-FR-CURR-CODE → CRL-FR-CURR-CODE, CTR-TO-CURR-CODE → CRL-TO-CURR-CODE
Fr CucodesCUCODESRequiredCTR-FR-CURR-CODE → CUC-CURRENCY-CODE
GlsystemGLSYSTEMRequiredCTR-COMPANY → GLS-COMPANY
To CucodesCUCODESRequiredCTR-TO-CURR-CODE → CUC-CURRENCY-CODE
TrcodesTRCODESRequiredCTR-TRANSL-CODE → TRC-TRANSL-CODE

One to many (1) — child tables

RelationTableRulesConditionField map
CutransbodCUTRANSBODCTR-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)