ItemCatalogscategoryHierarchies
ItemCatalogscategoryHierarchies
Columns
| Name | Type | Description |
| ItemCatalogsCatalogId [KEY] | Long | Value that uniquely identifies the item catalog. |
| CategoryId [KEY] | Long | Value that uniquely identifies the category. |
| CategoryCode | String | Abbreviation that identifies the category. |
| CategoryName | String | Name of the category. Review and update the value for this attribute using the Items work area, and the Manage Catalogs task. |
| CatalogId [KEY] | Long | Value that uniquely identifies the catalog. This value should not be used in service calls to create catalogs. |
| CatalogCode | String | Abbreviation that identifies the catalog. |
| ParentCategoryId | Long | Value that uniquely identifies the category set as the parent category. |
| ParentCategoryCode | String | Abbreviation that identifies the category set as the parent category. |
| Description | String | Description of the category. |
| StartDate | Date | Date when the category becomes active. |
| EndDate | Date | Date when the category becomes inactive. |
| ItemsOnlyFlag | Bool | Contains one of the following values: true or false. If true, then the category can be used only for item assignment. If false, then hierarchy can be created for the category. The default value is false. |
| SharedFlag | Bool | Contains one of the following values: true or false. If true, then the category hierarchy is shared. If false, then the hierarchy is copied and not shared. The default value is false. |
| CreationDateTime | Datetime | Date and time when the user created the category hierarchy. |
| LastUpdateDateTime | Datetime | Date and time when the user most recently updated the category. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String | finder |