# Fulfil schema ERD

Table and field reference for the Fivetran Fulfil connector.

## Table & Field Reference

### shipment_move

| Column | Type | Keys |
| --- | --- | --- |
| move_id | Unknown | PK |
| shipment_id | Unknown | PK, FK |

### shipment_package

| Column | Type | Keys |
| --- | --- | --- |
| package_id | Unknown | PK |
| shipment_id | Unknown | PK, FK |

### shipment_available_carrier_service

| Column | Type | Keys |
| --- | --- | --- |
| available_carrier_service_id | Unknown | PK |
| shipment_id | Unknown | PK, FK |

### shipment_channel

| Column | Type | Keys |
| --- | --- | --- |
| channel_id | Unknown | PK |
| shipment_id | Unknown | PK, FK |

### shipment_inventory_moves

| Column | Type | Keys |
| --- | --- | --- |
| inventory_moves_id | Unknown | PK |
| shipment_id | Unknown | PK, FK |

### shipment_outgoing_moves

| Column | Type | Keys |
| --- | --- | --- |
| outgoing_moves_id | Unknown | PK |
| shipment_id | Unknown | PK, FK |

### shipment_invoice

| Column | Type | Keys |
| --- | --- | --- |
| invoice_id | Unknown | PK |
| shipment_id | Unknown | PK, FK |

### shipment_metafield

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| shipment_id | Unknown | PK, FK |
| 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 | PK, FK |

### shipment_sale

| Column | Type | Keys |
| --- | --- | --- |
| sale_id | Unknown | PK, FK |
| shipment_id | Unknown | PK, FK |

### 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 | PK, FK |

### 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 | PK, FK |
| sales_order_message_index | Unknown | PK, FK |
| 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 | PK, FK |
| description | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |

### sales_order_line

| Column | Type | Keys |
| --- | --- | --- |
| line_id | Unknown | PK |
| sales_order_id | Unknown | PK, FK |

### sales_order_payment

| Column | Type | Keys |
| --- | --- | --- |
| payment_id | Unknown | PK |
| sales_order_id | Unknown | PK, FK |

### 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 |  |

## Relationships

- shipment_move(shipment_id) → shipment(id)
- shipment_package(shipment_id) → shipment(id)
- shipment_available_carrier_service(shipment_id) → shipment(id)
- shipment_channel(shipment_id) → shipment(id)
- shipment_inventory_moves(shipment_id) → shipment(id)
- shipment_outgoing_moves(shipment_id) → shipment(id)
- shipment_invoice(shipment_id) → shipment(id)
- shipment_metafield(shipment_id) → shipment(id)
- shipment_root_pacakage(shipment_id) → shipment(id)
- shipment_sale(sale_id) → sales_order(id)
- shipment_sale(shipment_id) → shipment(id)
- shipment_return_move(shipment_return_id) → shipment_return(id)
- sales_order_message_button(sales_order_id) → sales_order_message(sales_order_id)
- sales_order_message_button(sales_order_message_index) → sales_order_message(index)
- sales_order_message(sales_order_id) → sales_order(id)
- sales_order_line(sales_order_id) → sales_order(id)
- sales_order_payment(sales_order_id) → sales_order(id)