# Flexport schema ERD

Table and field reference for the Fivetran Flexport connector.

## Table & Field Reference

### commercial_invoice_line_item

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| commercial_invoice_id | Unknown | FK |
| product_id | Unknown | FK |
| container_number | Unknown |  |
| document_line_number | Unknown |  |
| first_sale_value_amount | Unknown |  |
| first_sale_value_currency_code | Unknown |  |
| first_sale_value_object | Unknown |  |
| manufacturer_address | Unknown |  |
| manufacturer_name | Unknown |  |
| metadata | Json |  |
| net_net_weight_object | Unknown |  |
| net_net_weight_unit | Unknown |  |
| net_net_weight_value | Unknown |  |
| net_value_amount | Unknown |  |
| net_value_currency_code | Unknown |  |
| net_value_object | Unknown |  |
| net_weight_object | Unknown |  |
| net_weight_unit | Unknown |  |
| net_weight_value | Unknown |  |
| object | Unknown |  |
| po_line_item_number | Unknown |  |
| price_per_unit_amount | Unknown |  |
| price_per_unit_currency_code | Unknown |  |
| price_per_unit_object | Unknown |  |
| purchase_order_number | Unknown |  |
| total_units | Unknown |  |
| value_amount | Unknown |  |
| value_currency_code | Unknown |  |
| value_object | Unknown |  |
| volume_object | Unknown |  |
| volume_unit | Unknown |  |
| volume_value | Unknown |  |
| weight_object | Unknown |  |
| weight_unit | Unknown |  |
| weight_value | Unknown |  |

### commercial_invoice_involved_party

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| commercial_invoice_id | Unknown | FK |
| company_entity_id | Unknown | FK |
| mailing_city | Unknown |  |
| mailing_country | Unknown |  |
| mailing_country_code | Unknown |  |
| mailing_object | Unknown |  |
| mailing_ref | Unknown |  |
| mailing_state | Unknown |  |
| mailing_street_address | Unknown |  |
| mailing_street_address_2 | Unknown |  |
| mailing_timezone | Unknown |  |
| mailing_unlocode | Unknown |  |
| mailing_zip | Unknown |  |
| name | Unknown |  |
| object | Unknown |  |
| type | Unknown |  |

### commercial_invoice

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| shipment_id | Unknown | FK |
| currency | Unknown |  |
| digitization_status | Unknown |  |
| invoice_date | Unknown |  |
| invoice_number | Unknown |  |
| is_related_parties | Unknown |  |
| metadata | Json |  |
| object | Unknown |  |
| order_number | Unknown |  |
| total_unit_count | Unknown |  |
| total_value_amount | Unknown |  |
| total_value_currency_code | Unknown |  |
| total_value_object | Unknown |  |
| total_volume_object | Unknown |  |
| total_volume_unit | Unknown |  |
| total_volume_value | Unknown |  |
| total_weight_object | Unknown |  |
| total_weight_unit | Unknown |  |
| total_weight_value | Unknown |  |

### document

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| shipment_id | Unknown | FK |
| archived_at | Unknown |  |
| document_type | Unknown |  |
| file_link | Unknown |  |
| file_metadata_object | Unknown |  |
| file_metadata_size | Unknown |  |
| file_metadata_uploaded_at | Unknown |  |
| file_name | Unknown |  |
| memo | Unknown |  |
| object | Unknown |  |

### container_leg_date

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| container_leg_id | Unknown | FK |
| actual_loaded_on_board_date | Unknown |  |

### container_leg

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| container_id | Unknown | FK |
| shipment_leg_id | Unknown | FK |
| object | Unknown |  |

