Integration Guide

Appendix B
WaveWorks PSS, Integration Guide, 1.10 Page 131
© 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
Suspend_ID Int NOT NULL Yes No
Suspend_Reason Varchar(80) NULL No No
PSS Customer Suspend Reason Table holds the Suspend ID reason codes for which a
customer may be suspended from using PSS.
Suspend_ID unique identifier for this suspend reason code
Suspend_Reason text description of this suspend reason code
B.10 Table Name: PSS_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 No
Department_Name Varchar(40) NULL No No
Department_Type Varchar(10) NULL No No
Allow_Quick_Order char(1) NULL No No
PSS Department Table contains the data describing a store’s departments
Department ID Unique identifier for a department
Department Name text name of department
Department Type text type of department (meant to provide particular functionality for
departments that require universal functionality, i.e. functionality
particular to all deli’s)
Allow Quick Order when set, this department shows up in the quick order department list
B.11 Table Name: PSS_EOD
Table Column Name Table Column
Datatype
Table Column Null
Option
Table Column Is PK Table Column Is FK
Recvd_Datetime Datetime NOT NULL Yes No
Description varchar(50) NULL No No
PSS EOD Table contains the End-Of-Day indicators received from the POS.
Recvd_Datetime date/time when this End-Of-Day indicator was received
Description description of this End-Of-Day indicator