Fulfillment By Amazon

FBA Amazon Fulfilled Shipments Report

Table name: sellercentral_fbaamazonfulfilledshipments_report

Seller Central Console Report: Amazon Fulfilled Shipments (Help)

For details on data availability and refresh schedule, please click here.

Column Name	Data type	Description
account_id	Integer
account_name	String
seller_id	String
amazon_order_id	String
shipment_id	String
shipment_item_id	String
amazon_order_item_id	String
merchant_order_id	String
merchant_order_item_id	String
purchase_date	Date Time
payments_date	Date Time
shipment_date	Date Time
reporting_date	Date Time
buyer_email	String
buyer_name	String
buyer_phone_number	String
sku	String
product_name	String
quantity_shipped	Integer
currency	String
item_price	Numeric
item_tax	Numeric
shipping_price	Numeric
shipping_tax	Numeric
gift_wrap_price	Numeric
gift_wrap_tax	Numeric
ship_service_level	String
recipient_name	String
ship_address_1	String
ship_address_2	String
ship_address_3	String
ship_city	String
ship_state	String
ship_postal_code	String
ship_country	String
ship_phone_number	String
bill_address_1	String
bill_address_2	String
bill_address_3	String
bill_city	String
bill_state	String
bill_postal_code	String
bill_country	String
item_promotion_discount	Numeric
ship_promotion_discount	Numeric
carrier	String
tracking_number	String
estimated_arrival_date	Date Time
fulfillment_center_id	String
fulfillment_channel	String
sales_channel	String

FBA Reserved Inventory Report

Table name: sellercentral_fbareservedinventory_report

Seller Central Console Report: Reserved Inventory (Help)

For details on data availability and refresh schedule, please click here.

Column Name	Data type	Description
account_id	Integer
account_name	String
seller_id	Integer
sku	String
fnsku	String
asin	String
product_name	String
reserved_qty	Numeric
reserved_customerorders	Numeric
reserved_fc_transfers	Numeric
reserved_fc_processing	Numeric
report_date	Date

FBA Stranded Inventory Report

Table name: sellercentral_fbastrandedinventory_report

Seller Central Console Report: Stranded Inventory (Help)

For details on data availability and refresh schedule, please click here.

Column Name	Data type	Description (Refer the help link above)
account_id	Integer
account_name	String
seller_id	Integer
primary_action	String
date_stranded	Date
status_primary	String
status_secondary	String
error_message	String
stranded_reason	String
asin	String
sku	String
fnsku	String
product_name	String
condition	String
fulfilled_by	String
fulfillable_qty	Integer
your_price	Numeric
unfulfillable_qty	Integer
reserved_quantity	Integer
inbound_shipped_qty	Integer
report_date	Date

Restock Inventory Report

Table name: sellercentral_restockinventory_report

Seller Central Console Report: Restock Inventory (Help)

For details on data availability and refresh schedule, please click here.

Column Name	Data type	Description
account_id	Integer
account_name	String
seller_id	Integer
country	String
product_name	String
fnsku	String
merchant_sku	String
asin	String
condition	String
supplier	String
supplier_part_no	String
currency_code	String
price	Numeric
sales_last_30_days	Numeric
units_sold_last_30_days	String
total_units	Integer
inbound	Integer
available	Integer
fc_transfer	Integer
fc_processing	Integer
customer_order	Integer
unfulfillable	Integer
fulfilled_by	String
days_of_supply	String
alert	String
recommended_replenishment_qty	Integer
recommended_ship_Date	Date Time
inventory_level_thresholds_published_current_month	String
current_month_very_low_inventory_threshold	Integer
current_month_minimum_inventory_threshold	Integer
current_month_maximum_inventory_threshold	Integer
current_month_very_high_inventory_threshold	Integer
inventory_level_thresholds_published_next_month	String
next_month_very_low_inventory_threshold	Integer
next_month_minimum_inventory_threshold	Integer
next_month_maximum_inventory_threshold	Integer
next_month_very_high_inventory_threshold	Integer
utilization	String
maximum_shipment_quantity	Integer
report_Date	Date
download_date	Date	Date of download
working	Integer
shipped	Integer
receiving	Integer
total_days_of_supply	String
days_of_supply_at_amazon	String
unit_storage_size	String

