Integration Guide

Appendix B
WaveWorks PSS, Integration Guide, 1.10 Page 150
© 2000, Symbol Technologies, Inc. February 1, 2000
B.42 Table Name: PSS_Tax_Table_Entry
Table Column Name Table Column
Datatype
Table Column Null
Option
Table Column Is PK Table Column Is FK
Tax_Plan_ID Int NOT NULL Yes Yes
Range_Indicator char(1) NOT NULL Yes No
Price_Group_Start int NOT NULL Yes No
Tax_Amount int NULL No No
PSS Tax Table Entries Table contains the definitions of the tax ranges for each tax plan
Tax Plan Tax table ID as referenced in item records
Range Indicator “H” or “L” indicates whether this is an entry in the Low tax table or is an
entry in the High tax table
Price Group Start Threshold price for identifying a transaction with this tax group
Tax Amount Tax cost for a transaction in this tax group
B.43 Table Name: PSS_Text
Table Column Name Table Column
Datatype
Table Column Null
Option
Table Column Is PK Table Column Is FK
Text_ID int NOT NULL Yes No
Language_ID int NOT NULL Yes Yes
Constant_Name varchar(40) NULL No No
Text varchar(255) NULL No No
PSS_Text Table contains text strings displayed throughout the system in various languages
Text_ID unique identifier for this text entry
Language_ID language ID (from PSS_Language) that this version of this text entry is in
Constant_Name a C++-style identifier for this text entry
Text the text for this text entry in this language
B.44 Table Name: PSS_Unknown_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
Terminal_ID varchar(16) NOT NULL Yes No
Scanned_Datetime datetime NOT NULL Yes No
Customer_ID int NULL No No
Shopping_List_ID int NULL No No