CBBALANCE – Bank Account Balance
- System
- Cash Ledger (CB)
- Prefix
CBB- Primary key
CASH-CODE,PER-END-DATE- Fields
- 10
- Updated by
- 3 programs
- Referenced by
- 33 programs
CBBALANCE is the Bank Account Balance table in Lawson Cash Ledger (prefix CBB). It is indexed by CASH-CODE, PER-END-DATE (CBBSET1); alternate indexes: CBBSET2. It is related 1:1 to CBCASHCODE and 1:M to CBTRANS. It is updated by CB190, CB300 and CB99.2 and referenced by AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 and 25 more. The table has 10 fields, 2 indexes and 2 documented relations.
About CBBALANCE
The Bank Account Balance file contains bank account period balance information for a cash code.
Fields (10)
Column = COBOL field name without the CBB- 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 |
|---|---|---|---|
#CBB-CASH-CODE PKCASH_CODE | Alpha 4 | The cash code. Represents a bank account. Must be a valid record in the Cash Code file. | CB190, CB99.2 |
#CBB-PER-END-DATE PKPER_END_DATE | Numeric 8 (yyyymmdd) | The closing date of the bank period. | CB190, CB99.2 |
#CBB-BEG-BALANCEBEG_BALANCE | Signed 18.2 | The bank account balance at the beginning of the bank period. This value equals the ending balance of the previous bank period. | CB190, CB99.2 |
#CBB-TRANS-BALANCETRANS_BALANCE | Signed 18.2 | The total amount of all transactions for the bank period. | CB190 |
#CBB-DEBIT-BALANCEDEBIT_BALANCE | Signed 18.2 | The total amount of bank debit transactions for the bank period. | CB190 |
#CBB-CREDIT-BALANCECREDIT_BALANCE | Signed 18.2 | The total amount of bank credit transactions for the bank period. | CB190 |
#CBB-DEBIT-REC-CNTDEBIT_REC_CNT | Numeric 7 | The total number of bank debit transactions for the bank period. | CB190 |
#CBB-CREDIT-REC-CNTCREDIT_REC_CNT | Numeric 7 | The total number of bank credit transactions for the bank period. | CB190 |
#CBB-ENDING-BALANCEENDING_BALANCE | Signed 18.2 | The bank account balance at the end of the bank period. | CB99.2 |
#CBB-PER-BEG-DATEPER_BEG_DATE | Numeric 8 (yyyymmdd) | The beginning date of the bank period. | CB190, CB99.2 |
Indexes (2)
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 | Condition | Used in |
|---|---|---|---|---|
CBBSET1 |
| Primary | AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more (list truncated in source) | |
CBBSET2 |
| CB222, CB30.1 |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map | |||
|---|---|---|---|---|---|---|---|
| Cbcashcode | CBCASHCODE | Required |
|
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Cbtrans | CBTRANS |
|
Programs
Updated by (3)
Referenced by (33)
- 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
- CB191 Bank Statement Close
- CB20.1 Bank Transaction Entry
- CB20.6 Bank Transaction DIstribution
- CB222 Cash Position Reconciliation
- CB25.1 Manual Reconciliation Entry
- CB30.1 Reconciliation Variance Adjustment
- CB43.1 Receipts Load Maintenance
- CB44.1 Returned Payment Maintenance
- 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
- CB90.3 Bank Account Period Balance