Shipping Adjustments¶

Table name:

referenced in Insights SQL queries: "SHIPPING_ADJUSTMENTS"
in data catalog export: marts_mdc_shipping_adjustments

Table providing detailed information on shipping adjustments, including order, account, invoice, and fulfillment data, along with calculated charges, ranks, and audit categories.

Columns¶

Column	Type	Description
`warehouse_timezone`	`varchar`	Timezone of the warehouse location in IANA format (e.g. America/New_York). Note: `invoice_date` is expressed in this timezone.
`invoice_number`	`varchar`	Unique identifier of the invoice related to the adjustment.
`invoice_date`	`date`	Invoice issue date in the timezone specified in the timezone column
`invoice_date_utc`	`date`	Invoice issue date in UTC
`account_id`	`number`	Identifier of the account linked to the adjustment.
`account_name`	`varchar`	Name of the account associated with the adjustment.
`order_id`	`number`	Identifier of the order associated with the adjustment.
`order_number`	`varchar`	Order number associated with the adjustment.
`shipped_at`	`timestamp_ntz`	Date and time when the the order was finished and is waiting for carrier pickup. In the timezone specified in the timezone column.
`shipped_at_utc`	`timestamp_ntz`	Date and time in UTC when the the order was finished and is waiting for carrier pickup.
`warehouse_name`	`varchar`	Name of the warehouse associated with the adjustment.
`tracking_number`	`varchar`	Tracking number of the shipment.
`shipping_method_name`	`varchar`	Name of the shipping method used.
`carrier_service_name`	`varchar`	Name of the carrier service used for shipping.
`carrier_name`	`varchar`	Name of the carrier responsible for the shipment.
`number_of_packages`	`number`	Total number of packages in the fulfillment.
`charge_currency`	`varchar`	Currency of all amounts in other fields.
`adjustment_amount`	`number`	Adjustment amount applied to the original charge.
`type`	`varchar`	Type of adjustment, categorized as charge or refund.
`original_charge`	`number`	Original shipping cost prior to any adjustments.
`adjusted_charge`	`number`	Final shipping charge after adjustments.
`estimated_zone`	`varchar`	Estimated shipping zone for the package.
`adjusted_zone`	`varchar`	Adjusted shipping zone after recalculations.
`estimated_billable_weight_unit`	`varchar`	Weight unit of the estimated billable weight.
`estimated_billable_weight`	`number`	Estimated billable weight for the shipment.
`adjusted_billable_weight_unit`	`varchar`	Weight unit of the adjusted billable weight.
`adjusted_billable_weight`	`number`	Adjusted billable weight after recalculations.
`estimated_dimensions_unit`	`varchar`	Length unit of the estimated dimensions.
`estimated_dimensions`	`varchar`	Estimated dimensions of the package. Blank for multipacks.
`adjusted_dimensions_unit`	`varchar`	Length unit of the adjusted dimensions.
`adjusted_dimensions`	`varchar`	Adjusted dimensions of the package after recalculations. Blank for multipacks.
`surcharge_changes`	`varchar`	Changes in surcharges applied to the shipment.
`category`	`varchar`	Category of the adjustment applied.