E-Commerce User Guide : Appendix A: Detailed description of Sales Host operation : Sales Host processing : ww_tix processing
 
ww_tix processing
 
The ww_tix table is used when the sale text contains information in a <ww_tix> tag. This table is used to take PDF images generated in the printing process of completing the sale and send them to the server. The table is initally populated as follows:
 
ww_tix table field
Initial value
wwtix_id
Unique id for ww_tix record
sale_no
Sale number of the sale that has been completed
num_img
Number of the image being added for this sale
tix_img
The binary data of the PDF file
expires
Empty (unused)
notes
Empty
retrieved
Empty (if the image was retrieved)
ret_date
Empty (gets the date/time when the PDF is retrieved)
ret_ip
Empty (gets the IP address where the PDF was retrieved from)
date_time
Date/time record added
salespoint
Salespoint ID
operator
web operator
fwd_time
Empty
fwd_status
0
fwd_tries
Empty
fwd_orig
Empty
 
These records are forwarded to the server in the same manner as all other forward files used in Sales.