Integration Guide

Table Of Contents
Appendix B
WaveWorks PSS, Integration Guide, 1.10 Page 137
© 2000, Symbol Technologies, Inc. February 1, 2000
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 Yes
Item_ID varchar(20) NOT NULL Yes Yes
Qty int NULL No No
Notes varchar(80) NULL No No
PSS Order List Item Table contains the item information in a customer order
Customer ID identifies customer associated to this order item
Shopping List ID identifies shopping list associated to this order item
Department ID the department which this order is for
Order List ID unique identifier for this quick order list (from PSS_Order_List)
Item ID identifies item in the list
Qty quantity ordered of this item
Notes text field entered via browser screen
B.23 Table Name: PSS_Order_Status
Table Column Name Table Column
Datatype
Table Column Null
Option
Table Column Is PK Table Column Is FK
Order_Status_ID int NOT NULL Yes No
Description varchar(20) NULL No No
PSS Order Status Table contains the allowable order states
Order Status ID status identifier
Description text message corresponding to this status
B.24 Table Name: PSS_POS_Status
Table Column Name Table Column
Datatype
Table Column Null
Option
Table Column Is PK Table Column Is FK
Item_Name varchar(30) NOT NULL Yes No
Instance_Name varchar(100) NOT NULL Yes No
Detection_Time datetime NULL No No
Start_Time datetime NULL No No
End_Time datetime NULL No No
Instance_Value varchar(20) NULL No No
Instance_Description varchar(50) NULL No No
Instance_Data int NULL No No
PSS POS Status Table contains the quick-order list information
Item_Name the type of entry this is (e.g. POSControllerName, PSSItemFile)