VNDR_THRD_VW

(SQL View)
Index Back

View of Active 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'

  • Related Language Record: VNDR_THRD_LG_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 THIRD_PRTY_VNDR Character(10) VARCHAR2(10) NOT NULL Third Party Supplier
    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