# 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

* <img src="https://fivetran.com/integrations/salesforce/resources/salesforce.svg" alt="" data-size="line"> 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               |                                                                                                                                                                                                           |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://endash-guidance-docs.gitbook.io/cigro-data-templates/data-model-templates/salesforce-account-daily-history.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.