|
|
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 CB20.1 CB80.1 AP91.1
UPDATED BY
AP150 AP155 AP160 AP161 AP170 AP190
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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CHK-CASH-CODE Alpha 4 AP150 AP155
Element: Cash Code The cash code. Represents the bank AP25.2 AP26.1
account the payment was issued from. AP27.1 AP55.1
Must be a valid record in the Cash Code AP81.1 CB06.2
file. CB500 EE20.1
EE20.2
CHK-BANK-INST-CODE Alpha 3 AP150 AP155
Element: Payment Code The payment code. Represents the type AP25.2 AP26.1
of cash payment. Must be a valid cash AP27.1 AP55.1
payment type transaction code record in AP81.1 CB06.2
the Bank Transaction Code file. CB500 EE20.1
EE20.2
CHK-TRANS-NBR Alpha 10 (Right Justified) AP150 AP155
Element: Payment NumberThe 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
Element: Transaction IDAn 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
Element: Company The company number. Must be a valid AP25.2 AP26.1
record in the Accounts Payable Company AP27.1 AP55.1
file. AP81.1 CB06.2
CB500 EE20.1
EE20.2 EE35.1
EE35.2
CHK-PROC-LEVEL Alpha 5 AP150 AP25.2
Element: Process Level The process level. Must be a valid AP26.1 AP27.1
record in the Process Level file. AP55.1 AP81.1
Updated only when AP150 (Cash CB06.2 CB500
Requirements) is run by process level. EE20.1 EE20.2
EE35.1 EE35.2
CHK-REC-STATUS Numeric 1 AP150 AP155
Element: Reconcile StatThe payment record status. Valid values AP160 AP161
are: AP170 AP190
AP25.2 AP26.1
0 = Scheduled by AP150. AP27.1 AP55.1
AP81.1 CB06.2
1 = Processed by AP155 or AP160 or a CB500 CB85.1
manual payment entered in AP20 or AP55. EE20.1 EE20.2
EE35.1 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 AP25.2
Element: Vendor Group The vendor group associated with the AP26.1 AP27.1
pay vendor. Must be a valid record in AP55.1 AP81.1
the Vendor Group file. CB06.2 CB500
EE20.1 EE20.2
EE35.1 EE35.2
CHK-PAY-GROUP Alpha 4 AP150 AP155
Element: 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 AP25.2
Element: Pay Vendor The vendor the payment was issued to. AP26.1 AP27.1
Must be a valid record in the Vendor AP55.1 AP81.1
file. CB06.2 CB500
EE20.1 EE20.2
EE35.1 EE35.2
CHK-PAID-NAME Alpha 30 AP150 AP155
Element: Pay Vendor NamThe name of the vendor the payment was AP25.2 AP26.1
issued to. AP27.1 AP55.1
AP81.1 CB06.2
CB500 EE20.1
EE20.2 EE35.1
EE35.2
CHK-REMIT-TO-CODE Alpha 4 AP150 AP25.2
Element: Remit To Code The remit-to location the payment was AP26.1 AP27.1
issued to, if applicable. Represents an AP55.1 AP81.1
alternate remittance location for the CB06.2 CB500
vendor. Must be a valid remit-to type EE20.1 EE20.2
location record in the Vendor Location EE35.1 EE35.2
file.
CHK-BASE-PMT-AMT Signed 18.2 AP150 AP25.2
Element: Base Payment AThe amount of the payment in the AP26.1 AP27.1
company base currency. AP55.1 AP81.1
CB06.2 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 18.2 AP150 AP25.2
Transaction Payment The amount of the invoices to be AP26.1 AP27.1
Amount applied to the payment in the currency AP55.1 AP81.1
of the invoices. CB06.2 CB500
EE20.1 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 18.2 AP150 AP25.2
Element: Total Invoice The total amount of invoices applied to AP26.1 AP27.1
the payment in invoice currency. AP55.1 AP55.2
AP81.1 CB06.2
CB500 EE20.1
EE20.2 EE35.1
EE35.2
CHK-CHECK-DATE Numeric 8 (yyyymmdd) AP150 AP155
Element: Check Date The payment date assigned to the payment AP160 AP161
in AP20, AP55, AP155, AP157, AP160, or AP25.2 AP26.1
AP161. AP27.1 AP55.1
AP81.1 CB06.2
CB500 EE20.1
EE20.2 EE35.1
EE35.2
CHK-PAY-CURRENCY Alpha 5 AP150 AP25.2
Element: Payment CurrenThe currency of the payment. AP26.1 AP27.1
AP55.1 AP81.1
CB06.2 CB500
EE20.1 EE20.2
EE35.1 EE35.2
CHK-ACT-CNV-RATE Signed 14.7 AP150 AP25.2
Trans to Base The currency exchange rate in effective AP26.1 AP27.1
Exchange Rate at the time of payment. Used to convert AP55.1 AP81.1
the payment amount from the invoice CB06.2 CB500
currency to the company base currency. EE20.1 EE20.2
EE35.1 EE35.2
CHK-SERIAL-NUM Numeric 8 AP160 AP161
Element: Serial Number A system-defined number assigned to an AP55.1 AP81.1
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 AP25.2 AP26.1
Payment Record Identifies where the cash payment record AP27.1 AP55.1
Origin originated. Valid values are: AP81.1 CB06.2
CB500 EE20.1
Blank. A system generated payment EE20.2 EE35.1
created in AP150, AP157, AP160, or EE35.2
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
CHK-RELEASE-FL Alpha 1 AP25.2 AP26.1
Element: Release Flag Indicates whether the payment has been AP27.1 AP55.1
released. Valid values are: AP81.1 CB06.2
CB191 CB500
N = No. EE20.1 EE20.2
Y = Yes. EE35.1 EE35.2
CHK-BASE-APPL-AMT Signed 18.2 AP150 AP25.2
Base Application The total amount of invoices applied to AP26.1 AP27.1
Amount the payment in the company base AP55.1 AP55.2
currency. AP81.1 CB06.2
CB500 EE20.1
EE20.2 EE35.1
EE35.2
CHK-BANK-CURR-AMT Signed 18.2 AP150 AP55.1
Element: Bank Currency 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 14.7 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 18.2 AP150 AP55.1
Element: Bank Applied AThe 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. EE20.1 EE20.2
CHK-REJECT-DATE Numeric 8 (yyyymmdd) CB500 CB85.1
Element: 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
Element: Sort Option 1 Sort option one used for sorting the
payment in AP150.
CHK-SORT-OPTION2 Alpha 15 AP150 CB06.2
Element: Sort Option 2 Sort option 2 used for sorting the
payment in AP150.
CHK-SORT-OPTION3 Alpha 15 AP150 CB06.2
Element: Sort Option 3 Sort option 3 used for sorting the
payment in AP150.
CHK-INVOICE-GROUP Alpha 4 AP150
Element: Invoice Group The invoice group assigned to the
payment.
CHK-PROC-GRP Alpha 4 (Lower Case) AP150
Element: 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
Element: Check Status Indicates the status of the payment.
CHK-SHORT-PAYEE Derived
Element: Short Payee A sort name for the vendor.
CHK-RECON-STMT-NBR Numeric 12 AP55.1
Reconcile Statement The bank-assigned reconciliation
Number 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
CHKSET10 PAY-GROUP KeyChange AP155 AP160
REC-STATUS AP161
CASH-CODE
BANK-INST-CODE
PROC-GRP
TRANS-NBR
TRANS-IDENT
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 AP25.2 AP26.1
TRANS-IDENT used to inquire on cash payment records AP27.1 AP520
by cash code, transaction code, and AP55.1 AP81.1
payment number. CB06.2 CB20.1
KeyChange CB500 EE20.1
EE20.2 EE35.1
EE35.2
CHKSET5 CASH-CODE This index is by AP160 (Invoice Accrual AP160 AP161
BANK-INST-CODEReconciliation) to access a serial AP190 CB300
SERIAL-NUM number. CB80.1 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 (-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 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
|
