Field on objects represent the details of each object and are analogous to columns in a database table. The following properties are listed in the field property column for each field of each object:
| Property | Description |
|---|---|
| Autonumber | The API creates an autonumber. |
| Create | Value for the field can be specified during create using the API. |
| Defaulted on create | When created, a default value is supplied if no other value is specified. |
| Delete | Value for the field can be deleted using the API. |
| Filter | Can be used as filter criteria in a SOQL query FROM or WHERE clause. |
| idLookup | 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(). |
| Nillable | The field can contain a null value. |
| Query | The field can be queried with SOQL using the API. |
| Replicate | The value of the field can be replicated using the API. |
| Restricted picklist | A picklist that depends on the value of another picklist for the values it displays. |
| Retrieve | Value of the field can be retrieved using the API. |
| Search | Can be searched with SOSL using the API. |
| Update | Can be updated using the API. |