Integration Guide

Appendix B
WaveWorks PSS, Integration Guide, 1.10 Page 127
© 2000, Symbol Technologies, Inc. February 1, 2000
Privilege_Mask varchar(255) NULL No No
Login_Failures int NULL No No
Last_IP varchar(16) NULL No No
Language_ID int NULL No Yes
PSS Admin User Table holds information about Service Terminal Users
Username the username this Administrative User will log in as
Full_Name the full name of this Administrative User
Password the password this Administrative User will use to log in
Valid_Datetime the date/time this Administrative User account is active
Expires_Datetime the date/time this Administrative User account is no longer active
Privilege_Level the privilege level of this Administrative User
Privilege_Mask the privilege mask for this Administrative User (currently unused)
Login_Failures number of failures since the last successful login for this Administrative
User
Last_IP the last IP address from which this Administrative User last accessed their
account
Language_ID the language (from PSS_Language) in which this Administrative User
prefers to view the service terminal
B.5 Table Name: PSS_Barcode_Variable_Weight
Table Column Name Table Column
Datatype
Table Column Null
Option
Table Column Is PK Table Column Is FK
Barcode_Type int NOT NULL No No
Barcode_Prefix varchar(20) NULL No No
Barcode_Prefix_Length int NULL No No
Item_Start int NULL No No
Item_Length int NULL No No
Price_Check_Start int NULL No No
Price_Check_Length int NULL No No
Price_Start int NULL No No
Price_Length int NULL No No
Price_Or_Weight char(1) NULL No No
PSS Barcode Variable Weight Table holds configuration information for price or weight-
embedded barcodes
Barcode_Type Type of Barcode (unknown, UPC, EAN, etc.)
Barcode_Prefix Sequence of digits starting the embedded barcode
Barcode_Prefix_Length Length of prefix
Item_Start Position of start of item code
Item_Length Length of item code
Price_Check_Start Position of price check digit
Price_Check_Length Length of price check digit(s)
Price_Start Position of price
Price_Length Length of price
Price_Or_Weight Indicates whether barcode is Price or Weight embedded