Integration Guide

Appendix A
WaveWorks PSS, Integration Guide, 1.10 Page 122
© 2000, Symbol Technologies, Inc. February 1, 2000
PSS_Shopping_Tax
Customer_ID: int
Shopping_List_ID: int
Tax_Plan_ID: int
Amount: int
Tax_Amount: char(18)
PSS_Unknown_Item
Item_ID: varchar(20)
Terminal_ID: varchar(16)
Scanned_Datetime: datetime
Customer_ID: int
Shopping_List_ID: int
PSS_Tax_Table
Tax_Plan_ID: int
Description: varchar(40)
Price_Range_Low: int
Tax_Amount_Low: int
Price_Range_High: int
Tax_Amount_High: int
First_Tax_Flag: char(1)
PSS_Tax_Table_Entry
Tax_Plan_ID: int
Range_Indicator: char(1)
Price_Group_Start: int
Tax_Amount: int
PSS_Shopping_Activity
Customer_ID: int
Shopping_List_ID: int
Activity_Nbr: int
Activity_Datetime: datetime
Activity_Type: varchar(10)
Activity_Detail: varchar(80)
PSS_Shopping_Item
Customer_ID: int
Shopping_List_ID: int
Shopping_Item_ID: int
Barcode: varchar(20)
Item_ID: varchar(20)
Sale_Price: int
Sale_Price_Currency2: int
Pricing_Method: char(1)
Mix_Match: int
Department_ID: int
Unit_Price: int
Deal_Price: int
Deal_Qty: int
Embedded_Price: char(1)
Tax_Plan: int
Currency_ID: int
PSS_Shopping_List
Customer_ID: int
Shopping_List_ID: int
Time_Started: datetime
Time_Ended: datetime
Shopping_List_Status_ID: int
Total: int
Total_Currency_2: int
Transaction_ID: varchar(25)
Rescanned: char(1)
Terminal_ID: varchar(16)
Scanned_Item_Count: int
Trip_Length_Seconds: int
PSS_Session
Terminal_ID: varchar(16)
Customer_ID: int
Shopping_List_ID: int
Customer_Name: varchar(45)
Status: int
Initiating_Customer_ID: int
Initiating_Shopping_List_ID: int
PSS_Item
Item_ID: varchar(20)
Description: varchar(40)
Price: int
Department_ID: int
Class: varchar(20)
Subclass: varchar(20)
Manufacturer_ID: int
Aisle: varchar(10)
Shelf: varchar(10)
Unit: varchar(10)
Weight: varchar(20)
Linkcode: varchar(20)
Pricing_Method: char(1)
Mix_Match: int
Foodstamp: char(1)
Flags: int
Deal_Price: int
Deal_Qty: int
Tax_Plan: int
POS_Item_Flag: char(1)
Currency_ID: int
PSS_Department
Department_ID: int
Department_Name: varchar(40)
Department_Type: varchar(10)
Allow_Quick_Order: char(1)
PSS_Order_List
Customer_ID: int
Shopping_List_ID: int
Department_ID: int
Order_List_ID: int
Order_Status_ID: int
PSS_Order_List_Item
Customer_ID: int
Shopping_List_ID: int
Department_ID: int
Order_List_ID: int
Item_ID: varchar(20)
Qty: int
Notes: varchar(80)
PSS_Order_Status
Order_Status_ID: int
Description: varchar(20)
PSS_Shopping_List_Status
Shopping_List_Status_ID: int
Description: varchar(20)
PSS_Manufacturer
Manufacturer_ID: int
Manufacturer_Name: varchar(20)