Fulfil

Explore the interactive ERD

Table & Field Reference

shipment_move

Column	Type	Keys
`move_id`	Unknown	PK
`shipment_id`	Unknown	PKFK

shipment_package

Column	Type	Keys
`package_id`	Unknown	PK
`shipment_id`	Unknown	PKFK

shipment_available_carrier_service

Column	Type	Keys
`available_carrier_service_id`	Unknown	PK
`shipment_id`	Unknown	PKFK

shipment_channel

Column	Type	Keys
`channel_id`	Unknown	PK
`shipment_id`	Unknown	PKFK

shipment_inventory_moves

Column	Type	Keys
`inventory_moves_id`	Unknown	PK
`shipment_id`	Unknown	PKFK

shipment_outgoing_moves

Column	Type	Keys
`outgoing_moves_id`	Unknown	PK
`shipment_id`	Unknown	PKFK

shipment_invoice

Column	Type	Keys
`invoice_id`	Unknown	PK
`shipment_id`	Unknown	PKFK

shipment_metafield

Column	Type	Keys
`id`	Unknown	PK
`shipment_id`	Unknown	PKFK
`field_code`	Unknown
`field_id`	Unknown
`field_type`	Unknown
`value_code`	Unknown
`value_id`	Unknown
`value_type`	Unknown

shipment_root_pacakage

Column	Type	Keys
`root_packages_id`	Unknown	PK
`shipment_id`	Unknown	PKFK

shipment_sale

Column	Type	Keys
`sale_id`	Unknown	PKFK
`shipment_id`	Unknown	PKFK

shipment

Column	Type	Keys
`id`	Unknown	PK
`acknowledged_at`	Unknown
`acknowledged_by`	Unknown
`acknowledged_by_3_p_l_at`	Unknown
`aes_itn`	Unknown
`assigned_by`	Unknown
`assigned_time`	Json
`attachments`	Json
`avg_cycle_time`	Json
`avg_cycle_time_cache`	Unknown
`bin_transfers`	Json
`carrier`	Unknown
`carrier_billing_account`	Unknown
`carrier_cost_method`	Unknown
`carrier_duties_account`	Unknown
`carrier_service`	Unknown
`channel_carrier_service_code`	Unknown
`channel_logo_url`	Unknown
`company`	Unknown
`consumable_moves`	Unknown
`consumables_cost`	Json
`consumables_cost_cache`	Json
`contact_categories`	Json
`contents_explanation`	Unknown
`contents_type`	Unknown
`cost`	Unknown
`cost_currency`	Unknown
`cost_currency_digits`	Unknown
`cost_invoice_line`	Unknown
`create_date`	Json
`create_return_label`	Unknown
`create_uid`	Unknown
`customer`	Unknown
`customer_location`	Unknown
`customs_items`	Json
`default_box_type`	Unknown
`delivery_address`	Unknown
`delivery_mode`	Unknown
`done_by`	Unknown
`duties_tax_id`	Unknown
`duties_tax_id_type`	Unknown
`eel_pfc`	Unknown
`effective_date`	Json
`eori_number`	Unknown
`fedex_saturday_delivery`	Unknown
`full_delivery_address`	Unknown
`gift_message`	Unknown
`has_gift_message`	Unknown
`hold_reason`	Unknown
`importer_of_record_address`	Unknown
`importer_of_record_contact`	Unknown
`importer_of_record_tax_identifiers`	Json
`incoterm`	Unknown
`insurance_amount`	Unknown
`is_international_shipping`	Unknown
`is_shippo`	Unknown
`last_modification`	Json
`license_plates`	Json
`messages`	Json
`metadata`	Unknown
`non_delivery_option`	Unknown
`number`	Unknown
`on_hold`	Unknown
`on_hold_until`	Unknown
`order_confirmation_time`	Json
`order_numbers`	Unknown
`order_references`	Unknown
`origins`	Unknown
`override_sscc`	Unknown
`packed_at`	Json
`packed_by`	Unknown
`packer`	Unknown
`payment_status`	Unknown
`payment_transactions`	Json
`picked_at`	Json
`picked_date`	Unknown
`picker`	Unknown
`picking_started_at`	Unknown
`picking_status`	Unknown
`picking_zones`	Json
`planned_date`	Json
`planned_datetime`	Json
`planned_time`	Unknown
`priority`	Unknown
`private_notes`	Json
`productions`	Unknown
`public_notes`	Json
`rec_blurb_description`	Unknown
`rec_blurb_fields`	Json
`rec_blurb_subtitle`	Json
`rec_blurb_thumbnail_url`	Unknown
`rec_blurb_title`	Unknown
`rec_name`	Unknown
`reference`	Unknown
`request_confirmation`	Unknown
`requested_delivery_date`	Unknown
`requested_shipping_service`	Unknown
`require_customs`	Unknown
`sale_date`	Json
`sent_to_3_p_l_at`	Unknown
`shipped_at`	Json
`shipper`	Unknown
`shipping_batch`	Unknown
`shipping_instructions`	Unknown
`shipping_label_date`	Unknown
`shipping_label_printed`	Unknown
`shipping_manifest`	Unknown
`sscc_code`	Unknown
`state`	Unknown
`subtitle`	Json
`tasks`	Json
`tax_id`	Unknown
`title`	Unknown
`total_amount_ccy`	Json
`total_cost`	Json
`total_customs_value`	Unknown
`total_item_cost_ccy`	Json
`total_quantity`	Unknown
`tpl`	Unknown
`tpl_reference`	Unknown
`tpl_status`	Unknown
`tracking_export_status`	Unknown
`tracking_number`	Unknown
`trading_partner`	Unknown
`tsv`	Unknown
`ups_saturday_delivery`	Unknown
`warehouse`	Unknown
`warehouse_output`	Unknown
`warehouse_storage`	Unknown
`weight`	Unknown
`weight_digits`	Unknown
`weight_uom`	Unknown
`weight_uom_symbol`	Unknown
`workflow`	Unknown
`workstation`	Unknown
`write_date`	Json
`write_uid`	Unknown

