ItemCategories
ItemCategories
Columns
| Name | Type | Description |
| CategoryId [KEY] | Long | Value that uniquely identifies the item category. This value should not be used in service calls to create categories in catalogs. |
| CategoryCode | String | Abbreviation that identifies the item category in user interface. |
| CategoryName | String | Name of the category. |
| CatalogId [KEY] | Long | Value that uniquely identifies the item catalog. |
| CatalogCode | String | Abbreviation that identifies the item catalog. |
| ParentCategoryCode | String | Abbreviation that identifies the parent category in a category hierarchy. |
| Description | String | Description of the category. |
| StartDate | Date | Date when the item 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 have only items assigned to it. If false, the category can have both items and child categories assigned to it. The default value is false. |
| SharedFlag | Bool | Contains one of the following values: true or false. If true, then the category is shared from a source catalog. If false, then it's not shared. The default value is false. |
| CreationDateTime | Datetime | Date and time when the user created the category. |
| LastUpdateDateTime | Datetime | Date and time when the user most recently updated the category. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| Bind_CatalogCode | String | Bind_CatalogCode |
| FunctionalAreaId | Long | FunctionalAreaId |
| Finder | String | finder |