<div dir="ltr">Hi Dario<div><br></div><div>Thanks for the pointer.</div><div><br></div><div>If I am correct nothing looks out of place.</div><div><br></div><div>If you would mind, maybe just confirm also ?</div><div><br></div><div>CDR </div><div>*************************** 1. row ***************************<br> id: 7467<br> update_time: 2024-05-30 00:55:01<br> source_user_id: c5662180-5bdf-459a-beb1-66b86c11e8bf<br> source_provider_id: 1<br> source_external_subscriber_id: <br> source_external_contract_id: QUI001<br> source_account_id: 4<br> source_user: 27100XXXXX<br> source_domain: <a href="http://sip.cloudvoice.co.za">sip.cloudvoice.co.za</a><br> source_cli: 27100XXXXXX<br> source_clir: 0<br> source_ip: 169.XXXXXXXX<br> source_lnp_prefix: <br> source_user_out: 27100XXXXX<br> destination_user_id: 0<br> destination_provider_id: 2<br> destination_external_subscriber_id: <br> destination_external_contract_id: <br> destination_account_id: 0<br> destination_user: 27113221888<br> destination_domain: 105.XXXXXXX<br> destination_user_dialed: 0113221888<br> destination_user_in: 27113221888<br> destination_domain_in: sip.cloudXXXXXXXXXXXXX<br> destination_lnp_prefix: <br> destination_user_out: 27113221888<br> peer_auth_user: <br> peer_auth_realm: <br> call_type: call<br> call_status: ok<br> call_code: 200<br> init_time: 1717022346.054<br> start_time: 1717022347.119<br> duration: 4.224<br> call_id: <a href="mailto:1_2550363646@192.168.0.125">1_2550363646@192.168.0.125</a><br> source_carrier_cost: 0.000000<br> source_reseller_cost: 0.000000<br> source_customer_cost: 19.200000<br> source_carrier_free_time: 0<br> source_reseller_free_time: 0<br> source_customer_free_time: 0<br> source_carrier_billing_fee_id: 1002<br> source_reseller_billing_fee_id: 1000<br> source_customer_billing_fee_id: 1015<br> source_carrier_billing_zone_id: 1001<br> source_reseller_billing_zone_id: 1<br> source_customer_billing_zone_id: 1019<br> destination_carrier_cost: 0.000000<br> destination_reseller_cost: 0.000000<br> destination_customer_cost: 0.000000<br> destination_carrier_free_time: 0<br> destination_reseller_free_time: 0<br> destination_customer_free_time: 0<br> destination_carrier_billing_fee_id: NULL<br> destination_reseller_billing_fee_id: NULL<br> destination_customer_billing_fee_id: NULL<br> destination_carrier_billing_zone_id: NULL<br>destination_reseller_billing_zone_id: NULL<br>destination_customer_billing_zone_id: NULL<br> frag_carrier_onpeak: NULL<br> frag_reseller_onpeak: NULL<br> frag_customer_onpeak: NULL<br> is_fragmented: 0<br> split: 0<br> rated_at: 2024-05-30 00:39:15<br> rating_status: ok<br> exported_at: 2024-05-30 00:55:01<br> export_status: ok<br> source_lnp_type: NULL<br> destination_lnp_type: NULL<br></div><div><br></div><div>Billing Fee</div><div>*************************** 1. row ***************************<br> id: 1015<br> billing_profile_id: 5<br> billing_zone_id: 1020<br> source: .*<br> destination: ^278[1-9]\d{7}.*<br> direction: out<br> type: call<br> onpeak_init_rate: 0.32<br> onpeak_init_interval: 60<br> onpeak_follow_rate: 0.32<br> onpeak_follow_interval: 60<br> offpeak_init_rate: 0.32<br> offpeak_init_interval: 60<br> offpeak_follow_rate: 0.32<br> offpeak_follow_interval: 60<br> onpeak_use_free_time: 0<br> match_mode: regex_longest_pattern<br> onpeak_extra_rate: 0<br> onpeak_extra_second: NULL<br> offpeak_extra_rate: 0<br> offpeak_extra_second: NULL<br> offpeak_use_free_time: 0<br>aoc_pulse_amount_per_message: 0<br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, May 30, 2024 at 4:33 PM Dario Busso <<a href="mailto:dbusso@sipwise.com">dbusso@sipwise.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div>You need to check the rated CDR record in the DB table accounting.cdr, the fee, and the billing profile used to rate the specific CDR.</div><div> Cross-check that the one applied is the one you intended to use.</div><div>Dario<br></div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, May 30, 2024 at 4:14 PM Quinten Rowland <<a href="mailto:quinten.rowland@gmail.com" target="_blank">quinten.rowland@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Hi All <div><br></div><div>Would like to find out if anyone else has encountered the situation where the call rating is rating the calls at a value lower than defined in the billing profile fee's.</div><div><br></div><div>I have a situation where the fee's defined in the billing profile is 0.32 but the cdr's are rated to 0.19.</div><div><br></div><div>Any guidance would be much appreciated.</div><font color="#888888"><div><br></div></font><div><br></div><span class="gmail_signature_prefix">-- </span><br><div dir="ltr" class="gmail_signature"><div dir="ltr">Kind Regards<div>Quinten Rowland</div><div>(+27) 62 318 2874</div></div></div></div>
-- <br>
Spce-user mailing list<br>
<a href="mailto:Spce-user@lists.sipwise.com" target="_blank">Spce-user@lists.sipwise.com</a><br>
<a href="http://lists.sipwise.com/mailman/listinfo/spce-user_lists.sipwise.com" rel="noreferrer" target="_blank">http://lists.sipwise.com/mailman/listinfo/spce-user_lists.sipwise.com</a><br>
</blockquote></div>
</blockquote></div><br clear="all"><div><br></div><span class="gmail_signature_prefix">-- </span><br><div dir="ltr" class="gmail_signature"><div dir="ltr">Kind Regards<div>Quinten Rowland</div><div>(+27) 62 318 2874</div></div></div>