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.

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。