PV_CO_LINK_SUPP

(SQL View)

SELECT A.SETID , A.VENDOR_ID , B.PV_CO_SCHEMA_NAME , A.PV_MS_SUP_MPID , B.PV_CO_ACTION_TIME , B.PROCESS_INSTANCE FROM PS_PV_MS_SUPPLIER A , PS_PV_CO_SUPPLIERS 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 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

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

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

5 PV_CO_ACTION_TIME DateTime(26) TIMESTAMP Cohera PS Action Time

6 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

#	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	PV_CO_SCHEMA_NAME	Character(128)	VARCHAR2(128) NOT NULL	Cohera Catalog Name
4	PV_MS_SUP_MPID	Character(50)	VARCHAR2(50) NOT NULL	e
5	PV_CO_ACTION_TIME	DateTime(26)	TIMESTAMP	Cohera PS Action Time
6	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance