PV_CO_VNDR_VW

(SQL View)

SELECT SETID , PV_CO_SCHEMA_NAME , VENDOR_ID , VNDR_LOC , B.PV_MS_SUP_MPID , A.PV_MS_SUP_TP_NAME FROM PS_PV_MS_SUPPLIER A , PS_PV_CO_SUPP_LST B WHERE A.PV_MS_SUP_MPID = B.PV_MS_SUP_MPID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 PV_CO_SCHEMA_NAME Character(128) VARCHAR2(128) NOT NULL Cohera Catalog Name

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

4 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

5 PV_MS_SUP_MPID Character(50) VARCHAR2(50) NOT NULL e

6 PV_MS_SUP_TP_NAME Character(50) VARCHAR2(50) NOT NULL Linked Supplier Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	PV_CO_SCHEMA_NAME	Character(128)	VARCHAR2(128) NOT NULL	Cohera Catalog Name
3	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
4	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
5	PV_MS_SUP_MPID	Character(50)	VARCHAR2(50) NOT NULL	e
6	PV_MS_SUP_TP_NAME	Character(50)	VARCHAR2(50) NOT NULL	Linked Supplier Name