Pipe17

Explore the interactive ERD

Table & Field Reference

purchase_cost

Column	Type	Keys
`index`	Unknown	PK
`purchase_id`	String	PKFK
`cost`	Double
`name`	String
`quantity`	Long

purchase_line_item

Column	Type	Keys
`id`	String	PK
`purchase_id`	String	PKFK
`location_id`	String	FK
`sku`	String	FK
`name`	String
`price`	Double
`quantity`	Long
`received_quantity`	Long
`routed`	Boolean
`shipped_quantity`	Long
`upc`	String

purchase

Column	Type	Keys
`id`	String	PK
`billing_address_email`	String	FK
`external_order_id`	String	FK
`integration_id`	String	FK
`organization_key`	String	FK
`to_location_id`	String	FK
`vendor_address_email`	String	FK
`actual_arrival_date`	Instant
`billing_address_first_name`	String
`billing_address_last_name`	String
`created_at`	Instant
`currency`	String
`employee_name`	String
`expected_arrival_date`	Instant
`incoterms`	String
`purchase_notes`	String
`purchase_order_date`	Instant
`purchase_tax`	Double
`reference_number`	String
`ship_by_date`	Instant
`shipping_carrier`	String
`shipping_notes`	String
`shipping_service`	String
`status`	String
`sub_total_price`	Double
`time_stamp`	Instant
`to_address_first_name`	String
`to_address_last_name`	String
`total_price`	Double
`updated_at`	Instant
`vendor_address_first_name`	String
`vendor_address_last_name`	String
`custom_`

account_integration

Column	Type	Keys
`account_user_id`	String	PKFK
`integration_id`	String	PKFK

account_role_id

Column	Type	Keys
`role_id`	String	PK
`account_user_id`	String	PKFK
`id`	Unknown	FK

account_payment_sale_discount_code

Column	Type	Keys
`sales_discount_code`	String	PK
`account_user_id`	String	PKFK

account

Column	Type	Keys
`user_id`	String	PKFK
`organization_key`	String	FK
`activation_key`	String
`billingamount`	Double
`billingbase_period`	String
`billingcharge_enterprise_support`	Boolean
`billingdeleted_at`	Instant
`billingeffective_plan`	String
`billingnote`	String
`billingoverage_amount`	Double
`billingoverage_period`	String
`billingpaused_at`	Instant
`billingplan`	String
`billingquota`	Double
`billingrenewal_date`	Instant
`billingsource`	String
`billingstart_date`	Instant
`billingstatus`	String
`branding_copyright`	String
`branding_logo_url`	String
`branding_privacy_url`	String
`created_at`	Instant
`expiration_date`	Instant
`is_multi_organization_allowed`	Boolean
`is_rebranding_allowed`	Boolean
`payment_expiration_date`	Instant
`pricing_id`	String
`secondary_organization_limit`	Long
`status`	String
`updated_at`	Instant

inventory

Column	Type	Keys
`_fivetran_id`	String	PK
`integration_id`	String	FK
`location_id`	String	FK
`order_id`	String	FK
`organization_key`	String	FK
`sku`	String	FK
`user`	Unknown	FK
`available`	Long
`available_to_promise`	Long
`commit_ship`	Long
`commit_transferred`	Long
`committed`	Long
`committed_future`	Long
`created_at`	Instant
`entity_id`	String
`entity_type`	String
`event`	String
`future`	Long
`id`	String
`incoming`	Long
`on_hand`	Long
`order_type`	String
`quantity`	Long
`status`	String
`unavailable`	Long
`updated_at`	Instant
`user_id`	String

transfer_line_item

Column	Type	Keys
`id`	String	PK
`transfer_id`	String	PKFK
`location_id`	String	FK
`name`	String
`quantity`	Long
`received_quantity`	Long
`routed`	Boolean
`shipped_quantity`	Long
`sku`	String
`upc`	String

transfer

Column	Type	Keys
`id`	String	PK
`from_location_id`	String	FK
`integration_id`	String	FK
`organization_key`	String	FK
`to_location_id`	String	FK
`actual_arrival_date`	Instant
`created_at`	Instant
`employee_name`	String
`expected_arrival_date`	Instant
`expected_ship_date`	Instant
`external_order_id`	String
`incoterms`	String
`order_source_type`	String
`ship_by_date`	Instant
`shipping_carrier`	String
`shipping_notes`	String
`shipping_service`	String
`status`	String
`time_stamp`	String
`to_address_first_name`	String
`to_address_last_name`	String
`transfer_notes`	String
`transfer_order_date`	Instant
`updated_at`	Instant
`custom_`

