Reports
Transactional data reports
Export and download transactional data reports in .CSV format for more detailed analysis in the Reports section.
Reports are downloaded in .csv format
Request reports
To request a report immediately:
- Access the side menu in the Reports section.
- Click the Export button
- Define the report name
- Select the date range
- Select advanced filters (Optional)
- Select the information columns that will make up the report
- Click the Export button
Download a report
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.
The file is downloaded in .CSV format, compressed in a ZIP file.
Report statuses
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 user request. |
| Available | The report was created and is available for download. |
| Failed | An error occurred when creating the file. E.g. The selected filter combination returned no results. |
Report types
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.
Filters
| Filter | Type | Description |
|---|---|---|
| Search | Search | Allows searching files by name. |
| Date | Date range | Allows specifying a date range for files. Additionally, 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 |
Report fields
The following information is included in the report:
| Field | Description |
|---|---|
| MERCHANT_ID | Unique merchant identifier (UUID). |
| MERCHANT_NAME | Merchant name. |
| MERCHANT_COUNTRY | ISO code of the merchant's country (for example, CO, MX, US). |
| STORE_CODE | Code of the store or branch within the merchant. |
| ORDER_TOKEN | Internal token that uniquely identifies the order in DEUNA. |
| ORDER_ID | Unique order identifier (may match the PSP system). |
| MASTER_ORDER_ID | Master order identifier (in case of split or related orders). |
| TRANSACTION_ID | Transaction ID associated with the order (for example, PSP reference). |
| AUTHORIZATION_CODE | Authorization code granted by the issuer or PSP for the payment. |
| PROCESSOR\REFERENCE_ID | Internal or external reference that identifies the payment in the processor. |
| ORDER_CREATED_DATE | Date and time when the order was created (UTC). |
| ORDER_STATUS | Current order status (e.g. created, processed, captured, refunded, cancelled). |
| ITEM_TOTAL | Total sum of item values before shipping, taxes and discounts (in cents or minor currency unit). |
| SHIP_TOTAL_AMOUNT | Total shipping amount (freight) referred to the order (in cents or minor currency unit). |
| TOTAL_DISCOUNT_AMOUNT | Total amount of discounts applied to the order (in cents or minor currency unit). |
| TOTAL_TAX_AMOUNT | Total amount of taxes applied to the order (in cents or minor currency unit). |
| SUB_TOTAL | Order subtotal (sum of items minus discounts, before taxes and shipping). |
| TOTAL_ORDER_AMOUNT_WITHOUT_TAXES | Total order amount excluding taxes (may match SUB_TOTAL + SHIP_TOTAL_AMOUNT). |
| TOTAL_ORDER_AMOUNT | Final total order amount (includes items, shipping, taxes and discounts). |
| ORDER_TYPE | Order type (for example, standard, recurring, subscription). |
| ORDER_JSON | Complete JSON representation of the order object in DEUNA (for auditing or analysis). |
| PAYMENT_CREATED_DATE | Date and time when the payment record was created (UTC). |
| PAYMENT_LAST_UPDATED_DATE | Date and time of the last modification to the payment record (UTC). |
| PAYMENT_PROCESSOR | PSP (Payment Service Provider) identifier used to process the payment (for example, stripe, checkout). |
| MERCHANT_PAYMENT_PROCESSOR_NAME | Readable name (alias) of the PSP configured in the merchant (e.g. "Stripe USD" or "MercadoPago MX"). |
| PAYMENT_STATUS | Current payment status (pending, authorized, captured, failed, refunded). |
| PAYMENT_TOTAL_AMOUNT | Total amount charged for the payment (includes any adjustment, in cents or minor currency unit). |
| PAYMENT_CURRENCY | ISO code of the payment currency (for example, COP, USD, MXN). |
| PAYMENT_ERROR_CODE | Error code returned by the PSP when the payment fails. |
| PAYMENT_REJECTED_REASON | Rejection reason provided by the PSP in free text (for example, "Insufficient funds"). |
| PAYMENT_ERROR_CATEGORY | General category of payment error (card_error, network_error, fraud_suspected). |
| PAYMENT_ISSUING_BANK | Name of the issuing bank of the card used (may be empty if not applicable). |
| PAYMENT_METHOD_TYPE | Payment method type (credit_card, debit_card, boleto, oxxo, apple_pay, google_pay, etc.). |
| PAYMENT_CARD_BRAND | Card brand (Visa, MasterCard, Amex, etc.), if applicable. |
| PAYMENT_CARD_BIN | Bank identification number (BIN) of 6 digits of the card. |
| PAYMENT_CARD_LAST_FOUR | Last four digits of the card. |
| CARDHOLDER_NAME | Cardholder name (as received by the PSP). |
| NUM_3DS | Number of 3DS (3-D Secure) attempts recorded for this payment. |
| CHALLENGE_3DS_INDICATOR | Indicator of whether there was a 3DS challenge (Y = yes, N = no). |
| CHALLENGE_3DS_STATUS | Final status of the 3DS challenge (success, failure, timeout). |
| FIRST_DENIED_BY | PSP that denied the payment on the first attempt (if there was initial rejection). |
| PSP_ERROR_CODE | Specific error code returned by the PSP in its own nomenclature. |
| PSP_ERROR_MESSAGE | Descriptive error message returned by the PSP. |
| LAST_PSP_ERROR_CODE | Last error code received in subsequent attempts, in case of retries. |
| LAST_PSP_ERROR_MESSAGE | Last descriptive error message received in retries. |
| ROUTING_FLOW_STATUS | Smart routing flow status (success, failed, pending). |
| ORDEN_SMART_ROUTING | Boolean indicator if smart routing was applied for this order (true/false). |
| ORDEN_RECOVERED_BY_SMART_ROUTING_INDICATOR | Indicator if the order was recovered (re-routed) by the smart routing mechanism (true/false). |
| STRATEGY_NAME | Name of the applied routing strategy (for example, fallback_psp, priority_psp). |
| HARD_SOFT | Indicates if the strategy is "hard" (strict priority) or "soft" (flexible priority). |
| ERROR_RETRY | Retry indicator in case of routing error (true/false). |
| FRAUD_PROCESSOR_NAME | Name of the configured anti-fraud engine (for example, Kount, Riskified). |
| FRAUD_RISK_SCORE | Assigned fraud risk score (for example, 0–100). |
| FRAUD_STATE | Anti-fraud verification status (clear, review, blocked). |
| FRAUD_DETAIL | Textual detail explaining the anti-fraud evaluation (for example, "high velocity detected"). |
| FRAUD_PROCESSOR_RESPONSE | Complete response (serialized JSON or text message) returned by the anti-fraud engine. |
| MCI_MSI_TYPE | Type of 3DS/MCI installments (for example, installment_ticket, single_payment). |
| INSTALLMENTS | Number of installments selected by the buyer (if the method supports it). |
| INSTALLMENT_AMOUNT | Amount of each installment (in cents or minor currency unit). |
| INTEREST_RATE | Interest rate applied to the installment plan (for example, 0.00 if interest-free). |
| USER_FIRST_NAME | First name of the buyer or user who placed the order. |
| USER_LAST_NAME | Last name of the buyer. |
| USER_PHONE | User's phone number (international format). |
| USER_EMAIL | User's email address. |
| USER_ADDRESS | User's complete postal address (street, number, complement). |
| USER_CITY | City registered in the user's address. |
| USER_STATE_NAME | State or department of the user's address. |
| USER_ZIP_CODE | Zip code associated with the user's address. |
| USER_COUNTRY_CODE | ISO code of the user's country (for example, CO, MX, US). |
| ITEMS_ARRAY | Serialized JSON array with details of each order item (SKU, quantity, unit price, etc.). |
| FRAUD_RISK_LEVEL | Categorized risk level (low, medium, high). |
| FRAUD_ERROR_CATEGORY | Specific error category in anti-fraud verification (if applicable). |
| FRAUD_ERROR_CODE | Error code returned by the anti-fraud system when evaluation fails. |
| FRAUD_ERROR_MESSAGE | Descriptive message associated with the anti-fraud error. |
| REFUND_VOID_REASON | Text describing the reason for void or refund when applied. |
| AIRLINE_INFORMATION | JSON object with information reserved for airline transactions (PNR, ticket number, itinerary, passengers). |
| CAR_ABANDONED_IND | Boolean indicator (true/false) if the customer abandoned a charge related to car rental (when applicable). |
Updated 3 days ago