### shipment_leg

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| actual_arrival_date | Unknown |  |
| actual_departure_date | Unknown |  |
| additional_cargo_ready_date | Unknown |  |
| additional_delivery_appointment_requested_at_date | Unknown |  |
| additional_delivery_appointment_requested_date | Unknown |  |
| additional_delivery_appointment_scheduled_at_date | Unknown |  |
| additional_delivery_appointment_scheduled_date | Unknown |  |
| additional_delivery_completed | Unknown |  |
| additional_loaded_on_truck_date | Unknown |  |
| air_leg_flight_number | Unknown |  |
| air_leg_iata_code | Unknown |  |
| air_leg_icao_code | Unknown |  |
| air_leg_object | Unknown |  |
| cargo_ready_date | Unknown |  |
| carrier_name | Unknown |  |
| container_leg_link | Unknown |  |
| container_leg_object | Unknown |  |
| deleted_at | Unknown |  |
| destination_object | Unknown |  |
| destination_place_name | Unknown |  |
| destination_place_object | Unknown |  |
| destination_terminal | Unknown |  |
| destination_terminal_firms_code | Unknown |  |
| destination_terminal_name | Unknown |  |
| destination_terminal_object | Unknown |  |
| estimated_arrival_date | Unknown |  |
| estimated_departure_date | Unknown |  |
| object | Unknown |  |
| ocean_leg_container_legs_link | Unknown |  |
| ocean_leg_container_legs_object | Unknown |  |
| ocean_leg_object | Unknown |  |
| ocean_leg_scac_code | Unknown |  |
| ocean_leg_vessel_imo | Unknown |  |
| ocean_leg_vessel_name | Unknown |  |
| ocean_leg_voyage_number | Unknown |  |
| origin_object | Unknown |  |
| origin_place_name | Unknown |  |
| origin_place_object | Unknown |  |
| origin_terminal_firms_code | Unknown |  |
| origin_terminal_name | Unknown |  |
| origin_terminal_object | Unknown |  |
| rail_leg_container_legs_link | Unknown |  |
| rail_leg_container_legs_object | Unknown |  |
| rail_leg_object | Unknown |  |
| shipment_id | Unknown |  |
| transportation_mode | Unknown |  |
| trucking_leg_container_less_leg_link | Unknown |  |
| trucking_leg_container_less_object | Unknown |  |
| trucking_leg_object | Unknown |  |
| trucking_leg_pieces | Unknown |  |
| trucking_leg_scac_code | Unknown |  |
| trucking_leg_service_type | Unknown |  |
| trucking_leg_tracking_number | Unknown |  |

### tags

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| shipment_leg_id | Unknown | FK |
| tags | Unknown |  |
| type | Unknown |  |

### detail

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| parent_id | Unknown | FK |
| country_code | Unknown |  |
| detail_type | Unknown |  |
| iata_code | Unknown |  |
| icao_code | Unknown |  |
| manufacturer_code | Unknown |  |
| object | Unknown |  |
| port_code | String |  |

### address

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| parent_id | Unknown | FK |
| address_type | Unknown |  |
| city | Unknown |  |
| country | Unknown |  |
| country_code | Unknown |  |
| object | Unknown |  |
| ref | Unknown |  |
| state | Unknown |  |
| street_address | Unknown |  |
| street_address_2 | Unknown |  |
| timezone | Unknown |  |
| unlocode | Unknown |  |
| zip | Unknown |  |

### company_entity_company

| Column | Type | Keys |
| --- | --- | --- |
| company_entity_id | Unknown | PK, FK |
| company_id | Unknown | PK, FK |

### company

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_link | Unknown |  |
| contact_object | Unknown |  |
| editable | Unknown |  |
| location_link | Unknown |  |
| location_object | Unknown |  |
| metadata | Json |  |
| name | Unknown |  |
| object | Unknown |  |
| ref | Unknown |  |

### purchase_order_party_contact

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| purchase_order_party_company_entity_id | Unknown | FK |
| purchase_order_party_purchase_order_id | Unknown | FK |
| department | Unknown |  |
| email | Unknown |  |
| fax | Unknown |  |
| name | Unknown |  |
| object | Unknown |  |
| phone | Unknown |  |

### purchase_order_party

| Column | Type | Keys |
| --- | --- | --- |
| company_entity_id | Unknown | PK, FK |
| purchase_order_id | Unknown | PK, FK |
| location_city | Unknown |  |
| location_country | Unknown |  |
| location_country_code | Unknown |  |
| location_object | Unknown |  |
| location_ref | Unknown |  |
| location_state | Unknown |  |
| location_street_address | Unknown |  |
| location_street_address_2 | Unknown |  |
| location_timezone | Unknown |  |
| location_unlocode | Unknown |  |
| location_zip | Unknown |  |
| object | Unknown |  |
| role | Unknown |  |

