Reports

On this page

Transactional data reports
Request reports
Download reports
Report statuses
Report types
Filters
Report fields

Generate and download transaction data as CSV files for reconciliation, investigation, or analysis outside DEUNA Admin. Report history keeps the requested scope and generation status visible while the file is prepared.

Interactive exampleUses sample data and does not make API requests.

Data and reports

Prepare a CSV export and keep its generation state visible.

Sample data

ReportPeriod

Name	Period	Type	Status
Orders export · Sep 30	Sep 30, 2026	Daily	Available
Weekly operations	Sep 21, 2026 – Sep 27, 2026	Weekly	Available
September settlement review	Sep 1, 2026 – Sep 30, 2026	Custom	Generating

Transactional data reports#

Reports are built from the merchant, environment, date range, filters, and columns selected when the export is requested. Confirm that scope before sharing or reconciling a file.

Request reports#

To request a report immediately:

Go to the DEUNA Admin.
Open Payments > Orders.
Select Export.
Enter the report name.
Select the date range.
(Optional) Select advanced filters.
Select the information columns to include in the report.
Select Export. Track the file in Data and reports > Exports and reports.

Download reports#

To download a report:

Open Data and reports > Exports and reports in the side navigation.
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.

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 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.

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.

Once the scheduled report is generated, it will be available for download in the report list.

Filters#

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

Report fields#

The following information is included in each report:

Reason text for void/refund when applied.

Merchant & Store

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).

Order

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).

Amounts & Taxes

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.

Payment

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.

Payment - AVS

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).

3DS

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.

Routing

The SMART_ROUTING names below are retained in the export schema for backward compatibility. They are historical field names for routing telemetry; the customer-facing routing capability is documented as Dynamic Routing.

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	Historical indicator that routing recovered the order (true/false).
ORDEN_SMART_ROUTING	boolean	Historical indicator that a routing flow was applied (true/false).
ROUTING_FLOW_STATUS	string	Routing flow status (success/failed/pending).
STRATEGY_NAME	string	Name of the applied routing strategy.

Fraud

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).

Installments

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).

User

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.

Items

Field	Type	Description
ITEMS_ARRAY	json	Serialized JSON array with details per item (SKU, qty, unit price, etc.).

Other

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.