Integration Guide

Table Of Contents
Appendix B
WaveWorks PSS, Integration Guide, 1.10 Page 140
© 2000, Symbol Technologies, Inc. February 1, 2000
B.29 Table Name: PSS_Shopping_History_Activity
Table Column Name Table Column
Datatype
Table Column Null
Option
Table Column Is PK Table Column Is FK
Customer_ID Int NOT NULL Yes Yes
Shopping_List_ID Int NOT NULL Yes Yes
Activity_Nbr Int NOT NULL Yes No
Activity_Datetime Datetime NULL No No
Activity_Type Varchar(10) NULL No No
Activity_Detail Varchar(80) NULL No No
PSS Shopping History Activity Table contains activities that occurred on the hand-held
terminal during a historical shopping trip, including addition/removal of items, marketing
messages displayed on the terminal, etc.
Customer ID identifies the customer (from PSS_Customer)
Shopping List ID identifies shopping list (from PSS_Shopping_List)
Activity Nbr a sequential number showing the order in which the events occurred
Activity Datetime the date and time of the activity
Activity Type the type of activity which occurred (i.e. ADDITEM, DELITEM, etc.)
Activity Detail a description of the activity which occurred