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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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` SET2 OPERATOR	Alpha 10	—	CB00.1, CB00.2, CB00.3, CB01.1, CB07.1
#`CAB-DATE` SET2 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` SET3 CREDIT_LINE	Alpha 4	—	CB00.1, CB00.2, CB00.3, CB01.1, CB07.1
#`CAB-FIELD-DESC` FIELD_DESC	Derived	—	—

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.

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

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

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

CBBANKAUD – Bank Entity Audit

About CBBANKAUD

Fields (14) Copy as SQL

Indexes (4)

Relations

One to one (2) — lookups and parents

Programs

Updated by (6)

Referenced by (1)

Fields (14)