Integration Guide

Appendix A
WaveWorks PSS, Integration Guide, 1.10 Page 123
© 2000, Symbol Technologies, Inc. February 1, 2000
PSS_Barcode_Variable_Weight
Barcode_Type: int
Barcode_Prefix: varchar(20)
Barcode_Prefix_Length: int
Item_Start: int
Item_Length: int
Price_Check_Start: int
Price_Check_Length: int
Price_Start: int
Price_Length: int
Price_Or_Weight: char(1)
PSS_POS_Status
Item_Name: varchar(30)
Instance_Name: varchar(100)
Detection_Time: datetime
Start_Time: datetime
End_Time: datetime
Instance_Value: varchar(20)
Instance_Description: varchar(50)
Instance_Data: int
PSS_Message_Log
Msg_Datetime: datetime
Msg_Facility: varchar(64)
Msg_Action: varchar(64)
Msg_Severity: int
Msg_Message: varchar(255)
Msg_Data: int
PSS_EOD
Recvd_Datetime: datetime
Description: varchar(50)
PSS_Shopping_History_Rescan
Customer_ID: int
Shopping_List_ID: int
POS_Price: int
PSS_Price: int
POS_Qty: int
PSS_Qty: int
PSS_Rescan_Level
Rescan_Level: int
Pct: int
Level_Name: varchar(20)
PSS_Rescan_Difference
Difference_Level: int
Difference_Amt: int
Level_Change_Amt: int
PSS_Shopping_History_Activity
Customer_ID: int
Shopping_List_ID: int
Activity_Nbr: int
Activity_Datetime: datetime
Activity_Type: varchar(10)
Activity_Detail: varchar(80)
PSS_Shopping_History_Item
Customer_ID: int
Shopping_List_ID: int
Shopping_Item_ID: int
Barcode: varchar(20)
Item_ID: varchar(20)
Sale_Price: int
Pricing_Method: char(1)
Mix_Match: int
Department_ID: int
Unit_Price: int
Deal_Price: int
Deal_Qty: int
Embedded_Price: char(1)
POS_Price: int
POS_PSA_Flag: char(1)
Exception: char(1)
Tax_Plan: int
PSS_Shopping_History_List
Customer_ID: int
Shopping_List_ID: int
Time_Started: datetime
Time_Ended: datetime
Shopping_List_Status_ID: int
Total: int
Transaction_ID: varchar(25)
Rescanned: char(1)
Terminal_ID: varchar(16)
Scanned_Item_Count: int
Trip_Length_Seconds: int
PSS_System_Setting
Name: varchar(20)
Subname: varchar(20)
Value: varchar(255)
Description: varchar(255)
Unit: varchar(10)
Default_Value: varchar(255)
Editable: char(1)
PSS_System_Message
System_Message_ID: int
Message_Text: varchar(255)
Frequency_Type: int
Month_Of_Year: int
Day_Of_Month: int
Day_Of_Week: int
Hour_Of_Day: int
Minutes_After_Hour: int
Time_Interval: int
Repeat_Count: int
Send_Next_At_Datetime: datetime
PSS_Special_Barcode
Barcode: varchar(20)
Type: int
Description: varchar(50)
PSS_Shopping_Incomplete_List
Customer_ID: int
Shopping_List_ID: int
Time_Started: datetime
Time_Ended: datetime
Shopping_List_Status_ID: int
Total: int
Transaction_ID: varchar(25)
Rescanned: char(1)
Terminal_ID: varchar(16)
Scanned_Item_Count: int
Trip_Length_Seconds: int