CBCONSOL – This file is updated by a batch program that consolidated CBTRANS amounts by Cash Code/Bank Inst Code/Company.

System: Cash Ledger (CB)
Prefix: CBO
Primary key: CASH-CODE, BANK-INST-CODE, COMPANY, MAINT-DATE
Fields: 24
Updated by: 34 programs
Referenced by: 4 programs

CBCONSOL is the This file is updated by a batch program that consolidated CBTRANS amounts by Cash Code/Bank Inst Code/Company. table in Lawson Cash Ledger (prefix CBO). It is indexed by CASH-CODE, BANK-INST-CODE, COMPANY, MAINT-DATE (CBOSET1); alternate indexes: CBOSET2, CBOSET3, CBOSET4 and CBOSET5. It is updated by AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 and 26 more and referenced by CB90.6, CB90.7, CB90.8 and CBOP.1. The table has 24 fields, 5 indexes and 0 documented relations.

About CBCONSOL

This file is updated by a batch program that consolidated CBTRANS amounts by Cash Code/Bank Inst Code/Company. It is used to populate cash ledger data marts.

Fields (24)

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

Field / column	Type	Description & values	Updated by
`CBO-CASH-CODE` PK CASH_CODE	Alpha 4	A cash code represents a bank account. More than one company can use the same cash code. The cash code must be linked to a bank in the Lawson Cash Ledger system.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +26 more
`CBO-BANK-INST-CODE` PK BANK_INST_CODE	Alpha 3	A transaction code represents a type of cash payment, bill of exchange payment, or bank service transaction.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +26 more
`CBO-COMPANY` PK COMPANY	Numeric 4	Identifies the cash code company.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +26 more
`CBO-BANK-BEG-BAL` BANK_BEG_BAL	Signed 18.2	The bank beginning balance. Represents Represents all reconciled transactions up to (but not including) the run date of the report.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +24 more
`CBO-BANK-END-BAL` BANK_END_BAL	Signed 18.2	The bank ending balance. Represents all reconciled transaction up through the run date of the report	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +24 more
`CBO-OPEN-BEG-BAL` OPEN_BEG_BAL	Signed 18.2	Open Beginning Balance. Represents all open transaction up to (but not including) the run date of the report.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +24 more
`CBO-ACCT-BEG-BAL` ACCT_BEG_BAL	Signed 18.2	Accounting Beginning Balance. Represents all transactions posted to the cash code general ledger account up to (but not including) the run date of the report	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +24 more
`CBO-ISSUED` ISSUED	Signed 18.2	Amount of all issues for the run date	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CBO-ISSUED-UNITS` ISSUED_UNITS	Signed 6.0	Number of CBTRANS records for the issued amount	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CBO-RECONCILED` RECONCILED	Signed 18.2	Amount of all reconciled transactions for the run date.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CBO-RECON-UNITS` RECON_UNITS	Signed 6.0	Number of CBTRANS records for the reconciled amount.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CBO-VOIDED` VOIDED	Signed 18.2	Amount of all voided transactions for the run date.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CBO-VOIDED-UNITS` VOIDED_UNITS	Signed 6.0	Number of CBTRANS records for the voided amount.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CBO-STOP-PAID` STOP_PAID	Signed 18.2	Amount of all stop paid transactions for the run date of the report.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CBO-STOP-UNITS` STOP_UNITS	Signed 6.0	Number of CBTRANS records for the stop paid amount.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CBO-ADJUSTMENTS` ADJUSTMENTS	Signed 18.2	Amount of any reopened reconciled, voided, stop paid or staled dated record. Also any reconcile variance amouns.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CBO-STALE-DATED` STALE_DATED	Signed 18.2	Amount of all stale dated transactions for the run date of the report.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CBO-STALE-UNITS` STALE_UNITS	Signed 6.0	Number of CBTRANS records for the stale dated amount.	—
`CBO-ESCHEATED` ESCHEATED	Signed 18.2	Amount of all escheated transactions for the run date of the report	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CBO-ESCH-UNITS` ESCH_UNITS	Signed 6.0	Number of CBTRANS records for the escheated amount.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
`CBO-OPEN-END-BAL` OPEN_END_BAL	Signed 18.2	Open Ending Balance. Represents the open amount as of the run date of the report.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +24 more
`CBO-ACCT-END-BAL` ACCT_END_BAL	Signed 18.2	Accounting End Balance. Represents the amount posted to the cash code general ledger account up to and including the run date of the report.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +24 more
`CBO-MAINT-DATE` PK MAINT_DATE	Numeric 8 (yyyymmdd)	The date last changed.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +26 more
`CBO-MAINT-TIME` MAINT_TIME	Numeric 6 (hhmmss)	The time last changed.	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +26 more

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
`CBOSET1`	`CASH-CODE`, `BANK-INST-CODE`, `COMPANY`, `MAINT-DATE`	Primary	AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more (list truncated in source)
`CBOSET2`	`MAINT-DATE`, `CASH-CODE`, `COMPANY`, `BANK-INST-CODE`		CB181, CBOP.1
`CBOSET3`	`CASH-CODE`, `COMPANY`, `BANK-INST-CODE`, `MAINT-DATE*`		AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more (list truncated in source)
`CBOSET4`	`CASH-CODE`, `BANK-INST-CODE`, `COMPANY`, `MAINT-DATE*`		AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more (list truncated in source)
`CBOSET5`	`CASH-CODE`, `MAINT-DATE*`, `COMPANY`, `BANK-INST-CODE`		CB181, CB90.6, CB90.7, CB90.8, CB99.3, CB99.4, CB99.5

Programs

Updated by (34)

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
CB181 CBCONSOL Current Day Build
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
CB30.1 Reconciliation Variance Adjustment
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
CB99.3 Transaction Bank Balance Update
CB99.4 Transaction Account Balance Update
CB99.5 Transaction Open Balance Update

Referenced by (4)

CB90.6 Transaction Balance Inquiry at Cash Code Level
CB90.7 Transaction Balance Inquiry at Company Level
CB90.8 Transaction Balance Inquiry at Tran Code Level
CBOP.1 Cash Ledger OLAP Data Build