# Anvyl schema ERD

Table and field reference for the Fivetran Anvyl connector.

## Table & Field Reference

### route

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| shipment_id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |
| actual_arrival_time | Unknown |  |
| actual_departure_time | Unknown |  |
| carrier_name | Unknown |  |
| destination_address_line_1 | Unknown |  |
| destination_address_line_2 | Unknown |  |
| destination_city | Unknown |  |
| destination_country | Unknown |  |
| destination_country_code | Unknown |  |
| destination_iata_code | Unknown |  |
| destination_id | Unknown |  |
| destination_lat | Unknown |  |
| destination_lon | Unknown |  |
| destination_name | Unknown |  |
| destination_port_name | Unknown |  |
| destination_port_type | Unknown |  |
| destination_postal_code | Unknown |  |
| destination_state | Unknown |  |
| estimated_arrival_time | Unknown |  |
| estimated_departure_time | Unknown |  |
| origin_address_line_1 | Unknown |  |
| origin_address_line_2 | Unknown |  |
| origin_city | Unknown |  |
| origin_country | Unknown |  |
| origin_country_code | Unknown |  |
| origin_iata_code | Unknown |  |
| origin_id | Unknown |  |
| origin_lat | Unknown |  |
| origin_lon | Unknown |  |
| origin_name | Unknown |  |
| origin_port_name | Unknown |  |
| origin_port_type | Unknown |  |
| origin_postal_code | Unknown |  |
| origin_state | Unknown |  |
| priority | Unknown |  |
| tracking_number | Unknown |  |
| transportation_mode | Unknown |  |
| vehicle_model | Unknown |  |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| supplier_id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |
| address_line_1 | Unknown |  |
| address_line_2 | Unknown |  |
| city | Unknown |  |
| country | Unknown |  |
| created_at | Unknown |  |
| email | Unknown |  |
| name | Unknown |  |
| phone | Unknown |  |
| postal_code | Unknown |  |
| state | Unknown |  |
| updated_at | Unknown |  |

### custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| team_id | Unknown | PK, FK |
| created_at | Unknown |  |
| default_value | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |
| option_currency | Unknown |  |
| option_field_type | Unknown |  |
| option_show_on_pdf | Unknown |  |
| option_unit_of_measure | Unknown |  |
| resource_type | Unknown |  |
| updated_at | Unknown |  |

### shipment_consolidation_order

| Column | Type | Keys |
| --- | --- | --- |
| shipment_consolidation_id | Unknown | PK, FK |
| track_shipment_requests_order_id | Unknown | PK, FK |
| shipment_consolidation_track_shipment_requests_id | Unknown |  |

### shipment_consolidation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| team_id | Unknown | PK, FK |
| ship_to_location_id | Unknown | FK |
| shipment_consolidation_order_id | Unknown | FK |
| shipment_consolidation_order_item_id | Unknown | FK |
| shipment_id | Unknown | FK |
| actual_delivery_date | Unknown |  |
| actual_freight_cost | Unknown |  |
| actual_ship_date | Unknown |  |
| cargo_pickup_date | Unknown |  |
| container_load_time | Unknown |  |
| created_at | Unknown |  |
| estimated_delivery_date | Unknown |  |
| estimated_ship_date | Unknown |  |
| last_date_to_cancel | Unknown |  |
| logistics_trackings_carrier | Unknown |  |
| logistics_trackings_created_at | Unknown |  |
| logistics_trackings_id | Unknown |  |
| logistics_trackings_tracking_number | Unknown |  |
| logistics_trackings_tracking_type | Unknown |  |
| logistics_trackings_updated_at | Unknown |  |
| name | Unknown |  |
| notes | Unknown |  |
| original_freight_quote | Unknown |  |
| port_of_departure | Unknown |  |
| shipment_consolidation_files_count | Unknown |  |
| shipment_consolidation_order_items_count | Unknown |  |
| shipment_consolidation_orders_count | Unknown |  |
| shipment_consolidation_select_all | Unknown |  |
| shipment_cost | Unknown |  |
| shipment_number | Unknown |  |
| status | Unknown |  |
| track_shipment_requests_carrier | Unknown |  |
| track_shipment_requests_created_at | Unknown |  |
| track_shipment_requests_id | Unknown |  |
| track_shipment_requests_order_ids | Unknown |  |
| track_shipment_requests_status | Unknown |  |
| track_shipment_requests_tracking_reference | Unknown |  |
| track_shipment_requests_type | Unknown |  |
| track_shipment_requests_updated_at | Unknown |  |
| updated_at | Unknown |  |
| vessel_number | Unknown |  |

