# Fulfillment By Amazon

## **FBA Amazon Fulfilled Shipments Report**

Table name: *sellercentral\_fbaamazonfulfilledshipments\_report*

Seller Central Console Report: [Amazon Fulfilled Shipments](https://sellercentral.amazon.com/reportcentral/AFNShipmentReport/1) ([Help](https://sellercentral.amazon.com/help/hub/reference/200453120))

*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="281.3333333333333">Column Name</th><th>Data type</th><th width="173.66666666666669">Description</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>shipment_id</td><td>String</td><td></td></tr><tr><td>shipment_item_id</td><td>String</td><td></td></tr><tr><td>amazon_order_item_id</td><td>String</td><td></td></tr><tr><td>merchant_order_id</td><td>String</td><td></td></tr><tr><td>merchant_order_item_id</td><td>String</td><td></td></tr><tr><td>purchase_date</td><td>Date Time</td><td></td></tr><tr><td>payments_date</td><td>Date Time</td><td></td></tr><tr><td>shipment_date</td><td>Date Time</td><td></td></tr><tr><td>reporting_date</td><td>Date Time</td><td></td></tr><tr><td>buyer_email</td><td>String</td><td></td></tr><tr><td>buyer_name</td><td>String</td><td></td></tr><tr><td>buyer_phone_number</td><td>String</td><td></td></tr><tr><td>sku</td><td>String</td><td></td></tr><tr><td>product_name</td><td>String</td><td></td></tr><tr><td>quantity_shipped</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>ship_service_level</td><td>String</td><td></td></tr><tr><td>recipient_name</td><td>String</td><td></td></tr><tr><td>ship_address_1</td><td>String</td><td></td></tr><tr><td>ship_address_2</td><td>String</td><td></td></tr><tr><td>ship_address_3</td><td>String</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>ship_phone_number</td><td>String</td><td></td></tr><tr><td>bill_address_1</td><td>String</td><td></td></tr><tr><td>bill_address_2</td><td>String</td><td></td></tr><tr><td>bill_address_3</td><td>String</td><td></td></tr><tr><td>bill_city</td><td>String</td><td></td></tr><tr><td>bill_state</td><td>String</td><td></td></tr><tr><td>bill_postal_code</td><td>String</td><td></td></tr><tr><td>bill_country</td><td>String</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>carrier</td><td>String</td><td></td></tr><tr><td>tracking_number</td><td>String</td><td></td></tr><tr><td>estimated_arrival_date</td><td>Date Time</td><td></td></tr><tr><td>fulfillment_center_id</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></tbody></table>

## **FBA Reserved Inventory Report**

Table name: *sellercentral\_fbareservedinventory\_report*

Seller Central Console Report: [Reserved Inventory](https://sellercentral.amazon.com/reportcentral/ReserveBreakdown/1) ([Help](https://sellercentral.amazon.com/help/hub/reference/201723860))

*For details on data availability and refresh schedule, please click* [*here*](#data-availability-and-refresh-schedule)*.*

<table><thead><tr><th width="251">Column Name</th><th width="129.33333333333331">Data type</th><th>Description</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>Integer</td><td></td></tr><tr><td>sku</td><td>String</td><td></td></tr><tr><td>fnsku</td><td>String</td><td></td></tr><tr><td>asin</td><td>String</td><td></td></tr><tr><td>product_name</td><td>String</td><td></td></tr><tr><td>reserved_qty</td><td>Numeric</td><td></td></tr><tr><td>reserved_customerorders</td><td>Numeric</td><td></td></tr><tr><td>reserved_fc_transfers</td><td>Numeric</td><td></td></tr><tr><td>reserved_fc_processing</td><td>Numeric</td><td></td></tr><tr><td>report_date</td><td>Date</td><td></td></tr></tbody></table>

## **FBA Stranded Inventory Report**

Table name: *sellercentral\_fbastrandedinventory\_report*

Seller Central Console Report: [Stranded Inventory](https://sellercentral.amazon.com/reportcentral/STRANDED_INVENTORY_UI/1) ([Help](https://sellercentral.amazon.com/help/hub/reference/201835130))

*For details on data availability and refresh schedule, please click* [*here*](#data-availability-and-refresh-schedule)*.*

<table><thead><tr><th width="149">Column Name</th><th width="100">Data type</th><th width="87">Description (Refer the 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>Integer</td><td></td></tr><tr><td>primary_action</td><td>String</td><td></td></tr><tr><td>date_stranded</td><td>Date</td><td></td></tr><tr><td>status_primary</td><td>String</td><td></td></tr><tr><td>status_secondary</td><td>String</td><td></td></tr><tr><td>error_message</td><td>String</td><td></td></tr><tr><td>stranded_reason</td><td>String</td><td></td></tr><tr><td>asin</td><td>String</td><td></td></tr><tr><td>sku</td><td>String</td><td></td></tr><tr><td>fnsku</td><td>String</td><td></td></tr><tr><td>product_name</td><td>String</td><td></td></tr><tr><td>condition</td><td>String</td><td></td></tr><tr><td>fulfilled_by</td><td>String</td><td></td></tr><tr><td>fulfillable_qty</td><td>Integer</td><td></td></tr><tr><td>your_price</td><td>Numeric</td><td></td></tr><tr><td>unfulfillable_qty</td><td>Integer</td><td></td></tr><tr><td>reserved_quantity</td><td>Integer</td><td></td></tr><tr><td>inbound_shipped_qty</td><td>Integer</td><td></td></tr><tr><td>report_date</td><td>Date</td><td></td></tr></tbody></table>

## **Restock Inventory Report**

Table name: *sellercentral\_restockinventory\_report*

Seller Central Console Report: [Restock Inventory](https://sellercentral.amazon.com/reportcentral/RestockReport/1) ([Help](https://sellercentral.amazon.com/help/hub/reference/202105670))

*For details on data availability and refresh schedule, please click* [*here*](#data-availability-and-refresh-schedule)*.*

| Column Name                                             | Data type | Description      |
| ------------------------------------------------------- | --------- | ---------------- |
| account\_id                                             | Integer   |                  |
| account\_name                                           | String    |                  |
| seller\_id                                              | Integer   |                  |
| country                                                 | String    |                  |
| product\_name                                           | String    |                  |
| fnsku                                                   | String    |                  |
| merchant\_sku                                           | String    |                  |
| asin                                                    | String    |                  |
| condition                                               | String    |                  |
| supplier                                                | String    |                  |
| supplier\_part\_no                                      | String    |                  |
| currency\_code                                          | String    |                  |
| price                                                   | Numeric   |                  |
| sales\_last\_30\_days                                   | Numeric   |                  |
| units\_sold\_last\_30\_days                             | String    |                  |
| total\_units                                            | Integer   |                  |
| inbound                                                 | Integer   |                  |
| available                                               | Integer   |                  |
| fc\_transfer                                            | Integer   |                  |
| fc\_processing                                          | Integer   |                  |
| customer\_order                                         | Integer   |                  |
| unfulfillable                                           | Integer   |                  |
| fulfilled\_by                                           | String    |                  |
| days\_of\_supply                                        | String    |                  |
| alert                                                   | String    |                  |
| recommended\_replenishment\_qty                         | Integer   |                  |
| recommended\_ship\_Date                                 | Date Time |                  |
| inventory\_level\_thresholds\_published\_current\_month | String    |                  |
| current\_month\_very\_low\_inventory\_threshold         | Integer   |                  |
| current\_month\_minimum\_inventory\_threshold           | Integer   |                  |
| current\_month\_maximum\_inventory\_threshold           | Integer   |                  |
| current\_month\_very\_high\_inventory\_threshold        | Integer   |                  |
| inventory\_level\_thresholds\_published\_next\_month    | String    |                  |
| next\_month\_very\_low\_inventory\_threshold            | Integer   |                  |
| next\_month\_minimum\_inventory\_threshold              | Integer   |                  |
| next\_month\_maximum\_inventory\_threshold              | Integer   |                  |
| next\_month\_very\_high\_inventory\_threshold           | Integer   |                  |
| utilization                                             | String    |                  |
| maximum\_shipment\_quantity                             | Integer   |                  |
| report\_Date                                            | Date      |                  |
| download\_date                                          | Date      | Date of download |
| working                                                 | Integer   |                  |
| shipped                                                 | Integer   |                  |
| receiving                                               | Integer   |                  |
| total\_days\_of\_supply                                 | String    |                  |
| days\_of\_supply\_at\_amazon                            | String    |                  |
| unit\_storage\_size                                     | String    |                  |

## FBA FEE Preview **Report**

Table name: sellercentral\_fbafeepreview\_report

Note: The  report data is 3 days behind

Seller Central Console Report: [FBA Preview](https://sellercentral.amazon.com/reportcentral/ESTIMATED_FBA_FEES/1) ([Help](https://sellercentral.amazon.com/gp/help/201115050))

*For details on data availability and refresh schedule, please click* [*here*](#data-availability-and-refresh-schedule)*.*

| Column Name                                 | Data type | Description |
| ------------------------------------------- | --------- | ----------- |
| account\_name                               | String    |             |
| account\_id                                 | Integer   |             |
| seller\_id                                  | String    |             |
| country\_code                               | String    |             |
| currency\_code                              | String    |             |
| report\_date                                | Date      |             |
| sku                                         | String    |             |
| fnsku                                       | String    |             |
| asin                                        | String    |             |
| product\_name                               | String    |             |
| product\_group                              | String    |             |
| brand                                       | String    |             |
| fulfilled\_by                               | String    |             |
| your\_price                                 | Numeric   |             |
| sales\_price                                | Numeric   |             |
| longest\_side                               | Numeric   |             |
| median\_side                                | Numeric   |             |
| shortest\_side                              | Numeric   |             |
| length\_and\_girth                          | Numeric   |             |
| unit\_of\_dimension                         | String    |             |
| item\_package\_weight                       | Numeric   |             |
| unit\_of\_weight                            | String    |             |
| product\_size\_tier                         | String    |             |
| currency                                    | String    |             |
| estimated\_fee\_total                       | Numeric   |             |
| estimated\_referral\_fee\_per\_unit         | Numeric   |             |
| estimated\_variable\_closing\_fee           | Numeric   |             |
| estimated\_order\_handling\_fee\_per\_order | Numeric   |             |
| estimated\_pick\_pack\_fee\_per\_unit       | Numeric   |             |
| estimated\_weight\_handling\_fee\_per\_unit | Numeric   |             |
| expected\_fulfillment\_fee\_per\_unit       | Numeric   |             |
| download\_date                              | Date      |             |

## FBA Amazon Fulfilled Inventory Report

Table name: sellercentral\_fbaamazonfulfilledinventory\_report

Seller Central Console Report: [Amazon Fulfilled Inventory](https://sellercentral.amazon.com/reportcentral/AFNInventoryReport/1) ([Help](https://sellercentral.amazon.com/gp/help/200453180))

*For details on data availability and refresh schedule, please click* [*here*](#data-availability-and-refresh-schedule)*.*

| Column Name                | Data type | Description |
| -------------------------- | --------- | ----------- |
| account\_name              | String    |             |
| account\_id                | Integer   |             |
| country\_code              | String    |             |
| asin                       | String    |             |
| report\_date               | Date      |             |
| seller\_sku                | String    |             |
| fulfillment\_channel\_sku  | String    |             |
| condition\_type            | String    |             |
| warehouse\_condition\_code | String    |             |
| quantity\_available        | Integer   |             |
| download\_date             | Date      |             |

## FBA Inventory Age Report (Deprecated)

Deprecated by Amazon as on July 2022, Please use [FBA Manage Inventory Health Report](#fba-manage-inventory-health-report)

Table name: sellercentral\_fbainventoryage\_report

Seller Central Console Report: [Amazon Fulfilled Inventory Age](https://sellercentral.amazon.com/reportcentral/INVENTORY_AGE/1) ([Help](https://sellercentral.amazon.com/help/hub/reference/201979220))

*For details on data availability and refresh schedule, please click* [*here*](#data-availability-and-refresh-schedule)*.*

| Column Name                                        | Data type | Description |
| -------------------------------------------------- | --------- | ----------- |
| account\_name                                      | String    |             |
| account\_id                                        | Integer   |             |
| country\_code                                      | String    |             |
| currency\_code                                     | String    |             |
| snapshot\_date                                     | Date      |             |
| sku                                                | String    |             |
| fnsku                                              | String    |             |
| asin                                               | String    |             |
| product\_name                                      | String    |             |
| condition                                          | String    |             |
| avaliable\_quantity\_sellable                      | Integer   |             |
| qty\_with\_removals\_in\_progress                  | Integer   |             |
| inv\_age\_0\_to\_90\_days                          | Integer   |             |
| inv\_age\_91\_to\_180\_days                        | Integer   |             |
| inv\_age\_181\_to\_270\_days                       | Integer   |             |
| inv\_age\_271\_to\_365\_days                       | Integer   |             |
| inv\_age\_365\_plus\_days                          | Integer   |             |
| currency                                           | String    |             |
| qty\_to\_be\_charged\_ltsf\_6\_mo                  | Integer   |             |
| projected\_ltsf\_6\_mo                             | Numeric   |             |
| qty\_to\_be\_charged\_ltsf\_12\_mo                 | Integer   |             |
| projected\_ltsf\_12\_mo                            | Numeric   |             |
| units\_shipped\_last\_7\_days                      | Integer   |             |
| units\_shipped\_last\_30\_days                     | Integer   |             |
| units\_shipped\_last\_60\_days                     | Integer   |             |
| units\_shipped\_last\_90\_days                     | Integer   |             |
| alert                                              | String    |             |
| your\_price                                        | Numeric   |             |
| sales\_price                                       | Numeric   |             |
| lowest\_price\_new                                 | Numeric   |             |
| lowest\_price\_used                                | Numeric   |             |
| recommended\_action                                | String    |             |
| healthy\_inventory\_level                          | Integer   |             |
| recommended\_sales\_price                          | Numeric   |             |
| recommended\_sale\_duration\_days                  | Integer   |             |
| recommended\_removal\_quantity                     | Integer   |             |
| estimated\_cost\_savings\_of\_recommended\_actions | Numeric   |             |
| sell\_through                                      | Numeric   |             |
| item\_volume                                       | Numeric   |             |
| volume\_units                                      | String    |             |
| storage\_type                                      | String    |             |
| report\_date                                       | Date      |             |
| download\_date                                     | Dat       |             |

## FBA Received Inventory Report (Deprecated)

Deprecated by Amazon as on 31st-Jan-2023 - Use [Legder Summary](https://docs.intentwise.com/supported-data-models/data-models/amazon-source-data/seller-central/fulfillment-by-amazon#fba-ledger-summary-report)

Table name: sellercentral\_fbareceivedinventory\_report

Seller Central Console Report: [Amazon Received Inventory](https://sellercentral.amazon.com/reportcentral/INVENTORY_RECEIPT/0) ([Help](https://sellercentral.amazon.com/help/hub/reference/200453220))

*For details on data availability and refresh schedule, please click* [*here*](#data-availability-and-refresh-schedule)*.*

| Column Name             | Data type | Description |
| ----------------------- | --------- | ----------- |
| account\_name           | String    |             |
| account\_id             | Integer   |             |
| country\_code           | String    |             |
| received\_date          | Timestamp |             |
| fnsku                   | String    |             |
| sku                     | String    |             |
| product\_name           | String    |             |
| quantity                | Integer   |             |
| fba\_shipment\_id       | String    |             |
| fulfillment\_center\_id | String    |             |
| report\_date            | Date      |             |
| download\_date          | Date      |             |

## FBA Customer Returns Report

Table name: sellercentral\_fbareturns\_report

Seller Central Console Report: [Amazon Fulfilled Customer Returns](https://sellercentral.amazon.com/reportcentral/CUSTOMER_RETURNS/0)([Help](https://sellercentral.amazon.com/help/hub/reference/200453320))

*For details on data availability and refresh schedule, please click* [*here*](#data-availability-and-refresh-schedule)*.*

| Column Name             | Data type | Description (Refer help link above) |
| ----------------------- | --------- | ----------------------------------- |
| account\_name           | String    |                                     |
| account\_id             | Integer   |                                     |
| country\_code           | String    |                                     |
| return\_date            | Timestamp |                                     |
| order\_id               | String    |                                     |
| sku                     | String    |                                     |
| asin                    | String    |                                     |
| fnsku                   | String    |                                     |
| product\_name           | String    |                                     |
| quantity                | Integer   |                                     |
| fulfillment\_center\_id | String    |                                     |
| detailed\_disposition   | String    |                                     |
| reason                  | String    |                                     |
| status                  | String    |                                     |
| license\_plate\_number  | String    |                                     |
| customer\_comments      | String    |                                     |
| seller\_id              | String    |                                     |
| report\_date            | Date      |                                     |
| download\_date          | Date      |                                     |

## FBA Daily Inventory History Report (Deprecated)

Deprecated by Amazon as on 31st-Jan-2023 - Use [Legder Summary](https://docs.intentwise.com/supported-data-models/data-models/amazon-source-data/seller-central/fulfillment-by-amazon#fba-ledger-summary-report)

Table name: sellercentral\_fbadailyinventoryhistory\_report

Seller Central Console Report: [Amazon Fulfilled Daily Inventory History](https://sellercentral.amazon.com/reportcentral/INVENTORY_SNAPSHOT/0)([Help](https://sellercentral.amazon.com/help/hub/reference/200453200))

*For details on data availability and refresh schedule, please click* [*here*](#data-availability-and-refresh-schedule)*.*

| Column Name             | Data type | Description (Refer help link above) |
| ----------------------- | --------- | ----------------------------------- |
|                         |           |                                     |
| account\_name           | String    |                                     |
| account\_id             | Integer   |                                     |
| country\_code           | String    |                                     |
| snapshot\_date          | Timestamp |                                     |
| fnsku                   | String    |                                     |
| sku                     | String    |                                     |
| product\_name           | String    |                                     |
| quantity                | Integer   |                                     |
| fulfillment\_center\_id | String    |                                     |
| detailed\_disposition   | String    |                                     |
| country                 | String    |                                     |
| report\_date            | Date      |                                     |
| download\_date          | Date      |                                     |

## FBA Inventory Health Report(Deprecated)

Deprecated by Amazon as on July 2022, Please use [FBA Manage Inventory Health Report](#fba-manage-inventory-health-report)

Table name: sellercentral\_fbainventoryhealth\_report

Seller Central Console Report: [Amazon Fulfilled Inventory Health Report](https://sellercentral.amazon.com/reportcentral/INVENTORY_HEALTH/0)([Help](https://sellercentral.amazon.com/help/hub/reference/200537120))

*For details on data availability and refresh schedule, please click* [*here*](#data-availability-and-refresh-schedule)*.*

| Column Name                           | Data type | Description (Refer help link above) |
| ------------------------------------- | --------- | ----------------------------------- |
| account\_name                         | String    |                                     |
| account\_id                           | Integer   |                                     |
| country\_code                         | String    |                                     |
| currency\_code                        | String    |                                     |
| snapshot\_date                        | Timestamp |                                     |
| sku                                   | String    |                                     |
| fnsku                                 | String    |                                     |
| asin                                  | String    |                                     |
| product\_name                         | String    |                                     |
| condition                             | String    |                                     |
| sales\_rank                           | Integer   |                                     |
| product\_group                        | String    |                                     |
| total\_quantity                       | Integer   |                                     |
| sellable\_quantity                    | Integer   |                                     |
| unsellable\_quantity                  | Integer   |                                     |
| inv\_age\_0\_to\_90\_days             | Integer   |                                     |
| inv\_age\_91\_to\_180\_days           | Integer   |                                     |
| inv\_age\_181\_to\_270\_days          | Integer   |                                     |
| inv\_age\_271\_to\_365\_days          | Integer   |                                     |
| inv\_age\_365\_plus\_days             | Integer   |                                     |
| units\_shipped\_last\_24\_hrs         | Integer   |                                     |
| units\_shipped\_last\_7\_days         | Integer   |                                     |
| units\_shipped\_last\_30\_days        | Integer   |                                     |
| units\_shipped\_last\_90\_days        | Integer   |                                     |
| units\_shipped\_last\_180\_days       | Integer   |                                     |
| units\_shipped\_last\_365\_days       | Integer   |                                     |
| weeks\_of\_cover\_t7                  | String    |                                     |
| weeks\_of\_cover\_t30                 | String    |                                     |
| weeks\_of\_cover\_t90                 | String    |                                     |
| weeks\_of\_cover\_t180                | String    |                                     |
| weeks\_of\_cover\_t365                | String    |                                     |
| num\_afn\_new\_sellers                | Integer   |                                     |
| num\_afn\_used\_sellers               | Integer   |                                     |
| currency                              | String    |                                     |
| your\_price                           | Numeric   |                                     |
| sales\_price                          | Numeric   |                                     |
| lowest\_afn\_new\_price               | Numeric   |                                     |
| lowest\_afn\_used\_price              | Numeric   |                                     |
| lowest\_mfn\_new\_price               | Numeric   |                                     |
| lowest\_mfn\_used\_price              | Numeric   |                                     |
| qty\_to\_be\_charged\_ltsf\_12\_mo    | Integer   |                                     |
| qty\_in\_long\_term\_storage\_program | Integer   |                                     |
| qty\_with\_removals\_in\_progress     | Integer   |                                     |
| projected\_ltsf\_12\_mo               | Numeric   |                                     |
| per\_unit\_volume                     | Numeric   |                                     |
| is\_hazmat                            | String    |                                     |
| in\_bound\_quantity                   | Integer   |                                     |
| asin\_limit                           | Integer   |                                     |
| inbound\_recommend\_quantity          | Integer   |                                     |
| qty\_to\_be\_charged\_ltsf\_6\_mo     | Integer   |                                     |
| projected\_ltsf\_6\_mo                | Numeric   |                                     |
| report\_date                          | Date      |                                     |
| download\_date                        | Date      |                                     |

## FBA Storage Fees Report

Table name: sellercentral\_fbastoragefees\_report

Seller Central Console Report: [Amazon Monthly Storage Fees](https://sellercentral.amazon.com/reportcentral/STORAGE_FEE_CHARGES/1)([Help](https://sellercentral.amazon.com/help/hub/reference/202086720))

*For details on data availability and refresh schedule, please click* [*here*](#data-availability-and-refresh-schedule)*.*

| Column Name                         | Data type | Description (Refer help link above) |
| ----------------------------------- | --------- | ----------------------------------- |
| account\_name                       | String    |                                     |
| account\_id                         | Integer   |                                     |
| currency\_code                      | String    |                                     |
| asin                                | String    |                                     |
| fnsku                               | String    |                                     |
| product\_name                       | String    |                                     |
| fulfillment\_center                 | String    |                                     |
| country\_code                       | String    |                                     |
| longest\_side                       | Numeric   |                                     |
| median\_side                        | Numeric   |                                     |
| shortest\_side                      | Numeric   |                                     |
| measurement\_units                  | String    |                                     |
| weight                              | Numeric   |                                     |
| weight\_units                       | String    |                                     |
| item\_volume                        | Numeric   |                                     |
| volume\_units                       | String    |                                     |
| product\_size\_tier                 | String    |                                     |
| average\_quantity\_on\_hand         | Numeric   |                                     |
| average\_quantity\_pending\_removal | Numeric   |                                     |
| estimated\_total\_item\_volume      | Numeric   |                                     |
| month\_of\_charge                   | String    |                                     |
| storage\_rate                       | Numeric   |                                     |
| currency                            | String    |                                     |
| estimated\_monthly\_storage\_fee    | Numeric   |                                     |
| dangerous\_goods\_storage\_type     | String    |                                     |
| eligible\_for\_inventory\_discount  | String    |                                     |
| qualifies\_for\_inventory\_discount | String    |                                     |
| total\_incentive\_fee\_amount       | Numeric   |                                     |
| breakdown\_incentive\_fee\_amount   | Numeric   |                                     |
| average\_quantity\_customer\_orders | Numeric   |                                     |
| report\_start\_date                 | Integer   |                                     |
| report\_end\_date                   | Integer   |                                     |
| download\_date                      | Integer   |                                     |

## FBA Monthly Inventory History Report (Deprecated)

Deprecated by Amazon as on 31st-Jan-2023 - Use [Legder Summary](https://docs.intentwise.com/supported-data-models/data-models/amazon-source-data/seller-central/fulfillment-by-amazon#fba-ledger-summary-report)

Table name: sellercentral\_fbamonthlyinventoryhistory\_report

Seller Central Console Report: [Monthly Inventory History Report ](https://sellercentral.amazon.com/reportcentral/INVENTORY_MONTHLY_SNAPSHOT/0)([Help](https://sellercentral.amazon.com/help/hub/reference/200490420))

*For details on data availability and refresh schedule, please click* [*here*](#data-availability-and-refresh-schedule)*.*

| Column Name             | Data type | Description (Refer help link above) |
| ----------------------- | --------- | ----------------------------------- |
| account\_name           | String    |                                     |
| account\_id             | Integer   |                                     |
| country\_code           | String    |                                     |
| month                   | Date      |                                     |
| fnsku                   | String    |                                     |
| sku                     | String    |                                     |
| product\_name           | String    |                                     |
| average\_quantity       | Numeric   |                                     |
| end\_quantity           | Integer   |                                     |
| fulfillment\_center\_id | String    |                                     |
| detailed\_disposition   | String    |                                     |
| country                 | String    |                                     |
| report\_start\_date     | Date      |                                     |
| report\_end\_date       | Date      |                                     |
| download\_date          | Date      |                                     |

## FBA Manage Inventory Report

Table name: sellercentral\_fbamanageinventory\_report

Seller Central Console Report: [FBA Manage Inventory Report](https://sellercentral.amazon.com/reportcentral/FBA_MYI_UNSUPPRESSED_INVENTORY/1) ([Help](https://sellercentral.amazon.com/help/hub/reference/200740930))

*For details on data availability and refresh schedule, please click* [*here*](#data-availability-and-refresh-schedule)*.*

| Column Name                       | Data type | Description (Refer help link above) |
| --------------------------------- | --------- | ----------------------------------- |
| account\_name                     | String    |                                     |
| account\_id                       | Integer   |                                     |
| currency\_code                    | String    |                                     |
| sku                               | String    |                                     |
| fnsku                             | String    |                                     |
| asin                              | String    |                                     |
| product\_name                     | String    |                                     |
| condition                         | String    |                                     |
| your\_price                       | Numeric   |                                     |
| mfn\_listing\_exists              | String    |                                     |
| mfn\_fulfillable\_quantity        | Integer   |                                     |
| afn\_listing\_exists              | String    |                                     |
| afn\_warehouse\_quantity          | Integer   |                                     |
| afn\_fulfillable\_quantity        | Integer   |                                     |
| afn\_unsellable\_quantity         | Integer   |                                     |
| afn\_reserved\_quantity           | Integer   |                                     |
| afn\_total\_quantity              | Integer   |                                     |
| per\_unit\_volume                 | Numeric   |                                     |
| afn\_inbound\_working\_quantity   | Integer   |                                     |
| afn\_inbound\_shipped\_quantity   | Integer   |                                     |
| afn\_inbound\_receiving\_quantity | Integer   |                                     |
| afn\_researching\_quantity        | Integer   |                                     |
| afn\_reserved\_future\_supply     | Integer   |                                     |
| afn\_future\_supply\_buyable      | Integer   |                                     |
| report\_date                      | Date      |                                     |
| download\_date                    | Date      |                                     |

## FBA Ledger Summary Report

Table name: sellercentral\_fbaledgersummary\_report

Seller Central Console Report: [FBA Inventory Ledger Report](https://sellercentral.amazon.com/reportcentral/FBA_MYI_UNSUPPRESSED_INVENTORY/1) ([Help](https://sellercentral.amazon.com/help/hub/reference/G4FKT5KQWFFJ7LDN))

*For details on data availability and refresh schedule, please click* [*here*](#data-availability-and-refresh-schedule)*.*

| Column Name                      | Data type | Description (Refer help link above) |
| -------------------------------- | --------- | ----------------------------------- |
| account\_name                    | String    |                                     |
| account\_id                      | Integer   |                                     |
| date                             | Date      |                                     |
| fnsku                            | String    |                                     |
| asin                             | String    |                                     |
| msku                             | String    |                                     |
| title                            | String    |                                     |
| disposition                      | String    |                                     |
| starting\_warehouse\_balance     | Integer   |                                     |
| in\_transit\_between\_warehouses | Integer   |                                     |
| receipts                         | Integer   |                                     |
| customer\_shipments              | Integer   |                                     |
| customer\_returns                | Integer   |                                     |
| vendor\_returns                  | Integer   |                                     |
| warehouse\_transfer\_in\_out     | Integer   |                                     |
| found                            | Integer   |                                     |
| lost                             | Integer   |                                     |
| damaged                          | Integer   |                                     |
| disposed                         | Integer   |                                     |
| other\_events                    | Integer   |                                     |
| ending\_warehouse\_balance       | Integer   |                                     |
| unknown\_events                  | Integer   |                                     |
| location                         | String    |                                     |
| download\_date                   | Date      |                                     |

## FBA Ledger *Detailed* Report

Table name: sellercentral\_fbaledgerdetailed\_report

Seller Central Console Report: [FBA Inventory Ledger Report](https://sellercentral.amazon.com/reportcentral/FBA_MYI_UNSUPPRESSED_INVENTORY/1) ([Help](https://sellercentral.amazon.com/help/hub/reference/G4FKT5KQWFFJ7LDN))

*For details on data availability and refresh schedule, please click* [*here*](#data-availability-and-refresh-schedule)*.*

| Column Name            | Data type | Description (Refer help link above) |
| ---------------------- | --------- | ----------------------------------- |
| account\_name          | String    |                                     |
| account\_id            | Integer   |                                     |
| date                   | Date      |                                     |
| fnsku                  | String    |                                     |
| asin                   | String    |                                     |
| msku                   | String    |                                     |
| title                  | String    |                                     |
| event\_type            | String    |                                     |
| reference\_id          | String    |                                     |
| quantity               | Integer   |                                     |
| fulfillment\_center    | String    |                                     |
| disposition            | String    |                                     |
| reason                 | String    |                                     |
| country                | String    |                                     |
| reconciled\_quantity   | Integer   |                                     |
| unreconciled\_quantity | Integer   |                                     |
| download\_date         | Date      |                                     |

## FBA Manage Inventory Health Report

Table name: sellercentral\_fbamanageinventoryhealth\_report

Seller Central Console Report: FBA Manage Inventory Health Report ([Help](https://sellercentral.amazon.com/gp/help/GKT9YKCHXMSDVJKB))

*For details on data availability and refresh schedule, please click* [*here*](https://docs.intentwise.com/supported-data-models/data-models/amazon-source-data/seller-central#data-availability-and-refresh-schedule)*.*

| Column Name                                            | Data Type | Description (Refer help link above) |
| ------------------------------------------------------ | --------- | ----------------------------------- |
| account\_name                                          | String    |                                     |
| account\_id                                            | Integer   |                                     |
| country\_code                                          | String    |                                     |
| snapshot\_date                                         | Timestamp |                                     |
| sku                                                    | String    |                                     |
| fnsku                                                  | String    |                                     |
| asin                                                   | String    |                                     |
| product\_name                                          | String    |                                     |
| condition                                              | String    |                                     |
| available                                              | Integer   |                                     |
| pending\_removal\_quantity                             | Integer   |                                     |
| inv\_age\_0\_to\_90\_days                              | Integer   |                                     |
| inv\_age\_91\_to\_180\_days                            | Integer   |                                     |
| inv\_age\_181\_to\_270\_days                           | Integer   |                                     |
| inv\_age\_271\_to\_365\_days                           | Integer   |                                     |
| inv\_age\_365\_plus\_days                              | Integer   |                                     |
| currency                                               | String    |                                     |
| qty\_to\_be\_charged\_ltsf\_9\_mo                      | Integer   |                                     |
| projected\_ltsf\_9\_mo                                 | Numeric   |                                     |
| qty\_to\_be\_charged\_ltsf\_12\_mo                     | Integer   |                                     |
| estimated\_ltsf\_next\_charge                          | Numeric   |                                     |
| units\_shipped\_t7                                     | Integer   |                                     |
| units\_shipped\_t30                                    | Integer   |                                     |
| units\_shipped\_t60                                    | Integer   |                                     |
| units\_shipped\_t90                                    | Integer   |                                     |
| alert                                                  | String    |                                     |
| your\_price                                            | Numeric   |                                     |
| sales\_price                                           | Numeric   |                                     |
| lowest\_price\_new\_plus\_shipping                     | Numeric   |                                     |
| lowest\_price\_used                                    | Numeric   |                                     |
| recommended\_action                                    | String    |                                     |
| healthy\_inventory\_level                              | Integer   |                                     |
| recommended\_sales\_price                              | Numeric   |                                     |
| recommended\_sale\_duration\_days                      | Integer   |                                     |
| recommended\_removal\_quantity                         | Integer   |                                     |
| estimated\_cost\_savings\_of\_recommended\_actions     | Numeric   |                                     |
| sell\_through                                          | Numeric   |                                     |
| item\_volume                                           | Numeric   |                                     |
| volume\_unit\_measurement                              | String    |                                     |
| storage\_type                                          | String    |                                     |
| storage\_volume                                        | Numeric   |                                     |
| market\_place                                          | String    |                                     |
| product\_group                                         | String    |                                     |
| sales\_rank                                            | Integer   |                                     |
| days\_of\_supply                                       | Integer   |                                     |
| estimated\_excess\_quantity                            | Integer   |                                     |
| weeks\_of\_cover\_t30                                  | Integer   |                                     |
| weeks\_of\_cover\_t90                                  | Integer   |                                     |
| featuredoffer\_price                                   | Numeric   |                                     |
| sales\_shipped\_last\_7\_days                          | Numeric   |                                     |
| sales\_shipped\_last\_30\_days                         | Numeric   |                                     |
| sales\_shipped\_last\_60\_days                         | Numeric   |                                     |
| sales\_shipped\_last\_90\_days                         | Numeric   |                                     |
| inv\_age\_0\_to\_30\_days                              | Integer   |                                     |
| inv\_age\_31\_to\_60\_days                             | Integer   |                                     |
| inv\_age\_61\_to\_90\_days                             | Integer   |                                     |
| inv\_age\_181\_to\_330\_days                           | Numeric   |                                     |
| inv\_age\_331\_to\_365\_days                           | Numeric   |                                     |
| estimated\_storage\_cost\_next\_month                  | Numeric   |                                     |
| inbound\_quantity                                      | Integer   |                                     |
| inbound\_working                                       | Integer   |                                     |
| inbound\_shipped                                       | Integer   |                                     |
| inbound\_received                                      | Integer   |                                     |
| no\_sale\_last\_6\_months                              | Integer   |                                     |
| reserved\_quantity                                     | Integer   |                                     |
| unfulfillable\_quantity                                | Integer   |                                     |
| download\_date                                         | Timestamp |                                     |
| quantity\_to\_be\_charged\_ais\_181\_210\_days         | Integer   |                                     |
| estimated\_ais\_181\_210\_days                         | Numeric   |                                     |
| quantity\_to\_be\_charged\_ais\_211\_240\_days         | Integer   |                                     |
| estimated\_ais\_211\_240\_days                         | Numeric   |                                     |
| quantity\_to\_be\_charged\_ais\_241\_270\_days         | Integer   |                                     |
| estimated\_ais\_241\_270\_days                         | Numeric   |                                     |
| quantity\_to\_be\_charged\_ais\_271\_300\_days         | Integer   |                                     |
| estimated\_ais\_271\_300\_days                         | Numeric   |                                     |
| quantity\_to\_be\_charged\_ais\_301\_330\_days         | Integer   |                                     |
| estimated\_ais\_301\_330\_days                         | Numeric   |                                     |
| quantity\_to\_be\_charged\_ais\_331\_365\_days         | Integer   |                                     |
| estimated\_ais\_331\_365\_days                         | Numeric   |                                     |
| quantity\_to\_be\_charged\_ais\_365\_plus\_days        | Integer   |                                     |
| estimated\_ais\_365\_plus\_days                        | Numeric   |                                     |
| fba\_inventory\_level\_health\_status                  | String    |                                     |
| fba\_minimum\_inventory\_level                         | Integer   |                                     |
| historical\_days\_of\_supply                           | Numeric   |                                     |
| projected\_ltsf\_11\_mo                                | Numeric   |                                     |
| qty\_to\_be\_charged\_ltsf\_11\_mo                     | Integer   |                                     |
| total\_reserved\_quantity                              | Integer   |                                     |
| recommended\_ship\_in\_quantity                        | Integer   |                                     |
| recommended\_ship\_in\_date                            | Timestamp |                                     |
| last\_updated\_date\_for\_historical\_days\_of\_supply | Timestamp |                                     |
| exempted\_from\_low\_inventory\_level\_fee             | String    |                                     |
| low\_inventory\_level\_fee\_applied\_in\_current\_week | String    |                                     |
| short\_term\_historical\_days\_of\_supply              | Integer   |                                     |
| long\_term\_historical\_days\_of\_supply               | Integer   |                                     |
| inventory\_age\_snapshot\_date                         | Timestamp |                                     |
| inventory\_supply\_at\_fba                             | Integer   |                                     |
| reserved\_fc\_transfer                                 | Integer   |                                     |
| reserved\_fc\_processing                               | Integer   |                                     |
| reserved\_customer\_order                              | Integer   |                                     |
| total\_days\_of\_supply                                | Integer   |                                     |
| inv\_age\_366\_to\_455\_days                           | Integer   |                                     |
| inv\_age\_456\_plus\_days                              | Integer   |                                     |
| quantity\_to\_be\_charged\_ais\_366\_455\_days         | Integer   |                                     |
| estimated\_ais\_366\_455\_days                         | Numeric   |                                     |
| quantity\_to\_be\_charged\_ais\_456\_plus\_days        | Integer   |                                     |
| estimated\_ais\_456\_plus\_days                        | Numeric   |                                     |
| download\_time                                         | Timestamp |                                     |

## FBA **Subscribe and Save Forecast Report (Deprecated)**

Table name: sellercentral\_fbasubscribeandsaveforecast\_report\
\
Please use the Replenishment Report for Subscribe and Save Data - [Link](https://docs.intentwise.com/iac-source-data/data-models/amazon-source-data/brand-analytics-reports#replenishment-reports)

| Column Name                                   | Data type | Description (Refer help link above) |
| --------------------------------------------- | --------- | ----------------------------------- |
| account\_name                                 | String    |                                     |
| account\_id                                   | Integer   |                                     |
| snapshot\_date                                | Date      |                                     |
| offer\_state                                  | String    |                                     |
| sku                                           | String    |                                     |
| fnsku                                         | String    |                                     |
| asin                                          | String    |                                     |
| estimated\_avg\_sns\_discount\_next\_8\_weeks | Numeric   |                                     |
| product\_name                                 | String    |                                     |
| country                                       | String    |                                     |
| active\_subscriptions                         | Integer   |                                     |
| week\_1\_start\_date                          | Date      |                                     |
| scheduled\_sns\_units\_week\_1                | Integer   |                                     |
| scheduled\_sns\_units\_week\_2                | Integer   |                                     |
| scheduled\_sns\_units\_week\_3                | Integer   |                                     |
| scheduled\_sns\_units\_week\_4                | Integer   |                                     |
| scheduled\_sns\_units\_week\_5                | Integer   |                                     |
| scheduled\_sns\_units\_week\_6                | Integer   |                                     |
| scheduled\_sns\_units\_week\_7                | Integer   |                                     |
| scheduled\_sns\_units\_week\_8                | Integer   |                                     |
| download\_date                                | Date      |                                     |

## FBA **Subscribe and Save Performance Report (Deprecated)**

Table name: sellercentral\_fbasubscribeandsaveperformance\_report

Please use the Replenishment Report for Subscribe and Save Data - [Link](https://docs.intentwise.com/iac-source-data/data-models/amazon-source-data/brand-analytics-reports#replenishment-reports)

<table><thead><tr><th width="256">Column Name</th><th>Data type</th><th>Description (Refer help link above)</th></tr></thead><tbody><tr><td>account_name</td><td>String</td><td></td></tr><tr><td>account_id</td><td>Integer</td><td></td></tr><tr><td>offer_state</td><td>String</td><td></td></tr><tr><td>snapshot_date</td><td>Date</td><td></td></tr><tr><td>sku</td><td>String</td><td></td></tr><tr><td>fnsku</td><td>String</td><td></td></tr><tr><td>asin</td><td>String</td><td></td></tr><tr><td>product_name</td><td>String</td><td></td></tr><tr><td>country</td><td>String</td><td></td></tr><tr><td>week_1_start_date</td><td>Date</td><td></td></tr><tr><td>sns_units_shipped_week_1</td><td>Integer</td><td></td></tr><tr><td>oos_rate_week_1</td><td>Numeric</td><td></td></tr><tr><td>sns_sale_price_week_1</td><td>Numeric</td><td></td></tr><tr><td>sns_discount_week_1</td><td>Numeric</td><td></td></tr><tr><td>sns_units_shipped_week_2</td><td>Integer</td><td></td></tr><tr><td>oos_rate_week_2</td><td>Numeric</td><td></td></tr><tr><td>sns_sale_price_week_2</td><td>Numeric</td><td></td></tr><tr><td>sns_discount_week_2</td><td>Numeric</td><td></td></tr><tr><td>sns_units_shipped_week_3</td><td>Integer</td><td></td></tr><tr><td>oos_rate_week_3</td><td>Numeric</td><td></td></tr><tr><td>sns_sale_price_week_3</td><td>Numeric</td><td></td></tr><tr><td>sns_discount_week_3</td><td>Numeric</td><td></td></tr><tr><td>sns_units_shipped_week_4</td><td>Integer</td><td></td></tr><tr><td>oos_rate_week_4</td><td>Numeric</td><td></td></tr><tr><td>sns_sale_price_week_4</td><td>Numeric</td><td></td></tr><tr><td>sns_discount_week_4</td><td>Numeric</td><td></td></tr><tr><td>seller_id</td><td>String</td><td></td></tr><tr><td>download_date</td><td>Date</td><td></td></tr></tbody></table>

## FBA Long Term Storage Fee Charges **Report**

Table name: sellercentral\_fbalongtermstoragefeecharges\_report

*Frequency : Monthly*

<table><thead><tr><th width="125">Column Name</th><th width="87">Data type</th><th width="87">Description</th></tr></thead><tbody><tr><td>account_id</td><td>Integer</td><td>Intentwise Account Id</td></tr><tr><td>account_name</td><td>String</td><td>Intentwise Account Name</td></tr><tr><td>snapshot_date</td><td>Timestamp</td><td>Snapshot Date</td></tr><tr><td>sku</td><td>String</td><td>SKU</td></tr><tr><td>asin</td><td>String</td><td>Amazon standard identification numbers (ASINs) are unique blocks of 10 letters or numbers that identify items. Amazon assigns the ASIN, which you can find on the product-detail page.</td></tr><tr><td>fnsku</td><td>String</td><td>Amazon's fulfillment network stock-keeping unit (SKU) identifier.</td></tr><tr><td>product_name</td><td>String</td><td>Description of the ASIN on the product-detail page.</td></tr><tr><td>condition</td><td>String</td><td>The condition of your product.</td></tr><tr><td>per_unit_volume</td><td>Numeric</td><td>The volume in cubic feet of each inventory unit assessed the aged inventory surcharge.</td></tr><tr><td>currency</td><td>String</td><td></td></tr><tr><td>volume_unit</td><td>String</td><td>Unit name of the volume value.</td></tr><tr><td>country</td><td>String</td><td>The country in which your products are stored.</td></tr><tr><td>qty_charged</td><td>Numeric</td><td>The number of units in fulfillment centers for which the aged inventory surcharge was assessed.</td></tr><tr><td>amount_charged</td><td>Numeric</td><td>The amount of aged inventory surcharge that was charged.</td></tr><tr><td>surcharge_age_tier</td><td>String</td><td>The age tier that was charged according to the aged inventory surcharge rates.</td></tr><tr><td>rate_surcharge</td><td>Numeric</td><td>The surcharge rate corresponding to the surcharge age tier charged (converted to a per-unit value).</td></tr><tr><td>report_start_date</td><td>Date</td><td>Report Start Date</td></tr><tr><td>report_end_date</td><td>Date</td><td>Report End Date</td></tr><tr><td>download_date</td><td>Date</td><td>Download date</td></tr></tbody></table>

## FBA **Reimbursements Report**

Table name: sellercentral\_fbareimbursements\_report

<table data-header-hidden><thead><tr><th></th><th width="241.80004882812503"></th><th></th></tr></thead><tbody><tr><td>Column Name</td><td>Data type</td><td>Description </td></tr><tr><td>account_id</td><td>Integer</td><td>Intentwise Account Id</td></tr><tr><td>account_name</td><td>String</td><td>Intentwise Account Name</td></tr><tr><td>approval_date</td><td>String</td><td>The date the reimbursement was approved.</td></tr><tr><td>reimbursement_id</td><td>String</td><td>The unique identifier for this reimbursement. Each reimbursement may include multiple line items.</td></tr><tr><td>case_id</td><td>String</td><td>The unique identifier assigned to the case when you request a reimbursement.</td></tr><tr><td>amazon_order_id</td><td>String</td><td>The unique identifier assigned to the customer order. This field is empty if the reimbursement is not associated with an order.</td></tr><tr><td>reason</td><td>String</td><td>The reason for the reimbursement (for example, Damaged: Warehouse).</td></tr><tr><td>sku</td><td>String</td><td>The merchant SKU (stock keeping unit) is the unique identifier you assigned to your product.</td></tr><tr><td>asin</td><td>String</td><td>An ASIN (Amazon Standard Identification Numbers) is a unique identifier assigned by Amazon to products in the Amazon product catalog. The ASIN can be found on the product detail page.</td></tr><tr><td>fnsku</td><td>String</td><td>The fulfillment network SKU (stock keeping unit) is the unique identifier Fulfillment by Amazon assigned to your product.</td></tr><tr><td>product_name</td><td>String</td><td>The name of your product.</td></tr><tr><td>condition</td><td>String</td><td>The condition of your item (for example, New).</td></tr><tr><td>currency_unit</td><td>String</td><td>The currency for the applicable marketplace.</td></tr><tr><td>amount_per_unit</td><td>Numeric</td><td>The per-unit reimbursement amount for this line item.</td></tr><tr><td>amount_total</td><td>Numeric</td><td>The total amount of the cash reimbursement for this line item.</td></tr><tr><td>quantity_reimbursed_cash</td><td>Integer</td><td>The total number of units reimbursed with cash.</td></tr><tr><td>quantity_reimbursed_inventory</td><td>Integer</td><td>The number of units reimbursed with inventory.</td></tr><tr><td>quantity_reimbursed_total</td><td>Integer</td><td>The total number of units reimbursed with either cash or inventory (Quantity Reimbursed [Cash] + Quantity Reimbursed [Inventory]).</td></tr><tr><td>original_reimbursement_id</td><td>String</td><td></td></tr><tr><td>original_reimbursement_type</td><td>String</td><td></td></tr><tr><td>report_start_date</td><td>Date</td><td>Report Start Date</td></tr><tr><td>report_end_date</td><td>Date</td><td>Report End Date</td></tr><tr><td>download_date</td><td>Date</td><td>Download date</td></tr></tbody></table>

## **FBA Promotions Report**

Table name: sellercentral\_fbapromotions\_report&#x20;

Seller Central Console Report: FBA Promotions Report ([Help](https://sellercentral.amazon.com/help/hub/reference/G200453160))

*Frequency: Daily*<br>

<table><thead><tr><th>Column Name</th><th width="235.4000244140625">Data Type</th><th>Description</th></tr></thead><tbody><tr><td>account_id</td><td>Integer</td><td>Intentwise Account Id</td></tr><tr><td>account_name</td><td>String</td><td>Intentwise Account Name</td></tr><tr><td>shipment-date</td><td>Date</td><td>Date the item was dispatched to the customer</td></tr><tr><td>currency_code</td><td>String</td><td>Local currency for the transaction</td></tr><tr><td>country_code</td><td>String</td><td>The country in which your products are stored.</td></tr><tr><td>item-promotion-discount</td><td>String</td><td>Promotion value applied to this shipment item.</td></tr><tr><td>item-promotion-id</td><td>String</td><td>Unique identifier for this promotion</td></tr><tr><td>description</td><td>String</td><td>Description of the promotion</td></tr><tr><td>promotion-rule-value</td><td>String</td><td>Maximum net value of the promotion</td></tr><tr><td>amazon-order-id</td><td>String</td><td>Order id of shipment to which the promotion was applied.</td></tr><tr><td>shipment-id</td><td>String</td><td>Unique identifier for this item in this shipment.</td></tr><tr><td>shipment-item-id</td><td>String</td><td>Unique identifier--pertains only to this item in this shipment.</td></tr><tr><td>download_date</td><td>Date</td><td>download date</td></tr></tbody></table>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.intentwise.com/iac-source-data/data-models/amazon-source-data/seller-central/fulfillment-by-amazon.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.