# ShipMonk schema ERD

Table and field reference for the Fivetran ShipMonk connector.

## Table & Field Reference

### receiving_item_detail

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| receiving_id | Unknown | PK, FK |
| receiving_item_index | Unknown | PK, FK |
| expected_quantity | Unknown |  |
| line_key | Unknown |  |
| lot | Unknown |  |
| received_at | Unknown |  |
| received_quantity | Unknown |  |

### receiving_item

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| receiving_id | Unknown | PK, FK |
| product_id | Unknown |  |

### receiving_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| receiving_id | Unknown | PK, FK |
| product_id | Unknown | FK |
| expected_quantity | Unknown |  |
| line_key | Unknown |  |
| lot | Unknown |  |
| received_quantity | Unknown |  |

### receiving_custom_data

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| receiving_id | Unknown | PK, FK |
| name | Unknown |  |
| value | Json |  |

### receiving

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| warehouse | Unknown | FK |
| arrived_at | Unknown |  |
| asn | Unknown |  |
| bol_number | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| estimated_delivery | Unknown |  |
| handling_unit_quantity | Unknown |  |
| handling_unit_type | Unknown |  |
| received_at | Unknown |  |
| receiving_key | Unknown |  |
| status | Unknown |  |
| supplier_name | Unknown |  |
| updated_at | Unknown |  |

### warehouse

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| address_city | Unknown |  |
| address_company | Unknown |  |
| address_country | Unknown |  |
| address_name | Unknown |  |
| address_phone | Unknown |  |
| address_postal_code | Unknown |  |
| address_residential | Unknown |  |
| address_state | Unknown |  |
| address_street_1 | Unknown |  |
| address_street_2 | Unknown |  |
| address_street_3 | Unknown |  |
| address_verified | Unknown |  |
| enabled | Unknown |  |
| identifier | Unknown |  |
| name | Unknown |  |
| timezone | Unknown |  |
| warehouse_wms_type | Unknown |  |

### receipt

| Column | Type | Keys |
| --- | --- | --- |
| receipt_id | Unknown | PK |
| receiving_id | Unknown | FK |
| receipt_completed_at | Unknown |  |
| receipt_created_at | Instant |  |

### return_item_receiving_detail

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| return_id | Unknown | PK, FK |
| return_item_index | Unknown | PK, FK |
| expected_quantity | Unknown |  |
| final_disposition | Unknown |  |
| lot_expiration_date | Unknown |  |
| lot_number | Unknown |  |
| received_at | Unknown |  |
| received_quantity | Unknown |  |
| type | Unknown |  |
| type_scoped_id | Unknown |  |

### return_item

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| return_id | Unknown | PK, FK |
| product_id | Unknown | FK |
| desired_action | Unknown |  |
| expected_quantity | Unknown |  |
| received_quantity | Unknown |  |

### return_custom_data

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| return_id | Unknown | PK, FK |
| name | Unknown |  |
| value | Json |  |

### return

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| order_key | Unknown | FK |
| warehouse | Unknown | FK |
| created_at | Unknown |  |
| note | Unknown |  |
| received_at | Unknown |  |
| return_reason | Unknown |  |
| rma | Unknown |  |
| source | Unknown |  |
| status | Unknown |  |
| store_id | Unknown |  |
| tracking_number | Unknown |  |
| updated_at | Instant |  |

### product_inventory_location_quantity_by_lot

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| product_id | Unknown | PK, FK |
| product_inventory_location_index | Unknown | PK, FK |
| lot_expiration_date | Unknown |  |
| lot_number | Unknown |  |
| region | Unknown |  |

### product_inventory_location

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| product_id | Unknown | PK, FK |
| warehouse_id | Unknown | FK |
| quantity_available | Unknown |  |
| quantity_final | Unknown |  |
| quantity_on_hand | Unknown |  |
| quantity_unavailable | Unknown |  |
| quarantined_quantity | Unknown |  |

### product_hs_code

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| product_id | Unknown | PK, FK |
| hs_code | Unknown |  |
| region | Unknown |  |

### product_barcode

| Column | Type | Keys |
| --- | --- | --- |
| barcode | Unknown | PK |
| product_id | Unknown | PK, FK |

