Windsor brings all your Amazon Vendor Central data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Amazon Vendor Central Field Reference
Fields
ID | Type | Name | Description | Report |
---|---|---|---|---|
account_id | TEXT | Account ID | The account ID | |
account_name | TEXT | Account Name | The account name | |
datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
date | DATE | Date | Date of the report | |
day_of_month | TEXT | Day of month | Day of the month | |
marketplace_country | COUNTRY | Marketplace Country | The Marketplace Country | |
month | TEXT | Month | Number of the month | |
source | TEXT | Source | The name of the Windsor connector returning the row | |
today | DATE | Today | Today's date | |
vendor_forecasting_report__asin | TEXT | asin (get_vendor_forecasting_report) | asin (get_vendor_forecasting_report) | get_vendor_forecasting_report |
vendor_forecasting_report__enddate | DATE | endDate (get_vendor_forecasting_report) | endDate (get_vendor_forecasting_report) | get_vendor_forecasting_report |
vendor_forecasting_report__forecastgenerationdate | TEXT | forecastGenerationDate (get_vendor_forecasting_report) | forecastGenerationDate (get_vendor_forecasting_report) | get_vendor_forecasting_report |
vendor_forecasting_report__meanforecastunits | NUMERIC | meanForecastUnits (get_vendor_forecasting_report) | meanForecastUnits (get_vendor_forecasting_report) | get_vendor_forecasting_report |
vendor_forecasting_report__p70forecastunits | NUMERIC | p70ForecastUnits (get_vendor_forecasting_report) | p70ForecastUnits (get_vendor_forecasting_report) | get_vendor_forecasting_report |
vendor_forecasting_report__p80forecastunits | NUMERIC | p80ForecastUnits (get_vendor_forecasting_report) | p80ForecastUnits (get_vendor_forecasting_report) | get_vendor_forecasting_report |
vendor_forecasting_report__p90forecastunits | NUMERIC | p90ForecastUnits (get_vendor_forecasting_report) | p90ForecastUnits (get_vendor_forecasting_report) | get_vendor_forecasting_report |
vendor_forecasting_report__startdate | DATE | startDate (get_vendor_forecasting_report) | startDate (get_vendor_forecasting_report) | get_vendor_forecasting_report |
vendor_inventory_report__aged90plusdayssellableinventorycost_amount | NUMERIC | aged90PlusDaysSellableInventoryCost-amount (get_vendor_inventory_report) | aged90PlusDaysSellableInventoryCost-amount (get_vendor_inventory_report) | get_vendor_inventory_report |
vendor_inventory_report__aged90plusdayssellableinventorycost_currencycode | TEXT | aged90PlusDaysSellableInventoryCost-currencyCode (get_vendor_inventory_report) | aged90PlusDaysSellableInventoryCost-currencyCode (get_vendor_inventory_report) | get_vendor_inventory_report |
vendor_inventory_report__aged90plusdayssellableinventoryunits | NUMERIC | aged90PlusDaysSellableInventoryUnits (get_vendor_inventory_report) | aged90PlusDaysSellableInventoryUnits (get_vendor_inventory_report) | get_vendor_inventory_report |
vendor_inventory_report__asin | TEXT | asin (get_vendor_inventory_report) | asin (get_vendor_inventory_report) | get_vendor_inventory_report |
vendor_inventory_report__averagevendorleadtimedays | NUMERIC | averageVendorLeadTimeDays (get_vendor_inventory_report) | averageVendorLeadTimeDays (get_vendor_inventory_report) | get_vendor_inventory_report |
vendor_inventory_report__enddate | DATE | endDate (get_vendor_inventory_report) | endDate (get_vendor_inventory_report) | get_vendor_inventory_report |
vendor_inventory_report__netreceivedinventorycost_amount | NUMERIC | netReceivedInventoryCost-amount (get_vendor_inventory_report) | netReceivedInventoryCost-amount (get_vendor_inventory_report) | get_vendor_inventory_report |
vendor_inventory_report__netreceivedinventorycost_currencycode | TEXT | netReceivedInventoryCost-currencyCode (get_vendor_inventory_report) | netReceivedInventoryCost-currencyCode (get_vendor_inventory_report) | get_vendor_inventory_report |
vendor_inventory_report__netreceivedinventoryunits | NUMERIC | netReceivedInventoryUnits (get_vendor_inventory_report) | netReceivedInventoryUnits (get_vendor_inventory_report) | get_vendor_inventory_report |
vendor_inventory_report__openpurchaseorderunits | NUMERIC | openPurchaseOrderUnits (get_vendor_inventory_report) | openPurchaseOrderUnits (get_vendor_inventory_report) | get_vendor_inventory_report |
vendor_inventory_report__procurableproductoutofstockrate | NUMERIC | procurableProductOutOfStockRate (get_vendor_inventory_report) | procurableProductOutOfStockRate (get_vendor_inventory_report) | get_vendor_inventory_report |
vendor_inventory_report__receivefillrate | NUMERIC | receiveFillRate (get_vendor_inventory_report) | receiveFillRate (get_vendor_inventory_report) | get_vendor_inventory_report |
vendor_inventory_report__sellableonhandinventorycost_amount | NUMERIC | sellableOnHandInventoryCost-amount (get_vendor_inventory_report) | sellableOnHandInventoryCost-amount (get_vendor_inventory_report) | get_vendor_inventory_report |
vendor_inventory_report__sellableonhandinventorycost_currencycode | TEXT | sellableOnHandInventoryCost-currencyCode (get_vendor_inventory_report) | sellableOnHandInventoryCost-currencyCode (get_vendor_inventory_report) | get_vendor_inventory_report |
vendor_inventory_report__sellableonhandinventoryunits | NUMERIC | sellableOnHandInventoryUnits (get_vendor_inventory_report) | sellableOnHandInventoryUnits (get_vendor_inventory_report) | get_vendor_inventory_report |
vendor_inventory_report__sellthroughrate | NUMERIC | sellThroughRate (get_vendor_inventory_report) | sellThroughRate (get_vendor_inventory_report) | get_vendor_inventory_report |
vendor_inventory_report__startdate | DATE | startDate (get_vendor_inventory_report) | startDate (get_vendor_inventory_report) | get_vendor_inventory_report |
vendor_inventory_report__uft | NUMERIC | uft (get_vendor_inventory_report) | uft (get_vendor_inventory_report) | get_vendor_inventory_report |
vendor_inventory_report__unfilledcustomerorderedunits | NUMERIC | unfilledCustomerOrderedUnits (get_vendor_inventory_report) | unfilledCustomerOrderedUnits (get_vendor_inventory_report) | get_vendor_inventory_report |
vendor_inventory_report__unhealthyinventorycost_amount | NUMERIC | unhealthyInventoryCost-amount (get_vendor_inventory_report) | unhealthyInventoryCost-amount (get_vendor_inventory_report) | get_vendor_inventory_report |
vendor_inventory_report__unhealthyinventorycost_currencycode | TEXT | unhealthyInventoryCost-currencyCode (get_vendor_inventory_report) | unhealthyInventoryCost-currencyCode (get_vendor_inventory_report) | get_vendor_inventory_report |
vendor_inventory_report__unhealthyinventoryunits | NUMERIC | unhealthyInventoryUnits (get_vendor_inventory_report) | unhealthyInventoryUnits (get_vendor_inventory_report) | get_vendor_inventory_report |
vendor_inventory_report__unsellableonhandinventorycost_amount | NUMERIC | unsellableOnHandInventoryCost-amount (get_vendor_inventory_report) | unsellableOnHandInventoryCost-amount (get_vendor_inventory_report) | get_vendor_inventory_report |
vendor_inventory_report__unsellableonhandinventorycost_currencycode | TEXT | unsellableOnHandInventoryCost-currencyCode (get_vendor_inventory_report) | unsellableOnHandInventoryCost-currencyCode (get_vendor_inventory_report) | get_vendor_inventory_report |
vendor_inventory_report__unsellableonhandinventoryunits | NUMERIC | unsellableOnHandInventoryUnits (get_vendor_inventory_report) | unsellableOnHandInventoryUnits (get_vendor_inventory_report) | get_vendor_inventory_report |
vendor_inventory_report__vendorconfirmationrate | NUMERIC | vendorConfirmationRate (get_vendor_inventory_report) | vendorConfirmationRate (get_vendor_inventory_report) | get_vendor_inventory_report |
vendor_net_pure_product_margin_report__asin | TEXT | asin (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__enddate | DATE | endDate (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__netpureproductmargin | NUMERIC | netPureProductMargin (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__startdate | DATE | startDate (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__asin | TEXT | asin (get_vendor_real_time_sales_report) | asin (get_vendor_real_time_sales_report) | get_vendor_real_time_sales_report |
vendor_real_time_sales_report__endtime | TIMESTAMP | endTime (get_vendor_real_time_sales_report) | endTime (get_vendor_real_time_sales_report) | get_vendor_real_time_sales_report |
vendor_real_time_sales_report__orderedrevenue | NUMERIC | orderedRevenue (get_vendor_real_time_sales) | orderedRevenue (get_vendor_real_time_sales) | get_vendor_real_time_sales_report |
vendor_real_time_sales_report__orderedunits | NUMERIC | orderedUnits (get_vendor_real_time_sales_report) | orderedUnits (get_vendor_real_time_sales_report) | get_vendor_real_time_sales_report |
vendor_real_time_sales_report__starttime | TIMESTAMP | startTime (get_vendor_real_time_sales_report) | startTime (get_vendor_real_time_sales_report) | get_vendor_real_time_sales_report |
vendor_sales_report__asin | TEXT | asin (get_vendor_sales_report) | asin (get_vendor_sales_report) | get_vendor_sales_report |
vendor_sales_report__customerreturns | NUMERIC | customerReturns (get_vendor_sales_report) | customerReturns (get_vendor_sales_report) | get_vendor_sales_report |
vendor_sales_report__enddate | DATE | endDate (get_vendor_sales_report) | endDate (get_vendor_sales_report) | get_vendor_sales_report |
vendor_sales_report__orderedrevenue_amount | NUMERIC | orderedRevenue-amount (get_vendor_sales_report) | orderedRevenue-amount (get_vendor_sales_report) (Manufacturing) | get_vendor_sales_report |
vendor_sales_report__orderedrevenue_currencycode | TEXT | orderedRevenue-currencyCode (get_vendor_sales_report) | orderedRevenue-currencyCode (get_vendor_sales_report) (Manufacturing) | get_vendor_sales_report |
vendor_sales_report__orderedunits | NUMERIC | orderedUnits (get_vendor_sales_report) | orderedUnits (get_vendor_sales_report) (Manufacturing) | get_vendor_sales_report |
vendor_sales_report__shippedcogs_amount | NUMERIC | shippedCogs-amount (get_vendor_sales_report) | shippedCogs-amount (get_vendor_sales_report) | get_vendor_sales_report |
vendor_sales_report__shippedcogs_currencycode | TEXT | shippedCogs-currencyCode (get_vendor_sales_report) | shippedCogs-currencyCode (get_vendor_sales_report) | get_vendor_sales_report |
vendor_sales_report__shippedrevenue_amount | NUMERIC | shippedRevenue-amount (get_vendor_sales_report) | shippedRevenue-amount (get_vendor_sales_report) | get_vendor_sales_report |
vendor_sales_report__shippedrevenue_currencycode | TEXT | shippedRevenue-currencyCode (get_vendor_sales_report) | shippedRevenue-currencyCode (get_vendor_sales_report) | get_vendor_sales_report |
vendor_sales_report__shippedunits | NUMERIC | shippedUnits (get_vendor_sales_report) | shippedUnits (get_vendor_sales_report) | get_vendor_sales_report |
vendor_sales_report__startdate | DATE | startDate (get_vendor_sales_report) | startDate (get_vendor_sales_report) | get_vendor_sales_report |
vendor_traffic_report__asin | TEXT | asin (get_vendor_traffic_report) | asin (get_vendor_traffic_report) | get_vendor_traffic_report |
vendor_traffic_report__enddate | DATE | endDate (get_vendor_traffic_report) | endDate (get_vendor_traffic_report) | get_vendor_traffic_report |
vendor_traffic_report__glanceviews | NUMERIC | glanceViews (get_vendor_traffic_report) | glanceViews (get_vendor_traffic_report) | get_vendor_traffic_report |
vendor_traffic_report__startdate | DATE | startDate (get_vendor_traffic_report) | startDate (get_vendor_traffic_report) | get_vendor_traffic_report |
week | TEXT | Week | Week (Sun-Sat). | |
week_day | TEXT | Day of week and day number | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. | |
week_day_iso | TEXT | Day of week and day number, ISO | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 | |
week_iso | TEXT | Week ISO | Week, ISO format (Mon-Sun). | |
year | TEXT | Year | Year | |
year_month | TEXT | Yearmonth | Year and month, e.g. 2024|3 | |
year_of_week | TEXT | Year of week | The year that contains first day of the week (Sun-Sat). | |
year_of_week_iso | TEXT | Year of week, ISO | The year that contains first day of the ISO week (Mon-Sun). | |
year_week | TEXT | Year week | Year and week for US weeks (Sun-Sat), e.g. 2024|15 | |
year_week_iso | TEXT | Year week ISO | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |