ODBC Driver for SugarCRM

Build 23.0.8839

Styleguide

The Styleguide table.

Columns

Name Type ReadOnly Description
Id [KEY] String False

Unique identifier

Name String True

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

Deleted Bool False

Record deletion indicator

Salutation String False

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

First_Name String False

First name of the contact

Last_Name String False

Last name of the contact

Full_Name String True

Title String True

Title of the Styleguide page

Facebook String False

The facebook name of the user

Twitter String False

The twitter name of the user

Googleplus String False

The google plus id of the user

Department String False

The department of the contact

Do_Not_Call Bool False

Whether or not to allow calls to contact

Phone_Home String False

Don't call to this number

Phone_Mobile String False

Mobile phone number of the contact

Phone_Work String False

Work phone number of the contact

Phone_Other String False

Other phone number for the contact

Phone_Fax String False

Contact fax number

Primary_Address_Street String False

The street address used for primary address

Primary_Address_Street_2 String False

Primary_Address_Street_3 String False

Primary_Address_City String False

City for primary address

Primary_Address_State String False

State for primary address

Primary_Address_Postalcode String False

Postal code for primary address

Primary_Address_Country String False

Country for primary address

Alt_Address_Street String False

Street address for alternate address

Alt_Address_Street_2 String False

Alt_Address_Street_3 String False

Alt_Address_City String False

City for alternate address

Alt_Address_State String False

State for alternate address

Alt_Address_Postalcode String False

Postal code for alternate address

Alt_Address_Country String False

Country for alternate address

Assistant String False

Name of the assistant of the contact

Assistant_Phone String False

Phone number of the assistant of the contact

Picture String False

Image to be used as an avatar

Parent_Type String True

Sugar module the Note is associated with

Parent_Id String False

The ID of the Sugar item specified in parent_type

Parent_Name String True

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)

Currency_Id String False

Currency of the product

List_Price Decimal True

List price of product (

Website String False

URL of website for the company

Birthdate Date False

The birthdate of the contact

Secret_Password String True

Your password will be saved securely

User_Email String False

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

Date_Start Datetime False

Date of start of meeting

Radio_Button_Group String True

Following Bool False

Is user following this record

My_Favorite Bool False

Favorite for the user

Locked_Fields String True

Sync_Key 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

Assigned_User_Id String False

User ID assigned to record

Assigned_User_Name String True

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