WTHD_RPT_IDLINE_NOVENDOR_SETIDPrompt Table: SP_SETVND_NONVW
VENDOR_IDVNDR_WTHDRPT_VW(SQL View) |
Index Back |
|---|---|
Supplier Withholding for Repor |
| SELECT WRD.WTHD_RPT_ID , WRD.LINE_NO , V.SETID , V.VENDOR_ID , V.VENDOR_NAME_SHORT FROM PS_VENDOR V , PS_WTHD_RPT_DTL WRD , PS_WTHD_CD_DTL WCD , PS_VENDOR_LOC VL WHERE V.SETID = VL.SETID AND V.VENDOR_ID = VL.VENDOR_ID AND WCD.SETID = VL.SETID AND WCD.WTHD_CD = VL.WTHD_CD AND WRD.WTHD_TYPE = WCD.WTHD_TYPE AND WRD.WTHD_CLASS = WCD.WTHD_CLASS |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | WTHD_RPT_ID |
Character(10) | VARCHAR2(10) NOT NULL | Withholding Report ID |
| 2 | LINE_NO |
Number(3,0) | SMALLINT NOT NULL | Line Number |
| 3 | VENDOR_SETID |
Character(5) | VARCHAR2(5) NOT NULL |
Vendor SetID
Prompt Table: SP_SETVND_NONVW |
| 4 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 5 | VENDOR_NAME_SHORT | Character(14) | VARCHAR2(14) NOT NULL | Short Vendor Name |