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.

DocumentHistoryID

Type: integer. Key. Generated ID

A unique identifier for the document history.

DocumentID

Type: integer. Key

The corresponding document. Foreign key to the Document table.

DocumentTypeID

Type: integer

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

DocumentName

Type: text (max 500 characters)

The name of the document.

DocumentFile

Type: image. Nullable

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

OpenWith

Type: text (max 500 characters). Nullable

The program to attempt to open the document with.

DocumentDescription

Type: text (max 3000 characters)

A description of the document.

PhysicalLocation

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.

DocumentSize

Type: integer. Nullable

Document size in bytes.

ContentType

Type: text (max 256 characters). Nullable

The MIME-type of the document file.

UserName

Type: text (max 256 characters)

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

AttachDate

Type: datetime

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

FileType

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.