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.

Field / column	Type	Description & values	Updated 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` OPERATOR	Alpha 10	—	CB00.1, CB00.2, CB00.3, CB01.1, CB07.1
`CCB-DATE` 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` 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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Used in
`CCBSET1`	`CASH-CODE`, `UNIQUE-I-D`	Primary	CB00.1, CB00.2, CB00.3, CB01.1, CB07.1, CB305, CB89.3
`CCBSET2`	`CASH-CODE`, `OPERATOR`, `DATE`, `UNIQUE-I-D`		—
`CCBSET3`	`CASH-CODE`, `USER-CLASS`, `UNIQUE-I-D`		—
`CCBUID`	`UNIQUE-I-D`		—

Relations

One to one (2) — lookups and parents

Relation	Table	Rules	Condition	Field map
Cbcashcode	CBCASHCODE	Required		`CCB-CASH-CODE` → `CBC-CASH-CODE (CBCSET1)`
Cbdict	CBDICT	Required		`CCB-DB-FILE-PFX` → `CBQ-DB-FILE-PFX`, `CCB-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.3 Cash Code Audit Analysis