SP_REM_VND_LVW

(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.language_cd , a.name1 FROM PS_VENDOR_LANG a

  • Related Language Record for SP_REMIT_VND_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 REMIT_TO_NAME Character(40) VARCHAR2(40) NOT NULL Remit To Supplier Name