FBA FEE Preview Report

Table name: sellercentral_fbafeepreview_report

Note: The report data is 3 days behind

Seller Central Console Report: FBA Preview (Help)

For details on data availability and refresh schedule, please click here.

Column Name	Data type	Description
account_name	String
account_id	Integer
seller_id	String
country_code	String
currency_code	String
report_date	Date
sku	String
fnsku	String
asin	String
product_name	String
product_group	String
brand	String
fulfilled_by	String
your_price	Numeric
sales_price	Numeric
longest_side	Numeric
median_side	Numeric
shortest_side	Numeric
length_and_girth	Numeric
unit_of_dimension	String
item_package_weight	Numeric
unit_of_weight	String
product_size_tier	String
currency	String
estimated_fee_total	Numeric
estimated_referral_fee_per_unit	Numeric
estimated_variable_closing_fee	Numeric
estimated_order_handling_fee_per_order	Numeric
estimated_pick_pack_fee_per_unit	Numeric
estimated_weight_handling_fee_per_unit	Numeric
expected_fulfillment_fee_per_unit	Numeric
download_date	Date

FBA Amazon Fulfilled Inventory Report

Table name: sellercentral_fbaamazonfulfilledinventory_report

Seller Central Console Report: Amazon Fulfilled Inventory (Help)

For details on data availability and refresh schedule, please click here.

Column Name	Data type	Description
account_name	String
account_id	Integer
country_code	String
asin	String
report_date	Date
seller_sku	String
fulfillment_channel_sku	String
condition_type	String
warehouse_condition_code	String
quantity_available	Integer
download_date	Date

FBA Inventory Age Report (Deprecated)

Deprecated by Amazon as on July 2022, Please use FBA Manage Inventory Health Report

Table name: sellercentral_fbainventoryage_report

Seller Central Console Report: Amazon Fulfilled Inventory Age (Help)

For details on data availability and refresh schedule, please click here.

Column Name	Data type	Description
account_name	String
account_id	Integer
country_code	String
currency_code	String
snapshot_date	Date
sku	String
fnsku	String
asin	String
product_name	String
condition	String
avaliable_quantity_sellable	Integer
qty_with_removals_in_progress	Integer
inv_age_0_to_90_days	Integer
inv_age_91_to_180_days	Integer
inv_age_181_to_270_days	Integer
inv_age_271_to_365_days	Integer
inv_age_365_plus_days	Integer
currency	String
qty_to_be_charged_ltsf_6_mo	Integer
projected_ltsf_6_mo	Numeric
qty_to_be_charged_ltsf_12_mo	Integer
projected_ltsf_12_mo	Numeric
units_shipped_last_7_days	Integer
units_shipped_last_30_days	Integer
units_shipped_last_60_days	Integer
units_shipped_last_90_days	Integer
alert	String
your_price	Numeric
sales_price	Numeric
lowest_price_new	Numeric
lowest_price_used	Numeric
recommended_action	String
healthy_inventory_level	Integer
recommended_sales_price	Numeric
recommended_sale_duration_days	Integer
recommended_removal_quantity	Integer
estimated_cost_savings_of_recommended_actions	Numeric
sell_through	Numeric
item_volume	Numeric
volume_units	String
storage_type	String
report_date	Date
download_date	Dat

FBA Received Inventory Report (Deprecated)

Deprecated by Amazon as on 31st-Jan-2023 - Use Legder Summary

Table name: sellercentral_fbareceivedinventory_report

Seller Central Console Report: Amazon Received Inventory (Help)

For details on data availability and refresh schedule, please click here.

Column Name	Data type	Description
account_name	String
account_id	Integer
country_code	String
received_date	Timestamp
fnsku	String
sku	String
product_name	String
quantity	Integer
fba_shipment_id	String
fulfillment_center_id	String
report_date	Date
download_date	Date

FBA Customer Returns Report

Table name: sellercentral_fbareturns_report

Seller Central Console Report: Amazon Fulfilled Customer Returns(Help)

