Integration Guide

Appendix B
WaveWorks PSS, Integration Guide, 1.10 Page 142
© 2000, Symbol Technologies, Inc. February 1, 2000
B.31 Table Name: PSS_Shopping_History_List
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 No
Time_Started datetime NULL No No
Time_Ended datetime NULL No No
Shopping_List_Status_ID int NULL No No
Total int NULL No No
Transaction_ID varchar(25) NULL No No
Rescanned char(1) NULL No No
Terminal_ID varchar(16) NULL No No
Scanned_Item_Count int NULL No No
Trip_Length_Seconds int NULL No No
PSS Shopping History List Table contains the high-level historical shopping trip information.
Once shopping trips are completed, the data is moved into the historical tables.
Customer ID customer with whom this shopping trip is associated (from
PSS_Customer)
Shopping List ID unique shopping list identifier
Time Started the date and time that a shopping list was started
Time Ended the date and time that a shopping list was completed
Shopping List Status ID status of this shopping trip (from PSS_Shopping_List_Status)
Total total amount for this trip
Transaction_ID transaction identifier sent to/from the POS to help match shopping lists
Rescanned indicates whether this shopping trip was rescanned
Terminal_ID the terminal ID (from UMS_Terminal) of the terminal last used on this
shopping trip
Scanned_Item_Count number of items in this shopping list
Trip_Length_Seconds number of seconds the terminal was in use for this shopping trip