ItemsV2ItemRevision
ItemsV2ItemRevision
Columns
| Name | Type | Description |
| ItemsV2ItemId [KEY] | Long | ItemsV2ItemId of ItemsV2ItemRevision |
| ItemsV2OrganizationId [KEY] | Long | ItemsV2OrganizationId of ItemsV2ItemRevision |
| RevisionId [KEY] | Long | An unique identifier of a revision. |
| ItemId | Long | An unique identifier for a part, material, product or service that is unique as compared with other items by the nature of its attributes. |
| OrganizationId [KEY] | Long | An unique identifier for an organizing unit in the internal or external structure of your enterprise. Organization structures provide the framework for performing legal reporting, financial control, and management reporting. |
| RevisionCode | String | An attribute value that represents a revision. |
| ItemRevisionDescription | String | The description for on item revision. |
| RevisionReasonValue | String | An attribute value that represents the reason for a revision. |
| EffectivityDate | Datetime | Revision effectively date |
| ImplementationDate | Datetime | Date and time when the revision was implemented. |
| EndEffectivityDate | Datetime | Date and time when the effectivity of the revision ends. |
| RevisionExtensibleFlexfieldCategoryCode | String | An attribute value for the EFF category code for the Item revision. |
| CreationDateTime | Datetime | Who column: An attribute that indicates the date and time of the creation of the item revision. |
| LastUpdateDateTime | Datetime | Who column: An attribute which indicates the date and time of the last update of the item revision. |
| CreatedBy | String | Who column: An attribute which indicates the user that created the item revision. |
| LastUpdateLogin | String | Who column: An attribute which indicates the user that logged in last for the item revision |
| LastUpdatedBy | String | Who column: An attribute which indicates the user that last updated the item revision |
| RequestId | Long | This is the request id generated at import. Its use case is to verify import, the items will be published based on RequestID. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| AcdType | String | AcdType |
| ChangeLineId | Long | ChangeLineId |
| InventoryOrganizationId | Long | InventoryOrganizationId |
| ItemNumber | String | ItemNumber |
| OrganizationCode | String | OrganizationCode |
| VersionId | Long | VersionId |
| Finder | String | finder |