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 141

B.30 Table Name: PSS_Shopping_History_Item

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

Shopping_Item_ID int NOT NULL Yes No

Barcode varchar(20) NULL No No

Item_ID varchar(20) NULL No No

Sale_Price int NULL No No

Pricing_Method char(1) NULL No No

Mix_Match int NULL No No

Department_ID int NULL No No

Unit_Price int NULL No No

Deal_Price int NULL No No

Deal_Qty int NULL No No

Embedded_Price char(1) NULL No No

POS_Price int NULL No No

POS_PSA_Flag char(1) NULL No No

Exception char(1) NULL No No

Tax_Plan int NULL No No

PSS Shopping History Item Table contains the items for a given historical shopping trip

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

PSS_Customer)

Shopping List ID shopping list with which this item is associated (from

PSS_Shopping_List)

Shopping Item ID sequential unique item identifier

Barcode the actual barcode scanned before any translation occurs (i.e. for

embedded price barcodes)

Item ID item ID as matched against item information in PSS_Item

Sale Price the actual price paid for this item

Pricing_Method the pricing method used to price this item

Mix_Match the POS mix/match category this item was included in

Department_ID the department ID (from PSS_Department) that this item belongs to

Unit_Price the unit price for this item (from PSS_Item)

Deal_Price the deal price for this item (from PSS_Item)

Deal_Qty the deal quantity for this item (from PSS_Item)

Embedded_Price indicates whether this item had an embedded price barcode

POS_Price the price for this item sent from the POS

POS_PSA_Flag indicates whether this item was in the PSS shopping list (S) only, the POS

shopping list (P) only, or both (B).

Exception indicates whether this was flagged as an exception item at checkout

Tax_Plan indicates the tax plan that applied to this item (from PSS_Tax_Table)