### purchase_order_source

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| purchase_order_id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |
| created_at | Unknown |  |
| source_id | Unknown |  |
| source_ref | Unknown |  |
| updated_at | Unknown |  |
| vendor_id | Unknown |  |
| vendor_name | Unknown |  |

### part_source

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| part_id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |
| created_at | Unknown |  |
| source_id | Unknown |  |
| source_ref | Unknown |  |
| updated_at | Unknown |  |
| vendor_id | Unknown |  |
| vendor_name | Unknown |  |

### tracked_shipment_order

| Column | Type | Keys |
| --- | --- | --- |
| order_id | Unknown | PK, FK |
| tracked_shipment_id | Unknown | PK, FK |

### tracked_shipment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| team_id | Unknown | PK, FK |
| created_at | Unknown |  |
| status | Unknown |  |
| tracking_carrier | Unknown |  |
| tracking_reference | Unknown |  |
| tracking_type | Unknown |  |
| updated_at | Unknown |  |

### task

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| team_id | Unknown | PK, FK |
| assignee_id | Unknown |  |
| assignee_type | Unknown |  |
| created_at | Unknown |  |
| creator_id | Unknown |  |
| description | Unknown |  |
| due_date | Unknown |  |
| required | Unknown |  |
| status | Unknown |  |
| taskable_id | Unknown |  |
| taskable_type | Unknown |  |
| title | Unknown |  |
| updated_at | Unknown |  |

### order_part

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| purchase_order_id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |

### order_collection

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| purchase_order_id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |
| name | Unknown |  |
| type | Unknown |  |

### invoice_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| invoice_id | Unknown | PK, FK |
| part_id | Unknown | FK |
| created_at | Unknown |  |
| name | Unknown |  |
| quantity | Unknown |  |
| unit_price_micros | Unknown |  |
| updated_at | Unknown |  |

### invoice

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| team_id | Unknown | PK, FK |
| order_id | Unknown | FK |
| created_at | Unknown |  |
| due_date | Unknown |  |
| number | Unknown |  |
| submitted_at | Unknown |  |
| total_micros | Unknown |  |
| updated_at | Unknown |  |

### collaborator

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| team_id | Unknown | PK, FK |
| user_id | Unknown | FK |
| category | Unknown |  |
| created_at | Unknown |  |
| email | Unknown |  |
| invite_message | Unknown |  |
| name | Unknown |  |
| restrict_files_access | Unknown |  |
| restrict_financial | Unknown |  |
| updated_at | Unknown |  |

### purchase_order_custom

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| purchase_order_id | Unknown | PK, FK |
| field_id | Unknown |  |
| field_name | Unknown |  |
| field_options_currency | Unknown |  |
| field_options_unit_of_measure | Unknown |  |
| value | Unknown |  |

### purchase_order_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| purchase_order_id | Unknown | PK, FK |
| tags | Unknown |  |

### purchase_order_invoice

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

### purchase_order_shipment

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

### purchase_order_item_custom

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| purchase_order_item_id | Unknown | PK, FK |
| purchase_order_item_purchase_order_id | Unknown | PK, FK |
| field_id | Unknown |  |
| field_name | Unknown |  |
| field_options_currency | Unknown |  |
| field_options_unit_of_measure | Unknown |  |
| value | Unknown |  |

