System information

tb_portednumbers:
id: autoincrement database primary key
number: original (normalized) called (B) number
providerpx: new prefix (for example instead of 3630 changed to 3620)
newnumber: the changed number
newdomain: the new service provider ip or domain
newport: service port (defaults to 5060)
priority: checked for duplicate numbers
datum: record insertion date
You must have the providerpx OR newnumber OR newdomain: newport specified.
If the newnumber is set, than the providerpx has no effect.
4.5. Billing
Mizu Servers and Gateways has built-in prepaid and postpaid billing.
The pricing must be set from MManage –Prices Settings form
You can list and compare the prices for different directions in the Price List.
The Billing and Invoice generation are done from the “Billing” form.
The Billing module conforms to the Hungarian laws and can be modified to fit for other countries.
4.5.1. Price Settings
Pricing of the CDR records are done after the prices defined on this form.
You can define “Price Groups”. All price settings that belong together after some logic (enduser prices for example). This is located in the left side of the
Prices form.
Invoices can be generated automatically by the server and send by email, or can be loaded manually by using the “Billing” form.
You can schedule when to send the invoice or report to the partner or for you (defined by the mailto entry)
The report format can be defined by “Invoice Type” and “Group by” fields.
Below a “Price Group” you can have several Price Setups named “Directions” or “Packets” (the middle column in the form)
For example “Traffic from MizuTech SRL” or “Traffic to T-Mobile direction”
Here you have to set up the actual prices. The price setup is further divided into different prefixes (the right side of the form -Pricelist), because it is very
common that you have lots of directions in a provider pricelist.
An alternative method to assign a price list to a user is by using the “Users and devices” from -> “Billing” tab -> “Billing packet” setting. This will always
take precedence over the packets set in the “Price Settings” middle column. This is used to simplify the pricelist assignment for users by resellers.