CBCSCDAUD – Cash Code Audit

System
Cash Ledger (CB)
Prefix
CCB
Primary key
CASH-CODE, UNIQUE-I-D
Fields
14
Updated by
6 programs
Referenced by
1 program

CBCSCDAUD is the Cash Code Audit table in Lawson Cash Ledger (prefix CCB). It is indexed by CASH-CODE, UNIQUE-I-D (CCBSET1); alternate indexes: CCBSET2, CCBSET3 and CCBUID. It is related 1:1 to CBCASHCODE and CBDICT. It is updated by CB00.1, CB00.2, CB00.3, CB01.1, CB07.1 and CB305 and referenced by CB89.3. The table has 14 fields, 4 indexes and 2 documented relations.

About CBCSCDAUD

No description in the Lawson data dictionary.

Fields (14)

Column = COBOL field name without the CCB- 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
#CCB-UNIQUE-I-D PK
UNIQUE_I_D		Bad Type 36——
#CCB-CASH-CODE PK
CASH_CODE		Alpha 4—CB00.1, CB00.2, CB00.3, CB01.1, CB07.1
#CCB-ACTION
ACTION		Alpha 1—CB00.1, CB00.2, CB00.3, CB01.1, CB07.1
#CCB-OPERATOR SET2
OPERATOR		Alpha 10—CB00.1, CB00.2, CB00.3, CB01.1, CB07.1
#CCB-DATE SET2
DATE		Numeric 8 (yyyymmdd)—CB00.1, CB00.2, CB00.3, CB01.1, CB07.1
#CCB-TIME
TIME		Numeric 6 (hhmmss)—CB00.1, CB00.2, CB00.3, CB01.1, CB07.1
#CCB-FLD-NAME
FLD_NAME		Alpha 15—CB00.1, CB00.2, CB00.3, CB01.1, CB07.1
#CCB-FLD-NBR
FLD_NBR		Numeric 4—CB00.1, CB00.2, CB00.3, CB01.1, CB07.1
#CCB-OLD-VALUE
OLD_VALUE		Alpha 60—CB00.1, CB00.2, CB00.3, CB01.1, CB07.1
#CCB-NEW-VALUE
NEW_VALUE		Alpha 60—CB00.1, CB00.2, CB00.3, CB01.1, CB07.1
#CCB-DB-FILE-PFX
DB_FILE_PFX		Alpha 3——
#CCB-USER-CLASS SET3
USER_CLASS		Alpha 12—CB00.1, CB00.2, CB00.3, CB01.1, CB07.1
#CCB-FIELD-DESC
FIELD_DESC		Derived——
#CCB-PROGRAM
PROGRAM		Alpha 5—CB00.1, CB00.2, CB00.3, CB01.1, CB07.1

Indexes (4)

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
CCBSET1
  1. CASH-CODE
  2. UNIQUE-I-D
PrimaryCB00.1, CB00.2, CB00.3, CB01.1, CB07.1, CB305, CB89.3
CCBSET2
  1. CASH-CODE
  2. OPERATOR
  3. DATE
  4. UNIQUE-I-D
—
CCBSET3
  1. CASH-CODE
  2. USER-CLASS
  3. UNIQUE-I-D
—
CCBUID
  1. UNIQUE-I-D
—

Relations

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

One to one (2) — lookups and parents

RelationTableRulesConditionField map
CbcashcodeCBCASHCODERequired
CCB-CASH-CODE→CBC-CASH-CODE (CBCSET1)
CbdictCBDICTRequired
CCB-DB-FILE-PFX→CBQ-DB-FILE-PFX
CCB-FLD-NBR→CBQ-FLD-NBR

Programs

Updated by (6)

Referenced by (1)