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 130
© 2000, Symbol Technologies, Inc. February 1, 2000
Greeting_Text greeting text to be displayed upon dispensing a terminal to this
customer
Registered_Datetime date/time that this customer was added to PSS
Display_Foodstamp indicates whether this customer is shown foodstamp totals on their
and-held terminal
Special_Customer indicates whether this is a special type of customer (e.g. Queue-
Buster, Price Checker, or Express Shopping-type customer)
Suspend_ID indicates whether this customer is suspended from PSS, and with
which reason code (from PSS_Customer_Suspend_Reason)
Num_Rescans number of rescanned PSS shopping trips for this customer
Group_ID number used for grouping customers (e.g. family cards, etc.)
Num_Rescan_Diffs number of rescanned PSS shopping trips with item count/amount
differences for this customer
Num_Trips_Incomplete number of incomplete PSS shopping trips (started, but never
checked out) for this customer
Total_Trip_Seconds total number of seconds this customer has spent shopping using a
PSS hand-held terminal
First_Trip_Datetime date/time of the first PSS shopping trip for this customer
Last_Incomplete_Datetime date/time of the last incomplete PSS shopping trip for this
customer
Total_Spent total amount this customer has spent using PSS
Last_Rescan_Datetime date/time of the last rescanned shopping trip for this customer
B.8 Table Name: PSS_Customer_Message
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
Message_Nbr int NOT NULL Yes No
Message_Text varchar(255) NULL No No
Start_Datetime datetime NULL No No
End_Datetime datetime NULL No No
PSS Customer Message Table holds messages to be displayed at the start of a shopping trip for
a particular PSS customer.
Customer_ID unique identifier for this customer
Message_Nbr unique identifier for this message for this customer
Message_Text message text to be displayed
Start_Datetime date/time after which this message is to be displayed
End_Datetime date/time after which this message will no longer be displayed
B.9 Table Name: PSS_Customer_Suspend_Reason