Startup check
At startup, Sales Host makes a call to the server for all ww_sales records matching its SalesPoint ID and with a fwd_status of 1. Any ww_sales record on the server, so marked, exists locally at the salespoint. If a ww_sales record is found on the server which it doesn't have locally, the record is written into the local ww_sales table. The fwd_status is marked locally as follows:
fwd_status code in ww_sales table | Description |
0 | If the result field is empty (it is unprocessed) |
4 | If there is no sale_no filled in (the result field presumably has the error) |
1 | If there is a sale_no filled in |
To prevent the ww_tix table from growing to an unmanageable size, any records with a fwd_status of “2” or “3” is pruned on startup of Sales Host when older than a set number of days (default thirty days). The default number of days may be changed with the .INI setting:
[Preferences]
PruneDaysTickets=number of days
Example:
PruneDaysTickets = 15
This illustrates how to prune records from ww_tix older than fifteen days.