Active |
Defines if the row contains active data. Inactive means logically deleted. |
ChangedBy |
The ID of the user who last edited this data. FK to HH.Users |
ChangedOn |
The datetime this data was last edited |
Createdby |
The ID of the user who first created this data. FK to HH.Users |
CreatedOn |
The datetime this data was first created |
EntityID |
The ID of the object this data belongs to. |
IsLocked |
This data is marked as closed (locked) by the user. |
IsPublic |
Not used |
NotesID |
The ID of the Note |
NoteText |
Note text in entered (html) format |
NoteTypeID |
The type of not. FK to HH.NotesType. Optional. |
ObjTypeID |
The type of object this data belongs to. See also HH.ObjType |
Version |
The number of times the data was been changed. See the corresponding AUDIT table for full audit trail. |