CBSTMTREC – No description in the Lawson data dictionary

System
Cash Ledger (CB)
Prefix
CSR
Primary key
STMT-NBR, STMT-SUFFIX, LINE-NBR
Fields
22
Updated by
6 programs
Referenced by
1 program

CBSTMTREC is a Lawson Cash Ledger table (prefix CSR); no description in the lawson data dictionary. It is indexed by STMT-NBR, STMT-SUFFIX, LINE-NBR (CSRSET1); alternate indexes: CSRSET2 and CSRSET3. It is related 1:M to CBTRANS. It is updated by CB185, CB30.1, CB300, CB80.1, CB81.1 and CB82.1 and referenced by CB281. The table has 22 fields, 3 indexes and 1 documented relation.

About CBSTMTREC

No description in the Lawson data dictionary.

Fields (22)

Column = COBOL field name without the CSR- 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
#CSR-STMT-NBR PK
STMT_NBR		Numeric 12The bank-assigned reconciliation statement number. Used only for cash codes that require reconciliation statements.CB81.1
#CSR-STMT-SUFFIX PK
STMT_SUFFIX		Alpha 5—CB81.1
#CSR-LINE-NBR PK
LINE_NBR		Numeric 6This field contains the line number.CB81.1
#CSR-BANK-ENTITY
BANK_ENTITY		Alpha 15Represents a bank institution location.CB81.1
#CSR-BANK-ACCT-NBR
BANK_ACCT_NBR		Alpha 35The bank-assigned account number identification to be used for the cash code.CB81.1
#CSR-RECORD-TYPE
RECORD_TYPE		Alpha 1This field identifies the type of record defined. Valid values are:
  • S Summary
  • D Detail
CB81.1
#CSR-CASH-CODE
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.CB185, CB81.1, CB82.1
#CSR-BANK-INST-CODE
BANK_INST_CODE		Alpha 3A transaction code represents a type of cash payment, bill of exchange payment, or bank service transaction.CB185, CB81.1, CB82.1
#CSR-TRANS-NBR
TRANS_NBR		Alpha 10 (Right Justified)A unique, user-defined value used to identify the transaction.CB81.1
#CSR-RECON-DATE
RECON_DATE		Numeric 8 (yyyymmdd)Represents the date the transaction cleared the bank or was voided.CB81.1
#CSR-RECON-AMT
RECON_AMT		Signed 18.2—CB81.1
#CSR-FUNCTION
FUNCTION		Alpha 1This field identifies the type of record defined. Valid values are: " " = Reconcile
  • S Summary
  • D Detail
  • V Void
  • R Reconcile
CB81.1
#CSR-DESCRIPTION
DESCRIPTION		Alpha 60 (Lower Case)—CB81.1
#CSR-USER-FIELD1
USER_FIELD1		Alpha 30This is the first user definable field. It can be used to capture any data that the user wants. The title of the field is setup in IC00.CB81.1
#CSR-USER-FIELD2
USER_FIELD2		Alpha 30This is the second user definable field. This field can be used to enter any data that the user wants to capture for this item. The title of the field is setup in IC00.CB81.1
#CSR-USER-FIELD3
USER_FIELD3		Alpha 30This is the first user definable field. It can be used to capture any data that the user wants. The title of the field is setup in IC00.CB81.1
#CSR-USER-FIELD4
USER_FIELD4		Alpha 30This is the second user definable field. This field can be used to enter any data that the user wants to capture for this item. The title of the field is setup in IC00.CB81.1
#CSR-RECON-BAL
RECON_BAL		Signed 18.2—CB185, CB30.1, CB81.1, CB82.1
#CSR-LINE-STATUS SET2 SET3
LINE_STATUS		Alpha 1This field identifies the type of record defined. Valid values are: " " = Open
  • S Summary
  • D Detail
  • C Closed
CB185, CB30.1, CB80.1, CB81.1, CB82.1
#CSR-MAINT-DATE
MAINT_DATE		Numeric 8 (yyyymmdd)The date last changed.CB81.1
#CSR-MAINT-TIME
MAINT_TIME		Numeric 6 (hhmmss)The time last changed.CB81.1
#CSR-OPERATOR
OPERATOR		Alpha 10This field is used to store the login id of the person who entered the record.CB81.1

Indexes (3)

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
CSRSET1
  1. STMT-NBR
  2. STMT-SUFFIX
  3. LINE-NBR
PrimaryCB185, CB30.1, CB300, CB80.1, CB81.1, CB82.1
CSRSET2
  1. STMT-NBR
  2. STMT-SUFFIX
  3. LINE-NBR
  4. LINE-STATUS
KeyChangeCB185, CB281
CSRSET3
  1. LINE-STATUS
  2. STMT-NBR
  3. STMT-SUFFIX
  4. LINE-NBR
KeyChangeCB185, CB281

Relations

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

One to many (1) — child tables

RelationTableRulesConditionField map
CbtransCBTRANS
CSR-CASH-CODE→CBT-CASH-CODE
CSR-STMT-NBR→CBT-CSR-STMT-NBR
CSR-STMT-SUFFIX→CBT-CSR-STMT-SUFF
CSR-LINE-NBR→CBT-CSR-LINE-NBR
—→CBT-BANK-INST-CODE
—→CBT-TRANS-NBR
—→CBT-TRANS-IDENT

Programs

Updated by (6)

Referenced by (1)