DocumentationCommerceCommerce Intelligence User Guide

enterprise_rma_item_entity Table

Last update: April 8, 2026

CREATED FOR:

  • Beginner
  • Intermediate
  • Admin
  • Developer
  • User

Each row in the enterprise_rma_item_entity table (often called magento_rma_item_entity in Commerce 2.x, but the name can be customized) contains information about a specific item from a requested return.

NOTE
This table only comes standard with your Commerce account if you are an Enterprise Edition or Enterprise Cloud Edition customer.

Common Native Columns

Column Name
Description
entity_id
Unique identifier for the table. Each entity_id represents an item that has been requested for return.
rma_entity_id
Foreign key associated with the enterprise_rma table.
status
The status of the item’s return. Values include ‘received’, ‘pending’, ‘authorized’, among others. The values in this status may not match the value of the overall return’s status.
qty_requested
The quantity the customer requests for return.
qty_approved
The quantity approved for return.
qty_returned
The quantity returned.
order_item_id
Foreign key associated with the sales_flat_order_item table.
product_sku
The sku being returned.

Common Calculated Columns

Column Name
Description
Return date_requested
This is the date that the customer requested the return.
Item price
The price of the item.
Return item's total value (qty_returned * price)
This is the total monetary value of the items that are returned. This is used to calculate the total return amount on the enterprise_rma table.

Common Metrics

Metric Name
Description
Construction
Number of items returned
The number of items that are returned.
Operation Column: qty returned
Operation: Sum
Timestamp Column: Return date requested
Returned items' total value
The monetary amount returned.
Operation Column: Return item’s total value (qty returned * price)
Operation: Sum
Timestamp Column: Return date requested

Connections to Other Tables

enterprise_rma

  • Create joined columns such as Return date_requested on the enterprise_rma_item_entity table via the following join:
  • Commerce 1.x: enterprise_rma_item_entity.rma_entity_id  (many) => enterprise_rma.entity_id (one)
  • Commerce 2.x: magento_rma_item_entity.rma_entity_id  (many) => magento_rma.entity_id (one)

sales_flat_order_item

  • Create joined columns on the  enterprise_rma_item_entity table via the following join:

  • Commerce 1.x: enterprise_rma_item_entity.order_item_id  (many) => sales_flat_order_item.item_id (one)

  • Commerce 2.x: magento_rma_item_entity.order_item_id  (many) => sales_order_item.item_id (one)

recommendation-more-help
commerce-business-intelligence-help-mbi