ItemsV2ItemAttachment
ItemsV2ItemAttachment
Columns
Name | Type | Description |
ItemsV2ItemId [KEY] | Long | ItemsV2ItemId of ItemsV2ItemAttachment |
ItemsV2OrganizationId [KEY] | Long | ItemsV2OrganizationId of ItemsV2ItemAttachment |
LastUpdateDate | Datetime | An attribute which indicates the date and time of the last update of the attachment. |
LastUpdatedBy | String | LastUpdatedBy of ItemsV2ItemAttachment |
DatatypeCode | String | An unique identifier for the datatype of the attachment. |
FileName | String | An attribute value the represents the name of a file of the attachment. |
DmFolderPath | String | An attribute value that represents the repository folder path of the attachment. |
DmDocumentId | String | An unique identifier for document in repository. |
DmVersionNumber | String | An attribute value that represents the version number of attachment in repository. |
Url | String | An attribute value that represents the URL for the attachment. |
CategoryName | String | An attribute that represents a component of catalog used for classification of items. |
UserName | String | An attribute value that represents the name of user who uploads the attachment. |
Uri | String | An attribute value the represents the Uniform Resource Identifier appended to the base URI derived from the endpoint associated with application identified by the MODULE_ID. |
FileUrl | String | FileUrl of ItemsV2ItemAttachment |
UploadedText | String | Contents of text file that is attached. |
UploadedFileContentType | String | UploadedFileContentType of ItemsV2ItemAttachment |
UploadedFileLength | Long | UploadedFileLength of ItemsV2ItemAttachment |
UploadedFileName | String | UploadedFileName of ItemsV2ItemAttachment |
ContentRepositoryFileShared | Bool | ContentRepositoryFileShared of ItemsV2ItemAttachment |
Title | String | An attribute value that represents the title of the attachment. |
Description | String | An attribute value that represents the description of the attachment. |
ErrorStatusCode | String | ErrorStatusCode of ItemsV2ItemAttachment |
ErrorStatusMessage | String | ErrorStatusMessage of ItemsV2ItemAttachment |
CreatedBy | String | CreatedBy of ItemsV2ItemAttachment |
CreationDate | Datetime | CreationDate of ItemsV2ItemAttachment |
ExpirationDate | Datetime | ExpirationDate of ItemsV2ItemAttachment |
LastUpdatedByUserName | String | LastUpdatedByUserName of ItemsV2ItemAttachment |
CreatedByUserName | String | CreatedByUserName of ItemsV2ItemAttachment |
DownloadInfo | String | DownloadInfo of ItemsV2ItemAttachment |
DocumentURL | String | An attribute value that represents the URL of the 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 |
AcdType | String | AcdType |
ChangeLineId | Long | ChangeLineId |
InventoryOrganizationId | Long | InventoryOrganizationId |
ItemId | Long | ItemId |
ItemNumber | String | ItemNumber |
OrganizationCode | String | OrganizationCode |
OrganizationId | Long | OrganizationId |
VersionId | Long | VersionId |
Finder | String | finder |