Order Line

Table name (referenced in Insights SQL queries): marts_mdc__order_line

This mart contains information how orders are fulfilled by ShipMonk (which products were shipped in given order). It also contains tracking fulfillment, status, shipping details, and trading partner information. In case you want to see order items you submit to ShipMonk, you can use "order item" 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.
warehouse_id	number	Identifier for the warehouse handling the fulfillment of the order.
warehouse_name	varchar	Represents the name of the warehouse.
account_id	number	Identifier for the account placing the order.
sku	varchar	Stock Keeping Unit (SKU) for the product, used for inventory and tracking.
product_name	varchar	Name of the product ordered by the customer.
order_status_group	varchar	Group classification of the order’s status, indicating overall progress.
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.
store_name	varchar	Name of the store the order was created within.
ordered_at_utc	timestamp_ntz	UTC timestamp when the order was placed.
date_ordered	date	Date when the order was placed.
order_created_at_utc	timestamp_ntz	UTC timestamp when the order record was created in the system.
date_created	date	Date when the order record was created in the system.
order_submitted_at_utc	timestamp_ntz	UTC timestamp when the order was submitted for fulfillment.
date_submitted	date	Date when the order was submitted for fulfillment.
order_shipped_at_utc	timestamp_ntz	UTC timestamp when the order was shipped to the customer.
date_shipped	date	Date when the order was shipped to the customer.
shipping_method	varchar	Name of the shipping method chosen for the order delivery.
country_name	varchar	Name of the destination country for the order.
address_state	varchar	State or region in the shipping address of the order.
is_monk_protected	varchar	Boolean flag indicating if the order is covered by Monk Protect.
shipping_zone	varchar	Designated shipping zone for the order, used for logistics and pricing.
tracking_number	varchar	Tracking number for the fulfillment, used to monitor shipment status.
warehouse_timezone	varchar	Timezone of the warehouse location, relevant for local timing.
ordered_quantity	number	Quantity of the product ordered for fulfillment.
packed_quantity	number	Quantity of the product that has been packed for shipment.
backordered_quantity	number	Quantity of the product currently on backorder.
account_trading_partner_name	varchar	Name of the account trading partner if set
merged_from_orders_list	varchar	A comma separated list of order ids this order was merged from
order_updated_at_utc	timestamp_ntz	UTC timestamp when the order was last updated.
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.
serial_numbers	varchar	Serial numbers associated with products in the order, if applicable.
order_gift_from	varchar	Name of the person sending the gift order, if applicable.
order_gift_message	varchar	Gift message included with the order, if applicable.
order_customer_notes	varchar	Additional notes or comments provided by the customer with the order.
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_name	varchar	Name of the customer who placed the order.
customer_email	varchar	Email address of the customer who placed the order.
company	varchar	Company name associated with the customer's address.
address_line1	varchar	First line of the customer's shipping address.
address_line2	varchar	Second line of the customer's shipping address.
address_city	varchar	City of the customer's shipping address.
address_country_id	varchar	Country identifier for the customer's shipping address.
address_country_name	varchar	Country name for the customer's shipping address.
address_country_iso3	varchar	ISO 3166-1 alpha-3 country code for the customer's shipping address.
address_zip3	varchar	ZIP3 (first 3 digits of postal code) of the customer's shipping address, as defined by United States Postal Service. NULL outside USA.
address_is_residential	boolean	Boolean flag indicating if the customer's shipping address is residential.
billing_country_id	integer	Identifier for the billing country.
billing_country_name	varchar	Name of the billing country.
shipping_payment_terms_type	integer	Type of shipping payment terms for order.
billing_account_number	varchar	Account number associated with the shipping payment terms for order.
billing_zip	varchar	Billing zip code associated with the shipping payment terms.
lot_number	varchar	Lot number associated with the order line inventory.
lot_expiration_date	date	Expiration date of the inventory lot associated with the order line.
has_engraving	boolean	Boolean flag indicating if the order line contains items with engraving special instructions.
has_embroidery	boolean	Boolean flag indicating if the order line contains items with embroidery special instructions.