Package Line

Table name (referenced in Insights SQL queries): marts_mdc__package_line

Table providing detailed information on package line.

Columns

Column	Type	Description
order_id	number	Reference to link individual package to its corresponding order.
order_number	varchar	Represents the unique merchant identifier assigned to a specific order.
order_key	varchar	Unique key identifier for the order used for external reference.
warehouse_id	number	Represents the unique identifier assigned to the warehouse from which the order was fulfilled.
warehouse_name	varchar	Represents the name of the warehouse from which the order was fulfilled.
account_id	number	Represents the unique identifier assigned to the account associated with a particular package in ShipMonk.
account_name	varchar	Represents the name of the account associated with a particular package in ShipMonk.
package_id	number	Unique identifier of the Package.
tracking_number	varchar	Contains the identifier assigned to a package for tracking purposes.
package_weight	number	Represents the weight of a package in pounds.
weight_unit	varchar	Represents the unit of weight of the item.
packed_quantity	number	Quantity of SKU that have been packed and prepared for shipment within an order.
product_id	number	Unique identifier of the Product.
sku	varchar	Identifier of the SKU as recorded in ShipMonk.
product_name	varchar	Detailed description of the SKU as entered in the Product Name field of ShipMonk.
packaging_name	varchar	The SKU for the packaging type utilized.
zone	varchar	The shipping zone used to determine shipping costs, typically based on the distance between the origin and destination.
delivered_at_utc	timestamp_ntz	Timestamp of the delivery scan of the package by the shipping carrier, UTC time.
time_in_transit_business_days	number	The number of business days (excluding holidays) between the timestamps for Truck Check out and Delivery.