Fivetran documentation

Search the docs

/

Clari

Explore the interactive ERD

Table & Field Reference

opportunity_field

Column	Type	Keys
`id`	Unknown	PK
`opportunity_id`	Unknown	PKFK
`alias`	Unknown
`image_url`	Unknown
`trend`	Unknown

opportunity_trend_history

Column	Type	Keys
`index`	Unknown	PK
`opportunity_id`	Unknown	PKFK
`date`	Unknown
`new_value`	Unknown
`old_value`	Unknown

opportunity

Column	Type	Keys
`id`	Unknown	PKFK
`crm_score`	Unknown
`crm_score_message`	Unknown

item

Column	Type	Keys
`_fivetran_id`	String	PK
`actor_id`	Unknown
`actor_type`	Unknown
`correlation_id`	Unknown
`event`	Unknown
`event_parameters`	Unknown
`event_timestamp_epoch_second`	Unknown
`event_timestamp_nano`	Unknown
`impersonating_actor_id`	Unknown
`ip_address`	Unknown
`session_id`	Unknown
`session_type`	Unknown

actor

Column	Type	Keys
`actor_id`	Unknown	PKFK
`actor_type`	Unknown
`email`	Unknown
`name`	Unknown

administrative

Column	Type	Keys
`_fivetran_id`	String	PK
`available_concurrent_limit`	Unknown
`available_monthly_quota`	Unknown
`concurrent_limit`	Unknown
`monthly_quota`	Unknown
`running_job_ids`	Json
`submitted_job_ids`	Json

time_frame

Column	Type	Keys
`forecast_id`	String	PK
`forecast_type`	Unknown	PK
`time_frame_id`	Unknown	PK
`end_date`	Unknown
`start_date`	Unknown

forecast_entry

Column	Type	Keys
`forecast_id`	String	PK
`forecast_type`	Unknown	PK
`field_id`	Unknown	PKFK
`time_frame_id`	Unknown	PKFK
`time_period_id`	Unknown	PKFK
`user_id`	Unknown	PKFK
`adjusted_by`	Unknown
`adjusted_on`	Unknown
`adjustment_value`	Unknown
`aggregation_total`	Unknown
`currency_code`	Unknown
`currency_symbol`	Unknown
`forecast_value`	Unknown
`is_updated`	Unknown
`quota_value`	Unknown
`updated_by`	Unknown
`updated_on`	Unknown

users

Column	Type	Keys
`forecast_id`	String	PK
`forecast_type`	Unknown	PK
`user_id`	Unknown	PK
`crm_id`	Unknown
`email`	Unknown
`hierarchy_id`	Unknown
`hierarchy_name`	Unknown
`name`	Unknown
`parent_hierarchy_id`	Unknown
`parent_hierarchy_name`	Unknown
`scope_id`	Unknown

field

Column	Type	Keys
`field_id`	Unknown	PK
`forecast_id`	String	PK
`forecast_type`	Unknown	PK
`field_name`	Unknown
`field_type`	Unknown

time_period

Column	Type	Keys
`forecast_id`	String	PK
`forecast_type`	Unknown	PK
`time_period_id`	Unknown	PK
`end_date`	Unknown
`label`	Unknown
`start_date`	Unknown
`type`	Unknown
`year`	Unknown

activity_account

Column	Type	Keys
`id`	Unknown	PK
`activity_id`	Unknown	PKFK
`name`	Unknown
`owner_id`	Unknown

activity_opportunity

Column	Type	Keys
`id`	Unknown	PK
`activity_id`	Unknown	PKFK
`name`	Unknown
`owner_id`	Unknown

activity_participant

Column	Type	Keys
`index`	Unknown	PK
`activity_id`	Unknown	PKFK
`email`	Unknown
`is_internal`	Unknown
`name`	Unknown
`sfdc_user_id`	Unknown

activity

Column	Type	Keys
`id`	Unknown	PK
`date`	Unknown
`organiser_id`	Unknown
`owner_id`	Unknown
`subject`	Unknown
`type`	Unknown