Integration Guide

Table Of Contents
Appendix B
WaveWorks PSS, Integration Guide, 1.10 Page 151
© 2000, Symbol Technologies, Inc. February 1, 2000
PSS_Unknown_Item Table contains items scanned during shopping trips for which no
matching item could be found in PSS_Item
Item_ID the barcode as returned by the scanner
Terminal_ID the Terminal ID (from UMS_Terminal) that scanned this item
Scanned_Datetime date/time that this item was scanned
Customer_ID the customer ID (from PSS_Customer) that scanned this item
Shopping_List_ID the shopping list ID (from PSS_Shopping_List) of the list that this item
was to be added to
B.45 Table Name: UMS_Card_Reader_Type
Table Column Name Table Column
Datatype
Table Column Null
Option
Table Column Is PK Table Column Is FK
Reader_Type Int NOT NULL Yes No
Description Varchar(50) NULL No No
Card_Sentinel varchar(5) NULL No No
Card_Offset int NULL No No
End_Sentinel varchar(5) NULL No No
UMS_Card_Reader_Type Table contains definitions of the various types of card reading
hardware used by the system
Reader_Type a unique identifier for the type of card reader hardware for this entry
Description the description of this card reader
Card_Sentinel the sentinel character(s) that mark the start of the card number
Card_Offset the number of characters after the first character of the start sentinel before
the card number begins
End_Sentinel the sentinel character(s) that mark the end of the card number