Customer Summary

Customer ID: 10202108-2851

Trunk Number: 10072

Status Active

Type	Standard account
Account Manager

Customer Portal

Reset Portal Password

PBX Device

PBX Device UI

Device
Device Type	Unknown
voip
pbxadmin

Contact Information

Name	anybody here
Company	chickens
Phone
Email

Credit Card Settings

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

Account Balances

Inbound Minutes	0
Outbound Minutes	0
Shared Minutes	800
Tank Balance	0

Billing Settings

Billing Cycle Start Date	2026-08-10
Billing Style	Manual Billing
Recharge Threshold	0
Tax Processing	Internal Calculations

Bill Plan

Inbound Minutes	0
Outbound Minutes	0
Shared Minutes	800

Bill Line Items

Invoices

Commission

Sales Agent
Sales Rep
Sales Manager

Provisioning

Trunk Status

SIP Server	No SIP Server
Registration Style	Dynamic Registration
Down Forward	None

Carrier Priorities

DIDs

DID	Description	International	e911 Status	Carrier

08-25-2026 21:04: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 = '40'

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

08-25-2026 21:04:47 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 = '40'

08-25-2026 21:04:47 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 = '40' ORDER BY trunk_number

08-25-2026 21:04:47 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 = '40' ORDER BY t.parentId

08-25-2026 21:04:47 SQL Statement: SELECT COUNT(*) AS quantity FROM customer_device_info WHERE customer_id = '40'

08-25-2026 21:04:47 SQL Statement: SELECT COUNT(*) AS quantity FROM trunk WHERE customer_id = '40'

08-25-2026 21:04:47 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 = '40'

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

08-25-2026 21:04:47 SQL Statement: SELECT trunk_number, call_type_id, carrier_ids FROM trunkCalltypeCarrierPriorities WHERE trunk_number = '37' ORDER BY call_type_id

08-25-2026 21:04:47 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:04:47 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 = '40'

08-25-2026 21:04:47 SQL Statement: SELECT COUNT(*) AS quantity FROM cc_data WHERE customer_id = '40'

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

08-25-2026 21:04:47 SQL Statement: SELECT id, commission_contact_id, customer_id, commission_type, fixed_amount, percentage FROM commission_agent WHERE customer_id = '40'

08-25-2026 21:04:47 SQL Statement: SELECT id, commission_contact_id, customer_id, commission_type, fixed_amount, percentage FROM commission_salesrep WHERE customer_id = '40'

08-25-2026 21:04:47 SQL Statement: SELECT id, commission_contact_id, customer_id, commission_type, fixed_amount, percentage FROM commission_salesmanager WHERE customer_id = '40'

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

08-25-2026 21:04:47 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 = '40' ORDER BY did

08-25-2026 21:04:47 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 = '40'