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

PV_PO_REQV_VW

(SQL View)
 Index Back

SELECT DISTINCT A.BUSINESS_UNIT , D.REQ_ID , C.REQ_LINE_NBR , A.PO_ID , B.LINE_NBR , B.DESCR254_MIXED , A.PO_STATUS , A.RECV_STATUS , A.CURRENCY_CD , D.PRICE_REQ , D.UNIT_OF_MEASURE , D.QTY_REQ , D.MERCHANDISE_AMT , B.RECV_REQ , B.INV_ITEM_ID , B.CATEGORY_ID , B.ITM_SETID , B.CANCEL_STATUS , D.MFG_ID , D.MFG_ITM_ID , A.VENDOR_ID , D.ITM_ID_VNDR FROM PS_PO_HDR A , PS_PO_LINE B , PS_PV_PO_REQ_XREF C , PS_REQ_LINE D WHERE A.BUSINESS_UNIT= B.BUSINESS_UNIT AND A.PO_ID=B.PO_ID AND B.BUSINESS_UNIT=C.BUSINESS_UNIT AND B.PO_ID=C.PO_ID AND B.LINE_NBR=C.LINE_NBR AND D.REQ_ID=C.REQ_ID AND D.LINE_NBR=C.REQ_LINE_NBR AND D.BUSINESS_UNIT=C.BUSINESS_UNIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_PM_NONVW

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 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

Default Value: NEXT

5 PO_LINE_NBR Number(5,0) INTEGER NOT NULL Purchase Order Line Number
6 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
7 PO_STATUS Character(2) VARCHAR2(2) NOT NULL PO Status
A=Approved
C=Complete
D=Dispatched
DA=Denied
I=Initial
LD=Line Denied
O=Open
PA=Pending Approval/Approved
PX=Pending Cancel
X=Canceled

Default Value: I

8 RECV_STATUS Character(1) VARCHAR2(1) NOT NULL Receipt Status
C=Closed Receipt
H=Hold Receipt
M=Moved to Destination
N=PO Not Received
O=Open
P=PO Partially Received
R=Fully Received
X=Canceled

Default Value: N

9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
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 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
12 QTY_REQ Number(16,4) DECIMAL(15,4) NOT NULL Requisition Quantity
13 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
14 RECV_REQ Character(1) VARCHAR2(1) NOT NULL Receiving Required
N=Optional
X=Do Not
Y=Required
15 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
16 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
17 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
18 CANCEL_STATUS Character(1) VARCHAR2(1) NOT NULL Cancel Status
A=Active
C=Closed
D=Denied
H=Hold
O=Open
P=Pending Approval
X=Canceled
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
21 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
22 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID