ItemsV2ItemCategory
ItemsV2ItemCategory
Columns
| Name | Type | Description |
| ItemsV2ItemId [KEY] | Long | ItemsV2ItemId of ItemsV2ItemCategory |
| ItemsV2OrganizationId [KEY] | Long | ItemsV2OrganizationId of ItemsV2ItemCategory |
| ItemId | Long | Value that uniquely identifies the part, item, product, or service. |
| OrganizationId | Long | A 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. |
| ItemCatalog | String | Name of the item catalog. |
| CategoryName | String | Name of the category. |
| SequenceNumber | Int | Value that indicates the sequence number of the item category assignments. |
| ItemCategoryAssignmentId [KEY] | Long | Value that uniquely identifies the item category assignment. |
| CreationDateTime | Datetime | Date and time of the creation of the item catalog category assignment. |
| LastUpdateDateTime | Datetime | Date and time when the user most recently updated the item-category association. |
| CategoryCode | String | A unique code that represents a component of the catalog used for classification of items. |
| CreatedBy | String | User who created the item category assignment. |
| LastUpdateLogin | String | Login that the user used when updating the item-category association.. |
| LastUpdatedBy | String | User who most recently updated the item-category association. |
| ItemCategoryHierarchyName | String | Value that represents category hierarchy using category names. |
| ItemCategoryHierarchyCode | String | Value that represents category hierarchy using category codes. |
| StartDate | Date | Date when the item association begins. The start date can't be specified for functional area catalogs, except for the catalog assigned to the service logistics functional area. |
| EndDate | Date | Date when the item association ends. The end date can't be specified for functional area catalogs, except for the catalog assigned to the service logistics functional area. |
| RequestId | Long | The request ID generated at import. Its use case is to verify the import. The items are 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 |