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



Type: integer. Key. Generated ID

A unique identifier for the document note.


Type: integer

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


Type: text (max 100 characters)

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


Type: text. Nullable

The content of the note.


Type: text (max 128 characters)

The operator who created the note.


Type: datetime

The date of creation of the note.


Type: text (max 128 characters)

The operator who last updated the note.


Type: datetime

The date of the last update to the note.