ItemsV2ItemDFF
ItemsV2ItemDFF
Columns
Name | Type | Description |
ItemsV2ItemId [KEY] | Long | ItemsV2ItemId of ItemsV2ItemDFF |
ItemsV2OrganizationId [KEY] | Long | ItemsV2OrganizationId of ItemsV2ItemDFF |
InventoryItemId [KEY] | Long | Value that uniquely identifies the part, item, product, or service. |
OrganizationId [KEY] | Long | Value that uniquely identifies the organization. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Inventory Organizations task. |
_FLEX_Context | String | Descriptive flexfield context name for items. |
_FLEX_Context_DisplayValue | String | Context |
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 |
VersionId | Long | VersionId |
Finder | String | finder |