Skip to content

Package Level Detail

Table name:

  • referenced in Insights SQL queries: "PACKAGE_LEVEL_DETAIL"
  • in data catalog export: marts_mdc_package_level_detail

The Package Level Detail report provides a comprehensive breakdown of individual shipment details at the package level, for orders with multiple packages there will be multiple lines within the report. This report helps ensure transparent reconciliation of shipping charges and supports logistics efficiency.

Column availability by pricing source. Some columns are only populated for certain pricing sources or billing arrangements. Each row's pricing source is exposed in the pricing_source column — see that column for the definitions and the carriers/methods that fall into each. Where a column is not populated for every shipment, its description ends with an Availability: note referencing one of those pricing sources; columns without an Availability: note are populated for all shipments.

Columns

Column Type Description
account_name varchar Name of the ShipMonk account on the order the package was shipped for.
account_id number Unique identifier of the ShipMonk account.
warehouse_name varchar The name of the warehouse where the package was processed or shipped from.
store varchar Name of the store within ShipMonk the order the package was shipped for was created within. (Deprecated: use store_name instead. Will be dropped on September 1, 2026.)
store_name — Name of the store within ShipMonk the order the package was shipped for was created within.
trading_partner varchar Name used for identifying orders associated with a certain retailer or partner. (Deprecated: use trading_partner_name instead. Will be dropped on September 1, 2026.)
trading_partner_name varchar Name used for identifying orders associated with a certain retailer or partner.
order_id number Unique identifier for the order within the system.
order_number varchar Merchant identifier associated with the order associated with the package.
shipmonk_invoice_number varchar A unique identifier for the invoice issued by ShipMonk that the order for this package was billed.
invoice_billing_period_end_date date The last date of the billing period that this invoice covers.
postal_code varchar The postal or ZIP code of the destination where the package will be delivered.
city varchar The city where the package will be delivered.
state varchar The state or region of the delivery address.
country varchar The ISO 3166-1 alpha-2 country code of the package's destination.
customer_name varchar The name of the customer receiving the package.
company varchar The name of the company or business in the "Company" field on the shipping address.
tracking_number varchar The tracking number assigned to the package for shipment tracking purposes (deprecated).
package_id number Unique identifier of the Package in the ShipMonk app.
package_tracking_number varchar The tracking number assigned to the package for shipment tracking purposes.
Blank for Multipack DHL Express shipments — use master_tracking_number instead.
master_tracking_number varchar The tracking number assigned to the package or assigned to the first package for multi-package shipments.
customer_shipping_method_name varchar The name of the shipping method visible in the ShipMonk platform during the order process.
actual_shipping_method_name varchar The shipping method used to ship the package.
pricing_source varchar Categorization of the package by how its pricing was calculated, which determines which pricing columns are populated. Assignment depends on the shipping method (Current Rating Engine vs Legacy Rating Engine) and on who is billed (Third-Party Billed). Possible values:
  • Current Rating Engine: ShipMonk Virtual Carrier Network, USPS (US Domestic), FedEx (US Domestic), FedEx Canada, Canada Post, Passport Canada, UPS (US Domestic). Priced through ShipMonk's current rating engine. The detailed rating fields — billable weight type, dimensional weight factor, fuel %, residential flag, surcharge breakdowns, zone, and dimensions — are populated.
  • Legacy Rating Engine: all other carriers/methods not included in Current Rating Engine. Priced through ShipMonk's legacy rating engine. A net amount and currency may still be available, but the detailed rating fields are blank. Shipping methods are gradually being migrated from Legacy Rating Engine to Current Rating Engine, so the split shifts over time.
  • Third-Party Billed: shipments billed to a party other than ShipMonk. Most pricing columns are blank.
reconciliation_status varchar The reconciliation state of the package's shipping cost against the carrier invoice. Possible values:
  • Reconciled: shipping cost was adjusted before invoice close-out.
  • Reconciled with Period Adjustment: shipping cost was adjusted after invoice close-out; extra charges billed as period adjustments.
  • Not Reconciled: the carrier invoice has not yet been reconciled for this package.

