PV_REQSTR_FAVS

(SQL Table)
Index Back

Requestor Items

This table contains the items ordered by a requestor. Date Initials Issue Description 092107 dh F-AHAYT-95051 PRICE_REQ for ePro change from number to Sign to allow negative

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

Prompt Table: ITM_PURCH_VW

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

Prompt Table: VENDOR_POVW1

9 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
10 VNDR_CATALOG_ID Character(20) VARCHAR2(20) NOT NULL Vendor's Catalog Number
11 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID
12 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
13 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID
14 SERVICE_TYPE Character(1) VARCHAR2(1) NOT NULL Sevice type
1=Service Request
2=Service Reply
15 ROLE_TYPE Character(6) VARCHAR2(6) NOT NULL Service Type
APR=Approver
MGR=Manager
OPR=Operator
16 PROJECT_ROLE Character(30) VARCHAR2(30) NOT NULL Project Role
17 QTY_REQ Number(16,4) DECIMAL(15,4) NOT NULL Requisition Quantity
18 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
19 CATEGORY_CD Character(18) VARCHAR2(18) NOT NULL Category Code
20 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
21 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
22 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.
23 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
24 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
25 USECOUNT Number(3,0) SMALLINT NOT NULL Use Count
26 LAST_ORDER_DATE Date(10) DATE Last Order Date
27 PREFERRED_FAV_FLG Number(1,0) SMALLINT NOT NULL Preferred Favorite Flag

Default Value: 0

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