Field group | Field | Type | Data type | Description |
---|---|---|---|---|
Sales | Units | METRIC | INTEGER | The number of units in orders |
Sales | Order Items | METRIC | INTEGER | The number of order items |
Sales | Orders | METRIC | INTEGER | The number of orders |
Sales | Avg Unit Price | METRIC | FLOAT | The average price for an item |
Sales | Total Sales | METRIC | FLOAT | The total ordered product sales for all orders |
Inventory | Fulfillable Quantity | METRIC | INTEGER | The item quantity that can be picked, packed, and shipped |
Inventory | Inbound Working Quantity | METRIC | INTEGER | The number of units in an inbound shipment for which you have notified Amazon |
Inventory | Inbound Shipped Quantity | METRIC | INTEGER | The number of units in an inbound shipment that you have notified Amazon about and have provided a tracking number |
Inventory | Inbound Receiving Quantity | METRIC | INTEGER | The number of units that have not yet been received at an Amazon fulfillment center for processing, but are part of an inbound shipment with some units that have already been received and processed |
Inventory | Total Reserved Quantity | METRIC | INTEGER | The total number of units in Amazon's fulfillment network that are currently being picked, packed, and shipped; or are sidelined for measurement, sampling, or other internal processes |
Inventory | Pending Customer Order Quantity | METRIC | INTEGER | The number of units reserved for customer orders |
Inventory | Pending Trans Shipment Quantity | METRIC | INTEGER | The number of units being transferred from one fulfillment center to another |
Inventory | FC Processing Quantity | METRIC | INTEGER | The number of units that have been sidelined at the fulfillment center for additional processing |
Inventory | Researching Quantity | METRIC | INTEGER | The total number of units currently being researched in Amazon's fulfillment network |
Inventory | Unfulfillable Quantity | METRIC | INTEGER | The total number of units in Amazon's fulfillment network in unsellable condition |
Inventory | Customer Damaged Quantity | METRIC | INTEGER | The number of units in customer damaged disposition |
Inventory | Warehouse Damaged Quantity | METRIC | INTEGER | The number of units in warehouse damaged disposition |
Inventory | Distributor Damaged Quantity | METRIC | INTEGER | The number of units in distributor damaged disposition |
Inventory | Carrier Damaged Quantity | METRIC | INTEGER | The number of units in carrier damaged disposition |
Inventory | Defective Quantity | METRIC | INTEGER | The number of units in defective disposition |
Inventory | Expired Quantity | METRIC | INTEGER | The number of units in expired disposition |
Inventory | Total Quantity | METRIC | INTEGER | Total quantity |
Order | Total Amount | METRIC | FLOAT | The total charge for this order |
Order | Shipped Items | METRIC | INTEGER | The number of items shipped |
Order | Unshipped Items | METRIC | INTEGER | The number of items unshipped |
Marketplace | Marketplace ID | DIMENSION | STRING | The encrypted unique ID of the marketplace |
Marketplace | Marketplace name | DIMENSION | STRING | The name of the marketplace |
Marketplace | Marketplace host name | DIMENSION | URL | The host name of the marketplace |
Marketplace | Marketplace country code | DIMENSION | COUNTRY_CODE | The country code of the marketplace |
Sales | Currency Code (Avg unit price) | DIMENSION | STRING | Three-digit currency code of average unit price. In ISO 4217 format |
Sales | Currency Code (Total sales) | DIMENSION | STRING | Three-digit currency code of total sales. In ISO 4217 format |
Inventory | ASIN | DIMENSION | STRING | The Amazon Standard Identification Number (ASIN) of the item |
Inventory | fn SKU | DIMENSION | STRING | A unique identifier assigned by Amazon to products stored in and fulfilled from an Amazon fulfillment center |
Inventory | Seller SKU | DIMENSION | STRING | The stock keeping unit (SKU) of the item |
Inventory | Item Condition | DIMENSION | STRING | The condition of the item |
Inventory | Product Name | DIMENSION | STRING | Product name |
Order | Amazon Order Id | DIMENSION | STRING | An Amazon-defined order identifier, in 3-7-7 format |
Order | Seller Order Id | DIMENSION | STRING | A seller-defined order identifier |
Order | Purchase Datetime | DIMENSION | DATETIME | The date when the order was created |
Order | Last Update Datetime | DIMENSION | DATETIME | The date when the order was last updated |
Order | Order Status | DIMENSION | STRING | The current order status. (Pending,Unshipped,PartiallyShipped,Shipped,Canceled,Unfulfillable,InvoiceUnconfirmed,PendingAvailability) |
Order | Sales Channel | DIMENSION | STRING | The sales channel of the first item in the order |
Order | Order Channel | DIMENSION | STRING | The order channel of the first item in the order |
Order | Shipment Service Level | DIMENSION | STRING | The shipment service level of the order |
Order | Payment Method | DIMENSION | STRING | The payment method for the order (COD - Cash On Delivery,CVS - Convenience Store or Other) |
Order | Shipment Service Level Category | DIMENSION | STRING | The shipment service level category of the order (Possible values: Expedited, FreeEconomy, NextDay, SameDay, SecondDay, Scheduled, Standard) |
Order | Shipping Label (CBA) | DIMENSION | STRING | Custom shipping label for Checkout by Amazon (CBA) |
Order | Order Type | DIMENSION | STRING | The type of the order (StandardOrder,LongLeadTimeOrder,Preorder,BackOrder or SourcingOnDemandOrder) |
Order | Earliest Ship Datetime | DIMENSION | DATETIME | The start of the time period within which you have committed to ship the order. In ISO 8601 date time format. Returned only for seller-fulfilled orders |
Order | Latest Ship Datetime | DIMENSION | DATETIME | The end of the time period within which you have committed to ship the order. In ISO 8601 date time format. Returned only for seller-fulfilled orders |
Order | Earliest Delivery Datetime | DIMENSION | DATETIME | The start of the time period within which you have committed to fulfill the order. In ISO 8601 date time format. Returned only for seller-fulfilled orders |
Order | Latest Delivery Datetime | DIMENSION | DATETIME | The end of the time period within which you have committed to fulfill the order. In ISO 8601 date time format. Returned only for seller-fulfilled orders that do not have a PendingAvailability, Pending, or Canceled status |
Order | Estimated Shipping Date | DIMENSION | DATETIME | Indicates the date by which the seller must respond to the buyer with an estimated ship date. Returned only for Sourcing on Demand orders |
Order | Is Business Order | DIMENSION | BOOLEAN | When true, the order is an Amazon Business order. An Amazon Business order is an order where the buyer is a Verified Business Buyer |
Order | Is Prime | DIMENSION | BOOLEAN | When true, the order is a seller-fulfilled Amazon Prime order |
Order | Is Premium Order | DIMENSION | BOOLEAN | When true, the order has a Premium Shipping Service Level Agreement |
Order | Is Global Express Enabled | DIMENSION | BOOLEAN | When true, the order is a GlobalExpress order |
Order | Replacement Order Id | DIMENSION | STRING | The order ID value for the order that is being replaced. Returned only if IsReplacementOrder = true |
Order | Is Replacement Order | DIMENSION | BOOLEAN | When true, this is a replacement order |
Order | Is Shipping Date Set | DIMENSION | BOOLEAN | When true, the estimated shipping date is set for the order. Returned only for Sourcing on Demand orders |
Order | Is Sold By AB | DIMENSION | BOOLEAN | When true, the item within this order was bought and re-sold by Amazon Business EU SARL (ABEU). By buying and instantly re-selling your items, ABEU becomes the seller of record, making your inventory available for sale to customers who would not otherwise purchase from a third-party seller |
Order | Fulfillment Supply SourceId | DIMENSION | STRING | Denotes the recommended sourceId where the order should be fulfilled from |
Order | Is Store Pickup | DIMENSION | BOOLEAN | When true, this order is marked to be picked up from a store rather than delivered |
Order | Currency Code (Order Amount) | DIMENSION | STRING | The three-digit currency code |
Order | Payment Method Details | DIMENSION | STRING | A list of payment method detail items |
Order | Shipping From Location | DIMENSION | STRING | The recommended location name for the seller to ship the items from. It is calculated at checkout. |
Order | Shipping From AddressLine2 | DIMENSION | STRING | The recommended location addressline for the seller to ship the items from. It is calculated at checkout. |
Order | Shipping From AddressLine2 | DIMENSION | STRING | The recommended location addressline for the seller to ship the items from. It is calculated at checkout. |
Order | Shipping From AddressLine3 | DIMENSION | STRING | The recommended location addressline for the seller to ship the items from. It is calculated at checkout. |
Order | Shipping From City | DIMENSION | STRING | The recommended location city for the seller to ship the items from. It is calculated at checkout. |
Order | Shipping From Country | DIMENSION | STRING | The recommended location country for the seller to ship the items from. It is calculated at checkout. |
Order | Shipping From District | DIMENSION | STRING | The recommended location district for the seller to ship the items from. It is calculated at checkout. |
Order | Shipping From State or Region | DIMENSION | STRING | The recommended location state or region for the seller to ship the items from. It is calculated at checkout. |
Order | Shipping From Municipality | DIMENSION | STRING | The recommended location municipality for the seller to ship the items from. It is calculated at checkout. |
Order | Shipping From PostalCode | DIMENSION | STRING | The recommended location postal code for the seller to ship the items from. It is calculated at checkout. |
Order | Country Code (Shipping From Location) | DIMENSION | STRING | The recommended location country code for the seller to ship the items from. It is calculated at checkout. |
Order | Phone number (Shipping From Location) | DIMENSION | STRING | The recommended location contact no for the seller to ship the items from. It is calculated at checkout. |
Order | Shipping From Address-type | DIMENSION | STRING | The recommended location address type for the seller to ship the items from. It is calculated at checkout. |