CBCHECK

Accounts Payable Cash Payment

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

REFERENCED BY
AP213 AP284 AP57.2 AP195


UPDATED BY
AP150 AP155 AP160 AP161 AP170 AP190
AP20.1 AP20.2 AP20.3 AP20.4 AP20.5 AP20.6
AP20.7 AP20.8 AP21.1 AP23.1 AP25.2 AP26.1
AP27.1 AP305 AP55.1 AP55.2 AP81.1 CB06.2
CB191 CB300 CB500 CB85.1 EE20.1 EE20.2
EE35.1 EE35.2 MA41.1 MA41.2 MA41.4 MA41.7
MA43.1 MA43.2 MA43.3 MA43.4 MA43.6 AP90.5
AP255 AP265 AP520 CB20.1 CB50.1 AP91.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CHK-CASH-CODE
Element: Cash Code		Alpha 4
The 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
AP20.7 AP20.8
AP21.1 AP23.1
AP25.2 AP26.1
AP27.1 AP55.1
AP81.1 CB06.2
CB500 EE20.1
EE20.2 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
CHK-BANK-INST-CODE
Element: Payment Code		Alpha 3
The 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
AP20.7 AP20.8
AP21.1 AP23.1
AP25.2 AP26.1
AP27.1 AP55.1
AP81.1 CB06.2
CB500 EE20.1
EE20.2 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
CHK-TRANS-NBR
Element: Payment Number		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
AP20.5 AP20.6
AP20.7 AP20.8
AP21.1 AP23.1
AP55.1 AP81.1
CB06.2 CB500
EE20.1 EE20.2
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6
CHK-TRANS-IDENT
Element: Transaction ID		Numeric 10
An 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
AP20.7 AP20.8
AP21.1 AP23.1
AP55.1 AP81.1
CB06.2 CB500
EE20.1 EE20.2
EE35.1 EE35.2
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6
CHK-COMPANY
Element: Company		Numeric 4
The 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
AP20.7 AP20.8
AP21.1 AP23.1
AP25.2 AP26.1
AP27.1 AP55.1
AP81.1 CB06.2
CB500 EE20.1
EE20.2 EE35.1
EE35.2 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
CHK-PROC-LEVEL
Element: Process Level		Alpha 5
The 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
AP20.8 AP21.1
AP23.1 AP25.2
AP26.1 AP27.1
AP55.1 AP81.1
CB06.2 CB500
EE20.1 EE20.2
EE35.1 EE35.2
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6
CHK-REC-STATUS
Element: Reconcile Status		Numeric 1
The payment record status. Valid values are: 0 = Scheduled by AP150. 1 = Processed by AP155 or AP160 or a manual payment entered in AP20 or AP55. 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
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP20.8
AP21.1 AP23.1
AP25.2 AP26.1
AP27.1 AP55.1
AP81.1 CB06.2
CB500 CB85.1
EE20.1 EE20.2
EE35.1 EE35.2
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6
CHK-VENDOR-GROUP
Element: Vendor Group		Alpha 4
The 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
AP20.8 AP21.1
AP23.1 AP25.2
AP26.1 AP27.1
AP55.1 AP81.1
CB06.2 CB500
EE20.1 EE20.2
EE35.1 EE35.2
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6
CHK-PAY-GROUP
Element: Pay Group		Alpha 4
The 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
AP20.7 AP20.8
AP21.1 AP23.1
AP55.1 AP81.1
CB500 EE20.1
EE20.2 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
CHK-PAID-VENDOR
Element: Pay 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
AP20.8 AP21.1
AP23.1 AP25.2
AP26.1 AP27.1
AP55.1 AP81.1
CB06.2 CB500
EE20.1 EE20.2
EE35.1 EE35.2
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6
CHK-PAID-NAME
Element: Pay Vendor Name		Alpha 30
The name of the vendor the payment was issued to.
AP150 AP155
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP20.8
AP21.1 AP23.1
AP25.2 AP26.1
AP27.1 AP55.1
AP81.1 CB06.2
CB500 EE20.1
EE20.2 EE35.1
EE35.2 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
CHK-REMIT-TO-CODE
Element: Remit To Code		Alpha 4
The 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
AP20.8 AP21.1
AP23.1 AP25.2
AP26.1 AP27.1
AP55.1 AP81.1
CB06.2 CB500
EE20.1 EE20.2
EE35.1 EE35.2
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6
CHK-BASE-PMT-AMT
Element: Base Payment Amount		Signed 18.2
The amount of the payment in the company base currency.
AP150 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP20.8 AP21.1
AP23.1 AP25.2
AP26.1 AP27.1
AP55.1 AP81.1
CB06.2 CB500
EE20.1 EE20.2
EE35.1 EE35.2
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6
CHK-BASE-ND
Base Number of
Decimals		Numeric 1
The 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
AP20.8 AP21.1
AP23.1 AP55.1
AP81.1 CB06.2
CB500 EE20.1
EE20.2 EE35.2
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6
CHK-TRAN-PMT-AMT
Transaction Payment
Amount		Signed 18.2
The 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
AP20.8 AP21.1
AP23.1 AP25.2
AP26.1 AP27.1
AP55.1 AP81.1
CB06.2 CB500
EE20.1 EE20.2
EE35.1 EE35.2
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6
CHK-TRAN-ND
Transaction Number
of Decimals		Numeric 1
The number of decimal places defined for the invoice currency.
AP150 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP20.8 AP21.1
AP23.1 AP55.1
AP81.1 CB06.2
CB500 EE20.1
EE20.2 EE35.2
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6
CHK-TOT-INV-PAID
Element: Total Invoice Paid		Signed 18.2
The 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
AP20.8 AP21.1
AP23.1 AP25.2
AP26.1 AP27.1
AP55.1 AP55.2
AP81.1 CB06.2
CB500 EE20.1
EE20.2 EE35.1
EE35.2 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
CHK-CHECK-DATE
Element: 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
AP20.5 AP20.6
AP20.7 AP20.8
AP21.1 AP23.1
AP25.2 AP26.1
AP27.1 AP55.1
AP81.1 CB06.2
CB500 EE20.1
EE20.2 EE35.1
EE35.2 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
CHK-PAY-CURRENCY
Element: Payment Currency		Alpha 5
The currency of the payment.
AP150 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP20.8 AP21.1
AP23.1 AP25.2
AP26.1 AP27.1
AP55.1 AP81.1
CB06.2 CB500
EE20.1 EE20.2
EE35.1 EE35.2
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6
CHK-ACT-CNV-RATE
Trans to Base
Exchange Rate		Signed 14.7
The 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
AP20.8 AP21.1
AP23.1 AP25.2
AP26.1 AP27.1
AP55.1 AP81.1
CB06.2 CB500
EE20.1 EE20.2
EE35.1 EE35.2
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6
CHK-SERIAL-NUM
Element: Serial Number		Numeric 8
A 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
AP20.7 AP20.8
AP21.1 AP23.1
AP55.1 AP81.1
CB06.2 CB500
EE20.1 EE20.2
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6
CHK-CHECK-TYPE
Payment Record
Origin		Alpha 1
Identifies where the cash payment record originated. Valid values are: Blank. A system generated payment created in AP150, AP157, AP160, or AP161. M = Manual. A manual payment created in AP20 or AP55. A = Alignment Form. A system voided payment used as an alignment form in AP155. L = Leader Form. A system voided payment used as a leader form in AP155. O = Overflow Form. A system voided payment used as an overflow form in AP155.
C = CB Payment
AP150 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP20.8 AP21.1
AP23.1 AP25.2
AP26.1 AP27.1
AP55.1 AP81.1
CB06.2 CB500
EE20.1 EE20.2
EE35.1 EE35.2
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6
CHK-RELEASE-FL
Element: Release Flag		Alpha 1
Indicates 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
AP21.1 AP23.1
AP25.2 AP26.1
AP27.1 AP55.1
AP81.1 CB06.2
CB191 CB500
EE20.1 EE20.2
EE35.1 EE35.2
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6
CHK-BASE-APPL-AMT
Base Application
Amount		Signed 18.2
The 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
AP20.8 AP21.1
AP23.1 AP25.2
AP26.1 AP27.1
AP55.1 AP55.2
AP81.1 CB06.2
CB500 EE20.1
EE20.2 EE35.1
EE35.2 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
CHK-BANK-CURR-AMT
Element: Bank Currency Amount		Signed 18.2
The payment amount in the currency of the bank account.
AP150 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP20.8 AP21.1
AP23.1 AP55.1
AP81.1 CB06.2
CB500 EE20.1
EE20.2 EE35.1
EE35.2 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
CHK-BNK-CNV-RATE
Trans to Bank
Exchange Rate		Signed 14.7
The 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
AP20.8 AP21.1
AP23.1 AP55.1
AP81.1 CB500
EE20.1 EE20.2
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6
CHK-BANK-APPL-AMT
Element: Bank Applied Amount		Signed 18.2
The 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
AP20.8 AP21.1
AP23.1 AP55.1
AP55.2 AP81.1
EE20.1 EE20.2
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6
CHK-BANK-ND
Bank Number of
Decimals		Numeric 1
The number of decimals defined for the bank account currency.
AP150 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP20.8 AP21.1
AP23.1 AP55.1
AP81.1 CB500
EE20.1 EE20.2
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6
CHK-REJECT-DATE
Element: 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
Element: Sort Option 1		Alpha 15
Sort option one used for sorting the payment in AP150.
AP150 CB06.2
CHK-SORT-OPTION2
Element: Sort Option 2		Alpha 15
Sort option 2 used for sorting the payment in AP150.
AP150 CB06.2
CHK-SORT-OPTION3
Element: Sort Option 3		Alpha 15
Sort option 3 used for sorting the payment in AP150.
AP150 CB06.2
CHK-INVOICE-GROUP
Element: Invoice Group		Alpha 4
The invoice group assigned to the payment.
AP150 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP20.8 AP21.1
AP23.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
CHK-PROC-GRP
Element: Process Group		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
Element: Check Status		Derived
Indicates the status of the payment.
CHK-SHORT-PAYEE
Element: Short Payee		Derived
A sort name for the vendor.
CHK-RECON-STMT-NBR
Reconcile Statement
Number		Numeric 12
The bank-assigned reconciliation statement number. Used only for cash codes that require reconciliation statements.
AP55.1


