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 140
© 2000, Symbol Technologies, Inc. February 1, 2000
B.29 Table Name: PSS_Shopping_History_Activity
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
Activity_Nbr Int NOT NULL Yes No
Activity_Datetime Datetime NULL No No
Activity_Type Varchar(10) NULL No No
Activity_Detail Varchar(80) NULL No No
PSS Shopping History Activity Table contains activities that occurred on the hand-held
terminal during a historical shopping trip, including addition/removal of items, marketing
messages displayed on the terminal, etc.
Customer ID identifies the customer (from PSS_Customer)
Shopping List ID identifies shopping list (from PSS_Shopping_List)
Activity Nbr a sequential number showing the order in which the events occurred
Activity Datetime the date and time of the activity
Activity Type the type of activity which occurred (i.e. ADDITEM, DELITEM, etc.)
Activity Detail a description of the activity which occurred