# All Report Types and Tables

### Schema 

The schema of each table offered by Daton is given according to the report type in the sheet linked below. 

{% file src="<https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FuOBO1maImkpFB74dWLsh%2FAmazon%20SP-API%20Tables%20Schema%20.xlsx?alt=media&token=ff1fa645-9639-4fff-b9f0-d7faf3b28dc7>" %}
Linked spreadsheet with schema of each table
{% endfile %}

### Table Details

The details of each table Daton offers are divided amongst Seller Reports and Raw API tables. Seller Reports are tables fetched via the Reports API in Amazon's SP API. Raw Data Tables refer to tables offered by Daton that are from all APIs other than the Reports API in Amazon's SP API.

{% file src="<https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2Fa6aWIcuFe8LPSja87R0x%2FAmazon%20Selling%20Partner%20Tables.xlsx?alt=media&token=7c084979-8173-4866-999e-ce9064a4493c>" %}
Details including SP-API endpoint/Report Types, history and latency used to fetch data for each table
{% endfile %}

### Report Types

{% tabs %}
{% tab title="Daily Reports" %}

| FlatFileV2SettlementReport                     |
| ---------------------------------------------- |
| PromotionsPerformanceReport                    |
| SalesAndTrafficReportByChildASIN               |
| SalesAndTrafficReportByParentASIN (deprecated) |
| SalesAndTrafficReportByDate                    |
| FBAReservedInventoryReport                     |
| FBAPromotionsReport                            |
| FBAReturnsReport                               |
| FBARemovalOrderDetailReport                    |
| FBADailyInventoryHistoryReport (deprecated)    |
| FBAReceivedInventoryReport (deprecated)        |
| FBAInventoryEventDetailReport (deprecated)     |
| FBAInventoryAdjustmentsReport (deprecated)     |
| FBAReplacementsReport                          |
| FBAInboundPerformanceReport                    |
| FBAReimbursementsReport                        |
| FBARemovalShipmentDetailReport                 |
| {% endtab %}                                   |

{% tab title="Snapshot Reports" %}

| PanEuropeanEligibilityFBAASINs           |
| ---------------------------------------- |
| SuppressedListingsReport                 |
| ListingQualityandSuppressedListingReport |
| FBAMultiCountryInventoryReport           |
| FBAManageInventoryHealthReport           |
| InventoryReport                          |
| AllListingsReport                        |
| OpenListingsReport                       |
| CanceledListingsReport                   |
| ActiveListingsReport                     |
| InactiveListingsReport                   |
| FBAAmazonFulfilledInventoryReport        |
| FBAManageInventory                       |
| FBAManageInventoryArchived (deprecated)  |
| FBARestockInventoryReport                |
| FBAStrandedInventoryReport               |
| FBARecommendedRemovalReport              |
| FBASmallAndLightInventoryReport          |
| FeePreviewReport                         |
| ReferralFeePreviewReport                 |
| ReferralFeeDiscountsReport               |
| AccountHealthSellerPerformanceReport     |
| ProductOpportunitiesNotYetOnAmazon       |
| ProductOpportunitiesRecommended          |
| {% endtab %}                             |

{% tab title="Real Time Reports" %}

| InventoryLedgerDetailedReport               |
| ------------------------------------------- |
| InventoryLedgerSummaryReport                |
| FBAFlatFileOrdersByLastUpdateReport         |
| FlatFileReturnsReportbyReturnDate           |
| FlatFileFeedbackReport                      |
| FBAAmazonFulfilledShipmentsReport           |
| FBACustomerShipmentSalesReport              |
| EasyShipPickedUpReport (India only)         |
| EasyShipWaitingforPickUpReport (India only) |
| FlatFileAllOrdersReportbyLastUpdate         |
| {% endtab %}                                |

{% tab title="Monthly Reports" %}

| VATTransactionsReport (EU only)               |
| --------------------------------------------- |
| FBAStorageFeesReport                          |
| FBAMonthlyInventoryHistoryReport (deprecated) |
| {% endtab %}                                  |

{% tab title="Raw Data Tables" %}

| ListAllFulfillmentOrders         |
| -------------------------------- |
| OrderMetricsHourly               |
| OrderMetricsDaily                |
| CatalogCategoriesForASIN         |
| CatalogCategoriesForSKU          |
| GetCompetitivePricingForSKU      |
| GetCompetitivePricingForASIN     |
| InboundShipments                 |
| InboundShipmentsItems            |
| InboundShipmentsTransportDetails |
| FBAInventorySummary              |
| ListOrder                        |
| ListOrderItems                   |
| ListFinancialEvents              |
| ListFinancialEventsGroups        |
| ListFinancialEventsByGroupId     |
| ListingsItemsSummary             |
| ListingsItemsIssues              |
| CatalogItems                     |
| CatalogItemsVariations           |
| CatalogItemsSalesRank            |
| CatalogItemsSummary              |
| ListingsRestrictions             |
| ListingOffers                    |
| PricingForASIN                   |

{% endtab %}
{% endtabs %}