Amazon Vendor Central API schema and ERD

32 tables

Joins between these tables aren't mapped yet.

Loading diagram…

catalog_item

purchase_order_status

vendor_purchase_order

catalog_item

asin

string

marketplace_id

string

_weld_synced

date

catalog_item_summary

asin

string

marketplace_id

string

brand

string

browse_classification_display_name

string

browse_classification_classification_id

string

color

string

item_classification

string

item_name

string

catalog_item_classification

asin

string

marketplace_id

string

display_name

string

classification_id

string

parent

string

_weld_synced

date

catalog_item_dimension

asin

string

marketplace_id

string

item_height_unit

string

item_height_value

double

item_length_unit

string

item_length_value

double

item_weight_unit

string

item_weight_value

double

catalog_item_identifier

asin

string

marketplace_id

string

identifier

string

identifier_type

string

_weld_synced

date

catalog_item_image

asin

string

marketplace_id

string

variant

string

link

string

height

int

width

int

_weld_synced

date

catalog_item_product_type

asin

string

marketplace_id

string

product_type

string

_weld_synced

date

catalog_item_relationship

asin

string

marketplace_id

string

type

string

parent_asins

string

child_asins

string

variation_theme

string

_weld_synced

date

catalog_item_sales_rank_classification

asin

string

marketplace_id

string

classification_id

string

title

string

link

string

rank

int

_weld_synced

date

catalog_item_sales_rank_display_group_ranks

asin

string

marketplace_id

string

website_display_group

string

title

string

link

string

rank

int

_weld_synced

date

catalog_item_vendor_details

asin

string

marketplace_id

string

brand_code

string

manufacturer_code

string

manufacturer_code_parent

string

product_category_display_name

string

product_category_value

string

product_group

string

product_subcategory_display_name

string

product_subcategory_value

string

replenishment_category

string

_weld_synced

date

purchase_order_status

purchase_order_number

string

purchase_order_status

string

purchase_order_date

date

last_updated_date

date

selling_party_party_id

string

selling_party_address_name

string

selling_party_address_address_line_1

string

selling_party_address_address_line_2

string

purchase_order_status_item

purchase_order_number

string

item_sequence_number

string

buyer_product_identifier

string

vendor_product_identifier

string

net_cost_currency_code

string

net_cost_amount

double

net_cost_unit_of_measure

string

list_price_currency_code

string

purchase_order_status_item_ordered_quantity_detail

purchase_order_number

string

item_sequence_number

string

updated_date

date

ordered_quantity_amount

double

ordered_quantity_unit_of_measure

string

ordered_quantity_unit_size

double

cancelled_quantity_amount

double

cancelled_quantity_unit_of_measure

string

cancelled_quantity_unit_size

double

_weld_synced

date

purchase_order_status_item_acknowledgement_status_detail

purchase_order_number

string

item_sequence_number

string

acknowledgement_date

date

accepted_quantity_amount

double

accepted_quantity_unit_of_measure

string

accepted_quantity_unit_size

double

rejected_quantity_amount

double

rejected_quantity_unit_of_measure

string

rejected_quantity_unit_size

double

_weld_synced

date

vendor_purchase_order

purchase_order_number

string

purchase_order_state

string

order_details_purchase_order_date

date

order_details_purchase_order_changed_date

date

order_details_purchase_order_state_changed_date

date

order_details_purchase_order_type

string

order_details_import_details_method_of_payment

string

order_details_import_details_international_commercial_terms

string

vendor_purchase_order_item

purchase_order_number

string

item_sequence_number

string

amazon_product_identifier

string

vendor_product_identifier

string

ordered_quantity_amount

double

ordered_quantity_unit_of_measure

string

ordered_quantity_unit_size

double

is_back_order_allowed

boolean

vendor_forecasting_report

asin

string

forecast_generation_date

string

start_date

string

end_date

string

mean_forecast_units

double

p_70_forecast_units

double

p_80_forecast_units

double

p_90_forecast_units

double

_weld_synced

date

vendor_inventory_consignment_retail_report

asin

string

report_id

string

start_date

string

end_date

string

sourceable_product_out_of_stock_rate

double

procurable_product_out_of_stock_rate

double

open_purchase_order_units

double

receive_fill_rate

double

vendor_inventory_manufacturing_retail_report

asin

string

report_id

string

start_date

string

end_date

string

sourceable_product_out_of_stock_rate

double

procurable_product_out_of_stock_rate

double

open_purchase_order_units

double

receive_fill_rate

double

vendor_inventory_sourcing_retail_report

asin

string

report_id

string

start_date

string

end_date

string

sourceable_product_out_of_stock_rate

double

procurable_product_out_of_stock_rate

double

open_purchase_order_units

double

receive_fill_rate

double

vendor_net_pure_product_margin_report

asin

string

report_id

string

start_date

string

end_date

string

net_pure_product_margin

double

_weld_synced

date

vendor_real_time_inventory_report

asin

string

report_id

string

start_time

date

end_time

date

highly_available_inventory

long

_weld_synced

date

vendor_real_time_sales_report

asin

string

report_id

string

start_time

date

end_time

date

ordered_units

long

ordered_revenue

double

_weld_synced

date

vendor_real_time_traffic_report

asin

string

report_id

string

start_time

date

end_time

date

glance_views

long

_weld_synced

date

vendor_sales_consignment_business_report

asin

string

report_id

string

customer_returns

double

shipped_cogs_amount

double

shipped_cogs_currency_code

string

shipped_revenue_amount

double

shipped_revenue_currency_code

string

shipped_units

double

vendor_sales_consignment_retail_report

asin

string

report_id

string

customer_returns

double

shipped_cogs_amount

double

shipped_cogs_currency_code

string

shipped_revenue_amount

double

shipped_revenue_currency_code

string

shipped_units

double

vendor_sales_manufacturing_business_report

asin

string

report_id

string

customer_returns

double

shipped_cogs_amount

double

shipped_cogs_currency_code

string

shipped_revenue_amount

double

shipped_revenue_currency_code

string

shipped_units

double

vendor_sales_manufacturing_retail_report

asin

string

report_id

string

customer_returns

double

shipped_cogs_amount

double

shipped_cogs_currency_code

string

shipped_revenue_amount

double

shipped_revenue_currency_code

string

shipped_units

double

vendor_sales_sourcing_business_report

asin

string

report_id

string

customer_returns

double

shipped_cogs_amount

double

shipped_cogs_currency_code

string

shipped_revenue_amount

double

shipped_revenue_currency_code

string

shipped_units

double

vendor_sales_sourcing_retail_report

asin

string

report_id

string

customer_returns

double

shipped_cogs_amount

double

shipped_cogs_currency_code

string

shipped_revenue_amount

double

shipped_revenue_currency_code

string

shipped_units

double

vendor_traffic_report

asin

string

report_id

string

start_date

string

end_date

string

glance_views

long

_weld_synced

date