Power BI Connector for SugarCRM

Build 20.0.7587

Accounts

Create, update, delete, and query the Accounts module in SugarCRM.

Columns

Name Type ReadOnly Description
My_Favorite Bool False

Whether the record is the favorite for the user.

Following Bool False

Whether the user is following this record.

Id [KEY] String False

The unique identifier of the company.

Name String False

The name of the company.

Date_Entered Datetime True

The date the record was created.

Date_Modified Datetime True

The date the record was last modified.

Modified_User_Id String True

The Id of the user who last modified the record.

Modified_By_Name String True

The name of the user who last modified the record.

Created_By String True

The Id of the user who created the record.

Created_By_Name String True

The name of the user who created the record.

Doc_Owner String False

The document owner.

User_Favorites String False

The user favorites for the record.

Description String False

The full text of the note.

Deleted Bool False

The record deletion indicator.

Assigned_User_Id String False

The Id of the user assigned to the record.

Assigned_User_Name String False

The user name of the user assigned to the record.

Team_Id String False

The Id of the primary team.

Team_Set_Id String False

The Id of the team set.

Team_Count String False

The count of the team set.

Team_Name String False

The name of the primary team.

Email String False

The email address for the company.

Email1 String False

The alternate email address for the company.

Email2 String False

The second alternate email addres for the company.

Invalid_Email Bool False

Whether the email address of the company has been marked as invalid.

Email_Opt_Out Bool False

Whether the company has opted out of emails.

Email_Addresses_Non_Primary String False

The nonprimary email addresses of the company.

Facebook String False

The Facebook name of the company.

Twitter String False

The Twitter name of the company.

Googleplus String False

The Google Plus name of the company.

Account_Type String False

The type of the company.

Industry String False

The industry that the company belongs in.

Annual_Revenue String False

Annual revenue for this company.

Phone_Fax String False

The fax phone number of this company.

Billing_Address_Street String False

The street address used for the billing address.

Billing_Address_Street_2 String False

The second line of the billing address.

Billing_Address_Street_3 String False

The third line of the billing address.

Billing_Address_Street_4 String False

The fourth line of the billing address.

Billing_Address_City String False

The city used for the billing address.

Billing_Address_State String False

The state used for the billing address.

Billing_Address_Postalcode String False

The postal code used for the billing address.

Billing_Address_Country String False

The country used for the billing address.

Rating String False

An arbitrary rating for this company for use in comparisons with others.

Phone_Office String False

The office phone number.

Phone_Alternate String False

An alternate phone number.

Website String False

The URL of the website for the company.

Ownership String False

The ownership of the company.

Employees String False

Number of employees. Can be a number (100) or range (50-100)

Ticker_Symbol String False

The stock trading (ticker) symbol for the company.

Shipping_Address_Street String False

The street address used for for shipping purposes.

Shipping_Address_Street_2 String False

The second line of the shipping address.

Shipping_Address_Street_3 String False

The third line of the shipping address.

Shipping_Address_Street_4 String False

The fourth line of the shipping address.

Shipping_Address_City String False

The city used for the shipping address.

Shipping_Address_State String False

The state used for the shipping address.

Shipping_Address_Postalcode String False

The ZIP code used for the shipping address.

Shipping_Address_Country String False

The country used for the shipping address.

Parent_Id String False

The Id of the parent of this account.

Sic_Code String False

SIC code of the account.

Duns_Num String False

DUNS number of the account.

Parent_Name String False

The name of the parent of this account.

Campaign_Id String False

The campaign that generated the account.

Campaign_Name String False

The first campaign name for the account.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587