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 |
Last updated