Documentation V3
  • Localpayment documentation V3
  • INTRODUCTION TO OUR SOLUTION
    • Intro to our Documentation
    • Intro to Payment Methods in Emerging Markets
    • Merchant Dashboard
      • Dashboard Navigation
      • Login
      • User Roles
      • Roles
      • Users
      • Whitelist your IPs
      • Whitelist your BINs
      • Setup your Webhooks
      • Reports
        • Balance
        • Projected Balance
        • Activity
        • Transaction Detail
        • FIDES Report
      • Virtual accounts
      • Refunds
        • Refund Bank Transfer
        • Refund Card Capture
        • Refund Cash
      • Chargeback
      • Internal Domestic Transfer
      • Internal Foreign Transfer
      • Currency Exchange
        • Create
      • Wire In
      • Wire Out
    • Intro to FX operations
    • Business definitions
      • Payins
      • Payouts
    • Onboarding & Integration
    • Postman Collection
  • ENVIRONMENTS
    • Environments
  • BEFORE A PAYMENT
    • Access Token
    • Validations
      • Document Validation
      • Bank Account Validation
      • Validate BIN
    • Holidays
    • Search Payment Method
    • Search Bank Codes
    • Cash Agents Geolocalization
    • Installments Plan Quote
    • Currency Exchange Quote
    • Billing Service
      • Create
        • Mexico
      • Check Billing status
      • Download Billing
  • REQUEST A PAYMENT
    • Payins
      • Bank Transfer
        • Direct debit
          • DEBIN (Argentina)
          • Transfiya (Colombia)
          • Wallet Fri (Guatemala)
        • Virtual Account
          • Mexico
            • Request Individual
            • Request Batch
            • Check Virtual account
            • Delete Virtual account
            • Enable or Disable Virtual Account
          • Brazil
            • Request Individual
            • Check Virtual account
            • Alias ​​configuration
          • Argentina
            • Request Individual
            • Request Batch
            • Check virtual account
            • Delete Virtual account
          • Refund Virtual Account
        • Online Reference Code Payments
          • Mexico
        • Refund Bank Transfer
        • Cancel
        • APMs
          • CODI (Mexico)
          • ETPAY (Chile)
          • Fintoc (Chile)
          • Boleto (Brazil)
          • PIX (Brazil)
            • Refund Pix
          • PSE (Colombia)
          • QR (Bolivia)
          • QR (Guatemala)
          • QR (Argentina)
          • QR (Perú)
      • Cash
        • Cash
          • APMs
            • Boleto (Brazil)
        • Cancel
        • Refund Cash
      • Debit Card
        • Capture
        • Refund Capture
      • Credit Card
        • Capture
        • Create Authorization
        • Capture Authorization
        • Cancel Authorization
        • Refund Capture
        • Installments
        • Save Cards
          • Save Card
          • Get Card
          • Delete Card
        • 3D-Secure
        • Validate card
        • Chargebacks
          • Notification
          • Send documentation
          • Close Chargeback
    • Payin Subscriptions
      • Create a subscription
      • Update subscription
      • Cancel
    • Payin Subscriptions Plan
      • Create subscription plan
      • Update subscription plan
      • Get subscription plan
    • Payouts
      • Search available banks
      • Create
        • Argentina
        • Bolivia
        • Brazil
        • Chile
        • Colombia
          • Colombia ACH
          • Colombia Transfiya
        • Costa Rica
        • Dominic Republic
        • Guatemala
        • Honduras
        • Mexico
        • Panama
        • Peru
        • Kenya
      • Manual Upload
        • Create Batch Upload
        • Batch Pending Authorization
        • Cancel Batch Pending Authorization
        • Batch Activity
      • Proof of Payment (POP)
      • Cancel
      • Commit payout
      • Attach documents
      • Ripplenet getway
    • Payouts Double Signature
      • Authorize
    • Checkout
      • Webcheckout
        • Credit Card
        • Debit Card
        • Cash
        • Bank Transfer
      • Link Payment
      • Frequent Items
      • Iframe
      • Smart Checkout/ iframe
      • Virtual Pos
      • Plugins
        • Magento
        • Shopify
        • Google Pay
        • WooCommerce
  • AFTER A PAYMENT
    • Check Status
    • Check Payment
    • Check Payment list
    • Check Subscription
    • Account Balance
      • Balance Reconciliation
      • Current Balance Amount
    • Withholding Certificates
    • Proof of Payment
    • RFI - Documentation
  • SETTLEMENT & EXCHANGE
    • Wire In
    • Wire Out
    • Currency Exchange Bulk
      • Quote
      • Bulk
      • Currency exchange - Front end
    • Internal Transfers
      • Internal Domestic Transfer
      • Internal Foreign Transfer
  • NOTIFICATIONS
    • Callbacks - Webhooks
      • Configurations
      • Payins
        • Payin Bank Transfer
        • PSE Colombia
        • Payin Virtual Account
        • Payin Cash
        • Payin Credit Card
        • Payin Debit Card
      • Payouts
    • SFTP- Email Reports
  • API REFERENCE GUIDE
    • Validation Error Codes
    • Transaction Type & Status
      • Payin
      • Subscriptions
      • Payout
      • Chargeback
      • Credit
      • Currency Exchange
      • Debit
      • Expenses
      • Internal Transfer
      • Recall
      • Refund
      • Return
      • Recurring Fee
      • Wire in
      • Wire out
    • Payout Methods + SLA
      • Latam
    • Payin Methods + SLA
      • Argentina
      • Bolivia
      • Brazil
      • Chile
      • Colombia
      • Dominican Republic
      • Guatemala
      • Mexico
      • Panama
      • Peru
    • Currency Codes
      • Latam
    • Country Codes
      • Latam
    • Bank codes
      • Latam
        • Argentina
        • Bolivia
        • Brazil
        • Chile
        • Colombia
        • Costa Rica
        • Dominican Republic
        • Guatemala
        • Honduras
        • Mexico
        • Panamá
        • Peru
    • Bank account validations
      • Latam
        • Argentina
        • Bolivia
        • Brazil
        • Chile
        • Colombia
        • Costa Rica
        • Dominican Republic
        • Guatemala
        • Mexico
        • Panama
        • Peru
    • Document Validations
      • Argentina
      • Bolivia
      • Brazil
      • Chile
      • Colombia
      • Costa Rica
      • Dominican Republic
      • El Salvador
      • Guatemala
      • Honduras
      • Mexico
      • Panama
      • Peru
    • Concept Codes
  • FLOWS AND CHARACTERISTICS
    • Account Currencies
    • Involved Parties
    • Payin Status Flow
      • Payins
        • Payin Status Flow - Card
        • Payin Status Flow - Bank
        • Payin Status Flow -Cash
      • Refund - Card
      • Refund - Cash & Bank
      • Chargeback
    • Payout Status Flow
      • Payout - Bank
      • Return
      • Recall
    • Payin Subscription Flow
      • Payins Subscription Status Flow - Card
    • Virtual Account Status Flow
    • Settlement Status Flow
      • Wire In
      • Wire Out
    • Payin Methods Flow
      • Argentina
      • Bolivia
      • Brazil
      • Chile
      • Colombia
      • Dominican Republic
      • Guatemala
      • Honduras
      • Mexico
      • Panama
      • Peru
  • HOLIDAYS
    • 2021
    • 2022
    • 2023
    • 2024
    • 2025
  • COMPLIANCE
    • Values
    • Prohibited Countries
    • Prohibited Business
    • Compliance Program Docs
    • Licenses
    • Terms & Conditions
  • GLOSSARY
    • Payments Explained
    • FAQ
  • PLUGINS
    • Magento
    • Shopify
    • Google Pay
    • WooCommerce
    • Ripplenet
Powered by GitBook
On this page

Was this helpful?

  1. INTRODUCTION TO OUR SOLUTION
  2. Merchant Dashboard
  3. Reports

Transaction Detail

PreviousActivityNextFIDES Report

Last updated 1 year ago

Was this helpful?

The purpose of this report is to provide you with information on the properties of the payment (activity report), and of the parties such as the beneficiary or the payer.

Note: The time is expressed in the time zone of the browser used by the user.

Description of the columns of the Transaction Detail screen

Grouping
Display Column
Display Column
Description

Date

Creation

Date when the customer create the transaction.

Format AAAA-MM-DD HH:MM:SS.

Processed

Date when the transaction was processed.

Format AAAA-MM-DD HH:MM:SS.

Setlement

For Payin. Date when the status will changged to completed and be credited in the cliente account.

Format AAAA-MM-DD HH:MM:SS.

Expiration

Date when the transaction expires. Depends on the transaction type. Format AAAA-MM-DD HH:MM:SS.

ID

Internal

An ID that is meaningful to our system. It's unique.

External

An ID that is meaningful to you and your system. Must be unique.

Client

Name

Name of client.

Code

Code of client account in our system.

Number

Number of client account in our system.

MoR

Label used to identify the client's account number in our system.

Merchant Name

The name of the merchant sending the payment.

