Substitute Components
The Substitute Components view object provides information about the substitute components associated with an item component in the bill of materials. It stores substitute components of current components as well as components that are pending on engineering change orders.
Data Store Key : FscmTopModelAM.ScmExtractAM.EgpBiccExtractAM.SubstituteComponentsExtractPVO
Primary Keys : SubstituteComponentsPEOSubCompSequenceId
Initial Extract Date :
Incremental Extract Date :
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| SubstituteComponentsPEOAcdType | Value that indicates if the substitute component is being added, modified, or deleted through a change order. A list of values are defined in the EGP_ACD_TYPE lookup code. The lookup values are as follows: 1: Added, 2: Updated, 3: Disabled, 4: Deleted, 5: Copied. |
| SubstituteComponentsPEOAttribute1 | Segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttribute10 | Segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttribute11 | Segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttribute12 | Segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttribute13 | Segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttribute14 | Segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttribute15 | Segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttribute16 | Segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttribute17 | Segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttribute18 | Segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttribute19 | Segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttribute2 | Segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttribute20 | Segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttribute21 | Segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttribute22 | Segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttribute23 | Segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttribute24 | Segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttribute25 | Segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttribute26 | Segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttribute27 | Segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttribute28 | Segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttribute29 | Segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttribute3 | Segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttribute30 | Segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttribute4 | Segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttribute5 | Segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttribute6 | Segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttribute7 | Segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttribute8 | Segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttribute9 | Segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttributeCategory | Context name for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttributeDate1 | Date segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttributeDate2 | Date segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttributeDate3 | Date segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttributeDate4 | Date segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttributeDate5 | Date segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttributeNumber1 | Number segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttributeNumber10 | Number segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttributeNumber2 | Number segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttributeNumber3 | Number segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttributeNumber4 | Number segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttributeNumber5 | Number segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttributeNumber6 | Number segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttributeNumber7 | Number segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttributeNumber8 | Number segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttributeNumber9 | Number segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttributeTimestamp1 | Date and time segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttributeTimestamp2 | Date and time segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttributeTimestamp3 | Date and time segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttributeTimestamp4 | Date and time segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOAttributeTimestamp5 | Date and time segment for the Substitute Component descriptive flexfield. |
| SubstituteComponentsPEOChangeLineId | Value that uniquely identifies the change line corresponding to the substitute component. This is the foreign key to the Change Lines view object. |
| SubstituteComponentsPEOChangeNotice | Change order number corresponding to the substitute component. |
| SubstituteComponentsPEOCommonComponentSequenceId | Value that uniquely identifies the substitute component of the common bill of material. |
| SubstituteComponentsPEOComponentSequenceId | Value that uniquely identifies the component in a structure. This is a foreign key to the Components view object. |
| SubstituteComponentsPEOCreatedBy | User who created the substitute component. |
| SubstituteComponentsPEOCreationDate | Date and time when the substitute component was created. |
| SubstituteComponentsPEOEnforceIntRequirements | Value that's used by Planning to generate the demand in integer quantities. A list of values is defined in the lookup code EGP_SUB_COMP_ENFORCE_INT_REQ. The lookup values are: 0: None, 1: Round down, 2: Round up. |
| SubstituteComponentsPEOJobDefinitionName | Value that indicates the name of the import job that created or updated the row. A possible value is ItemImportJobDef. |
| SubstituteComponentsPEOLastUpdateDate | Date and time when the substitute component was last updated. |
| SubstituteComponentsPEOLastUpdateLogin | Session login associated with the user who last updated the substitute component. |
| SubstituteComponentsPEOLastUpdatedBy | User who last updated the substitute component row. |
| SubstituteComponentsPEOObjectVersionNumber | Number of times the substitute component row has been updated. |
| SubstituteComponentsPEOOriginalSystemReference | Value that indicates the original system from where the data was sourced. For example, the name of the spoke system from where the data originated. |
| SubstituteComponentsPEOProgramAppName | Value that identifies the process which created this substitute component. |
| SubstituteComponentsPEOProgramName | The name of the process that created or edited this substitute component. |
| SubstituteComponentsPEORequestId | Value that uniquely identifies the process request that created or last updated the row. |
| SubstituteComponentsPEOSubCompSequenceId | Value that uniquely identifies the substitute component. This is the primary key of the Substitute Components view object. |
| SubstituteComponentsPEOSubstituteComponentId | Value that uniquely identifies the substitute component inventory item. |
| SubstituteComponentsPEOSubstituteItemQuantity | Value that indicates the substitute component quantity required to replace the component quantity. |
| SubstituteComponentsPEOVersionId | Value that uniquely identifies the version of a change line or affected item. A value other than -1 indicates this row is pending or released through a change order. This is the foreign key to the Versions Extract view object. This attribute isn't currently in use. |