Integration Guide

Table Of Contents
Appendix B
WaveWorks PSS, Integration Guide, 1.10 Page 134
© 2000, Symbol Technologies, Inc. February 1, 2000
Language_ID language that this message is in (from PSS_Language)
Message Text marketing message text
Target Coupon Amt if the message contains a coupon offer, this is the amount of the coupon
Target Rank the customer rank level targeted by this message
Start_Datetime date/time after which this message is to be displayed
End_Datetime date/time after which this message will no longer be displayed
B.16 Table Name: PSS_Marketing_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 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 Item Table contains the marketing messages for particular items
Item ID unique item identifier (from PSS_Item)
Language_ID language that this message is in (from PSS_Language)
Message Text marketing message text
Target Coupon Amt if the message contains a coupon offer, this is the amount of the coupon
Target Rank the customer rank level targeted by this message
Start_Datetime date/time after which this message is to be displayed
End_Datetime date/time after which this message will no longer be displayed
B.17 Table Name: PSS_Marketing_Mfg
Table Column Name Table Column
Datatype
Table Column Null
Option
Table Column Is PK Table Column Is FK
Manufacturer_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 Mfg Table contains the marketing messages for particular manufacturers
Manufacturer ID unique identifier for this manufacturer (from PSS_Manufacturer)
Language_ID language that this message is in (from PSS_Language)
Message Text marketing message text