Freightview

Explore the interactive ERD

Table & Field Reference

shipment_item

Column	Type	Keys
`_fivetran_id`	String	PK
`shipment_id`	String	FK
`description`	String
`freight_class`	Double
`hazard_class`	String
`hazard_hazmat_id`	String
`hazard_packing_group`	String
`hazard_special_permit`	String
`hazard_sub_class_1`	String
`hazard_sub_class_2`	String
`hazardous`	Boolean
`height`	Long
`length`	Long
`nmfc`	String
`package`	String
`pieces`	Long
`said_to_contain`	Long
`said_to_contain_packaging_type`	String
`stackable`	Boolean
`weight`	Long
`width`	Long

shipment_rate_charge

Column	Type	Keys
`index`	Unknown	PK
`shipment_id`	String	PKFK
`amount`	Double
`code`	String
`name`	String
`provider_detail`	String

shipment_accessorial

Column	Type	Keys
`accessorial`	String	PK
`shipment_id`	String	PKFK

shipment_file

Column	Type	Keys
`_fivetran_id`	String	PK
`shipment_id`	String	FK
`subtype`	String
`type`	String
`upload_date`	Instant
`url`	String

shipment_share_shipment_email

Column	Type	Keys
`email`	String	PK
`shipment_id`	String	PKFK

shipment_invoice_payment

Column	Type	Keys
`index`	Unknown	PK
`shipment_id`	String	PKFK
`amount`	Double
`remitted`	Boolean

shipment_tracking_history

Column	Type	Keys
`index`	Unknown	PK
`shipment_id`	String	PKFK
`created_date`	Instant
`event_date`	Instant
`status`	String
`summary`	String

shipment

Column	Type	Keys
`id`	String	PK
`archived`	Boolean
`bill_to_address`	String
`bill_to_address_2`	String
`bill_to_city`	String
`bill_to_company`	String
`bill_to_contact_email`	String
`bill_to_contact_name`	String
`bill_to_contact_phone`	String
`bill_to_country`	String
`bill_to_postal_code`	String
`bill_to_state`	String
`bol_num`	String
`booked_by`	String
`created_date`	Instant
`destination_address`	String
`destination_address_2`	String
`destination_city`	String
`destination_company`	String
`destination_contact_email`	String
`destination_contact_name`	String
`destination_contact_phone`	String
`destination_country`	String
`destination_dock_hours_end`	String
`destination_dock_hours_start`	String
`destination_instructions`	String
`destination_postal_code`	String
`destination_reference_number`	String
`destination_ship_type`	String
`destination_state`	String
`direction`	String
`dispatch_bol_status`	String
`dispatch_carrier`	String
`dispatch_carrier_code`	String
`dispatch_carrier_id`	String
`dispatch_pickup_num`	String
`dispatch_pro_num`	String
`dispatch_schedule_pickup`	Boolean
`dispatch_tracking_num`	String
`invoice_amount`	Double
`invoice_created_date`	Instant
`invoice_disputed_amount`	Double
`invoice_number`	String
`origin_address`	String
`origin_address_2`	String
`origin_city`	String
`origin_company`	String
`origin_contact_email`	String
`origin_contact_name`	String
`origin_contact_phone`	String
`origin_country`	String
`origin_dock_hours_end`	String
`origin_dock_hours_start`	String
`origin_instructions`	String
`origin_postal_code`	String
`origin_reference_number`	String
`origin_ship_type`	String
`origin_state`	String
`payment_terms`	String
`pickup_date`	Instant
`quoted_by`	String
`rate_carrier`	String
`rate_carrier_code`	String
`rate_carrier_id`	String
`rate_created_date`	Instant
`rate_days_plus`	Boolean
`rate_guaranteed`	Boolean
`rate_interline`	Boolean
`rate_mode`	String
`rate_payment_terms`	String
`rate_provider`	String
`rate_provider_code`	String
`rate_quote_num`	String
`rate_service_description`	String
`rate_service_option`	String
`rate_service_type`	String
`rate_total`	Double
`rate_transit_days`	Long
`status`	String
`tracking_delivery_date_actual`	Instant
`tracking_delivery_date_estimate`	Instant
`tracking_last_updated_date`	Instant
`tracking_pickup_date_actual`	Instant
`tracking_status`	String
`tracking_summary`	String