### purchase_order

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| buyer_id | Unknown | FK |
| seller_id | Unknown | FK |
| archived_at | Unknown |  |
| cargo_ready_date | Unknown |  |
| created_at | Unknown |  |
| destination_port_name | Unknown |  |
| destination_port_object | Unknown |  |
| freight_paymnet_term | Unknown |  |
| incoterm | Unknown |  |
| issue_date | Unknown |  |
| line_itemlink | Unknown |  |
| line_itemobject | Unknown |  |
| line_itemref_type | Unknown |  |
| memo | Unknown |  |
| metadata | Json |  |
| must_arrive_date | Unknown |  |
| name | Unknown |  |
| object | Unknown |  |
| order_class | Unknown |  |
| order_type | Unknown |  |
| origin_port_name | Unknown |  |
| origin_port_object | Unknown |  |
| priority | Unknown |  |
| status | Unknown |  |
| transportation_mode | Unknown |  |
| updated_at | Unknown |  |

### location

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | FK |
| contacts_link | String |  |
| contacts_object | Unknown |  |
| contacts_ref_type | Unknown |  |
| editable | Unknown |  |
| metadata | Json |  |
| name | Unknown |  |
| object | Unknown |  |

### shipment_buyer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| shipment_id | Unknown | FK |
| mailing_city | Unknown |  |
| mailing_country | Unknown |  |
| mailing_country_code | Unknown |  |
| mailing_object | Unknown |  |
| mailing_ref | Unknown |  |
| mailing_state | Unknown |  |
| mailing_street_address | Unknown |  |
| mailing_street_address_2 | Unknown |  |
| mailing_timezone | Unknown |  |
| mailing_unlocode | Unknown |  |
| mailing_zip | Unknown |  |
| name | Unknown |  |
| object | Unknown |  |
| ref | Unknown |  |

### shipment_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | FK |
| shipment_id | Unknown | FK |
| object | Unknown |  |
| purchase_order_number | Unknown |  |
| total_units | Unknown |  |
| total_vloume_object | Unknown |  |
| total_vloume_unit | Unknown |  |
| total_vloume_value | Unknown |  |
| total_weight_object | Unknown |  |
| total_weight_unit | Unknown |  |
| total_weight_value | Unknown |  |

### shipment_importers_record

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| shipment_id | Unknown | FK |
| mailing_city | Unknown |  |
| mailing_country | Unknown |  |
| mailing_country_code | Unknown |  |
| mailing_object | Unknown |  |
| mailing_ref | Unknown |  |
| mailing_state | Unknown |  |
| mailing_street_address | Unknown |  |
| mailing_street_address_2 | Unknown |  |
| mailing_timezone | Unknown |  |
| mailing_unlocode | Unknown |  |
| mailing_zip | Unknown |  |
| name | Unknown |  |
| object | Unknown |  |
| ref | Unknown |  |

### shipment_child

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| shipment_id | Unknown | PK, FK |
| link | Unknown |  |
| object | Unknown |  |

### shipment_dangerious_goods_classification

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