product_published

Column	Type	Keys
`index`	Unknown	PK
`product_id`	String	PKFK
`integration_id`	String	FK
`buffer_inventory`	Long
`external_product_id`	String
`inventory_not_tracked`	Boolean
`name`	String
`sku`	Unknown
`status`	String
`updated_at`	Instant

product_bundle_item

Column	Type	Keys
`sku`	String	PK
`product_id`	String	PKFK
`quantity`	Long

product_variant_option

Column	Type	Keys
`index`	Unknown	PK
`product_id`	String	PKFK
`name`	String
`value`	String

product_price

Column	Type	Keys
`index`	Unknown	PK
`product_id`	String	PKFK
`currency`	String
`name`	String
`value`	Double

product_image_url

Column	Type	Keys
`image_url`	String	PK
`product_id`	String	PKFK

product_tag

Column	Type	Keys
`index`	Unknown	PK
`product_id`	String	PKFK
`tags`	String

product_type

Column	Type	Keys
`type`	String	PK
`product_id`	String	PKFK

product

Column	Type	Keys
`id`	String	PK
`integration_id`	String	FK
`mapped_product_integration_id`	String	FK
`organization_key`	String	FK
`cost`	Double
`cost_currency`	String
`country_of_origin`	String
`created_at`	Instant
`description`	String
`dimensions_unit`	String
`external_product_api_id`	String
`external_product_created_at`	Instant
`external_product_id`	String
`external_product_updated_at`	Instant
`harmonized_code`	String
`height`	Double
`hide_in_store`	Boolean
`inventory_not_tracked`	Boolean
`length`	Double
`mapped_product_buffer_inventory`	Long
`mapped_product_external_product_id`	String
`mapped_product_inventory_not_tracked`	Boolean
`mapped_product_name`	String
`mapped_product_sku`	String
`mapped_product_status`	String
`mapped_product_updated_at`	Instant
`name`	String
`parent_external_product_id`	String
`part_id`	String
`sku`	String
`status`	String
`taxable`	Boolean
`upc`	String
`updated_at`	Instant
`vendor`	String
`weight`	Double
`weight_unit`	String
`width`	Double
`custom_`

order_additional_charge

Column	Type	Keys
`line_item_id`	String	PKFK
`orders_id`	String	PKFK
`label`	String
`reference`	String
`type`	String
`value`	Double

order_discount

Column	Type	Keys
`index`	Unknown	PK
`orders_id`	String	PKFK
`line_item_id`	String	FK
`label`	String
`reference`	String
`type`	String
`value`	Double

order_payment

Column	Type	Keys
`index`	Unknown	PK
`orders_id`	String	PKFK
`amount`	Double
`conversion`	Long
`currency`	String
`custom_method`	String
`kind`	String
`method`	String
`reference`	String
`status`	String

order_line_item

Column	Type	Keys
`id`	String	PK
`orders_id`	String	PKFK
`location_id`	String	FK
`sku`	String	FK
`item_discount`	Double
`item_price`	Double
`item_tax`	Double
`name`	String
`quantity`	Long
`requires_shipping`	Boolean
`routed`	Boolean
`taxable`	Boolean
`custom_`

order_tag

Column	Type	Keys
`index`	Unknown	PK
`orders_id`	String	PKFK
`tags`	String

orders

Column	Type	Keys
`id`	String	PK
`billing_address_email`	String	FK
`customer_id`	Unknown	FK
`integration_id`	String	FK
`location_id`	String	FK
`organization_key`	String	FK
`shipping_address_email`	String	FK
`billing_address_first_name`	String
`billing_address_last_name`	String
`created_at`	Instant
`currency`	String
`expected_delivery_date`	Instant
`external_order_api_id`	String
`external_order_created_at`	Instant
`external_order_id`	String
`external_order_updated_at`	Instant
`external_order_url`	String
`fulfillment_status`	String
`gift_note`	String
`incoterms`	String
`order_discount`	Double
`order_note`	String
`order_source`	String
`order_source_type`	String
`order_tax`	Double
`payment_status`	String
`require_shipping_labels`	Boolean
`routing_status`	String
`ship_after_date`	Instant
`ship_by_date`	Instant
`ship_cancel_by_date`	Instant
`shipping_address_first_name`	String
`shipping_address_last_name`	String
`shipping_carrier`	String
`shipping_class`	String
`shipping_code`	String
`shipping_note`	String
`shipping_price`	Double
`status`	String
`sub_total_price`	Double
`time_stamp`	Instant
`total_price`	Double
`updated_at`	Instant
`custom_`