Reconciliation is driven by the carrier invoice, which typically takes up to ~30 days after shipment to be received. The carrier invoice must be received within 40 days of shipment; if it is not, the package stays Not Reconciled permanently.
shipped_at_utc timestamp_ntz Timestamp when the order is marked as shipped within the ShipMonk platform, UTC time.
packaging_name varchar The SKU for the packaging type utilized.
estimated_width number The estimated width of the package in units specified in estimated_dimensions_unit.
Availability: Current Rating Engine only.
estimated_height number The estimated height of the package in units specified in estimated_dimensions_unit.
Availability: Current Rating Engine only.
estimated_length number The estimated length of the package in units specified in estimated_dimensions_unit.
Availability: Current Rating Engine only.
estimated_dimensions_unit varchar The unit of measurement used for the estimated package dimensions. One of in, cm, mm, m, ft.
Availability: Current Rating Engine only.
estimated_weight number The estimated physical weight of the package in pounds.
Availability: Current Rating Engine only.
estimated_billable_weight_type varchar The type of weight used to calculate the estimated billable weight for the shipment. Possible values: Real (charged on actual physical weight), Dimensional (charged on dimensional weight derived from package size), LargePackageMinimum (carrier-applied minimum billable weight for oversized packages).
Availability: Current Rating Engine only.
estimated_billable_weight number The estimated billable weight of the package used for pricing purposes.
Availability: Current Rating Engine only.
estimated_billable_weight_unit varchar The unit of measurement used for the estimated billable weight (e.g., pounds, ounces).
Availability: Current Rating Engine only.
adjusted_width number The final, adjusted width of the package after invoicing by the carrier, in units specified in adjusted_dimensions_unit.
Populated only for Current Rating Engine packages where the carrier invoice changed the billed amount during reconciliation (reconciliation_status = 'Reconciled with Period Adjustment'). Blank when the carrier confirmed the estimate unchanged or reconciliation is still pending.
adjusted_height number The final, adjusted height of the package after invoicing by the carrier, in units specified in adjusted_dimensions_unit.
Populated only for Current Rating Engine packages where the carrier invoice changed the billed amount during reconciliation (reconciliation_status = 'Reconciled with Period Adjustment'). Blank when the carrier confirmed the estimate unchanged or reconciliation is still pending.
adjusted_length number The final, adjusted length of the package after invoicing by the carrier, in units specified in adjusted_dimensions_unit.
Populated only for Current Rating Engine packages where the carrier invoice changed the billed amount during reconciliation (reconciliation_status = 'Reconciled with Period Adjustment'). Blank when the carrier confirmed the estimate unchanged or reconciliation is still pending.
adjusted_dimensions_unit varchar The unit of measurement used for the adjusted package dimensions. One of in, cm, mm, m, ft.
Populated only for Current Rating Engine packages where the carrier invoice changed the billed amount during reconciliation (reconciliation_status = 'Reconciled with Period Adjustment'). Blank when the carrier confirmed the estimate unchanged or reconciliation is still pending.
adjusted_weight number The final, adjusted physical weight of the package after invoicing by the carrier in pounds.
Populated only for Current Rating Engine packages where the carrier invoice changed the billed amount during reconciliation (reconciliation_status = 'Reconciled with Period Adjustment'). Blank when the carrier confirmed the estimate unchanged or reconciliation is still pending.
adjustment_billable_weight_type varchar The type of weight (e.g., dimensional or real) used to calculate the adjusted billable weight for the shipment. (Deprecated: use adjusted_billable_weight_type instead. Will be dropped on September 1, 2026.)
Populated only for Current Rating Engine packages where the carrier invoice changed the billed amount during reconciliation (reconciliation_status = 'Reconciled with Period Adjustment'). Blank when the carrier confirmed the estimate unchanged or reconciliation is still pending.
adjusted_billable_weight_type varchar The type of weight used to calculate the adjusted billable weight for the shipment. Possible values: Real (charged on actual physical weight), Dimensional (charged on dimensional weight derived from package size), LargePackageMinimum (carrier-applied minimum billable weight for oversized packages).
Populated only for Current Rating Engine packages where the carrier invoice changed the billed amount during reconciliation (reconciliation_status = 'Reconciled with Period Adjustment'). Blank when the carrier confirmed the estimate unchanged or reconciliation is still pending.
adjusted_billable_weight number The final, adjusted billable weight of the package used for pricing purposes after invoicing by the carrier.
Populated only for Current Rating Engine packages where the carrier invoice changed the billed amount during reconciliation (reconciliation_status = 'Reconciled with Period Adjustment'). Blank when the carrier confirmed the estimate unchanged or reconciliation is still pending.
adjusted_billable_weight_unit varchar The unit of measurement used for the adjusted billable weight (e.g., pounds, ounces).
Populated only for Current Rating Engine packages where the carrier invoice changed the billed amount during reconciliation (reconciliation_status = 'Reconciled with Period Adjustment'). Blank when the carrier confirmed the estimate unchanged or reconciliation is still pending.
dimensional_weight_factor number The divisor used to calculate dimensional weight (based on package size rather than actual weight) in the calculation length * width * height / dim_factor.
Availability: Current Rating Engine only.
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.)
Availability: Current Rating Engine only.
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): a number from 1 to 8 (up to 9 for some USPS services), where Zone 1 is the closest and the highest zone is the farthest.
  • UPS express services: 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: 17 (FedEx) or 44/45/46 (UPS), representing carrier-defined surcharge zones.
  • Canada Post domestic services: an alphanumeric code (e.g. A1, G3) derived from the destination postal code prefix.
  • Royal Mail: an alphanumeric postcode-based zone (e.g. SW1A).
  • International services (UPS Worldwide, DHL International, Passport, Royal Mail International): a 2-letter ISO country code (e.g. GB, AU, MX).
  • Blank: 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.

Availability: Current Rating Engine only.
currency varchar ISO 4217 Currency Code.
Availability: not populated for Third-Party Billed shipments.
estimate_fuel_percent number The estimated percentage of fuel surcharge applied to the shipment. (Deprecated: use estimated_fuel_percent instead. Will be dropped on September 1, 2026.)
Availability: Current Rating Engine only.
estimated_fuel_percent number The estimated percentage of fuel surcharge applied to the shipment.
Availability: Current Rating Engine only.
adjusted_fuel_percent number The final, adjusted percentage of fuel surcharge after invoicing by the carrier.
Populated only for Current Rating Engine packages where the carrier invoice changed the billed amount during reconciliation (reconciliation_status = 'Reconciled with Period Adjustment'). Blank when the carrier confirmed the estimate unchanged or reconciliation is still pending.
estimate_residential number An estimate of whether the address is residential, based on FedEx address validation. (Deprecated: use estimated_residential instead. Will be dropped on September 1, 2026.)
Availability: Current Rating Engine only.
estimated_residential number An estimate of whether the address is residential, based on FedEx address validation.
Availability: Current Rating Engine only.
adjusted_residential number Whether this was considered a residential address by the carrier.
Populated only for Current Rating Engine packages where the carrier invoice changed the billed amount during reconciliation (reconciliation_status = 'Reconciled with Period Adjustment'). Blank when the carrier confirmed the estimate unchanged or reconciliation is still pending.
estimated_net_amount number The estimated net amount charged for the package, including surcharges.
Availability: not populated for Third-Party Billed shipments.
package_adjustment_amount number The amount of any adjustments made to the original package cost.
Blank until the carrier invoice has been received and reconciled — see reconciliation_status.
Availability: not populated for Third-Party Billed shipments.
adjusted_net_amount number The final, adjusted net amount charged for the package after invoicing by the carrier.
Blank until the carrier invoice has been received and reconciled — see reconciliation_status.
Availability: not populated for Third-Party Billed shipments.
estimated_total_package_surcharges number The total amount of estimated surcharges applied to the package.
Availability: Current Rating Engine only.
adjusted_total_package_surcharges number The final, adjusted total amount of surcharges applied to the package after invoicing by the carrier.
Populated only for Current Rating Engine packages where the carrier invoice changed the billed amount during reconciliation (reconciliation_status = 'Reconciled with Period Adjustment'). Blank when the carrier confirmed the estimate unchanged or reconciliation is still pending.
estimated_residential_surcharge number The estimated surcharge for residential delivery.
Availability: Current Rating Engine only.
adjusted_residential_surcharge number The final, adjusted surcharge for residential delivery after invoicing by the carrier.
Populated only for Current Rating Engine packages where the carrier invoice changed the billed amount during reconciliation (reconciliation_status = 'Reconciled with Period Adjustment'). Blank when the carrier confirmed the estimate unchanged or reconciliation is still pending.
estimated_delivery_area_surcharge number The estimated surcharge for delivering to certain areas, such as remote or difficult-to-access locations.
Availability: Current Rating Engine only.
adjusted_delivery_area_surcharge number The final, adjusted delivery area surcharge after invoicing by the carrier.
Populated only for Current Rating Engine packages where the carrier invoice changed the billed amount during reconciliation (reconciliation_status = 'Reconciled with Period Adjustment'). Blank when the carrier confirmed the estimate unchanged or reconciliation is still pending.
estimated_fuel_surcharge number The estimated fuel surcharge for the shipment.
Availability: Current Rating Engine only.
adjusted_fuel_surcharge number The final, adjusted fuel surcharge after invoicing by the carrier.
Populated only for Current Rating Engine packages where the carrier invoice changed the billed amount during reconciliation (reconciliation_status = 'Reconciled with Period Adjustment'). Blank when the carrier confirmed the estimate unchanged or reconciliation is still pending.
estimated_peak_surcharge number The estimated surcharge applied during peak seasons or periods of high demand.
Availability: Current Rating Engine only.
adjusted_peak_surcharge number The final, adjusted peak surcharge after invoicing by the carrier.
Populated only for Current Rating Engine packages where the carrier invoice changed the billed amount during reconciliation (reconciliation_status = 'Reconciled with Period Adjustment'). Blank when the carrier confirmed the estimate unchanged or reconciliation is still pending.
estimated_additional_handling_surcharge number The estimated surcharge for additional handling requirements (e.g. oversized packages).
Availability: Current Rating Engine only.
adjusted_additional_handling_surcharge number The final, adjusted surcharge for additional handling requirements (e.g. oversized packages) after invoicing by the carrier.
Populated only for Current Rating Engine packages where the carrier invoice changed the billed amount during reconciliation (reconciliation_status = 'Reconciled with Period Adjustment'). Blank when the carrier confirmed the estimate unchanged or reconciliation is still pending.
estimated_other_surcharges number The total of any other estimated surcharges applied to the package.
Availability: Current Rating Engine only.
estimated_other_surcharge_types varchar A list of other types of estimated surcharges applied to the package.
Availability: Current Rating Engine only.
adjusted_other_surcharges number The final, adjusted total amount of other surcharges applied to the package after invoicing by the carrier.
Populated only for Current Rating Engine packages where the carrier invoice changed the billed amount during reconciliation (reconciliation_status = 'Reconciled with Period Adjustment'). Blank when the carrier confirmed the estimate unchanged or reconciliation is still pending.
adjusted_other_surcharge_types varchar A list of other types of surcharges applied to the package after invoicing by the carrier.
Populated only for Current Rating Engine packages where the carrier invoice changed the billed amount during reconciliation (reconciliation_status = 'Reconciled with Period Adjustment'). Blank when the carrier confirmed the estimate unchanged or reconciliation is still pending.
ordered_at_utc timestamp_ntz Timestamp imported from ecommerce platform of when the order was placed, UTC time.
submitted_at_utc timestamp_ntz Timestamp of when the order was Submitted for Fulfillment, UTC time.
truck_checked_out_at_utc timestamp_ntz Timestamp of when truck the package had been sorted to was checked out of the warehouse, UTC time.
Blank for shipments that don't go through a tracked truck check-out (e.g. Amazon FBA labels and similar bulk hand-over flows).
first_carrier_scan_at_utc timestamp_ntz Timestamp of the first scan of the package by the shipping carrier, UTC time.
Blank for shipments without carrier scan tracking (e.g. Amazon FBA labels and other non-tracked shipping methods).
delivered_at_utc timestamp_ntz Timestamp of the delivery scan of the package by the shipping carrier, UTC time.
Blank when the package has not yet been delivered, or for shipments without carrier delivery tracking (e.g. Amazon FBA labels).
time_in_transit_business_days number The number of business days (excluding holidays) between the timestamps for Truck Check out and Delivery.
Blank when either truck_checked_out_at_utc or delivered_at_utc is missing — e.g. packages not yet delivered, or shipments without tracked truck check-out / carrier delivery scans (such as Amazon FBA labels).
location_timezone varchar Timezone of the warehouse location. (Deprecated: use warehouse_timezone instead. Will be dropped on September 1, 2026.)
warehouse_timezone — Timezone of the warehouse location in IANA format (e.g. America/New_York).