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.

Field / columnTypeDescription & valuesUpdated by
CBB-CASH-CODE PK
CASH_CODE		Alpha 4The cash code. Represents a bank account. Must be a valid record in the Cash Code file.CB190, CB99.2
CBB-PER-END-DATE PK
PER_END_DATE		Numeric 8 (yyyymmdd)The closing date of the bank period.CB190, CB99.2
CBB-BEG-BALANCE
BEG_BALANCE		Signed 18.2The 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-BALANCE
TRANS_BALANCE		Signed 18.2The total amount of all transactions for the bank period.CB190
CBB-DEBIT-BALANCE
DEBIT_BALANCE		Signed 18.2The total amount of bank debit transactions for the bank period.CB190
CBB-CREDIT-BALANCE
CREDIT_BALANCE		Signed 18.2The total amount of bank credit transactions for the bank period.CB190
CBB-DEBIT-REC-CNT
DEBIT_REC_CNT		Numeric 7The total number of bank debit transactions for the bank period.CB190
CBB-CREDIT-REC-CNT
CREDIT_REC_CNT		Numeric 7The total number of bank credit transactions for the bank period.CB190
CBB-ENDING-BALANCE
ENDING_BALANCE		Signed 18.2The bank account balance at the end of the bank period.CB99.2
CBB-PER-BEG-DATE
PER_BEG_DATE		Numeric 8 (yyyymmdd)The beginning date of the bank period.CB190, CB99.2

Indexes (2)

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

IndexKeysFlagsConditionUsed in
CBBSET1CASH-CODE, PER-END-DATEPrimaryAP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more (list truncated in source)
CBBSET2CASH-CODE, PER-END-DATE*CB222, CB30.1

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
CbcashcodeCBCASHCODERequiredCBB-CASH-CODE → CBC-CASH-CODE

One to many (1) — child tables

RelationTableRulesConditionField map
CbtransCBTRANSCBB-CASH-CODE → CBT-CASH-CODE, CBB-PER-END-DATE → CBT-PERIOD-DATE, → CBT-BANK-INST-CODE, → CBT-TRANS-NBR, → CBT-SUFFIX, → CBT-TRANS-IDENT

Programs

Updated by (3)

Referenced by (33)