label

Column	Type	Keys
`id`	String	PK
`organization_key`	String	FK
`tracking_number`	String	FK
`content_type`	String
`created_at`	Instant
`file_name`	String
`label_type`	String
`shipping_method`	String
`status`	String
`updated_at`	Instant

customer

Column	Type	Keys
`id`	String	PK
`billing_email`	Unknown	FK
`organization_key`	String	FK
`shipping_email`	Unknown	FK
`company`	String
`created_at`	Instant
`display_name`	String
`email`	String
`external_customer_id`	String
`first_name`	String
`last_name`	String
`phone`	String
`status`	String
`updated_at`	Instant
`custom_`

mapping_attribute

Column	Type	Keys
`_fivetran_id`	String	PK
`mapping_id`	String	FK
`defaults`	Json
`enabled`	Boolean
`lookup`	Json
`missing`	String
`name`	String
`require`	String
`source`	String
`target`	String
`type`	String

mapping

Column	Type	Keys
`id`	String	PK
`connector_id`	String	FK
`organization_key`	String	FK
`created_at`	Instant
`description`	String
`is_public`	Boolean
`origin_id`	String
`updated_at`	Instant
`uuid`	String

user_role

Column	Type	Keys
`role`	String	PK
`users_id`	String	PKFK

users

Column	Type	Keys
`id`	String	PK
`email`	String	FK
`organization_key`	String	FK
`created_at`	Instant
`description`	String
`last_ip_address`	String
`last_login`	Instant
`logins_count`	Long
`name`	String
`phone`	String
`status`	String
`time_zone`	String
`updated_at`	Instant

connector_entity

Column	Type	Keys
`index`	Unknown	PK
`connector_id`	String	PKFK
`mapping_uuid`	String	FK
`routing_uuid`	String	FK
`direction`	String
`name`	String
`path`	Json

connector_action_field

Column	Type	Keys
`_fivetran_id`	String	PK
`connector_id`	String	FK
`groups`	String
`options_common`	Boolean
`options_component`	String
`options_default_value`	Json
`options_end_adornment`	String
`options_extra`	Json
`options_fields`	Json
`options_genkey`	String
`options_group`	String
`options_helper_text`	String
`options_hidden`	Boolean
`options_label`	String
`options_place_holder`	String
`options_read_me`	String
`options_read_only`	Boolean
`options_start_adornment`	String
`options_wizard`	Boolean
`path`	String
`secret`	Boolean
`type`	String

connector_action

Column	Type	Keys
`_fivetran_id`	String	PK
`connector_id`	String	FK
`action_name`	String
`action_type`	String
`description`	String
`verb`	String

connector

Column	Type	Keys
`id`	String	PK
`organization_key`	String	FK
`availability_status`	String
`capability`	Json
`connection_type`	String
`connection_url`	String
`connector_name`	String
`connector_type`	String
`created_at`	Instant
`description`	String
`display_name`	String
`intent_name`	String
`intent_rank`	Long
`intent_show`	Boolean
`is_public`	Boolean
`logo_url`	String
`organization_unique`	Boolean
`organization_wide_access`	Boolean
`pricing_category`	String
`rank`	Long
`read_me`	String
`self_service_mode`	String
`slug`	String
`status`	String
`updated_at`	Instant
`version`	String
`webhook_topics`	Json
`webhook_url`	String

connector_field

Column	Type	Keys
`_fivetran_id`	String	PK
`connector_id`	String	FK
`groups`	String
`options`	Json
`options_common`	Boolean
`options_component`	String
`options_default_value`	Json
`options_end_adornment`	String
`options_extra`	Json
`options_fields`	Json
`options_genkey`	String
`options_group`	String
`options_helper_text`	String
`options_hidden`	Boolean
`options_label`	String
`options_place_holder`	String
`options_read_me`	String
`options_read_only`	Boolean
`options_start_adornment`	String
`options_wizard`	Boolean
`path`	String
`secret`	Boolean
`status`	Unknown
`type`	String

location_external_system

