IdeasAttachments
Manages attachments linked to ideas for supporting documentation.
Columns
| Name | Type | Description |
| IdeasIdeaId [KEY] | Long | The unique identifier of the idea associated with this attachment. This identifier establishes the relationship between an idea and its supporting documents. |
| AttachedDocumentId [KEY] | Long | A system-generated unique identifier for the attached document. This identifier is used for tracking and managing attachments linked to ideas. |
| LastUpdateDate | Datetime | The timestamp of the most recent update to the attachment. This timestamp helps in auditing modifications and tracking the latest version. |
| LastUpdatedBy | String | The username or identifier of the last user who modified the attachment. This identifier is useful for monitoring document changes and accountability. |
| DatatypeCode | String | A short code representing the data type of the attachment, such as text, image, or PDF. This code helps in categorizing and processing attachments. |
| FileName | String | The original name of the uploaded file. This name provides a human-readable reference to identify the document. |
| DmFolderPath | String | The repository folder path where the attachment is stored. This path defines the document’s location in the content management system. |
| DmDocumentId | String | The unique identifier assigned to the document within the document management system. This identifier is used for version control and retrieval. |
| DmVersionNumber | String | The version number of the document in the document management system. This number helps in tracking changes and ensuring access to the latest version. |
| Url | String | The direct Uniform Resource Locator (URL) of the attachment, allowing users to access it via a web browser or API. |
| CategoryName | String | The classification or category assigned to the attachment. This classification helps in organizing and filtering attachments based on purpose or content type. |
| UserName | String | The username of the individual who uploaded or owns the attachment. This username provides visibility into content ownership. |
| Uri | String | The URI of the attachment, which serves as a unique reference for retrieval in content management systems. |
| FileUrl | String | The URL specifically pointing to the attached file, enabling direct access and downloads. |
| UploadedText | String | The textual content of the attachment. This field is used for storing plain text-based attachments. |
| UploadedFileContentType | String | The content type of the uploaded file. This content type helps in correctly handling file types in processing and display. |
| UploadedFileLength | Long | The file size of the uploaded attachment in bytes. This metric is used for storage management and file size restrictions. |
| UploadedFileName | String | The name of the file when uploaded, which can differ from the original file name if renaming occurs during processing. |
| ContentRepositoryFileShared | Bool | Indicates whether the attachment is shared with other users. Possible values include 'true' (shared) or 'false' (not shared). The default is 'false'. |
| Title | String | The title or display name of the attachment. This title is used for identifying attachments in lists and reports. |
| Description | String | A brief description of the attachment's contents. This description provides context for users reviewing attachments related to an idea. |
| ErrorStatusCode | String | A system-generated error code, if any, related to the attachment. This error code is used for diagnosing upload or processing issues. |
| ErrorStatusMessage | String | A descriptive error message providing details about an issue encountered while processing the attachment. |
| CreatedBy | String | The username or identifier of the user who originally uploaded the attachment. This identifier helps track content ownership and submission history. |
| CreationDate | Datetime | The timestamp when the attachment was first uploaded. This timestamp provides historical tracking of content additions. |
| FileContents | String | The raw content of the attachment, typically used for inline storage of file data in text-based formats. |
| ExpirationDate | Datetime | The date when the attachment expires or is scheduled for removal. This date helps in content lifecycle management. |
| LastUpdatedByUserName | String | The username of the last user who modified the attachment. This username is useful for tracking recent changes. |
| CreatedByUserName | String | The username of the individual who initially uploaded the attachment. This username provides a human-readable identifier for the creator. |
| AsyncTrackerId | String | A system-generated identifier used to track the upload process for asynchronous file processing. |
| FileWebImage | String | The URL or reference to a web-friendly version of the attachment, typically used for displaying images or previewing files in a browser. |
| DownloadInfo | String | A JSON object represented as a string containing metadata and parameters needed to programmatically retrieve a file attachment. This information is used for system integrations and automated file access. |
| PostProcessingAction | String | The name of the action that can be performed after an attachment is uploaded. This can include actions such as validation, conversion, or notification triggers. |
| Finder | String | The name of the predefined finder query used to retrieve attachments dynamically. Finders help optimize attachment searches based on criteria such as associated ideas or upload dates. |
| IdeaId | Long | The unique identifier of the idea associated with this attachment. This identifier establishes a direct relationship between an idea and its supporting documents. |