Item Structure Component Interface

An open interface table for a constituent item of a structure that includes attributes describing its usage, such as component PWRCRD of a laptop item structure, or component GEAR of an auto transmission item structure.

QName: {http://xmlns.oracle.com/apps/scm/productHub/itemImport/batches/structureInterfaceService/}ComponentInterface

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

AutoRequestMaterialFlag

boolean

A flag that indicates if a move order is automatically created for a material at work order release.

BasisValue

string

An attribute value that determines if the option class quantity can be overridden by sales order. The valid values include None (can override) or Option Class (cannot override)

BatchId

long

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

BatchName

string

An attribute value that represents the name of the batch.

CheckATPFlag

boolean

A flag indicating to check available to promise and/or capable to promise information when placing demand.

Comments

string

An attribute value that represents comments about a component.

ComponentItemNumber

string

An attribute that represents the item number of a component.

ComponentTransactionId

long

Unique identifier of interface record.
  • Primary Key

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 component interface record.

EndDateTime

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

The date and time on which a component in a structure ends.

EnforceIntegerRequirementsValue

string

Starting Item Unit Number or starting Item Serial Number that a component is effective in a structure. Valid only for unit/serial effective structures.

FindNumber

int

A number that identifies a specific instance of an item in a structure.

FromNumber

string

The item unit number or serial number from which the component is effective. Valid only for unit or serial effective structures. The value should be a serial number or an unit number depending on the effectivity of the structure.

IncludeOnShipDocsFlag

boolean

A flag value that indicates if a component is displayed on shipping documentation.

InstantiabilityValue

string

An unique identifier indicating whether a component item is instantiable in an item structure.

ItemSequenceNumber

decimal

A unique number which defines the sequence of components in a structure.

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 component interface record.

MaximumQuantity

{http://xmlns.oracle.com/adf/svc/types/}MeasureType

An attribute that value indicates the maximum quantity allowed on an order.

MinimumQuantity

{http://xmlns.oracle.com/adf/svc/types/}MeasureType

An attribute that value indicates the minimum quantity allowed on an order.

MutuallyExclusiveFlag

boolean

A flag indicating if one or more options under this Option Class can be chosen.

NewFindNumber

int

The new value of the Find Number when you replace a component.

NewFromNumber

string

The new item unit number or serial number from which the component is effective. Valid only for unit or serial effective structures. The value should be a serial number or an unit number depending on the effectivity of the structure.

NewStartDateTime

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

The new date and time on which a component in a structure starts.

OptionalFlag

boolean

A flag indicating if component is optional for a structure.

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.

ParentItemNumber

string

An attribute for the parent of an identifier for a part, material, product or service that is unique as compared with other items by the nature of its attributes. The value for this attribute will be mapped to the item number of the parent item for a batch using PIMDH for the spoke system and will be mapped to the parent spoke system item number for all other batches.

PlanningPercent

decimal

An attribute used by forecast planning that represents the distribution percentage for a component.

PrimaryUOMCode

string

A value which indicates the component's own unit of measurement as used in a bill of materials. This may be different from the item's own unit of measurement. An example would be Wooden Panels used in the construction of a piece of furniure e.g. a Table. The wooden panel's unit of measurement may be "Box" , but it may have a unit of measurement "Each" when used as component of a table.

PrimaryUOMCodeValue

string

A value which indicates the component's own unit of measurement as used in a bill of materials. This may be different from the item's own unit of measurement. An example would be Wooden Panels used in the construction of a piece of furniure e.g. a Table. The wooden panel's unit of measurement may be "Box" , but it may have a unit of measurement "Each" when used as component of a table.

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.

Quantity

{http://xmlns.oracle.com/adf/svc/types/}MeasureType

An attribute value the represents the quantity of component item used.

ReplacedBy

string

The item number corresponding to the item that replaced the component.

RequiredForRevenueFlag

boolean

A flag indicating if component is required to recognize revenue before you ship the order.

RequiredToShipFlag

boolean

Flag indicating if component is required to ship

SalesOrderBasisValue

string

An indicator to override the default quantity for the option class when a sales order is entered (the default), for components of BOM Item Type option class. Option class quantities affect the mandatory standard components assigned to the option class.

ShowInSalesValue

string

An attribute value that indicates if the component is visible in the sales application. Values include Yes, Hide Self and Hide Self and descendents.

SpokeSystemItem

string

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

StartDateTime

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

The date and time on which a component in a structure begins.

StructureName

string

An attribute which value represents the name of a structure.

SuggestedOperationSequence

int

The operation sequence number for the component in a manufacturing work definition, suggested by a design engineer

SupplyType

decimal

An attribute indicating a supply type for components.

ToNumber

string

The item unit number or serial number up to which the component is effective. Valid only for unit or serial effective structures. The value should be a serial number or an unit number depending on the effectivity of the structure.

TransactionType

string

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

UsePlaceholderFlag

boolean

Indicates whether a placeholder should be set for the component while loading data into configurator models. If set to Yes, a placeholder is set and component data isn't loaded into the configurator model during structure import.

Yield

decimal

An attribute that for a quantity represents the planned or actual output of a process. Yield includes a loss, an increase, or no change in the planned or actual output quantity.