Column	Type	Keys
`index`	Unknown	PK
`location_id`	String	PKFK
`integration_id`	String	FK
`location_value`	String

location

Column	Type	Keys
`id`	String	PK
`integration_id`	String	FK
`organization_key`	String	FK
`address_1`	String
`address_2`	String
`city`	String
`company`	String
`country`	String
`created_at`	Instant
`email`	String
`exclude_from_totals`	Boolean
`fulfillment_integration_id`	String
`infinite`	Boolean
`inventory_integration_id`	String
`merged_with_location_id`	String
`name`	String
`phone`	String
`preserve_bundles`	Boolean
`state_or_province`	String
`status`	String
`updated_at`	Instant
`zip_code_or_postal_code`	String

routing

Column	Type	Keys
`id`	String	PK
`organization_key`	String	FK
`created_at`	Instant
`description`	String
`enabled`	Boolean
`filter`	String
`is_public`	Boolean
`updated_at`	Instant
`uuid`	String

shipment_line_item

Column	Type	Keys
`id`	String	PK
`shipment_id`	String	PKFK
`sku`	String	FK
`bundle_quantity`	Long
`bundle_sku`	String
`item_price`	Double
`name`	String
`quantity`	Long
`shipped_quantity`	Long
`custom_`

shipment_shipping_label

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

shipment_tag

Column	Type	Keys
`index`	Unknown	PK
`shipment_id`	String	PKFK
`tags`	String

shipment

Column	Type	Keys
`id`	String	PK
`integration_id`	String	FK
`location_id`	String	FK
`order_id`	String	FK
`order_type`	String	FK
`organization_key`	String	FK
`created_at`	Instant
`expected_delivery_date`	Instant
`expected_ship_date`	Instant
`external_order_id`	String
`external_reference_id`	String
`external_reference_url`	String
`external_shipment_id`	String
`fulfillment_integration_id`	String
`gift_note`	String
`incoterms`	String
`order_create_time`	String
`sent_to_fulfillment_at`	Instant
`ship_after_date`	Instant
`ship_by_date`	Instant
`ship_cancel_by_date`	Instant
`shipping_address_first_name`	String
`shipping_address_last_name`	String
`shipping_carrier`	String
`shipping_class`	String
`shipping_code`	String
`shipping_method_mapping`	Boolean
`shipping_note`	String
`status`	String
`updated_at`	Instant
`version`	Long
`custom_`

fulfillment_line_item

Column	Type	Keys
`fulfillment_id`	String	PKFK
`sku`	String	PKFK
`unique_id`	String	FK
`bundle_quantity`	Long
`bundle_quantity_partial`	Json
`bundle_sku`	String
`quantity`	Long

fulfillment_tracking_number

Column	Type	Keys
`tracking_number`	String	PK
`fulfillment_id`	String	PKFK

fulfillment_tracking_url

Column	Type	Keys
`tracking_url`	String	PK
`fulfillment_id`	String	PKFK

fulfillment

Column	Type	Keys
`id`	String	PK
`integration_id`	String	FK
`location_id`	String	FK
`organization_key`	String	FK
`shipment_id`	String	FK
`actual_ship_date`	Instant
`created_at`	Instant
`expected_arrival_date`	Instant
`external_fulfillment_id`	String
`external_order_id`	String
`shipping_carrier`	String
`shipping_charge`	Double
`shipping_class`	String
`updated_at`	Instant
`weight`	Double
`weight_unit`	String
`custom_`

supplier_contact

Column	Type	Keys
`email`	String	PK
`supplier_id`	String	PKFK
`organization_key`	Unknown	FK
`first_name`	String
`last_name`	String
`phone`	String

supplier

Column	Type	Keys
`id`	String	PK
`organization_key`	String	FK
`address_address_1`	String
`address_address_2`	String
`address_city`	String
`address_country`	String
`address_state_or_province`	String
`address_zip_code_or_postal_code`	String
`created_at`	Instant
`name`	String
`updated_at`	Instant

organization_setting

Column	Type	Keys
`index`	Unknown	PK
`organization_key`	String	PKFK
`path`	String
`type`	String
`value`	Json

organization

Column	Type	Keys
`organization_key`	String	PK
`account_id`	String	FK
`email`	String	FK
`branding_copyright`	String
`branding_logo_url`	String
`branding_privacy_url`	String
`created_at`	Instant
`is_holding_organization`	Boolean
`logo_url`	String
`name`	String
`organization_mode`	String
`phone`	String
`status`	String
`tier`	String
`time_zone`	String
`updated_at`	Instant

