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. |