Commission Bills

08-25-2026 21:53:50 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 id = '5'

08-25-2026 21:53:50 SQL Statement: SELECT t.id, t.commission_recipient_id, t.monthly_bill_id, t.commission_type, t.commission_rate, t.commission_amount, t.paid, t.pay_date, t.commissionable_total, t.commission_pay, t.commission_contact_id, t.agent_customer_id, t.agent_commission_type, t.agent_fixed_amount, t.agent_percentage, t.customer_id, t.bill_start, t.bill_end, t.total_monthly_cost, t.grand_total_cost, t.account_number, t.first_name, t.last_name, t.company_name, t.status, t.inactivation, t.billing_type, t.parent, t.wholesale, t.child, t.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.tax_id, t.ssn FROM (SELECT agent_bill.id AS id, agent_bill.commission_recipient_id AS commission_recipient_id, agent_bill.monthly_bill_id AS monthly_bill_id, agent_bill.commission_type AS commission_type, agent_bill.commission_rate AS commission_rate, agent_bill.commission_amount AS commission_amount, agent_bill.paid AS paid, agent_bill.pay_date AS pay_date, agent_bill.commissionable_total AS commissionable_total, agent_bill.commission_pay AS commission_pay, agent.commission_contact_id AS commission_contact_id, agent.customer_id AS agent_customer_id, agent.commission_type AS agent_commission_type, agent.fixed_amount AS agent_fixed_amount, agent.percentage AS agent_percentage, bill.customer_id AS customer_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.account_number AS account_number, c.first_name AS first_name, c.last_name AS last_name, c.company_name AS company_name, c.status AS status, c.inactivation AS inactivation, c.billing_type AS billing_type, c.parent AS parent, c.wholesale AS wholesale, c.child AS child, agent_contact.active AS active, agent_contact.first_name AS agent_first_name, agent_contact.last_name AS agent_last_name, agent_contact.company_name AS agent_company_name, agent_contact.phone AS agent_phone, agent_contact.address1 AS agent_address1, agent_contact.address2 AS agent_address2, agent_contact.city AS agent_city, agent_contact.state AS agent_state, agent_contact.zip AS agent_zip, agent_contact.notes AS agent_notes, agent_contact.tax_id AS tax_id, agent_contact.ssn AS ssn FROM commission_agent_bill agent_bill LEFT JOIN commission_agent agent ON agent.id = agent_bill.commission_recipient_id LEFT JOIN monthly_bill_charges bill ON bill.id = agent_bill.monthly_bill_id LEFT JOIN customer c ON c.id = bill.customer_id LEFT JOIN commission_contact agent_contact ON agent_contact.id = bill.customer_id) AS t WHERE t.commission_recipient_id = '5' AND t.paid = '1' AND t.bill_end >= '2025-08-25' ORDER BY t.bill_end

08-25-2026 21:53:50 SQL Statement: SELECT t.id, t.commission_recipient_id, t.monthly_bill_id, t.commission_type, t.commission_rate, t.commission_amount, t.paid, t.pay_date, t.commissionable_total, t.commission_pay, t.commission_contact_id, t.salesrep_customer_id, t.salesrep_commission_type, t.salesrep_fixed_amount, t.salesrep_percentage, t.customer_id, t.bill_start, t.bill_end, t.total_monthly_cost, t.grand_total_cost, t.account_number, t.first_name, t.last_name, t.company_name, t.status, t.inactivation, t.billing_type, t.parent, t.wholesale, t.child, t.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.tax_id, t.ssn FROM (SELECT salesrep_bill.id AS id, salesrep_bill.commission_recipient_id AS commission_recipient_id, salesrep_bill.monthly_bill_id AS monthly_bill_id, salesrep_bill.commission_type AS commission_type, salesrep_bill.commission_rate AS commission_rate, salesrep_bill.commission_amount AS commission_amount, salesrep_bill.paid AS paid, salesrep_bill.pay_date AS pay_date, salesrep_bill.commissionable_total AS commissionable_total, salesrep_bill.commission_pay AS commission_pay, salesrep.commission_contact_id AS commission_contact_id, salesrep.customer_id AS salesrep_customer_id, salesrep.commission_type AS salesrep_commission_type, salesrep.fixed_amount AS salesrep_fixed_amount, salesrep.percentage AS salesrep_percentage, bill.customer_id AS customer_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.account_number AS account_number, c.first_name AS first_name, c.last_name AS last_name, c.company_name AS company_name, c.status AS status, c.inactivation AS inactivation, c.billing_type AS billing_type, c.parent AS parent, c.wholesale AS wholesale, c.child AS child, salesrep_contact.active AS active, salesrep_contact.first_name AS salesrep_first_name, salesrep_contact.last_name AS salesrep_last_name, salesrep_contact.company_name AS salesrep_company_name, salesrep_contact.phone AS salesrep_phone, salesrep_contact.address1 AS salesrep_address1, salesrep_contact.address2 AS salesrep_address2, salesrep_contact.city AS salesrep_city, salesrep_contact.state AS salesrep_state, salesrep_contact.zip AS salesrep_zip, salesrep_contact.notes AS salesrep_notes, salesrep_contact.tax_id AS tax_id, salesrep_contact.ssn AS ssn FROM commission_salesrep_bill salesrep_bill LEFT JOIN commission_salesrep salesrep ON salesrep.id = salesrep_bill.commission_recipient_id LEFT JOIN monthly_bill_charges bill ON bill.id = salesrep_bill.monthly_bill_id LEFT JOIN customer c ON c.id = bill.customer_id LEFT JOIN commission_contact salesrep_contact ON salesrep_contact.id = bill.customer_id) AS t WHERE t.commission_recipient_id = '5' AND t.paid = '1' AND t.bill_end >= '2025-08-25' ORDER BY t.bill_end

