CBCHECK – Accounts Payable Cash Payment

System
Cash Ledger (CB)
Prefix
CHK
Primary key
CASH-CODE, BANK-INST-CODE, TRANS-IDENT
Fields
39
Updated by
315 programs
Referenced by
33 programs

CBCHECK is the Accounts Payable Cash Payment table in Lawson Cash Ledger (prefix CHK). It is indexed by CASH-CODE, BANK-INST-CODE, TRANS-IDENT (CHKSET1); alternate indexes: CHKSET10, CHKSET2, CHKSET3, CHKSET4, CHKSET5, CHKSET7, CHKSET8 and CHKSET9. It is related 1:1 to APCOMPANY, APPROCLEV, APVENMAST, CBCASHCODE, CBCPYCASH, CBTRANS and GLSYSTEM and 1:M to APAPPHIST, APPAYMENT, CBDISTRIB and CBPAYMENT. It is updated by AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 and 307 more and referenced by AP10.1, AP10.2, AP100, AP109, AP111, AP14.1, AP14.2, AP14.5 and 25 more. The table has 39 fields, 9 indexes and 12 documented relations.

About CBCHECK

The Accounts Payable Cash Payment file contains all accounts payable cash payment records for a cash code (bank account).

Fields (39)

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

Field / columnTypeDescription & valuesUpdated by
CHK-CASH-CODE PK
CASH_CODE
Alpha 4The cash code. Represents the bank account the payment was issued from. Must be a valid record in the Cash Code file.AP150, AP155, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.6 +21 more
CHK-BANK-INST-CODE PK
BANK_INST_CODE
Alpha 3The payment code. Represents the type of cash payment. Must be a valid cash payment type transaction code record in the Bank Transaction Code file.AP150, AP155, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.6 +21 more
CHK-TRANS-NBR
TRANS_NBR
Alpha 10 (Right Justified)The payment number. Represents a unique value used to identify the cash payment transaction.AP150, AP155, AP160, AP161, AP20.1, AP20.2, AP20.3, AP20.4 +21 more
CHK-TRANS-IDENT PK
TRANS_IDENT
Numeric 10An identification number assigned by the system upon creation. Used as a unique identifier by the system.AP150, AP155, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.6 +20 more
CHK-TRANS-ID-CBT
TRANS_ID_CBT
Numeric 10
CHK-COMPANY
COMPANY
Numeric 4The company number. Must be a valid record in the Accounts Payable Company file.AP150, AP155, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.6 +23 more
CHK-PROC-LEVEL
PROC_LEVEL
Alpha 5The process level. Must be a valid record in the Process Level file. Updated only when AP150 (Cash Requirements) is run by process level.AP150, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.6, AP20.7 +22 more
CHK-REC-STATUS
REC_STATUS
Numeric 1The payment record status. Valid values are: manual payment entered in AP20 or AP55.
  • 0 Scheduled by AP150.
  • 1 Processed by AP155 or AP160 or a
  • 2 Closed by AP170.
  • 3 Tape Reject (not reinstated).
  • 4 Tape Reject (reinstated).
  • 5 Temporary Void.
  • 9 Reserved for Manual Payment.
