enterprise_rma Table

Last update: July 24, 2023

CREATED FOR:

  • Beginner
  • Intermediate
  • Admin
  • Developer
  • User

Each row in the enterprise_rma table (often called magento_rma in Adobe Commerce 2.x, but the name can be customized) contains information about a specific return request.

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

Common Native Columns

Column NameDescription
entity\_idUnique identifier for the table. Each entity\_id represents a return request.
date\_requestedThe date that the return was requested.
statusThe status of the return. Values include ‘received’, ‘pending’, ‘authorized’, among others.
order\_idForeign key associated with the sales\_flat\_order table.
customer\_idForeign key associated with the customer\_entity table.

Common Calculated Columns

Column NameDescription
Order's created\_atThis is the date of the original order. This can be used to obtain the time between order and return request.
Customer's order numberThis is the customer’s order number associated with the original order.
Seconds between order's created\_at and return's date\_requestedThe number of seconds from the order date to the return request.
Return's total valueThis is the total monetary amount that is returned. This is the sum of each return item’s individual return amount.