# Wherefour schema ERD

Table and field reference for the Fivetran Wherefour connector.

## Table & Field Reference

### quote_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| quote_id | Unknown | PK, FK |
| inventory_id | Unknown | FK |
| category_name | Unknown |  |
| cost | Unknown |  |
| count | Unknown |  |
| created_at | Unknown |  |
| name | Unknown |  |
| sku | Unknown |  |
| updated_at | Unknown |  |

### quote

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| created_at | Unknown |  |
| date | Unknown |  |
| delivery_method_id | Unknown |  |
| discount | Unknown |  |
| expiration_date | Unknown |  |
| instruction | Unknown |  |
| number | Unknown |  |
| payment_term_id | Unknown |  |
| salesperson_name | Unknown |  |
| shipping | Unknown |  |
| status | Unknown |  |
| subtotal | Unknown |  |
| tax | Unknown |  |
| total | Unknown |  |
| updated_at | Unknown |  |

### shipment_address

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| shipment_id | Unknown | PK, FK |
| city | Unknown |  |
| country | Unknown |  |
| country_subdivision_code | Unknown |  |
| created_at | Unknown |  |
| descriptive_name | Unknown |  |
| line_1 | Unknown |  |
| line_2 | Unknown |  |
| line_3 | Unknown |  |
| line_4 | Unknown |  |
| line_5 | Unknown |  |
| postal_code | Unknown |  |
| updated_at | Unknown |  |

### shipment_item_auto_ship

| Column | Type | Keys |
| --- | --- | --- |
| adjustment_id | Unknown | PK |
| shipment_id | Unknown | PK, FK |
| shipment_item_id | Unknown | PK, FK |
| barcode | Unknown |  |
| change | Unknown |  |
| count | Unknown |  |
| lot_code | Unknown |  |
| reason | Unknown |  |
| stock_id | Unknown |  |

### shipment_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| shipment_id | Unknown | PK, FK |
| count | Unknown |  |
| inventory_name | Unknown |  |
| inventory_sku | Unknown |  |
| part_of_kit | Unknown |  |

### shipment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| order_id | Unknown | FK |
| created_at | Unknown |  |
| delivery_driver | Unknown |  |
| delivery_vehicle | Unknown |  |
| note | Unknown |  |
| number | Unknown |  |
| ship_date | Unknown |  |
| tracking_number | Unknown |  |
| updated_at | Unknown |  |
| user_name | Unknown |  |

### purchase_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| purchase_id | Unknown | PK, FK |
| inventory_id | Unknown | FK |
| category_name | Unknown |  |
| cost | Unknown |  |
| count | Unknown |  |
| created_at | Unknown |  |
| name | Unknown |  |
| sku | Unknown |  |
| updated_at | Unknown |  |

### purchase

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| vendor_id | Unknown | FK |
| created_at | Unknown |  |
| date | Unknown |  |
| deliver_by_date | Unknown |  |
| delivery_method_id | Unknown |  |
| delivery_method_instruction | Unknown |  |
| delivery_method_kind | Unknown |  |
| delivery_method_name | Unknown |  |
| discount | Unknown |  |
| instruction | Unknown |  |
| number | Unknown |  |
| shipping | Unknown |  |
| status | Unknown |  |
| subtotal | Unknown |  |
| tax | Unknown |  |
| total | Unknown |  |
| updated_at | Unknown |  |

### inventory_conversion

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| inventory_id | Unknown | FK |
| catch_weight | Unknown |  |
| from_count | Unknown |  |
| maximum_weight | Unknown |  |
| minimum_weight | Unknown |  |
| to_count | Unknown |  |
| unit_of_measurement | Unknown |  |

### inventory_custom_field_value

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| inventory_id | Unknown | PK, FK |
| active_stock_id | Unknown |  |
| created_at | Unknown |  |
| updated_at | Unknown |  |
| value | Unknown |  |
| value_type | Unknown |  |
| custom_** |  |  |

### inventory

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| category_name | Unknown |  |
| created_at | Unknown |  |
| height | Unknown |  |
| lead_time | Unknown |  |
| length | Unknown |  |
| name | Unknown |  |
| on_hand | Unknown |  |
| property | Unknown |  |
| pull_strategy | Unknown |  |
| purchase_conversion | Unknown |  |
| quantity_not_tracked | Unknown |  |
| reorder_point | Unknown |  |
| retired | Unknown |  |
| sku | Unknown |  |
| unit_of_dimension | Unknown |  |
| unit_of_invoice | Unknown |  |
| unit_of_order | Unknown |  |
| unit_of_pick_and_ship | Unknown |  |
| unit_of_purchase | Unknown |  |
| unit_of_use | Unknown |  |
| unit_of_weight | Unknown |  |
| updated_at | Unknown |  |
| waste_percentage | Unknown |  |
| weight | Unknown |  |
| width | Unknown |  |

