Fivetran documentation

Search the docs

/

Loop

Explore the interactive ERD

Table & Field Reference

return_cancelled_exchange

Column	Type	Keys
`exchange_id`	Unknown	PK
`return_cancelled_id`	Unknown	PKFK
`discount`	Unknown
`out_of_stock`	Unknown
`out_of_stock_resolution`	Unknown
`price`	Unknown
`product_id`	Unknown
`sku`	Unknown
`tax`	Unknown
`title`	Unknown
`total`	Unknown
`type`	Unknown
`variant_id`	Unknown

return_cancelled_line_item

Column	Type	Keys
`line_item_id`	Unknown	PK
`return_cancelled_id`	Unknown	PKFK
`barcode`	Unknown
`discount`	Unknown
`exchange_variant`	Unknown
`outcome`	Unknown
`parent_return_reason`	Unknown
`price`	Unknown
`product_id`	Unknown
`provider_line_item_id`	Unknown
`refund`	Unknown
`return_comment`	Unknown
`return_reason`	Unknown
`returned_at`	Unknown
`sku`	Unknown
`tax`	Unknown
`title`	Unknown
`variant_id`	Unknown

return_cancelled

Column	Type	Keys
`id`	Unknown	PK
`address_1`	Unknown
`address_2`	Unknown
`carrier`	Unknown
`city`	Unknown
`company`	Unknown
`country`	Unknown
`country_code`	Unknown
`created_at`	Unknown
`credit_total`	Unknown
`currency`	Unknown
`customer`	Unknown
`destination_id`	Unknown
`discount_total`	Unknown
`exchange_credit_total`	Unknown
`exchange_discount_total`	Unknown
`exchange_product_total`	Unknown
`exchange_tax_total`	Unknown
`exchange_total`	Unknown
`gift_card`	Unknown
`handling_fee`	Unknown
`label_rate`	Unknown
`label_status`	Unknown
`label_updated_at`	Unknown
`label_url`	Unknown
`latitude`	Unknown
`longitude`	Unknown
`method_state`	Unknown
`method_type`	Unknown
`multi_currency`	Unknown
`name`	Unknown
`order_id`	Unknown
`order_name`	Unknown
`order_number`	Unknown
`outcome`	Unknown
`package_reference`	Unknown
`phone`	Unknown
`product_total`	Unknown
`provider`	Unknown
`provider_order_id`	Unknown
`qr_code_url`	Unknown
`refund`	Unknown
`return_total`	Unknown
`rma_id`	Unknown
`scannable_id`	Unknown
`scheduled_at`	Unknown
`state`	Unknown
`state_address`	Unknown
`status_page_url`	Unknown
`tax_total`	Unknown
`total`	Unknown
`tracking_number`	Unknown
`updated_at`	Unknown
`upsell`	Unknown
`zip`	Unknown

advanced_shipping_notice

Column	Type	Keys
`id`	Unknown	PK
`order_id`	Unknown	PK
`return_line_item_id`	Unknown	PK
`barcode`	Unknown
`closed_at`	Unknown
`created_at`	Unknown
`customer_email`	Unknown
`purchase_price`	Unknown
`restock_status`	Unknown
`return_list_id`	Unknown
`sku`	Unknown
`title`	Unknown
`updated_at`	Unknown

return_review_exchange

Column	Type	Keys
`exchange_id`	Unknown	PK
`return_review_id`	Unknown	PKFK
`discount`	Unknown
`out_of_stock`	Unknown
`out_of_stock_resolution`	Unknown
`price`	Unknown
`product_id`	Unknown
`sku`	Unknown
`tax`	Unknown
`title`	Unknown
`total`	Unknown
`type`	Unknown
`variant_id`	Unknown

return_review_line_item

Column	Type	Keys
`line_item_id`	Unknown	PK
`return_review_id`	Unknown	PKFK
`barcode`	Unknown
`discount`	Unknown
`exchange_variant`	Unknown
`outcome`	Unknown
`parent_return_reason`	Unknown
`price`	Unknown
`product_id`	Unknown
`provider_line_item_id`	Unknown
`refund`	Unknown
`return_comment`	Unknown
`return_reason`	Unknown
`returned_at`	Unknown
`sku`	Unknown
`tax`	Unknown
`title`	Unknown
`variant_id`	Unknown

return_review

