Commissions for Bill

08-25-2026 23:17:47 SQL Statement: SELECT id, customer_id, bill_start, bill_end, plan_name, plan_term, plan_start, plan_cost, trunk_rate, trunk_quantity, did_rate, did_quantity, tfdid_rate, tfdid_quantity, domestic_inbound_rate, domestic_outbound_rate, tollfree_inbound_rate, rogue_emergency_charge, information_call_charge, phonebook_rate, phonebook_quantity, cnam_lookup_rate, cnam_lookup_quantity, sms_rate, sms_quantity, mms_rate, mms_quantity, smsout_rate, smsout_quantity, emergency_address_rate, emergency_address_entry_quantity, did_setup_rate, did_setup_quantity, tfdid_setup_rate, tfdid_setup_quantity, grand_total_cost, tax_rate, invoiced, billed, cdr_taxed FROM monthly_bill_charges WHERE id = '2227'

08-25-2026 23:17:47 SQL Statement: SELECT id, account_number, company_name, first_name, last_name, status, auto_inactive_enable, inactivation, billing_type, parent, wholesale, child, credit_card_failure, account_manager FROM customer WHERE id = '27'

08-25-2026 23:17:47 SQL Statement: SELECT id, commission_recipient_id, monthly_bill_id, commission_type, commission_rate, commission_amount, paid, pay_date, commissionable_total, commission_pay FROM commission_agent_bill WHERE monthly_bill_id = '2227'

08-25-2026 23:17:47 SQL Statement: SELECT id, commission_recipient_id, monthly_bill_id, commission_type, commission_rate, commission_amount, paid, pay_date, commissionable_total, commission_pay FROM commission_salesrep_bill WHERE monthly_bill_id = '2227'

08-25-2026 23:17:47 SQL Statement: SELECT id, commission_recipient_id, monthly_bill_id, commission_type, commission_rate, commission_amount, paid, pay_date, commissionable_total, commission_pay FROM commission_salesmanager_bill WHERE monthly_bill_id = '2227'

08-25-2026 23:17:47 SQL Statement: SELECT id, active, first_name, last_name, company_name, phone, address1, address2, city, state, zip, notes, tax_id, ssn FROM commission_contact WHERE active = '1' ORDER BY last_name