DCM_VNDR_VAT_VW(SQL View) |
Index Back |
|---|---|
Vendor Vat RegistrationsVat Registration # |
| SELECT a.setid , a.vendor_id , b.vat_rgstrn_id FROM PS_VENDOR a , ps_vndr_vat_rgstrn b WHERE a.setid = b.setid AND a.vendor_id = b.vendor_id AND b.home_country_flg = 'Y' UNION SELECT aa.setid , aa.vendor_id , ' ' FROM PS_VENDOR aa WHERE NOT EXISTS ( SELECT 'x' FROM ps_vndr_vat_rgstrn bb WHERE bb.setid = aa.setid AND bb.vendor_id = aa.vendor_id AND bb.home_country_flg = 'Y') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 3 | VAT_RGSTRN_ID | Character(20) | VARCHAR2(20) NOT NULL | VAT Registration ID |