# ShipNetwork schema ERD

Table and field reference for the Fivetran ShipNetwork connector.

## Table & Field Reference

### advance_shipping_notice_item

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| advance_shipping_notice_id | Unknown | PK, FK |
| description | Unknown |  |
| expected_quantity | Unknown |  |
| purchase_order_number | Unknown |  |
| received_quantity | Unknown |  |
| stock_keeping_unit | Unknown |  |
| tracking_number | Unknown |  |

### advance_shipping_notice

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| arrival_date | Unknown |  |
| client_advanced_shipment_notice | Unknown |  |
| estimated_delivery_date | Unknown |  |
| warehouse_name | Unknown |  |

### hs_code

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| code | Unknown |  |
| long_description | Unknown |  |
| short_description | Unknown |  |

### item_available_inventory_lot_detail

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| item_available_inventory_index | Unknown | PK, FK |
| lot_number | Unknown |  |
| quantity | Unknown |  |

### item_available_inventory

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| available_inventory_quantity | Unknown |  |
| warehouse_name | Unknown |  |

### item_lot_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| expiration_date | Unknown |  |
| lot_number | Unknown |  |
| quantity | Unknown |  |

### item

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| hs_code_id | Unknown | FK |
| barcode | Unknown |  |
| category | Unknown |  |
| declared_value | Unknown |  |
| description | Unknown |  |
| haz_mat_type | Unknown |  |
| height | Unknown |  |
| is_expiration_tracked | Unknown |  |
| is_haz_mat | Unknown |  |
| is_label_only | Unknown |  |
| is_lot_tracked | Unknown |  |
| is_serial_tracked | Unknown |  |
| length | Unknown |  |
| origin_country | Unknown |  |
| stock_keeping_unit | Unknown |  |
| weight | Unknown |  |
| width | Unknown |  |

### order_business_stock_keeping_unit_item_lot

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_business_stock_keeping_unit_index | Unknown | PK, FK |
| order_business_stock_keeping_unit_order_business_id | Unknown | PK, FK |
| expiration_date | Unknown |  |
| lot_number | Unknown |  |
| quantity | Unknown |  |

### order_business_stock_keeping_unit_serial_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_business_stock_keeping_unit_index | Unknown | PK, FK |
| order_business_stock_keeping_unit_order_business_id | Unknown | PK, FK |
| serial_number | Unknown |  |

### order_business_stock_keeping_unit

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_business_id | Unknown | PK, FK |
| description | Unknown |  |
| quantity | Unknown |  |
| stock_keeping_unit | Unknown |  |

### order_business

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| comment | Unknown |  |
| customer_address_1 | Unknown |  |
| customer_address_2 | Unknown |  |
| customer_address_3 | Unknown |  |
| customer_city | Unknown |  |
| customer_company | Unknown |  |
| customer_country | Unknown |  |
| customer_email | Unknown |  |
| customer_name | Unknown |  |
| customer_phone_number | Unknown |  |
| customer_postal_code | Unknown |  |
| customer_state_or_province | Unknown |  |
| date_backordered | Unknown |  |
| date_created | Unknown |  |
| reference_number | Unknown |  |
| shipping_method | Unknown |  |
| status_description | Unknown |  |
| type | Unknown |  |
| warehouse_name | Unknown |  |

### backorder_dropship_stock_keeping_unit_item_lot

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| backorder_dropship_stock_keeping_unit_backorder_dropship_id | Unknown | PK, FK |
| backorder_dropship_stock_keeping_unit_index | Unknown | PK, FK |
| expiration_date | Unknown |  |
| lot_number | Unknown |  |
| quantity | Unknown |  |

### backorder_dropship_stock_keeping_unit_serial_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| backorder_dropship_stock_keeping_unit_backorder_dropship_id | Unknown | PK, FK |
| backorder_dropship_stock_keeping_unit_index | Unknown | PK, FK |
| serial_number | Unknown |  |

### backorder_dropship_stock_keeping_unit

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| backorder_dropship_id | Unknown | PK, FK |
| description | Unknown |  |
| quantity | Unknown |  |
| stock_keeping_unit | Unknown |  |

