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.