Funds Transferred to Unclaimed Property and Funds Exempt from Transfer to Unclaimed Property Report (APR140)
-
Print
-
DarkLight
-
PDF
Funds Transferred to Unclaimed Property and Funds Exempt from Transfer to Unclaimed Property Report (APR140)
-
Print
-
DarkLight
-
PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Report Description
A report that lists payment information for funds transferred to the Unclaimed Property Trust Fund or those that are exempt from Transfer to Unclaimed Property, pursuant to Sections 17.26 and 717.117, Florida Statutes, and payment information for funds returned to the original source.
Agency Report primarily intended to support users monitor on the disposition of warrants cancelled due to not being presented for payment within one year after the last day of the month in which it was originally issued. This report contains only Accounts Payable data and is intended to support agency monitoring and resolution of grant-related exempt payments. 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)
- Key enterprise partners
Suggested Report Frequency
- 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 |
|---|---|---|---|---|
Cancel Date (From: To:) | N | CAST("Payables Payment Voucher Details"."Cancel Date" AS DATE) | Y | Y |
Business Unit | N | "AP Voucher Business Unit"."AP Business Unit (Voucher)" | N | Y |
Organization | N | "AP Voucher Business Unit"."Organization" | N | Y |
Stale Date Status | N | "Payables Payment Voucher Details"."Stale Date Status" | N | Y |
Report Columns
The layout of the report is listed below.
Column Name | Column in Subject Area or TableName.ColumnName |
|---|---|
Business Unit | "AP Voucher Business Unit"."AP Business Unit (Voucher)" |
Organization | "AP Voucher Business Unit"."Organization" |
Voucher ID | "Account Payables Identifiers"."Voucher ID" |
Supplier ID | "Supplier"."Supplier Number" |
Remit Supplier Name | "Payables Payment Voucher Details"."Name 1" |
Voucher Line | "Payables Payment Voucher Details"."Voucher Line Number" |
Voucher Distribution Line | "Payables Payment Voucher Details"."Distribution Line Number" |
Distribution Line Merchandise Amount | "Fact - Fins - AP Transaction Custom"."Distribution Merchandise Amount" |
Account | "GL Account"."Account" |
Budget Entity | "GL Account"."Budget Entity" |
Fund | "GL Account"."Fund" |
Category | "GL Account"."Category" |
Grant | "GL Account"."Grant Id" |
Project | "GL Account"."Project" |
Budget Date | "Payables Payment Voucher Details"."Budget Date" |
Payment Reference Number | "Account Payables Identifiers"."Payment Reference ID" |
Payment Date | "Payables Payment Voucher Details"."Payment Date" |
Cancel Date | "Payables Payment Voucher Details"."Cancel Date" |
Stale Date Status | "Payables Payment Voucher Details"."Stale Date Status" |
Confidential | CASE WHEN "Payment and Voucher Details"."Confidential" = 'Y' THEN 'Yes' WHEN "Payment and Voucher Details"."Confidential" = 'N' THEN 'No' END |
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 ChartField 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?
