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

> Seller reports (SP-API) · GET_FLAT_FILE_ALL_ORDERS_DATA_BY_LAST_UPDATE_GENERAL|GET_FLAT_FILE_ALL_ORDERS_DATA_BY_ORDER_DATE_GENERAL · Every hour, on the hour

- Family: seller
- Report type: `GET_FLAT_FILE_ALL_ORDERS_DATA_BY_LAST_UPDATE_GENERAL|GET_FLAT_FILE_ALL_ORDERS_DATA_BY_ORDER_DATE_GENERAL`
- How fresh: Hourly — Every hour, on the hour
- Need it right now: [`orders_searchOrders`](https://sellersheetai.com/docs/mcp-api/tools/orders_searchOrders)
- Grain: region · sync: incremental

## Columns

| Column | Type | Key |
|---|---|---|
| `id` | INTEGER |  |
| `store_id` | VARCHAR(36) | key |
| `report_date` | DATE |  |
| `amazon_order_id` | VARCHAR(50) | key |
| `merchant_order_id` | VARCHAR(50) |  |
| `purchase_date` | TIMESTAMP WITH TIME ZONE |  |
| `last_updated_date` | TIMESTAMP WITH TIME ZONE |  |
| `order_status` | VARCHAR(50) |  |
| `fulfillment_channel` | VARCHAR(20) |  |
| `sales_channel` | VARCHAR(100) |  |
| `order_channel` | VARCHAR(100) |  |
| `ship_service_level` | VARCHAR(50) |  |
| `product_name` | TEXT |  |
| `sku` | VARCHAR(200) | key |
| `asin` | VARCHAR(20) |  |
| `item_status` | VARCHAR(50) |  |
| `ship_city` | VARCHAR(100) |  |
| `ship_state` | VARCHAR(100) |  |
| `ship_postal_code` | VARCHAR(20) |  |
| `ship_country` | VARCHAR(10) |  |
| `quantity` | INTEGER |  |
| `currency` | VARCHAR(10) |  |
| `item_price` | NUMERIC(12, 2) |  |
| `item_tax` | NUMERIC(12, 2) |  |
| `shipping_price` | NUMERIC(12, 2) |  |
| `shipping_tax` | NUMERIC(12, 2) |  |
| `gift_wrap_price` | NUMERIC(12, 2) |  |
| `gift_wrap_tax` | NUMERIC(12, 2) |  |
| `item_promotion_discount` | NUMERIC(12, 2) |  |
| `ship_promotion_discount` | NUMERIC(12, 2) |  |
| `promotion_ids` | TEXT |  |
| `is_business_order` | VARCHAR(10) |  |
| `number_of_items` | INTEGER |  |
| `price_designation` | VARCHAR(50) |  |
| `buyer_company_name` | VARCHAR(200) |  |
| `purchase_order_number` | VARCHAR(100) |  |
| `buyer_tax_registration_country` | VARCHAR(10) |  |
| `buyer_tax_registration_type` | VARCHAR(50) |  |
| `tax_collection_model` | VARCHAR(50) |  |
| `tax_collection_responsible_party` | VARCHAR(50) |  |
| `is_exchange_order` | VARCHAR(10) |  |
| `is_replacement_order` | VARCHAR(10) |  |
| `is_transparency` | VARCHAR(10) |  |
| `payment_method_details` | TEXT |  |
| `item_amazon_funded_promotion` | VARCHAR(10) |  |
| `amazon_programs` | TEXT |  |
| `fulfilled_by` | VARCHAR(50) |  |
| `is_iba` | VARCHAR(10) |  |
| `is_buyer_requested_cancellation` | VARCHAR(10) |  |
| `buyer_requested_cancel_reason` | VARCHAR(255) |  |
| `signature_confirmation_recommended` | VARCHAR(10) |  |
| `order_item_id` | VARCHAR(50) | key |
| `is_prime` | VARCHAR(10) |  |
| `is_amazon_invoiced` | VARCHAR(10) |  |
| `vat_exclusive_item_price` | NUMERIC(12, 2) |  |
| `vat_exclusive_shipping_price` | NUMERIC(12, 2) |  |
| `vat_exclusive_giftwrap_price` | NUMERIC(12, 2) |  |
| `item_total` | NUMERIC(12, 2) |  |
| `amount_paid_by_buyer` | NUMERIC(12, 2) |  |
| `original_order_id` | VARCHAR(50) |  |
| `ioss_number` | VARCHAR(50) |  |
| `address_type` | VARCHAR(50) |  |
| `is_heavy_or_bulky` | VARCHAR(10) |  |
| `license_expiration_date` | DATE |  |
| `license_state` | VARCHAR(50) |  |
| `order_kind` | VARCHAR(10) |  |
| `marketplace` | VARCHAR(10) |  |
| `extra` | JSON |  |

## Query it

```json
{
  "name": "query_report_data",
  "arguments": {
    "store": "myStore-US",
    "tables": [
      "rpt_orders"
    ],
    "columns": [
      "rpt_orders.amazon_order_id",
      "rpt_orders.sku",
      "rpt_orders.order_item_id"
    ],
    "order_by": [
      {
        "column": "rpt_orders.purchase_date",
        "dir": "desc"
      }
    ],
    "limit": 100
  }
}
```