VENDOR_SETIDVENDOR_IDVNDR_LOCWTHD_ENTITYWTHD_JUR_CDWTHD_TYPEWTHD_CLASSVWTHD_CLASS_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT B.SETID , B.VENDOR_ID , B.VNDR_LOC , B.WTHD_ENTITY , B.WTHD_JUR_CD , B.WTHD_TYPE , A.WTHD_CLASS , A.DESCR FROM PS_WTHD_CLASS_TBL A , PS_VENDOR_WTHD_JUR B , PS_VENDOR_LOC V WHERE A.WTHD_TYPE = B.WTHD_TYPE AND A.WTHD_CLASS = B.DEFAULT_CLASS 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 V.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_JUR_CD |
Character(5) | VARCHAR2(5) NOT NULL | Withholding Jurisdiction |
| 6 | WTHD_TYPE |
Character(5) | VARCHAR2(5) NOT NULL | Withholding Type |
| 7 | WTHD_CLASS |
Character(5) | VARCHAR2(5) NOT NULL | Withholding Class |
| 8 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |