BomComponent
Information about a bill of materials (BOM) components used in supply chain planning.
Label, Plural Label
Component, Components
Qualified Label, Qualified Plural Label
BOM Component, BOM Components
Module
oraScmCorePlanningCommon
Keys
-
$primary: billSequenceId, componentSequenceId, organizationId, planId, newPlanId, simulationSetId (default)
-
altKey: billSequenceId, effectivityDate, findNumber, inventoryItemIdentifier, newPlanId, operationSequenceNumber, organizationId, planId, simulationSetId
Fields
* Field can't be null- applied (int32)
Indicates whether this record is changed for simulation purpose. Valid values are 1, 2 and null.
Label
Changes Applied
- atpIndicator (big-decimal)
Indicates whether a specific component in an Item Structure is considered for Available to Promise . Contains one of the following values: 1 or 2. If 1, then the component is included in Available to Promise calculations. If 2, then the component is excluded from ATP checks. The default value is 2.
Label
Available to Promise
- basisType (big-decimal)
Indicates whether the component item usage is based on the quantity of an item produced or for the entire lot. Valid values are Item or Lot.
Label
Basis
- billSequenceId (int64)*
Unique identifier of the item structure.
Label
Bill Sequence ID
Properties
- searchable
- sortable
- not nullable
- componentSequenceId (int64)*
Unique identifier of the component from the source system.
Label
Component Sequence ID
Properties
- searchable
- sortable
- not nullable
- componentType (big-decimal)
Identifies the type of the component within an item structure as represented in the planning data model. This classification helps the supply planning determine how to process each component during supply and requirements explosions.
Label
Component Type
- componentYieldFactor (big-decimal)
The percentage of the component that was used and then became part of an assembly. For example, 90% indicates that 90% of the total quantity of a component item was used and then became part of the finished assembly.
Label
Component Yield
- contributeToYield (int32)
Indicates whether the component should contribute to the overall yield calculation for the assembly.
Label
Contributes to Yield
- createdBy (string)*
The user who created the record.
Label
Created By
Properties
- not nullable
- defaultOperationSequenceIndicator (big-decimal)
Identifies whether the operation sequence assigned to a component is the primary or default operation for that material. Possible values are 1 for default and 2 or null for nondefault.
Label
Default Operation Sequence
- disableDate (date)
Date when the component item can no longer be used in the manufacturing process
Label
Component Item Effective End Date
- effectivityDate (date)*
Date when the routing operation will be used for the first time.
Label
Operation Effective Start Date
Properties
- not nullable
- findNumber (int64)
The number used to locate a specific instance of an item in a structure. This number enables users to define multiple occurrences of the same component for an assembly in its item structure.
Label
Find Number
- inventoryItemIdentifier (int64)*
Identifier of the component item.
Label
Inventory Item
Properties
- not nullable
- lineOpSeqNumber (big-decimal)
Sequence number of the production line operation.
Label
Production Line Operation Sequence Number
- materialSeqNumber (big-decimal)
Sequence number of a component used in a production line operation.
Label
Item Sequence
- newPlanId (int64)*
Unique identifier of a new plan.
Label
New Plan ID
Properties
- searchable
- sortable
- not nullable
- newPlanList (string)
A list of identifiers for the new plan.
Label
New Plan List
- operationOffsetPercent (big-decimal)
Percentage of the operation offset.
Label
Operation Offset Percentage
- operationSequenceIdentifier (big-decimal)
Identifier of the operation with an assigned routing.
Label
Operation Sequence Identifier
- operationSequenceNumber (int64)
Number of operation sequence in the routing.
Label
Operation Sequence
- optionalComponent (big-decimal)
Indicates whether a component is optional or mandatory in the planning explosion process.
Label
Optional Component
- organizationId (int64)*
Unique identifier of the organization.
Label
Organization ID
Properties
- searchable
- sortable
- not nullable
- planId (int64)*
Unique identifier of the plan for the record.
Label
Plan ID
Properties
- searchable
- sortable
- not nullable
- planningFactor (big-decimal)
The percentage of time a component item or option will be used within a parent model or a product family.
Label
Planning Percentage
- refreshNumber (int64)
Refresh number populated by the collection program.
Label
Refresh Number
- revision (string)
Identifies the specific engineering or inventory revision of a component used in an Item Structure.
Label
Component Item Revision
- roundingDirection (big-decimal)
Indicates how planning should handle rounding for component quantities, especially when calculated requirements result in fractional quantities during BOM explosion. The valid values are: 1 round up, 2 round down and 3 none.
Label
Rounding Method
- simEditFlags (big-decimal)
Indicates which columns are edited in simulation set records.
Label
Simulation Set Edits
- simulationSetId (int64)*
Unique identifier of the simulation set in the application instance.
Label
Simulation Set ID
Properties
- searchable
- sortable
- not nullable
- timeCreated (date-time)*
The date and time when the record was created.
Label
Creation Date
Properties
- sortable
- not nullable
- timeUpdated (date-time)*
The date and time when the record was last updated.
Label
Last Updated Date
Properties
- searchable
- sortable
- not nullable
- uomCode (string)
Identifier of the unit of measure associated with a component item.
Label
Component UOM
- updatedBy (string)*
The user who last updated the record.
Label
Last Updated By
Properties
- not nullable
- usageQuantity (big-decimal)
Quantity of a component item used.
Label
Usage Quantity
- usingAssemblyIdentifier (int64)
Identifier of the finished good item.
Label
Assembly
- wipSupplyType (big-decimal)
The supply type of the item which is in work-in-process.
Label
WIP Supply Type
- workDefinitionUsageQuantity (big-decimal)
Quantity of component required to build one unit of item.
Label
Work Definition Usage Quantity
Business Views
** Available for extracting data- default
Data Source
RDBMS
Fields
- billSequenceId (int64)
Unique identifier of the item structure.
Label
Bill Sequence ID
Properties
- searchable
- sortable
- not nullable
- componentSequenceId (int64)
Unique identifier of the component from the source system.
Label
Component Sequence ID
Properties
- searchable
- sortable
- not nullable
- effectivityDate (date)
Date when the routing operation will be used for the first time.
Label
Operation Effective Start Date
Properties
- not nullable
- findNumber (int64)
The number used to locate a specific instance of an item in a structure. This number enables users to define multiple occurrences of the same component for an assembly in its item structure.
Label
Find Number
- inventoryItemIdentifier (int64)
Identifier of the component item.
Label
Inventory Item
Properties
- not nullable
- newPlanId (int64)
Unique identifier of a new plan.
Label
New Plan ID
Properties
- searchable
- sortable
- not nullable
- operationSequenceNumber (int64)
Number of operation sequence in the routing.
Label
Operation Sequence
- organizationId (int64)
Unique identifier of the organization.
Label
Organization ID
Properties
- searchable
- sortable
- not nullable
- planId (int64)
Unique identifier of the plan for the record.
Label
Plan ID
Properties
- searchable
- sortable
- not nullable
- simulationSetId (int64)
Unique identifier of the simulation set in the application instance.
Label
Simulation Set ID
Properties
- searchable
- sortable
- not nullable
- billSequenceId (int64)
Other Properties
| Property | Value |
|---|---|
| Application Package Name | ora_scm_core_planning_common |
| Extensible | No |