Integration Guide
Table Of Contents
- I
- Introduction
- Architecture Overview
- Hardware Requirements
- PSS Software Installation
- Install NT 4.0 Server
- Install the NT 4 Service Pack
- Install Internet Explorer 4.01 Service Pack 2
- NT Option Pack Install
- Install the Video Driver
- Create and Format the Database partition
- Desktop Cleanup (optional)
- Install Microsoft SQL Server 7
- Create and Configure the PSS Database
- Install Microsoft Access
- Internet Explorer 5.0 with Task Scheduler install
- Install WaveWorks
- Install PSS Runtime System
- Install Waveworks Development Studio
- Install PSS Development System
- TFTP Configuration
- DHCP Configuration
- Create an ODBC Data Source
- Load Initial Data
- MS IIS Configuration
- Obtaining Access to PSS System Administration Screens
- Configure Task Scheduler
- Configure Unit Management
- Configure Licensing
- Configure the NBQMAIN Service (IBM 4690 POS Only)
- Setup NT System Log
- Configuration of the PSS System
- Validation of System Operation
- Directory Listing of PSS Folders/Files
- Software Description
- _
- Hardware Overview
- Software Components
- Database Access
- Start of Shopping Trip Processing
- Shopping Trip Processing
- End of Shopping Trip Processing
- Shopping Trip Message Log Entries
- Fatal Messages:
- PSSTransactionFile Processing
- POS Transaction File Processing
- Item Record File Processing
- Customer Update File Processing
- PSS Services
- _
- Customizing the PSS System Software
- Custom DisplayServer Scripts
- Custom Services
- Custom Business Objects
- User Exit DLL
- Available User Exit Functions
- UE_PreProcessItemFile
- UE_PreProcessItemRecord
- UE_PostProcessItemRecord
- UE_PostProcessItemFile
- UE_PreProcessTaxFile
- UE_PostProcessTaxFile
- UE_PreProcessPOSTransFile
- UE_PreProcessPOSTransRecord
- UE_PostProcessPOSTransRecord
- UE_ProcessEODRecord
- UE_PostProcessPOSTransFile
- UE_PreProcessPSSTransFile
- UE_PreProcessPSSTransRecord
- UE_PostProcessPSSTransFile
- UE_CalculateItemPrice_Method10to20
- UE_RescanLevelCalculation
- UE_Pre-RescanDetermination
- UE_PostRescanDetermination
- UE_PreProcessMarketingMessage
- UE_LoginAuthorization
- System Administration Interface
- Specific Features
Appendix B
WaveWorks PSS, Integration Guide, 1.10 Page 137
© 2000, Symbol Technologies, Inc. February 1, 2000
Table Column Name Table Column
Datatype
Table Column Null
Option
Table Column Is PK Table Column Is FK
Customer_ID int NOT NULL Yes Yes
Shopping_List_ID int NOT NULL Yes Yes
Department_ID int NOT NULL Yes Yes
Order_List_ID int NOT NULL Yes Yes
Item_ID varchar(20) NOT NULL Yes Yes
Qty int NULL No No
Notes varchar(80) NULL No No
PSS Order List Item Table contains the item information in a customer order
Customer ID identifies customer associated to this order item
Shopping List ID identifies shopping list associated to this order item
Department ID the department which this order is for
Order List ID unique identifier for this quick order list (from PSS_Order_List)
Item ID identifies item in the list
Qty quantity ordered of this item
Notes text field entered via browser screen
B.23 Table Name: PSS_Order_Status
Table Column Name Table Column
Datatype
Table Column Null
Option
Table Column Is PK Table Column Is FK
Order_Status_ID int NOT NULL Yes No
Description varchar(20) NULL No No
PSS Order Status Table contains the allowable order states
Order Status ID status identifier
Description text message corresponding to this status
B.24 Table Name: PSS_POS_Status
Table Column Name Table Column
Datatype
Table Column Null
Option
Table Column Is PK Table Column Is FK
Item_Name varchar(30) NOT NULL Yes No
Instance_Name varchar(100) NOT NULL Yes No
Detection_Time datetime NULL No No
Start_Time datetime NULL No No
End_Time datetime NULL No No
Instance_Value varchar(20) NULL No No
Instance_Description varchar(50) NULL No No
Instance_Data int NULL No No
PSS POS Status Table contains the quick-order list information
Item_Name the type of entry this is (e.g. POSControllerName, PSSItemFile)