### backorder_dropship

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| comment | Unknown |  |
| customer_address_1 | Unknown |  |
| customer_address_2 | Unknown |  |
| customer_address_3 | Unknown |  |
| customer_city | Unknown |  |
| customer_company | Unknown |  |
| customer_country | Unknown |  |
| customer_email | Unknown |  |
| customer_name | Unknown |  |
| customer_phone_number | Unknown |  |
| customer_postal_code | Unknown |  |
| customer_state_or_province | Unknown |  |
| date_backordered | Unknown |  |
| date_created | Unknown |  |
| reference_number | Unknown |  |
| shipping_method | Unknown |  |
| type | Unknown |  |
| warehouse_name | Unknown |  |

### order_dropship_stock_keeping_unit_item_lot

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_dropship_stock_keeping_unit_index | Unknown | PK, FK |
| order_dropship_stock_keeping_unit_order_dropship_id | Unknown | PK, FK |
| expiration_date | Unknown |  |
| lot_number | Unknown |  |
| quantity | Unknown |  |

### order_dropship_stock_keeping_unit_serial_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_dropship_stock_keeping_unit_index | Unknown | PK, FK |
| order_dropship_stock_keeping_unit_order_dropship_id | Unknown | PK, FK |
| serial_number | Unknown |  |

### order_dropship_stock_keeping_unit

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_dropship_id | Unknown | PK, FK |
| description | Unknown |  |
| quantity | Unknown |  |
| stock_keeping_unit | Unknown |  |

### order_dropship

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| comment | Unknown |  |
| customer_address_1 | Unknown |  |
| customer_address_2 | Unknown |  |
| customer_address_3 | Unknown |  |
| customer_city | Unknown |  |
| customer_company | Unknown |  |
| customer_country | Unknown |  |
| customer_email | Unknown |  |
| customer_name | Unknown |  |
| customer_phone_number | Unknown |  |
| customer_postal_code | Unknown |  |
| customer_state_or_province | Unknown |  |
| date_backordered | Unknown |  |
| date_created | Unknown |  |
| reference_number | Unknown |  |
| shipping_method | Unknown |  |
| status_description | Unknown |  |
| type | Unknown |  |
| warehouse_name | Unknown |  |

### order_consumer_stock_keeping_unit_item_lot

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_consumer_stock_keeping_unit_index | Unknown | PK, FK |
| order_consumer_stock_keeping_unit_order_consumer_id | Unknown | PK, FK |
| expiration_date | Unknown |  |
| lot_number | Unknown |  |
| quantity | Unknown |  |

### order_consumer_stock_keeping_unit_serial_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_consumer_stock_keeping_unit_index | Unknown | PK, FK |
| order_consumer_stock_keeping_unit_order_consumer_id | Unknown | PK, FK |
| serial_number | Unknown |  |

### order_consumer_stock_keeping_unit

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_consumer_id | Unknown | PK, FK |
| description | Unknown |  |
| quantity | Unknown |  |
| stock_keeping_unit | Unknown |  |

### order_consumer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| comment | Unknown |  |
| customer_address_1 | Unknown |  |
| customer_address_2 | Unknown |  |
| customer_address_3 | Unknown |  |
| customer_city | Unknown |  |
| customer_company | Unknown |  |
| customer_country | Unknown |  |
| customer_email | Unknown |  |
| customer_name | Unknown |  |
| customer_phone_number | Unknown |  |
| customer_postal_code | Unknown |  |
| customer_state_or_province | Unknown |  |
| date_backordered | Unknown |  |
| date_created | Unknown |  |
| reference_number | Unknown |  |
| shipping_method | Unknown |  |
| status_description | Unknown |  |
| type | Unknown |  |
| warehouse_name | Unknown |  |

### backorder_consumer_stock_keeping_unit_item_lot

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| backorder_consumer_stock_keeping_unit_backorder_consumer_id | Unknown | PK, FK |
| backorder_consumer_stock_keeping_unit_index | Unknown | PK, FK |
| expiration_date | Unknown |  |
| lot_number | Unknown |  |
| quantity | Unknown |  |

