> ## 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 Transaction Report **Note:** This report is intended for Resellers (Service Providers) using the [Merchant-managed](g_partnerManagedFlow) product lifecycle. The Daily Transaction Report contains details about transactions that Partner Ecosystem Management handled within the last 24 hours. This includes successful and failed transactions. The report pertains to transactions for products sold from the Merchant's digital store and billed through the Reseller (Service Provider). This file is generated daily at 8:00 UTC. Use the Daily Transaction 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 Transaction Report. The Daily Transaction Report is your source of truth for subscription data. You can also use this report to analyze transaction errors. The report contains detailed error descriptions from ESB. The Daily Transaction Report is a CSV file in the following format: **RATED\_EXTRACT\_TRX\_\.CSV**. **\** represents the day and hour the report was generated. ## Daily Transaction Report File Fields | Field Name | Format | Description | | - | - | - | | plmTransactionID | Alphanumeric string (up to 255 characters) | The ID of the transaction in Partner Ecosystem Management. For example: **C34332E0-3D34-4586-831C-30B6E1CA5F8D**. | | extTransactionId | Alphanumeric string (up to 255 characters) | The external transaction ID, which is provided by the Merchant or Partner Ecosystem Management. For example: **g3692334336476363**. | | chargeDate | Date/time in UTC time zone (MM/DD/YY HH:MM:SS) | The date and time of the transaction. For example: **01/01/2023 17:36:00**. | | cspOrganizationId | Alphanumeric string (up to 36 characters) | The Reseller (Service Provider) organization code, which Partner Ecosystem Management provides. For example: **INTERNATIONALTELCO**. | | cspProductCode | Alphanumeric string (up to 36 characters) | The product and charge code that is provided by the Reseller (Service Provider). This value is unique to each product the Reseller (Service Provider) uses. For example: **PLM\_PART\_3731:330:STREAMING**. | | partnerOrganizationId | Alphanumeric string (up to 36 characters) | The Merchant organization code that Partner Ecosystem Management provides. For example: **AMAZINGENTERTAINMENT**. | | partnerOrganizationName | Alphanumeric string (up to 255 characters) | The name of the Merchant. For example: **Amazing Entertainment**. | | partnerProductCode | Alphanumeric string (up to 36 characters) | The product code the Merchant provides. This field appears blank if the Merchant doesn't send a product code. For example: **AE003**. | | partnerProductName | Alphanumeric string (up to 255 characters) | The product name the Merchant provides. This field appears blank if the Merchant doesn't send a product name. For example: **Amazing Entertainment Basic**. | | productCategoryName | Alphanumeric string (up to 255 characters) | The product category from the Merchant. This field appears blank if the Merchant doesn't send a product category. For example: **Content**. | | description | Text (up to 65,535 characters) | The description of the customer purchase, which the Merchant or Reseller (Service Provider) provides in the transaction. For example: **5000 points (Awesome Adventure Game)**. | | currency | Alphanumeric string (up to 3 characters) (ISO-4217) | The currency of the transaction. For example: **MXN**. | | amount | Float | The transaction amount. A charge must be a positive value. A refund must be a negative value. For example: **100.12** for a charge or **-200.34** for a refund. | | taxIncluded | String (1 character) | Flags if tax was included in the transaction amount.Valid values are: - **Y** - **N** For example: **Y**. | | taxAmount | Float | The tax amount if the transaction contains tax. The tax amount = the transaction amount x tax %. For example: **10.5**. This field is blank if the transaction is not successful or there is no tax in the charge amount. **Note:** The currency for this amount will be same as what's shown in the **currency** field. | | settlementAmount | Float | The settlement amount for the transaction to be paid to the Merchant. For example: **7.23**. This field is blank if the transaction is not successful or if the revenue share is not defined for the Merchant.**Note:** The currency for this amount will be same as shown in the **currency** field. | | status | Alphanumeric string (up to 255 characters) | The status of the transaction.Valid values are: - **Success** - **Failure** For example: **Success**. | | phoneNumber | Alphanumeric string (up to 255 characters) | The MSISDN associated with the Reseller (Service Provider) account returned in the `/account/validate` API. For example: **4633293733**. | | extCustomerId | Alphanumeric string (up to 255 characters) | The customer ID associated with the Reseller (Service Provider) account returned in the `/account/validate` API. This value is unique to the Reseller (Service Provider). For example: **23332536**. | | extAccountId | Alphanumeric string (up to 255 characters) | The ID associated with the Reseller (Service Provider) account returned in the `/account/validate` API. For example: **38433396**. | | extAccountIdType | Alphanumeric string (up to 255 characters) | The account type associated with the Reseller (Service Provider) account returned in the `/account/validate` API. Valid values are: - **Prepaid** - **Postpaid** For example: **Prepaid**. | | extBillingId | Alphanumeric string (up to 255 characters) | The financial account ID associated with the Reseller (Service Provider) account returned in the `/account/validate` API. For example: **38433396**. | | reasonCode | Alphanumeric string (up to 255 characters) | The error reason code the Reseller's (Service Provider's) billing system or Partner Ecosystem Management returned during customer validation, transaction processing, or settlement processing. For example: **insufficient-balance**. | | reasonDesc | Alphanumeric string (up to 255 characters) | The error reason description provided by ESB. For example: **Exception Occurred In Insufficient balance :RPL received 4012 EC from RLC::IB**. | | platform | Alphanumeric string (up to 255 characters) | The platform. | | brand | Alphanumeric string (up to 255 characters) | The brand. | | partnerSubscriptionId | Alphanumeric string (up to 256 characters) | The subscription ID associated with the Merchant. | | partnerCustomerId | Alphanumeric string (up to 256 characters) | The customer ID associated with the Merchant. | | **Parent topic:**[Reports](r_reportingAbout) | | | This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.