Integration Guide

Appendix B
WaveWorks PSS, Integration Guide, 1.10 Page 133
© 2000, Symbol Technologies, Inc. February 1, 2000
POS_Item_Flag indicates whether this item has been processed through the POS during the
current download process
Currency_ID currency identifier for the currency in which this items price is described
(from PSS_Currency)
B.13 Table Name: PSS_Language
Table Column Name Table Column
Datatype
Table Column Null
Option
Table Column Is PK Table Column Is FK
Language_ID Int NOT NULL Yes No
Language_Name Varchar(20) NULL No No
PSS Language Table holds the languages supported by the system
Language ID unique identifier for a language
Language Name text name of language
B.14 Table Name: PSS_Manufacturer
Table Column Name Table Column
Datatype
Table Column Null
Option
Table Column Is PK Table Column Is FK
Manufacturer_ID int NOT NULL Yes No
Manufacturer_Name varchar(20) NULL No No
PSS Manufacturer Table holds the manufacturers for PSS items
Manufacturer ID unique identifier for a manufacturer
Manufacturer Name text name of manufacturer
B.15 Table Name: PSS_Marketing_Department
Table Column Name Table Column
Datatype
Table Column Null
Option
Table Column Is PK Table Column Is FK
Department_ID int NOT NULL Yes Yes
Language_ID int NOT NULL Yes Yes
Message_Text varchar(255) NULL No No
Target_Coupon_Amt int NULL No No
Target_Rank int NULL No No
Start_Datetime datetime NULL No No
End_Datetime datetime NULL No No
PSS Marketing Department Table contains the marketing messages for particular departments
Department ID unique department identifier (from PSS_Department)