Export and download transactional data reports in .CSV format for more detailed analysis in Reports.
📘
To request a report immediately:
- Go to the DEUNA Admin.
- Go to Reports
- In Reports* section, click Export.
- Enter the report name.
- Select the date range.
- (Optional) Select advanced filters.
- Select the information columns to include in the report.
- Click Export.
To download a report:
- Access the side menu in the Reports section.
- Locate the file you want to download using the available filters. Filter by:
- Transaction ID
- Date:
- Custom
- Today
- Last 7 days
- Last 15 days
- Last 30 days
- Report type:
- All
- Daily report
- Weekly report
- Click Download.
📘
Discover how transactional data reports are structured in DEUNA Admin.
Once a report is generated, it is displayed in the report history with one of the following statuses:
| Status | Description |
|---|
| Generating | The file is being generated following a user request. |
| Available | The report was created and is available for download. |
| Failed | An error occurred when creating the file. The selected filter combination returned no results. |
The Admin generates the following types of reports:
- Daily report: Generated automatically every day at 00:00 in the merchant's country time zone. The report includes complete transactional information for the day, from 00:00 to 23:59.
- Weekly report: Generated automatically at the end of each week. The start of the week is considered Monday and the last day of the week is considered Sunday. The report covers transactional information from Monday at 00:00 to Sunday at 23:59.
- Monthly report: Generated automatically at the end of each month, covering from the first day of the month to the last day of the calendar month. The report includes transactional information from the first day of each month at 00:00 to the last day of each month at 23:59.
| Filter | Type | Description |
|---|
| Search | Search | Allows searching files by name. |
| Date | Date range | Allows specifying a date range for files. Additionally, it offers predefined options like "Today", "7 days", "15 days" and "30 days" for quick selection. |
| Report | Single selection | Allows filtering files by the following options: Daily report, Weekly report, Monthly report |
The following information is included in each report:
Reason text for void/refund when applied.
| Field | Type | Description |
|---|
| COUNTRY_CURRENCY | string | Base currency associated with the merchant/store (ISO 4217). |
| MERCHANT_COUNTRY | string | ISO code of the merchant's country (e.g., CO, MX, US). |
| MERCHANT_ID | string | Unique merchant identifier (UUID). |
| MERCHANT_NAME | string | Merchant name. |
| MERCHANT_PAYMENT_PROCESSOR_NAME | string | Readable PSP/connection alias configured by the merchant (e.g., 'Stripe USD'). |
| STORE_CODE | string | Code of the store/branch within the merchant (replaces STORE_COD). |
| Field | Type | Description |
|---|
| AUTHORIZATION_CODE | string | Authorization code provided by issuer/PSP for the payment. |
| MASTER_ORDER_ID | string | Master order identifier (for split or related orders). |
| ORDER_CREATED_DATE | datetime | Date/time when the order was created (merchant local time). |
| ORDER_ID | string | Unique order identifier (may match the PSP/merchant system). |
| ORDER_JSON | json | Complete JSON representation of the order object in DEUNA. |
| ORDER_METADATA | json | Order metadata payload (JSON), including mapped/normalized additional_data. |
| ORDER_STATUS | string | Current order status (e.g., created, processed, captured, refunded, cancelled). |
| ORDER_TOKEN | string | Internal token that uniquely identifies the order in DEUNA. |
| ORDER_TYPE | string | Order type (e.g., standard, recurring, subscription). |
| PROCESSOR_REFERENCE_ID | string | Internal or external reference that identifies the payment in the processor. |
| TRANSACTION_ID | string | Transaction ID associated with the order (e.g., PSP reference). |
| Field | Type | Description |
|---|
| ITEMS_ORIGINAL_TAX_AMOUNT | number | Items tax in the original transaction currency. |
| ITEMS_TAX_AMOUNT_USD | number | Items tax amount converted to USD. |
| ITEM_TOTAL | number | Total sum of item values before shipping, taxes and discounts (in merchant/base currency). |
| ITEM_TOTAL_USD | number | Item total converted to USD. |
| SHIP_ORIGINAL_TAX_AMOUNT | number | Shipping tax in the original transaction currency. |
| SHIP_ORIGINAL_TOTAL | number | Shipping total in the original transaction currency. |
| SHIP_ORIGINAL_TOTAL_DISCOUNT | number | Shipping discount in the original transaction currency. |
| SHIP_TAX_AMOUNT_USD | number | Shipping tax amount converted to USD. |
| SHIP_TOTAL_AMOUNT | number | Total shipping amount for the order (in merchant/base currency). |
| SHIP_TOTAL_DISCOUNT_USD | number | Shipping discount amount converted to USD. |
| SHIP_TOTAL_USD | number | Shipping total converted to USD. |
| SUB_TOTAL | number | Order subtotal (items minus discounts, before taxes and shipping). |
| TAX_ORIGINAL_AMOUNT | number | Tax amount in the original transaction currency. |
| TOTAL_DISCOUNT_AMOUNT | number | Total amount of discounts applied to the order (in merchant/base currency). |
| TOTAL_DISCOUNT_USD | number | Total discount amount converted to USD. |
| TOTAL_ORIGINAL_AMOUNT | number | Total amount in the original transaction currency (pre-conversion). |
| TOTAL_ORIGINAL_DISCOUNT | number | Total discount amount in the original transaction currency. |
| TOTAL_ORIGINAL_WITH_TAXES_AMOUNT | number | Total amount including taxes in the original transaction currency. |
| TOTAL_ORDER_AMOUNT | number | Final total order amount (items, shipping, taxes and discounts). |
| TOTAL_ORDER_AMOUNT_WITHOUT_TAXES | number | Total order amount excluding taxes. |
| TOTAL_TAX_AMOUNT | number | Total amount of taxes applied to the order (in merchant/base currency). |
| TOTAL_USD | number | Total amount converted to USD for reporting/benchmarking. |
| TOTAL_WITH_TAXES_AMOUNT_USD | number | Total amount including taxes converted to USD. |
| Field | Type | Description |
|---|
| ACCEPTANCE_RATE_INDICATOR | integer (0/1) | Indicator (0/1) of whether the payment was accepted/approved for acceptance-rate calculations. |
| CARDHOLDER_NAME | string | Cardholder name as received by the PSP. |
| FIRST_DENIED_BY | string | PSP that denied the payment on the first attempt (if any). |
| LAST_PSP_ERROR_CODE | string | Last PSP error code received in retries (if any). |
| LAST_PSP_ERROR_MESSAGE | string | Last PSP error message received in retries (if any). |
| PAYMENT_CARD_BIN | string | First 6 digits (BIN) of the card, if applicable. |
| PAYMENT_CARD_BRAND | string | Card brand (Visa, Mastercard, Amex, etc.), if applicable. |
| PAYMENT_CARD_LAST_FOUR | string | Last 4 digits of the card, if applicable. |
| PAYMENT_CREATED_DATE | datetime | Date/time when the payment record was created (merchant local time). |
| PAYMENT_CURRENCY | string | ISO code of the payment currency (e.g., COP, USD, MXN). |
| PAYMENT_ERROR_CATEGORY | string | General category of payment error (e.g., card_error, network_error, fraud_suspected). |
| PAYMENT_ERROR_CODE | string | Error code returned by the PSP when payment fails. |
| PAYMENT_ISSUING_BANK | string | Issuing bank name (if applicable). |
| PAYMENT_LAST_UPDATED_DATE | datetime | Date/time of the last update to the payment record (merchant local time). |
| PAYMENT_METHOD_TYPE | string | Payment method type (e.g., credit_card, debit_card, oxxo, apple_pay). |
| PAYMENT_PROCESSOR | string | PSP identifier used to process the payment (e.g., stripe, checkout). |
| PAYMENT_REJECTED_REASON | string | Free-text rejection reason returned by the PSP. |
| PAYMENT_STATUS | string | Current payment status (e.g., pending, authorized, captured, failed, refunded). |
| PAYMENT_TOTAL_AMOUNT | number | Total amount charged for the payment (in original transaction currency). |
| PSP_ERROR_CODE | string | PSP-specific error code. |
| PSP_ERROR_MESSAGE | string | PSP-specific error message. |
| Field | Type | Description |
|---|
| PAYMENT__DATA__AVS__CODE | string | AVS result code (normalized). |
| PAYMENT__DATA__AVS__DESCRIPTION | string | AVS human-readable description (normalized). |
| PAYMENT__DATA__AVS__PSP_CODE | string | Raw AVS code as returned by the PSP (if available). |
| PAYMENT__DATA__AVS__PSP_DESCRIPTION | string | Raw AVS description as returned by the PSP (if available). |
| PAYMENT__DATA__AVS__VALIDATION_RESULT | string | AVS validation result (e.g., PASSED/FAILED). |
| Field | Type | Description |
|---|
| CHALLENGE_3DS_INDICATOR | string | Whether a 3DS challenge happened (Y/N). |
| CHALLENGE_3DS_STATUS | string | Final status of the 3DS challenge (e.g., success, failure, timeout). |
| NUM_3DS | number | Number of 3DS attempts recorded for the payment. |
| Field | Type | Description |
|---|
| ERROR_RETRY | boolean | Whether there was a retry due to routing error (true/false). |
| HARD_SOFT | string | Whether the strategy execution is hard (strict) or soft (flexible). |
| ORDEN_RECOVERED_BY_SMART_ROUTING_INDICATOR | boolean | Whether the order was recovered via smart routing re-routing (true/false). |
| ORDEN_SMART_ROUTING | boolean | Whether smart routing was applied (true/false). |
| ROUTING_FLOW_STATUS | string | Smart routing flow status (success/failed/pending). |
| STRATEGY_NAME | string | Name of the applied routing strategy. |
| Field | Type | Description |
|---|
| FRAUD__ANALYSIS__DETAILS | string | Normalized fraud analysis details (human-readable). |
| FRAUD_DETAIL | string | Text detail explaining the fraud evaluation. |
| FRAUD_ERROR_CATEGORY | string | Fraud error category (if evaluation failed). |
| FRAUD_ERROR_CODE | string | Fraud system error code (if evaluation failed). |
| FRAUD_ERROR_MESSAGE | string | Fraud system error message (if evaluation failed). |
| FRAUD_PROCESSOR_NAME | string | Name of the configured anti-fraud engine (e.g., Kount, Riskified). |
| FRAUD_PROCESSOR_RESPONSE | string | Full response returned by the anti-fraud engine (serialized). |
| FRAUD_RISK_LEVEL | string | Categorized fraud risk level (low/medium/high). |
| FRAUD_RISK_SCORE | number | Fraud risk score assigned by the engine (e.g., 0–100). |
| FRAUD_SHADOWMODE | json | Shadow-mode fraud evaluation payload (JSON), if the merchant runs fraud in shadow mode. |
| FRAUD_STATE | string | Anti-fraud verification status (clear/review/blocked). |
| Field | Type | Description |
|---|
| INSTALLMENT_AMOUNT | number | Amount of each installment (in original transaction currency). |
| INSTALLMENTS | number | Number of installments selected (if applicable). |
| INTEREST_RATE | number | Interest rate applied to installments (0.00 if interest-free). |
| MCI_MSI_TYPE | string | Installments type (e.g., MSI/MCI variant or single payment). |
| Field | Type | Description |
|---|
| USER_ADDRESS | string | User full postal address. |
| USER_CITY | string | City from user address. |
| USER_COUNTRY_CODE | string | ISO country code from user address. |
| USER_EMAIL | string | User email. |
| USER_FIRST_NAME | string | Buyer/user first name. |
| USER_LAST_NAME | string | Buyer/user last name. |
| USER_PHONE | string | User phone number (international format). |
| USER_STATE_NAME | string | State/department from user address. |
| USER_ZIP_CODE | string | Postal/ZIP code from user address. |
| Field | Type | Description |
|---|
| ITEMS_ARRAY | json | Serialized JSON array with details per item (SKU, qty, unit price, etc.). |
| Field | Type | Description |
|---|
| AIRLINE_INFORMATION | string | JSON object reserved for airline transactions (PNR, ticket, itinerary, passengers). |
| CAR_ABANDONED_IND | boolean | Whether a car-rental related charge was abandoned (true/false). |
| REFUND_VOID_REASON | string | Reason text for void/refund when applied. |
