PV_ITM_VNDR_SES

(SQL Table)

# 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 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID

7 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID

8 PV_PREF_VNDR Character(1) VARCHAR2(1) NOT NULL Preferred Supplier
N=Not Preferred
Y=Preferred
Default Value: N

9 PRICE_LIST Number(16,5) DECIMAL(15,5) NOT NULL Standard Price

10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

11 CURRENCY_CD_COMM Character(3) VARCHAR2(3) NOT NULL Common Currency Code

12 PRICE_LIST_COMM Number(16,5) DECIMAL(15,5) NOT NULL Common price used for searching in ePro.

13 LEAD_TIME Number(3,0) SMALLINT NOT NULL Lead Time Days

14 PV_SPECIALTAGS Long Character CLOB FIeld to hold special tags for PTSF processing.

15 LAST_UPDATE_DTTM 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	MFG_ID	Character(50)	VARCHAR2(50) NOT NULL	Manufacturer ID
7	MFG_ITM_ID	Character(50)	VARCHAR2(50) NOT NULL	Manufacturer's Item ID
8	PV_PREF_VNDR	Character(1)	VARCHAR2(1) NOT NULL	Preferred Supplier N=Not Preferred Y=Preferred Default Value: N
9	PRICE_LIST	Number(16,5)	DECIMAL(15,5) NOT NULL	Standard Price
10	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
11	CURRENCY_CD_COMM	Character(3)	VARCHAR2(3) NOT NULL	Common Currency Code
12	PRICE_LIST_COMM	Number(16,5)	DECIMAL(15,5) NOT NULL	Common price used for searching in ePro.
13	LEAD_TIME	Number(3,0)	SMALLINT NOT NULL	Lead Time Days
14	PV_SPECIALTAGS	Long Character	CLOB	FIeld to hold special tags for PTSF processing.
15	LAST_UPDATE_DTTM	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.