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 |