Windsor brings all your Insightly data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Insightly Field Reference
Fields
ID | Type | Name | Description | Report |
---|---|---|---|---|
activity_sets__ACTIVITIES | OBJECT | activity_sets.ACTIVITIES | activity_sets.ACTIVITIES | activity_sets |
activity_sets__ACTIVITYSET_ID | NUMERIC | activity_sets.ACTIVITYSET_ID | activity_sets.ACTIVITYSET_ID | activity_sets |
activity_sets__FOR_CONTACTS | BOOLEAN | activity_sets.FOR_CONTACTS | activity_sets.FOR_CONTACTS | activity_sets |
activity_sets__FOR_LEADS | BOOLEAN | activity_sets.FOR_LEADS | activity_sets.FOR_LEADS | activity_sets |
activity_sets__FOR_OPPORTUNITIES | BOOLEAN | activity_sets.FOR_OPPORTUNITIES | activity_sets.FOR_OPPORTUNITIES | activity_sets |
activity_sets__FOR_ORGANISATIONS | BOOLEAN | activity_sets.FOR_ORGANISATIONS | activity_sets.FOR_ORGANISATIONS | activity_sets |
activity_sets__FOR_PROJECTS | BOOLEAN | activity_sets.FOR_PROJECTS | activity_sets.FOR_PROJECTS | activity_sets |
activity_sets__NAME | TEXT | activity_sets.NAME | activity_sets.NAME | activity_sets |
activity_sets__OWNER_USER_ID | NUMERIC | activity_sets.OWNER_USER_ID | activity_sets.OWNER_USER_ID | activity_sets |
contacts__ADDRESS_MAIL_CITY | TEXT | contacts.ADDRESS_MAIL_CITY | contacts.ADDRESS_MAIL_CITY | contacts |
contacts__ADDRESS_MAIL_COUNTRY | TEXT | contacts.ADDRESS_MAIL_COUNTRY | contacts.ADDRESS_MAIL_COUNTRY | contacts |
contacts__ADDRESS_MAIL_POSTCODE | TEXT | contacts.ADDRESS_MAIL_POSTCODE | contacts.ADDRESS_MAIL_POSTCODE | contacts |
contacts__ADDRESS_MAIL_STATE | TEXT | contacts.ADDRESS_MAIL_STATE | contacts.ADDRESS_MAIL_STATE | contacts |
contacts__ADDRESS_MAIL_STREET | TEXT | contacts.ADDRESS_MAIL_STREET | contacts.ADDRESS_MAIL_STREET | contacts |
contacts__ADDRESS_OTHER_CITY | TEXT | contacts.ADDRESS_OTHER_CITY | contacts.ADDRESS_OTHER_CITY | contacts |
contacts__ADDRESS_OTHER_COUNTRY | TEXT | contacts.ADDRESS_OTHER_COUNTRY | contacts.ADDRESS_OTHER_COUNTRY | contacts |
contacts__ADDRESS_OTHER_POSTCODE | TEXT | contacts.ADDRESS_OTHER_POSTCODE | contacts.ADDRESS_OTHER_POSTCODE | contacts |
contacts__ADDRESS_OTHER_STATE | TEXT | contacts.ADDRESS_OTHER_STATE | contacts.ADDRESS_OTHER_STATE | contacts |
contacts__ADDRESS_OTHER_STREET | TEXT | contacts.ADDRESS_OTHER_STREET | contacts.ADDRESS_OTHER_STREET | contacts |
contacts__ASSISTANT_NAME | TEXT | contacts.ASSISTANT_NAME | contacts.ASSISTANT_NAME | contacts |
contacts__BACKGROUND | TEXT | contacts.BACKGROUND | contacts.BACKGROUND | contacts |
contacts__CONTACT_ID | NUMERIC | contacts.CONTACT_ID | contacts.CONTACT_ID | contacts |
contacts__CREATED_USER_ID | NUMERIC | contacts.CREATED_USER_ID | contacts.CREATED_USER_ID | contacts |
contacts__CUSTOMFIELDS | OBJECT | contacts.CUSTOMFIELDS | contacts.CUSTOMFIELDS | contacts |
contacts__DATES | OBJECT | contacts.DATES | contacts.DATES | contacts |
contacts__DATE_CREATED_UTC | TEXT | contacts.DATE_CREATED_UTC | contacts.DATE_CREATED_UTC | contacts |
contacts__DATE_OF_BIRTH | TEXT | contacts.DATE_OF_BIRTH | contacts.DATE_OF_BIRTH | contacts |
contacts__DATE_UPDATED_UTC | TEXT | contacts.DATE_UPDATED_UTC | contacts.DATE_UPDATED_UTC | contacts |
contacts__EMAIL_ADDRESS | TEXT | contacts.EMAIL_ADDRESS | contacts.EMAIL_ADDRESS | contacts |
contacts__EMAIL_OPTED_OUT | BOOLEAN | contacts.EMAIL_OPTED_OUT | contacts.EMAIL_OPTED_OUT | contacts |
contacts__FIRST_NAME | TEXT | contacts.FIRST_NAME | contacts.FIRST_NAME | contacts |
contacts__IMAGE_URL | TEXT | contacts.IMAGE_URL | contacts.IMAGE_URL | contacts |
contacts__LAST_ACTIVITY_DATE_UTC | TEXT | contacts.LAST_ACTIVITY_DATE_UTC | contacts.LAST_ACTIVITY_DATE_UTC | contacts |
contacts__LAST_NAME | TEXT | contacts.LAST_NAME | contacts.LAST_NAME | contacts |
contacts__LINKS | OBJECT | contacts.LINKS | contacts.LINKS | contacts |
contacts__NEXT_ACTIVITY_DATE_UTC | TEXT | contacts.NEXT_ACTIVITY_DATE_UTC | contacts.NEXT_ACTIVITY_DATE_UTC | contacts |
contacts__ORGANISATION_ID | NUMERIC | contacts.ORGANISATION_ID | contacts.ORGANISATION_ID | contacts |
contacts__OWNER_USER_ID | NUMERIC | contacts.OWNER_USER_ID | contacts.OWNER_USER_ID | contacts |
contacts__PHONE | TEXT | contacts.PHONE | contacts.PHONE | contacts |
contacts__PHONE_ASSISTANT | TEXT | contacts.PHONE_ASSISTANT | contacts.PHONE_ASSISTANT | contacts |
contacts__PHONE_FAX | TEXT | contacts.PHONE_FAX | contacts.PHONE_FAX | contacts |
contacts__PHONE_HOME | TEXT | contacts.PHONE_HOME | contacts.PHONE_HOME | contacts |
contacts__PHONE_MOBILE | TEXT | contacts.PHONE_MOBILE | contacts.PHONE_MOBILE | contacts |
contacts__PHONE_OTHER | TEXT | contacts.PHONE_OTHER | contacts.PHONE_OTHER | contacts |
contacts__SALUTATION | TEXT | contacts.SALUTATION | contacts.SALUTATION | contacts |
contacts__SOCIAL_FACEBOOK | TEXT | contacts.SOCIAL_FACEBOOK | contacts.SOCIAL_FACEBOOK | contacts |
contacts__SOCIAL_LINKEDIN | TEXT | contacts.SOCIAL_LINKEDIN | contacts.SOCIAL_LINKEDIN | contacts |
contacts__SOCIAL_TWITTER | TEXT | contacts.SOCIAL_TWITTER | contacts.SOCIAL_TWITTER | contacts |
contacts__TAGS | OBJECT | contacts.TAGS | contacts.TAGS | contacts |
contacts__TITLE | TEXT | contacts.TITLE | contacts.TITLE | contacts |
contacts__VISIBLE_TEAM_ID | NUMERIC | contacts.VISIBLE_TEAM_ID | contacts.VISIBLE_TEAM_ID | contacts |
contacts__VISIBLE_TO | TEXT | contacts.VISIBLE_TO | contacts.VISIBLE_TO | contacts |
countries__COUNTRY_NAME | TEXT | countries.COUNTRY_NAME | countries.COUNTRY_NAME | countries |
currencies__CURRENCY_CODE | TEXT | currencies.CURRENCY_CODE | currencies.CURRENCY_CODE | currencies |
currencies__CURRENCY_SYMBOL | TEXT | currencies.CURRENCY_SYMBOL | currencies.CURRENCY_SYMBOL | currencies |
datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
emails__CREATED_USER_ID | NUMERIC | emails.CREATED_USER_ID | emails.CREATED_USER_ID | emails |
emails__DATE_CREATED_UTC | TEXT | emails.DATE_CREATED_UTC | emails.DATE_CREATED_UTC | emails |
emails__EMAIL_DATE_UTC | TEXT | emails.EMAIL_DATE_UTC | emails.EMAIL_DATE_UTC | emails |
emails__EMAIL_FROM | TEXT | emails.EMAIL_FROM | emails.EMAIL_FROM | emails |
emails__EMAIL_ID | NUMERIC | emails.EMAIL_ID | emails.EMAIL_ID | emails |
emails__FORMAT | TEXT | emails.FORMAT | emails.FORMAT | emails |
emails__LINKS | OBJECT | emails.LINKS | emails.LINKS | emails |
emails__OWNER_USER_ID | NUMERIC | emails.OWNER_USER_ID | emails.OWNER_USER_ID | emails |
emails__QUEUED_SEND_DATE_UTC | TEXT | emails.QUEUED_SEND_DATE_UTC | emails.QUEUED_SEND_DATE_UTC | emails |
emails__SIZE | NUMERIC | emails.SIZE | emails.SIZE | emails |
emails__SUBJECT | TEXT | emails.SUBJECT | emails.SUBJECT | emails |
emails__TAGS | OBJECT | emails.TAGS | emails.TAGS | emails |
events__ALL_DAY | BOOLEAN | events.ALL_DAY | events.ALL_DAY | events |
events__CUSTOMFIELDS | OBJECT | events.CUSTOMFIELDS | events.CUSTOMFIELDS | events |
events__DATE_CREATED_UTC | TEXT | events.DATE_CREATED_UTC | events.DATE_CREATED_UTC | events |
events__DATE_UPDATED_UTC | TEXT | events.DATE_UPDATED_UTC | events.DATE_UPDATED_UTC | events |
events__DETAILS | TEXT | events.DETAILS | events.DETAILS | events |
events__END_DATE_UTC | TEXT | events.END_DATE_UTC | events.END_DATE_UTC | events |
events__EVENT_ID | NUMERIC | events.EVENT_ID | events.EVENT_ID | events |
events__LINKS | OBJECT | events.LINKS | events.LINKS | events |
events__LOCATION | TEXT | events.LOCATION | events.LOCATION | events |
events__OWNER_USER_ID | NUMERIC | events.OWNER_USER_ID | events.OWNER_USER_ID | events |
events__REMINDER_DATE_UTC | TEXT | events.REMINDER_DATE_UTC | events.REMINDER_DATE_UTC | events |
events__REMINDER_SENT | BOOLEAN | events.REMINDER_SENT | events.REMINDER_SENT | events |
events__START_DATE_UTC | TEXT | events.START_DATE_UTC | events.START_DATE_UTC | events |
events__TITLE | TEXT | events.TITLE | events.TITLE | events |
knowledge_article_categories__CATEGORY_ID | NUMERIC | knowledge_article_categories.CATEGORY_ID | knowledge_article_categories.CATEGORY_ID | knowledge_article_categories |
knowledge_article_categories__CATEGORY_NAME | TEXT | knowledge_article_categories.CATEGORY_NAME | knowledge_article_categories.CATEGORY_NAME | knowledge_article_categories |
knowledge_article_categories__CREATED_USER_ID | NUMERIC | knowledge_article_categories.CREATED_USER_ID | knowledge_article_categories.CREATED_USER_ID | knowledge_article_categories |
knowledge_article_categories__DATE_CREATED_UTC | TEXT | knowledge_article_categories.DATE_CREATED_UTC | knowledge_article_categories.DATE_CREATED_UTC | knowledge_article_categories |
knowledge_article_categories__DATE_UPDATED_UTC | TEXT | knowledge_article_categories.DATE_UPDATED_UTC | knowledge_article_categories.DATE_UPDATED_UTC | knowledge_article_categories |
knowledge_article_categories__DESCRIPTION | TEXT | knowledge_article_categories.DESCRIPTION | knowledge_article_categories.DESCRIPTION | knowledge_article_categories |
knowledge_article_folders__CATEGORY_ID | TEXT | knowledge_article_folders.CATEGORY_ID | knowledge_article_folders.CATEGORY_ID | knowledge_article_folders |
knowledge_article_folders__CREATED_USER_ID | NUMERIC | knowledge_article_folders.CREATED_USER_ID | knowledge_article_folders.CREATED_USER_ID | knowledge_article_folders |
knowledge_article_folders__DATE_CREATED_UTC | TEXT | knowledge_article_folders.DATE_CREATED_UTC | knowledge_article_folders.DATE_CREATED_UTC | knowledge_article_folders |
knowledge_article_folders__DATE_UPDATED_UTC | TEXT | knowledge_article_folders.DATE_UPDATED_UTC | knowledge_article_folders.DATE_UPDATED_UTC | knowledge_article_folders |
knowledge_article_folders__FOLDER_ID | NUMERIC | knowledge_article_folders.FOLDER_ID | knowledge_article_folders.FOLDER_ID | knowledge_article_folders |
knowledge_article_folders__FOLDER_NAME | TEXT | knowledge_article_folders.FOLDER_NAME | knowledge_article_folders.FOLDER_NAME | knowledge_article_folders |
knowledge_article_folders__ORDER_ARTICLES | TEXT | knowledge_article_folders.ORDER_ARTICLES | knowledge_article_folders.ORDER_ARTICLES | knowledge_article_folders |
knowledge_article_folders__VISIBILITY | TEXT | knowledge_article_folders.VISIBILITY | knowledge_article_folders.VISIBILITY | knowledge_article_folders |
knowledge_articles__ARCHIVED_DATE_UTC | TEXT | knowledge_articles.ARCHIVED_DATE_UTC | knowledge_articles.ARCHIVED_DATE_UTC | knowledge_articles |
knowledge_articles__ARTICLE_ID | NUMERIC | knowledge_articles.ARTICLE_ID | knowledge_articles.ARTICLE_ID | knowledge_articles |
knowledge_articles__ARTICLE_NO | NUMERIC | knowledge_articles.ARTICLE_NO | knowledge_articles.ARTICLE_NO | knowledge_articles |
knowledge_articles__ArticleVersion | TEXT | knowledge_articles.ArticleVersion | knowledge_articles.ArticleVersion | knowledge_articles |
knowledge_articles__Body | TEXT | knowledge_articles.Body | knowledge_articles.Body | knowledge_articles |
knowledge_articles__CATEGORY_ID | NUMERIC | knowledge_articles.CATEGORY_ID | knowledge_articles.CATEGORY_ID | knowledge_articles |
knowledge_articles__CREATED_USER_ID | NUMERIC | knowledge_articles.CREATED_USER_ID | knowledge_articles.CREATED_USER_ID | knowledge_articles |
knowledge_articles__CUSTOMFIELDS | OBJECT | knowledge_articles.CUSTOMFIELDS | knowledge_articles.CUSTOMFIELDS | knowledge_articles |
knowledge_articles__DATE_CREATED_UTC | TEXT | knowledge_articles.DATE_CREATED_UTC | knowledge_articles.DATE_CREATED_UTC | knowledge_articles |
knowledge_articles__DATE_UPDATED_UTC | TEXT | knowledge_articles.DATE_UPDATED_UTC | knowledge_articles.DATE_UPDATED_UTC | knowledge_articles |
knowledge_articles__DOWNVOTE_COUNT | NUMERIC | knowledge_articles.DOWNVOTE_COUNT | knowledge_articles.DOWNVOTE_COUNT | knowledge_articles |
knowledge_articles__ExternalLinkCount | TEXT | knowledge_articles.ExternalLinkCount | knowledge_articles.ExternalLinkCount | knowledge_articles |
knowledge_articles__FIRST_PUBLISHED_DATE_UTC | TEXT | knowledge_articles.FIRST_PUBLISHED_DATE_UTC | knowledge_articles.FIRST_PUBLISHED_DATE_UTC | knowledge_articles |
knowledge_articles__FOLDER_ID | NUMERIC | knowledge_articles.FOLDER_ID | knowledge_articles.FOLDER_ID | knowledge_articles |
knowledge_articles__LAST_PUBLISHED_DATE_UTC | TEXT | knowledge_articles.LAST_PUBLISHED_DATE_UTC | knowledge_articles.LAST_PUBLISHED_DATE_UTC | knowledge_articles |
knowledge_articles__Language | TEXT | knowledge_articles.Language | knowledge_articles.Language | knowledge_articles |
knowledge_articles__OWNER_USER_ID | NUMERIC | knowledge_articles.OWNER_USER_ID | knowledge_articles.OWNER_USER_ID | knowledge_articles |
knowledge_articles__PROMOTED | BOOLEAN | knowledge_articles.PROMOTED | knowledge_articles.PROMOTED | knowledge_articles |
knowledge_articles__Status | TEXT | knowledge_articles.Status | knowledge_articles.Status | knowledge_articles |
knowledge_articles__TAGS | OBJECT | knowledge_articles.TAGS | knowledge_articles.TAGS | knowledge_articles |
knowledge_articles__Title | TEXT | knowledge_articles.Title | knowledge_articles.Title | knowledge_articles |
knowledge_articles__UPVOTE_COUNT | NUMERIC | knowledge_articles.UPVOTE_COUNT | knowledge_articles.UPVOTE_COUNT | knowledge_articles |
knowledge_articles__URL_SLUG | TEXT | knowledge_articles.URL_SLUG | knowledge_articles.URL_SLUG | knowledge_articles |
lead_sources__DEFAULT_VALUE | BOOLEAN | lead_sources.DEFAULT_VALUE | lead_sources.DEFAULT_VALUE | lead_sources |
lead_sources__FIELD_ORDER | NUMERIC | lead_sources.FIELD_ORDER | lead_sources.FIELD_ORDER | lead_sources |
lead_sources__LEAD_SOURCE | TEXT | lead_sources.LEAD_SOURCE | lead_sources.LEAD_SOURCE | lead_sources |
lead_sources__LEAD_SOURCE_ID | NUMERIC | lead_sources.LEAD_SOURCE_ID | lead_sources.LEAD_SOURCE_ID | lead_sources |
lead_statuses__DEFAULT_STATUS | BOOLEAN | lead_statuses.DEFAULT_STATUS | lead_statuses.DEFAULT_STATUS | lead_statuses |
lead_statuses__FIELD_ORDER | NUMERIC | lead_statuses.FIELD_ORDER | lead_statuses.FIELD_ORDER | lead_statuses |
lead_statuses__LEAD_STATUS | TEXT | lead_statuses.LEAD_STATUS | lead_statuses.LEAD_STATUS | lead_statuses |
lead_statuses__LEAD_STATUS_ID | NUMERIC | lead_statuses.LEAD_STATUS_ID | lead_statuses.LEAD_STATUS_ID | lead_statuses |
lead_statuses__STATUS_TYPE | NUMERIC | lead_statuses.STATUS_TYPE | lead_statuses.STATUS_TYPE | lead_statuses |
milestones__COMPLETED | BOOLEAN | milestones.COMPLETED | milestones.COMPLETED | milestones |
milestones__COMPLETED_DATE_UTC | TEXT | milestones.COMPLETED_DATE_UTC | milestones.COMPLETED_DATE_UTC | milestones |
milestones__DATE_CREATED_UTC | TEXT | milestones.DATE_CREATED_UTC | milestones.DATE_CREATED_UTC | milestones |
milestones__DATE_UPDATED_UTC | TEXT | milestones.DATE_UPDATED_UTC | milestones.DATE_UPDATED_UTC | milestones |
milestones__DUE_DATE | TEXT | milestones.DUE_DATE | milestones.DUE_DATE | milestones |
milestones__MILESTONE_ID | NUMERIC | milestones.MILESTONE_ID | milestones.MILESTONE_ID | milestones |
milestones__OWNER_USER_ID | NUMERIC | milestones.OWNER_USER_ID | milestones.OWNER_USER_ID | milestones |
milestones__PROJECT_ID | NUMERIC | milestones.PROJECT_ID | milestones.PROJECT_ID | milestones |
milestones__RESPONSIBLE_USER | NUMERIC | milestones.RESPONSIBLE_USER | milestones.RESPONSIBLE_USER | milestones |
milestones__TITLE | TEXT | milestones.TITLE | milestones.TITLE | milestones |
notes__BODY | TEXT | notes.BODY | notes.BODY | notes |
notes__DATE_CREATED_UTC | TEXT | notes.DATE_CREATED_UTC | notes.DATE_CREATED_UTC | notes |
notes__DATE_UPDATED_UTC | TEXT | notes.DATE_UPDATED_UTC | notes.DATE_UPDATED_UTC | notes |
notes__LINKS | OBJECT | notes.LINKS | notes.LINKS | notes |
notes__NOTE_ID | NUMERIC | notes.NOTE_ID | notes.NOTE_ID | notes |
notes__OWNER_USER_ID | NUMERIC | notes.OWNER_USER_ID | notes.OWNER_USER_ID | notes |
notes__TITLE | TEXT | notes.TITLE | notes.TITLE | notes |
opportunities__ACTUAL_CLOSE_DATE | TEXT | opportunities.ACTUAL_CLOSE_DATE | opportunities.ACTUAL_CLOSE_DATE | opportunities |
opportunities__BID_AMOUNT | NUMERIC | opportunities.BID_AMOUNT | opportunities.BID_AMOUNT | opportunities |
opportunities__BID_CURRENCY | TEXT | opportunities.BID_CURRENCY | opportunities.BID_CURRENCY | opportunities |
opportunities__BID_DURATION | NUMERIC | opportunities.BID_DURATION | opportunities.BID_DURATION | opportunities |
opportunities__BID_TYPE | TEXT | opportunities.BID_TYPE | opportunities.BID_TYPE | opportunities |
opportunities__CATEGORY_ID | NUMERIC | opportunities.CATEGORY_ID | opportunities.CATEGORY_ID | opportunities |
opportunities__CREATED_USER_ID | NUMERIC | opportunities.CREATED_USER_ID | opportunities.CREATED_USER_ID | opportunities |
opportunities__CUSTOMFIELDS | OBJECT | opportunities.CUSTOMFIELDS | opportunities.CUSTOMFIELDS | opportunities |
opportunities__DATE_CREATED_UTC | TEXT | opportunities.DATE_CREATED_UTC | opportunities.DATE_CREATED_UTC | opportunities |
opportunities__DATE_UPDATED_UTC | TEXT | opportunities.DATE_UPDATED_UTC | opportunities.DATE_UPDATED_UTC | opportunities |
opportunities__FORECAST_CLOSE_DATE | TEXT | opportunities.FORECAST_CLOSE_DATE | opportunities.FORECAST_CLOSE_DATE | opportunities |
opportunities__IMAGE_URL | TEXT | opportunities.IMAGE_URL | opportunities.IMAGE_URL | opportunities |
opportunities__LAST_ACTIVITY_DATE_UTC | TEXT | opportunities.LAST_ACTIVITY_DATE_UTC | opportunities.LAST_ACTIVITY_DATE_UTC | opportunities |
opportunities__LINKS | OBJECT | opportunities.LINKS | opportunities.LINKS | opportunities |
opportunities__NEXT_ACTIVITY_DATE_UTC | TEXT | opportunities.NEXT_ACTIVITY_DATE_UTC | opportunities.NEXT_ACTIVITY_DATE_UTC | opportunities |
opportunities__OPPORTUNITY_DETAILS | TEXT | opportunities.OPPORTUNITY_DETAILS | opportunities.OPPORTUNITY_DETAILS | opportunities |
opportunities__OPPORTUNITY_ID | NUMERIC | opportunities.OPPORTUNITY_ID | opportunities.OPPORTUNITY_ID | opportunities |
opportunities__OPPORTUNITY_NAME | TEXT | opportunities.OPPORTUNITY_NAME | opportunities.OPPORTUNITY_NAME | opportunities |
opportunities__OPPORTUNITY_STATE | TEXT | opportunities.OPPORTUNITY_STATE | opportunities.OPPORTUNITY_STATE | opportunities |
opportunities__OPPORTUNITY_VALUE | NUMERIC | opportunities.OPPORTUNITY_VALUE | opportunities.OPPORTUNITY_VALUE | opportunities |
opportunities__ORGANISATION_ID | NUMERIC | opportunities.ORGANISATION_ID | opportunities.ORGANISATION_ID | opportunities |
opportunities__OWNER_USER_ID | NUMERIC | opportunities.OWNER_USER_ID | opportunities.OWNER_USER_ID | opportunities |
opportunities__PIPELINE_ID | NUMERIC | opportunities.PIPELINE_ID | opportunities.PIPELINE_ID | opportunities |
opportunities__PRICEBOOK_ID | NUMERIC | opportunities.PRICEBOOK_ID | opportunities.PRICEBOOK_ID | opportunities |
opportunities__PROBABILITY | NUMERIC | opportunities.PROBABILITY | opportunities.PROBABILITY | opportunities |
opportunities__RESPONSIBLE_USER_ID | NUMERIC | opportunities.RESPONSIBLE_USER_ID | opportunities.RESPONSIBLE_USER_ID | opportunities |
opportunities__STAGE_ID | NUMERIC | opportunities.STAGE_ID | opportunities.STAGE_ID | opportunities |
opportunities__TAGS | OBJECT | opportunities.TAGS | opportunities.TAGS | opportunities |
opportunities__VISIBLE_TEAM_ID | NUMERIC | opportunities.VISIBLE_TEAM_ID | opportunities.VISIBLE_TEAM_ID | opportunities |
opportunities__VISIBLE_TO | TEXT | opportunities.VISIBLE_TO | opportunities.VISIBLE_TO | opportunities |
opportunity_categories__ACTIVE | BOOLEAN | opportunity_categories.ACTIVE | opportunity_categories.ACTIVE | opportunity_categories |
opportunity_categories__BACKGROUND_COLOR | TEXT | opportunity_categories.BACKGROUND_COLOR | opportunity_categories.BACKGROUND_COLOR | opportunity_categories |
opportunity_categories__CATEGORY_ID | NUMERIC | opportunity_categories.CATEGORY_ID | opportunity_categories.CATEGORY_ID | opportunity_categories |
opportunity_categories__CATEGORY_NAME | TEXT | opportunity_categories.CATEGORY_NAME | opportunity_categories.CATEGORY_NAME | opportunity_categories |
opportunity_state_reasons__FOR_OPPORTUNITY_STATE | TEXT | opportunity_state_reasons.FOR_OPPORTUNITY_STATE | opportunity_state_reasons.FOR_OPPORTUNITY_STATE | opportunity_state_reasons |
opportunity_state_reasons__STATE_REASON | TEXT | opportunity_state_reasons.STATE_REASON | opportunity_state_reasons.STATE_REASON | opportunity_state_reasons |
opportunity_state_reasons__STATE_REASON_ID | NUMERIC | opportunity_state_reasons.STATE_REASON_ID | opportunity_state_reasons.STATE_REASON_ID | opportunity_state_reasons |
organisations__ADDRESS_BILLING_CITY | TEXT | organisations.ADDRESS_BILLING_CITY | organisations.ADDRESS_BILLING_CITY | organisations |
organisations__ADDRESS_BILLING_COUNTRY | TEXT | organisations.ADDRESS_BILLING_COUNTRY | organisations.ADDRESS_BILLING_COUNTRY | organisations |
organisations__ADDRESS_BILLING_POSTCODE | TEXT | organisations.ADDRESS_BILLING_POSTCODE | organisations.ADDRESS_BILLING_POSTCODE | organisations |
organisations__ADDRESS_BILLING_STATE | TEXT | organisations.ADDRESS_BILLING_STATE | organisations.ADDRESS_BILLING_STATE | organisations |
organisations__ADDRESS_BILLING_STREET | TEXT | organisations.ADDRESS_BILLING_STREET | organisations.ADDRESS_BILLING_STREET | organisations |
organisations__ADDRESS_SHIP_CITY | TEXT | organisations.ADDRESS_SHIP_CITY | organisations.ADDRESS_SHIP_CITY | organisations |
organisations__ADDRESS_SHIP_COUNTRY | TEXT | organisations.ADDRESS_SHIP_COUNTRY | organisations.ADDRESS_SHIP_COUNTRY | organisations |
organisations__ADDRESS_SHIP_POSTCODE | TEXT | organisations.ADDRESS_SHIP_POSTCODE | organisations.ADDRESS_SHIP_POSTCODE | organisations |
organisations__ADDRESS_SHIP_STATE | TEXT | organisations.ADDRESS_SHIP_STATE | organisations.ADDRESS_SHIP_STATE | organisations |
organisations__ADDRESS_SHIP_STREET | TEXT | organisations.ADDRESS_SHIP_STREET | organisations.ADDRESS_SHIP_STREET | organisations |
organisations__BACKGROUND | TEXT | organisations.BACKGROUND | organisations.BACKGROUND | organisations |
organisations__CREATED_USER_ID | NUMERIC | organisations.CREATED_USER_ID | organisations.CREATED_USER_ID | organisations |
organisations__CUSTOMFIELDS | OBJECT | organisations.CUSTOMFIELDS | organisations.CUSTOMFIELDS | organisations |
organisations__DATES | OBJECT | organisations.DATES | organisations.DATES | organisations |
organisations__DATE_CREATED_UTC | TEXT | organisations.DATE_CREATED_UTC | organisations.DATE_CREATED_UTC | organisations |
organisations__DATE_UPDATED_UTC | TEXT | organisations.DATE_UPDATED_UTC | organisations.DATE_UPDATED_UTC | organisations |
organisations__EMAILDOMAINS | OBJECT | organisations.EMAILDOMAINS | organisations.EMAILDOMAINS | organisations |
organisations__IMAGE_URL | TEXT | organisations.IMAGE_URL | organisations.IMAGE_URL | organisations |
organisations__LAST_ACTIVITY_DATE_UTC | TEXT | organisations.LAST_ACTIVITY_DATE_UTC | organisations.LAST_ACTIVITY_DATE_UTC | organisations |
organisations__LINKS | OBJECT | organisations.LINKS | organisations.LINKS | organisations |
organisations__NEXT_ACTIVITY_DATE_UTC | TEXT | organisations.NEXT_ACTIVITY_DATE_UTC | organisations.NEXT_ACTIVITY_DATE_UTC | organisations |
organisations__ORGANISATION_ID | NUMERIC | organisations.ORGANISATION_ID | organisations.ORGANISATION_ID | organisations |
organisations__ORGANISATION_NAME | TEXT | organisations.ORGANISATION_NAME | organisations.ORGANISATION_NAME | organisations |
organisations__OWNER_USER_ID | NUMERIC | organisations.OWNER_USER_ID | organisations.OWNER_USER_ID | organisations |
organisations__PHONE | TEXT | organisations.PHONE | organisations.PHONE | organisations |
organisations__PHONE_FAX | TEXT | organisations.PHONE_FAX | organisations.PHONE_FAX | organisations |
organisations__SOCIAL_FACEBOOK | TEXT | organisations.SOCIAL_FACEBOOK | organisations.SOCIAL_FACEBOOK | organisations |
organisations__SOCIAL_LINKEDIN | TEXT | organisations.SOCIAL_LINKEDIN | organisations.SOCIAL_LINKEDIN | organisations |
organisations__SOCIAL_TWITTER | TEXT | organisations.SOCIAL_TWITTER | organisations.SOCIAL_TWITTER | organisations |
organisations__TAGS | OBJECT | organisations.TAGS | organisations.TAGS | organisations |
organisations__VISIBLE_TEAM_ID | NUMERIC | organisations.VISIBLE_TEAM_ID | organisations.VISIBLE_TEAM_ID | organisations |
organisations__VISIBLE_TO | TEXT | organisations.VISIBLE_TO | organisations.VISIBLE_TO | organisations |
organisations__WEBSITE | TEXT | organisations.WEBSITE | organisations.WEBSITE | organisations |
pipeline_stages__ACTIVITYSET_ID | NUMERIC | pipeline_stages.ACTIVITYSET_ID | pipeline_stages.ACTIVITYSET_ID | pipeline_stages |
pipeline_stages__OWNER_USER_ID | NUMERIC | pipeline_stages.OWNER_USER_ID | pipeline_stages.OWNER_USER_ID | pipeline_stages |
pipeline_stages__PIPELINE_ID | NUMERIC | pipeline_stages.PIPELINE_ID | pipeline_stages.PIPELINE_ID | pipeline_stages |
pipeline_stages__STAGE_ID | NUMERIC | pipeline_stages.STAGE_ID | pipeline_stages.STAGE_ID | pipeline_stages |
pipeline_stages__STAGE_NAME | TEXT | pipeline_stages.STAGE_NAME | pipeline_stages.STAGE_NAME | pipeline_stages |
pipeline_stages__STAGE_ORDER | NUMERIC | pipeline_stages.STAGE_ORDER | pipeline_stages.STAGE_ORDER | pipeline_stages |
pipelines__FOR_OPPORTUNITIES | BOOLEAN | pipelines.FOR_OPPORTUNITIES | pipelines.FOR_OPPORTUNITIES | pipelines |
pipelines__FOR_PROJECTS | BOOLEAN | pipelines.FOR_PROJECTS | pipelines.FOR_PROJECTS | pipelines |
pipelines__OWNER_USER_ID | NUMERIC | pipelines.OWNER_USER_ID | pipelines.OWNER_USER_ID | pipelines |
pipelines__PIPELINE_ID | NUMERIC | pipelines.PIPELINE_ID | pipelines.PIPELINE_ID | pipelines |
pipelines__PIPELINE_NAME | TEXT | pipelines.PIPELINE_NAME | pipelines.PIPELINE_NAME | pipelines |
project_categories__ACTIVE | BOOLEAN | project_categories.ACTIVE | project_categories.ACTIVE | project_categories |
project_categories__BACKGROUND_COLOR | TEXT | project_categories.BACKGROUND_COLOR | project_categories.BACKGROUND_COLOR | project_categories |
project_categories__CATEGORY_ID | NUMERIC | project_categories.CATEGORY_ID | project_categories.CATEGORY_ID | project_categories |
project_categories__CATEGORY_NAME | TEXT | project_categories.CATEGORY_NAME | project_categories.CATEGORY_NAME | project_categories |
projects__CATEGORY_ID | NUMERIC | projects.CATEGORY_ID | projects.CATEGORY_ID | projects |
projects__COMPLETED_DATE | TEXT | projects.COMPLETED_DATE | projects.COMPLETED_DATE | projects |
projects__CREATED_USER_ID | NUMERIC | projects.CREATED_USER_ID | projects.CREATED_USER_ID | projects |
projects__CUSTOMFIELDS | OBJECT | projects.CUSTOMFIELDS | projects.CUSTOMFIELDS | projects |
projects__DATE_CREATED_UTC | TEXT | projects.DATE_CREATED_UTC | projects.DATE_CREATED_UTC | projects |
projects__DATE_UPDATED_UTC | TEXT | projects.DATE_UPDATED_UTC | projects.DATE_UPDATED_UTC | projects |
projects__IMAGE_URL | TEXT | projects.IMAGE_URL | projects.IMAGE_URL | projects |
projects__LAST_ACTIVITY_DATE_UTC | TEXT | projects.LAST_ACTIVITY_DATE_UTC | projects.LAST_ACTIVITY_DATE_UTC | projects |
projects__LINKS | OBJECT | projects.LINKS | projects.LINKS | projects |
projects__NEXT_ACTIVITY_DATE_UTC | TEXT | projects.NEXT_ACTIVITY_DATE_UTC | projects.NEXT_ACTIVITY_DATE_UTC | projects |
projects__OPPORTUNITY_ID | NUMERIC | projects.OPPORTUNITY_ID | projects.OPPORTUNITY_ID | projects |
projects__OWNER_USER_ID | NUMERIC | projects.OWNER_USER_ID | projects.OWNER_USER_ID | projects |
projects__PIPELINE_ID | NUMERIC | projects.PIPELINE_ID | projects.PIPELINE_ID | projects |
projects__PROJECT_DETAILS | TEXT | projects.PROJECT_DETAILS | projects.PROJECT_DETAILS | projects |
projects__PROJECT_ID | NUMERIC | projects.PROJECT_ID | projects.PROJECT_ID | projects |
projects__PROJECT_NAME | TEXT | projects.PROJECT_NAME | projects.PROJECT_NAME | projects |
projects__RESPONSIBLE_USER_ID | NUMERIC | projects.RESPONSIBLE_USER_ID | projects.RESPONSIBLE_USER_ID | projects |
projects__STAGE_ID | NUMERIC | projects.STAGE_ID | projects.STAGE_ID | projects |
projects__STARTED_DATE | TEXT | projects.STARTED_DATE | projects.STARTED_DATE | projects |
projects__STATUS | TEXT | projects.STATUS | projects.STATUS | projects |
projects__TAGS | OBJECT | projects.TAGS | projects.TAGS | projects |
projects__VISIBLE_TEAM_ID | NUMERIC | projects.VISIBLE_TEAM_ID | projects.VISIBLE_TEAM_ID | projects |
projects__VISIBLE_TO | TEXT | projects.VISIBLE_TO | projects.VISIBLE_TO | projects |
prospects__ADDRESS_CITY | TEXT | prospects.ADDRESS_CITY | prospects.ADDRESS_CITY | prospects |
prospects__ADDRESS_COUNTRY | TEXT | prospects.ADDRESS_COUNTRY | prospects.ADDRESS_COUNTRY | prospects |
prospects__ADDRESS_POSTCODE | TEXT | prospects.ADDRESS_POSTCODE | prospects.ADDRESS_POSTCODE | prospects |
prospects__ADDRESS_STATE | TEXT | prospects.ADDRESS_STATE | prospects.ADDRESS_STATE | prospects |
prospects__ADDRESS_STREET | TEXT | prospects.ADDRESS_STREET | prospects.ADDRESS_STREET | prospects |
prospects__CONTACT_ID | NUMERIC | prospects.CONTACT_ID | prospects.CONTACT_ID | prospects |
prospects__CREATED_USER_ID | NUMERIC | prospects.CREATED_USER_ID | prospects.CREATED_USER_ID | prospects |
prospects__CUSTOMFIELDS | OBJECT | prospects.CUSTOMFIELDS | prospects.CUSTOMFIELDS | prospects |
prospects__DATE_CREATED_UTC | TEXT | prospects.DATE_CREATED_UTC | prospects.DATE_CREATED_UTC | prospects |
prospects__DATE_UPDATED_UTC | TEXT | prospects.DATE_UPDATED_UTC | prospects.DATE_UPDATED_UTC | prospects |
prospects__DESCRIPTION | TEXT | prospects.DESCRIPTION | prospects.DESCRIPTION | prospects |
prospects__DO_NOT_CALL | BOOLEAN | prospects.DO_NOT_CALL | prospects.DO_NOT_CALL | prospects |
prospects__DO_NOT_EMAIL | BOOLEAN | prospects.DO_NOT_EMAIL | prospects.DO_NOT_EMAIL | prospects |
prospects__DO_NOT_SYNC | BOOLEAN | prospects.DO_NOT_SYNC | prospects.DO_NOT_SYNC | prospects |
prospects__EMAIL_ADDRESS | TEXT | prospects.EMAIL_ADDRESS | prospects.EMAIL_ADDRESS | prospects |
prospects__EMPLOYEE_COUNT | NUMERIC | prospects.EMPLOYEE_COUNT | prospects.EMPLOYEE_COUNT | prospects |
prospects__FAX | TEXT | prospects.FAX | prospects.FAX | prospects |
prospects__FIRST_NAME | TEXT | prospects.FIRST_NAME | prospects.FIRST_NAME | prospects |
prospects__GRADE | TEXT | prospects.GRADE | prospects.GRADE | prospects |
prospects__GRADE_PROFILE_ID | NUMERIC | prospects.GRADE_PROFILE_ID | prospects.GRADE_PROFILE_ID | prospects |
prospects__INDUSTRY | TEXT | prospects.INDUSTRY | prospects.INDUSTRY | prospects |
prospects__LAST_ACTIVITY_DATE_UTC | TEXT | prospects.LAST_ACTIVITY_DATE_UTC | prospects.LAST_ACTIVITY_DATE_UTC | prospects |
prospects__LAST_NAME | TEXT | prospects.LAST_NAME | prospects.LAST_NAME | prospects |
prospects__LEAD_CONVERSION_DATE_UTC | TEXT | prospects.LEAD_CONVERSION_DATE_UTC | prospects.LEAD_CONVERSION_DATE_UTC | prospects |
prospects__LEAD_ID | NUMERIC | prospects.LEAD_ID | prospects.LEAD_ID | prospects |
prospects__MOBILE | TEXT | prospects.MOBILE | prospects.MOBILE | prospects |
prospects__OPTED_OUT | BOOLEAN | prospects.OPTED_OUT | prospects.OPTED_OUT | prospects |
prospects__ORGANISATION_ID | NUMERIC | prospects.ORGANISATION_ID | prospects.ORGANISATION_ID | prospects |
prospects__ORGANISATION_NAME | TEXT | prospects.ORGANISATION_NAME | prospects.ORGANISATION_NAME | prospects |
prospects__OWNER_USER_ID | NUMERIC | prospects.OWNER_USER_ID | prospects.OWNER_USER_ID | prospects |
prospects__PHONE | TEXT | prospects.PHONE | prospects.PHONE | prospects |
prospects__PROSPECT_ID | NUMERIC | prospects.PROSPECT_ID | prospects.PROSPECT_ID | prospects |
prospects__SALUTATION | TEXT | prospects.SALUTATION | prospects.SALUTATION | prospects |
prospects__SCORE | NUMERIC | prospects.SCORE | prospects.SCORE | prospects |
prospects__TAGS | OBJECT | prospects.TAGS | prospects.TAGS | prospects |
prospects__TITLE | TEXT | prospects.TITLE | prospects.TITLE | prospects |
prospects__WEBSITE | TEXT | prospects.WEBSITE | prospects.WEBSITE | prospects |
relationships__FORWARD | TEXT | relationships.FORWARD | relationships.FORWARD | relationships |
relationships__FORWARD_TITLE | TEXT | relationships.FORWARD_TITLE | relationships.FORWARD_TITLE | relationships |
relationships__FOR_CONTACTS | BOOLEAN | relationships.FOR_CONTACTS | relationships.FOR_CONTACTS | relationships |
relationships__FOR_ORGANISATIONS | BOOLEAN | relationships.FOR_ORGANISATIONS | relationships.FOR_ORGANISATIONS | relationships |
relationships__RELATIONSHIP_ID | NUMERIC | relationships.RELATIONSHIP_ID | relationships.RELATIONSHIP_ID | relationships |
relationships__REVERSE | TEXT | relationships.REVERSE | relationships.REVERSE | relationships |
relationships__REVERSE_TITLE | TEXT | relationships.REVERSE_TITLE | relationships.REVERSE_TITLE | relationships |
source | TEXT | Source | The name of the Windsor connector returning the row | |
task_categories__ACTIVE | BOOLEAN | task_categories.ACTIVE | task_categories.ACTIVE | task_categories |
task_categories__BACKGROUND_COLOR | TEXT | task_categories.BACKGROUND_COLOR | task_categories.BACKGROUND_COLOR | task_categories |
task_categories__CATEGORY_ID | NUMERIC | task_categories.CATEGORY_ID | task_categories.CATEGORY_ID | task_categories |
task_categories__CATEGORY_NAME | TEXT | task_categories.CATEGORY_NAME | task_categories.CATEGORY_NAME | task_categories |
tasks__ASSIGNED_BY_USER_ID | NUMERIC | tasks.ASSIGNED_BY_USER_ID | tasks.ASSIGNED_BY_USER_ID | tasks |
tasks__ASSIGNED_DATE_UTC | TEXT | tasks.ASSIGNED_DATE_UTC | tasks.ASSIGNED_DATE_UTC | tasks |
tasks__ASSIGNED_TEAM_ID | NUMERIC | tasks.ASSIGNED_TEAM_ID | tasks.ASSIGNED_TEAM_ID | tasks |
tasks__CATEGORY_ID | NUMERIC | tasks.CATEGORY_ID | tasks.CATEGORY_ID | tasks |
tasks__COMPLETED | BOOLEAN | tasks.COMPLETED | tasks.COMPLETED | tasks |
tasks__COMPLETED_DATE_UTC | TEXT | tasks.COMPLETED_DATE_UTC | tasks.COMPLETED_DATE_UTC | tasks |
tasks__CREATED_USER_ID | NUMERIC | tasks.CREATED_USER_ID | tasks.CREATED_USER_ID | tasks |
tasks__CUSTOMFIELDS | OBJECT | tasks.CUSTOMFIELDS | tasks.CUSTOMFIELDS | tasks |
tasks__DATE_CREATED_UTC | TEXT | tasks.DATE_CREATED_UTC | tasks.DATE_CREATED_UTC | tasks |
tasks__DATE_UPDATED_UTC | TEXT | tasks.DATE_UPDATED_UTC | tasks.DATE_UPDATED_UTC | tasks |
tasks__DETAILS | TEXT | tasks.DETAILS | tasks.DETAILS | tasks |
tasks__DUE_DATE | TEXT | tasks.DUE_DATE | tasks.DUE_DATE | tasks |
tasks__EMAIL_ID | NUMERIC | tasks.EMAIL_ID | tasks.EMAIL_ID | tasks |
tasks__LINKS | OBJECT | tasks.LINKS | tasks.LINKS | tasks |
tasks__MILESTONE_ID | NUMERIC | tasks.MILESTONE_ID | tasks.MILESTONE_ID | tasks |
tasks__OPPORTUNITY_ID | NUMERIC | tasks.OPPORTUNITY_ID | tasks.OPPORTUNITY_ID | tasks |
tasks__OWNER_USER_ID | NUMERIC | tasks.OWNER_USER_ID | tasks.OWNER_USER_ID | tasks |
tasks__OWNER_VISIBLE | BOOLEAN | tasks.OWNER_VISIBLE | tasks.OWNER_VISIBLE | tasks |
tasks__PARENT_TASK_ID | NUMERIC | tasks.PARENT_TASK_ID | tasks.PARENT_TASK_ID | tasks |
tasks__PERCENT_COMPLETE | NUMERIC | tasks.PERCENT_COMPLETE | tasks.PERCENT_COMPLETE | tasks |
tasks__PRIORITY | NUMERIC | tasks.PRIORITY | tasks.PRIORITY | tasks |
tasks__PROJECT_ID | NUMERIC | tasks.PROJECT_ID | tasks.PROJECT_ID | tasks |
tasks__PUBLICLY_VISIBLE | BOOLEAN | tasks.PUBLICLY_VISIBLE | tasks.PUBLICLY_VISIBLE | tasks |
tasks__RECURRENCE | TEXT | tasks.RECURRENCE | tasks.RECURRENCE | tasks |
tasks__REMINDER_DATE_UTC | TEXT | tasks.REMINDER_DATE_UTC | tasks.REMINDER_DATE_UTC | tasks |
tasks__REMINDER_SENT | BOOLEAN | tasks.REMINDER_SENT | tasks.REMINDER_SENT | tasks |
tasks__RESPONSIBLE_USER_ID | NUMERIC | tasks.RESPONSIBLE_USER_ID | tasks.RESPONSIBLE_USER_ID | tasks |
tasks__STAGE_ID | NUMERIC | tasks.STAGE_ID | tasks.STAGE_ID | tasks |
tasks__START_DATE | TEXT | tasks.START_DATE | tasks.START_DATE | tasks |
tasks__STATUS | TEXT | tasks.STATUS | tasks.STATUS | tasks |
tasks__TASK_ID | NUMERIC | tasks.TASK_ID | tasks.TASK_ID | tasks |
tasks__TITLE | TEXT | tasks.TITLE | tasks.TITLE | tasks |
team_members__MEMBER_USER_ID | NUMERIC | team_members.MEMBER_USER_ID | team_members.MEMBER_USER_ID | team_members |
team_members__PERMISSION_ID | NUMERIC | team_members.PERMISSION_ID | team_members.PERMISSION_ID | team_members |
team_members__TEAM_ID | NUMERIC | team_members.TEAM_ID | team_members.TEAM_ID | team_members |
teams__ANONYMOUS_TEAM | BOOLEAN | teams.ANONYMOUS_TEAM | teams.ANONYMOUS_TEAM | teams |
teams__DATE_CREATED_UTC | TEXT | teams.DATE_CREATED_UTC | teams.DATE_CREATED_UTC | teams |
teams__DATE_UPDATED_UTC | TEXT | teams.DATE_UPDATED_UTC | teams.DATE_UPDATED_UTC | teams |
teams__TEAMMEMBERS | OBJECT | teams.TEAMMEMBERS | teams.TEAMMEMBERS | teams |
teams__TEAM_ID | NUMERIC | teams.TEAM_ID | teams.TEAM_ID | teams |
teams__TEAM_NAME | TEXT | teams.TEAM_NAME | teams.TEAM_NAME | teams |
today | DATE | Today | Today's date | |
users__ACCOUNT_OWNER | BOOLEAN | users.ACCOUNT_OWNER | users.ACCOUNT_OWNER | users |
users__ACTIVE | BOOLEAN | users.ACTIVE | users.ACTIVE | users |
users__ADMINISTRATOR | BOOLEAN | users.ADMINISTRATOR | users.ADMINISTRATOR | users |
users__CONTACT_DISPLAY | TEXT | users.CONTACT_DISPLAY | users.CONTACT_DISPLAY | users |
users__CONTACT_ID | NUMERIC | users.CONTACT_ID | users.CONTACT_ID | users |
users__CONTACT_ORDER | TEXT | users.CONTACT_ORDER | users.CONTACT_ORDER | users |
users__DATE_CREATED_UTC | TEXT | users.DATE_CREATED_UTC | users.DATE_CREATED_UTC | users |
users__DATE_UPDATED_UTC | TEXT | users.DATE_UPDATED_UTC | users.DATE_UPDATED_UTC | users |
users__EMAIL_ADDRESS | TEXT | users.EMAIL_ADDRESS | users.EMAIL_ADDRESS | users |
users__EMAIL_DROPBOX_ADDRESS | TEXT | users.EMAIL_DROPBOX_ADDRESS | users.EMAIL_DROPBOX_ADDRESS | users |
users__EMAIL_DROPBOX_IDENTIFIER | TEXT | users.EMAIL_DROPBOX_IDENTIFIER | users.EMAIL_DROPBOX_IDENTIFIER | users |
users__FIRST_NAME | TEXT | users.FIRST_NAME | users.FIRST_NAME | users |
users__INSTANCE_ID | NUMERIC | users.INSTANCE_ID | users.INSTANCE_ID | users |
users__LAST_NAME | TEXT | users.LAST_NAME | users.LAST_NAME | users |
users__PROFILE_ID | NUMERIC | users.PROFILE_ID | users.PROFILE_ID | users |
users__ROLE_ID | NUMERIC | users.ROLE_ID | users.ROLE_ID | users |
users__TASK_WEEK_START | NUMERIC | users.TASK_WEEK_START | users.TASK_WEEK_START | users |
users__TIMEZONE_ID | TEXT | users.TIMEZONE_ID | users.TIMEZONE_ID | users |
users__USER_CURRENCY | TEXT | users.USER_CURRENCY | users.USER_CURRENCY | users |
users__USER_ID | NUMERIC | users.USER_ID | users.USER_ID | users |