PV_REQFAVS_VW2

(SQL View)
 Index Back

Requestor Items

Favorites search from mobile application.

SELECT REQUESTOR_ID ,' ' ,FAVORITES_TYPE , SEQ_NBR , MERCHANTID , ITM_SETID , INV_ITEM_ID , VENDOR_SETID , VENDOR_ID , VNDR_LOC , SERVICE_TYPE , ROLE_TYPE , PROJECT_ROLE , QTY_REQ , PRICE_REQ , CATEGORY_CD , UNIT_OF_MEASURE , CURRENCY_CD , DUE_DT , DESCR254_MIXED , PV_SR_TYPE , USECOUNT , LAST_ORDER_DATE , PREFERRED_FAV_FLG , MFG_ITM_ID , MFG_ID , ITM_ID_VNDR , LN_TYPE , KEY1 , KEY1_FLD_VAL , KEY2 , KEY2_FLD_VAL , KEY3 , KEY3_FLD_VAL , UPN_TYPE_CD , UPN_ID FROM PS_PV_REQSTR_FAVS UNION SELECT REQUESTOR_ID , PV_REQ_FAVS_GRP , FAVORITES_TYPE , SEQ_NBR , MERCHANTID , ITM_SETID , INV_ITEM_ID , VENDOR_SETID , VENDOR_ID , VNDR_LOC , SERVICE_TYPE , ROLE_TYPE , PROJECT_ROLE , QTY_REQ , PRICE_REQ , CATEGORY_CD , UNIT_OF_MEASURE , CURRENCY_CD , DUE_DT , DESCR254_MIXED , PV_SR_TYPE , USECOUNT , LAST_ORDER_DATE , PREFERRED_FAV_FLG , MFG_ITM_ID , MFG_ID , ITM_ID_VNDR , LN_TYPE , KEY1 , KEY1_FLD_VAL , KEY2 , KEY2_FLD_VAL , KEY3 , KEY3_FLD_VAL , UPN_TYPE_CD , UPN_ID FROM PS_PV_REQ_GRP_ITEM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
2 PV_REQ_FAVS_GRP Character(30) VARCHAR2(30) NOT NULL Group name
3 FAVORITES_TYPE Character(5) VARCHAR2(5) NOT NULL Favorite Type
4 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
5 MERCHANTID Character(30) VARCHAR2(30) NOT NULL Merchant ID
6 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
7 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: ITM_PURCH_VW

8 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
9 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VENDOR_POVW1

10 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
11 SERVICE_TYPE Character(1) VARCHAR2(1) NOT NULL Sevice type
1=Service Request
2=Service Reply
12 ROLE_TYPE Character(6) VARCHAR2(6) NOT NULL Service Type
APR=Approver
MGR=Manager
OPR=Operator
13 PROJECT_ROLE Character(30) VARCHAR2(30) NOT NULL Project Role
14 QTY_REQ Number(16,4) DECIMAL(15,4) NOT NULL Requisition Quantity
15 PRICE_REQ Signed Number(17,5) DECIMAL(15,5) NOT NULL Date Initials Issue Description 092107 dh F-AHAYT-95051 ePro change from number to Sign to allow negative
16 CATEGORY_CD Character(18) VARCHAR2(18) NOT NULL Category Code
17 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
18 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
19 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
20 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
21 PV_SR_TYPE Character(1) VARCHAR2(1) NOT NULL Request type
B=Blanket Order
F=Fixed Cost
G=Good
L=Variable Cost
M=Time & Materials 2
N=Rentals
R=Recurring Agreement
T=Time and Materials
22 USECOUNT Number(3,0) SMALLINT NOT NULL Use Count
23 LAST_ORDER_DATE Date(10) DATE Last Order Date
24 PREFERRED_FAV_FLG Number(1,0) SMALLINT NOT NULL Preferred Favorite Flag

Default Value: 0

25 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID
26 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
27 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID
28 LN_TYPE Character(4) VARCHAR2(4) NOT NULL Line Type
CAT=Catalog Item
CUST=Custom Item
DC=Direct Connect Item
DCEX=Exchange Item
DCPO=Punchout Item
DCRT=Round Trip
DCTP=Transparent Punchout Item
DESR=Ad-hoc Item
EF=Express Form Item
OS=Order Sheet
SDF=Supplemental Data Form
SPRO=Service
SR=ePro Special Request Item
SRFC=Fixed Cost Service Item
SRTM=Time and Material Service Item
SRVC=Variable Cost Service Item
29 KEY1 Character(65) VARCHAR2(65) NOT NULL First Key
30 KEY1_FLD_VAL Character(50) VARCHAR2(50) NOT NULL Key 1 Field Value
31 KEY2 Character(65) VARCHAR2(65) NOT NULL Second Key
32 KEY2_FLD_VAL Character(50) VARCHAR2(50) NOT NULL Key 2 Field Value
33 KEY3 Character(65) VARCHAR2(65) NOT NULL Third Key
34 KEY3_FLD_VAL Character(50) VARCHAR2(50) NOT NULL Key 3 Field Value
35 UPN_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Universal Product Number Format Type
36 UPN_ID Character(20) VARCHAR2(20) NOT NULL Universal Product Number