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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 SET10 SET2 SET3 SET4 SET5 SET9
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 SET7
TRANS_ID_CBT		Numeric 10——
#CHK-COMPANY SET8
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 SET10 SET3
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 SET8
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 SET10 SET2 SET3 SET9
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 SET8
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 SET8 SET9
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 SET5
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 SET10
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 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
CHKSET1
  1. CASH-CODE
  2. BANK-INST-CODE
  3. TRANS-IDENT
PrimaryAP10.1, AP10.2, AP100, AP109, AP110, AP111, AP115, AP125 +22 more (list truncated in source)
CHKSET10
  1. PAY-GROUP
  2. REC-STATUS
  3. CASH-CODE
  4. BANK-INST-CODE
  5. PROC-GRP
  6. TRANS-NBR
  7. TRANS-IDENT
KeyChangeAP155, AP160, AP161, AP170, ZA161
CHKSET2
  1. PAY-GROUP
  2. CASH-CODE
  3. BANK-INST-CODE
  4. TRANS-NBR
  5. TRANS-IDENT
KeyChangeAP161, AP55.1, AP90.5, ZA161, CB06.2, CB191
CHKSET3
  1. PAY-GROUP
  2. REC-STATUS
  3. CASH-CODE
  4. BANK-INST-CODE
  5. TRANS-NBR
  6. TRANS-IDENT
KeyChangeAP150, AP155, AP160, AP161, AP170, AP190, AP195, AP255 +4 more
CHKSET4
  1. CASH-CODE
  2. BANK-INST-CODE
  3. TRANS-NBR
  4. TRANS-IDENT
KeyChangeAP155, AP160, AP161, AP190, AP20.1, AP20.2, AP20.3, AP20.4 +22 more (list truncated in source)
CHKSET5
  1. CASH-CODE
  2. BANK-INST-CODE
  3. SERIAL-NUM
  4. TRANS-NBR
  5. TRANS-IDENT
KeyChangeAP160, AP161, AP190, ZA161, CB300, CB80.1, CB82.1, CB85.1
CHKSET7
  1. CASH-CODE
  2. BANK-INST-CODE
  3. TRANS-IDENT
  4. TRANS-ID-CBT
—
CHKSET8
  1. VENDOR-GROUP
  2. PAID-VENDOR
  3. COMPANY
  4. CHECK-DATE ↓
  5. BANK-INST-CODE
  6. CASH-CODE
  7. TRANS-IDENT
KeyChangeAC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +22 more (list truncated in source)
CHKSET9
  1. PAY-GROUP
  2. CASH-CODE
  3. CHECK-DATE
  4. BANK-INST-CODE
  5. TRANS-NBR
  6. TRANS-IDENT
KeyChangeAP265

Relations

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

One to one (8) — lookups and parents

RelationTableRulesConditionField map
ApcompanyAPCOMPANYRequired
CHK-COMPANY→CPY-COMPANY
ApproclevAPPROCLEVRequiredWhen (-REC-STATUS < "9") And (-PROC-LEVEL != Spaces)
CHK-COMPANY→APR-COMPANY
CHK-PROC-LEVEL→APR-PROC-LEVEL
ApvenmastAPVENMASTRequired
CHK-VENDOR-GROUP→VEN-VENDOR-GROUP
CHK-PAID-VENDOR→VEN-VENDOR
CbcashcodeCBCASHCODERequired
CHK-CASH-CODE→CBC-CASH-CODE
CbcpycashCBCPYCASHRequired
CHK-COMPANY→CBY-COMPANY
CHK-CASH-CODE→CBY-CASH-CODE
CbtransCBTRANSNot RequiredValid When CHK-SERIAL-NUM = Zeroes
CHK-BANK-INST-CODE→CBT-BANK-INST-CODE
CHK-TRANS-IDENT→CBT-TRANS-IDENT
Cbtrans TapeCBTRANSNot RequiredValid When CHK-SERIAL-NUM != Zeroes
CHK-BANK-INST-CODE→CBT-BANK-INST-CODE
CHK-SERIAL-NUM→CBT-SERIAL-NUM
CHK-TRANS-IDENT→CBT-TRANS-IDENT
GlsystemGLSYSTEMRequired
CHK-COMPANY→GLS-COMPANY

One to many (4) — child tables

RelationTableRulesConditionField map
ApapphistAPAPPHIST
CHK-PAY-GROUP→AH3-PAY-GROUP
CHK-BANK-INST-CODE→AH3-BANK-INST-CODE
CHK-TRANS-IDENT→AH3-TRANS-IDENT
—→AH3-VENDOR
—→AH3-INVOICE
—→AH3-SUFFIX
—→AH3-CANCEL-SEQ
—→AH3-SEQ-NBR
—→AH3-VOID-SEQ
—→AH3-COMPANY
AppaymentAPPAYMENT
CHK-PAY-GROUP→APP-PAY-GROUP
CHK-BANK-INST-CODE→APP-BANK-INST-CODE
CHK-TRANS-IDENT→APP-TRANS-IDENT
—→APP-VENDOR
—→APP-INVOICE
—→APP-SUFFIX
—→APP-CANCEL-SEQ
—→APP-SEQ-NBR
—→APP-VOID-SEQ
—→APP-COMPANY
CbdistribCBDISTRIB
CHK-CASH-CODE→CBD-CASH-CODE
CHK-BANK-INST-CODE→CBD-BANK-INST-CODE
CHK-TRANS-IDENT→CBD-TRANS-IDENT
—→CBD-DIST-TYPE
—→CBD-SEQ-NBR
CbpaymentCBPAYMENT
CHK-PAY-GROUP→CBM-PAY-GROUP
CHK-BANK-INST-CODE→CBM-BANK-INST-CODE
CHK-TRANS-IDENT→CBM-TRANS-IDENT
—→CBM-CASH-CODE

Programs

Updated by (315)

Referenced by (33)