Customer Summary

Customer ID: 08201712-7660

Trunk Number: 10001


Status Active

Type Parent account
Account Manager mike

Customer Portal

Reset Portal Password

PBX Device

PBX Device UI

Device XAA
Device Type Protel 6
voip 392XAA466cxd473
pbxadmin XAA255vat529ABE

Contact Information

Name XAA Testing
Company nexMatrix
Phone (208) 697-5000
Email kevin.mcmahan@nexmatrix.com

Credit Card Settings

Card Number ************xxxx
Expiration Date 01/70

Account Balances

Inbound Minutes 0
Outbound Minutes 0
Shared Minutes 10
Tank Balance 129

Billing Settings

Billing Cycle Start Date 2026-08-02
Billing Style Monthly Charge Billing
Recharge Threshold 15
Tax Processing Internal Calculations

Bill Plan

Inbound Minutes 0
Outbound Minutes 0
Shared Minutes 10

Bill Line Items


Bill History

Invoices

Commission

Sales Agent
Sales Rep Sheep, Shawn
Sales Manager

Provisioning

Trunk Status
SIP Server No SIP Server
Registration Style Static IP
Down Forward None

Carrier Priorities


DIDs

DID Description International e911 Status Carrier

Child Accounts

Account Number Name Status

08-25-2026 21:03:34 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 = '2'

08-25-2026 21:03:34 SQL Statement: SELECT id, summary, description FROM billing_styles ORDER BY id

08-25-2026 21:03:34 SQL Statement: SELECT contact_data.id, contact_data.email, contact_data.name_contact, contact_data.phone, contact_data.fax, customer_contact_data.customer_id FROM contact_data, customer_contact_data WHERE contact_data.id = customer_contact_data.contact_id AND customer_contact_data.customer_id = '2'

08-25-2026 21:03:34 SQL Statement: SELECT id, customer_id, trunk_number, secret, callForward, down_forward_trunkid, ipAddress, callerID, caller_id_name, CID_FlatRate_ON, callLimit, trunk_username_inbound, trunk_username_outbound, allow_g729, default_carriers_also, allow_g711, did_prefix_strip FROM trunk WHERE customer_id = '2' ORDER BY trunk_number

08-25-2026 21:03:34 SQL Statement: SELECT t.id, t.childId, t.parentId, t.childAccountNum, t.childStatus, t.childDeactive, t.childFirstName, t.childLastName, t.childCompany, t.parentAccountNum, t.parentWholesale, t.parentFirstName, t.parentLastName, t.parentCompany FROM (SELECT pair.id AS id, pair.child_id AS childId, pair.parent_id AS parentId, c.account_number AS childAccountNum, c.status AS childStatus, c.inactivation AS childDeactive, c.first_name AS childFirstName, c.last_name AS childLastName, c.company_name AS childCompany, p.account_number AS parentAccountNum, p.wholesale AS parentWholesale, p.first_name AS parentFirstName, p.last_name AS parentLastName, p.company_name AS parentCompany FROM customer_parent_child pair LEFT JOIN customer c ON pair.child_id = c.id LEFT JOIN customer p ON pair.parent_id = p.id) AS t WHERE t.parentId = '2' ORDER BY t.parentId

08-25-2026 21:03:34 SQL Statement: SELECT id, customer_id, trunk_number, secret, callForward, down_forward_trunkid, ipAddress, callerID, caller_id_name, CID_FlatRate_ON, callLimit, trunk_username_inbound, trunk_username_outbound, allow_g729, default_carriers_also, allow_g711, did_prefix_strip FROM trunk WHERE customer_id IN (NULL) ORDER BY trunk_number

08-25-2026 21:03:34 SQL Statement: SELECT COUNT(*) AS quantity FROM customer_device_info WHERE customer_id = '2'

