-
Print
-
DarkLight
-
PDF
Duplicate Suppliers Report (APR069)
-
Print
-
DarkLight
-
PDF
Report Description
A report that identifies potential duplicate Supplier records, or related suppliers.
This detail report identifies instances of duplicate supplier records which may occur due to separate instances of confidential suppliers in the statewide supplier file. This on-demand report is intended to support enterprise partners monitor and manage supplier records.
Report Location
Data Warehouse
Report Sample Layout
See the sample layout report below.
Report Navigation
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:
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.AP Voucher Business Unit.Supplier Business Unit | N | Y |
Supplier Status | Y | Financials – AP Transactions.Supplier Account.Supplier Account Supplier Status | N | Y |
Confidential | N | Financials – AP Transactions.Accounts Payables Identifiers.Confidential | 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.Supplier Business Unit |
Supplier ID | Financials – AP Transactions.Supplier Account.Supplier Account Number |
Additional ID Type | Financials – AP Transactions.Supplier Account.Supplier Account Additional ID Type |
Additional ID Number | Financials – AP Transactions.Supplier Account.Supplier Account Additional ID Number |
Supplier Status | Financials – AP Transactions.Supplier Account.Supplier Account Supplier Status |
Confidential | Financials – AP Transactions.Accounts Payables Identifiers.Confidential |
Supplier Classification | Financials – AP Transactions.Supplier Account.Supplier Account Supplier Classification |
Supplier Last Modified Date | Financials – AP Transactions.Supplier Account.Supplier Account Last Modified Date |
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 |