Item Interface Extensible Flexfield

An open interface table for an item extensible flexfields.

QName: {http://xmlns.oracle.com/apps/scm/productCatalogManagement/advancedItems/protectedModel/}ItemInterfaceEffBase

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

Extended by

Item Interface Extensible Flexfield

Attributes

The following table describes attributes in the service data object.

Name Type Description

BatchId

long

An unique identifier of the batch in which this interface record is to be processed. Not a required field.

ContextCode

string

Attribute which controls the structure or segments applicable.

CreationDate

{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.

InterfaceTableUniqueId

long

Unique identifier of interface record.
  • Primary Key

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

LastUpdateDate

{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.

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

Read Only: 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.

SourceSystemReference

string

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

TransactionType

string

The attribute value which indicates the action type for the Item Interface transaction. The values includes CREATE, UPDATE, or SYNC.

VersionEnabledFlag

string

A flag that controls if a version is enabled for an item revision.

VersionRevisionCode

string

Read Only: An attribute that represent an incremenatal change to the item. All items have at least one revision.

VersionStartDate

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

The date and time on which the item revision is scheduled to be effective.