Introduction

Datasources and destinations

Fields listing for Amazon Vendor Central

Normalized Date Day
Normalized day generated from the report date such as 02.
Field ID_NORMALIZED_DATE_FIELD_DAY
TypeDAY
Data Typedimension
Normalized Date Day Of Week
Normalized day of week generated from the report date such as 3.
Field ID_NORMALIZED_DATE_FIELD_DAY_OF_WEEK
TypeDAY_OF_WEEK
Data Typedimension
Hour of the day
Hour of the day
Field ID_NORMALIZED_DATE_FIELD_HOUR
TypeHOUR
Data Typedimension
Normalized Date Month
Normalized month generated from the report date such as 04.
Field ID_NORMALIZED_DATE_FIELD_MONTH
TypeMONTH
Data Typedimension
Normalized Date Month Day
Normalized month-day generated from the report date such as 0402.
Field ID_NORMALIZED_DATE_FIELD_MONTH_DAY
TypeMONTH_DAY
Data Typedimension
Normalized Date Quarter
Normalized quarter generated from the report date such as 2.
Field ID_NORMALIZED_DATE_FIELD_QUARTER
TypeQUARTER
Data Typedimension
Normalized Date Week
Normalized week generated from the report date such as 14.
Field ID_NORMALIZED_DATE_FIELD_WEEK
TypeWEEK
Data Typedimension
Normalized Date Week Start Sunday
Normalized Sunday-based week generated from the report date such as 14.
Field ID_NORMALIZED_DATE_FIELD_WEEK_START_SUNDAY
TypeWEEK
Data Typedimension
Normalized Date Year
Normalized year generated from the report date such as 2025.
Field ID_NORMALIZED_DATE_FIELD_YEAR
TypeYEAR
Data Typedimension
Normalized Date Year Month
Normalized year-month generated from the report date such as 202504.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH
TypeYEAR_MONTH
Data Typedimension
Normalized Date Year Month Day
Normalized calendar date generated from the report date such as 20250402.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY
TypeYEAR_MONTH_DAY
Data Typedimension
Year month day hour
Year, month, day, and hour.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR
TypeYEAR_MONTH_DAY_HOUR
Data Typedimension
Normalized Date Year Quarter
Normalized year-quarter generated from the report date such as 20252.
Field ID_NORMALIZED_DATE_FIELD_YEAR_QUARTER
TypeYEAR_QUARTER
Data Typedimension
Normalized Date Year Week
Normalized ISO year-week generated from the report date such as 202514.
Field ID_NORMALIZED_DATE_FIELD_YEAR_WEEK
TypeYEAR_WEEK
Data Typedimension
Aged 90 Plus Days Sellable Inventory Cost Amount
Sellable inventory cost older than ninety days such as 450.00.
Field IDaged90PlusDaysSellableInventoryCost.amount
TypeNUMBER
Data Typemetric
Aged 90 Plus Days Sellable Inventory Cost Currency Code
Sellable inventory cost currency code older than ninety days such as USD.
Field IDaged90PlusDaysSellableInventoryCost.currencyCode
TypeTEXT
Data Typedimension
Aged 90 Plus Days Sellable Inventory Units
Sellable inventory units older than ninety days such as 11.
Field IDaged90PlusDaysSellableInventoryUnits
TypeNUMBER
Data Typemetric
Asin
Amazon Standard Identification Number such as B012345678.
Field IDasin
TypeTEXT
Data Typedimension
Average Vendor Lead Time Days
Average vendor lead time in days such as 18.
Field IDaverageVendorLeadTimeDays
TypeNUMBER
Data Typemetric
Customer Returns
Units returned by customers such as 12.
Field IDcustomerReturns
TypeNUMBER
Data Typemetric
Distributor View
Requested distributor view such as SOURCING when supported by the selected report.
Field IDdistributorView
TypeTEXT
Data Typedimension
End Date
Report end date such as 2025-04-01.
Field IDendDate
TypeYEAR_MONTH_DAY
Data Typedimension
Forecast Generation Date
Forecast snapshot date such as 2025-04-02.
Field IDforecastGenerationDate
TypeYEAR_MONTH_DAY
Data Typedimension
Glance Views
Product glance views such as 4500.
Field IDglanceViews
TypeNUMBER
Data Typemetric
Marketplace Id
Amazon marketplace id such as ATVPDKIKX0DER.
Field IDmarketplaceId
TypeTEXT
Data Typedimension
Marketplace Name
Amazon marketplace label such as United States of America.
Field IDmarketplaceName
TypeTEXT
Data Typedimension
Mean Forecast Units
Mean forecast units such as 340.
Field IDmeanForecastUnits
TypeNUMBER
Data Typemetric
Net Pure Product Margin
Net pure product margin percentage such as 22.4.
Field IDnetPureProductMargin
TypePERCENT
Data Typemetric
Net Received Inventory Cost Amount
Net received inventory cost amount such as 4520.10.
Field IDnetReceivedInventoryCost.amount
TypeNUMBER
Data Typemetric
Net Received Inventory Cost Currency Code
Net received inventory cost currency code such as USD.
Field IDnetReceivedInventoryCost.currencyCode
TypeTEXT
Data Typedimension
Net Received Inventory Units
Net received inventory units such as 145.
Field IDnetReceivedInventoryUnits
TypeNUMBER
Data Typemetric
Open Purchase Order Units
Open purchase order units such as 37.
Field IDopenPurchaseOrderUnits
TypeNUMBER
Data Typemetric
Ordered Revenue Amount
Ordered revenue amount such as 1532.45.
Field IDorderedRevenue.amount
TypeNUMBER
Data Typemetric
Ordered Revenue Currency Code
Ordered revenue currency code such as USD.
Field IDorderedRevenue.currencyCode
TypeTEXT
Data Typedimension
Ordered Units
Units ordered such as 87.
Field IDorderedUnits
TypeNUMBER
Data Typemetric
P70 Forecast Units
P70 forecast units such as 360.
Field IDp70ForecastUnits
TypeNUMBER
Data Typemetric
P80 Forecast Units
P80 forecast units such as 380.
Field IDp80ForecastUnits
TypeNUMBER
Data Typemetric
P90 Forecast Units
P90 forecast units such as 410.
Field IDp90ForecastUnits
TypeNUMBER
Data Typemetric
Procurable Product Out Of Stock Rate
Out of stock rate for procurable products such as 4.3.
Field IDprocurableProductOutOfStockRate
TypePERCENT
Data Typemetric
Receive Fill Rate
Receive fill rate such as 92.1.
Field IDreceiveFillRate
TypePERCENT
Data Typemetric
Report Level
Level emitted from the report payload such as aggregate or asin.
Field IDreportLevel
TypeTEXT
Data Typedimension
Report Name
Human label for the selected report such as Vendor Sales.
Field IDreportName
TypeTEXT
Data Typedimension
Report Period
Requested report period such as DAY or MONTH when supported by the selected report.
Field IDreportPeriod
TypeTEXT
Data Typedimension
Report Type
Amazon report type identifier such as GET_VENDOR_SALES_REPORT.
Field IDreportType
TypeTEXT
Data Typedimension
Sell Through Rate
Sell through rate such as 15.9.
Field IDsellThroughRate
TypePERCENT
Data Typemetric
Sellable On Hand Inventory Cost Amount
Sellable on-hand inventory cost amount such as 3100.50.
Field IDsellableOnHandInventoryCost.amount
TypeNUMBER
Data Typemetric
Sellable On Hand Inventory Cost Currency Code
Sellable on-hand inventory cost currency code such as USD.
Field IDsellableOnHandInventoryCost.currencyCode
TypeTEXT
Data Typedimension
Sellable On Hand Inventory Units
Sellable on-hand inventory units such as 88.
Field IDsellableOnHandInventoryUnits
TypeNUMBER
Data Typemetric
Selling Program
Requested selling program such as RETAIL when supported by the selected report.
Field IDsellingProgram
TypeTEXT
Data Typedimension
Shipped Cogs Amount
Shipped cost of goods sold amount such as 922.10.
Field IDshippedCogs.amount
TypeNUMBER
Data Typemetric
Shipped Cogs Currency Code
Shipped cost of goods sold currency code such as USD.
Field IDshippedCogs.currencyCode
TypeTEXT
Data Typedimension
Shipped Revenue Amount
Shipped revenue amount such as 1418.77.
Field IDshippedRevenue.amount
TypeNUMBER
Data Typemetric
Shipped Revenue Currency Code
Shipped revenue currency code such as USD.
Field IDshippedRevenue.currencyCode
TypeTEXT
Data Typedimension
Shipped Units
Units shipped such as 80.
Field IDshippedUnits
TypeNUMBER
Data Typemetric
Start Date
Report start date such as 2025-04-01.
Field IDstartDate
TypeYEAR_MONTH_DAY
Data Typedimension
Uft
Unfilled fill metric such as 96.8.
Field IDuft
TypePERCENT
Data Typemetric
Unfilled Customer Ordered Units
Customer ordered units that could not be fulfilled such as 9.
Field IDunfilledCustomerOrderedUnits
TypeNUMBER
Data Typemetric
Unhealthy Inventory Cost Amount
Unhealthy inventory cost amount such as 210.20.
Field IDunhealthyInventoryCost.amount
TypeNUMBER
Data Typemetric
Unhealthy Inventory Cost Currency Code
Unhealthy inventory cost currency code such as USD.
Field IDunhealthyInventoryCost.currencyCode
TypeTEXT
Data Typedimension
Unhealthy Inventory Units
Unhealthy inventory units such as 7.
Field IDunhealthyInventoryUnits
TypeNUMBER
Data Typemetric
Unsellable On Hand Inventory Cost Amount
Unsellable on-hand inventory cost amount such as 120.75.
Field IDunsellableOnHandInventoryCost.amount
TypeNUMBER
Data Typemetric
Unsellable On Hand Inventory Cost Currency Code
Unsellable on-hand inventory cost currency code such as USD.
Field IDunsellableOnHandInventoryCost.currencyCode
TypeTEXT
Data Typedimension
Unsellable On Hand Inventory Units
Unsellable on-hand inventory units such as 3.
Field IDunsellableOnHandInventoryUnits
TypeNUMBER
Data Typemetric
Vendor Confirmation Rate
Vendor confirmation rate such as 98.4.
Field IDvendorConfirmationRate
TypePERCENT
Data Typemetric