### backorder_consumer_stock_keeping_unit_serial_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| backorder_consumer_stock_keeping_unit_backorder_consumer_id | Unknown | PK, FK |
| backorder_consumer_stock_keeping_unit_index | Unknown | PK, FK |
| serial_number | Unknown |  |

### backorder_consumer_stock_keeping_unit

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| backorder_consumer_id | Unknown | PK, FK |
| description | Unknown |  |
| quantity | Unknown |  |
| stock_keeping_unit | Unknown |  |

### backorder_consumer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| comment | Unknown |  |
| customer_address_1 | Unknown |  |
| customer_address_2 | Unknown |  |
| customer_address_3 | Unknown |  |
| customer_city | Unknown |  |
| customer_company | Unknown |  |
| customer_country | Unknown |  |
| customer_email | Unknown |  |
| customer_name | Unknown |  |
| customer_phone_number | Unknown |  |
| customer_postal_code | Unknown |  |
| customer_state_or_province | Unknown |  |
| date_backordered | Unknown |  |
| date_created | Unknown |  |
| reference_number | Unknown |  |
| shipping_method | Unknown |  |
| type | Unknown |  |
| warehouse_name | Unknown |  |

### backorder_wholesale_stock_keeping_unit_item_lot

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| backorder_wholesale_stock_keeping_unit_backorder_wholesale_id | Unknown | PK, FK |
| backorder_wholesale_stock_keeping_unit_index | Unknown | PK, FK |
| expiration_date | Unknown |  |
| lot_number | Unknown |  |
| quantity | Unknown |  |

### backorder_wholesale_stock_keeping_unit_serial_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| backorder_wholesale_stock_keeping_unit_backorder_wholesale_id | Unknown | PK, FK |
| backorder_wholesale_stock_keeping_unit_index | Unknown | PK, FK |
| serial_number | Unknown |  |

### backorder_wholesale_stock_keeping_unit

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| backorder_wholesale_id | Unknown | PK, FK |
| description | Unknown |  |
| quantity | Unknown |  |
| stock_keeping_unit | Unknown |  |

### backorder_wholesale

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| comment | Unknown |  |
| customer_address_1 | Unknown |  |
| customer_address_2 | Unknown |  |
| customer_address_3 | Unknown |  |
| customer_city | Unknown |  |
| customer_company | Unknown |  |
| customer_country | Unknown |  |
| customer_email | Unknown |  |
| customer_name | Unknown |  |
| customer_phone_number | Unknown |  |
| customer_postal_code | Unknown |  |
| customer_state_or_province | Unknown |  |
| date_backordered | Unknown |  |
| date_created | Unknown |  |
| reference_number | Unknown |  |
| shipping_method | Unknown |  |
| type | Unknown |  |
| warehouse_name | Unknown |  |

### order_wholesale_stock_keeping_unit_item_lot

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_wholesale_stock_keeping_unit_index | Unknown | PK, FK |
| order_wholesale_stock_keeping_unit_order_wholesale_id | Unknown | PK, FK |
| expiration_date | Unknown |  |
| lot_number | Unknown |  |
| quantity | Unknown |  |

### order_wholesale_stock_keeping_unit_serial_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_wholesale_stock_keeping_unit_index | Unknown | PK, FK |
| order_wholesale_stock_keeping_unit_order_wholesale_id | Unknown | PK, FK |
| serial_number | Unknown |  |

### order_wholesale_stock_keeping_unit

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_wholesale_id | Unknown | PK, FK |
| description | Unknown |  |
| quantity | Unknown |  |
| stock_keeping_unit | Unknown |  |

### order_wholesale

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| comment | Unknown |  |
| customer_address_1 | Unknown |  |
| customer_address_2 | Unknown |  |
| customer_address_3 | Unknown |  |
| customer_city | Unknown |  |
| customer_company | Unknown |  |
| customer_country | Unknown |  |
| customer_email | Unknown |  |
| customer_name | Unknown |  |
| customer_postal_code | Unknown |  |
| customer_state_or_province | Unknown |  |
| date_backordered | Unknown |  |
| date_created | Unknown |  |
| phone_number | Unknown |  |
| reference_number | Unknown |  |
| shipping_method | Unknown |  |
| status_description | Unknown |  |
| type | Unknown |  |
| warehouse_name | Unknown |  |

