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

> Seller reports (SP-API) · GET_FBA_INVENTORY_PLANNING_DATA · Every 6 hours, at minute 5 (marketplace local time)

- Family: seller
- Report type: `GET_FBA_INVENTORY_PLANNING_DATA`
- How fresh: Several times a day — Every 6 hours, at minute 5 (marketplace local time)
- Need it right now: synced only
- Grain: per_mkt · sync: snapshot

## Columns

| Column | Type | Key |
|---|---|---|
| `id` | INTEGER |  |
| `store_id` | VARCHAR(36) | key |
| `snapshot_date` | DATE | key |
| `country_code` | VARCHAR(16) | key |
| `country` | VARCHAR(20) |  |
| `sku` | VARCHAR(200) | key |
| `fnsku` | VARCHAR(200) | key |
| `asin` | VARCHAR(20) |  |
| `product_name` | TEXT |  |
| `condition` | VARCHAR(50) | key |
| `supplier` | VARCHAR(200) |  |
| `currency_code` | VARCHAR(10) |  |
| `price` | NUMERIC(12, 2) |  |
| `sales_last_30_days` | NUMERIC(12, 2) |  |
| `total_units` | INTEGER |  |
| `inbound` | INTEGER |  |
| `available` | INTEGER |  |
| `fc_transfer` | INTEGER |  |
| `fc_processing` | INTEGER |  |
| `customer_order` | INTEGER |  |
| `unfulfillable` | INTEGER |  |
| `working` | INTEGER |  |
| `shipped` | INTEGER |  |
| `receiving` | INTEGER |  |
| `fulfilled_by` | VARCHAR(50) |  |
| `total_days_of_supply_including_units_from_open_shipments` | NUMERIC(12, 2) |  |
| `days_of_supply_at_amazon_fulfillment_network` | NUMERIC(12, 2) |  |
| `alert` | VARCHAR(200) |  |
| `weeks_of_cover` | NUMERIC(8, 2) |  |
| `units_sold_last_30_days` | INTEGER |  |
| `recommended_replenishment_qty` | INTEGER |  |
| `unit_storage_size` | VARCHAR(50) |  |
| `pending_removal_quantity` | INTEGER |  |
| `your_price` | NUMERIC(12, 2) |  |
| `sales_price` | NUMERIC(12, 2) |  |
| `lowest_price_new_plus_shipping` | NUMERIC(12, 2) |  |
| `lowest_price_used` | NUMERIC(12, 2) |  |
| `featuredoffer_price` | NUMERIC(12, 2) |  |
| `recommended_action` | VARCHAR(100) |  |
| `healthy_inventory_level` | INTEGER |  |
| `recommended_sales_price` | NUMERIC(12, 2) |  |
| `recommended_sale_duration_days` | INTEGER |  |
| `recommended_removal_quantity` | INTEGER |  |
| `estimated_cost_savings_of_recommended_actions` | NUMERIC(12, 2) |  |
| `sell_through` | NUMERIC(10, 4) |  |
| `item_volume` | NUMERIC(12, 4) |  |
| `volume_unit_measurement` | VARCHAR(20) |  |
| `storage_type` | VARCHAR(50) |  |
| `storage_volume` | NUMERIC(12, 4) |  |
| `marketplace` | VARCHAR(50) |  |
| `product_group` | VARCHAR(100) |  |
| `sales_rank` | INTEGER |  |
| `days_of_supply` | NUMERIC(10, 2) |  |
| `estimated_excess_quantity` | INTEGER |  |
| `weeks_of_cover_t30` | NUMERIC(10, 2) |  |
| `weeks_of_cover_t90` | NUMERIC(10, 2) |  |
| `estimated_storage_cost_next_month` | NUMERIC(12, 2) |  |
| `is_seasonal_in_next_3_months` | VARCHAR(20) |  |
| `units_shipped_t7` | INTEGER |  |
| `units_shipped_t30` | INTEGER |  |
| `units_shipped_t60` | INTEGER |  |
| `units_shipped_t90` | INTEGER |  |
| `sales_shipped_last_7_days` | NUMERIC(12, 2) |  |
| `sales_shipped_last_30_days` | NUMERIC(12, 2) |  |
| `sales_shipped_last_60_days` | NUMERIC(12, 2) |  |
| `sales_shipped_last_90_days` | NUMERIC(12, 2) |  |
| `inbound_quantity` | INTEGER |  |
| `inbound_working` | INTEGER |  |
| `inbound_shipped` | INTEGER |  |
| `inbound_received` | INTEGER |  |
| `unfulfillable_quantity` | INTEGER |  |
| `total_reserved_quantity` | INTEGER |  |
| `reserved_fc_transfer` | INTEGER |  |
| `reserved_fc_processing` | INTEGER |  |
| `reserved_customer_order` | INTEGER |  |
| `inv_age_0_to_90_days` | INTEGER |  |
| `inv_age_91_to_180_days` | INTEGER |  |
| `inv_age_181_to_270_days` | INTEGER |  |
| `inv_age_271_to_365_days` | INTEGER |  |
| `inv_age_366_to_455_days` | INTEGER |  |
| `inv_age_456_plus_days` | INTEGER |  |
| `inv_age_0_to_30_days` | INTEGER |  |
| `inv_age_31_to_60_days` | INTEGER |  |
| `inv_age_61_to_90_days` | INTEGER |  |
| `inv_age_181_to_330_days` | INTEGER |  |
| `inv_age_331_to_365_days` | INTEGER |  |
| `inventory_age_snapshot_date` | DATE |  |
| `historical_days_of_supply` | NUMERIC(10, 2) |  |
| `last_updated_for_historical_days_of_supply` | DATE |  |
| `short_term_historical_days_of_supply` | NUMERIC(10, 2) |  |
| `long_term_historical_days_of_supply` | NUMERIC(10, 2) |  |
| `recommended_ship_in_quantity` | INTEGER |  |
| `recommended_ship_in_date` | DATE |  |
| `inventory_supply_at_fba` | INTEGER |  |
| `recommended_order_quantity` | INTEGER |  |
| `recommended_order_date` | DATE |  |
| `weeks_of_cover_estimated_excess_quantity` | INTEGER |  |
| `season_name` | VARCHAR(50) |  |
| `qty_to_be_charged_ltsf_6_mo` | INTEGER |  |
| `projected_ltsf_6_mo` | NUMERIC(12, 2) |  |
| `qty_to_be_charged_ltsf_12_mo` | INTEGER |  |
| `estimated_ltsf_next_charge` | NUMERIC(12, 2) |  |
| `qty_to_be_charged_ais_241_270_days` | INTEGER |  |
| `estimated_ais_241_270_days` | NUMERIC(12, 2) |  |
| `qty_to_be_charged_ais_271_300_days` | INTEGER |  |
| `estimated_ais_271_300_days` | NUMERIC(12, 2) |  |
| `qty_to_be_charged_ais_301_330_days` | INTEGER |  |
| `estimated_ais_301_330_days` | NUMERIC(12, 2) |  |
| `qty_to_be_charged_ais_331_365_days` | INTEGER |  |
| `estimated_ais_331_365_days` | NUMERIC(12, 2) |  |
| `qty_to_be_charged_ais_366_455_days` | INTEGER |  |
| `estimated_ais_366_455_days` | NUMERIC(12, 2) |  |
| `qty_to_be_charged_ais_456_plus_days` | INTEGER |  |
| `estimated_ais_456_plus_days` | NUMERIC(12, 2) |  |
| `restock_plus_seller_eligible` | VARCHAR(20) |  |
| `restock_plus_seller_opted` | VARCHAR(20) |  |
| `restock_plus_suggested_weeks_of_cover` | NUMERIC(8, 2) |  |
| `restock_plus_storage_incentives` | NUMERIC(12, 2) |  |
| `restock_plus_total_incentives` | NUMERIC(12, 2) |  |
| `inv_age_365_plus_days` | INTEGER |  |
| `inv_age_91_to_150_days` | INTEGER |  |
| `inv_age_151_to_180_days` | INTEGER |  |
| `qty_to_be_charged_ais_181_210_days` | INTEGER |  |
| `estimated_ais_181_210_days` | NUMERIC(12, 2) |  |
| `qty_to_be_charged_ais_211_240_days` | INTEGER |  |
| `estimated_ais_211_240_days` | NUMERIC(12, 2) |  |
| `qty_to_be_charged_ais_365_plus_days` | INTEGER |  |
| `estimated_ais_365_plus_days` | NUMERIC(12, 2) |  |
| `projected_ltsf_5_mo` | NUMERIC(12, 2) |  |
| `qty_to_be_charged_ltsf_5_mo` | INTEGER |  |
| `low_inventory_level_fee_exempted` | VARCHAR(20) |  |
| `low_inventory_level_fee_applied` | VARCHAR(20) |  |
| `reserved_staging` | INTEGER |  |
| `fba_inventory_level_health_status` | VARCHAR(50) |  |
| `fba_minimum_inventory_level` | INTEGER |  |
| `no_sale_last_6_months` | VARCHAR(20) |  |
| `fulfillment_service_and_programs` | VARCHAR(50) |  |
| `extra` | JSON |  |

## Query it

```json
{
  "name": "query_report_data",
  "arguments": {
    "store": "myStore-US",
    "tables": [
      "rpt_get_fba_inventory_planning_data"
    ],
    "columns": [
      "rpt_get_fba_inventory_planning_data.snapshot_date",
      "rpt_get_fba_inventory_planning_data.country_code",
      "rpt_get_fba_inventory_planning_data.sku",
      "rpt_get_fba_inventory_planning_data.fnsku"
    ],
    "order_by": [
      {
        "column": "rpt_get_fba_inventory_planning_data.snapshot_date",
        "dir": "desc"
      }
    ],
    "limit": 100
  }
}
```