Custom field definitions for the Internet Charging module

The Internet Charging module stores transaction data in the custom_transactions table of the Pharos Database.

The following data is stored:

transaction_id ID number linking to the Transactions table
custom_transaction_type Internet Time (fixed value)
terminal_name Not used
data_float1 Charged amount in dollars
data_float2 Not used
data_integer1 Session duration in seconds
data_integer2 Not used
data_string1 Machine name
data_string2 User name
data_string3 Date-time in the following format: yyyymmddhhnnss
data_string4 Not used