All Transactions (CSV)

The following table describes the columns available in the account_transactions_v1 layout. Descriptions are based on the response schemas for GET /accounts/{acct_id}/transactions/{trx_id}, including the transaction-type metadata schemas flattened into this CSV report.

Description of the report columns

Column name	Description
`id`	ID of the transaction.
`type`	Type of the transaction.
`amount`	Amount of the transaction, represented in the smallest unit of the currency.
`previous_balance`	Balance of the account affected by the transaction before receiving it.
`current_balance`	Balance of the account affected by the transaction after receiving it.
`currency`	Currency of the transaction.
`credit_debit_type`	Indicates whether the transaction is a credit or debit.
`created_at`	Date when the transaction was created on the platform.
`transaction_date`	Date when the transaction was created in origin.
`account_id`	Unique identifier of the account affected by the transaction.
`account_alias`	Alias of the account affected by the transaction.
`account_geo`	Geography of the account affected by the transaction.
`account_provider_id`	Provider ID linked to the account affected by the transaction.
`account_provider_name`	Friendly name of the provider linked to the account affected by the transaction.
`account_number`	Account number or Cobre Tag of the account affected by the transaction.
`account_type`	Account type of the account affected by the transaction.
`metadata.sender_name`	Name of the sender related to the transaction.
`metadata.sender_id`	Identification number of the sender related to the transaction.
`metadata.description`	Transaction description returned in metadata.
`metadata.intended_beneficiary_name`	Intended beneficiary name for the transaction.
`metadata.intended_beneficiary_id`	Intended beneficiary identification for the transaction.
`metadata.sender_account_number`	Account number of the sender related to the transaction.
`metadata.tracking_key`	Tracking key provided by the network.
`metadata.reference`	Transaction reference returned by the payment network or source system.
`metadata.beneficiary_account_number`	Account number of the transaction beneficiary.
`metadata.money_movement_id`	Money Movement ID associated with the transaction.
`metadata.cep`	CEP (Comprobante Electronico de Pago) value for applicable SPEI transactions.
`metadata.bank_statement_id`	Bank statement ID associated with the transaction when provided by the financial institution.
`metadata.bank_transaction_type`	Bank transaction type associated with the transaction when provided by the financial institution.
`metadata.bank_transaction_type_code`	Bank transaction type code associated with the transaction when provided by the financial institution.
`metadata.bank_rejection_code`	Bank rejection code associated with the transaction when provided by the financial institution.
`metadata.bank_transaction_type_2`	Secondary bank transaction type associated with the transaction when provided by the financial institution.
`metadata.beneficiary_name`	Name of the transaction beneficiary.
`metadata.beneficiary_id`	Identification number of the transaction beneficiary.
`metadata.sender_bank_code`	Financial institution code of the sender.
`metadata.r2p_method`	R2P payment method associated with the transaction.
`metadata.operation_date`	Date when the operation was applied by the financial institution.
`metadata.mm_external_id`	External ID of the Money Movement associated with the transaction.
`metadata.beneficiary_id_type`	Identification type of the transaction beneficiary.
`metadata.account_reference`	Account reference associated with the transaction.

The following accordions show example values for each transaction type in the account_transactions_v1 layout.

spei_credit Example

spei_debit Example

spei_return Example

misc_debit Example

misc_credit Example

adjustment_credit Example

adjustment_debit Example

internal_credit Example

internal_debit Example

mex_credit Example

mex_debit Example

col_debit Example

col_credit Example

r2p_credit Example

col_cb_debit Example

col_cb_credit Example

dd_credit Example

cbmm_credit Example

cbmm_debit Example

breb_credit Example

r2p_breb_credit Example

r2p_spei_credit Example

transfer_credit Example