Fields on objects represent the details of each object and are analogous to columns in a database table. Each field on each object has one or more of the following properties:
|Can be used by one of the SOQL aggregate functions.
|The API creates an autonumber.
|Value for the field can be specified during create using the API.
|Defaulted on create
|If no other value is specified when created, a default value is supplied.
|Value for the field can be deleted using the API.
|Can be used as filter criteria in a SOQL query FROM or WHERE clause.
|Can be included in the GROUP BY clause of a SOQL query (true) or not (false). Available in API version 18.0 and later.
|Can be used to specify a record in an upsert call. The Id field of each object has this property and some Name fields. There are exceptions, so check for the property in any object you wish to upsert.
|Indicates whether the field’s value is the Name of the parent of this object (true) or not (false). Used for objects whose parents can be more than one type of object. For example, a task can have an account or a contact as a parent.
|The field can contain a null value.
|The field can be queried with SOQL using the API.
|A picklist whose values are restricted to those values defined by a Salesforce admin. Users can’t load unapproved values through the API.
|Value of the field can be retrieved using the API.
|Indicates whether a query can sort on this field (true) or not (false).
|Can be updated using the API.