### shipment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| parent_shipment_id | Unknown | FK |
| actual_arrival_date | Unknown |  |
| actual_delivered_in_full_date | Unknown |  |
| actual_departure_date | Unknown |  |
| actual_picked_up_in_full_date | Unknown |  |
| air_shipment_chargeable_volume_object | Unknown |  |
| air_shipment_chargeable_volume_unit | Unknown |  |
| air_shipment_chargeable_volume_value | Unknown |  |
| air_shipment_chargeable_weight_object | Unknown |  |
| air_shipment_chargeable_weight_unit | Unknown |  |
| air_shipment_chargeable_weight_value | Unknown |  |
| air_shipment_house_airway_bill | Unknown |  |
| air_shipment_master_airway_bill | Unknown |  |
| air_shipment_object | Unknown |  |
| archived_at | Unknown |  |
| arrival_date | Unknown |  |
| belongs_to_a_buyers_consol | Unknown |  |
| booking_id | Unknown |  |
| calculated_volume_object | Unknown |  |
| calculated_volume_unit | Unknown |  |
| calculated_volume_value | Unknown |  |
| calculated_weight_object | Unknown |  |
| calculated_weight_unit | Unknown |  |
| calculated_weight_value | Unknown |  |
| cargo_ready_date | Unknown |  |
| commercial_invoices_link | Unknown |  |
| commercial_invoices_object | Unknown |  |
| created_date | Unknown |  |
| customs_entries_link | Unknown |  |
| customs_entries_object | Unknown |  |
| dangerous_goods_object | Unknown |  |
| dangerous_goods_review_status | Unknown |  |
| delivered_in_full_date | Unknown |  |
| departure_date | Unknown |  |
| documents_link | Unknown |  |
| documents_object | Unknown |  |
| estimated_arrival_date | Unknown |  |
| estimated_delivered_in_full_date | Unknown |  |
| estimated_departure_date | Unknown |  |
| estimated_picked_up_in_full_date | Unknown |  |
| freight_type | Unknown |  |
| incoterm | Unknown |  |
| it_number | Unknown |  |
| legs_link | Unknown |  |
| legs_object | Unknown |  |
| metadata | Json |  |
| name | Unknown |  |
| object | Unknown |  |
| ocean_shipment_carrier_booking_number | Unknown |  |
| ocean_shipment_confirmed_space_released_at | Unknown |  |
| ocean_shipment_containers_link | Unknown |  |
| ocean_shipment_containers_object | Unknown |  |
| ocean_shipment_house_bill_number | Unknown |  |
| ocean_shipment_is_lcl | Unknown |  |
| ocean_shipment_master_bill_number | Unknown |  |
| ocean_shipment_object | Unknown |  |
| picked_up_in_full_date | Unknown |  |
| pieces | Unknown |  |
| priority | Unknown |  |
| status | Unknown |  |
| target_delivery_date | Unknown |  |
| transportation_mode | Unknown |  |
| updated_at | Unknown |  |
| visibility_only | Unknown |  |
| wants_commercial_invoice_transcription | Unknown |  |
| wants_delivery_service | Unknown |  |
| wants_export_customs_service | Unknown |  |
| wants_flexport_freight | Unknown |  |
| wants_flexport_insurance | Unknown |  |
| wants_freight_management_bco | Unknown |  |
| wants_import_customs_service | Unknown |  |
| wants_pickup_service | Unknown |  |
| wants_trade_declaration_service | Unknown |  |

### vat_number

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| parent_id | Unknown | FK |
| country_code | Unknown |  |
| number | Unknown |  |
| object | Unknown |  |
| vat_number_type | Unknown |  |

### shipment_entity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| shipment_id | Unknown | FK |
| entity_type | Unknown |  |

### custom_entry

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| shipment_id | Unknown | FK |
| entry_number | Unknown |  |
| object | Unknown |  |
| release_date | Unknown |  |
| release_status | Unknown |  |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | FK |
| email | Unknown |  |
| locations_link | Unknown |  |
| locations_object | Unknown |  |
| locations_ref_type | Unknown |  |
| name | Unknown |  |
| object | Unknown |  |
| phone_number | Unknown |  |

### booking_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| booking_id | Unknown | FK |
| purchase_order_line_item_id | Unknown | FK |
| object | Unknown |  |
| unit | Unknown |  |

### product_supplier

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | FK |
| country_of_origin | Unknown |  |
| object | Unknown |  |
| ref | Unknown |  |

### product_classification_code

| Column | Type | Keys |
| --- | --- | --- |
| hs_code | Unknown | PK, FK |
| product_classification_id | Unknown | PK, FK |

### product_classification

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

### product_property

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| product_id | Unknown | FK |
| object | Unknown |  |
| type | Unknown |  |
| value | Unknown |  |

### product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| archived_at | Unknown |  |
| client_verified | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |
| object | Unknown |  |
| product_category | Unknown |  |
| sku | Unknown |  |

### booking_cargo_shipping_unit

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| booking_id | Unknown | FK |
| atomic_count | Unknown |  |
| count | Unknown |  |
| name | Json |  |
| unit_type | Unknown |  |