For details on data availability and refresh schedule, please click here.

Column Name	Data type	Description (Refer help link above)
account_name	String
account_id	Integer
country_code	String
return_date	Timestamp
order_id	String
sku	String
asin	String
fnsku	String
product_name	String
quantity	Integer
fulfillment_center_id	String
detailed_disposition	String
reason	String
status	String
license_plate_number	String
customer_comments	String
seller_id	String
report_date	Date
download_date	Date

FBA Daily Inventory History Report (Deprecated)

Deprecated by Amazon as on 31st-Jan-2023 - Use Legder Summary

Table name: sellercentral_fbadailyinventoryhistory_report

Seller Central Console Report: Amazon Fulfilled Daily Inventory History(Help)

For details on data availability and refresh schedule, please click here.

Column Name	Data type	Description (Refer help link above)
account_name	String
account_id	Integer
country_code	String
snapshot_date	Timestamp
fnsku	String
sku	String
product_name	String
quantity	Integer
fulfillment_center_id	String
detailed_disposition	String
country	String
report_date	Date
download_date	Date

FBA Inventory Health Report(Deprecated)

Deprecated by Amazon as on July 2022, Please use FBA Manage Inventory Health Report

Table name: sellercentral_fbainventoryhealth_report

Seller Central Console Report: Amazon Fulfilled Inventory Health Report(Help)

For details on data availability and refresh schedule, please click here.

Column Name	Data type	Description (Refer help link above)
account_name	String
account_id	Integer
country_code	String
currency_code	String
snapshot_date	Timestamp
sku	String
fnsku	String
asin	String
product_name	String
condition	String
sales_rank	Integer
product_group	String
total_quantity	Integer
sellable_quantity	Integer
unsellable_quantity	Integer
inv_age_0_to_90_days	Integer
inv_age_91_to_180_days	Integer
inv_age_181_to_270_days	Integer
inv_age_271_to_365_days	Integer
inv_age_365_plus_days	Integer
units_shipped_last_24_hrs	Integer
units_shipped_last_7_days	Integer
units_shipped_last_30_days	Integer
units_shipped_last_90_days	Integer
units_shipped_last_180_days	Integer
units_shipped_last_365_days	Integer
weeks_of_cover_t7	String
weeks_of_cover_t30	String
weeks_of_cover_t90	String
weeks_of_cover_t180	String
weeks_of_cover_t365	String
num_afn_new_sellers	Integer
num_afn_used_sellers	Integer
currency	String
your_price	Numeric
sales_price	Numeric
lowest_afn_new_price	Numeric
lowest_afn_used_price	Numeric
lowest_mfn_new_price	Numeric
lowest_mfn_used_price	Numeric
qty_to_be_charged_ltsf_12_mo	Integer
qty_in_long_term_storage_program	Integer
qty_with_removals_in_progress	Integer
projected_ltsf_12_mo	Numeric
per_unit_volume	Numeric
is_hazmat	String
in_bound_quantity	Integer
asin_limit	Integer
inbound_recommend_quantity	Integer
qty_to_be_charged_ltsf_6_mo	Integer
projected_ltsf_6_mo	Numeric
report_date	Date
download_date	Date

FBA Storage Fees Report

Table name: sellercentral_fbastoragefees_report

Seller Central Console Report: Amazon Monthly Storage Fees(Help)

For details on data availability and refresh schedule, please click here.

Column Name	Data type	Description (Refer help link above)
account_name	String
account_id	Integer
currency_code	String
asin	String
fnsku	String
product_name	String
fulfillment_center	String
country_code	String
longest_side	Numeric
median_side	Numeric
shortest_side	Numeric
measurement_units	String
weight	Numeric
weight_units	String
item_volume	Numeric
volume_units	String
product_size_tier	String
average_quantity_on_hand	Numeric
average_quantity_pending_removal	Numeric
estimated_total_item_volume	Numeric
month_of_charge	String
storage_rate	Numeric
currency	String
estimated_monthly_storage_fee	Numeric
dangerous_goods_storage_type	String
eligible_for_inventory_discount	String
qualifies_for_inventory_discount	String
total_incentive_fee_amount	Numeric
breakdown_incentive_fee_amount	Numeric
average_quantity_customer_orders	Numeric
report_start_date	Integer
report_end_date	Integer
download_date	Integer

