Order Line 7D

Table name:

• referenced in Insights SQL queries: "ORDER_LINE_7D"
• in data catalog export: marts_mdc_order_line_7d

Order Line (marts_mdc__order_line) 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 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.
order_created_at_utc	timestamp_ntz	UTC timestamp when the order record was created in the system.
order_submitted_at_utc	timestamp_ntz	UTC timestamp when the order was submitted for fulfillment.
order_shipped_at_utc	timestamp_ntz	UTC timestamp when the order was shipped to the customer.
shipping_method_name	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.
trading_partner_name	—	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.