Windsor brings all your Amazon Vendor Central data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, TableauPostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL

Amazon Vendor Central Field Reference


Fields

IDTypeNameDescriptionReport
account_idTEXTAccount IDThe account ID
account_nameTEXTAccount NameThe account name
datasourceTEXTData SourceThe name of the Windsor connector returning the row
dateDATEDateDate of the report
day_of_monthTEXTDay of monthDay of the month
marketplace_countryCOUNTRYMarketplace CountryThe Marketplace Country
monthTEXTMonthNumber of the month
sourceTEXTSourceThe name of the Windsor connector returning the row
todayDATETodayToday's date
vendor_forecasting_report__asinTEXTasin (get_vendor_forecasting_report)asin (get_vendor_forecasting_report)get_vendor_forecasting_report
vendor_forecasting_report__enddateDATEendDate (get_vendor_forecasting_report)endDate (get_vendor_forecasting_report)get_vendor_forecasting_report
vendor_forecasting_report__forecastgenerationdateTEXTforecastGenerationDate (get_vendor_forecasting_report)forecastGenerationDate (get_vendor_forecasting_report)get_vendor_forecasting_report
vendor_forecasting_report__meanforecastunitsNUMERICmeanForecastUnits (get_vendor_forecasting_report)meanForecastUnits (get_vendor_forecasting_report)get_vendor_forecasting_report
vendor_forecasting_report__p70forecastunitsNUMERICp70ForecastUnits (get_vendor_forecasting_report)p70ForecastUnits (get_vendor_forecasting_report)get_vendor_forecasting_report
vendor_forecasting_report__p80forecastunitsNUMERICp80ForecastUnits (get_vendor_forecasting_report)p80ForecastUnits (get_vendor_forecasting_report)get_vendor_forecasting_report
vendor_forecasting_report__p90forecastunitsNUMERICp90ForecastUnits (get_vendor_forecasting_report)p90ForecastUnits (get_vendor_forecasting_report)get_vendor_forecasting_report
vendor_forecasting_report__startdateDATEstartDate (get_vendor_forecasting_report)startDate (get_vendor_forecasting_report)get_vendor_forecasting_report
vendor_inventory_report__aged90plusdayssellableinventorycost_amountNUMERICaged90PlusDaysSellableInventoryCost-amount (get_vendor_inventory_report)aged90PlusDaysSellableInventoryCost-amount (get_vendor_inventory_report)get_vendor_inventory_report
vendor_inventory_report__aged90plusdayssellableinventorycost_currencycodeTEXTaged90PlusDaysSellableInventoryCost-currencyCode (get_vendor_inventory_report)aged90PlusDaysSellableInventoryCost-currencyCode (get_vendor_inventory_report)get_vendor_inventory_report
vendor_inventory_report__aged90plusdayssellableinventoryunitsNUMERICaged90PlusDaysSellableInventoryUnits (get_vendor_inventory_report)aged90PlusDaysSellableInventoryUnits (get_vendor_inventory_report)get_vendor_inventory_report
vendor_inventory_report__asinTEXTasin (get_vendor_inventory_report)asin (get_vendor_inventory_report)get_vendor_inventory_report
vendor_inventory_report__averagevendorleadtimedaysNUMERICaverageVendorLeadTimeDays (get_vendor_inventory_report)averageVendorLeadTimeDays (get_vendor_inventory_report)get_vendor_inventory_report
vendor_inventory_report__enddateDATEendDate (get_vendor_inventory_report)endDate (get_vendor_inventory_report)get_vendor_inventory_report
vendor_inventory_report__netreceivedinventorycost_amountNUMERICnetReceivedInventoryCost-amount (get_vendor_inventory_report)netReceivedInventoryCost-amount (get_vendor_inventory_report)get_vendor_inventory_report
vendor_inventory_report__netreceivedinventorycost_currencycodeTEXTnetReceivedInventoryCost-currencyCode (get_vendor_inventory_report)netReceivedInventoryCost-currencyCode (get_vendor_inventory_report)get_vendor_inventory_report
vendor_inventory_report__netreceivedinventoryunitsNUMERICnetReceivedInventoryUnits (get_vendor_inventory_report)netReceivedInventoryUnits (get_vendor_inventory_report)get_vendor_inventory_report
vendor_inventory_report__openpurchaseorderunitsNUMERICopenPurchaseOrderUnits (get_vendor_inventory_report)openPurchaseOrderUnits (get_vendor_inventory_report)get_vendor_inventory_report
vendor_inventory_report__procurableproductoutofstockrateNUMERICprocurableProductOutOfStockRate (get_vendor_inventory_report)procurableProductOutOfStockRate (get_vendor_inventory_report)get_vendor_inventory_report
vendor_inventory_report__receivefillrateNUMERICreceiveFillRate (get_vendor_inventory_report)receiveFillRate (get_vendor_inventory_report)get_vendor_inventory_report
vendor_inventory_report__sellableonhandinventorycost_amountNUMERICsellableOnHandInventoryCost-amount (get_vendor_inventory_report)sellableOnHandInventoryCost-amount (get_vendor_inventory_report)get_vendor_inventory_report
vendor_inventory_report__sellableonhandinventorycost_currencycodeTEXTsellableOnHandInventoryCost-currencyCode (get_vendor_inventory_report)sellableOnHandInventoryCost-currencyCode (get_vendor_inventory_report)get_vendor_inventory_report
vendor_inventory_report__sellableonhandinventoryunitsNUMERICsellableOnHandInventoryUnits (get_vendor_inventory_report)sellableOnHandInventoryUnits (get_vendor_inventory_report)get_vendor_inventory_report
vendor_inventory_report__sellthroughrateNUMERICsellThroughRate (get_vendor_inventory_report)sellThroughRate (get_vendor_inventory_report)get_vendor_inventory_report
vendor_inventory_report__startdateDATEstartDate (get_vendor_inventory_report)startDate (get_vendor_inventory_report)get_vendor_inventory_report
vendor_inventory_report__uftNUMERICuft (get_vendor_inventory_report)uft (get_vendor_inventory_report)get_vendor_inventory_report
vendor_inventory_report__unfilledcustomerorderedunitsNUMERICunfilledCustomerOrderedUnits (get_vendor_inventory_report)unfilledCustomerOrderedUnits (get_vendor_inventory_report)get_vendor_inventory_report
vendor_inventory_report__unhealthyinventorycost_amountNUMERICunhealthyInventoryCost-amount (get_vendor_inventory_report)unhealthyInventoryCost-amount (get_vendor_inventory_report)get_vendor_inventory_report
vendor_inventory_report__unhealthyinventorycost_currencycodeTEXTunhealthyInventoryCost-currencyCode (get_vendor_inventory_report)unhealthyInventoryCost-currencyCode (get_vendor_inventory_report)get_vendor_inventory_report
vendor_inventory_report__unhealthyinventoryunitsNUMERICunhealthyInventoryUnits (get_vendor_inventory_report)unhealthyInventoryUnits (get_vendor_inventory_report)get_vendor_inventory_report
vendor_inventory_report__unsellableonhandinventorycost_amountNUMERICunsellableOnHandInventoryCost-amount (get_vendor_inventory_report)unsellableOnHandInventoryCost-amount (get_vendor_inventory_report)get_vendor_inventory_report
vendor_inventory_report__unsellableonhandinventorycost_currencycodeTEXTunsellableOnHandInventoryCost-currencyCode (get_vendor_inventory_report)unsellableOnHandInventoryCost-currencyCode (get_vendor_inventory_report)get_vendor_inventory_report
vendor_inventory_report__unsellableonhandinventoryunitsNUMERICunsellableOnHandInventoryUnits (get_vendor_inventory_report)unsellableOnHandInventoryUnits (get_vendor_inventory_report)get_vendor_inventory_report
vendor_inventory_report__vendorconfirmationrateNUMERICvendorConfirmationRate (get_vendor_inventory_report)vendorConfirmationRate (get_vendor_inventory_report)get_vendor_inventory_report
vendor_net_pure_product_margin_report__asinTEXTasin (get_vendor_net_pure_product_margin_report)asin (get_vendor_net_pure_product_margin_report)get_vendor_net_pure_product_margin_report
vendor_net_pure_product_margin_report__enddateDATEendDate (get_vendor_net_pure_product_margin_report)endDate (get_vendor_net_pure_product_margin_report)get_vendor_net_pure_product_margin_report
vendor_net_pure_product_margin_report__netpureproductmarginNUMERICnetPureProductMargin (get_vendor_net_pure_product_margin_report)netPureProductMargin (get_vendor_net_pure_product_margin_report)get_vendor_net_pure_product_margin_report
vendor_net_pure_product_margin_report__startdateDATEstartDate (get_vendor_net_pure_product_margin_report)startDate (get_vendor_net_pure_product_margin_report)get_vendor_net_pure_product_margin_report
vendor_real_time_sales_report__asinTEXTasin (get_vendor_real_time_sales_report)asin (get_vendor_real_time_sales_report)get_vendor_real_time_sales_report
vendor_real_time_sales_report__endtimeTIMESTAMPendTime (get_vendor_real_time_sales_report)endTime (get_vendor_real_time_sales_report)get_vendor_real_time_sales_report
vendor_real_time_sales_report__orderedrevenueNUMERICorderedRevenue (get_vendor_real_time_sales)orderedRevenue (get_vendor_real_time_sales)get_vendor_real_time_sales_report
vendor_real_time_sales_report__orderedunitsNUMERICorderedUnits (get_vendor_real_time_sales_report)orderedUnits (get_vendor_real_time_sales_report)get_vendor_real_time_sales_report
vendor_real_time_sales_report__starttimeTIMESTAMPstartTime (get_vendor_real_time_sales_report)startTime (get_vendor_real_time_sales_report)get_vendor_real_time_sales_report
vendor_sales_report__asinTEXTasin (get_vendor_sales_report)asin (get_vendor_sales_report)get_vendor_sales_report
vendor_sales_report__customerreturnsNUMERICcustomerReturns (get_vendor_sales_report)customerReturns (get_vendor_sales_report)get_vendor_sales_report
vendor_sales_report__enddateDATEendDate (get_vendor_sales_report)endDate (get_vendor_sales_report)get_vendor_sales_report
vendor_sales_report__orderedrevenue_amountNUMERICorderedRevenue-amount (get_vendor_sales_report)orderedRevenue-amount (get_vendor_sales_report) (Manufacturing)get_vendor_sales_report
vendor_sales_report__orderedrevenue_currencycodeTEXTorderedRevenue-currencyCode (get_vendor_sales_report)orderedRevenue-currencyCode (get_vendor_sales_report) (Manufacturing)get_vendor_sales_report
vendor_sales_report__orderedunitsNUMERICorderedUnits (get_vendor_sales_report)orderedUnits (get_vendor_sales_report) (Manufacturing)get_vendor_sales_report
vendor_sales_report__shippedcogs_amountNUMERICshippedCogs-amount (get_vendor_sales_report)shippedCogs-amount (get_vendor_sales_report)get_vendor_sales_report
vendor_sales_report__shippedcogs_currencycodeTEXTshippedCogs-currencyCode (get_vendor_sales_report)shippedCogs-currencyCode (get_vendor_sales_report)get_vendor_sales_report
vendor_sales_report__shippedrevenue_amountNUMERICshippedRevenue-amount (get_vendor_sales_report)shippedRevenue-amount (get_vendor_sales_report)get_vendor_sales_report
vendor_sales_report__shippedrevenue_currencycodeTEXTshippedRevenue-currencyCode (get_vendor_sales_report)shippedRevenue-currencyCode (get_vendor_sales_report)get_vendor_sales_report
vendor_sales_report__shippedunitsNUMERICshippedUnits (get_vendor_sales_report)shippedUnits (get_vendor_sales_report)get_vendor_sales_report
vendor_sales_report__startdateDATEstartDate (get_vendor_sales_report)startDate (get_vendor_sales_report)get_vendor_sales_report
vendor_traffic_report__asinTEXTasin (get_vendor_traffic_report)asin (get_vendor_traffic_report)get_vendor_traffic_report
vendor_traffic_report__enddateDATEendDate (get_vendor_traffic_report)endDate (get_vendor_traffic_report)get_vendor_traffic_report
vendor_traffic_report__glanceviewsNUMERICglanceViews (get_vendor_traffic_report)glanceViews (get_vendor_traffic_report)get_vendor_traffic_report
vendor_traffic_report__startdateDATEstartDate (get_vendor_traffic_report)startDate (get_vendor_traffic_report)get_vendor_traffic_report
weekTEXTWeekWeek (Sun-Sat).
week_dayTEXTDay of week and day numberWeekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_isoTEXTDay of week and day number, ISOWeekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_isoTEXTWeek ISOWeek, ISO format (Mon-Sun).
yearTEXTYearYear
year_monthTEXTYearmonthYear and month, e.g. 2024|3
year_of_weekTEXTYear of weekThe year that contains first day of the week (Sun-Sat).
year_of_week_isoTEXTYear of week, ISOThe year that contains first day of the ISO week (Mon-Sun).
year_weekTEXTYear weekYear and week for US weeks (Sun-Sat), e.g. 2024|15
year_week_isoTEXTYear week ISOYear and week for ISO weeks (Mon-Sun), e.g. 2024|20