CBCHECK FILE
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 AP90.5 AP195 AP255
AP265 AP520 CB80.1 AP91.1
UPDATED BY
AP150 AP155 AP157 AP160 AP161 AP170
AP190 AP20.1 AP20.2 AP20.5 AP20.6 AP20.7
AP20.8 AP23.1 AP25.2 AP26.1 AP305 AP55.1
AP55.2 AP81.1 CB06.2 CB191 CB300 CB500
CB85.1 CB951 EE20.1 EE20.2 EE35.1 EE35.2
MA40.1 MA40.2 MA41.1 MA41.2 MA41.4 MA41.5
MA41.6 MA43.1 MA43.2 MA43.3 MA43.4 MA52.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CHK-CASH-CODE Alpha 4 AP150 AP155
Cash Code The cash code. Represents the bank AP157 AP20.1
account the payment was issued from. AP20.2 AP20.5
Must be a valid record in the Cash Code AP20.6 AP20.7
file. AP20.8 AP23.1
AP25.2 AP26.1
AP55.1 AP81.1
CB06.2 CB500
CB951 EE20.1
EE20.2 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
CHK-BANK-INST-CODE Alpha 3 AP150 AP155
Payment Code The payment code. Represents the type AP157 AP20.1
of cash payment. Must be a valid cash AP20.2 AP20.5
payment type transaction code record in AP20.6 AP20.7
the Bank Transaction Code file. AP20.8 AP23.1
AP25.2 AP26.1
AP55.1 AP81.1
CB06.2 CB500
CB951 EE20.1
EE20.2 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
CHK-TRANS-NBR Alpha 10 (Right Justified) AP150 AP155
Payment Number The payment number. Represents a unique AP157 AP160
value used to identify the cash payment AP161 AP20.1
transaction. AP20.2 AP20.5
AP20.6 AP20.7
AP20.8 AP23.1
AP55.1 AP81.1
CB06.2 CB500
CB951 EE20.1
EE20.2 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
CHK-TRANS-IDENT Numeric 10 AP150 AP155
Transaction ID An identification number assigned by AP157 AP20.1
the system upon creation. Used as a AP20.2 AP20.5
unique identifier by the system. AP20.6 AP20.7
AP20.8 AP23.1
AP55.1 AP81.1
CB06.2 CB500
CB951 EE20.1
EE20.2 EE35.1
EE35.2 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
CHK-COMPANY Numeric 4 AP150 AP155
Company The company number. Must be a valid AP157 AP20.1
record in the Accounts Payable Company AP20.2 AP20.5
file. AP20.6 AP20.7
AP20.8 AP23.1
AP25.2 AP26.1
AP55.1 AP81.1
CB06.2 CB500
CB951 EE20.1
EE20.2 EE35.1
EE35.2 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
CHK-PROC-LEVEL Alpha 5 AP150 AP20.1
Process Level The process level. Must be a valid AP20.2 AP20.5
record in the Process Level file. AP20.6 AP20.7
Updated only when AP150 (Cash AP20.8 AP23.1
Requirements) is run by process level. AP25.2 AP26.1
AP55.1 AP81.1
CB06.2 CB500
CB951 EE20.1
EE20.2 EE35.1
EE35.2 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
CHK-REC-STATUS Numeric 1 AP150 AP155
Record Status The payment record status. Valid values AP157 AP160
are: AP161 AP170
AP190 AP20.1
0 = Scheduled by AP150. AP20.2 AP20.5
AP20.6 AP20.7
1 = Processed by AP155 or AP160 or a AP20.8 AP23.1
manual payment entered in AP20 or AP55. AP25.2 AP26.1
AP55.1 AP81.1
2 = Closed by AP170. CB06.2 CB500
CB85.1 CB951
3 = Tape Reject (not reinstated). EE20.1 EE20.2
EE35.1 EE35.2
4 = Tape Reject (reinstated). MA40.1 MA40.2
MA41.1 MA41.2
5 = Temporary Void. MA41.4 MA41.5
MA41.6 MA43.1
9 = Reserved for Manual Payment. MA43.2 MA43.3
MA43.4 MA52.1
CHK-VENDOR-GROUP Alpha 4 AP150 AP20.1
Vendor Group The vendor group associated with the AP20.2 AP20.5
pay vendor. Must be a valid record in AP20.6 AP20.7
the Vendor Group file. AP20.8 AP23.1
AP25.2 AP26.1
AP55.1 AP81.1
CB06.2 CB500
CB951 EE20.1
EE20.2 EE35.1
EE35.2 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
CHK-PAY-GROUP Alpha 4 AP150 AP155
Pay Group The pay group. Must be a valid record AP157 AP20.1
in the Pay Group file. AP20.2 AP20.5
AP20.6 AP20.7
AP20.8 AP23.1
AP55.1 AP81.1
CB500 CB951
EE20.1 EE20.2
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
CHK-PAID-VENDOR Alpha 9 AP150 AP20.1
Pay Vendor The vendor the payment was issued to. AP20.2 AP20.5
Must be a valid record in the Vendor AP20.6 AP20.7
file. AP20.8 AP23.1
AP25.2 AP26.1
AP55.1 AP81.1
CB06.2 CB500
CB951 EE20.1
EE20.2 EE35.1
EE35.2 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
CHK-PAID-NAME Alpha 30 AP150 AP155
Pay Vendor Name The name of the vendor the payment was AP157 AP20.1
issued to. AP20.2 AP20.5
AP20.6 AP20.7
AP20.8 AP23.1
AP25.2 AP26.1
AP55.1 AP81.1
CB06.2 CB500
CB951 EE20.1
EE20.2 EE35.1
EE35.2 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
CHK-REMIT-TO-CODE Alpha 4 AP150 AP20.1
Remit To Location The remit-to location the payment was AP20.2 AP20.5
Code issued to, if applicable. Represents an AP20.6 AP20.7
alternate remittance location for the AP20.8 AP23.1
vendor. Must be a valid remit-to type AP25.2 AP26.1
location record in the Vendor Location AP55.1 AP81.1
file. CB06.2 CB500
CB951 EE20.1
EE20.2 EE35.1
EE35.2 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
CHK-BASE-PMT-AMT Signed 15.2 AP150 AP20.1
Base Payment Amount The amount of the payment in the AP20.2 AP20.5
company base currency. AP20.6 AP20.7
AP20.8 AP23.1
AP25.2 AP26.1
AP55.1 AP81.1
CB06.2 CB500
CB951 EE20.1
EE20.2 EE35.1
EE35.2 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
CHK-BASE-ND Numeric 1 AP150 AP20.1
Base Number Of The number of decimal places defined AP20.2 AP20.5
Decimals for the company base currency. AP20.6 AP20.7
AP20.8 AP23.1
AP55.1 AP81.1
CB06.2 CB500
CB951 EE20.1
EE20.2 EE35.2
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
CHK-TRAN-PMT-AMT Signed 15.2 AP150 AP20.1
Payment Amount The amount of the invoices to be AP20.2 AP20.5
applied to the payment in the currency AP20.6 AP20.7
of the invoices. AP20.8 AP23.1
AP25.2 AP26.1
AP55.1 AP81.1
CB06.2 CB500
CB951 EE20.1
EE20.2 EE35.1
EE35.2 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
CHK-TRAN-ND Numeric 1 AP150 AP20.1
Transaction Number The number of decimal places defined AP20.2 AP20.5
of Decimals for the invoice currency. AP20.6 AP20.7
AP20.8 AP23.1
AP55.1 AP81.1
CB06.2 CB500
CB951 EE20.1
EE20.2 EE35.2
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
CHK-TOT-INV-PAID Signed 15.2 AP150 AP20.1
Total of Invoices The total amount of invoices applied to AP20.2 AP20.5
Paid the payment in invoice currency. AP20.6 AP20.7
AP20.8 AP23.1
AP25.2 AP26.1
AP55.1 AP55.2
AP81.1 CB06.2
CB500 CB951
EE20.1 EE20.2
EE35.1 EE35.2
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
CHK-CHECK-DATE Numeric 8 (yyyymmdd) AP150 AP155
Payment Date The payment date assigned to the AP157 AP160
payment. AP161 AP20.1
AP20.2 AP20.5
AP20.6 AP20.7
AP20.8 AP23.1
AP25.2 AP26.1
AP55.1 AP81.1
CB06.2 CB500
CB951 EE20.1
EE20.2 EE35.1
EE35.2 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
CHK-PAY-CURRENCY Alpha 5 AP150 AP20.1
Payment Currency The currency of the payment. AP20.2 AP20.5
AP20.6 AP20.7
AP20.8 AP23.1
AP25.2 AP26.1
AP55.1 AP81.1
CB06.2 CB500
CB951 EE20.1
EE20.2 EE35.1
EE35.2 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
CHK-ACT-CNV-RATE Signed 12.6 AP150 AP20.1
Trans to Base The currency exchange rate in effective AP20.2 AP20.5
Exchange Rate at the time of payment. Used to convert AP20.6 AP20.7
the payment amount from the invoice AP20.8 AP23.1
currency to the company base currency. AP25.2 AP26.1
AP55.1 AP81.1
CB06.2 CB500
CB951 EE20.1
EE20.2 EE35.1
EE35.2 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
CHK-SERIAL-NUM Numeric 8 AP160 AP161
Payment Run Serial A system-defined number assigned to an AP20.1 AP20.2
Number electronic payment tape created in AP160 AP20.5 AP20.6
(Payment Tape Creation) or an electronic AP20.7 AP20.8
payment file in AP161 (Electronic AP23.1 AP55.1
Payment Creation). This serial number is AP81.1 CB06.2
required to recreate a payment tape in CB500 CB951
AP160 or a file AP161. EE20.1 EE20.2
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
CHK-CHECK-TYPE Alpha 1 AP20.1 AP20.2
Payment Record Identifies where the cash payment AP20.5 AP20.6
Origin record originated. Valid values are: AP20.7 AP20.8
AP23.1 AP25.2
Blank. A system generated payment AP26.1 AP55.1
created in AP150, AP157, AP160, or AP81.1 CB06.2
AP161. CB500 CB951
EE20.1 EE20.2
M = Manual. A manual payment created in EE35.1 EE35.2
AP20 or AP55. MA40.1 MA40.2
MA41.1 MA41.2
A = Alignment Form. A system voided MA41.4 MA41.5
payment used as an alignment form in MA41.6 MA43.1
AP155. MA43.2 MA43.3
MA43.4 MA52.1
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.
CHK-RELEASE-FL Alpha 1 AP20.1 AP20.2
Released Indicates whether the payment has been AP20.5 AP20.6
released. Valid values are: AP20.7 AP20.8
AP23.1 AP25.2
N = No. AP26.1 AP55.1
Y = Yes. AP81.1 CB06.2
CB191 CB500
CB951 EE20.1
EE20.2 EE35.1
EE35.2 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
CHK-BASE-APPL-AMT Signed 15.2 AP150 AP20.1
Base Applied Amount The total amount of invoices applied to AP20.2 AP20.5
the payment in the company base AP20.6 AP20.7
currency. AP20.8 AP23.1
AP25.2 AP26.1
AP55.1 AP55.2
AP81.1 CB06.2
CB500 CB951
EE20.1 EE20.2
EE35.1 EE35.2
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
CHK-BANK-CURR-AMT Signed 15.2 AP150 AP20.1
Bank Currency Amount The payment amount in the currency of AP20.2 AP20.5
the bank account. AP20.6 AP20.7
AP20.8 AP23.1
AP55.1 AP81.1
CB06.2 CB500
CB951 EE20.1
EE20.2 EE35.1
EE35.2 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
CHK-BNK-CNV-RATE Signed 12.6 AP150 AP20.1
Trans to Bank The currency exchange rate at the time AP20.2 AP20.5
Exchange Rate of payment. Used to convert the payment AP20.6 AP20.7
amount from the invoice currency to the AP20.8 AP23.1
bank account currency. AP55.1 AP81.1
CB500 CB951
EE20.1 EE20.2
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
CHK-BANK-APPL-AMT Signed 15.2 AP150 AP20.1
Bank Applied Amount The amount of invoices applied to the AP20.2 AP20.5
payment in the currency of the bank AP20.6 AP20.7
account. AP20.8 AP23.1
AP55.1 AP55.2
AP81.1 CB951
EE20.1 EE20.2
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
CHK-BANK-ND Numeric 1 AP150 AP20.1
Bank Number of The number of decimals defined for the AP20.2 AP20.5
Decimals bank account currency. AP20.6 AP20.7
AP20.8 AP23.1
AP55.1 AP81.1
CB500 CB951
EE20.1 EE20.2
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
CHK-REJECT-DATE Numeric 8 (yyyymmdd) CB500 CB85.1
Reject Date If the payment was created in AP160 and CB951
was rejected by the bank, this field
contains the date the tape payment
record was rejected by the bank.
CHK-SORT-OPTION1 Alpha 15 AP150 CB06.2
Sort Option 1 Sort option one used for sorting the CB951
payment in AP150.
CHK-SORT-OPTION2 Alpha 15 AP150 CB06.2
Sort Option 2 Sort option 2 used for sorting the CB951
payment in AP150.
CHK-SORT-OPTION3 Alpha 15 AP150 CB06.2
Sort Option 3 Sort option 3 used for sorting the CB951
payment in AP150.
CHK-INVOICE-GROUP Alpha 4 AP150 AP20.1
Invoice Group The invoice group assigned to the AP20.2 AP20.5
payment. AP20.6 AP20.7
AP20.8 AP23.1
CB951 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
CHK-PROC-GRP Alpha 4 (Lower Case) AP150
Process Group The process group assigned to the
payment, if assigned.
A process group is an identifier used
for separating vendors into different
groups to enable concurrent processing
within the cash payment cycle.
CHK-CHK-STATUS Derived
Payment Status Indicates the status of the payment.
CHK-SHORT-PAYEE Derived
Short Payee A sort name for the vendor.
CHK-RECON-STMT-NBR Numeric 12 AP55.1 CB951
Reconciliation The bank-assigned reconciliation
Statement statement number. Used only for cash
codes that require reconciliation
statements.
CBCHECK FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CHKSET1 CASH-CODE This index is used to access and update AP155 AP157
BANK-INST-CODEcash payment records. AP160 AP161
TRANS-IDENT AP170 AP190
AP20.6 AP20.8
AP213 AP284
AP57.2 CB300
CB951 EE20.1
EE20.2
CHKSET2 PAY-GROUP This index is used to inquire on AP160 AP90.5
CASH-CODE specific cash payment records by pay CB06.2 CB191
BANK-INST-CODEgroup, cash code, transaction code, and
TRANS-NBR payment number.
TRANS-IDENT KeyChange
CHKSET3 PAY-GROUP This index is used to access cash AP150 AP155
REC-STATUS payment records for an accounts payable AP157 AP160
CASH-CODE company's bank account. AP161 AP170
BANK-INST-CODEKeyChange AP190 AP195
TRANS-NBR AP255 AP265
TRANS-IDENT AP55.1 AP55.2
CHKSET4 CASH-CODE This index is used to access AP155 AP157
BANK-INST-CODEunreconciled cash payment records AP160 AP161
TRANS-NBR (processed cash payment records). Also AP190 AP20.1
used to inquire on cash payment records AP20.2 AP20.5
by cash code, transaction code, and AP20.6 AP20.7
payment number. AP20.8 AP23.1
KeyChange, Duplicates AP25.2 AP26.1
AP520 AP55.1
AP81.1 CB06.2
CB500 EE20.1
EE20.2 EE35.1
EE35.2 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
...
CHKSET5 CASH-CODE This index is by AP160 (Invoice Accrual AP160 AP161
BANK-INST-CODEReconciliation) to access a serial AP190 CB80.1
SERIAL-NUM number. CB85.1
TRANS-NBR KeyChange, Duplicates
CHKSET8 VENDOR-GROUP This index is used to display all cash AP305 AP91.1
PAID-VENDOR payment transactions for a vendor
COMPANY regardless of the issuing company.
CHECK-DATE* KeyChange, Duplicates
BANK-INST-CODE
TRANS-IDENT
CHKSET9 PAY-GROUP This index is used to select records to AP265
CASH-CODE print on the payment register.
CHECK-DATE KeyChange
BANK-INST-CODE
TRANS-NBR
TRANS-IDENT
CBCHECK FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
CHK-COMPANY -> CPY-COMPANY
Approclev APPROCLEV Required
When (CHK-REC-STATUS < 9 )
And (CHK-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
Glsystem GLSYSTEM Required
CHK-COMPANY -> GLS-COMPANY
CBCHECK FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
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
|