Order Reference 7D¶

Table name:

Order Reference (marts_mdc__order_reference) data limited to the latest 7 calendar days by order last_updated_at_utc column

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.