### booking

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| shipment_id | Unknown | FK |
| air_booking_incoterm | Unknown |  |
| air_booking_object | Unknown |  |
| air_booking_origin_port_name | Unknown |  |
| air_booking_origin_port_object | Unknown |  |
| air_booking_wants_delivery_service | Unknown |  |
| air_booking_wants_pickup_service | Unknown |  |
| booking_line_items_link | Unknown |  |
| booking_line_items_object | Unknown |  |
| cargo_contains_hazmat | Unknown |  |
| cargo_contains_li_ion | Unknown |  |
| cargo_contains_magnets | Unknown |  |
| cargo_contains_non_li_ion_battery | Unknown |  |
| cargo_contains_other_dangerous_goods | Unknown |  |
| cargo_lithium_batteries_packing_types | Json |  |
| cargo_marks_and_numbers | Unknown |  |
| cargo_object | Unknown |  |
| cargo_ready_date | Unknown |  |
| cargo_volume_object | Unknown |  |
| cargo_volume_unit | Unknown |  |
| cargo_volume_value | Unknown |  |
| cargo_weight_object | Unknown |  |
| cargo_weight_unit | Unknown |  |
| cargo_weight_value | Unknown |  |
| consignee_entity_id | Unknown |  |
| consignee_entity_name | Unknown |  |
| consignee_entity_object | Unknown |  |
| consignee_entity_ref | Unknown |  |
| created_at | Unknown |  |
| delivery_date | Unknown |  |
| flex_id | Unknown |  |
| metadata | Json |  |
| name | Unknown |  |
| notify_party | Unknown |  |
| object | Unknown |  |
| ocean_booking_container_counts_forty_five_ft_hc | Unknown |  |
| ocean_booking_container_counts_forty_ft | Unknown |  |
| ocean_booking_container_counts_forty_ft_hc | Unknown |  |
| ocean_booking_container_counts_object | Unknown |  |
| ocean_booking_container_counts_twenty_ft | Unknown |  |
| ocean_booking_destination_port_name | Unknown |  |
| ocean_booking_destination_port_object | Unknown |  |
| ocean_booking_incoterm | Unknown |  |
| ocean_booking_is_lcl | Unknown |  |
| ocean_booking_object | Unknown |  |
| ocean_booking_origin_port_name | Unknown |  |
| ocean_booking_origin_port_object | Unknown |  |
| ocean_booking_wants_delivery_service | Unknown |  |
| ocean_booking_wants_pickup_service | Unknown |  |
| quote_status | Unknown |  |
| shipper_entity_id | Unknown |  |
| shipper_entity_name | Unknown |  |
| shipper_entity_object | Unknown |  |
| shipper_entity_ref | Unknown |  |
| special_instructions | Unknown |  |
| status | Unknown |  |
| transportation_mode | Unknown |  |
| trucking_booking_description_of_products | Unknown |  |
| trucking_booking_is_ftl | Unknown |  |
| trucking_booking_object | Unknown |  |
| trucking_booking_payement_terms | Unknown |  |
| wants_export_customs_service | Unknown |  |
| wants_import_customs_service | Unknown |  |

### hs

| Column | Type | Keys |
| --- | --- | --- |
| code | Unknown | PK |
| country_code | Unknown | PK |
| description | Unknown |  |
| object | Unknown |  |

### booking_description

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | Unknown | PK |
| code | Unknown | FK |
| country_code | Unknown | FK |
| parent_id | Unknown | FK |
| description | Unknown |  |
| description_for_export_customs | Unknown |  |
| description_for_export_customs_locale | Unknown |  |
| description_type | Unknown |  |
| object | Unknown |  |

### port

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| object | Unknown |  |

### invoice_credit_memo

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| invoice_id | Unknown | FK |
| amount_amount | Unknown |  |
| amount_currency_code | Unknown |  |
| amount_object | Unknown |  |
| categories | Unknown |  |
| category | Unknown |  |
| credited_at | Unknown |  |
| object | Unknown |  |
| reason | Unknown |  |
| reasons | Unknown |  |

