# Freightview schema ERD

Table and field reference for the Fivetran Freightview connector.

## 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 | PK, FK |
| amount | Double |  |
| code | String |  |
| name | String |  |
| provider_detail | String |  |

### shipment_accessorial

| Column | Type | Keys |
| --- | --- | --- |
| accessorial | String | PK |
| shipment_id | String | PK, FK |

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

### shipment_invoice_payment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| shipment_id | String | PK, FK |
| amount | Double |  |
| remitted | Boolean |  |

### shipment_tracking_history

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

## Relationships

- shipment_item(shipment_id) → shipment(id)
- shipment_rate_charge(shipment_id) → shipment(id)
- shipment_accessorial(shipment_id) → shipment(id)
- shipment_file(shipment_id) → shipment(id)
- shipment_share_shipment_email(shipment_id) → shipment(id)
- shipment_invoice_payment(shipment_id) → shipment(id)
- shipment_tracking_history(shipment_id) → shipment(id)