Anvyl
Explore the interactive ERD
Table & Field Reference
route
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
shipment_id | Unknown | PKFK |
team_id | Unknown | PKFK |
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 | PKFK |
team_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
track_shipment_requests_order_id | Unknown | PKFK |
shipment_consolidation_track_shipment_requests_id | Unknown |
shipment_consolidation
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
team_id | Unknown | PKFK |
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 | PKFK |
team_id | Unknown | PKFK |
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 | PKFK |
team_id | Unknown | PKFK |
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 | PKFK |
tracked_shipment_id | Unknown | PKFK |
tracked_shipment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
team_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
purchase_order_id | Unknown | PKFK |
team_id | Unknown | PKFK |
order_collection
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
purchase_order_id | Unknown | PKFK |
team_id | Unknown | PKFK |
name | Unknown | |
type | Unknown |
invoice_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
invoice_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
tags | Unknown |
purchase_order_invoice
| Column | Type | Keys |
|---|---|---|
invoice_id | Unknown | PKFK |
purchase_order_id | Unknown | PKFK |
purchase_order_shipment
| Column | Type | Keys |
|---|---|---|
purchase_order_id | Unknown | PKFK |
shipment_id | Unknown | PKFK |
purchase_order_item_custom
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
purchase_order_item_id | Unknown | PKFK |
purchase_order_item_purchase_order_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
task_id | Unknown | PKFK |
purchase_order
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
team_id | Unknown | PKFK |
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 | PKFK |
created_at | Unknown | |
email | Unknown | |
name | Unknown | |
updated_at | Unknown |
logistics_tracking
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
purchase_order_id | Unknown | PKFK |
team_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
supplier_part_supplier_id | Unknown | PKFK |
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 | PKFK |
supplier_part_supplier_id | Unknown | PKFK |
label | Unknown | |
value | Unknown |
supplier_part_custom
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
supplier_part_part_id | Unknown | PKFK |
supplier_part_supplier_id | Unknown | PKFK |
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 | PKFK |
supplier_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
label | Unknown | |
value | Unknown |
part_children
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
part_id | Unknown | PKFK |
part_parent
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
part_id | Unknown | PKFK |
part_tag
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
part_id | Unknown | PKFK |
tags | Unknown |
part
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
team_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
capability | Unknown |
factory
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
supplier_id | Unknown | PKFK |
team_id | Unknown | PKFK |
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 | PKFK |
created_at | Unknown | |
name | Unknown | |
updated_at | Unknown |
order_milestone
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
purchase_order_id | Unknown | PKFK |
team_id | Unknown | PKFK |
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 | PKFK |
custom_field_id | Unknown | |
name | Unknown | |
type | Unknown |
workflow
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
team_id | Unknown | PKFK |
created_at | Unknown | |
description | Unknown | |
is_enabled | Unknown | |
name | Unknown | |
updated_at | Unknown |