Database view containing P-Card Invoice vendor name

Owned by Knowledge Assistant
Last updated: Jun 30, 2023
1 min read



Description of Issue

Client needs to retrieve vendor name for P-Cards containing 99999 as the vendor number in a custom report



Context

  • SSRS reports

  • Crystal reports

  • SaaS, Tyler-hosted clients

  • OnPrem, Self-hosted clients

  • Invoices

  • P-Cards



Cause

View database column does not show table information



Resolution

All vendor information for P-Card invoices with 9999 as the vendor number will be found in TRS view ap_otp_vendor_address



Additional Information