Report fields - Account balance - Mercado Pago Developers

Glossary

We know, some terms are technical and you may not be familiar with all of them. Use this glossary to not get lost!

Name on the report columnWhat it means
EXTERNAL_REFERENCE
ID that helps identify the origin of the operation. For example, it can be the sale through the order ID or the shipment (if it is a cart purchase) or the own ID provided by the seller in case of an external integration.

Keep in mind that it is possible that this field is empty for some cases such as ticket payment or money transfer, among others.

SOURCE_IDOperation ID in Mercado Pago (for example, the payment of a sale).
USER_IDSeller account code (Cust ID).
PAYMENT_METHODReview the available payment methods according to the country with which you operate in Mercado Pago.
PAYMENT_METHOD_TYPEPayment method type.

It can be:

credit_card: credit card.
debit_card: debit card.
bank_transfer: transfer.
atm: ATM.
ticket: cash.
account_money: account money.

SITECountry that the Mercado Pago account belongs to:

MLA: Argentina
MLB: Brasil
MLM: México
MLV: Venezuela
MLC: Chile
MCO: Colombia
MLU: Uruguay
MPE: Peru

TRANSACTION_TYPETransaction type.

It can be:

SETTLEMENT: approved payment.
REFUND: payment returned in whole or in part.
CHARGEBACK: the buyer made a chargeback (unrecognized payment) on his credit card.
DISPUTE: the buyer initiated a claim for that payment.
WITHDRAWAL: withdrawal to a bank account.
WITHDRAWAL_CANCEL: canceled withdrawal to a bank account.
PAYOUT: money withdrawal available at Mercado Pago.
TRAVA_DE_RECEBIVEL: block receivable.

TRANSACTION_AMOUNTGross amount of the transaction.
TRANSACTION_CURRENCYYou can take some of these values as appropriate:

MXN (Mexican Peso)
CLP (Chilean Peso)
ARS (Argentine Peso)
BRL (Brazilian Real)
COP (Colombian Peso)
PEN (Peruvian Sun)
UYU (Uruguayan Peso)
VES (Venezuelan Bolivar)

SELLER_AMOUNTAmount received for split purchases.
TRANSACTION_DATEDate of transaction accreditation.
FEE_AMOUNTSum of processing fees, shipments, financing and coupons if assumed by the seller.
SETTLEMENT_NET_AMOUNTNet amount of the transaction that impacted the account balance. All commissions involved from TRANSACTION_AMOUNT were discounted.
SETTLEMENT_CURRENCYYou can take some of these values as appropriate:

MXN (Mexican Peso)
CLP (Chilean Peso)
ARS (Argentine Peso)
BRL (Brazilian Real)
COP (Colombian Peso)
PEN (Peruvian Sun)
UYU (Uruguayan Peso)
VES (Venezuelan Bolivar)

SETTLEMENT_DATEDate the transaction money was credited.
REAL_AMOUNTNet amount of the transaction, if it is a settlement, the amounts for chargebacks, claims or returns are discounted.
COUPON_AMOUNTDiscount coupon amount. Only the gross amount (TRANSACTION_AMOUNT) is discounted if provided by the seller.
METADATAExtra data such as the ID of partial returns or data provided by the seller in case of having an external integration.
MKP_FEE_AMOUNTMercado Libre Fee.
FINANCING_FEE_AMOUNTCost for offering interest-free installments.
SHIPPING_FEE_AMOUNTShipping cost.
TAXES_AMOUNTTaxes charged for gross income withholdings.
INSTALLMENTSNumber of installments in which the operation was carried out.
TAX_AMOUNT_TELCOThe value of the tax on telecommunications companies that is deducted from the gross value.
TAX_DETAILDescription of the tax withheld by operation in TAXES_AMOUNT.

POS_IDCash ID if the payment is made through a physical commerce.
POS_NAMECash name for the payment made through a physical commerce.
EXTERNAL_POS_IDUser-defined cashier ID for payment made through a physical commerce.
STORE_IDBranch ID if payment is made through a physical commerce.
STORE_NAMEBranch name for payment made through a physical commerce.
EXTERNAL_STORE_IDUser-defined branch ID for payment made through a physical commerce.
ORDER_IDPurchase Order.
SHIPPING_IDShipping Identification.
SHIPMENT_MODEShipping Mode.
PACK_IDPackage identification in the cart.
TAXES_DISAGGREGATEDTaxes disaggregated in JSON format.
POI_IDPoint ID if payment is made through a physical retailer.
POI_WALLET_NAMEName of the digital wallet that a virtual payment comes from. Allows you to identify the origin of a transaction when you charge with a Mercado Pago QR Code.
POI_BANK_NAMEName of the bank that a virtual payment comes from. Allows you to identify the origin of a transaction when you charge with a Mercado Pago QR Code.
CARD_INITIAL_NUMBERIt corresponds to the first digits of the credit or debit card that you used to make the purchase.
OPERATION_TAGSThese are labels to categorize and/or segment different aspects of the transaction, such as the channels used to make a payment. They are identified as:
WHATSAPP_PAY: This label indicates that the payment was made via WhatsApp
QR: This label indicates that the payment was made with a QR code
PO: This label indicates that the payment was made with Point
MARKETPLACE: This label indicates that the payment was made directly in Mercado Libre.