FBA Monthly Inventory History Report (Deprecated)

Deprecated by Amazon as on 31st-Jan-2023 - Use Legder Summary

Table name: sellercentral_fbamonthlyinventoryhistory_report

Seller Central Console Report: Monthly Inventory History Report (Help)

For details on data availability and refresh schedule, please click here.

Column Name	Data type	Description (Refer help link above)
account_name	String
account_id	Integer
country_code	String
month	Date
fnsku	String
sku	String
product_name	String
average_quantity	Numeric
end_quantity	Integer
fulfillment_center_id	String
detailed_disposition	String
country	String
report_start_date	Date
report_end_date	Date
download_date	Date

FBA Manage Inventory Report

Table name: sellercentral_fbamanageinventory_report

Seller Central Console Report: FBA Manage Inventory Report (Help)

For details on data availability and refresh schedule, please click here.

Column Name	Data type	Description (Refer help link above)
account_name	String
account_id	Integer
currency_code	String
sku	String
fnsku	String
asin	String
product_name	String
condition	String
your_price	Numeric
mfn_listing_exists	String
mfn_fulfillable_quantity	Integer
afn_listing_exists	String
afn_warehouse_quantity	Integer
afn_fulfillable_quantity	Integer
afn_unsellable_quantity	Integer
afn_reserved_quantity	Integer
afn_total_quantity	Integer
per_unit_volume	Numeric
afn_inbound_working_quantity	Integer
afn_inbound_shipped_quantity	Integer
afn_inbound_receiving_quantity	Integer
afn_researching_quantity	Integer
afn_reserved_future_supply	Integer
afn_future_supply_buyable	Integer
report_date	Date
download_date	Date

FBA Ledger Summary Report

Table name: sellercentral_fbaledgersummary_report

Seller Central Console Report: FBA Inventory Ledger Report (Help)

For details on data availability and refresh schedule, please click here.

Column Name	Data type	Description (Refer help link above)
account_name	String
account_id	Integer
date	Date
fnsku	String
asin	String
msku	String
title	String
disposition	String
starting_warehouse_balance	Integer
in_transit_between_warehouses	Integer
receipts	Integer
customer_shipments	Integer
customer_returns	Integer
vendor_returns	Integer
warehouse_transfer_in_out	Integer
found	Integer
lost	Integer
damaged	Integer
disposed	Integer
other_events	Integer
ending_warehouse_balance	Integer
unknown_events	Integer
location	String
download_date	Date

FBA Ledger Detailed Report

Table name: sellercentral_fbaledgerdetailed_report

Seller Central Console Report: FBA Inventory Ledger Report (Help)

For details on data availability and refresh schedule, please click here.

Column Name	Data type	Description (Refer help link above)
account_name	String
account_id	Integer
date	Date
fnsku	String
asin	String
msku	String
title	String
event_type	String
reference_id	String
quantity	Integer
fulfillment_center	String
disposition	String
reason	String
country	String
reconciled_quantity	Integer
unreconciled_quantity	Integer
download_date	Date

FBA Manage Inventory Health Report

Table name: sellercentral_fbamanageinventoryhealth_report

Seller Central Console Report: FBA Manage Inventory Health Report (Help)

For details on data availability and refresh schedule, please click here.

