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
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. |
|
||||||||||||||||||||||||||||||
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. |
|
||||||||||||||||||||||||||||||
CHK-TRANS-NBR Element: Payment Number | Alpha 10 (Right Justified) The payment number. Represents a unique value used to identify the cash payment transaction. |
|
||||||||||||||||||||||||||||||
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. |
|
||||||||||||||||||||||||||||||
CHK-TRANS-ID-CBT Element: Trans Id Cbt | Numeric 10 |
|
||||||||||||||||||||||||||||||
CHK-COMPANY Element: Company | Numeric 4 The company number. Must be a valid record in the Accounts Payable Company file. |
|||||||||||||||||||||||||||||||
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. |
|||||||||||||||||||||||||||||||
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. |
|||||||||||||||||||||||||||||||
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. |
|||||||||||||||||||||||||||||||
CHK-PAY-GROUP Element: Pay Group | Alpha 4 The pay group. Must be a valid record in the Pay Group file. |
|
||||||||||||||||||||||||||||||
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. |
|||||||||||||||||||||||||||||||
CHK-PAID-NAME Element: Pay Vendor Name | Alpha 30 The name of the vendor the payment was issued to. |
|||||||||||||||||||||||||||||||
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. |
|||||||||||||||||||||||||||||||
CHK-BASE-PMT-AMT Element: Base Payment Amount | Signed 18.2 The amount of the payment in the company base currency. |
|||||||||||||||||||||||||||||||
CHK-BASE-ND Base Number of Decimals | Numeric 1 The number of decimal places defined for the company base currency. |
|
||||||||||||||||||||||||||||||
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. |
|||||||||||||||||||||||||||||||
CHK-TRAN-ND Transaction Number of Decimals | Numeric 1 The number of decimal places defined for the invoice currency. |
|
||||||||||||||||||||||||||||||
CHK-TOT-INV-PAID Element: Total Invoice Paid | Signed 18.2 The total amount of invoices applied to the payment in invoice currency. |
|||||||||||||||||||||||||||||||
CHK-CHECK-DATE Element: Check Date | Numeric 8 (yyyymmdd) The payment date assigned to the payment in AP20, AP55, AP155, AP157, AP160, or AP161. |
|||||||||||||||||||||||||||||||
CHK-PAY-CURRENCY Element: Payment Currency | Alpha 5 The currency of the payment. |
|||||||||||||||||||||||||||||||
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. |
|||||||||||||||||||||||||||||||
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. |
|
||||||||||||||||||||||||||||||
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 |
|||||||||||||||||||||||||||||||
CHK-RELEASE-FL Element: Release Flag | Alpha 1 Indicates whether the payment has been released. Valid values are: N = No. Y = Yes. |
|||||||||||||||||||||||||||||||
CHK-BASE-APPL-AMT Base Application Amount | Signed 18.2 The total amount of invoices applied to the payment in the company base currency. |
|||||||||||||||||||||||||||||||
CHK-BANK-CURR-AMT Element: Bank Currency Amount | Signed 18.2 The payment amount in the currency of the bank account. |
|
||||||||||||||||||||||||||||||
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. |
|
||||||||||||||||||||||||||||||
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. |
|
||||||||||||||||||||||||||||||
CHK-BANK-ND Bank Number of Decimals | Numeric 1 The number of decimals defined for the bank account currency. |
|
||||||||||||||||||||||||||||||
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. |
|
||||||||||||||||||||||||||||||
CHK-SORT-OPTION1 Element: Sort Option 1 | Alpha 15 Sort option one used for sorting the payment in AP150. |
|
||||||||||||||||||||||||||||||
CHK-SORT-OPTION2 Element: Sort Option 2 | Alpha 15 Sort option 2 used for sorting the payment in AP150. |
|
||||||||||||||||||||||||||||||
CHK-SORT-OPTION3 Element: Sort Option 3 | Alpha 15 Sort option 3 used for sorting the payment in AP150. |
|
||||||||||||||||||||||||||||||
CHK-INVOICE-GROUP Element: Invoice Group | Alpha 4 The invoice group assigned to the payment. |
|
||||||||||||||||||||||||||||||
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. |
|
||||||||||||||||||||||||||||||
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. |
|
||||||||||||||||||||||||||||||
CHK-TEMP-HOLD Element: Temp Hold | Alpha 1 S = Sent for Approval A = Approved by Engine |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CHKSET1 |
CASH-CODE BANK-INST-CODE TRANS-IDENT |
|
| ||||||||||||||||||||||||||||||||||||
CHKSET10 |
PAY-GROUP REC-STATUS CASH-CODE BANK-INST-CODE PROC-GRP TRANS-NBR TRANS-IDENT |
|
| ||||||||||||||||||||||||||||||||||||
CHKSET2 |
PAY-GROUP CASH-CODE BANK-INST-CODE TRANS-NBR TRANS-IDENT |
|
| ||||||||||||||||||||||||||||||||||||
CHKSET3 |
PAY-GROUP REC-STATUS CASH-CODE BANK-INST-CODE TRANS-NBR TRANS-IDENT |
|
| ||||||||||||||||||||||||||||||||||||
CHKSET4 |
CASH-CODE BANK-INST-CODE TRANS-NBR TRANS-IDENT |
|
|||||||||||||||||||||||||||||||||||||
CHKSET5 |
CASH-CODE BANK-INST-CODE SERIAL-NUM TRANS-NBR TRANS-IDENT |
|
| ||||||||||||||||||||||||||||||||||||
CHKSET7 |
CASH-CODE BANK-INST-CODE TRANS-IDENT TRANS-ID-CBT |
|
|||||||||||||||||||||||||||||||||||||
CHKSET8 |
VENDOR-GROUP PAID-VENDOR COMPANY CHECK-DATE* BANK-INST-CODE CASH-CODE TRANS-IDENT |
|
|||||||||||||||||||||||||||||||||||||
CHKSET9 |
PAY-GROUP CASH-CODE CHECK-DATE BANK-INST-CODE TRANS-NBR TRANS-IDENT |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Apcompany | APCOMPANY |
Required
| ||||||||||||||||||
Approclev | APPROCLEV |
Required
| ||||||||||||||||||
Apvenmast | APVENMAST |
Required
| ||||||||||||||||||
Cbcashcode | CBCASHCODE |
Required
| ||||||||||||||||||
Cbcpycash | CBCPYCASH |
Required
| ||||||||||||||||||
Cbtrans | CBTRANS |
Not Required
| ||||||||||||||||||
Cbtrans Tape | CBTRANS |
Not Required
| ||||||||||||||||||
Glsystem | GLSYSTEM |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Apapphist | APAPPHIST |
| ||||||||||||||||||||||||||||||
Appayment | APPAYMENT |
| ||||||||||||||||||||||||||||||
Cbdistrib | CBDISTRIB |
| ||||||||||||||||||||||||||||||
Cbpayment | CBPAYMENT |
|
All trademarks and registered trademarks are the property of their
respective owners.