ItemCategoriesattachments
ItemCategoriesattachments
Columns
| Name | Type | Description |
| ItemCategoriesCatalogId [KEY] | Long | Value that uniquely identifies the item catalog. |
| ItemCategoriesCategoryId [KEY] | Long | Value that uniquely identifies the item category. |
| LastUpdateDate | Datetime | Date when the user most recently updated the attachment. |
| LastUpdatedBy | String | User who most recently updated the attachment. |
| DatatypeCode | String | Abbreviation that indicates the type of data. Valid values include WEB_PAGE, TEXT, or FILE. |
| FileName | String | Name of the file attached to the item. |
| DmFolderPath | String | Path to the folder in which the attached file is uploaded. |
| Url | String | Uniform resource locator of the attachment. |
| CategoryName | String | Name of the catalog attachment category. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Attachment Categories task. |
| UserName | String | Display name of the attachment category. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage attachment categories task. |
| Uri | String | Uniform resource identifier appended to the base URI derived from the endpoint associated with application identified by the MODULE_ID. |
| FileUrl | String | Uniform resource locator of the attachment file. |
| UploadedText | String | Content of the attached text file. |
| UploadedFileContentType | String | Type of the file content. |
| UploadedFileLength | Long | Size of the attached file. |
| UploadedFileName | String | Name of the attached file. |
| ContentRepositoryFileShared | Bool | Contains one of the following values: true or false. If true, then the attachment is shared. If false, then it's not shared. The default value is false. |
| Title | String | Title of the catalog attachment. |
| Description | String | Description of the catalog attachment. |
| ErrorStatusCode | String | Abbreviation that identifies the error code, if any, for the attachment. |
| ErrorStatusMessage | String | Text of the error message, if any, for the attachment. |
| CreatedBy | String | User who created the attachment. |
| CreationDate | Datetime | Date when the user created the attachment. |
| DownloadInfo | String | JSON object represented as a string containing information used to programmatically retrieve a file attachment. |
| DocumentURL | String | Uniform resource locator of the catalog attachment. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| Bind_CatalogCode | String | Bind_CatalogCode |
| CatalogId | Long | CatalogId |
| CategoryId | Long | CategoryId |
| FunctionalAreaId | Long | FunctionalAreaId |
| Finder | String | finder |