| # |
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 |
WS_MERCHANT_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Merchant ID
|
| 3 |
SEQNUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 4 |
WS_NBR_DISPLAY |
Character(2) |
VARCHAR2(2) NOT NULL |
Number to display
01=01
02=02
03=03
04=04
05=05
06=06
07=07
08=08
09=09
10=10
11=11
12=12
13=13
14=14
15=15
16=16
17=17
18=18
19=19
20=20
Default Value: 02
|
| 5 |
WS_HST_PERIOD |
Character(3) |
VARCHAR2(3) NOT NULL |
View transactions created
0=6 - all transactions
180=4 - in last 6 months
30=2 - in last month
365=5 - in last year
7=1 - in last week
90=3 - in last 3 months
Default Value: 30
|
| 6 |
WS_START_PAGE |
Character(3) |
VARCHAR2(3) NOT NULL |
Enter the codes to start the page when the user first comes to the site and tries to Login.
CAT=Catalog
EXP=Express Order
HOM=Home
HST=Order Status
PER=Personal List
Default Value: HOM
|
| 7 |
WS_SHOW_CART |
Character(1) |
VARCHAR2(1) NOT NULL |
eStore Display Order List/ Shopping Cart flag
N=Continue Shopping
Y=View Cart
Default Value: Y
|
| 8 |
WS_USE_ADVANCED |
Character(1) |
VARCHAR2(1) NOT NULL |
eStore Use advanced mode flag
N=Use Basic View
Y=Use Advanced View
Default Value: N
|
| 9 |
WS_SHOW_MY_ORDERS |
Character(1) |
VARCHAR2(1) NOT NULL |
Used in user preferences
N=Show all orders
Y=Show only my orders
Default Value: Y
|
| 10 |
CUSTOMER_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Customer SetID
Prompt Table:
CNTCT_SETID_VW
|
| 11 |
SOLD_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Sold To Customer
Prompt Table:
CNTCT_SLDCST_VW
|