> ## Documentation Index
> Fetch the complete documentation index at: https://docs.m3ter.com/llms.txt
> Use this file to discover all available pages before exploring further.
# Prepayments Data Explorer
You can use the *Prepayments Data Explorer* to configure and perform queries against the Prepayments/Commitments data for your Organization in m3ter. You can quickly set up and submit a query that returns the Prepayments data set needed for your current analytical purposes. You can then review the data in either a Summaries or a Data Table format.
When a query succeeds for Prepayments data, you can also review:
* Remaining obligations due on Prepayment as month-on-month amounts for the remainder of the Prepayment service period.
* Draw-down amounts made against the Prepayment at billing.
This topic explains how to work successfully in the Prepayments data explorer to configure and perform queries against your Prepayments data and review returned data.
**Important! Required Permissions for performing Prepayment queries in Data Explorer**. If you create a Custom Permission Policy to assign to your Organization Users and want Users to be able to perform Prepayment queries in Data Explorer and view the results, ensure the Permission Policy allows:
* Create and Retrieve action for the `config:analyticsJob` Resource.
* Retrieve action for the `config:commitment` Resource.
For more details on working with Permission Policies, see [Understanding, Creating and Managing Permission Policies](/guides/organization-and-access-management/creating-and-managing-permissions).
**Tip: Prepayments on Accounts?** For more details on Prepayments and creating them for an Account, see [Creating Prepayments for Accounts](/guides/end-customer-accounts/creating-prepayments-for-accounts).
## Building and Performing a Prepayments Data Query
**To submit queries for Prepayments data and review returned data:**
1. Select **Accounts>Prepayments Data Explorer**:
The **Prepayments Data Explorer** page opens and you can use the **Prepayments query builder** to build the specific query you want to perform against Prepayments data collected for your Organization.
2. In the **Select period** section, define a period for returning Prepayments data:
* **Time period**. Use the drop-down list to select a period. If a Prepayment has a start date that falls in the period, then its data will be returned for the query.
* **Today**. All of today - that is, the 24 hour period from midnight to midnight. This saves you from having to reset the query time period to catch other new Prepayment data that become available later that same day. (*Default*)
* **Yesterday**. All of yesterday - that is, the 24 hour period from midnight to midnight yesterday.
* **Week to date/Month to date**. Period covering the current week/month to date. For example, selecting **Month to date** on April 8th, 2024 means your query returns data for the time period starting April 1st, 2024 and including the entire current day - April 8th - and ending at midnight. This saves you from having to reset the query time period to catch other new Prepayment data that become available later that same day.
* **Last 7/30/90/120 days**. Period covering the selected number of whole days leading up to today. For example, selecting **Last 30 days** on April 8th, 2024 means your query returns data for the time period commencing 30 days prior - March 9th, 2024 - and ending midnight on April 7th, 2024.
* **Previous week/month/quarter**. Period covering the entire previous week/month/quarter. For example, selecting **Previous month** on April 8th, 2024 means your query returns data for the whole of March 2024.
* **Custom**. Define the time period for which you want your query to return data.
* If you want to define a specific period, you can use **Custom**:
* **Start (inclusive)** and **End (exclusive)**. If you select **Custom** for the query **Time period**, these date/time fields will be enabled. You can use calendar popups to define the start and end dates/times for a custom period.
* Start dates are explicitly labeled as *inclusive* and End dates as *exclusive*. For example, if you want data returned for the entire month of June 2023, you must set the **Start date** at June 1st 2023 and the **End date** at July 1st 2023. If you set the **End date** at June 30th 2023, the Custom Time period for your query will end at midnight on June 29th 2023.
3. In the **Apply an account filter** section, select the **Accounts** you want to the query to return Prepayments data for:
* **All Accounts**. Data will be returned for all Accounts for which Prepayments have been created.
* **Selected Accounts**. Use the drop-down to select the Accounts you want to return Prepayments data for.
In this example we have:
* Selected a single Account to return Prepayments data for.
* Selected a **Custom** time period. The Organization Timezone is set to **UTC**.
4. Select **Perform query**. The query executes and the resultant data is loaded into the **Summaries** panel and **Data Table**.
**Note: Prepayment Start Date must fall in selected period!** The query will only return data for Prepayments on the selected Accounts for Prepayments whose *start date falls in the selected time period*.
**Important: Limits imposed on response payload size and number of rows!**
* **Response too Large:** If the response payload for your query is **>10MB**, this exceeds the limit and you'll receive an error message to inform you. You can either use the available filters to further limit the query result set and re-run your query or use the **Export** button to download the current results in a `.csv` formatted file - see [Exporting Query Results](/guides/data-explorer/exporting-usage-query-results).
* **Number of Rows Returned for Query:** If the number of rows returned by your query exceeds **5001** but the payload size limit is not exceeded, then only the first **5001** are loaded. You will not receive an error and if you suspect your query return contained more rows, we recommend you use the **Export** button to download the results in a `.csv` formatted file and check.
* **Number of Rows for Export:** If you download the query results in a `.csv` formatted file, the number of rows is limited to **20001**.
## Reviewing Prepayments Data Query Results in a Summaries Table
You can review the Prepayments data returned for your query in a **Summaries** table:
**Tip: Multiple Prepayments Data?** If your query has returned data for multiple Prepayments - either for a single Account or across multiple Accounts - you can use the **Prepayment** drop-down to select which one you want to review.
## Reviewing Prepayment Data Query Results in a Data Table
You can review the Prepayments data returned for your query in a data **Table**:
* In **Prepayments - Table**:
**Tip: End Date shown in Results Data differs from end date set for query?** The **End date** shown for the returned data, both in the **Prepayments - Summaries** panel and in the **Prepayments - Table**, might not be the same as the **End date** you've set for a query. This is because a Prepayment spans an entire contract period, and is not simply a minimum spend amount to be charged on a bill-by-bill basis. The **End date** shows as the *end date of the Prepayment contract period*, which in this example is January 1st 2025.
You can reorder the columns for the **Prepayments - Table**.
**To reorder columns:**
1. Select the column icon at top-right:
A panel appears listing the available table columns.
2. Drag-and-drop these into a top-bottom ordering to correspond to the left-right ordering you want for the **Prepayments - Table**:
3. Select **Update**. The panel closes and the **Prepayments - Table** refreshes for the selected column order:
**Tip: Exporting Prepayments Data?** You can use the **Export** button to create a `.csv` file of your returned Prepayments data. See [Exporting Query Results](/guides/data-explorer/exporting-usage-query-results) for more details.
## Reviewing Remaining Obligations for Prepayments
You can use the **Obligations** panel to review the remaining obligations due under the Prepayment service period:
* Note that you can reorder the columns in the **Obligations** table in the same way as you can in the **Prepayments - Table**. See the [previous section](/guides/data-explorer/performing-commitments-queries-and-reviewing-results#reviewing-prepayment-data-query-results-in-a-data-table) for details.
**Tip: Export Prepayment Obligations?** You can select **Export** on the **Obligations** panel to export the remaining obligations as a `.csv` format file, which is downloaded to the Downloads folder on your local machine.
## Reviewing Prepayments Billing Information
You can scroll down in the **Prepayments** tab to review a **Billing** panel. This gives details of amounts drawn-down against Prepayments at billing:
* Note that you can reorder the columns in the **Billing** table in the same way as you can in the **Prepayments - Table**. See the [section above](/guides/data-explorer/performing-commitments-queries-and-reviewing-results#reviewing-prepayment-data-query-results-in-a-data-table) for details.
**Tip: Export Prepayment billing details?** You can select **Export** on the **Billing** panel to export the billing details as a `.csv` format file, which is downloaded locally.
**Tip: Saving Prepayments Queries?** You can save, update already saved, and re-use saved Prepayments queries. You can also load pre-configured *Standard Queries* directly into the Query Builder. See [Saving, Updating, and Re-Using Queries](/guides/data-explorer/saving-queries).