Amazon Seller Central (Amazon SP) Field Reference
Sample
https://connectors.windsor.ai/amazon_sp?api_key=[your API key]&date_preset=last_7d&fields=date,account_id,order_channel,order_status
The Amazon Seller Central / Amazon SP connector lets you pull Amazon Seller Central data on a transaction level. If you specify the fields
date_from and date_to it will filter for a date range in which the products were purchased.Sample query for the Amazon Sales and Traffic Report By ASIN
https://connectors.windsor.ai/amazon_sp?api_key=[your API key]&date_preset=last_28d&fields=date,account_name,sales_and_traffic_report_by_date__trafficbyasin_browserpageviews,sales_and_traffic_report_by_date__trafficbyasin_mobileapppageviews,sales_and_traffic_report_by_date__trafficbyasin_pageviews,sales_and_traffic_report_by_date__trafficbyasin_browsersessions,sales_and_traffic_report_by_date__trafficbyasin_mobileappsessions,sales_and_traffic_report_by_date__trafficbyasin_sessions,sales_and_traffic_report_by_date__parentasin,sales_and_traffic_report_by_date__childasin
Sample query for the Amazon Sales and Traffic Report
https://connectors.windsor.ai/amazon_sp?api_key=[your API key]&date_preset=last_28d&fields=date,account_name,sales_and_traffic_report_by_date__date,sales_and_traffic_report_by_date__salesbydate_averagesalesperorderitem_amount,sales_and_traffic_report_by_date__salesbydate_averagesalesperorderitem_currencycode,sales_and_traffic_report_by_date__salesbydate_averagesalesperorderitemb2b_amount,sales_and_traffic_report_by_date__salesbydate_averagesalesperorderitemb2b_currencycode,sales_and_traffic_report_by_date__salesbydate_averagesellingprice_amount,sales_and_traffic_report_by_date__salesbydate_averagesellingprice_currencycode,sales_and_traffic_report_by_date__salesbydate_averagesellingpriceb2b_amount,sales_and_traffic_report_by_date__salesbydate_averagesellingpriceb2b_currencycode,sales_and_traffic_report_by_date__salesbydate_averageunitsperorderitem,sales_and_traffic_report_by_date__salesbydate_averageunitsperorderitemb2b,sales_and_traffic_report_by_date__salesbydate_claimsamount_amount,sales_and_traffic_report_by_date__salesbydate_claimsamount_currencycode,sales_and_traffic_report_by_date__salesbydate_claimsgranted,sales_and_traffic_report_by_date__salesbydate_orderedproductsales_amount,sales_and_traffic_report_by_date__salesbydate_orderedproductsales_currencycode,sales_and_traffic_report_by_date__salesbydate_orderedproductsalesb2b_amount,sales_and_traffic_report_by_date__salesbydate_orderedproductsalesb2b_currencycode,sales_and_traffic_report_by_date__salesbydate_ordersshipped,sales_and_traffic_report_by_date__salesbydate_refundrate,sales_and_traffic_report_by_date__salesbydate_shippedproductsales_amount,sales_and_traffic_report_by_date__salesbydate_shippedproductsales_currencycode,sales_and_traffic_report_by_date__salesbydate_totalorderitems,sales_and_traffic_report_by_date__salesbydate_totalorderitemsb2b,sales_and_traffic_report_by_date__salesbydate_unitsordered,sales_and_traffic_report_by_date__salesbydate_unitsorderedb2b,sales_and_traffic_report_by_date__salesbydate_unitsrefunded,sales_and_traffic_report_by_date__salesbydate_unitsshipped,sales_and_traffic_report_by_date__trafficbydate_averageoffercount,sales_and_traffic_report_by_date__trafficbydate_averageparentitems,sales_and_traffic_report_by_date__trafficbydate_browserpageviews,sales_and_traffic_report_by_date__trafficbydate_browsersessions,sales_and_traffic_report_by_date__trafficbydate_buyboxpercentage,sales_and_traffic_report_by_date__trafficbydate_feedbackreceived,sales_and_traffic_report_by_date__trafficbydate_mobileapppageviews,sales_and_traffic_report_by_date__trafficbydate_mobileappsessions,sales_and_traffic_report_by_date__trafficbydate_negativefeedbackreceived,sales_and_traffic_report_by_date__trafficbydate_orderitemsessionpercentage,sales_and_traffic_report_by_date__trafficbydate_orderitemsessionpercentageb2b,sales_and_traffic_report_by_date__trafficbydate_pageviews,sales_and_traffic_report_by_date__trafficbydate_receivednegativefeedbackrate,sales_and_traffic_report_by_date__trafficbydate_sessions,sales_and_traffic_report_by_date__trafficbydate_unitsessionpercentage,sales_and_traffic_report_by_date__trafficbydate_unitsessionpercentageb2b,
Sample query for the Amazon Fulfilled Shipments Data General Report
https://connectors.windsor.ai/amazon_sp?api_key=[your API key]&date_preset=last_28d&fields=date,account_name,amazon_fulfilled_shipments_data_general__amazon_order_id,amazon_fulfilled_shipments_data_general__amazon_order_item_id,amazon_fulfilled_shipments_data_general__bill_address_1,amazon_fulfilled_shipments_data_general__bill_address_2,amazon_fulfilled_shipments_data_general__bill_address_3,amazon_fulfilled_shipments_data_general__bill_city,amazon_fulfilled_shipments_data_general__bill_country,amazon_fulfilled_shipments_data_general__bill_postal_code,amazon_fulfilled_shipments_data_general__bill_state,amazon_fulfilled_shipments_data_general__buyer_email,amazon_fulfilled_shipments_data_general__buyer_name,amazon_fulfilled_shipments_data_general__buyer_phone_number,amazon_fulfilled_shipments_data_general__carrier,amazon_fulfilled_shipments_data_general__currency,amazon_fulfilled_shipments_data_general__estimated_arrival_date,amazon_fulfilled_shipments_data_general__fulfillment_center_id,amazon_fulfilled_shipments_data_general__fulfillment_channel,amazon_fulfilled_shipments_data_general__gift_wrap_price,amazon_fulfilled_shipments_data_general__gift_wrap_tax,amazon_fulfilled_shipments_data_general__item_price,amazon_fulfilled_shipments_data_general__item_promotion_discount,amazon_fulfilled_shipments_data_general__item_tax,amazon_fulfilled_shipments_data_general__merchant_order_id,amazon_fulfilled_shipments_data_general__merchant_order_item_id,amazon_fulfilled_shipments_data_general__payments_date,amazon_fulfilled_shipments_data_general__product_name,amazon_fulfilled_shipments_data_general__purchase_date,amazon_fulfilled_shipments_data_general__quantity_shipped,amazon_fulfilled_shipments_data_general__recipient_name,amazon_fulfilled_shipments_data_general__reporting_date,amazon_fulfilled_shipments_data_general__sales_channel,amazon_fulfilled_shipments_data_general__ship_address_1,amazon_fulfilled_shipments_data_general__ship_address_2,amazon_fulfilled_shipments_data_general__ship_address_3,amazon_fulfilled_shipments_data_general__ship_city,amazon_fulfilled_shipments_data_general__ship_country,amazon_fulfilled_shipments_data_general__ship_phone_number,amazon_fulfilled_shipments_data_general__ship_postal_code,amazon_fulfilled_shipments_data_general__ship_promotion_discount,amazon_fulfilled_shipments_data_general__ship_service_level,amazon_fulfilled_shipments_data_general__ship_state,amazon_fulfilled_shipments_data_general__shipment_date,amazon_fulfilled_shipments_data_general__shipment_id,amazon_fulfilled_shipments_data_general__shipment_item_id,amazon_fulfilled_shipments_data_general__shipping_price,amazon_fulfilled_shipments_data_general__shipping_tax,amazon_fulfilled_shipments_data_general__sku,amazon_fulfilled_shipments_data_general__tracking_number
Sample query for the Flat File All Orders Data By Last Update General Report
https://connectors.windsor.ai/amazon_sp?api_key=[your API key]&date_preset=last_28d&fields=date,account_name,flat_file_all_orders_data_by_last_update_general__amazon_order_id,flat_file_all_orders_data_by_last_update_general__asin,flat_file_all_orders_data_by_last_update_general__currency,flat_file_all_orders_data_by_last_update_general__fulfillment_channel,flat_file_all_orders_data_by_last_update_general__gift_wrap_price,flat_file_all_orders_data_by_last_update_general__gift_wrap_tax,flat_file_all_orders_data_by_last_update_general__is_business_order,flat_file_all_orders_data_by_last_update_general__item_price,flat_file_all_orders_data_by_last_update_general__item_promotion_discount,flat_file_all_orders_data_by_last_update_general__item_status,flat_file_all_orders_data_by_last_update_general__item_tax,flat_file_all_orders_data_by_last_update_general__last_updated_date,flat_file_all_orders_data_by_last_update_general__merchant_order_id,flat_file_all_orders_data_by_last_update_general__order_channel,flat_file_all_orders_data_by_last_update_general__order_status,flat_file_all_orders_data_by_last_update_general__price_designation,flat_file_all_orders_data_by_last_update_general__product_name,flat_file_all_orders_data_by_last_update_general__promotion_ids,flat_file_all_orders_data_by_last_update_general__purchase_date,flat_file_all_orders_data_by_last_update_general__purchase_order_number,flat_file_all_orders_data_by_last_update_general__quantity,flat_file_all_orders_data_by_last_update_general__sales_channel,flat_file_all_orders_data_by_last_update_general__ship_city,flat_file_all_orders_data_by_last_update_general__ship_country,flat_file_all_orders_data_by_last_update_general__ship_postal_code,flat_file_all_orders_data_by_last_update_general__ship_promotion_discount,flat_file_all_orders_data_by_last_update_general__ship_service_level,flat_file_all_orders_data_by_last_update_general__ship_state,flat_file_all_orders_data_by_last_update_general__shipping_price,flat_file_all_orders_data_by_last_update_general__shipping_tax,flat_file_all_orders_data_by_last_update_general__sku
Sample query for the FBA Fulfilment Customer Returns Data Report
https://connectors.windsor.ai/amazon_sp?api_key=[your API key]&date_preset=last_28d&fields=date,account_name,fba_fulfillment_customer_returns_data__asin,fba_fulfillment_customer_returns_data__customer_comments,fba_fulfillment_customer_returns_data__detailed_disposition,fba_fulfillment_customer_returns_data__fnsku,fba_fulfillment_customer_returns_data__fulfillment_center_id,fba_fulfillment_customer_returns_data__license_plate_number,fba_fulfillment_customer_returns_data__order_id,fba_fulfillment_customer_returns_data__product_name,fba_fulfillment_customer_returns_data__quantity,fba_fulfillment_customer_returns_data__reason,fba_fulfillment_customer_returns_data__return_date,fba_fulfillment_customer_returns_data__sku,fba_fulfillment_customer_returns_data__status,
Sample query for the FBA Reimbursements Data report
https://connectors.windsor.ai/amazon_sp?api_key=[your API key]&date_preset=last_28d&fields=date,account_name,fba_reimbursements_data__amazon_order_id,fba_reimbursements_data__amount_per_unit,fba_reimbursements_data__amount_total,fba_reimbursements_data__approval_date,fba_reimbursements_data__asin,fba_reimbursements_data__case_id,fba_reimbursements_data__condition,fba_reimbursements_data__currency_unit,fba_reimbursements_data__fnsku,fba_reimbursements_data__original_reimbursement_id,fba_reimbursements_data__original_reimbursement_type,fba_reimbursements_data__product_name,fba_reimbursements_data__quantity_reimbursed_cash,fba_reimbursements_data__quantity_reimbursed_inventory,fba_reimbursements_data__quantity_reimbursed_total,fba_reimbursements_data__reason,fba_reimbursements_data__reimbursement_id,fba_reimbursements_data__sku,
Sample query for the FBA Inventory Planning Data report
https://connectors.windsor.ai/amazon_sp?api_key=[your API key]&fields=date,account_id,account_name,fba_inventory_planning_data__alert,fba_inventory_planning_data__available,fba_inventory_planning_data__days_of_supply,fba_inventory_planning_data__estimated_cost_savings_of_recommended_actions,fba_inventory_planning_data__estimated_excess_quantity,fba_inventory_planning_data__estimated_ltsf_next_charge,fba_inventory_planning_data__estimated_storage_cost_next_month,fba_inventory_planning_data__featuredoffer_price,fba_inventory_planning_data__healthy_inventory_level,fba_inventory_planning_data__inbound_quantity,fba_inventory_planning_data__inbound_received,fba_inventory_planning_data__inbound_shipped,fba_inventory_planning_data__inbound_working,fba_inventory_planning_data__inv_age_0_to_30_days,,fba_inventory_planning_data__inv_age_181_to_330_days,fba_inventory_planning_data__inv_age_31_to_60_days,fba_inventory_planning_data__inv_age_331_to_365_days,,fba_inventory_planning_data__inv_age_61_to_90_days,fba_inventory_planning_data__item_volume,fba_inventory_planning_data__lowest_price_new_plus_shipping,fba_inventory_planning_data__lowest_price_used,fba_inventory_planning_data__marketplace,fba_inventory_planning_data__no_sale_last_6_months,fba_inventory_planning_data__pending_removal_quantity,fba_inventory_planning_data__projected_ltsf_9_mo,fba_inventory_planning_data__qty_to_be_charged_ltsf_9_mo,fba_inventory_planning_data__recommended_action,fba_inventory_planning_data__recommended_removal_quantity,fba_inventory_planning_data__recommended_sale_duration_days,fba_inventory_planning_data__recommended_sales_price,fba_inventory_planning_data__sales_shipped_last_30_days,fba_inventory_planning_data__sales_shipped_last_60_days,fba_inventory_planning_data__sales_shipped_last_7_days,fba_inventory_planning_data__sales_shipped_last_90_days,fba_inventory_planning_data__sell_through,,fba_inventory_planning_data__storage_type,fba_inventory_planning_data__storage_volume,fba_inventory_planning_data__units_shipped_t30,fba_inventory_planning_data__units_shipped_t60,fba_inventory_planning_data__units_shipped_t7,fba_inventory_planning_data__units_shipped_t90,fba_inventory_planning_data__volume_unit_measurement&date_preset=last_7d&fields=
Sample query for the FBA MYI Unsuppressed Inventory Data report
https://connectors.windsor.ai/amazon_sp?api_key=[your API key]&date_preset=last_7d&fields=date,account_id,account_name,fba_myi_unsuppressed_inventory_data__afn_fulfillable_quantity,fba_myi_unsuppressed_inventory_data__afn_future_supply_buyable,fba_myi_unsuppressed_inventory_data__afn_inbound_receiving_quantity,fba_myi_unsuppressed_inventory_data__afn_inbound_shipped_quantity,fba_myi_unsuppressed_inventory_data__afn_inbound_working_quantity,fba_myi_unsuppressed_inventory_data__afn_listing_exists,fba_myi_unsuppressed_inventory_data__afn_researching_quantity,fba_myi_unsuppressed_inventory_data__afn_reserved_future_supply,fba_myi_unsuppressed_inventory_data__afn_reserved_quantity,fba_myi_unsuppressed_inventory_data__afn_total_quantity,fba_myi_unsuppressed_inventory_data__afn_unsellable_quantity,fba_myi_unsuppressed_inventory_data__afn_warehouse_quantity,fba_myi_unsuppressed_inventory_data__asin,fba_myi_unsuppressed_inventory_data__condition,fba_myi_unsuppressed_inventory_data__fnsku,fba_myi_unsuppressed_inventory_data__mfn_fulfillable_quantity,fba_myi_unsuppressed_inventory_data__mfn_listing_exists,fba_myi_unsuppressed_inventory_data__per_unit_volume,fba_myi_unsuppressed_inventory_data__product_name,fba_myi_unsuppressed_inventory_data__sku,fba_myi_unsuppressed_inventory_data__your_price
Sample query for the FBA Estimated FBA Fees report
https://connectors.windsor.ai/amazon_sp?api_key=[your API key]&date_preset=last_7d&fields=date,account_id,account_name,fba_estimated_fba_fees_txt_data__asin,fba_estimated_fba_fees_txt_data__brand,fba_estimated_fba_fees_txt_data__currency,fba_estimated_fba_fees_txt_data__estimated_fee_total,fba_estimated_fba_fees_txt_data__estimated_order_handling_fee_per_order,fba_estimated_fba_fees_txt_data__estimated_pick_pack_fee_per_unit,fba_estimated_fba_fees_txt_data__estimated_referral_fee_per_unit,fba_estimated_fba_fees_txt_data__estimated_variable_closing_fee,fba_estimated_fba_fees_txt_data__estimated_weight_handling_fee_per_unit,fba_estimated_fba_fees_txt_data__expected_fulfillment_fee_per_unit,fba_estimated_fba_fees_txt_data__fnsku,fba_estimated_fba_fees_txt_data__fulfilled_by,fba_estimated_fba_fees_txt_data__item_package_weight,fba_estimated_fba_fees_txt_data__length_and_girth,fba_estimated_fba_fees_txt_data__longest_side,fba_estimated_fba_fees_txt_data__median_side,fba_estimated_fba_fees_txt_data__product_group,fba_estimated_fba_fees_txt_data__product_name,fba_estimated_fba_fees_txt_data__product_size_tier,fba_estimated_fba_fees_txt_data__sales_price,fba_estimated_fba_fees_txt_data__shortest_side,fba_estimated_fba_fees_txt_data__sku,fba_estimated_fba_fees_txt_data__unit_of_dimension,fba_estimated_fba_fees_txt_data__unit_of_weight,fba_estimated_fba_fees_txt_data__your_price
Sample query for the FBA UNO Inventory Data report
https://connectors.windsor.ai/amazon_sp?api_key=[your API key]&date_preset=last_7d&fields=date,account_id,account_name,fba_uno_inventory_data__asin,fba_uno_inventory_data__price,fba_uno_inventory_data__quantity,fba_uno_inventory_data__sku
Sample query for the Merchant Listings All Data report
https://connectors.windsor.ai/amazon_sp?api_key=[your API key]&date_preset=last_7d&fields=date,account_id,account_name,merchant_listings_all_data__add_delete,merchant_listings_all_data__asin1,merchant_listings_all_data__asin2,merchant_listings_all_data__asin3,merchant_listings_all_data__bid_for_featured_placement,merchant_listings_all_data__expedited_shipping,merchant_listings_all_data__fulfillment_channel,merchant_listings_all_data__image_url,merchant_listings_all_data__item_condition,merchant_listings_all_data__item_description,merchant_listings_all_data__item_is_marketplace,merchant_listings_all_data__item_name,merchant_listings_all_data__item_note,merchant_listings_all_data__listing_id,merchant_listings_all_data__merchant_shipping_group,merchant_listings_all_data__open_date,merchant_listings_all_data__pending_quantity,merchant_listings_all_data__price,merchant_listings_all_data__product_id,merchant_listings_all_data__product_id_type,merchant_listings_all_data__quantity,merchant_listings_all_data__seller_sku,merchant_listings_all_data__status,merchant_listings_all_data__will_ship_internationally,merchant_listings_all_data__zshop_boldface,merchant_listings_all_data__zshop_browse_path,merchant_listings_all_data__zshop_category1,merchant_listings_all_data__zshop_shipping_fee,merchant_listings_all_data__zshop_storefront_feature
Sample query for the Restock Inventory Recommendations report
https://connectors.windsor.ai/amazon_sp?api_key=[your API key]&date_preset=last_7d&fields=date,account_id,account_name,restock_inventory_recommendations_report__alert,restock_inventory_recommendations_report__asin,restock_inventory_recommendations_report__available,restock_inventory_recommendations_report__condition,restock_inventory_recommendations_report__country,restock_inventory_recommendations_report__currency_code,restock_inventory_recommendations_report__customer_order,restock_inventory_recommendations_report__days_of_supply_at_amazon_fulfillment_network,restock_inventory_recommendations_report__fc_processing,restock_inventory_recommendations_report__fc_transfer,restock_inventory_recommendations_report__fnsku,restock_inventory_recommendations_report__fulfilled_by,restock_inventory_recommendations_report__inbound,restock_inventory_recommendations_report__merchant_sku,restock_inventory_recommendations_report__price,restock_inventory_recommendations_report__product_name,restock_inventory_recommendations_report__receiving,restock_inventory_recommendations_report__recommended_action,restock_inventory_recommendations_report__recommended_replenishment_qty,restock_inventory_recommendations_report__recommended_ship_date,restock_inventory_recommendations_report__sales_last_30_days,restock_inventory_recommendations_report__shipped,restock_inventory_recommendations_report__supplier,restock_inventory_recommendations_report__supplier_part_no.,restock_inventory_recommendations_report__total_days_of_supply_(including_units_from_open_shipments),restock_inventory_recommendations_report__total_units,restock_inventory_recommendations_report__unfulfillable,restock_inventory_recommendations_report__units_sold_last_30_days,restock_inventory_recommendations_report__working
Sample query for the Flat File Open Listings Data report
https://connectors.windsor.ai/amazon_sp?api_key=[your API key]&date_preset=last_28d&fields=date,account_name,flat_file_open_listings_data__asin,flat_file_open_listings_data__business_price,flat_file_open_listings_data__price,flat_file_open_listings_data__progressive_lower_bound_1,flat_file_open_listings_data__progressive_lower_bound_2,flat_file_open_listings_data__progressive_lower_bound_3,flat_file_open_listings_data__progressive_price_1,flat_file_open_listings_data__progressive_price_2,flat_file_open_listings_data__progressive_price_3,flat_file_open_listings_data__progressive_price_type,flat_file_open_listings_data__quantity,flat_file_open_listings_data__quantity_lower_bound_1,flat_file_open_listings_data__quantity_lower_bound_2,flat_file_open_listings_data__quantity_lower_bound_3,flat_file_open_listings_data__quantity_lower_bound_4,flat_file_open_listings_data__quantity_lower_bound_5,flat_file_open_listings_data__quantity_price_1,flat_file_open_listings_data__quantity_price_2,flat_file_open_listings_data__quantity_price_3,flat_file_open_listings_data__quantity_price_4,flat_file_open_listings_data__quantity_price_5,flat_file_open_listings_data__quantity_price_type,flat_file_open_listings_data__sku
Fields
| ID | Type | Name | Description |
|---|---|---|---|
| account_id | TEXT | Account ID | The account ID |
| account_name | TEXT | Account Name | The account name |
| amazon_fulfilled_shipments_data_general__amazon_order_id | TEXT | amazon-order-id (get_amazon_fulfilled_shipments_data_general) | amazon-order-id (get_amazon_fulfilled_shipments_data_general) Amazon's; unique, displayable identifier for an order.; |
| amazon_fulfilled_shipments_data_general__amazon_order_item_id | TEXT | amazon-order-item-id (get_amazon_fulfilled_shipments_data_general) | amazon-order-item-id (get_amazon_fulfilled_shipments_data_general); Amazon's unique, displayable identifier for an item within the order.; |
| amazon_fulfilled_shipments_data_general__bill_address_1 | TEXT | bill-address-1 (get_amazon_fulfilled_shipments_data_general) | bill-address-1 (get_amazon_fulfilled_shipments_data_general) The first; line of a standard address.; |
| amazon_fulfilled_shipments_data_general__bill_address_2 | TEXT | bill-address-2 (get_amazon_fulfilled_shipments_data_general) | bill-address-2 (get_amazon_fulfilled_shipments_data_general) The; second line of a standard address.; |
| amazon_fulfilled_shipments_data_general__bill_address_3 | TEXT | bill-address-3 (get_amazon_fulfilled_shipments_data_general) | bill-address-3 (get_amazon_fulfilled_shipments_data_general) The third; line of a standard address.; |
| amazon_fulfilled_shipments_data_general__bill_city | TEXT | bill-city (get_amazon_fulfilled_shipments_data_general) | bill-city (get_amazon_fulfilled_shipments_data_general) The city of a; standard address.; |
| amazon_fulfilled_shipments_data_general__bill_country | TEXT | bill-country (get_amazon_fulfilled_shipments_data_general) | bill-country (get_amazon_fulfilled_shipments_data_general) ISO 3166; standard two-letter country code.; |
| amazon_fulfilled_shipments_data_general__bill_postal_code | TEXT | bill-postal-code (get_amazon_fulfilled_shipments_data_general) | bill-postal-code (get_amazon_fulfilled_shipments_data_general) The; postal (zip) code of a standard address.; |
| amazon_fulfilled_shipments_data_general__bill_state | TEXT | bill-state (get_amazon_fulfilled_shipments_data_general) | bill-state (get_amazon_fulfilled_shipments_data_general) The state or; region of a standard address.; |
| amazon_fulfilled_shipments_data_general__buyer_email | TEXT | buyer-email (get_amazon_fulfilled_shipments_data_general) | buyer-email (get_amazon_fulfilled_shipments_data_general) The; encrypted email address of the buyer.; |
| amazon_fulfilled_shipments_data_general__buyer_name | TEXT | buyer-name (get_amazon_fulfilled_shipments_data_general) | buyer-name (get_amazon_fulfilled_shipments_data_general) The full name; of the buyer.; |
| amazon_fulfilled_shipments_data_general__buyer_phone_number | TEXT | buyer-phone-number (get_amazon_fulfilled_shipments_data_general) | buyer-phone-number (get_amazon_fulfilled_shipments_data_general) The; phone number of the buyer.; |
| amazon_fulfilled_shipments_data_general__carrier | TEXT | carrier (get_amazon_fulfilled_shipments_data_general) | carrier (get_amazon_fulfilled_shipments_data_general) The name of the; carrier the package was shipped with.; |
| amazon_fulfilled_shipments_data_general__currency | TEXT | currency (get_amazon_fulfilled_shipments_data_general) | currency (get_amazon_fulfilled_shipments_data_general) The currency; used for the purchase. Supported currencies include USD, CAD, GBP,; EUR, and JPY.; |
| amazon_fulfilled_shipments_data_general__estimated_arrival_date | TEXT | estimated-arrival-date (get_amazon_fulfilled_shipments_data_general) | estimated-arrival-date (get_amazon_fulfilled_shipments_data_general); The estimated date of delivery to the customer.; |
| amazon_fulfilled_shipments_data_general__fulfillment_center_id | TEXT | fulfillment-center-id (get_amazon_fulfilled_shipments_data_general) | fulfillment-center-id (get_amazon_fulfilled_shipments_data_general); The unique identifier from which fulfillment center the order was; shipped.; |
| amazon_fulfilled_shipments_data_general__fulfillment_channel | TEXT | fulfillment-channel (get_amazon_fulfilled_shipments_data_general) | fulfillment-channel (get_amazon_fulfilled_shipments_data_general); Indicates how the order was fulfilled, via Amazon (AFN) or Merchant; (MFN); |
| amazon_fulfilled_shipments_data_general__gift_wrap_price | NUMERIC | gift-wrap-price (get_amazon_fulfilled_shipments_data_general) | gift-wrap-price (get_amazon_fulfilled_shipments_data_general) The; amount that the buyer paid for gift wrap. Amount is aggregate of the; quantity, not unit price.; |
| amazon_fulfilled_shipments_data_general__gift_wrap_tax | NUMERIC | gift-wrap-tax (get_amazon_fulfilled_shipments_data_general) | gift-wrap-tax (get_amazon_fulfilled_shipments_data_general) The amount; that the buyer paid for gift wrap tax. Amount is aggregate of the; quantity, not unit price.; |
| amazon_fulfilled_shipments_data_general__item_price | NUMERIC | item-price (get_amazon_fulfilled_shipments_data_general) | item-price (get_amazon_fulfilled_shipments_data_general) The amount; that the buyer paid for the item. Amount is aggregate of the quantity,; not unit price.; |
| amazon_fulfilled_shipments_data_general__item_promotion_discount | NUMERIC | item-promotion-discount (get_amazon_fulfilled_shipments_data_general) | item-promotion-discount (get_amazon_fulfilled_shipments_data_general); Promotion discount applied to the order item.; |
| amazon_fulfilled_shipments_data_general__item_tax | NUMERIC | item-tax (get_amazon_fulfilled_shipments_data_general) | item-tax (get_amazon_fulfilled_shipments_data_general) The amount that; the buyer paid for item tax. Amount is aggregate of the quantity, not; unit price.; |
| amazon_fulfilled_shipments_data_general__merchant_order_id | TEXT | merchant-order-id (get_amazon_fulfilled_shipments_data_general) | merchant-order-id (get_amazon_fulfilled_shipments_data_general) A; unique identifier optionally supplied for the order by the Merchant.; |
| amazon_fulfilled_shipments_data_general__merchant_order_item_id | TEXT | merchant-order-item-id (get_amazon_fulfilled_shipments_data_general) | merchant-order-item-id (get_amazon_fulfilled_shipments_data_general) A; unique identifier for an item within the order.; |
| amazon_fulfilled_shipments_data_general__payments_date | DATE | payments-date (get_amazon_fulfilled_shipments_data_general) | payments-date (get_amazon_fulfilled_shipments_data_general) The date; the buyer's credit card was charged and order processing was; completed.; |
| amazon_fulfilled_shipments_data_general__product_name | TEXT | product-name (get_amazon_fulfilled_shipments_data_general) | product-name (get_amazon_fulfilled_shipments_data_general) The short; title for the product, displayed in bold on the detail web page and in; the title bar of the browser window.; |
| amazon_fulfilled_shipments_data_general__purchase_date | DATE | purchase-date (get_amazon_fulfilled_shipments_data_general) | purchase-date (get_amazon_fulfilled_shipments_data_general) The date; the order was placed.; |
| amazon_fulfilled_shipments_data_general__quantity_shipped | NUMERIC | quantity-shipped (get_amazon_fulfilled_shipments_data_general) | quantity-shipped (get_amazon_fulfilled_shipments_data_general) The; number of this item that were shipped.; |
| amazon_fulfilled_shipments_data_general__recipient_name | TEXT | recipient-name (get_amazon_fulfilled_shipments_data_general) | recipient-name (get_amazon_fulfilled_shipments_data_general) Name; field of a standard address.; |
| amazon_fulfilled_shipments_data_general__reporting_date | DATE | reporting-date (get_amazon_fulfilled_shipments_data_general) | reporting-date (get_amazon_fulfilled_shipments_data_general) The date; the data for this report became available in the FBA data store.; |
| amazon_fulfilled_shipments_data_general__sales_channel | TEXT | sales-channel (get_amazon_fulfilled_shipments_data_general) | sales-channel (get_amazon_fulfilled_shipments_data_general) The source; of the order.; |
| amazon_fulfilled_shipments_data_general__ship_address_1 | TEXT | ship-address-1 (get_amazon_fulfilled_shipments_data_general) | ship-address-1 (get_amazon_fulfilled_shipments_data_general) The first; line of a standard address.; |
| amazon_fulfilled_shipments_data_general__ship_address_2 | TEXT | ship-address-2 (get_amazon_fulfilled_shipments_data_general) | ship-address-2 (get_amazon_fulfilled_shipments_data_general) The; second line of a standard address.; |
| amazon_fulfilled_shipments_data_general__ship_address_3 | TEXT | ship-address-3 (get_amazon_fulfilled_shipments_data_general) | ship-address-3 (get_amazon_fulfilled_shipments_data_general) The third; line of a standard address.; |
| amazon_fulfilled_shipments_data_general__ship_city | TEXT | ship-city (get_amazon_fulfilled_shipments_data_general) | ship-city (get_amazon_fulfilled_shipments_data_general) The city of a; standard address.; |
| amazon_fulfilled_shipments_data_general__ship_country | TEXT | ship-country (get_amazon_fulfilled_shipments_data_general) | ship-country (get_amazon_fulfilled_shipments_data_general) ISO 3166; standard two-letter country code.; |
| amazon_fulfilled_shipments_data_general__ship_phone_number | TEXT | ship-phone-number (get_amazon_fulfilled_shipments_data_general) | ship-phone-number (get_amazon_fulfilled_shipments_data_general) The; phone number associated with the ship-to address.; |
| amazon_fulfilled_shipments_data_general__ship_postal_code | TEXT | ship-postal-code (get_amazon_fulfilled_shipments_data_general) | ship-postal-code (get_amazon_fulfilled_shipments_data_general) The; postal (ZIP) code of a standard address.; |
| amazon_fulfilled_shipments_data_general__ship_promotion_discount | NUMERIC | ship-promotion-discount (get_amazon_fulfilled_shipments_data_general) | ship-promotion-discount (get_amazon_fulfilled_shipments_data_general); Promotion discount applied to shipping.; |
| amazon_fulfilled_shipments_data_general__ship_service_level | TEXT | ship-service-level (get_amazon_fulfilled_shipments_data_general) | ship-service-level (get_amazon_fulfilled_shipments_data_general) An; enumerated value that determines the type of fulfillment service that; the buyer expects the merchant to use (e.g., Standard v. Expedited); |
| amazon_fulfilled_shipments_data_general__ship_state | TEXT | ship-state (get_amazon_fulfilled_shipments_data_general) | ship-state (get_amazon_fulfilled_shipments_data_general) The state or; region of a standard address.; |
| amazon_fulfilled_shipments_data_general__shipment_date | DATE | shipment-date (get_amazon_fulfilled_shipments_data_general) | shipment-date (get_amazon_fulfilled_shipments_data_general) The date; the shipment was completed (shipped) by the fulfillment center; |
| amazon_fulfilled_shipments_data_general__shipment_id | TEXT | shipment-id (get_amazon_fulfilled_shipments_data_general) | shipment-id (get_amazon_fulfilled_shipments_data_general) Encrypted; Amazon shipment id; |
| amazon_fulfilled_shipments_data_general__shipment_item_id | TEXT | shipment-item-id (get_amazon_fulfilled_shipments_data_general) | shipment-item-id (get_amazon_fulfilled_shipments_data_general); Encrypted Amazon shipment item id; |
| amazon_fulfilled_shipments_data_general__shipping_price | NUMERIC | shipping-price (get_amazon_fulfilled_shipments_data_general) | shipping-price (get_amazon_fulfilled_shipments_data_general) The; amount that the buyer paid for shipping. Amount is aggregate of the; quantity, not unit price.; |
| amazon_fulfilled_shipments_data_general__shipping_tax | NUMERIC | shipping-tax (get_amazon_fulfilled_shipments_data_general) | shipping-tax (get_amazon_fulfilled_shipments_data_general) The amount; that the buyer paid for shipping tax. Amount is aggregate of the; quantity, not unit price.; |
| amazon_fulfilled_shipments_data_general__sku | TEXT | sku (get_amazon_fulfilled_shipments_data_general) | sku (get_amazon_fulfilled_shipments_data_general) A merchant-defined; unique identifier for a product.; |
| amazon_fulfilled_shipments_data_general__tracking_number | TEXT | tracking-number (get_amazon_fulfilled_shipments_data_general) | tracking-number (get_amazon_fulfilled_shipments_data_general) The; carrier's tracking number for the package.; |
| date | DATE | Date | Date to which metrics apply |
| fba_estimated_fba_fees_txt_data__asin | TEXT | asin (get_fba_estimated_fba_fees_txt_data) | asin (get_fba_estimated_fba_fees_txt_data) Amazon Standard; Identification Numbers (ASINs) are unique blocks of 10 letters or; numbers that identify products. ASINs are assigned by Amazon. You can; find the ASIN on the product detail page.; |
| fba_estimated_fba_fees_txt_data__brand | TEXT | brand (get_fba_estimated_fba_fees_txt_data) | brand (get_fba_estimated_fba_fees_txt_data) The brand of your product; |
| fba_estimated_fba_fees_txt_data__currency | TEXT | currency (get_fba_estimated_fba_fees_txt_data) | currency (get_fba_estimated_fba_fees_txt_data) The currency in which; the fee is calculated; |
| fba_estimated_fba_fees_txt_data__estimated_fee_total | NUMERIC | estimated-fee-total (get_fba_estimated_fba_fees_txt_data) | estimated-fee-total (get_fba_estimated_fba_fees_txt_data) The; estimated fulfillment and selling on Amazon fee; |
| fba_estimated_fba_fees_txt_data__estimated_order_handling_fee_per_order | NUMERIC | estimated-order-handling-fee-per-order (get_fba_estimated_fba_fees_txt_data) | estimated-order-handling-fee-per-order; (get_fba_estimated_fba_fees_txt_data) The estimated order handling fee; per order; |
| fba_estimated_fba_fees_txt_data__estimated_pick_pack_fee_per_unit | TEXT | estimated-pick-pack-fee-per-unit (get_fba_estimated_fba_fees_txt_data) | estimated-pick-pack-fee-per-unit (get_fba_estimated_fba_fees_txt_data); |
| fba_estimated_fba_fees_txt_data__estimated_referral_fee_per_unit | NUMERIC | estimated-referral-fee-per-unit (get_fba_estimated_fba_fees_txt_data) | estimated-referral-fee-per-unit (get_fba_estimated_fba_fees_txt_data); The estimated selling on Amazon referral fee; |
| fba_estimated_fba_fees_txt_data__estimated_variable_closing_fee | NUMERIC | estimated-variable-closing-fee (get_fba_estimated_fba_fees_txt_data) | estimated-variable-closing-fee (get_fba_estimated_fba_fees_txt_data); The estimated variable closing fee for your product; |
| fba_estimated_fba_fees_txt_data__estimated_weight_handling_fee_per_unit | NUMERIC | estimated-weight-handling-fee-per-unit (get_fba_estimated_fba_fees_txt_data) | estimated-weight-handling-fee-per-unit; (get_fba_estimated_fba_fees_txt_data) The estimated weight handling; fee for your product based on the outbound shipping weight; |
| fba_estimated_fba_fees_txt_data__expected_fulfillment_fee_per_unit | NUMERIC | expected-fulfillment-fee-per-unit (get_fba_estimated_fba_fees_txt_data) | expected-fulfillment-fee-per-unit; (get_fba_estimated_fba_fees_txt_data); |
| fba_estimated_fba_fees_txt_data__fnsku | TEXT | fnsku (get_fba_estimated_fba_fees_txt_data) | fnsku (get_fba_estimated_fba_fees_txt_data) Unique identifier assigned; by Amazon to products stored in and fulfilled from an Amazon; fulfillment center; |
| fba_estimated_fba_fees_txt_data__fulfilled_by | TEXT | fulfilled-by (get_fba_estimated_fba_fees_txt_data) | fulfilled-by (get_fba_estimated_fba_fees_txt_data) The entity that; fulfilled the item; |
| fba_estimated_fba_fees_txt_data__item_package_weight | NUMERIC | item-package-weight (get_fba_estimated_fba_fees_txt_data) | item-package-weight (get_fba_estimated_fba_fees_txt_data) |
| fba_estimated_fba_fees_txt_data__length_and_girth | NUMERIC | length-and-girth (get_fba_estimated_fba_fees_txt_data) | length-and-girth (get_fba_estimated_fba_fees_txt_data) The longest; side of your product, including its packaging, plus the girth, a unit; measure, equivalent to 2 x (median side + shortest side); |
| fba_estimated_fba_fees_txt_data__longest_side | NUMERIC | longest-side (get_fba_estimated_fba_fees_txt_data) | longest-side (get_fba_estimated_fba_fees_txt_data) Measurement of the; longest side of your product including its packaging; |
| fba_estimated_fba_fees_txt_data__median_side | NUMERIC | median-side (get_fba_estimated_fba_fees_txt_data) | median-side (get_fba_estimated_fba_fees_txt_data) Measurement of the; side that is neither the longest nor the shortest side of your product; including its packaging; |
| fba_estimated_fba_fees_txt_data__product_group | TEXT | product-group (get_fba_estimated_fba_fees_txt_data) | product-group (get_fba_estimated_fba_fees_txt_data) The Amazon; department or category; |
| fba_estimated_fba_fees_txt_data__product_name | TEXT | product-name (get_fba_estimated_fba_fees_txt_data) | product-name (get_fba_estimated_fba_fees_txt_data) The title of your; product; |
| fba_estimated_fba_fees_txt_data__product_size_tier | TEXT | product-size-tier (get_fba_estimated_fba_fees_txt_data) | product-size-tier (get_fba_estimated_fba_fees_txt_data) The size tier; assigned to your product by FBA based on its dimensions and weight; |
| fba_estimated_fba_fees_txt_data__sales_price | NUMERIC | sales-price (get_fba_estimated_fba_fees_txt_data) | sales-price (get_fba_estimated_fba_fees_txt_data) Your current; promotional price; |
| fba_estimated_fba_fees_txt_data__shortest_side | NUMERIC | shortest-side (get_fba_estimated_fba_fees_txt_data) | shortest-side (get_fba_estimated_fba_fees_txt_data) Measurement of the; shortest side of your product including its packaging; |
| fba_estimated_fba_fees_txt_data__sku | TEXT | sku (get_fba_estimated_fba_fees_txt_data) | sku (get_fba_estimated_fba_fees_txt_data) Stock Keeping Units (SKUs); are unique blocks of letters or numbers that identify your products.; SKUs are assigned by you as the seller.; |
| fba_estimated_fba_fees_txt_data__unit_of_dimension | TEXT | unit-of-dimension (get_fba_estimated_fba_fees_txt_data) | unit-of-dimension (get_fba_estimated_fba_fees_txt_data) |
| fba_estimated_fba_fees_txt_data__unit_of_weight | TEXT | unit-of-weight (get_fba_estimated_fba_fees_txt_data) | unit-of-weight (get_fba_estimated_fba_fees_txt_data) The unit of; weight used in weight measurement; |
| fba_estimated_fba_fees_txt_data__your_price | NUMERIC | your-price (get_fba_estimated_fba_fees_txt_data) | your-price (get_fba_estimated_fba_fees_txt_data) Your current selling; price; |
| fba_fulfillment_customer_returns_data__asin | TEXT | asin (get_fba_fulfillment_customer_returns_data) | asin (get_fba_fulfillment_customer_returns_data) Amazon standard item; number; |
| fba_fulfillment_customer_returns_data__customer_comments | TEXT | customer-comments (get_fba_fulfillment_customer_returns_data) | customer-comments (get_fba_fulfillment_customer_returns_data) When; available, comments submitted by customers regarding the reason for; the return are provided.; |
| fba_fulfillment_customer_returns_data__detailed_disposition | TEXT | detailed-disposition (get_fba_fulfillment_customer_returns_data) | detailed-disposition (get_fba_fulfillment_customer_returns_data); Condition of the returned item: see Condition Codes below for; explanation; |
| fba_fulfillment_customer_returns_data__fnsku | TEXT | fnsku (get_fba_fulfillment_customer_returns_data) | fnsku (get_fba_fulfillment_customer_returns_data) Fulfillment network; SKU; |
| fba_fulfillment_customer_returns_data__fulfillment_center_id | TEXT | fulfillment-center-id (get_fba_fulfillment_customer_returns_data) | fulfillment-center-id (get_fba_fulfillment_customer_returns_data); Fulfillment center where the returned merchandise was processed; |
| fba_fulfillment_customer_returns_data__license_plate_number | TEXT | license-plate-number (get_fba_fulfillment_customer_returns_data) | license-plate-number (get_fba_fulfillment_customer_returns_data); |
| fba_fulfillment_customer_returns_data__order_id | TEXT | order-id (get_fba_fulfillment_customer_returns_data) | order-id (get_fba_fulfillment_customer_returns_data) |
| fba_fulfillment_customer_returns_data__product_name | TEXT | product-name (get_fba_fulfillment_customer_returns_data) | product-name (get_fba_fulfillment_customer_returns_data) The name of; the product as it appears on Amazon; |
| fba_fulfillment_customer_returns_data__quantity | NUMERIC | quantity (get_fba_fulfillment_customer_returns_data) | quantity (get_fba_fulfillment_customer_returns_data) Number of units; of this item returned; |
| fba_fulfillment_customer_returns_data__reason | TEXT | reason (get_fba_fulfillment_customer_returns_data) | reason (get_fba_fulfillment_customer_returns_data) A short description; of reason for return as indicated by the customer.; See Customer Reason below for explanation; |
| fba_fulfillment_customer_returns_data__return_date | DATE | return-date (get_fba_fulfillment_customer_returns_data) | return-date (get_fba_fulfillment_customer_returns_data) Date returned; merchandise was processed at the fulfillment center.; DD-MM-YYYY.; |
| fba_fulfillment_customer_returns_data__sku | TEXT | sku (get_fba_fulfillment_customer_returns_data) | sku (get_fba_fulfillment_customer_returns_data) Seller's item; identifier; |
| fba_fulfillment_customer_returns_data__status | TEXT | status (get_fba_fulfillment_customer_returns_data) | status (get_fba_fulfillment_customer_returns_data) A short description; of the status of the customer return. Please see; Return Status below for explanation.; |
| fba_fulfillment_inventory_health_data__asin | TEXT | asin (get_fba_inventory_planning_data) | asin (get_fba_inventory_planning_data) Unique blocks of 10 letters or; numbers that Amazon assigns to the products that are sold through; Amazon; |
| fba_fulfillment_inventory_health_data__asin_limit | NUMERIC | asin-limit (get_fba_inventory_planning_data) | asin-limit (get_fba_inventory_planning_data) |
| fba_fulfillment_inventory_health_data__condition | TEXT | condition (get_fba_inventory_planning_data) | condition (get_fba_inventory_planning_data) The condition of the unit; (for example, new or used); |
| fba_fulfillment_inventory_health_data__currency | TEXT | currency (get_fba_inventory_planning_data) | currency (get_fba_inventory_planning_data) The currency for the; estimated long-term storage fee charge; |
| fba_fulfillment_inventory_health_data__fnsku | TEXT | fnsku (get_fba_inventory_planning_data) | fnsku (get_fba_inventory_planning_data) Unique blocks of letters and; numbers that Amazon assigns to products that are stored in and; fulfilled from an Amazon fulfillment center; |
| fba_fulfillment_inventory_health_data__in_bound_quantity | NUMERIC | in-bound-quantity (get_fba_inventory_planning_data) | in-bound-quantity (get_fba_inventory_planning_data) |
| fba_fulfillment_inventory_health_data__inbound_recommend_quantity | NUMERIC | inbound-recommend-quantity (get_fba_inventory_planning_data) | inbound-recommend-quantity (get_fba_inventory_planning_data) |
| fba_fulfillment_inventory_health_data__inv_age_0_to_90_days | NUMERIC | inv-age-0-to-90-days (get_fba_inventory_planning_data) | inv-age-0-to-90-days (get_fba_inventory_planning_data) |
| fba_fulfillment_inventory_health_data__inv_age_181_to_270_days | NUMERIC | inv-age-181-to-270-days (get_fba_inventory_planning_data) | inv-age-181-to-270-days (get_fba_inventory_planning_data) |
| fba_fulfillment_inventory_health_data__inv_age_271_to_365_days | NUMERIC | inv-age-271-to-365-days (get_fba_inventory_planning_data) | inv-age-271-to-365-days (get_fba_inventory_planning_data) |
| fba_fulfillment_inventory_health_data__inv_age_365_plus_days | NUMERIC | inv-age-365-plus-days (get_fba_inventory_planning_data) | inv-age-365-plus-days (get_fba_inventory_planning_data) |
| fba_fulfillment_inventory_health_data__inv_age_91_to_180_days | NUMERIC | inv-age-91-to-180-days (get_fba_inventory_planning_data) | inv-age-91-to-180-days (get_fba_inventory_planning_data) |
| fba_fulfillment_inventory_health_data__is_hazmat | TEXT | is-hazmat (get_fba_inventory_planning_data) | is-hazmat (get_fba_inventory_planning_data) |
| fba_fulfillment_inventory_health_data__lowest_afn_new_price | NUMERIC | lowest-afn-new-price (get_fba_inventory_planning_data) | lowest-afn-new-price (get_fba_inventory_planning_data) |
| fba_fulfillment_inventory_health_data__lowest_afn_used_price | NUMERIC | lowest-afn-used-price (get_fba_inventory_planning_data) | lowest-afn-used-price (get_fba_inventory_planning_data) |
| fba_fulfillment_inventory_health_data__lowest_mfn_new_price | NUMERIC | lowest-mfn-new-price (get_fba_inventory_planning_data) | lowest-mfn-new-price (get_fba_inventory_planning_data) |
| fba_fulfillment_inventory_health_data__lowest_mfn_used_price | NUMERIC | lowest-mfn-used-price (get_fba_inventory_planning_data) | lowest-mfn-used-price (get_fba_inventory_planning_data) |
| fba_fulfillment_inventory_health_data__num_afn_new_sellers | NUMERIC | num-afn-new-sellers (get_fba_inventory_planning_data) | num-afn-new-sellers (get_fba_inventory_planning_data) |
| fba_fulfillment_inventory_health_data__num_afn_used_sellers | NUMERIC | num-afn-used-sellers (get_fba_inventory_planning_data) | num-afn-used-sellers (get_fba_inventory_planning_data) |
| fba_fulfillment_inventory_health_data__per_unit_volume | NUMERIC | per-unit-volume (get_fba_inventory_planning_data) | per-unit-volume (get_fba_inventory_planning_data) |
| fba_fulfillment_inventory_health_data__product_group | TEXT | product-group (get_fba_inventory_planning_data) | product-group (get_fba_inventory_planning_data) Distinct product; grouping distinguishing products like books, from watches or video; games; |
| fba_fulfillment_inventory_health_data__product_name | TEXT | product-name (get_fba_inventory_planning_data) | product-name (get_fba_inventory_planning_data) The name of your; product; |
| fba_fulfillment_inventory_health_data__projected_ltsf_12_mo | NUMERIC | projected-ltsf-12-mo (get_fba_inventory_planning_data) | projected-ltsf-12-mo (get_fba_inventory_planning_data) |
| fba_fulfillment_inventory_health_data__projected_ltsf_6_mo | NUMERIC | projected-ltsf-6-mo (get_fba_inventory_planning_data) | projected-ltsf-6-mo (get_fba_inventory_planning_data) |
| fba_fulfillment_inventory_health_data__qty_in_long_term_storage_program | NUMERIC | qty-in-long-term-storage-program (get_fba_inventory_planning_data) | qty-in-long-term-storage-program (get_fba_inventory_planning_data); |
| fba_fulfillment_inventory_health_data__qty_to_be_charged_ltsf_12_mo | NUMERIC | qty-to-be-charged-ltsf-12-mo (get_fba_inventory_planning_data) | qty-to-be-charged-ltsf-12-mo (get_fba_inventory_planning_data); |
| fba_fulfillment_inventory_health_data__qty_to_be_charged_ltsf_6_mo | NUMERIC | qty-to-be-charged-ltsf-6-mo (get_fba_inventory_planning_data) | qty-to-be-charged-ltsf-6-mo (get_fba_inventory_planning_data); |
| fba_fulfillment_inventory_health_data__qty_with_removals_in_progress | TEXT | qty-with-removals-in-progress (get_fba_inventory_planning_data) | qty-with-removals-in-progress (get_fba_inventory_planning_data); |
| fba_fulfillment_inventory_health_data__sales_price | NUMERIC | sales-price (get_fba_inventory_planning_data) | sales-price (get_fba_inventory_planning_data) |
| fba_fulfillment_inventory_health_data__sales_rank | NUMERIC | sales-rank (get_fba_inventory_planning_data) | sales-rank (get_fba_inventory_planning_data) The current rank for your; product. The change in sales rank value is the plus or minus change in; the past 7 days.; |
| fba_fulfillment_inventory_health_data__sellable_quantity | NUMERIC | sellable-quantity (get_fba_inventory_planning_data) | sellable-quantity (get_fba_inventory_planning_data) |
| fba_fulfillment_inventory_health_data__sku | TEXT | sku (get_fba_inventory_planning_data) | sku (get_fba_inventory_planning_data) Unique blocks of letters and; numbers that you assign to the products that you are selling; |
| fba_fulfillment_inventory_health_data__snapshot_date | DATE | snapshot-date (get_fba_inventory_planning_data) | snapshot-date (get_fba_inventory_planning_data) The date the report; was generated; |
| fba_fulfillment_inventory_health_data__total_quantity | NUMERIC | total-quantity (get_fba_inventory_planning_data) | total-quantity (get_fba_inventory_planning_data) |
| fba_fulfillment_inventory_health_data__units_shipped_last_180_days | NUMERIC | units-shipped-last-180-days (get_fba_inventory_planning_data) | units-shipped-last-180-days (get_fba_inventory_planning_data); |
| fba_fulfillment_inventory_health_data__units_shipped_last_24_hrs | NUMERIC | units-shipped-last-24-hrs (get_fba_inventory_planning_data) | units-shipped-last-24-hrs (get_fba_inventory_planning_data) |
| fba_fulfillment_inventory_health_data__units_shipped_last_30_days | NUMERIC | units-shipped-last-30-days (get_fba_inventory_planning_data) | units-shipped-last-30-days (get_fba_inventory_planning_data) |
| fba_fulfillment_inventory_health_data__units_shipped_last_365_days | NUMERIC | units-shipped-last-365-days (get_fba_inventory_planning_data) | units-shipped-last-365-days (get_fba_inventory_planning_data); |
| fba_fulfillment_inventory_health_data__units_shipped_last_7_days | NUMERIC | units-shipped-last-7-days (get_fba_inventory_planning_data) | units-shipped-last-7-days (get_fba_inventory_planning_data) |
| fba_fulfillment_inventory_health_data__units_shipped_last_90_days | NUMERIC | units-shipped-last-90-days (get_fba_inventory_planning_data) | units-shipped-last-90-days (get_fba_inventory_planning_data) |
| fba_fulfillment_inventory_health_data__unsellable_quantity | NUMERIC | unsellable-quantity (get_fba_inventory_planning_data) | unsellable-quantity (get_fba_inventory_planning_data) |
| fba_fulfillment_inventory_health_data__weeks_of_cover_t180 | TEXT | weeks-of-cover-t180 (get_fba_inventory_planning_data) | weeks-of-cover-t180 (get_fba_inventory_planning_data) |
| fba_fulfillment_inventory_health_data__weeks_of_cover_t30 | TEXT | weeks-of-cover-t30 (get_fba_inventory_planning_data) | weeks-of-cover-t30 (get_fba_inventory_planning_data) Your historical; trailing 30-day on-hand inventory average divided by your units sold; over the same time period divided by 4 weeks. If you sold 400 units of; a given item in the last 30 days (4 weeks) and had 100 sellable units; in fulfillment centers, your weeks of cover last 30 days would be 1.; |
| fba_fulfillment_inventory_health_data__weeks_of_cover_t365 | TEXT | weeks-of-cover-t365 (get_fba_inventory_planning_data) | weeks-of-cover-t365 (get_fba_inventory_planning_data) |
| fba_fulfillment_inventory_health_data__weeks_of_cover_t7 | TEXT | weeks-of-cover-t7 (get_fba_inventory_planning_data) | weeks-of-cover-t7 (get_fba_inventory_planning_data) |
| fba_fulfillment_inventory_health_data__weeks_of_cover_t90 | TEXT | weeks-of-cover-t90 (get_fba_inventory_planning_data) | weeks-of-cover-t90 (get_fba_inventory_planning_data) Your historical; trailing 90-day on-hand inventory average divided by your units sold; over the same time period divided by 12 weeks. If you sold 400 units; of a given item in the last 90 days (12 weeks) and had an average of; 10 sellable units in fulfillment centers, your weeks of cover last 90; days would be 3.33.; |
| fba_fulfillment_inventory_health_data__your_price | NUMERIC | your-price (get_fba_inventory_planning_data) | your-price (get_fba_inventory_planning_data) Your listed price; |
| fba_inventory_planning_data__alert | TEXT | alert (get_fba_inventory_planning_data) | alert (get_fba_inventory_planning_data) This is displayed when an item; has a low-traffic or low-conversion alert. Low traffic indicates; that a low number of potential buyers have seen the listing. Low; conversion indicates that potential buyers are viewing the listing but; aren’t following through to buy the product.; |
| fba_inventory_planning_data__available | NUMERIC | available (get_fba_inventory_planning_data) | available (get_fba_inventory_planning_data) Available (sellable; inventory) quantity; |
| fba_inventory_planning_data__days_of_supply | NUMERIC | days-of-supply (get_fba_inventory_planning_data) | days-of-supply (get_fba_inventory_planning_data) The estimated number; of days that your current inventory supply will last based on the; projected demand for your product; |
| fba_inventory_planning_data__estimated_cost_savings_of_recommended_actions | NUMERIC | estimated-cost-savings-of-recommended-actions (get_fba_inventory_planning_data) | estimated-cost-savings-of-recommended-actions; (get_fba_inventory_planning_data) Estimated cost savings between; taking the recommended action versus the storage fees you would incur; on that inventory by taking no action; |
| fba_inventory_planning_data__estimated_excess_quantity | NUMERIC | estimated-excess-quantity (get_fba_inventory_planning_data) | estimated-excess-quantity (get_fba_inventory_planning_data) Estimated; excess units are overstocked units based on your current sales; velocity and customer demand forecast. It’s costing you more to keep; these units on hand and pay storage fees than to reduce the number of; units through a price reduction or removal.; |
| fba_inventory_planning_data__estimated_ltsf_next_charge | TEXT | estimated-ltsf-next-charge (get_fba_inventory_planning_data) | estimated-ltsf-next-charge (get_fba_inventory_planning_data) |
| fba_inventory_planning_data__estimated_storage_cost_next_month | NUMERIC | estimated-storage-cost-next-month (get_fba_inventory_planning_data) | estimated-storage-cost-next-month (get_fba_inventory_planning_data); Estimated storage fees (monthly storage + long-term storage) that you; would incur 30 days from today, based on your current sales rate.; Note: Inventory costs are based on quantities in the latest daily; snapshot and may differ from your actual inventory quantities.; |
| fba_inventory_planning_data__featuredoffer_price | NUMERIC | featuredoffer-price (get_fba_inventory_planning_data) | featuredoffer-price (get_fba_inventory_planning_data) Offer displayed; on a product detail page with an Add to Cart button; |
| fba_inventory_planning_data__healthy_inventory_level | NUMERIC | healthy-inventory-level (get_fba_inventory_planning_data) | healthy-inventory-level (get_fba_inventory_planning_data) Quantity of; inventory that is not considered excess based on product demand and; your costs. Our recommendations are based on helping you reach this; level of inventory.; |
| fba_inventory_planning_data__inbound_quantity | NUMERIC | inbound-quantity (get_fba_inventory_planning_data) | inbound-quantity (get_fba_inventory_planning_data) Inbound quantity =; inbound-working + inbound-shipped + inbound receiving; |
| fba_inventory_planning_data__inbound_received | NUMERIC | inbound-received (get_fba_inventory_planning_data) | inbound-received (get_fba_inventory_planning_data) Shipments in; receiving status; |
| fba_inventory_planning_data__inbound_shipped | NUMERIC | inbound-shipped (get_fba_inventory_planning_data) | inbound-shipped (get_fba_inventory_planning_data) Shipments in shipped; status; |
| fba_inventory_planning_data__inbound_working | NUMERIC | inbound-working (get_fba_inventory_planning_data) | inbound-working (get_fba_inventory_planning_data) Shipments in working; status; |
| fba_inventory_planning_data__inv_age_0_to_30_days | TEXT | inv-age-0-to-30-days (get_fba_inventory_planning_data) | inv-age-0-to-30-days (get_fba_inventory_planning_data) |
| fba_inventory_planning_data__inv_age_181_to_330_days | TEXT | inv-age-181-to-330-days (get_fba_inventory_planning_data) | inv-age-181-to-330-days (get_fba_inventory_planning_data) |
| fba_inventory_planning_data__inv_age_31_to_60_days | TEXT | inv-age-31-to-60-days (get_fba_inventory_planning_data) | inv-age-31-to-60-days (get_fba_inventory_planning_data) |
| fba_inventory_planning_data__inv_age_331_to_365_days | TEXT | inv-age-331-to-365-days (get_fba_inventory_planning_data) | inv-age-331-to-365-days (get_fba_inventory_planning_data) |
| fba_inventory_planning_data__inv_age_61_to_90_days | TEXT | inv-age-61-to-90-days (get_fba_inventory_planning_data) | inv-age-61-to-90-days (get_fba_inventory_planning_data) |
| fba_inventory_planning_data__item_volume | NUMERIC | item-volume (get_fba_inventory_planning_data) | item-volume (get_fba_inventory_planning_data) The volume of the item,; which is calculated by multiplying the longest side, median side, and; shortest side together. These measurements generally correspond to the; length, width, and height of the item.; |
| fba_inventory_planning_data__lowest_price_new_plus_shipping | TEXT | lowest-price-new-plus-shipping (get_fba_inventory_planning_data) | lowest-price-new-plus-shipping (get_fba_inventory_planning_data); |
| fba_inventory_planning_data__lowest_price_used | TEXT | lowest-price-used (get_fba_inventory_planning_data) | lowest-price-used (get_fba_inventory_planning_data) |
| fba_inventory_planning_data__marketplace | TEXT | marketplace (get_fba_inventory_planning_data) | marketplace (get_fba_inventory_planning_data) The Amazon store where; the product is located; |
| fba_inventory_planning_data__no_sale_last_6_months | NUMERIC | no-sale-last-6-months (get_fba_inventory_planning_data) | no-sale-last-6-months (get_fba_inventory_planning_data) Inventory that; has not sold in six or more consecutive months and that have been in; fulfillment centers for more than 180 days. These units will be; automatically removed during the next removal cycle if you are opted; in to automated fulfillable inventory removals.; |
| fba_inventory_planning_data__pending_removal_quantity | NUMERIC | pending-removal-quantity (get_fba_inventory_planning_data) | pending-removal-quantity (get_fba_inventory_planning_data) The number; of units that you have asked to be returned to you or disposed of; |
| fba_inventory_planning_data__projected_ltsf_9_mo | TEXT | projected-ltsf-9-mo (get_fba_inventory_planning_data) | projected-ltsf-9-mo (get_fba_inventory_planning_data) |
| fba_inventory_planning_data__qty_to_be_charged_ltsf_9_mo | TEXT | qty-to-be-charged-ltsf-9-mo (get_fba_inventory_planning_data) | qty-to-be-charged-ltsf-9-mo (get_fba_inventory_planning_data); |
| fba_inventory_planning_data__recommended_action | TEXT | recommended-action (get_fba_inventory_planning_data) | recommended-action (get_fba_inventory_planning_data) The action; recommended for your inventory. Recommendations are based on your; current customer demand and on whether it would cost you less to take; an action than to do nothing.; |
| fba_inventory_planning_data__recommended_removal_quantity | NUMERIC | recommended-removal-quantity (get_fba_inventory_planning_data) | recommended-removal-quantity (get_fba_inventory_planning_data); Estimated number of units that would likely benefit from removal; instead of being charged storage fees; |
| fba_inventory_planning_data__recommended_sale_duration_days | NUMERIC | recommended-sale-duration-days (get_fba_inventory_planning_data) | recommended-sale-duration-days (get_fba_inventory_planning_data) If a; sale is recommended, this is the estimated sale duration in days that; would likely help you sell through your excess inventory.; |
| fba_inventory_planning_data__recommended_sales_price | NUMERIC | recommended-sales-price (get_fba_inventory_planning_data) | recommended-sales-price (get_fba_inventory_planning_data) Sales price; recommended to help you sell through your inventory based on your; current inventory settings. This value may be different from the; lowest price or Featured Offer price. We recommend that you keep your; product at this price until you have sold through your excess; inventory.; |
| fba_inventory_planning_data__sales_shipped_last_30_days | NUMERIC | sales-shipped-last-30-days (get_fba_inventory_planning_data) | sales-shipped-last-30-days (get_fba_inventory_planning_data) Shipped-; unit sales in the last 30 days; |
| fba_inventory_planning_data__sales_shipped_last_60_days | NUMERIC | sales-shipped-last-60-days (get_fba_inventory_planning_data) | sales-shipped-last-60-days (get_fba_inventory_planning_data) Shipped-; unit sales in the last 60 days; |
| fba_inventory_planning_data__sales_shipped_last_7_days | NUMERIC | sales-shipped-last-7-days (get_fba_inventory_planning_data) | sales-shipped-last-7-days (get_fba_inventory_planning_data) Shipped-; unit sales in the last 7 days; |
| fba_inventory_planning_data__sales_shipped_last_90_days | NUMERIC | sales-shipped-last-90-days (get_fba_inventory_planning_data) | sales-shipped-last-90-days (get_fba_inventory_planning_data) Shipped-; unit sales in the last 90 days; |
| fba_inventory_planning_data__sell_through | NUMERIC | sell-through (get_fba_inventory_planning_data) | sell-through (get_fba_inventory_planning_data) The rate at which your; units sold and shipped over the past 90 days divided by the average; inventory available at fulfillment centers during that time. Tracking; your sell-through rate can help you determine whether you need to take; action to improve traffic or conversion for your products.; |
| fba_inventory_planning_data__storage_type | TEXT | storage-type (get_fba_inventory_planning_data) | storage-type (get_fba_inventory_planning_data) Storage-type category; of the product for which storage limits are set. Note: Standard size; includes small and standard types.; |
| fba_inventory_planning_data__storage_volume | NUMERIC | storage-volume (get_fba_inventory_planning_data) | storage-volume (get_fba_inventory_planning_data) Storage volume is the; total usage for this product in our fulfillment centers minus; inventory that is pending removal; |
| fba_inventory_planning_data__units_shipped_t30 | NUMERIC | units-shipped-t30 (get_fba_inventory_planning_data) | units-shipped-t30 (get_fba_inventory_planning_data) Units shipped in; the last 30 days; |
| fba_inventory_planning_data__units_shipped_t60 | NUMERIC | units-shipped-t60 (get_fba_inventory_planning_data) | units-shipped-t60 (get_fba_inventory_planning_data) Units shipped in; the last 60 days; |
| fba_inventory_planning_data__units_shipped_t7 | NUMERIC | units-shipped-t7 (get_fba_inventory_planning_data) | units-shipped-t7 (get_fba_inventory_planning_data) Units shipped in; the last 7 days; |
| fba_inventory_planning_data__units_shipped_t90 | NUMERIC | units-shipped-t90 (get_fba_inventory_planning_data) | units-shipped-t90 (get_fba_inventory_planning_data) Units shipped in; the last 90 days; |
| fba_inventory_planning_data__volume_unit_measurement | TEXT | volume-unit-measurement (get_fba_inventory_planning_data) | volume-unit-measurement (get_fba_inventory_planning_data) Unit of; measurement for the volume of the item; |
| fba_myi_unsuppressed_inventory_data__afn_fulfillable_quantity | NUMERIC | afn-fulfillable-quantity (get_fba_myi_unsuppressed_inventory_data) | afn-fulfillable-quantity (get_fba_myi_unsuppressed_inventory_data) The; number of units you have for a SKU in Amazon fulfillment centers; that can be picked, packed, and shipped.; |
| fba_myi_unsuppressed_inventory_data__afn_future_supply_buyable | NUMERIC | afn-future-supply-buyable (get_fba_myi_unsuppressed_inventory_data) | afn-future-supply-buyable (get_fba_myi_unsuppressed_inventory_data); The number of units available for customers to find and buy while; inventory is on its way to an Amazon fulfillment center through In-; Stock Head Start.; |
| fba_myi_unsuppressed_inventory_data__afn_inbound_receiving_quantity | NUMERIC | afn-inbound-receiving-quantity (get_fba_myi_unsuppressed_inventory_data) | afn-inbound-receiving-quantity; (get_fba_myi_unsuppressed_inventory_data) The number of units you have; for a SKU 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.; |
| fba_myi_unsuppressed_inventory_data__afn_inbound_shipped_quantity | NUMERIC | afn-inbound-shipped-quantity (get_fba_myi_unsuppressed_inventory_data) | afn-inbound-shipped-quantity (get_fba_myi_unsuppressed_inventory_data); The number of units you have for a SKU in an inbound shipment that you; have notified Amazon about and provided a tracking number.; |
| fba_myi_unsuppressed_inventory_data__afn_inbound_working_quantity | NUMERIC | afn-inbound-working-quantity (get_fba_myi_unsuppressed_inventory_data) | afn-inbound-working-quantity (get_fba_myi_unsuppressed_inventory_data); The number of units you have for a SKU in an inbound shipment that you; have notified Amazon about.; |
| fba_myi_unsuppressed_inventory_data__afn_listing_exists | TEXT | afn-listing-exists (get_fba_myi_unsuppressed_inventory_data) | afn-listing-exists (get_fba_myi_unsuppressed_inventory_data) "Yes"; indicates that the item is listed for Fulfillment by; Amazon.; |
| fba_myi_unsuppressed_inventory_data__afn_researching_quantity | NUMERIC | afn-researching-quantity (get_fba_myi_unsuppressed_inventory_data) | afn-researching-quantity (get_fba_myi_unsuppressed_inventory_data); |
| fba_myi_unsuppressed_inventory_data__afn_reserved_future_supply | NUMERIC | afn-reserved-future-supply (get_fba_myi_unsuppressed_inventory_data) | afn-reserved-future-supply (get_fba_myi_unsuppressed_inventory_data); The number of units that customers have purchased while inventory is; on its way to an Amazon fulfillment center; through In-Stock Head Start.; |
| fba_myi_unsuppressed_inventory_data__afn_reserved_quantity | NUMERIC | afn-reserved-quantity (get_fba_myi_unsuppressed_inventory_data) | afn-reserved-quantity (get_fba_myi_unsuppressed_inventory_data) The; number of units you have for a SKU in Amazon fulfillment centers; that are currently being picked, packed, and shipped or are sidelined; for measurement, sampling, or other internal; processes.; |
| fba_myi_unsuppressed_inventory_data__afn_total_quantity | NUMERIC | afn-total-quantity (get_fba_myi_unsuppressed_inventory_data) | afn-total-quantity (get_fba_myi_unsuppressed_inventory_data) The total; number of units you have for a SKU in an inbound shipment or; in Amazon fulfillment centers: (afn-total-quantity) =; (afn-warehouse-quantity) + (afn-inbound-working-quantity) +; (afn-inbound-shipped-quantity) + (afn-inbound-receiving-quantity); |
| fba_myi_unsuppressed_inventory_data__afn_unsellable_quantity | NUMERIC | afn-unsellable-quantity (get_fba_myi_unsuppressed_inventory_data) | afn-unsellable-quantity (get_fba_myi_unsuppressed_inventory_data) The; number of units you have for a SKU in Amazon fulfillment centers in; unsellable condition.; |
| fba_myi_unsuppressed_inventory_data__afn_warehouse_quantity | NUMERIC | afn-warehouse-quantity (get_fba_myi_unsuppressed_inventory_data) | afn-warehouse-quantity (get_fba_myi_unsuppressed_inventory_data) The; number of units you have for an SKU in Amazon fulfillment centers; that have been processed: (afn-warehouse-quantity) =; (afn-fulfillable-quantity) + (afn-unsellable-quantity) +; (afn-reserved-quantity).; |
| fba_myi_unsuppressed_inventory_data__asin | TEXT | asin (get_fba_myi_unsuppressed_inventory_data) | asin (get_fba_myi_unsuppressed_inventory_data) Amazon Standard; Identification Numbers (ASINs) are unique blocks of 10; letters or numbers that identify items. ASINs are assigned by Amazon.; You can find the ASIN on the product detail; page.; |
| fba_myi_unsuppressed_inventory_data__condition | TEXT | condition (get_fba_myi_unsuppressed_inventory_data) | condition (get_fba_myi_unsuppressed_inventory_data) The condition of; your product.; |
| fba_myi_unsuppressed_inventory_data__fnsku | TEXT | fnsku (get_fba_myi_unsuppressed_inventory_data) | fnsku (get_fba_myi_unsuppressed_inventory_data) Fulfillment Network; Stock Keeping Units (FNSKUs) are unique identifiers; assigned by Amazon to products stored in and fulfilled from Amazon; fulfillment centers.; |
| fba_myi_unsuppressed_inventory_data__mfn_fulfillable_quantity | TEXT | mfn-fulfillable-quantity (get_fba_myi_unsuppressed_inventory_data) | mfn-fulfillable-quantity (get_fba_myi_unsuppressed_inventory_data) The; quantity in your fulfillment network that can be picked, packed, and; shipped.; |
| fba_myi_unsuppressed_inventory_data__mfn_listing_exists | TEXT | mfn-listing-exists (get_fba_myi_unsuppressed_inventory_data) | mfn-listing-exists (get_fba_myi_unsuppressed_inventory_data) "Yes"; indicates that the product is listed for fulfillment by you as the; seller.; |
| fba_myi_unsuppressed_inventory_data__per_unit_volume | NUMERIC | per-unit-volume (get_fba_myi_unsuppressed_inventory_data) | per-unit-volume (get_fba_myi_unsuppressed_inventory_data) The volume; in cubic feet of one unit (to the nearest; 1/100 of an inch).; |
| fba_myi_unsuppressed_inventory_data__product_name | TEXT | product-name (get_fba_myi_unsuppressed_inventory_data) | product-name (get_fba_myi_unsuppressed_inventory_data) The title of; your product.; |
| fba_myi_unsuppressed_inventory_data__sku | TEXT | sku (get_fba_myi_unsuppressed_inventory_data) | sku (get_fba_myi_unsuppressed_inventory_data) Stock Keeping Units; (SKUs) are unique blocks of letters or numbers that; identify your products.; |
| fba_myi_unsuppressed_inventory_data__your_price | NUMERIC | your-price (get_fba_myi_unsuppressed_inventory_data) | your-price (get_fba_myi_unsuppressed_inventory_data) Your current; selling price.; |
| fba_reimbursements_data__amazon_order_id | TEXT | amazon-order-id (get_fba_reimbursements_data) | amazon-order-id (get_fba_reimbursements_data) The unique identifier; assigned to the customer order. This field is; empty if the reimbursement is not associated with an order.; |
| fba_reimbursements_data__amount_per_unit | NUMERIC | amount-per-unit (get_fba_reimbursements_data) | amount-per-unit (get_fba_reimbursements_data) The per-unit; reimbursement amount for this line item.; |
| fba_reimbursements_data__amount_total | NUMERIC | amount-total (get_fba_reimbursements_data) | amount-total (get_fba_reimbursements_data) The total amount of the; cash reimbursement for this line item.; |
| fba_reimbursements_data__approval_date | DATE | approval-date (get_fba_reimbursements_data) | approval-date (get_fba_reimbursements_data) The date the reimbursement; was approved.; |
| fba_reimbursements_data__asin | TEXT | asin (get_fba_reimbursements_data) | asin (get_fba_reimbursements_data) An ASIN (Amazon Standard; Identification Numbers) is a unique identifier; assigned by Amazon to products in the Amazon product catalog. The ASIN; can be found on the product detail page.; |
| fba_reimbursements_data__case_id | TEXT | case-id (get_fba_reimbursements_data) | case-id (get_fba_reimbursements_data) The unique identifier assigned; to the case when you request a reimbursement.; |
| fba_reimbursements_data__condition | TEXT | condition (get_fba_reimbursements_data) | condition (get_fba_reimbursements_data) The condition of your item; (for example, New).; |
| fba_reimbursements_data__currency_unit | TEXT | currency-unit (get_fba_reimbursements_data) | currency-unit (get_fba_reimbursements_data) The currency for the; applicable marketplace.; |
| fba_reimbursements_data__fnsku | TEXT | fnsku (get_fba_reimbursements_data) | fnsku (get_fba_reimbursements_data) The fulfillment network SKU (stock; keeping unit) is the unique identifier; Fulfillment by Amazon assigned to your product.; |
| fba_reimbursements_data__original_reimbursement_id | TEXT | original-reimbursement-id (get_fba_reimbursements_data) | original-reimbursement-id (get_fba_reimbursements_data) |
| fba_reimbursements_data__original_reimbursement_type | TEXT | original-reimbursement-type (get_fba_reimbursements_data) | original-reimbursement-type (get_fba_reimbursements_data) |
| fba_reimbursements_data__product_name | TEXT | product-name (get_fba_reimbursements_data) | product-name (get_fba_reimbursements_data) The name of your product.; |
| fba_reimbursements_data__quantity_reimbursed_cash | NUMERIC | quantity-reimbursed-cash (get_fba_reimbursements_data) | quantity-reimbursed-cash (get_fba_reimbursements_data) The total; number of units reimbursed with cash.; |
| fba_reimbursements_data__quantity_reimbursed_inventory | NUMERIC | quantity-reimbursed-inventory (get_fba_reimbursements_data) | quantity-reimbursed-inventory (get_fba_reimbursements_data) The number; of units reimbursed with inventory.; |
| fba_reimbursements_data__quantity_reimbursed_total | NUMERIC | quantity-reimbursed-total (get_fba_reimbursements_data) | quantity-reimbursed-total (get_fba_reimbursements_data) The total; number of units reimbursed with either cash or inventory; (Quantity Reimbursed [Cash] + Quantity Reimbursed [Inventory]).; |
| fba_reimbursements_data__reason | TEXT | reason (get_fba_reimbursements_data) | reason (get_fba_reimbursements_data) The reason for the reimbursement; (for example, Damaged: Warehouse).; |
| fba_reimbursements_data__reimbursement_id | TEXT | reimbursement-id (get_fba_reimbursements_data) | reimbursement-id (get_fba_reimbursements_data) The unique identifier; for this reimbursement. Each reimbursement may; include multiple line items.; |
| fba_reimbursements_data__sku | TEXT | sku (get_fba_reimbursements_data) | sku (get_fba_reimbursements_data) |
| fba_uno_inventory_data__asin | TEXT | asin (get_fba_uno_inventory_data) | asin (get_fba_uno_inventory_data) |
| fba_uno_inventory_data__price | NUMERIC | price (get_fba_uno_inventory_data) | price (get_fba_uno_inventory_data) |
| fba_uno_inventory_data__quantity | NUMERIC | quantity (get_fba_uno_inventory_data) | quantity (get_fba_uno_inventory_data) |
| fba_uno_inventory_data__sku | TEXT | sku (get_fba_uno_inventory_data) | sku (get_fba_uno_inventory_data) |
| flat_file_all_orders_data_by_last_update_general__amazon_order_id | TEXT | amazon-order-id (get_flat_file_all_orders_data_by_last_update_general) | amazon-order-id (get_flat_file_all_orders_data_by_last_update_general); |
| flat_file_all_orders_data_by_last_update_general__asin | TEXT | asin (get_flat_file_all_orders_data_by_last_update_general) | asin (get_flat_file_all_orders_data_by_last_update_general) |
| flat_file_all_orders_data_by_last_update_general__currency | TEXT | currency (get_flat_file_all_orders_data_by_last_update_general) | currency (get_flat_file_all_orders_data_by_last_update_general); Currency type Example: USD; |
| flat_file_all_orders_data_by_last_update_general__fulfillment_channel | TEXT | fulfillment-channel (get_flat_file_all_orders_data_by_last_update_general) | fulfillment-channel; (get_flat_file_all_orders_data_by_last_update_general); |
| flat_file_all_orders_data_by_last_update_general__gift_wrap_price | NUMERIC | gift-wrap-price (get_flat_file_all_orders_data_by_last_update_general) | gift-wrap-price (get_flat_file_all_orders_data_by_last_update_general); The price of the gift wrap selected by the buyer.; |
| flat_file_all_orders_data_by_last_update_general__gift_wrap_tax | NUMERIC | gift-wrap-tax (get_flat_file_all_orders_data_by_last_update_general) | gift-wrap-tax (get_flat_file_all_orders_data_by_last_update_general); The amount of tax paid on the gift wrap.; |
| flat_file_all_orders_data_by_last_update_general__is_business_order | TEXT | is-business-order (get_flat_file_all_orders_data_by_last_update_general) | is-business-order; (get_flat_file_all_orders_data_by_last_update_general) Indicates if; the order is from an Amazon Business customer.Example: true, false; |
| flat_file_all_orders_data_by_last_update_general__item_price | NUMERIC | item-price (get_flat_file_all_orders_data_by_last_update_general) | item-price (get_flat_file_all_orders_data_by_last_update_general); Price a buyer paid for the item(s). All amounts are aggregates of the; quantity, not unit prices.Example: Item Price = $10 Quantity = 2 Item; price displayed = $20; |
| flat_file_all_orders_data_by_last_update_general__item_promotion_discount | TEXT | item-promotion-discount (get_flat_file_all_orders_data_by_last_update_general) | item-promotion-discount; (get_flat_file_all_orders_data_by_last_update_general) Amount; discounted from orders that qualify for either a money-off or a; percent-off promotion.; |
| flat_file_all_orders_data_by_last_update_general__item_status | TEXT | item-status (get_flat_file_all_orders_data_by_last_update_general) | item-status (get_flat_file_all_orders_data_by_last_update_general); |
| flat_file_all_orders_data_by_last_update_general__item_tax | NUMERIC | item-tax (get_flat_file_all_orders_data_by_last_update_general) | item-tax (get_flat_file_all_orders_data_by_last_update_general); |
| flat_file_all_orders_data_by_last_update_general__last_updated_date | DATE | last-updated-date (get_flat_file_all_orders_data_by_last_update_general) | last-updated-date; (get_flat_file_all_orders_data_by_last_update_general); |
| flat_file_all_orders_data_by_last_update_general__merchant_order_id | TEXT | merchant-order-id (get_flat_file_all_orders_data_by_last_update_general) | merchant-order-id; (get_flat_file_all_orders_data_by_last_update_general); |
| flat_file_all_orders_data_by_last_update_general__order_channel | TEXT | order-channel (get_flat_file_all_orders_data_by_last_update_general) | order-channel (get_flat_file_all_orders_data_by_last_update_general); Information about how an order was placed.; |
| flat_file_all_orders_data_by_last_update_general__order_status | TEXT | order-status (get_flat_file_all_orders_data_by_last_update_general) | order-status (get_flat_file_all_orders_data_by_last_update_general); |
| flat_file_all_orders_data_by_last_update_general__price_designation | TEXT | price-designation (get_flat_file_all_orders_data_by_last_update_general) | price-designation; (get_flat_file_all_orders_data_by_last_update_general) Indicates the; type of business price that the buyer used. Learn more about business; prices. (Amazon Business Seller Program only.); |
| flat_file_all_orders_data_by_last_update_general__product_name | TEXT | product-name (get_flat_file_all_orders_data_by_last_update_general) | product-name (get_flat_file_all_orders_data_by_last_update_general); Short title for the product, displayed on the product detail page and; in the browser title bar.Example: Snowboard; |
| flat_file_all_orders_data_by_last_update_general__promotion_ids | TEXT | promotion-ids (get_flat_file_all_orders_data_by_last_update_general) | promotion-ids (get_flat_file_all_orders_data_by_last_update_general); |
| flat_file_all_orders_data_by_last_update_general__purchase_date | DATE | purchase-date (get_flat_file_all_orders_data_by_last_update_general) | purchase-date (get_flat_file_all_orders_data_by_last_update_general); Date the order was placed, in yyyy-mm-dd format. Note: Unless you; specify a different shipping lead time, you have agreed to ship the; order within two business days of this date.; |
| flat_file_all_orders_data_by_last_update_general__purchase_order_number | TEXT | purchase-order-number (get_flat_file_all_orders_data_by_last_update_general) | purchase-order-number; (get_flat_file_all_orders_data_by_last_update_general) The buyer's; purchase order number (for orders from Amazon Business customers).; This must be included on the customer package packing slip or on the; package shipping label. For more information on packing slips and; purchase order numbers, click here.; |
| flat_file_all_orders_data_by_last_update_general__quantity | TEXT | quantity (get_flat_file_all_orders_data_by_last_update_general) | quantity (get_flat_file_all_orders_data_by_last_update_general); |
| flat_file_all_orders_data_by_last_update_general__sales_channel | TEXT | sales-channel (get_flat_file_all_orders_data_by_last_update_general) | sales-channel (get_flat_file_all_orders_data_by_last_update_general); |
| flat_file_all_orders_data_by_last_update_general__ship_city | TEXT | ship-city (get_flat_file_all_orders_data_by_last_update_general) | ship-city (get_flat_file_all_orders_data_by_last_update_general) City; of "Ship To" address.; |
| flat_file_all_orders_data_by_last_update_general__ship_country | TEXT | ship-country (get_flat_file_all_orders_data_by_last_update_general) | ship-country (get_flat_file_all_orders_data_by_last_update_general); International Standards Organization two-letter country code (ISO; 3166-2 compliant).Example: US; |
| flat_file_all_orders_data_by_last_update_general__ship_postal_code | TEXT | ship-postal-code (get_flat_file_all_orders_data_by_last_update_general) | ship-postal-code; (get_flat_file_all_orders_data_by_last_update_general) ZIP code or; postal code of "Ship To" address. Value format depends on destination; country.; |
| flat_file_all_orders_data_by_last_update_general__ship_promotion_discount | TEXT | ship-promotion-discount (get_flat_file_all_orders_data_by_last_update_general) | ship-promotion-discount; (get_flat_file_all_orders_data_by_last_update_general); |
| flat_file_all_orders_data_by_last_update_general__ship_service_level | TEXT | ship-service-level (get_flat_file_all_orders_data_by_last_update_general) | ship-service-level; (get_flat_file_all_orders_data_by_last_update_general) Type of; shipping selected by the buyer when ordering the item; for example,; standard, expedited.; |
| flat_file_all_orders_data_by_last_update_general__ship_state | TEXT | ship-state (get_flat_file_all_orders_data_by_last_update_general) | ship-state (get_flat_file_all_orders_data_by_last_update_general); State, province, or region of "Ship To" address. Varies with country; of origin. Note: Abbreviations can vary depending on how it was; entered by the buyer.; |
| flat_file_all_orders_data_by_last_update_general__shipping_price | NUMERIC | shipping-price (get_flat_file_all_orders_data_by_last_update_general) | shipping-price (get_flat_file_all_orders_data_by_last_update_general); Price a buyer paid for shipping. All amounts are aggregates of the; quantity, not unit prices.; |
| flat_file_all_orders_data_by_last_update_general__shipping_tax | TEXT | shipping-tax (get_flat_file_all_orders_data_by_last_update_general) | shipping-tax (get_flat_file_all_orders_data_by_last_update_general); |
| flat_file_all_orders_data_by_last_update_general__sku | TEXT | sku (get_flat_file_all_orders_data_by_last_update_general) | sku (get_flat_file_all_orders_data_by_last_update_general) Stock; Keeping Unit. The seller-defined unique identifier for a product.; Example: AA786936215595; |
| flat_file_all_orders_data_by_order_date_general__amazon_order_id | TEXT | amazon-order-id (get_flat_file_all_orders_data_by_order_date_general) | amazon-order-id (get_flat_file_all_orders_data_by_order_date_general); |
| flat_file_all_orders_data_by_order_date_general__asin | TEXT | asin (get_flat_file_all_orders_data_by_order_date_general) | asin (get_flat_file_all_orders_data_by_order_date_general) |
| flat_file_all_orders_data_by_order_date_general__currency | TEXT | currency (get_flat_file_all_orders_data_by_order_date_general) | currency (get_flat_file_all_orders_data_by_order_date_general); Currency type Example: USD; |
| flat_file_all_orders_data_by_order_date_general__fulfillment_channel | TEXT | fulfillment-channel (get_flat_file_all_orders_data_by_order_date_general) | fulfillment-channel; (get_flat_file_all_orders_data_by_order_date_general); |
| flat_file_all_orders_data_by_order_date_general__gift_wrap_price | NUMERIC | gift-wrap-price (get_flat_file_all_orders_data_by_order_date_general) | gift-wrap-price (get_flat_file_all_orders_data_by_order_date_general); The price of the gift wrap selected by the buyer.; |
| flat_file_all_orders_data_by_order_date_general__gift_wrap_tax | NUMERIC | gift-wrap-tax (get_flat_file_all_orders_data_by_order_date_general) | gift-wrap-tax (get_flat_file_all_orders_data_by_order_date_general); The amount of tax paid on the gift wrap.; |
| flat_file_all_orders_data_by_order_date_general__is_business_order | TEXT | is-business-order (get_flat_file_all_orders_data_by_order_date_general) | is-business-order; (get_flat_file_all_orders_data_by_order_date_general) Indicates if the; order is from an Amazon Business customer.Example: true, false; |
| flat_file_all_orders_data_by_order_date_general__item_price | NUMERIC | item-price (get_flat_file_all_orders_data_by_order_date_general) | item-price (get_flat_file_all_orders_data_by_order_date_general) Price; a buyer paid for the item(s). All amounts are aggregates of the; quantity, not unit prices.Example: Item Price = $10 Quantity = 2 Item; price displayed = $20; |
| flat_file_all_orders_data_by_order_date_general__item_promotion_discount | TEXT | item-promotion-discount (get_flat_file_all_orders_data_by_order_date_general) | item-promotion-discount; (get_flat_file_all_orders_data_by_order_date_general) Amount; discounted from orders that qualify for either a money-off or a; percent-off promotion.; |
| flat_file_all_orders_data_by_order_date_general__item_status | TEXT | item-status (get_flat_file_all_orders_data_by_order_date_general) | item-status (get_flat_file_all_orders_data_by_order_date_general); |
| flat_file_all_orders_data_by_order_date_general__item_tax | NUMERIC | item-tax (get_flat_file_all_orders_data_by_order_date_general) | item-tax (get_flat_file_all_orders_data_by_order_date_general); |
| flat_file_all_orders_data_by_order_date_general__last_updated_date | DATE | last-updated-date (get_flat_file_all_orders_data_by_order_date_general) | last-updated-date; (get_flat_file_all_orders_data_by_order_date_general); |
| flat_file_all_orders_data_by_order_date_general__merchant_order_id | TEXT | merchant-order-id (get_flat_file_all_orders_data_by_order_date_general) | merchant-order-id; (get_flat_file_all_orders_data_by_order_date_general); |
| flat_file_all_orders_data_by_order_date_general__order_channel | TEXT | order-channel (get_flat_file_all_orders_data_by_order_date_general) | order-channel (get_flat_file_all_orders_data_by_order_date_general); Information about how an order was placed.; |
| flat_file_all_orders_data_by_order_date_general__order_status | TEXT | order-status (get_flat_file_all_orders_data_by_order_date_general) | order-status (get_flat_file_all_orders_data_by_order_date_general); |
| flat_file_all_orders_data_by_order_date_general__price_designation | TEXT | price-designation (get_flat_file_all_orders_data_by_order_date_general) | price-designation; (get_flat_file_all_orders_data_by_order_date_general) Indicates the; type of business price that the buyer used. Learn more about business; prices. (Amazon Business Seller Program only.); |
| flat_file_all_orders_data_by_order_date_general__product_name | TEXT | product-name (get_flat_file_all_orders_data_by_order_date_general) | product-name (get_flat_file_all_orders_data_by_order_date_general); Short title for the product, displayed on the product detail page and; in the browser title bar.Example: Snowboard; |
| flat_file_all_orders_data_by_order_date_general__promotion_ids | TEXT | promotion-ids (get_flat_file_all_orders_data_by_order_date_general) | promotion-ids (get_flat_file_all_orders_data_by_order_date_general); |
| flat_file_all_orders_data_by_order_date_general__purchase_date | DATE | purchase-date (get_flat_file_all_orders_data_by_order_date_general) | purchase-date (get_flat_file_all_orders_data_by_order_date_general); Date the order was placed, in yyyy-mm-dd format. Note: Unless you; specify a different shipping lead time, you have agreed to ship the; order within two business days of this date.; |
| flat_file_all_orders_data_by_order_date_general__purchase_order_number | TEXT | purchase-order-number (get_flat_file_all_orders_data_by_order_date_general) | purchase-order-number; (get_flat_file_all_orders_data_by_order_date_general) The buyer's; purchase order number (for orders from Amazon Business customers).; This must be included on the customer package packing slip or on the; package shipping label. For more information on packing slips and; purchase order numbers, click here.; |
| flat_file_all_orders_data_by_order_date_general__quantity | TEXT | quantity (get_flat_file_all_orders_data_by_order_date_general) | quantity (get_flat_file_all_orders_data_by_order_date_general); |
| flat_file_all_orders_data_by_order_date_general__sales_channel | TEXT | sales-channel (get_flat_file_all_orders_data_by_order_date_general) | sales-channel (get_flat_file_all_orders_data_by_order_date_general); |
| flat_file_all_orders_data_by_order_date_general__ship_city | TEXT | ship-city (get_flat_file_all_orders_data_by_order_date_general) | ship-city (get_flat_file_all_orders_data_by_order_date_general) City; of "Ship To" address.; |
| flat_file_all_orders_data_by_order_date_general__ship_country | TEXT | ship-country (get_flat_file_all_orders_data_by_order_date_general) | ship-country (get_flat_file_all_orders_data_by_order_date_general); International Standards Organization two-letter country code (ISO; 3166-2 compliant).Example: US; |
| flat_file_all_orders_data_by_order_date_general__ship_postal_code | TEXT | ship-postal-code (get_flat_file_all_orders_data_by_order_date_general) | ship-postal-code (get_flat_file_all_orders_data_by_order_date_general); ZIP code or postal code of "Ship To" address. Value format depends on; destination country.; |
| flat_file_all_orders_data_by_order_date_general__ship_promotion_discount | TEXT | ship-promotion-discount (get_flat_file_all_orders_data_by_order_date_general) | ship-promotion-discount; (get_flat_file_all_orders_data_by_order_date_general); |
| flat_file_all_orders_data_by_order_date_general__ship_service_level | TEXT | ship-service-level (get_flat_file_all_orders_data_by_order_date_general) | ship-service-level; (get_flat_file_all_orders_data_by_order_date_general) Type of shipping; selected by the buyer when ordering the item; for example, standard,; expedited.; |
| flat_file_all_orders_data_by_order_date_general__ship_state | TEXT | ship-state (get_flat_file_all_orders_data_by_order_date_general) | ship-state (get_flat_file_all_orders_data_by_order_date_general); State, province, or region of "Ship To" address. Varies with country; of origin. Note: Abbreviations can vary depending on how it was; entered by the buyer.; |
| flat_file_all_orders_data_by_order_date_general__shipping_price | NUMERIC | shipping-price (get_flat_file_all_orders_data_by_order_date_general) | shipping-price (get_flat_file_all_orders_data_by_order_date_general); Price a buyer paid for shipping. All amounts are aggregates of the; quantity, not unit prices.; |
| flat_file_all_orders_data_by_order_date_general__shipping_tax | TEXT | shipping-tax (get_flat_file_all_orders_data_by_order_date_general) | shipping-tax (get_flat_file_all_orders_data_by_order_date_general); |
| flat_file_all_orders_data_by_order_date_general__sku | TEXT | sku (get_flat_file_all_orders_data_by_order_date_general) | sku (get_flat_file_all_orders_data_by_order_date_general) Stock; Keeping Unit. The seller-defined unique identifier for a product.; Example: AA786936215595; |
| flat_file_open_listings_data__asin | TEXT | asin (get_flat_file_open_listings_data) | asin (get_flat_file_open_listings_data) |
| flat_file_open_listings_data__business_price | TEXT | Business Price (get_flat_file_open_listings_data) | Business Price (get_flat_file_open_listings_data) |
| flat_file_open_listings_data__price | NUMERIC | price (get_flat_file_open_listings_data) | price (get_flat_file_open_listings_data) |
| flat_file_open_listings_data__progressive_lower_bound_1 | TEXT | Progressive Lower Bound 1 (get_flat_file_open_listings_data) | Progressive Lower Bound 1 (get_flat_file_open_listings_data) |
| flat_file_open_listings_data__progressive_lower_bound_2 | TEXT | Progressive Lower Bound 2 (get_flat_file_open_listings_data) | Progressive Lower Bound 2 (get_flat_file_open_listings_data) |
| flat_file_open_listings_data__progressive_lower_bound_3 | TEXT | Progressive Lower Bound 3 (get_flat_file_open_listings_data) | Progressive Lower Bound 3 (get_flat_file_open_listings_data) |
| flat_file_open_listings_data__progressive_price_1 | TEXT | Progressive Price 1 (get_flat_file_open_listings_data) | Progressive Price 1 (get_flat_file_open_listings_data) |
| flat_file_open_listings_data__progressive_price_2 | TEXT | Progressive Price 2 (get_flat_file_open_listings_data) | Progressive Price 2 (get_flat_file_open_listings_data) |
| flat_file_open_listings_data__progressive_price_3 | TEXT | Progressive Price 3 (get_flat_file_open_listings_data) | Progressive Price 3 (get_flat_file_open_listings_data) |
| flat_file_open_listings_data__progressive_price_type | TEXT | Progressive Price Type (get_flat_file_open_listings_data) | Progressive Price Type (get_flat_file_open_listings_data) |
| flat_file_open_listings_data__quantity | NUMERIC | quantity (get_flat_file_open_listings_data) | quantity (get_flat_file_open_listings_data) |
| flat_file_open_listings_data__quantity_lower_bound_1 | TEXT | Quantity Lower Bound 1 (get_flat_file_open_listings_data) | Quantity Lower Bound 1 (get_flat_file_open_listings_data) |
| flat_file_open_listings_data__quantity_lower_bound_2 | TEXT | Quantity Lower Bound 2 (get_flat_file_open_listings_data) | Quantity Lower Bound 2 (get_flat_file_open_listings_data) |
| flat_file_open_listings_data__quantity_lower_bound_3 | TEXT | Quantity Lower Bound 3 (get_flat_file_open_listings_data) | Quantity Lower Bound 3 (get_flat_file_open_listings_data) |
| flat_file_open_listings_data__quantity_lower_bound_4 | TEXT | Quantity Lower Bound 4 (get_flat_file_open_listings_data) | Quantity Lower Bound 4 (get_flat_file_open_listings_data) |
| flat_file_open_listings_data__quantity_lower_bound_5 | TEXT | Quantity Lower Bound 5 (get_flat_file_open_listings_data) | Quantity Lower Bound 5 (get_flat_file_open_listings_data) |
| flat_file_open_listings_data__quantity_price_1 | TEXT | Quantity Price 1 (get_flat_file_open_listings_data) | Quantity Price 1 (get_flat_file_open_listings_data) |
| flat_file_open_listings_data__quantity_price_2 | TEXT | Quantity Price 2 (get_flat_file_open_listings_data) | Quantity Price 2 (get_flat_file_open_listings_data) |
| flat_file_open_listings_data__quantity_price_3 | TEXT | Quantity Price 3 (get_flat_file_open_listings_data) | Quantity Price 3 (get_flat_file_open_listings_data) |
| flat_file_open_listings_data__quantity_price_4 | TEXT | Quantity Price 4 (get_flat_file_open_listings_data) | Quantity Price 4 (get_flat_file_open_listings_data) |
| flat_file_open_listings_data__quantity_price_5 | TEXT | Quantity Price 5 (get_flat_file_open_listings_data) | Quantity Price 5 (get_flat_file_open_listings_data) |
| flat_file_open_listings_data__quantity_price_type | TEXT | Quantity Price Type (get_flat_file_open_listings_data) | Quantity Price Type (get_flat_file_open_listings_data) |
| flat_file_open_listings_data__sku | TEXT | sku (get_flat_file_open_listings_data) | sku (get_flat_file_open_listings_data) |
| marketplace_country | TEXT | Marketplace Country | The Marketplace Country |
| merchant_listings_all_data__add_delete | TEXT | add-delete (get_merchant_listings_all_data) | add-delete (get_merchant_listings_all_data) This field will be empty; in the report; it enables you to use an open listings report to update; online inventory.; |
| merchant_listings_all_data__asin1 | TEXT | asin1 (get_merchant_listings_all_data) | asin1 (get_merchant_listings_all_data) This is not used. The field is; populated with the product-id.; |
| merchant_listings_all_data__asin2 | TEXT | asin2 (get_merchant_listings_all_data) | asin2 (get_merchant_listings_all_data) This is used for backwards; compatibility only.; |
| merchant_listings_all_data__asin3 | TEXT | asin3 (get_merchant_listings_all_data) | asin3 (get_merchant_listings_all_data) This is used for backwards; compatibility only.; |
| merchant_listings_all_data__bid_for_featured_placement | TEXT | bid-for-featured-placement (get_merchant_listings_all_data) | bid-for-featured-placement (get_merchant_listings_all_data) This is; used for backwards compatibility only.; |
| merchant_listings_all_data__expedited_shipping | TEXT | expedited-shipping (get_merchant_listings_all_data) | expedited-shipping (get_merchant_listings_all_data) Second = listings; that are available for second day shipping to U.S. domestic addresses; Next = listings that are available for next day shipping to U.S.; domestic addresses Same = listings that are available for same day; shipping to U.S. domestic addresses n = not offered; |
| merchant_listings_all_data__fulfillment_channel | TEXT | fulfillment-channel (get_merchant_listings_all_data) | fulfillment-channel (get_merchant_listings_all_data) This will; indicate for FBA sellers if the listing is set for seller fulfilment; or fulfilment by Amazon.; |
| merchant_listings_all_data__image_url | TEXT | image-url (get_merchant_listings_all_data) | image-url (get_merchant_listings_all_data) |
| merchant_listings_all_data__item_condition | NUMERIC | item-condition (get_merchant_listings_all_data) | item-condition (get_merchant_listings_all_data) This is your condition; code for the listing.1 = Used; Like New 2 = Used; Very Good 3 = Used;; Good 4 = Used; Acceptable 5 = Collectible; Like New 6 = Collectible;; Very Good 7 = Collectible; Good 8 = Collectible; Acceptable 10 =; Refurbished 11 = New; |
| merchant_listings_all_data__item_description | TEXT | item-description (get_merchant_listings_all_data) | item-description (get_merchant_listings_all_data) This is used for; backwards compatibility only.; |
| merchant_listings_all_data__item_is_marketplace | TEXT | item-is-marketplace (get_merchant_listings_all_data) | item-is-marketplace (get_merchant_listings_all_data) This will always; be y.; |
| merchant_listings_all_data__item_name | TEXT | item-name (get_merchant_listings_all_data) | item-name (get_merchant_listings_all_data) The title of the item; listed. This will be populated with Amazon catalog data.; |
| merchant_listings_all_data__item_note | TEXT | item-note (get_merchant_listings_all_data) | item-note (get_merchant_listings_all_data) Your description of the; listing.; |
| merchant_listings_all_data__listing_id | TEXT | listing-id (get_merchant_listings_all_data) | listing-id (get_merchant_listings_all_data) An identifier created by; Amazon when you create a listing. Consists of 4 digits, a capital; letter, and 6 more digits.; |
| merchant_listings_all_data__merchant_shipping_group | TEXT | merchant-shipping-group (get_merchant_listings_all_data) | merchant-shipping-group (get_merchant_listings_all_data) |
| merchant_listings_all_data__open_date | DATE | open-date (get_merchant_listings_all_data) | open-date (get_merchant_listings_all_data) The date the listing was; created.; |
| merchant_listings_all_data__pending_quantity | TEXT | pending-quantity (get_merchant_listings_all_data) | pending-quantity (get_merchant_listings_all_data) This is the quantity; of the item that is pending purchase at the time of the report.; |
| merchant_listings_all_data__price | NUMERIC | price (get_merchant_listings_all_data) | price (get_merchant_listings_all_data) The price you are asking for; the product.; |
| merchant_listings_all_data__product_id | TEXT | product-id (get_merchant_listings_all_data) | product-id (get_merchant_listings_all_data) ASIN, ISBN, UPC, or EAN; for the item; |
| merchant_listings_all_data__product_id_type | NUMERIC | product-id-type (get_merchant_listings_all_data) | product-id-type (get_merchant_listings_all_data) A numeric entry that; indicates if the product-id is an ASIN, ISBN, UPC, or EAN code/number.; When uploading files in Standard Book format, this field value will; default to 2 (ISBN) unless otherwise specified.1 = ASIN 2 = ISBN 3 =; UPC 4 = EAN; |
| merchant_listings_all_data__quantity | TEXT | quantity (get_merchant_listings_all_data) | quantity (get_merchant_listings_all_data) The quantity of the product; available for purchase.; |
| merchant_listings_all_data__seller_sku | TEXT | seller-sku (get_merchant_listings_all_data) | seller-sku (get_merchant_listings_all_data) Stock Keeping Units (SKUs); are unique blocks of letters and/or numbers that identify your; products. SKUs are assigned by you as the seller.; |
| merchant_listings_all_data__status | TEXT | status (get_merchant_listings_all_data) | status (get_merchant_listings_all_data) |
| merchant_listings_all_data__will_ship_internationally | TEXT | will-ship-internationally (get_merchant_listings_all_data) | will-ship-internationally (get_merchant_listings_all_data) 2 =; listings that are available to customers outside the U.S.1 = listings; that are available only to customers in the U.S.; |
| merchant_listings_all_data__zshop_boldface | TEXT | zshop-boldface (get_merchant_listings_all_data) | zshop-boldface (get_merchant_listings_all_data) This is used for; backwards compatibility only.; |
| merchant_listings_all_data__zshop_browse_path | TEXT | zshop-browse-path (get_merchant_listings_all_data) | zshop-browse-path (get_merchant_listings_all_data) This is used for; backwards compatibility only.; |
| merchant_listings_all_data__zshop_category1 | TEXT | zshop-category1 (get_merchant_listings_all_data) | zshop-category1 (get_merchant_listings_all_data) This is used for; backwards compatibility only.; |
| merchant_listings_all_data__zshop_shipping_fee | TEXT | zshop-shipping-fee (get_merchant_listings_all_data) | zshop-shipping-fee (get_merchant_listings_all_data) This is used for; backwards compatibility only.; |
| merchant_listings_all_data__zshop_storefront_feature | TEXT | zshop-storefront-feature (get_merchant_listings_all_data) | zshop-storefront-feature (get_merchant_listings_all_data) This is used; for backwards compatibility only.; |
| restock_inventory_recommendations_report__alert | TEXT | Alert (get_restock_inventory_recommendations_report) | Alert (get_restock_inventory_recommendations_report) |
| restock_inventory_recommendations_report__asin | TEXT | ASIN (get_restock_inventory_recommendations_report) | ASIN (get_restock_inventory_recommendations_report) |
| restock_inventory_recommendations_report__available | NUMERIC | Available (get_restock_inventory_recommendations_report) | Available (get_restock_inventory_recommendations_report) |
| restock_inventory_recommendations_report__condition | TEXT | Condition (get_restock_inventory_recommendations_report) | Condition (get_restock_inventory_recommendations_report) |
| restock_inventory_recommendations_report__country | TEXT | Country (get_restock_inventory_recommendations_report) | Country (get_restock_inventory_recommendations_report) |
| restock_inventory_recommendations_report__currency_code | TEXT | Currency code (get_restock_inventory_recommendations_report) | Currency code (get_restock_inventory_recommendations_report) |
| restock_inventory_recommendations_report__customer_order | NUMERIC | Customer Order (get_restock_inventory_recommendations_report) | Customer Order (get_restock_inventory_recommendations_report); |
| restock_inventory_recommendations_report__days_of_supply_at_amazon_fulfillment_network | TEXT | Days of Supply at Amazon Fulfillment Network (get_restock_inventory_recommendations_report) | Days of Supply at Amazon Fulfillment Network; (get_restock_inventory_recommendations_report); |
| restock_inventory_recommendations_report__fc_processing | NUMERIC | FC Processing (get_restock_inventory_recommendations_report) | FC Processing (get_restock_inventory_recommendations_report) |
| restock_inventory_recommendations_report__fc_transfer | NUMERIC | FC transfer (get_restock_inventory_recommendations_report) | FC transfer (get_restock_inventory_recommendations_report) |
| restock_inventory_recommendations_report__fnsku | TEXT | FNSKU (get_restock_inventory_recommendations_report) | FNSKU (get_restock_inventory_recommendations_report) |
| restock_inventory_recommendations_report__fulfilled_by | TEXT | Fulfilled by (get_restock_inventory_recommendations_report) | Fulfilled by (get_restock_inventory_recommendations_report) |
| restock_inventory_recommendations_report__inbound | NUMERIC | Inbound (get_restock_inventory_recommendations_report) | Inbound (get_restock_inventory_recommendations_report) |
| restock_inventory_recommendations_report__merchant_sku | TEXT | Merchant SKU (get_restock_inventory_recommendations_report) | Merchant SKU (get_restock_inventory_recommendations_report) |
| restock_inventory_recommendations_report__price | NUMERIC | Price (get_restock_inventory_recommendations_report) | Price (get_restock_inventory_recommendations_report) |
| restock_inventory_recommendations_report__product_name | TEXT | Product Name (get_restock_inventory_recommendations_report) | Product Name (get_restock_inventory_recommendations_report) |
| restock_inventory_recommendations_report__receiving | NUMERIC | Receiving (get_restock_inventory_recommendations_report) | Receiving (get_restock_inventory_recommendations_report) |
| restock_inventory_recommendations_report__recommended_action | TEXT | Recommended action (get_restock_inventory_recommendations_report) | Recommended action (get_restock_inventory_recommendations_report); |
| restock_inventory_recommendations_report__recommended_replenishment_qty | NUMERIC | Recommended replenishment qty (get_restock_inventory_recommendations_report) | Recommended replenishment qty; (get_restock_inventory_recommendations_report); |
| restock_inventory_recommendations_report__recommended_ship_date | TEXT | Recommended ship date (get_restock_inventory_recommendations_report) | Recommended ship date (get_restock_inventory_recommendations_report); |
| restock_inventory_recommendations_report__sales_last_30_days | NUMERIC | Sales last 30 days (get_restock_inventory_recommendations_report) | Sales last 30 days (get_restock_inventory_recommendations_report); |
| restock_inventory_recommendations_report__shipped | NUMERIC | Shipped (get_restock_inventory_recommendations_report) | Shipped (get_restock_inventory_recommendations_report) |
| restock_inventory_recommendations_report__supplier | TEXT | Supplier (get_restock_inventory_recommendations_report) | Supplier (get_restock_inventory_recommendations_report) |
| restock_inventory_recommendations_report__supplier_part_no. | TEXT | Supplier part no. (get_restock_inventory_recommendations_report) | Supplier part no. (get_restock_inventory_recommendations_report); |
| restock_inventory_recommendations_report__total_days_of_supply_(including_units_from_open_shipments) | TEXT | Total Days of Supply (including units from open shipments) (get_restock_inventory_recommendations_report) | Total Days of Supply (including units from open shipments); (get_restock_inventory_recommendations_report); |
| restock_inventory_recommendations_report__total_units | NUMERIC | Total Units (get_restock_inventory_recommendations_report) | Total Units (get_restock_inventory_recommendations_report) |
| restock_inventory_recommendations_report__unfulfillable | NUMERIC | Unfulfillable (get_restock_inventory_recommendations_report) | Unfulfillable (get_restock_inventory_recommendations_report) |
| restock_inventory_recommendations_report__units_sold_last_30_days | NUMERIC | Units Sold Last 30 Days (get_restock_inventory_recommendations_report) | Units Sold Last 30 Days (get_restock_inventory_recommendations_report); |
| restock_inventory_recommendations_report__working | NUMERIC | Working (get_restock_inventory_recommendations_report) | Working (get_restock_inventory_recommendations_report) |
| sales_and_traffic_report_by_date__childasin | TEXT | childAsin (get_sales_and_traffic_report_by_date) | childAsin; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__date | DATE | date (get_sales_and_traffic_report_by_date) | date (get_sales_and_traffic_report_by_date) |
| sales_and_traffic_report_by_date__parentasin | TEXT | parentAsin (get_sales_and_traffic_report_by_date) | parentAsin; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbyasin_averagesalesperorderitem_amount | NUMERIC | salesByAsin-averageSalesPerOrderItem-amount (get_sales_and_traffic_report_by_date) | salesByAsin-averageSalesPerOrderItem-amount; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbyasin_averagesalesperorderitem_currencycode | TEXT | salesByAsin-averageSalesPerOrderItem-currencyCode (get_sales_and_traffic_report_by_date) | salesByAsin-averageSalesPerOrderItem-currencyCode; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbyasin_averagesalesperorderitemb2b_amount | NUMERIC | salesByAsin-averageSalesPerOrderItemB2B-amount (get_sales_and_traffic_report_by_date) | salesByAsin-averageSalesPerOrderItemB2B-amount; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbyasin_averagesalesperorderitemb2b_currencycode | TEXT | salesByAsin-averageSalesPerOrderItemB2B-currencyCode (get_sales_and_traffic_report_by_date) | salesByAsin-averageSalesPerOrderItemB2B-currencyCode; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbyasin_averagesellingprice_amount | NUMERIC | salesByAsin-averageSellingPrice-amount (get_sales_and_traffic_report_by_date) | salesByAsin-averageSellingPrice-amount; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbyasin_averagesellingprice_currencycode | TEXT | salesByAsin-averageSellingPrice-currencyCode (get_sales_and_traffic_report_by_date) | salesByAsin-averageSellingPrice-currencyCode; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbyasin_averagesellingpriceb2b_amount | NUMERIC | salesByAsin-averageSellingPriceB2B-amount (get_sales_and_traffic_report_by_date) | salesByAsin-averageSellingPriceB2B-amount; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbyasin_averagesellingpriceb2b_currencycode | TEXT | salesByAsin-averageSellingPriceB2B-currencyCode (get_sales_and_traffic_report_by_date) | salesByAsin-averageSellingPriceB2B-currencyCode; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbyasin_averageunitsperorderitem | NUMERIC | salesByAsin-averageUnitsPerOrderItem (get_sales_and_traffic_report_by_date) | salesByAsin-averageUnitsPerOrderItem; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbyasin_averageunitsperorderitemb2b | NUMERIC | salesByAsin-averageUnitsPerOrderItemB2B (get_sales_and_traffic_report_by_date) | salesByAsin-averageUnitsPerOrderItemB2B; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbyasin_claimsamount_amount | TEXT | salesByAsin-claimsAmount-amount (get_sales_and_traffic_report_by_date) | salesByAsin-claimsAmount-amount (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbyasin_claimsamount_currencycode | TEXT | salesByAsin-claimsAmount-currencyCode (get_sales_and_traffic_report_by_date) | salesByAsin-claimsAmount-currencyCode; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbyasin_claimsgranted | TEXT | salesByAsin-claimsGranted (get_sales_and_traffic_report_by_date) | salesByAsin-claimsGranted (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbyasin_orderedproductsales_amount | NUMERIC | salesByAsin-orderedProductSales-amount (get_sales_and_traffic_report_by_date) | salesByAsin-orderedProductSales-amount; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbyasin_orderedproductsales_currencycode | TEXT | salesByAsin-orderedProductSales-currencyCode (get_sales_and_traffic_report_by_date) | salesByAsin-orderedProductSales-currencyCode; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbyasin_orderedproductsalesb2b_amount | NUMERIC | salesByAsin-orderedProductSalesB2B-amount (get_sales_and_traffic_report_by_date) | salesByAsin-orderedProductSalesB2B-amount; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbyasin_orderedproductsalesb2b_currencycode | TEXT | salesByAsin-orderedProductSalesB2B-currencyCode (get_sales_and_traffic_report_by_date) | salesByAsin-orderedProductSalesB2B-currencyCode; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbyasin_ordersshipped | NUMERIC | salesByAsin-ordersShipped (get_sales_and_traffic_report_by_date) | salesByAsin-ordersShipped (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbyasin_refundrate | NUMERIC | salesByAsin-refundRate (get_sales_and_traffic_report_by_date) | salesByAsin-refundRate (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbyasin_shippedproductsales_amount | NUMERIC | salesByAsin-shippedProductSales-amount (get_sales_and_traffic_report_by_date) | salesByAsin-shippedProductSales-amount; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbyasin_shippedproductsales_currencycode | TEXT | salesByAsin-shippedProductSales-currencyCode (get_sales_and_traffic_report_by_date) | salesByAsin-shippedProductSales-currencyCode; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbyasin_totalorderitems | NUMERIC | salesByAsin-totalOrderItems (get_sales_and_traffic_report_by_date) | salesByAsin-totalOrderItems (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbyasin_totalorderitemsb2b | NUMERIC | salesByAsin-totalOrderItemsB2B (get_sales_and_traffic_report_by_date) | salesByAsin-totalOrderItemsB2B (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbyasin_unitsordered | NUMERIC | salesByAsin-unitsOrdered (get_sales_and_traffic_report_by_date) | salesByAsin-unitsOrdered (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbyasin_unitsorderedb2b | NUMERIC | salesByAsin-unitsOrderedB2B (get_sales_and_traffic_report_by_date) | salesByAsin-unitsOrderedB2B (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbyasin_unitsrefunded | NUMERIC | salesByAsin-unitsRefunded (get_sales_and_traffic_report_by_date) | salesByAsin-unitsRefunded (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbyasin_unitsshipped | NUMERIC | salesByAsin-unitsShipped (get_sales_and_traffic_report_by_date) | salesByAsin-unitsShipped (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbydate_averagesalesperorderitem_amount | NUMERIC | salesByDate-averageSalesPerOrderItem-amount (get_sales_and_traffic_report_by_date) | salesByDate-averageSalesPerOrderItem-amount; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbydate_averagesalesperorderitem_currencycode | TEXT | salesByDate-averageSalesPerOrderItem-currencyCode (get_sales_and_traffic_report_by_date) | salesByDate-averageSalesPerOrderItem-currencyCode; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbydate_averagesalesperorderitemb2b_amount | NUMERIC | salesByDate-averageSalesPerOrderItemB2B-amount (get_sales_and_traffic_report_by_date) | salesByDate-averageSalesPerOrderItemB2B-amount; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbydate_averagesalesperorderitemb2b_currencycode | TEXT | salesByDate-averageSalesPerOrderItemB2B-currencyCode (get_sales_and_traffic_report_by_date) | salesByDate-averageSalesPerOrderItemB2B-currencyCode; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbydate_averagesellingprice_amount | NUMERIC | salesByDate-averageSellingPrice-amount (get_sales_and_traffic_report_by_date) | salesByDate-averageSellingPrice-amount; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbydate_averagesellingprice_currencycode | TEXT | salesByDate-averageSellingPrice-currencyCode (get_sales_and_traffic_report_by_date) | salesByDate-averageSellingPrice-currencyCode; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbydate_averagesellingpriceb2b_amount | NUMERIC | salesByDate-averageSellingPriceB2B-amount (get_sales_and_traffic_report_by_date) | salesByDate-averageSellingPriceB2B-amount; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbydate_averagesellingpriceb2b_currencycode | TEXT | salesByDate-averageSellingPriceB2B-currencyCode (get_sales_and_traffic_report_by_date) | salesByDate-averageSellingPriceB2B-currencyCode; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbydate_averageunitsperorderitem | NUMERIC | salesByDate-averageUnitsPerOrderItem (get_sales_and_traffic_report_by_date) | salesByDate-averageUnitsPerOrderItem; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbydate_averageunitsperorderitemb2b | NUMERIC | salesByDate-averageUnitsPerOrderItemB2B (get_sales_and_traffic_report_by_date) | salesByDate-averageUnitsPerOrderItemB2B; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbydate_claimsamount_amount | TEXT | salesByDate-claimsAmount-amount (get_sales_and_traffic_report_by_date) | salesByDate-claimsAmount-amount (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbydate_claimsamount_currencycode | TEXT | salesByDate-claimsAmount-currencyCode (get_sales_and_traffic_report_by_date) | salesByDate-claimsAmount-currencyCode; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbydate_claimsgranted | TEXT | salesByDate-claimsGranted (get_sales_and_traffic_report_by_date) | salesByDate-claimsGranted (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbydate_orderedproductsales_amount | NUMERIC | salesByDate-orderedProductSales-amount (get_sales_and_traffic_report_by_date) | salesByDate-orderedProductSales-amount; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbydate_orderedproductsales_currencycode | TEXT | salesByDate-orderedProductSales-currencyCode (get_sales_and_traffic_report_by_date) | salesByDate-orderedProductSales-currencyCode; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbydate_orderedproductsalesb2b_amount | NUMERIC | salesByDate-orderedProductSalesB2B-amount (get_sales_and_traffic_report_by_date) | salesByDate-orderedProductSalesB2B-amount; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbydate_orderedproductsalesb2b_currencycode | TEXT | salesByDate-orderedProductSalesB2B-currencyCode (get_sales_and_traffic_report_by_date) | salesByDate-orderedProductSalesB2B-currencyCode; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbydate_ordersshipped | NUMERIC | salesByDate-ordersShipped (get_sales_and_traffic_report_by_date) | salesByDate-ordersShipped (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbydate_refundrate | NUMERIC | salesByDate-refundRate (get_sales_and_traffic_report_by_date) | salesByDate-refundRate (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbydate_shippedproductsales_amount | NUMERIC | salesByDate-shippedProductSales-amount (get_sales_and_traffic_report_by_date) | salesByDate-shippedProductSales-amount; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbydate_shippedproductsales_currencycode | TEXT | salesByDate-shippedProductSales-currencyCode (get_sales_and_traffic_report_by_date) | salesByDate-shippedProductSales-currencyCode; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbydate_totalorderitems | NUMERIC | salesByDate-totalOrderItems (get_sales_and_traffic_report_by_date) | salesByDate-totalOrderItems (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbydate_totalorderitemsb2b | NUMERIC | salesByDate-totalOrderItemsB2B (get_sales_and_traffic_report_by_date) | salesByDate-totalOrderItemsB2B (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbydate_unitsordered | NUMERIC | salesByDate-unitsOrdered (get_sales_and_traffic_report_by_date) | salesByDate-unitsOrdered (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbydate_unitsorderedb2b | NUMERIC | salesByDate-unitsOrderedB2B (get_sales_and_traffic_report_by_date) | salesByDate-unitsOrderedB2B (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbydate_unitsrefunded | NUMERIC | salesByDate-unitsRefunded (get_sales_and_traffic_report_by_date) | salesByDate-unitsRefunded (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__salesbydate_unitsshipped | NUMERIC | salesByDate-unitsShipped (get_sales_and_traffic_report_by_date) | salesByDate-unitsShipped (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__trafficbyasin_averageoffercount | NUMERIC | trafficByAsin-averageOfferCount (get_sales_and_traffic_report_by_date) | trafficByAsin-averageOfferCount (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__trafficbyasin_averageparentitems | NUMERIC | trafficByAsin-averageParentItems (get_sales_and_traffic_report_by_date) | trafficByAsin-averageParentItems; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__trafficbyasin_browserpageviews | NUMERIC | trafficByAsin-browserPageViews (get_sales_and_traffic_report_by_date) | trafficByAsin-browserPageViews (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__trafficbyasin_browserpageviewsb2b | NUMERIC | trafficByAsin-browserPageViewsB2B (get_sales_and_traffic_report_by_date) | trafficByAsin-browserPageViewsB2B; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__trafficbyasin_browsersessions | NUMERIC | trafficByAsin-browserSessions (get_sales_and_traffic_report_by_date) | trafficByAsin-browserSessions (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__trafficbyasin_browsersessionsb2b | NUMERIC | trafficByAsin-browserSessionsB2B (get_sales_and_traffic_report_by_date) | trafficByAsin-browserSessionsB2B; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__trafficbyasin_buyboxpercentage | NUMERIC | trafficByAsin-buyBoxPercentage (get_sales_and_traffic_report_by_date) | trafficByAsin-buyBoxPercentage (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__trafficbyasin_buyboxpercentageb2b | NUMERIC | trafficByAsin-buyBoxPercentageB2B (get_sales_and_traffic_report_by_date) | trafficByAsin-buyBoxPercentageB2B; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__trafficbyasin_feedbackreceived | TEXT | trafficByAsin-feedbackReceived (get_sales_and_traffic_report_by_date) | trafficByAsin-feedbackReceived (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__trafficbyasin_mobileapppageviews | NUMERIC | trafficByAsin-mobileAppPageViews (get_sales_and_traffic_report_by_date) | trafficByAsin-mobileAppPageViews; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__trafficbyasin_mobileapppageviewsb2b | NUMERIC | trafficByAsin-mobileAppPageViewsB2B (get_sales_and_traffic_report_by_date) | trafficByAsin-mobileAppPageViewsB2B; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__trafficbyasin_mobileappsessions | NUMERIC | trafficByAsin-mobileAppSessions (get_sales_and_traffic_report_by_date) | trafficByAsin-mobileAppSessions (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__trafficbyasin_mobileappsessionsb2b | NUMERIC | trafficByAsin-mobileAppSessionsB2B (get_sales_and_traffic_report_by_date) | trafficByAsin-mobileAppSessionsB2B; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__trafficbyasin_negativefeedbackreceived | TEXT | trafficByAsin-negativeFeedbackReceived (get_sales_and_traffic_report_by_date) | trafficByAsin-negativeFeedbackReceived; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__trafficbyasin_orderitemsessionpercentage | NUMERIC | trafficByAsin-orderItemSessionPercentage (get_sales_and_traffic_report_by_date) | trafficByAsin-orderItemSessionPercentage; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__trafficbyasin_orderitemsessionpercentageb2b | NUMERIC | trafficByAsin-orderItemSessionPercentageB2B (get_sales_and_traffic_report_by_date) | trafficByAsin-orderItemSessionPercentageB2B; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__trafficbyasin_pageviews | NUMERIC | trafficByAsin-pageViews (get_sales_and_traffic_report_by_date) | trafficByAsin-pageViews (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__trafficbyasin_pageviewsb2b | NUMERIC | trafficByAsin-pageViewsB2B (get_sales_and_traffic_report_by_date) | trafficByAsin-pageViewsB2B (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__trafficbyasin_receivednegativefeedbackrate | TEXT | trafficByAsin-receivedNegativeFeedbackRate (get_sales_and_traffic_report_by_date) | trafficByAsin-receivedNegativeFeedbackRate; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__trafficbyasin_sessions | NUMERIC | trafficByAsin-sessions (get_sales_and_traffic_report_by_date) | trafficByAsin-sessions (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__trafficbyasin_sessionsb2b | NUMERIC | trafficByAsin-sessionsB2B (get_sales_and_traffic_report_by_date) | trafficByAsin-sessionsB2B (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__trafficbyasin_unitsessionpercentage | NUMERIC | trafficByAsin-unitSessionPercentage (get_sales_and_traffic_report_by_date) | trafficByAsin-unitSessionPercentage; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__trafficbyasin_unitsessionpercentageb2b | NUMERIC | trafficByAsin-unitSessionPercentageB2B (get_sales_and_traffic_report_by_date) | trafficByAsin-unitSessionPercentageB2B; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__trafficbydate_averageoffercount | NUMERIC | trafficByDate-averageOfferCount (get_sales_and_traffic_report_by_date) | trafficByDate-averageOfferCount (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__trafficbydate_averageparentitems | NUMERIC | trafficByDate-averageParentItems (get_sales_and_traffic_report_by_date) | trafficByDate-averageParentItems; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__trafficbydate_browserpageviews | NUMERIC | trafficByDate-browserPageViews (get_sales_and_traffic_report_by_date) | trafficByDate-browserPageViews (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__trafficbydate_browserpageviewsb2b | NUMERIC | trafficByDate-browserPageViewsB2B (get_sales_and_traffic_report_by_date) | trafficByDate-browserPageViewsB2B; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__trafficbydate_browsersessions | NUMERIC | trafficByDate-browserSessions (get_sales_and_traffic_report_by_date) | trafficByDate-browserSessions (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__trafficbydate_browsersessionsb2b | NUMERIC | trafficByDate-browserSessionsB2B (get_sales_and_traffic_report_by_date) | trafficByDate-browserSessionsB2B; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__trafficbydate_buyboxpercentage | NUMERIC | trafficByDate-buyBoxPercentage (get_sales_and_traffic_report_by_date) | trafficByDate-buyBoxPercentage (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__trafficbydate_buyboxpercentageb2b | NUMERIC | trafficByDate-buyBoxPercentageB2B (get_sales_and_traffic_report_by_date) | trafficByDate-buyBoxPercentageB2B; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__trafficbydate_feedbackreceived | TEXT | trafficByDate-feedbackReceived (get_sales_and_traffic_report_by_date) | trafficByDate-feedbackReceived (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__trafficbydate_mobileapppageviews | NUMERIC | trafficByDate-mobileAppPageViews (get_sales_and_traffic_report_by_date) | trafficByDate-mobileAppPageViews; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__trafficbydate_mobileapppageviewsb2b | NUMERIC | trafficByDate-mobileAppPageViewsB2B (get_sales_and_traffic_report_by_date) | trafficByDate-mobileAppPageViewsB2B; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__trafficbydate_mobileappsessions | NUMERIC | trafficByDate-mobileAppSessions (get_sales_and_traffic_report_by_date) | trafficByDate-mobileAppSessions (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__trafficbydate_mobileappsessionsb2b | NUMERIC | trafficByDate-mobileAppSessionsB2B (get_sales_and_traffic_report_by_date) | trafficByDate-mobileAppSessionsB2B; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__trafficbydate_negativefeedbackreceived | TEXT | trafficByDate-negativeFeedbackReceived (get_sales_and_traffic_report_by_date) | trafficByDate-negativeFeedbackReceived; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__trafficbydate_orderitemsessionpercentage | NUMERIC | trafficByDate-orderItemSessionPercentage (get_sales_and_traffic_report_by_date) | trafficByDate-orderItemSessionPercentage; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__trafficbydate_orderitemsessionpercentageb2b | NUMERIC | trafficByDate-orderItemSessionPercentageB2B (get_sales_and_traffic_report_by_date) | trafficByDate-orderItemSessionPercentageB2B; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__trafficbydate_pageviews | NUMERIC | trafficByDate-pageViews (get_sales_and_traffic_report_by_date) | trafficByDate-pageViews (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__trafficbydate_pageviewsb2b | NUMERIC | trafficByDate-pageViewsB2B (get_sales_and_traffic_report_by_date) | trafficByDate-pageViewsB2B (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__trafficbydate_receivednegativefeedbackrate | TEXT | trafficByDate-receivedNegativeFeedbackRate (get_sales_and_traffic_report_by_date) | trafficByDate-receivedNegativeFeedbackRate; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__trafficbydate_sessions | NUMERIC | trafficByDate-sessions (get_sales_and_traffic_report_by_date) | trafficByDate-sessions (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__trafficbydate_sessionsb2b | NUMERIC | trafficByDate-sessionsB2B (get_sales_and_traffic_report_by_date) | trafficByDate-sessionsB2B (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__trafficbydate_unitsessionpercentage | NUMERIC | trafficByDate-unitSessionPercentage (get_sales_and_traffic_report_by_date) | trafficByDate-unitSessionPercentage; (get_sales_and_traffic_report_by_date); |
| sales_and_traffic_report_by_date__trafficbydate_unitsessionpercentageb2b | NUMERIC | trafficByDate-unitSessionPercentageB2B (get_sales_and_traffic_report_by_date) | trafficByDate-unitSessionPercentageB2B; (get_sales_and_traffic_report_by_date); |
| v2_settlement_report_data_flat_file_v2__adjustment_id | TEXT | adjustment-id (get_v2_settlement_report_data_flat_file_v2) | adjustment-id (get_v2_settlement_report_data_flat_file_v2) |
| v2_settlement_report_data_flat_file_v2__amount | NUMERIC | amount (get_v2_settlement_report_data_flat_file_v2) | amount (get_v2_settlement_report_data_flat_file_v2) |
| v2_settlement_report_data_flat_file_v2__amount_description | TEXT | amount-description (get_v2_settlement_report_data_flat_file_v2) | amount-description (get_v2_settlement_report_data_flat_file_v2); |
| v2_settlement_report_data_flat_file_v2__amount_type | TEXT | amount-type (get_v2_settlement_report_data_flat_file_v2) | amount-type (get_v2_settlement_report_data_flat_file_v2) |
| v2_settlement_report_data_flat_file_v2__currency | TEXT | currency (get_v2_settlement_report_data_flat_file_v2) | currency (get_v2_settlement_report_data_flat_file_v2) |
| v2_settlement_report_data_flat_file_v2__deposit_date | DATE | deposit-date (get_v2_settlement_report_data_flat_file_v2) | deposit-date (get_v2_settlement_report_data_flat_file_v2) |
| v2_settlement_report_data_flat_file_v2__fulfillment_id | TEXT | fulfillment-id (get_v2_settlement_report_data_flat_file_v2) | fulfillment-id (get_v2_settlement_report_data_flat_file_v2) |
| v2_settlement_report_data_flat_file_v2__marketplace_name | TEXT | marketplace-name (get_v2_settlement_report_data_flat_file_v2) | marketplace-name (get_v2_settlement_report_data_flat_file_v2); |
| v2_settlement_report_data_flat_file_v2__merchant_adjustment_item_id | TEXT | merchant-adjustment-item-id (get_v2_settlement_report_data_flat_file_v2) | merchant-adjustment-item-id; (get_v2_settlement_report_data_flat_file_v2); |
| v2_settlement_report_data_flat_file_v2__merchant_order_id | TEXT | merchant-order-id (get_v2_settlement_report_data_flat_file_v2) | merchant-order-id (get_v2_settlement_report_data_flat_file_v2); |
| v2_settlement_report_data_flat_file_v2__merchant_order_item_id | TEXT | merchant-order-item-id (get_v2_settlement_report_data_flat_file_v2) | merchant-order-item-id (get_v2_settlement_report_data_flat_file_v2); |
| v2_settlement_report_data_flat_file_v2__order_id | TEXT | order-id (get_v2_settlement_report_data_flat_file_v2) | order-id (get_v2_settlement_report_data_flat_file_v2) |
| v2_settlement_report_data_flat_file_v2__order_item_code | TEXT | order-item-code (get_v2_settlement_report_data_flat_file_v2) | order-item-code (get_v2_settlement_report_data_flat_file_v2) |
| v2_settlement_report_data_flat_file_v2__posted_date | DATE | posted-date (get_v2_settlement_report_data_flat_file_v2) | posted-date (get_v2_settlement_report_data_flat_file_v2) |
| v2_settlement_report_data_flat_file_v2__posted_date_time | TEXT | posted-date-time (get_v2_settlement_report_data_flat_file_v2) | posted-date-time (get_v2_settlement_report_data_flat_file_v2); |
| v2_settlement_report_data_flat_file_v2__promotion_id | TEXT | promotion-id (get_v2_settlement_report_data_flat_file_v2) | promotion-id (get_v2_settlement_report_data_flat_file_v2) |
| v2_settlement_report_data_flat_file_v2__quantity_purchased | NUMERIC | quantity-purchased (get_v2_settlement_report_data_flat_file_v2) | quantity-purchased (get_v2_settlement_report_data_flat_file_v2); |
| v2_settlement_report_data_flat_file_v2__settlement_end_date | DATE | settlement-end-date (get_v2_settlement_report_data_flat_file_v2) | settlement-end-date (get_v2_settlement_report_data_flat_file_v2); |
| v2_settlement_report_data_flat_file_v2__settlement_id | TEXT | settlement-id (get_v2_settlement_report_data_flat_file_v2) | settlement-id (get_v2_settlement_report_data_flat_file_v2) |
| v2_settlement_report_data_flat_file_v2__settlement_start_date | DATE | settlement-start-date (get_v2_settlement_report_data_flat_file_v2) | settlement-start-date (get_v2_settlement_report_data_flat_file_v2); |
| v2_settlement_report_data_flat_file_v2__shipment_id | TEXT | shipment-id (get_v2_settlement_report_data_flat_file_v2) | shipment-id (get_v2_settlement_report_data_flat_file_v2) |
| v2_settlement_report_data_flat_file_v2__sku | TEXT | sku (get_v2_settlement_report_data_flat_file_v2) | sku (get_v2_settlement_report_data_flat_file_v2) |
| v2_settlement_report_data_flat_file_v2__total_amount | NUMERIC | total-amount (get_v2_settlement_report_data_flat_file_v2) | total-amount (get_v2_settlement_report_data_flat_file_v2) |
| v2_settlement_report_data_flat_file_v2__transaction_type | TEXT | transaction-type (get_v2_settlement_report_data_flat_file_v2) | transaction-type (get_v2_settlement_report_data_flat_file_v2); |