Amazon Selling Partner

Explore the interactive ERD

Table & Field Reference

item_buy_box_price_type

Column	Type	Keys
`condition`	String	PK
`marketplace_id`	String	PK
`asin`	String	PKFK
`landed_price_amount`	Double
`landed_price_currency_code`	String
`listing_price_amount`	Double
`listing_price_currency_code`	String
`offer_type`	String
`points_points_number`	Long
`pointspoints_monetary_value_amount`	Double
`pointspoints_monetary_value_currency_code`	String
`quantity_discount_type`	String
`quantity_tier`	Long
`seller_id`	String
`shipping_price_amount`	Double
`shipping_price_currency_code`	String

feed

Column	Type	Keys
`feed_id`	String	PK
`created_time`	Instant
`feed_type`	String
`processing_end_time`	Instant
`processing_start_time`	Instant
`processing_status`	String
`result_feed_document_id`	String

financial_debt_recovery_item

Column	Type	Keys
`index`	Int	PK
`debt_recovery_event_id`	String	PKFK
`group_begin_date`	Instant
`group_end_date`	Instant
`recovery_amount_currency_amount`	Double
`recovery_amount_currency_code`	String

financial_charge_component

Column	Type	Keys
`charge_kind`	String	PK
`charge_type`	String	PK
`index`	Int	PK
`linked_to`	String	PK
`linked_to_id`	String	PK
`currency_amount`	Double
`currency_code`	String

approval_support_data_element

Column	Type	Keys
`name`	String	PK
`amazon_order_id`	String	PKFK
`order_item_id`	String	PKFK
`value`	String

financial_coupon_payment_event

Column	Type	Keys
`_fivetran_id`	String	PK
`financial_event_group_id`	String	FK
`clip_or_redemption_count`	Long
`coupon_id`	String
`payment_event_id`	String
`posted_date`	Instant
`seller_coupon_description`	String
`total_amount_currency_amount`	Double
`total_amount_currency_code`	String

item_offer_detail

Column	Type	Keys
`index`	Long	PK
`marketplace_id`	String	PK
`sub_condition`	String	PK
`asin`	String	PKFK
`availability_type`	String
`available_date`	Instant
`condition_notes`	String
`country`	String
`feedback_count`	String
`is_buy_box_winner`	Boolean
`is_featured_merchant`	Boolean
`is_fulfilled_by_amazon`	Boolean
`is_national_prime`	Boolean
`is_prime`	Boolean
`listing_price_amount`	Double
`listing_price_currency_code`	String
`maximum_hours`	Long
`minimum_hours`	Long
`offer_type`	String
`points_monetary_value_amount`	Double
`points_monetary_value_currency_code`	String
`points_number`	Long
`seller_id`	String
`seller_positive_feedback_rating`	String
`shipping_amount`	Double
`shipping_currency_code`	String
`state`	String

content_meta_data_record

Column	Type	Keys
`content_reference_key`	String	PK
`marketplace_id`	String	PK
`name`	String
`status`	String
`update_time`	Instant

rapid_retail_analytics_traffic_report_hourly

Column	Type	Keys
`asin`	String	PK
`end_time`	Instant	PK
`marketplace_id`	String	PK
`start_time`	Instant	PK
`glance_views`	Long

financial_removal_shipment_event

Column	Type	Keys
`_fivetran_id`	String	PK
`financial_event_group_id`	String	FK
`merchant_order_id`	String
`order_id`	String
`posted_date`	Instant
`transaction_type`	String

vendor_direct_fulfillment_customer_invoice

Column	Type	Keys
`purchase_order_number`	String	PKFK
`content`	String

acknowledgement_status_details

Column	Type	Keys
`index`	Long	PK
`item_sequence_number`	String	PKFK
`purchase_order_number`	String	PKFK
`accepted_quantity_amount`	Long
`accepted_quantity_unit_of_measure`	String
`accepted_quantity_unit_size`	Long
`acknowledgement_date`	Instant
`rejected_quantity_amount`	Long
`rejected_quantity_unit_of_measure`	String
`rejected_quantity_unit_size`	Long

payment_method_detail_item

Column	Type	Keys
`method`	String	PK
`amazon_order_id`	String	PKFK

financial_removal_shipment_item_adjustment

Column	Type	Keys
`removal_shipment_item_id`	String	PK
`removal_shipment_adjustment_event_id`	String	PKFK
`adjusted_quantity`	Long
`fulfillment_network_sku`	String
`revenue_adjustment_currency_amount`	Double
`revenue_adjustment_currency_code`	String
`tax_amount_adjustment_currency_amount`	Double
`tax_amount_adjustment_currency_code`	String
`tax_collection_model`	String
`tax_withheld_adjustment_currency_amount`	Double
`tax_withheld_adjustment_currency_code`	String

fba_myi_all_inventory_data_report

Column	Type	Keys
`fnsku`	String	PK
`marketplace_id`	String	PK
`sku`	String	PK
`afn_fulfillable_quantity`	Long
`afn_future_supply_buyable`	Long
`afn_inbound_receiving_quantity`	Long
`afn_inbound_shipped_quantity`	Long
`afn_inbound_working_quantity`	Long
`afn_listing_exists`	String
`afn_researching_quantity`	Long
`afn_reserved_future_supply`	Long
`afn_reserved_quantity`	Long
`afn_total_quantity`	Long
`afn_unsellable_quantity`	Long
`afn_warehouse_quantity`	Long
`asin`	String
`condition`	String
`mfn_fulfillable_quantity`	Long
`mfn_listing_exists`	String
`per_unit_volume`	Double
`product_name`	String
`store`	String
`your_price`	Double

regulated_information_field

Column	Type	Keys
`id`	String	PK
`amazon_order_id`	String	PKFK
`field_label`	String
`field_type`	String
`field_value`	String

item_relationship

Column	Type	Keys
`type`	String	PK
`child_asin`	String	PKFK
`parent_asin`	String	PKFK

easyship_package_item

Column	Type	Keys
`order_item_id`	String	PKFK
`package_id`	String	PKFK

financial_affordability_expense_event

Column	Type	Keys
`_fivetran_id`	String	PK
`financial_event_group_id`	String	FK
`amazon_order_id`	String
`base_expense_currency_amount`	Double
`base_expense_currency_code`	String
`event_type`	String
`marketplace_id`	String
`posted_date`	Instant
`tax_type_cgst_currency_amount`	Double
`tax_type_cgst_currency_code`	String
`tax_type_igst_currency_amount`	Double
`tax_type_igst_currency_code`	String
`tax_type_sgst_currency_amount`	Double
`tax_type_sgst_currency_code`	String
`total_expense_currency_amount`	Double
`total_expense_currency_code`	String
`transaction_type`	String

vendor_sales_report_asin

Column	Type	Keys
`asin`	String	PK
`end_date`	LocalDate	PK
`marketplace_id`	String	PK
`start_date`	LocalDate	PK
`customer_returns`	Long
`ordered_revenue_amount`	Double
`ordered_revenue_currency_code`	String
`ordered_units`	Long
`shipped_cogs_amount`	Double
`shipped_cogs_currency_code`	String
`shipped_revenue_amount`	Double
`shipped_revenue_currency_code`	String
`shipped_units`	Long

financial_adjustment_item

Column	Type	Keys
`index`	Int	PK
`adjustment_event_id`	String	PKFK
`asin`	String
`fn_sku`	String
`per_unit_amount_currency_amount`	Double
`per_unit_amount_currency_code`	String
`product_description`	String
`quantity`	String
`seller_sku`	String
`total_amount_currency_amount`	Double
`total_amount_currency_code`	String

inner_container_sequence_number

Column	Type	Keys
`container_sequence_number`	String	PKFK
`container_type`	String	PKFK
`transaction_date`	LocalDateTime	PKFK
`vendor_shipment_identifier`	String	PKFK

brand_analytics_search_catalog_performance_report_weekly

Column	Type	Keys
`asin`	String	PK
`end_date`	LocalDate	PK
`marketplace_id`	String	PK
`start_date`	LocalDate	PK
`cart_add_count`	Long
`cart_added_median_price_amount`	Double
`cart_added_median_price_currency_code`	String
`click_count`	Long
`click_rate`	Double
`clicked_median_price_amount`	Double
`clicked_median_price_currency_code`	String
`conversion_rate`	Double
`impression_count`	Long
`impression_median_price_amount`	Double
`impression_median_price_currency_code`	String
`one_day_shipping_cart_add_count`	Long
`one_day_shipping_click_count`	Long
`one_day_shipping_impression_count`	Long
`one_day_shipping_purchase_count`	Long
`purchase_count`	Long
`purchase_median_price_amount`	Double
`purchase_median_price_currency_code`	String
`same_day_shipping_cart_add_count`	Long
`same_day_shipping_click_count`	Long
`same_day_shipping_impression_count`	Long
`same_day_shipping_purchase_count`	Long
`search_traffic_sales_amount`	Double
`search_traffic_sales_currency_code`	String
`two_day_shipping_cart_add_count`	Long
`two_day_shipping_click_count`	Long
`two_day_shipping_impression_count`	Long
`two_day_shipping_purchase_count`	Long

