Item Structure Explosion

A Structure Explosion breaks apart each assembly or sub-assembly into its component parts.

QName: {http://xmlns.oracle.com/apps/scm/productModel/items/structures/structureServiceV2/}Explosion

Logical Business Objects

  • SCM : Product Model : Item Structure

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 Structure Version 2

Attributes

The following table describes attributes in the service data object.

Name Type Description

ATPCode

string

An attribute to check the following information when placing a demand: available to promise and capable to promise.

ATPComponentFlag

boolean

A flag that indicates whether to include, in available to promise checking, additional components in the bill of material for ATO and PTO items.

ATPComponentsCode

string

An attribute indicating whether to check additional components in the bill of material of assemble-to-order and pick-to-order items when running the available to promise checks.

ATPFlag

boolean

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

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)

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.

CommonComponentSequenceId

decimal

A unique identifier for an component in a structure.

ComponentItemId

string

A unique value that identifies the item of a component.

ComponentItemNumber

string

An attribute value that represents the item number of a component.

ComponentPath

string

An attribute value that represents the hierarchical Path of a component item to the root item in a structure.

ComponentSequenceId

decimal

A unique identifier for an Component in a structure.

ComponentSequencePath

string

An attribute value that represents the hierarchical Path or linage of a component item to the root item in a structure using the component sequence IDs.
  • Primary Key

ComponentStructureItemTypeValue

string

An attribute which indicates the component sub-assembly is Date effective or "Model or Unit" effetive.

ComponentUOMCodeValue

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.

CustomerOrderEnabledFlag

boolean

A flag indicating whether an item is currently customer orderable.

CustomerOrderFlag

boolean

A flag attribute Indicating whether to allow an item to be ordered by external customers.

EndDateTime

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

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.

ExtendedQuantity

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

A calculated total quantity of the component used in the whole explosion.

FindNumber

int

An attribute value that holds find number for the component.

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.

ImplementationDate

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

A date on which the item revision is schedule to be implemented.

IncludeOnShipDocsFlag

boolean

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

InstantiabilityValue

string

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

InternalOrderEnabledFlag

boolean

A flag indicating whether to allow an item to be ordered on an internal requisition.

InternalOrderFlag

boolean

Attribute indicating whether an Item can be ordered internally.

InverseQuantity

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

An attribute value which represents the inverse of an exact or specified quantity defined for a structure component.

ItemClassName

string

An attribute value that provides metadata common to all items that share the category.

ItemSequenceNumber

decimal

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

ItemStatus

string

An attribute that defines codes used to control the transaction activity of an item. For example, an item in active status can be customer order enabled.

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.

OptionalFlag

boolean

A flag indicating if component is optional for a structure.

OrganizationCode

string

The parent 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.

OrganizationId

string

The unique identifier 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.

ParentBillSequenceId

long

A unique identifier for parent structure.

ParentCommonBillSequenceId

long

A unique identifier for parent structure.

ParentComponentSequencePath

string

An attribute value that represents the hierarchical Path or linage of a parent component item to the root item in a structure using the component sequence IDs.

ParentEffectivityControlValue

string

An attribute which value indicates the way effectively is controlled within the parent of the structure. The values include Date, Unit Number, or Serial Number.

ParentItemId

string

A unique value 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.

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.

ParentStructureDescription

string

An attribute which value represents the description of a parent structure.

ParentStructureItemTypeValue

string

An attribute which indicates the structure is Date effective or "Model or Unit" effetive.

ParentStructureName

string

An attribute which value represents the name of a parent structure.

PickComponentFlag

boolean

A flag indicating whether an item has a structure l with options, classes, or included items picked from finished goods inventory.

PlanLevel

decimal

An attribute which indicates the depth of the node (row) in the exploded tree. For example, a value 0 denotes that it is the root node.

PlanningPercentage

decimal

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

Quantity

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

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

QuantityRelatedFlag

boolean

An attribute that Identifiers to indicates if this component has quantity related reference designators.

ReplenishToOrderFlag

boolean

A flag indicating is generally built for sales order demand; a final assembly work order is created based on sales order details.

RequiredForRevenueFlag

boolean

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

RequiredToShipFlag

boolean

A flag indicating if component is required to ship the order.

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.

SalesOrderTransactionFlag

boolean

A flag that is a reference to the source transaction definition that identifies the type of transactions within each application where a budgetary control transaction is originated.

ShippableItemFlag

boolean

A flag indicating whether to ship an item to a customer.

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.

StartDateTime

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

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

SuggestedOperationSequence

int

An attribute value that holds the suggested operation sequence.

SupplyType

string

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.

TopBillSequenceId

string

A unique identifier for the bill sequence of the root item of the structure.

TopItemId

string

A unique identifier for the root item for the explosion of the structure.

TopItemNumber

string

An attribute value that is the identifier for the root item for the explosion of the structure.

UsePlaceholderFlag

boolean

An attribute that determines whether option class item data should be loaded into configurator models or not.

UserItemTypeValue

string

A unique value that indicates a grouping of all items of a particular category that share the same set of item attributes, used as a high-level grouping for processes. For example, each account generator item type (such as FA account generator) contains a group of processes for determining how an accounting flexfield code combination is created.

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.