Integration Guide

Appendix A
WaveWorks PSS, Integration Guide, 1.10 Page 124
© 2000, Symbol Technologies, Inc. February 1, 2000
UMS_Power
Power_ID: int
Description: varchar(50)
Status_Code: int
Status_Datetime: datetime
Power_Notes: varchar(40)
UMS_Cradle
Cradle_ID: varchar(4)
Power_ID: int
Dispenser_ID: varchar(4)
Status_Code: int
Status_Datetime: datetime
Cradle_Notes: varchar(40)
Default_Interface: varchar(40)
UMS_Terminal_Types
Terminal_Type: varchar(8)
Terminal_Class: varchar(50)
Default_Interface: varchar(40)
Display_Rows: int
Display_Cols: int
Keypad_Type: int
UMS_Status_Codes
Status_Code: int
Status_Text: varchar(30)
UMS_Terminal
Terminal_ID: varchar(16)
Cradle_ID: varchar(4)
Status_Code: int
Status_Datetime: datetime
Battery_Level: int
Battery_Datetime: int
Terminal_Type: varchar(8)
Good_Scans: int
Bad_Scans: int
Seconds_Used: int
Tot_Issue_Count: int
Tot_Good_Scans: int
Tot_Bad_Scans: int
Tot_Seconds_Used: int
Timeout_Count: int
Current_Interface: varchar(50)
Dispenser_ID: varchar(4)
Terminal_Notes: varchar(40)
Battery_Status: int
UMS_Printer
Printer_ID: int
Description: varchar(50)
Printer_Type: int
Printer_Port: varchar(8)
Status_Code: int
Status_Datetime: datetime
Backup_ID: int
Current_Mode: int
Hardware_ID: varchar(16)
Printer_Notes: varchar(40)
Paper_Remaining: int
UMS_Entrance
Entrance_ID: int
Description: varchar(50)
Reader_Type: int
Reader_Port: varchar(8)
Status_Code: int
Status_Datetime: datetime
Display_Type: int
Display_Port: varchar(8)
Default_Mode: int
Current_Mode: int
Backup_ID: int
Hardware_ID: varchar(16)
Reader_Status: int
Display_Status: int
Entrance_Notes: varchar(40)
UMS_Dispenser
Dispenser_ID: varchar(4)
Dispenser_Name: varchar(50)
Entrance_ID: int
Printer_ID: int
Default_Entrance: int
Status_Code: int
Status_Datetime: datetime
Default_Printer: int
Current_Mode: int
UMS_Card_Reader_Type
Reader_Type: int
Description: varchar(50)
Card_Sentinel: varchar(5)
Card_Offset: int
End_Sentinel: varchar(5)