shipment_status_detail

Column	Type	Keys
`index`	Int	PK
`transaction_date`	LocalDateTime	PKFK
`vendor_shipment_identifier`	String	PKFK
`shipment_status`	String
`shipment_status_date`	LocalDateTime

vendor_direct_fulfillment_order_item

Column	Type	Keys
`item_sequence_number`	String	PK
`customer_order_number`	String	PKFK
`purchase_order_number`	String	PKFK
`amount`	Long
`buyer_product_identifier`	String
`customized_url`	String
`earliest_nominated_delivery_date`	Instant
`gift_message`	String
`gift_wrap_id`	String
`latest_nominated_delivery_date`	Instant
`net_price_amount`	Double
`net_price_currency_code`	String
`scheduled_delivery_service_type`	String
`title`	String
`total_price_amount`	Double
`total_price_currency_code`	String
`unit_of_measure`	String
`unit_size`	Long
`vendor_product_identifier`	String

fba_inventory_researching_quantity_entry

Column	Type	Keys
`name`	String	PK
`inventory_summary_id`	String	PKFK
`granularity_id`	String
`granularity_type`	String
`quantity`	Int

fulfillment_order_feature_settings

Column	Type	Keys
`feature_name`	String	PK
`seller_fulfillment_order_id`	String	PKFK
`feature_fulfillment_policy`	String

competitive_price_type

Column	Type	Keys
`id`	String	PK
`marketplace_id`	String	PK
`asin`	String	PKFK
`belongs_to_requester`	Boolean
`condition`	String
`landed_amount`	Double
`landed_currency_code`	String
`listing_amount`	Double
`listing_currency_code`	String
`offer_type`	String
`points_monetary_value_amount`	Double
`points_monetary_value_currency_code`	String
`points_number`	Long
`quantity_discount_type`	String
`quantity_tier`	Long
`seller_id`	String
`shipping_amount`	Double
`shipping_currency_code`	String
`subcondition`	String

inventory_feature

Column	Type	Keys
`seller_sku`	String	PK
`feature_name`	String	PKFK
`asin`	String
`fn_sku`	String
`overlapping_skus`	Json
`sku_count`	Long

sales_and_traffic_business_report

Column	Type	Keys
`date`	LocalDate	PK
`marketplace_id`	String	PK
`sales_by_date_`
`traffic_by_date_`

item_dimension

Column	Type	Keys
`asin`	String	PKFK
`marketplace_id`	String	PKFK
`item_`
`package_`

financial_removal_shipment_adjustment_event

Column	Type	Keys
`_fivetran_id`	String	PK
`adjustment_event_id`	String	PK
`financial_event_group_id`	String	FK
`merchant_order_id`	String
`order_id`	String
`posted_date`	Instant
`transaction_type`	String

easyship_package

Column	Type	Keys
`package_id`	String	PK
`amazon_order_id`	String	PKFK
`invoice_invoice_date`	Instant
`invoice_invoice_number`	String
`package_identifier`	String
`package_status`	String
`tracking_id`	String
`package_`
`time_slot_`

item_offer_summary

Column	Type	Keys
`condition`	String	PK
`marketplace_id`	String	PK
`asin`	String	PKFK
`competitive_price_threshold_amount`	Double
`competitive_price_threshold_currency_code`	String
`list_price_amount`	Double
`list_price_currency_code`	String
`offers_available_time`	Instant
`suggested_lower_price_plus_shipping_amount`	Double
`suggested_lower_price_plus_shipping_currency_code`	String
`total_offer_count`	Long

vendor_inventory_report_asin

Column	Type	Keys
`asin`	String	PK
`end_date`	LocalDate	PK
`marketplace_id`	String	PK
`start_date`	LocalDate	PK
`aged_90_plus_days_sellable_inventory_cost_amount`	Double
`aged_90_plus_days_sellable_inventory_cost_currency_code`	String
`aged_90_plus_days_sellable_inventory_units`	Long
`average_vendor_lead_time_days`	Double
`net_received_inventory_cost_amount`	Double
`net_received_inventory_cost_currency_code`	String
`net_received_inventory_units`	Long
`open_purchase_order_units`	Long
`procurable_product_out_of_stock_rate`	Double
`receive_fill_rate`	Double
`sell_through_rate`	Double
`sellable_on_hand_inventory_cost_amount`	Double
`sellable_on_hand_inventory_cost_currency_code`	String
`sellable_on_hand_inventory_units`	Long
`uft`	Double
`unfilled_customer_ordered_units`	Long
`unhealthy_inventory_cost_amount`	Double
`unhealthy_inventory_cost_currency_code`	String
`unhealthy_inventory_units`	Long
`unsellable_on_hand_inventory_cost_amount`	Double
`unsellable_on_hand_inventory_cost_currency_code`	String
`unsellable_on_hand_inventory_units`	Long
`vendor_confirmation_rate`	Double

cod_payment_execution_detail

Column	Type	Keys
`index`	Long	PK
`amazon_order_id`	String	PKFK
`payment_amount`	String
`payment_currency_code`	String
`payment_method`	String

sales_and_traffic_business_child_asin_report

Column	Type	Keys
`child_asin`	String	PK
`end_date`	LocalDate	PK
`marketplace_id`	String	PK
`parent_asin`	String	PK
`start_date`	LocalDate	PK
`sales_by_asin_`
`traffic_by_asin_`

catalog

Column	Type	Keys
`asin`	String	PK
`marketplace_id`	String

financial_tax_withholding_event

Column	Type	Keys
`_fivetran_id`	String	PK
`financial_event_group_id`	String	FK
`base_amount_currency_amount`	Double
`base_amount_currency_code`	String
`posted_date`	Instant
`tax_with_holding_period_end_date`	Instant
`tax_with_holding_period_start_date`	Instant
`with_held_amount_currency_amount`	Double
`with_held_amount_currency_code`	String

orders_report

Column	Type	Keys
`amazon_order_id`	String	PK
`asin`	String	PK
`marketplace_id`	String	PK
`sku`	String	PK
`actual_ship_from_address_city`	String
`actual_ship_from_address_country`	String
`actual_ship_from_address_field_1`	String
`actual_ship_from_address_field_2`	String
`actual_ship_from_address_field_3`	String
`actual_ship_from_address_name`	String
`actual_ship_from_address_postal_code`	String
`actual_ship_from_address_state`	String
`currency`	String
`default_ship_from_address_city`	String
`default_ship_from_address_country`	String
`default_ship_from_address_field_1`	String
`default_ship_from_address_field_2`	String
`default_ship_from_address_field_3`	String
`default_ship_from_address_name`	String
`default_ship_from_address_postal_code`	String
`default_ship_from_address_state`	String
`fulfillment_channel`	String
`gift_wrap_price`	Double
`gift_wrap_tax`	Double
`ioss_number`	String
`item_price`	Double
`item_promotion_discount`	Double
`item_status`	String
`item_tax`	Double
`last_updated_date`	Instant
`license_expiration_date`	LocalDate
`license_number`	String
`license_state`	String
`licensee_name`	String
`merchant_order_id`	String
`order_channel`	String
`order_status`	String
`product_name`	String
`promotion_ids`	String
`purchase_date`	Instant
`quantity`	Int
`sales_channel`	String
`ship_city`	String
`ship_country`	String
`ship_postal_code`	String
`ship_promotion_discount`	Double
`ship_service_level`	String
`ship_state`	String
`shipping_price`	Double
`shipping_tax`	Double
`tax_collection_model`	String

sales_and_traffic_business_sku_report

Column	Type	Keys
`child_asin`	String	PK
`end_date`	LocalDate	PK
`marketplace_id`	String	PK
`parent_asin`	String	PK
`sku`	String	PK
`start_date`	LocalDate	PK
`sales_by_asin_`
`traffic_by_asin_`

financial_safet_reimbursement_event

Column	Type	Keys
`_fivetran_id`	String	PK
`financial_event_group_id`	String	FK
`posted_date`	Instant
`reason_code`	String
`reimbursed_amount_currency_amount`	Double
`reimbursed_amount_currency_code`	String
`safetclaim_id`	String

item_display_group_sales_rank

Column	Type	Keys
`website_display_group`	String	PK
`asin`	String	PKFK
`link`	String
`rank`	String
`title`	String

