Item Catalog Category Version 2

The association of a category to a catalog or a child category to a parent category, such as the association of the Televisions category to the Summer catalog or to the Electronics category.

QName: {http://xmlns.oracle.com/apps/scm/productModel/items/itemServiceV2/}ItemCategory

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

Contained by

Item Version 2

Handled by

Item Version 2

Handled by

Product Design Change Order Web Service

Attributes

The following table describes attributes in the service data object.

Name Type Description

CategoryCode

string

An unique code that represents a component of catalog used for classification of items.

CategoryName

string

An unique value that represents a component of catalog used for classification of items.

CreatedBy

string

Who column: An attribute which indicates the user that created the item catalog category.

CreationDateTime

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

Who column: An attribute that indicates the date and time of the creation of the item catalog category.

EndDate

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

Date when the item association ends. The end date cannot be specified for functional area catalogs, except for the catalog assigned to service logistics functional area.

ItemCatalog

string

An attribute that represents a classification of a set of categories.

ItemCategoryAssignmentId

long

An unique value that represents the assignment of an item to a category.
  • Primary Key

ItemCategoryHierarchyCode

string

An attribute that represents category hierarchy using category codes.

ItemCategoryHierarchyName

string

An attribute that represents category hierarchy using category names.

ItemId

long

An unique identifier for a part, material, product or service that is unique as compared with other items by the nature of its attributes.

LastUpdateDateTime

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

Who column: An attribute which indicates the date and time of the last update of the item catalog category.

LastUpdateLogin

string

Who column: An attribute which indicates the user that logged in last for the item catalog category.

LastUpdatedBy

string

Who column: An attribute which indicates the user that last updated the item catalog category.

ObjectVersionNumber

int

This value is set to value of 1 when the item is created and incremented every time the item is updated.

OrganizationId

long

An unique identifier for an organizing unit in the internal or external structure of your enterprise. Organization structures provide the framework for performing legal reporting, financial control, and management reporting.

PublicationTransactionType

string

This attribute determines if the Category is being publishing from Production table or Audit Table.

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.

SequenceNumber

int

An attribute that indicates the sequence number of the item category assignments.

StartDate

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

Date when the item association begins. The start date cannot be specified for functional area catalogs, except for the catalog assigned to service logistics functional area.