ERD for Amazon Selling Partner API

20 tables

Loading diagram…

settlement_report

settlement_id

string

order_id

string

amount_type

string

amount_description

string

sku

string

merchant_order_item_id

string

posted_date_time

string

merchant_adjustment_item_id

string

order_item_code

string

shipment_id

string

promotion_id

string

amount

double

transaction_type

string

merchant_order_id

string

adjustment_id

string

marketplace_name

string

fulfillment_id

string

posted_date

string

quantity_purchased

double

_weld_synced

date

settlement_description

settlement_id

string

settlement_start_date

string

settlement_end_date

string

deposit_date

string

total_amount

double

currency

string

fba_shipment_items

shipment_id

string

seller_sku

string

fulfillment_network_sku

string

quantity_shipped

int

quantity_received

int

quantity_in_case

int

release_date

date

_weld_synced

date

fba_shipment_item_prep_details

prep_instruction

string

prep_owner

string

shipment_id

string

seller_sku

string

fulfillment_network_sku

string

orders

BuyerInfo_BuyerEmail

string

BuyerInfo_BuyerName

string

BuyerInfo_BuyerCounty

string

BuyerInfo_BuyerPurchaseOrderNumber

string

BuyerInfo_BuyerTaxInfo_CompanyLegalName

string

BuyerInfo_BuyerTaxInfo_TaxingRegion

string

BuyerInfo_BuyerTaxInfo_TaxClassifications

string

AmazonOrderId

string

EarliestShipDate

date

SalesChannel

string

OrderStatus

string

NumberOfItemsShipped

double

OrderType

string

IsPremiumOrder

boolean

IsPrime

boolean

FulfillmentChannel

string

NumberOfItemsUnshipped

double

IsReplacementOrder

boolean

IsSoldByAB

boolean

LatestShipDate

date

ShipServiceLevel

string

IsISPU

boolean

MarketplaceId

string

PurchaseDate

date

SellerOrderId

string

PaymentMethod

string

IsBusinessOrder

boolean

OrderTotal_CurrencyCode

string

OrderTotal_Amount

double

PaymentMethodDetails

string

IsGlobalExpressEnabled

boolean

LastUpdateDate

date

ShipmentServiceLevelCategory

string

ShippingAddress_Name

string

ShippingAddress_AddressLine1

string

ShippingAddress_AddressLine2

string

ShippingAddress_AddressLine3

string

ShippingAddress_City

string

ShippingAddress_County

string

ShippingAddress_District

string

ShippingAddress_StateOrRegion

string

ShippingAddress_Municipality

string

ShippingAddress_PostalCode

string

ShippingAddress_CountryCode

string

ShippingAddress_Phone

string

ShippingAddress_AddressType

string

_weld_synced

date

returns_by_return_date_report

order_id

string

order_date

date

return_request_date

date

return_request_status

string

amazon_rma_id

string

merchant_rma_id

string

label_type

string

label_cost

double

currency_code

string

return_carrier

string

tracking_id

string

label_to_be_paid_by

string

a_to_z_claim

boolean

is_prime

boolean

asin

string

merchant_sku

string

item_name

string

return_quantity

int

return_reason

string

in_policy

boolean

return_type

string

resolution

string

invoice_number

string

return_delivery_date

date

order_amount

double

order_quantity

int

safe_t_action_reason

string

safe_t_claim_id

string

safe_t_claim_state

string

safe_t_claim_creation_time

string

safe_t_claim_reimbursement_amount

double

refunded_amount

double

marketplace_id

string

_weld_synced

date

fba_shipments

shipment_id

string

shipment_name

string

shipment_status

string

label_prep_type

string

destination_fulfillment_center_id

string

are_cases_required

boolean

confirmed_need_by_date

date

box_contents_source

string

estimated_box_contents_fee_total_units

int

estimated_box_contents_fee_fee_per_unit

double

estimated_box_contents_fee_total_fee

double

ship_from_address_address_line_1

string

ship_from_address_city

string

ship_from_address_country_code

string

ship_from_address_name

string

ship_from_address_postal_code

string

_weld_synced

date

sales_and_traffic_report_by_asin

marketplace_id

string

parent_asin

string

child_asin

string

sku

string

units_ordered

int

ordered_product_sales_amount

double

ordered_product_sales_currency_code

string

total_order_items

int

browser_sessions

int

mobile_app_sessions

int

sessions

int

browser_session_percentage

double

mobile_app_session_percentage

double

session_percentage

double

browser_page_views

int

mobile_app_page_views

int

page_views

int

browser_page_views_percentage

double

mobile_app_page_views_percentage

double

page_views_percentage

double

buy_box_percentage

double

unit_session_percentage

double

browser_page_views_b_2_b

int

browser_page_views_percentage_b_2_b

double

browser_session_percentage_b_2_b

double

browser_sessions_b_2_b

int

buy_box_percentage_b_2_b

double

mobile_app_page_views_b_2_b

int

mobile_app_page_views_percentage_b_2_b

double

mobile_app_session_percentage_b_2_b

double

mobile_app_sessions_b_2_b

int