financial_service_fee_event

Column	Type	Keys
`_fivetran_id`	String	PK
`financial_event_group_id`	String	PKFK
`amazon_order_id`	String
`asin`	String
`fee_description`	String
`fee_reason`	String
`fn_sku`	String
`seller_sku`	String

item_product_type

Column	Type	Keys
`product_type`	String	PK
`asin`	String	PKFK
`marketplace_id`	String	PKFK

return_reason_code

Column	Type	Keys
`return_reason_code`	String	PK
`description`	String
`translated_description`	String

financial_adhoc_disbursement_event

Column	Type	Keys
`_fivetran_id`	String	PK
`financial_event_group_id`	String	FK
`posted_date`	Instant
`transaction_amount_currency_amount`	Double
`transaction_amount_currency_code`	String
`transaction_id`	String
`transaction_type`	String

cpt_trade_in_value

Column	Type	Keys
`marketplace_id`	String	PK
`asin`	String	PKFK
`amount`	Double
`currency_code`	String

financial_product_ads_payment_event

Column	Type	Keys
`_fivetran_id`	String	PK
`financial_event_group_id`	String	FK
`base_value_currency_amount`	Double
`base_value_currency_code`	String
`invoice_id`	String
`posted_date`	Instant
`tax_value_currency_amount`	Double
`tax_value_currency_code`	String
`transaction_type`	String
`transaction_value_currency_amount`	Double
`transaction_value_currency_code`	String

order_item

Column	Type	Keys
`order_item_id`	String	PK
`amazon_order_id`	String	PKFK
`asin`	String
`buyer_requested_cancel_buyer_cancel_reason`	String
`buyer_requested_cancel_is_buyer_requested_cancel`	Boolean
`condition_id`	String
`condition_note`	String
`condition_subtype_id`	String
`deemed_reseller_category`	String
`ioss_number`	String
`is_gift`	Boolean
`is_transparency`	Boolean
`item_approval_context_approval_status`	String
`item_approval_context_approval_type`	String
`item_price_amount`	String
`item_price_currency_code`	String
`item_tax_amount`	String
`item_tax_currency_code`	String
`points_granted_monetary_amount`	String
`points_granted_monetary_currency_code`	String
`points_granted_points_number`	Long
`price_designation`	String
`product_info_detail_number_of_items`	Long
`promotion_discount_amount`	String
`promotion_discount_currency_code`	String
`promotion_discount_tax_amount`	String
`promotion_discount_tax_currency_code`	String
`quantity_ordered`	Long
`quantity_shipped`	Long
`scheduled_delivery_end_date`	String
`scheduled_delivery_start_date`	String
`seller_sku`	String
`serial_number_required`	Boolean
`shipping_discount_amount`	String
`shipping_discount_currency_code`	String
`shipping_discount_tax_amount`	String
`shipping_discount_tax_currency_code`	String
`shipping_price_amount`	String
`shipping_price_currency_code`	String
`shipping_tax_amount`	String
`shipping_tax_currency_code`	String
`store_chain_store_id`	String
`tax_collection_model`	String
`tax_collection_responsible_party`	String
`title`	String

fba_inventory_summary

Column	Type	Keys
`_fivetran_id`	String	PK
`asin`	String	FK
`carrier_damaged_quantity`	Long
`condition`	String
`customer_damaged_quantity`	Long
`defective_quantity`	Long
`distributor_damaged_quantity`	Long
`expired_quantity`	Long
`fc_processing_quantity`	Long
`fn_sku`	String
`fulfillable_quantity`	Long
`granularity_id`	String
`granularity_type`	String
`inbound_receiving_quantity`	Long
`inbound_shipped_quantity`	Long
`inbound_working_quantity`	Long
`last_updated_time`	Instant
`pending_customer_order_quantity`	Long
`pending_transshipment_quantity`	Long
`product_name`	String
`seller_sku`	String
`total_quantity`	Long
`total_reserved_quantity`	Long
`total_unfulfillable_quantity`	Long
`warehouse_damaged_quantity`	Long

container_identification

Column	Type	Keys
`container_identification_number`	String	PK
`container_identification_type`	String	PK
`container_sequence_number`	String	PKFK
`container_type`	String	PKFK
`transaction_date`	LocalDateTime	PKFK
`vendor_shipment_identifier`	String	PKFK

ledger_summary_view_fc_report_daily

Column	Type	Keys
`date`	String	PK
`disposition`	String	PK
`fnsku`	String	PK
`location`	String	PK
`marketplace_id`	String	PK
`msku`	String	PK
`asin`	String
`customer_returns`	Int
`customer_shipments`	Int
`damaged`	Int
`disposed`	Int
`ending_warehouse_balance`	Int
`found`	Int
`in_transit_between_warehouses`	Int
`lost`	Int
`other_events`	Int
`receipts`	Int
`starting_warehouse_balance`	Int
`title`	String
`unknown_events`	Int
`vendor_returns`	Int
`warehouse_transfer_in_out`	Int

listed_item_summary

Column	Type	Keys
`asin`	String	PK
`marketplace_id`	String	PK
`sku`	String	PKFK
`condition_type`	String
`created_date`	Instant
`fn_sku`	String
`height`	Int
`item_name`	String
`last_updated_date`	Instant
`link`	String
`product_type`	String
`status`	Json
`width`	Int

orders

Column	Type	Keys
`amazon_order_id`	String	PK
`automated_shipping_setting_automated_carrier`	String
`automated_shipping_setting_automated_ship_method`	String
`automated_shipping_setting_has_automated_shipping_settings`	Boolean
`buyer_invoice_preference`	String
`cba_displayable_shipping_label`	String
`earliest_delivery_date`	Instant
`earliest_ship_date`	Instant
`easy_ship_shipment_status`	String
`electronic_invoice_status`	String
`fulfillment_channel`	String
`fulfillment_supply_source_id`	String
`has_regulated_items`	Boolean
`is_access_point_order`	Boolean
`is_business_order`	Boolean
`is_estimated_ship_date_set`	Boolean
`is_global_express_enabled`	Boolean
`is_iba`	Boolean
`is_ispu`	Boolean
`is_premium_order`	Boolean
`is_prime`	Boolean
`is_replacement_order`	Boolean
`is_sold_by_ab`	Boolean
`last_update_date`	Instant
`latest_delivery_date`	Instant
`latest_ship_date`	Instant
`marketplace_id`	String
`number_of_items_shipped`	Long
`number_of_items_unshipped`	Long
`order_channel`	String
`order_status`	String
`order_total_amount`	String
`order_total_currency_code`	String
`order_type`	String
`payment_method`	String
`promise_response_due_date`	String
`purchase_date`	Instant
`replaced_order_id`	String
`sales_channel`	String
`seller_display_name`	String
`seller_order_id`	String
`ship_service_level`	String
`shipment_service_level_category`	String
`buyer_info_`
`buyer_tax_info`
`default_ship_from_location_`
`shipping_address_`

network_commingling_transaction_event

Column	Type	Keys
`_fivetran_id`	String	PK
`financial_event_group_id`	String	FK
`asin`	String
`marketplace_id`	String
`net_co_transaction_id`	String
`posted_date`	Instant
`swap_reason`	String
`tax_amount_currency_amount`	Double
`tax_amount_currency_code`	String
`tax_exclusive_amount_currency_amount`	Double
`tax_exclusive_amount_currency_code`	String
`transaction_type`	String

financial_capacity_reservation_billing_event

Column	Type	Keys
`_fivetran_id`	String	PK
`financial_event_group_id`	String	FK
`description`	String
`posted_date`	Instant
`transaction_amount_currency_amount`	Double
`transaction_amount_currency_code`	String
`transaction_type`	String

financial_solution_provider_credit_event

Column	Type	Keys
`_fivetran_id`	String	PK
`financial_event_group_id`	String	FK
`marketplace_country_code`	String
`marketplace_id`	String
`provider_id`	String
`provider_store_name`	String
`provider_transaction_type`	String
`seller_id`	String
`seller_order_id`	String
`seller_store_name`	String
`transaction_amount_currency_amount`	Double
`transaction_amount_currency_code`	String
`transaction_creation_date`	Instant

financial_pay_with_amazon_event

Column	Type	Keys
`_fivetran_id`	String	PK
`financial_event_group_id`	String	FK
`amount_description`	String
`business_object_type`	String
`fulfillment_channel`	String
`payment_amount_type`	String
`sales_channel`	String
`seller_order_id`	String
`store_name`	String
`transaction_posted_date`	Instant

item_classification_sales_rank

Column	Type	Keys
`classification_id`	String	PK
`asin`	String	PKFK
`link`	String
`rank`	String
`title`	String

