ContractNote Table
ContractNote
stores a list of notes 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.
Database Column |
Details |
---|---|
ContractNoteID
|
Type: integer. Key. Generated ID A unique identifier for the contract note. |
ContractID
|
Type: integer. Key The contract that the note is for. Foreign key to the |
ShortDescription
|
Type: text (max 100 characters) In the user interface, this maps to the contract 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. |