> ## Documentation Index
> Fetch the complete documentation index at: https://docs.m1amdocs.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Daily Subscription Extract

**Note:** This report is intended for Resellers (Service Providers) using the [Platform-managed product lifecycle](g_platformManagedFlow) and Commerce Engine.

Partner Ecosystem Management's Daily Subscription Extract shows the changes made to subscriptions the previous day. Data changes for each Merchant's product are shown. For example, changes can include subscription creations, deletions, and cancellations.

The Daily Subscription Extract is your source of truth for subscription data. Use the Daily Subscription Extract report to check the accuracy of your system data. If there are any differences in subscription data, update your data to reflect what's in the Daily Subscription Extract.

Any changes that have occurred to subscriptions in the Daily Subscription Extract can happen for a variety of reasons. For example, Partner Ecosystem Management and/or the Merchant may discover and resolve differences in customer subscription data during [Reconciliation](m_reconciliationAbout). Reconciliation is a process that's available to Merchants through Partner Ecosystem Management. Reconciliation allows Merchants to identify any subscription data in their system that differs from Partner Ecosystem Management's data. Depending on the difference, either the Merchant or Partner Ecosystem Management can take action to resolve the issues before they become customer issues.

This file is generated daily.

The Daily Subscription Extract consists of the following files:

* **Subscription\_Updates\_yyyymmddThhmmssZ \_v2.csv**: A CSV file that contains subscription changes that happened the previous day. Only data from partnered organizations is included.
* **Subscription\_Updates\_yyyymmddThhmmssZ\_v2.man**: A MAN file that contains the time and date the extract began, the time and date it ended, and the number of records in the CSV file. If there are no records on a given day, the manifest file will be empty.

## Subscription Updates CSV File Fields

| Field Name | Format | Description |
| - | - | - |
| Account ID | Alphanumeric string (up to 128 characters) | The ID of the account the subscription belongs to. |
| Parent Account ID | Alphanumeric string (up to 128 characters) | This field is only populated if the account has a parent account. |
| Subscription ID | Alphanumeric string (up to 128 characters) | The ID of the subscription in Partner Ecosystem Management. |
| Billing Plan ID | Alphanumeric string (up to 128 characters) | The subscription billing plan ID in Commerce Engine. |
| Payment Method Type | Alphanumeric string (up to 128 characters) | The payment method for the subscription. |
| Subscription Status | Alphanumeric string (up to 50 characters) | The subscription status in Commerce Engine's record. Valid values are: - **Active**: The subscription is actively granting entitled service and billing in accordance with the assigned billing plan and associated subscription items. - **Pending Cancel**: The subscription is active but scheduled for cancellation. The subscription will leave active service at the current end date. - **Cancelled**: The subscription is no longer actively granting service. It has been canceled due to user, merchant, or system action. For example, the customer has opted out of recurring billing or canceled the service; API calls to cancel the subscription or stop billing on the customer have been made; or if a chargeback is received against a transaction generated by the subscription. Canceled is a terminal and permanent status. Note that the customer who owns the subscription is entitled until the subscription's end date. |
| Subscription Start Date | Date/time in UTC time zone (yyyy-mm-ddThh:mm:ssZ) | The first day of the specified date range, if the subscription was active for the account on that date. Otherwise, the start date will be the date the subscription was activated within that date range. This date comes from Commerce Engine's record. |
| Subscription End Date | Date/time in UTC time zone (yyyy-mm-ddThh:mm:ssZ) | The last day of the specified date range if the subscription was active on that date. Otherwise, the end date will be the date that the subscription stopped being active within that date range. This date comes from Commerce Engine's record. This is only populated if the subscription has been canceled. |
| Subscription Created Date | Date/time in UTC time zone (yyyy-mm-ddThh:mm:ssZ) | The date the subscription was created. |
| Subscription Updated Date | Date/time in UTC time zone (yyyy-mm-ddThh:mm:ssZ) | The date the subscription was last updated. This field contains the date time stamp of an event that updated Commerce Engine's record. |
| Record Type | Alphanumeric string (up to 50 characters) | The type of record.Valid values are: - **Subscription** - **Subscription Item** (see description below) |
| Subscription Item ID | Alphanumeric string (up to 128 characters) | Partner Ecosystem Management creates the Subscription Item ID when multiple products exist under a single subscription. Each product record under a subscription has a unique Subscription Item ID. |
| Subscription Item Product ID | Alphanumeric string (up to 128 characters) | Commerce Engine's subscription product ID. |
| Subscription Item Start Date | Date/time (yyyy-mm-ddThh:mm:ssZ) | The first day of the specified date range, if the subscription item was active for the account on that date. Otherwise, the start date will be the date the subscription item was activated within that date range. |
| Subscription Item End Date | Date/time (yyyy-mm-ddThh:mm:ssZ) | The last day of the specified date range if the subscription item was active on that date. Otherwise, the end date will be the date that the subscription item stopped being active within that date range. |
| Subscription Item Promotion Code | Alphanumeric string (up to 128 characters) | The promotion code applied to the subscription item. |

## Subscription Updates Manifest File Fields

| Field Name | Format | Description |
| - | - | - |
| File Name | Alphanumeric string (up to 256 characters) | The name of the file. |
| Source Name | Alphanumeric string (up to 256 characters) | The source of the file, which is always Partner Ecosystem Management. |
| Extract Start Date | Date/time in UTC (yyyy-mm-ddThh:mm:ssZ) | The date and time the extract started. |
| Extract End Date | Date/time in UTC (yyyy-mm-ddThh:mm:ssZ) | The date and time the extract ended. |
| Number Of Records | Alphanumeric string (up to 16 characters) | The number of records in the CSV file. |
| Delta | Variable (1 character) | The delta version. This value identifies if there are differences or new content available. |
| Checksum | Alphanumeric string (up to 128 characters) | This value is used for data integrity verification. This value can be used to identify changes in the file or to detect errors by comparing it to other versions of the file. |

**Parent topic:**[Reports](m_reportingAbout)


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.