CUTABLE – Currency Table

System
General Ledger Setup (IF)
Prefix
CTB
Primary key
CURRENCY-TABLE
Fields
5
Updated by
1 program
Referenced by
137 programs

CUTABLE is the Currency Table table in Lawson General Ledger Setup (prefix CTB). It is indexed by CURRENCY-TABLE (CTBSET1). It is related 1:M to CUCONV, CURELAT, CUTRANSL and GLSYSTEM. It is updated by CU00.1 and referenced by AC00.1, AC191, AC200, AC210, AC56.1, AC560, AC70.1, AP125 and 129 more. The table has 5 fields, 1 index and 4 documented relations.

About CUTABLE

This file defines currency tables, which include currency relationships, currency exchange rates, and translation rates. CU20.1 (Currency Table Translation Rates) is the primary program that updates this file.

Fields (5)

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

Field / columnTypeDescription & valuesUpdated by
CTB-CURRENCY-TABLE PK
CURRENCY_TABLE		Alpha 12This is the currency table, a table of currency relationships, currency exchange rates, and translation rates for one or more companies.CU00.1
CTB-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This is the description of the currency table.AC00.1, AC70.1, CU00.1
CTB-ACTIVE-FLAG
ACTIVE_FLAG		Alpha 1This field indicates whether the currency table is active or inactive.
  • A Active
  • I Inactive
—
CTB-AUTOGEN
AUTOGEN		Alpha 1This field indicates whether the opposite currency relationship should be added when a new relationship is added. It also indicates whether exchange rates should be added if the opposite currency relationship exists and if that opposite relationship has the reverse operator.CU00.1
CTB-CURR-REL-FLAG
CURR_REL_FLAG		Derived——

Indexes (1)

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

IndexKeysFlagsConditionUsed in
CTBSET1CURRENCY-TABLEPrimaryAC00.1, AC191, AC200, AC210, AC56.1, AC560, AC70.1, AP125 +22 more (list truncated in source)

Relations

One to many (4) — child tables

RelationTableRulesConditionField map
CuconvCUCONVCTB-CURRENCY-TABLE → CCN-CURRENCY-TABLE, → CCN-FR-CURR-CODE, → CCN-TO-CURR-CODE, → CCN-SYSTEM, → CCN-EFFECT-DATE
CurelatCURELATCTB-CURRENCY-TABLE → CRL-CURRENCY-TABLE, → CRL-FR-CURR-CODE, → CRL-TO-CURR-CODE
CutranslCUTRANSLCTB-CURRENCY-TABLE → CTR-CURRENCY-TABLE, → CTR-FR-CURR-CODE, → CTR-TO-CURR-CODE, → CTR-FISCAL-YEAR, → CTR-COMPANY, → CTR-BUDGET-NBR, → CTR-TRANSL-CODE
GlsystemGLSYSTEMRequiredCTB-CURRENCY-TABLE → GLS-CURRENCY-TABLE, → GLS-COMPANY

Programs

Updated by (1)

Referenced by (137)