DATE |
The release date of the monetary movement. It may also refer to the date the movement was blocked or unblocked (due to an opening or settlement of a payment dispute). |
SOURCE_ID |
This ID represents the operations registered in Mercado Pago, such as receiving money from a sale or paying a shipping fee.
This ID can be used to view more details of the operation by using the search tab in the Activities section.
|
EXTERNAL_REFERENCE |
This information allows you to identify a transaction according to its origin. The code can be:
- Order ID: This ID can be used to track the status of the order in Global Selling and the payment of the sale in Mercado Pago.
- Shipping ID: Represent the payment of shipping fees.
This field may be empty for some cases, such as money transfers, among others.
This information is also available in the columns ORDER_ID and SHIPPING_ID. If you do not see them, you can add them to the reports: Reports -> Release Reports -> Set up
Also, the following information is shown:
- Advertising Payment: A code preceded by the word “PADS”
- Invoice Payment: A code preceded by the word “MELIPAYMENTS”
- Money returned to you by customer service resolutions: A code preceded CASHBACK
This field may be empty for some cases, such as money transfers.
|
RECORD_TYPE |
- initial_available_balance: Money available from the previous period.
- release: Liberated money from the collection of a sale, or payment of a fee such as shipping.
- total: Total net amount of money movements.
- available_balance: Account balance before and after a withdrawal or deposit.
|
DESCRIPTION |
For blocked or unblocked
- chargeback: A charge returned to a payment card after a buyer successfully disputes an item on their account.
- reserve_for_dispute: It is the reserve of money/release of money done when mediation or complaint is initiated or resolved. It can occur before or after the payment has been released as available. You can check the amount in the withheld money section in Mercado Pago.
- shipping_return: When a payment made by express return is blocked or unlocked.
- reserve_for_payment: Reserve generated before the payment of expenses such as Invoices.
- reserve_for_debt_payment: Amount of money retained for Invoice payment and debt collection.
- reserve_for_refund: Value retained for approved returns of the products.
- reserve_for_bpp_shipping_return: The value we retained during the initiation of a claim. Represent the cost of the eventual return shipping fee.
For release
- payment: The amount of money paid to you for each sale, discounting the corresponding selling fee.
- refund: The amount of the selling fee that we return to you after the settlement of a claim.
- shipping: We charge you a fee for the delivery of the product to the buyer.
- shipping_cancel: Cancellation of the shipping fee.
- mediation: Amount of money debited from the seller and given to the buyer after the resolution of a complaint in favor of the buyer.
- mediation_cancel: Amount of money credited to the seller after the resolution of a complaint.
- chargeback: Funds that are returned after the cardholder has disputed a charge and the dispute has been resolved in their favor.
- payout: Amount of money transferred to your preferred collection method.
For available_balance
The field will display the prefix "pre" or "pos" to indicate the balance before or after a withdrawal or transfer, as appropriate, followed by the type of transaction, in this case, a transfer (payout), and finally, the identification number of the transaction or ID Source. (Payment ID)
Prefix + transaction name + transaction number.
Example: pre_payout_ID source pre_payout_1948976543 pos_payout_1948976543
|
GROSS_AMOUNT |
The gross operation amount depends on the type of transaction. For example:
- payments: Consider the total value of the sale without discounting the selling fee.
- shipping: Amount of money charged to the seller.
- payout: Total amount to be transferred to your collection method.
|
MP_FEE_AMOUNT |
Selling fee that Mercado Libre charges the seller for each sale. The percentage depends on the category of the product.
VAT included. |
SHIPPING_FEE_AMOUNT |
Shipping fee based on validated gross weight and dimensions of the package. |
NET_CREDIT_AMOUNT |
Amount of money added to your balance. |
NET_DEBIT_AMOUNT |
Amount of money subtracted from your balance. |
CURRENCY |
Currency used in this report (USD). |
SHIPPING_ID |
Shipping identification to track the logistic status. |
ORDER_ID |
Order Identification: It is useful to track the status of the order in Global Selling and also track the payment in Mercado Pago. |
ITEM_ID |
Identifier of the product sold. |
PACK_ID |
Package identification in the cart.
For example, in Fulfillment sales, you can have more than one Order ID related to a single Pack ID.
|
TRANSACTION_APPROVAL_DATE |
Date of approval of the operation
|