08-25-2026 21:03:34 SQL Statement: SELECT customer_device_id, device_info_id, customer_id, account_number, first_name, last_name, company_name, status, inactivation, box_num, mac_address, ip_address, port_number, allow_changing_port, follow_changing_port, canreinvite, admin_email, notes, type, typeName, box_serial, software_serial, extension_count, acd_extension_count, support_end_date, update_end_date, http_address, lan_ip, ssh_port, web_port, require_vlan, ssl_enable, voip_pw, pbxadmin_pw, eula_agreement, eula_addendum1_agreement, support_agreement FROM customer_device_info WHERE customer_id = '2'

08-25-2026 21:03:34 SQL Statement: SELECT COUNT(*) AS quantity FROM trunk WHERE customer_id = '2'

08-25-2026 21:03:34 SQL Statement: SELECT id, customer_id, sipserver_id, trunk_number, secret, callForward, down_forward_trunkid, ipAddress, callerID, caller_id_name, CID_FlatRate_ON, callLimit, trunk_username_inbound, trunk_username_outbound, allow_g729, default_carriers_also, allow_g711, did_prefix_strip FROM trunk WHERE customer_id = '2'

08-25-2026 21:03:34 SQL Statement: SELECT COUNT(*) AS quantity FROM sipServers WHERE serverID = ''

08-25-2026 21:03:34 SQL Statement: SELECT trunk_number, call_type_id, carrier_ids FROM trunkCalltypeCarrierPriorities WHERE trunk_number = '2' ORDER BY call_type_id

08-25-2026 21:03:34 SQL Statement: SELECT id, name, host, accountcode, priorityDomestic, priorityInternational, priorityE911, priorityE411, dialstringDomestic, dialstringInternational, dialstringSpecial, addressStyle, tcp_enable, port FROM carriersOutbound ORDER BY name

08-25-2026 21:03:34 SQL Statement: SELECT billPlan.bpID, billPlan.s_date, billPlan.nextBillDate, billPlan.setupFee_E411, billPlan.perCall_E411, billPlan.perCall_E411, billPlan.perCall_E911, billPlan.perCall_Rogue911, billPlan.stateTax, billPlan.USinInitialCharge, billPlan.USoutInitialCharge, billPlan.USin2ndCharge, billPlan.USout2ndCharge, billPlan.InternationalinInitialCharge, billPlan.InternationaloutInitialCharge, billPlan.InternationalinAfterCall, billPlan.InternationaloutAfterCall, billPlan.inRate, billPlan.outRate, billPlan.perCall_tollFree, billPlan.TollFreeInitialCharge, billPlan.TollFreeAfterCharge, billPlan.usf_enable, billPlan.baseAmount, billPlan.trunkRate, billPlan.trunksIn, billPlan.trunksIn, billPlan.trunksOut, billPlan.STD_In_numbersPorted, billPlan.STD_In_numberPortingFee, billPlan.STD_Out_numbersPorted, billPlan.STD_Out_numberPortingFee, billPlan.tollFree_In_numbersPorted, billPlan.tollFree_In_numberPortingFee, billPlan.tollFree_Out_numbersPorted, billPlan.tollFree_Out_numberPortingFee, billPlan.setupFee_InitialDID, billPlan.DIDMonthlyFee, billPlan.setupFee_tollFree, billPlan.DIDMonthlyFee_tollFree, billPlan.phoneBookListing, billPlan.numPhoneBookListings, billPlan.paperInvoiceFee, billPlan.planID, billPlan.inPack, billPlan.outPack, billPlan.combinedSecs, billPlan.cidFee, billPlan.sms_rate, billPlan.mms_rate, billPlan.smsout_rate, billPlan.cardRejectFee, billPlan.PerChild50, billPlan.PerChild100, billPlan.PerChild250, billPlan.PerChild500, billPlan.PerChild1000, customer_billplan.customer_id FROM billPlan, customer_billplan WHERE billPlan.bpID = customer_billplan.plan_id AND customer_billplan.customer_id = '2'

