Søgning » Teamshare » Notes
Tabel

Notes


Beskrivelse ?

A single comment made on a case, document, task or user, or as a reply to an existing comment.

Størrelse (Antal rækker) ?

345

Indhold (Kolonner/variable) ?

Navn Indhold
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.