### invoice_line_item

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| invoice_id | Unknown | FK |
| amount_amount | Unknown |  |
| amount_currency_code | Unknown |  |
| amount_object | Unknown |  |
| category | Unknown |  |
| name | Unknown |  |
| object | Unknown |  |
| quantity_object | Unknown |  |
| quantity_qualifier | Unknown |  |
| quantity_value | Unknown |  |
| rate_object | Unknown |  |
| rate_qualifier | Unknown |  |
| rate_value | Unknown |  |
| slug | Unknown |  |

### invoice

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| shipment_id | Unknown | FK |
| balance_amount | Unknown |  |
| balance_currency_code | Unknown |  |
| balance_object | Unknown |  |
| due_date | Unknown |  |
| issued_at | Unknown |  |
| issuer_id | Unknown |  |
| issuer_name | Unknown |  |
| issuer_object | Unknown |  |
| issuer_ref | Unknown |  |
| last_updated_at | Unknown |  |
| name | Unknown |  |
| notes | Json |  |
| object | Unknown |  |
| recipient_id | Unknown |  |
| recipient_name | Unknown |  |
| recipient_object | Unknown |  |
| recipient_ref | Unknown |  |
| status | Unknown |  |
| total_amount | Unknown |  |
| total_currency_code | Unknown |  |
| total_object | Unknown |  |
| type | Unknown |  |
| voided_at | Unknown |  |

### company_entity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |
| object | Unknown |  |
| ref | Unknown |  |

### purchase_order_line_item_measurement

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| purchase_order_line_item_id | Unknown | FK |
| measure_type | Unknown |  |
| object | Unknown |  |
| unit_of_measure | Unknown |  |
| value | Unknown |  |

### purchase_order_line_item_product_classification

| Column | Type | Keys |
| --- | --- | --- |
| hs_code | Unknown | PK, FK |
| purchase_order_line_item_id | Unknown | PK, FK |
| object | Unknown |  |
| region | Unknown |  |

### purchase_order_line_item_product_property

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| parent_id | Unknown | PK, FK |
| object | Unknown |  |
| type | Unknown |  |
| value | Unknown |  |

### purchase_order_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| country_code | Unknown | FK |
| hs_code | Unknown | FK |
| product_id | Unknown | FK |
| purchase_order_id | Unknown | FK |
| assigned_party_id | Unknown |  |
| assigned_party_name | Unknown |  |
| assigned_party_object | Unknown |  |
| assigned_party_ref | Unknown |  |
| booking_line_item_link | Unknown |  |
| booking_line_item_object | Unknown |  |
| destination_port_name | Unknown |  |
| incoterm | Unknown |  |
| item_key | Unknown |  |
| line_item_number | Unknown |  |
| line_type | Unknown |  |
| metadata | Json |  |
| must_arrive_date | Unknown |  |
| object | Unknown |  |
| origin_port_name | Unknown |  |
| parent_line_key | Unknown |  |
| product_color | Unknown |  |
| product_dangerous | Unknown |  |
| product_ean_ucc_13 | Unknown |  |
| product_ean_ucc_8 | Unknown |  |
| product_lot_number | Unknown |  |
| product_size | Unknown |  |
| product_style | Unknown |  |
| product_upc | Unknown |  |
| supplier | Json |  |
| transportation_mode | Unknown |  |
| unit_cost_amount | Unknown |  |
| unit_cost_currency_code | Unknown |  |
| unit_cost_object | Unknown |  |
| unit_of_measure | Unknown |  |
| units | Unknown |  |

### container_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| container_id | Unknown | FK |
| product_id | Unknown | FK |
| object | Unknown |  |
| purchase_order_number | Unknown |  |
| total_unit | Unknown |  |
| total_volume_object | Unknown |  |
| total_volume_unit | Unknown |  |
| total_volume_value | Unknown |  |
| total_weight_object | Unknown |  |
| total_weight_unit | Unknown |  |
| total_weight_value | Unknown |  |

