CBDICT – No description in the Lawson data dictionary

System
Cash Ledger (CB)
Prefix
CBQ
Primary key
DB-FILE-PFX, FLD-NBR
Fields
5
Updated by
1 program
Referenced by
4 programs

CBDICT is a Lawson Cash Ledger table (prefix CBQ); no description in the lawson data dictionary. It is indexed by DB-FILE-PFX, FLD-NBR (CBQSET1); alternate indexes: CBQSET2. It is updated by CB588 and referenced by CB89.1, CB89.2, CB89.3 and CB89.4. The table has 5 fields, 2 indexes and 0 documented relations.

About CBDICT

No description in the Lawson data dictionary.

Fields (5)

Column = COBOL field name without the CBQ- 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
#CBQ-DB-FILE-PFX PK
DB_FILE_PFX		Alpha 3—CB588
#CBQ-FLD-NBR PK
FLD_NBR		Numeric 4—CB588
#CBQ-FLD-NAME SET2
FLD_NAME		Alpha 15—CB588
#CBQ-FLD-NAME-DESC
FLD_NAME_DESC		Alpha 50 (Lower Case)—CB588
#CBQ-DATA-TYPE
DATA_TYPE		Alpha 1—CB588

Indexes (2)

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
CBQSET1
  1. DB-FILE-PFX
  2. FLD-NBR
PrimaryCB588, CB89.1, CB89.2, CB89.3, CB89.4
CBQSET2
  1. DB-FILE-PFX
  2. FLD-NAME
  3. FLD-NBR
—

Programs

Updated by (1)

Referenced by (4)