VENDOR_POVW1

(SQL View)
Index Back

View of Active PO Suppliers


select 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: VENDOR_POVW1_LN
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor 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