The common properties of all objects that use versioning are summarized below.
| External Name | Internal Name | Type | Description |
|---|---|---|---|
| Comment | Comment | text | This calculated property provides the object’s revision comment regardless of whether it is stored in the ShortComment or LCOMM table. |
| CommentID | CommentID | int | If a revision comment < 2,000 characters exists, this field is a foreign key to the LCOMM table that contains the full comment. |
| Created By | CreatedUserID | int | ID of the user that first created the object. |
| Created Time | CreatedTime | timestamp | Date/time at which the object was created. |
| Deleted By | DeletedUserID | int | ID of the user that deleted the object. -1 means the object is still “live”. |
| Deleted Time | DeletedTime | timestamp | Date/time that the object was deleted. 0 means object is still “live”. Non-zero means the record is soft-deleted. |
| Dot Notation | DotNotation | text | This calculated property is the dotted-notation representation of the object’s version. |
| End Modified Time | EndModifiedTime | timestamp | Date/time that this object revision was replaced by another revision. 0 identifies the latest (tip) revision. |
| Locked By | ExclusiveLocker | int | ID of the user that currently has the object exclusively locked. -1 means the object is not exclusively locked. |
| Modified By | ModifiedUserID | int | ID of the user that last modified the object. |
| Modified Time | ModifiedTime | timestamp | Date/time that the object was last modified. |
| My Lock | MyLock | int | This client-calculated property indicates if the current user has this object locked. |
| New Revision Comment | NewRevisionComment | text | This client-calculated property serves as a place holder for a new revision comment value. |
| Non-Exclusive Lockers | NonExclusiveLockers | text | List of users that currently have the object non-exclusively locked, if any. |
| Object ID | ID | int | ID that is unique to each object in the database. |
| Read Only | ReadOnly | int | This calculated property indicates if the object is currently read-only. |
| Revision Flags | RevisionFlags | int | This field is currently always zero. |
| Short Comment | ShortComment | text | Value of the revision comment if it is less than 2,000 characters. |
| Version | RevisionNumber | int | Revision number of this object revision. 0 = first revision. |