Customer Summary

Customer ID: 10202011-1637

Trunk Number: 10071


Status Active

Type Standard account
Account Manager

Customer Portal

Reset Portal Password

PBX Device

PBX Device UI

Device XZA
Device Type Protel 5 (multitenant)
voip 929XZA155rzr958
pbxadmin XZA304voa515HRN

Contact Information

Name Aminidab Corianton
Company
Phone
Email

Credit Card Settings

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

Account Balances

Inbound Minutes 0
Outbound Minutes 0
Shared Minutes 0
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 0

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:05: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 = '36'

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

08-25-2026 21:05: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 = '36'

08-25-2026 21:05: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 = '36' ORDER BY trunk_number

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

08-25-2026 21:05: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 IN (NULL) ORDER BY trunk_number

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

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

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

08-25-2026 21:05: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 = '36'

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

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

08-25-2026 21:05: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:05: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 = '36'

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

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

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

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

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

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

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

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

08-25-2026 21:05: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 = '36' ORDER BY did

08-25-2026 21:05: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 = '36'

08-25-2026 21:05: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 = '36'

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