CBSTATEMNT – Reconciliation Statement

System
Cash Ledger (CB)
Prefix
CSM
Primary key
CASH-CODE, RECON-STMT-NBR
Fields
22
Updated by
7 programs
Referenced by
27 programs

CBSTATEMNT is the Reconciliation Statement table in Lawson Cash Ledger (prefix CSM). It is indexed by CASH-CODE, RECON-STMT-NBR (CSMSET1); alternate indexes: CSMSET2. It is related 1:M to CBSTMTDTL. It is updated by CB06.1, CB06.2, CB185, CB191, CB30.1, CB80.1 and CB82.1 and referenced by AP170, AP180, AP181, AP190, AP255, AP265, AP55.1, AP81.1 and 19 more. The table has 22 fields, 2 indexes and 1 documented relation.

About CBSTATEMNT

The Reconciliation Statement file contains reconciliation statement records for cash codes that require statements to be reconciled.

Fields (22)

Column = COBOL field name without the CSM- 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
#CSM-CASH-CODE PK
CASH_CODE		Alpha 4The cash code. Represents the bank account that requires reconciliation statements. Must be a valid record in the Cash Code file and must have Yes selected in the Reconciliation Statement Required field.CB06.1
#CSM-RECON-STMT-NBR PK
RECON_STMT_NBR		Numeric 12The bank-assigned reconciliation statement number. Used only for cash codes that require reconciliation statements.CB06.1
#CSM-RECON-STMT-DT
RECON_STMT_DT		Numeric 8 (yyyymmdd)The date the reconciliation statement was prepared.CB06.1
#CSM-BEGIN-BAL
BEGIN_BAL		Signed 18.2The beginning balance for reconciliation statement. Represents the balance before the first transaction listed on the statement.CB06.1
#CSM-END-BAL
END_BAL		Signed 18.2The ending balance for the reconciliation statement. Represents the balance after the last transaction listed on the statement.CB06.1
#CSM-RECON-JRNL-BK
RECON_JRNL_BK		Alpha 12The reconciliation journal book assigned to the reconciliation statement.CB06.1
#CSM-STMT-STATUS SET2
STMT_STATUS		Numeric 1The status of the reconciliation statement. Valid values are:
  • 1 Open.
  • 9 Closed.
CB06.1, CB191
#CSM-COMPANY
COMPANY		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.CB06.1
#CSM-PROC-LEVEL
PROC_LEVEL		Alpha 5This field contains the process level, which is the reporting hierarchy below company.CB06.2
#CSM-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).CB06.1
#CSM-ORIG-RATE
ORIG_RATE		Signed 14.7The currency rate.CB06.1
#CSM-CURR-MUDV
CURR_MUDV		Alpha 1—CB06.1
#CSM-ORIG-ND
ORIG_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.CB06.1
#CSM-STMT-BAL-ENT
STMT_BAL_ENT		Signed 18.2—CB06.2, CB185, CB30.1, CB80.1, CB82.1
#CSM-STMT-ENT-DR
STMT_ENT_DR		Signed 18.2—CB06.2, CB185, CB30.1, CB80.1, CB82.1
#CSM-STMT-ENT-CR
STMT_ENT_CR		Signed 18.2—CB06.2, CB185, CB30.1, CB80.1, CB82.1
#CSM-DEP-INST-CODE
DEP_INST_CODE		Alpha 3—CB06.1
#CSM-CHK-INST-CODE
CHK_INST_CODE		Alpha 3—CB06.1
#CSM-BANK-INST-CODE
BANK_INST_CODE		Alpha 3A transaction code represents a type of cash payment, bill of exchange payment, or bank service transaction.CB06.1
#CSM-RECN-INST-CODE
RECN_INST_CODE		Alpha 3—CB06.1
#CSM-BATCH-NBR
BATCH_NBR		Numeric 6This identifies the batch the entered invoices, debit memos, and credit memos are a part of.CB06.2
#CSM-NBR-LINES
NBR_LINES		Numeric 6This is the number of detail lines.CB06.2, CB185, CB30.1, CB80.1, CB82.1

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.

IndexKeysFlagsConditionUsed in
CSMSET1
  1. CASH-CODE
  2. RECON-STMT-NBR
PrimaryAP170, AP180, AP181, AP190, AP255, AP265, AP55.1, AP81.1 +22 more (list truncated in source)
CSMSET2
  1. CASH-CODE
  2. RECON-STMT-NBR
  3. STMT-STATUS
KeyChange, SubsetWhere STMT-STATUS = 1—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
CBSTMTDTLCBSTATEMNT

One to many (1) — child tables

RelationTableRulesConditionField map
CbstmtdtlCBSTMTDTLDelete Restricted
CSM-CASH-CODE→CSD-CASH-CODE (CSDSET1)
CSM-RECON-STMT-NBR→CSD-RECON-STMT-NBR
—→CSD-LINE-NBR

Programs

Updated by (7)

Referenced by (27)