Column	Type	Keys
`id`	Unknown	PK
`address_1`	Unknown
`address_2`	Unknown
`carrier`	Unknown
`city`	Unknown
`company`	Unknown
`country`	Unknown
`country_code`	Unknown
`created_at`	Unknown
`credit_total`	Unknown
`currency`	Unknown
`customer`	Unknown
`destination_id`	Unknown
`discount_total`	Unknown
`exchange_credit_total`	Unknown
`exchange_discount_total`	Unknown
`exchange_product_total`	Unknown
`exchange_tax_total`	Unknown
`exchange_total`	Unknown
`gift_card`	Unknown
`handling_fee`	Unknown
`label_rate`	Unknown
`label_status`	Unknown
`label_updated_at`	Unknown
`label_url`	Unknown
`latitude`	Unknown
`longitude`	Unknown
`method_state`	Unknown
`method_type`	Unknown
`multi_currency`	Unknown
`name`	Unknown
`order_id`	Unknown
`order_name`	Unknown
`order_number`	Unknown
`outcome`	Unknown
`package_reference`	Unknown
`phone`	Unknown
`product_total`	Unknown
`provider`	Unknown
`provider_order_id`	Unknown
`qr_code_url`	Unknown
`refund`	Unknown
`return_total`	Unknown
`rma_id`	Unknown
`scannable_id`	Unknown
`scheduled_at`	Unknown
`state`	Unknown
`state_address`	Unknown
`status_page_url`	Unknown
`tax_total`	Unknown
`total`	Unknown
`tracking_number`	Unknown
`updated_at`	Unknown
`upsell`	Unknown
`zip`	Unknown

return_open_closed_expired_exchange

Column	Type	Keys
`exchange_id`	Unknown	PK
`return_open_closed_expired_id`	Unknown	PKFK
`discount`	Unknown
`out_of_stock`	Unknown
`out_of_stock_resolution`	Unknown
`price`	Unknown
`product_id`	Unknown
`sku`	Unknown
`tax`	Unknown
`title`	Unknown
`total`	Unknown
`type`	Unknown
`variant_id`	Unknown

return_open_closed_expired_line_item

Column	Type	Keys
`line_item_id`	Unknown	PK
`return_open_closed_expired_id`	Unknown	PKFK
`barcode`	Unknown
`discount`	Unknown
`exchange_variant`	Unknown
`outcome`	Unknown
`parent_return_reason`	Unknown
`price`	Unknown
`product_id`	Unknown
`provider_line_item_id`	Unknown
`refund`	Unknown
`return_comment`	Unknown
`return_reason`	Unknown
`returned_at`	Unknown
`sku`	Unknown
`tax`	Unknown
`title`	Unknown
`variant_id`	Unknown

return_open_closed_expired

Column	Type	Keys
`id`	Unknown	PK
`address_1`	Unknown
`address_2`	Unknown
`carrier`	Unknown
`city`	Unknown
`company`	Unknown
`country`	Unknown
`country_code`	Unknown
`created_at`	Unknown
`credit_total`	Unknown
`currency`	Unknown
`customer`	Unknown
`destination_id`	Unknown
`discount_total`	Unknown
`exchange_credit_total`	Unknown
`exchange_discount_total`	Unknown
`exchange_product_total`	Unknown
`exchange_tax_total`	Unknown
`exchange_total`	Unknown
`gift_card`	Unknown
`handling_fee`	Unknown
`label_rate`	Unknown
`label_status`	Unknown
`label_updated_at`	Unknown
`label_url`	Unknown
`latitude`	Unknown
`longitude`	Unknown
`method_state`	Unknown
`method_type`	Unknown
`multi_currency`	Unknown
`name`	Unknown
`order_id`	Unknown
`order_name`	Unknown
`order_number`	Unknown
`outcome`	Unknown
`package_reference`	Unknown
`phone`	Unknown
`product_total`	Unknown
`provider`	Unknown
`provider_order_id`	Unknown
`qr_code_url`	Unknown
`refund`	Unknown
`return_total`	Unknown
`rma_id`	Unknown
`scannable_id`	Unknown
`scheduled_at`	Unknown
`state`	Unknown
`state_address`	Unknown
`status_page_url`	Unknown
`tax_total`	Unknown
`total`	Unknown
`tracking_number`	Unknown
`updated_at`	Unknown
`upsell`	Unknown
`zip`	Unknown