financial_charge_instrument

Column	Type	Keys
`index`	Int	PK
`debt_recovery_event_id`	String	PKFK
`amount_currency_amount`	Double
`amount_currency_code`	String
`description`	String
`tail`	String

repeat_purchase_report

Column	Type	Keys
`asin`	String	PK
`end_date`	String	PK
`marketplace_id`	String	PK
`start_date`	String	PK
`orders`	Long
`repeat_customers_pct_total`	Double
`repeat_purchase_revenue_amount`	Double
`repeat_purchase_revenue_currency_code`	String
`repeat_purchase_revenue_pct_total`	Double
`unique_customers`	Long

content_badge_set

Column	Type	Keys
`content_badge`	String	PK
`content_reference_key`	String	PKFK

financial_trial_shipment_event

Column	Type	Keys
`_fivetran_id`	String	PK
`financial_event_group_id`	String	FK
`amazon_order_id`	String
`posted_date`	Instant
`sku`	String

net_pure_product_margin_report

Column	Type	Keys
`asin`	String	PK
`end_date`	LocalDate	PK
`marketplace_id`	String	PK
`start_date`	LocalDate	PK
`net_pure_product_margin`	Double

vendor_sales_report

Column	Type	Keys
`end_date`	LocalDate	PK
`marketplace_id`	String	PK
`start_date`	LocalDate	PK
`customer_returns`	Long
`ordered_revenue_amount`	Double
`ordered_revenue_currency_code`	String
`ordered_units`	Long
`shipped_cogs_amount`	Double
`shipped_cogs_currency_code`	String
`shipped_revenue_amount`	Double
`shipped_revenue_currency_code`	String
`shipped_units`	Long

rapid_retail_analytics_sales_report_hourly

Column	Type	Keys
`asin`	String	PK
`end_time`	Instant	PK
`marketplace_id`	String	PK
`start_time`	Instant	PK
`ordered_revenue`	Double
`ordered_units`	Long

order_item_promotion_id

Column	Type	Keys
`promotion_id`	String	PK
`amazon_order_id`	String	PKFK
`order_item_id`	String	PKFK

item_offer_lowest_price_type

Column	Type	Keys
`condition`	String	PK
`marketplace_id`	String	PK
`asin`	String	PKFK
`fulfillment_channel`	String
`landed_price_amount`	Double
`landed_price_currency_code`	String
`listing_price_amount`	Double
`listing_price_currency_code`	String
`offer_type`	String
`points_points_number`	Long
`pointspoints_monetary_value_amount`	Double
`pointspoints_monetary_value_currency_code`	String
`quantity_discount_type`	String
`quantity_tier`	Long
`shipping_amount`	Double
`shipping_currency_code`	String

listed_item_issue

Column	Type	Keys
`code`	String	PK
`sku`	String	PKFK
`attribute_names`	Json
`message`	String
`severity`	String

rapid_retail_analytics_inventory_report_hourly

Column	Type	Keys
`asin`	String	PK
`end_time`	Instant	PK
`marketplace_id`	String	PK
`start_time`	Instant	PK
`highly_available_inventory`	Long

vendor_retail_procurement_order_status

Column	Type	Keys
`purchase_order_number`	String	PK
`last_updated_date`	Instant
`purchase_order_date`	Instant
`purchase_order_status`	String

all_listings_report

Column	Type	Keys
`marketplace_id`	String	PK
`seller_sku`	String	PK
`add_delete`	String
`asin_1`	String
`asin_2`	String
`asin_3`	String
`bid_for_featured_placement`	String
`expedited_shipping`	String
`fulfillment_channel`	String
`image_url`	String
`item_condition`	Int
`item_description`	String
`item_is_marketplace`	String
`item_name`	String
`item_note`	String
`listing_id`	String
`merchant_shipping_group`	String
`open_date`	String
`pending_quantity`	Int
`price`	Double
`product_id`	String
`product_id_type`	Int
`quantity`	Int
`status`	String
`will_ship_internationally`	Int
`zshop_boldface`	String
`zshop_browse_path`	String
`zshop_category_1`	String
`zshop_shipping_fee`	Double
`zshop_storefront_feature`	String

item_quantity_discount_price_type

Column	Type	Keys
`condition`	String	PK
`marketplace_id`	String	PK
`asin`	String	PKFK
`listing_price_amount`	Double
`listing_price_currency_code`	String
`quantity_discount_type`	String
`quantity_tier`	Long

financial_removal_shipment_item

Column	Type	Keys
`removal_shipment_item_id`	String	PK
`removal_shipment_event_id`	String	PKFK
`fee_amount_currency_amount`	Double
`fee_amount_currency_code`	String
`fulfillment_network_sku`	String
`quantity`	Long
`revenue_currency_amount`	Double
`revenue_currency_code`	String
`tax_amount_currency_amount`	Double
`tax_amount_currency_code`	String
`tax_collection_model`	String
`tax_with_held_currency_amount`	Double
`tax_with_held_currency_code`	String

reimbursements_report

Column	Type	Keys
`amazon_order_id`	String	PK
`asin`	String	PK
`marketplace_id`	String	PK
`reimbursement_id`	String	PK
`sku`	String	PK
`amount_per_unit`	Double
`amount_total`	Double
`approval_date`	Instant
`case_id`	String
`condition`	String
`currency_unit`	String
`fnsku`	String
`original_reimbursement_id`	String
`original_reimbursement_type`	String
`product_name`	String
`quantity_reimbursed_cash`	Int
`quantity_reimbursed_inventory`	Int
`quantity_reimbursed_total`	Int
`reason`	String

financial_shipment_direct_payment

Column	Type	Keys
`index`	Int	PK
`shipment_event_id`	String	PKFK
`currency_amount`	Double
`currency_code`	String
`payment_type`	String
`shipment_event_type`	String

item_offer_count_type

Column	Type	Keys
`condition`	String	PK
`marketplace_id`	String	PK
`type`	String	PK
`asin`	String	PKFK
`fullfillment_channel`	String
`offer_count`	Long

financial_shipment_event_item

Column	Type	Keys
`_fivetran_id`	String	PK
`financial_shipment_event_id`	String	FK
`cost_of_points_granted_currency_amount`	Double
`cost_of_points_granted_currency_code`	String
`cost_of_points_returned_currency_amount`	Double
`cost_of_points_returned_currency_code`	String
`index`	Int
`item_kind`	String
`order_adjustment_item_id`	String
`order_item_id`	String
`quantity_shipped`	Long
`seller_sku`	String

vendor_traffic_report

Column	Type	Keys
`asin`	String	PK
`end_date`	LocalDate	PK
`marketplace_id`	String	PK
`start_date`	LocalDate	PK
`glance_views`	Long

financial_seller_review_enrollment_payment_event

Column	Type	Keys
`_fivetran_id`	String	PK
`financial_event_group_id`	String	FK
`enrollment_id`	String
`parent_asin`	String
`posted_date`	Instant
`total_amount_currency_amount`	Double
`total_amount_currency_code`	String

ordered_quantity_details

Column	Type	Keys
`index`	Long	PK
`item_sequence_number`	String	PKFK
`purchase_order_number`	String	PKFK
`cancelled_amount`	Long
`cancelled_unit_of_measure`	String
`cancelled_unit_size`	Long
`ordered_amount`	Long
`ordered_unit_of_measure`	String
`ordered_unit_size`	Long
`updated_date`	Instant

long_term_storage_fee_charges_report

Column	Type	Keys
`asin`	String	PK
`fnsku`	String	PK
`marketplace_id`	String	PK
`sku`	String	PK
`snapshot_date`	Instant	PK
`amount_charged`	Double
`condition`	String
`country`	String
`currency`	String
`enrolled_in_small_and_light`	String
`long_time_range_long_term_storage_fee`	Double
`per_unit_volume`	Double
`product_name`	String
`qty_charged`	Int
`qty_charged_long_time_range_long_term_storage_fee`	Int
`qty_charged_short_time_range_long_term_storage_fee`	Int
`rate_surcharge`	Double
`short_time_range_long_term_storage_fee`	Double
`surcharge_age_tier`	String
`volume_unit`	String

fee_preview_report

Column	Type	Keys
`asin`	String	PK
`fnsku`	String	PK
`marketplace_id`	String	PK
`sku`	String	PK
`amazon_store`	String
`brand`	String
`currency`	String
`current_fee_category`	String
`estimated_fba_fulfillment_fee_per_unit`	Double
`estimated_fee_total`	Double
`estimated_future_referral_fee_per_unit`	Double
`estimated_order_handling_fee_per_order`	Double
`estimated_pick_pack_fee_per_unit`	Double
`estimated_referral_fee_per_unit`	Double
`estimated_variable_closing_fee`	Double
`estimated_weight_handling_fee_per_unit`	Double
`fulfilled_by`	String
`future_fee_category`	String
`future_fee_category_effective_date`	String
`item_package_weight`	Double
`length_and_girth`	Double
`longest_side`	Double
`median_side`	Double
`product_group`	String
`product_name`	String
`product_size_tier`	String
`sales_price`	Double
`shortest_side`	Double
`unit_of_dimension`	String
`unit_of_weight`	String
`your_price`	Double

