Package Line¶

Table name:

referenced in Insights SQL queries: "PACKAGE_LINE"
in data catalog export: 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. (Deprecated: use `shipping_zone` instead. Will be dropped on September 1, 2026.)
`shipping_zone`	`varchar`	The shipping zone assigned to your package by the carrier. Zones are used to determine base shipping rates and generally reflect the distance between the origin warehouse and the delivery destination — lower zones indicate shorter distances, higher zones indicate longer distances. The value depends on the carrier and service used: US domestic carriers (UPS Ground, FedEx Ground, USPS, DHL eCommerce, OnTrac, Cirro, SpeedX) use a number from 1 to 8 (or up to 9 for some USPS services), where Zone 1 is the closest and Zone 8 the farthest; UPS express services use a 3-digit code where the hundreds digit indicates the service tier (1xx = Next Day Air, 2xx = 2nd Day Air, 3xx = 3 Day Select); UPS Ground / FedEx Ground to Alaska, Hawaii, or Puerto Rico may show values of 17 (FedEx) or 44/45/46 (UPS) representing carrier-defined surcharge zones; Canada Post domestic services use an alphanumeric code (e.g. A1, G3) derived from the destination postal code prefix; Royal Mail uses an alphanumeric postcode-based zone (e.g. SW1A); international services (UPS Worldwide, DHL International, Passport, Royal Mail International) use a 2-letter ISO country code (e.g. GB, AU, MX); blank/null means zone is not applicable or not provided by the carrier, expected for international flat-rate services (FedEx International, FlavorCloud) and some specialty services where zone does not factor into pricing.
`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.