DocumentNote Table

DocumentNote stores a list of notes attached to a document. The document itself is attached to a contract.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for DocumentNote table

Database Column

Details

DocumentNoteID

Type: integer. Key. Generated ID

A unique identifier for the document note.

DocumentID

Type: integer

The document that the note is for. Foreign key to the Document table.

ShortDescription

Type: text (max 100 characters)

In the user interface, this maps to the document reference to which the note relates.

LongDescription

Type: text. Nullable

The content of the note.

CreationUser

Type: text (max 128 characters)

The operator who created the note.

CreationDate

Type: datetime

The date of creation of the note.

UpdatedUser

Type: text (max 128 characters)

The operator who last updated the note.

UpdatedDate

Type: datetime

The date of the last update to the note.