Column Name	Data type	Description (Refer help link above)
account_name	String
account_id	Integer
country_code	String
snapshot_date	Date
sku	String
fnsku	String
asin	String
product_name	String
condition	String
available	Integer
pending_removal_quantity	Integer
inv_age_0_to_90_days	Integer
inv_age_91_to_180_days	Integer
inv_age_181_to_270_days	Integer
inv_age_271_to_365_days	Integer
inv_age_365_plus_days	Integer
currency	String
qty_to_be_charged_ltsf_9_mo	Integer
projected_ltsf_9_mo	Numeric
qty_to_be_charged_ltsf_12_mo	Integer
estimated_ltsf_next_charge	Numeric
units_shipped_t7	Integer
units_shipped_t30	Integer
units_shipped_t60	Integer
units_shipped_t90	Integer
alert	String
your_price	Numeric
sales_price	Numeric
lowest_price_new_plus_shipping	Numeric
lowest_price_used	Numeric
recommended_action	String
healthy_inventory_level	Integer
recommended_sales_price	Numeric
recommended_sale_duration_days	Integer
recommended_removal_quantity	Integer
estimated_cost_savings_of_recommended_actions	Numeric
sell_through	Numeric
item_volume	Numeric
volume_unit_measurement	String
storage_type	String
storage_volume	Numeric
market_place	String
product_group	String
sales_rank	Integer
days_of_supply	Integer
estimated_excess_quantity	Integer
weeks_of_cover_t30	Integer
weeks_of_cover_t90	Integer
featuredoffer_price	Numeric
sales_shipped_last_7_days	Numeric
sales_shipped_last_30_days	Numeric
sales_shipped_last_60_days	Numeric
sales_shipped_last_90_days	Numeric
inv_age_0_to_30_days	Integer
inv_age_31_to_60_days	Integer
inv_age_61_to_90_days	Integer
inv_age_181_to_330_days	Numeric
inv_age_331_to_365_days	Numeric
estimated_storage_cost_next_month	Numeric
inbound_quantity	Integer
inbound_working	Integer
inbound_shipped	Integer
inbound_received	Integer
no_sale_last_6_months	Integer
reserved_quantity	Integer
unfulfillable_quantity	Integer
download_date	Date
quantity_to_be_charged_ais_181_210_days	Integer
estimated_ais_181_210_days	Numeric
quantity_to_be_charged_ais_211_240_days	Integer
estimated_ais_211_240_days	Numeric
quantity_to_be_charged_ais_241_270_days	Integer
estimated_ais_241_270_days	Numeric
quantity_to_be_charged_ais_271_300_days	Integer
estimated_ais_271_300_days	Numeric
quantity_to_be_charged_ais_301_330_days	Integer
estimated_ais_301_330_days	Numeric
quantity_to_be_charged_ais_331_365_days	Integer
estimated_ais_331_365_days	Numeric
quantity_to_be_charged_ais_365_plus_days	Integer
estimated_ais_365_plus_days	Numeric

FBA Subscribe and Save Forecast Report

Table name: sellercentral_fbasubscribeandsaveforecast_report

Seller Central Console Report: FBA Subscribe and Save Forecast Report (Help)

Frequency : Weekly - Monday

Column Name	Data type	Description (Refer help link above)
account_name	String
account_id	Integer
snapshot_date	Date
offer_state	String
sku	String
fnsku	String
asin	String
estimated_avg_sns_discount_next_8_weeks	Numeric
product_name	String
country	String
active_subscriptions	Integer
week_1_start_date	Date
scheduled_sns_units_week_1	Integer
scheduled_sns_units_week_2	Integer
scheduled_sns_units_week_3	Integer
scheduled_sns_units_week_4	Integer
scheduled_sns_units_week_5	Integer
scheduled_sns_units_week_6	Integer
scheduled_sns_units_week_7	Integer
scheduled_sns_units_week_8	Integer
download_date	Date

FBA Subscribe and Save Performance Report

Table name: sellercentral_fbasubscribeandsaveperformance_report

Seller Central Console Report: FBA Subscribe and Save Performance Report (Help)

Frequency : Weekly - Monday

Column Name	Data type	Description (Refer help link above)
account_name	String
account_id	Integer
offer_state	String
snapshot_date	Date
sku	String
fnsku	String
asin	String
product_name	String
country	String
week_1_start_date	Date
sns_units_shipped_week_1	Integer
oos_rate_week_1	Numeric
sns_sale_price_week_1	Numeric
sns_discount_week_1	Numeric
sns_units_shipped_week_2	Integer
oos_rate_week_2	Numeric
sns_sale_price_week_2	Numeric
sns_discount_week_2	Numeric
sns_units_shipped_week_3	Integer
oos_rate_week_3	Numeric
sns_sale_price_week_3	Numeric
sns_discount_week_3	Numeric
sns_units_shipped_week_4	Integer
oos_rate_week_4	Numeric
sns_sale_price_week_4	Numeric
sns_discount_week_4	Numeric
seller_id	String
download_date	Date

