Order Item¶

Table name (referenced in Insights SQL queries): marts_mdc__order_item

This mart contains information about order items imported or manually created. It should serve as a source of truth for the synchronization from your system. To resolve bundle component products, join with "bundle mapping" mart on bundle_id. In case you want to see how each order is fulfilled use "order line" mart.

Columns¶

Column	Type	Description
`order_id`	`number`	Unique identifier for the order within the system.
`order_number`	`varchar`	The primary order identifier as defined by the order source. Typically the customer-facing order number (e.g. shown in confirmation emails), but is also commonly set to an internal reference such as a shipment or fulfillment number when sent from an ERP.
`order_key`	`varchar`	Unique key identifier for the order used for external reference.
`order_type`	`varchar`	Order type indicating the sales channel or fulfillment purpose. Possible values: direct_to_consumer, retail, amazon, transfer, removal_liquidation, disposal, bonded_inventory_clearance, work_order.
`account_id`	`number`	Identifier for the account that placed the order.
`order_status`	`varchar`	Overall status of the order. Possible values: invalid, cancelled, processing, submitted, complete, onHold, pick_in_progress, pending_batching, fulfilled_by_3rd, awaiting_package_forwarding, awaiting_label_request_from_merchant_facility.
`processing_status`	`varchar`	Current processing status of the order. Possible values: backorder, unable_to_submit, queued_to_submit, subscription, package_forwarding, awaiting_label_request_from_merchant_facility, on_hold, submitted, pick_in_progress, pack_in_progress, packed, awaiting_pick_up, awaiting_carrier_processing, en_route, delivered, undeliverable, shipped_untrackable, fulfilled_by_3rd, cancellation_requested, cancelled, updating.
`store_name`	`varchar`	Name of the store the order was created within.
`trading_partner_name`	`varchar`	Name of the account trading partner if set
`order_source`	`varchar`	Source system or channel where the order originated. Possible values: manual, imported (automatically imported via integration), manually_imported (imported by user in the app), merged, cloned, splitted, oversize_split, wholesale_split, claim_reship, automated_bonded_clearance_order.
`customer_notes`	`varchar`	Additional notes or comments provided by the customer with the order.
`gift_from`	`varchar`	Name of the person sending the gift order, if applicable.
`gift_message`	`varchar`	Gift message included with the order, if applicable.
`is_monk_protected`	`varchar`	Boolean flag indicating if the order is covered by Monk Protect.
`merged_from_orders_list`	`varchar`	A list of order ids this order was merged from
`marketplace_sku`	`varchar`	The SKU provided by the merchant when placing the order. For bundle orders, this is the merchant-side SKU that maps to one or more physical products in ShipMonk.
`line_key`	`varchar`	Unique key for this line within the order, as provided by the merchant when submitting the order. Used to cross-reference order lines with the merchant's own system.
`quantity`	`number`	Requested quantity of the item on the order.
`item_deleted_at_utc`	`timestamp_ntz`	Timestamp (UTC) when the item was removed from the order, or null if the item is still active.
`bundle_id`	`number`	Identifier of the bundle this item belongs to, or null if the item is not a bundle.