CBBANKAUD – Bank Entity Audit

System: Cash Ledger (CB)
Prefix: CAB
Primary key: BANK-ENTITY, UNIQUE-I-D
Fields: 14
Updated by: 6 programs
Referenced by: 1 program

CBBANKAUD is the Bank Entity Audit table in Lawson Cash Ledger (prefix CAB). It is indexed by BANK-ENTITY, UNIQUE-I-D (CABSET1); alternate indexes: CABSET2, CABSET3 and CABUID. It is related 1:1 to CBBANKENT and CBDICT. It is updated by CB00.1, CB00.2, CB00.3, CB01.1, CB07.1 and CB305 and referenced by CB89.1. The table has 14 fields, 4 indexes and 2 documented relations.

About CBBANKAUD

No description in the Lawson data dictionary.

Fields (14)

Column = COBOL field name without the CAB- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`CAB-UNIQUE-I-D` PK UNIQUE_I_D	Bad Type 36	—	—
`CAB-BANK-ENTITY` PK BANK_ENTITY	Alpha 15	—	CB00.1, CB00.2, CB00.3, CB01.1, CB07.1
`CAB-ACTION` ACTION	Alpha 1	—	CB00.1, CB00.2, CB00.3, CB01.1, CB07.1
`CAB-OPERATOR` OPERATOR	Alpha 10	—	CB00.1, CB00.2, CB00.3, CB01.1, CB07.1
`CAB-DATE` DATE	Numeric 8 (yyyymmdd)	—	CB00.1, CB00.2, CB00.3, CB01.1, CB07.1
`CAB-TIME` TIME	Numeric 6 (hhmmss)	—	CB00.1, CB00.2, CB00.3, CB01.1, CB07.1
`CAB-PROGRAM` PROGRAM	Alpha 5	—	CB00.1, CB00.2, CB00.3, CB01.1, CB07.1
`CAB-FLD-NAME` FLD_NAME	Alpha 15	—	CB00.1, CB00.2, CB00.3, CB01.1, CB07.1
`CAB-FLD-NBR` FLD_NBR	Numeric 4	—	CB00.1, CB00.2, CB00.3, CB01.1, CB07.1
`CAB-OLD-VALUE` OLD_VALUE	Alpha 60	—	CB00.1, CB00.2, CB00.3, CB01.1, CB07.1
`CAB-NEW-VALUE` NEW_VALUE	Alpha 60	—	CB00.1, CB00.2, CB00.3, CB01.1, CB07.1
`CAB-DB-FILE-PFX` DB_FILE_PFX	Alpha 3	—	CB00.1, CB00.2, CB00.3, CB01.1, CB07.1
`CAB-CREDIT-LINE` CREDIT_LINE	Alpha 4	—	CB00.1, CB00.2, CB00.3, CB01.1, CB07.1
`CAB-FIELD-DESC` FIELD_DESC	Derived	—	—

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
`CABSET1`	`BANK-ENTITY`, `UNIQUE-I-D`	Primary	CB00.1, CB00.2, CB00.3, CB01.1, CB07.1, CB305, CB89.1
`CABSET2`	`BANK-ENTITY`, `DATE`, `OPERATOR`, `UNIQUE-I-D`		—
`CABSET3`	`BANK-ENTITY`, `CREDIT-LINE`, `UNIQUE-I-D`		—
`CABUID`	`UNIQUE-I-D`		—

Relations

One to one (2) — lookups and parents

Relation	Table	Rules	Condition	Field map
Cbbankent	CBBANKENT	Required		`CAB-BANK-ENTITY` → `CBE-BANK-ENTITY (CBESET1)`
Cbdict	CBDICT	Required		`CAB-DB-FILE-PFX` → `CBQ-DB-FILE-PFX`, `CAB-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.1 Bank Entity Audit Analysis