ItemCategoriesattachments
Handles attachments for item categories, enabling additional references or documentation to be linked to specific categories.
Columns
| Name | Type | Description |
| ItemCategoriesCatalogId [KEY] | Long | The unique identifier of the catalog associated with this category attachment. This identifier ensures that the attachment is linked to the correct catalog. |
| ItemCategoriesCategoryId [KEY] | Long | The unique identifier of the category to which the attachment belongs. This identifier establishes the relationship between the category and its supporting documents. |
| LastUpdateDate | Datetime | The timestamp of the most recent update to the attachment. This timestamp is used for tracking modifications and maintaining version history. |
| LastUpdatedBy | String | The username or identifier of the user who last modified the attachment. This field helps track changes and maintain accountability. |
| DatatypeCode | String | The data type code representing the type of the attachment (for example, 'text', 'image', or 'PDF'). This code is used for categorizing and processing attachments. |
| FileName | String | The original name of the uploaded file. This name provides a human-readable reference for identifying documents. |
| DmFolderPath | String | The repository folder path where the attachment is stored. This path defines the attachmentâs location in the document management system. |
| Url | String | The direct Uniform Resource Locator (URL) of the attachment, allowing users to access it via a web browser or API. This URL ensures quick retrieval of stored files. |
| CategoryName | String | The name of the category associated with the attachment. This name provides a human-readable reference for categorization. |
| UserName | String | The username of the individual who uploaded or owns the attachment. This username provides visibility into content ownership. |
| Uri | String | The URI (Uniform Resource Identifier) of the attachment, which serves as a unique reference for retrieval in content management systems. This identifier ensures system-wide consistency in referencing files. |
| FileUrl | String | The URL specifically pointing to the attached file, enabling direct access and downloads. This URL provides an alternative method for retrieving stored documents. |
| UploadedText | String | The textual content of the attachment. This content is used for storing plain text-based attachments. |
| UploadedFileContentType | String | The content type of the uploaded file. This 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 enforcing 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. This name is essential for maintaining accurate file records. |
| ContentRepositoryFileShared | Bool | Indicates whether the attachment is shared with other users. A value of 'true' means the attachment is shared, while 'false' means it is not shared. The default value 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 item category. |
| ErrorStatusCode | String | A system-generated error code, if any, related to the attachment. This 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. This message assists in troubleshooting errors. |
| CreatedBy | String | The username or identifier of the user who originally uploaded the attachment. This field 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. |
| DownloadInfo | String | A JSON object containing metadata and parameters needed to programmatically retrieve a file attachment. This information is used for system integrations and automated file access. |
| DocumentURL | String | The URL of the document stored in the content repository. This URL enables direct access for viewing or downloading the document. |
| Bind_CatalogCode | String | The catalog code used for binding category attachment data during service calls or data retrieval operations. This code ensures consistency in catalog-category relationships. |
| CatalogId | Long | The unique identifier of the catalog associated with the attachment. This identifier ensures attachments are correctly linked to the appropriate catalog. |
| CategoryId | Long | The unique identifier of the item category associated with this attachment. This identifier ensures that attachments are linked to the correct category within the catalog. |
| Finder | String | The name of the predefined finder query used to retrieve category attachment records dynamically. This query improves efficiency in searching for category attachments. |
| FunctionalAreaId | Long | The unique identifier of the functional area associated with this category attachment. This identifier ensures that attachments are linked to relevant business functions. |