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 AP160 AP161 AP170 AP190
AP305 AP55.1 AP55.2 AP81.1 CB06.2 CB191
CB300 CB500 CB85.1 EE20.1 EE20.2 EE35.1
EE35.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CHK-CASH-CODE Alpha 4 AP150 AP155
Cash Code The cash code. Represents the bank AP55.1 AP81.1
account the payment was issued from. CB06.2 CB500
Must be a valid record in the Cash Code EE20.1 EE20.2
file.
CHK-BANK-INST-CODE Alpha 3 AP150 AP155
Payment Code The payment code. Represents the type AP55.1 AP81.1
of cash payment. Must be a valid cash CB06.2 CB500
payment type transaction code record in EE20.1 EE20.2
the Bank Transaction Code file.
CHK-TRANS-NBR Alpha 10 (Right Justified) AP150 AP155
Payment Number The payment number. Represents a unique AP160 AP161
value used to identify the cash payment AP55.1 AP81.1
transaction. CB06.2 CB500
EE20.1 EE20.2
CHK-TRANS-IDENT Numeric 10 AP150 AP155
Transaction ID An identification number assigned by AP55.1 AP81.1
the system upon creation. Used as a CB06.2 CB500
unique identifier by the system. EE20.1 EE20.2
EE35.1 EE35.2
CHK-COMPANY Numeric 4 AP150 AP155
Company The company number. Must be a valid AP55.1 AP81.1
record in the Accounts Payable Company CB06.2 CB500
file. EE20.1 EE20.2
EE35.1 EE35.2
CHK-PROC-LEVEL Alpha 5 AP150 AP55.1
Process Level The process level. Must be a valid AP81.1 CB06.2
record in the Process Level file. CB500 EE20.1
Updated only when AP150 (Cash EE20.2 EE35.1
Requirements) is run by process level. EE35.2
CHK-REC-STATUS Numeric 1 AP150 AP155
Record Status The payment record status. Valid values AP160 AP161
are: AP170 AP190
AP55.1 AP81.1
0 = Scheduled by AP150. CB06.2 CB500
CB85.1 EE20.1
1 = Processed by AP155 or AP160 or a EE20.2 EE35.1
manual payment entered in AP20 or AP55. EE35.2
2 = Closed by AP170.
3 = Tape Reject (not reinstated).
4 = Tape Reject (reinstated).
5 = Temporary Void.
9 = Reserved for Manual Payment.
CHK-VENDOR-GROUP Alpha 4 AP150 AP55.1
Vendor Group The vendor group associated with the AP81.1 CB06.2
pay vendor. Must be a valid record in CB500 EE20.1
the Vendor Group file. EE20.2 EE35.1
EE35.2
CHK-PAY-GROUP Alpha 4 AP150 AP155
Pay Group The pay group. Must be a valid record AP55.1 AP81.1
in the Pay Group file. CB500 EE20.1
EE20.2
CHK-PAID-VENDOR Alpha 9 (Right Justified) AP150 AP55.1
Pay Vendor The vendor the payment was issued to. AP81.1 CB06.2
Must be a valid record in the Vendor CB500 EE20.1
file. EE20.2 EE35.1
EE35.2
CHK-PAID-NAME Alpha 30 AP150 AP155
Pay Vendor Name The name of the vendor the payment was AP55.1 AP81.1
issued to. CB06.2 CB500
EE20.1 EE20.2
EE35.1 EE35.2
CHK-REMIT-TO-CODE Alpha 4 AP150 AP55.1
Remit To Location The remit-to location the payment was AP81.1 CB06.2
Code issued to, if applicable. Represents an CB500 EE20.1
alternate remittance location for the EE20.2 EE35.1
vendor. Must be a valid remit-to type EE35.2
location record in the Vendor Location
file.
CHK-BASE-PMT-AMT Signed 15.2 AP150 AP55.1
Base Payment Amount The amount of the payment in the AP81.1 CB06.2
company base currency. CB500 EE20.1
EE20.2 EE35.1
EE35.2
CHK-BASE-ND Numeric 1 AP150 AP55.1
Base Number Of The number of decimal places defined AP81.1 CB06.2
Decimals for the company base currency. CB500 EE20.1
EE20.2 EE35.2
CHK-TRAN-PMT-AMT Signed 15.2 AP150 AP55.1
Payment Amount The amount of the invoices to be AP81.1 CB06.2
applied to the payment in the currency CB500 EE20.1
of the invoices. EE20.2 EE35.1
EE35.2
CHK-TRAN-ND Numeric 1 AP150 AP55.1
Transaction Number The number of decimal places defined AP81.1 CB06.2
of Decimals for the invoice currency. CB500 EE20.1
EE20.2 EE35.2
CHK-TOT-INV-PAID Signed 15.2 AP150 AP55.1
Total of Invoices The total amount of invoices applied to AP55.2 AP81.1
Paid the payment in invoice currency. CB06.2 CB500
EE20.1 EE20.2
EE35.1 EE35.2
CHK-CHECK-DATE Numeric 8 (yyyymmdd) AP150 AP155
Payment Date The payment date assigned to the payment AP160 AP161
in AP20, AP55, AP155, AP157, AP160, or AP55.1 AP81.1
AP161. CB06.2 CB500
EE20.1 EE20.2
EE35.1 EE35.2
CHK-PAY-CURRENCY Alpha 5 AP150 AP55.1
Payment Currency The currency of the payment. AP81.1 CB06.2
CB500 EE20.1
EE20.2 EE35.1
EE35.2
CHK-ACT-CNV-RATE Signed 12.6 AP150 AP55.1
Trans to Base The currency exchange rate in effective AP81.1 CB06.2
Exchange Rate at the time of payment. Used to convert CB500 EE20.1
the payment amount from the invoice EE20.2 EE35.1
currency to the company base currency. EE35.2
CHK-SERIAL-NUM Numeric 8 AP160 AP161
Payment Run Serial A system-defined number assigned to an AP55.1 AP81.1
Number electronic payment tape created in AP160 CB06.2 CB500
(Payment Tape Creation) or an electronic EE20.1 EE20.2
payment file in AP161 (Electonic Payment
Creation). This serial number is
required to recreate a payment tape in
AP160 or a file AP161.
CHK-CHECK-TYPE Alpha 1 AP55.1 AP81.1
Payment Record Identifies where the cash payment record CB06.2 CB500
Origin originated. Valid values are: EE20.1 EE20.2
EE35.1 EE35.2
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.
CHK-RELEASE-FL Alpha 1 AP55.1 AP81.1
Released Indicates whether the payment has been CB06.2 CB191
released. Valid values are: CB500 EE20.1
EE20.2 EE35.1
N = No. EE35.2
Y = Yes.
CHK-BASE-APPL-AMT Signed 15.2 AP150 AP55.1
Base Applied Amount The total amount of invoices applied to AP55.2 AP81.1
the payment in the company base CB06.2 CB500
currency. EE20.1 EE20.2
EE35.1 EE35.2
CHK-BANK-CURR-AMT Signed 15.2 AP150 AP55.1
Bank Currency Amount The payment amount in the currency of AP81.1 CB06.2
the bank account. CB500 EE20.1
EE20.2 EE35.1
EE35.2
CHK-BNK-CNV-RATE Signed 12.6 AP150 AP55.1
Trans to Bank The currency exchange rate at the time AP81.1 CB500
Exchange Rate of payment. Used to convert the payment EE20.1 EE20.2
amount from the invoice currency to the
bank account currency.
CHK-BANK-APPL-AMT Signed 15.2 AP150 AP55.1
Bank Applied Amount The amount of invoices applied to the AP55.2 AP81.1
payment in the currency of the bank EE20.1 EE20.2
account.
CHK-BANK-ND Numeric 1 AP150 AP55.1
Bank Number of The number of decimals defined for the AP81.1 CB500
Decimals bank account currency.
CHK-REJECT-DATE Numeric 8 (yyyymmdd) CB500 CB85.1
Reject Date 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.
CHK-SORT-OPTION1 Alpha 15 AP150 CB06.2
Sort Option 1 Sort option one used for sorting the
payment in AP150.
CHK-SORT-OPTION2 Alpha 15 AP150 CB06.2
Sort Option 2 Sort option 2 used for sorting the
payment in AP150.
CHK-SORT-OPTION3 Alpha 15 AP150 CB06.2
Sort Option 3 Sort option 3 used for sorting the
payment in AP150.
CHK-INVOICE-GROUP Alpha 4 AP150
Invoice Group The invoice group assigned to the
payment.
CHK-PROC-GRP Alpha 4 (Lower Case) AP150
Process Group 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
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 AP160
BANK-INST-CODEcash payment records. AP161 AP170
TRANS-IDENT AP190 AP213
AP284 AP57.2
CB300 EE20.1
EE20.2
CHKSET2 PAY-GROUP This index is used to inquire on AP161 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 AP160 AP161
CASH-CODE company's bank account. AP170 AP190
BANK-INST-CODEKeyChange AP195 AP255
TRANS-NBR AP265 AP55.1
TRANS-IDENT AP55.2
CHKSET4 CASH-CODE This index is used to access AP155 AP160
BANK-INST-CODEunreconciled cash payment records AP161 AP190
TRANS-NBR (processed cash payment records). Also AP520 AP55.1
TRANS-IDENT used to inquire on cash payment records AP81.1 CB06.2
by cash code, transaction code, and CB500 EE20.1
payment number. EE20.2 EE35.1
KeyChange EE35.2
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
TRANS-IDENT
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
BANK-INST-CODE
CASH-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
CHK-TRANS-IDENT -> CBT-TRANS-IDENT
Glsystem GLSYSTEM Required
CHK-COMPANY -> GLS-COMPANY
CBCHECK FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME 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
|
