Login
Contents x
Payment Detail Report (APR032)
  • Print
  • Dark
    Light
  • PDF
Contents

Payment Detail Report (APR032)

  • Print
  • Dark
    Light
  • PDF
Article summary

Report Description

A report that lists warrant and electronic payment detail and status for payments. This report lists payments issued to suppliers or other external payees and includes payment information, with key voucher information. This report is intended for agency and enterprise users to monitor payment activities.

Report Location

Data Warehouse

Report Sample Layout

See the sample layout report below.

APR032_Payment_Detail_Report_Sample_File_Layout.xlsx

Report Navigation

Coming Soon!

Report Audience

  • Florida PALM Subject Matter Experts (SME’s)
  • Key enterprise partners

Suggested Report Frequency

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.Voucher Business Unit.Business Unit

Y

Y

*Payment Date (From: To: )

Y

Financials – AP Transactions.Payables Payment Voucher Details.Payment Date

Y

Y

Organization

N

Financials – AP Transactions.APVoucher Business Unit.Organization

N

Y

Project

N

Financials – AP Transactions.GL Account.Project

N

Y

Grant

N

Financials – AP Transactions.GL Account.Grant Id

N

Y

Contract

N

Financials – AP Transactions.GL Account.Contract Id

N

Y

Account

N

Financials – AP Transactions.GL Account.Account

N

Y

Fund

N

Financials – AP Transactions.GL Account.Fund

N

Y

Budget Entity

N

Financials – AP Transactions.GL Account.Budget Entity

N

Y

Category

N

Financials – AP Transactions.GL Account.Category

N

Y

PO ID

N

Financials – AP Transactions.Account Payables Identifiers.PO ID

N

Y

Voucher Origin

N

Financials – AP Transactions.Payables Payment Voucher Details.Voucher Origin

N

Y

Voucher Style

N

Financials – AP Transactions.Payables Payment Voucher Details.Voucher Style

N

Y

Emergency Voucher

N

Financials – AP Transactions.Payables Payment Voucher Details.Emergency Voucher

N

Y

Supplier ID

N

Financials – AP Transactions.Supplier.Supplier Number

N

Y

Payment Method

N

Financials – AP Transactions.Payables Payment Voucher Details.Payment Method

N

Y

Confidential

N

Financials – AP Transactions.Account Payables Identifiers.Confidential

N

Y

Payment Reference ID

N

Financials – AP Transactions.Account Payables Identifiers.Payment Reference ID

N

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.AP Voucher Business Unit.Business Unit

Organization

Financials – AP Transactions.APVoucher Business Unit.Organization

Voucher Origin

Financials – AP Transactions.Payables Payment Voucher Details.Voucher Origin

Voucher ID

Financials – AP Transactions.Account Payables Identifiers.Voucher ID

Invoice ID

Financials – AP Transactions.Account Payables Identifiers.Invoice ID

PO ID

Financials – AP Transactions.Account Payables Identifiers.PO ID

Receipt ID

Financials – AP Transactions.AP Account Payables Identifiers.Receipt ID

Emergency Voucher

Financials – AP Transactions.Payables Payment Voucher Details.Emergency Voucher

Supplier ID

Financials – AP Transactions.Supplier Account.Supplier Account Number

Name1

Financials – AP Transactions.Supplier Account.Supplier Name

Voucher Line Number

Financials – AP Transactions.Payables Payment Voucher Details.Voucher Line Number

Document Number

Financials – AP Transactions Payables Payment Voucher Details.Document Number

Distribution Line Number

Financials – AP Transactions. Payables Payment Voucher Details.Distribution Line Number

Account

Financials – AP Transactions.GL Account.Account

Fund

Financials – AP Transactions.GL Account.Fund

Budget Entity

Financials – AP Transactions.GL Account.Budget Entity

Category

Financials – AP Transactions.GL Account.Category

State Program

Financials – AP Transactions.GL Account.State Program

Grant ID

Financials – AP Transactions.GL Account.Grant Id

Contract ID

Financials – AP Transactions.GL Account.Contract Id

OA1

Financials – AP Transactions.GL Account.OA1

OA2

Financials – AP Transactions.GL Account.OA2

PC Business Unit

Financials – AP Transactions.GL Account.PC Business Unit

Project ID

Financials – AP Transactions.GL Account.Project

Activity

Financials – AP Transactions.GL Account.Activity

PC Source Type

Financials – AP Transactions.GL Account.PC Source Type

PC Category

Financials – AP Transactions.GL Account.PC Category

PC Subcategory

Financials – AP Transactions.GL Account.PC Subcategory

Budget Date

Financials – AP Transactions. Payables Payment Voucher Details.Budget Date

Payment Sequence Number

Financials – AP Transactions. Payables Payment Voucher Details.Payment Sequence Number

Payment Reference ID

Financials – AP Transactions.Account Payables Identifiers.Payment Reference ID

Payment Date

Financials – AP Transactions.Payables Payment Voucher Details.Payment Date

Payment Amount

Financials – AP Transactions.Fact - Fins – AP Transaction Custom.Payment Amount

Payment Method

Financials – AP Transactions.Payables Payment Voucher Details.Payment Method

Payment Handling Code

Financials – AP Transactions.Payables Payment Voucher Details.Payment Handling Code

Reconciliation Status

Financials – AP Transactions. Payment and Voucher Details.Reconciliation Status

Reconciliation Date

Financials – AP Transactions.Payables Payment Voucher Details.Payment Reconciliation Date

Final Payment Indicator

Financials – AP Transactions.Payables Payment Voucher Details.Final Payment Indicator

Confidential

Financials – AP Transactions.Account Payables Identifiers.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?
What's Next
The Florida PALM Knowledge Center serves as the central hub of information that helps agencies quickly and effectively adopt Florida PALM at Financials and Payroll Wave by providing quick access to the design of the system.
Change password!
Changing your password will log you out immediately. Use the new password to log back in.
Change profile
Success!
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.
Logout