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.

Field / column	Type	Description & values	Updated 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` OPERATOR	Alpha 10	—	CB00.1, CB00.2, CB00.3, CB01.1, CB07.1
`CCC-DATE` 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` BANK_INST_CODE	Alpha 3	—	—
`CCC-PROCESS-LEVEL` PROCESS_LEVEL	Alpha 5	—	CB00.1, CB00.2, CB00.3, CB01.1, CB07.1
`CCC-FIELD-DESC` FIELD_DESC	Derived	—	—

Indexes (5)

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

Index	Keys	Flags	Used in
`CCCSET1`	`COMPANY`, `CASH-CODE`, `UNIQUE-I-D`	Primary	CB00.1, CB00.2, CB00.3, CB01.1, CB07.1, CB305, CB89.4
`CCCSET2`	`COMPANY`, `CASH-CODE`, `OPERATOR`, `UNIQUE-I-D`, `DATE`		—
`CCCSET3`	`COMPANY`, `CASH-CODE`, `PROCESS-LEVEL`, `UNIQUE-I-D`		—
`CCCSET4`	`COMPANY`, `CASH-CODE`, `BANK-INST-CODE`, `UNIQUE-I-D`		—
`CCCUID`	`UNIQUE-I-D`		—

Relations

One to one (2) — lookups and parents

Relation	Table	Rules	Condition	Field map
Cbcpycash	CBCPYCASH	Required		`CCC-COMPANY` → `CBY-COMPANY (CBYSET1)`, `CCC-CASH-CODE` → `CBY-CASH-CODE`
Cbdict	CBDICT	Required		`CCC-DB-FILE-PFX` → `CBQ-DB-FILE-PFX`, `CCC-FLD-NBR` → `CBQ-FLD-NBR`

Programs

Updated by (6)

CB00.1 Bank
CB00.2 Cash Code
CB00.3 Company Cash Code Relationships
CB01.1 Credit Risk
CB07.1 Stale Dating Accounts
CB305 Audit Report and Purge

Referenced by (1)

CB89.4 Company Cash Code Audit Analysis