### purchase_order_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| purchase_order_id | Unknown | PK, FK |
| part_id | Unknown | FK |
| name | Unknown |  |
| quantity | Unknown |  |
| unit_of_measure | Unknown |  |
| unit_price_micros | Unknown |  |

### purchase_order_task

| Column | Type | Keys |
| --- | --- | --- |
| purchase_order_id | Unknown | PK, FK |
| task_id | Unknown | PK, FK |

### purchase_order

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| team_id | Unknown | PK, FK |
| creator_id | Unknown | FK |
| current_milestone_id | Unknown | FK |
| supplier_id | Unknown | FK |
| workflow_id | Unknown | FK |
| created_at | Unknown |  |
| creator_email | Unknown |  |
| currency | Unknown |  |
| current_milestone_status | Unknown |  |
| delivered_on | Unknown |  |
| incoterms | Unknown |  |
| is_delivered | Unknown |  |
| is_shipped | Unknown |  |
| issued_at | Unknown |  |
| last_issued_at | Unknown |  |
| name | Unknown |  |
| note | Unknown |  |
| order_number | Unknown |  |
| payment_terms | Unknown |  |
| seller_address_line_1 | Unknown |  |
| seller_address_line_2 | Unknown |  |
| seller_city | Unknown |  |
| seller_company_line_1 | Unknown |  |
| seller_company_line_2 | Unknown |  |
| seller_country | Unknown |  |
| seller_postal_code | Unknown |  |
| seller_state | Unknown |  |
| shipping_method | Unknown |  |
| ships_on | Unknown |  |
| ships_to_address_line_1 | Unknown |  |
| ships_to_address_line_2 | Unknown |  |
| ships_to_city | Unknown |  |
| ships_to_company_line_1 | Unknown |  |
| ships_to_company_line_2 | Unknown |  |
| ships_to_country | Unknown |  |
| ships_to_email | Unknown |  |
| ships_to_phone | Unknown |  |
| ships_to_postal_code | Unknown |  |
| ships_to_state | Unknown |  |
| status | Unknown |  |
| submitter_email | Unknown |  |
| submitter_id | Unknown |  |
| updated_at | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| team_id | Unknown | PK, FK |
| created_at | Unknown |  |
| email | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### logistics_tracking

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| purchase_order_id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |
| carrier | Unknown |  |
| created_at | Unknown |  |
| number | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### order_schedule

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| purchase_order_id | Unknown | FK |
| team_id | Unknown | FK |
| actual_delivery_date | Unknown |  |
| actual_ship_date | Unknown |  |
| delivered_on | Unknown |  |
| expected_ship_date | Unknown |  |
| mass_production_starts_on | Unknown |  |
| original_ships_on | Unknown |  |
| ship_date | Unknown |  |

### location

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| team_id | Unknown | PK, FK |
| address_line_1 | Unknown |  |
| address_line_2 | Unknown |  |
| city | Unknown |  |
| company_line_1 | Unknown |  |
| company_line_2 | Unknown |  |
| country | Unknown |  |
| email | Unknown |  |
| name | Unknown |  |
| phone | Unknown |  |
| postal_code | Unknown |  |
| state | Unknown |  |

### shipment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| team_id | Unknown | PK, FK |
| purchase_order_id | Unknown | FK |
| actual_arrival_time | Unknown |  |
| actual_delivered_time | Unknown |  |
| actual_departure_time | Unknown |  |
| cargo_ready_date | Unknown |  |
| created_at | Unknown |  |
| estimated_arrival_time | Unknown |  |
| estimated_delivery_time | Unknown |  |
| estimated_departure_time | Unknown |  |
| estimated_pickup_time | Unknown |  |
| external_id | Unknown |  |
| metadata | Unknown |  |
| name | Unknown |  |
| pickup_time | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |
| vendor_name | Unknown |  |

### supplier_part_quantity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| supplier_part_part_id | Unknown | PK, FK |
| supplier_part_supplier_id | Unknown | PK, FK |
| currency | Unknown |  |
| lead_time_days | Unknown |  |
| min_order_qty | Unknown |  |
| unit_of_measure | Unknown |  |
| unit_price_micros | Unknown |  |

### supplier_identifier

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| supplier_part_part_id | Unknown | PK, FK |
| supplier_part_supplier_id | Unknown | PK, FK |
| label | Unknown |  |
| value | Unknown |  |

### supplier_part_custom

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| supplier_part_part_id | Unknown | PK, FK |
| supplier_part_supplier_id | Unknown | PK, FK |
| field_id | Unknown |  |
| field_name | Unknown |  |
| field_options_currency | Unknown |  |
| field_options_unit_of_measure | Unknown |  |
| value | Unknown |  |

### supplier_part

| Column | Type | Keys |
| --- | --- | --- |
| part_id | Unknown | PK, FK |
| supplier_id | Unknown | PK, FK |
| master_cases_per_pallet | Unknown |  |
| notes | Unknown |  |
| supplier_part_number | Unknown |  |
| units_per_master_case | Unknown |  |

### supplier

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| team_id | Unknown | PK, FK |
| address_line_1 | Unknown |  |
| address_line_2 | Unknown |  |
| city | Unknown |  |
| country | Unknown |  |
| created_at | Unknown |  |
| default_custom_payment_term_id | Unknown |  |
| default_incoterms | Unknown |  |
| default_payment_term | Unknown |  |
| name | Unknown |  |
| notes | Unknown |  |
| phone | Unknown |  |
| postal_code | Unknown |  |
| state | Unknown |  |
| updated_at | Unknown |  |

### part_identifier

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| part_id | Unknown | PK, FK |
| label | Unknown |  |
| value | Unknown |  |

### part_children

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| part_id | Unknown | PK, FK |

### part_parent

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| part_id | Unknown | PK, FK |

### part_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| part_id | Unknown | PK, FK |
| tags | Unknown |  |

### part

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| team_id | Unknown | PK, FK |
| asin | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| hts_code | Unknown |  |
| is_archived | Unknown |  |
| isbn | Unknown |  |
| name | Unknown |  |
| sku | Unknown |  |
| upc | Unknown |  |
| updated_at | Unknown |  |

### rule

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| team_id | Unknown | PK, FK |
| action_id | Unknown |  |
| action_name | Unknown |  |
| created_at | Unknown |  |
| name | Unknown |  |
| status | Unknown |  |
| trigger_event_type | Unknown |  |
| trigger_id | Unknown |  |
| trigger_status | Unknown |  |
| updated_at | Unknown |  |

### factory_capability

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| factory_id | Unknown | PK, FK |
| capability | Unknown |  |

### factory

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| supplier_id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |
| address_line_1 | Unknown |  |
| address_line_2 | Unknown |  |
| city | Unknown |  |
| country | Unknown |  |
| created_at | Unknown |  |
| name | Unknown |  |
| phone | Unknown |  |
| postal_code | Unknown |  |
| state | Unknown |  |
| updated_at | Unknown |  |

### payment_term

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| team_id | Unknown | PK, FK |
| created_at | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### order_milestone

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| purchase_order_id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |
| created_at | Unknown |  |
| key_date | Unknown |  |
| sequential_id | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### team

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| address_line_1 | Unknown |  |
| address_line_2 | Unknown |  |
| city | Unknown |  |
| country | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |
| postal_code | Unknown |  |
| state | Unknown |  |
| updated_at | Unknown |  |

### workflow_milestone

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| workflow_id | Unknown | PK, FK |
| custom_field_id | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |

### workflow

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| team_id | Unknown | PK, FK |
| created_at | Unknown |  |
| description | Unknown |  |
| is_enabled | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

## Relationships

