Contract Expenditures Report (APR051)
-
Print
-
DarkLight
-
PDF
Contract Expenditures Report (APR051)
-
Print
-
DarkLight
-
PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Report Description
A report of contract payment information by Vendor Name, contract ID number, Payment Number, Posted Invoice #, Date Posted Invoice posted, Payment Amount, document number unique to document payment, Voucher information, voucher status or available fields with the ability to export data into an excel format.
This detail report will provide transaction and accounting information for payments made to Supplier that are associated with a contract. This on-demand report is primarily intended to support agency users, and monitor contract payment activities. This report may also be used by enterprise users.
Report Location
Data Warehouse
Report Sample Layout
See the sample layout report below.
Report Navigation
Coming Soon!
Report Audience
This document should be read and reviewed by:
- Florida PALM Subject Matter Experts (SME’s)
- Reporting Team
- Key enterprise partners
Suggested Report Frequency
- Ad Hoc
Business Process Models
This report can be found in the following business processes:
- 30.3 Enter and Process Vouchers
- 30.3.1 Process Vouchers
- 30.4 Process Payments
- 30.4.1 Process Pay Cycle
- 90.3 Create and Maintain Contracts
- 90.3.2 Monitor and Close Out Contract
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 | WC_AP_TRANS_D.BUSINESS_UNIT | Y | Y |
From: Voucher Entered Date | N | WC_AP_TRANS_D.ENTERED_DT | Y | Y |
To: Voucher Entered Date | N | WC_AP_TRANS_D.ENTERED_DT Y | Y | Y |
Organization | N | WC_AP_TRANS_D.DEPTID | N | Y |
Category | N | W_GL_ACCOUNT_D.ACCOUNT_SEG6_CODE | N | Y |
Contract ID | N | W_GL_ACCOUNT_D.ACCOUNT_SEG11_CODE | N | Y |
Report Columns
The layout of the report is listed below.
Column Name | Column in Subject Area or TableName.ColumnName |
|---|---|
Business Unit | WC_AP_TRANS_D.BUSINESS_UNIT |
Contract ID | W_GL_ACCOUNT_D.ACCOUNT_SEG11_CODE |
Organization | WC_AP_TRANS_D.DEPTID |
Voucher Origin | WC_AP_TRANS_D.ORIGIN |
Voucher ID | WC_AP_TRANS_D.VOUCHER_ID |
Invoice ID | WC_AP_TRANS_D.INVOICE_ID |
Voucher Entered Date | WC_AP_TRANS_D.ENTERED_DT |
Supplier ID | W_SUPPLIER_ACCOUT_D.SPLR_ACCT_NUM |
Supplier Name | W_SUPPLIER_ACCOUNT_D.SPLR_ACCT_NAME |
Remit Supplier Name | WC_AP_TRANS_D.NAME1 |
Voucher Line Number | WC_AP_TRANS_D.VOUCHER_LINE_NUM |
Document Number | WC_AP_TRANS_D.PACKSLIP_NO |
Voucher Distribution Line Number | WC_AP_TRANS_D.DISTRIB_LINE_NUM |
Distribution Line Merchandise Amount | WC_AP_TRANS_F.MERCHANDISE_AMT |
Account | W_GL_ACCOUNT_D.NATURAL_ACCOUNT_NUM |
Fund | W_GL_ACCOUNT_D.BALANCING_SEGMENT_NUM |
Budget Entity | W_GL_ACCOUNT_D.ACCOUNT_SEG5_CODE |
Category | W_GL_ACCOUNT_D.ACCOUNT_SEG6_CODE |
Budget Date | WC_AP_TRANS_D.BUDGET_DT |
Payment Reference ID | WC_AP_TRANS_D.PYMNT_ID_REF |
Payment Date | WC_AP_TRANS_D.PYMNT_DT |
PO ID | WC_AP_TRANS_D.PO_ID |
Commodity Code | W_PRODUCT_D.X_CATEGORY_ID |
Confidential | WC_FLP_VDR_CNF_TBL_D.FLP_CNF_FLAG |
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 ChartFieldand related values is included in the Chart of Accounts Design.
Version History
Date | Revision Description |
|---|---|
01/31/2025 | Original Version |
Was this article helpful?