shipment_return_move

Column	Type	Keys
`move_id`	Unknown	PK
`shipment_return_id`	Unknown	PKFK

shipment_return

Column	Type	Keys
`id`	Unknown	PK
`assigned_by`	Unknown
`attachments`	Json
`company`	Unknown
`create_date`	Json
`create_uid`	Unknown
`delivery_address`	Unknown
`done_by`	Unknown
`effective_date`	Json
`from_location`	Unknown
`license_plates`	Json
`messages`	Json
`metadata`	Unknown
`metafields`	Json
`number`	Unknown
`origins`	Unknown
`planned_date`	Unknown
`private_notes`	Json
`public_notes`	Json
`rec_blurb_description`	Unknown
`rec_blurb_field`	Json
`rec_blurb_subtitle`	Json
`rec_blurb_thumbnail_url`	Unknown
`rec_blurb_title`	Unknown
`rec_name`	Unknown
`reference`	Unknown
`state`	Unknown
`supplier`	Unknown
`to_location`	Unknown
`write_date`	Json
`write_uid`	Unknown

sales_order_message_button

Column	Type	Keys
`id`	Unknown	PK
`sales_order_id`	Unknown	PKFK
`sales_order_message_index`	Unknown	PKFK
`action`	Unknown
`active`	Unknown
`context`	Unknown
`create_uid`	Unknown
`email`	Unknown
`groups`	Json
`icon`	Unknown
`icon_rec_name`	Unknown
`keywords`	Json
`model`	Unknown
`name`	Unknown
`rec_name`	Unknown
`string`	Unknown
`type`	Unknown
`usage`	Unknown
`window`	Unknown
`wiz_name`	Unknown
`write_uid`	Unknown

sales_order_message

Column	Type	Keys
`index`	Unknown	PK
`sales_order_id`	Unknown	PKFK
`description`	Unknown
`title`	Unknown
`type`	Unknown

sales_order_line

Column	Type	Keys
`line_id`	Unknown	PK
`sales_order_id`	Unknown	PKFK

sales_order_payment

