Scheduled Payments Report (APR007)
- 29 May 2024
- 1 Minute to read
-
Print
-
DarkLight
-
PDF
Scheduled Payments Report (APR007)
- Updated on 29 May 2024
- 1 Minute to read
-
Print
-
DarkLight
-
PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Report Description
The Scheduled Payments Report is used by agencies to plan and ensure funds are available for successfully completing the Cash Checking process. This report lists all approved and Budget Checked Vouchers not paid.
Report Navigation: Main Menu > Florida PALM> Reports > AP > Scheduled Payments Report
Query Name: APR007_Scheduled_Payments_Report
See the sample layout report below.
Business Roles
The following business roles have access to this report:
Business Process Models
This report can be found in the following business processes:
Selection Criteria
The report data can be filtered by the following selection criteria:
Data Field | Data Field Details |
|---|---|
Business Unit | Optional |
Scheduled Due Date From | Optional |
Scheduled Due Date To | Optional |
Supplier ID | Optional |
Supplier Name | Optional |
Fund | Optional |
Report Layout
The layout of the report is listed below.
Data Field | Florida PALM RECORD.FIELD mapping |
|---|---|
Business Unit | PS_VOUCHER.BUSINESS_UNIT |
Voucher ID | PS_VOUCHER.VOUCHER_ID |
Invoice ID | PS_VOUCHER.INVOICE_ID |
Invoice Date | PS_VOUCHER.INVOICE_DT |
Accounting Date | PS_VOUCHER.ACCOUNTING_DT |
Supplier ID | PS_VOUCHER.VENDOR_ID |
Supplier Name | PS_VENDOR.NAME1 |
Additional Supplier Name | PS_VENDOR.NAME2 |
Scheduled Due Date | PS_PYMNT_VCHR_XREF.SCHEDULED_PAY_DT |
Prompt Payment Due Date | PS_VOUCHER.BASIS_DATE + 35 or + 40 depending on the Fund Attribute Prompt Pay |
Voucher Line | PS_VOUCHER_LINE.VOUCHER_LINE_NUM |
Distribution Line | PS_DISTRIB_LINE.DISTRIB_LINE_NUM |
Fund Code | PS_DISTRIB_LINE.FUND_CODE |
Budget Entity | PS_ BUD_REF_TBL.BUDGET_REF |
Category | PS_DISTRIB_LINE.PRODUCT |
Distribution Amount | PS_DISTRIB_LINE.MERCHANDISE_AMT |
Hold Payment | PS_PYMNT_VCHR_XREF.PYMNT_HOLD |
Payment Method | PS_PYMNT_VCHR_XREF.PYMNT_METHOD |
Version History
Date | Revision Description |
|---|---|
12/01/2023 | Original Version |
Was this article helpful?
