Document Table
The Document
table stores details of documents or files relating to assets, contracts, purchase orders, licenses and terms and conditions.
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 |
---|---|
DocumentID
|
Type: integer. Key. Generated ID A unique identifier for the document. |
DocumentTypeID
|
Type: integer The way that the document is stored and referenced. Foreign key to the |
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 |
DocumentSize
|
Type: integer. Nullable Document size in bytes. |
ContentType
|
Type: text (max 256 characters). Nullable The MIME-type of the document file. |
AssetID
|
Type: integer. Key. Nullable The asset to which this document may be linked. Foreign key to the |
PurchaseOrderID
|
Type: integer. Key. Nullable The purchase order to which the document may be linked. Foreign key to the |
PurchaseOrderDetailID
|
Type: integer. Key. Nullable The purchase order detail (or PO line) to which the document may be linked. Foreign key to the |
ContractID
|
Type: integer. Key. Nullable The contract to which the document may be linked. Foreign key to the |
SoftwareLicenseID
|
Type: integer. Nullable The license to which the document may be linked. Foreign key to the |
ComplianceUserID
|
Type: integer. Key. Nullable The end-user to which the document may be linked. Foreign key to the |
AttachDate
|
Type: datetime The date and time this document was linked. |
UserName
|
Type: text (max 256 characters) Operator who created the link between this document and the other object. |
DocumentNoteID
|
Type: integer. Key. Nullable The note to which this document may be linked. Foreign key to the |
ContractNoteID
|
Type: integer. Key. Nullable The contract note to which this document may be linked. Foreign key to the |
TermAndConditionID
|
Type: integer. Key. Nullable The term/condition to which this document may be linked. Foreign key to the |
SecurityTypeID
|
Type: integer. Key. Nullable Security type for this document (role-based or individual access). Foreign key to the |
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. |
ComplianceOperatorID
|
Type: integer. Nullable The end-operator to which the documnet may be linked. Foreign key to the |
IsOracleLMS
|
Type: boolean If set to |
FlexNet Manager Suite (On-Premises)
2020 R1