> ## 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. # Transaction Refund Detail This report lists refund Transaction details for the selected time period. The original Transaction information and refund Transaction ID and date are also provided. Totals, by page or All, provided for Pre-Tax and Total Billed. This report is generated using the Reports 1.0 data engine. | **Reports 1.0** data engine | Provides the data you need in the reports up to near real-time. Reports data is displayed in UTC time zone. Reports 1.0 lets you select which display columns to include in the report. Report generation typically lasts several hours. | | - | - | ## To generate a one time report: 1. Enter the date range 2. Optional. Enter an Email address where you'd like to receive notifications when the report is available. A single email address can be entered. 3. Select the Affiliate ID as relevant for the report. Select **No Affiliate** if not required. 4. Optional. Enter **Additional Filters** for the report: * Select the Account ID as a filter for the report. * Select the Payment Method as a filter for the report. * Select a Currency as a filter for the report. 5. For **Reports 1.0**, select the **Display Columns** you'd like to include in the report. 6. Click **Submit**. View the report in the **My Reports** page. ## To schedule a recurring report: 1. Toggle **Recurring** toggle to **Yes**. 2. Select a date for the first reporting period. **Note:** Reports display data occurring starting from the defined date. For example, a monthly report starting on March 1st displays data for the month of March up to March 31st. 3. Select the report's **Frequency**. Choose between Weekly, Monthly or Quarterly. 4. Select from **Generate report days in advance** how many days before the reporting period you'd like to have the report generated. 5. Optional. Enter an Email address where you'd like to receive notifications when the report is available. A single email address can be entered. 6. Optional. If you want to receive the report uploaded to an SFTP Server, enable this option and provide the required details. When enabled, a scheduled report will be uploaded to the specified SFTP Server. The SFTP report follows the **\-\-\.csv** naming convention where: * **\** is the name of the report * **\** is the defined frequency such as monthly, weekly, quarterly, daily or once * **\** is the format **YYYY-MM-DD"T"HH\_MI\_SS.TZ**, where TZ is the timezone offset, for example, 2022-01-27T10\_57\_02.433174455Z. For this report, the **\** is **transaction\_refund\_detail**. **Note:** An email notification is sent if there is an issue in generating or downloading the report on the specified SFTP Server. 7. Optional. Enter Additional Filters for the report: * Select the Account ID as a filter for the report. * Select the Payment Method as a filter for the report. * Select a Currency as a filter for the report. 8. For **Reports 1.0**, select the **Display Columns** you'd like to include in the report. 9. Click **Submit**. The report is submitted and will be generated according to the details provided. If you have provided an email or SFTP details, you will be notified when it is available for viewing. 10. View the report in the **My Reports** page. ## Display Columns **Note:** The report's display columns **order** is machine-generated and may therefore change without prior notice. | **Field** | **Description** | | - | - | | Company | The Customer’s Company, if available. | | Account ID | The Customer’s ID. | | Account Name | The Customer’s Name | | Affiliate ID | The affiliate ID of each listed Transaction, if any. | | Sub-Affiliate ID | The sub-affiliate ID of each listed Transaction, if any. | | Product ID | Product ID from the customer's Subscription or as specified in the Transaction. If the Transaction is not generated from an Subscription and the Product is not defined in Commerce Engine, this field will not be populated. | | Product Name | Product description from the customer's Subscription, or as specified in the Transaction. If the Transaction is not generated from an Subscription and the Product is not defined in Commerce Engine, this field will not be populated. | | Billing Plan ID | ID of the associated billing plan. | | Payment Method | Payment Method used for the original Transaction (e.g., Credit Card). | | Payment Method Type | Additional information concerning the Payment Method used. If the payment method is Credit Card, the card type (e.g., Visa, MasterCard, AMEX, Discover, etc.) will be used. For some Payment Methods, no additional information is available. | | Original Transaction ID | The ID of the Transaction for which the refund was generated. | | Processor ID | The name Amdocs uses to identify a Commerce Engine Transaction to the associated payment processor. This is usually the Commerce Engine Transaction ID. In some cases however, due to the format requirements of some payment processors, Commerce Engine alters the Transaction name before sending it to the processor. In those cases, the name of a transaction in a report by the payment processor will differ from the name of the same transaction in a report by Amdocs. The enables you to reconcile the original Commerce Engine Transaction name with the altered Transaction name Commerce Engine sends to the payment processor, to identify the Transaction. | | Original Transaction Date | The date of the Transaction for which the refund was generated. | | Pre Tax Amount | Amount before tax. | | Tax Collected | Tax calculated. | | Total Billed | Amount plus Tax. | | Currency | Currency of refund Transaction. | | Refund ID | ID of the refund Transaction sent to the payment processor. | | Refund Date | Date of the refund. | | Refund Amount | Amount of the refund (can be partial or full). | | Refund Status | Status of the refund Transaction. - Reported—refund has been issued but has not been processed by the payment processor/issuer. - Processing—refund call has been requested for a transaction that has not yet been captured. The refund will start processing after capture of the transaction (refunds are batched and sent daily). - Failed—payment processor has rejected the refund. - Complete—refund Transaction has been sent and processed by payment processor | | Refund Note | Note, if any, entered when the refund was issued. | | Issued By | The user name of the person who processed the refund. | | City | Customer’s billing city. | | State/District | Customer’s billing state or district. | | **Parent topic:**[Transaction Reports](reportsTransactionsAbout) | | This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.