CBCHECK FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CHKSET1 CASH-CODE
BANK-INST-CODE
TRANS-IDENT
AP155 AP160
AP161 AP170
AP190 AP20.6
AP20.8 AP213
AP284 AP57.2
CB300 EE20.1
EE20.2
CHKSET10 PAY-GROUP
REC-STATUS
CASH-CODE
BANK-INST-CODE
PROC-GRP
TRANS-NBR
TRANS-IDENT
KeyChange
AP155 AP160
AP161
CHKSET2 PAY-GROUP
CASH-CODE
BANK-INST-CODE
TRANS-NBR
TRANS-IDENT
KeyChange
AP161 AP55.1
AP90.5 CB06.2
CB191
CHKSET3 PAY-GROUP
REC-STATUS
CASH-CODE
BANK-INST-CODE
TRANS-NBR
TRANS-IDENT
KeyChange
AP150 AP155
AP160 AP161
AP170 AP190
AP195 AP255
AP265 AP55.1
AP55.2
CHKSET4 CASH-CODE
BANK-INST-CODE
TRANS-NBR
TRANS-IDENT
KeyChange
...
AP155 AP160
AP161 AP190
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.6
AP20.7 AP20.8
AP21.1 AP23.1
AP25.2 AP26.1
AP27.1 AP520
AP55.1 AP81.1
CB06.2 CB20.1
CB50.1 CB500
EE20.1 EE20.2
EE35.1 EE35.2
MA41.1 MA41.2
CHKSET5 CASH-CODE
BANK-INST-CODE
SERIAL-NUM
TRANS-NBR
TRANS-IDENT
KeyChange
AP160 AP161
AP190 CB300
CB85.1
CHKSET8 VENDOR-GROUP
PAID-VENDOR
COMPANY
CHECK-DATE*
BANK-INST-CODE
CASH-CODE
TRANS-IDENT
KeyChange
AP305 AP91.1
CHKSET9 PAY-GROUP
CASH-CODE
CHECK-DATE
BANK-INST-CODE
TRANS-NBR
TRANS-IDENT
KeyChange
AP265


