# Amazon Selling Partner schema ERD

Table and field reference for the Fivetran Amazon Selling Partner connector.

## Table & Field Reference

### 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 |  |

### fba_returns_report

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

### 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 |  |

### financial_charge_instrument

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| debt_recovery_event_id | String | PK, FK |
| amount_currency_amount | Double |  |
| amount_currency_code | String |  |
| description | String |  |
| tail | String |  |

### 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_** |  |  |

### 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 |  |

### container_packed_item

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| container_sequence_number | String | PK, FK |
| container_type | String | PK, FK |
| transaction_date | LocalDateTime | PK, FK |
| vendor_shipment_identifier | String | PK, FK |
| 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_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

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

### 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 |  |

### 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 |  |

### vendor_direct_fulfillment_shipping_label

| Column | Type | Keys |
| --- | --- | --- |
| purchase_order_number | String | PK, FK |
| 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 |  |

### transaction_item_breakdown

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| parent_breakdown_id | String | FK |
| transaction_item_fivetran_id | String | FK |
| breakdown_amount_currency_amount | Double |  |
| breakdown_amount_currency_code | String |  |
| breakdown_type | String |  |

### vendor_retail_procurement_container

| Column | Type | Keys |
| --- | --- | --- |
| container_sequence_number | String | PK |
| container_type | String | PK |
| transaction_date | LocalDateTime | PK, FK |
| vendor_shipment_identifier | String | PK, FK |
| block | Long |  |
| container_count | String |  |
| tier | Long |  |
| tracking_number | String |  |
| weight_unit_of_measure | String |  |
| weight_value | Double |  |
| dimensions_** |  |  |

### 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 |  |

### 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 |  |

### 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 |  |

### 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_** |  |  |

### easyship_package

| Column | Type | Keys |
| --- | --- | --- |
| package_id | String | PK |
| amazon_order_id | String | PK, FK |
| invoice_invoice_date | Instant |  |
| invoice_invoice_number | String |  |
| package_identifier | String |  |
| package_status | String |  |
| tracking_id | String |  |
| package_** |  |  |
| time_slot_** |  |  |

### 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 |  |

### 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 |  |

### vendor_retail_procurement_order_item

| Column | Type | Keys |
| --- | --- | --- |
| item_sequence_number | String | PK |
| purchase_order_number | String | PK, FK |
| 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 |  |

### 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 |  |

### order_item_promotion_id

| Column | Type | Keys |
| --- | --- | --- |
| promotion_id | String | PK |
| amazon_order_id | String | PK, FK |
| order_item_id | String | PK, FK |

### 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_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 |  |

### 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 |  |

### fulfillment_order_notification_email

| Column | Type | Keys |
| --- | --- | --- |
| email | String | PK |
| seller_fulfillment_order_id | String | PK, FK |

### item_identifier

| Column | Type | Keys |
| --- | --- | --- |
| identifier | String | PK |
| identifier_type | String | PK |
| asin | String | PK, FK |
| marketplace_id | String | PK, FK |

### item_product_type

| Column | Type | Keys |
| --- | --- | --- |
| product_type | String | PK |
| asin | String | PK, FK |
| marketplace_id | String | PK, FK |

### 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 |  |

### 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 |  |

### vendor_retail_procurement_order_item_status

| Column | Type | Keys |
| --- | --- | --- |
| item_sequence_number | String | PK |
| purchase_order_number | String | PK, FK |
| 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_offer_summary

| Column | Type | Keys |
| --- | --- | --- |
| condition | String | PK |
| marketplace_id | String | PK |
| asin | String | PK, FK |
| 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 |  |

### 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 |  |

### inner_container_sequence_number

| Column | Type | Keys |
| --- | --- | --- |
| container_sequence_number | String | PK, FK |
| container_type | String | PK, FK |
| transaction_date | LocalDateTime | PK, FK |
| vendor_shipment_identifier | String | PK, FK |

### 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 |  |

### 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_** |  |  |

### listed_item_offers

| Column | Type | Keys |
| --- | --- | --- |
| marketplace_id | String | PK |
| offer_type | String | PK |
| sku | String | PK, FK |
| points_number | Long |  |
| price_amount | String |  |
| price_currency_code | String |  |

