PV_MOBILEINST(SQL Table) |
Index Back |
|---|---|
Mobil |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PV_MB_SHOWSAV | Character(1) | VARCHAR2(1) NOT NULL |
Show Checkout Options
Y/N Table Edit Default Value: N |
| 2 | PV_MB_SAVEOPT | Character(1) | VARCHAR2(1) NOT NULL |
Save Options
0=Save Button Only 1=Submit Button Only 2=Display Both Buttons Default Value: 0 |
| 3 | PV_MB_ITM_PREF | Character(1) | VARCHAR2(1) NOT NULL |
Line Overview Item Preference
0=Item ID 1=Supplier Item ID Default Value: 0 |
| 4 | PV_MOBILE_LOGGING | Character(1) | VARCHAR2(1) NOT NULL |
Enable Mobile Logging
Y/N Table Edit Default Value: N |
| 5 | PV_DC_AUTOEXPAND | Character(1) | VARCHAR2(1) NOT NULL |
Auto Expand Cart
Y/N Table Edit Default Value: N |
| 6 | PV_DC_SHOWCART | Character(1) | VARCHAR2(1) NOT NULL |
Show Cart Options
Y/N Table Edit Default Value: N |
| 7 | PV_DC_SHOWVIEWOPT | Character(1) | VARCHAR2(1) NOT NULL |
Show Result View Options
Y/N Table Edit Default Value: N |
| 8 | PV_DC_VIEWOPT | Character(1) | VARCHAR2(1) NOT NULL |
Search Results View Default
C=View Catalog Items First F=View Favorites First W=View Web Suppliers First Default Value: C |
| 9 | PV_ALLOW_UOM_EDIT | Character(1) | VARCHAR2(1) NOT NULL |
Allow Editing of UOM
Y/N Table Edit Default Value: Y |
| 10 | PV_SHOW_OTHERSUPP | Character(1) | VARCHAR2(1) NOT NULL |
Show Other Suppliers
N=Hide Other Suppliers Y=Show Other Suppliers Default Value: Y |
| 11 | PV_SHOW_ITMDET_GRP | Character(1) | VARCHAR2(1) NOT NULL |
Show Item Details Options
Y/N Table Edit Default Value: Y |
| 12 | PV_SHOW_RECENT | Character(1) | VARCHAR2(1) NOT NULL |
Display Recently Ordered
Y/N Table Edit Default Value: Y |
| 13 | PV_SHOW_WEB | Character(1) | VARCHAR2(1) NOT NULL |
Display Web Suppliers
Y/N Table Edit Default Value: Y |
| 14 | PV_SHOW_FAV | Character(1) | VARCHAR2(1) NOT NULL |
Display Favorites
Y/N Table Edit Default Value: Y |
| 15 | PV_SHOW_HOME_GRP | Character(1) | VARCHAR2(1) NOT NULL |
Show Home Page Options
Y/N Table Edit Default Value: Y |
| 16 | PV_RECV_ITM_INFO | Character(1) | VARCHAR2(1) NOT NULL |
Show
I=Item ID M=Manufacturing Item ID S=Supplier Item ID U=UPN Details Default Value: I |
| 17 | PV_MOB_REQMODE | Character(1) | VARCHAR2(1) NOT NULL |
Requisition Mode
A=Add E=Edit Default Value: A |
| 18 | PV_GOTO_CHECKOUT | Character(1) | VARCHAR2(1) NOT NULL |
Edit Requisition Options
C=Go To Cart First E=Go To Checkout First Default Value: C |
| 19 | PV_AUTO_EXPAND_ACC | Character(1) | VARCHAR2(1) NOT NULL |
Expand Section
Y/N Table Edit |
| 20 | PV_CHARTFIELD_ERR | Character(1) | VARCHAR2(1) NOT NULL |
Disable Chartfield Error
Y/N Table Edit Default Value: Y |
| 21 | PV_REQ_TYPE_OPTION | Number(3,0) | SMALLINT NOT NULL |
Requisition Type Option
Default Value: 0 |