Integration Guide

Appendix B
WaveWorks PSS, Integration Guide, 1.10 Page 136
© 2000, Symbol Technologies, Inc. February 1, 2000
B.20 Table Name: PSS_Opening_Message
Table Column Name Table Column
Datatype
Table Column Null
Option
Table Column Is PK Table Column Is FK
Msg_ID Int NOT NULL Yes No
Sequence Int NOT NULL Yes No
Language_ID Int NOT NULL Yes Yes
Message Varchar(20) NULL No No
Start_Datetime Datetime NULL No No
End_Datetime Datetime NULL No No
Target_Rank Int NULL No No
PSS Opening Message Table holds messages that the customer may scroll through at the start
of a shopping trip
Msg_ID unique identifier for this message
Sequence sequence number for this line of this message
Language_ID the language this message is in (from PSS_Language)
Message the message text for this line
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
Target_Rank the customer rank level targeted by this message
B.21 Table Name: PSS_Order_List
Table Column Name Table Column
Datatype
Table Column Null
Option
Table Column Is PK Table Column Is FK
Customer_ID Int NOT NULL Yes Yes
Shopping_List_ID Int NOT NULL Yes Yes
Department_ID Int NOT NULL Yes Yes
Order_List_ID Int NOT NULL Yes No
Order_Status_ID Int NULL No Yes
PSS Order List Table contains the quick-order list information
Customer ID identifies customer associated with this order (from PSS_Customer)
Shopping List ID identifies the customer shopping list associated with this order (from
PSS_Shopping_List)
Department ID the department which this order is for (from PSS_Department)
Order List ID unique identifier for this quick order list
Order Status ID status of this order (from PSS_Order_Status, e.g. ready, picked up, etc.)
B.22 Table Name: PSS_Order_List_Item