PV_REQ_MBL_L_VW

(SQL View)

SELECT A.BUSINESS_UNIT , A.REQ_ID , A.LINE_NBR , A.INV_ITEM_ID , A.AMT_ONLY_FLG , A.ORIG_INV_ITEM_ID , A.CURR_STATUS , A.DESCR254_MIXED , A.PRICE_REQ , A.CURRENCY_CD , A.QTY_REQ , A.UNIT_OF_MEASURE , A.VENDOR_SETID , A.VENDOR_ID , A.LN_TYPE FROM PS_REQ_LINE A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID

3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

4 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

5 AMT_ONLY_FLG Character(1) VARCHAR2(1) NOT NULL Amount Only
N=No
Y=Yes

6 ORIG_INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Used to identify the original item ordered, in case an item substitution has taken place.

7 CURR_STATUS Character(1) VARCHAR2(1) NOT NULL Current Status
A=Approved
C=Closed
D=Denied
H=Hold
O=Open
P=Pending
X=Canceled

8 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description

9 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

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

11 QTY_REQ Number(16,4) DECIMAL(15,4) NOT NULL Requisition Quantity

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 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

14 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

15 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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID
3	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
4	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
5	AMT_ONLY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Amount Only N=No Y=Yes
6	ORIG_INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Used to identify the original item ordered, in case an item substitution has taken place.
7	CURR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Current Status A=Approved C=Closed D=Denied H=Hold O=Open P=Pending X=Canceled
8	DESCR254_MIXED	Character(254)	VARCHAR2(254) NOT NULL	Description
9	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
10	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
11	QTY_REQ	Number(16,4)	DECIMAL(15,4) NOT NULL	Requisition Quantity
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	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
14	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
15	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