SP_REMIT_VND_VW

(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.name1 FROM PS_VENDOR a

  • Related Language Record: SP_REM_VND_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETVC_NONVW

    2 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor
    3 REMIT_TO_NAME Character(40) VARCHAR2(40) NOT NULL Remit To Supplier Name