Customer Commissions

08-25-2026 22:40:38 SQL Statement: SELECT t.id, t.bill_start, t.bill_end, t.total_monthly_cost, t.grand_total_cost, t.customer_id, t.customer_account_number, t.customer_first_name, t.customer_last_name, t.customer_company_name, t.agent_bill_id, t.agent_bill_commission_recipient_id, t.agent_bill_monthly_bill_id, t.agent_bill_commission_type, t.agent_bill_commission_rate, t.agent_bill_commission_amount, t.agent_bill_paid, t.agent_bill_pay_date, t.agent_bill_commissionable_total, t.agent_bill_commission_pay, t.agent_id, t.agent_active, t.agent_first_name, t.agent_last_name, t.agent_company_name, t.agent_phone, t.agent_address1, t.agent_address2, t.agent_city, t.agent_state, t.agent_zip, t.agent_notes, t.agent_tax_id, t.agent_ssn, t.salesrep_bill_id, t.salesrep_bill_commission_recipient_id, t.salesrep_bill_monthly_bill_id, t.salesrep_bill_commission_type, t.salesrep_bill_commission_rate, t.salesrep_bill_commission_amount, t.salesrep_bill_paid, t.salesrep_bill_pay_date, t.salesrep_bill_commissionable_total, t.salesrep_bill_commission_pay, t.salesrep_id, t.salesrep_active, t.salesrep_first_name, t.salesrep_last_name, t.salesrep_company_name, t.salesrep_phone, t.salesrep_address1, t.salesrep_address2, t.salesrep_city, t.salesrep_state, t.salesrep_zip, t.salesrep_notes, t.salesrep_tax_id, t.salesrep_ssn, t.salesmanager_bill_id, t.salesmanager_bill_commission_recipient_id, t.salesmanager_bill_monthly_bill_id, t.salesmanager_bill_commission_type, t.salesmanager_bill_commission_rate, t.salesmanager_bill_commission_amount, t.salesmanager_bill_paid, t.salesmanager_bill_pay_date, t.salesmanager_bill_commissionable_total, t.salesmanager_bill_commission_pay, t.salesmanager_id, t.salesmanager_active, t.salesmanager_first_name, t.salesmanager_last_name, t.salesmanager_company_name, t.salesmanager_phone, t.salesmanager_address1, t.salesmanager_address2, t.salesmanager_city, t.salesmanager_state, t.salesmanager_zip, t.salesmanager_notes, t.salesmanager_tax_id, t.salesmanager_ssn FROM (SELECT bill.id AS id, bill.bill_start AS bill_start, bill.bill_end AS bill_end, bill.total_monthly_cost AS total_monthly_cost, bill.grand_total_cost AS grand_total_cost, c.id AS customer_id, c.account_number AS customer_account_number, c.first_name AS customer_first_name, c.last_name AS customer_last_name, c.company_name AS customer_company_name, agent_bill.id AS agent_bill_id, agent_bill.commission_recipient_id AS agent_bill_commission_recipient_id, agent_bill.monthly_bill_id AS agent_bill_monthly_bill_id, agent_bill.commission_type AS agent_bill_commission_type, agent_bill.commission_rate AS agent_bill_commission_rate, agent_bill.commission_amount AS agent_bill_commission_amount, agent_bill.paid AS agent_bill_paid, agent_bill.pay_date AS agent_bill_pay_date, agent_bill.commissionable_total AS agent_bill_commissionable_total, agent_bill.commission_pay AS agent_bill_commission_pay, agent.id AS agent_id, agent.active AS agent_active, agent.first_name AS agent_first_name, agent.last_name AS agent_last_name, agent.company_name AS agent_company_name, agent.phone AS agent_phone, agent.address1 AS agent_address1, agent.address2 AS agent_address2, agent.city AS agent_city, agent.state AS agent_state, agent.zip AS agent_zip, agent.notes AS agent_notes, agent.tax_id AS agent_tax_id, agent.ssn AS agent_ssn, salesrep_bill.id AS salesrep_bill_id, salesrep_bill.commission_recipient_id AS salesrep_bill_commission_recipient_id, salesrep_bill.monthly_bill_id AS salesrep_bill_monthly_bill_id, salesrep_bill.commission_type AS salesrep_bill_commission_type, salesrep_bill.commission_rate AS salesrep_bill_commission_rate, salesrep_bill.commission_amount AS salesrep_bill_commission_amount, salesrep_bill.paid AS salesrep_bill_paid, salesrep_bill.pay_date AS salesrep_bill_pay_date, salesrep_bill.commissionable_total AS salesrep_bill_commissionable_total, salesrep_bill.commission_pay AS salesrep_bill_commission_pay, salesrep.id AS salesrep_id, salesrep.active AS salesrep_active, salesrep.first_name AS salesrep_first_name, salesrep.last_name AS salesrep_last_name, salesrep.company_name AS salesrep_company_name, salesrep.phone AS salesrep_phone, salesrep.address1 AS salesrep_address1, salesrep.address2 AS salesrep_address2, salesrep.city AS salesrep_city, salesrep.state AS salesrep_state, salesrep.zip AS salesrep_zip, salesrep.notes AS salesrep_notes, salesrep.tax_id AS salesrep_tax_id, salesrep.ssn AS salesrep_ssn, salesmanager_bill.id AS salesmanager_bill_id, salesmanager_bill.commission_recipient_id AS salesmanager_bill_commission_recipient_id, salesmanager_bill.monthly_bill_id AS salesmanager_bill_monthly_bill_id, salesmanager_bill.commission_type AS salesmanager_bill_commission_type, salesmanager_bill.commission_rate AS salesmanager_bill_commission_rate, salesmanager_bill.commission_amount AS salesmanager_bill_commission_amount, salesmanager_bill.paid AS salesmanager_bill_paid, salesmanager_bill.pay_date AS salesmanager_bill_pay_date, salesmanager_bill.commissionable_total AS salesmanager_bill_commissionable_total, salesmanager_bill.commission_pay AS salesmanager_bill_commission_pay, salesmanager.id AS salesmanager_id, salesmanager.active AS salesmanager_active, salesmanager.first_name AS salesmanager_first_name, salesmanager.last_name AS salesmanager_last_name, salesmanager.company_name AS salesmanager_company_name, salesmanager.phone AS salesmanager_phone, salesmanager.address1 AS salesmanager_address1, salesmanager.address2 AS salesmanager_address2, salesmanager.city AS salesmanager_city, salesmanager.state AS salesmanager_state, salesmanager.zip AS salesmanager_zip, salesmanager.notes AS salesmanager_notes, salesmanager.tax_id AS salesmanager_tax_id, salesmanager.ssn AS salesmanager_ssn FROM monthly_bill_charges bill LEFT JOIN customer c ON c.id = bill.customer_id LEFT JOIN commission_agent_bill agent_bill ON agent_bill.monthly_bill_id = bill.id LEFT JOIN commission_contact agent ON agent.id = agent_bill.commission_recipient_id LEFT JOIN commission_salesrep_bill salesrep_bill ON salesrep_bill.monthly_bill_id = bill.id LEFT JOIN commission_contact salesrep ON salesrep.id = salesrep_bill.commission_recipient_id LEFT JOIN commission_salesmanager_bill salesmanager_bill ON salesmanager_bill.monthly_bill_id = bill.id LEFT JOIN commission_contact salesmanager ON salesmanager.id = salesmanager_bill.commission_recipient_id) AS t WHERE t.customer_id = '12' ORDER BY t.bill_end