Accounts
The Accounts table.
Columns
Name | Type | ReadOnly | Description |
Id [KEY] | String | False |
Unique identifier |
Name | String | False |
Name of the Company |
Date_Entered | Datetime | True |
Date record created |
Date_Modified | Datetime | True |
Date record last modified |
Modified_User_Id | String | True |
User who last modified record |
Modified_By_Name | String | True | |
Created_By | String | True |
User who created record |
Created_By_Name | String | True | |
Description | String | False |
Full text of the note |
Deleted | Bool | False |
Record deletion indicator |
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 Company is of this type |
Industry | String | False |
The company belongs in this industry |
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 billing address |
Billing_Address_City | String | False |
The city used for billing address |
Billing_Address_State | String | False |
The state used for billing address |
Billing_Address_Postalcode | String | False |
The postal code used for 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 |
URL of website for the company |
Ownership | String | False | |
Employees | String | False |
Number of employees, varchar to accomodate for both 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_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 |
Service_Level | String | False |
An indication of the service level of a company |
Parent_Id | String | False |
Account 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 | True | |
Business_Center_Name | String | True |
The name of the business center represented by the business_center_id field |
Business_Center_Id | String | False |
The business center to which the case is associated |
Campaign_Id | String | False |
Campaign that generated Account |
Campaign_Name | String | True |
The first campaign name for Account (Meta-data only) |
Next_Renewal_Date | Date | True | |
Widget_Next_Renewal_Date | String | True | |
Hint_Account_Size | String | False |
Company Size |
Hint_Account_Industry | String | False |
Company Industry |
Hint_Account_Location | String | False |
Company Location |
Hint_Account_Industry_Tags | String | False |
industry tags |
Hint_Account_Founded_Year | String | False |
company founded year |
Hint_Account_Facebook_Handle | String | False |
company facebook |
Hint_Account_Logo | String | False |
company logo |
Hint_Account_Pic | String | False |
Hint Account logo |
Hint_Account_Naics_Code_Lbl | String | False |
NAICS Code |
Hint_Account_Fiscal_Year_End | String | False |
FY End |
Geocode_Status | String | True | |
Following | Bool | False |
Is user following this record |
My_Favorite | Bool | False |
Favorite for the user |
Tag | String | False | |
Commentlog | String | True | |
Locked_Fields | String | True | |
Sync_Key | String | True | |
Assigned_User_Id | String | False |
User ID assigned to record |
Assigned_User_Name | String | True | |
Team_Id | String | False |
Team ID for the account |
Team_Set_Id | String | False | |
Acl_Team_Set_Id | String | False | |
Team_Count | String | False | |
Team_Name | String | False | |
Acl_Team_Names | String | True | |
String | False | ||
Email1 | String | False | |
Email2 | String | False | |
Invalid_Email | Bool | False | |
Email_Opt_Out | Bool | False | |
Email_Addresses_Non_Primary | String | False | |
Is_Escalated | Bool | True |
Is this escalated? |
Dri_Workflow_Template_Id | String | False | |
Dri_Workflow_Template_Name | String | True | |
Perform_Sugar_Action | Bool | False | |
Hint_Account_Industry_C | String | False | |
Orderconfirmed_C | Bool | False | |
Accounts_Prospects_1_Name | String | True | |
Accounts_Prospects_1prospects_Idb | String | False | |
Call_Id_C | String | False | |
Campaign_Id_C | String | False | |
Hint_Account_Facebook_Handle_C | String | False | |
Hint_Account_Fiscal_Year_End_C | String | False | |
Hint_Account_Founded_Year_C | String | False | |
Hint_Account_Industry_Tags_C | String | False | |
Hint_Account_Location_C | String | False | |
Hint_Account_Logo_C | String | False | |
Hint_Account_Naics_Code_Lbl_C | String | False | |
Hint_Account_Pic_C | String | False | |
Hint_Account_Size_C | String | False | |
Latitude_C | String | False | |
Longitude_C | String | False |