Item Catalog Category Interface

An open interface table for 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/productHub/itemImport/batches/itemInterfaceService/}ItemCategoryInterface

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

Handled by

Item Batch Maintenance

Attributes

The following table describes attributes in the service data object.

Name Type Description

BatchId

long

An unique indentifier for a batch.

BatchName

string

An attribute value that represents the name of the batch.

CategoryCode

string

An attribute that represents code of a category used for classification of items.

CategoryName

string

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

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 trading partner item.

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.

InterfaceTableUniqueId

long

Unique identifier of interface record.
  • Primary Key

ItemCatalog

string

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

ItemNumber

string

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

ItemTransactionId

long

Reference to the item record in the item interface table.

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 trading partner item.

OldCategoryCode

string

Code of the category to which the item is currently assigned.

OldCategoryName

string

Name of the category to which the item is currently assigned.

OrganizationCode

string

A name of 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.

ProcessStatus

long

An attribute value which represents the status of a interface record. A value of 3 represents an error and value of 7 represents a successful import.

SpokeSystemItem

string

An attribute value that represents an item in the spoke system that is being referenced.

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.

TransactionType

string

The attribute value which incates the action type for the structure transaction. The values includes CREATE, UPDATE, or DELETE.