ODBC Driver for SugarCRM

Build 24.0.9062

Accounts

The Accounts table.

Columns

Name Type ReadOnly Description
Account_Type String False

The Company is of this type

Acl_Team_Names String True

Acl_Team_Set_Id String False

Affiliated_Business_Or_Jv_C Bool False

Affiliationothername_C String False

Agentstarthistorydate_C Date False

Agenttrax_User_C Bool False

Agenttrax_User_Notes_C String False

Agenttraxaccounttype_C String False

Agenttraxaccttype_C String False

Annual_Revenue String False

Annual revenue for this company

Area_C String False

Assigned_User_Id String False

User ID assigned to record

Assigned_User_Name String True

Base_Rate Decimal False

Billing_Address_City String False

The city used for billing address

Billing_Address_Country String False

The country used for the billing address

Billing_Address_Postalcode String False

The postal code used for billing address

Billing_Address_State String False

The state used for billing address

Billing_Address_Street String False

The street address used for billing address

Business_Center_Id String False

The business center to which the case is associated

Business_Center_Name String True

The name of the business center represented by the business_center_id field

Campaign_Id String False

Campaign that generated Account

Campaign_Name String True

The first campaign name for Account (Meta-data only)

Cancellation_Date_C Date False

Claimsratioytdloc_C Decimal False

Commentlog String True

Commission_C Decimal False

Contact_To_Discuss_Audits_C String False

Contact_To_Discuss_Claims_C String False

Contact_To_Discuss_General_C String False

Contact_To_Discuss_Premiums_C String False

Contact_To_Discuss_Reporting_C String False

Cplspriorytdloc_C Int False

Cplsytdloc_C Int False

Created_By String True

User who created record

Created_By_Name String True

Credit_Reports_Agent_Permiss_C Bool False

Credit_Reports_Last_Run_Off_C Date False

Currency_Id String False

Currytdnetloc_C Decimal False

Cyber_Insurance_Coverage_C Bool False

Date_Entered Datetime True

Date record created

Date_Modified Datetime True

Date record last modified

Dba_C String False

Deleted Bool False

Record deletion indicator

Description String False

Full text of the note

Doctype_C String False

Dri_Workflow_Template_Id String False

Dri_Workflow_Template_Name String True

Duns_Num String False

DUNS number of the account

Ec_Purchasing_User_C Bool False

Email String False

Email_Addresses_Non_Primary String False

Email_Opt_Out Bool False

Email1 String False

Email2 String False

Employees String False

Number of employees, varchar to accomodate for both number (100) or range (50-100)

Epay_User_C Bool False

Est_Total_Prem_Gen_At_Office_C Decimal False

Estatement_User_C Bool False

Estimated_Fntg_Wallet_Share_C String False

Facebook String False

The facebook name of the company

Fidelity_Pak_User_C Bool False

Fnf_Agencies_Accounts_1_Name String True

Fnf_Agencies_Accounts_1fnf_Agencies_Ida String False

Following Bool False

Is user following this record

Googleplus String False

The Google Plus name of the company

Hint_Account_Facebook_Handle String False

company facebook

Hint_Account_Fiscal_Year_End String False

FY End

Hint_Account_Founded_Year String False

company founded year

Hint_Account_Industry String False

Company Industry

Hint_Account_Industry_Tags String False

industry tags

Hint_Account_Location String False

Company Location

Hint_Account_Logo String False

company logo

Hint_Account_Naics_Code_Lbl String False

NAICS Code

Hint_Account_Pic String False

Hint Account logo

Hint_Account_Size String False

Company Size

Id [KEY] String True

Unique identifier

Industry String False

The company belongs in this industry

Invalid_Email Bool False

Is_Escalated Bool True

Is this escalated?

Jacketsorderedytdloc_C String False

Jv_Or_Afba_Partner_Name_C String False

Lastaccountingperiod_C String False

Lastupdatedate_C Datetime False

Local_Tag_C String False

Locked_Fields String True

Maxliability_C Decimal False

Modified_By_Name String True

Modified_User_Id String True

User who last modified record

Mtcc_Modules_In_Use_C String False

My_Favorite Bool False

Favorite for the user

Name String False

Name of the Company

Name_City_State_C String False

Nasid_C String False

Next_Renewal_Date Date True

Ownership String False

Parent_Id String False

Account ID of the parent of this account

Parent_Name String True

Perform_Sugar_Action Bool False

Phone_Alternate String False

An alternate phone number

Phone_Fax String False

The fax phone number of this company

Phone_Office String False

The office phone number

Primarylocation_C Bool False

Prior_Year_Total_Premium_C Decimal False

Prioreoynetloc_C Decimal False

Priorytdnetloc_C Decimal False

Prospect_Numb_Sales_Calls_C Int False

Prospecting_Next_Step_C String False

Prospecting_Notes_C String False

Rating String False

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

Reportedpoliciesytdloc_C Int False

Rynoh_Erecon_C Bool False

Service_Level String False

An indication of the service level of a company

Shipping_Address_City String False

The city used for the shipping address

Shipping_Address_Country String False

The country used for the shipping address

Shipping_Address_Postalcode String False

The zip code used for the shipping address

Shipping_Address_State String False

The state used for the shipping address

Shipping_Address_Street String False

The street address used for for shipping purposes

Sic_Code String False

SIC code of the account

Software_Escrow_Title_C String False

Status_C String False

Sync_Key String True

Tag String False

Team_Count String False

Team_Id String False

Team ID for the account

Team_Name String False

Team_Set_Id String False

Test_Contact_For_Claims_C String False

Ticker_Symbol String False

The stock trading (ticker) symbol for the company

Titlepoint_User_C Bool False

Titlepoint_User_Notes_C String False

Titlewave_User_C Bool False

Twitter String False

The twitter name of the company

Website String False

URL of website for the company

Widget_Next_Renewal_Date String True

Ytdvarianceloc_C Decimal False

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