financial_fee_component

Column	Type	Keys
`fee_kind`	String	PK
`fee_type`	String	PK
`index`	Int	PK
`linked_to`	String	PK
`linked_to_id`	String	PK
`currency_amount`	Double
`currency_code`	String

financial_value_added_service_charge_event

Column	Type	Keys
`_fivetran_id`	String	PK
`financial_event_group_id`	String	FK
`description`	String
`posted_date`	Instant
`transaction_amount_currency_amount`	Double
`transaction_amount_currency_code`	String
`transaction_type`	String

package_tracking_detail

Column	Type	Keys
`package_number`	Long	PK
`additional_location_info`	String
`carrier_code`	String
`carrier_phone_number`	String
`carrier_url`	String
`current_status`	String
`current_status_description`	String
`customer_tracking_link`	String
`estimated_arrival_date`	Instant
`ship_date`	Instant
`ship_to_city`	String
`ship_to_country`	String
`ship_to_state`	String
`signed_for_by`	String
`tracking_number`	String

vendor_retail_procurement_shipment

Column	Type	Keys
`transaction_date`	LocalDateTime	PK
`vendor_shipment_identifier`	String	PK
`bill_of_lading_number`	String
`buyer_reference_number`	String
`carrier_assignment_date`	LocalDateTime
`carrier_details_code`	String
`carrier_details_email`	String
`carrier_details_name`	String
`carrier_details_phone`	String
`carrier_details_shipment_reference_number`	String
`current_shipment_status`	String
`currentshipment_status_date`	String
`estimated_delivery_date`	LocalDateTime
`package_label_create_date`	LocalDateTime
`requested_pick_up`	LocalDateTime
`scheduled_pick_up`	LocalDateTime
`selling_party_address_line_1`	String
`selling_party_address_line_2`	String
`selling_party_address_line_3`	String
`selling_party_attention`	String
`selling_party_city`	String
`selling_party_country_code`	String
`selling_party_county`	String
`selling_party_district`	String
`selling_party_name`	String
`selling_party_party_id`	String
`selling_party_phone`	String
`selling_party_postal_code`	String
`selling_party_state_or_region`	String
`ship_from_party_address_line_1`	String
`ship_from_party_address_line_2`	String
`ship_from_party_address_line_3`	String
`ship_from_party_attention`	String
`ship_from_party_city`	String
`ship_from_party_country_code`	String
`ship_from_party_county`	String
`ship_from_party_district`	String
`ship_from_party_name`	String
`ship_from_party_party_id`	String
`ship_from_party_phone`	String
`ship_from_party_postal_code`	String
`ship_from_party_state_or_region`	String
`ship_mode`	String
`ship_to_party_address_line_1`	String
`ship_to_party_address_line_2`	String
`ship_to_party_address_line_3`	String
`ship_to_party_attention`	String
`ship_to_party_city`	String
`ship_to_party_country_code`	String
`ship_to_party_county`	String
`ship_to_party_district`	String
`ship_to_party_name`	String
`ship_to_party_party_id`	String
`ship_to_party_phone`	String
`ship_to_party_postal_code`	String
`ship_to_party_state_or_region`	String
`shipment_confirm_date`	LocalDateTime
`shipment_create_date`	LocalDateTime
`shipment_delivery_date`	LocalDateTime
`shipment_freight_term`	String
`shipped_date`	LocalDateTime
`transaction_type`	String
`transportation_mode`	String
`import_details_`
`shipment_measurements_`

vendor_retail_procurement_order

Column	Type	Keys
`purchase_order_date`	Instant	PK
`purchase_order_number`	String	PK
`bill_to_party_address_line_1`	String
`bill_to_party_address_line_2`	String
`bill_to_party_address_line_3`	String
`bill_to_party_address_type`	String
`bill_to_party_city`	String
`bill_to_party_country`	String
`bill_to_party_country_code`	String
`bill_to_party_district`	String
`bill_to_party_district_or_county`	String
`bill_to_party_municipality`	String
`bill_to_party_name`	String
`bill_to_party_party_id`	String
`bill_to_party_phone`	String
`bill_to_party_postal_code`	String
`bill_to_party_state_or_region`	String
`bill_to_party_tax_registration_number`	String
`bill_to_party_tax_registration_type`	String
`billable_weight_unit_of_measure`	String
`billable_weight_value`	Double
`buying_party_address_line_1`	String
`buying_party_address_line_2`	String
`buying_party_address_line_3`	String
`buying_party_address_type`	String
`buying_party_city`	String
`buying_party_country`	String
`buying_party_country_code`	String
`buying_party_district`	String
`buying_party_district_or_county`	String
`buying_party_municipality`	String
`buying_party_name`	String
`buying_party_party_id`	String
`buying_party_phone`	String
`buying_party_postal_code`	String
`buying_party_state_or_region`	String
`buying_party_tax_registration_number`	String
`buying_party_tax_registration_type`	String
`deal_code`	String
`delivery_window`	String
`estimated_ship_by_date`	LocalDateTime
`handling_instructions`	String
`import_containers`	String
`international_commercial_terms`	String
`method_of_payment`	String
`payment_method`	String
`port_of_delivery`	String
`purchase_order_changed_date`	Instant
`purchase_order_state`	String
`purchase_order_state_changed_date`	Instant
`purchase_order_type`	String
`seal_number`	String
`selling_party_address_line_1`	String
`selling_party_address_line_2`	String
`selling_party_address_line_3`	String
`selling_party_address_type`	String
`selling_party_city`	String
`selling_party_country`	String
`selling_party_country_code`	String
`selling_party_district`	String
`selling_party_district_or_county`	String
`selling_party_municipality`	String
`selling_party_name`	String
`selling_party_party_id`	String
`selling_party_phone`	String
`selling_party_postal_code`	String
`selling_party_state_or_region`	String
`selling_party_tax_registration_number`	String
`selling_party_tax_registration_type`	String
`ship_to_party_address_line_1`	String
`ship_to_party_address_line_2`	String
`ship_to_party_address_line_3`	String
`ship_to_party_address_type`	String
`ship_to_party_city`	String
`ship_to_party_country`	String
`ship_to_party_country_code`	String
`ship_to_party_district`	String
`ship_to_party_district_or_county`	String
`ship_to_party_municipality`	String
`ship_to_party_name`	String
`ship_to_party_party_id`	String
`ship_to_party_phone`	String
`ship_to_party_postal_code`	String
`ship_to_party_state_or_region`	String
`ship_to_party_tax_registration_number`	String
`ship_to_party_tax_registration_type`	String
`ship_window`	String
`shipping_instructions`	String

search_terms_report

Column	Type	Keys
`clicked_asin`	String	PK
`department_name`	String	PK
`end_date`	LocalDate	PK
`marketplace_id`	String	PK
`search_frequency_rank`	Int	PK
`search_term`	String	PK
`start_date`	LocalDate	PK
`click_share`	Double
`click_share_rank`	Int
`conversion_share`	Double

vendor_direct_fulfillment_order

