CBPOSIDATE – Cash Positive Date

System
Cash Ledger (CB)
Prefix
CPS
Primary key
CASH-CODE, BANK-INST-CODE
Fields
4
Updated by
1 program
Referenced by
0 programs

CBPOSIDATE is the Cash Positive Date table in Lawson Cash Ledger (prefix CPS). It is indexed by CASH-CODE, BANK-INST-CODE (CPSSET1). It is updated by CB170. The table has 4 fields, 1 index and 0 documented relations.

About CBPOSIDATE

No description in the Lawson data dictionary.

Fields (4)

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

Field / columnTypeDescription & valuesUpdated by
CPS-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.CB170
CPS-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.CB170
CPS-RUN-DATE
RUN_DATE
Numeric 8 (yyyymmdd)The date last changed.CB170
CPS-RUN-TIME
RUN_TIME
Numeric 6 (hhmmss)The time last changed.CB170

Indexes (1)

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

IndexKeysFlagsConditionUsed in
CPSSET1CASH-CODE, BANK-INST-CODEPrimaryCB170

Programs

Updated by (1)