Payment Method

Transaction Type

Transaction Type. Example PayIn or PayOut.

Method Type

Type of Payment method defined for the transaccion. Verify it in the transaction type documentation.

Method Name

Name of Payment method defined for the transaccion. Verify it in the transaction type documentation.

Payer

Type

For Payin. Type of person performing the transaction. Value "INDIVIDUAL" or "COMPANY"

First Name

For Payin. Name of person performing the transaction.

Last Name

For Payin. Last name of person performing the transaction.

Document

Type

For Payin. Document type of person performing the transaction.

ID

For Payin. Document id of person performing the transaction.

Email

For Payin. Email of person performing the transaction.

User Reference

For Payin. Information adiction for the payer

Payer Bank

Name

For Payin. Name of bank where performing the transaction.

Code

For Payin. Code of bank where performing the transaction.

Branch

For Payin. Branch Code of bank where performing the transaction.

Account

Type

For Payin. Type of Account Number where performing the transaction.

Number

For Payin. Account number of person performing the transaction.

Alias

For Payin. Account Alias of Account performing the transaccion.

Phone

For Payin. Phone numbe of Bank performing the transaccion.

Beneficiary

Type

For Payout. Type of person that receive money.

Name

For Payout. Name of person that receive money.

Document

Type

For Payout. Document type of person that receive money.

ID

For Payout. ID Document of person that receive money.

email

For Payout. Email of person that receive money.

Beneficiary Bank

Name

For Payout. Name of bank where performing the transaction.

Code

For Payout. Code of bank where performing the transaction.

Branch

For Payout. Branch Code of bank where performing the transaction.

Account

Type

For Payout. Type of Account Number where performing the transaction.

Number

For Payout. Account number of person that receive money.

Alias

For Payout. Account Alias of Account performing the transaccion.

Phone

For Payout. Phone numbe of Bank performing the transaccion.

Status

Status

The status of the transaction in our system.

Description

Descripcion of status of the transaction in our system.

Comment

Comment of status of the transaction in our system.

Payment

Amount

Amount of the transaction. Reporting in the currency of field.

Withholdings / Financial Fee

Value of Withholdings / Financial Fee. Reporting in the currency of field.

Payment Amount

Value of payment amount. Reporting in the currency field.

Fx Quote

Value of FX rate.

Confirmed

Value confirmed of the transaction. Reporting in the currency of field.

Local Taxes

Value of Local Tax. Reporting in the currency of field.

Finalcial Fees

Value of Financial Fees. Reporting in currency of field.

Fees

Value of Fees. Reporting in currency of field.

How to generte a file

Select the <Export> option to generate the report

Definition of File Transaction Detail

  • The report generates an excel spreadsheet

  • Extension XLXS

  • Report name Client_Details_<MMDDAAAA>_<HHMMSS>

  • Column definition

Column title
Definition

Creation

Date when the customer create the transaction.

