Integration Guide

Appendix B
WaveWorks PSS, Integration Guide, 1.10 Page 146
© 2000, Symbol Technologies, Inc. February 1, 2000
B.35 Table Name: PSS_Shopping_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 Yes
Total int NULL No No
Total_Currency_2 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 List Table contains the high level shopping trip information
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 this shopping list was started
Time Ended the date and time that this 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 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
B.36 Table Name: PSS_Shopping_List_Status
Table Column Name Table Column
Datatype
Table Column Null
Option
Table Column Is PK Table Column Is FK
Shopping_List_Status_ID int NOT NULL Yes No
Description varchar(20) NULL No No
PSS Shopping List Status Table identifies the allowable shopping list states
Shopping List Status ID unique status identifier
Description text describing this state