|
Drop-down
|
Metaschema name
|
SQL type
|
Notes
|
|
Address
|
--
|
VARCHAR
|
Creates four more text fields for the address components. The field names are the name entered plus "_city", "_state", and "_country", as type "varchar(100)", and "_postalcode", which is "varchar(20)".
|
|
--
|
assigned_user_name
|
VARCHAR
|
Cannot be created via UI.
|
|
Checkbox
|
bool
|
BIT
|
Has three values: "":"", 1:"Yes", 2:"No". The default value is either checked or unchecked only.
|
|
Currency
|
currency
|
DECIMAL
|
The first time this is created in the record, a currency_id field of type currency_id is also created.
|
|
--
|
currency_id
|
VARCHAR
|
Created as a side-effect of creating the first currency column. It is always named "currency_id".
|
|
Date
|
date
|
DATE
|
Default values include:yesterday, today, tomorrow, next week, next monday, next friday, two weeks, next month, first day of next month, three months, six months, next year
|
|
--
|
datetime
|
TIMESTAMP
|
Cannot be created via UI.
|
|
Datetime
|
datetimecombo
|
TIMESTAMP
|
Defaults include those for date, and optional times. In addition for time, the hours 01-12:00,15,30,45:am/pm.
|
|
Decimal
|
decimal
|
DECIMAL
|
|
|
Dropdown
|
enum
|
VARCHAR
|
|
|
--
|
email
|
VARCHAR
|
Cannot be created via UI.
|
|
Encrypt
|
encrypt
|
VARCHAR
|
Cannot be created via UI.
|
|
File
|
file
|
LONGVARCHAR
|
|
|
Float
|
float
|
FLOAT
|
Equivalent to Java Double.
|
|
--
|
fullname
|
VARCHAR
|
This is a concatenation of the two name components first_name and last_name.
|
|
--
|
function
|
LONGVARCHAR
|
Cannot be created directly using the UI.
|
|
HTML
|
html
|
LONGVARCHAR
|
|
|
--
|
id
|
LONGVARCHAR
|
Cannot be created directly using the UI.
|
|
IFrame
|
iframe
|
VARCHAR
|
|
|
Image
|
image
|
VARCHAR
|
|
|
Integer
|
int
|
INTEGER
|
|
|
--
|
json
|
LONGVARCHAR
|
Cannot be created directly using the UI.
|
|
--
|
link
|
VARCHAR
|
|
|
--
|
long
|
BIGINT
|
Cannot be created directly using the UI.
|
|
--
|
longtext
|
LONGVARCHAR
|
|
|
--
|
modified_user_name
|
VARCHAR
|
Cannot be created directly using the UI.
|
|
Multiselect
|
multienum
|
VARCHAR
|
Returned as comma-separated values.
|
|
--
|
name
|
VARCHAR
|
Cannot be created directly with the UI.
|
|
--
|
none
|
If the metadata returns a data type of "none", the column is ignored.
|
|
|
Parent
|
parent
|
VARCHAR
|
Supports the SugarCRM "Flex Relate" feature, which allows the type of the link target to be set dynamically at runtime.
|
|
--
|
parent_type
|
VARCHAR
|
Supports the SugarCRM "Flex Relate" feature, which allows the type of the link target to be set dynamically at runtime.
|
|
Password
|
password
|
VARCHAR
|
|
|
PHONE
|
phone
|
VARCHAR
|
|
|
Radio
|
radioenum
|
VARCHAR
|
|
|
Relate
|
relate
|
VARCHAR
|
|
|
--
|
short
|
INTEGER
|
Cannot be created using the UI.
|
|
--
|
string
|
VARCHAR
|
Cannot be created using the UI.
|
|
--
|
team_list
|
VARCHAR
|
Cannot be created using the UI.
|
|
Textarea
|
text
|
VARCHAR
|
|
|
TextField
|
varchar
|
VARCHAR
|
|
|
Time
|
time
|
TIME
|
|
|
TimePeriod
|
timeperiod
|
VARCHAR
|
Cannot be created directly with the UI.
|
|
URL
|
url
|
VARCHAR
|
|
|
--
|
user_name
|
VARCHAR
|