Structure Components

The Structure Components view object provides information about the bill of material components within a structure. This view object manages information of only single-level components. The structure components view object is the main child of the structures view object. This view object also contains certain attributes related to shipping, billing, and accounting for revenue on a customer order through Oracle Order Management.

Data Store Key : FscmTopModelAM.ScmExtractAM.EgpBiccExtractAM.ComponentsExtractPVO

Primary Keys : ComponentPEOComponentSequenceId

Initial Extract Date :

Incremental Extract Date :

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
ComponentPEOAcdType	Value indicates whether the component is being added, modified, or deleted through a change order. A list of accepted values is defined in the lookup EGP_ACD_TYPE.
ComponentPEOAttribute1	Segment for the Components descriptive flexfield.
ComponentPEOAttribute10	Segment for the Components descriptive flexfield.
ComponentPEOAttribute11	Segment for the Components descriptive flexfield.
ComponentPEOAttribute12	Segment for the Components descriptive flexfield.
ComponentPEOAttribute13	Segment for the Components descriptive flexfield.
ComponentPEOAttribute14	Segment for the Components descriptive flexfield.
ComponentPEOAttribute15	Segment for the Components descriptive flexfield.
ComponentPEOAttribute16	Segment for the Components descriptive flexfield.
ComponentPEOAttribute17	Segment for the Components descriptive flexfield.
ComponentPEOAttribute18	Segment for the Components descriptive flexfield.
ComponentPEOAttribute19	Segment for the Components descriptive flexfield.
ComponentPEOAttribute2	Segment for the Components descriptive flexfield.
ComponentPEOAttribute20	Segment for the Components descriptive flexfield.
ComponentPEOAttribute21	Segment for the Components descriptive flexfield.
ComponentPEOAttribute22	Segment for the Components descriptive flexfield.
ComponentPEOAttribute23	Segment for the Components descriptive flexfield.
ComponentPEOAttribute24	Segment for the Components descriptive flexfield.
ComponentPEOAttribute25	Segment for the Components descriptive flexfield.
ComponentPEOAttribute26	Segment for the Components descriptive flexfield.
ComponentPEOAttribute27	Segment for the Components descriptive flexfield.
ComponentPEOAttribute28	Segment for the Components descriptive flexfield.
ComponentPEOAttribute29	Segment for the Components descriptive flexfield.
ComponentPEOAttribute3	Segment for the Components descriptive flexfield.
ComponentPEOAttribute30	Segment for the Components descriptive flexfield.
ComponentPEOAttribute4	Segment for the Components descriptive flexfield.
ComponentPEOAttribute5	Segment for the Components descriptive flexfield.
ComponentPEOAttribute6	Segment for the Components descriptive flexfield.
ComponentPEOAttribute7	Segment for the Components descriptive flexfield.
ComponentPEOAttribute8	Segment for the Components descriptive flexfield.
ComponentPEOAttribute9	Segment for the Components descriptive flexfield.
ComponentPEOAttributeCategory	Context name for the Components Type descriptive flexfield.
ComponentPEOAttributeDate1	Date segment for the Components descriptive flexfield.
ComponentPEOAttributeDate2	Date segment for the Components descriptive flexfield.
ComponentPEOAttributeDate3	Date segment for the Components descriptive flexfield.
ComponentPEOAttributeDate4	Date segment for the Components descriptive flexfield.
ComponentPEOAttributeDate5	Date segment for the Components descriptive flexfield.
ComponentPEOAttributeNumber1	Number segment for the Components descriptive flexfield.
ComponentPEOAttributeNumber10	Number segment for the Components descriptive flexfield.
ComponentPEOAttributeNumber2	Number segment for the Components descriptive flexfield.
ComponentPEOAttributeNumber3	Number segment for the Components descriptive flexfield.
ComponentPEOAttributeNumber4	Number segment for the Components descriptive flexfield.
ComponentPEOAttributeNumber5	Number segment for the Components descriptive flexfield.
ComponentPEOAttributeNumber6	Number segment for the Components descriptive flexfield.
ComponentPEOAttributeNumber7	Number segment for the Components descriptive flexfield.
ComponentPEOAttributeNumber8	Number segment for the Components descriptive flexfield.
ComponentPEOAttributeNumber9	Number segment for the Components descriptive flexfield.
ComponentPEOAttributeTimestamp1	Date and time segment for the Components descriptive flexfield.
ComponentPEOAttributeTimestamp2	Date and time segment for the Components descriptive flexfield.
ComponentPEOAttributeTimestamp3	Date and time segment for the Components descriptive flexfield.
ComponentPEOAttributeTimestamp4	Date and time segment for the Components descriptive flexfield.
ComponentPEOAttributeTimestamp5	Date and time segment for the Components descriptive flexfield.
ComponentPEOAutoRequestMaterial	The AutoRequestMaterial indicates if a move order is automatically created for a material at work order release. A list of accepted values is defined in the lookup type EGP_YES_NO.
ComponentPEOBasisType	The basis type identifies component usage as fixed or variable. A list of accepted values is defined in the lookup type EGP_BOM_BASIS_TYPE. If the component quantity required is to increase or decrease linearly along with the changes to the work order or job quantity, then the user selects Variable. If the component quantity required remains the same regardless of the work order or job quantity, then the user selects Fixed.
ComponentPEOBillSequenceId	Value that uniquely identifies the bill of material. This is the foreign key to the Structure view object. This attribute is read-only, and can be modified only if the resource is already modified.
ComponentPEOBomItemType	Type of component in a bill of material that can be associated with the item. A list of accepted values is defined in the lookup type EGP_BOM_ITEM_TYPE.
ComponentPEOChangeId	Value that indicates the change order number associated with the component.
ComponentPEOChangeLineId	Value that uniquely identifies the revised change line to which the pending component is added. This is the foreign key to the Change Lines view object.
ComponentPEOCheckAtp	Value that determines whether to check the available to promise and capable to promise information when placing a demand. A list of accepted values is defined in the lookup type EGP_COMMON_YES_NO_NUM.
ComponentPEOCommonComponentSequenceId	Value that identifies the common bill of material.
ComponentPEOComponentItemRevisionId	Value that uniquely identifies the revision of the item component.
ComponentPEOComponentQuantity	Value that represents the quantity of the component in the bill of material.
ComponentPEOComponentRemarks	Comments or remarks about the component in the bill of material.
ComponentPEOComponentSequenceId	Value that uniquely identifies the component in a structure. This is a primary key of the Component Extract view object. This attribute is read-only and isn't required for an update operation.
ComponentPEOComponentYieldFactor	Value that indicates a loss, an increase, or no change in the planned or actual output quantity. If yield value is 0.5, then 50% of the quantity of a component is included in the finished process. The default value is 1, which equates to no gain or loss.
ComponentPEOCreatedBy	User who created the component.
ComponentPEOCreationDate	Date and time when the component was created.
ComponentPEODeleteGroupName	Delete Group name for the entity type you're deleting.
ComponentPEODgDescription	Description of the Delete Group.
ComponentPEODisableDate	Value that indicates the last effective date of the component. After this date, the component will no longer be effective.
ComponentPEOEffectivityDate	Value that indicates the effective start date of the component.
ComponentPEOEnforceIntRequirements	Value that's used by Planning to generate the demand in integer quantities. A list of accepted values is defined in the lookup type EGP_SUB_COMP_ENFORCE_INT_REQ.
ComponentPEOFromEndItemRevId	Value that uniquely identifies the starting revision of the parent item or root item.
ComponentPEOFromEndItemUnitNumber	Number that indicates the item unit or serial from which the component is effective. It's valid only for unit or serial effective structures. Whether the value is unit or serial number depends on when the component is effective.
ComponentPEOHighQuantity	Value that indicates the maximum quantity allowed on an order.
ComponentPEOImplementationDate	Date and time when the component was implemented in production. It displays NULL for pending components. You can use this value to differentiate between pending and production components.
ComponentPEOIncludeOnBillDocs	Indicates whether the component should be included in billing documentation, such as invoices. A list of accepted values is defined in the lookup type EGP_COMMON_YES_NO_NUM.
ComponentPEOIncludeOnShipDocs	Indicates whether the component is displayed on shipping documents. A list of accepted values is defined from the lookup type EGP_COMMON_YES_NO_NUM.
ComponentPEOInstantiabilityCode	Code that identifies whether a component item is instantiable in a model item structure. Value in this attribute defines the number of instances that can be created of a model reference during a runtime configuration session. A list of accepted values is defined in the lookup type EGP_COMP_INSTANTIABILITY.
ComponentPEOItemNum	Indicates the sequence of the item on an item structure. It's used to sort components when presenting item structure details.
ComponentPEOLastUpdateDate	Date and time when the component was last updated.
ComponentPEOLastUpdateLogin	Session login associated with the user who last updated the component.
ComponentPEOLastUpdatedBy	User who last updated the component row.
ComponentPEOLowQuantity	Value that indicates the minimum quantity allowed on an order.
ComponentPEOMutuallyExclusiveOptions	Value that indicates whether one or more options under this option class can be picked when taking an order. A list of accepted values is defined in the lookup type EGP_COMMON_YES_NO_NUM.
ComponentPEOObjName	Value that identifies the name of the object. A possible value is EGO_ITEM.
ComponentPEOObjectVersionNumber	Number of times the component row has been updated.
ComponentPEOOldComponentSequenceId	Value of the identifier that refers to the original component row when this component has been affected or redlined through a change order.
ComponentPEOOperationLeadTimePercent	Operation offset from first operation in routing.
ComponentPEOOperationSeqNum	Unique value that represents the Routing Operation Sequence used for the component. The routing operation sequence is the order in which operations must be performed on a routing.
ComponentPEOOptional	Value that indicates whether the component is optional in a structure. A list of accepted values is defined in the lookup type EGP_COMMON_YES_NO_NUM.
ComponentPEOOriginalSystemReference	Value that identifies the application from where the data has originated for managing the record.
ComponentPEOParentBillSeqId	Value that identifies the common bill sequence identification of the model bill.
ComponentPEOPickComponents	Value that indicates whether an item has a structure with options, classes, or included items picked from a finished goods inventory. A list of accepted values is defined in the lookup type EGP_COMMON_YES_NO_NUM.
ComponentPEOPk1Value	Value that identifies the inventory item of the component. This is the foreign key to the Item view object.
ComponentPEOPk2Value	Value that uniquely identifies the organization. This is the foreign key to the Inventory Organizations view object.
ComponentPEOPlanningFactor	Factor used to multiply component quantity to obtain planning quantity. This is used in material requirement planning.
ComponentPEOPrimaryUomCode	Code that indicates the unit of measure for a component in the bill of materials. This may be different from the unit of measure for the item. For example, wooden panels used in the making of a table. The unit of measure for the wooden panel can be Box. However, when used as the component of a table, the unit of measurement can be Each.
ComponentPEOProgramAppName	Value that identifies the process which created this component.
ComponentPEOProgramName	The name of the process that created or edited this component.
ComponentPEOQuantityRelated	Value that indicates whether this component has quantity-related reference designators. A list of accepted values is defined in the lookup type EGP_COMMON_YES_NO_NUM.
ComponentPEORequestId	Value that identifies the process ID of the job that created or last updated the row.
ComponentPEORequiredForRevenue	Value that indicates whether the component is required to recognize revenue before you ship the order. A list of accepted values is defined in the lookup type EGP_COMMON_YES_NO_NUM.
ComponentPEORequiredToShip	Value that indicates whether the component is required to ship. A list of accepted values is defined in the lookup type EGP_COMMON_YES_NO_NUM.
ComponentPEOShippingAllowed	Value that indicates whether the component is allowed to ship component shipping details. A list of accepted values is defined in the lookup type EGP_COMMON_YES_NO_NUM.
ComponentPEOShowInSales	Value that indicates whether the component is visible in the sales application. A list of accepted values is defined in the lookup type EGP_STR_SHOWINSALES. The lookup codes and values are: 1 - Yes, 2 - Hide Self, and 3 - Hide Self and Descendants.
ComponentPEOSoBasis	Value that determines whether to override the default quantity when a sales order is entered for components belonging to BOM Item Type option class. Option class quantities affect the mandatory standard components assigned to the option class. A list of acceptable values are defined in EGP_BOM_BASIS_TYPE. The lookup code and values are: 1 - Variable, and 2 - Fixed.
ComponentPEOSuggestedOperationSeqNum	The sequence number suggested by a design engineer for a specific component operation in a manufacturing work definition. Example values are 10, 20, 30, and so on.
ComponentPEOSuggestedVendorName	Suggested supplier name for the direct items in bills of materials for asset management.
ComponentPEOSupplyLocatorId	Value that uniquely identifies the location within the subinventory where goods are stored.
ComponentPEOSupplySubinventory	Value that uniquely identifies the subinventory where the component is stored.
ComponentPEOToEndItemRevId	Value that uniquely identifies the ending revision of the parent item or root item.
ComponentPEOToEndItemUnitNumber	Number that identifies the item unit or serial up to which the component is effective. It's valid only for unit or serial effective structures. Whether the value is unit or serial number depends on when the component is effective.
ComponentPEOUnitPrice	Unit price for direct items used in bills of materials for asset management.
ComponentPEOUsePlaceholder	An attribute that determines whether option class item data should be loaded into configurator models or not. If set to Yes, a placeholder is used for the item data, and actual item data is loaded only when required.
ComponentPEOVendorId	Value that uniquely identifies the suggested supplier.
ComponentPEOWipSupplyType	Value that indicates the supply types for the components. Supply types control how components are supplied in Work in Process. A list of accepted values is defined in the lookup EGP_WIP_SUP_TYPE. Contains the following lookup code and lookup values: 1 - Push, 2 - Assembly pull, 3 - Operation pull, 4 - Bulk, 5 - Supplier, and 6 - Phantom.