Return Line

Table name (referenced in Insights SQL queries): marts_mdc__return_line

Provides detailed return line information, including linked orders, accounts, warehouses, products, and return costs. Tracks individual item-level data for returns.

Columns

Column	Type	Description
return_entity_id	number	Unique identifier for the return entity associated with the line.
rma	varchar	Return Merchandise Authorization for the return line.
receiving_item_id	number	Identifier of the receiving item linked to the return line.
order_id	number	Identifier of the order associated with the return line.
order_number	varchar	Number of the order linked to the return line.
order_key	varchar	Unique key identifier for the order used for external reference.
account_id	number	Identifier of the account associated with the return line.
account_name	varchar	Name of the account linked to the return line.
warehouse_id	number	Identifier of the warehouse associated with the return line.
warehouse_name	varchar	Name of the warehouse linked to the return line.
lot_number	varchar	Lot number of the inventory
expiration_date	varchar	Expiration date of the inventory
return_entity_created_at_utc	timestamp_ntz	Timestamp when the return entity was created.
return_entity_received_at_utc	timestamp_ntz	Timestamp when the return entity was received at the warehouse.
return_entity_updated_at_utc	timestamp_ntz	Timestamp when the return entity was last updated.
return_reason	varchar	Reason for the return provided by the customer or system.
return_tracking_number	varchar	Carrier specific identifier usable to track the return package.
return_entity_source	varchar	Indicates the origin of the return. For returns created via the ShipMonk API or manually within the Order Management System (OMS), the value will be ShipMonk. Other values correspond to returns processed through external integrations.
product_id	number	Identifier of the product being returned.
product_name	varchar	Name of the product being returned.
sku	varchar	Stock Keeping Unit (SKU) of the product being returned.
final_disposition	varchar	Final disposition
product_replacement_value	number	Replacement value of the product being returned.
product_replacement_value_currency	varchar	Currency of product replacement value in ISO 4217 (USD / EUR / GBP).
receiving_item_status	varchar	Status of the receiving item linked to the return line.
return_entity_status	varchar	Current status of the return entity associated with the return line.
return_cost	number	Calculated cost for processing the return line.
return_cost_currency	varchar	Currency of return cost in ISO 4217 (USD / EUR / GBP).
expected_quantity	number	Quantity of items expected to be returned.
received_quantity	number	Quantity of items actually received in the return.
warehouse_timezone	varchar	Timezone of the warehouse associated with the return line.
return_entity_note	varchar	Additional notes or comments about the return line.