### backorder_business_stock_keeping_unit_item_lot

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| backorder_business_stock_keeping_unit_backorder_business_id | Unknown | PK, FK |
| backorder_business_stock_keeping_unit_index | Unknown | PK, FK |
| expiration_date | Unknown |  |
| lot_number | Unknown |  |
| quantity | Unknown |  |

### backorder_business_stock_keeping_unit_serial_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| backorder_business_stock_keeping_unit_backorder_business_id | Unknown | PK, FK |
| backorder_business_stock_keeping_unit_index | Unknown | PK, FK |
| serial_number | Unknown |  |

### backorder_business_stock_keeping_unit

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| backorder_business_id | Unknown | PK, FK |
| description | Unknown |  |
| quantity | Unknown |  |
| stock_keeping_unit | Unknown |  |

### backorder_business

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| comment | Unknown |  |
| customer_address_1 | Unknown |  |
| customer_address_2 | Unknown |  |
| customer_address_3 | Unknown |  |
| customer_city | Unknown |  |
| customer_company | Unknown |  |
| customer_country | Unknown |  |
| customer_email | Unknown |  |
| customer_name | Unknown |  |
| customer_phone_number | Unknown |  |
| customer_postal_code | Unknown |  |
| customer_state_or_province | Unknown |  |
| date_backordered | Unknown |  |
| date_created | Unknown |  |
| reference_number | Unknown |  |
| shipping_method | Unknown |  |
| type | Unknown |  |
| warehouse_name | Unknown |  |

## Relationships

