The following fields are read-only fields found on most objects. These fields are automatically updated during API operations. For example, the ID field is automatically generated during a create operation and the LastModifiedDate is automatically updated during any operation on an object.
|Id||ID||Globally unique string that identifies a record. For information on IDs, see ID Field Type. Because this field exists in every object, it is not listed in the field table for each object. Id fields have Defaulted on create and Filter access.|
|IsDeleted||boolean||Indicates whether the record has been moved to the Recycle Bin (true) or not (false). Because this field does not appear in all objects, it is listed in the field table for each object.|
|CreatedById||reference||ID of the User who created this record. CreatedById fields have Defaulted on create and Filter access.|
|CreatedDate||dateTime||Date and time when this record was created. CreatedDate fields have Defaulted on create and Filter access.|
|LastModifiedById||reference||ID of the User who last updated this record. LastModifiedById fields have Defaulted on create and Filter access.|
|LastModifiedDate||dateTime||Date and time when a user last modified this record. LastModifiedDate fields have Defaulted on create and Filter access.|
|SystemModstamp||dateTime||Date and time when a user or automated process (such as a trigger) last modified this record. SystemModstamp fields have Defaulted on create and Filter access.|
If you import data into Salesforce and want to retain the audit field values of the source system, you can set the values for audit fields on the following objects: Account, ArticleVersion, Attachment, CampaignMember, Case, CaseComment, Contact, ContentVersion, Contract, Event, Idea, IdeaComment, Lead, Opportunity, Question, Task, Vote, and custom objects. The only audit field you cannot set a value for is systemModstamp.
Not all standard objects have all audit fields. Check the Enterprise WSDL to verify which audit fields are available for a given object.
If an object has a relationship to a parent object, two fields are added.
SELECT Case.ContactId, Case.Contact.Name FROM Case
Even if the object can parent itself, these fields occur. For example, the Campaign object has a Campaign and CampaignId field for referencing the parent Campaign.