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

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

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

## Columns

| Column | Type | Key |
|---|---|---|
| `id` | INTEGER |  |
| `project_code` | VARCHAR(50) | key |
| `marketplace` | VARCHAR(16) | key |
| `report_date` | DATE |  |
| `id_partner` | VARCHAR(50) |  |
| `partner_name` | VARCHAR(255) |  |
| `market_place` | VARCHAR(40) |  |
| `order_nr` | VARCHAR(80) |  |
| `market_place_country_code` | VARCHAR(8) |  |
| `destination_country_code` | VARCHAR(8) |  |
| `item_nr` | VARCHAR(80) | key |
| `sku` | VARCHAR(200) |  |
| `warehouse_code` | VARCHAR(40) |  |
| `order_placed_at` | TIMESTAMP WITH TIME ZONE |  |
| `min_expected_delivery_at` | TIMESTAMP WITH TIME ZONE |  |
| `max_expected_delivery_at` | TIMESTAMP WITH TIME ZONE |  |
| `item_status` | VARCHAR(40) |  |
| `shipment_nr` | VARCHAR(80) |  |
| `awb_nr` | VARCHAR(80) |  |
| `is_fulfilled_by_noon` | BOOLEAN |  |
| `delivered_at` | TIMESTAMP WITH TIME ZONE |  |
| `extra` | JSON |  |

## Query it

```json
{
  "name": "query_report_data",
  "arguments": {
    "store": "myNoon-AE",
    "tables": [
      "rpt_noon_orders"
    ],
    "columns": [
      "rpt_noon_orders.project_code",
      "rpt_noon_orders.marketplace",
      "rpt_noon_orders.item_nr"
    ],
    "order_by": [
      {
        "column": "rpt_noon_orders.report_date",
        "dir": "desc"
      }
    ],
    "limit": 100
  }
}
```