08-25-2026 21:03:34 SQL Statement: SELECT COUNT(*) AS quantity FROM cc_data WHERE customer_id = '2'

08-25-2026 21:03:34 SQL Statement: SELECT btID, customer_id, tankbalance, TFInbound, amountDue, pastDue, pastDue30, pastDue60, pastDue90, totalInMinutesAllowed, totalOutMinutesAllowed, totalCombinedMinutesAllowed FROM billTotal WHERE customer_id = '2'

08-25-2026 21:03:34 SQL Statement: SELECT id, commission_contact_id, customer_id, commission_type, fixed_amount, percentage FROM commission_agent WHERE customer_id = '2'

08-25-2026 21:03:34 SQL Statement: SELECT id, commission_contact_id, customer_id, commission_type, fixed_amount, percentage FROM commission_salesrep WHERE customer_id = '2'

08-25-2026 21:03:34 SQL Statement: SELECT id, commission_contact_id, customer_id, commission_type, fixed_amount, percentage FROM commission_salesmanager WHERE customer_id = '2'

08-25-2026 21:03:34 SQL Statement: SELECT COUNT(*) AS quantity FROM commission_contact WHERE id = ''

08-25-2026 21:03:34 SQL Statement: SELECT COUNT(*) AS quantity FROM commission_contact WHERE id = '1'

08-25-2026 21:03:34 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 = '1'

08-25-2026 21:03:34 SQL Statement: SELECT COUNT(*) AS quantity FROM commission_contact WHERE id = ''

08-25-2026 21:03:34 SQL Statement: SELECT did_id, did, startTimestamp, carrier_id, forward_number, forward_delay, cnam_enable, e911_enable, dial_format, did_tag, did_description, carrier_name, customer_id, account_number, customer_first_name, customer_last_name, customer_company, customer_status, customer_hardinactive, trunk_id, trunk_number, sipserver_id, international_enable FROM customer_did WHERE customer_id = '2' ORDER BY did

08-25-2026 21:03:34 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 = '2'

08-25-2026 21:03:35 SQL Statement: SELECT billPlan.bpID, billPlan.planName, billPlan.term, billPlan.s_date, billPlan.nextBillDate, billPlan.billingDays, billPlan.gracePeriod, billPlan.external_tax_processing, billPlan.external_tax_filing, billPlan.threshold, billPlan.threshold_type, billPlan.chargeAmount, billPlan.recharge_type, billPlan.cutoff_value, billPlan.international_enable, billPlan.international_enable_style, billPlan.international_warning_minutes, billPlan.international_cutoff_minutes, customer_billplan.customer_id FROM billPlan, customer_billplan WHERE billPlan.bpID = customer_billplan.plan_id AND customer_billplan.customer_id = '2'

08-25-2026 21:03:35 SQL Statement: SELECT t.id, t.childId, t.parentId, t.childAccountNum, t.childStatus, t.childDeactive, t.childFirstName, t.childLastName, t.childCompany, t.parentAccountNum, t.parentWholesale, t.parentFirstName, t.parentLastName, t.parentCompany FROM (SELECT pair.id AS id, pair.child_id AS childId, pair.parent_id AS parentId, c.account_number AS childAccountNum, c.status AS childStatus, c.inactivation AS childDeactive, c.first_name AS childFirstName, c.last_name AS childLastName, c.company_name AS childCompany, p.account_number AS parentAccountNum, p.wholesale AS parentWholesale, p.first_name AS parentFirstName, p.last_name AS parentLastName, p.company_name AS parentCompany FROM customer_parent_child pair LEFT JOIN customer c ON pair.child_id = c.id LEFT JOIN customer p ON pair.parent_id = p.id) AS t WHERE t.parentId = '2' ORDER BY t.childId

08-25-2026 21:03:35 SQL Statement: SELECT id, username, password_hash, access_type, customer_id, AES_DECRYPT(password, '0mp7wmvTCmqU7jLXN4CT') AS password FROM login WHERE username = '10001'