Fivetran documentation

Search the docs

/

Duoplane

Explore the interactive ERD

Table & Field Reference

shipment_tracking_attribute

Column	Type	Keys
`id`	String	PK
`tracking`	String	PK
`shipment_id`	String	FK
`tracking_url`	String

shipment_item_serial_code

Column	Type	Keys
`serial_code`	String	PK
`shipment_item_attribute_id`	String	PKFK
`shipment_item_attribute_order_item_id`	String	PKFK

shipment_item_attribute

Column	Type	Keys
`id`	String	PK
`order_item_id`	String	PK
`shipment_id`	String	FK
`cost`	Double
`order_item_name`	String
`quantity`	Int

shipment

Column	Type	Keys
`id`	String	PK
`created_at`	Instant
`purchase_order_id`	String
`purchase_order_public_reference`	String
`shipper_id`	String
`shipper_invoice_reference`	String
`shipper_name`	String
`shipper_scac_code`	String
`shipper_shipping_cost`	Double
`updated_at`	Instant
`vendor_handling_cost`	Double
`vendor_invoice_reference`	String
`vendor_shipping_cost`	Double
`vendor_tax_cost`	Double

purchase_order_item_note

Column	Type	Keys
`_fivetran_id`	String	PK
`purchase_order_item_id`	String	FK
`body`	String
`title`	String

purchase_order_item_comment

Column	Type	Keys
`id`	String	PK
`purchase_order_item_id`	String	FK
`body`	String
`commentator_company_name`	String
`recipient_company_name`	String

purchase_order_item

Column	Type	Keys
`id`	String	PK
`purchase_order_id`	String	FK
`cost`	Double
`mpn`	String
`name`	String
`net_price`	Double
`order_id`	String
`other_barcode`	String
`price`	Double
`promise_date`	LocalDate
`quantity`	Int
`quantity_open`	Int
`retailer_product_id`	String
`retailer_sku`	String
`total_discount`	Double
`upc`	String
`vendor_sku`	String

purchase_order_note

Column	Type	Keys
`_fivetran_id`	String	PK
`purchase_order_id`	String	FK
`body`	String
`title`	String

purchase_order

Column	Type	Keys
`id`	String	PK
`created_at`	Instant
`customer_note`	String
`order_id`	String
`order_public_reference`	String
`ordered_at`	Instant
`promise_date`	LocalDate
`public_reference`	String
`retailer_account`	String
`retailer_id`	String
`retailer_name`	String
`sent_at`	Instant
`ship_method`	String
`shipping_address_address_1`	String
`shipping_address_address_2`	String
`shipping_address_city`	String
`shipping_address_company_name`	String
`shipping_address_country`	String
`shipping_address_email`	String
`shipping_address_first_name`	String
`shipping_address_last_name`	String
`shipping_address_phone`	String
`shipping_address_post_code`	String
`shipping_address_province`	String
`shipping_address_province_iso`	String
`status`	String
`store_name`	String
`total_shipping_revenue`	Double
`total_tax`	Double
`updated_at`	Instant
`vendor`	String
`vendor_account`	String
`vendor_id`	String
`vendor_reference`	String

product_inventory

Column	Type	Keys
`id`	String	PK
`product_id`	String	FK
`actual_leadtime_days`	Int
`backordered_until`	Unknown
`cost`	Double
`manage_inventory`	String
`purchase_name`	String
`quantity_available`	Int
`vendor_id`	String
`vendor_name`	String
`vendor_sku`	String

store_product

Column	Type	Keys
`id`	String	PK
`product_id`	String	FK
`inventory_quantity_buffer`	String
`store_id`	String
`store_name`	String
`store_product_type`	String
`store_reference_unique`	String
`vendor_store_reference`	String

product

Column	Type	Keys
`id`	String	PK
`created_at`	Instant
`deactivated_at`	Unknown
`mpn`	String
`name`	String
`other_barcode`	String
`price`	String
`price_map`	String
`price_msrp`	String
`product_type`	String
`retailer_sku`	String
`upc`	String
`updated_at`	Instant

order_vendor_comment

Column	Type	Keys
`id`	String	PK
`purchase_order_id`	String	FK
`body`	String
`commentable_id`	String
`commentable_type`	String
`commenter_email`	String
`commenter_full_name`	String
`created_at`	Instant
`recipient_company_id`	String
`recipient_company_name`	String
`updated_at`	Instant

order_retailer_comment

Column	Type	Keys
`id`	String	PK
`purchase_order_item_id`	String	FK
`body`	String
`commentable_id`	String
`commentable_type`	String
`commenter_email`	String
`commenter_full_name`	String
`created_at`	Instant
`recipient_company_id`	String
`recipient_company_name`	String
`updated_at`	Instant