Integration Guide

Appendix B
WaveWorks PSS, Integration Guide, 1.10 Page 147
© 2000, Symbol Technologies, Inc. February 1, 2000
B.37 Table Name: PSS_Shopping_Tax
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
Tax_Plan_ID int NOT NULL Yes Yes
Amount int NULL No No
Tax_Amount char(18) NULL No No
PSS Shopping Tax Table contains the tax amounts by plan for items from a particular shopping
list
Customer ID customer with whom this shopping list is associated (from PSS_Customer)
Shopping List ID shopping list with which this item is associated (from
PSS_Shopping_List)
Tax_Plan_ID tax table ID as referenced in item records (from PSS_Tax_Table)
Amount taxable amount in base currency
Tax_Amount amount of tax in base currency (currently unused)
B.38 Table Name: PSS_Special_Barcode
Table Column Name Table Column
Datatype
Table Column Null
Option
Table Column Is PK Table Column Is FK
Barcode Varchar(20) NOT NULL Yes No
Type Int NULL No No
Description Varchar(50) NULL No No
PSS_Special_Barcode Table contains configuration information for barcodes with special
meanings, such as an End-Of-Trip barcode, or Queue Buster barcodes.
Barcode the special barcode as returned from the scanner
Type the type of barcode (quick order weight = 10, end-of-trip = 11, swap scanner = 12,
queue buster = 13)
Description a text description of this barcode