### container

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| shipment_id | Unknown | FK |
| actual_arrival_date | Unknown |  |
| actual_delivery_date | Unknown |  |
| actual_departure_date | Unknown |  |
| actual_pickup_date | Unknown |  |
| available_for_pickup_date | Unknown |  |
| cargo_ready_date | Unknown |  |
| container_legs_link | Unknown |  |
| container_legs_object | Unknown |  |
| container_number | Unknown |  |
| container_size | Unknown |  |
| container_type | Unknown |  |
| empty_returned_date | Unknown |  |
| estimated_arrival_date | Unknown |  |
| estimated_available_for_pickup_date | Unknown |  |
| estimated_delivery_date | Unknown |  |
| estimated_departure_date | Unknown |  |
| estimated_pickup_date | Unknown |  |
| last_free_day_date | Unknown |  |
| metadata | Json |  |
| object | Unknown |  |
| pickup_number | Unknown |  |
| seal_number | Unknown |  |

## Relationships

- commercial_invoice_line_item(product_id) → product(id)
- commercial_invoice_line_item(commercial_invoice_id) → commercial_invoice(id)
- commercial_invoice_involved_party(company_entity_id) → company_entity(id)
- commercial_invoice_involved_party(commercial_invoice_id) → commercial_invoice(id)
- commercial_invoice(shipment_id) → shipment(id)
- document(shipment_id) → shipment(id)
- container_leg_date(container_leg_id) → container_leg(id)
- container_leg(shipment_leg_id) → shipment_leg(id)
- container_leg(container_id) → container(id)
- tags(shipment_leg_id) → shipment_leg(id)
- detail(parent_id) → shipment_leg(id)
- address(parent_id) → shipment_leg(id)
- company_entity_company(company_entity_id) → company_entity(id)
- company_entity_company(company_id) → company(id)
- purchase_order_party_contact(purchase_order_party_company_entity_id) → purchase_order_party(company_entity_id)
- purchase_order_party_contact(purchase_order_party_purchase_order_id) → purchase_order_party(purchase_order_id)
- purchase_order_party(company_entity_id) → company_entity(id)
- purchase_order_party(purchase_order_id) → purchase_order(id)
- purchase_order(seller_id) → shipment_entity(id)
- purchase_order(buyer_id) → shipment_buyer(id)
- location(company_id) → company(id)
- shipment_buyer(shipment_id) → shipment(id)
- shipment_item(product_id) → product(id)
- shipment_item(shipment_id) → shipment(id)
- shipment_importers_record(shipment_id) → shipment(id)
- shipment_child(shipment_id) → shipment(id)
- shipment_dangerious_goods_classification(shipment_id) → shipment(id)
- shipment(id) → booking(id)
- shipment(parent_shipment_id) → shipment(id)
- vat_number(parent_id) → booking(id)
- shipment_entity(shipment_id) → shipment(id)
- custom_entry(shipment_id) → shipment(id)
- contact(company_id) → company(id)
- booking_line_item(purchase_order_line_item_id) → purchase_order_line_item(id)
- booking_line_item(booking_id) → booking(id)
- product_supplier(product_id) → product(id)
- product_classification_code(hs_code) → hs(code)
- product_classification_code(product_classification_id) → product_classification(index)
- product_classification(region) → hs(country_code)
- product_classification(product_id) → product(id)
- product_property(product_id) → product(id)
- booking_cargo_shipping_unit(booking_id) → booking(id)
- booking(shipment_id) → shipment(id)
- booking_description(country_code) → hs(country_code)
- booking_description(parent_id) → booking(id)
- booking_description(code) → hs(code)
- invoice_credit_memo(invoice_id) → invoice(id)
- invoice_line_item(invoice_id) → invoice(id)
- invoice(shipment_id) → shipment(id)
- purchase_order_line_item_measurement(purchase_order_line_item_id) → purchase_order_line_item(id)
- purchase_order_line_item_product_classification(hs_code) → hs(code)
- purchase_order_line_item_product_classification(purchase_order_line_item_id) → purchase_order_line_item(id)
- purchase_order_line_item_product_property(parent_id) → purchase_order_line_item(id)
- purchase_order_line_item(product_id) → product(id)
- purchase_order_line_item(purchase_order_id) → purchase_order(id)
- purchase_order_line_item(hs_code) → hs(code)
- purchase_order_line_item(country_code) → hs(country_code)
- container_item(product_id) → product(id)
- container_item(container_id) → container(id)
- container(shipment_id) → shipment(id)