### product_bundle

| Column | Type | Keys |
| --- | --- | --- |
| bundle_sku | Unknown | PK |
| product_id | Unknown | PK, FK |
| products | Json |  |

### product_handling_unit

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| product_id | Unknown | PK, FK |
| count | Unknown |  |
| dimension_height | Unknown |  |
| dimension_lenght | Unknown |  |
| dimension_unit | Unknown |  |
| dimension_width | Unknown |  |
| type | Unknown |  |
| weight_unit | Unknown |  |
| weight_value | Unknown |  |

### product_custom_data

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| product_id | Unknown | PK, FK |
| name | Unknown |  |
| value | Json |  |

### product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| country_code | Unknown |  |
| created_at | Unknown |  |
| dimension_height | Unknown |  |
| dimension_lenght | Unknown |  |
| dimension_unit | Unknown |  |
| dimension_width | Unknown |  |
| inventory_on_hand_last_updated_at | Unknown |  |
| is_active | Unknown |  |
| name | Unknown |  |
| replacement_cost | Unknown |  |
| replacement_cost_currency | Unknown |  |
| sku | Unknown |  |
| stock_out_days | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| weight_unit | Unknown |  |
| weight_value | Unknown |  |

### order_item_product_other_potential_lot

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_id | Unknown | PK, FK |
| order_item_index | Unknown | PK, FK |
| order_item_product_index | Unknown | PK, FK |
| expiration_date | Unknown |  |
| number | Unknown |  |

### order_item_product

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_id | Unknown | PK, FK |
| order_item_index | Unknown | PK, FK |
| backordered_quantity | Unknown |  |
| lot_expiration_date | Unknown |  |
| lot_number | Unknown |  |
| quantity | Unknown |  |
| sku | Unknown |  |

### order_item

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_id | Unknown | PK, FK |
| fulfilled_quantity | Unknown |  |
| image_url | Unknown |  |
| line_key | Unknown |  |
| name | Unknown |  |
| price | Unknown |  |
| quantity | Unknown |  |
| sku | Unknown |  |
| source | Unknown |  |

### order_package_carton_label

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_id | Unknown | PK, FK |
| order_package_index | Unknown | PK, FK |
| identifier | Unknown |  |
| type | Unknown |  |

### order_package_packed_product_lot

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_id | Unknown | PK, FK |
| order_package_packed_product_index | Unknown | PK, FK |
| order_package_packed_product_order_package_index | Unknown | PK, FK |
| expiration_date | Unknown |  |
| number | Unknown |  |

### order_package_packed_product

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_id | Unknown | PK, FK |
| order_package_index | Unknown | PK, FK |
| quantity | Unknown |  |
| sku | Unknown |  |

### order_package_packed_item

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_id | Unknown | PK, FK |
| order_package_index | Unknown | PK, FK |
| line_key | Unknown |  |
| quantity | Unknown |  |
| sku | Unknown |  |

### order_package

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_id | Unknown | PK, FK |
| box_number | Unknown |  |
| number | Unknown |  |
| packing_group_key | Unknown |  |
| packing_group_name | Unknown |  |
| pallet_number | Unknown |  |
| pallet_weight_lb_unit | Unknown |  |
| pallet_weight_lb_value | Unknown |  |
| tracking_number | Unknown |  |
| tracking_url | Unknown |  |
| weight_lb_unit | Unknown |  |
| weight_lb_value | Unknown |  |

### order_attribute

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_id | Unknown | PK, FK |
| name | Unknown |  |
| value | Unknown |  |

### order_reference

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_id | Unknown | PK, FK |
| type | Unknown |  |
| value | Unknown |  |

### order_special_requirement_carton_label

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_id | Unknown | PK, FK |
| name | Unknown |  |
| url | Unknown |  |

### order_special_requirement_additional_document

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_id | Unknown | PK, FK |
| name | Unknown |  |
| url | Unknown |  |

### order_extra_data

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_id | Unknown | PK, FK |
| label | Unknown |  |
| value | Unknown |  |

