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

> noon reports · NOON_FBN_AGING · Twice a day, at 04:00 and 16:00 UTC

- Family: noon
- Report type: `NOON_FBN_AGING`
- How fresh: Several times a day — Twice a day, at 04:00 and 16:00 UTC
- Need it right now: synced only
- Grain: per_mkt · sync: snapshot

## Columns

| Column | Type | Key |
|---|---|---|
| `id` | INTEGER |  |
| `project_code` | VARCHAR(50) | key |
| `marketplace` | VARCHAR(16) |  |
| `report_date` | DATE |  |
| `snapshot_date` | DATE | key |
| `country_code` | VARCHAR(8) | key |
| `sku` | VARCHAR(200) | key |
| `partner_sku` | VARCHAR(200) |  |
| `partner_barcode` | VARCHAR(80) | key |
| `inventory_condition` | VARCHAR(40) | key |
| `qc_fail_item_identifier` | VARCHAR(80) | key |
| `first_received_date` | DATE |  |
| `last_movement_date` | DATE |  |
| `gross_quantity` | INTEGER |  |
| `quantity_0_30d` | INTEGER |  |
| `quantity_31_60d` | INTEGER |  |
| `quantity_61_90d` | INTEGER |  |
| `quantity_91_180d` | INTEGER |  |
| `quantity_181_365d` | INTEGER |  |
| `quantity_366d` | INTEGER |  |
| `extra` | JSON |  |

## Query it

```json
{
  "name": "query_report_data",
  "arguments": {
    "store": "myNoon-AE",
    "tables": [
      "rpt_noon_fbn_aging"
    ],
    "columns": [
      "rpt_noon_fbn_aging.project_code",
      "rpt_noon_fbn_aging.snapshot_date",
      "rpt_noon_fbn_aging.country_code",
      "rpt_noon_fbn_aging.sku"
    ],
    "order_by": [
      {
        "column": "rpt_noon_fbn_aging.snapshot_date",
        "dir": "desc"
      }
    ],
    "limit": 100
  }
}
```