### order_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| order_id | Unknown | PK, FK |
| inventory_id | Unknown | FK |
| category_name | Unknown |  |
| cost | Unknown |  |
| count | Unknown |  |
| created_at | Unknown |  |
| name | Unknown |  |
| sku | Unknown |  |
| updated_at | Unknown |  |

### order_billing_address

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| orders_id | Unknown | PK, FK |
| city | Unknown |  |
| country | Unknown |  |
| country_subdivision_code | Unknown |  |
| created_at | Unknown |  |
| descriptive_name | Unknown |  |
| line_1 | Unknown |  |
| line_2 | Unknown |  |
| line_3 | Unknown |  |
| line_4 | Unknown |  |
| line_5 | Unknown |  |
| postal_code | Unknown |  |
| updated_at | Unknown |  |

### order_shipping_address

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| orders_id | Unknown | PK, FK |
| city | Unknown |  |
| country | Unknown |  |
| country_subdivision_code | Unknown |  |
| created_at | Unknown |  |
| descriptive_name | Unknown |  |
| line_1 | Unknown |  |
| line_2 | Unknown |  |
| line_3 | Unknown |  |
| line_4 | Unknown |  |
| line_5 | Unknown |  |
| postal_code | Unknown |  |
| updated_at | Unknown |  |

### order_ship_from_address

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| orders_id | Unknown | PK, FK |
| city | Unknown |  |
| country | Unknown |  |
| country_subdivision_code | Unknown |  |
| created_at | Unknown |  |
| descriptive_name | Unknown |  |
| line_1 | Unknown |  |
| line_2 | Unknown |  |
| line_3 | Unknown |  |
| line_4 | Unknown |  |
| line_5 | Unknown |  |
| postal_code | Unknown |  |
| updated_at | Unknown |  |

### orders

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| created_at | Unknown |  |
| deliver_date | Unknown |  |
| delivery_method_id | Unknown |  |
| discount | Unknown |  |
| instruction | Unknown |  |
| invoiced | Unknown |  |
| invoiced_at | Unknown |  |
| order_date | Unknown |  |
| order_number | Unknown |  |
| payment_term_id | Unknown |  |
| po_number | Unknown |  |
| produce_date | Unknown |  |
| sales_channel_name | Unknown |  |
| sales_person_name | Unknown |  |
| ship_date | Unknown |  |
| shipping | Unknown |  |
| status | Unknown |  |
| subtotal | Unknown |  |
| tax | Unknown |  |
| total | Unknown |  |
| updated_at | Unknown |  |

### customer_address

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | PK, FK |
| city | Unknown |  |
| country | Unknown |  |
| country_subdivision_code | Unknown |  |
| created_at | Unknown |  |
| descriptive_name | Unknown |  |
| line_1 | Unknown |  |
| line_2 | Unknown |  |
| line_3 | Unknown |  |
| line_4 | Unknown |  |
| line_5 | Unknown |  |
| postal_code | Unknown |  |
| updated_at | Unknown |  |

### customer_billing_address

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | PK, FK |
| city | Unknown |  |
| country | Unknown |  |
| country_subdivision_code | Unknown |  |
| created_at | Unknown |  |
| descriptive_name | Unknown |  |
| line_1 | Unknown |  |
| line_2 | Unknown |  |
| line_3 | Unknown |  |
| line_4 | Unknown |  |
| line_5 | Unknown |  |
| postal_code | Unknown |  |
| updated_at | Unknown |  |

### customer_shipping_address

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | PK, FK |
| city | Unknown |  |
| country | Unknown |  |
| country_subdivision_code | Unknown |  |
| created_at | Unknown |  |
| descriptive_name | Unknown |  |
| line_1 | Unknown |  |
| line_2 | Unknown |  |
| line_3 | Unknown |  |
| line_4 | Unknown |  |
| line_5 | Unknown |  |
| postal_code | Unknown |  |
| updated_at | Unknown |  |

### customer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_license_number | Unknown |  |
| created_at | Unknown |  |
| default_special_instructions | Unknown |  |
| delivery_driver | Unknown |  |
| delivery_method | Unknown |  |
| delivery_method_id | Unknown |  |
| delivery_vehicle | Unknown |  |
| display_name | Unknown |  |
| email | Unknown |  |
| fax | Unknown |  |
| first_name | Unknown |  |
| kind | Unknown |  |
| last_name | Unknown |  |
| mobile | Unknown |  |
| note | Unknown |  |
| payment_terms | Unknown |  |
| phone | Unknown |  |
| sales_channel | Unknown |  |
| salesperson | Unknown |  |
| updated_at | Unknown |  |
| website | Unknown |  |
| custom_** |  |  |

### invoice_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| invoice_id | Unknown | PK, FK |
| inventory_id | Unknown | FK |
| category_name | Unknown |  |
| cost | Unknown |  |
| count | Unknown |  |
| created_at | Unknown |  |
| name | Unknown |  |
| sku | Unknown |  |
| updated_at | Unknown |  |

