Integration Guide

Appendix B
WaveWorks PSS, Integration Guide, 1.10 Page 145
© 2000, Symbol Technologies, Inc. February 1, 2000
B.34 Table Name: PSS_Shopping_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 Yes
Sale_Price int NULL No No
Sale_Price_Currency2 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
Tax_Plan int NULL No No
Currency_ID int NULL No No
PSS Shopping Item Table contains the items for a given current shopping trip
Customer ID customer with whom 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
Sale_Price_Currency2 the actual price paid for this item in the secondary currency
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
Tax_Plan indicates the tax plan that applied to this item (from PSS_Tax_Table)
Currency_ID currency identifier (from PSS_Currency) for the currency in which
Sale_Price is described