Fivetran documentation

Search the docs

/

EasyPost

Explore the interactive ERD

Table & Field Reference

insurance

Column	Type	Keys
`id`	Unknown	PK
`from_address_id`	Unknown	FK
`shipment_id`	Unknown	FK
`to_address_id`	Unknown	FK
`tracking_code`	Unknown	FK
`amount`	Unknown
`created_at`	Unknown
`fee_amount`	Unknown
`fee_charged`	Unknown
`fee_object`	Unknown
`fee_refunded`	Unknown
`fee_type`	Unknown
`messages`	Json
`mode`	Unknown
`provider`	Unknown
`reference`	Unknown
`status`	Unknown
`tracker`	Unknown
`updated_at`	Unknown

address

Column	Type	Keys
`id`	Unknown	PK
`carrier_facility`	Unknown
`city`	Unknown
`company`	Unknown
`country`	Unknown
`created_at`	Instant
`email`	Unknown
`federal_tax_id`	Unknown
`mode`	Unknown
`name`	Unknown
`phone`	Unknown
`residential`	Unknown
`state`	Unknown
`state_tax_id`	Unknown
`street_1`	Unknown
`street_2`	Unknown
`updated_at`	Unknown
`verification_zip_4_details`	Unknown
`verification_zip_4_success`	Boolean
`verifications_delivery_latitude`	Unknown
`verifications_delivery_longitude`	Unknown
`verifications_delivery_success`	Unknown
`verifications_delivery_time_zone`	Unknown
`zip`	Unknown

address_error

Column	Type	Keys
`_fivetran_id`	Unknown	PK
`address_id`	Unknown	FK
`code`	Unknown
`field`	Unknown
`message`	Unknown
`suggestion`	Unknown
`type`	Unknown

end_shipper

Column	Type	Keys
`id`	Unknown	PK
`city`	Unknown
`company`	Unknown
`country`	Unknown
`created_at`	Unknown
`email`	Unknown
`mode`	Unknown
`name`	Unknown
`phone`	Unknown
`state`	Unknown
`street_1`	Unknown
`street_2`	Unknown
`updated_at`	Unknown
`zip`	Unknown

scan_form_tracking_code

Column	Type	Keys
`tracking_code`	Unknown	PK
`scan_form_id`	Unknown	PKFK

scan_form

Column	Type	Keys
`id`	Unknown	PK
`address_id`	Unknown	FK
`batch_id`	Unknown	FK
`confirmation`	Unknown
`created_at`	Unknown
`form_file_type`	Unknown
`message`	Unknown
`status`	Unknown
`updated_at`	Unknown

batch_shipment

Column	Type	Keys
`id`	Unknown	PK
`batch_id`	Unknown	FK
`batch_message`	Unknown
`batch_status`	Unknown
`reference`	Unknown
`tracking_code`	Unknown

batch

Column	Type	Keys
`id`	Unknown	PK
`scan_form_id`	Unknown	FK
`created_at`	Unknown
`mode`	Unknown
`pickup`	Unknown
`reference`	Unknown
`state`	Unknown
`status_created`	Unknown
`status_creation_failed`	Unknown
`status_postage_purchase_failed`	Unknown
`status_postage_purchased`	Unknown
`status_queued_for_purchase`	Unknown
`updated_at`	Unknown

tracker_detail

Column	Type	Keys
`_fivetran_id`	String	PK
`tracker_id`	Unknown	FK
`carrier_code`	Unknown
`datetime`	Unknown
`description`	Unknown
`message`	Unknown
`source`	Unknown
`status`	Unknown
`status_detail`	Unknown

tracker

Column	Type	Keys
`id`	Unknown	PK
`shipment_id`	Unknown	FK
`carrier`	Unknown
`carrier_alternate_identifier`	Unknown
`carrier_container_type`	Unknown
`carrier_destination_location`	Unknown
`carrier_destination_tracking_location`	Unknown
`carrier_est_delivery_date_local`	Unknown
`carrier_est_delivery_time_local`	Unknown
`carrier_guaranteed_delivery_date`	Unknown
`carrier_initial_delivery_attempt`	Unknown
`carrier_object`	Unknown
`carrier_origin_location`	Unknown
`carrier_origin_tracking_city`	Unknown
`carrier_origin_tracking_country`	Unknown
`carrier_origin_tracking_object`	Unknown
`carrier_origin_tracking_state`	Unknown
`carrier_origin_tracking_zip`	Unknown
`carrier_service`	Unknown
`created_at`	Unknown
`est_delivery_date`	Unknown
`fees`	Json
`mode`	Unknown
`public_url`	Unknown
`signed_by`	Unknown
`status`	Unknown
`status_detail`	Unknown
`tracking_code`	Unknown
`updated_at`	Unknown
`weight`	Unknown

shipment_rate

Column	Type	Keys
`id`	Unknown	PK
`shipment_id`	Unknown	FK
`billing_type`	Unknown
`carrier`	Unknown
`carrier_account_id`	Unknown
`created_at`	Unknown
`currency`	Unknown
`delivery_date`	Unknown
`delivery_date_guaranteed`	Unknown
`delivery_days`	Unknown
`est_delivery_days`	Unknown
`list_currency`	Unknown
`list_rate`	Unknown
`mode`	Unknown
`object`	Unknown
`rate`	Unknown
`retail_currency`	Unknown
`retail_rate`	Unknown
`service`	Unknown
`updated_at`	Unknown

shipment_fee

Column	Type	Keys
`_fivetran_id`	String	PK
`shipment_id`	Unknown	FK
`amount`	Unknown
`charged`	Unknown
`object`	Unknown
`refunded`	Unknown
`type`	Unknown

shipment_message

Column	Type	Keys
`_fivetran_id`	String	PK
`shipment_id`	Unknown	FK
`carrier`	Unknown
`carrier_account_id`	Unknown
`message`	Unknown
`type`	Unknown

shipment_parcel

Column	Type	Keys
`id`	Unknown	PK
`shipment_id`	Unknown	FK
`created_at`	Unknown
`height`	Unknown
`length`	Unknown
`mode`	Unknown
`object`	Unknown
`predefined_package`	Unknown
`updated_at`	Unknown
`weight`	Unknown
`width`	Unknown

shipment_custom_item

Column	Type	Keys
`id`	Unknown	PK
`shipment_custom_info_id`	Unknown	FK
`code`	Unknown
`created_at`	Unknown
`currency`	Unknown
`description`	Unknown
`eccn`	Unknown
`hs_tariff_number`	Unknown
`manufacturer`	Unknown
`mode`	Unknown
`object`	Unknown
`origin_country`	Unknown
`printed_commodity_identifier`	Unknown
`quantity`	Unknown
`updated_at`	Unknown
`value`	Unknown
`weight`	Unknown

shipment_custom_info

Column	Type	Keys
`id`	Unknown	PK
`shipment_id`	Unknown	FK
`contents_explanation`	Unknown
`contents_type`	Unknown
`created_at`	Unknown
`customs_certify`	Unknown
`customs_signer`	Unknown
`declaration`	Unknown
`eel_pfc`	Unknown
`mode`	Unknown
`non_delivery_option`	Unknown
`object`	Unknown
`restriction_comments`	Unknown
`restriction_type`	Unknown
`updated_at`	Unknown

shipment

Column	Type	Keys
`id`	Unknown	PK
`batch_id`	Unknown	FK
`buyer_address_id`	Unknown	FK
`from_address_id`	Unknown	FK
`return_address_id`	Unknown	FK
`scan_form_id`	Unknown	FK
`selected_rate_id`	Unknown	FK
`to_address_id`	Unknown	FK
`tracker_id`	Unknown	FK
`created_at`	Unknown
`forms`	Json
`insurance`	Unknown
`is_return`	Unknown
`mode`	Unknown
`object`	Unknown
`postage_abel_date`	Unknown
`postage_created_at`	Unknown
`postage_date_advance`	Unknown
`postage_id`	Unknown
`postage_integrated_form`	Unknown
`postage_label_epl_2_url`	Unknown
`postage_label_file`	Unknown
`postage_label_file_type`	Unknown
`postage_label_pdf_url`	Unknown
`postage_label_resolution`	Unknown
`postage_label_size`	Unknown
`postage_label_type`	Unknown
`postage_label_url`	Unknown
`postage_label_zpl_url`	Unknown
`postage_object`	Unknown
`postage_updated_at`	Unknown
`refund_status`	Unknown
`status`	Unknown
`updated_at`	Unknown
`usps_zone`	Unknown
`option_`

shipment_invoice_report

Column	Type	Keys
`shipment_id`	Unknown	PKFK
`adjustment_amount`	Unknown
`adjustment_reason`	Unknown
`captured_currency`	Unknown
`captured_height`	Unknown
`captured_length`	Unknown
`captured_package`	Unknown
`captured_service`	Unknown
`captured_weight`	Unknown
`captured_width`	Unknown
`carrier`	Unknown
`carrier_account_id`	Unknown
`carrier_invoice_id`	Unknown
`claimed_height`	Unknown
`claimed_length`	Unknown
`claimed_package`	Unknown
`claimed_service`	Unknown
`claimed_weight`	Unknown
`claimed_width`	Unknown
`clawback_payment_log`	Unknown
`final_invoice_amount`	Unknown
`initially_paid_amount`	Unknown
`initially_paid_payment_log`	Unknown
`invoice_date`	Unknown
`invoice_payment_log`	Unknown
`label_date`	Unknown
`package_dispute_id`	Unknown
`quoted_amount`	Unknown
`quoted_currency`	Unknown
`refund_payment_log`	Unknown
`status`	Unknown
`tracking_code`	Unknown
`user_id`	Unknown
`user_parent_id`	Unknown

cash_flow_report

Column	Type	Keys
`_fivetran_id`	String	PK
`bank_account_refund`	Unknown
`bank_debits`	Unknown
`carbon_offset_fees`	Unknown
`credit_card_debits`	Unknown
`credit_card_fees`	Unknown
`credit_card_refund`	Unknown
`date`	Unknown
`dispute_reinstatements`	Unknown
`dispute_withdrawals`	Unknown
`end_balance`	Unknown
`insurance_fees`	Unknown
`invoice_adjustment_fees`	Unknown
`label_fees`	Unknown
`manual_credits`	Unknown
`manual_debits`	Unknown
`payment_failure_deduction`	Unknown
`postage_fees`	Unknown
`refunds`	Unknown
`start_balance`	Unknown
`total_fees`	Unknown
`tracker_fees`	Unknown
`user_id`	Unknown
`utc_offset`	Unknown
`wire_transfer_debits`	Unknown

payment_log_report

Column	Type	Keys
`id`	Unknown	PK
`shipment_id`	Unknown	FK
`amount`	Unknown
`balance`	Unknown
`charge_type`	Unknown
`created_at`	Unknown
`description`	Unknown
`source_type`	Unknown
`status`	Unknown
`target_type`	Unknown