- route(shipment_id) → shipment(id)
- route(team_id) → team(id)
- contact(supplier_id) → supplier(id)
- contact(team_id) → team(id)
- custom_field(team_id) → team(id)
- shipment_consolidation_order(track_shipment_requests_order_id) → purchase_order(id)
- shipment_consolidation_order(shipment_consolidation_id) → shipment_consolidation(id)
- shipment_consolidation(ship_to_location_id) → location(id)
- shipment_consolidation(shipment_id) → shipment(id)
- shipment_consolidation(shipment_consolidation_order_id) → purchase_order(id)
- shipment_consolidation(shipment_consolidation_order_item_id) → purchase_order_item(id)
- shipment_consolidation(team_id) → team(id)
- purchase_order_source(purchase_order_id) → purchase_order(id)
- purchase_order_source(team_id) → team(id)
- part_source(part_id) → part(id)
- part_source(team_id) → team(id)
- tracked_shipment_order(order_id) → purchase_order(id)
- tracked_shipment_order(tracked_shipment_id) → tracked_shipment(id)
- tracked_shipment(team_id) → team(id)
- task(team_id) → team(id)
- order_part(id) → part(id)
- order_part(team_id) → team(id)
- order_part(purchase_order_id) → purchase_order(id)
- order_collection(purchase_order_id) → purchase_order(id)
- order_collection(team_id) → team(id)
- invoice_item(part_id) → part(id)
- invoice_item(invoice_id) → invoice(id)
- invoice(order_id) → purchase_order(id)
- invoice(team_id) → team(id)
- collaborator(user_id) → users(id)
- collaborator(team_id) → team(id)
- purchase_order_custom(purchase_order_id) → purchase_order(id)
- purchase_order_tag(purchase_order_id) → purchase_order(id)
- purchase_order_invoice(invoice_id) → invoice(id)
- purchase_order_invoice(purchase_order_id) → purchase_order(id)
- purchase_order_shipment(shipment_id) → shipment(id)
- purchase_order_shipment(purchase_order_id) → purchase_order(id)
- purchase_order_item_custom(purchase_order_item_purchase_order_id) → purchase_order_item(purchase_order_id)
- purchase_order_item_custom(purchase_order_item_id) → purchase_order_item(id)
- purchase_order_item(part_id) → part(id)
- purchase_order_item(purchase_order_id) → purchase_order(id)
- purchase_order_task(task_id) → task(id)
- purchase_order_task(purchase_order_id) → purchase_order(id)
- purchase_order(team_id) → team(id)
- purchase_order(current_milestone_id) → order_milestone(id)
- purchase_order(supplier_id) → supplier(id)
- purchase_order(workflow_id) → workflow(id)
- purchase_order(creator_id) → users(id)
- users(team_id) → team(id)
- logistics_tracking(purchase_order_id) → purchase_order(id)
- logistics_tracking(team_id) → team(id)
- order_schedule(purchase_order_id) → purchase_order(id)
- order_schedule(team_id) → team(id)
- location(team_id) → team(id)
- shipment(purchase_order_id) → purchase_order(id)
- shipment(team_id) → team(id)
- supplier_part_quantity(supplier_part_supplier_id) → supplier_part(supplier_id)
- supplier_part_quantity(supplier_part_part_id) → supplier_part(part_id)
- supplier_identifier(supplier_part_supplier_id) → supplier_part(supplier_id)
- supplier_identifier(supplier_part_part_id) → supplier_part(part_id)
- supplier_part_custom(supplier_part_supplier_id) → supplier_part(supplier_id)
- supplier_part_custom(supplier_part_part_id) → supplier_part(part_id)
- supplier_part(part_id) → part(id)
- supplier_part(supplier_id) → supplier(id)
- supplier(team_id) → team(id)
- part_identifier(part_id) → part(id)
- part_children(part_id) → part(id)
- part_parent(part_id) → part(id)
- part_tag(part_id) → part(id)
- part(team_id) → team(id)
- rule(team_id) → team(id)
- factory_capability(factory_id) → factory(id)
- factory(supplier_id) → supplier(id)
- factory(team_id) → team(id)
- payment_term(team_id) → team(id)
- order_milestone(purchase_order_id) → purchase_order(id)
- order_milestone(team_id) → team(id)
- workflow_milestone(workflow_id) → workflow(id)
- workflow(team_id) → team(id)