CBSTMTDTL – Cash Staement Detail

System
Cash Ledger (CB)
Prefix
CSD
Primary key
CASH-CODE, RECON-STMT-NBR, LINE-NBR
Fields
18
Updated by
5 programs
Referenced by
26 programs

CBSTMTDTL is the Cash Staement Detail table in Lawson Cash Ledger (prefix CSD). It is indexed by CASH-CODE, RECON-STMT-NBR, LINE-NBR (CSDSET1); alternate indexes: CSDSET2. It is updated by CB06.2, CB185, CB30.1, CB80.1 and CB82.1 and referenced by AP170, AP180, AP181, AP190, AP255, AP265, AP55.1, AP81.1 and 18 more. The table has 18 fields, 2 indexes and 0 documented relations.

About CBSTMTDTL

No description in the Lawson data dictionary.

Fields (18)

Column = COBOL field name without the CSD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
CSD-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.CB06.2, CB185, CB30.1, CB80.1, CB82.1
CSD-RECON-STMT-NBR PK
RECON_STMT_NBR		Numeric 12The bank-assigned reconciliation statement number. Used only for cash codes that require reconciliation statements.CB06.2, CB185, CB30.1, CB80.1, CB82.1
CSD-LINE-NBR PK
LINE_NBR		Numeric 6This field contains the line number.CB06.2, CB185, CB30.1, CB80.1, CB82.1
CSD-TRANS-TYPE
TRANS_TYPE		Alpha 1Determines if amounts or units are processed in each transaction.CB06.2, CB185, CB30.1, CB80.1, CB82.1
CSD-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.2, CB185, CB30.1, CB80.1, CB82.1
CSD-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.2, CB185, CB30.1, CB80.1, CB82.1
CSD-CUSTOMER
CUSTOMER		Alpha 9 (Right Justified)This field contains the number that represents a customer.CB06.2
CSD-VENDOR
VENDOR		Alpha 9 (Right Justified)The vendor's identification code.CB06.2
CSD-REMIT-TO-CODE
REMIT_TO_CODE		Alpha 4A user-defined code that represents a vendor's remittance address.CB06.2
CSD-PAYMENT-NBR
PAYMENT_NBR		Alpha 10 (Right Justified)—CB06.2, CB185, CB30.1, CB80.1, CB82.1
CSD-ORIG-CURRENCY
ORIG_CURRENCY		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).CB06.2, CB185, CB30.1, CB80.1, CB82.1
CSD-TRAN-AMT
TRAN_AMT		Signed 18.2—CB06.2, CB185, CB30.1, CB80.1, CB82.1
CSD-ORIG-AMT
ORIG_AMT		Signed 18.2—CB06.2, CB185, CB30.1, CB80.1, CB82.1
CSD-TRANS-DATE
TRANS_DATE		Numeric 8 (yyyymmdd)The date of the transaction.CB06.2, CB185, CB30.1, CB80.1, CB82.1
CSD-BATCH-NBR
BATCH_NBR		Numeric 6This identifies the batch the entered invoices, debit memos, and credit memos are a part of.CB06.2
CSD-PROC-LEVEL
PROC_LEVEL		Alpha 5This field contains the process level, which is the reporting hierarchy below company.CB06.2
CSD-PAY-GROUP
PAY_GROUP		Alpha 4A pay group is used for processing accounts payable payments. A pay group lets you create a single payment for a vendor to pay invoices received by all company process levels assigned to the pay group.CB06.2
CSD-TRANS-IDENT
TRANS_IDENT		Numeric 10A unique system-generated identification value assigned to the transaction to make this record unique.CB06.2, CB185, CB30.1, CB80.1, CB82.1

Indexes (2)

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

IndexKeysFlagsConditionUsed in
CSDSET1CASH-CODE, RECON-STMT-NBR, LINE-NBRPrimaryCB06.1, CB06.2, CB191
CSDSET2BANK-INST-CODE, RECON-STMT-NBR, PAYMENT-NBR, TRANS-TYPE, CASH-CODE, LINE-NBRKeyChangeAP170, AP180, AP181, AP190, AP255, AP265, AP55.1, AP81.1 +22 more (list truncated in source)

Programs

Updated by (5)

Referenced by (26)