ItemStructuresComponent
The Components resource manages the details of a component within a structure.
Columns
| Name | Type | Description |
| ItemStructuresBillSequenceId | String | ItemStructuresBillSequenceId of ItemStructuresComponent |
| ComponentSequenceId | String | A unique identifier for an component in a structure. This attribute is read only and is not required for an update operation. |
| OrganizationId | String | Value that uniquely identifies the organization. |
| ComponentItemNumber | String | An attribute that represents the item number of a component. This attribute is only updatable for a create operation, otherwise is read only. |
| ComponentItemId | String | Value that uniquely identifies the item associated with the component. |
| ChangeNotice | String | Read Only: This attribute provides the Change Order Notice to which the pending component is added. |
| ChangeLineId | String | Read Only: This attribute provides the revised line the pending component is added to. |
| ItemSequenceNumber | String | A unique number which defines the sequence of components in a structure. |
| Quantity | String | An attribute value the represents the quantity of component item used. |
| Yield | String | 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. |
| Comments | String | An attribute value that represents comments about a component. |
| StartDateTime | Datetime | The date and time on which a component in a structure begins. |
| EndDateTime | Datetime | The date and time on which a component in a structure ends. |
| ImplementationDateTime | Datetime | Read Only: This attributes provides the timestamp when the component was implemented as production row. This attribute can be used to differentiate among pending and production components. For pending components this will be null. |
| 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. |
| 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. |
| PlanningPercent | String | An attribute used by forecast planning that represents the distribution percentage for a component. |
| BasisType | Long | Value that indicates if the option class quantity can be overridden by sales order. Valid values include None (can override) or Option Class (cannot override). |
| 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) |
| EnforceIntRequirements | String | Value that is used by Oracle Supply Planning Cloud to generate the demand in integer quantities. Valid values include Round Up, Round Down, or None. |
| EnforceIntegerRequirementsValue | String | An attribute value used by planning to generate the demand in integer quantities. The values include Round Up, Round Down or None. |
| WipSupplyType | String | Type of supply for components. |
| SupplyType | String | An attribute indicating a supply type for components. |
| AutoRequestMaterialFlag | Bool | A flag that indicates if a move order is automatically created for a material at work order release. |
| MinimumQuantity | String | An attribute that value indicates the minimum quantity allowed on an order. |
| MaximumQuantity | String | An attribute that value indicates the maximum quantity allowed on an order. |
| OptionalFlag | Bool | A flag indicating if component is optional for a structure. |
| MutuallyExclusiveFlag | Bool | A flag indicating if one or more options under this Option Class can be chosen. |
| CheckATPFlag | Bool | A flag indicating to check available to promise and/or capable to promise information when placing demand. |
| SoBasis | String | Value that indicates the basis to override the default quantity for the option class when a sales order is entered (the default), for components of the BOM Item Type option class. The option class quantities affect the mandatory standard components assigned to the option class. |
| 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. |
| InstantiabilityCode | String | Abbreviation that identifies the whether a component item is instantiable in an item structure. |
| InstantiabilityValue | String | A unique identifier indicating whether a component item is instantiable in an item structure. |
| ShowInSales | String | Value that indicates if the component is visible in the sales application. Valid values include Yes, Hide Self, and Hide Self and Descendants. |
| 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. |
| RequiredToShipFlag | Bool | Flag indicating if component is required to ship |
| RequiredForRevenueFlag | Bool | A flag indicating if component is required to recognize revenue before you ship the order. |
| IncludeOnShipDocsFlag | Bool | A flag value that indicates if a component is displayed on shipping documentation. |
| CreationDateTime | Datetime | Who column: An attribute that indicates the date and time of the creation of the component. |
| LastUpdateDateTime | Datetime | Who column: An attribute which indicates the date and time of the last update of the component. |
| BillSequenceId | String | Value that uniquely identifies the structure. |
| PrimaryUOMValue | String | PrimaryUOMValue of ItemStructuresComponent |
| PrimaryUOMCode | String | Primary unit of measure for the item quantities. |
| 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. |
| ACDTypeValue | String | Read Only: This attribute specifies whether the substitute component is being added, modified, or deleted through a change line |
| CreatedBy | String | Who column: An attribute which indicates the user that created the structure |
| LastUpdateLogin | String | Who column: An attribute which indicates the user that logged in last for the structure. |
| LastUpdatedBy | String | Who column: An attribute which indicates the user that last updated the structure. |
| ComponentItemClass | String | The component item's item class. This attribute is read only. |
| QuantityRelatedFlag | Bool | An attribute that indicates whether a component is quantity related or not. If enabled, the application validates whether the specified quantity matches the number of reference designators on the component. |
| Replaces | String | The item number of the component that is being replaced. |
| ReplacedBy | String | The item number of the replacement component. |