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 column | What 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_ID | Operation ID in Mercado Pago (for example, the payment of a sale). |
| USER_ID | Seller account code (Cust ID). |
| PAYMENT_METHOD | Review the available payment methods according to the country with which you operate in Mercado Pago. |
| PAYMENT_METHOD_TYPE | Payment method type. It can be: credit_card: credit card. debit_card: debit card. bank_transfer: transfer. atm: ATM. ticket: cash. account_money: account money. |
| SITE | Country 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_TYPE | Transaction 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. |
| TRANSACTION_AMOUNT | Gross amount of the transaction. |
| TRANSACTION_CURRENCY | You 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_AMOUNT | Amount received for split purchases. |
| TRANSACTION_DATE | Date of transaction accreditation. |
| FEE_AMOUNT | Sum of processing fees, shipments, financing and coupons if assumed by the seller. |
| SETTLEMENT_NET_AMOUNT | Net amount of the transaction that impacted the account balance. All commissions involved from TRANSACTION_AMOUNT were discounted. |
| SETTLEMENT_CURRENCY | You 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_DATE | Date the transaction money was credited. |
| REAL_AMOUNT | Net amount of the transaction, if it is a settlement, the amounts for chargebacks, claims or returns are discounted. |
| COUPON_AMOUNT | Discount coupon amount. Only the gross amount (TRANSACTION_AMOUNT) is discounted if provided by the seller. |
| METADATA | Extra data such as the ID of partial returns or data provided by the seller in case of having an external integration. |
| MKP_FEE_AMOUNT | Mercado Libre Fee. |
| FINANCING_FEE_AMOUNT | Cost for offering interest-free installments. |
| SHIPPING_FEE_AMOUNT | Shipping cost. |
| TAXES_AMOUNT | Taxes charged for gross income withholdings. |
| INSTALLMENTS | Number of installments in which the operation was carried out. |
| TAX_AMOUNT_TELCO | The value of the tax on telecommunications companies that is deducted from the gross value. |
| TAX_DETAIL | Description of the tax withheld by operation in TAXES_AMOUNT. |
| POS_ID | Cash ID if the payment is made through a physical commerce. |
| POS_NAME | Cash name for the payment made through a physical commerce. |
| EXTERNAL_POS_ID | User-defined cashier ID for payment made through a physical commerce. |
| STORE_ID | Branch ID if payment is made through a physical commerce. |
| STORE_NAME | Branch name for payment made through a physical commerce. |
| EXTERNAL_STORE_ID | User-defined branch ID for payment made through a physical commerce. |
| ORDER_ID | Purchase Order. |
| SHIPPING_ID | Shipping Identification. |
| SHIPMENT_MODE | Shipping Mode. |
| PACK_ID | Package identification in the cart. |
| TAXES_DISAGGREGATED | Taxes disaggregated in JSON format. |
| POI_ID | Point ID if payment is made through a physical retailer. |
| POI_WALLET_NAME | Name 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_NAME | Name 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_NUMBER | It corresponds to the first digits of the credit or debit card that you used to make the purchase. |
| OPERATION_TAGS | These 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. |
| BUSINESS_UNIT | Corresponds to the channel through which an order was generated. The channels are Mercado Pago, Mercado Libre, Mercado Shops and Delivery. |
| SUB_UNIT | Allows you to identify the method that was used to collect the payment of an order with Mercado Pago. |
(*) This information can only be used for reconciliation purposes, will be treated according to the applicable
personal data protection laws and will be available when payments via QR code or transfers are received, as well as
when a donation is received by an NGO.