JDBC Driver for SugarCRM

Build 24.0.9062

Styleguide

The Styleguide table.

Columns

Name Type ReadOnly Description
Alt_Address_City String False

City for alternate address

Alt_Address_Country String False

Country for alternate address

Alt_Address_Postalcode String False

Postal code for alternate address

Alt_Address_State String False

State for alternate address

Alt_Address_Street String False

Street address for alternate address

Alt_Address_Street_2 String False

Alt_Address_Street_3 String False

Assigned_User_Id String False

User ID assigned to record

Assigned_User_Name String True

Assistant String False

Name of the assistant of the contact

Assistant_Phone String False

Phone number of the assistant of the contact

Birthdate Date False

The birthdate of the contact

Created_By String True

User who created record

Created_By_Name String True

Currency_Id String False

Currency of the product

Date_Entered Datetime True

Date record created

Date_Modified Datetime True

Date record last modified

Date_Start Datetime False

Date of start of meeting

Deleted Bool False

Record deletion indicator

Department String False

The department of the contact

Description String False

Full text of the styleguide page

Do_Not_Call Bool False

Whether or not to allow calls to contact

Email String False

Email_Addresses_Non_Primary String False

Email_Opt_Out Bool False

Email1 String False

Email2 String False

Facebook String False

The facebook name of the user

File_Mime_Type String False

Attachment MIME type

File_Url String False

Path to file (can be URL)

Filename String True

File name associated with the note (attachment)

First_Name String False

First name of the contact

Following Bool False

Is user following this record

Full_Name String True

Googleplus String False

The google plus id of the user

Id [KEY] String True

Unique identifier

Invalid_Email Bool False

Last_Name String False

Last name of the contact

List_Price Decimal True

List price of product (

Locked_Fields String True

Modified_By_Name String True

Modified_User_Id String True

User who last modified record

My_Favorite Bool False

Favorite for the user

Name String True

Parent_Id String False

The ID of the Sugar item specified in parent_type

Parent_Name String True

Parent_Type String True

Sugar module the Note is associated with

Phone_Fax String False

Contact fax number

Phone_Home String False

Don't call to this number

Phone_Mobile String False

Mobile phone number of the contact

Phone_Other String False

Other phone number for the contact

Phone_Work String False

Work phone number of the contact

Picture String False

Image to be used as an avatar

Primary_Address_City String False

City for primary address

Primary_Address_Country String False

Country for primary address

Primary_Address_Postalcode String False

Postal code for primary address

Primary_Address_State String False

State for primary address

Primary_Address_Street String False

The street address used for primary address

Primary_Address_Street_2 String False

Primary_Address_Street_3 String False

Radio_Button_Group String True

Salutation String False

Contact salutation (e.g., Mr, Ms)

Secret_Password String True

Your password will be saved securely

Sync_Key String True

Title String True

Title of the Styleguide page

Twitter String False

The twitter name of the user

User_Email String False

Emails can also have a big help description to further enhance the user experience

Website String False

URL of website for the company

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