PV_GRP_ITM_VW2

(SQL View)
 Index Back

Favorites Group Items

Favorites Group Items Date Initials Issue Description 092107 dh F-AHAYT-95051 PRICE_REQ for ePro change from number to Sign to allow negative

SELECT A.REQUESTOR_ID ,A.PV_REQ_FAVS_GRP ,A.FAVORITES_TYPE ,A.SEQ_NBR ,A.ITM_SETID ,A.INV_ITEM_ID ,A.VENDOR_SETID ,A.VENDOR_ID ,A.VNDR_LOC ,A.PRICE_REQ ,A.CATEGORY_CD ,A.UNIT_OF_MEASURE ,A.CURRENCY_CD ,A.DESCR254_MIXED ,A.PV_SR_TYPE ,A.LN_TYPE ,A.QTY_REQ ,A.ITM_ID_VNDR ,A.MFG_ID ,A.MFG_ITM_ID FROM PS_PV_REQ_GRP_ITEM A

# 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 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
6 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
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 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
11 CATEGORY_CD Character(18) VARCHAR2(18) NOT NULL Category Code
12 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
13 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
14 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
15 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
16 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
17 QTY_REQ Number(16,4) DECIMAL(15,4) NOT NULL Requisition Quantity
18 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID
19 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
20 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID