Order Reference

Table name (referenced in Insights SQL queries): marts_mdc__order_reference

View all order references associated with your orders. This table provides a complete list of all reference values linked to orders, including PO numbers, external order IDs, and other reference types used for tracking and identification. Orders may have multiple references, and all are included in this view.

Columns

Column	Type	Description
order_id	number	Unique identifier for the order associated with this reference. An order may have multiple references of different types.
account_id	number	Unique identifier for your merchant account.
order_reference_value	varchar	The reference value associated with the order. This could be a Purchase Order (PO) number, external order ID, or other identifier used for tracking and cross-referencing orders between systems.
reference_type	varchar	Type of reference this record represents. Common types include 'po_number' for Purchase Order numbers. This field helps categorize different kinds of order references for easier filtering and reporting.
order_reference_created_at_utc	timestamp_ntz	UTC timestamp indicating when this order reference was created in the system. This helps track when additional references were added to orders.