Item Catalog SDO

A hierarchical organization of items into categories, such as a spring sale catalog or a purchasing catalog.

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

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 Catalog Descriptive Flexfield

Contains

Attachment SDO

Contains

Catalog Category Hierarchy SDO

Contains

Item Catalog Translation

Handled by

Item Catalog

Attributes

The following table describes attributes in the service data object.

Name Type Description

AllowMultipleItemCategoryAssignmentsFlag

boolean

Flag indicating if multiple items can be assigned to a category

AssignItemsToLeafLevelCategoriesOnlyFlag

boolean

Flag indicating if items are assigned to leaf level categories only

Attachment

Attachment SDO

A view object for attachments associated with a Catalog.

CatalogCode

string

Code of the catalog.

CatalogDFF

Item Catalog Descriptive Flexfield

Descriptive flexfields of the catalog.

CatalogId

long

Unique Identifier of the catalog.
  • Primary Key

CatalogName

string

Name of the catalog

CatalogTranslation

Item Catalog Translation

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

Category

Catalog Category Hierarchy SDO

List of categories under a catalog

ControlledAt

string

Indicates if the catalog is controlled at the master organization level or at the individual organization level.

CreatedBy

string

Created by of the Catalog

CreationDateTime

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

Creation date and time of the catalog.

DefaultCategory

string

Default Category for the Catalog

Description

string

Describes the catalog.

EndDate

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

Date until which the catalog is effective.

LastUpdateDateTime

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

Last update date and time of the Catalog.

LastUpdateLogin

string

Last update date login of the Catalog

LastUpdatedBy

string

Last update date by of the Catalog

ObjectVersionNumber

int

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

PublicCatalog

string

Indicates whether the catalog is public.

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.

StartDate

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

Date from which the catalog is effective.