### order_serial_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_id | Unknown | PK, FK |
| line_key | Unknown |  |
| serial_numbers | Json |  |

### order_return

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_id | Unknown | PK, FK |
| rma | Unknown | FK |

### order_custom_data

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_id | Unknown | PK, FK |
| name | Unknown |  |
| value | Json |  |

### orders

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| warehouse_id | Unknown | FK |
| actions_required_address | Unknown |  |
| actions_required_at_risk | Unknown |  |
| actions_required_automation_rule | Unknown |  |
| actions_required_customs | Unknown |  |
| actions_required_freight_info | Unknown |  |
| actions_required_freight_quote | Unknown |  |
| actions_required_global_e_label | Unknown |  |
| actions_required_hs_code | Unknown |  |
| actions_required_item_mapping | Unknown |  |
| actions_required_pending_b_2_b_routing | Unknown |  |
| actions_required_routing | Unknown |  |
| actions_required_ship_monk_hazmat_carrier_service_not_available | Unknown |  |
| actions_required_ship_short | Unknown |  |
| actions_required_shipping_mapping | Unknown |  |
| actions_required_value_added_service_problem | Unknown |  |
| currency_code | Unknown |  |
| customer_email | Unknown |  |
| customer_notes | Unknown |  |
| gift_from | Unknown |  |
| gift_message | Unknown |  |
| main_order_number | Unknown |  |
| master_tracking_number | Unknown |  |
| number | Unknown |  |
| order_costs_estimated_packaging_material_charges_amount | Unknown |  |
| order_costs_estimated_packaging_material_charges_currency | Unknown |  |
| order_costs_estimated_pick_and_pack_charges_amount | Unknown |  |
| order_costs_estimated_pick_and_pack_charges_currency | Unknown |  |
| order_costs_estimated_shipping_related_charges_amount | Unknown |  |
| order_costs_estimated_shipping_related_charges_currency | Unknown |  |
| order_detail_url | Unknown |  |
| ordered_at | Unknown |  |
| processing_status | Unknown |  |
| recipient_tax_id_type | Unknown |  |
| recipient_tax_id_value | Unknown |  |
| recipient_tax_issuing_country_code | Unknown |  |
| recipient_tax_issuing_country_name | Unknown |  |
| requested_shipping_service | Unknown |  |
| ship_from_city | Unknown |  |
| ship_from_company | Unknown |  |
| ship_from_country_code | Unknown |  |
| ship_from_email | Unknown |  |
| ship_from_name | Unknown |  |
| ship_from_phone | Unknown |  |
| ship_from_residential | Unknown |  |
| ship_from_state | Unknown |  |
| ship_from_street_1 | Unknown |  |
| ship_from_street_2 | Unknown |  |
| ship_from_zip | Unknown |  |
| ship_to_city | Unknown |  |
| ship_to_company | Unknown |  |
| ship_to_country_code | Unknown |  |
| ship_to_email | Unknown |  |
| ship_to_name | Unknown |  |
| ship_to_phone | Unknown |  |
| ship_to_residential | Unknown |  |
| ship_to_state | Unknown |  |
| ship_to_street_1 | Unknown |  |
| ship_to_street_2 | Unknown |  |
| ship_to_zip | Unknown |  |
| shipment_data_authorization_number | Unknown |  |
| shipment_data_bill_of_lading_number | Unknown |  |
| shipment_data_carrier | Unknown |  |
| shipment_data_carrier_alpha_code | Unknown |  |
| shipment_data_carrier_tracking_url | Unknown |  |
| shipment_data_carrier_trans_method_code | Unknown |  |
| shipment_data_estimated_shipping_cost | Unknown |  |
| shipment_data_load_number | Unknown |  |
| shipment_data_master_bill_of_lading_number | Unknown |  |
| shipment_data_routing_key | Unknown |  |
| shipment_data_service | Unknown |  |
| shipped_at | Unknown |  |
| shipping_method_carrier_id | Unknown |  |
| shipping_method_carrier_name | Unknown |  |
| shipping_method_id | Unknown |  |
| shipping_method_name | Unknown |  |
| shipping_paid | Unknown |  |
| shipping_payment_terms | Unknown |  |
| size | Unknown |  |
| special_requirements_cancel_date | Unknown |  |
| special_requirements_delivery_date_earliest | Unknown |  |
| special_requirements_delivery_date_latest | Unknown |  |
| special_requirements_delivery_date_requested | Unknown |  |
| special_requirements_pack_list_required | Unknown |  |
| special_requirements_shipping_date_earliest | Unknown |  |
| special_requirements_shipping_date_latest | Unknown |  |
| special_requirements_shipping_date_requested | Unknown |  |
| special_requirements_shipping_label_url | Unknown |  |
| special_requirements_special_instruction | Unknown |  |
| status | Unknown |  |
| store_id | Unknown |  |
| store_name | Unknown |  |
| tax_id_type | Unknown |  |
| tax_id_value | Unknown |  |
| tax_issuing_country_code | Unknown |  |
| tax_issuing_country_name | Unknown |  |
| tax_paid | Unknown |  |
| tracking_url | Unknown |  |
| trading_partner_account_id | Unknown |  |
| trading_partner_account_name | Unknown |  |
| trading_partner_id | Unknown |  |
| trading_partner_identifier | Unknown |  |
| trading_partner_name | Unknown |  |
| type | Unknown |  |

