CBCPCSAUD – Company Cash Code Audit

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

CBCPCSAUD is the Company Cash Code Audit table in Lawson Cash Ledger (prefix CCC). It is indexed by COMPANY, CASH-CODE, UNIQUE-I-D (CCCSET1); alternate indexes: CCCSET2, CCCSET3, CCCSET4 and CCCUID. It is related 1:1 to CBCPYCASH and CBDICT. It is updated by CB00.1, CB00.2, CB00.3, CB01.1, CB07.1 and CB305 and referenced by CB89.4. The table has 16 fields, 5 indexes and 2 documented relations.

About CBCPCSAUD

No description in the Lawson data dictionary.

Fields (16)

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

Indexes (5)

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
CCCSET1
  1. COMPANY
  2. CASH-CODE
  3. UNIQUE-I-D
PrimaryCB00.1, CB00.2, CB00.3, CB01.1, CB07.1, CB305, CB89.4
CCCSET2
  1. COMPANY
  2. CASH-CODE
  3. OPERATOR
  4. UNIQUE-I-D
  5. DATE
—
CCCSET3
  1. COMPANY
  2. CASH-CODE
  3. PROCESS-LEVEL
  4. UNIQUE-I-D
—
CCCSET4
  1. COMPANY
  2. CASH-CODE
  3. BANK-INST-CODE
  4. UNIQUE-I-D
—
CCCUID
  1. UNIQUE-I-D
—

Relations

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

One to one (2) — lookups and parents

RelationTableRulesConditionField map
CbcpycashCBCPYCASHRequired
CCC-COMPANY→CBY-COMPANY (CBYSET1)
CCC-CASH-CODE→CBY-CASH-CODE
CbdictCBDICTRequired
CCC-DB-FILE-PFX→CBQ-DB-FILE-PFX
CCC-FLD-NBR→CBQ-FLD-NBR

Programs

Updated by (6)

Referenced by (1)