Integration Guide

Appendix B
WaveWorks PSS, Integration Guide, 1.10 Page 149
© 2000, Symbol Technologies, Inc. February 1, 2000
B.40 Table Name: PSS_System_Setting
Table Column Name Table Column
Datatype
Table Column Null
Option
Table Column Is PK Table Column Is FK
Name Varchar(20) NOT NULL Yes No
Subname Varchar(20) NOT NULL Yes No
Value Varchar(255) NULL No No
Description varchar(255) NULL No No
Unit varchar(10) NULL No No
Default_Value varchar(255) NULL No No
Editable char(1) NULL No No
PSS System Setting Table contains system-wide configuration settings
Name the configuration option name
Subname the component name within the given configuration option name
Value the data associated with this configuration setting
Description the description of this system setting
Unit the unit of measure for this system setting
Default_Value the default Value for this system setting
Editable indicates whether this system setting is editable from the System Setting
web page
B.41 Table Name: PSS_Tax_Table
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 No
Description varchar(40) NULL No No
Price_Range_Low int NULL No No
Tax_Amount_Low int NULL No No
Price_Range_High int NULL No No
Tax_Amount_High int NULL No No
First_Tax_Flag char(1) NULL No No
PSS Tax Table Table contains the definitions of the possible tax plans for this location
TaxPlan Taxtable ID as referenced in item records
Description Identifies type of tax (State, Federal , Excise, …)
PriceRangeLow Transaction price below which the Low Tax table is used
TaxAmountLow Tax cost for a transaction with price equal to PriceRangeLow
PriceRangeHigh Price range that corresponds to TaxAmountHigh. Transaction price is
divided by this amount to determine the number of TaxAmountHigh
increments to charge. Any remainder is computed by lookup in the High
Tax Table for the Tax Plan.
TaxAmountHigh Tax cost for each PriceRangeHigh increment.
First_Tax_Flag indicates whether tax is collected on the first tax range.