ItemsV2ItemRevisionRevisionAttachment
ItemsV2ItemRevisionRevisionAttachment
Columns
Name | Type | Description |
ItemsV2ItemId [KEY] | Long | ItemsV2ItemId of ItemsV2ItemRevisionRevisionAttachment |
ItemsV2OrganizationId [KEY] | Long | ItemsV2OrganizationId of ItemsV2ItemRevisionRevisionAttachment |
ItemrevisionInventoryItemId [KEY] | Long | ItemrevisionInventoryItemId of ItemsV2ItemRevisionRevisionAttachment |
ItemrevisionOrganizationId [KEY] | Long | ItemrevisionOrganizationId of ItemsV2ItemRevisionRevisionAttachment |
ItemrevisionRevisionId [KEY] | Long | ItemrevisionRevisionId of ItemsV2ItemRevisionRevisionAttachment |
LastUpdateDate | Datetime | An attribute which indicates the date and time of the last update of the attachment. |
LastUpdatedBy | String | LastUpdatedBy of ItemsV2ItemRevisionRevisionAttachment |
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 | Url of ItemsV2ItemRevisionRevisionAttachment |
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 ItemsV2ItemRevisionRevisionAttachment |
UploadedText | String | Contents of text file that is attached. |
UploadedFileContentType | String | UploadedFileContentType of ItemsV2ItemRevisionRevisionAttachment |
UploadedFileLength | Long | UploadedFileLength of ItemsV2ItemRevisionRevisionAttachment |
UploadedFileName | String | UploadedFileName of ItemsV2ItemRevisionRevisionAttachment |
ContentRepositoryFileShared | Bool | ContentRepositoryFileShared of ItemsV2ItemRevisionRevisionAttachment |
Title | String | Title of ItemsV2ItemRevisionRevisionAttachment |
Description | String | Description of ItemsV2ItemRevisionRevisionAttachment |
ErrorStatusCode | String | ErrorStatusCode of ItemsV2ItemRevisionRevisionAttachment |
ErrorStatusMessage | String | ErrorStatusMessage of ItemsV2ItemRevisionRevisionAttachment |
CreatedBy | String | CreatedBy of ItemsV2ItemRevisionRevisionAttachment |
CreationDate | Datetime | CreationDate of ItemsV2ItemRevisionRevisionAttachment |
ExpirationDate | Datetime | ExpirationDate of ItemsV2ItemRevisionRevisionAttachment |
LastUpdatedByUserName | String | LastUpdatedByUserName of ItemsV2ItemRevisionRevisionAttachment |
CreatedByUserName | String | CreatedByUserName of ItemsV2ItemRevisionRevisionAttachment |
DownloadInfo | String | DownloadInfo of ItemsV2ItemRevisionRevisionAttachment |
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 |