VENDOR_SETIDVENDOR_IDVNDR_LOCWTHD_ENTITYWTHD_TYPEWTHD_JUR_CDLANGUAGE_CDVWTHD_JUR_LVW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT B.SETID , B.VENDOR_ID , B.VNDR_LOC , B.WTHD_ENTITY , B.WTHD_TYPE , B.WTHD_JUR_CD , A.lANGUAGE_CD , A.DESCR FROM PS_WTHD_JUR_LANG A , PS_VENDOR_WTHD_JUR B , PS_VENDOR_LOC V WHERE A.WTHD_TYPE = B.WTHD_TYPE AND A.WTHD_JUR_CD = B.WTHD_JUR_CD 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_TYPE |
Character(5) | VARCHAR2(5) NOT NULL | Withholding Type |
| 6 | WTHD_JUR_CD |
Character(5) | VARCHAR2(5) NOT NULL | Withholding Jurisdiction |
| 7 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 8 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |