VENDOR_SETIDPrompt Table: SP_SETID_NONVW
VENDOR_IDPrompt Table: VENDOR_NAME_VW1
VNDR_LOCPrompt Table: VNDR_LOC_AP_VW2
B=Global and 1099
G=Global
T=1099
VNDR_LC_WTHD_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT A.SETID , A.VENDOR_ID , A.VNDR_LOC , B.NAME1 , B.WTHD_SW FROM PS_VENDOR_LOC A , PS_VENDOR B WHERE A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(I.EFFDT) FROM PS_VENDOR_LOC I WHERE I.SETID = A.SETID AND I.VENDOR_ID = A.VENDOR_ID AND I.VNDR_LOC = A.VNDR_LOC AND I.EFFDT <= %CurrentDateIn) AND B.SETID = A.SETID AND B.VENDOR_ID = A.VENDOR_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | VENDOR_SETID |
Character(5) | VARCHAR2(5) NOT NULL |
Vendor SetID
Prompt Table: SP_SETID_NONVW |
| 2 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: VENDOR_NAME_VW1 |
| 3 | VNDR_LOC |
Character(10) | VARCHAR2(10) NOT NULL |
Vendor Location
Prompt Table: VNDR_LOC_AP_VW2 |
| 4 | VENDOR_NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Vendor Name1 |
| 5 | WTHD_SW | Character(1) | VARCHAR2(1) NOT NULL |
Withholding Applicable Flag
B=Global and 1099 G=Global T=1099 |