---
title: "account (Odoo)"
description: "itgen_odoo_account"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.social.account
original: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.social.account
updated: 2023-03-01T15:29:04Z
license: https://documentation.invantive.eu/en/
---

# account: Odoo itgen_odoo_account

`read only` `per partition`

- Catalog: `Odoo`
- Schema: `social`
- Label: itgen_odoo_account

Social Account

Can only retrieve data.

## Summary

A social.account represents an actual account on the related social.media.
    Ex: A Facebook Page or a Twitter Account.

    These social.accounts will then be used to send generic social.posts to multiple social.accounts.
    They are also used to display a 'dashboard' of statistics on the 'Feed' view.

    Account statistic fields are 'computed' manually through the _compute_statistics method
    that is overridden by each actual social module implementations (social_facebook, social_twitter, ...).
    The statistics computation is run manually when visualizing the Feed.

## Table Columns

The columns of the table `account` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `active` | `boolean` | Active | [ ] |  |  |
| `audience` | `int32` | Audience | [ ] |  | General audience of the Social Account (Page Likes, Account Follows, ...). |
| `audience_trend` | `numeric` | Audience Trend | [ ] |  | Percentage of increase/decrease of the audience over a defined period. |
| `company_id` | `varchar2` |  | [ ] |  | Link an account to a company to restrict its usage or keep empty to let all companies use it. |
| `company_id_label` | `varchar2` |  | [ ] |  | Link an account to a company to restrict its usage or keep empty to let all companies use it. |
| `create_date` | `datetime` | Created on | [ ] |  |  |
| `create_uid` | `varchar2` |  | [ ] |  |  |
| `create_uid_label` | `varchar2` |  | [ ] |  |  |
| `display_name` | `varchar2` | Display Name | [ ] |  |  |
| `engagement` | `int32` | Engagement | [ ] |  | Number of people engagements with your posts (Likes, Comments, ...). |
| `engagement_trend` | `numeric` | Engagement Trend | [ ] |  | Percentage of increase/decrease of the engagement over a defined period. |
| `facebook_access_token` | `varchar2` | Facebook Access Token | [ ] |  | Facebook Page Access Token provided by the Facebook API, this should never be set manually.             It's used to authenticate requests when posting to or reading information from this account. |
| `facebook_account_id` | `varchar2` | Facebook Account ID | [ ] |  | Facebook Page ID provided by the Facebook API, this should never be set manually. |
| `firebase_admin_key_file` | `varbinary` | Firebase Admin Key File | [ ] |  |  |
| `firebase_project_id` | `varchar2` | Firebase Project ID | [ ] |  |  |
| `firebase_push_certificate_key` | `varchar2` | Firebase Push Certificate Key | [ ] |  |  |
| `firebase_sender_id` | `varchar2` | Firebase Sender ID | [ ] |  |  |
| `firebase_use_own_account` | `boolean` | Use your own Firebase account | [ ] |  |  |
| `firebase_web_api_key` | `varchar2` | Firebase Web API Key | [ ] |  |  |
| `has_account_stats` | `boolean` | Has Account Stats | [ ] |  | Defines whether this account has Audience/Engagements/Stories stats.         Account with stats are displayed on the dashboard. |
| `has_trends` | `boolean` | Has Trends? | [ ] |  | Defines whether this account has statistics tends or not. |
| `id` | `int32` | ID | [ ] |  |  |
| `image` | `varbinary` | Image | [ ] |  |  |
| `instagram_access_token` | `varchar2` | Instagram Access Token | [ ] |  | Instagram Access Token provided by the Facebook API, this should never be set manually.         It's used to authenticate requests when posting to or reading information from this account. |
| `instagram_account_id` | `varchar2` | Instagram Account ID | [ ] |  | Instagram Account ID provided by the Facebook API, this should never be set manually. |
| `instagram_facebook_account_id` | `varchar2` | Instagram Facebook Account ID | [ ] |  | Facebook Account ID provided by the Facebook API, this should never be set manually.         The Instagram ("Professional") account is always linked to a Facebook account. |
| `is_media_disconnected` | `boolean` | Link with external Social Media is broken | [ ] |  |  |
| `linkedin_access_token` | `varchar2` | LinkedIn access token | [ ] |  | The access token is used to perform request to the REST API |
| `linkedin_account_id` | `varchar2` | LinkedIn Account ID | [ ] |  |  |
| `linkedin_account_urn` | `varchar2` | LinkedIn Account URN | [ ] |  | LinkedIn Account URN |
| `media_id` | `varchar2` |  | [ ] |  | Related Social Media (Facebook, Twitter, ...). |
| `media_id_label` | `varchar2` |  | [ ] |  | Related Social Media (Facebook, Twitter, ...). |
| `media_type` | `varchar2` | Media Type | [ ] |  | Used to make comparisons when we need to restrict some features to a specific media ('facebook', 'twitter', ...). |
| `name` | `varchar2` | Name | [x] |  |  |
| `notification_request_body` | `varchar2` | Notification Request Text | [ ] |  |  |
| `notification_request_delay` | `int32` | Notification Request Delay (seconds) | [ ] |  |  |
| `notification_request_icon` | `varbinary` | Notification Request Icon | [ ] |  |  |
| `notification_request_title` | `varchar2` | Notification Request Title | [ ] |  |  |
| `social_account_handle` | `varchar2` | Handle / Short Name | [ ] |  | Contains the social media handle of the person that created this account. E.g: '@odoo.official' for the 'Odoo' Twitter account |
| `stats_link` | `varchar2` | Stats Link | [ ] |  | Link to the external Social Account statistics |
| `stories` | `int32` | Stories | [ ] |  | Number of stories created from your posts (Shares, Re-tweets, ...). |
| `stories_trend` | `numeric` | Stories Trend | [ ] |  | Percentage of increase/decrease of the stories over a defined period. |
| `twitter_oauth_token` | `varchar2` | Twitter OAuth Token | [ ] |  |  |
| `twitter_oauth_token_secret` | `varchar2` | Twitter OAuth Token Secret | [ ] |  |  |
| `twitter_user_id` | `varchar2` | Twitter User ID | [ ] |  |  |
| `utm_medium_id` | `varchar2` |  | [ ] |  | Every time an account is created, a utm.medium is also created and linked to the account |
| `utm_medium_id_label` | `varchar2` |  | [ ] |  | Every time an account is created, a utm.medium is also created and linked to the account |
| `website_id` | `varchar2` |  | [ ] |  | This firebase configuration will only be used for the specified website |
| `website_id_label` | `varchar2` |  | [ ] |  | This firebase configuration will only be used for the specified website |
| `write_date` | `datetime` | Last Updated on | [ ] |  |  |
| `write_uid` | `varchar2` |  | [ ] |  |  |
| `write_uid_label` | `varchar2` |  | [ ] |  |  |
| `youtube_access_token` | `varchar2` | Google Access Token | [ ] |  | Access token provided by the YouTube API, this should never be set manually. |
| `youtube_channel_id` | `varchar2` | YouTube Channel ID | [ ] |  | YouTube Channel ID provided by the YouTube API, this should never be set manually. |
| `youtube_refresh_token` | `varchar2` | Google Refresh Token | [ ] |  | Refresh token provided by the YouTube API, this should never be set manually. |
| `youtube_token_expiration_date` | `datetime` | Token expiration date | [ ] |  | Expiration date of the Access Token provided by the YouTube API, this should never be set manually. |
| `youtube_upload_playlist_id` | `varchar2` | YouTube Upload Playlist ID | [ ] |  | 'Uploads' Playlist ID provided by the YouTube API, this should never be set manually. |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Odoo](/en/release-notes/drivers?driver=odoo)

