ItemCatalogs
ItemCatalogs
Columns
Name | Type | Description |
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. |
CatalogName | String | Name of the catalog. |
Description | String | Description of the catalog. |
MasterControlledFlag | Bool | Contains the following values: Master Level or Organization Level. Master Level enables automatic assignment of the items assigned to a category to be assigned to all child organizations. Organization Level assigns the item only to the organization in the current context. The default value is Master Level. |
StartDate | Date | Date when the catalog becomes active. |
EndDate | Date | Date when the catalog becomes inactive. |
AssignItemsToLeafOnlyFlag | Bool | Contains one of the following values: true or false. If true, then an item can be assigned to lowest level of categories in an hierarchy in the catalog. If false, then an item can only be assigned to any category in the catalog. The default value is true. |
AllowItemToMultipleCategoriesFlag | Bool | Contains one of the following values: true or false. If true, then an item can be assigned to multiple categories in the catalog. If false, then an item can only be assigned to a single category in the catalog. The default value is false. |
PublicCatalogFlag | Bool | Contains one of the following values: true or false. If true, then the catalog is accessible to all users and groups. If false, then the catalog accessibility is controlled by data security policies. The default value is true. |
DefaultCategoryCode | String | Abbreviation that identifies the default category specified for a catalog. Review and update the value for this attribute using the Items work area, and the Manage Catalogs task. |
HierarchyEnabledFlag | Bool | Contains one of the following values: true or false. If true, then the item can be assigned to lowest level of categories in an hierarchy in the catalog. If false, then the item can only be assigned to any category in the catalog. The default value is true. |
CreationDateTime | Datetime | Date and time when the user created the catalog. |
LastUpdateDateTime | Datetime | Date and time when the user most recently updated the catalog. |
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 |
Finder | String | finder |