In this section, you can find all report types and related fields available when generating your reports. Take into account the description of the fields, where you can find the origin of the data and its availability.
Yuno provides four report types:
Below, you will find details of each report type.
Updates
The report fields are subject to modifications, and new fields can be added to the end of the current structure.
Payment report
Payment report field details
Parameter | Type | Description | Example |
---|---|---|---|
account_id |
string | The unique identifier of the account (MAX 64; MIN 36). | 64143128-dd12-11ec-9d64-0242ac120002 |
airline_leg_arrival_airport |
string | Code of the destination airport for the flight leg. | JFK |
airline_leg_base_fare |
number | Base fare of the flight leg before taxes and fees. | 250 |
airline_leg_base_fare_currency |
enum | Currency in which the base fare is charged (ISO 4217). | USD |
airline_leg_carrier_code |
string | Airline carrier code for the flight leg. | AA |
airline_leg_departure_airport |
string | Code of the departure airport for the flight leg. | LAX |
airline_leg_departure_datetime |
datetime | Date and time of the flight departure. | 2024-09-12 15:30 |
airline_leg_fare_basis_code |
string | Code defining fare rules for the ticket. | Y26HNR |
airline_leg_fare_class_code |
string | Class code of the ticket (e.g., economy, business). | Y |
airline_leg_flight_number |
string | Number of the flight for the specific leg. | 100 |
airline_leg_stopover_code |
enum | Indicates if the flight has a stopover (Y/N). | N |
airline_passenger_country |
string | Country of residence of the passenger. | US |
airline_passenger_date_of_birth |
date | Passenger's date of birth. | 1990-05-14 |
airline_passenger_document_number |
string | Number of the passenger's identification document. | A12345678 |
airline_passenger_document_type |
enum | Type of identification document (e.g., passport, ID card). | PASSPORT |
airline_passenger_email |
string | Email address of the passenger. | [email protected] |
airline_passenger_first_name |
string | First name of the passenger. | John |
airline_passenger_last_name |
string | Last name of the passenger. | Doe |
airline_passenger_loyalty_number |
string | Loyalty program number of the passenger. | 123456789 |
airline_passenger_loyalty_tier |
enum | Tier level of the passenger's loyalty program (e.g., Gold, Platinum). | Gold |
airline_passenger_middle_name |
string | Middle name of the passenger (if applicable). | Andrew |
airline_passenger_nationality |
string | Nationality of the passenger. | US |
airline_passenger_phone_country_code |
string | Country code for the passenger's phone number. | 1 |
airline_passenger_phone_number |
string | Passenger's phone number. | 555-1234 |
airline_passenger_type |
enum | Type of passenger (e.g., adult, child, infant). | Adult |
airline_ticket_e_ticket |
boolean | Indicates if the ticket is electronic (true/false). | TRUE |
airline_ticket_issue_address |
string | Address where the ticket was issued. | 123 Main St |
airline_ticket_issue_carrier_prefix_code |
string | Carrier prefix code for the issuing airline. | 1 |
airline_ticket_issue_city |
string | City where the ticket was issued. | New York |
airline_ticket_issue_country |
string | Country where the ticket was issued. | US |
airline_ticket_issue_date |
date | Date when the ticket was issued. | 2024-09-10 |
airline_ticket_issue_travel_agent_code |
string | Code of the travel agent who issued the ticket. | TA123 |
airline_ticket_issue_travel_agent_name |
string | Name of the travel agent who issued the ticket. | John Doe Travel |
airline_ticket_issue_zip_code |
string | Postal code where the ticket was issued. | 10001 |
airline_ticket_restricted |
boolean | Indicates if the ticket has restrictions (true/false). | FALSE |
airline_ticket_ticket_number |
string | Unique number assigned to the ticket. | 1234567890123 |
airline_ticket_total_fare_amount |
number | Total amount paid for the ticket. | 300 |
airline_ticket_total_fee_amount |
number | Total additional fees applied to the ticket. | 50 |
airline_ticket_total_tax_amount |
number | Total taxes applied to the ticket. | 25 |
amount_value |
number | The payment amount (multiple of 0.0001). | 111111 |
bank_name |
string | Name of the bank associated with the transaction. | Wells Fargo |
beneficiary_name |
string | Name of the beneficiary for the transaction or payment. | Jane Doe |
browser_info_accept_header |
string | The 'accept' header sent by the browser. | text/html |
browser_info_color_depth |
number | Color depth supported by the browser's display (in bits). | 24 |
browser_info_javascript_enabled |
boolean | Indicates if JavaScript is enabled in the browser. | TRUE |
browser_info_language |
string | Default language set in the browser. | en-US |
browser_info_screen_height |
number | Height of the browser screen in pixels. | 1080 |
browser_info_screen_width |
number | Width of the browser screen in pixels. | 1920 |
browser_info_user_agent |
string | User agent string representing the browser and operating system. | Mozilla/5.0 |
captured |
number | Indicates the total amount captured for payment. | 1000.00 |
card_brand |
string | Brand of the card used in the transaction (e.g., Visa, MasterCard). | Visa |
card_category |
string | Category of the card (e.g., credit, debit). | Credit |
card_holder_name |
string | Name of the cardholder. | John Doe |
card_iin |
string | Issuer Identification Number (IIN) for the card (first 6 digits). | 123456 |
card_issuer_code |
string | Code identifying the card issuer. | CITI123 |
card_issuer_name |
string | Name of the bank or institution issuing the card. | Citi Bank |
card_lfd |
number | Last four digits of the card number. | 7890 |
card_type |
enum | Type of card (e.g., credit, debit). | Credit |
checkout_session |
string | Unique identifier for the checkout session. | ch_sess_12345 |
country |
enum | The country where the transaction must be processed (MAX 2; MIN 2; ISO 3166-1). | US |
created_at |
timestamp | The payment creation date (MAX 27; MIN 27; ISO 8601). | 2022-05-09T20:46:54.786342Z |
currency |
enum | The currency used to make the payment (MAX 3; MIN 3; ISO 4217). | COP |
customer_first_name |
string | The customer's first name (MAX 255; MIN 1). | John |
customer_id |
string | The unique identifier of the customer (MAX 255; MIN 3). | 23456 |
customer_last_name |
string | The customer's last name (MAX 255; MIN 1). | Doe |
customer_payer_phone_country_code |
number | The customer's country code (MAX 3; MIN 2). | 52 |
customer_payer_phone_number |
number | The customer's phone number (MAX 255; MIN 1). | 3313873320 |
date_of_birth |
date | Date of birth of the individual. | 1985-07-28 |
description |
string | The description of the payment (MAX 255; MIN 3). | Order1234 |
device_fingerprint |
string | Unique identifier for the device used in the transaction. | df_987654321 |
document_number |
string | Document number of the individual. | A98765432 |
document_type |
enum | Type of document (e.g., ID card, passport). | ID |
email |
string | The customer's e-mail (MAX 255; MIN 3). | [email protected] |
gender |
enum | Gender of the individual. | Male |
installments |
number | Number of installments for the payment. | 6 |
ip_address |
string | The customer's IP address (MAX 255; MIN 3). | 2806:103e:2a:414 |
merchant_customer_id |
enum | A unique identifier assigned by a merchant to represent a specific customer (MAX 255; MIN 3). | 9440127422 |
merchant_order_id |
string | The identification of the order (MAX 255; MIN 3). | 123456789 |
nationality |
string | Nationality of the individual. | US |
order_fee_amount |
number | Total fees applied to the order. | 10 |
order_item_brand |
string | Brand of the item in the order. | Nike |
order_item_category |
string | Category of the item in the order. | Shoes |
order_item_id |
string | Unique identifier for the item in the order. | item_12345 |
order_item_manufacture_part_number |
string | Manufacturer's part number for the item. | MP56789 |
order_item_name |
string | Name of the item in the order. | Air Max 2024 |
order_item_quantity |
number | Quantity of the item in the order. | 2 |
order_item_sku_code |
string | SKU code of the item in the order. | SKU98765 |
order_item_unit_amount |
number | Unit price of the item. | 150 |
order_shipping_amount |
number | Shipping cost for the order. | 20 |
payment_callback_url |
string | A URL endpoint provided by the merchant. | https://www.domain.com |
payment_id |
string | A unique identifier assigned to a specific payment transaction. | 69ad0a39-b769-423c-b223-d7b8bf |
payment_seller_details_address_city |
string | City of the seller's address. | Miami |
payment_seller_details_address_country |
string | Country of the seller's address. | US |
payment_seller_details_address_line_1 |
string | First line of the seller's address. | 456 Market St |
payment_seller_details_address_line_2 |
string | Second line of the seller's address. | Apt 202 |
payment_seller_details_address_state |
string | State or province of the seller's address. | FL |
payment_seller_details_address_zip_code |
string | Postal code of the seller's address. | 33101 |
payment_seller_details_country |
string | Country where the seller is based. | US |
payment_seller_details_document_number |
string | Document number of the seller. | 98765432 |
payment_seller_details_document_type |
enum | Type of document for the seller (e.g., ID, passport). | ID |
payment_seller_details_email |
string | Seller's email address. | [email protected] |
payment_seller_details_industry |
string | The industry to which the seller belongs. | Retail |
payment_seller_details_name |
string | Name of the seller. | Best Store |
payment_seller_details_phone_code |
string | Country code for the seller's phone number. | 1 |
payment_seller_details_phone_number |
string | Seller's phone number. | 123-456-7890 |
payment_seller_details_reference |
string | Internal reference for the seller. | ref_789456 |
payment_seller_details_web_site |
string | Seller's website URL. | www.domain.com |
payment_tax_base |
number | Base amount used to calculate tax. | 100 |
payment_tax_percentage |
number | Percentage of tax applied to the transaction. | 10 |
payment_tax_type |
string | Type of tax applied (e.g., VAT, GST). | VAT |
payment_tax_value |
number | The calculated tax amount. | 10 |
payment_workflow |
string | Workflow used for the payment process. | standard |
pnr |
string | Passenger Name Record (PNR) reference. | |
provider_number |
integer | The ticket's number. | 13141 |
refunded |
number | The payment amount that has been refunded. | 10000 |
sdk_action_required |
boolean | A boolean field that indicates whether additional action is needed from the customer or merchant. | TRUE |
status |
enum | The status of the payment (MAX 255; MIN 3). | SUCCEEDED |
sub_status |
enum | The substatus of the payment (MAX 255; MIN 3). | APPROVED |
subscription_id |
string | A unique identifier assigned to a recurring subscription or billing agreement. | 111aaa222 |
updated_at |
timestamp | The date and time of the last update for the payment. | 2022-05-15T20:46:54.786342Z |
Transaction report
Transaction report field details
Parameter | Type | Description | Example |
---|---|---|---|
account_id |
string | Unique identifier for the account (MAX 64; MIN 36). | 2c05976d-f696-497f-a309-6421883de48d |
account_integration_id |
string | Unique identifier of the account integration (MAX 64; MIN 36). | 6a0f939c-0cd1-4350-acbc-b0cbdbee9739 |
amount |
number | Amount of the transaction (MAX 10000; MIN 0). | 887 |
authorization_code |
string | Authorization code for the transaction (MAX 6; MIN 6). | 161058 |
bank_name |
string | Name of the bank involved in the transaction (MAX 100; MIN 3). | BANCO SANTANDER |
bank_transfer_account |
string | Bank transfer account details (MAX 255; MIN 3). | 12345678901234567 |
bank_transfer_account_2 |
string | Secondary bank transfer account details (MAX 255; MIN 3). | 76543210987654321 |
bank_transfer_account_type |
enum | Type of the bank transfer account (MAX 20; MIN 3). | Checking |
bank_transfer_payment_instruction |
string | Instructions for bank transfer payments (MAX 255; MIN 3). | Payment to be completed within 48 hours. |
beneficiary_document |
string | Document identifier of the beneficiary (MAX 20; MIN 5). | 123456789 |
beneficiary_document_type |
enum | Document type of the beneficiary (MAX 10; MIN 3). | Passport |
beneficiary_name |
string | Full name of the beneficiary (MAX 255; MIN 3). | John Doe |
capture |
boolean | Indicates if the transaction is captured. | TRUE |
card_brand |
string | Brand of the card used (MAX 50; MIN 2). | VISA |
card_category |
string | Category of the card used (MAX 50; MIN 2). | CLASSIC |
card_holder_name |
string | Name of the cardholder (MAX 255; MIN 3). | GIAIMO ANGELA MERCEDES |
card_iin |
string | Issuer Identification Number (IIN) of the card (MAX 8; MIN 6). | 49296404 |
card_issuer_code |
string | Code of the card issuer (MAX 50; MIN 2). | BCO001 |
card_issuer_name |
string | Name of the card issuer (MAX 100; MIN 3). | BANCO SANTANDER |
card_lfd |
string | Last four digits of the card number (MAX 4; MIN 4). | 1228 |
card_number_length |
number | Length of the card number (MAX 19; MIN 12). | 16 |
card_security_code_length |
number | Length of the card security code (MAX 4; MIN 3). | 3 |
card_type |
enum | Type of card used (CREDIT or DEBIT). | CREDIT |
country |
enum | Country where the transaction occurred (MAX 2; MIN 2). | UY |
created_at |
timestamp | Timestamp when the transaction was created (ISO 8601). | 2024-09-11T23:16:06.602Z |
currency |
enum | Currency code for the transaction (MAX 3; MIN 3). | UYU |
customer_first_name |
string | First name of the customer (MAX 255; MIN 3). | angela |
customer_id |
string | Unique identifier for the customer (MAX 64; MIN 36). | f4c53557-a832-44e9 -94e4-0344f91e9d4f |
customer_last_name |
string | Last name of the customer (MAX 255; MIN 3). | giaimo |
description |
string | Description of the transaction (MAX 255; MIN 3). | McDonalds Ecommerce |
document_number |
string | Document number of the customer (MAX 20; MIN 5). | 48054205 |
document_type |
string | Document type of the customer (MAX 10; MIN 2). | CI |
email |
string | Email address of the customer (MAX 255; MIN 3). | [email protected] |
first_installments_deferral |
string | Details of the first installment deferral (MAX 255; MIN 3). | No deferral |
fraud_screening_provider_score |
number | Fraud screening score provided by the fraud detection system (MAX 100; MIN 0). | 85 |
installments |
number | Number of installments for the transaction (MAX 24; MIN 1). | 1 |
installments_amount |
number | Total amount of installments (MAX 10000; MIN 0). | 887 |
installments_type |
string | Type of installments plan (MAX 50; MIN 3). | Single payment |
merchant_order_id |
string | Merchant's order identifier (MAX 64; MIN 36). | NC2- 66e224a53fb722eaa0507579 |
merchant_transaction_id |
string | Merchant's transaction identifier (MAX 64; MIN 36). | NC2- 66e224a53fb722eaa0507579 |
nationality |
string | Nationality of the customer (MAX 3; MIN 2). | UY |
payment_id |
string | Unique identifier for the payment (MAX 64; MIN 36). | 49b08cf9-c577-4451- a673-2dc1ae930200 |
payment_link_fee_details |
string | Details of any fees associated with the payment link (MAX 255; MIN 3). | No additional fees |
payment_link_money_release_date |
timestamp | Date when the money from the payment link will be released (ISO 8601). | 2024-09-15 |
payment_link_payment_method_detail |
string | Details of the payment method used in the payment link (MAX 255; MIN 3). | VISA Card ending in 1228 |
payment_link_payment_method_id |
string | Unique identifier for the payment method in the payment link (MAX 64; MIN 36). | PLPMID123456 |
payment_link_sponsor_id |
string | Unique identifier for the sponsor of the payment link (MAX 64; MIN 36). | PLS123456 |
payment_method_category |
enum | Category of the payment method (CARD, BANK_TRANSFER, etc.). | CARD |
payment_method_type |
enum | Type of payment method (CARD, BANK_TRANSFER, etc.). | CARD |
pnr |
string | Passenger Name Record if applicable (MAX 64; MIN 36). | 987654321 |
provider_account_id |
string | Provider's account identifier (MAX 64; MIN 36). | 699ec8d444 |
provider_expiration_date |
timestamp | Expiration date provided by the provider (ISO 8601). | 2024-12-31 |
provider_id |
string | Unique identifier for the provider (MAX 64; MIN 36). | DLOCAL |
provider_image |
string | URL of the provider's image or logo (MAX 255; MIN 3). | https://example.com/logo.png |
provider_number |
string | Provider number (MAX 64; MIN 36). | 12345 |
provider_response_code |
string | Response code from the provider (MAX 255; MIN 3). | 200 |
provider_response_message |
string | Response message from the provider (MAX 255; MIN 3). | The payment was paid. |
provider_status |
string | Status of the payment at the provider (MAX 255; MIN 3). | PAID |
provider_status_detail |
string | Detailed status from the provider (MAX 255; MIN 3). | Transaction completed successfully. |
provider_third_party_account_id |
string | Third-party account ID associated with the provider (MAX 64; MIN 36). | ACC123456 |
provider_third_party_transaction_id |
string | Third-party transaction ID associated with the provider (MAX 64; MIN 36). | TID123456 |
provider_transaction_id |
string | Unique transaction identifier from the provider (MAX 64; MIN 36). | T-51056-1e10f992-e5cf- 40bf-9eb6-8edc881de30b |
reason |
string | Reason for the transaction (MAX 255; MIN 3). | McDonald's order payment |
redirect_url |
string | URL where the user will be redirected after payment (MAX 255; MIN 3). | https://example.com/redirect-url |
refund_execution_origin |
string | Origin of the refund execution (MAX 255; MIN 3). | Customer Request |
refund_execution_user |
string | User who executed the refund (MAX 255; MIN 3). | RefundServiceAgent |
response_code |
string | Response code from the system (MAX 255; MIN 3). | 200 |
response_message |
string | Response message from the system (MAX 255; MIN 3). | Payment successful. |
retrieval_reference_number |
string | Reference number for retrieving transaction details (MAX 255; MIN 3). | 1234567890 |
soft_descriptor |
string | The soft descriptor shown on the customer's bank statement (MAX 22; MIN 3). | MCD ECOMMERCE |
status |
enum | Status of the transaction (MAX 50; MIN 2). | PAID |
subscription_id |
string | Unique identifier for a subscription associated with the transaction (MAX 64; MIN 36). | SUB123456 |
three_d_secure_cryptogram |
string | Cryptogram data used in 3D Secure authentication (MAX 255; MIN 3). | ABCDEFG12345 |
three_d_secure_directory_server_transaction_id |
string | Directory server transaction ID for 3D Secure authentication (MAX 255; MIN 3). | 3DSTID123456 |
three_d_secure_electronic_commerce_indicator |
string | Electronic commerce indicator for 3D Secure authentication (MAX 255; MIN 3). | ECI05 |
three_d_secure_setup_id |
string | Setup ID for 3D Secure authentication (MAX 255; MIN 3). | SETUP123456 |
three_d_secure_transaction_id |
string | Transaction ID for 3D Secure authentication (MAX 255; MIN 3). | 3DSTXID123456 |
three_d_secure_version |
string | Version of 3D Secure protocol used (MAX 255; MIN 3). | 2.1.0 |
has_challenge |
boolean | Indicates if the transaction has a challenge step (3D Secure). | FALSE |
ticket_provider_barcode |
string | Barcode provided by the ticket provider (MAX 255; MIN 3). | 123456789 |
ticket_provider_format |
string | Format of the ticket provided by the provider (MAX 255; MIN 3). | |
ticket_provider_logo |
string | Logo of the ticket provider (MAX 255; MIN 3). | https://example.com/logo.png |
token |
string | Token generated for the transaction (MAX 255; MIN 3). | fa476a40-854c-4e66 -9a98-55a68a6b88f4 |
transaction_id |
string | Unique identifier for the transaction (MAX 64; MIN 36). | b04db1c6-b2c7-4765-a77e-953d284d080b |
type |
string | Type of transaction (MAX 50; MIN 2). | PURCHASE |
updated_at |
timestamp | Timestamp when the transaction was last updated (ISO 8601). | 2024-09-11T23:17:07.602Z |
vault_on_success |
boolean | Indicates if vaulting should occur upon transaction success. | FALSE |
vaulted_token |
string | Token generated for a vaulted card (MAX 255; MIN 3). | fa476a40-854c-4e66- 9a98-55a68a6b88f4 |
verify |
boolean | Indicates if verification was performed. | FALSE |
wallet |
string | Wallet associated with the transaction (MAX 255; MIN 3). | PayPal |
Transaction reconciliation report
Transaction reconciliation report field details
Parameter | Type | Description | Example |
---|---|---|---|
account_id |
string | The unique identifier of the account (MAX 64; MIN 36). | 64143128-dd12-11ec-9d64-0242ac120002 |
country |
enum | The country where the transaction must be processed (MAX 2; MIN 2; ISO 3166-1). | US |
type |
enum | The transaction type (MAX 255; MIN 3). | PURCHASE |
payment_method_category |
enum | Category of the transaction (MAX 255; MIN 3). | BANK_TRANSFER |
payment_method_type |
enum | The type of payment method selected by the customer (MAX 255; MIN 3). | BANCOLOMBIA_TRANSFER |
provider_id |
enum | The ID of the provider that processed the transaction. | WOMPI |
customer_id |
string | The unique identifier of the customer (MAX 255; MIN 3). | 23456 |
payment_id |
string | The unique identifier of the payment (MAX 64; MIN 36). | 5104911d-5df9-229e-8468-bd41abea1 |
merchant_order_id |
string | Identification of the order assigned by your company (MAX 255; MIN 3). | 123456789 |
merchant_transaction_id |
string | Identification of the transaction assigned by your company (MAX 255; MIN 3). | 987654321 |
transaction_id |
string | The unique identifier of the transaction assigned by Yuno (MAX 64; MIN 36). | 9104911d-5df9-429e-8488-ad41abea1a4b |
provider_transaction_id |
string | The unique identifier of the transaction from the provider (MAX 255; MIN 3). | 53443e9c-dd17-11ec-9d64-0242ac120002 |
status |
string | The status of the transaction (MAX 255; MIN 3). | SUCCEEDED |
response_code |
string | The code that represents the response to the outcome of the transaction. | SUCCEEDED |
provider_status |
string | The transaction status from the provider (MAX 255; MIN 3). | Authorised |
amount |
number | The amount of the transaction. | 100 |
local_amount (A) |
decimal | The corresponding amount for all transactions in settlement currency minus local retention and local tax (multiple of 0.0001). | 140.1 |
local_retention (A) |
decimal | The corresponding amount for all transactions in settlement currency minus local amount and local tax (multiple of 0.0001). | 7.37 |
local_tax (A) |
decimal | The corresponding amount for all transactions in settlement currency minus local retention and local amount (multiple of 0.0001). | 11.73 |
provider_fees (A) |
decimal | The commission fee that was withheld by the acquirer on transactions in settlement currency (multiple of 0.0001). | 3.53 |
provider_fee_taxes (A) |
decimal | The commission fee tax that was withheld by the acquirer in settlement currency (multiple of 0.0001). | 0.78 |
net_amount (A) |
decimal | The amount submitted in the credit transaction requests minus acquirer fees in settlement currency (multiple of 0.0001). | 135.79 |
currency |
enum | The currency used to make the payment (MAX 3; MIN 3; ISO 4217). | COP |
card_type |
string | The type of the card's issuer (MAX 255; MIN 3). | CREDIT |
card_brand |
string | The card's brand information (MAX 255; MIN 3). | VISA |
provider_card_brand |
string | The payment method or card brand (MAX 255; MIN 3). | PIX |
retrieval_reference_number |
string | Unique reference number for transaction retrieval (MAX 255; MIN 3). | CAQMCAQRisS2iL |
card_category |
enum | Category of the card used in the transaction (MAX 255; MIN 3). | CLASSIC |
card_iin |
number | The issuer identification number (IIN) refers to the first few digits of a payment card number issued by a financial institution (MAX 8; MIN 8). | 123456 |
card_lfd |
number | Last four digits of the card (MAX 4; MIN 4). | 7890 |
card_expiration_month |
number | Card expiration month (MAX 2; MIN 1). | 10 |
card_expiration_year |
number | Card expiration year (MAX 2; MIN 2). | 10 |
card_issuer_name |
enum | Bank to which the card corresponds. | BANCO ITAU |
card_issuer_country |
enum | Country in which settlement was made (MAX 2; MIN 2). | UY |
authorization_code |
string | The acquirer's response code. | 742A64 |
installments |
number | In case of a card transaction, the number of installments in which the payment was requested (MAX 2; MIN 1). | 1 |
pnr |
string | The passenger name record (MAX 255; MIN 3). | 1P-2UUGJW |
created_at |
timestamp | Transaction creation date (MAX 27; MIN 27; ISO 8601). | 2022-05-09T20:46:54.786342Z |
updated_at |
timestamp | The date and time from the last time the transaction was updated. | 2022-05-15T20:46:54.786342Z |
estimated_settlement_date (A) |
timestamp | Estimated date by the acquirer in which the funds will be deposited in the merchant's bank account. | 2022-05-09 |
reconciliation_status |
enum | The reconciliation status of a transaction (MAX 255; MIN 3). | RECONCILED |
reconciliation_sub_status |
enum | The reconciliation substatus of a transaction (MAX 255; MIN 3). | AUTOMATICALLY |
reconciliation_date |
timestamp | The date the transaction was reconciled (MAX 27; MIN 27; ISO 8601). | 2022-05-09T20:46:54.786342Z |
reconciliation_id |
enum | The unique identifier assigned to a transaction when it is reconciled (MAX 255; MIN 3). | 2478d494-4a20-45b1-8a12-1c2604cf2d1d |
reconciliation_settlement_date |
timestamp | Date by the acquirer in which the funds will be deposited in the merchant's bank account. | 2022-05-09 0:00 |
Settlement report
The settlement report has two types of reports:
- Header: Shows the settlement summary.
- Body: shows the data of each header.
Settlement report field details - Header
Parameter | Type | Description | Example |
---|---|---|---|
type |
string | Row type. Value: HEADER (MAX 255; MIN 3). |
HEADER |
acquirer |
enum | Name of the acquirer that processed the original payment. In aggregator models, the provider is the same as the acquirer. In other models, they may be different entities (MAX 255; MIN 3). | SpinPay |
number_of_transactions |
number | Total transactions contained in the report for the acquirer (MAX 255; MIN 1). | 15 |
gross_currency |
enum | Currency code in which transactions were made (MAX 3; MIN 3; ISO 4217). | USD |
gross_credit |
decimal | For credit transactions, the corresponding gross amount (multiple of 0.0001). | 1000.0 |
gross_debit |
decimal | For debit transactions, the corresponding gross amount (multiple of 0.0001). | 1000.0 |
settlement_currency |
enum | Currency code in which settlement was made (MAX 3; MIN 3; ISO 4217). | USD |
settlement_gross_amount |
decimal | The corresponding gross amount for all transactions in settlement currency (multiple of 0.0001). | 100.0 |
settlement_credit_fees |
decimal | Commission fee that was withheld by the acquirer on credit transactions in settlement currency. This should be the difference between the gross and net amounts (multiple of 0.0001). | 15.0 |
settlement_debit_fees |
decimal | Commission fee that was withheld by the acquirer on debit transactions in settlement currency. This should be the difference between the gross and net amounts (multiple of 0.0001). | 5.0 |
settlement_fee_taxes |
decimal | Commission fee tax that was withheld by the acquirer in settlement currency. This should be the difference between the gross and net amounts (multiple of 0.0001). | 0.10 |
settlement_taxes |
decimal | Value of taxes applied to the transactions in settlement currency. This should be the difference between the gross and net amounts (multiple of 0.0001). | 1.0 |
settlement_cost_of_installments |
decimal | Commission fee that the acquirer withheld for advance installments in settlement currency (multiple of 0.0001). This should be the difference between the gross and net amounts. | 15.0 |
settlement_net_credit |
decimal | Amount submitted in the credit transaction requests minus acquirer fees in settlement currency (multiple of 0.0001). | 970.0 |
settlement_net_debit |
decimal | Amount submitted in the debit transaction requests minus acquirer fees in settlement currency (multiple of 0.0001). | 970.0 |
settlement_net_balance |
decimal | Net credit/debit amount in settlement currency (multiple of 0.0001). | 1000.0 |
settlement_batch_id (A) |
string | This field contains the unique acquirer settlement batch number that you can find on your bank statement for the corresponding deposit (MAX 255; MIN 3). | SETT-111450235000 |
settlement_date (A) |
date | Estimated date by the acquirer on which the funds will be deposited in the merchant's bank account. | 2022-05-09 |
country (A) |
enum | Country of the merchant account (ISO 3166-1). | US |
Settlement report field details - Body
Parameter | Type | Description | Example |
---|---|---|---|
account_id (A) |
string | The merchant account ID (MAX 64; MIN 36). | 64143128-dd12-11ec-9d64-0242ac120002 |
provider_merchant_id (A) |
string | Merchant ID in the PSP system (MAX 255; MIN 3). | 15a8c304-d334-4da7-bccb-09cf85a1d7a6 |
country (A) |
enum | Country of the merchant account (ISO 3166-1). | US |
settlement_batch_id (A) |
string | This field contains the unique acquirer settlement batch number that you can find on your bank statement for the corresponding deposit (MAX 255; MIN 3). | SETT-111450235000 |
settlement_date (A) |
timestamp | Estimated date by the acquirer when the funds will be deposited into the merchant's bank account. | 2022-05-09 |
payment_method_category |
enum | Category of the transaction (MAX 255; MIN 3). | BANK_TRANSFER |
payment_method_type |
enum | The type of payment method selected by the customer (MAX 255; MIN 3). | BANCOLOMBIA_TRANSFER |
provider_id |
enum | Identification of the provider (MAX 255; MIN 3). | WOMPI |
acquirer |
enum | Name of the acquirer that processed the original payment. In aggregator models, the provider is the same as the acquirer. In other models, they may be different entities (MAX 255; MIN 3). | SpinPay |
payment_id |
string | The unique identifier of the payment (MAX 64; MIN 36). | 5104911d-5df9-229e-8468-bd41abea1 |
merchant_order_id (A) |
string | Identification of the order (MAX 255; MIN 3). | abc123456789 |
merchant_transaction_id |
string | Identification of the transaction assigned by the merchant (MAX 255; MIN 3). | 987654321 |
transaction_id (A) |
string | The unique identifier of the transaction assigned by Yuno (MAX 64; MIN 36). | 9104911d-5df9-429e-8488-ad41abea1a4b |
provider_transaction_id (A) |
string | The unique identifier of the transaction assigned by the gateway. This field is empty if the gateway doesn't provide transaction information (MAX 255; MIN 3). | 53443e9c-dd17-11ec-9d64-0242ac120002 |
transaction_date |
timestamp | Transaction creation date (MAX 27; MIN 27; ISO 8601). | 2022-05-09T20:46:54.786342Z |
type |
enum | The type of transaction. Values could be: SALE, RETURN, CHARGEBACK, DISPUTE, COMMISSION, TAX, SETTLEMENT. | SALE |
gross_currency |
enum | Currency code in which the transaction was made (MAX 3; MIN 3; ISO 4217). | USD |
gross_credit |
decimal | For credit transactions, the corresponding gross amount (multiple of 0.0001). | 1000.0 |
gross_debit |
decimal | For debit transactions, the corresponding gross amount (multiple of 0.0001). | 1000.0 |
fee_rate (A) |
decimal | Percentage value of the fee retained by the acquirer. This field is empty if the acquirer doesn't provide transaction information. | 15 |
settlement_currency |
enum | Currency code in which settlement was made (MAX 3; MIN 3; ISO 4217). | USD |
fx_rate |
decimal | The exchange rate applied to the transaction at the time of settlement (multiple of 0.0001). | 10 |
settlement_gross_amount |
decimal | The corresponding gross amount for all transactions in settlement currency (multiple of 0.0001). | 100.0 |
settlement_fees |
decimal | The commission fee that was withheld by the acquirer on transactions in settlement currency. This should be the difference between the gross and net amounts (multiple of 0.0001). | 15.0 |
settlement_fee_taxes |
decimal | The commission fee tax that was withheld by the acquirer in settlement currency. This should be the difference between the gross and net amounts (multiple of 0.0001). | 0.10 |
settlement_taxes |
decimal | The value of taxes applied to the transactions in settlement currency. This should be the difference between the gross and net amounts (multiple of 0.0001). | 1.0 |
cost_of_installments_rate (A) |
decimal | In case of processing sales in installments, the percentage financing cost rate retained by the acquirer. This field is empty if the acquirer doesn't provide transaction information. | 15 |
settlement_cost_of_installments |
decimal | The commission fee that was withheld by the acquirer for advance installments in settlement currency (multiple of 0.0001). This should be the difference between the gross and net amounts. | 15.0 |
settlement_net_credit |
decimal | The amount submitted in the credit transaction requests minus acquirer fees in settlement currency (multiple of 0.0001). | 970.0 |
settlement_net_debit |
decimal | The amount submitted in the debit transaction requests minus acquirer fees in settlement currency (multiple of 0.0001). | 970.0 |
card_type |
enum | Type of card used in the transaction (MAX 7; MIN 5). | CREDIT |
card_brand |
enum | Brand of the card used in the transaction (MAX 255; MIN 3). | VISA |
card_category |
enum | Category of the card used in the transaction (MAX 255; MIN 3). | premium |
card_iin (A) |
number | The issuer identification number (IIN) refers to the first few digits of a payment card number issued by a financial institution (MAX 8; MIN 8). | 123456 |
card_lfd (A) |
number | Last four digits of the card (MAX 4; MIN 4). | 7890 |
authorization_code (A) |
string | In case of a card transaction, the code assigned by the issuing bank to the transaction when it is authorized. This field is empty if the gateway doesn't provide transaction information (MAX 255; MIN 3). | 123456 |
customer_id (A) |
string | The unique identifier of the customer (MAX 255; MIN 3). | 23456 |
voucher (A) |
string | In case of a card transaction, the unique identifier of the payment receipt assigned by the issuing bank. This field is empty if the gateway doesn't provide transaction information (MAX 255; MIN 3). | 43564 |
installments |
number | In case of a card transaction, the number of installments in which the payment was requested (MAX 2; MIN 1). | 1 |
installment_number (A) |
string | In case of a card transaction in installments, the installment number that is being settled in this batch. If the installment payment is made in a single batch, the field is empty (MAX 6; MIN 3). | 1/3 |
pnr |
string | The passenger name record (MAX 255; MIN 3). | 1P-2UUGJW |
reconciliation |
struct | ||
reconciliation_status |
enum | The reconciliation status of a transaction (MAX 255; MIN 3). | RECONCILED |
reconciliation_sub_status |
enum | The reconciliation substatus of a transaction (MAX 255; MIN 3). | AUTOMATICALLY |
reconciliation_date |
timestamp | The date the transaction was reconciled (MAX 27; MIN 27; ISO 8601). | 2022-05-09T20:46:54.786342Z |
reconciliation_id |
string | The unique identifier assigned to a transaction when it is reconciled (MAX 255; MIN 3). | 2478d494-4a20-45b1-8a12-1c2604cf2d1d |
legal_entity |
string | The legal entity of the merchant (MAX 255; MIN 3). | ArcosDourados |
provider_merchant_account_name |
string | Name of the merchant account assigned by the payment provider. | ArcosDourados_Ecomm_BRA |
local_amount (A) |
decimal | The corresponding gross amount for all transactions in settlement currency plus local taxes and retention (multiple of 0.0001). | 263.09 |
provider_fees (A) |
decimal | The commission fee that was withheld by the acquirer on transactions in settlement currency. This should be the difference between the gross and net amounts but with the opposite sign (multiple of 0.0001). | 5.53 |
provider_fee_taxes (A) |
decimal | The commission fee tax that was withheld by the acquirer in settlement currency. This should be the difference between the gross and net amounts but with the opposite sign (multiple of 0.0001). | 1.22 |
net_amount (A) |
decimal | The amount submitted in the credit transaction requests minus acquirer fees in settlement currency (multiple of 0.0001). | 256.35 |
local_retention (A) |
decimal | The local amount minus the corresponding gross amount for all transactions in settlement currency minus the local tax (multiple of 0.0001). | 13.84 |
local_tax (A) |
decimal | The local amount minus the corresponding gross amount for all transactions in settlement currency minus the local retention (multiple of 0.0001). | 22.04 |
estimated_settlement_date (A) |
timestamp | Estimated date by the acquirer when the funds will be deposited in the merchant's bank account. | 2022-05-09 |
description (A) |
enum | Description of the merchant. | McDonalds Ecommerce |
(A) The availability of this data field depends on whether the processor or acquirer provides the information. If Yuno can identify the transaction, it will display the data; otherwise, the field may be empty.