VENDOR_SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETVND_NONVW
VENDOR_IDVNDR_LOCLANGUAGE_CDVNDR_WTH_LG_VW2(SQL View) |
Index Back |
|---|
| SELECT a.setid , a.vendor_id , a.vndr_loc , f.language_cd , f.name1 FROM ps_vendor_wthd a , ps_vendor b , PS_VENDOR_ADDR_LNG f , 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 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') AND d.setid = f.setid AND d.vendor_id = f.vendor_id AND d.address_seq_num = f.address_seq_num |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | VENDOR_SETID |
Character(5) | VARCHAR2(5) NOT NULL |
Vendor SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETVND_NONVW |
| 2 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 3 | VNDR_LOC |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |