PV_ITEM_VNDR_VW

(SQL View)

SELECT A.SETID , A.INV_ITEM_ID , A.VENDOR_SETID , A.VENDOR_ID , A.ITMV_PRIORITY_LOC , A.ITM_ID_VNDR , A.ITM_VNDR_PRIORITY , A.ITM_STATUS , B.VENDOR_NAME_SHORT , B.NAME1 , B.DEFAULT_LOC , C.ITM_VNDR_PREFPRIOR , %DateTimeIn('1900-01-1-11.59.00.000000') FROM PS_ITM_VENDOR A , PS_VENDOR B , PS_PV_ITM_VNDPR_VW C WHERE A.VENDOR_SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.ITM_STATUS = 'A' AND B.VENDOR_STATUS = 'A' AND B.VNDR_STATUS_PO = 'Y' AND A.SETID = C.SETID AND A.INV_ITEM_ID = C.INV_ITEM_ID

Related Language Record: PV_ITEM_VNDR_LV

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

3 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

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

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

6 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID

7 ITM_VNDR_PRIORITY Number(3,0) SMALLINT NOT NULL Item Vendor Priority

8 ITM_STATUS Character(1) VARCHAR2(1) NOT NULL Item Status
A=Active
D=Discntued
H=Hold
I=Inactive
X=To be Del

9 VENDOR_SNAME Character(14) VARCHAR2(14) NOT NULL Supplier Short Name

10 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1

11 DEFAULT_LOC Character(10) VARCHAR2(10) NOT NULL Default Location

12 ITM_VNDR_PREFPRIOR Number(3,0) SMALLINT NOT NULL Item Vendor Priority

13 LAST_DTTM_UPDATE DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
3	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
4	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
5	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
6	ITM_ID_VNDR	Character(50)	VARCHAR2(50) NOT NULL	Vendor Item ID
7	ITM_VNDR_PRIORITY	Number(3,0)	SMALLINT NOT NULL	Item Vendor Priority
8	ITM_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Item Status A=Active D=Discntued H=Hold I=Inactive X=To be Del
9	VENDOR_SNAME	Character(14)	VARCHAR2(14) NOT NULL	Supplier Short Name
10	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
11	DEFAULT_LOC	Character(10)	VARCHAR2(10) NOT NULL	Default Location
12	ITM_VNDR_PREFPRIOR	Number(3,0)	SMALLINT NOT NULL	Item Vendor Priority
13	LAST_DTTM_UPDATE	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.