ShipNetwork
Explore the interactive ERD
Table & Field Reference
advance_shipping_notice_item
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
advance_shipping_notice_id | Unknown | PKFK |
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 | PKFK |
item_available_inventory_index | Unknown | PKFK |
lot_number | Unknown | |
quantity | Unknown |
item_available_inventory
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
_fivetran_id | Unknown | PKFK |
available_inventory_quantity | Unknown | |
warehouse_name | Unknown |
item_lot_number
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
_fivetran_id | Unknown | PKFK |
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 | PKFK |
order_business_stock_keeping_unit_order_business_id | Unknown | PKFK |
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 | PKFK |
order_business_stock_keeping_unit_order_business_id | Unknown | PKFK |
serial_number | Unknown |
order_business_stock_keeping_unit
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
order_business_id | Unknown | PKFK |
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 | PKFK |
backorder_dropship_stock_keeping_unit_index | Unknown | PKFK |
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 | PKFK |
backorder_dropship_stock_keeping_unit_index | Unknown | PKFK |
serial_number | Unknown |
backorder_dropship_stock_keeping_unit
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
backorder_dropship_id | Unknown | PKFK |
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 | PKFK |
order_dropship_stock_keeping_unit_order_dropship_id | Unknown | PKFK |
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 | PKFK |
order_dropship_stock_keeping_unit_order_dropship_id | Unknown | PKFK |
serial_number | Unknown |
order_dropship_stock_keeping_unit
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
order_dropship_id | Unknown | PKFK |
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 | PKFK |
order_consumer_stock_keeping_unit_order_consumer_id | Unknown | PKFK |
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 | PKFK |
order_consumer_stock_keeping_unit_order_consumer_id | Unknown | PKFK |
serial_number | Unknown |
order_consumer_stock_keeping_unit
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
order_consumer_id | Unknown | PKFK |
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 | PKFK |
backorder_consumer_stock_keeping_unit_index | Unknown | PKFK |
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 | PKFK |
backorder_consumer_stock_keeping_unit_index | Unknown | PKFK |
serial_number | Unknown |
backorder_consumer_stock_keeping_unit
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
backorder_consumer_id | Unknown | PKFK |
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 | PKFK |
backorder_wholesale_stock_keeping_unit_index | Unknown | PKFK |
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 | PKFK |
backorder_wholesale_stock_keeping_unit_index | Unknown | PKFK |
serial_number | Unknown |
backorder_wholesale_stock_keeping_unit
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
backorder_wholesale_id | Unknown | PKFK |
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 | PKFK |
order_wholesale_stock_keeping_unit_order_wholesale_id | Unknown | PKFK |
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 | PKFK |
order_wholesale_stock_keeping_unit_order_wholesale_id | Unknown | PKFK |
serial_number | Unknown |
order_wholesale_stock_keeping_unit
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
order_wholesale_id | Unknown | PKFK |
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 | PKFK |
backorder_business_stock_keeping_unit_index | Unknown | PKFK |
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 | PKFK |
backorder_business_stock_keeping_unit_index | Unknown | PKFK |
serial_number | Unknown |
backorder_business_stock_keeping_unit
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
backorder_business_id | Unknown | PKFK |
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 |