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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| 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 |