CBTRANSAUD – No description in the Lawson data dictionary

System: Cash Ledger (CB)
Prefix: CAU
Primary key: BANK-INST-CODE, TRANS-IDENT, UNIQUE-I-D
Fields: 19
Updated by: 32 programs
Referenced by: 3 programs

CBTRANSAUD is a Lawson Cash Ledger table (prefix CAU); no description in the lawson data dictionary. It is indexed by BANK-INST-CODE, TRANS-IDENT, UNIQUE-I-D (CAUSET1); alternate indexes: CAUSET2, CAUSET3, CAUSET4, CAUSET5, CAUSET6 and CAUUID. It is related 1:1 to CBTRANS. It is updated by AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 and 24 more and referenced by CB00.2, CB95.1 and CB95.2. The table has 19 fields, 7 indexes and 1 documented relation.

About CBTRANSAUD

No description in the Lawson data dictionary.

Fields (19)

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

Field / column	Type	Description & values	Updated by
`CAU-UNIQUE-I-D` PK UNIQUE_I_D	Bad Type 36	—	—
`CAU-CASH-CODE` CASH_CODE	Alpha 4	—	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CAU-BANK-INST-CODE` PK BANK_INST_CODE	Alpha 3	—	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CAU-BANK-INST-TYPE` BANK_INST_TYPE	Alpha 1	—	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CAU-TRANS-NBR` TRANS_NBR	Alpha 10 (Right Justified)	—	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CAU-SUFFIX` SUFFIX	Numeric 3	—	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CAU-TRANS-IDENT` PK TRANS_IDENT	Numeric 10	—	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CAU-COMPANY` COMPANY	Numeric 4	—	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CAU-VENDOR` VENDOR	Alpha 9 (Right Justified)	—	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CAU-CUSTOMER` CUSTOMER	Alpha 9 (Right Justified)	—	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CAU-EMPLOYEE` EMPLOYEE	Numeric 9	—	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CAU-APPROVER` APPROVER	Alpha 30	—	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CAU-OPERATOR` OPERATOR	Alpha 10	—	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CAU-PERIOD-DATE` PERIOD_DATE	Numeric 8 (yyyymmdd)	—	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CAU-MAINT-DATE` MAINT_DATE	Numeric 8 (yyyymmdd)	—	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CAU-MAINT-TIME` MAINT_TIME	Numeric 6 (hhmmss)	—	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CAU-TRANS-DATE` TRANS_DATE	Numeric 8 (yyyymmdd)	—	—
`CAU-TRANS-TIME` TRANS_TIME	Numeric 6 (hhmmss)	—	—
`CAU-REC-STATUS` REC_STATUS	Numeric 1	—	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more

Indexes (7)

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

Index	Keys	Flags	Used in
`CAUSET1`	`BANK-INST-CODE`, `TRANS-IDENT`, `UNIQUE-I-D`	Primary, KeyChange	—
`CAUSET2`	`OPERATOR`, `MAINT-DATE`, `CASH-CODE`, `BANK-INST-CODE`, `TRANS-IDENT`, `REC-STATUS`, `UNIQUE-I-D`	KeyChange	CB295, CB95.2
`CAUSET3`	`CASH-CODE`, `MAINT-DATE`, `OPERATOR`, `BANK-INST-CODE`, `TRANS-NBR`, `TRANS-IDENT`, `REC-STATUS`, `UNIQUE-I-D`	KeyChange	CB00.2, CB295, CB305, CB95.1
`CAUSET4`	`VENDOR`, `MAINT-DATE`, `OPERATOR`, `BANK-INST-CODE`, `CASH-CODE`, `TRANS-NBR`, `TRANS-IDENT`, `UNIQUE-I-D`		—
`CAUSET5`	`CUSTOMER`, `MAINT-DATE`, `OPERATOR`, `CASH-CODE`, `COMPANY`, `BANK-INST-CODE`, `TRANS-IDENT`, `REC-STATUS`, `UNIQUE-I-D`	KeyChange	—
`CAUSET6`	`COMPANY`, `VENDOR`, `CUSTOMER`, `EMPLOYEE`, `MAINT-DATE`, `REC-STATUS`, `BANK-INST-CODE`, `TRANS-IDENT`, `CASH-CODE`, `UNIQUE-I-D`	KeyChange	—
`CAUUID`	`UNIQUE-I-D`		CB305

Relations

One to one (1) — lookups and parents

Relation	Table	Rules	Condition	Field map
Cbtrans	CBTRANS	Required		`CAU-BANK-INST-CODE` → `CBT-BANK-INST-CODE`, `CAU-TRANS-IDENT` → `CBT-TRANS-IDENT`

Programs

Updated by (32)

AP170 Payment Closing
AP180 Bill of Exchange Cashing Update
AP181 Bill of Exchange Statement Update
AP190 Invoice Reinstatement
AP255 Bank Account Payment History
AP265 Cash Payment Register
AP81.1 Manual Forms Reservation
AP90.5 Cash Payment Inquiry
CB06.2 Bank Statement Detail Entry
CB10.1 Cash Receipt Deposit
CB145 EFT Extract Update
CB15.1 Bank Fund Transfer - Multiple Deposits
CB15.2 Bank Fund Transfer - Multiple Withdrawals
CB150 Mass Release
CB180 Cash Ledger Void Update
CB185 Bank Tape Mass Reconciliation
CB186 Stale Dating Processing
CB187 Stale Dating Reopen Update
CB190 Bank Period Close
CB191 Bank Statement Close
CB20.1 Bank Transaction Entry
CB20.6 Bank Transaction DIstribution
CB25.1 Manual Reconciliation Entry
CB295 Bank Transaction Audit Report
CB30.1 Reconciliation Variance Adjustment
CB305 Audit Report and Purge
CB46.1 Returned Payment Entry
CB500 Bank Transaction Interface
CB543 Receipts Load
CB544 Returned Payment Load
CB80.1 Bank Transaction Adjustment
CB82.1 Statement Reconciliation

Referenced by (3)

CB00.2 Cash Code
CB95.1 Cash Code Audit
CB95.2 Operator Audit