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

Field / columnTypeDescription & valuesUpdated by
#CBO-CASH-CODE PK
CASH_CODE		Alpha 4A 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 3A 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 4Identifies 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.2The 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.2The bank ending balance. Represents all reconciled transaction up through the run date of the reportAP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +24 more
#CBO-OPEN-BEG-BAL
OPEN_BEG_BAL		Signed 18.2Open 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.2Accounting Beginning Balance. Represents all transactions posted to the cash code general ledger account up to (but not including) the run date of the reportAP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +24 more
#CBO-ISSUED
ISSUED		Signed 18.2Amount of all issues for the run dateAP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
#CBO-ISSUED-UNITS
ISSUED_UNITS		Signed 6.0Number of CBTRANS records for the issued amountAP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
#CBO-RECONCILED
RECONCILED		Signed 18.2Amount 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.0Number of CBTRANS records for the reconciled amount.AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
#CBO-VOIDED
VOIDED		Signed 18.2Amount 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.0Number 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.2Amount 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.0Number 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.2Amount 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.2Amount 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.0Number of CBTRANS records for the stale dated amount.—
#CBO-ESCHEATED
ESCHEATED		Signed 18.2Amount of all escheated transactions for the run date of the reportAP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more
#CBO-ESCH-UNITS
ESCH_UNITS		Signed 6.0Number 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.2Open 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.2Accounting 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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CBOSET1
  1. CASH-CODE
  2. BANK-INST-CODE
  3. COMPANY
  4. MAINT-DATE
PrimaryAP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more (list truncated in source)
CBOSET2
  1. MAINT-DATE
  2. CASH-CODE
  3. COMPANY
  4. BANK-INST-CODE
CB181, CBOP.1
CBOSET3
  1. CASH-CODE
  2. COMPANY
  3. BANK-INST-CODE
  4. MAINT-DATE ↓
AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more (list truncated in source)
CBOSET4
  1. CASH-CODE
  2. BANK-INST-CODE
  3. COMPANY
  4. MAINT-DATE ↓
AP170, AP180, AP181, AP190, AP255, AP265, AP81.1, AP90.5 +22 more (list truncated in source)
CBOSET5
  1. CASH-CODE
  2. MAINT-DATE ↓
  3. COMPANY
  4. BANK-INST-CODE
CB181, CB90.6, CB90.7, CB90.8, CB99.3, CB99.4, CB99.5

Programs

Updated by (34)

Referenced by (4)