CBCHECK FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
CHK-COMPANY->CPY-COMPANY
Approclev APPROCLEV Required
When (-REC-STATUS <"9" )
And(-PROC-LEVEL !=Spaces )
CHK-COMPANY->APR-COMPANY
CHK-PROC-LEVEL->APR-PROC-LEVEL
Apvenmast APVENMAST Required
CHK-VENDOR-GROUP->VEN-VENDOR-GROUP
CHK-PAID-VENDOR->VEN-VENDOR
Cbcashcode CBCASHCODE Required
CHK-CASH-CODE->CBC-CASH-CODE
Cbcpycash CBCPYCASH Required
CHK-COMPANY->CBY-COMPANY
CHK-CASH-CODE->CBY-CASH-CODE
Cbtrans CBTRANS Not Required
Valid When CHK-SERIAL-NUM =Zeroes
CHK-BANK-INST-CODE->CBT-BANK-INST-CODE
CHK-TRANS-IDENT->CBT-TRANS-IDENT
Cbtrans Tape CBTRANS Not Required
Valid 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
Glsystem GLSYSTEM Required
CHK-COMPANY->GLS-COMPANY


CBCHECK FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Apapphist APAPPHIST
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
Appayment APPAYMENT
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
Cbdistrib CBDISTRIB
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
Cbpayment CBPAYMENT
CHK-PAY-GROUP->CBM-PAY-GROUP
CHK-BANK-INST-CODE->CBM-BANK-INST-CODE
CHK-TRANS-IDENT->CBM-TRANS-IDENT
  CBM-CASH-CODE

File created: Wed Jun 08 20:48:21 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.