PV_VENDOR_PO_VW

(SQL View)
 Index Back

View of Active PO Suppliers

07/24/2009 PKL 1906356001 Online dispatcher and Batch dispatcher page will show all the suppliers.

SELECT DISTINCT A.SETID , A.VENDOR_ID , A.VENDOR_NAME_SHORT , A.NAME1 , A.NAME2 , A.AR_NUM , A.OLD_VENDOR_ID FROM PS_VENDOR A WHERE A.VENDOR_STATUS = 'A' AND A.VNDR_STATUS_PO = 'Y'

  • Related Language Record: VNDR_ACTIVE_VLN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    3 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
    4 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    5 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2
    6 AR_NUM Character(15) VARCHAR2(15) NOT NULL Our Customer Number
    7 OLD_VENDOR_ID Character(15) VARCHAR2(15) NOT NULL Old Vendor ID