<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: Times New Roman; font-size: 12pt; color: #000000'><font size="3">Hi again Richard!!</font><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;"><br></div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">I´ve checked accounting.cdr table and <span style="font-size: 12pt;">source_account_id field of the </span><span style="font-size: 12pt;">contains 22, and the customer_cost field contains the </span><span style="font-size: 12pt;">cost. Here you can see the query with relevant data:</span></div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;"><span style="font-size: 12pt;"><br></span></div><div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">mysql> select * from cdr where source_account_id like "22"\G;</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">*************************** 1. row ***************************</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">id: 52</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">update_time: 2013-03-21 15:03:32</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">source_user_id: 635a08f3-3df3-4559-a6fd-d5e280d9761e</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">source_provider_id: 1</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">source_external_subscriber_id: XXXXXXXX</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">source_external_contract_id: </div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">source_account_id: 22</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">source_user: XXXXXXXXX</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">source_domain: xxx.xxx.es</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">source_cli: 34XXXXXXXXX</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">source_clir: 0</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">source_ip: 192.168.0.24</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">destination_user_id: 43317f99-0859-4e89-a63b-ddf3d9bffb20</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">destination_provider_id: 1</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">destination_external_subscriber_id: XXXXXXXXX</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">destination_external_contract_id: XXXXX</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">destination_account_id: 8</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">destination_user: XXXXXXXXX</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">destination_domain: xxx.xxx.es</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">destination_user_dialed: XXXXXXXXX</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">destination_user_in: XXXXXXXXX</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">destination_domain_in: xxx.xxx.es</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">peer_auth_user:</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">peer_auth_realm:</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">call_type: call</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">call_status: ok</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">call_code: 200</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">init_time: 1363874581.577</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">start_time: 1363874584.840</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">duration: 15.680</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">call_id: OWIzN2RmY2M5M2RlMmFmMWU1MzVhNzkyNTVkNzI2YmM.</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">carrier_cost: 0.00</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">reseller_cost: 0.00</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">customer_cost: 16.50</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">carrier_free_time: 0</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">reseller_free_time: 0</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">customer_free_time: 0</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">carrier_billing_fee_id: NULL</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">reseller_billing_fee_id: NULL</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">customer_billing_fee_id: 7</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">carrier_billing_zone_id: NULL</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">reseller_billing_zone_id: NULL</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">customer_billing_zone_id: 7</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;"> frag_carrier_onpeak: NULL</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">frag_reseller_onpeak: NULL</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">frag_customer_onpeak: NULL</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">is_fragmented: NULL</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">split: 0</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">rated_at: 2013-03-21 15:03:32</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">rating_status: ok</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">exported_at: NULL</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">export_status: unexported</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;"><br></div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;">Jon, I paste the query with \G:</div><div style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt;"><br></div><div><div>mysql> select * from contracts where id = 22\G;</div><div>*************************** 1. row ***************************</div><div> id: 22</div><div> customer_id: NULL</div><div> reseller_id: 1</div><div> contact_id: NULL</div><div> order_id: NULL</div><div> status: active</div><div> external_id: </div><div> modify_timestamp: 2013-03-21 15:02:14</div><div> create_timestamp: 2013-03-21 15:02:14</div><div> activate_timestamp: 2013-03-21 15:02:14</div><div>terminate_timestamp: NULL</div><div>1 row in set (0.00 sec)</div><div><br></div><div>mysql> select * from contract_balances where contract_id = 22\G;</div><div>*************************** 1. row ***************************</div><div> id: 21</div><div> contract_id: 22</div><div> cash_balance: 0</div><div> cash_balance_interval: 0</div><div> free_time_balance: 0</div><div>free_time_balance_interval: 0</div><div> start: 2013-03-01 00:00:00</div><div> end: 2013-03-31 23:59:59</div><div> invoice_id: NULL</div><div>1 row in set (0.00 sec)</div><div><br></div><div>mysql> select * from billing.billing_mappings m, billing.billing_profiles p</div><div> -> where p.id = m.billing_profile_id and m.contract_id = 22\G;</div><div>*************************** 1. row ***************************</div><div> id: 22</div><div> start_date: NULL</div><div> end_date: NULL</div><div> billing_profile_id: 4</div><div> contract_id: 22</div><div> product_id: NULL</div><div> id: 4</div><div> reseller_id: 1</div><div> handle: Tarifa_plana</div><div> name: Tarifa plana</div><div> prepaid: 0</div><div> interval_charge: 0</div><div> interval_free_time: 0</div><div> interval_free_cash: 0</div><div> interval_unit: month</div><div> interval_count: 1</div><div> fraud_interval_limit: 100</div><div> fraud_interval_lock: 3</div><div>fraud_interval_notify: </div><div> fraud_daily_limit: 100</div><div> fraud_daily_lock: 3</div><div> fraud_daily_notify: NULL</div><div> currency: â¬</div><div> vat_rate: 0</div><div> vat_included: 0</div><div>1 row in set (0.00 sec)</div></div></div><div><br></div><div>Thank you very much!!</div></div></body></html>