### invoice_billing_address

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| invoice_id | Unknown | PK, FK |
| city | Unknown |  |
| country | Unknown |  |
| country_subdivision_code | Unknown |  |
| created_at | Unknown |  |
| descriptive_name | Unknown |  |
| line_1 | Unknown |  |
| line_2 | Unknown |  |
| line_3 | Unknown |  |
| line_4 | Unknown |  |
| line_5 | Unknown |  |
| postal_code | Unknown |  |
| updated_at | Unknown |  |

### invoice_shipping_address

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| invoice_id | Unknown | PK, FK |
| city | Unknown |  |
| country | Unknown |  |
| country_subdivision_code | Unknown |  |
| created_at | Unknown |  |
| descriptive_name | Unknown |  |
| line_1 | Unknown |  |
| line_2 | Unknown |  |
| line_3 | Unknown |  |
| line_4 | Unknown |  |
| line_5 | Unknown |  |
| postal_code | Unknown |  |
| updated_at | Unknown |  |

### invoice

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| created_at | Unknown |  |
| date | Unknown |  |
| delivery_method_id | Unknown |  |
| discount | Unknown |  |
| instruction | Unknown |  |
| invoice_number | Unknown |  |
| payment_term_id | Unknown |  |
| sales_channel | Unknown |  |
| sales_person_id | Unknown |  |
| salesperson_name | Unknown |  |
| shipping | Unknown |  |
| status | Unknown |  |
| subtotal | Unknown |  |
| tax | Unknown |  |
| total | Unknown |  |
| updated_at | Unknown |  |

### categories

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |

### vendor_billing_address

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| vendor_id | Unknown | PK, FK |
| city | Unknown |  |
| country | Unknown |  |
| country_subdivision_code | Unknown |  |
| created_at | Unknown |  |
| descriptive_name | Unknown |  |
| line_1 | Unknown |  |
| line_2 | Unknown |  |
| line_3 | Unknown |  |
| line_4 | Unknown |  |
| line_5 | Unknown |  |
| postal_code | Unknown |  |
| updated_at | Unknown |  |

### vendor_shipping_address

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| vendor_id | Unknown | PK, FK |
| city | Unknown |  |
| country | Unknown |  |
| country_subdivision_code | Unknown |  |
| created_at | Unknown |  |
| descriptive_name | Unknown |  |
| line_1 | Unknown |  |
| line_2 | Unknown |  |
| line_3 | Unknown |  |
| line_4 | Unknown |  |
| line_5 | Unknown |  |
| postal_code | Unknown |  |
| updated_at | Unknown |  |

### vendor

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_license_number | Unknown |  |
| created_at | Unknown |  |
| delivery_method_id | Unknown |  |
| delivery_method_kind | Unknown |  |
| delivery_method_name | Unknown |  |
| display_name | Unknown |  |
| email | Unknown |  |
| fax | Unknown |  |
| first_name | Unknown |  |
| kind | Unknown |  |
| last_name | Unknown |  |
| mobile | Unknown |  |
| note | Unknown |  |
| payment_term_id | Unknown |  |
| payment_term_name | Unknown |  |
| payment_term_net | Unknown |  |
| phone | Unknown |  |
| updated_at | Unknown |  |
| website | Unknown |  |
| custom_** |  |  |

## Relationships

- quote_line_item(inventory_id) → inventory(id)
- quote_line_item(quote_id) → quote(id)
- quote(customer_id) → customer(id)
- shipment_address(shipment_id) → shipment(id)
- shipment_item_auto_ship(shipment_item_id) → shipment_item(id)
- shipment_item_auto_ship(shipment_id) → shipment_item(shipment_id)
- shipment_item(shipment_id) → shipment(id)
- shipment(order_id) → orders(id)
- shipment(customer_id) → customer(id)
- purchase_line_item(inventory_id) → inventory(id)
- purchase_line_item(purchase_id) → purchase(id)
- purchase(vendor_id) → vendor(id)
- inventory_conversion(inventory_id) → inventory(id)
- inventory_custom_field_value(inventory_id) → inventory(id)
- order_line_item(inventory_id) → inventory(id)
- order_line_item(order_id) → orders(id)
- order_billing_address(orders_id) → orders(id)
- order_shipping_address(orders_id) → orders(id)
- order_ship_from_address(orders_id) → orders(id)
- orders(customer_id) → customer(id)
- customer_address(customer_id) → customer(id)
- customer_billing_address(customer_id) → customer(id)
- customer_shipping_address(customer_id) → customer(id)
- invoice_line_item(inventory_id) → inventory(id)
- invoice_line_item(invoice_id) → invoice(id)
- invoice_billing_address(invoice_id) → invoice(id)
- invoice_shipping_address(invoice_id) → invoice(id)
- invoice(customer_id) → customer(id)
- vendor_billing_address(vendor_id) → vendor(id)
- vendor_shipping_address(vendor_id) → vendor(id)