Column	Type	Keys
`customer_order_number`	String	PK
`purchase_order_number`	String	PK
`address_address_line_1`	String
`address_address_line_2`	String
`address_address_line_3`	String
`address_attention`	String
`address_city`	String
`address_country_code`	String
`address_county`	String
`address_district`	String
`address_name`	String
`address_phone`	String
`address_postal_code`	String
`address_state_or_region`	String
`bill_to_party_address_address_line_1`	String
`bill_to_party_address_address_line_2`	String
`bill_to_party_address_address_line_3`	String
`bill_to_party_address_attention`	String
`bill_to_party_address_city`	String
`bill_to_party_address_country_code`	String
`bill_to_party_address_county`	String
`bill_to_party_address_district`	String
`bill_to_party_address_name`	String
`bill_to_party_address_phone`	String
`bill_to_party_address_postal_code`	String
`bill_to_party_address_state_or_region`	String
`bill_to_party_party_id`	String
`bill_to_party_tax_registration_tax_registration_number`	String
`bill_to_party_tax_registration_tax_registration_type`	String
`is_gift`	Boolean
`is_priority_shipment`	Boolean
`is_pslip_required`	Boolean
`is_scheduled_delivery_shipment`	Boolean
`message_to_customer`	String
`order_date`	Instant
`order_status`	String
`promised_delivery_date`	Instant
`required_ship_date`	Instant
`selling_party_address_address_line_1`	String
`selling_party_address_address_line_2`	String
`selling_party_address_address_line_3`	String
`selling_party_address_attention`	String
`selling_party_address_city`	String
`selling_party_address_country_code`	String
`selling_party_address_county`	String
`selling_party_address_district`	String
`selling_party_address_name`	String
`selling_party_address_phone`	String
`selling_party_address_postal_code`	String
`selling_party_address_state_or_region`	String
`selling_party_party_id`	String
`selling_party_tax_registration_tax_registration_number`	String
`selling_party_tax_registration_tax_registration_type`	String
`ship_from_party_address_address_line_1`	String
`ship_from_party_address_address_line_2`	String
`ship_from_party_address_address_line_3`	String
`ship_from_party_address_attention`	String
`ship_from_party_address_city`	String
`ship_from_party_address_country_code`	String
`ship_from_party_address_county`	String
`ship_from_party_address_district`	String
`ship_from_party_address_name`	String
`ship_from_party_address_phone`	String
`ship_from_party_address_postal_code`	String
`ship_from_party_address_state_or_region`	String
`ship_from_party_party_id`	String
`ship_from_party_tax_registration_tax_registration_number`	String
`ship_from_party_tax_registration_tax_registration_type`	String
`ship_method`	String

listed_item_offers

Column	Type	Keys
`marketplace_id`	String	PK
`offer_type`	String	PK
`sku`	String	PKFK
`points_number`	Long
`price_amount`	String
`price_currency_code`	String

financial_tds_reimbursement_event

Column	Type	Keys
`_fivetran_id`	String	PK
`financial_event_group_id`	String	FK
`posted_date`	Instant
`reimbursed_amount_currency_amount`	Double
`reimbursed_amount_currency_code`	String
`tdsorder_id`	String

small_and_light_enrollment_status

Column	Type	Keys
`marketplace_id`	String	PK
`seller_sku`	String	PK
`status`	String

fba_returns_report

Column	Type	Keys
`license_plate_number`	String	PK
`marketplace_id`	String	PK
`asin`	String
`customer_comments`	String
`detailed_disposition`	String
`fnsku`	String
`fulfillment_center_id`	String
`order_id`	String
`product_name`	String
`quantity`	Int
`reason`	String
`return_date`	String
`sku`	String
`status`	String

fulfillment_customer_shipment_promotion_report

Column	Type	Keys
`amazon_order_id`	String	PK
`item_promotion_id`	String	PK
`marketplace_id`	String	PK
`shipment_id`	String	PK
`shipment_item_id`	String	PK
`currency`	String
`description`	String
`item_promotion_discount`	Double
`promotion_rule_value`	Double
`shipment_date`	Instant

technician

Column	Type	Keys
`technician_id`	String	PK
`service_id`	Long	PKFK
`name`	String

vendor_retail_procurement_order_item

Column	Type	Keys
`item_sequence_number`	String	PK
`purchase_order_number`	String	PKFK
`amazon_product_identifier`	String
`amount`	Long
`is_back_order_allowed`	Boolean
`list_price_amount`	Double
`list_price_currency_code`	String
`net_cost_amount`	Double
`net_cost_currency_code`	String
`unit_of_measure`	String
`unit_size`	Long
`vendor_product_identifier`	String

fba_shipment_replacement_data_report

Column	Type	Keys
`fulfillment_center_id`	String	PK
`marketplace_id`	String	PK
`replacement_amazon_order_id`	String	PK
`sku`	String	PK
`asin`	String
`original_amazon_order_id`	String
`original_fulfillment_center_id`	String
`quantity`	Int
`replacement_reason_code`	String
`shipment_date`	Instant

item_identifier

Column	Type	Keys
`identifier`	String	PK
`identifier_type`	String	PK
`asin`	String	PKFK
`marketplace_id`	String	PKFK

item_attribute

Column	Type	Keys
`key`	String	PK
`asin`	String	PKFK
`value`	String

financial_charge_refund_event

Column	Type	Keys
`_fivetran_id`	String	PK
`financial_event_group_id`	String	FK
`posted_date`	Instant
`reason_code`	String
`reason_code_description`	String

financial_fba_liquidation_event

Column	Type	Keys
`_fivetran_id`	String	PK
`financial_event_group_id`	String	FK
`liquidation_fee_amount_currency_amount`	Double
`liquidation_fee_amount_currency_code`	String
`liquidation_proceeds_amount_currency_amount`	Double
`liquidation_proceeds_amount_currency_code`	String
`original_removal_order_id`	String
`posted_date`	Instant

financial_rental_transaction_event

Column	Type	Keys
`_fivetran_id`	String	PK
`financial_event_group_id`	String	FK
`amazon_order_id`	String
`extension_length`	Long
`marketplace_name`	String
`posted_date`	Instant
`rental_event_type`	String
`rental_initial_value_currency_amount`	Double
`rental_initial_value_currency_code`	String
`rental_reimbursement_currency_amount`	Double
`rental_reimbursement_currency_code`	String

financial_shipment_event_item_promotion

Column	Type	Keys
`index`	Int	PK
`type`	String	PK
`financial_shipment_event_item_id`	String	PKFK
`amount_currency_amount`	Double
`amount_currency_code`	String
`id`	String
`promotion_kind`	String

vendor_forecasting_report

Column	Type	Keys
`asin`	String	PK
`end_date`	LocalDate	PK
`forecast_generation_date`	LocalDate	PK
`marketplace_id`	String	PK
`start_date`	LocalDate	PK
`mean_forecast_units`	Double
`p_70_forecast_units`	Double
`p_80_forecast_units`	Double
`p_90_forecast_units`	Double

restock_inventory_recommendations_report

Column	Type	Keys
`fnsku`	String	PK
`marketplace_id`	String	PK
`merchant_sku`	String	PK
`alert`	String
`asin`	String
`available`	Int
`condition`	String
`country`	String
`currency_code`	String
`customer_order`	Int
`days_of_supply_at_amazon_fulfillment_network`	String
`fc_processing`	Int
`fc_transfer`	Int
`fulfilled_by`	String
`inbound`	Int
`price`	Double
`product_name`	String
`receiving`	Int
`recommended_action`	String
`recommended_replenishment_qty`	Int
`recommended_ship_date`	String
`sales_last_30_days`	Double
`shipped`	Int
`supplier`	String
`supplier_part_no`	String
`total_days_of_supply`	String
`total_units`	Int
`unfulfillable`	Int
`unit_storage_size`	String
`units_sold_last_30_days`	Int
`working`	Int

marketplace_participation

Column	Type	Keys
`id`	String	PK
`merchant_id`	String	PK
`country_code`	String
`default_currency_code`	String
`default_language_code`	String
`domain_name`	String
`name`	String

fulfillment_order

Column	Type	Keys
`seller_fulfillment_order_id`	String	PK
`cod_charge_currency_code`	String
`cod_charge_taxcurrency_code`	String
`cod_charge_taxvalue`	String
`cod_charge_value`	String
`delivery_window_end_date`	Instant
`delivery_window_start_date`	Instant
`displayable_order_comment`	String
`displayable_order_date`	Instant
`displayable_order_id`	String
`fulfillment_action`	String
`fulfillment_order_status`	String
`fulfillment_policy`	String
`is_cod_required`	Boolean
`marketplace_id`	String
`received_date`	Instant
`shipping_charge_currency_code`	String
`shipping_charge_taxcurrency_code`	String
`shipping_charge_taxvalue`	String
`shipping_charge_value`	String
`shipping_speed_category`	String
`status_updated_date`	Instant
`address_`

customer_shipment_sales_report

Column	Type	Keys
`amazon_order_id`	String	PK
`asin`	String	PK
`marketplace_id`	String	PK
`sku`	String	PK
`currency`	String
`fnsku`	String
`fulfillment_center_id`	String
`gift_wrap_price`	Double
`item_price_per_unit`	String
`quantity`	Int
`ship_city`	String
`ship_postal_code`	String
`ship_state`	String
`shipment_date`	Instant
`shipping_price`	Double

financial_debt_recovery_event

Column	Type	Keys
`_fivetran_id`	String	PK
`financial_event_group_id`	String	FK
`debt_recovery_type`	String
`over_payment_credit_currency_amount`	Double
`over_payment_credit_currency_code`	String
`recovery_amount_currency_amount`	Double
`recovery_amount_currency_code`	String

service_job

Column	Type	Keys
`service_job_id`	Long	PK
`asin`	String
`create_time`	Instant
`marketplace_id`	String
`quantity`	Long
`required_skills`	Json
`seller_id`	String
`service_job_provider_id`	String
`service_job_status`	String
`service_location_address_line_1`	String
`service_location_address_line_2`	String
`service_location_address_line_3`	String
`service_location_address_type`	String
`service_location_city`	String
`service_location_country`	String
`service_location_country_code`	String
`service_location_district`	String
`service_location_district_or_county`	String
`service_location_municipality`	String
`service_location_name`	String
`service_location_phone`	String
`service_location_postal_code`	String
`service_location_service_location_type`	String
`service_location_state_or_region`	String
`service_order_id`	String
`store_id`	String
`title`	String

financial_failed_adhoc_disbursement_event

Column	Type	Keys
`_fivetran_id`	String	PK
`financial_event_group_id`	String	FK
`disbursement_id`	String
`funds_transfers_type`	String
`payment_disbursement_type`	String
`posted_date`	Instant
`status`	String
`transfer_amount_currency_amount`	Double
`transfer_amount_currency_code`	String
`transfer_id`	String

tracking_additional_input

Column	Type	Keys
`rate_id`	String	PK

financial_event_group

Column	Type	Keys
`financial_event_group_id`	String	PK
`account_tail`	String
`beginning_balance_currency_amount`	Double
`beginning_balance_currency_code`	String
`converted_total_currency_amount`	Double
`converted_total_currency_code`	String
`financial_event_group_end`	Instant
`financial_event_group_start`	Instant
`fund_transfer_date`	Instant
`fund_transfer_status`	String
`original_total_currency_amount`	Double
`original_total_currency_code`	String
`processing_status`	String
`trace_id`	String

vendor_retail_procurement_container

Column	Type	Keys
`container_sequence_number`	String	PK
`container_type`	String	PK
`transaction_date`	LocalDateTime	PKFK
`vendor_shipment_identifier`	String	PKFK
`block`	Long
`container_count`	String
`tier`	Long
`tracking_number`	String
`weight_unit_of_measure`	String
`weight_value`	Double
`dimensions_`

item_vendor_detail

Column	Type	Keys
`asin`	String	PKFK
`marketplace_id`	String	PKFK
`manufacturer_code`	String
`manufacturer_code_parent`	String
`product_categorydisplay_name`	String
`product_categoryvalue`	String
`product_group`	String
`product_subcategorydisplay_name`	String
`product_subcategoryvalue`	String
`replenishment_category`	String

financial_seller_deal_payment_event

Column	Type	Keys
`_fivetran_id`	String	PK
`financial_event_group_id`	String	FK
`deal_description`	String
`deal_id`	String
`event_type`	String
`fee_amount_currency_amount`	Double
`fee_amount_currency_code`	String
`fee_type`	String
`posted_date`	Instant
`tax_amount_currency_amount`	Double
`tax_amount_currency_code`	String
`total_amount_currency_amount`	Double
`total_amount_currency_code`	String

vendor_shipping_order

Column	Type	Keys
`purchase_order_date`	LocalDateTime	PKFK
`purchase_order_number`	String	PKFK
`transaction_date`	LocalDateTime	PKFK
`vendor_shipment_identifier`	String	PKFK
`ship_window`	String

item_variation_theme

Column	Type	Keys
`theme`	String	PK
`asin`	String	PKFK
`attribute`	Json

easyship_package_item_serial_number

Column	Type	Keys
`order_item_serial_number`	String	PK
`order_item_id`	String	PKFK
`package_id`	String	PKFK

financial_loan_servicing_event

Column	Type	Keys
`_fivetran_id`	String	PK
`financial_event_group_id`	String	FK
`loan_amount_currency_amount`	Double
`loan_amount_currency_code`	String
`source_business_event_type`	String

outbound_seller_feature

Column	Type	Keys
`feature_name`	String	PK
`feature_description`	String
`seller_eligible`	Boolean

marketplace_tax_classification

Column	Type	Keys
`name`	String	PK
`amazon_order_id`	String	PKFK
`value`	String

financial_imaging_services_fee_event

Column	Type	Keys
`_fivetran_id`	String	PK
`financial_event_group_id`	String	FK
`asin`	String
`imaging_request_billing_item_id`	String
`posted_date`	Instant

fulfilled_shipments_data_general_report

Column	Type	Keys
`amazon_order_id`	String	PK
`amazon_order_item_id`	String	PK
`marketplace_id`	String	PK
`shipment_id`	String	PK
`shipment_item_id`	String	PK
`sku`	String	PK
`bill_address_1`	String
`bill_address_2`	String
`bill_address_3`	String
`bill_city`	String
`bill_country`	String
`bill_postal_code`	String
`bill_state`	String
`buyer_email`	String
`buyer_name`	String
`buyer_phone_number`	String
`carrier`	String
`currency`	String
`estimated_arrival_date`	Instant
`fulfillment_center_id`	String
`fulfillment_channel`	String
`gift_wrap_price`	Double
`gift_wrap_tax`	Double
`item_price`	Double
`item_promotion_discount`	String
`item_tax`	Double
`merchant_order_id`	String
`merchant_order_item_id`	String
`payments_date`	Instant
`product_name`	String
`purchase_date`	Instant
`quantity_shipped`	String
`recipient_name`	String
`reporting_date`	Instant
`sales_channel`	String
`ship_address_1`	String
`ship_address_2`	String
`ship_address_3`	String
`ship_city`	String
`ship_country`	String
`ship_phone_number`	String
`ship_postal_code`	String
`ship_promotion_discount`	String
`ship_service_level`	String
`ship_state`	String
`shipment_date`	Instant
`shipping_price`	Double
`shipping_tax`	Double
`tracking_number`	String

financial_adjustment_event

Column	Type	Keys
`_fivetran_id`	String	PK
`financial_event_group_id`	String	FK
`adjustment_amount_currency_amount`	Double
`adjustment_amount_currency_code`	String
`adjustment_type`	String
`posted_date`	Instant

order_item_serial_number

Column	Type	Keys
`serial_number`	String	PK
`amazon_order_id`	String	PKFK
`order_item_id`	String	PKFK

vendor_inventory_report

Column	Type	Keys
`end_date`	LocalDate	PK
`marketplace_id`	String	PK
`start_date`	LocalDate	PK
`aged_90_plus_days_sellable_inventory_cost_amount`	Double
`aged_90_plus_days_sellable_inventory_cost_currency_code`	String
`aged_90_plus_days_sellable_inventory_units`	Long
`average_vendor_lead_time_days`	Double
`net_received_inventory_cost_amount`	Double
`net_received_inventory_cost_currency_code`	String
`net_received_inventory_units`	Long
`open_purchase_order_units`	Long
`procurable_product_out_of_stock_rate`	Double
`receive_fill_rate`	Double
`sell_through_rate`	Double
`sellable_on_hand_inventory_cost_amount`	Double
`sellable_on_hand_inventory_cost_currency_code`	String
`sellable_on_hand_inventory_units`	Long
`uft`	Double
`unfilled_customer_ordered_units`	Long
`unhealthy_inventory_cost_amount`	Double
`unhealthy_inventory_cost_currency_code`	String
`unhealthy_inventory_units`	Long
`unsellable_on_hand_inventory_cost_amount`	Double
`unsellable_on_hand_inventory_cost_currency_code`	String
`unsellable_on_hand_inventory_units`	Long
`vendor_confirmation_rate`	Double

item_image

Column	Type	Keys
`link`	String	PK
`variant`	String	PK
`asin`	String	PKFK
`marketplace_id`	String	PKFK
`height`	Long
`width`	Long

vendor_direct_fulfillment_shipping_label

Column	Type	Keys
`purchase_order_number`	String	PKFK
`label_format`	String
`selling_party_address_address_line_1`	String
`selling_party_address_address_line_2`	String
`selling_party_address_address_line_3`	String
`selling_party_address_attention`	String
`selling_party_address_city`	String
`selling_party_address_country_code`	String
`selling_party_address_county`	String
`selling_party_address_district`	String
`selling_party_address_name`	String
`selling_party_address_phone`	String
`selling_party_address_postal_code`	String
`selling_party_address_state_or_region`	String
`selling_party_party_id`	String
`ship_from_party_address_address_line_1`	String
`ship_from_party_address_address_line_2`	String
`ship_from_party_address_address_line_3`	String
`ship_from_party_address_attention`	String
`ship_from_party_address_city`	String
`ship_from_party_address_country_code`	String
`ship_from_party_address_county`	String
`ship_from_party_address_district`	String
`ship_from_party_address_name`	String
`ship_from_party_address_phone`	String
`ship_from_party_address_postal_code`	String
`ship_from_party_address_state_or_region`	String
`ship_from_party_party_id`	String

