Database views containing one time vendor names and their invoices

Client needs a database view containing one time vendor names for building a custom report.

• All versions of Munis

• SSRS reports

• Crystal reports

• SaaS, Tyler-hosted clients

• OnPrem, Self-hosted clients

• Accounts Payable

Pcard transaction vendor names do not appear in ap_vendors. We need to fetch them from another view.

The following sample query will fetch all invoices along with vendor data:

select *

from ap_invoice

left join ap_pcard_trans

on a_document_number = a_invoice_number

join ap_vendor

on ap_invoice.a_vendor_number = ap_vendor.a_vendor_number