multiSwitch – user manual
© TOPEX 2008 49
7.9 Data Base Billing
TOPEX multiSwitch equipment support three types of data base PostGre SQL, MySQL and
Microsoft SQL. Each variant of data base must be configured according to the corresponding
parameters.
The number of fields from billing is variable and can be configured from the “
exec.cfg
”
configuration file. By default in billing are written the first 43 fields. The specified value must be
displayed in telnet at the command “
billing fields number
”. If the number of fields is 255 then all the
billing fields are exported.
The order of billing fields is presented below:
1. type
17. source signaling IP
33. ptime
2. source transcoding port
18. source signaling PORT
34. client id out
3. ANI in
19. source RTP IP
35. gw_name
4. DNIS in
20. source RTP port
36. ANI out
5. date
21. destination IP
37. DNIS out
6. time
22. destination port
38. original ANI
7. call duration
23. destination RTP IP
39. connected DNIS
8. billing units
24. destination RTP port
40. in_billing_profileid
9. SIM used
25. call session id
41. out_billing_profileid
10. destination transcoding
port
26. packet loss
42. in_classid
11. release cause
27. jitter
43. out_classid
12. release Q850 code
28. client id in
44. billing_prefix
13. CIMI
29. class name out
45. price_in
14. call selection time
30. protocol_in
15. GSM cell
31. protocol_out
16. class name in
32. codec