VNDR_VALRMTS_VW

(SQL View)
Index Back

Supplier who can be remit supp

To identify suppliers who are eligible to be remit suppliers. They must be approved and not a one time supplier.

select setid, vendor_id, vendor_name_short, name1, name2 from PS_VENDOR where vendor_status = 'A' and vendor_persistence <> 'O'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 REMIT_SETID Character(5) VARCHAR2(5) NOT NULL Remit SetID
2 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor
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