System information

11: isdngw, (parentid is the gatewayowner)
12: sms, fax,email gateway
14: support users (can operate with MManage, has ftp account)
15: admin users (can see and modify everything, can receive email/sms reports)
17: other users (for various reasons)
ParentID:
This field is very important for resellers/subresellers relationships.
Logical parent of the user. Checked for routing pattern, max lines, etc.
if a sipenduser then reseller company
if traffic sender, then traffic owner
if gateway, then gateway owner
if reseller company, than operator
BillingUserID:
Where the invoices will be sent. Credit will checked for these users
If the current type is an end-user, then can have a BillingUserID where we send the invoices.
If not set or the same ID as the current, than the bills will be generated t
itself. For example in a company, all bills will be sent to the boss (company address), nit the employee
IsBilledUser: set to 1 if this user is not a real service user, but a user who pays for other user. Usually this is a company who pays for its employee.
Deprecated!
UserGroup: users can call each other only if the user group is the same (default: 0)
usually users with the same parentid (reseller) has common parentid
RingGroup: a list of usernames separated by comma (all number will ring when the actual user will be called)
BelongsToCompany: when a company has more then one subscriber. Used for example for short sip numbers.
IsCompany: if the current user actually is a company
RGMode: how to use the ringgroup: 0=forked call, 1=round robin
Name: user first and last –name
Country: sip phone country (important for prefix rules)
ContactName: additional name
UseCallingCard: if has calling card (usable with pin codes)
CanDial: example: for sipuser is 1. for simowners is 0
Phone: user phone number (but not the sip phone)
Email: where the user can be contacted
Address: where the user can be contacted
Billaddress: where to send the invoices
TelNumber: sip telnumber.users can be contacted if we call there username or telnumber.
More than one DID or ANI number can be
assigned for one user. For this the tb_users_othernumbers table is used where the type field is 0 for DID numbers and 1 for
numbers.