Integration Guide

Appendix B
WaveWorks PSS, Integration Guide, 1.10 Page 128
© 2000, Symbol Technologies, Inc. February 1, 2000
B.6 Table Name: PSS_Currency
Table Column Name Table Column
Datatype
Table Column Null
Option
Table Column Is PK Table Column Is FK
Currency_ID int NOT NULL Yes No
Currency_Name varchar(20) NULL No No
Exchange_Rate real NULL No No
Num_Decimal_Digits int NULL No No
Decimal_Char char(1) NULL No No
Thousands_Char char(1) NULL No No
Currency_Symbol char(1) NULL No No
Use_Curr_Symbol char(1) NULL No No
Price_Times_Factor int NULL No No
Currency_Symbol2 char(1) NULL No No
Currency_Symbol_Web char(1) NULL No No
PSS Currency Table holds the supported currency types and conversion rates
Currency ID Unique ID associated with this currency
Currency Name text name of currency
Exchange Rate exchange rate with base currency
Num_Decimal_Digits number of digits in the stored integer value that are decimal digits
Decimal_Char character used to delineate the decimal portion
Thousands_Char character used to delineate groups of three decimal digits
Currency_Symbol currency symbol used for display on hand-held terminals
Use_Curr_Symbol indicates whether the currency symbol should be used in display
Price_Times_Factor amount that a stored value should be multiplied by to arrive at a
displayable value
Currency_Symbol2 currency symbol used for display on printed transaction tickets
Currency_Symbol_Web currency symbol used for display on service terminal pages
B.7 Table Name: PSS_Customer
Table Column Name Table Column
Datatype
Table Column Null
Option
Table Column Is PK Table Column Is FK
Customer_ID int NOT NULL Yes No
Card_Number varchar(30) NOT NULL No No
First_Name varchar(40) NULL No No
Middle_Name varchar(40) NULL No No
Last_Name varchar(40) NULL No No
Address varchar(40) NULL No No
Address2 varchar(40) NULL No No
City varchar(40) NULL No No
State varchar(40) NULL No No
Postal_Code varchar(20) NULL No No
Country varchar(40) NULL No No
Allow_Promotions char(1) NULL No No
Allow_Checks char(1) NULL No No