ShipMonk
Explore the interactive ERD
Table & Field Reference
receiving_item_detail
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
receiving_id | Unknown | PKFK |
receiving_item_index | Unknown | PKFK |
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 | PKFK |
product_id | Unknown |
receiving_line
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
receiving_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
return_item_index | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
product_inventory_location_index | Unknown | PKFK |
lot_expiration_date | Unknown | |
lot_number | Unknown | |
region | Unknown |
product_inventory_location
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
product_id | Unknown | PKFK |
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 | PKFK |
hs_code | Unknown | |
region | Unknown |
product_barcode
| Column | Type | Keys |
|---|---|---|
barcode | Unknown | PK |
product_id | Unknown | PKFK |
product_bundle
| Column | Type | Keys |
|---|---|---|
bundle_sku | Unknown | PK |
product_id | Unknown | PKFK |
products | Json |
product_handling_unit
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
product_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
order_item_index | Unknown | PKFK |
order_item_product_index | Unknown | PKFK |
expiration_date | Unknown | |
number | Unknown |
order_item_product
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
order_id | Unknown | PKFK |
order_item_index | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
order_package_index | Unknown | PKFK |
identifier | Unknown | |
type | Unknown |
order_package_packed_product_lot
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
order_id | Unknown | PKFK |
order_package_packed_product_index | Unknown | PKFK |
order_package_packed_product_order_package_index | Unknown | PKFK |
expiration_date | Unknown | |
number | Unknown |
order_package_packed_product
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
order_id | Unknown | PKFK |
order_package_index | Unknown | PKFK |
quantity | Unknown | |
sku | Unknown |
order_package_packed_item
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
order_id | Unknown | PKFK |
order_package_index | Unknown | PKFK |
line_key | Unknown | |
quantity | Unknown | |
sku | Unknown |
order_package
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
order_id | Unknown | PKFK |
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 | PKFK |
name | Unknown | |
value | Unknown |
order_reference
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
order_id | Unknown | PKFK |
type | Unknown | |
value | Unknown |
order_special_requirement_carton_label
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
order_id | Unknown | PKFK |
name | Unknown | |
url | Unknown |
order_special_requirement_additional_document
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
order_id | Unknown | PKFK |
name | Unknown | |
url | Unknown |
order_extra_data
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
order_id | Unknown | PKFK |
label | Unknown | |
value | Unknown |
order_serial_number
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
order_id | Unknown | PKFK |
line_key | Unknown | |
serial_numbers | Json |
order_return
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
order_id | Unknown | PKFK |
rma | Unknown | FK |
order_custom_data
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
order_id | Unknown | PKFK |
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 |