VENDOR_SETIDVENDOR_IDVNDR_LOCWTHD_ENTITYWTHD_TYPEVWTHD_TYPE_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT B.SETID , B.VENDOR_ID , B.VNDR_LOC , B.WTHD_ENTITY , A.WTHD_TYPE , A.DESCR FROM PS_WTHD_TYPE_TBL A , PS_VENDOR_WTHD_JUR B , PS_VENDOR_LOC V WHERE A.WTHD_TYPE = B.WTHD_TYPE AND V.SETID = B.SETID AND V.VENDOR_ID = B.VENDOR_ID AND V.VNDR_LOC = B.VNDR_LOC AND V.EFF_STATUS = 'A' AND V.EFFDT = B.EFFDT AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_VENDOR_LOC C WHERE C.SETID = V.SETID AND C.VENDOR_ID = V.VENDOR_ID AND C.VNDR_LOC = V.VNDR_LOC AND C.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | VENDOR_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 2 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 3 | VNDR_LOC |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 4 | WTHD_ENTITY |
Character(5) | VARCHAR2(5) NOT NULL | Withholding Entity |
| 5 | WTHD_TYPE |
Character(5) | VARCHAR2(5) NOT NULL | Withholding Type |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |