Package Level Detail

Table name (referenced in Insights SQL queries): 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.

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 withinn 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.
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.
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.
reconciliation_status	varchar	Reconciled(Shipping cost were adjusted before invoice close-out) Reconciled with Period Adjustment(Shipping cost adjusted after invocie close-out -extra charges billed as period adjustments) Not Reconciled(Carrier invoice not yet reconciled for this package)
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 inches.
estimated_height	number	The estimated height of the package in inches.
estimated_length	number	The estimated length of the package in inches.
estimated_weight	number	The estimated physical weight of the package in lbs.
estimated_billable_weight_type	varchar	The type of weight (e.g., dimensional or real) used to calculate the estimated billable weight for the shipment.
estimated_billable_weight	number	The estimated billable weight of the package used for pricing purposes.
estimated_billable_weight_unit	varchar	The unit of measurement used for the estimated billable weight (e.g., pounds, ounces).
adjusted_width	number	The final, adjusted width of the package after invoicing by the carrier in inches.
adjusted_height	number	The final, adjusted height of the package after invoicing by the carrier in inches.
adjusted_length	number	The final, adjusted length of the package after invoicing by the carrier in inches.
adjusted_weight	number	The final, adjusted physical weight of the package after invoicing by the carrier in pounds.
adjustment_billable_weight_type	varchar	The type of weight (e.g., dimensional or real) used to calculate the adjusted billable weight for the shipment.
adjusted_billable_weight	number	The adjusted billable weight used for pricing after any corrections.
adjusted_billable_weight_unit	varchar	The unit of measurement used for the adjusted billable weight (e.g., pounds, ounces).
dimensional_weight_factor	number	The divisor used to calculate dimensional weight (based on package size rather than actual weight) in the calculation lengthwidthheight/dim factor.
zone	varchar	The shipping zone used to determine shipping costs, typically based on the distance between the origin and destination.
currency	varchar	ISO 4217 Currency Code (USD / EUR / GBP)
estimate_fuel_percent	number	The estimated percentage of fuel surcharge applied to the shipment.
adjusted_fuel_percent	number	The final, adjusted percentage of fuel surcharge after verification.
estimate_residential	number	Whether we expect this to be considered a residential address; ShipMonk uses FedEx address validation to determine if an address is residential.
adjusted_residential	number	Whether this was considered a residential address by the carrier.
estimated_net_amount	number	The estimated net amount charged for the package, including surcharges.
package_adjustment_amount	number	The amount of any adjustments made to the original package cost.
adjusted_net_amount	number	The final net amount charged for the package after all adjustments.
estimated_total_package_surcharges	number	The total amount of estimated surcharges applied to the package.
adjusted_total_package_surcharges	number	The final total amount of surcharges applied to the package after verification.
estimated_residential_surcharge	number	The estimated surcharge for residential delivery.
adjusted_residential_surcharge	number	The actual surcharge for residential delivery charged to the package.
estimated_delivery_area_surcharge	number	The estimated surcharge for delivering to certain areas, such as remote or difficult-to-access locations.
adjusted_delivery_area_surcharge	number	The final delivery area surcharge after adjustments.
estimated_fuel_surcharge	number	The estimated fuel surcharge for the shipment.
adjusted_fuel_surcharge	number	The final fuel surcharge after adjustments.
estimated_peak_surcharge	number	The estimated surcharge applied during peak seasons or periods of high demand.
adjusted_peak_surcharge	number	The final peak surcharge applied after any adjustments.
estimated_additional_handling_surcharge	number	The estimated surcharge for additional handling requirements (e.g. oversized packages).
adjusted_additional_handling_surcharge	number	The final surcharge for additional handling requirements (e.g. oversized packages).
estimated_other_surcharges	number	The total of any other estimated surcharges applied to the package.
estimated_other_surcharge_types	varchar	A list of other types of estimated surcharges applied to the package.
adjusted_other_surcharges	number	The total amount of other surcharges applied after adjustments.
adjusted_other_surcharge_types	varchar	A list of other types of surcharges applied to the package after adjustments.
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.
first_carrier_scan_at_utc	timestamp_ntz	Timestamp of the first scan of the package by the shipping carrier, UTC time.
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) beteen the timestamps for Truck Check out and Delivery.
location_timezone	varchar	Timezone of the location associated with the order fulfillment, relevant for time-sensitive actions.