PV_SS_AMOUNT_VW

(SQL View)
Index Back

SELECT BUSINESS_UNIT , PO_ID , LINE_NBR , PRICE_PO FROM PS_PO_LINE_SHIP WHERE SCHED_NBR=1

  • Parent record: PV_SS_POINV2_VW
  • # 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 PRICE_PO Signed Number(17,5) DECIMAL(15,5) NOT NULL Purchase Order Price