VENDOR_VW1

(SQL View)
 Index Back

Supplier Search Record

Used as a search record for several supplier related panel groups

SELECT a.setid , a.vendor_id , a.vendor_name_short , a.ar_num , a.name1 , a.wthd_sw , a.default_loc , a.prim_addr_seq_num FROM PS_VENDOR a

  • Related Language Record: VNDR_VSET_VWLNG

    • # 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

    Prompt Table: VENDOR_VW

    3 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name

    Prompt Table: VENDOR_SHRT_VW1

    4 AR_NUM Character(15) VARCHAR2(15) NOT NULL Our Customer Number

    Prompt Table: VNDR_AR_VW

    5 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1

    Prompt Table: VNDR_NAME1_VW

    6 WTHD_SW Character(1) VARCHAR2(1) NOT NULL Withholding Applicable Flag
    B=Global and 1099
    G=Global
    T=1099
    7 DEFAULT_LOC Character(10) VARCHAR2(10) NOT NULL Default Location
    8 PRIM_ADDR_SEQ_NUM Number(5,0) INTEGER NOT NULL Invoicing Location