### inventory_feature

| Column | Type | Keys |
| --- | --- | --- |
| seller_sku | String | PK |
| feature_name | String | PK, FK |
| asin | String |  |
| fn_sku | String |  |
| overlapping_skus | Json |  |
| sku_count | Long |  |

### listed_item_summary

| Column | Type | Keys |
| --- | --- | --- |
| asin | String | PK |
| marketplace_id | String | PK |
| sku | String | PK, FK |
| 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 |  |

### fulfillment_removal_order_detail_report

| Column | Type | Keys |
| --- | --- | --- |
| 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 |  |

### 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_** |  |  |

### 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 |  |

### vendor_direct_fulfillment_order_item

| Column | Type | Keys |
| --- | --- | --- |
| item_sequence_number | String | PK |
| customer_order_number | String | PK, FK |
| purchase_order_number | String | PK, FK |
| 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 |  |

### 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 |  |

### 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_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 |  |

### 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 |  |

### 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 |  |

### cod_payment_execution_detail

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| amazon_order_id | String | PK, FK |
| payment_amount | String |  |
| payment_currency_code | String |  |
| payment_method | String |  |

### transaction_item

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| transaction_id | String | FK |
| description | String |  |
| total_amount_currency_amount | Double |  |
| total_amount_currency_code | String |  |

### financial_debt_recovery_item

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| debt_recovery_event_id | String | PK, FK |
| group_begin_date | Instant |  |
| group_end_date | Instant |  |
| recovery_amount_currency_amount | Double |  |
| recovery_amount_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 |  |

### transaction_context

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| transaction_id | String | PK, FK |
| asin | String |  |
| channel | String |  |
| context_type | String |  |
| deferral_reason | String |  |
| end_time | Instant |  |
| fulfillment_network | String |  |
| maturity_date | Instant |  |
| order_type | String |  |
| payment_date | Instant |  |
| payment_method | String |  |
| payment_reference | String |  |
| payment_type | String |  |
| quantity_shipped | Int |  |
| sku | String |  |
| start_time | Instant |  |
| store_name | String |  |

### outbound_seller_feature

| Column | Type | Keys |
| --- | --- | --- |
| feature_name | String | PK |
| feature_description | String |  |
| seller_eligible | Boolean |  |

### fulfilled_shipments_data_general_report

| Column | Type | Keys |
| --- | --- | --- |
| amazon_order_id | String | PK |
| amazon_order_item_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 |  |

### 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 |  |

### item_variation_theme

| Column | Type | Keys |
| --- | --- | --- |
| theme | String | PK |
| asin | String | PK, FK |
| attribute | Json |  |

### fba_inventory_researching_quantity_entry

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| inventory_summary_id | String | PK, FK |
| granularity_id | String |  |
| granularity_type | String |  |
| quantity | Int |  |

### item_summary

| Column | Type | Keys |
| --- | --- | --- |
| asin | String | PK, FK |
| marketplace_id | String | PK, FK |
| 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 |  |

### item_offer_lowest_price_type

| Column | Type | Keys |
| --- | --- | --- |
| condition | String | PK |
| marketplace_id | String | PK |
| asin | String | PK, FK |
| 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 |  |

### 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 |  |

### package_tracking_event

| Column | Type | Keys |
| --- | --- | --- |
| code | String | PK |
| package_number | Long | PK, FK |
| address_city | String |  |
| address_country | String |  |
| address_state | String |  |
| date | Instant |  |
| description | 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 |  |

### orders_report

| Column | Type | Keys |
| --- | --- | --- |
| amazon_order_id | String | PK |
| asin | 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 |  |

### item_quantity_discount_price_type

| Column | Type | Keys |
| --- | --- | --- |
| condition | String | PK |
| marketplace_id | String | PK |
| asin | String | PK, FK |
| listing_price_amount | Double |  |
| listing_price_currency_code | String |  |
| quantity_discount_type | String |  |
| quantity_tier | Long |  |

### content_meta_data_record

| Column | Type | Keys |
| --- | --- | --- |
| content_reference_key | String | PK |
| marketplace_id | String | PK |
| name | String |  |
| status | String |  |
| update_time | Instant |  |

### 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 |  |

### item_offer_count_type

| Column | Type | Keys |
| --- | --- | --- |
| condition | String | PK |
| marketplace_id | String | PK |
| type | String | PK |
| asin | String | PK, FK |
| fullfillment_channel | String |  |
| offer_count | Long |  |

### item_display_group_sales_rank

| Column | Type | Keys |
| --- | --- | --- |
| website_display_group | String | PK |
| asin | String | PK, FK |
| link | String |  |
| rank | String |  |
| title | String |  |

### item_vendor_detail

| Column | Type | Keys |
| --- | --- | --- |
| asin | String | PK, FK |
| marketplace_id | String | PK, FK |
| 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 |  |

### cpt_trade_in_value

| Column | Type | Keys |
| --- | --- | --- |
| marketplace_id | String | PK |
| asin | String | PK, FK |
| amount | Double |  |
| currency_code | String |  |

### customer_shipment_sales_report

| Column | Type | Keys |
| --- | --- | --- |
| amazon_order_id | String | PK |
| asin | 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 |  |

### ordered_quantity_details

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| item_sequence_number | String | PK, FK |
| purchase_order_number | String | PK, FK |
| 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 |  |

### vendor_direct_fulfillment_customer_invoice

| Column | Type | Keys |
| --- | --- | --- |
| purchase_order_number | String | PK, FK |
| content | String |  |

### competitive_price_type

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| marketplace_id | String | PK |
| asin | String | PK, FK |
| 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 |  |

### fulfillment_customer_shipment_promotion_report

| Column | Type | Keys |
| --- | --- | --- |
| amazon_order_id | String | PK |
| item_promotion_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 |  |

### 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 |  |

### 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 |  |

### item_buy_box_price_type

| Column | Type | Keys |
| --- | --- | --- |
| condition | String | PK |
| marketplace_id | String | PK |
| asin | String | PK, FK |
| 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 |  |

### 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 |  |

### storage_fee_charges_report

| Column | Type | Keys |
| --- | --- | --- |
| asin | String | PK |
| fulfillment_center | 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 |  |

### 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 |  |

### 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 |  |

### item_classification_sales_rank

| Column | Type | Keys |
| --- | --- | --- |
| classification_id | String | PK |
| asin | String | PK, FK |
| link | String |  |
| rank | String |  |
| title | String |  |

### financial_adjustment_item

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| adjustment_event_id | String | PK, FK |
| 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 |  |

### container_identification

| Column | Type | Keys |
| --- | --- | --- |
| container_identification_number | String | PK |
| container_identification_type | String | PK |
| container_sequence_number | String | PK, FK |
| container_type | String | PK, FK |
| transaction_date | LocalDateTime | PK, FK |
| vendor_shipment_identifier | String | PK, FK |

### return_reason_code

| Column | Type | Keys |
| --- | --- | --- |
| return_reason_code | String | PK |
| description | String |  |
| translated_description | String |  |

### 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 |  |

### small_and_light_enrollment_status

| Column | Type | Keys |
| --- | --- | --- |
| marketplace_id | String | PK |
| seller_sku | String | PK |
| status | 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 |  |

### item_image

| Column | Type | Keys |
| --- | --- | --- |
| link | String | PK |
| variant | String | PK |
| asin | String | PK, FK |
| marketplace_id | String | PK, FK |
| height | Long |  |
| width | Long |  |

### shipment_status_detail

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| transaction_date | LocalDateTime | PK, FK |
| vendor_shipment_identifier | String | PK, FK |
| shipment_status | String |  |
| shipment_status_date | LocalDateTime |  |

### 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 |  |

### sales_and_traffic_business_report

| Column | Type | Keys |
| --- | --- | --- |
| date | LocalDate | PK |
| marketplace_id | String | PK |
| sales_by_date_** |  |  |
| traffic_by_date_** |  |  |

### 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 |  |

### financial_removal_shipment_item_adjustment

| Column | Type | Keys |
| --- | --- | --- |
| removal_shipment_item_id | String | PK |
| removal_shipment_adjustment_event_id | String | PK, FK |
| 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_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 |  |

### order_item_serial_number

| Column | Type | Keys |
| --- | --- | --- |
| serial_number | String | PK |
| amazon_order_id | String | PK, FK |
| order_item_id | String | PK, FK |

### financial_shipment_event_item_promotion

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| type | String | PK |
| financial_shipment_event_item_id | String | PK, FK |
| amount_currency_amount | Double |  |
| amount_currency_code | String |  |
| id | String |  |
| promotion_kind | String |  |

### payment_method_detail_item

| Column | Type | Keys |
| --- | --- | --- |
| method | String | PK |
| amazon_order_id | String | PK, FK |

### catalog

| Column | Type | Keys |
| --- | --- | --- |
| asin | String | PK |
| marketplace_id | String |  |

### 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 |  |

### transaction_item_context

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| transaction_item_fivetran_id | String | FK |
| asin | String |  |
| channel | String |  |
| context_type | String |  |
| deferral_reason | String |  |
| end_time | Instant |  |
| fulfillment_network | String |  |
| maturity_date | Instant |  |
| order_type | String |  |
| payment_date | Instant |  |
| payment_method | String |  |
| payment_reference | String |  |
| payment_type | String |  |
| quantity_shipped | Int |  |
| sku | String |  |
| start_time | Instant |  |
| store_name | String |  |

### tracking_event_history

| Column | Type | Keys |
| --- | --- | --- |
| event_code | String | PK |
| tracking_id | String | PK, FK |
| event_time | Instant |  |
| location_** |  |  |

### fulfillment_order_feature_settings

| Column | Type | Keys |
| --- | --- | --- |
| feature_name | String | PK |
| seller_fulfillment_order_id | String | PK, FK |
| feature_fulfillment_policy | String |  |

### tracking

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| alternate_leg_tracking_id | String |  |
| promised_delivery_date | Instant |  |
| tracking_summary_status | String |  |

### 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 |  |

### 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 |  |

### financial_shipment_direct_payment

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| shipment_event_id | String | PK, FK |
| currency_amount | Double |  |
| currency_code | String |  |
| payment_type | String |  |
| shipment_event_type | 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_direct_fulfillment_shipping_label_data

| Column | Type | Keys |
| --- | --- | --- |
| package_identifier | String | PK |
| purchase_order_number | String | PK, FK |
| content | String |  |
| ship_method | String |  |
| ship_method_name | String |  |
| tracking_number | 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 |  |

### order_regulated_info

| Column | Type | Keys |
| --- | --- | --- |
| amazon_order_id | String | PK, FK |
| 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 |  |

### item_attribute

| Column | Type | Keys |
| --- | --- | --- |
| key | String | PK |
| asin | String | PK, FK |
| value | String |  |

### order_item

| Column | Type | Keys |
| --- | --- | --- |
| order_item_id | String | PK |
| amazon_order_id | String | PK, FK |
| 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 |  |

### 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_** |  |  |

### transaction

| Column | Type | Keys |
| --- | --- | --- |
| transaction_id | String | PK |
| description | String |  |
| marketplace_details_marketplace_id | String |  |
| marketplace_details_marketplace_name | String |  |
| posted_date | Instant |  |
| selling_partner_metadata_account_type | String |  |
| selling_partner_metadata_marketplace_id | String |  |
| selling_partner_metadata_selling_partner_id | String |  |
| total_amount_currency_amount | Double |  |
| total_amount_currency_code | String |  |
| transaction_status | String |  |
| transaction_type | 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_** |  |  |

### financial_safet_reimbursement_item

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| index | Int | PK |
| safet_reimbursement_event_id | String | PK, FK |
| product_description | String |  |
| quantity | String |  |

### 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_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 |  |

### easyship_package_item

| Column | Type | Keys |
| --- | --- | --- |
| order_item_id | String | PK, FK |
| package_id | String | PK, FK |

### vendor_direct_fulfillment_tax_detail

| Column | Type | Keys |
| --- | --- | --- |
| type | String | PK |
| customer_order_number | String | PK, FK |
| purchase_order_number | String | PK, FK |
| tax_amount | Double |  |
| tax_currency_code | String |  |
| tax_rate | Double |  |
| taxable_amount | Double |  |
| taxable_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 |  |

### transaction_breakdown

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| transaction_id | String | PK, FK |
| parent_breakdown_id | String | FK |
| breakdown_amount_currency_amount | Double |  |
| breakdown_amount_currency_code | String |  |
| breakdown_type | String |  |

### content_badge_set

| Column | Type | Keys |
| --- | --- | --- |
| content_badge | String | PK |
| content_reference_key | String | PK, FK |

### regulated_information_field

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| amazon_order_id | String | PK, FK |
| field_label | String |  |
| field_type | String |  |
| field_value | String |  |

### service_job_appointment_time

| Column | Type | Keys |
| --- | --- | --- |
| service_job_id | Long | PK, FK |
| duration_in_minutes | Long |  |
| start_time | Instant |  |
| type | String |  |

### vendor_shipping_order

| Column | Type | Keys |
| --- | --- | --- |
| purchase_order_date | LocalDateTime | PK, FK |
| purchase_order_number | String | PK, FK |
| transaction_date | LocalDateTime | PK, FK |
| vendor_shipment_identifier | String | PK, FK |
| ship_window | String |  |

### reimbursements_report

| Column | Type | Keys |
| --- | --- | --- |
| amazon_order_id | String | PK |
| asin | 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 |  |

### item_sales_rank_type

| Column | Type | Keys |
| --- | --- | --- |
| marketplace_id | String | PK |
| asin | String | PK, FK |
| product_category_id | String |  |
| rank | String |  |

### transaction_related_identifier

| Column | Type | Keys |
| --- | --- | --- |
| related_identifier_name | String | PK |
| related_identifier_value | String | PK |
| transaction_id | String | PK, FK |

### long_term_storage_fee_charges_report

| Column | Type | Keys |
| --- | --- | --- |
| asin | String | PK |
| fnsku | 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 |  |

### technician

| Column | Type | Keys |
| --- | --- | --- |
| technician_id | String | PK |
| service_id | Long | PK, FK |
| name | String |  |

### transaction_item_related_identifier

| Column | Type | Keys |
| --- | --- | --- |
| item_related_identifier_name | String | PK |
| item_related_identifier_value | String | PK |
| transaction_item_fivetran_id | String | PK, FK |

### item_relationship

| Column | Type | Keys |
| --- | --- | --- |
| type | String | PK |
| child_asin | String | PK, FK |
| parent_asin | String | PK, FK |

### listed_item

| Column | Type | Keys |
| --- | --- | --- |
| sku | String | PK |
| item_procurement_amount | String |  |
| item_procurement_currency_code | String |  |

### easyship_package_item_serial_number

| Column | Type | Keys |
| --- | --- | --- |
| order_item_serial_number | String | PK |
| order_item_id | String | PK, FK |
| package_id | String | PK, FK |

### item_offer_detail

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| marketplace_id | String | PK |
| sub_condition | String | PK |
| asin | String | PK, FK |
| 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 |  |

### 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 |  |

### 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 |  |

### approval_support_data_element

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| amazon_order_id | String | PK, FK |
| order_item_id | String | PK, FK |
| value | String |  |

### 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 |  |

### item_fulfillment_availability

| Column | Type | Keys |
| --- | --- | --- |
| fulfillment_channel_code | String | PK |
| sku | String | PK, FK |
| quantity | Long |  |

### financial_removal_shipment_item

| Column | Type | Keys |
| --- | --- | --- |
| removal_shipment_item_id | String | PK |
| removal_shipment_event_id | String | PK, FK |
| 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 |  |

### marketplace_tax_classification

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| amazon_order_id | String | PK, FK |
| value | String |  |

### 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 |  |

### acknowledgement_status_details

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| item_sequence_number | String | PK, FK |
| purchase_order_number | String | PK, FK |
| 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 |  |

### 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 |  |

### item_dimension

| Column | Type | Keys |
| --- | --- | --- |
| asin | String | PK, FK |
| marketplace_id | String | PK, FK |
| item_** |  |  |
| package_** |  |  |

### financial_service_fee_event

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| financial_event_group_id | String | PK, FK |
| amazon_order_id | String |  |
| asin | String |  |
| fee_description | String |  |
| fee_reason | String |  |
| fn_sku | String |  |
| seller_sku | String |  |

### listed_item_issue

| Column | Type | Keys |
| --- | --- | --- |
| code | String | PK |
| sku | String | PK, FK |
| attribute_names | Json |  |
| message | String |  |
| severity | String |  |