role

Column	Type	Keys
`id`	String	PK
`organization_key`	String	FK
`created_at`	Instant
`description`	String
`is_public`	Boolean
`name`	String
`status`	String
`updated_at`	Instant

arrival_line_item

Column	Type	Keys
`id`	String	PK
`arrival_id`	String	PKFK
`unique_id`	Unknown	FK
`name`	String
`quantity`	Long
`received_quantity`	Long
`sku`	String
`upc`	String

arrival

Column	Type	Keys
`id`	String	PK
`from_location_id`	String	FK
`fulfillment_id`	String	FK
`integration_id`	String	FK
`organization_key`	String	FK
`purchase_id`	String	FK
`to_location_id`	String	FK
`transfer_id`	String	FK
`created_at`	Instant
`expected_arrival_date`	Instant
`external_arrival_id`	String
`external_order_id`	String
`incoterms`	String
`sender_name`	String
`shipping_carrier`	String
`shipping_method`	String
`shipping_note`	String
`status`	String
`total_weight`	String
`updated_at`	Instant
`weight_unit`	String
`custom_`

inventory_rule

Column	Type	Keys
`id`	String	PK
`integration_id`	String	FK
`organization_key`	String	FK
`created_at`	Instant
`description`	String
`event`	String
`partner`	String
`ptype`	String
`rule`	String
`status`	String
`updated_at`	Instant

receipt_line_item

Column	Type	Keys
`id`	String	PK
`receipt_id`	String	PKFK
`quantity`	Long
`sku`	String

receipt

Column	Type	Keys
`id`	String	PK
`arrival_id`	String	FK
`integration_id`	String	FK
`organization_key`	String	FK
`created_at`	Instant
`currency`	String
`external_order_id`	String
`external_receipt_id`	String
`shipping_carrier`	String
`shipping_class`	String
`updated_at`	Instant
`custom_`

tracking

Column	Type	Keys
`id`	String	PK
`fulfillment_id`	String	FK
`organization_key`	String	FK
`actual_arrival_date`	Instant
`actual_ship_date`	Instant
`created_at`	Instant
`expected_arrival_date`	Instant
`shipping_carrier`	String
`status`	String
`tracking_number`	String
`updated_at`	Instant
`url`	String

shipping_method_mapped_method

Column	Type	Keys
`method_id`	String	PK
`shipping_method_id`	String	PKFK

shipping_method

Column	Type	Keys
`id`	String	PK
`integration_id`	String	FK
`organization_key`	String	FK
`created_at`	Instant
`description`	String
`external_method_id`	String
`is_default`	Boolean
`is_passthrough`	Boolean
`name`	String
`shipping_carrier`	String
`shipping_code`	String
`shipping_service`	String
`source_integration_id`	String
`source_type`	String
`status`	String
`updated_at`	Instant

integration_entity_restriction

Column	Type	Keys
`_fivetran_id`	String	PK
`integration_id`	String	PKFK
`path`	String
`type`	String
`value`	Json

integration_entity

Column	Type	Keys
`_fivetran_id`	String	PK
`integration_id`	String	PKFK
`mapping_uuid`	String	FK
`routing_uuid`	String	FK
`direction`	String
`name`	String

integration_connection_field

Column	Type	Keys
`index`	Unknown	PK
`integration_id`	String	PKFK
`path`	String
`value`	Json

integration_setting_field

Column	Type	Keys
`index`	Unknown	PK
`integration_id`	String	PKFK
`path`	String
`value`	Json

integration

Column	Type	Keys
`id`	String	PK
`connector_id`	String	FK
`organization_key`	String	FK
`capability`	Json
`connector_name`	String
`created_at`	Instant
`environment`	String
`error_text`	String
`integration_name`	String
`status`	String
`updated_at`	Instant
`variables_property_1_type`	String
`variables_property_1_value`	Json
`variables_property_2_type`	String
`variables_property_2_value`	Json
`version`	String

action_param

Column	Type	Keys
`index`	Unknown	PK
`integration_action_id`	String	PKFK
`path`	String
`value`	Json

integration_action

Column	Type	Keys
`id`	String	PK
`integration_id`	String	FK
`organization_key`	String	FK
`action_name`	String
`action_type`	String
`created_at`	Instant
`progress`	Long
`status`	String
`updated_at`	Instant