Integration Guide

ManualsBrandsSymbol Technologies ManualsElectronicsHandheld Portable Shopping System Transmitter

141

142

143

144

145

146

147

148

149

150

Table Of Contents

Appendix B

WaveWorks PSS, Integration Guide, 1.10 Page 143

B.32 Table Name: PSS_Shopping_History_Rescan

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

POS_Price int NULL No No

PSS_Price int NULL No No

POS_Qty int NULL No No

PSS_Qty int NULL No No

PSS Shopper History Rescan Table contains the re-scan data for a customer’s previous

shopping trip.

Customer ID customer with whom this shopping trip is associated (from

PSS_Customer)

Shopping List ID unique shopping list identifier

POS Price the re-scanned shopping list amount from the POS

PSS Price the original shopping list amount from PSS

POS Qty the number of items in the re-scanned shopping list from the POS

PSS Price the number of items in the original shopping list amount from PSS

B.33 Table Name: PSS_Shopping_Incomplete_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 Incomplete List Table contains the high-level shopping trip information for

incomplete shopping trips. The DB Cleanup task moves all current shopping trips that haven’t

been checked out after a configurable length of time (8 hours is the default) to this table.

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)