ContractNote Table

FlexNet Manager Suite (Cloud)

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.
Table 1. Database columns for ContractNote table

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 Contract table.

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.

FlexNet Manager Suite (Cloud)

Current