Salesforce: Account Daily History

Description

• Each record is a daily record in an account, starting with its first active date and updating up toward either the current date (if still active) or its last active date.

Supported Data Sources

• Salesforce

Columns

Type	Name	Description
STRING	account_day_id	Surrogate key hashed on date_day and account_id
DATE	date_day	Date on which the account had these field values.
STRING	account_id	The unique, system-generated ID assigned during creation.
DATETIME	_fivetran_start	The time when the record was first created or modified in the source, based on a timestamp value in the source table that monotonically increases over time with data change or update.
DATETIME	_fivetran_end	The time until which the record was active minus epsilon, where epsilon is the smallest time difference that can be stored in the timestamp type value.
DATE	_fivetran_date
STRING	history_unique_key	Surrogate key hashed on _fivetran_start and account_id.
BOOLEAN	_fivetran_active	true if it is the currently active record. false if it is a historical version of the record. Only one version of the record can be true.
DATETIME	_fivetran_synced	The time at which fivetran last synced this record.
INTEGER	account_number	Account number assigned to this account (not the unique, system-generated ID assigned during creation).
STRING	account_source	The source of the account record. For example, Advertisement, Data.com, or Trade Show.
DECIMAL	annual_revenue	Estimated annual revenue of the account.
STRING	billing_city	Details for the billing address of this account.
STRING	billing_country	Details for the billing address of this account.
STRING	billing_postal_code	Details for the billing address of this account.
STRING	billing_state	Details for the billing address of this account.
STRING	billing_street	Street address for the billing address of this account.
STRING	description
STRING	industry	An industry associated with this account.
BOOLEAN	is_deleted	Indicates whether the object has been moved to the Recycle Bin (true) or not (false).
DATETIME	last_activity_date	Value is one of the following, whichever is the most recent.
DATETIME	last_referenced_date	The timestamp when the current user last accessed this record, a record related to this record, or a list view.
DATETIME	last_viewed_date	The timestamp when the current user last viewed this record or list view. If this value is null, the user might have only accessed this record or list view (LastReferencedDate) but not viewed it.
STRING	master_record_id	If this object was deleted as the result of a merge, this field contains the ID of the record that was kept. If this object was deleted for any other reason, or has not been deleted, the value is null.
STRING	name
INTEGER	number_of_employees	Number of employees working at the company represented by this account.
STRING	owner_id	The ID of the user who currently owns this account.
INTEGER	ownership	Ownership type for the account, for example Private, Public, or Subsidiary.
INTEGER	parent_id	ID of the parent object, if any.
INTEGER	rating	The account’s prospect rating, for example Hot, Warm, or Cold.
STRING	record_type_id	ID of the record type assigned to this object.
INTEGER	shipping_city	Details of the shipping address for this account.
STRING	shipping_country	Details of the shipping address for this account. Country.
INTEGER	shipping_postal_code	Details of the shipping address for this account. Postal code.
INTEGER	shipping_state	Details of the shipping address for this account. State.
INTEGER	shipping_street	The street address of the shipping address for this account.
STRING	type	Type of account, for example, Customer, Competitor, or Partner.
STRING	website	The website of this account.
INTEGER	row_num