Database view containing one time vendor address

Need database view containing one time vendor address

• EERP all versions

• SSRS reports

• Crystal reports

• SaaS clients

• OnPrem clients

• One time vendor

• Accounts Payable

Need to retrieve address of one time vendor for building custom reports

One time vendor address is available through TRS view ap_otp_vendor_address in the following columns:

• ir_address1

• ir_address2

• ir_city

• ir_state

• ir_zip

• ir_country

Refer to the sample query below to retrieve all One-time vendors and their addresses.

^{SELECT V.a_vendor_number, V.a_invoice_number, V.ir_name, V.ir_address1, V.ir_address2, V.ir_city, V.ir_state, V.ir_zip, V.ir_country FROM ap_checks as C LEFT OUTER JOIN ap_otp_vendor_address AS V ON C.a_vendor_number = V.a_vendor_number AND C.a_invoice_number = V.a_invoice_number WHERE C.vn_vend_status = 'O'}