Integration Guide

Appendix B
WaveWorks PSS, Integration Guide, 1.10 Page 132
© 2000, Symbol Technologies, Inc. February 1, 2000
B.12 Table Name: PSS_Item
Table Column Name Table Column
Datatype
Table Column Null
Option
Table Column Is PK Table Column Is FK
Item_ID varchar(20) NOT NULL Yes No
Description varchar(40) NULL No No
Price Int NULL No No
Department_ID Int NULL No Yes
Class varchar(20) NULL No No
Subclass varchar(20) NULL No No
Manufacturer_ID Int NULL No Yes
Aisle varchar(10) NULL No No
Shelf varchar(10) NULL No No
Unit varchar(10) NULL No No
Weight varchar(20) NULL No No
Linkcode varchar(20) NULL No No
Pricing_Method char(1) NULL No No
Mix_Match Int NULL No No
Foodstamp char(1) NULL No No
Flags Int NULL No No
Deal_Price Int NULL No No
Deal_Qty Int NULL No No
Tax_Plan int NULL No No
POS_Item_Flag char(1) NULL No No
Currency_ID int NULL No No
PSS Item Table holds item information; source of information can be the POS item file
Item ID unique item identifier
Description text description of the item
Price unit price of the item represented in the base store currency
Department ID unique identifier for the department assigned to this item (from
PSS_Department)
Class the classification group of this item
Subclass a more specific classification of an item within a class
Manufacturer ID unique identifier for this item manufacturer (from PSS_Manufacturer)
Aisle usual aisle in store for this item
Shelf shelf location in store
Unit the unit used to measure quantities of an item (i.e. fluid ounces, pounds,
etc.)
Weight the amount of the unit
Linkcode a barcode for an item linked to this item
Pricing Method identifies pricing method to be used for this item
Mix Match when set, this item is part of an identically priced group (i.e. yogurts,
canned soups)
Foodstamp when set, indicates that this item is food stamp eligible
Flags holds information specific to the item (i.e. discontinued, applicable tax
levels, etc.)
Deal Price The price of the deal, if any, assigned to this item
Deal Quantity quantity of this item which must be purchased to enable the deal
Tax_Plan unique identifier for the text plan under which this item falls (from
PSS_Tax_Table)