PV_SRCH_N1_VW

(SQL View)
Index Back

PV_SRCH_INDX Proc. View

PV_SRCH_INDX Proc. View

SELECT A.SETID ,A.INV_ITEM_ID ,B.VENDOR_SETID ,B.VENDOR_ID ,%subrec(PV_VER_ITM_SREC, A) ,B.ITM_ID_VNDR ,B.VNDR_CATALOG_ID ,B.ITM_VNDR_PRIORITY ,B.VNDR_NAME1 ,B.VNDR_STATUS_PO ,B.ITM_STATUS ,B.VENDOR_STATUS FROM PS_PV_SRCH_IP_TMP A , PS_PV_SRCH_VND_TMP B WHERE A.INV_ITEM_ID = B.INV_ITEM_ID AND A.SETID = B.SETID

# 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 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
6 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
8 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
9 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
10 INVENTORY_ITEM Character(1) VARCHAR2(1) NOT NULL Inventory Item
N=No
Y=Yes
11 PRICE_LIST Number(16,5) DECIMAL(15,5) NOT NULL Standard Price
12 STD_LEAD Number(3,0) SMALLINT NOT NULL Purchase Lead Time Days
13 MODEL Character(30) VARCHAR2(30) NOT NULL Model
14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
15 AVAIL_ALL_RGNS Character(1) VARCHAR2(1) NOT NULL Available in All Regions
16 ITM_STATUS_CURRENT Character(1) VARCHAR2(1) NOT NULL Item Status Current
1=Active
2=Hold
3=Discontinue
4=Inactive
5=Pending Approval
6=Denied Approval
7=Under Initialization
17 ITM_STATUS_FUTURE Character(1) VARCHAR2(1) NOT NULL Item Status Future
1=Active
2=Hold
3=Discontinue
4=Inactive
18 ITM_STATUS_EFFDT Date(10) DATE Item Status Date
19 ITM_STAT_DT_FUTURE Date(10) DATE Item Date Future
20 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID
21 VNDR_CATALOG_ID Character(20) VARCHAR2(20) NOT NULL Vendor's Catalog Number
22 ITM_VNDR_PRIORITY Number(3,0) SMALLINT NOT NULL Item Vendor Priority
23 VNDR_NAME1 Character(40) VARCHAR2(40) NOT NULL Supplier Name
24 VNDR_STATUS_PO Character(1) VARCHAR2(1) NOT NULL Open For Ordering
N=No
Y=Yes
25 ITM_STATUS Character(1) VARCHAR2(1) NOT NULL Item Status
A=Active
D=Discntued
H=Hold
I=Inactive
X=To be Del
26 VENDOR_STATUS Character(1) VARCHAR2(1) NOT NULL Vendor Status
A=Approved
D=Denied
E=Unapproved
I=Inactive
X=To Be Archived