DocumentHistory Table

The DocumentHistory table stores history of documents or files relating to assets, contracts, purchase orders, licenses, and terms and conditions.

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 DocumentHistory table

Database Column



Type: integer. Key. Generated ID

A unique identifier for the document history.


Type: integer. Key

The corresponding document. Foreign key to the Document table.


Type: integer

The way that the document is stored and referenced. Foreign key to the DocumentType table.


Type: text (max 500 characters)

The name of the document.


Type: image. Nullable

The binary data for the document (if it is stored in the FlexNet Manager Suite database).


Type: text (max 500 characters). Nullable

The program to attempt to open the document with.


Type: text (max 3000 characters)

A description of the document.


Type: text (max 500 characters). Nullable

Physical location of a (possibly hard) copy of this document. NOTE: for compatibility with the FlexNet Manager Suite console, when the document type is 3 (Reference), the DocumentName column should be used instead, and this field set to null.


Type: integer. Nullable

Document size in bytes.


Type: text (max 256 characters). Nullable

The MIME-type of the document file.


Type: text (max 256 characters)

Operator who created the link between this document and the other object.


Type: datetime

The date and time this document was linked to the other object.


Type: text (max 20 characters). Nullable

The type of the file that has been uploaded, if any. This is used to provide full-text indexing.