PV_SR_ITMSRH_VW(SQL View) |
Index Back |
|---|---|
Special Request search options |
| SELECT PV_SP_CATEGORY_ID , PV_SP_VENDOR_ID , PV_SP_ITM_ID_VNDR , PV_SP_MFG_ID , PV_SP_MFG_ITM_ID , PV_SP_DESCR FROM PS_PV_SRCH_SET_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PV_SP_CATEGORY_ID | Character(1) | VARCHAR2(1) NOT NULL |
Category ID
Default Value: N |
| 2 | PV_SP_VENDOR_ID | Character(1) | VARCHAR2(1) NOT NULL |
Supplier ID
Default Value: N |
| 3 | PV_SP_ITM_ID_VNDR | Character(1) | VARCHAR2(1) NOT NULL |
Supplier Item ID
Default Value: N |
| 4 | PV_SP_MFG_ID | Character(1) | VARCHAR2(1) NOT NULL |
Manufacturer ID
Default Value: N |
| 5 | PV_SP_MFG_ITM_ID | Character(1) | VARCHAR2(1) NOT NULL |
Manufacurer's Item ID
Default Value: N |
| 6 | PV_SP_DESCR | Character(1) | VARCHAR2(1) NOT NULL |
Item Description
Default Value: Y |