SCR_VND_AUDIT_V (SQL View)	Index Back
SCR Vendor Audit Template This table joins the vendor table to the Vendor Contact table to determine if Auditing is turned on and select the correct template

SCR_VND_AUDIT_V

(SQL View)

SCR Vendor Audit Template

This table joins the vendor table to the Vendor Contact table to determine if Auditing is turned on and select the correct template

SELECT a.setid , a.vendor_id , a.suppaudit_flg , a.vndr_audit_flg , a.template_id FROM ps_vendor a WHERE a.template_id <> ' ' UNION SELECT a.setid , a.vendor_id , a.suppaudit_flg , b.vndr_audit_flg , b.template_id FROM ps_vendor a , PS_VENDOR_CONTROL b WHERE a.setid = b.setid AND a.template_id = ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

3 SUPPAUDIT_FLG Character(1) VARCHAR2(1) NOT NULL Used to mention 'Default' or 'Specify' on the Vendor Page
D=Default
S=Specify

4 VNDR_AUDIT_FLG Character(1) VARCHAR2(1) NOT NULL Supplier Audit
Y/N Table Edit

5 TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Project Template

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
3	SUPPAUDIT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Used to mention 'Default' or 'Specify' on the Vendor Page D=Default S=Specify
4	VNDR_AUDIT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Supplier Audit Y/N Table Edit
5	TEMPLATE_ID	Character(30)	VARCHAR2(30) NOT NULL	Project Template