PV_SRCH_DISPLAY(SQL Table) |
Index Back |
|---|---|
Search Results Display ConfigTable used as the default values to use when showing/hiding search results in ePro searches. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PV_SHOW_ITEMID | Character(1) | VARCHAR2(1) NOT NULL |
Item ID
Y/N Table Edit Default Value: Y |
| 2 | PV_SHOW_LEADTIME | Character(1) | VARCHAR2(1) NOT NULL |
Lead Time Days
Y/N Table Edit Default Value: Y |
| 3 | PV_SHOW_MFG | Character(1) | VARCHAR2(1) NOT NULL |
Manufacturer
Y/N Table Edit Default Value: Y |
| 4 | PV_SHOW_MFGID | Character(1) | VARCHAR2(1) NOT NULL |
Manufacturer ID
Y/N Table Edit Default Value: Y |
| 5 | PV_SHOW_MFGITEM | Character(1) | VARCHAR2(1) NOT NULL |
Mfg Item ID
Y/N Table Edit Default Value: Y |
| 6 | PV_SHOW_PRICE | Character(1) | VARCHAR2(1) NOT NULL |
Price
Y/N Table Edit Default Value: Y |
| 7 | PV_SHOW_UOM | Character(1) | VARCHAR2(1) NOT NULL |
UOM
Y/N Table Edit Default Value: Y |
| 8 | PV_SHOW_VENDOR | Character(1) | VARCHAR2(1) NOT NULL |
Supplier
Y/N Table Edit Default Value: Y |
| 9 | PV_SHOW_VNDITEM | Character(1) | VARCHAR2(1) NOT NULL |
Supplier Item ID
Y/N Table Edit Default Value: Y |
| 10 | PV_SHOW_VNDRID | Character(1) | VARCHAR2(1) NOT NULL |
Supplier ID
Y/N Table Edit Default Value: Y |
| 11 | PV_SHOW_IMAGES | Character(1) | VARCHAR2(1) NOT NULL |
Show Search Result Item Images
N=No Y=Yes Default Value: Y |
| 12 | PV_SHOW_UPNID | Character(1) | VARCHAR2(1) NOT NULL |
UPN ID
Y/N Table Edit Default Value: N |