CAEDD_VNDR_VW

(SQL View)
 Index Back

SELECT a.setid , a.vendor_id , a.vndr_loc , b.name1 , a.tin , a.tin_type , d.address1 , d.city , d.state , d.postal , b.vendor_name_short FROM ps_vendor_wthd a , ps_vendor b , PS_VENDOR_ADDR d WHERE a.effdt = ( SELECT MAX(c.effdt) FROM ps_vendor_loc c WHERE c.setid = a.setid AND c.vendor_id = a.vendor_id AND c.vndr_loc = a.vndr_loc AND c.effdt <= %CurrentDateIn AND c.eff_status = 'A') AND b.setid = a.setid AND b.vendor_id = a.vendor_id AND b.wthd_sw = 'Y' AND a.tin <> ' ' AND d.setid = a.setid AND d.vendor_id = a.vendor_id AND d.setid = a.setid AND d.vendor_id = a.vendor_id AND d.address_seq_num = a.address_seq_num AND d.effdt = ( SELECT MAX(e.effdt) FROM PS_VENDOR_ADDR e WHERE e.setid = d.setid AND e.vendor_id = d.vendor_id AND e.address_seq_num = d.address_seq_num AND e.effdt <= %CurrentDateIn AND e.eff_status = 'A')

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

2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VNDR_ACTIVE_VW

3 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
4 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1

Prompt Table: VNDR_NAME1_VW

5 TIN Character(20) VARCHAR2(20) NOT NULL Taxpayer Identification Number
6 TIN_TYPE Character(1) VARCHAR2(1) NOT NULL TIN Type
F=Federal Employer ID Number
S=Social Security Number
7 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
8 CITY Character(30) VARCHAR2(30) NOT NULL City
9 STATE Character(6) VARCHAR2(6) NOT NULL State
10 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
11 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name

Prompt Table: VENDOR_SHRT_VW1