Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
VENDOR_RETAIL_PROCUREMENT_ORDER ⇱
puchase_order_date🔑�puchase_order_number🔑
bill_to_party_name
bill_to_party_party_id
bill_to_party_tax_registration_number
bill_to_party_tax_registration_type
buying_party_name
buying_party_party_id
buying_party_tax_registration_number
buying_party_tax_registration_type
deal_code
delivery_window
import_containers
international_commercial_terms
method_of_payment
payment_method
port_of_delivery
purchase_order_changed_date
purchase_order_state
purchase_order_state_changed_date
purchase_order_type
selling_party_name
selling_party_party_id
selling_party_tax_registration_number
selling_party_tax_registration_type
ship_to_party_name
ship_to_party_party_id
ship_to_party_tax_registration_number
ship_to_party_tax_registration_type
ship_window
shipping_instructions
bill_to_party_address_*
buying_party_address_*
selling_party_address_*
ship_to_party_address_*
VENDOR_RETAIL_PROCUREMENT_ORDER_ITEM ⇱
customer_order_number🔑➤ VENDOR_RETAIL_PROCUREMENT_ORDER
puchase_order_number🔑➤ VENDOR_RETAIL_PROCUREMENT_ORDER
amazon_product_identifier
amount
is_back_order_allowed
list_price_amount
list_price_currency_code
net_cost_amount
net_cost_currency_code
unit_of_measure
unit_size
vendor_product_identifier
Vendor
For Vendor Central Only
VENDOR_RETAIL_PROCUREMENT_ORDER_STATUS ⇱
puchase_order_number🔑➤ VENDOR_RETAIL_PROCUREMENT_ORDER
last_updated_date
purchase_order_date
purchase_order_status
VENDOR_RETAIL_PROCUREMENT_ORDER_ITEM_STATUS ⇱
item_sequence_number🔑
puchase_order_number🔑➤ VENDOR_RETAIL_PROCUREMENT_ORDER_STATUS
accepted_quantity_amount
accepted_quantity_unit_of_measure
accepted_quantity_unit_size
buyer_product_identifier
confirmation_status
last_receive_date
list_price_amount
list_price_currency_code
net_cost_amount
net_cost_currency_code
ordered_quantity_amount
ordered_quantity_unit_of_measure
ordered_quantity_unit_size
receive_status
received_quantity_amount
received_quantity_unit_of_measure
received_quantity_unit_of_size
rejected_quantity_amount
rejected_quantity_unit_of_measure
rejected_quantity_unit_size
ORDERED_QUANTITY_DETAILS ⇱
index🔑
item_sequence_number🔑➤ VENDOR_RETAIL_PROCUREMENT_ORDER_ITEM_STATUS
puchase_order_number🔑➤ VENDOR_RETAIL_PROCUREMENT_ORDER_ITEM_STATUS
cancelled_amount
cancelled_unit_of_measure
cancelled_unit_size
ordered_amount
ordered_unit_of_measure
ordered_unit_size
updated_date
ACKNOWLEDGEMENT_STATUS_DETAILS ⇱
index🔑
item_sequence_number🔑➤ VENDOR_RETAIL_PROCUREMENT_ORDER_ITEM_STATUS
puchase_order_number🔑➤ VENDOR_RETAIL_PROCUREMENT_ORDER_ITEM_STATUS
accepted_quantity_amount
accepted_quantity_unit_of_measure
accepted_quantity_unit_size
acknowledgement_date
rejected_quantity_amount
rejected_quantity_unit_of_measure
rejected_quantity_unit_size
Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
CONTAINER_IDENTIFICATION ⇱
container_identification_number 🔑
container_identification_type 🔑
container_sequence_number🔑 ➤ VENDOR_RETAIL_PROCUREMENT_CONTAINER
container_type 🔑 ➤ VENDOR_RETAIL_PROCUREMENT_CONTAINER
transaction_date 🔑 ➤ VENDOR_RETAIL_PROCUREMENT_CONTAINER
vendor_shipment_identifier🔑 ➤ VENDOR_RETAIL_PROCUREMENT_CONTAINER
VENDOR_RETAIL_PROCUREMENT_SHIPMENT ⇱
transaction_date 🔑
vendor_shipment_identifier 🔑
bill_of_lading_number
buyer_reference_number
carrier_assignment_date
carrier_details_code
carrier_details_email
carrier_details_name
carrier_details_phone
carrier_details_shipment_reference_number
current_shipment_status
current_shipment_status_date
estimated_delivery_date
import_details_billable_weight_unit_of_measure
import_details_billable_weight_value
import_details_estimated_ship_by_date
import_details_handling_instructions
import_details_import_containers
import_details_international_commercial_terms
import_details_method_of_payment
import_details_port_of_delivery
import_details_seal_number
import_details_shipping_instructions
packageLabel_create_date
requested_pick_up
scheduled_pick_up
selling_party_attention
selling_party_name
selling_party_party_id
ship_from_party_attention
ship_from_party_name
ship_from_party_party_id
ship_mode
ship_to_party_attention
ship_to_party_name
ship_to_party_party_id
shipment_confirm_date
shipment_create_date
shipment_delivery_date
shipment_freight_term
shipment_measurements_total_carton_count
shipment_measurements_total_pallet_non_stackable
shipment_measurements_total_pallet_stackable
shipment_measurements_volume_unit_of_measure
shipment_measurements_volume_value
shipment_measurements_weight_unit_of_measure
shipment_measurements_weight_value
shipped_date
transaction_type
transportation_mode
selling_party_address*
ship_from_party_address*
ship_to_party_address*
CONTAINER_PACKED_ITEM ⇱
index 🔑
container_sequence_number 🔑 ➤ VENDOR_RETAIL_PROCUREMENT_CONTAINER
container_type 🔑 ➤ VENDOR_RETAIL_PROCUREMENT_CONTAINER
transaction_date 🔑 ➤ VENDOR_RETAIL_PROCUREMENT_CONTAINER
vendor_shipment_identifier 🔑 ➤ VENDOR_RETAIL_PROCUREMENT_CONTAINER
buyer_product_identifier
item_sequence_number
packed_item_details_expiry_duration_duration_unit
packed_item_details_expiry_duration_duration_value
packed_item_details_expiry_expiry_date
packed_item_details_expiry_manufacture_date
packed_item_details_lot_number
packed_item_details_purchase_order_number
packed_quantity_amount
packed_quantity_unit_of_measure
packed_quantity_unit_size
vendor_product_identifier
INNER_CONTAINER_SEQUENCE_NUMBER ⇱
inner_container_sequence_number🔑
container_sequence_number 🔑➤ VENDOR_RETAIL_PROCUREMENT_CONTAINER
container_type 🔑➤ VENDOR_RETAIL_PROCUREMENT_CONTAINER
transaction_date 🔑➤ VENDOR_RETAIL_PROCUREMENT_CONTAINER
vendor_shipment_identifier 🔑➤ VENDOR_RETAIL_PROCUREMENT_CONTAINER
SHIPMENT_STATUS_DETAIL ⇱
index 🔑
transaction_date 🔑 ➤ VENDOR_RETAIL_PROCUREMENT_SHIPMENT
vendor_shipment_identifier 🔑 ➤ VENDOR_RETAIL_PROCUREMENT_SHIPMENT
shipment_status
shipment_status_date
VENDOR_RETAIL_PROCUREMENT_CONTAINER ⇱
container_sequence_number 🔑
container_type 🔑
transaction_date 🔑 ➤ VENDOR_RETAIL_PROCUREMENT_SHIPMENT
vendor_shipment_identifier 🔑 ➤ VENDOR_RETAIL_PROCUREMENT_SHIPMENT
block
container_count
dimensions_height
dimensions_length
dimensions_unit_of_measure
dimensions_width
tier
tracking_number
weight_unit_of_measure
weight_value
VENDOR_SHIPPING_ORDER ⇱
purchase_order_date 🔑 ➤ VENDOR_RETAIL_PROCUREMENT_ORDER
purchase_order_number 🔑 ➤ VENDOR_RETAIL_PROCUREMENT_ORDER
transaction_date 🔑 ➤ VENDOR_RETAIL_PROCUREMENT_SHIPMENT
vendor_shipment_identifier 🔑 ➤ VENDOR_RETAIL_PROCUREMENT_SHIPMENT
ship_window
Vendor Shipping
For Vendor Central Only
Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
ORDERS ⇱
amazon_order_id🔑
automated_shipping_setting_automated_carrier
automated_shipping_setting_automated_ship_method
automated_shipping_setting_has_automated_shipping_settings
buyer_info__buyer_email
buyer_info_buyer_county
buyer_info_buyer_name
buyer_info_purchase_order_number
buyer_invoice_preference
buyer_tax_info_ buyer_business_address
buyer_tax_info_buyer_legal_company_name
buyer_tax_info_buyer_tax_office
buyer_tax_info_buyer_tax_registration_id
cba_displayable_shipping_label
earliest_delivery_date
earliest_ship_date
easy_ship_shipment_status
electronic_invoice_status
fulfillment_channel
fulfillment_supply_source_id
has_regulated_items
is_access_point_order
is_business_order
is_estimated_ship_date_set
is_global_express_enabled
is_iba
is_ispu
is_premium_order
is_prime
is_replacement_order
is_sold_by_ab
last_update_date
latest_delivery_date
latest_ship_date
marketplace_id
number_of_items_shipped
number_of_items_unshipped
order_channel
order_status
order_total_amount
order_total_currency_code
order_type
payment_method
promise_response_due_date
purchase_date
replaced_order_id
sales_channel
seller_display_name
seller_order_id
ship_service_level
shipment_service_level_category
default_ship_from_location_*�shipping_address_*
ORDER_ITEM ⇱
order_item_id🔑
amazon_order_id🔑➤ ORDERS.amazon_order_id
is_gift
is_transparency
asin
buyer_requested_cancelIs_buyer_requested_cancel
buyer_requested_cancel_buyer_cancel_reason
condition_id
condition_note
condition_subtype_id
deemed_reseller_category
ioss_number
item_approval_context_approval_status
item_approval_context_approval_type
item_price_amount
item_price_currency_code
item_tax_amount
item_tax_currencycode
points_granted_monetary_amount
points_granted_monetary_currency_code
points_granted_points_number
price_designation
product_info_detail_number_of_items
promotion_discount_amount
promotion_discount_currency_code
promotion_discount_tax_currency_code
promotion_discount_taxa_amount
quantity_ordered
quantity_shipped
scheduled_delivery_end_date
scheduled_delivery_start_date
seller_sku
serial_number_required
shipping_discount_amount
shipping_discount_currency_code
shipping_discount_tax_amount
shipping_discount_tax_currency_code
shipping_price_amount
shipping_price_currency_code
shipping_tax_amount
shipping_taxcurrency_code
store_chain_storeId
tax_collection_model
tax_collection_responsible_party
title
ORDER_ITEM_PROMOTION_ID ⇱
promotion_id🔑
amazon_order_id🔑➤ ORDERS.amazon_order_id
order_item_id🔑➤ ORDER_ITEM.order_item_id
Orders
COD_PAYMENT_EXECUTION_DETAIL ⇱
index🔑
amazon_order_id 🔑➤ ORDERS.amazon_order_id
payment_method
payment_amount
payment_currency_code
PAYMENT_METHOD_DETAIL_ITEM ⇱
method🔑
amazon_order_id 🔑➤ ORDERS.amazon_order_id
MARKETPLACE_TAX_CLASSIFICATION ⇱
name🔑
amazon_order_id 🔑➤ ORDERS.amazon_order_id
value
ORDER_ITEM_SERIAL_NUMBER ⇱
serial_number🔑
amazon_order_id🔑➤ ORDER_ITEM.amazon_order_id
order_item_id🔑➤ ORDER_ITEM.order_item_id
APPROVAL_SUPPORT_DATA_ELEMENT ⇱
name🔑
amazon_order_id🔑➤ ORDERS.amazon_order_id
order_item_id🔑➤ ORDER_ITEM.order_item_id
value
amazon_order_id 🔑➤ ORDERS.amazon_order_id
external_reviewer_id
rejection_reason
requires_dosage_label
requires_merchant_action
review_date
status
ORDER_REGULATED_INFO ⇱
REGULATED_INFORMATION_FIELD ⇱
id🔑
amazon_order_id 🔑➤ ORDER_REGULATED_INFO.amazon_order_id
field_label
field_type
field_value
Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
CATALOG ⇱
asin 🔑
marketplace_id 🔑
attribute_*
ITEM_DIMENSION ⇱
asin 🔑➤ CATALOG
marketplace_id🔑➤ CATALOG
item_height_unit
item_height_value
item_length_unit
item_length_value
item_weight_unit
item_weight_value
item_width_unit
Item_width_value
package_height_unit
package_height_value
package_length_unit
package_length_value
package_weight_unit
package_weight_value
package_width_unit
pckage_width_value
ITEM_IDENTIFIER ⇱
asin 🔑➤ CATALOG
marketplace_id🔑➤ CATALOG
identifier_type🔑
identifier
ITEM_IMAGE ⇱
asin 🔑➤ CATALOG
marketplace_id🔑➤ CATALOG
variant 🔑
height
link
width
ITEM_PRODUCT_TYPE ⇱
asin 🔑➤ CATALOG
marketplace_id🔑➤ CATALOG�product_type
ITEM_RELATIONSHIP ⇱
parent_asin 🔑➤ CATALOG
child_asin🔑➤ CATALOG
type 🔑
ITEM_CLASSIFICATION_SALES_RANK ⇱
asin 🔑➤ CATALOG
marketplace_id🔑➤ CATALOG
classification_id 🔑
link
rank
title
ITEM_DISPLAY_GROUP_SALES_RANK ⇱
asin 🔑➤ CATALOG
website_display_group 🔑
title
link
rank
ITEM_VARIATION_THEME ⇱
asin 🔑➤ CATALOG
theme
attribute
ITEM_SUMMARY ⇱
asin 🔑➤ CATALOG
marketplace_id🔑➤ CATALOG
brand
browser_classification_classification_id
browser_classification_display_name
color
contributors
item_classification
item_name
manufacture
model_number
package_quantity
part_number
size
style
website_display_group
website_display_group_name
ITEM_VENDOR_DETAILS ⇱
asin 🔑➤ CATALOG
marketplace_id🔑➤ CATALOG
brand_code
manufacture_code
manufacture_code_parent
product_category_display_name
product_category_value
product_group
product_subcategory_display_name
product_subcategory_value
replenishment_category
Catalog
id🔑�asin🔑➤ CATALOG
belong_to_requester
condition
offer_type
price_landed_price_amount
price_landed_price_currency_code
price_listing_price_amount
price_listing_price_currency_code
price_points_points_monetary_value_amount
price_points_points_monetary_value_currency_code
price_points_points_number
price_shipping_amount
price_shipping_currency_code
quantity_discount_type
quantity_tier
seller_id
subcondition
COMPETITIVE_PRICE_TYPE⇱
CPT_OFFER_LISTING_COUNT_TYPE⇱
asin 🔑➤ CATALOG
condition
count
CPT_TRADE_IN_VALUE ⇱
asin 🔑➤ CATALOG
currency_code�amount
ITEM_OFFER_SUMMARY⇱
asin🔑➤ CATALOG
competitive_price_threshold_amount
competitive_price_threshold_currency_code
item_condition
list_price_amount
list_price_currency_code
marketplace_id
offers_available_time
sku
status
suggested_lower_price_plus_shipping_amount
suggested_lower_price_plus_shipping_currency_code
total_offer_count
ITEM_OFFER_COUNT_TYPE⇱
asin 🔑➤ CATALOG
condition
fullfillment_channel�offer_count
ITEM_OFFER_LOWEST_PRICE_TYPE⇱
asin 🔑➤ CATALOG
condition
fullfillment_channel
landed_price_amount
landed_price_currency_code
listing_price_amount
listing_price_currency_code
offer_type
points_monetary_value_amount
points_monetary_value_currency_code
points_points_number
quantity_discount_type
quantity_tier
shipping_amount
shipping_currency_code
ITEM_BUY_BOX_PRICE_TYPE⇱
asin 🔑➤ CATALOG
condition
landed_price_amount
landed_price_currency_code
listing_price_amount
listing_price_currency_code
offer_type
points_monetary_value_amount
points_monetary_value_currency_code
points_points_number
quantity_discount_type
quantity_tier
seller_id
shipping_amount
shipping_currency_code
ITEM_SALES_RANK_TYPE⇱
asin 🔑➤ CATALOG
product_category_id
rank
asin 🔑➤ CATALOG
sub_condition 🔑
index 🔑
condition_notes
is_buy_box_winner
is_featured_merchant
is_fullfilled_by_amazon
is_national_prime
listing_price_amount
listing_price_currency_code
my_offer
offer_type
points_points_monetary_value
points_points_number
prime_information_is_prime
seller_feedback_rating
seller_id
shipping_amount
shipping_currency_code
shipping_time_available_date
shipping_time_availablity_type
shipping_time_maximum_hours
shipping_time_minimum_hours
ships_from_country
ships_from_state
ITEM_OFFER_DETAIL⇱
ITEM_QUANTITY_DISCOUNT_PRICE_TYPE⇱
asin 🔑➤ CATALOG
listing_price_amount
listing_price_currency_code
quantity_discount_type
quantity_tier
Product Pricing
Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
FULLFILLMENT_ORDER ⇱
seller_fulfillment_order_id🔑
cod_charge_currency_code
cod_charge_tax_currency_code
cod_charge_tax_value
cod_charge_value
is_cod_required
shipping_charge_currency_code
shipping_charge_tax_currency_code
shipping_charge_tax_value
shipping_charge_value
delivery_window_end_date
delivery_window_start_date
displayable_order_comment
displayable_order_date
displayable_order_id
fullfillment_action
fullfillment_order_status
fullfillment_policy
marketplace_id
received_date
shipping_speed_category
status_updated_date
address_*
FULLFILLMENT_ORDER_NOTIFICATION_EMAIL ⇱
email 🔑
seller_fulfillment_order_id 🔑 ➤ FULLFILLMENT_ORDER
FULLFILLMENT_ORDER_FEATURE_SETTINGS ⇱
feature_name 🔑
seller_fulfillment_order_id 🔑 ➤ FULLFILLMENT_ORDER
feature_fullfillment_policy
PACKAGE_TRACKING_DETAIL ⇱
package_number🔑
additional_location_info
carrier_code
carrier_phone_number
carrier_url
current_status_description
current_status
customer_tracking_link
estimated_arrival_date
ship_date
ship_to_address_city
ship_to_address_country
ship_to_address_state
signed_for_by
tracking_number
PACKAGE_TRACKING_EVENT ⇱
code 🔑
package_number🔑 ➤ PACKAGE_TRACKING_DETAIL
address_city
address_country
address_state
date
description
tracking_number
OUTBOUND_SELLER_FEATURE ⇱
feature_name🔑
feature_description
seller_eligible
INVENTORY_FEATURE ⇱
seller_sku 🔑
feature_name 🔑 ➤ OUTBOUND_SELLER_FEATURE
asin
fn_sku
marketplace_id
overlapping_skus
sku_count
RETURN_REASON_CODE ⇱
return_reason_code 🔑
description
translated_description
Fulfillment Outbound
ITEM_FULLFILLMENT_AVAILABILITY ⇱
fullfillment_channel_code 🔑
sku 🔑 ➤ LISTED_ITEM
quantity
LISTED_ITEM ⇱
sku🔑
item_procurement_amount
item_procurement_currency_code
LISTED_ITEM_ISSUE ⇱
code 🔑
sku 🔑 ➤ LISTED_ITEM
message
severity
LISTED_ITEM_OFFER ⇱
marketplace_id 🔑
offer_type 🔑
sku 🔑 ➤ LISTED_ITEM
points_number
price_amount
price_currency_code
LISTED_ITEM_SUMMARY ⇱
marketplace_id 🔑
sku 🔑 ➤ LISTED_ITEM
asin
condition_type
created_date
fn_sku
image_height
image_link
image_width
item_name
last_updated_date
message
product_type
severity
Listed Item
FBA_INVENTORY_SUMMARY ⇱
_fivetran_id 🔑
asin ➤ CATALOG
granularity_id
granularity_type
carrier_damaged_quantity
condition
customer_damaged_quantity
defective_quantity
distributor_damaged_quantity
expired_quantity
fc_processing_quantity
fn_sku
fullfillable_quantity
inblound_shipped_quantity
inbound_receiving_quantity
inbound_working_quantity
last_updated_time
pending_customer_order_quantity
pending_tansshipment_quantity
product_name
seller_sku
total_quantity
total_researching_quantity
total_reserved_quantity
total_unfulfillable_quantity
warehouse_damaged_quantity
FBA_INVENTORY_RESEARCHING_QUANTITY_ENTRY ⇱
inventory_summary_id 🔑 ➤ FBA_INVENTORY_SUMMARY
name 🔑
quantity
SMALL_AND_LIGHT_ENROLLMENT_STATUS ⇱
marketplace_id 🔑
seller_sku 🔑
status
FBA
Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
EASYSHIP_PACKAGE ⇱
package_id 🔑
amazon_order_id 🔑 ➤ ORDER
invoice_date
invoice_number
package_height
package_identifier
package_length
package_status
package_unit
package_weight_unit
package_weight_value
package_width
time_slot_end_time
time_slot_handover_method
time_slot_id
time_slot_start_time
tracking_id
EASYSHIP_PACKAGE_ITEM ⇱
order_item_id 🔑 ➤ ORDER_ITEM
package_id 🔑 ➤ EASYSHIP_PACKAGE
EASYSHIP_PACKAGE_ITEM_SERIAL_NUMBER ⇱
order_item_serial_number 🔑
order_item_id 🔑 ➤ ORDER_ITEM
package_id 🔑 ➤ EASYSHIP_PACKAGE
Easyship
FEED ⇱
id 🔑
created_time
feed_type
processing_end_time
processing_start_time
processing_status
result_feed_document_id
Feeds
CONTENT_META_DATA_RECORD ⇱
content_reference_key🔑
marketplace_id🔑
name
status
update_time
CONTENT_BADGE_SET ⇱
content_reference_key🔑➤ CONTENT_META_DATA_RECORD.content_reference_key
content_badge🔑
id🔑
asin
buyer_buyer_id
buyer_is_prime_member
buyer_name
buyer_phone
create_time
marketplace_id
quantity
required_skills
seller_id
service_job_provider_id
service_job_status
service_location_address_phone
service_location_service_location_type
service_order_id
store_id
title
service_location_address_*
SERVICE_JOB ⇱
SERVICE_JOB_APPOINTMENT_TIME ⇱
service_job_id🔑➤ SERVICE_JOB
duration_in_minutes
start_time
SERVICE_JOB_APPOINTMENT ⇱
appointment_id🔑
service_job_id🔑➤ SERVICE_JOB
appointment_status
appointment_time_duration_in_minutes
appointment_time_start_time
poa_oploading_technician
poa_type
poa_upload_time
rescheduled_appointement_id
upload_time
TECHNICIAN ⇱
technician_id🔑
service_job_id🔑➤ SERVICE_JOB�name
Services
Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
FINANCIAL_EVENT_GROUP ⇱
id 🔑
account_tail
beginning_balance_currency_amount
beginning_balance_currency_code
converted_total_currency_amount
converted_total_currency_code
financial_event_group_end
financial_event_group_start
fund_transfer_date
fund_transfer_status
original_total_currency_amount
original_total_currency_code
processing_status
trace_id
FINANCIAL_SHIPMENT_EVENT ⇱
_fivetran_id 🔑
amazon_order_id ➤ ORDER.amazon_order_id
financial_event_group_id ➤ FINANCIAL_EVENT_GROUP
seller_order_id ➤ ORDER.seller_order_id
event_type
marketplace_name
posted_date
FINANCIAL_CHARGE_COMPONENT ⇱
charge_kind 🔑
charge_type 🔑
index 🔑
linked_to 🔑
linked_to_id 🔑
currency_amount
currency_code
FINANCIAL_FEE_COMPONENT ⇱t
index 🔑
fee_kind 🔑
fee_type 🔑
linked_to 🔑
linked_to_id 🔑
currency_amount
currency_code
FINANCIAL_SHIPMENT_DIRECT_PAYMENT ⇱
index 🔑
shipment_event_id 🔑 ➤ FINANCIAL_SHIPMENT_EVENT
shipment_event_type
currency_amount
currency_code
payment_type
FINANCIAL_PAY_WITH_AMAZON_EVENT ⇱
_fivetran_id 🔑
seller_order_id ➤ ORDER.seller_order_id
financial_event_group_id ➤ FINANCIAL_EVENT_GROUP
amount_description
business_object_type
charge_currency_amount
charge_currency_code
charge_type
fullfillment_channel
payment_amount_type
sales_channel
store_name
transaction_posted_date
FINANCIAL_SOLUTION_PROVIDER_CREDIT_EVENT ⇱
_fivetran_id 🔑
financial_event_group_id ➤ FINANCIAL_EVENT_GROUP
seller_order_id ➤ ORDER.seller_order_id
marketplace_country_code
marketplace_id
provider_id
provider_store_name
provider_transaction_type
seller_id
seller_store_name
transaction_amount
transaction_creation_date
FINANCIAL_RETRO_CHARGE_EVENT ⇱
_fivetran_id 🔑
amazon_order_id ➤ ORDER.amazon_order_id
financial_event_group_id ➤ FINANCIAL_EVENT_GROUP
basetax_currency_amount
basetax_currency_code
marketplace_name
posted_date
retrocharge_event_type
shipping_tax_currency_amount
shipping_tax_currency_code
tax_collection_model
FINANCIAL_RENTAL_TRANSACTION _EVENT ⇱
_fivetran_id 🔑
amazon_order_id ➤ ORDER.amazon_order_id
financial_event_group_id ➤ FINANCIAL_EVENT_GROUP
extension_length
marketplace_name
posted_date
rental_event_type
rental_initial_value_currency_amount
rental_initial_value_currency_code
rental_reimbursement_value_currency_amount
rental_reimbursement_value_currency_code
tax_collection_model
FINANCIAL_PRODUCT_ADS_PAYMENT _EVENT ⇱
_fivetran_id 🔑
financial_event_group_id ➤ FINANCIAL_EVENT_GROUP
base_value_currency_amount
base_value_currency_code
invoice_id
posted_date
tax_value_currency_amount
tax_value_currency_code
transaction_type
transaction_value_currency_amount
transaction_value_currency_code
FINANCIAL_SERVICE_FEE_EVENT ⇱
_fivetran_id 🔑
amazon_order_id ➤ ORDER.amazon_order_id
financial_event_group_id ➤ FINANCIAL_EVENT_GROUP
asin
fee_description
fee_reason
fn_sku
seller_sku
FINANCIAL_SELLER_DEAL_PAYMENT_EVENT ⇱
_fivetran_id 🔑
financial_event_group_id ➤ FINANCIAL_EVENT_GROUP
deal_description
deal_id
event_type
fee_amount_currency_amount
fee_amount_currency_code
fee_type
posted_date
tax_amount_currency_amount
tax_amount_currency_code
total_amount_currency_amount
total_amount_currency_code
FINANCIAL_DEBT_RECOVERY_EVENT ⇱
_fivetran_id 🔑
financial_event_group_id ➤ FINANCIAL_EVENT_GROUP
debt_recovery_type
over_payment_credit_currency_amount
over_payment_credit_currency_code
recovery_amount_currency_amount
recovery_amount_currency_code
FINANCIAL_DEBT_RECOVERY_ITEM ⇱
debt_recovery_event_id 🔑➤ FINANCIAL_DEBT_RECOVERY_EVENT
index 🔑
debt_recovery_type
over_payment_credit_currency_amount
over_payment_credit_currency_code
recovery_amount_currency_amount
recovery_amount_currency_code
FINANCIAL_LOAN_SERVICING_EVENT ⇱
_fivetran_id 🔑
financial_event_group_id ➤ FINANCIAL_EVENT_GROUP
loan_amount_currency_amount
loan_amount_currency_code
source_business_event_type
FINANCIAL_ADJUSTMENT_EVENT ⇱
_fivetran_id 🔑
financial_event_group_id ➤ FINANCIAL_EVENT_GROUP
adjustment_amount_currency_amount
adjustment_amount_currency_code
adjustment_type
posted_date
FINANCIAL_SAFET_REIMBURSEMENT_EVENT ⇱
_fivetran_id 🔑
financial_event_group_id ➤ FINANCIAL_EVENT_GROUP
posted_date
reason_code
reimbursed_amount_currency_amount
reimbursed_amount_currency_code
safet_claim_id
FINANCIAL_SAFET_REIMBURSEMENT_ITEM ⇱
index 🔑
_fivetran_id 🔑
safet_reimbursement_event_id 🔑➤ FINANCIAL_SAFET_REIMBURSEMENT_EVENT
product_description
quantity
FINANCIAL_SELLER_REVIEW_ENROLLMENT_PAYMENT_EVENT ⇱
_fivetran_id 🔑
financial_event_group_id ➤ FINANCIAL_EVENT_GROUP
enrollment_id
parent_asin
posted_date
total_amount_currency_amount
total_amount_currency_code
FINANCIAL_FBA_LIQUIDATION_EVENT ⇱
_fivetran_id 🔑
financial_event_group_id ➤ FINANCIAL_EVENT_GROUP
liquidation_fee_amount_currency_amount
liquidation_fee_amount_currency_code
liquidation_proceeds_amount_currency_amount
liquidation_proceeds_amount_currency_code
original_removal_order_id
posted_date
FINANCIAL_IMAGING_SERVICES_FEE_EVENT ⇱
_fivetran_id 🔑
financial_event_group_id ➤ FINANCIAL_EVENT_GROUP
asin
imaging_request_billing_item_id
posted_date
NETWORK_COMMINGLING_TRANSACTION_EVENT ⇱
_fivetran_id 🔑
financial_event_group_id ➤ FINANCIAL_EVENT_GROUP
net_co_transaction_id
asin
marketplace_id
posted_date
swap_reason
tax_amount_currency_amount
tax_amount_currency_code
tax_exclusive_amount_currency_amount
tax_exclusive_amount_currency_code
transaction_type
FINANCIAL_AFFORDABILITY_EXPENSE_EVENT ⇱
_fivetran_id 🔑
amazon_order_id ➤ ORDER.amazon_order_id
financial_event_group_id ➤ FINANCIAL_EVENT_GROUP
base_expense_currency_amount
base_expense_currency_code
event_type
marketplace_id
posted_date
tax_type_cgst_currency_amount
tax_type_cgst_currency_code
tax_type_igst_currency_amount
tax_type_igst_currency_code
tax_type_sgst_currency_amount
tax_type_sgst_currency_code
total_expense_currency_amount
total_expense_currency_amount
transaction_type
FINANCIAL_CHARGE_INSTRUMENT ⇱
debt_recovery_event_id 🔑➤ FINANCIAL_DEBT_RECOVERY_EVENT
index 🔑
amount_currency_amount
amount_currency_code
description
tail
FINANCIAL_ADJUSTMENT_ITEM ⇱
adjustment_event_id 🔑➤ FINANCIAL_ADJUSTMENT_EVENT
index 🔑
asin
fn_sku
per_unit_amount_currency_amount
per_unit_amount_currency_code
posted_date
product_description
quantity
seller_sku
total_amount_currency_amount
total_amount_currency_code
FINANCIAL_TRIAL_SHIPMENT_EVENT ⇱
_fivetran_id 🔑
amazon_order_id ➤ ORDER.amazon_order_id
financial_event_group_id ➤ FINANCIAL_EVENT_GROUP
posted_date
sku
FINANCIAL_TAX_WITHHOLDING_EVENT ⇱
_fivetran_id 🔑
financial_event_group_id ➤ FINANCIAL_EVENT_GROUP
base_amount_currency_amount
base_amount_currency_code
posted_date
tax_withholding_period_end_date
tax_withholding_period_start_date
withheld_amount_currency_amount
withheld_amount_currency_code
FINANCIAL_REMOVAL_SHIPMENT_EVENT ⇱
_fivetran_id 🔑
financial_event_group_id ➤ FINANCIAL_EVENT_GROUP
merchant_order_id
order_id
posted_date
transaction_type
FINANCIAL_REMOVAL_SHIPMENT_ITEM ⇱
removal_shipment_event_id 🔑➤ FINANCIAL_REMOVAL_SHIPMENT_EVENT
removal_shipment_item_id 🔑
fee_amount_currency_amount
fee_amount_currency_code
full_fillment_network_sku
quantity
revenue_currency_amount
revenue_currency_code
tax_amount_currency_amount
tax_amount_currency_code
tax_with_held_currency_amount
tax_with_held_currency_code
FINANCIAL_REMOVAL_SHIPMENT_ADJUSTMENT_EVENT ⇱
_fivetran_id 🔑
adjustment_event_id
financial_event_group_id ➤ FINANCIAL_EVENT_GROUP
merchant_order_id
order_id
posted_date
transaction_type
FINANCIAL_COUPON_PAYMENT_EVENT ⇱
_fivetran_id 🔑
financial_event_group_id ➤ FINANCIAL_EVENT_GROUP
clip_or_redemption_count
coupon_id
payment_event_id
posted_date
seller_coupon_description
total_amount_currency_amount
total_amount_currency_code
Finance
FINANCIAL_REMOVAL_SHIPMENT_ITEM_ADJUSTMENT ⇱
financial_removal_shipment_adjustment_event_id 🔑➤ FINANCIAL_REMOVAL_SHIPMENT_ADJUSTMENT_EVENT
removal_shipment_id 🔑
adjusted_quantity
fulfillment_network_sku
revenue_adjustment_currency_amount
revenue_adjustment_currency_code
tax_amount_currency_amount
tax_amount_currency_code
tax_collection_model
tax_withheld_currency_amount
tax_withheld_currency_code
FINANCIAL_ADHOC_DISBURSEMENT_EVENT ⇱
_fivetran_id 🔑
financial_event_group_id ➤ FINANCIAL_EVENT_GROUP
posted_date
transaction_amount_currency_amount
transaction_amount_currency_code
transaction_id
transaction_type
FINANCIAL_TDS_REIMBURSEMENT_EVENT ⇱
_fivetran_id 🔑
financial_event_group_id ➤ FINANCIAL_EVENT_GROUP
posted_date
reimbursed_amount_currency_amount
reimbursed_amount_currency_code
tds_order_id
FINANCIAL_CHARGE_REFUND_EVENT ⇱
_fivetran_id 🔑
financial_event_group_id ➤ FINANCIAL_EVENT_GROUP
posted_date
reason_code
reason_code_description
FINANCIAL_CAPACITY_RESERVATION_BILLING_EVENT ⇱
_fivetran_id 🔑
financial_event_group_id ➤ FINANCIAL_EVENT_GROUP
transaction_type
posted_date
description
transaction_amount_currency_amount
transaction_amount_currency_code
FINANCIAL_FAILED_ADHOC_DISBURSEMENT_EVENT ⇱
_fivetran_id 🔑
financial_event_group_id ➤ FINANCIAL_EVENT_GROUP
disbursement_id
funds_transfers_type
payment_disbursement_type
posted_date
status
transfer_amount_currency_amount
transfer_amount_currency_code
transfer_id
FINANCIAL_VALUE_ADDED_SERVICE_CHARGE_EVENT ⇱
_fivetran_id 🔑
financial_event_group_id ➤ FINANCIAL_EVENT_GROUP
description
posted_date
transaction_amount_currency_amount
transaction_amount_currency_code
transaction_type
FINANCIAL_SHIPMENT_EVENT_ITEM_PROMOTION ⇱
financial_shipment_event_item_id 🔑➤ FINANCIAL_SHIPMENT_EVENT_ITEM
index 🔑
type 🔑
amount_currency_amount
amount_currency_code
id
promotion_kind
FINANCIAL_SHIPMENT_EVENT_ITEM ⇱
_fivetran_id 🔑
financial_shipment_event_id ➤ FINANCIAL_SHIPMENT_EVENT�order_item_id ➤ ORDER_ITEM
cost_of_points_granted_currency_amount
cost_of_points_granted_currency_code
cost_of_points_returned_currency_amount
cost_of_points_returned_currency_code
index
item_kind
order_adjustment_item_id
quantity_shipped
seller_sku
financial_charge_component
Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
Reports
NET_PURE_PRODUCT_MARGIN_REPORT_* ⇱
asin 🔑
end_date 🔑
marketplace_id 🔑
start_date 🔑
net_pure_product_margin
RAPID_RETAIL_ANALYTICS_INVENTORY_REPORT_* ⇱
asin 🔑
end_time 🔑
marketplace_id 🔑
start_time 🔑
highly_available_inventory
RAPID_RETAIL_ANALYTICS_SALES_REPORT_* ⇱
asin 🔑
end_time 🔑
marketplace_id 🔑
start_time 🔑
ordered_units
ordered_revenue
RAPID_RETAIL_ANALYTICS_TRAFFIC_REPORT_* ⇱
asin 🔑
end_time 🔑
marketplace_id 🔑
start_time 🔑
glance_views
VENDOR_TRAFFIC_REPORT_* ⇱
asin 🔑
end_date 🔑
marketplace_id 🔑
start_date 🔑
glance_views
Vendor Reports
VENDOR_FORECASTING_REPORT_* ⇱
asin 🔑
end_date 🔑
forecast_generation_date 🔑
marketplace_id 🔑
start_date 🔑
mean_forecast_units
p70_forecast_units
p80_forecast_units
p90_forecast_units
VENDOR_INVENTORY_REPORT_* ⇱
end_date 🔑
marketplace_id 🔑
start_date 🔑
aged_90_plus_days_sellable_inventory_cost_amount
aged_90_plus_days_sellable_inventory_cost_currency_code
aged_90_plus_days_sellable_inventory_units
average_vendor_lead_time_days
net_received_inventory_cost_amount
net_received_inventory_cost_currency_code
net_received_inventory_units
open_purchase_order_units
procurable_product_out_of_stock_rate
receive_fill_rate
sell_through_rate
sellable_on_hand_inventory_cost_amount
sellable_on_hand_inventory_cost_currency_code
sellable_on_hand_inventory_units
uft
unfilled_customer_ordered_units
unhealthy_inventory_cost_amount
unhealthy_inventory_cost_currency_code
unhealthy_inventory_units
unsellable_on_hand_inventory_cost_amount
unsellable_on_hand_inventory_cost_currency_code
unsellable_on_hand_inventory_units
vendor_confirmation_rate
VENDOR_SALES_REPORT_* ⇱
end_date 🔑
marketplace_id 🔑
start_date 🔑
customer_returns
ordered_revenue_amount
ordered_revenue_currency_code
ordered_units
shipped_cogs_amount
shipped_cogs_currency_code
shipped_revenue_amount
shipped_revenue_currency_code
shipped_units
VENDOR_SALES_ASIN_REPORT_* ⇱
asin 🔑
end_date 🔑
marketplace_id 🔑
start_date 🔑
customer_returns
ordered_revenue_amount
ordered_revenue_currency_code
ordered_units
shipped_cogs_amount
shipped_cogs_currency_code
shipped_revenue_amount
shipped_revenue_currency_code
shipped_units
VENDOR_INVENTORY_ASIN_REPORT_* ⇱
asin 🔑
end_date 🔑
marketplace_id 🔑
start_date 🔑
aged_90_plus_days_sellable_inventory_cost_amount
aged_90_plus_days_sellable_inventory_cost_currency_code
aged_90_plus_days_sellable_inventory_units
average_vendor_lead_time_days
net_received_inventory_cost_amount
net_received_inventory_cost_currency_code
net_received_inventory_units
open_purchase_order_units
procurable_product_out_of_stock_rate
receive_fill_rate
sell_through_rate
sellable_on_hand_inventory_cost_amount
sellable_on_hand_inventory_cost_currency_code
sellable_on_hand_inventory_units
uft
unfilled_customer_ordered_units
unhealthy_inventory_cost_amount
unhealthy_inventory_cost_currency_code
unhealthy_inventory_units
unsellable_on_hand_inventory_cost_amount
unsellable_on_hand_inventory_cost_currency_code
unsellable_on_hand_inventory_units
vendor_confirmation_rate
Note: The VENDOR_SALES_REPORT represents the following Amazon reports:
Note: The VENDOR_SALES_ASIN_REPORT_ represents the following Amazon reports:
Note: The VENDOR_INVENTORY_REPORT_* represents the following Amazon reports:
Note: The VENDOR_INVENTORY_ASIN_REPORT_* represents the following Amazon reports:
MARKET_BASKET_ANALYSIS_REPORT_* ⇱
asin 🔑
end_date 🔑
marketplace_id 🔑
purchased_with_asin 🔑
start_date 🔑
combination_pct
purchased_with_rank
REPEAT_PURCHASE_REPORT_* ⇱
asin 🔑
end_date 🔑
marketplace_id 🔑
start_date 🔑
orders
repeat_customers_pct_total
repeat_purchase_revenue_amount
repeat_purchase_revenue_currency_code
repeat_purchase_revenue_pct_total
unique_customers
SEARCH_TERMS_REPORT_* ⇱
clicked_asin 🔑
department_name 🔑
end_date 🔑
marketplace_id 🔑
search_frequency_rank 🔑
search_term 🔑
start_date 🔑
click_share
click_share_rank
conversion_share
Common Reports
Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
Reports
Sales Reports
FULFILLED_SHIPMENTS_DATA_GENERAL_REPORT ⇱
amazon_order_id 🔑
amazon_order_item_id 🔑
marketplace_id 🔑
shipment_id 🔑
shipment_item_id 🔑
sku 🔑
bill_address_1
bill_address_2
bill_address_3
bill_city
bill_country
bill_postal_code
bill_state
buyer_email
buyer_name
buyer_phone_number
carrier
currency
estimated_arrival_date
fulfillment_center_id
fulfillment_channel
gift_wrap_price
gift_wrap_tax
item_price
item_promotion_discount
Item_tax
merchant_order_id
merchant_order_item_id
payments_date
product_name
purchase_date
quantity_shipped
reporting_date
recipient_name
sales_channel
ship_address_1
ship_address_2
ship_address_3
ship_city
ship_country
ship_phone_number
ship_postal_code
ship_promotion_discount
ship_service_level
ship_state
shipment_date
shipping_price
shipping_tax
tracking_number
CUSTOMER_SHIPMENT_SALES_REPORT ⇱
amazon_order_id 🔑
asin 🔑
marketplace_id 🔑
sku 🔑
currency
fnsku
fulfillment_center_id
gift_wrap_price
item_price_per_unit
quantity
ship_city
ship_postal_code
ship_state
shipment_date
shipping_price
Payments Reports
REIMBURSEMENTS_REPORT ⇱
amazon_order_id 🔑
asin 🔑
marketplace_id 🔑
reimbursement_id 🔑
sku 🔑
amount_per_unit
amount_total
approval_date
case_id
condition
currency_unit
fnsku
original_reimbursement_id
original_reimbursement_type
product_name
quantity_reimbursed_cash
quantity_reimbursed_inventory
quantity_reimbursed_total
reason
ORDERS_REPORT ⇱
amazon_order_id 🔑
asin 🔑
marketplace_id 🔑
sku 🔑
actual_ship_from_address_city
actual_ship_from_address_country
actual_ship_from_address_field_1
actual_ship_from_address_field_2
actual_ship_from_address_field_3
actual_ship_from_address_name
actual_ship_from_address_postal_code
actual_ship_from_address_state
currency
default_ship_from_address_city
default_ship_from_address_country
default_ship_from_address_field_1
default_ship_from_address_field_2
default_ship_from_address_field_3
default_ship_from_address_name
default_ship_from_address_postal_code
default_ship_from_address_state
fulfillment_channel
gift_wrap_price
gift_wrap_tax
ioss_number
item_price
item_promotion_discount
item_status
item_tax
last_updated_date
license_expiration_date
license_number
license_state
licensee_name
merchant_order_id
order_channel
order_status
product_name
promotion_ids
purchase_date
quantity
sales_channel
ship_city
ship_country
ship_postal_code
ship_promotion_discount
ship_service_level
ship_state
shipping_price
shipping_tax
FULFILLMENT_CUSTOMER_SHIPMENT_PROMOTION_REPORT ⇱
amazon_order_id 🔑
marketplace_id 🔑
item_promotion_id 🔑
shipment_id 🔑
shipment_item_id 🔑
currency
description
item_promotion_discount
promotion_rule_value
shipment_date
FEE_PREVIEW_REPORT ⇱
asin 🔑
fnsku 🔑
marketplace_id 🔑
sku 🔑
amazon_store
brand
currency
current_fee_category
estimated_fba_fulfillment_fee_per_unit
estimated_fee_total
estimated_future_referral_fee_per_unit
estimated_order_handling_fee_per_order
estimated_pick_pack_fee_per_unit
estimated_referral_fee_per_unit
estimated_variable_closing_fee
estimated_weight_handling_fee_per_unit
fulfilled_by
future_fee_category
future_fee_category_effective_date
item_package_weight
length_and_girth
longest_side
median_side
product_group
product_name
product_size_tier
sales_price
shortest_side
unit_of_dimension
unit_of_weight
your_price
LONG_TERM_STORAGE_FEE_CHARGES_REPORT ⇱
asin 🔑
fnsku 🔑
marketplace_id 🔑
sku 🔑
snapshot_date 🔑
condition
country
currency
enrolled_in_small_and_light
long_time_range_long_term_storage_fee
per_unit_volume
product_name
qty_charged_long_time_range_long_term_storage_fee
qty_charged_short_time_range_long_term_storage_fee
rate_surcharge
short_time_range_long_term_storage_fee
surcharge_age_tier
volume_unit
Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
Reports
SALES_AND_TRAFFIC_BUSINESS_REPORT_* ⇱
date 🔑
marketplace_id 🔑
sales_by_date_average_sales_per_order_item_amount
sales_by_date_average_sales_per_order_item_b2b_amount
sales_by_date_average_sales_per_order_item_b2b_currency_code
sales_by_date_average_sales_per_order_item_currency_code
sales_by_date_average_selling_price_amount
sales_by_date_average_selling_price_b2b_amount
sales_by_date_average_selling_price_b2b_currency_code
sales_by_date_average_selling_price_currency_code
sales_by_date_average_units_per_order_item
sales_by_date_average_units_per_order_item_b2b
sales_by_date_claims_amount_amount
sales_by_date_claims_amount_currency_code
sales_by_date_claims_granted
sales_by_date_ordered_product_sales_amount
sales_by_date_ordered_product_sales_b2b_amount
sales_by_date_ordered_product_sales_b2b_currency_code
sales_by_date_ordered_product_sales_currency_code
sales_by_date_orders_shipped
sales_by_date_refund_rate
sales_by_date_shipped_product_sales_amount
sales_by_date_shipped_product_sales_currency_code
sales_by_date_total_order_items
sales_by_date_total_order_items_b2b
sales_by_date_units_ordered
sales_by_date_units_ordered_b2b
sales_by_date_units_refunded
sales_by_date_units_shipped
traffic_by_date_average_offer_count
traffic_by_date_average_parent_items
traffic_by_date_browser_page_views
traffic_by_date_browser_page_views_b2b
traffic_by_date_browser_sessions
traffic_by_date_browser_sessions_b2b
traffic_by_date_buy_box_percentage
traffic_by_date_buy_box_percentage_b2b
traffic_by_date_feedback_received
traffic_by_date_mobile_app_page_views
traffic_by_date_mobile_app_page_views_b2b
traffic_by_date_mobile_app_sessions
traffic_by_date_mobile_app_sessions_b2b
traffic_by_date_negative_feedback_received
traffic_by_date_order_item_session_percentage
traffic_by_date_order_item_session_percentage_b2b
traffic_by_date_page_views
traffic_by_date_page_views_b2b
traffic_by_date_received_negative_feedback_rate
traffic_by_date_sessions
traffic_by_date_sessions_b2b
traffic_by_date_unit_session_percentage
traffic_by_date_unit_session_percentage_b2b
Seller Reports
SUBSCRIBE_AND_SAVE_FORECAST_REPORT ⇱
asin 🔑
marketplace_id 🔑
sku 🔑
week_1_start_date 🔑
active_subscriptions
country
estimated_avg_sns_discount_next_8_weeks
fnsku
offer_state
product_name
scheduled_sns_units_week_1
scheduled_sns_units_week_2
scheduled_sns_units_week_3
scheduled_sns_units_week_4
scheduled_sns_units_week_5
scheduled_sns_units_week_6
scheduled_sns_units_week_7
scheduled_sns_units_week_8
snapshot_date
SUBSCRIBE_AND_SAVE_PERFORMANCE_REPORT ⇱
asin 🔑
marketplace_id 🔑
sku 🔑
week_1_start_date 🔑
country
fnsku
offer_state
oos_rate_week_1
oos_rate_week_2
oos_rate_week_3
oos_rate_week_4
product_name
snapshot_date
sns_discount_week_1
sns_discount_week_2
sns_discount_week_3
sns_discount_week_4
sns_sale_price_week_1
sns_sale_price_week_2
sns_sale_price_week_3
sns_sale_price_week_4
sns_units_shipped_week_1
sns_units_shipped_week_2
sns_units_shipped_week_3
sns_units_shipped_week_4
SALES_AND_TRAFFIC_BUSINESS_PARENT_ASIN_REPORT_* ⇱
end_date 🔑
marketplace_id 🔑
parent_asin 🔑
start_date 🔑
sales_by_asin_ordered_product_sales_amount
sales_by_asin_ordered_product_sales_b2b_amount
sales_by_asin_ordered_product_sales_b2b_currency_code
sales_by_asin_ordered_product_sales_currency_code
sales_by_asin_total_order_items
sales_by_asin_total_order_items_b2b
sales_by_asin_units_ordered
sales_by_asin_units_ordered_b2b
traffic_by_asin_browser_page_views
traffic_by_asin_browser_page_views_b2b
traffic_by_asin_browser_page_views_percentage
traffic_by_asin_browser_page_views_percentage_b2b
traffic_by_asin_browser_session_percentage
traffic_by_asin_browser_session_percentage_b2b
traffic_by_asin_browser_sessions
traffic_by_asin_browser_sessions_b2b
traffic_by_asin_buy_box_percentage
traffic_by_asin_buy_box_percentage_b2b
traffic_by_asin_mobile_app_session_percentage
traffic_by_asin_mobile_app_session_percentage_b2b
traffic_by_asin_mobile_app_sessions
traffic_by_asin_mobile_app_sessions_b2b
traffic_by_asin_mobile_page_views
traffic_by_asin_mobile_page_views_b2b
traffic_by_asin_mobile_page_views_percentage
traffic_by_asin_mobile_page_views_percentage_b2b
traffic_by_asin_page_views
traffic_by_asin_page_views_b2b
traffic_by_asin_page_views_percentage
traffic_by_asin_page_views_percentage_b2b
traffic_by_asin_session_percentage
traffic_by_asin_session_percentage_b2b
traffic_by_asin_sessions
traffic_by_asin_sessions_b2b
traffic_by_asin_unit_session_percentage
traffic_by_asin_unit_session_percentage_b2b
SALES_AND_TRAFFIC_BUSINESS_CHILD_ASIN_REPORT_* ⇱
child_asin 🔑
end_date 🔑
marketplace_id 🔑
parent_asin 🔑
start_date 🔑
sales_by_asin_ordered_product_sales_amount
sales_by_asin_ordered_product_sales_b2b_amount
sales_by_asin_ordered_product_sales_b2b_currency_code
sales_by_asin_ordered_product_sales_currency_code
sales_by_asin_total_order_items
sales_by_asin_total_order_items_b2b
sales_by_asin_units_ordered
sales_by_asin_units_ordered_b2b
traffic_by_asin_browser_page_views
traffic_by_asin_browser_page_views_b2b
traffic_by_asin_browser_page_views_percentage
traffic_by_asin_browser_page_views_percentage_b2b
traffic_by_asin_browser_session_percentage
traffic_by_asin_browser_session_percentage_b2b
traffic_by_asin_browser_sessions
traffic_by_asin_browser_sessions_b2b
traffic_by_asin_buy_box_percentage
traffic_by_asin_buy_box_percentage_b2b
traffic_by_asin_mobile_app_session_percentage
traffic_by_asin_mobile_app_session_percentage_b2b
traffic_by_asin_mobile_app_sessions
traffic_by_asin_mobile_app_sessions_b2b
traffic_by_asin_mobile_page_views
traffic_by_asin_mobile_page_views_b2b
traffic_by_asin_mobile_page_views_percentage
traffic_by_asin_mobile_page_views_percentage_b2b
traffic_by_asin_page_views
traffic_by_asin_page_views_b2b
traffic_by_asin_page_views_percentage
traffic_by_asin_page_views_percentage_b2b
traffic_by_asin_session_percentage
traffic_by_asin_session_percentage_b2b
traffic_by_asin_sessions
traffic_by_asin_sessions_b2b
traffic_by_asin_unit_session_percentage
traffic_by_asin_unit_session_percentage_b2b
SALES_AND_TRAFFIC_BUSINESS_SKU_REPORT_* ⇱
child_asin 🔑
end_date 🔑
marketplace_id 🔑
parent_asin 🔑
sku 🔑
start_date 🔑
sales_by_asin_ordered_product_sales_amount
sales_by_asin_ordered_product_sales_b2b_amount
sales_by_asin_ordered_product_sales_b2b_currency_code
sales_by_asin_ordered_product_sales_currency_code
sales_by_asin_total_order_items
sales_by_asin_total_order_items_b2b
sales_by_asin_units_ordered
sales_by_asin_units_ordered_b2b
traffic_by_asin_browser_page_views
traffic_by_asin_browser_page_views_b2b
traffic_by_asin_browser_page_views_percentage
traffic_by_asin_browser_page_views_percentage_b2b
traffic_by_asin_browser_session_percentage
traffic_by_asin_browser_session_percentage_b2b
traffic_by_asin_browser_sessions
traffic_by_asin_browser_sessions_b2b
traffic_by_asin_buy_box_percentage
traffic_by_asin_buy_box_percentage_b2b
traffic_by_asin_mobile_app_session_percentage
traffic_by_asin_mobile_app_session_percentage_b2b
traffic_by_asin_mobile_app_sessions
traffic_by_asin_mobile_app_sessions_b2b
traffic_by_asin_mobile_page_views
traffic_by_asin_mobile_page_views_b2b
traffic_by_asin_mobile_page_views_percentage
traffic_by_asin_mobile_page_views_percentage_b2b
traffic_by_asin_page_views
traffic_by_asin_page_views_b2b
traffic_by_asin_page_views_percentage
traffic_by_asin_page_views_percentage_b2b
traffic_by_asin_session_percentage
traffic_by_asin_session_percentage_b2b
traffic_by_asin_sessions
traffic_by_asin_sessions_b2b
traffic_by_asin_unit_session_percentage
traffic_by_asin_unit_session_percentage_b2b