service_job_appointment

Column	Type	Keys
`appointment_id`	String	PK
`service_job_id`	Long	FK
`poa_poa_type`	String
`poa_upload_time`	Instant
`poa_uploading_technician`	String
`rescheduled_appointment_id`	String

shipment_document

Column	Type	Keys
`shipment_id`	String	PK
`type`	String	PK
`tracking_id`	String	FK
`contents`	String
`format`	String
`package_client_reference_id`	String

tracking

Column	Type	Keys
`id`	String	PK
`alternate_leg_tracking_id`	String
`promised_delivery_date`	Instant
`tracking_summary_status`	String

package_tracking_event

Column	Type	Keys
`code`	String	PK
`package_number`	Long	PKFK
`address_city`	String
`address_country`	String
`address_state`	String
`date`	Instant
`description`	String

item_summary

Column	Type	Keys
`asin`	String	PKFK
`marketplace_id`	String	PKFK
`adult_product`	Boolean
`autographed`	Boolean
`brand`	String
`classification_id`	String
`color`	String
`contributors`	Json
`display_name`	String
`item_classification`	String
`item_name`	String
`manufacturer`	String
`memorabilia`	Boolean
`model_number`	String
`package_quantity`	Long
`part_number`	String
`release_date`	LocalDate
`size`	String
`style`	String
`trade_in_eligible`	Boolean
`website_display_group`	String
`website_display_group_name`	String

vendor_direct_fulfillment_tax_detail

Column	Type	Keys
`type`	String	PK
`customer_order_number`	String	PKFK
`purchase_order_number`	String	PKFK
`tax_amount`	Double
`tax_currency_code`	String
`tax_rate`	Double
`taxable_amount`	Double
`taxable_currency_code`	String

settlement_report

Column	Type	Keys
`_fivetran_id`	String	PK
`adjustment_id`	String
`amount`	String
`amount_description`	String
`amount_type`	String
`fulfillment_id`	String
`marketplace_name`	String
`merchant_adjustment_item_id`	String
`merchant_order_id`	String
`merchant_order_item_id`	String
`order_id`	String
`order_item_code`	String
`posted_date`	String
`posted_date_time`	Instant
`promotion_id`	String
`quantity_purchased`	Long
`settlement_id`	String
`shipment_id`	String
`sku`	String
`transaction_type`	String

financial_retro_charge_event

Column	Type	Keys
`_fivetran_id`	String	PK
`financial_event_group_id`	String	FK
`amazon_order_id`	String
`base_tax_currency_amount`	Double
`base_tax_currency_code`	String
`marketplace_name`	String
`posted_date`	Instant
`retrocharge_event_type`	String
`shipping_tax_currency_amount`	Double
`shipping_tax_currency_code`	String

vendor_direct_fulfillment_shipping_label_data

Column	Type	Keys
`package_identifier`	String	PK
`purchase_order_number`	String	PKFK
`content`	String
`ship_method`	String
`ship_method_name`	String
`tracking_number`	String

vendor_retail_procurement_order_item_status

Column	Type	Keys
`item_sequence_number`	String	PK
`purchase_order_number`	String	PKFK
`accepted_quantity_amount`	Long
`accepted_quantity_unit_of_measure`	String
`accepted_quantity_unit_size`	Long
`buyer_product_identifier`	String
`confirmation_status`	String
`last_receive_date`	Instant
`list_price_amount`	Double
`list_price_currency_code`	String
`net_cost_amount`	Double
`net_cost_currency_code`	String
`ordered_quantity_amount`	Long
`ordered_quantity_unit_of_measure`	String
`ordered_quantity_unit_size`	Long
`receive_status`	String
`received_quantity_amount`	Long
`received_quantity_unit_of_measure`	String
`received_quantity_unit_size`	Long
`rejected_quantity_amount`	Long
`rejected_quantity_unit_of_measure`	String
`rejected_quantity_unit_size`	Long

item_sales_rank_type

Column	Type	Keys
`marketplace_id`	String	PK
`asin`	String	PKFK
`product_category_id`	String
`rank`	String

financial_safet_reimbursement_item

Column	Type	Keys
`_fivetran_id`	String	PK
`index`	Int	PK
`safet_reimbursement_event_id`	String	PKFK
`product_description`	String
`quantity`	String

fulfillment_order_notification_email

Column	Type	Keys
`email`	String	PK
`seller_fulfillment_order_id`	String	PKFK

tracking_event_history

Column	Type	Keys
`event_code`	String	PK
`tracking_id`	String	PKFK
`event_time`	Instant
`location_`

container_packed_item

Column	Type	Keys
`index`	Long	PK
`container_sequence_number`	String	PKFK
`container_type`	String	PKFK
`transaction_date`	LocalDateTime	PKFK
`vendor_shipment_identifier`	String	PKFK
`buyer_product_identifier`	String
`item_sequence_number`	String
`packed_item_details_expiry_duration_duration_unit`	String
`packed_item_details_expiry_duration_duration_value`	String
`packed_item_details_expiry_expiry_date`	String
`packed_item_details_expiry_manufacture_date`	String
`packed_item_details_lot_number`	String
`packed_item_details_purchase_order_number`	String
`packed_quantity_amount`	Long
`packed_quantity_unit_of_measure`	String
`packed_quantity_unit_size`	Long
`vendor_product_identifier`	String

financial_shipment_event

Column	Type	Keys
`_fivetran_id`	String	PK
`financial_event_group_id`	String	FK
`amazon_order_id`	String
`event_type`	String
`marketplace_name`	String
`posted_date`	Instant
`seller_order_id`	String

service_job_appointment_time

Column	Type	Keys
`service_job_id`	Long	PKFK
`duration_in_minutes`	Long
`start_time`	Instant
`type`	String

listed_item

Column	Type	Keys
`sku`	String	PK
`item_procurement_amount`	String
`item_procurement_currency_code`	String

fulfillment_removal_order_detail_report

Column	Type	Keys
`marketplace_id`	String	PK
`order_id`	String	PK
`request_date`	String	PK
`sku`	String	PK
`cancelled_quantity`	Int
`currency`	String
`disposed_quantity`	Int
`disposition`	String
`fnsku`	String
`in_process_quantity`	Int
`last_updated_date`	String
`order_source`	String
`order_status`	String
`order_type`	String
`removal_fee`	Double
`requested_quantity`	Int
`service_speed`	String
`shipped_quantity`	Int

market_basket_analysis_report

Column	Type	Keys
`asin`	String	PK
`end_date`	LocalDate	PK
`marketplace_id`	String	PK
`purchased_with_asin`	String	PK
`start_date`	LocalDate	PK
`combination_pct`	Double
`purchased_with_rank`	Int

item_fulfillment_availability

Column	Type	Keys
`fulfillment_channel_code`	String	PK
`sku`	String	PKFK
`quantity`	Long

storage_fee_charges_report

Column	Type	Keys
`asin`	String	PK
`fulfillment_center`	String	PK
`marketplace_id`	String	PK
`month_of_charge`	String	PK
`average_quantity_customer_orders`	Double
`average_quantity_on_hand`	Double
`average_quantity_pending_removal`	Double
`avg_qty_for_sus`	Double
`base_rate`	Double
`breakdown_incentive_fee_amount`	String
`category`	String
`country_code`	String
`currency`	String
`dangerous_goods_storage_type`	String
`eligible_for_inventory_discount`	String
`est_base_msf`	Double
`est_sus`	Double
`est_vol_for_sus`	Double
`estimated_monthly_storage_fee`	Double
`estimated_total_item_volume`	Double
`fnsku`	String
`item_volume`	Double
`longest_side`	Double
`measurement_units`	String
`median_side`	Double
`product_name`	String
`product_size_tier`	String
`qualifies_for_inventory_discount`	String
`shortest_side`	Double
`storage_rate`	Double
`storage_utilization_ratio`	String
`storage_utilization_ratio_units`	String
`total_incentive_fee_amount`	Double
`utilization_surcharge_rate`	Double
`volume_units`	String
`weight`	Double
`weight_units`	String

sales_and_traffic_business_parent_asin_report

Column	Type	Keys
`end_date`	LocalDate	PK
`marketplace_id`	String	PK
`parent_asin`	String	PK
`start_date`	LocalDate	PK
`sales_by_asin_`
`traffic_by_asin_`

order_regulated_info

Column	Type	Keys
`amazon_order_id`	String	PKFK
`external_reviewer_id`	String
`rejection_reason`	String
`rejection_reason_description`	String
`rejection_reason_id`	String
`requires_dosage_label`	Boolean
`requires_merchant_action`	Boolean
`review_date`	Instant
`status`	String
`valid_rejection_reasons`	Json