- advance_shipping_notice_item(advance_shipping_notice_id) → advance_shipping_notice(id)
- item_available_inventory_lot_detail(item_available_inventory_index) → item_available_inventory(index)
- item_available_inventory_lot_detail(_fivetran_id) → item_available_inventory(_fivetran_id)
- item_available_inventory(_fivetran_id) → item(_fivetran_id)
- item_lot_number(_fivetran_id) → item(_fivetran_id)
- item(hs_code_id) → hs_code(id)
- order_business_stock_keeping_unit_item_lot(order_business_stock_keeping_unit_index) → order_business_stock_keeping_unit(index)
- order_business_stock_keeping_unit_item_lot(order_business_stock_keeping_unit_order_business_id) → order_business_stock_keeping_unit(order_business_id)
- order_business_stock_keeping_unit_serial_number(order_business_stock_keeping_unit_index) → order_business_stock_keeping_unit(index)
- order_business_stock_keeping_unit_serial_number(order_business_stock_keeping_unit_order_business_id) → order_business_stock_keeping_unit(order_business_id)
- order_business_stock_keeping_unit(order_business_id) → order_business(id)
- backorder_dropship_stock_keeping_unit_item_lot(backorder_dropship_stock_keeping_unit_index) → backorder_dropship_stock_keeping_unit(index)
- backorder_dropship_stock_keeping_unit_item_lot(backorder_dropship_stock_keeping_unit_backorder_dropship_id) → backorder_dropship_stock_keeping_unit(backorder_dropship_id)
- backorder_dropship_stock_keeping_unit_serial_number(backorder_dropship_stock_keeping_unit_index) → backorder_dropship_stock_keeping_unit(index)
- backorder_dropship_stock_keeping_unit_serial_number(backorder_dropship_stock_keeping_unit_backorder_dropship_id) → backorder_dropship_stock_keeping_unit(backorder_dropship_id)
- backorder_dropship_stock_keeping_unit(backorder_dropship_id) → backorder_dropship(id)
- order_dropship_stock_keeping_unit_item_lot(order_dropship_stock_keeping_unit_index) → order_dropship_stock_keeping_unit(index)
- order_dropship_stock_keeping_unit_item_lot(order_dropship_stock_keeping_unit_order_dropship_id) → order_dropship_stock_keeping_unit(order_dropship_id)
- order_dropship_stock_keeping_unit_serial_number(order_dropship_stock_keeping_unit_index) → order_dropship_stock_keeping_unit(index)
- order_dropship_stock_keeping_unit_serial_number(order_dropship_stock_keeping_unit_order_dropship_id) → order_dropship_stock_keeping_unit(order_dropship_id)
- order_dropship_stock_keeping_unit(order_dropship_id) → order_dropship(id)
- order_consumer_stock_keeping_unit_item_lot(order_consumer_stock_keeping_unit_index) → order_consumer_stock_keeping_unit(index)
- order_consumer_stock_keeping_unit_item_lot(order_consumer_stock_keeping_unit_order_consumer_id) → order_consumer_stock_keeping_unit(order_consumer_id)
- order_consumer_stock_keeping_unit_serial_number(order_consumer_stock_keeping_unit_index) → order_consumer_stock_keeping_unit(index)
- order_consumer_stock_keeping_unit_serial_number(order_consumer_stock_keeping_unit_order_consumer_id) → order_consumer_stock_keeping_unit(order_consumer_id)
- order_consumer_stock_keeping_unit(order_consumer_id) → order_consumer(id)
- backorder_consumer_stock_keeping_unit_item_lot(backorder_consumer_stock_keeping_unit_index) → backorder_consumer_stock_keeping_unit(index)
- backorder_consumer_stock_keeping_unit_item_lot(backorder_consumer_stock_keeping_unit_backorder_consumer_id) → backorder_consumer_stock_keeping_unit(backorder_consumer_id)
- backorder_consumer_stock_keeping_unit_serial_number(backorder_consumer_stock_keeping_unit_index) → backorder_consumer_stock_keeping_unit(index)
- backorder_consumer_stock_keeping_unit_serial_number(backorder_consumer_stock_keeping_unit_backorder_consumer_id) → backorder_consumer_stock_keeping_unit(backorder_consumer_id)
- backorder_consumer_stock_keeping_unit(backorder_consumer_id) → backorder_consumer(id)
- backorder_wholesale_stock_keeping_unit_item_lot(backorder_wholesale_stock_keeping_unit_index) → backorder_wholesale_stock_keeping_unit(index)
- backorder_wholesale_stock_keeping_unit_item_lot(backorder_wholesale_stock_keeping_unit_backorder_wholesale_id) → backorder_wholesale_stock_keeping_unit(backorder_wholesale_id)
- backorder_wholesale_stock_keeping_unit_serial_number(backorder_wholesale_stock_keeping_unit_index) → backorder_wholesale_stock_keeping_unit(index)
- backorder_wholesale_stock_keeping_unit_serial_number(backorder_wholesale_stock_keeping_unit_backorder_wholesale_id) → backorder_wholesale_stock_keeping_unit(backorder_wholesale_id)
- backorder_wholesale_stock_keeping_unit(backorder_wholesale_id) → backorder_wholesale(id)
- order_wholesale_stock_keeping_unit_item_lot(order_wholesale_stock_keeping_unit_index) → order_wholesale_stock_keeping_unit(index)
- order_wholesale_stock_keeping_unit_item_lot(order_wholesale_stock_keeping_unit_order_wholesale_id) → order_wholesale_stock_keeping_unit(order_wholesale_id)
- order_wholesale_stock_keeping_unit_serial_number(order_wholesale_stock_keeping_unit_index) → order_wholesale_stock_keeping_unit(index)
- order_wholesale_stock_keeping_unit_serial_number(order_wholesale_stock_keeping_unit_order_wholesale_id) → order_wholesale_stock_keeping_unit(order_wholesale_id)
- order_wholesale_stock_keeping_unit(order_wholesale_id) → order_wholesale(id)
- backorder_business_stock_keeping_unit_item_lot(backorder_business_stock_keeping_unit_index) → backorder_business_stock_keeping_unit(index)
- backorder_business_stock_keeping_unit_item_lot(backorder_business_stock_keeping_unit_backorder_business_id) → backorder_business_stock_keeping_unit(backorder_business_id)
- backorder_business_stock_keeping_unit_serial_number(backorder_business_stock_keeping_unit_index) → backorder_business_stock_keeping_unit(index)
- backorder_business_stock_keeping_unit_serial_number(backorder_business_stock_keeping_unit_backorder_business_id) → backorder_business_stock_keeping_unit(backorder_business_id)
- backorder_business_stock_keeping_unit(backorder_business_id) → backorder_business(id)