Work Definition Operation Material
The Work Definition Operation Material view object contains information about the material consumed at any given work definition operation.
Data Store Key : FscmTopModelAM.ScmExtractAM.WisBiccExtractAM.WDOperationMaterialExtractPVO
Primary Keys : WdOperationMaterialId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| AdhocFlag | Indicates if the work definition operation material is an ad hoc item, which means that the item doesn't come from the associated item structure. |
| AttributeCategory | Context name for the Work Definition Operation Material descriptive flexfield. |
| AttributeChar1 | Character segment for the Work Definition Operation Material descriptive flexfield. |
| AttributeChar10 | Character segment for the Work Definition Operation Material descriptive flexfield. |
| AttributeChar11 | Character segment for the Work Definition Operation Material descriptive flexfield. |
| AttributeChar12 | Character segment for the Work Definition Operation Material descriptive flexfield. |
| AttributeChar13 | Character segment for the Work Definition Operation Material descriptive flexfield. |
| AttributeChar14 | Character segment for the Work Definition Operation Material descriptive flexfield. |
| AttributeChar15 | Character segment for the Work Definition Operation Material descriptive flexfield. |
| AttributeChar16 | Character segment for the Work Definition Operation Material descriptive flexfield. |
| AttributeChar17 | Character segment for the Work Definition Operation Material descriptive flexfield. |
| AttributeChar18 | Character segment for the Work Definition Operation Material descriptive flexfield. |
| AttributeChar19 | Character segment for the Work Definition Operation Material descriptive flexfield. |
| AttributeChar2 | Character segment for the Work Definition Operation Material descriptive flexfield. |
| AttributeChar20 | Character segment for the Work Definition Operation Material descriptive flexfield. |
| AttributeChar3 | Character segment for the Work Definition Operation Material descriptive flexfield. |
| AttributeChar4 | Character segment for the Work Definition Operation Material descriptive flexfield. |
| AttributeChar5 | Character segment for the Work Definition Operation Material descriptive flexfield. |
| AttributeChar6 | Character segment for the Work Definition Operation Material descriptive flexfield. |
| AttributeChar7 | Character segment for the Work Definition Operation Material descriptive flexfield. |
| AttributeChar8 | Character segment for the Work Definition Operation Material descriptive flexfield. |
| AttributeChar9 | Character segment for the Work Definition Operation Material descriptive flexfield. |
| AttributeDate1 | Date segment for the Work Definition Operation Material descriptive flexfield. |
| AttributeDate2 | Date segment for the Work Definition Operation Material descriptive flexfield. |
| AttributeDate3 | Date segment for the Work Definition Operation Material descriptive flexfield. |
| AttributeDate4 | Date segment for the Work Definition Operation Material descriptive flexfield. |
| AttributeDate5 | Date segment for the Work Definition Operation Material descriptive flexfield. |
| AttributeNumber1 | Number segment for the Work Definition Operation Material descriptive flexfield. |
| AttributeNumber10 | Number segment for the Work Definition Operation Material descriptive flexfield. |
| AttributeNumber2 | Number segment for the Work Definition Operation Material descriptive flexfield. |
| AttributeNumber3 | Number segment for the Work Definition Operation Material descriptive flexfield. |
| AttributeNumber4 | Number segment for the Work Definition Operation Material descriptive flexfield. |
| AttributeNumber5 | Number segment for the Work Definition Operation Material descriptive flexfield. |
| AttributeNumber6 | Number segment for the Work Definition Operation Material descriptive flexfield. |
| AttributeNumber7 | Number segment for the Work Definition Operation Material descriptive flexfield. |
| AttributeNumber8 | Number segment for the Work Definition Operation Material descriptive flexfield. |
| AttributeNumber9 | Number segment for the Work Definition Operation Material descriptive flexfield. |
| AttributeTimestamp1 | Date and time segment for the Work Definition Operation Material descriptive flexfield. |
| AttributeTimestamp2 | Date and time segment for the Work Definition Operation Material descriptive flexfield. |
| AttributeTimestamp3 | Date and time segment for the Work Definition Operation Material descriptive flexfield. |
| AttributeTimestamp4 | Date and time segment for the Work Definition Operation Material descriptive flexfield. |
| AttributeTimestamp5 | Date and time segment for the Work Definition Operation Material descriptive flexfield. |
| BasisType | Indicates if the material usage is dependent on quantity of product produced. A list of accepted values is defined in the lookup type EGP_BOM_BASIS_TYPE. |
| ComponentSequenceId | Value that uniquely identifies the item structure component in the Work Definition Operation Material view object. |
| ComponentSequenceIdPath | Value that uniquely identifies this component in the exploded assemble to order model item structure. |
| CreatedBy | User who created the work definition operation material record. |
| CreationDate | Date when the work definition operation material record was created. |
| InventoryItemId | Value that uniquely identifies the material item associated to the work definition operation. |
| InverseMaterialQuantity | Inverse of the material quantity. |
| JobDefinitionName | Indicates the name of the job that created or last updated the row. This is populated through Enterprise Service Scheduler. |
| JobDefinitionPackage | Indicates the package name of the job that created or last updated the row. This is populated through Enterprise Service Scheduler. |
| LastUpdateDate | Date and time when the user last updated the work definition operation material record. |
| LastUpdateLogin | Session login associated with the user who last updated the work definition operation material record. |
| LastUpdatedBy | User who last updated the work definition operation material record. |
| MaterialQuantity | Quantity of material required to perform the operation. |
| MaterialSeqNumber | Unique sequence of the material assigned to the work definition operation. |
| MaterialType | Type of material consumed at the operation. A list of accepted values is defined in the lookup type ORA_WIS_WD_INPUT_MATERIAL. |
| ObjectVersionNumber | 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. |
| OrganizationId | Value that uniquely identifies the manufacturing plant to which this work definition operation material belongs. |
| RequestId | Indicates the request ID of the job that created or last updated the row. This is populated through Enterprise Service Scheduler. |
| SupplyLocatorId | Value that uniquely identifies the locator within the supply subinventory that supplies the material for consumption at the operation. |
| SupplySubinventoryName | Subinventory that supplies the material for consumption at the operation. |
| SupplyType | Supply type used for the work definition operation material. A list of accepted values is defined in the lookup types EGP_WIP_SUP_TYPE and ORA_WIE_WO_SUPPLY_TYPE. |
| UomCode | Code that represents the unit of measure of the material quantity. |
| WdOperationId | Value that uniquely identifies the work definition operation in the Work Definition Operation Material view object. This is a foreign key to the Work Definition Operation view object. |
| WdOperationMaterialId | Value that uniquely identifies the work definition operation material. This is the primary key of the Work Definition Operation Material view object. |
| YieldFactor | Factor used to calculate the quantity of material required at the operation to accommodate material wastage. |