Column	Type	Keys
`payment_id`	Unknown	PK
`sales_order_id`	Unknown	PKFK

sales_order

Column	Type	Keys
`id`	Unknown	PK
`access_token`	Unknown
`account_class_allocation_template`	Unknown
`acknowledged_at`	Unknown
`acknowledgement_status`	Unknown
`amount_invoiced`	Json
`attachments`	Json
`available_carrier_services`	Json
`bundle_explosion_method`	Unknown
`carrier`	Unknown
`carrier_cost_method`	Unknown
`carrier_service`	Unknown
`channel`	Unknown
`channel_identifier`	Unknown
`channel_segment`	Unknown
`channel_tax_amount`	Unknown
`channel_type`	Unknown
`cogs_account`	Unknown
`comment`	Unknown
`company`	Unknown
`company_currency_digits`	Unknown
`confirmation_time`	Unknown
`cost_center_allocation_template`	Unknown
`create_date`	Json
`create_uid`	Unknown
`credit`	Json
`currency`	Unknown
`currency_digits`	Unknown
`currency_symbol`	Unknown
`description`	Unknown
`drop_location`	Unknown
`drop_shipments`	Json
`dropship_order_reference`	Unknown
`edi_attributes`	Unknown
`end_customer_order_reference`	Unknown
`error_message`	Unknown
`exceptions`	Json
`exchange_rate`	Unknown
`external_url`	Unknown
`gateway_transactions`	Json
`gift_card_method`	Unknown
`gift_message`	Unknown
`guest_access_code`	Unknown
`has_channel_exception`	Unknown
`has_line_with_discount`	Unknown
`has_return`	Unknown
`integration`	Unknown
`invoice_address`	Unknown
`invoice_method`	Unknown
`invoice_state`	Unknown
`invoices`	Json
`invoices_ignored`	Json
`invoices_recreated`	Json
`is_cart`	Unknown
`is_international_shipping`	Unknown
`is_recently_active`	Unknown
`last_modification`	Json
`manual_account_class`	Unknown
`manual_cost_center`	Unknown
`metafields`	Json
`moves`	Json
`number`	Unknown
`origin`	Unknown
`party`	Unknown
`party_lang`	Unknown
`payment_authorize_on`	Unknown
`payment_authorized`	Json
`payment_available`	Json
`payment_capture_on`	Unknown
`payment_captured`	Json
`payment_collected`	Json
`payment_processing_state`	Unknown
`payment_term`	Unknown
`payment_total`	Json
`price_list`	Unknown
`priority`	Unknown
`private_notes`	Json
`promotion`	Unknown
`public_notes`	Json
`rec_blurb_description`	Unknown
`rec_blurb_field`	Json
`rec_blurb_subtitle`	Json
`rec_blurb_thumbnail_url`	Unknown
`rec_blurb_title`	Unknown
`reference`	Unknown
`requested_shipping_service`	Unknown
`sale_date`	Unknown
`sales_person`	Unknown
`shipment_address`	Unknown
`shipment_cost_markup`	Unknown
`shipment_cost_method`	Unknown
`shipment_method`	Unknown
`shipment_party`	Unknown
`shipment_returns`	Json
`shipment_state`	Unknown
`shipments`	Json
`shipping_account`	Unknown
`shipping_cost_computation`	Unknown
`shipping_end_date`	Unknown
`shipping_instructions`	Unknown
`shipping_start_date`	Unknown
`state`	Unknown
`tax_amount_cache`	Unknown
`tax_amount_cpny_ccy_cache`	Unknown
`tax_identifiers`	Json
`taxability_status`	Unknown
`total_amount_cache`	Unknown
`total_amount_cpny_ccy_cache`	Unknown
`total_quantity`	Unknown
`total_quantity_uom`	Unknown
`trading_partner`	Unknown
`tsv`	Unknown
`untaxed_amount_cache`	Unknown
`untaxed_amount_cpny_ccy_cache`	Unknown
`warehouse`	Unknown
`weight`	Unknown
`weight_digits`	Unknown
`weight_uom`	Unknown
`weight_uom_symbol`	Unknown
`write_date`	Json
`write_uid`	Unknown