VNDR_ACTIVE_VW4

(SQL View)
 Index Back

View of Active Suppliers

11/15/2015 JOHAN PO0025 - Master contract fluid

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 vendor_persistence <> 'S'

  • Related Language Record: VNDR_ACT_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