AP150, AP155, AP160, AP161, AP170, AP190, AP20.1, AP20.2 +30 more
CHK-VENDOR-GROUP
VENDOR_GROUP
Alpha 4The vendor group associated with the pay vendor. Must be a valid record in the Vendor Group file.AP150, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.6, AP20.7 +22 more
CHK-PAY-GROUP
PAY_GROUP
Alpha 4The pay group. Must be a valid record in the Pay Group file.AP150, AP155, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.6 +17 more
CHK-PAID-VENDOR
PAID_VENDOR
Alpha 9 (Right Justified)The vendor the payment was issued to. Must be a valid record in the Vendor file.AP150, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.6, AP20.7 +22 more
CHK-PAID-NAME
PAID_NAME
Alpha 30The name of the vendor the payment was issued to.AP150, AP155, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.6 +23 more
CHK-REMIT-TO-CODE
REMIT_TO_CODE
Alpha 4The remit-to location the payment was issued to, if applicable. Represents an alternate remittance location for the vendor. Must be a valid remit-to type location record in the Vendor Location file.AP150, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.6, AP20.7 +22 more
CHK-BASE-PMT-AMT
BASE_PMT_AMT
Signed 18.2The amount of the payment in the company base currency.AP150, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.6, AP20.7 +22 more
CHK-BASE-ND
BASE_ND
Numeric 1The number of decimal places defined for the company base currency.AP150, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.6, AP20.7 +18 more
CHK-TRAN-PMT-AMT
TRAN_PMT_AMT
Signed 18.2The amount of the invoices to be applied to the payment in the currency of the invoices.AP150, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.6, AP20.7 +22 more
CHK-TRAN-ND
TRAN_ND
Numeric 1The number of decimal places defined for the invoice currency.AP150, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.6, AP20.7 +18 more
CHK-TOT-INV-PAID
TOT_INV_PAID
Signed 18.2The total amount of invoices applied to the payment in invoice currency.AP150, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.6, AP20.7 +23 more
CHK-CHECK-DATE
CHECK_DATE
Numeric 8 (yyyymmdd)The payment date assigned to the payment in AP20, AP55, AP155, AP157, AP160, or AP161.AP150, AP155, AP160, AP161, AP20.1, AP20.2, AP20.3, AP20.4 +26 more
CHK-PAY-CURRENCY
PAY_CURRENCY
Alpha 5The currency of the payment.AP150, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.6, AP20.7 +22 more
CHK-ACT-CNV-RATE
ACT_CNV_RATE
Signed 14.7The currency exchange rate in effective at the time of payment. Used to convert the payment amount from the invoice currency to the company base currency.AP150, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.6, AP20.7 +22 more
CHK-SERIAL-NUM
SERIAL_NUM
Numeric 8A system-defined number assigned to an electronic payment tape created in AP160 (Payment Tape Creation) or an electronic payment file in AP161 (Electonic Payment Creation). This serial number is required to recreate a payment tape in AP160 or a file AP161.AP160, AP161, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.6 +19 more
CHK-CHECK-TYPE
CHECK_TYPE
Alpha 1Identifies where the cash payment record originated. Valid values are: Blank. A system generated payment created in AP150, AP157, AP160, or AP161. AP20 or AP55. payment used as an alignment form in AP155. used as a leader form in AP155. payment used as an overflow form in AP155.
  • M Manual. A manual payment created in
  • A Alignment Form. A system voided
  • L Leader Form. A system voided payment
  • O Overflow Form. A system voided
  • C CB Payment
AP150, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.6, AP20.7 +22 more
CHK-RELEASE-FL
RELEASE_FL
Alpha 1Indicates whether the payment has been released. Valid values are:
  • N No.
  • Y Yes.
AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.6, AP20.7, AP20.8 +22 more
CHK-BASE-APPL-AMT
BASE_APPL_AMT
Signed 18.2The total amount of invoices applied to the payment in the company base currency.AP150, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.6, AP20.7 +23 more
CHK-BANK-CURR-AMT
BANK_CURR_AMT
Signed 18.2The payment amount in the currency of the bank account.AP150, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.6, AP20.7 +19 more
CHK-BNK-CNV-RATE
BNK_CNV_RATE
Signed 14.7The currency exchange rate at the time of payment. Used to convert the payment amount from the invoice currency to the bank account currency.AP150, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.6, AP20.7 +16 more
CHK-BANK-APPL-AMT
BANK_APPL_AMT
Signed 18.2The amount of invoices applied to the payment in the currency of the bank account.AP150, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.6, AP20.7 +16 more
CHK-BANK-ND
BANK_ND
Numeric 1The number of decimals defined for the bank account currency.AP150, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.6, AP20.7 +16 more
CHK-REJECT-DATE
REJECT_DATE
Numeric 8 (yyyymmdd)If the payment was created in AP160 and was rejected by the bank, this field contains the date the tape payment record was rejected by the bank.CB500, CB85.1
CHK-SORT-OPTION1
SORT_OPTION1
Alpha 15Sort option one used for sorting the payment in AP150.AP150, CB06.2
CHK-SORT-OPTION2
SORT_OPTION2
Alpha 15Sort option 2 used for sorting the payment in AP150.AP150, CB06.2
CHK-SORT-OPTION3
SORT_OPTION3
Alpha 15Sort option 3 used for sorting the payment in AP150.AP150, CB06.2
CHK-INVOICE-GROUP
INVOICE_GROUP
Alpha 4The invoice group assigned to the payment.AP150, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.6, AP20.7 +11 more
CHK-PROC-GRP
PROC_GRP
Alpha 4 (Lower Case)A process group is an identifier used for separating vendors into different groups to enable concurrent processing within the cash payment cycle.AP150, AP155
CHK-CHK-STATUS
CHK_STATUS
DerivedIndicates the status of the payment.
CHK-SHORT-PAYEE
SHORT_PAYEE
DerivedA sort name for the vendor.
CHK-RECON-STMT-NBR
RECON_STMT_NBR
Numeric 12The bank-assigned reconciliation statement number. Used only for cash codes that require reconciliation statements.AP55.1
CHK-TEMP-HOLD
TEMP_HOLD
Alpha 1
  • S Sent for Approval
  • A Approved by Engine
AP150, AP30.3, CB55.1

Indexes (9)

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

