Work Order Operation Material
The Work Order Operation Material view object contains information about the material requirements of an operation in a work order.
Data Store Key : FscmTopModelAM.ScmExtractAM.WieBiccExtractAM.WOOperationMaterialExtractPVO
Primary Keys : WOOpMaterialsPEOWoOperationMaterialId
Initial Extract Date : WOOpMaterialsPEOCreationDate
Incremental Extract Date : WOOpMaterialsPEOLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| WOOpMaterialsPEOAllocatedQuantity | The total allocated quantity displayed as part of component pick processing. The value is incremented for the pick release quantity and adjusted for the quantity that's pick confirmed from inventory. |
| WOOpMaterialsPEOAttributeCategory | Context name for the Work Order Operation Material descriptive flexfield. |
| WOOpMaterialsPEOAttributeChar1 | Character segment for the Work Order Operation Material descriptive flexfield. |
| WOOpMaterialsPEOAttributeChar10 | Character segment for the Work Order Operation Material descriptive flexfield. |
| WOOpMaterialsPEOAttributeChar11 | Character segment for the Work Order Operation Material descriptive flexfield. |
| WOOpMaterialsPEOAttributeChar12 | Character segment for the Work Order Operation Material descriptive flexfield. |
| WOOpMaterialsPEOAttributeChar13 | Character segment for the Work Order Operation Material descriptive flexfield. |
| WOOpMaterialsPEOAttributeChar14 | Character segment for the Work Order Operation Material descriptive flexfield. |
| WOOpMaterialsPEOAttributeChar15 | Character segment for the Work Order Operation Material descriptive flexfield. |
| WOOpMaterialsPEOAttributeChar16 | Character segment for the Work Order Operation Material descriptive flexfield. |
| WOOpMaterialsPEOAttributeChar17 | Character segment for the Work Order Operation Material descriptive flexfield. |
| WOOpMaterialsPEOAttributeChar18 | Character segment for the Work Order Operation Material descriptive flexfield. |
| WOOpMaterialsPEOAttributeChar19 | Character segment for the Work Order Operation Material descriptive flexfield. |
| WOOpMaterialsPEOAttributeChar2 | Character segment for the Work Order Operation Material descriptive flexfield. |
| WOOpMaterialsPEOAttributeChar20 | Character segment for the Work Order Operation Material descriptive flexfield. |
| WOOpMaterialsPEOAttributeChar3 | Character segment for the Work Order Operation Material descriptive flexfield. |
| WOOpMaterialsPEOAttributeChar4 | Character segment for the Work Order Operation Material descriptive flexfield. |
| WOOpMaterialsPEOAttributeChar5 | Character segment for the Work Order Operation Material descriptive flexfield. |
| WOOpMaterialsPEOAttributeChar6 | Character segment for the Work Order Operation Material descriptive flexfield. |
| WOOpMaterialsPEOAttributeChar7 | Character segment for the Work Order Operation Material descriptive flexfield. |
| WOOpMaterialsPEOAttributeChar8 | Character segment for the Work Order Operation Material descriptive flexfield. |
| WOOpMaterialsPEOAttributeChar9 | Character segment for the Work Order Operation Material descriptive flexfield. |
| WOOpMaterialsPEOAttributeDate1 | Date segment for the Work Order Operation Material descriptive flexfield. |
| WOOpMaterialsPEOAttributeDate2 | Date segment for the Work Order Operation Material descriptive flexfield. |
| WOOpMaterialsPEOAttributeDate3 | Date segment for the Work Order Operation Material descriptive flexfield. |
| WOOpMaterialsPEOAttributeDate4 | Date segment for the Work Order Operation Material descriptive flexfield. |
| WOOpMaterialsPEOAttributeDate5 | Date segment for the Work Order Operation Material descriptive flexfield. |
| WOOpMaterialsPEOAttributeNumber1 | Number segment for the Work Order Operation Material descriptive flexfield. |
| WOOpMaterialsPEOAttributeNumber10 | Number segment for the Work Order Operation Material descriptive flexfield. |
| WOOpMaterialsPEOAttributeNumber2 | Number segment for the Work Order Operation Material descriptive flexfield. |
| WOOpMaterialsPEOAttributeNumber3 | Number segment for the Work Order Operation Material descriptive flexfield. |
| WOOpMaterialsPEOAttributeNumber4 | Number segment for the Work Order Operation Material descriptive flexfield. |
| WOOpMaterialsPEOAttributeNumber5 | Number segment for the Work Order Operation Material descriptive flexfield. |
| WOOpMaterialsPEOAttributeNumber6 | Number segment for the Work Order Operation Material descriptive flexfield. |
| WOOpMaterialsPEOAttributeNumber7 | Number segment for the Work Order Operation Material descriptive flexfield. |
| WOOpMaterialsPEOAttributeNumber8 | Number segment for the Work Order Operation Material descriptive flexfield. |
| WOOpMaterialsPEOAttributeNumber9 | Number segment for the Work Order Operation Material descriptive flexfield. |
| WOOpMaterialsPEOAttributeTimestamp1 | Date and Time segment for the Work Order Operation Material descriptive flexfield. |
| WOOpMaterialsPEOAttributeTimestamp2 | Date and Time segment for the Work Order Operation Material descriptive flexfield. |
| WOOpMaterialsPEOAttributeTimestamp3 | Date and Time segment for the Work Order Operation Material descriptive flexfield. |
| WOOpMaterialsPEOAttributeTimestamp4 | Date and Time segment for the Work Order Operation Material descriptive flexfield. |
| WOOpMaterialsPEOAttributeTimestamp5 | Date and Time segment for the Work Order Operation Material descriptive flexfield. |
| WOOpMaterialsPEOBasisType | Indicates whether the material quantity is dependent on quantity of product produced. A list of accepted values is defined in the lookup type EGP_BOM_BASIS_TYPE. |
| WOOpMaterialsPEOCreatedBy | User who created the work order operation material record. |
| WOOpMaterialsPEOCreationDate | Date and time when the user created the work order operation material record. |
| WOOpMaterialsPEOIncludeInPlanningFlag | Indicates whether this material requirement should be seen by the planning process. |
| WOOpMaterialsPEOInventoryItemId | Value that uniquely identifies the material item in the work order operation materials. |
| WOOpMaterialsPEOInverseQuantity | Inverse of the component quantity. |
| WOOpMaterialsPEOIssuedQuantity | Net quantity of the material issued to the operation. |
| WOOpMaterialsPEOItemRevision | Revision of the item. |
| WOOpMaterialsPEOJobDefinitionName | Indicates the name of the job that created or last updated the row. This is populated through Enterprise Service Scheduler. |
| WOOpMaterialsPEOJobDefinitionPackage | Indicates the package name of the job that created or last updated the row. This is populated through Enterprise Service Scheduler. |
| WOOpMaterialsPEOLastUpdateDate | Date and time when the user last updated the work order operation material record. |
| WOOpMaterialsPEOLastUpdateLogin | Session login associated with the user who last updated the work order operation material record. |
| WOOpMaterialsPEOLastUpdatedBy | User who last updated the work order operation material record. |
| WOOpMaterialsPEOMaterialSeqNumber | Unique sequence of the component assigned to the work order operation. |
| WOOpMaterialsPEOMaterialType | Type of material either produced or consumed by the operation. For materials being consumed, the list of accepted values is defined in the lookup type ORA_WIS_WD_INPUT_MATERIAL. For materials being produced, the list of accepted values is defined in the lookup type ORA_WIS_WD_OUTPUT_MATERIAL. |
| WOOpMaterialsPEOObjectVersionNumber | Number of times the object row was updated. This attribute is used to implement optimistic locking. This number is incremented every time the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
| WOOpMaterialsPEOOrganizationId | Value that uniquely identifies the manufacturing plant to which this work order operation material belongs. |
| WOOpMaterialsPEOPickedQuantity | The actual pick confirmed quantity which gets updated when inventory does pick confirm for move orders. |
| WOOpMaterialsPEOProducedQuantity | Quantity of the assembly item that's completed into inventory. The material type for this material is PRIMARY_PRODUCT. |
| WOOpMaterialsPEOQuantity | Quantity of the material required to perform the operation of the work order. |
| WOOpMaterialsPEOQuantityPerProduct | Quantity of the material required to manufacture each unit of the product in discrete manufacturing. |
| WOOpMaterialsPEORemainingAllocatedQuantity | The total remaining allocated quantity maintained as part of component pick processing. The value represents the total allocated quantity minus the quantity issued to the work order post allocation. |
| WOOpMaterialsPEORequestId | Indicates the request ID of the job that created or last updated the row. This is populated through Enterprise Service Scheduler. |
| WOOpMaterialsPEORequiredDate | Date when the material is required in the operation. |
| WOOpMaterialsPEOSubstituteFlag | Value that indicates that the component is a substitute. |
| WOOpMaterialsPEOSubstitutePriorityRanking | Value that identifies the order of preference for a substitute material. |
| WOOpMaterialsPEOSupplyLocatorId | Value that uniquely identifies the locator within the supply subinventory that supplies the material for consumption at the operation. |
| WOOpMaterialsPEOSupplySubinventory | The subinventory that supplies material to the operation. |
| WOOpMaterialsPEOSupplyType | Reference of the supply type used for the work order operation material. A list of accepted values is defined in the lookup types EGP_WIP_SUP_TYPE and ORA_WIE_WO_SUPPLY_TYPE. |
| WOOpMaterialsPEOTiaRefEntity | Column that specifies whether the transaction item attribute reference identifier is from CTO Match Lines or OM Order Lines. |
| WOOpMaterialsPEOTiaRefLineId | The transaction item attribute reference identifier. The identifier could be either the value of the CTO match Lines or OM Order Lines. The differentiator will be persisted in the transaction item attribute reference entity. |
| WOOpMaterialsPEOUomCode | Represents the unit of measure code of the specified quantity. |
| WOOpMaterialsPEOWdOperationMaterialId | Value that uniquely identifies the work definition operation material in the Work Order Operation Material view object. This is the foreign key to the Work Definition Operation Material view object. |
| WOOpMaterialsPEOWoOperationId | Value that uniquely identifies the work order operation in the Work Order Operation Material view object. This is the foreign key to the Work Order Operation view object. |
| WOOpMaterialsPEOWoOperationMaterialId | Value that uniquely identifies the work order operation material. This is the primary key of the Work Order Operation Material view object. |
| WOOpMaterialsPEOWorkOrderId | Value that uniquely identifies the work order in the Work Order Operation Material view object. This is the foreign key to the Work Order view object. |
| WOOpMaterialsPEOYieldFactor | Factor to use when calculating the quantity that the operation requires to accommodate component wastage when it processes the item. |