Work Definition Operation Substitute Material
The Work Definition Operation Substitute Material view object contains information about substitute materials defined for any given work definition operation material.
Data Store Key : FscmTopModelAM.ScmExtractAM.WisBiccExtractAM.WDOperationSubstituteMaterialExtractPVO
Primary Keys : WdOpSubMaterialId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| AttributeCategory | Context name for the Work Definition Operation Substitute Material descriptive flexfield. |
| AttributeChar1 | Character segment for the Work Definition Operation Substitute Material descriptive flexfield. |
| AttributeChar10 | Character segment for the Work Definition Operation Substitute Material descriptive flexfield. |
| AttributeChar11 | Character segment for the Work Definition Operation Substitute Material descriptive flexfield. |
| AttributeChar12 | Character segment for the Work Definition Operation Substitute Material descriptive flexfield. |
| AttributeChar13 | Character segment for the Work Definition Operation Substitute Material descriptive flexfield. |
| AttributeChar14 | Character segment for the Work Definition Operation Substitute Material descriptive flexfield. |
| AttributeChar15 | Character segment for the Work Definition Operation Substitute Material descriptive flexfield. |
| AttributeChar16 | Character segment for the Work Definition Operation Substitute Material descriptive flexfield. |
| AttributeChar17 | Character segment for the Work Definition Operation Substitute Material descriptive flexfield. |
| AttributeChar18 | Character segment for the Work Definition Operation Substitute Material descriptive flexfield. |
| AttributeChar19 | Character segment for the Work Definition Operation Substitute Material descriptive flexfield. |
| AttributeChar2 | Character segment for the Work Definition Operation Substitute Material descriptive flexfield. |
| AttributeChar20 | Character segment for the Work Definition Operation Substitute Material descriptive flexfield. |
| AttributeChar3 | Character segment for the Work Definition Operation Substitute Material descriptive flexfield. |
| AttributeChar4 | Character segment for the Work Definition Operation Substitute Material descriptive flexfield. |
| AttributeChar5 | Character segment for the Work Definition Operation Substitute Material descriptive flexfield. |
| AttributeChar6 | Character segment for the Work Definition Operation Substitute Material descriptive flexfield. |
| AttributeChar7 | Character segment for the Work Definition Operation Substitute Material descriptive flexfield. |
| AttributeChar8 | Character segment for the Work Definition Operation Substitute Material descriptive flexfield. |
| AttributeChar9 | Character segment for the Work Definition Operation Substitute Material descriptive flexfield. |
| AttributeDate1 | Date segment for the Work Definition Operation Substitute Material descriptive flexfield. |
| AttributeDate2 | Date segment for the Work Definition Operation Substitute Material descriptive flexfield. |
| AttributeDate3 | Date segment for the Work Definition Operation Substitute Material descriptive flexfield. |
| AttributeDate4 | Date segment for the Work Definition Operation Substitute Material descriptive flexfield. |
| AttributeDate5 | Date segment for the Work Definition Operation Substitute Material descriptive flexfield. |
| AttributeNumber1 | Number segment for the Work Definition Operation Substitute Material descriptive flexfield. |
| AttributeNumber10 | Number segment for the Work Definition Operation Substitute Material descriptive flexfield. |
| AttributeNumber2 | Number segment for the Work Definition Operation Substitute Material descriptive flexfield. |
| AttributeNumber3 | Number segment for the Work Definition Operation Substitute Material descriptive flexfield. |
| AttributeNumber4 | Number segment for the Work Definition Operation Substitute Material descriptive flexfield. |
| AttributeNumber5 | Number segment for the Work Definition Operation Substitute Material descriptive flexfield. |
| AttributeNumber6 | Number segment for the Work Definition Operation Substitute Material descriptive flexfield. |
| AttributeNumber7 | Number segment for the Work Definition Operation Substitute Material descriptive flexfield. |
| AttributeNumber8 | Number segment for the Work Definition Operation Substitute Material descriptive flexfield. |
| AttributeNumber9 | Number segment for the Work Definition Operation Substitute Material descriptive flexfield. |
| AttributeTimestamp1 | Date and time segment for the Work Definition Operation Substitute Material descriptive flexfield. |
| AttributeTimestamp2 | Date and time segment for the Work Definition Operation Substitute Material descriptive flexfield. |
| AttributeTimestamp3 | Date and time segment for the Work Definition Operation Substitute Material descriptive flexfield. |
| AttributeTimestamp4 | Date and time segment for the Work Definition Operation Substitute Material descriptive flexfield. |
| AttributeTimestamp5 | Date and time segment for the Work Definition Operation Substitute Material descriptive flexfield. |
| ComponentSequenceId | Value that uniquely identifies the item structure component in the Work Definition Operation Substitute Material view object. |
| CreatedBy | User who created the work definition operation substitute material record. |
| CreationDate | Date when the work definition operation substitute material record was created. |
| 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 substitute material record. |
| LastUpdateLogin | Session login associated with the user who last updated the work definition operation substitute material record. |
| LastUpdatedBy | User who last updated the work definition operation substitute material record. |
| 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. |
| PriorityRanking | Indicates the order of preference of the substitute material. Planning uses this information to choose the appropriate substitute material. |
| RequestId | Indicates the request ID of the job that created or last updated the row. This is populated through Enterprise Service Scheduler. |
| SubstituteComponentId | Value that uniquely identifies the substitute material item. |
| SubstituteInverseQuantity | Inverse of the substitute material quantity. |
| SubstituteItemQuantity | Quantity of substitute material required to perform the operation. |
| WdOpSubMaterialId | Value that uniquely identifies the work definition operation substitute material. This is the primary key of the Work Definition Operation Substitute Material view object. |
| WdOperationMaterialId | Value that uniquely identifies the work definition operation material in the Work Definition Operation Substitute Material view object. This is the foreign key to the Work Definition Operation Material view object. |