> For the complete documentation index, see [llms.txt](https://docs.intentwise.com/iac-source-data/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.intentwise.com/iac-source-data/data-models/amazon-source-data/seller-central/order-reports.md).

# Order Reports

## Order Reports

### Flat File Orders By Order Date Report

Table name: *sellercentral\_ordersbydate\_report*

Seller Central Console Report*:* [All Order Reports](https://sellercentral.amazon.com/order-reports-and-feeds/reports/ref=xx_orderrpt_dnav_xx) ([Help](https://sellercentral.amazon.com/help/hub/reference/G200547170?locale=en_US))

*For details on data availability and refresh schedule, please click*[ *here*](/iac-source-data/data-models/amazon-source-data/seller-central.md#data-availability-and-refresh-schedule)*.*\
\
**Note:** The *Purchase Date* column in this report is based on the **Pacific Standard Time (PST)** timezone.

<table><thead><tr><th width="243.33333333333326">Column Name</th><th width="127">Data type</th><th>Description (Refer help link above)</th></tr></thead><tbody><tr><td>account_id</td><td>Integer</td><td></td></tr><tr><td>account_name</td><td>String</td><td></td></tr><tr><td>seller_id</td><td>String</td><td></td></tr><tr><td>amazon_order_id</td><td>String</td><td></td></tr><tr><td>merchant_order_id</td><td>String</td><td></td></tr><tr><td>purchase_date</td><td>Date Time</td><td></td></tr><tr><td>last_updated_date</td><td>Date Time</td><td></td></tr><tr><td>order_status</td><td>String</td><td></td></tr><tr><td>fulfillment_channel</td><td>String</td><td></td></tr><tr><td>sales_channel</td><td>String</td><td></td></tr><tr><td>order_channel</td><td>String</td><td></td></tr><tr><td>url</td><td>String</td><td></td></tr><tr><td>ship_service_level</td><td>String</td><td></td></tr><tr><td>product_name</td><td>String</td><td></td></tr><tr><td>sku</td><td>String</td><td></td></tr><tr><td>asin</td><td>String</td><td></td></tr><tr><td>item_status</td><td>String</td><td></td></tr><tr><td>quantity</td><td>Integer</td><td></td></tr><tr><td>currency</td><td>String</td><td></td></tr><tr><td>item_price</td><td>Numeric</td><td></td></tr><tr><td>item_tax</td><td>Numeric</td><td></td></tr><tr><td>shipping_price</td><td>Numeric</td><td></td></tr><tr><td>shipping_tax</td><td>Numeric</td><td></td></tr><tr><td>gift_wrap_price</td><td>Numeric</td><td></td></tr><tr><td>gift_wrap_tax</td><td>Numeric</td><td></td></tr><tr><td>item_promotion_discount</td><td>Numeric</td><td></td></tr><tr><td>ship_promotion_discount</td><td>Numeric</td><td></td></tr><tr><td>ship_city</td><td>String</td><td></td></tr><tr><td>ship_state</td><td>String</td><td></td></tr><tr><td>ship_postal_code</td><td>String</td><td></td></tr><tr><td>ship_country</td><td>String</td><td></td></tr><tr><td>promotion_ids</td><td>String</td><td></td></tr><tr><td>purchase_order_number</td><td>String</td><td></td></tr><tr><td>price_designation</td><td>String</td><td></td></tr><tr><td>is_business_order</td><td>Boolean</td><td></td></tr><tr><td>buyer_company_name</td><td>String</td><td></td></tr><tr><td>is_replacement_order</td><td>Boolean</td><td></td></tr><tr><td>is_exchange_order</td><td>Boolean</td><td></td></tr><tr><td>original_order_id</td><td>String</td><td></td></tr><tr><td>download_date</td><td>Date</td><td></td></tr><tr><td>account_timezone</td><td>String</td><td></td></tr><tr><td>purchase_date_account_timezone</td><td>DateTime</td><td></td></tr><tr><td>last_updated_date_account_timezone</td><td>DateTime</td><td></td></tr></tbody></table>

### Flat File Orders By Last Update Report

Table name: sellercentral\_ordersbylastupdate\_report

Seller Central Console Repor&#x74;*: Updated Orders* ([Help](https://sellercentral.amazon.com/help/hub/reference/G200547170?locale=en_US))

*For details on data availability and refresh schedule, please click*[ *here*](/iac-source-data/data-models/amazon-source-data/seller-central.md#data-availability-and-refresh-schedule)*.*\
\
**Note:** The *Purchase Date* column in this report is based on the **Pacific Standard Time (PST)** timezone.

| Column Name                            | Data type | Description (Refer help link above) |
| -------------------------------------- | --------- | ----------------------------------- |
| account\_id                            | Integer   |                                     |
| account\_name                          | String    |                                     |
| currency\_code                         | String    |                                     |
| amazon\_order\_id                      | String    |                                     |
| merchant\_order\_id                    | String    |                                     |
| purchase\_date                         | Timestamp |                                     |
| last\_updated\_date                    | Timestamp |                                     |
| order\_status                          | String    |                                     |
| fulfillment\_channel                   | String    |                                     |
| sales\_channel                         | String    |                                     |
| order\_channel                         | String    |                                     |
| ship\_service\_level                   | String    |                                     |
| product\_name                          | String    |                                     |
| sku                                    | String    |                                     |
| asin                                   | String    |                                     |
| number\_of\_items                      | Integer   |                                     |
| item\_status                           | String    |                                     |
| quantity                               | Integer   |                                     |
| currency                               | String    |                                     |
| item\_price                            | Numeric   |                                     |
| item\_tax                              | Numeric   |                                     |
| shipping\_price                        | Numeric   |                                     |
| shipping\_tax                          | Numeric   |                                     |
| gift\_wrap\_price                      | Numeric   |                                     |
| gift\_wrap\_tax                        | Numeric   |                                     |
| item\_promotion\_discount              | Numeric   |                                     |
| ship\_promotion\_discount              | Numeric   |                                     |
| ship\_city                             | String    |                                     |
| ship\_state                            | String    |                                     |
| ship\_postal\_code                     | String    |                                     |
| ship\_country                          | String    |                                     |
| promotion\_ids                         | String    |                                     |
| is\_business\_order                    | Boolean   |                                     |
| purchase\_order\_number                | String    |                                     |
| price\_designation                     | String    |                                     |
| buyer\_company\_name                   | String    |                                     |
| license\_state                         | String    |                                     |
| license\_expiration\_date              | Timestamp |                                     |
| download\_date                         | Date      |                                     |
| account\_timezone                      | String    |                                     |
| purchase\_date\_account\_timezone      | Timestamp |                                     |
| last\_updated\_date\_account\_timezone | Timestamp |                                     |

##