ItemsV2ItemRevisionItemRevisionDFF
ItemsV2ItemRevisionItemRevisionDFF
Columns
| Name | Type | Description |
| ItemsV2ItemId [KEY] | Long | ItemsV2ItemId of ItemsV2ItemRevisionItemRevisionDFF |
| ItemsV2OrganizationId [KEY] | Long | ItemsV2OrganizationId of ItemsV2ItemRevisionItemRevisionDFF |
| ItemrevisionInventoryItemId [KEY] | Long | ItemrevisionInventoryItemId of ItemsV2ItemRevisionItemRevisionDFF |
| ItemrevisionOrganizationId [KEY] | Long | ItemrevisionOrganizationId of ItemsV2ItemRevisionItemRevisionDFF |
| ItemrevisionRevisionId [KEY] | Long | ItemrevisionRevisionId of ItemsV2ItemRevisionItemRevisionDFF |
| RevisionId [KEY] | Long | Value that uniquely identifies the revision of the item. |
| _FLEX_ValidationDate | Date | _FLEX_ValidationDate of ItemsV2ItemRevisionItemRevisionDFF |
| _FLEX_Context | String | Descriptive flexfield context name for item revision. |
| _FLEX_NumOfSegments | Int | _FLEX_NumOfSegments of ItemsV2ItemRevisionItemRevisionDFF |
| _FLEX_NumOfVisibleSegments | Int | _FLEX_NumOfVisibleSegments of ItemsV2ItemRevisionItemRevisionDFF |
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 |