Catalog Category Hierarchy SDO

A hierarchical arrangement of categories within a catalog.

QName: {http://xmlns.oracle.com/apps/scm/productModel/catalogs/itemCatalogService/}CategoryHierarchyReadOnly

Logical Business Objects

  • SCM : Product Model : Item Catalog

Relationships

The following table describes how this service data object is related to other service data objects or business object services.

Relationship Type Object or Service

Contains

Item Category Descriptive Flexfield

Contains

Attachment SDO

Contains

Item Category Translation

Contains

Catalog Category Hierarchy SDO

Contains

Item Category Assignment SDO

Contained by

Catalog Category Hierarchy SDO

Contained by

Item Catalog SDO

Handled by

Item Catalog

Attributes

The following table describes attributes in the service data object.

Name Type Description

Attachment

Attachment SDO

List of Attachments under a catalog

Category

Catalog Category Hierarchy SDO

List of categories under a catalog.

CategoryCode

string

Code of the category.

CategoryDFF

Item Category Descriptive Flexfield

Descriptive flexfield of category

CategoryId

long

Unique Identifier of the category.
  • Primary Key

CategoryName

string

Name of the category.

CategorySetId

long

Unique Identifier of the catalog.
  • Primary Key

CategoryTranslation

Item Category Translation

User can provide values in other languages for translatable fields of the category.

CreatedBy

string

Created by of the Cateroy

CreationDateTime

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

Creation Date and Time of the Category

Description

string

Describes the category.

EndDateActive

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Start date of category.

ItemCategoryAssignment

Item Category Assignment SDO

List of items assigned to the category.

LastUpdateDateTime

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

Last update date and time fo the Category

LastUpdateLogin

string

Last update date login of the Category

LastUpdatedBy

string

Last update date by of the Category

ObjectVersionNumber

int

Change record indicator, indicates number of times category row is updated.

ParentCategoryCode

string

Parent Category Code

ParentCategoryId

long

An unique identifier of the parent category of the context category.

ParentCategoryName

string

Parent Category Name

RequestId

long

This is the request id generated at import. Its use case is to verify import, the items will be published based on RequestID.

StartDateActive

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Start date of category.