SupplierQualificationQuestionsattachments
Holds documents (images, policy PDFs) linked to a question, giving respondents extra context or references.
Columns
| Name | Type | Description |
| SupplierQualificationQuestionsQuestionId [KEY] | Long | Unique identifier for the question to which the attachment is associated. This ID links the attachment to a specific question. |
| AttachedDocumentId [KEY] | Long | Unique identifier for the attachment. This primary key is generated by the application when a document is attached to a question. The ID helps in tracking and referencing the attachment. |
| LastUpdateDate | Datetime | Timestamp of when the attachment was last updated. This helps in tracking changes made to the attachment. |
| LastUpdatedBy | String | Username of the person who last updated the attachment. This provides traceability for any modifications to the attachment. |
| DatatypeCode | String | Abbreviation that identifies the type of data in the attachment. Accepted values typically include FILE, FOLDER, TEXT, or WEB_PAGE. |
| FileName | String | Name of the attachment file. This field stores the original name of the file that was uploaded. |
| DmFolderPath | String | Path within the document management system where the attachment is stored. |
| DmDocumentId | String | Unique identifier for the document in the document management system. This helps in linking the document to the system for retrieval. |
| DmVersionNumber | String | Version number of the attachment. It identifies the specific version of the document in case of updates or revisions. |
| Url | String | URL (Uniform Resource Locator) that directly locates the attachment in the system. |
| CategoryName | String | Category associated with the attachment. This could be used to group similar types of attachments, such as contracts or proposals. |
| UserName | String | Username of the person who uploaded the attachment. This helps identify the uploader of the document. |
| Uri | String | Uniform Resource Identifier (URI) that identifies the location of the attachment in the system. |
| FileUrl | String | Full URL (Uniform Resource Locator) used to access the attachment. |
| UploadedText | String | Text content that may be included in the attachment. This could be descriptive or textual content related to the file. |
| UploadedFileContentType | String | The content type of the uploaded file, indicating its format. |
| UploadedFileLength | Long | Size of the uploaded file, typically in bytes. This field is used to track the file size. |
| UploadedFileName | String | Name of the uploaded file as it is stored in the system after the upload. |
| ContentRepositoryFileShared | Bool | Indicates whether the file is shared with others. Acceptable values: true (shared) or false (not shared). The default value is false. |
| Title | String | Title of the attachment. This is a short description of the document to provide context to users. |
| Description | String | Description of the attachment. This provides more detailed information about the attachment's content. |
| ErrorStatusCode | String | Error code associated with the attachment, if any. This code helps identify the issue with the attachment if it fails to upload or has problems. |
| ErrorStatusMessage | String | Descriptive text explaining the error encountered while uploading or processing the attachment. |
| CreatedBy | String | Username of the person who initially created or uploaded the attachment. |
| CreationDate | Datetime | Date and time when the attachment was originally created or uploaded. |
| FileContents | String | Textual or encoded representation of the file contents. This is typically used for previewing text-based files. |
| ExpirationDate | Datetime | Date when the attachment's content is set to expire or become invalid. |
| LastUpdatedByUserName | String | Username of the person who last modified or updated the attachment. |
| CreatedByUserName | String | Username of the person who created or uploaded the attachment, useful for tracking origins. |
| AsyncTrackerId | String | Identifier used for tracking asynchronous file uploads, if the system handles file uploads in the background. |
| FileWebImage | String | Base64-encoded image representation of the file, used for displaying the file as an image, such as a .png preview. |
| DownloadInfo | String | JSON string containing information needed to retrieve the attachment programmatically. |
| PostProcessingAction | String | Action to be performed after the attachment is uploaded, such as indexing or virus scanning. |
| Finder | String | Search keyword used to locate the attachment in the system. This is helpful for users to quickly search for specific documents. |
| QuestionId | Long | Unique identifier for the question that this attachment is linked to. This helps to associate the document with the specific qualification question. |