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. |
| 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. |
| String | False |
The Facebook name of the company. | |
| 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. |