# Loop schema ERD

Table and field reference for the Fivetran Loop connector.

## Table & Field Reference

### return_cancelled_exchange

| Column | Type | Keys |
| --- | --- | --- |
| exchange_id | Unknown | PK |
| return_cancelled_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 |  |

## Relationships

- return_cancelled_exchange(return_cancelled_id) → return_cancelled(id)
- return_cancelled_line_item(return_cancelled_id) → return_cancelled(id)
- return_review_exchange(return_review_id) → return_review(id)
- return_review_line_item(return_review_id) → return_review(id)
- return_open_closed_expired_exchange(return_open_closed_expired_id) → return_open_closed_expired(id)
- return_open_closed_expired_line_item(return_open_closed_expired_id) → return_open_closed_expired(id)