PV_REQ_PO_D_VW3

(SQL View)
Index Back

ePro PO views


SELECT DISTINCT A.BUSINESS_UNIT , C.REQ_ID , A.PO_ID , A.LINE_NBR , A.SCHED_NBR , B.INV_ITEM_ID , A.MERCHANDISE_AMT , A.MATCH_STATUS_LN_PO , A.QTY_PO FROM PS_PO_LINE_SHIP A , PS_PO_LINE B , PS_PV_REQ_PO_D_VW2 C WHERE A.BUSINESS_UNIT= B.BUSINESS_UNIT AND A.PO_ID= B.PO_ID AND A.LINE_NBR = B.LINE_NBR AND A.BUSINESS_UNIT= C.BUSINESS_UNIT AND A.PO_ID = C.PO_ID

# 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

Default Value: NEXT

3 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
4 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
5 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
6 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
7 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
8 MATCH_STATUS_LN_PO Character(1) VARCHAR2(1) NOT NULL Match Status PO
M=Matched
N=Not Matched
P=Partially Matched
9 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity