Fivetran documentation

Search the docs

/

eBay

Explore the interactive ERD

Table & Field Reference

orders_fulfillment_start_instruction

Column	Type	Keys
`index`	Unknown	PK
`order_id`	Unknown	PKFK
`ebay_supported_fulfillment`	Unknown
`fulfillment_instructions_type`	Unknown
`max_estimated_delivery_date`	Unknown
`min_estimated_delivery_date`	Unknown
`ship_to_contact_address_city`	Unknown
`ship_to_contact_address_country_code`	Unknown
`ship_to_contact_address_line_1`	Unknown
`ship_to_contact_address_line_2`	Unknown
`ship_to_contact_address_postalcode`	Unknown
`ship_to_contact_address_state`	Unknown
`ship_to_email`	Unknown
`ship_to_fullname`	Unknown
`ship_to_phone_number`	Unknown
`shipping_service_code`	Unknown

orders_line_item_refund

Column	Type	Keys
`index`	Unknown	PK
`orders_line_item_id`	Unknown	PKFK
`orders_line_item_order_id`	Unknown	PKFK
`amount_currency`	Unknown
`amount_value`	Unknown
`converted_from_currency`	Unknown
`converted_from_value`	Unknown
`refund_date`	Unknown
`refund_id`	Unknown
`refund_reference_id`	Unknown
`refund_status`	Unknown

orders_line_item_promotion

Column	Type	Keys
`promotion_id`	Unknown	PK
`orders_line_item_id`	Unknown	PKFK
`orders_line_item_order_id`	Unknown	PKFK
`amount_currency`	Unknown
`amount_value`	Unknown
`converted_from_currency`	Unknown
`converted_from_value`	Unknown
`description`	Unknown

orders_line_item_tax

Column	Type	Keys
`tax_type`	Unknown	PK
`orders_line_item_id`	Unknown	PKFK
`orders_line_item_order_id`	Unknown	PKFK
`amount_currency`	Unknown
`amount_value`	Unknown
`converted_from_currency`	Unknown
`converted_from_value`	Unknown

orders_line_item_variation_aspect

Column	Type	Keys
`index`	Unknown	PK
`orders_line_item_id`	Unknown	PKFK
`orders_line_item_order_id`	Unknown	PKFK
`name`	Unknown
`value`	Unknown

orders_line_item

Column	Type	Keys
`id`	Unknown	PK
`order_id`	Unknown	PKFK
`buyer_protection`	Unknown
`cost_currency`	Unknown
`cost_value`	Unknown
`fulfillment_status`	Unknown
`guaranteed_delivery`	Unknown
`item_country_code`	Unknown
`item_location`	Unknown
`item_postal_code`	Unknown
`legacy_item_id`	Unknown
`legacy_variation_id`	Unknown
`listing_marketplace_id`	Unknown
`max_estimated_delivery_date`	Unknown
`min_estimated_delivery_date`	Unknown
`purchase_marketplace_id`	Unknown
`quantity`	Unknown
`ship_by_date`	Unknown
`shipping_cost_currency`	Unknown
`shipping_cost_value`	Unknown
`sku`	Unknown
`sold_format`	Unknown
`sold_via_ad_campaign`	Unknown
`title`	Unknown
`total_currency`	Unknown
`total_value`	Unknown

orders_payment_refund

Column	Type	Keys
`index`	Unknown	PK
`orders_payment_order_id`	Unknown	PKFK
`orders_payment_reference_id`	Unknown	PKFK
`amount_currency`	Unknown
`amount_value`	Unknown
`converted_from_currency`	Unknown
`converted_from_value`	Unknown
`refund_date`	Unknown
`refund_id`	Unknown
`refund_reference_id`	Unknown
`refund_status`	Unknown

orders_payment_hold

Column	Type	Keys
`index`	Unknown	PK
`orders_payment_order_id`	Unknown	PKFK
`orders_payment_reference_id`	Unknown	PKFK
`amount_currency`	Unknown
`amount_value`	Unknown
`expected_release_date`	Unknown
`reason`	Unknown
`release_date`	Unknown
`seller_action_to_release`	Unknown
`state`	Unknown

orders_payment

Column	Type	Keys
`reference_id`	Unknown	PK
`order_id`	Unknown	PKFK
`amount_currency`	Unknown
`amount_value`	Unknown
`date`	Unknown
`method`	Unknown
`status`	Unknown

order_history

Column	Type	Keys
`id`	Unknown	PK
`adjustment_currency`	Unknown
`adjustment_value`	Unknown
`buyer_contact_address_city`	Unknown
`buyer_contact_address_country_code`	Unknown
`buyer_contact_address_line_1`	Unknown
`buyer_contact_address_postal_code`	Unknown
`buyer_contact_address_state`	Unknown
`buyer_email`	Unknown
`buyer_fullname`	Unknown
`buyer_phone_number`	Unknown
`buyer_secondary_phone_number`	Unknown
`buyer_tax_address_city`	Unknown
`buyer_tax_address_country_code`	Unknown
`buyer_tax_address_postal_code`	Unknown
`buyer_tax_address_state`	Unknown
`buyer_username`	Unknown
`cancel_request`	Json
`cancel_state`	Unknown
`creation_date`	Unknown
`delivery_cost_currency`	Unknown
`delivery_cost_value`	Unknown
`delivery_discount_currency`	Unknown
`delivery_discount_value`	Unknown
`ebay_collect_and_remit_tax`	Unknown
`fee_currency`	Unknown
`fee_value`	Unknown
`fulfillment_href`	Json
`last_modified_date`	Unknown
`legacy_order_id`	Unknown
`order_fulfillment_status`	Unknown
`order_payment_status`	Unknown
`payment_refund`	Json
`payment_total_due_seller_currency`	Unknown
`payment_total_due_seller_value`	Unknown
`price_discount_currency`	Unknown
`price_discount_value`	Unknown
`price_subtotal_currency`	Unknown
`price_subtotal_value`	Unknown
`sales_record_reference`	Unknown
`seller_id`	Unknown
`tax_currency`	Unknown
`tax_value`	Unknown
`total_currency`	Unknown
`total_fee_basis_amountcurrency`	Unknown
`total_fee_basis_amountvalue`	Unknown
`total_marketplace_feecurrency`	Unknown
`total_marketplace_feevalue`	Unknown
`total_value`	Unknown

shipping_fulfillment_line_item

Column	Type	Keys
`line_item_id`	Unknown	PKFK
`shipping_fulfillment_fivetran_id`	Unknown	PKFK
`quantity`	Unknown

shipping_fulfillment

Column	Type	Keys
`_fivetran_id`	String	PK
`order_id`	Unknown	FK
`carrier_code`	Unknown
`fulfillment_id`	Unknown
`service_code`	Unknown
`shipped_date`	Unknown
`tracking_number`	Unknown

payment_dispute_activity

Column	Type	Keys
`activity_date`	Unknown	PK
`payment_dispute_id`	Unknown	PKFK
`activity_type`	Unknown
`actor`	Unknown

payment_dispute_line_item

Column	Type	Keys
`line_item_id`	Unknown	PKFK
`payment_dispute_id`	Unknown	PKFK
`item_id`	Unknown

payment_dispute

Column	Type	Keys
`id`	Unknown	PK
`order_id`	Unknown	FK
`amount_currency`	Unknown
`amount_value`	Unknown
`buyer_provided_note`	Unknown
`buyer_username`	Unknown
`open_date`	Unknown
`reason`	Unknown
`respond_by_date`	Unknown
`revision`	Unknown
`seller_response`	Unknown
`status`	Unknown