ordered_product_sales_b_2_b_amount

double

ordered_product_sales_b_2_b_currency_code

string

page_views_b_2_b

int

page_views_percentage_b_2_b

double

session_percentage_b_2_b

double

sessions_b_2_b

int

total_order_items_b_2_b

int

unit_session_percentage_b_2_b

double

units_ordered_b_2_b

int

start_date

date

end_date

date

_weld_synced

date

orderitems

ProductInfo_NumberOfItems

double

BuyerInfo

string

ItemTax_CurrencyCode

string

ItemTax_Amount

double

QuantityShipped

double

ItemPrice_CurrencyCode

string

ItemPrice_Amount

double

ASIN

string

SellerSKU

string

Title

string

IsGift

boolean

IsTransparency

boolean

QuantityOrdered

double

PromotionDiscountTax_CurrencyCode

string

PromotionDiscountTax_Amount

double

PromotionDiscount_CurrencyCode

string

PromotionDiscount_Amount

double

OrderItemId

double

AmazonOrderId

string

purchaseDate

date

hasNext

boolean

ShippingTax_CurrencyCode

string

ShippingTax_Amount

double

ShippingPrice_CurrencyCode

string

ShippingPrice_Amount

double

ShippingDiscount_CurrencyCode

string

ShippingDiscount_Amount

double

ShippingDiscountTax_CurrencyCode

string

ShippingDiscountTax_Amount

double

PromotionIds

string

TaxCollection

string

AmazonPrograms

string

_weld_synced

date

sales_and_traffic_report_by_date

marketplace_id

string

date

ordered_product_sales_amount

double

ordered_product_sales_currency_code

string

units_ordered

int

total_order_items

int

average_sales_per_order_item_amount

double

average_sales_per_order_item_currency_code

string

average_units_per_order_item

double

average_selling_price_amount

double

average_selling_price_currency_code

string

units_refunded

int

refund_rate

double

claims_granted

int

claims_amount_amount

double

claims_amount_currency_code

string

shipped_product_sales_amount

double

shipped_product_sales_currency_code

string

units_shipped

int

orders_shipped

int

browser_page_views

int

mobile_app_page_views

int

page_views

int

browser_sessions

int

mobile_app_sessions

int

sessions

int

buy_box_percentage

double

order_item_session_percentage

double

unit_session_percentage

double

average_offer_count

int

average_parent_items

int

feedback_received

int

negative_feedback_received

int

received_negative_feedback_rate

double

_weld_synced

date

fba_inventory_summary

marketplace_id

string

asin

string

fn_sku

string

seller_sku

string

condition

string

last_updated_time

string

product_name

string

total_quantity

double

fulfillable_quantity

double

future_supply_buyable_quantity

double

reserved_future_supply_quantity

double

inbound_receiving_quantity

double

inbound_shipped_quantity

double

inbound_working_quantity

double

total_researching_quantity

double

researching_quantity_breakdown

string

fc_processing_quantity

double

pending_customer_order_quantity

double

pending_transshipment_quantity

double

total_reserved_quantity

double

carrier_damaged_quantity

double

customer_damaged_quantity

double

defective_quantity

double

distributor_damaged_quantity

double

expired_quantity

double

total_unfulfillable_quantity

double

warehouse_damaged_quantity

double

_weld_synced

date

fba_returns_report

return_date

date

order_id

string

sku

string

asin

string

fnsku

string

product_name

string

quantity

string

fulfillment_center_id

string

detailed_disposition

string

reason

string

status

string

license_plate_number

string

customer_comments

string

_weld_synced

date

ordermetrics

interval

string

unitCount

double

orderItemCount

double

orderCount

double

averageUnitPrice_amount

double

averageUnitPrice_currencyCode

string

totalSales_amount

double

totalSales_currencyCode

string

marketplaceId

string

intervalId

string

_weld_synced

date

merchant_listings_report

item_name

string

item_description

string

listing_id

string

seller_sku

string

price

double

quantity

int

open_date

string

image_url

string

item_is_marketplace

boolean

product_id_type

string

zshop_shipping_fee

double

item_note

string

item_condition

string

zshop_category_1

string

zshop_browse_path

string

zshop_storefront_feature

string

asin_1

string

asin_2

string

asin_3

string

will_ship_internationally

string

expedited_shipping

string

zshop_boldface

string

product_id

string

bid_for_featured_placement

string

add_delete

string

pending_quantity

int

fulfillment_channel

string

merchant_shipping_group

string

status

string

marketplace_id

string

_weld_synced

date

sales_and_traffic_report_by_asin_child

marketplace_id

string

parent_asin

string

child_asin

string

sku

string

units_ordered

int

ordered_product_sales_amount

double

ordered_product_sales_currency_code

string

total_order_items

int

browser_sessions

int

mobile_app_sessions

int

sessions

int

browser_session_percentage

double

mobile_app_session_percentage

double

session_percentage

double

browser_page_views

int

mobile_app_page_views

int

page_views

int

browser_page_views_percentage

double

mobile_app_page_views_percentage

double

page_views_percentage

double

buy_box_percentage

double

unit_session_percentage

double

browser_page_views_b_2_b

int

browser_page_views_percentage_b_2_b

double

browser_session_percentage_b_2_b

double

browser_sessions_b_2_b

int

buy_box_percentage_b_2_b

double

mobile_app_page_views_b_2_b

int

mobile_app_page_views_percentage_b_2_b

double

mobile_app_session_percentage_b_2_b

double

mobile_app_sessions_b_2_b

int

ordered_product_sales_b_2_b_amount

double

ordered_product_sales_b_2_b_currency_code

string

page_views_b_2_b

int

page_views_percentage_b_2_b

double

session_percentage_b_2_b

double

sessions_b_2_b

int

total_order_items_b_2_b

int

unit_session_percentage_b_2_b

double

units_ordered_b_2_b

int

start_date

date

end_date

date

_weld_synced

date

fba_sns_performance_report

sku

string

fnsku

string

asin

string

week_1_start_date

date

marketplace_id

string

country

string

offer_state

string

snapshot_date

date

product_name

string

sns_units_shipped_week_1

double

oos_rate_week_1

string

sns_sale_price_week_1

double

sns_discount_week_1

string

sns_units_shipped_week_2

double

oos_rate_week_2

string

sns_sale_price_week_2

double

sns_discount_week_2

string

sns_units_shipped_week_3

double

oos_rate_week_3

string

sns_sale_price_week_3

double

sns_discount_week_3

string

sns_units_shipped_week_4

double

oos_rate_week_4

string

sns_sale_price_week_4

double

sns_discount_week_4

string

report_id

string

_weld_synced

date

fba_reimbursements_report

approval_date

date

reimbursement_id

string

case_id

string

amazon_order_id

string

reason

string

sku

string

fnsku

string

asin

string

product_name

string

condition

string

currency_unit

string

amount_per_unit

string

amount_total

string

quantity_reimbursed_cash

string

quantity_reimbursed_inventory

string

quantity_reimbursed_total

string

original_reimbursement_id

string

original_reimbursement_type

string

_weld_synced

date

fba_sns_forecast_report

sku

string

fnsku

string

asin

string

week_1_start_date

date

marketplace_id

string

country

string

offer_state

string

snapshot_date

date

estimated_avg_sns_discount_next_8_weeks

string

product_name

string

active_subscriptions

double

scheduled_sns_units_week_1

double

scheduled_sns_units_week_2

double

scheduled_sns_units_week_3

double

scheduled_sns_units_week_4

double

scheduled_sns_units_week_5

double

scheduled_sns_units_week_6

double

scheduled_sns_units_week_7

double

scheduled_sns_units_week_8

double

report_id

string

_weld_synced

date

orders_by_last_updated_date_report

amazon_order_id

string

merchant_order_id

string

purchase_date

date

last_updated_date

date

order_status

string

fulfillment_channel

string

sales_channel

string

order_channel

string

ship_service_level

string

product_name

string

sku

string

asin

string

number_of_items

string

item_status

string

quantity

int

currency

string

item_price

double

item_tax

double

shipping_price

double

shipping_tax

double

gift_wrap_price

double

gift_wrap_tax

double

item_promotion_discount

double

ship_promotion_discount

double

ship_city

string

ship_state

string

ship_postal_code

string

ship_country

string

promotion_ids

string

item_extensions_data

string

is_business_order

boolean

purchase_order_number

string

price_designation

string

fulfilled_by

string

is_amazon_invoiced

boolean

vat_exclusive_item_price

double

vat_exclusive_shipping_price

double

vat_exclusive_giftwrap_price

double

is_iba

boolean

order_invoice_type

string

_weld_synced

date

sales_and_traffic_report_by_asin_sku

marketplace_id

string

parent_asin

string

child_asin

string

sku

string

units_ordered

int

ordered_product_sales_amount

double

ordered_product_sales_currency_code

string

total_order_items

int

browser_sessions

int

mobile_app_sessions

int

sessions

int

browser_session_percentage

double

mobile_app_session_percentage

double

session_percentage

double

browser_page_views

int

mobile_app_page_views

int

page_views

int

browser_page_views_percentage

double

mobile_app_page_views_percentage

double

page_views_percentage

double

buy_box_percentage

double

unit_session_percentage

double

browser_page_views_b_2_b

int

browser_page_views_percentage_b_2_b

double

browser_session_percentage_b_2_b

double

browser_sessions_b_2_b

int

buy_box_percentage_b_2_b

double

mobile_app_page_views_b_2_b

int

mobile_app_page_views_percentage_b_2_b

double

mobile_app_session_percentage_b_2_b

double

mobile_app_sessions_b_2_b

int

ordered_product_sales_b_2_b_amount

double

ordered_product_sales_b_2_b_currency_code

string

page_views_b_2_b

int

page_views_percentage_b_2_b

double

session_percentage_b_2_b

double

sessions_b_2_b

int

total_order_items_b_2_b

int

unit_session_percentage_b_2_b

double

units_ordered_b_2_b

int

start_date

date

end_date

date

_weld_synced

date

Table

Sub table