SupplierQualificationAreasattachments
Stores attachments for qualification areas, such as policy files or reference documents supporting the qualification criteria.
Columns
| Name | Type | Description |
| SupplierQualificationAreasQualAreaId [KEY] | Long | Unique identifier for the qualification area to which the attachment is linked. This ID connects the attachment to a specific qualification area. You can find this ID in the qualification area management system. |
| AttachedDocumentId [KEY] | Long | Unique identifier for the attached document. It is the primary key created when a document is uploaded. This can be found in the document management system where the file is stored. |
| LastUpdateDate | Datetime | The date and time when the attachment was last updated. This helps track when the document was modified or replaced. |
| LastUpdatedBy | String | Name of the user who last updated the attachment. This field identifies the individual who made changes to the document record. |
| DatatypeCode | String | Abbreviation identifying the data type of the attachment. Accepted values include 'FILE', 'FOLDER', 'TEXT', or 'WEB_PAGE'. These values can be found in the data type lookup configuration. |
| FileName | String | Name of the file uploaded as the attachment. This is the actual name of the file that was attached and stored. |
| DmFolderPath | String | Path to the folder where the document is stored in the document management system (DMS). This provides the location within the repository. |
| DmDocumentId | String | Unique identifier of the document in the document management system. This ID is used to retrieve the document from the repository. |
| DmVersionNumber | String | Version number of the attached document. It helps track the document's version history and can be found in the version control section of the document management system. |
| Url | String | URL (Uniform Resource Locator) to access the attachment. This is the web link pointing to the location of the file in the system. |
| CategoryName | String | Category assigned to the attachment. This field is used to group similar types of documents together in the document management system. |
| UserName | String | The login credentials of the user who uploaded the attachment. This helps identify who was responsible for adding the document. |
| Uri | String | Uniform Resource Identifier (URI) that uniquely identifies the attachment within the system. The URI is often used for programmatic access to the file. |
| FileUrl | String | URL of the attachment file. This link can be used to download or view the document directly. |
| UploadedText | String | Text content extracted from the uploaded file. This field is applicable if the attachment is a text-based document. |
| UploadedFileContentType | String | The content type of the uploaded file, indicating its format. |
| UploadedFileLength | Long | Size of the uploaded file in bytes. This field shows how large the file is and can be found in the file metadata. |
| UploadedFileName | String | Name of the uploaded file as it appears in the document repository. This can be different from the original file name if it was modified during upload. |
| ContentRepositoryFileShared | Bool | Indicates whether the file is shared with others. If true, the file is accessible by authorized users, otherwise it is not. This setting is managed in the content repository configuration. |
| Title | String | Title of the attachment. This is a short description or title that summarizes the content of the attachment. |
| Description | String | Detailed description of the attachment. This field provides context and more information about the file for users reviewing the document. |
| ErrorStatusCode | String | Code that identifies any errors associated with the attachment. If any issues occurred during upload or processing, this code is used to indicate the error type. Accepted values can be found in the error code lookup. |
| ErrorStatusMessage | String | Message explaining the error, if any, associated with the attachment. This provides more context about the issue and can be found in the error logs. |
| CreatedBy | String | The name of the user who created the attachment record in the system. This is the individual who first uploaded the document. |
| CreationDate | Datetime | The date and time when the attachment was first uploaded to the system. |
| FileContents | String | Content of the file in text form, if applicable. This field may be used for textual files or to display a preview of the document's contents. |
| ExpirationDate | Datetime | Date when the attachment will expire. After this date, the file may be archived or removed from the system, depending on retention policies. |
| LastUpdatedByUserName | String | Username of the individual who last updated the attachment. This helps track modifications made to the document record. |
| CreatedByUserName | String | Username of the individual who originally created the attachment. This identifies the person who uploaded the document. |
| AsyncTrackerId | String | Unique identifier used to track the asynchronous processing of the attachment upload. This can be useful for monitoring the upload status. |
| FileWebImage | String | Base64-encoded image of the file displayed as a web image in .png format if the document is an image that can be converted to a web-viewable format. |
| DownloadInfo | String | JSON object containing information necessary for programmatic retrieval of the attachment. This can be used by developers to automate the file retrieval process. |
| PostProcessingAction | String | Action that can be performed after the file is uploaded, such as indexing, virus scanning, or conversion. This is defined by post-upload processing rules. |
| Finder | String | Search term or filter used to locate the attachment within the system. This helps users find specific attachments based on keywords or tags. |
| QualAreaId | Long | Unique identifier for the qualification area that the attachment is linked to. This ID connects the attachment to a specific qualification area. |