## Relationships

- receiving_item_detail(receiving_item_index) → receiving_item(index)
- receiving_item_detail(receiving_id) → receiving_item(receiving_id)
- receiving_item(receiving_id) → receiving(id)
- receiving_line(product_id) → product(id)
- receiving_line(receiving_id) → receiving(id)
- receiving_custom_data(receiving_id) → receiving(id)
- receiving(warehouse) → warehouse(identifier)
- receipt(receiving_id) → receiving(id)
- return_item_receiving_detail(return_item_index) → return_item(index)
- return_item_receiving_detail(return_id) → return_item(return_id)
- return_item(product_id) → product(id)
- return_item(return_id) → return(id)
- return_custom_data(return_id) → return(id)
- return(warehouse) → warehouse(identifier)
- return(order_key) → orders(id)
- product_inventory_location_quantity_by_lot(product_inventory_location_index) → product_inventory_location(index)
- product_inventory_location_quantity_by_lot(product_id) → product_inventory_location(product_id)
- product_inventory_location(warehouse_id) → warehouse(id)
- product_inventory_location(product_id) → product(id)
- product_hs_code(product_id) → product(id)
- product_barcode(product_id) → product(id)
- product_bundle(product_id) → product(id)
- product_handling_unit(product_id) → product(id)
- product_custom_data(product_id) → product(id)
- order_item_product_other_potential_lot(order_item_index) → order_item_product(order_item_index)
- order_item_product_other_potential_lot(order_id) → order_item_product(order_id)
- order_item_product_other_potential_lot(order_item_product_index) → order_item_product(index)
- order_item_product(order_item_index) → order_item(index)
- order_item_product(order_id) → order_item(order_id)
- order_item(order_id) → orders(id)
- order_package_carton_label(order_id) → order_package(order_id)
- order_package_carton_label(order_package_index) → order_package(index)
- order_package_packed_product_lot(order_id) → order_package_packed_product(order_id)
- order_package_packed_product_lot(order_package_packed_product_index) → order_package_packed_product(index)
- order_package_packed_product_lot(order_package_packed_product_order_package_index) → order_package_packed_product(order_package_index)
- order_package_packed_product(order_id) → order_package(order_id)
- order_package_packed_product(order_package_index) → order_package(index)
- order_package_packed_item(order_id) → order_package(order_id)
- order_package_packed_item(order_package_index) → order_package(index)
- order_package(order_id) → orders(id)
- order_attribute(order_id) → orders(id)
- order_reference(order_id) → orders(id)
- order_special_requirement_carton_label(order_id) → orders(id)
- order_special_requirement_additional_document(order_id) → orders(id)
- order_extra_data(order_id) → orders(id)
- order_serial_number(order_id) → orders(id)
- order_return(rma) → return(rma)
- order_return(order_id) → orders(id)
- order_custom_data(order_id) → orders(id)
- orders(warehouse_id) → warehouse(id)