DocumentHistory Table

FlexNet Manager Suite 2020 R1 (On-Premises)

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	Details
`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.

FlexNet Manager Suite (On-Premises)

2020 R1