System information

tb_invoice_entries:
Id: autoincrement database primary key
Invoiceid: foreign key to tb_invoices
datum: record insert date
description: product description with code
fromdate: billing period if applied
todate: billing period if applied
Ammount: ammount
AmmountName: name of the amount (minute)
AmmountPrice: unit price (net)
The emmitent (company) settings are stored in the tb_providers table. Only one company entry can be stored (conform to Hungarian laws). Once the
company details are inserted to the database, the company name cannot be changed anymore.
4.5.9. Environment variables
Creditelapseunit: prepaid credits will be elapsed automatically after this period is elapsed. Creditelapseunit means the credit amount for 1 day. For
example if you set it to 40 and the user will buy 5000 ft credit, than it will elapse after 4 month
Currency: the currency type is loaded from the “currency” global configuration or from the billed user currency setting.
The price setup currency settings also can affect the currency settings.
Currency conversions: if the pricelist is not in the native currency format (set by the “currency” global config option), than the server can convert to it
automatically based on tb_currencies. You can change the conversion rates from MManage -> Billing -> Currency converter
Language: the invoice language can be controlled from the invoice form.
PDF Printer and delay: set this on MManage -> Menu-> Options
Time format: if to separe duration values to day/hour/min/sec or display only in seconds. (MManage -> Menu-> Options)
Money precision and rounding and separator are stored in the tb_currency_precizion table, accessible from the Billing form.
MINSPEACHLENONROUTE: the minimum calculated max speechlength when the call will be routed
4.5.10. Payments
There are various built-in prepaid and postpaid payment method implemented. Payments are tracked in the tb_invoices table and can be queried later for
statistics and reports (Billing -> Reports form)
All credit changes for prepaid users should be logged in this user. Never modify the credit directly. Use the “Modify” button from Users and device ->
Billing page if direct modification is required.
Invoices for postpaid user can be generated from the Billing -> Invoices