FBA Long Term Storage Fee Charges Report

Table name: sellercentral_fbalongtermstoragefeecharges_report

Frequency : Monthly

Column Name	Data type	Description
account_id	Integer	Intentwise Account Id
account_name	String	Intentwise Account Name
snapshot_date	Timestamp	Snapshot Date
sku	String	SKU
asin	String	Amazon standard identification numbers (ASINs) are unique blocks of 10 letters or numbers that identify items. Amazon assigns the ASIN, which you can find on the product-detail page.
fnsku	String	Amazon's fulfillment network stock-keeping unit (SKU) identifier.
product_name	String	Description of the ASIN on the product-detail page.
condition	String	The condition of your product.
per_unit_volume	Numeric	The volume in cubic feet of each inventory unit assessed the aged inventory surcharge.
currency	String
volume_unit	String	Unit name of the volume value.
country	String	The country in which your products are stored.
qty_charged	Numeric	The number of units in fulfillment centers for which the aged inventory surcharge was assessed.
amount_charged	Numeric	The amount of aged inventory surcharge that was charged.
surcharge_age_tier	String	The age tier that was charged according to the aged inventory surcharge rates.
rate_surcharge	Numeric	The surcharge rate corresponding to the surcharge age tier charged (converted to a per-unit value).
report_start_date	Date	Report Start Date
report_end_date	Date	Report End Date
download_date	Date	Download date

FBA Reimbursements Report

Table name: sellercentral_fbareimbursements_report

Column Name	Data type	Description
account_id	Integer	Intentwise Account Id
account_name	String	Intentwise Account Name
approval_date	String	The date the reimbursement was approved.
reimbursement_id	String	The unique identifier for this reimbursement. Each reimbursement may include multiple line items.
case_id	String	The unique identifier assigned to the case when you request a reimbursement.
amazon_order_id	String	The unique identifier assigned to the customer order. This field is empty if the reimbursement is not associated with an order.
reason	String	The reason for the reimbursement (for example, Damaged: Warehouse).
sku	String	The merchant SKU (stock keeping unit) is the unique identifier you assigned to your product.
asin	String	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.
fnsku	String	The fulfillment network SKU (stock keeping unit) is the unique identifier Fulfillment by Amazon assigned to your product.
product_name	String	The name of your product.
condition	String	The condition of your item (for example, New).
currency_unit	String	The currency for the applicable marketplace.
amount_per_unit	Numeric	The per-unit reimbursement amount for this line item.
amount_total	Numeric	The total amount of the cash reimbursement for this line item.
quantity_reimbursed_cash	Integer	The total number of units reimbursed with cash.
quantity_reimbursed_inventory	Integer	The number of units reimbursed with inventory.
quantity_reimbursed_total	Integer	The total number of units reimbursed with either cash or inventory (Quantity Reimbursed [Cash] + Quantity Reimbursed [Inventory]).
original_reimbursement_id	String
original_reimbursement_type	String
report_start_date	Date	Report Start Date
report_end_date	Date	Report End Date
download_date	Date	Download date

FBA Promotions Report

Table name: sellercentral_fbapromotions_report

Seller Central Console Report: FBA Promotions Report (Help)

Frequency: Daily

Column Name	Data Type	Description
account_id	Integer	Intentwise Account Id
account_name	String	Intentwise Account Name
shipment-date	Date	Date the item was dispatched to the customer
currency_code	String	Local currency for the transaction
country_code	String	The country in which your products are stored.
item-promotion-discount	String	Promotion value applied to this shipment item.
item-promotion-id	String	Unique identifier for this promotion
description	String	Description of the promotion
promotion-rule-value	String	Maximum net value of the promotion
amazon-order-id	String	Order id of shipment to which the promotion was applied.
shipment-id	String	Unique identifier for this item in this shipment.
shipment-item-id	String	Unique identifier--pertains only to this item in this shipment.
download_date	Date	download date