PV_SS_POINV2_VW

(SQL View)
 Index Back

SELECT DISTINCT A.PO_ID , A.BUSINESS_UNIT , A.PO_DT , A.BUYER_ID , B.VENDOR_ID , A.VENDOR_SETID , A.PO_STATUS , A.RECV_STATUS , B.OPRID FROM PS_PO_HDR A , PS_PV_SS_OPR_VNDR B WHERE A.PO_STATUS IN ('D','C') AND A.VENDOR_SETID=B.SETID AND A.VENDOR_ID=B.VENDOR_ID AND A.PO_ID NOT IN ( SELECT C.PO_ID FROM PS_PV_SS_INVC_PO C WHERE C.PV_SS_COMP_FLG='Y')

  • Parent Record Of PV_SS_ACCT_VW PV_SS_AMOUNT_VW PV_SS_INV_DL_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 PO_DT Date(10) DATE Date
    4 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
    5 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    6 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
    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
    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
    9 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).