Fivetran documentation

Search the docs

/

DSV

Explore the interactive ERD

Table & Field Reference

shipment

Column	Type	Keys
`shipment_id`	Unknown	PK
`actual_delivery`	Unknown
`actual_pickup`	Unknown
`barcode`	Unknown
`barcode_latest_event`	Unknown
`booking_id`	Unknown
`from_date`	Unknown
`from_date_end`	Unknown
`from_date_start`	Unknown
`from_date_type`	Unknown
`goods_total_colli`	Unknown
`goods_total_load_meter`	Unknown
`goods_total_volume`	Unknown
`goods_total_weight`	Unknown
`main_tms_shipment_id`	Unknown
`mode_of_transport`	Unknown
`requested_delivery`	Unknown
`requested_pickup`	Unknown
`status`	Unknown
`to_date`	Unknown
`to_date_end`	Unknown
`to_date_start`	Unknown
`to_date_type`	Unknown

events

Column	Type	Keys
`index`	Unknown	PK
`shipment_id`	Unknown	PKFK
`cargo_availability`	Unknown
`cargo_cut_off`	Unknown
`code`	Unknown
`date`	Unknown
`description`	Unknown
`groups`	Unknown
`location_country_code`	Unknown
`location_place`	Unknown
`location_unlocode`	Unknown
`transport_mode`	Unknown
`type`	Unknown
`type_value`	Unknown
`vessel_name`	Unknown
`voyage_flight_no`	Unknown
`voyage_id`	Unknown

dangerous_package

Column	Type	Keys
`_fivetran_id`	String	PK
`package_index`	Unknown	FK
`shipment_id`	Unknown	FK
`class_name`	Unknown
`empty`	Unknown
`flash_point`	Unknown
`gross_quantity`	Unknown
`gross_quantity_unit`	Unknown
`limited_quantity`	Unknown
`marine_pollutant`	Unknown
`net_quantity`	Unknown
`net_quantity_unit`	Unknown
`package_count`	Unknown
`packing_group`	Unknown
`packing_kind`	Unknown
`proper_shipping_name`	Unknown
`sub_risk`	Unknown
`technical_name`	Unknown
`technical_name_national`	Unknown
`temperature_from`	Unknown
`temperature_to`	Unknown
`tunnel_code`	Unknown
`type`	Unknown
`un_code`	Unknown

package_reference

Column	Type	Keys
`index`	Unknown	PK
`shipment_id`	Unknown	PKFK
`package_index`	Unknown	FK
`qualifier`	Unknown
`reference`	Unknown

package

Column	Type	Keys
`index`	Unknown	PK
`shipment_id`	Unknown	PKFK
`cargo_aircraft_only`	Unknown
`container_no`	Unknown
`description`	Unknown
`goods_type`	Unknown
`gross_weight`	Unknown
`height`	Unknown
`height_uom`	Unknown
`is_dangerous`	Unknown
`length`	Unknown
`length_uom`	Unknown
`loading_meters`	Unknown
`net_weight`	Unknown
`package_type`	Unknown
`pallet_space`	Unknown
`quantity`	Unknown
`shipping_mark`	Unknown
`stackable`	Json
`temperature_controlled`	Unknown
`temperature_max`	Unknown
`temperature_min`	Unknown
`total_volume`	Unknown
`total_weight`	Unknown
`tracking_number`	Json
`volume_uom`	Unknown
`width`	Unknown
`width_uom`	Unknown

product_container

Column	Type	Keys
`index`	Unknown	PK
`shipment_id`	Unknown	PKFK
`genset`	Unknown
`ref`	Unknown
`temp`	Unknown
`type`	Unknown

container

Column	Type	Keys
`index`	Unknown	PK
`shipment_id`	Unknown	PKFK
`container_number`	Unknown
`container_type`	Unknown
`seal_number`	Unknown

issue

Column	Type	Keys
`index`	Unknown	PK
`shipment_id`	Unknown	PKFK
`date`	Unknown
`note`	Unknown
`party_code`	Unknown
`party_description`	Unknown
`point_code`	Unknown
`point_description`	Unknown
`reason_code`	Unknown
`reason_description`	Unknown
`resolved`	Unknown
`type_code`	Unknown
`type_description`	Unknown

proof_of_delivery

Column	Type	Keys
`document_id`	Unknown	PK
`shipment_id`	Unknown	PKFK
`create_date`	Unknown
`document_type`	Unknown
`download_url`	Unknown
`file_name`	Unknown
`file_type`	Unknown
`type_description`	Unknown

selected_service

Column	Type	Keys
`index`	Unknown	PK
`shipment_id`	Unknown	PKFK
`code`	Unknown
`detail`	Json
`name`	Unknown

reference

Column	Type	Keys
`index`	Unknown	PK
`shipment_id`	Unknown	PKFK
`type`	Unknown
`value`	Unknown

child_shipment_id

Column	Type	Keys
`index`	Unknown	PK
`shipment_id`	Unknown	PKFK
`child_shipment_id`	Unknown

shipment_detail

Column	Type	Keys
`shipment_id`	Unknown	PKFK
`booking_id`	Unknown	FK
`booked_by`	Unknown
`carrier_tracking_id`	Unknown
`customs_entry_number`	Json
`customs_removal_mode`	Unknown
`customs_shipped_onboard_date`	Unknown
`customs_status`	Unknown
`delivery_date`	Unknown
`delivery_end`	Unknown
`delivery_instruction`	Unknown
`delivery_start`	Unknown
`goods_description`	Unknown
`goods_gross_weight_uom`	Unknown
`goods_gross_weight_value`	Unknown
`goods_loading_meters_uom`	Unknown
`goods_loading_meters_value`	Unknown
`goods_quantity_uom`	Unknown
`goods_quantity_value`	Unknown
`goods_volume_uom`	Unknown
`goods_volume_value`	Unknown
`incoterms_code`	Unknown
`incoterms_location`	Unknown
`master_shipment_id`	Unknown
`pickup_date`	Unknown
`pickup_end`	Unknown
`pickup_instruction`	Unknown
`pickup_start`	Unknown
`product_bill_of_lading`	Unknown
`product_container_mode`	Unknown
`product_drop_off`	Unknown
`product_name`	Unknown
`public_shipment_id`	Unknown
`service_level_code`	Unknown
`service_level_description`	Unknown
`shipment_note`	Unknown
`status`	Unknown
`transport_awb`	Unknown
`transport_destination_code`	Unknown
`transport_destination_name`	Unknown
`transport_house_bill_number`	Unknown
`transport_master_bill_number`	Unknown
`transport_origin_code`	Unknown
`transport_origin_name`	Unknown

address

Column	Type	Keys
`index`	Unknown	PK
`shipment_id`	Unknown	PKFK
`address_id`	Unknown
`address_line_1`	Unknown
`address_line_2`	Unknown
`address_line_3`	Unknown
`address_type`	Unknown
`city`	Unknown
`company_name`	Unknown
`country_code`	Unknown
`email`	Unknown
`instruction`	Unknown
`mdm`	Unknown
`name`	Unknown
`role`	Unknown
`state`	Unknown
`telephone`	Unknown
`zip_code`	Unknown