IndexKeysFlagsConditionUsed in
CHKSET1CASH-CODE, BANK-INST-CODE, TRANS-IDENTPrimaryAP10.1, AP10.2, AP100, AP109, AP110, AP111, AP115, AP125 +22 more (list truncated in source)
CHKSET10PAY-GROUP, REC-STATUS, CASH-CODE, BANK-INST-CODE, PROC-GRP, TRANS-NBR, TRANS-IDENTKeyChangeAP155, AP160, AP161, AP170, ZA161
CHKSET2PAY-GROUP, CASH-CODE, BANK-INST-CODE, TRANS-NBR, TRANS-IDENTKeyChangeAP161, AP55.1, AP90.5, ZA161, CB06.2, CB191
CHKSET3PAY-GROUP, REC-STATUS, CASH-CODE, BANK-INST-CODE, TRANS-NBR, TRANS-IDENTKeyChangeAP150, AP155, AP160, AP161, AP170, AP190, AP195, AP255 +4 more
CHKSET4CASH-CODE, BANK-INST-CODE, TRANS-NBR, TRANS-IDENTKeyChangeAP155, AP160, AP161, AP190, AP20.1, AP20.2, AP20.3, AP20.4 +22 more (list truncated in source)
CHKSET5CASH-CODE, BANK-INST-CODE, SERIAL-NUM, TRANS-NBR, TRANS-IDENTKeyChangeAP160, AP161, AP190, ZA161, CB300, CB80.1, CB82.1, CB85.1
CHKSET7CASH-CODE, BANK-INST-CODE, TRANS-IDENT, TRANS-ID-CBT
CHKSET8VENDOR-GROUP, PAID-VENDOR, COMPANY, CHECK-DATE*, BANK-INST-CODE, CASH-CODE, TRANS-IDENTKeyChangeAC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +22 more (list truncated in source)
CHKSET9PAY-GROUP, CASH-CODE, CHECK-DATE, BANK-INST-CODE, TRANS-NBR, TRANS-IDENTKeyChangeAP265

Relations

One to one (8) — lookups and parents

RelationTableRulesConditionField map
ApcompanyAPCOMPANYRequiredCHK-COMPANYCPY-COMPANY
ApproclevAPPROCLEVRequiredWhen (-REC-STATUS < "9") And (-PROC-LEVEL != Spaces)CHK-COMPANYAPR-COMPANY, CHK-PROC-LEVELAPR-PROC-LEVEL
ApvenmastAPVENMASTRequiredCHK-VENDOR-GROUPVEN-VENDOR-GROUP, CHK-PAID-VENDORVEN-VENDOR
CbcashcodeCBCASHCODERequiredCHK-CASH-CODECBC-CASH-CODE
CbcpycashCBCPYCASHRequiredCHK-COMPANYCBY-COMPANY, CHK-CASH-CODECBY-CASH-CODE
CbtransCBTRANSNot RequiredValid When CHK-SERIAL-NUM = ZeroesCHK-BANK-INST-CODECBT-BANK-INST-CODE, CHK-TRANS-IDENTCBT-TRANS-IDENT
Cbtrans TapeCBTRANSNot RequiredValid When CHK-SERIAL-NUM != ZeroesCHK-BANK-INST-CODECBT-BANK-INST-CODE, CHK-SERIAL-NUMCBT-SERIAL-NUM, CHK-TRANS-IDENTCBT-TRANS-IDENT
GlsystemGLSYSTEMRequiredCHK-COMPANYGLS-COMPANY

One to many (4) — child tables

RelationTableRulesConditionField map
ApapphistAPAPPHISTCHK-PAY-GROUPAH3-PAY-GROUP, CHK-BANK-INST-CODEAH3-BANK-INST-CODE, CHK-TRANS-IDENTAH3-TRANS-IDENT, AH3-VENDOR, AH3-INVOICE, AH3-SUFFIX, AH3-CANCEL-SEQ, AH3-SEQ-NBR, AH3-VOID-SEQ, AH3-COMPANY
AppaymentAPPAYMENTCHK-PAY-GROUPAPP-PAY-GROUP, CHK-BANK-INST-CODEAPP-BANK-INST-CODE, CHK-TRANS-IDENTAPP-TRANS-IDENT, APP-VENDOR, APP-INVOICE, APP-SUFFIX, APP-CANCEL-SEQ, APP-SEQ-NBR, APP-VOID-SEQ, APP-COMPANY
CbdistribCBDISTRIBCHK-CASH-CODECBD-CASH-CODE, CHK-BANK-INST-CODECBD-BANK-INST-CODE, CHK-TRANS-IDENTCBD-TRANS-IDENT, CBD-DIST-TYPE, CBD-SEQ-NBR
CbpaymentCBPAYMENTCHK-PAY-GROUPCBM-PAY-GROUP, CHK-BANK-INST-CODECBM-BANK-INST-CODE, CHK-TRANS-IDENTCBM-TRANS-IDENT, CBM-CASH-CODE

Programs

Updated by (315)

Referenced by (33)