### 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 |  |

### 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_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 |  |

## Relationships

- financial_tds_reimbursement_event(financial_event_group_id) → financial_event_group(financial_event_group_id)
- financial_removal_shipment_adjustment_event(financial_event_group_id) → financial_event_group(financial_event_group_id)
- financial_charge_instrument(debt_recovery_event_id) → financial_debt_recovery_event(_fivetran_id)
- financial_debt_recovery_event(financial_event_group_id) → financial_event_group(financial_event_group_id)
- container_packed_item(container_sequence_number) → vendor_retail_procurement_container(container_sequence_number)
- container_packed_item(container_type) → vendor_retail_procurement_container(container_sequence_number)
- container_packed_item(vendor_shipment_identifier) → vendor_retail_procurement_container(container_sequence_number)
- container_packed_item(transaction_date) → vendor_retail_procurement_container(container_sequence_number)
- financial_affordability_expense_event(financial_event_group_id) → financial_event_group(financial_event_group_id)
- financial_adhoc_disbursement_event(financial_event_group_id) → financial_event_group(financial_event_group_id)
- vendor_direct_fulfillment_shipping_label(purchase_order_number) → vendor_direct_fulfillment_order(purchase_order_number)
- transaction_item_breakdown(transaction_item_fivetran_id) → transaction_item(_fivetran_id)
- transaction_item_breakdown(parent_breakdown_id) → transaction_item_breakdown(_fivetran_id)
- vendor_retail_procurement_container(vendor_shipment_identifier) → vendor_retail_procurement_shipment(vendor_shipment_identifier)
- vendor_retail_procurement_container(transaction_date) → vendor_retail_procurement_shipment(vendor_shipment_identifier)
- easyship_package(amazon_order_id) → orders(amazon_order_id)
- financial_coupon_payment_event(financial_event_group_id) → financial_event_group(financial_event_group_id)
- vendor_retail_procurement_order_item(purchase_order_number) → vendor_retail_procurement_order(purchase_order_number)
- financial_imaging_services_fee_event(financial_event_group_id) → financial_event_group(financial_event_group_id)
- order_item_promotion_id(order_item_id) → order_item(order_item_id)
- order_item_promotion_id(amazon_order_id) → orders(amazon_order_id)
- service_job_appointment(service_job_id) → service_job(service_job_id)
- fulfillment_order_notification_email(seller_fulfillment_order_id) → fulfillment_order(seller_fulfillment_order_id)
- item_identifier(asin) → catalog(asin)
- item_identifier(marketplace_id) → catalog(asin)
- item_product_type(asin) → catalog(asin)
- item_product_type(marketplace_id) → catalog(asin)
- financial_trial_shipment_event(financial_event_group_id) → financial_event_group(financial_event_group_id)
- vendor_retail_procurement_order_item_status(purchase_order_number) → vendor_retail_procurement_order_status(purchase_order_number)
- item_offer_summary(asin) → catalog(asin)
- inner_container_sequence_number(container_sequence_number) → vendor_retail_procurement_container(container_sequence_number)
- inner_container_sequence_number(container_type) → vendor_retail_procurement_container(container_sequence_number)
- inner_container_sequence_number(vendor_shipment_identifier) → vendor_retail_procurement_container(container_sequence_number)
- inner_container_sequence_number(transaction_date) → vendor_retail_procurement_container(container_sequence_number)
- financial_removal_shipment_event(financial_event_group_id) → financial_event_group(financial_event_group_id)
- listed_item_offers(sku) → listed_item(sku)
- inventory_feature(feature_name) → outbound_seller_feature(feature_name)
- listed_item_summary(sku) → listed_item(sku)
- financial_solution_provider_credit_event(financial_event_group_id) → financial_event_group(financial_event_group_id)
- vendor_direct_fulfillment_order_item(purchase_order_number) → vendor_direct_fulfillment_order(purchase_order_number)
- vendor_direct_fulfillment_order_item(customer_order_number) → vendor_direct_fulfillment_order(purchase_order_number)
- financial_safet_reimbursement_event(financial_event_group_id) → financial_event_group(financial_event_group_id)
- network_commingling_transaction_event(financial_event_group_id) → financial_event_group(financial_event_group_id)
- financial_pay_with_amazon_event(financial_event_group_id) → financial_event_group(financial_event_group_id)
- cod_payment_execution_detail(amazon_order_id) → orders(amazon_order_id)
- transaction_item(transaction_id) → transaction(transaction_id)
- financial_debt_recovery_item(debt_recovery_event_id) → financial_debt_recovery_event(_fivetran_id)
- financial_product_ads_payment_event(financial_event_group_id) → financial_event_group(financial_event_group_id)
- transaction_context(transaction_id) → transaction(transaction_id)
- item_variation_theme(asin) → catalog(asin)
- fba_inventory_researching_quantity_entry(inventory_summary_id) → fba_inventory_summary(_fivetran_id)
- item_summary(asin) → catalog(asin)
- item_summary(marketplace_id) → catalog(asin)
- item_offer_lowest_price_type(asin) → catalog(asin)
- financial_adjustment_event(financial_event_group_id) → financial_event_group(financial_event_group_id)
- package_tracking_event(package_number) → package_tracking_detail(package_number)
- item_quantity_discount_price_type(asin) → catalog(asin)
- shipment_document(tracking_id) → tracking(id)
- item_offer_count_type(asin) → catalog(asin)
- item_display_group_sales_rank(asin) → catalog(asin)
- item_vendor_detail(asin) → catalog(asin)
- item_vendor_detail(marketplace_id) → catalog(asin)
- cpt_trade_in_value(asin) → catalog(asin)
- ordered_quantity_details(item_sequence_number) → vendor_retail_procurement_order_item(item_sequence_number)
- ordered_quantity_details(purchase_order_number) → vendor_retail_procurement_order_item(item_sequence_number)
- vendor_direct_fulfillment_customer_invoice(purchase_order_number) → vendor_direct_fulfillment_order(purchase_order_number)
- competitive_price_type(asin) → catalog(asin)
- financial_tax_withholding_event(financial_event_group_id) → financial_event_group(financial_event_group_id)
- item_buy_box_price_type(asin) → catalog(asin)
- financial_fba_liquidation_event(financial_event_group_id) → financial_event_group(financial_event_group_id)
- financial_loan_servicing_event(financial_event_group_id) → financial_event_group(financial_event_group_id)
- item_classification_sales_rank(asin) → catalog(asin)
- financial_adjustment_item(adjustment_event_id) → financial_adjustment_event(_fivetran_id)
- container_identification(container_sequence_number) → vendor_retail_procurement_container(container_sequence_number)
- container_identification(container_type) → vendor_retail_procurement_container(container_sequence_number)
- container_identification(vendor_shipment_identifier) → vendor_retail_procurement_container(container_sequence_number)
- container_identification(transaction_date) → vendor_retail_procurement_container(container_sequence_number)
- item_image(asin) → catalog(asin)
- item_image(marketplace_id) → catalog(asin)
- shipment_status_detail(vendor_shipment_identifier) → vendor_retail_procurement_shipment(vendor_shipment_identifier)
- shipment_status_detail(transaction_date) → vendor_retail_procurement_shipment(vendor_shipment_identifier)
- financial_failed_adhoc_disbursement_event(financial_event_group_id) → financial_event_group(financial_event_group_id)
- financial_removal_shipment_item_adjustment(removal_shipment_adjustment_event_id) → financial_removal_shipment_adjustment_event(adjustment_event_id)
- fba_inventory_summary(asin) → catalog(asin)
- order_item_serial_number(order_item_id) → order_item(order_item_id)
- order_item_serial_number(amazon_order_id) → order_item(order_item_id)
- financial_shipment_event_item_promotion(financial_shipment_event_item_id) → financial_shipment_event_item(_fivetran_id)
- payment_method_detail_item(amazon_order_id) → orders(amazon_order_id)
- transaction_item_context(transaction_item_fivetran_id) → transaction_item(_fivetran_id)
- tracking_event_history(tracking_id) → tracking(id)
- fulfillment_order_feature_settings(seller_fulfillment_order_id) → fulfillment_order(seller_fulfillment_order_id)
- financial_retro_charge_event(financial_event_group_id) → financial_event_group(financial_event_group_id)
- financial_shipment_direct_payment(shipment_event_id) → financial_shipment_event(_fivetran_id)
- financial_seller_deal_payment_event(financial_event_group_id) → financial_event_group(financial_event_group_id)
- vendor_direct_fulfillment_shipping_label_data(purchase_order_number) → vendor_direct_fulfillment_shipping_label(purchase_order_number)
- financial_shipment_event(financial_event_group_id) → financial_event_group(financial_event_group_id)
- order_regulated_info(amazon_order_id) → orders(amazon_order_id)
- item_attribute(asin) → catalog(asin)
- order_item(amazon_order_id) → orders(amazon_order_id)
- financial_safet_reimbursement_item(safet_reimbursement_event_id) → financial_safet_reimbursement_event(_fivetran_id)
- financial_charge_refund_event(financial_event_group_id) → financial_event_group(financial_event_group_id)
- easyship_package_item(package_id) → easyship_package(amazon_order_id)
- easyship_package_item(order_item_id) → order_item(order_item_id)
- vendor_direct_fulfillment_tax_detail(purchase_order_number) → vendor_direct_fulfillment_order(purchase_order_number)
- vendor_direct_fulfillment_tax_detail(customer_order_number) → vendor_direct_fulfillment_order(purchase_order_number)
- financial_value_added_service_charge_event(financial_event_group_id) → financial_event_group(financial_event_group_id)
- transaction_breakdown(transaction_id) → transaction(transaction_id)
- transaction_breakdown(parent_breakdown_id) → transaction_breakdown(_fivetran_id)
- content_badge_set(content_reference_key) → content_meta_data_record(content_reference_key)
- regulated_information_field(amazon_order_id) → orders(amazon_order_id)
- service_job_appointment_time(service_job_id) → service_job(service_job_id)
- vendor_shipping_order(vendor_shipment_identifier) → vendor_retail_procurement_shipment(vendor_shipment_identifier)
- vendor_shipping_order(transaction_date) → vendor_retail_procurement_shipment(vendor_shipment_identifier)
- vendor_shipping_order(purchase_order_number) → vendor_retail_procurement_order(purchase_order_number)
- vendor_shipping_order(purchase_order_date) → vendor_retail_procurement_order(purchase_order_number)
- item_sales_rank_type(asin) → catalog(asin)
- transaction_related_identifier(transaction_id) → transaction(transaction_id)
- technician(service_id) → service_job(service_job_id)
- transaction_item_related_identifier(transaction_item_fivetran_id) → transaction_item(_fivetran_id)
- item_relationship(parent_asin) → catalog(asin)
- item_relationship(child_asin) → catalog(asin)
- easyship_package_item_serial_number(package_id) → easyship_package(amazon_order_id)
- easyship_package_item_serial_number(order_item_id) → order_item(order_item_id)
- item_offer_detail(asin) → catalog(asin)
- approval_support_data_element(order_item_id) → order_item(order_item_id)
- approval_support_data_element(amazon_order_id) → order_item(order_item_id)
- financial_rental_transaction_event(financial_event_group_id) → financial_event_group(financial_event_group_id)
- item_fulfillment_availability(sku) → listed_item(sku)
- financial_removal_shipment_item(removal_shipment_event_id) → financial_removal_shipment_event(_fivetran_id)
- marketplace_tax_classification(amazon_order_id) → orders(amazon_order_id)
- financial_shipment_event_item(financial_shipment_event_id) → financial_shipment_event(_fivetran_id)
- acknowledgement_status_details(item_sequence_number) → vendor_retail_procurement_order_item(item_sequence_number)
- acknowledgement_status_details(purchase_order_number) → vendor_retail_procurement_order_item(item_sequence_number)
- item_dimension(asin) → catalog(asin)
- item_dimension(marketplace_id) → catalog(asin)
- financial_service_fee_event(financial_event_group_id) → financial_event_group(financial_event_group_id)
- listed_item_issue(sku) → listed_item(sku)
- financial_seller_review_enrollment_payment_event(financial_event_group_id) → financial_event_group(financial_event_group_id)
- financial_capacity_reservation_billing_event(financial_event_group_id) → financial_event_group(financial_event_group_id)