What is a Short Report?
The short report is concise and has limited information available in it. However, the short report can be configured and scheduled as per requirement. You can generate a short report for a custom period, monthly, weekly, or per invoice.
Follow https://ingrammicro-assist.freshdesk.com/en/support/solutions/articles/66000396564-10-how-to-generate-and-download-the-billing-data-export-report-from-the-control-panel for How to Generate and Download the Short Rated Data Export Report from Reseller Control Panel.
Below is the sample table showing the fields included in a Short Report.
New Billing Data Export (short view) | Example value | Column description |
Reseller ID | 1000105104 | Reseller account ID. |
Reseller Company Name | CloudSoft LTD | The company name of a reseller account. |
Customer Account ID | 1000105107 | Customer account ID. |
End Customer Name | Helent’s Company | The company name of an end customer account. |
Subscription ID | 1173522 | Subscription ID. |
Subscription Name | Microsoft 365 Business (Monthly Pre-Paid) | Subscription name. By default, it matches the plan name. |
Subscription Expiration Date | 2022-04-01 | Subscription expiration date. |
Plan ID | 119458 | The ID of an end customer’s plan. |
Source Delegated Plan ID | 67021 | The ID of an Ingram Micro Cloud (IMC) plan. It is used to identify which IMC plans were sold to end customers. |
Source Delegated Resource ID | 33215 | The ID of an IMC resource. It is used to identify which IMC resources were sold to end customers. |
Detail Type | Plan Recurring | Order detail type. |
Description | Subscription #1173522: Microsoft 365 Business (Monthly Pre-Paid) Recurring | Description for an order detail. |
Order Number | SO000001 | The number of an end customer’s order. |
Order Type | SO | The type of an end customer’s order. If it is a new billing data export, an order type abbreviation is used instead of a full name: Ø SO – sales order Ø BO – billing order Ø CH – change order Ø CL – cancellation order Ø RN – renewal order |
Extended Price | 54.54 | The total cost of a plan or resource for a reseller. |
Unit Price | 18.18 | The per-unit cost of a plan or resource for a reseller. |
Quantity | 3 | The number of purchased resources. |
Duration | 1 | The reseller’s charge duration. |
Contract Period | 1 | Subscription period. In the new billing data export, the component contract period column is split into two separate columns: Ø Contract Period – period length (1, 2, 12, 8); Ø Contract Period Type - period type (MONTHS, YEARS)
|
Contract Period Type | YEARS | |
Billing Period | 1 | Subscription billing period. In the new billing data export component, the contract period field is split into two separate columns: · Billing Period – period length (1, 2, 12, 8); · Billing Period Type – period type (MONTHS, YEARS) |
Billing Period Type | MONTHS | |
Invoice Date | 2019-04-02 | The date that a reseller’s invoice was issued by IMC. |
Purchase Date | 2019-04-01 | The date that a subscription was purchased. |
Pretax Total | 54.54 | The amount before taxes |
Start Date | 2019-04-01 | The reseller’s charge start date. |
End Date | 2019-05-01 | The reseller’s charge end date. |
Last Billing Date | 2019-04-01 | The most recent date that a subscription was billed. |
Next Billing Date | 2019-05-01 | The date that a subscription will be billed next. |
End Customer Unit Price | 24.21 | The reseller’s sales amount of a resource or plan, per unit. |
End Customer Extended Price | 72.63
| The total sales amount of a plan or resource per order detail. |
SKU | 2b3b8d2d-10aa-4be4-b5fd-7f2feb0c3092 | SKU ID. |
Custom Account ID | CUST-001 | External Account ID. Can be used for integration with external systems. |
Purchase Order Number | PO-4352 | Purchase Order number information. Can be used for integration with external systems. |