PV_MOBILEOPTNS

(SQL Table)
Index Back

Mobil Options

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
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: 2

3 PV_DC_AUTOEXPAND Character(1) VARCHAR2(1) NOT NULL Auto Expand Cart

Y/N Table Edit

Default Value: N

4 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

5 PV_SHOW_OTHERSUPP Character(1) VARCHAR2(1) NOT NULL Show Other Suppliers
N=Hide Other Suppliers
Y=Show Other Suppliers

Default Value: Y

6 PV_SHOW_RECENT Character(1) VARCHAR2(1) NOT NULL Display Recently Ordered

Y/N Table Edit

Default Value: N

7 PV_SHOW_WEB Character(1) VARCHAR2(1) NOT NULL Display Web Suppliers

Y/N Table Edit

Default Value: N

8 PV_SHOW_FAV Character(1) VARCHAR2(1) NOT NULL Display Favorites

Y/N Table Edit

Default Value: N