# 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*](https://docs.intentwise.com/iac-source-data/data-models/amazon-source-data/seller-central/..#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>report</td><td>Integer</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></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*](https://docs.intentwise.com/iac-source-data/data-models/amazon-source-data/seller-central/..#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      |                                     |

##