Excel Add-In for Oracle Fusion Cloud SCM

Build 24.0.9175

WorkOrdersWorkOrderAssemblyComponent

Manages assemblies issued as components to work orders, supporting rework and component tracking.

Columns

Name Type Description
WorkOrdersWorkOrderId [KEY] Long The unique identifier linking the assembly component to its associated work order. This identifier ensures all component details are correctly mapped to the relevant work order for traceability.
OrganizationId Long The unique identifier for the inventory organization enabled for manufacturing. This identifier links the assembly component to the correct organization, ensuring proper segmentation in multi-organization setups.
WorkOrderId Long The unique identifier for the reworked work order. This identifier serves as the primary reference for managing and tracking rework processes within the work order.
WoOperationId Long The unique identifier for the first count point operation that references this material. This identifier links the assembly component to the relevant operation for accurate tracking.
OperationSequenceNumber Decimal The sequence number of the operation within the work order. This number ensures proper execution order of operations involving the assembly component.
OperationName String The name of the operation associated with the assembly component. This name provides a descriptive label for easy identification of the operation in reports and interfaces.
WoOperationMaterialId [KEY] Long The unique identifier for the material referenced in the rework operation. This identifier ensures accurate tracking of reworked materials within the work order.
InventoryItemId Long The unique identifier for the item, product, or assembly in the inventory organization. This identifier links the component to its corresponding inventory record.
ItemNumber String The unique item number associated with the assembly component. This number serves as a reference for identifying the material within the system.
Quantity Decimal The planned quantity of the reworked assembly for the work order. This metric matches the total work order quantity and supports production planning.
UnitOfMeasure String The unit of measure (UOM) for the assembly component (for example, 'Pieces' or 'Kilograms'). This metric ensures consistency in quantity calculations and reporting.
SupplySubinventory String The subinventory used by default when the plant procures the material for rework. This field ensures proper material sourcing.
SupplyLocatorId Long The unique identifier for the locator within the subinventory. This identifier ensures precise tracking of storage locations for reworked materials.
SupplyLocator String The locator within the subinventory where the material for rework is stored. This locator helps in material handling and tracking.
ReservedQuantity Decimal The quantity of the assembly component that is reserved for the operation. This metric ensures that materials are available for production when needed.
IssuedQuantity Decimal The quantity of the assembly component that has been issued for the operation. This metric supports tracking material consumption during rework.
BackToBackFlag String Indicates whether the assembly component is part of a back-to-back process. This flag helps manage items directly tied to specific sales orders or demands.
ContractMfgFlag String Specifies whether the assembly component is part of a contract manufacturing process. This flag identifies outsourced components within the work order.
DueDays Int The number of days remaining until the assembly component is due for completion. This metric supports scheduling and prioritization.
Finder String A utility field enabling advanced search and filtering capabilities for assembly components. This field improves usability and efficiency in managing large datasets.
FirmPlannedFlag String Indicates whether the assembly component is firm planned. If the value is 'true', the component details are locked and not subject to changes from automated planning processes.
LastUpdateDate Datetime The date and time when the assembly component details were last updated. Thess metrics provide traceability and ensures the data reflects recent changes.
MaterialItemId Long The unique identifier for the material item associated with the assembly component. This identifier ensures accurate linkage to required materials.
PlannedCompletionDate Datetime The scheduled completion date for the reworked assembly. This metric ensures production timelines are met and supports tracking progress.
PlannedStartDate Datetime The scheduled start date for the rework involving the assembly component. This metric helps ensure proper scheduling and resource allocation.
ProductSerialId Long The unique identifier for the product serial number associated with the assembly component. This identifier supports traceability for serialized products.
ResourceId Long The unique identifier for the resource assigned to the assembly component operation. This identifier ensures that resources are correctly allocated and tracked.
SerialNumber String The serial number of the assembly component. This serial number provides detailed tracking for serialized items in the rework process.
SourceHeaderReferenceId Long The unique identifier for the source header reference associated with the assembly component. This identifier helps link the component to its originating transaction or document.
SourceHeaderRefId Long An alternative identifier for the source header reference. This identifier provides flexibility in integrating external systems.
SourceLineReferenceId Long The unique identifier for the source line reference associated with the assembly component. This identifier ensures accurate tracking of specific line items from the originating document.
SourceLineRefId Long An alternative identifier for the source line reference. This identifier supports flexible integration with external systems.
SourceSystemId Long The unique identifier for the source system that created the assembly component record. This identifier ensures traceability across integrated systems.
Tolerance Int The allowed deviation (in days) for the assembly component's completion date. This metric defines acceptable thresholds for delays.
WoProjectNumber String The unique project number associated with the assembly component. This number ties components to specific projects for better tracking and reporting.
WorkAreaId Long The unique identifier for the work area associated with the assembly component. This identifier ensures proper segmentation of components by operational zones.
WorkCenterId Long The unique identifier for the work center where the assembly component is processed. This identifierfield helps allocate and monitor resources at the work center level.
WorkOrderNumber String The unique number assigned to the work order. This number serves as a primary reference for identifying and tracking the work order.
WorkOrderStatusId Long The unique identifier for the status of the work order associated with the assembly component. This identifier ensures alignment between the work order's overall status and its components.
WoTaskNumber String The unique task number associated with the assembly component. This number provides detailed tracking of tasks within the work order.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175