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

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 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
CTBSET1
  1. CURRENCY-TABLE
PrimaryAC00.1, AC191, AC200, AC210, AC56.1, AC560, AC70.1, AP125 +22 more (list truncated in source)

Relations

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

One to many (4) — child tables

RelationTableRulesConditionField map
CuconvCUCONV
CTB-CURRENCY-TABLE→CCN-CURRENCY-TABLE
—→CCN-FR-CURR-CODE
—→CCN-TO-CURR-CODE
—→CCN-SYSTEM
—→CCN-EFFECT-DATE
CurelatCURELAT
CTB-CURRENCY-TABLE→CRL-CURRENCY-TABLE
—→CRL-FR-CURR-CODE
—→CRL-TO-CURR-CODE
CutranslCUTRANSL
CTB-CURRENCY-TABLE→CTR-CURRENCY-TABLE
—→CTR-FR-CURR-CODE
—→CTR-TO-CURR-CODE
—→CTR-FISCAL-YEAR
—→CTR-COMPANY
—→CTR-BUDGET-NBR
—→CTR-TRANSL-CODE
GlsystemGLSYSTEMRequired
CTB-CURRENCY-TABLE→GLS-CURRENCY-TABLE
—→GLS-COMPANY

Programs

Updated by (1)

Referenced by (137)