# rpt_get_fba_fulfillment_removal_order_detail_data (https://sellersheetai.com/docs/data/rpt_get_fba_fulfillment_removal_order_detail_data)

> Seller reports (SP-API) · GET_FBA_FULFILLMENT_REMOVAL_ORDER_DETAIL_DATA · Daily at 01:03 marketplace local time

- Family: seller
- Report type: `GET_FBA_FULFILLMENT_REMOVAL_ORDER_DETAIL_DATA`
- How fresh: Daily — Daily at 01:03 marketplace local time
- Need it right now: synced only
- Grain: region · sync: incremental

## Columns

| Column | Type | Key |
|---|---|---|
| `id` | INTEGER |  |
| `store_id` | VARCHAR(36) | key |
| `report_date` | DATE |  |
| `request_date` | TIMESTAMP WITH TIME ZONE |  |
| `order_id` | VARCHAR(50) | key |
| `order_source` | TEXT |  |
| `order_type` | VARCHAR(50) |  |
| `service_speed` | VARCHAR(50) |  |
| `order_status` | VARCHAR(50) |  |
| `last_updated_date` | TIMESTAMP WITH TIME ZONE |  |
| `sku` | VARCHAR(200) | key |
| `fnsku` | VARCHAR(200) |  |
| `disposition` | VARCHAR(50) | key |
| `requested_quantity` | INTEGER |  |
| `cancelled_quantity` | INTEGER |  |
| `disposed_quantity` | INTEGER |  |
| `shipped_quantity` | INTEGER |  |
| `in_process_quantity` | INTEGER |  |
| `removal_fee` | NUMERIC(12, 2) |  |
| `currency` | VARCHAR(10) |  |
| `extra` | JSON |  |

## Query it

```json
{
  "name": "query_report_data",
  "arguments": {
    "store": "myStore-US",
    "tables": [
      "rpt_get_fba_fulfillment_removal_order_detail_data"
    ],
    "columns": [
      "rpt_get_fba_fulfillment_removal_order_detail_data.order_id",
      "rpt_get_fba_fulfillment_removal_order_detail_data.sku",
      "rpt_get_fba_fulfillment_removal_order_detail_data.disposition"
    ],
    "order_by": [
      {
        "column": "rpt_get_fba_fulfillment_removal_order_detail_data.request_date",
        "dir": "desc"
      }
    ],
    "limit": 100
  }
}
```