Claim¶

Table name (referenced in Insights SQL queries): marts_mdc__claim

View a detailed breakdown of all your claims over a given period. One row equals one claim.

Columns¶

Column	Type	Description
`claim_id`	`number`	Unique identifier for the claim within the system.
`account_id`	`number`	Identifier for the account associated with the claim.
`warehouse_name`	`varchar`	Represents the name of the warehouse from which the original order was fulfilled.
`warehouse_id`	`number`	Identifier for the warehouse handling the fulfillment of the order.
`claim_number`	`varchar`	Denotes the unique identifier assigned to a claim filed.
`claim_order_id`	`number`	Unique identifier for the original order associated with the claim.
`claim_order_number`	`varchar`	This field provides a reference to the original order related to the claim.
`reship_order_id`	`number`	Unique identifier for the reship order if one was created.
`reship_order_number`	`varchar`	This field provides a reference to the new order created for reshipping items as part of the resolution process for the claim.
`claim_order_list_status`	`varchar`	Indicates the status of the original order associated with a claim.
`claim_type`	`varchar`	Specifies the type of the claim filed by a customer. It can have two possible values 'fulfillment' and 'shipping'.
`claim_source`	`varchar`	Identifies who filed the claim, distinguishing between the merchant and the end customer, especially in cases where the orders had MonkProtect protection enabled.
`claim_status`	`varchar`	Current status of the claim, such as shipmonk_review, awaiting_carrier_response,customer_action_required, etc.
`reship_type`	`varchar`	This field provides information about whether a reshipment has been requested, already reshipped, rejected, etc as part of the resolution for the claim.
`claim_customer_note`	`varchar`	This field serves as a communication channel for customers to convey relevant information to the claims processing team, helping to provide context and insights that may assist in the investigation and resolution of the claim.
`claim_created_at_utc`	`timestamp_ntz`	UTC timestamp indicating when the claim was created.
`claim_resolved_at_utc`	`timestamp_ntz`	UTC timestamp indicating when the claim was resolved.
`reject_reason`	`varchar`	This field provides information about the rationale or justification for denying the claim, such as 'neligible_to_claim', 'insufficient_information_provided', 'outside_of_claim_window', etc.
`claim_order_shipped_at_utc`	`timestamp_ntz`	Represents the timestamp indicating when the original order associated with a claim was shipped from the warehouse.
`claim_order_tracking_number`	`varchar`	Contains the tracking number associated with the original order that is the subject of the claim.
`store_name`	`varchar`	Name of the store the order was created within.
`shipping_method_name`	`varchar`	Provides information about the chosen shipping option for the original order.
`is_monk_protected`	`boolean`	Indicates whether an original order was protected by ShipMonk's Delivery Protection program.
`credited_amount`	`number`	Represents the amount credited or refunded to the customer as part of the resolution for the claim.
`claim_category`	`varchar`	This field includes various categories such as 'lost_in_transit', 'order_shorted', 'order_overage', 'delivered_not_received', etc. separated by commas.
`missing_quantity`	`number`	Indicates the total number of products reported as missing or not received by the customer.
`damaged_quantity`	`number`	Indicates the total number of products reported as damaged by the customer.
`missing_skus`	`varchar`	Contains the SKUs of the products reported as missing or not received separated by commas.
`damaged_skus`	`varchar`	Contains the SKUs of the products reported as damaged separated by commas.
`location_timezone`	`varchar`	Timezone of the location associated with the claim, relevant for time-sensitive actions.