Supplier Payments Report (APR006)
-
Print
-
DarkLight
-
PDF
Supplier Payments Report (APR006)
-
Print
-
DarkLight
-
PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Report Description
A report that summarizes payments, including P-card Merchant transactions by supplier/merchant and other key data elements including minority business codes. This summary report provides total payments by unique supplier (including related transactions identified by the Merchant field), is intended to support agency users and enterprise users to monitor total supplier spend, includes Government Certifications/Classifications to support analysis of total spend for compliance reporting required by law, and supports monitoring for Single Audit Reporting requirements.
Report Location
Data Warehouse
Report Sample Layout
See the sample layout report below.
Report Navigation
Coming Soon!
Report Audience
- AP Reporter
- Confidential AP Reporter
Suggested Report Frequency
- Quarterly
- Monthly
- Ad Hoc
Business Process Models
This report can be found in the following business processes:
Report Prompts
The report data can be filtered by the following report prompts:
Parameter Name | Default Value | Column in Subject Area | Required (Y/N) | User Input |
|---|---|---|---|---|
Business Unit | N | Financials – AP Transactions.Payables Payment Business Unit.Payables Payment Business Unit Name | Y | Y |
Payment Date (From: To:) | N | Financials – AP Transactions.Invoice Cleared Date.Payment Date | Y | Y |
Supplier ID | N | Financials – AP Transactions.Supplier Account.Supplier Account Number | Y | Y |
Confidential | N | Financials – AP Transactions.Payment and Voucher Details.Confidential | Y | Y |
Report Columns
The layout of the report is listed below.
Column Name | Column in Subject Area or TableName.ColumnName |
|---|---|
Business Unit | Financials – AP Transactions.Payables Payment Business Unit.Payables Payment Business Unit Name |
Supplier ID | Financials – AP Transactions.Supplier Account.Supplier Account Number |
Supplier Name | Financials – AP Transactions.Supplier.Supplier Name |
Merchant | Financials – AP Transactions.Payment and Voucher Details.Merchant |
Additional ID Number | Financials – AP Transactions.Supplier Account.Supplier Account Additional ID Number |
Governmental Certification | Financials – AP Transactions.Supplier Account.Supplier Account Governental Certification |
Payment Reference ID | Financials – AP Transactions.Payment and Voucher Details.Payment Reference ID |
Alternate Payee Name | "Payables Payment Voucher Details"."Name 1" |
Payment Date | Financials – AP Transactions.Invoice Cleared Date.Payment Date |
Payment Amount | Financials – AP Transactions.Facts - AP Transactions.AP Amount |
Confidential | Financials – AP Transactions.Payment and Voucher Details.Confidential |
Data
More information about the data fields, including business definition and key values, is included as part of the Interface Catalog and applicable interface file layouts.
More information about the data values is included here: Configured Data Values.
More information about the ChartFields and related values is included in the Chart of Accounts Design.
Version History
Date | Revision Description |
|---|---|
01/31/2025 | Original Version |
Was this article helpful?
