PV_SS_PO_DTL_VW

(SQL View)
Index Back

SELECT DISTINCT A.BUSINESS_UNIT , A.PO_ID , A.LINE_NBR , A.ITM_ID_VNDR , A.VNDR_CATALOG_ID , A.DESCR254_MIXED , B.PRICE_PO , B.QTY_PO FROM PS_PO_LINE A , PS_PO_LINE_SHIP B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PO_ID=B.PO_ID AND A.LINE_NBR = B.LINE_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
4 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID
5 VNDR_CATALOG_ID Character(20) VARCHAR2(20) NOT NULL Vendor's Catalog Number
6 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
7 PRICE_PO Signed Number(17,5) DECIMAL(15,5) NOT NULL Purchase Order Price
8 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity