JDBC Driver for SugarCRM

Build 23.0.8839

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

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 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

Email 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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839