Document Table

The Document table stores details 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 `Document` table
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 `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 IT Asset Management 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 IT Asset Management 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.
`AssetID`	Type: integer. Key. Nullable The asset to which this document may be linked. Foreign key to the `Asset` table.
`PurchaseOrderID`	Type: integer. Key. Nullable The purchase order to which the document may be linked. Foreign key to the `PurchaseOrder` table.
`PurchaseOrderDetailID`	Type: integer. Key. Nullable The purchase order detail (or PO line) to which the document may be linked. Foreign key to the `PurchaseOrderDetail` table.
`ContractID`	Type: integer. Key. Nullable The contract to which the document may be linked. Foreign key to the `Contract` table.
`SoftwareLicenseID`	Type: integer. Nullable The license to which the document may be linked. Foreign key to the `SoftwareLicense` table.
`ComplianceUserID`	Type: integer. Key. Nullable The end-user to which the document may be linked. Foreign key to the `ComplianceUser` table.
`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 `DocumentNote` table.
`ContractNoteID`	Type: integer. Key. Nullable The contract note to which this document may be linked. Foreign key to the `ContractNote` table.
`TermAndConditionID`	Type: integer. Key. Nullable The term/condition to which this document may be linked. Foreign key to the `TermAndCondition` table.
`SecurityTypeID`	Type: integer. Key. Nullable Security type for this document (role-based or individual access). Foreign key to the `SecurityType` table.
`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 document may be linked. Foreign key to the `ComplianceOperator` table.
`IsOracleLMS`	Type: boolean If set to `True`, this field indicates that this document is relating to Oracle GLAS. If `False`, then the document is not relating to Oracle GLAS.