Core reports are located in the Report Explorer. The IDI platform provides other reports (not located in Report Explorer) that are run via IDI Desktop Client menus. Such reports are not listed in this article, but are covered in IDI Desktop Client Online Help.
The reports listed in this article are organized by their respective default folders in Report Explorer. IDI platform users may choose to create their own folders and place copies of standard reports in those folders as needed. This article does not account for any custom folders or placement of reports in other (non-default) folders as you may configure on your system.
The ULT column in these tables indicates whether the report observes User Limit To profiles as configured in Admin Console > Security > Profiles. A report enforces the User Limit To profile by restricting access to setup criteria (specifically; dropdown lists for Market, Account Type, or Sales Channel) and/or limiting the displayed results.
All reports are presented in grids that support sorting and filtering, unless listed as a Document-style (PDF) report.
Audit
Name | Class | ULT | Folder | Description |
|---|---|---|---|---|
Application Performance Data | Base | No | Audit/Application Performance | Provides raw performance data for further analysis. |
Application Performance Summary | Base | No | Audit/Application Performance | Provides summarized performance trending data for further analysis. |
Active Items in Disconnected Packages | Base | Yes | Audit/Billing | A list of billing active items in disconnected packages. |
Auto Pay Status | Base | No | Audit/Billing | A list of all accounts by billing cycle and their E-Pay status. |
Billed Taxes Difference | Base | No | Audit/Billing | Displays a list of taxes that were assessed in this billing period and were not in the previous billing period. |
Compare Customer Invoices | Base | Yes | Audit/Billing | Displays a list of all customers who have exceeded a certain dollar amount from one bill period to the next. |
Expired Private Line Tax Jurisdictions | Base | Yes | Audit/Billing | A list of assigned private line products with expired tax jurisdictions |
Grant Discounts Used | Base | Yes | Audit/Billing | A list, by service number, of grant discount units used by invoice group. |
Not Billing Accounts with Outstanding Balances | Base | Yes | Audit/Billing | Displays a list of accounts with a billing status of Not Billing that have outstanding balances |
Not Billing Catalog Items | Base | Yes | Audit/Billing | Displays a list of account numbers and related details of accounts that have assigned catalog items with a status of Not Billing. |
Not Billing Service Numbers | Base | Yes | Audit/Billing | Displays a list of active service numbers where the billing status of the service number is Not Billing. |
Usage by Day by Source | Base | No | Audit/Billing | Enables the user to easily find missing usage by ensuring that usage is not missing for a day or part thereof. |
Account Event Log | Base | Yes | Audit/Customers & Services | Provides a history of all changes done on an account. |
Account Services and Products with Attributes | Base | Yes | Audit/Customers & Services | A list of all attributes on services and features per account, along with their populated data. |
Accounts with Account Code Groups | Wireline | Yes | Audit/Customers & Services | Displays account information (such as history, verification, and billing cycles) for those accounts that are part of an account code group. |
Active Accounts Assigned to an Inactive Market | Base | Yes | Audit/Customers & Services | Provides a listing of the active customer accounts that are currently assigned to inactive markets. |
Active Customers with No Salesperson | Base | Yes | Audit/Customers & Services | Displays active accounts with no assigned sales person. Parent account numbers are included (if applicable). |
Active Customers with No Services | Base | Yes | Audit/Customers & Services | A list of active customers who have no (billing) services. |
Active Customers with Zero Balances | Base | Yes | Audit/Customers & Services | Displays accounts with current balances of zero. Can be used to audit customers who may not be using their services. |
All Service Numbers by Service Type | Base | Yes | Audit/Customers & Services | Displays a list of all service types and the total number of services on each service type. |
Bill Cycle Change Audit | Base | Yes | Audit/Customers & Services | Per account, lists a record of billing cycle changes, and who made the change. |
Collections Exempt Customers | Base | Yes | Audit/Customers & Services | Displays accounts that are tagged to be exempt from being put into collections. |
Customer Alert Messages | Base | Yes | Audit/Customers & Services | Displays a list of all customers who have custom alerts assigned to appear when the customer’s screen is opened. |
Customer Invoice Messages | Base | Yes | Audit/Customers & Services | Displays a list of all custom messages assigned (on the customer’s account) to appear on the customer’s invoice during the date range selected. |
Customers per Finance Group | Base | Yes | Audit/Customers & Services | A list of customer accounts per finance group. |
Customers per Invoice Format | Base | Yes | Audit/Customers & Services | Displays a list of all invoice formats and a count of customers assigned to those formats. |
Customers with No Invoice Formats | Base | Yes | Audit/Customers & Services | Displays a list of accounts with parent account numbers. Allows you to open the account and assign an invoice format. |
Duplicate ESN | Wireless | No | Audit/Customers & Services | Displays a list of all ESNs that have been assigned to multiple service numbers. |
Finance Charge Exempt Customers | Base | Yes | Audit/Customers & Services | Displays a list of accounts that are tagged to be exempt from having finance charges applied. |
Inactive Corporate Parents with Active Children | Base | Yes | Audit/Customers & Services | Displays a list of all accounts with corporate structures where the parent is not billing active but some or all of the children are active. |
Inactive Customers with a Total Amount Due | Base | Yes | Audit/Customers & Services | Displays a list of all customers who are no longer active but have a remaining balance on their account. |
Market Change Audit | Base | Yes | Audit/Customers & Services | Lists accounts with a ‘history’ of any change (move) in the assigned market for each customer account for a specified date range. |
Orphaned Services | Wireless | Yes | Audit/Customers & Services | A list of services, by account, that have become “orphaned,” meaning that they are no longer affiliated with another service that they had shared a discount with |
Service Number Change History | Base | No | Audit/Customers & Services | Displays the full chain of from and to history for a given service number across accounts. |
Service Numbers with No Billing Number | Base | Yes | Audit/Customers & Services | Displays a list of service numbers that do not have a billing number assigned to them. |
Service Numbers with No Pricing Plans | Base | Yes | Audit/Customers & Services | Displays service numbers that do not have a pricing plan assigned to them, nor assigned to the account. |
Suppress Invoice Print Customers | Base | Yes | Audit/Customers & Services | Displays accounts that have the suppress invoice print option enabled. |
Suspended Customers | Base | Yes | Audit/Customers & Services | Displays, by date, a list of all customers who have been suspended. |
Admin Console Activity | Base | No | Audit/PCI | Lists details event log entries pertaining to activity that occurred within Admin Console. |
Failed Logon Attempts Detail | Base | No | Audit/PCI | Lists details of failed logon attempts. |
Failed Logon Attempts Summary | Base | No | Audit/PCI | Shows a summary of failed logon attempts. |
User Inactivity | Base | No | Audit/PCI | Displays all active users who have not logged into the system in the last ‘X’ days. |
Manual SIM Card Provisioning | Wireless | No | Audit/Provisioning | Displays a list of services that have been exported by the Manual SIM card Provisioning File Export Scheduled Job. |
Billed Products with No Tax Class | Base | No | Audit/Taxes | Displays a list of products that have been billed that do not have a tax class currently assigned to them. |
Expired Tax Jurisdictions | Base | Yes | Audit/Taxes | Displays a list of customers whose tax jurisdictions have expired. |
Invoice Tax Details Audit | Base | No | Audit/Taxes | Facilitates auditing calculated taxes after billing processes have completed. The results help experienced personnel confirm invoiced items were taxed correctly (or not). The report provides insight into taxation details down to the service-level. An example application is to audit the taxation from the roll-out (and billing) of new service-level Products and Packages. |
Mismatched Tax Account Types | Base | Yes | Audit/Taxes | Displays a list of personal accounts with non-personal service numbers tax types. |
Tax Audit Log Customers | Base | Yes | Audit/Taxes | Displays a detailed description of all tax issues listed by customer. |
Tax Audit Log Services | Base | Yes | Audit/Taxes | Displays a detailed description of all tax issues listed by service number and service type. |
Tax Exempt Customers | Base | Yes | Audit/Taxes | Displays a list of customers and all of the taxes for which they are exempt. |
Usage Notifications Configuration Summary | Wireless | No | Audit/Usage Notifications | Displays the number of active services using each send notification option |
Usage Notifications History | Wireless | No | Audit/Usage Notifications | Displays a summary of usage notification activity |
Churn
Name | Class | ULT | Folder | Description |
|---|---|---|---|---|
Churn Breakdown by Month Document | Base | No | Churn | Displays a monthly breakdown of the number of adds and disconnects along with the net change to the number of current customers. |
Customer Churn by Account Type | Base | Yes | Churn | Displays the total number of active accounts on the specified From Date and the activity through the To Date. |
Customer Churn by Reason | Base | Yes | Churn | Displays the total number of lost accounts on the specified From Date and the activity through the To Date and the reason. |
Customer Churn Detail | Base | Yes | Churn | Displays each of the accounts disconnected within the specified date range. |
Service Churn by Reason | Base | Yes | Churn | Displays the total number of lost accounts on the specified From Date and the activity through the To Date and the reason. |
Service Churn by Service Type | Base | Yes | Churn | Displays the total number of active services on the specified From Date and the activity through the To Date. |
Service Churn Detail | Base | Yes | Churn | Displays each of the accounts that has disconnected services within the specified date range. |
CPNI
Name | Class | ULT | Folder | Description |
|---|---|---|---|---|
Security Saturation Document | Base | No | CPNI | Displays CPNI summary information. |
Customer Care & Management
Name | Class | ULT | Folder | Description |
|---|---|---|---|---|
Account Status Detail | Base | Yes | Customer Care & Management | Displays a list of all active accounts by market, account type, account status, and billing cycle. |
Account Status Summary | Base | Yes | Customer Care & Management | Displays totals for billing statuses by account status per billing cycle. |
Accounts with Additional Billing Reports | Base | Yes | Customer Care & Management | Displays a list of accounts that have additional billing reports added to their Invoice format. |
Active Accounts by Bill Cycle | Base | Yes | Customer Care & Management | Displays a list of all active accounts with their bill cycle ID, bill cycle, and number of total accounts. |
Active Accounts by Country | Base | Yes | Customer Care & Management | Provides a total, by market, of all active accounts and their country. |
Active Accounts by Credit Class | Base | Yes | Customer Care & Management | Summary and detail information of accounts per credit class. |
Active Accounts by Language | Base | Yes | Customer Care & Management | Provides a total by market of all active accounts with their language ID and language. |
Active Accounts by Region | Base | Yes | Customer Care & Management | Displays a total by market of all active accounts with their region. |
Active Accounts by State | Base | Yes | Customer Care & Management | Displays a list of all active accounts by state. |
Active Services by City, State and Zip | Base | Yes | Customer Care & Management | Displays active services by service type name, city, county, state, and zip code for a given date. Also includes drill-down detail for these parameters. |
Active Services by Type | Base | Yes | Customer Care & Management | Displays number of active subscribers split up by account type and service type as of the date specified. Does not include future dated activations or disconnects. |
Affinity Sales Document | Wireline | Yes | Customer Care & Management | Displays invoice affinity information and balances of customers within affinity groups. |
Bonus Discount Detail | Wireless | Yes | Customer Care & Management | Displays a detailed list of customers who are eligible for a specific bonus or discount. |
Bonus Discount Summary | Wireless | Yes | Customer Care & Management | Displays a summary list of customers who are eligible for a specific bonus or discount. |
Contract Renegotiation | Wireline | Yes | Customer Care & Management | Displays customers whose contracts either have expired, or are scheduled to expire, during the dates selected. |
Corporate Service Address Locations | Wireline | Yes | Customer Care & Management | Displays complete corporate service address locations (and service and billing numbers) by requested parent account number. |
Customer Mailing List | Base | Yes | Customer Care & Management | Displays customers and addresses by account type and status. |
Customer Primary and Billing Addresses | Wireline | Yes | Customer Care & Management | Displays customer’s addresses, contacts, services, products and account code. Can be used for a comprehensive review of customers and their products. |
Customer Profile Document | Base | No | Customer Care & Management | Displays a complete list of customer’s addresses, contacts, services, products and account code. |
Customer Summary by Group Document | Base | No | Customer Care & Management | Displays multiple reports depending on criteria. Included is a date range and the ability to include or exclude inactive account statuses. |
Customers by Bill Cycle Document | Base | No | Customer Care & Management | Displays subscribers and account numbers for a selected bill cycle, and reflects their account status. |
Customers by Group Document | Base | No | Customer Care & Management | Displays a complete list of customers by date and grouping. |
Disconnected Services by Customer | Base | Yes | Customer Care & Management | Displays a list of all services disconnected by customer during the date range chosen. |
Feature Cross Reference | Wireless | Yes | Customer Care & Management | Lists customers and their plans, features and discounts according to selected parameters. It may be used to ensure that customers do not have conflicting features and/or discounts. |
New Customer Accounts by Market Detail | Base | Yes | Customer Care & Management | Displays a row for each new customer account created within a specified time frame. |
New Customer Accounts by Market Summary | Base | Yes | Customer Care & Management | Provides a count of newly created customer accounts by market. |
New Service Activations by Market Detail | Base | Yes | Customer Care & Management | Provides a listing of the services that were activated during a desired timeframe. |
New Service Activations by Market Summary | Base | Yes | Customer Care & Management | Provides a count of newly activated (created) services by market. |
Top Revenue Customers | Base | Yes | Customer Care & Management | Lists customers with the top revenue for a defined time period. It can be exported to a spreadsheet and might be used to create a list of customers who will receive thank you gifts or rewards. |
Wireless Contract Renegotiation | Wireless | Yes | Customer Care & Management | Displays a list of customers whose contracts either have expired, or are scheduled to expire, during the dates selected. |
Account Overage Balance | Wireless | No | Customer Care & Management/Advance Pay | Displays all customers (by account number) that have incurred overage charges relative to their service(s) |
Carefree Calling Plan Changes | Wireless | Yes | Customer Care & Management/Carefree | Displays customers with carefree calling that changed their plans in a given month |
Payoff Detail | POS | No | Customer Care & Management/Installment Plans | Displays a row for each installment plan payoff transaction performed as a POS or OnlineBill transaction for a particular location for a defined timeframe |
Sales Detail | POS | No | Customer Care & Management/Installment Plans | Displays a row for each installment item sold or returned through a POS sales transaction for a particular location for a defined timeframe. |
Installment Plans by SKU | POS | No | Customer Care & Management/Installment Plans | Displays total value and outstanding balance for all active plans for a specified SKU or all SKUs |
Installment Plans by Account | POS | No | Customer Care & Management/Installment Plans | Displays installment plan details for a specified account or all accounts |
Enhanced Address Validation
Note:
The Enhanced Address Validation Audit and Enhanced Address Validation Audit Detail reports are obsolete. Use the Address Validation Audit Log Search in the Audit Log web application instead. Refer the article on Address Validation Search in the IDI Knowledge Center or Audit Log web help for details.
Executive Management
Name | Class | ULT | Folder | Description |
|---|---|---|---|---|
ALE Revenue | Wireline | No | Executive Management | For each product, by location, shows number of installs and removals, total installed at end of period, number of pending services and products at end date, and number of active services and products at end date. |
Sales Revenue Document | Base | Yes | Executive Management | Displays revenue associated to each sales channel, broken down by sales person assigned to the reported channel. |
Standard Sales Document | Base | Yes | Executive Management | Displays a listing of commissions applicable to each reported sales person. |
Finance
Name | Class | ULT | Folder | Description |
|---|---|---|---|---|
Accounts Receivable Month End Audit | Base | No | Finance/Accounts Receivable | Shows transactional activity that impacts accounts receivable for a specified month |
Active Contract Asset Value by Account | Base | No | Finance/Accounts Receivable | Lets you review the current value of the Contract Assets that are applicable to the FASB ASC 606 standard. The report calculates and presents the current Contract Asset Value per Account/Service as of the moment the report is run. Contracts that are no longer active are not included. This report will return data for all accounts unless a specific account number is specified |
Active Customers by AR Group | Base | Yes | Finance/Accounts Receivable | Displays the total number of accounts assigned to each AR group. |
Adjustments by Batch ID Document | Base | No | Finance/Accounts Receivable | Displays all adjustments per customer (totaled) for the desired timeframe. |
Adjustments by Date Document | Base | No | Finance/Accounts Receivable | Displays adjustments (and totals) by customer. The report also provides totals by invoice group. (paper style report) |
Adjustments by Date (grid) | Base | No | Finance/Accounts Receivable | Displays adjustments (and totals) by customer. The report also provides totals by invoice group. (grid style report) |
Adjustments by Source | Base | No | Finance/Accounts Receivable | Provides a rollup of adjustments for daily reconciliation, auditing and cross-referencing with the Month End Journal Entry report and other reports. |
Adjustments by Type Summary | Base | Yes | Finance/Accounts Receivable | Displays a summary of adjustments by type by invoice group |
Aging 30-60-90-120 | Base | Yes | Finance/Accounts Receivable | Displays all customers who have aging balances of 30, 60, 90 and 120 days. Customer’s status and collections information is included. |
Aging Date Specific by Group Document | Base | No | Finance/Accounts Receivable | Displays dozens of aging reports from this one report as it has multiple criteria options to select. |
Arrears Document | Base | No | Finance/Accounts Receivable | Displays a cross reference between customer information and past due information. |
Average Days To Pay Document | Base | No | Finance/Accounts Receivable | Displays an analysis of a customer’s ability to pay a bill, average and length of time between invoice date and date of payment. |
Banks | Base | No | Finance/Accounts Receivable | Displays all banks that have been provided along with their routing numbers |
Collections | Base | No | Finance/Accounts Receivable | Lists customers in a specified state of collection, by numerous other criteria including billing cycle, market and balance aging group. |
Collections – Customer Account Detail | Base | No | Finance/Accounts Receivable | Displays the current customers (with basic account details) in collections by greatest amount outstanding. |
Collections – Customer Status Detail Document | Base | No | Finance/Accounts Receivable | Displays the current customers (with basic account details) in collections by greatest amount outstanding. |
Contract Asset Sales Audit | Base | No | Finance/Accounts Receivable | Review and assess those sales and the details that contribute to the calculation of the Contract Asset Value. |
Contract Penalties Applied | Base | Yes | Finance/Accounts Receivable | A list of customers who received a penalty(ies) for breaking their contract. |
Credit Card Expiration Document | Base | No | Finance/Accounts Receivable | Displays customers whose E-Pay Credit card is about to expire within the entered date range. |
Customer Payment Types Document | Base | No | Finance/Accounts Receivable | Displays payment totals by batch number and payment type. Includes a count of subscribers that made payments and a total per batch. |
Customers Approaching Credit Limit Document | Base | No | Finance/Accounts Receivable | Displays customers who are currently approaching their respective credit limits. |
Customers Over Credit Limit Document | Base | No | Finance/Accounts Receivable | Displays customers who have exceeded their respective credit limits. |
Customers with Credit Balances | Yes | Finance/Accounts Receivable | Displays a list of accounts with positive balances. | |
Deposit Detail | Base | Yes | Finance/Accounts Receivable | Displays a row of deposit data per customer/account number, breakdown of deposit amounts and accrued interest during chosen date range. |
Deposit Summary | Base | No | Finance/Accounts Receivable | Displays a summary row of data that is a sum of deposit and interest amounts. |
Disputes Document | Base | No | Finance/Accounts Receivable | Displays a listing of those customers who question (dispute) specific charges that appeared on their invoice. Displays charges in dispute or resolved. |
E-Pay Bank Accounts by Customer | Base | Yes | Finance/Accounts Receivable | Displays ACH account info (bank name and routing number minimum) by customer so carriers can identify accounts with missing ACH information. |
E-Pay Transaction Detail | Base | Yes | Finance/Accounts Receivable | Displays a list of each individual E-Pay transaction as well as customer Information and E-Pay transaction detail. |
E-Pay Transaction Summary | Base | Yes | Finance/Accounts Receivable | Displays a count and total amount per E-pay Transaction status. |
Finance Charges Applied | Base | Yes | Finance/Accounts Receivable | Displays a list of financial charges applied to an account for the specified date range by invoice group. |
Financial Discounts by Customer Document | Base | No | Finance/Accounts Receivable | Displays discount information by discount plan for each customer within a bill period. Discount by billing period and a grand total are presented. |
Financial Discounts by Plan Document | Base | No | Finance/Accounts Receivable | Displays a list of pricing plans, including plans that need to be addressed to rate associated records. Provides status as of the day the report is selected. |
Forfeited Contract Revenue | Base | No | Finance/Accounts Receivable | Provides the identification of each early-disconnected FASB ASC 606 contract and the resulting amount of forfeited unearned revenue, if applicable. From and To dates must be specified when running this report. |
Market Change Balance Detail | Base | Yes | Finance/Accounts Receivable | Provides details on the individual account, its balance, and relevant market change details. |
Market Change Balance Summary | Base | Yes | Finance/Accounts Receivable | Provides the sum of the individual account balances grouped by a combination of change to market and change from market for a specified timeframe. |
Package Revenue Detail | Wireless | Yes | Finance/Accounts Receivable | Displays a detailed listing by customer of all packages, and the amount of revenue they are bringing into the company on a monthly basis. |
Package Revenue | Wireless | Yes | Finance/Accounts Receivable | Displays a listing of all packages and the amount of revenue they are bringing into the company on a monthly basis. |
Payment by Customer | Base | No | Finance/Accounts Receivable | A list of all customers, and the types of payments and dollar amount paid during the bill period. |
Payments by Batch ID Document | Base | No | Finance/Accounts Receivable | Displays payments made per customer. Batch ID is an optional parameter. |
Payments by Date Summary | Base | No | Finance/Accounts Receivable | Displays all payment types used during the selected date range, number of payments of that type, and total dollar amount of the payments for each type. |
Payments by Source | Base | No | Finance/Accounts Receivable | Provides a summary of payments for daily reconciliation, auditing and cross-referencing with the Month End Journal Entry report and other reports. |
Payments by Type Summary | Base | Yes | Finance/Accounts Receivable | Displays a list of payment types and amounts by invoice group for a specified date range. |
Post-Paid Accounts Receivable Daily Balance | Base | No | Finance/Accounts Receivable | This is an audit/summary report used to monitor the daily change to post-paid accounts receivable. |
Revenue History | Base | No | Finance/Accounts Receivable | Displays a revenue and product analysis, by supplying a quick breakdown of billed revenue per product per bill cycle. |
SBX Export | Base | Yes | Finance/Accounts Receivable | Displays a list of each account, simple contact details, current balance and count of payments made late: (31- 60 days) (61+ days) |
Security Deposit Allocation Document | Base | No | Finance/Accounts Receivable | Displays deposit history data per customer/account and details on the return of the deposit to the customer. |
Security Deposits Document | Base | No | Finance/Accounts Receivable | Displays a row of deposit detail data per customer/account number for each deposit collected. |
Service Type Summary | Base | Yes | Finance/Accounts Receivable | Displays a cost and usage summary by service type, usage type and distance type for the specified bill period. |
Write Off Document | Base | Yes | Finance/Accounts Receivable | Displays customers by billing (service) number who have been written off. Each is listed with account number, final bill date and AR aged balances. |
Write Off Taxes Document | Base | Yes | Finance/Accounts Receivable | Displays subtotals by tax jurisdiction by state. The subtotals are summed to provide grand totals for the provided setup criteria. |
Billed Catalog Items Summary | Base | Yes | Finance/Billing Operations | Displays a list of SKUs with counts and charge totals by invoice group. |
Charges Trending by Market | Base | Yes | Finance/Billing Operations | Displays a summary of charges by SKU over a specified number of months. |
Compare Two Bill Periods | Base | Yes | Finance/Billing Operations | Displays a side-by-side comparison of criteria from two bill periods. |
Compare Usage for Two Bill Periods | Base | No | Finance/Billing Operations | Displays the invoice totals for each customer and is grouped by market and sub-grouped by bill period. |
Financial Billing Summary Document | Base | No | Finance/Billing Operations | Provides a billing overview for each customer within a specified date range. It is broken down by market and invoice group for each account number, providing simple financial data. |
Minutes of Use Summary By Type | Wireless | No | Finance/Billing Operations | Displays a summary of calls and charges by market, service type and usage type for the specified bill period. |
Remaining Contract Value by Contract | Base | No | Finance/Billing Operations | Displays a row for the estimated charges per active contract associated with a contract with a start or end date within a specified time frame. |
Remaining Contract Value by Service Type | Base | No | Finance/Billing Operations | Displays a row for the estimated charges per service type associated with a contract with a start or end date within a specified time frame. |
Consolidated Balance Sheet Document | Base | No | Finance/Financial Statements | Displays the current amounts of the carrier’s assets and liabilities for a specified month end in a traditional balance sheet format |
Consolidated Income Statement Document | Base | No | Finance/Financial Statements | Displays the current amounts of the carrier’s revenues and expenses for a specified month to facilitate calculating net income. |
Month End Financial Summary – Assets and Liabilities Document | Base | No | Finance/Financial Statements | Displays a high level summary of assets & liabilities based upon general ledger accounts and customer accounts. |
Month End Financial Summary – Revenue, Taxes and Expenses Document | Base | No | Finance/Financial Statements | Displays a high level summary of revenue, taxes and expenses based upon general ledger accounts. |
Fiscal Year Journal Summary | Base | No | Finance/General Ledger | Displays a month-by-month total of amounts journalized to each GL account for the specified fiscal year. |
General Ledger for Post- Paid Accounts Receivable | Base | No | Finance/General Ledger | This is an audit/summary report of all journal entries made for post-paid payments, adjustments and invoices. |
General Ledger Journal Entries Audit | Base | No | Finance/General Ledger | Displays entries that do not balance. Includes a summary line on the grid that totals the debit column and the credit column. |
General Ledger Journal Entries Details | Base | No | Finance/General Ledger | Displays a list of all journal entries made for the specified criteria. Includes a summary line that totals the debit column and the credit column. |
General Ledger Micro Transactions Summary | Base | No | Finance/General Ledger | Provides a summary grid by “transaction type” of all micro transactions. |
General Ledger System Error Audit Summary | Base | No | Finance/General Ledger | Provides a row for each transaction/activity that has incurred a General Ledger system error (where journal entries, and related the debit and credit amounts, for a specific transaction are generated but the sum of the debits do not equal the sum of the credits). |
General Ledger System Error Audit Detail | Base | No | Finance/General Ledger | Provides a row for each journal entry of each transaction/activity that has incurred a General Ledger system error with an option to list correctly balanced transactions as well. This lets you see which entries were correctly posted to identify those that were missing and were replaced by the GL system error. |
Journalized Adjustments by Source | Base | No | Finance/General Ledger | Provides a breakout of the adjustments on the Month End Journal Entry report for auditing and reconciliation. |
Journalized Invoices by Source | Base | No | Finance/General Ledger | Provides a breakout of invoices on the Month End Journal Entry report for auditing and reconciliation. |
Journalized Payments by Source | Base | No | Finance/General Ledger | Provides a summary of payments for daily reconciliation, auditing and cross-referencing with Month End Journal Entry report and other reports. |
Journalized POS Transactions by Source | POS | No | Finance/General Ledger | Provides a breakout of POS transactions on the Month End Journal Entry report for auditing and reconciliation. |
Month End Anonymous GL Journal Entries | Base | No | Finance/General Ledger | Lists anonymous journal entries for the selected month/year and any other specified criteria. |
Month End General Ledger Journal Entries | Base | No | Finance/General Ledger | Displays breakout of accruals/reversal entries for future months, journal entries post date for a specified month, and summary line at bottom of grid. |
Month End GL Journal Entries by Source | Base | No | Finance/General Ledger | Provides a breakout of the journal entries to cross reference and audit with other general ledger reports. |
POS Micro Transactions by GL Subcode | POS | No | Finance/General Ledger | Provides a detailed grid by “POS transaction type” of all POS related micro transactions by location subcode and market subcode. |
T-Account Audit | Base | No | Finance/General Ledger | Displays debits and credits for each transaction. Used to satisfy third party general ledger audits. |
Deposit Liability Daily Balance | Base | No | Finance/Liabilities | Displays the daily starting balance, changes and ending balance of all the deposits in the system. |
Store Credit Liability Daily Balance | POS | No | Finance/Liabilities | Displays the daily starting balance, changes and ending balance of all the store credits in the system. |
Reseller Product and Usage Detail | Base | Yes | Finance/Wholesaler & Reseller Reports | Displays applicable product and usage totals by each product (SKU) and/or Usage Type, and then by the customer’s account number (for reseller) |
Reseller Product and Usage Summary | Base | Yes | Finance/Wholesaler & Reseller Reports | Displays applicable product and usage totals by each product (SKU) and/or Usage Type (for reseller) |
Wholesaler Product and Usage Detail | Base | Yes | Finance/Wholesaler & Reseller Reports | Displays applicable product and usage totals by each product (SKU) and/or Usage Type, and then by the customer’s account number, with columns for Cost and Cost Margins (for wholesaler) |
Wholesaler Product and Usage Summary | Base | Yes | Finance/Wholesaler & Reseller Reports | Displays applicable product and usage totals by each product (SKU) and/or Usage Type, with columns for Cost and Cost Margins (for wholesaler) |
Inventory
Name | Class | ULT | Folder | Description |
|---|---|---|---|---|
MIN Utilization Detail | Wireless | No | Inventory | Displays each MIN in the inventory with its associated status and, if it’s assigned, its associated MDN. |
NRUF Exception | Wireline | No | Inventory | Displays service numbers whose inventory has been marked as requiring NRUF reporting and which show up in more than one NRUF inventory. |
NRUF Form 502 – U1 Utilization | Wireline | No | Inventory | Lists how each block of 1000 service numbers for nonrural primary carriers is used or not used. |
NRUF Form 502 – U3 Utilization | Wireline | No | Inventory | Lists how each block of 1000 service numbers for rural primary carriers is used or not used. |
NRUF Sub-Category | Wireline | No | Inventory | Displays a list of each service number and its associated NRUF category and sub-category. |
NRUF Summary Forecast | Wireline | No | Inventory | Displays a summary of the utilization of service numbers by rate center. |
Service Number Aging | Base | No | Inventory | Displays the service numbers in inventory waiting to become available for reassignment based upon the defined number of grace days. |
OnlineBill
Name | Class | ULT | Folder | Description |
|---|---|---|---|---|
OnlineBill Accounts | OnlineBill | No | OnlineBill | Displays a list of customers using OnlineBill. |
Orders
Name | Class | ULT | Folder | Description |
|---|---|---|---|---|
Order Activity | Base | No | Orders | Displays all of the specific details for the requested order. |
Order Breakdown by Day | Base | Yes | Orders | Displays a breakdown of orders for each order status by day. |
Order Detail Document | Base | Yes | Orders | Displays detailed information about each order submitted for the selected time period. |
Order Summary by Group Document | Base | No | Orders | Displays a summary of orders by group including initial and additional grouping (order description, order state, order status, etc.) |
Order Threshold by Day | Base | No | Orders | Provides a real-time snapshot as to how fast orders are completing from a trending view point. |
Order Type Summary by Week Document | Base | No | Orders | Displays a summary per order type of the statuses by week during the date range selected. Also provides a summary of the Order State (status). |
Orders by Product Document | Wireline | No | Orders | Displays all ordered products by description and provides a total by the status (completed, submitted, in process, etc.). |
Swap Equipment | POS | Yes | Orders | Displays a row for each swap equipment transaction |
POS
Name | Class | ULT | Folder | Description |
|---|---|---|---|---|
Inventory Adjustment Detail | POS | No | POS Inventory/Adjustments & Inventory Counts | Displays each SKU per adjustment type on an inventory adjustment for the desired set-up criteria. |
Inventory Adjustment Summary | POS | No | POS Inventory/Adjustments & Inventory Counts | Displays a row per inventory adjustment transaction. Each row contains summary information about the inventory adjustment. |
Inventory Count Worksheet Document | POS | No | POS Inventory/Adjustments & Inventory Counts | Listing of retail products selected to be manually counted. |
Pending Approval Audit Document | POS | No | POS Inventory/Adjustments & Inventory Counts | Beginning and ending detail of the resulting adjustment(s) created by approval of an inventory count. |
Pending Approval Audit of Counted Serialized Items | POS | No | POS Inventory/Adjustments & Inventory Counts | One listing of Equipment IDs across all SKUs in the about-to-be-approved inventory count. |
Loaner and Rental Inventory Audit | POS | No | POS InventoryLoaners & Rentals | Displays inventory levels of loaner and rental retail products. |
Back Office Receipt Number Audit | POS | No | POS Inventory/Management | Displays a row per each transaction performed by POS. This is a simple ‘audit’ report that crossreferences the receipt number with the BO transaction type. |
Inventory Activity | POS | No | POS Inventory/Management | Displays a row per SKU per inventory status per selected location. Each row provides a column to display the total quantity (increase or decrease) per the noted transactions over a defined time range. |
Location Stock Replenishment | POS | No | POS Inventory/Management | Displays a row per SKU that has a current on-hand quantity that is below the configured restock minimum level for the desired store location. |
Master SKU | POS | No | POS Inventory/Management | Displays a row of data per each product in the product catalog that has a SKU. |
Serialized Item History | POS | No | POS Inventory/Management | Displays a row per transaction that the SKU/Equipment ID has been included in. This includes BO and Sales Transactions. |
Serialized Retail Product History | POS | No | POS Inventory/Management | Displays all serialized items for the location for the serialized SKU and the first inventory transaction recorded for that SKU. |
Stock Evaluation Non-Serialized Item Detail | POS | No | POS Inventory/Management | Displays a row per each non-serialized retail product per status in inventory. |
Stock Evaluation Serialized Item Detail | POS | No | POS Inventory/Management | Displays a row per each equipment ID (serial number) in inventory per location. |
Stock Evaluation Summary | POS | No | POS Inventory/Management | Displays a row per each retail product per inventory status in inventory. This report is a combined list for serialized and non-serialized retail products. |
Purchase Order Detail | POS | No | POS Inventory/Purchase Orders | Displays a row per each SKU line item on a purchase order for the desired set-up criteria. |
Purchase Order (Document) | POS | No | POS Inventory/Purchase Orders | Displays details for the requested purchase order, including item, description, cost, quantity and extended cost. Also included is the to information and the PO reference number, account number and ship-to information. |
Purchase Order Summary | POS | No | POS Inventory/Purchase Orders | Displays a row per purchase order transaction. Each row contains summary information about the PO. |
Receiving Detail | POS | No | POS Inventory/Receiving | Displays a row per each SKU line item on a receiving transaction for the desired set-up criteria. |
Receiving Summary | POS | No | POS Inventory/Receiving | Displays a row of summary information per receiving transaction. |
Return to Agent Transfer Document | POS | No | POS Inventory/Transfers | Displays details for the requested return-to-agent transaction, including item, description and quantity, as well as sales agent name, ship-to information, and return information. |
Solicited and Unsolicited Transfer Document | POS | No | POS Inventory/Transfers | Displays details for the requested transfer, including item, description, cost, quantity and extended cost. Also listed is the transfer-to and transfer-from information and the reason. |
Transfer Detail | POS | No | POS Inventory/Transfers | Displays a row per each SKU line item on a transfer for the desired set-up criteria. |
Transfer Summary | POS | No | POS Inventory/Transfers | Displays a row per transfer transaction. Each row contains summary information about the transfer. |
Cash Posting Analysis Document | POS | No | POS Register/Management | Provides a snapshot or summary view of tender data. |
EOD Store Detail | POS | No | POS Register/Management | Provides a row per store by reconciled tender type for the chosen dates and location. |
EOD Store Summary by Day | POS | No | POS Register/Management | Provides a row per store of user counts, system expected amounts and store overages/shortages for the chosen dates and location. |
EOD Transaction Count per Tender Type | POS | No | POS Register/Management | Displays a summary of tender type per store of sales transactions for the chosen dates and location. |
Open Register Audit | POS | No | POS Register/Management | Displays a row per each accepted tender type for the register’s location |
Open Register Audit Document | POS | No | POS Register/Management | As above in document form |
Reconcile Exception (Unreconciled Registers) | POS | No | POS Register/Management | Displays a row for each non-reconciled (open) register for the desired location(s) and date range, validating all registers reconciled prior to GL posting. |
Registers | POS | No | POS Register/Management | Displays all the back office register setup information at the store level, by location, plus how many registers are assigned and to whom. |
Drawer Detail | POS | No | POS Register/Operations | Provides a row per transaction and tender used for each POS register/drawer No Sale transaction. |
Receipt Number Audit | POS | No | POS Register/Operations | Displays a row per transaction performed by POS. It serves as a cross reference between the receipt number and transaction type. |
Register Reconciliation Detail | POS | No | POS Register/Operations | Displays the last reconciliation (closed) transaction for registers by tender types for the chosen Location and date range. |
Register Reconciliation Summary | POS | No | POS Register/Operations | Displays a row per reconciled register for the chosen Location and date range. |
Register Tender Detail Audit | POS | No | POS Register/Operations | Provides a row per tender used for each POS sale and no sale transaction performed. A row is displayed for tender involved in the transaction, including a row for the change amount. |
Sales Tender Audit | POS | No | POS Register/Operations | Displays a row per tender used for each POS sale transaction performed. |
Transaction Activity Detail Document | POS | No | POS Register/Operations | Displays a formatted layout presentation front office transaction details. |
Loaner and Rental Activity | POS | No | POS Sales/Loaners & Rentals | Displays loaner and rental activity for a specified location and date range |
Corporate Check Refund | POS | No | POS Sales/Management | Displays a row for every sales return transaction that was tendered to corporate check. |
Sales by Associate/Sales Channel by SKU | POS | No | POS Sales/Management | Displays data per sales person (and by location if chosen) per SKU sold. |
Sales by Inventory Category | POS | No | POS Sales/Management | Displays sales data per inventory category sold, displaying counts and amounts per assigned inventory. |
Sales by SKU | POS | No | POS Sales/Management | Displays sales data per SKU sold. Only products sold that have a SKU are displayed. |
Sales Summary by Store by Day | POS | No | POS Sales/Management | Displays sales data per POS location by day; used for measuring store productivity. |
Sales Summary by Store | POS | No | POS Sales/Management | Displays sales data per POS location, containing net result counts, amounts of retail and billing products sold, retail discounts, taxes, payments, and deposits. |
Sales Summary by User | POS | No | POS Sales/Management | Displays sales data per POS user (clerk) who tendered the sales transaction. |
Serialized Retail Product Sales Audit | POS | No | POS Sales/Management | Displays a row for each serialized retail product line item sold or returned through a POS make Sale transaction for a particular location over a specified timeframe. |
Sales Detail by Store | POS | No | POS Sales/Operations | Displays sales data per POS location, including counts and amounts of retail and billing products sold, retail discounts, taxes, payments and deposits. |
Sales Detail | POS | No | POS Sales/Operations | Displays a row of detail for each line item of a sales transaction, for the selected date range. |
Sales Summary | POS | No | POS Sales/Operations | Displays sales data per POS transaction, separating amounts by retail products, retail discounts, taxes, deposits, billed amount total and transaction Total. |
Return Receive Detail | POS | No | POS Sales/Return Request & Return Receive | Displays a row of data per POS return receive line Item per transaction. |
Return Receive Summary | POS | No | POS Sales/Return Request & Return Receive | Displays a row of data per POS return receive transaction. |
Return Request Detail | POS | No | POS Sales/Return Request & Return Receive | Displays a row of data per POS return request line item per transaction. |
Return Request Summary | POS | No | POS Sales/Return Request & Return Receive | Displays a row of data per POS return request transaction. |
Fulfillment Request Detail | POS | No | POS Sales/Sales Request & Fulfillment | Displays a row of data per POS sales request line Item per transaction. |
Fulfillment Request Summary | POS | No | POS Sales/Sales Request & Fulfillment | Displays a row of data per POS fulfillment request transaction. |
Fulfillment Sale Detail | POS | No | POS Sales/Sales Request & Fulfillment | Displays a row of data per POS fulfillment sale line Item per transaction. |
Fulfillment Sale Summary | POS | No | POS Sales/Sales Request & Fulfillment | Displays a row of data per POS fulfillment sale transaction. A fulfillment sale transaction is the result of a completed fulfillment request. |
Sales Request Detail | POS | No | POS Sales/Sales Request & Fulfillment | Displays a row of data per POS sales request line item per transaction. |
Sales Request Summary | POS | No | POS Sales/Sales Request & Fulfillment | Displays a row of data per POS sales request transaction. |
Sales and Use Tax Summary | POS | No | POS Sales/Taxes | Provides a row of data per sale, return, exchange, and bill payment transaction. |
Sales Detail with Taxes | POS | No | POS Sales/Taxes | Displays details for each line item of a sales transaction with additional columns that display tax details. |
Sales Request and Use Tax Summary | POS | No | POS Sales/Taxes | Provides a row of data per sales request and return receive transaction. |
Sales Request Detail with Taxes | POS | No | POS Sales/Taxes | Provides a row of data per POS sales request and return receive line Item per transaction. In contrast to the Sales Request Detail report, this report provides additional columns for tax details. |
Sales Request Summary with Taxes | POS | No | POS Sales/Taxes | Provides a row of data per POS sales request and return receive transaction. In contrast to the Sales Request Summary report, this report provides additional columns for tax details. |
Sales Request Tax Summary by Location | POS | No | POS Sales/Taxes | Provides a row per POS transaction (POS sales request and return receive). |
Sales Summary with Taxes | POS | No | POS Sales/Taxes | Displays details for each line item of a sales transaction with additional columns that display tax details. |
Sales Tax Summary by Location | POS | No | POS Sales/Taxes | Displays a row of retail sales and use tax data per Location per a selected date range. |
Tax Exempt Sales Detail | POS | No | POS Sales/Taxes | Provides a row per tax applied per line item of a POS Transaction. |
Tax Exempt Sales | POS | No | POS Sales/Taxes | Displays data per sales transaction line item containing any tax exemptions. |
Roaming
Name | Class | ULT | Folder | Description |
|---|---|---|---|---|
Agreements Reaching Disconnect | Wireless | No | Roaming | Displays roaming partners whose roaming agreements are nearing the end of their contract. (SIDs only). |
CIBER Cellsite Usage Type | Wireless | No | Roaming | Displays roaming usage for a bill period by cell site and usage type, with one row for each CIBER record. |
CIBER Outcollects by Batch | Wireless | No | Roaming | By day of the week and date, this provides a list of outcollects by carriers with details such as number of calls, minutes and charges, and rate plan information. |
CIBER Outcollects by Day | Wireless | No | Roaming | By day of the week and date, this provides a list of outcollects by carriers with details such as number of calls, minutes and charges, and rate plan information. |
Incollect (Company) Returns Document | Wireless | No | Roaming | Displays return records by carrier ID that cannot be processed and are tagged as possible returns to be sent to the clearinghouse. |
Incollect Document | Wireless | No | Roaming | Displays details of incollect traffic including carrier ID, sequence numbers, record count, minutes and charges by the specified dates. |
Incollect Rejections Document | Wireless | No | Roaming | Displays information on records that were received as incollects and were rejected. Totals are grouped by reject code and the reject description. |
Incollect Export | Wireless | No | Roaming | Displays the details of incollect traffic including carrier ID, sequence numbers, record count, minutes and charges by the specified dates. |
Incollects Rerate | Wireless | Yes | Roaming | Displays a listing of incollect records for a bill period, including minutes at wholesale cost as well as prediscount and postdiscount. |
Missing BIDs | Wireless | No | Roaming | Displays incollects that may be rated incorrectly because the serving SID/BID is unknown. |
Outcollect (Partner and ARP) Returns Document | Wireless | No | Roaming | Displays a list of CIBER outcollects that are returned by the clearinghouse for various reasons. |
Outcollect Document | Wireless | No | Roaming | Displays a list of CIBER outcollects sent to the clearinghouse, including sequence number, number of records, minutes and charges. |
Outcollect Export | Wireless | No | Roaming | Displays a list of CIBER outcollects sent to the clearinghouse, including sequence number, number of records, minutes and charges. |
Settlement (Document) | Wireless | No | Roaming | Provides a snapshot of outgoing traffic over a specified time period, including the net charges for the associated roaming partner. |
Settlement Export | Wireless | No | Roaming | Provides a snapshot of outgoing traffic over a specified time period, including the net charges for the associated roaming partner. |
TAP Cellsite Usage Type | Wireless | No | Roaming | Displays roaming usage for a bill period by cell site and usage type, with one row for each TAP record. |
TAP Outcollects by Batch | Wireless | No | Roaming | Displays a list of outcollects by carriers with details such as number of calls, minutes and charges, and rate plan information by week and date. |
TAP Outcollects by Day | Wireless | No | Roaming | Displays a summary of outcollects by carriers with details such as number of calls, minutes and charges, and rate plan information by week and date. |
Unassigned SIDs | Wireless | No | Roaming | Displays SIDs that are not part of a roaming agreement, indicating that the billing cycle is not up to date. |
Sales
Name | Class | ULT | Folder | Description |
|---|---|---|---|---|
Active Accounts by Sales Person | Base | Yes | Sales | Sales rep identification and code along with the number of active accounts per sales rep. Provides drilldown ability to 2 more levels for customer detail. |
Contract Sales Detail by Service Number | Base | Yes | Sales | Displays detail information regarding wireless contract changes to service numbers. |
Contract Sales Summary | Base | Yes | Sales | Displays summary information regarding wireless contract changes to service numbers. |
Detail Charges by Sales Channel | Wireline | Yes | Sales | Displays detailed information per customer account. |
Feature Distribution Summary | Wireless | Yes | Sales | Displays all features (plans, discounts, products, etc.) that are active on the From Date and the change activity through the To Date. |
Feature Sales Detail | Base | Yes | Sales | Displays detail information regarding wireless feature changes to service numbers. |
Feature Sales Summary | Base | Yes | Sales | Displays summary information regarding wireless feature changes to service numbers. |
Orders by Referral Source | Base | Yes | Sales | Displays information on how successful certain promotions are. |
Orders Per Sales Rep Document | Base | Yes | Sales | Displays the status of order activity associated to the sales person during the selected date interval. |
Orders Per Sales Rep | Base | No | Sales | Displays the status of order activity associated with the sales person during the selected date interval. |
Plan Distribution Summary | Wireless | Yes | Sales | Display the plans that are active on the From Date and the change activity through the To Date. |
Plan Sales Detail | Base | Yes | Sales | Displays detail information on wireless rate plan changes to service numbers. |
Plan Sales Summary | Base | Yes | Sales | Displays summary information on wireless rate plan changes to service numbers. |
Sales Order Detail | Base | Yes | Sales | Lists details of order information by sales representatives; can be used to calculate sales commissions. |
System
Name | Class | ULT | Folder | Description |
|---|---|---|---|---|
Annual Period Report Statistic | N/A | No | System | Internal report, requires BCT permission. |
All Invoice Reports | Base | No | System | Displays a list of all invoice reports including report IDs and description. |
Assigned Catalog Items | Base | Yes | System | A row for every assigned catalog item on each service. |
Assigned Product by USOC | Wireline | Yes | System | A list of products with assigned USOC, with account number, customer name, etc. |
Catalog Items by Class of Service | Wireline | No | System | Displays products grouped by class of service predetermined by the customer. |
Catalog Items by Exclusive Groups | Base | No | System | A row for every catalog item, by exclusive group, with its description, alias, and other product type information. |
Contracts | Base | No | System | Displays all established contracts and includes SKU, description, length, and available and discontinue dates. |
Data Management | Base | No | System | A list of all the values and additional information in the Data Management section of Admin Console. |
Discounts | Base | No | System | Provides audit information on discounts including description, available and discontinue dates, children, associative type, processing order and GL account. |
File Process Log | Base | No | System | A list of system files that were automatically processed by the IDI platform |
Hunt Groups | Wireline | No | System | A list of what hunt groups are assigned to what accounts (including hunt activity and telephone/terminal numbers) |
Invoice Formats | Base | No | System | Displays details on existing invoice formats including the description, attributes, E-pay logic, and rules. |
Order Type Configuration | Base | No | System | Displays information about each order type and the work plans and task plans associated with it. |
Pricing Plans | Base | No | System | Displays a layout of pricing plans and their configuration. |
Pricing Plans Overview | Base | No | System | Displays all pricing plans and their associated rate plans. |
Products and Packages | Base | No | System | Displays a flattened view of the product catalog, showing pertinent details of all products. |
Provisioning Companies | Wireline | No | System | Displays provisioning companies, account number and account ID information as well as CIC information. |
Rates Summary | Base | No | System | Displays an overview of either all, or specified rate plans with all their associated details. |
Retail Products | Base | No | System | A view of all retail products with their SKU and their details. |
Sales Channels | Base | Yes | System | Displays data such as name, address, email, start/end date, and parent relationship on sales channels. |
Security User Profiles | Base | No | System | Displays a list of users and their security permissions, groups, password changes and related details. |
Service Types | Base | No | System | Displays service types and characteristics of inventory rules default billing statuses and tax class and method. |
Taxes
Name | Class | ULT | Folder | Description |
|---|---|---|---|---|
Billed Taxes | Base | No | Taxes | Displays a summary of the taxes assessed; customer can then drill down to see the specific invoices that contain the selected tax. |
Billed Taxes Detail | Base | No | Taxes | Displays specific invoices from a bill period to which the selected tax was applied. Drills down to the customer to whom the invoice belongs. |
Product Tax | Base | No | Taxes | Displays taxes assessed, by customer, on chargeable products for the selected bill period. |
Product Taxability by Tax ID | Base | No | Taxes | Displays all taxable products and the applicability of the selected tax ID. Drill down on any product to see its detailed product catalog entry. |
Retail Tax Log by Market | POS | No | Taxes | Lists retail taxes paid, by market, for the specified date range. |
Retail Tax Log | POS | No | Taxes | Displays taxes due to the taxing entities, grouped by state. Tax is included for any sales finalized within the date range or between bill cycle start date and bill cycle end date. |
State Overview Document | Base | No | Taxes | Displays all state and local taxes with key details. Listed first are State taxes, followed by county, city and regional taxes. |
Tax Basis Details | Base | No | Taxes | Displays a breakdown of all applicable taxes to the selected invoice. Drills down to the customer to whom the invoice belongs. |
Tax Changes Detail | Base | No | Taxes | Displays a tax change reason detail with state-level release notes. Individual tax detail data groups by tax release and state. |
Tax Changes Document | Base | No | Taxes | Displays a summary heading for the tax release and a subheading for each state including state-level release notes followed by the individual tax detail data for the state. |
Tax Changes Summary | Base | No | Taxes | Displays state-level release notes for all tax releases in the specified date range. |
Tax Log | Base | No | Taxes | Displays taxes due to the taxing entities, grouped by state. If an invoice group is specified, it displays all taxes due for this group. |
Tax Log Summary by Market | Base | Yes | Taxes | Displays taxes due to the taxing entities, grouped by market. If an invoice group is specified, it displays all taxes due for this group. |
Tax Updates and Additions | Base | No | Taxes | Displays a listing of all additions or changes to the tax database in the specified interval, grouped by state. |
Taxes Per Billing Period | Base | Yes | Taxes | Displays the number of invoices and the total tax amount for any tax affecting the specified billing period. Drill down on any of the displayed taxes to access the invoice details, and from there, the associated customer. |
Troubles
Name | Class | ULT | Folder | Description |
|---|---|---|---|---|
Trouble Resolution Document | Base | No | Troubles | Displays all closed troubles by resolution type, along with duration information. |
Trouble Tickets by Day | Base | No | Troubles | Displays the total number of troubles opened in a specified date range, broken out by day of the week. |
Trouble Tickets Hold Document | Base | No | Troubles | Displays all troubles that were ever in a hold state, in the specified date range, by resolution type, along with duration information. |
Troubles and Follow-ups Document | Base | No | Troubles | Displays summary information for any open trouble tickets and follow-ups during the specified date range. |
Usage
Name | Class | ULT | Folder | Description |
|---|---|---|---|---|
All Usage Detail by Customer | Base | Yes | Usage | Displays all usage detail for the selected customer during the chosen date range. |
CDR File Summary | Base | No | Usage | Displays a summary with file information, location of all records for each file, and the counts of each location per file. |
Cellsite Usage | Wireless | No | Usage | Displays summary of billable wireless usage for all cellsites during specified date range. |
Cellsite Usage Document | Wireless | No | Usage | Same as above in document form. |
Customer Usage Super Summary | Wireline | Yes | Usage | Displays a history of usage type, distance type and service number. |
Data Usage Summary | Wireless | No | Usage | Summary of data usage. |
Discounted Usage Per Account | Wireless | Yes | Usage | Displays discounted usage for the specified service number and bill period. |
Duplicates by File | Base | No | Usage | Displays the file name, number of duplicates, file format, and initial parse date of files that contain duplicate records. |
Excessive Usage | Wireless | No | Usage | Displays customers with excessive home, toll and/or roaming minutes. |
High Usage Summary Document | Wireline | Yes | Usage | Displays customers who have a high number of calls – exceeding a specified number of minutes or a specified number of calls. |
More Roam Than Home | Wireless | Yes | Usage | Displays roaming call details and identifies customers who are breaking their contract. |
Pricing Plan Summary by Market | Wireline | Yes | Usage | Displays the total of calls, minutes, charge and cost grouped by market, pricing plan and usage type. |
Purged Records by Request | Base | No | Usage | Displays the number of records that were purged by request. |
Service Number Usage History | Wireline | No | Usage | Displays all historical usage details for a selected service number. |
Service Type Summary by Market | Wireline | Yes | Usage | Displays a list, by market, of services and their usage type and details. |
Terminating Country Super Summary | Wireline | Yes | Usage | Displays detailed usage for international calls by terminating country. |
Terminating State Super Summary | Wireline | Yes | Usage | Displays detailed usage for calls by terminating state. |
Usage by Billing Period | Wireline | No | Usage | Displays a summary of the usage by billing period ending date. |
Usage by Carrier | Wireline | Yes | Usage | Displays each carrier and a summary of their usage by service type, broken down by usage and distance types. |
Usage by Carrier by Orig State | Wireline | No | Usage | Displays each carrier and a summary of their usage by service type, broken down by usage and distance types. |
Usage by Customer | Wireline | Yes | Usage | Displays a summary of the usage associated with each customer for the selected billing period. |
Usage by Customer Region Summary Document | Wireline | Yes | Usage | Displays a summary of the number of calls and minutes used by market, sub-grouped by region for bill period. |
Usage by Customer Wireless | Wireless | Yes | Usage | Displays a summary of the billable usage for all wireless customers. |
Usage by Day | Base | No | Usage | Displays an overall visual of CDR traffic to be billed for the bill period; can be used to verify that there are no missing CDR records before monthly billing occurs. |
Usage by Distance Type | Wireline | Yes | Usage | Displays a summary of a customer’s usage by distance type along with the associated plan. |
Usage by Hour | Wireless | No | Usage | Displays, by day, the number of billable call records loaded for the usage file format selected. Can be used to monitor usage traffic trending to see if usage records are missing. |
Usage by LATA | Wireline | Yes | Usage | Displays each LATA, service type and usage type, the # of minutes, # of calls and the cost, charge, profit and margin. |
Usage Over Threshold | Wireline | Yes | Usage | Displays an evaluation of individual call charges where the amount is in excess of the threshold entered by the user. |
Usage Summary by Service Type | Wireline | Yes | Usage | Displays a list, by market, of services and their usage type and details. |
Zero Usage by Customer | Base | Yes | Usage | Displays a list of all customers who show no usage for the selected bill period. |
Zero Usage by Service Number | Base | Yes | Usage | Displays customers, with service numbers, who show no usage for the selected bill period. |