Schema and Tables
The reporting service provides reports that you can use to track, measure ad performance, and adjust settings to optimize your budget or campaign.
This section details the following entities:
Schema
The schema contains the field name and datatype of all columns in the tables offered by Daton:
Real-Time Reports
Daily Reports
Monthly Report
Raw Data Tables
Snapshot Reports
Click here to view the Amazon SP API- Tables Schema
Tables
The details of each table offered by Daton is given divided amongst Seller Reports and Raw API tables.
Seller Reports are tables that are fetched via the Reports API in Amazon's SP API.
Raw Data Tables are offered by Daton that are from all APIs other than the Reports API in Amazon's SP API.
Seller Reports
The following representation contains the Name, Enum, and Location of all the Reports offered by Daton. They also specify the locations of the marketplaces that are being served. Here, we have categorized them as:
FBAAmazonFulfilledShipmentsReport
For FBA Sellers only - Europe (EU), Japan, and North America (NA)
GET_AMAZON_FULFILLED_SHIPMENTS_DATA
Reports->Fulfillment->Sales->Amazon Fulfilled Shipments
FBACustomerShipmentSalesReport
For FBA Sellers only - Europe (EU), Japan, and North America (NA)
GET_FBA_FULFILLMENT_CUSTOMER_SHIPMENT_SALES_DATA
Reports->Fulfillment->Sales->Customer Shipment Sales
FBAPromotionsReport
FBA sellers only - North America (NA)
GET_FBA_FULFILLMENT_CUSTOMER_SHIPMENT_PROMOTION_DATA
Reports->Fulfillment->Sales->Promotions
FBAAmazonFulfilledInventoryReport
For FBA Sellers only
GET_AFN_INVENTORY_DATA
Reports->Fulfillment->Inventory->Amazon Fulfilled Inventory
FBAMonthlyInventoryHistoryReport
For FBA sellers only
GET_FBA_FULFILLMENT_MONTHLY_INVENTORY_DATA
Reports->Fulfillment->Inventory->Monthly Inventory History
FBAInventoryEventDetailReport
For FBA sellers only
GET_FBA_FULFILLMENT_INVENTORY_SUMMARY_DATA
Reports->Fulfillment->Inventory->Inventory Event Detail
FBAInboundPerformanceReport
For FBA sellers only
GET_FBA_FULFILLMENT_INBOUND_NONCOMPLIANCE_DATA
Reports->Fulfillment->Inventory->Inbound Performance
FBAReservedInventoryReport
For FBA sellers only
GET_RESERVED_INVENTORY_DATA
Reports->Fulfillment->Inventory->Reserved Inventory
FBAStorageFeesReport
For FBA Sellers only
GET_FBA_STORAGE_FEE_CHARGES_DATA
Reports->Fulfillment->Payments->Monthly Storage Fees
FBAReplacementsReport
For FBA sellers only - US only
GET_FBA_FULFILLMENT_CUSTOMER_SHIPMENT_REPLACEMENT_DATA
Reports->Fulfillment->Customer Concessions->Replacements
FBAInventoryHealthReport
For FBA sellers only - This report is not available in the Mexico and Australia marketplaces.
GET_FBA_FULFILLMENT_INVENTORY_HEALTH_DATA
Reports->Fulfillment->Inventory->Inventory Health
FBAManageInventory
For FBA sellers only
GET_FBA_MYI_UNSUPPRESSED_INVENTORY_DATA
Reports->Fulfillment->Inventory->Manage FBA Inventory
FBAManageInventoryArchived
For FBA sellers only - All regions except Mexico
GET_FBA_MYI_ALL_INVENTORY_DATA
Reports->Fulfillment->Inventory->Manage FBA Inventory Archived
FBARestockInventoryReport
FBA Sellers only - Formerly US Marketplace only. Now enabled for all marketplaces
GET_RESTOCK_INVENTORY_RECOMMENDATIONS_REPORT
Reports->Fulfillment->Inventory->Restock Inventory
FBAStrandedInventoryReport
FBA Sellers only - US, India, and Japan
GET_STRANDED_INVENTORY_UI_DATA
Reports->Fulfillment->Inventory->Stranded Inventory
FBAInventoryAgeReport
For FBA sellers only - US, India, and Japan marketplaces.
GET_FBA_INVENTORY_AGED_DATA
Reports->Fulfillment->Inventory->Inventory Age
FBADailyInventoryHistoryReport
For FBA sellers only - For all Regions
GET_FBA_FULFILLMENT_CURRENT_INVENTORY_DATA
Reports->Fulfillment->Inventory->Daily Inventory History
FBAReceivedInventoryReport
For FBA sellers only
GET_FBA_FULFILLMENT_INVENTORY_RECEIPTS_DATA
Reports->Fulfillment->Inventory->Received Inventory
FBAInventoryAdjustmentsReport
For FBA sellers only.
GET_FBA_FULFILLMENT_INVENTORY_ADJUSTMENTS_DATA
Reports->Fulfillment->Inventory->Inventory Adjustments
FeePreviewReport
FBA Sellers only - EU and NA
GET_FBA_ESTIMATED_FBA_FEES_TXT_DATA
Reports->Fulfillment->Payments->Fee Preview
FBARecommendedRemovalReport
For FBA sellers only
GET_FBA_RECOMMENDED_REMOVAL_DATA
Reports->Fulfillment->Removals->Recommended Removal
FBAReimbursementsReport
For FBA sellers only
GET_FBA_REIMBURSEMENTS_DATA
Reports->Fulfillment->Payments->Reimbursements
FBAReturnsReport
For FBA sellers only
GET_FBA_FULFILLMENT_CUSTOMER_RETURNS_DATA
Reports->Fulfillment->Customer Concessions->FBA Customer returns
FBASmallandLightInventoryReport
FBA Sellers only - US, UK, Germany, and Japan
GET_FBA_UNO_INVENTORY_DATA
Reports->Fulfillment->Inventory->Small & Light Inventory
FBARemovalOrderDetailReport
FBA Sellers only
GET_FBA_FULFILLMENT_REMOVAL_ORDER_DETAIL_DATA
Reports->Fulfillment->Removals->Removal Order Detail
FBARemovalShipmentDetailReport
FBA Sellers only
GET_FBA_FULFILLMENT_REMOVAL_SHIPMENT_DETAIL_DATA
Reports->Fulfillment->Removals->Removal Shipment Detail
InventoryLedgerSummaryReport
All Sellers
GET_LEDGER_SUMMARY_VIEW_DATA
Reports->Fulfillment->Inventory->InventoryLedger
InventoryLedgerSummaryReportByFulfillmentCentre
All Sellers
GET_LEDGER_SUMMARY_VIEW_DATA
Reports->Fulfillment->Inventory->InventoryLedger
InventoryLedgerDetailedReport
All Sellers
GET_LEDGER_DETAIL_VIEW_DATA
Reports->Fulfillment->Inventory->InventoryLedger
FBAManageInventoryHealthReport
All Sellers
GET_FBA_INVENTORY_PLANNING_DA
ports->Fulfillment->Inventory->FBA Inventory
ReferralFeePreviewReport
For Seller Central Only
GET_REFERRAL_FEE_PREVIEW_REPORT
Inventory->Inventory Reports->Referral Fee Preview Report
ReferralFeeDiscountsReport
For Amazon Business Sellers Only - US, UK, Germany, India, and Japan
FEE_DISCOUNTS_REPORT
Inventory->Inventory Reports->Referral Fee Discounts Report
AllListingsReport
For Seller Central Only - Canada, US,Europe, and India
GET_MERCHANT_LISTINGS_ALL_DATA
Inventory->Inventory Reports->All Listing Report
ActiveListingsReport
For Seller Central Only
GET_MERCHANT_LISTINGS_DATA
Inventory->Inventory Reports->Active Listing Report
InactiveListingsReport
For Seller Central Only
GET_MERCHANT_LISTINGS_INACTIVE_DATA
Inventory->Inventory Reports->Inactive Listings report
OpenListingsReport
For Seller Central Only - Canada, US, UK, and India
GET_MERCHANT_LISTINGS_DATA_BACK_COMPAT
Inventory->Inventory Reports->Open Listings Report
CanceledListingsReport
For Seller Central Only - Canada, US, UK, and India
GET_MERCHANT_CANCELLED_LISTINGS_DATA
Inventory->Inventory Reports->Canceled Listings Report
ListingQualityAndSuppressedListingReport
For Seller Central Only
GET_MERCHANT_LISTINGS_DEFECT_DATA
Inventory->Inventory Reports->Listing Quality and Suppressed Listings Report
SoldListingsReport
For Seller Central Only - Canada, US, UK, and India
GET_CONVERGED_FLAT_FILE_SOLD_LISTINGS_DATA
Inventory->Inventory Reports->Sold Listings Report
InventoryReport
GET_FLAT_FILE_OPEN_LISTINGS_DATA
Reports->Inventory Reports->Inventory Report
SuppressedListingsReport
GET_MERCHANTS_LISTINGS_FYP_REPORT
PanEuropeanEligibilityFBAASINs
This report is only available to FBA sellers in the Spain, UK, France, Germany, and Italy marketplaces.
GET_PAN_EU_OFFER_STATUS
Seller Central -> Reports -> Fulfilment -> Inventory -> Pan-European Eligibility: FBA ASINs
PanEuropeanEligibilitySelfFulfilledASINs
This report is only available in the Spain, UK, France, Germany, and Italy marketplaces.
GET_MFN_PAN_EU_OFFER_STATUS
Seller Central -> Reports -> Fulfilment -> Inventory -> Pan-European Eligibility: Self-fulfilled ASINs
ReferralFeePreviewReport
For Seller Central Only
GET_REFERRAL_FEE_PREVIEW_REPORT
Inventory->Inventory Reports->Referral Fee Preview Report
ReferralFeeDiscountsReport
For Amazon Business Sellers Only - US, UK, Germany, India, and Japan
FEE_DISCOUNTS_REPORT
Inventory->Inventory Reports->Referral Fee Discounts Report
AllListingsReport
For Seller Central Only - Canada, US,Europe, and India
GET_MERCHANT_LISTINGS_ALL_DATA
Inventory->Inventory Reports->All Listing Report
ActiveListingsReport
For Seller Central Only
GET_MERCHANT_LISTINGS_DATA
Inventory->Inventory Reports->Active Listing Report
InactiveListingsReport
For Seller Central Only
GET_MERCHANT_LISTINGS_INACTIVE_DATA
Inventory->Inventory Reports->Inactive Listings report
OpenListingsReport
For Seller Central Only - Canada, US, UK, and India
GET_MERCHANT_LISTINGS_DATA_BACK_COMPAT
Inventory->Inventory Reports->Open Listings Report
CanceledListingsReport
For Seller Central Only - Canada, US, UK, and India
GET_MERCHANT_CANCELLED_LISTINGS_DATA
Inventory->Inventory Reports->Canceled Listings Report
ListingQualityAndSuppressedListingReport
For Seller Central Only
GET_MERCHANT_LISTINGS_DEFECT_DATA
Inventory->Inventory Reports->Listing Quality and Suppressed Listings Report
SoldListingsReport
For Seller Central Only - Canada, US, UK, and India
GET_CONVERGED_FLAT_FILE_SOLD_LISTINGS_DATA
Inventory->Inventory Reports->Sold Listings Report
InventoryReport
GET_FLAT_FILE_OPEN_LISTINGS_DATA
Reports->Inventory Reports->Inventory Report
SuppressedListingsReport
GET_MERCHANTS_LISTINGS_FYP_REPORT
PanEuropeanEligibilityFBAASINs
For FBA sellers in the Spain, UK, France, Germany, and Italy marketplaces.
GET_PAN_EU_OFFER_STATUS
Seller Central -> Reports -> Fulfilment -> Inventory -> Pan-European Eligibility: FBA ASINs
PanEuropeanEligibilitySelfFulfilledASINs
For the Spain, UK, France, Germany, and Italy marketplaces.
GET_MFN_PAN_EU_OFFER_STATUS
Seller Central -> Reports -> Fulfilment -> Inventory -> Pan-European Eligibility: Self-fulfilled ASINs
SubscribeAndSaveForecastReport
GET_FBA_SNS_FORECAST_DATA
SubscribeAndSavePerformanceReport
GET_FBA_SNS_PERFORMANCE_DATA
All of these reports are available for all Sellers in all the regions and to access it, user must be registered on Amazon Brand Registry.
BrandAnalyticsMarketBasketReport
GET_BRAND_ANALYTICS_MARKET_BASKET_REPORT
Brands->Brand Analytics->Consumer Behaviour Dashboards->Market Basket Analysis
BrandAnalyticsSearchTermsReport
GET_BRAND_ANALYTICS_SEARCH_TERMS_REPORT
Brands->Brand Analytics->Consumer Behaviour Dashboards->Amazon Search Terms Report
RepeatPurchaseReport
GET_BRAND_ANALYTICS_REPEAT_PURCHASE_REPORT
Brands->Brand Analytics->Consumer Behaviour Dashboards->Repeat Purchase Behaviour
AlternatePurchaseReport
GET_BRAND_ANALYTICS_ALTERNATE_PURCHASE_REPORT
Brands->Brand Analytics->Consumer Behaviour Dashboards->Item Comparison and Alternate Purchase Behaviour
ItemComparisonReport
GET_BRAND_ANALYTICS_ITEM_COMPARISON_REPORT
Brands->Brand Analytics->Consumer Behaviour Dashboards->Item Comparison and Alternate Purchase Behaviour
FlatFileReturnsReportByReturnDate
GET_FLAT_FILE_RETURNS_DATA_BY_RETURN_DATE
Reports->Returns
FlatFileFeedbackReport
GET_SELLER_FEEDBACK_DATA
Performance->Feedback
EasyShipPickedUpReport
India Only
GET_EASYSHIP_PICKEDUP
Orders->Order Reports->EasyShip Orders
EasyShipWaitingforPickUpReport
India Only
GET_EASYSHIP_WAITING_FOR_PICKUP
Orders->Order Reports->EasyShip Orders
FBAFlatFileOrdersByLastUpdateReport
GET_FLAT_FILE_ALL_ORDERS_DATA_BY_LAST_UPDATE
Reports->Fulfillment->Sales->All Orders (Select Last Update Date from options)
ManageInventoryHealth
For Seller Central Only
GET_FLAT_FILE_ORDERS_DATA
Orders->Order Reports->New Orders
FlatFileV2SettlementReport
GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE_V2
Reports->Payments->All Statements
FlatFileAllOrdersReportbyLastUpdate
GET_FLAT_FILE_ALL_ORDERS_DATA_BY_LAST_UPDATE
Reports->FulfilledByAmazon->Sales->All Orders
ProductOpportunitiesRecommended
US, UK, France, Spain, Italy, India, Japan, Germany
GET_B2B_PRODUCT_OPPORTUNITIES_RECOMMENDED_FOR_YOU
B2B->Product Opportunities->Recommended For You
ProductOpportunitiesNotYetOnAmazon
US, UK, France, Spain, Italy, India, Japan, Germany
GET_B2B_PRODUCT_OPPORTUNITIES_NOT_YET_ON_AMAZON
B2B->Product Opportunities->Products Not Yet On Amazon
AccountHealthSellerPerformanceReport
GET_V2_SELLER_PERFORMANCE_REPORT
Performance->Account Health->Reports->Performance Over Time
PromotionsPerformanceReport
For Sellers registered on Amazon Brand Registry and with Selling Partner, Insights Selling Partner API role
GET_PROMOTION_PERFORMANCE_REPORT
Seller Central -> Advertising -> Deals
VATTransactionsReport
Germany, Spain, Italy, France, and UK
GET_VAT_TRANSACTION_DATA
Reports->Fullfillment->Tax->Amazon VAT Transactions Report
GSTMerchantTaxReportB2B
India Only
GET_GST_MTR_B2B_CUSTOM
Reports->Tax Documents Library->Merchant Tax Reports->B2B
GSTMerchantTaxReportB2C
India Only
GET_GST_MTR_B2C_CUSTOM
Reports->Tax Documents Library->Merchant Tax Reports->B2B
Click here for a detailed view of the Amazon SP - Seller Reports
Raw Data Tables
CatalogItems (This table cannot be added when any one of listed tables are added: CatalogItemsVariations, CatalogItemsSalesRank, CatalogItemsSummary)
List of ASINs IncludedData - attributes, dimensions, identifiers, images, productTypes, relationships, salesRanks, summaries
CatalogItemsSummary
List of ASINs IncludedData - Summaries
CatalogItemsVariations
List of ASINs IncludedData - Variations
CatalogItemsSalesRank
List of ASINs IncludedData - SalesRank
CatalogCategoriesForASIN
List of ASINs
CatalogCategoriesForSKU
List of SKUs
ListingsRestrictions
List of ASINs
FBAInventorySummary
details - true granularityType - Iterate Marketplaces granularityId - Iterate Marketplaces marketplaceIds - Iterate Marketplaces
ListFinancialEvents
None
ListFinancialEventsByGroupId
FinancialEventsGroupId - from ListFinancialEventGroups
ListFinancialEventGroups
None
InboundShipments
QueryType - DATE_RANGE, Next Token LastUpdatedAfter
InboundShipmentItems
QueryType - DATE_RANGE, Next Token LastUpdatedAfter
InboundShipmentsTransportDetails
QueryType - DATE_RANGE, Next Token LastUpdatedAfter
ListOrder
OrderStatuses - All Enums FulfillmentChannels - All Enums PaymentMethods - All Enums Check whether defaults give all statuses and channels.
ListOrderItems
GetCompetitivePricingForSKU
SKUs - List ItemType - SKU CustomerType
GetCompetitivePricingForASIN
ASIN - List ItemType - ASIN CustomerType
PricingForASIN
OfferType - Both B2B and B2C ItemType - SKU, List of ASINs
OrderMetricsDaily
granularity - Day
OrderMetricsHourly
granularity - Hour
GetMarketplaceParticipations
ListingsItemsSummary
IncludedData - Summaries
ListingsItemsIssues
IncludedData - Issues
ListingsRestrictions
ListingOffers
ItemCondition - All CustomerType - All
ListingOffersForASIN
ItemCondition - All CustomerType - All
APLusContentDocument
marketplaceIds, includedDataSet = CONTENT, contentReferenceKey
ListAllFulfillmentOrders
None
FeeEstimateForSKU
SellerInputIdentifier - skus
FeeEstimateForASIN
SellerInputIdentifier - asins
PricingForSKU
OfferType - Both B2B and B2C ItemType - SKU, List of SKUs
Last updated