Format AAAA-MM-DD HH:MM:SS

Processed

Date when the transaction was processed.

Format AAAA-MM-DD HH:MM:SS

Setlement

For Payin. Date when the status will changged to completed and be credited in the cliente account.

Format AAAA-MM-DD HH:MM:SS

Expiration

Date when the transaction expires. Depends on the transaction type. Format AAAA-MM-DD HH:MM:SS

Internal ID

An ID that is meaningful to our system. It's unique.

External ID

An ID that is meaningful to you and your system. Must be unique.

Cliente Name

Name of client

Account Code

Code of client account in our system

Account Number

Number of client account in our system

MoR

Label used to identify the client's account number in our system

Merchant Name

The name of the merchant sending the payment

Transaction Type

Transaction Type. Example PayIn or PayOut

Payment Method Type

Type of Payment method defined for the transaccion. Verify it in the transaction type documentation

Payment Method Code

Code of Payment method defined for the transaccion. Verify it in the transaction type documentation

Payer Type

For Payin. Type of person performing the transaction. Value "INDIVIDUAL" or "COMPANY"

Payer Name

For Payin. Name of person performing the transaction.

Payer Lastname

For Payin. Last name of person performing the transaction.

Payer Document Type

For Payin. Document type of person performing the transaction.

Payer Document ID

For Payin. Document id of person performing the transaction.

Payer Email

For Payin. Email of person performing the transaction.

Payer User Reference

For Payin. Information adiction for the payer

Payer Bank Name

For Payin. Name of bank where performing the transaction.

Payer Bank Code

For Payin. Code of bank where performing the transaction.

Payer Bank Branch

For Payin. Branch Code of bank where performing the transaction.

Payer Bank Account Type

For Payin. Type of Account Number where performing the transaction.

Payer Account Number

For Payin. Account number of person performing the transaction.

Payer Bank Account Alias

For Payin. Account Alias of Account performing the transaccion.

Payer Bank Account Phone

For Payin. Phone numbe of Bank performing the transaccion.

Beneficiary Type

For Payout. Type of person that receive money.

Beneficary Name

For Payout. Name of person that receive money.

Beneficiary Lastname

For Payout. Lastname of person that receive money.

Beneficiary Document Type

For Payout. Document type of person that receive money.

Beneficiary Document ID

For Payout. ID Document of person that receive money.

Beneficiary Email

For Payout. Email of person that receive money.

Beneficiary Bank Name

For Payout. Name of bank where performing the transaction.

Beneficiary Bank Code

For Payout. Code of bank where performing the transaction.

Beneficiary Bank Branch

For Payout. Branch Code of bank where performing the transaction.

Beneficiary Bank Account Type

For Payout. Type of Account Number where performing the transaction.

Beneficiary Bank Account Number

For Payout. Account number of person that receive money.

Beneficiary Bank Account Alias

For Payout. Account Alias of Account performing the transaccion.

Beneficiary Bank Account Phone

For Payout. Phone numbe of Bank performing the transaccion.

Status

The status of the transaction in our system.

Description

Descripcion of status of the transaction in our system.

Comment

Comment of status of the transaction in our system.

Currency Amount

Currency of transaction amount

Amount

Amount of the transaction

Withholdings / Financial Fee Currency

Currency of transaction Withholdings / Financial Fee

Withholdings / Financial Fee

Value of Withholdings / Financial Fee

Payment Amount Currency

Currency of payment amount

Payment Amount

Value of payment amount

Fx Quote

Value of FX rate

Confirmed Currency

Currency of amount confirmed of the transaction.

Confirmed

Value confirmed of the transaction

Local Taxes Currency

Currency of Local Tax

Local Taxes

Value of Local Tax

Financial Fees Currency

Currency of Financial Fee

Financial Fees

Value of Financial Fees

Fees Currency

Currency of Fees

Fees

Value of Fees

Total Currency

Currency of transaction total

Total

Value of the total amount involved in the transaction.

Example File Transaction Detail

92KB
Client_Details_04262024_225526.xlsx