08-25-2026 21:53:50 SQL Statement: SELECT t.id, t.commission_recipient_id, t.monthly_bill_id, t.commission_type, t.commission_rate, t.commission_amount, t.paid, t.pay_date, t.commissionable_total, t.commission_pay, t.commission_contact_id, t.salesmanager_customer_id, t.salesmanager_commission_type, t.salesmanager_fixed_amount, t.salesmanager_percentage, t.customer_id, t.bill_start, t.bill_end, t.total_monthly_cost, t.grand_total_cost, t.account_number, t.first_name, t.last_name, t.company_name, t.status, t.inactivation, t.billing_type, t.parent, t.wholesale, t.child, t.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.tax_id, t.ssn FROM (SELECT salesmanager_bill.id AS id, salesmanager_bill.commission_recipient_id AS commission_recipient_id, salesmanager_bill.monthly_bill_id AS monthly_bill_id, salesmanager_bill.commission_type AS commission_type, salesmanager_bill.commission_rate AS commission_rate, salesmanager_bill.commission_amount AS commission_amount, salesmanager_bill.paid AS paid, salesmanager_bill.pay_date AS pay_date, salesmanager_bill.commissionable_total AS commissionable_total, salesmanager_bill.commission_pay AS commission_pay, salesmanager.commission_contact_id AS commission_contact_id, salesmanager.customer_id AS salesmanager_customer_id, salesmanager.commission_type AS salesmanager_commission_type, salesmanager.fixed_amount AS salesmanager_fixed_amount, salesmanager.percentage AS salesmanager_percentage, bill.customer_id AS customer_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.account_number AS account_number, c.first_name AS first_name, c.last_name AS last_name, c.company_name AS company_name, c.status AS status, c.inactivation AS inactivation, c.billing_type AS billing_type, c.parent AS parent, c.wholesale AS wholesale, c.child AS child, salesmanager_contact.active AS active, salesmanager_contact.first_name AS salesmanager_first_name, salesmanager_contact.last_name AS salesmanager_last_name, salesmanager_contact.company_name AS salesmanager_company_name, salesmanager_contact.phone AS salesmanager_phone, salesmanager_contact.address1 AS salesmanager_address1, salesmanager_contact.address2 AS salesmanager_address2, salesmanager_contact.city AS salesmanager_city, salesmanager_contact.state AS salesmanager_state, salesmanager_contact.zip AS salesmanager_zip, salesmanager_contact.notes AS salesmanager_notes, salesmanager_contact.tax_id AS tax_id, salesmanager_contact.ssn AS ssn FROM commission_salesmanager_bill salesmanager_bill LEFT JOIN commission_salesmanager salesmanager ON salesmanager.id = salesmanager_bill.commission_recipient_id LEFT JOIN monthly_bill_charges bill ON bill.id = salesmanager_bill.monthly_bill_id LEFT JOIN customer c ON c.id = bill.customer_id LEFT JOIN commission_contact salesmanager_contact ON salesmanager_contact.id = bill.customer_id) AS t WHERE t.commission_recipient_id = '5' AND t.paid = '1' AND t.bill_end >= '2025-08-25' ORDER BY t.bill_end