Supplier Authorized Banks Exception and Updates Report (APR112)
-
Print
-
DarkLight
-
PDF
Supplier Authorized Banks Exception and Updates Report (APR112)
-
Print
-
DarkLight
-
PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Report Description
Supplier Authorized Banks Exceptions and Updates Report is a query that lists the exceptions/updates that occurred from the validation done when the Inbound Authorized Bank Titles interface (API030) is run. The file validates the Depository Financial Institution (DFI)/Routing numbers of supplier banks in Florida PALM with supplier bank information from the Authorized Bank Titles File interface. This report is used to determine what corrections were made to the supplier banking information.
Report Navigation: Main Menu>Reporting Tools>Query>Query Viewer
Query Name: FLP_APR112_Supplier_Authorized_Bank_Exception_and_Updates
See the sample layout report below.
Business Roles
The following business roles have access to this report:
- DFS AP Supplier Processor
- DFS AP Supplier Approver
Business Process Models
This report can be found in the following business sub-processes:
Selection Criteria
The report data can be filtered by the following selection criteria:
Data Field | Data Field Details |
Bank ID | Optional |
Bank Name | Optional |
Supplier SetID | Optional |
Supplier ID | Optional |
Supplier Status | Optional |
Report Layout
The layout of the report is listed below.
Data Field | Florida PALM RECORD.FIELD mapping |
Report Type | “Updates” – String value |
Supplier SetID | PS_FLP_API030_HIST.SETID |
Supplier ID | PS_FLP_API030_HIST.VENDOR_ID |
Supplier Name | PS_VENDOR.NAME1 |
Supplier Status* | PS_VENDOR.VENDOR_STATUS |
Supplier Location | PS_FLP_API030_HIST .VNDR_LOC |
Supplier Location Status* | PS_VENDOR_LOC.EFF_STATUS |
Supplier Bank ID | PS_VNDR_BANK_ACCT. BNK_ID_NBR |
Supplier Bank Name | PS_VNDR_BANK_ACCT. BENEFICIARY_BANK |
Supplier Routing Number | PS_VNDR_BANK_ACCT.DFI_ID_NUM |
Bank Title New Routing Number | PS_FLP_API030_HIST. FLP_NEW_ROUTE_NBR |
Bank Title Old Routing Number | PS_FLP_API030_HIST. FLP_ROUTING_NBR |
File Processed date | PS_FLP_API030_HIST. DATETIMESTAMP |
Bank Change Date | PS_FLP_API030_HIST. FLP_CHANGE_DT |
Bank Change Date | PS_FLP_API030_HIST. FLP_CHANGE_DT |
Report Type | “Exceptions” – String Value |
Supplier SetID | PS_VENDOR.SETID |
Supplier ID | PS_VENDOR.VENDOR_ID |
Supplier Name | PS_VENDOR.NAME1 |
Supplier Status* | PS_VENDOR.VENDOR_STATUS |
Supplier Location | PS_VENDOR_LOC.VNDR_LOC |
Supplier Location Status* | PS_VENDOR_LOC.EFF_STATUS |
Supplier Bank ID | PS_VNDR_BANK_ACCT. BNK_ID_NBR |
Supplier Bank Name | PS_VNDR_BANK_ACCT. BENEFICIARY_BANK |
Supplier Routing Number | PS_VNDR_BANK_ACCT.DFI_ID_NUM |
Bank Title New Routing Number | PS_FLP_API030_HIST. FLP_NEW_ROUTE_NBR |
Bank Title Old Routing Number | PS_FLP_API030_HIST. FLP_ROUTING_NBR |
File Processed date | PS_FLP_API030_HIST. DATETIMESTAMP |
Bank Change Date | PS_FLP_API030_HIST. FLP_CHANGE_DT |
*For Supplier and Location Status, PSXLATITEM.XLATLONGNAME should be displayed
Version History
Date | Revision Description |
12/01/2023 | Original Version |
Was this article helpful?
