CData Python Connector for Oracle Fusion Cloud SCM

Build 24.0.9175

WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial

Tracks serials for assemblies issued to rework work orders, supporting detailed serial traceability.

Columns

Name Type Description
WorkOrdersWorkOrderId [KEY] Long The unique identifier linking the serialized component to its associated work order. This identifier ensures precise tracking of serial-specific details within the work order.
WorkorderassemblycomponentWoOperationMaterialId [KEY] Long The unique identifier for the operation material associated with the serialized component. This identifier links the serial number to its corresponding operation material for traceability.
WoOperationMaterialSerialId [KEY] Long The unique identifier for the specific serial record of the operation material. This identifier ensures accurate tracking of serialized data for assembly components.
OrganizationId Long The unique identifier for the inventory organization managing the serialized component. This identifier supports multi-organization setups and ensures proper segmentation.
WorkOrderId Long The primary key that uniquely identifies the work order associated with the serialized component. This primary key ensures that serial details are tied to the correct work order for tracking and management.
WoOperationMaterialId Long The unique identifier for the reworked assembly item associated with the serialized component. This identifier ensures linkage to specific materials in the rework process.
WoOperationMaterialLotId Long The unique identifier for the material lot associated with the serialized component. This identifier ensures traceability of serialized items within the lot.
LotNumber String The lot number associated with the serialized assembly. This number supports tracking serialized items within their corresponding lots.
InventoryItemId Long The unique identifier for the inventory item associated with the serialized component. This identifier ensures accurate linkage to the inventory record.
SerialNumber String The unique serial number assigned to the reworked assembly. This number enables detailed tracking and traceability for serialized items.
BackToBackFlag String Indicates whether the serialized 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 serialized component is part of a contract manufacturing process. This field identifies outsourced components within the work order.
DueDays Int The number of days remaining until the serialized component is due for completion. This metric supports prioritization and scheduling.
Finder String A utility field enabling advanced search and filtering capabilities for serialized components. This field helps users efficiently locate specific serial records.
FirmPlannedFlag String Indicates whether the serialized component is firm planned. If the value is 'true', the component details are locked and not subject to changes from automated planning processes.
ItemNumber String The unique item number associated with the serialized component. This number provides a reference for identifying serialized materials or products.
LastUpdateDate Datetime The date and time when the serialized component details were last updated. These metrics ensure traceability and reflects recent changes.
MaterialItemId Long The unique identifier for the material item associated with the serialized component. This identifier ensures correct linkage to required materials.
PlannedCompletionDate Datetime The scheduled completion date for the serialized component. This metric ensures production timelines are met and supports tracking progress.
PlannedStartDate Datetime The scheduled start date for the serialized component's rework or production. This metric ensures proper scheduling and resource allocation.
ProductSerialId Long The unique identifier for the product serial number associated with the component. This identifier supports traceability for serialized items.
ResourceId Long The unique identifier for the resource assigned to the serialized component operation. This identifier ensures that resources are correctly allocated and tracked.
SourceHeaderReferenceId Long The unique identifier for the source header reference associated with the serialized 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 serialized 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 serialized component record. This identifier ensures traceability across integrated systems.
Tolerance Int The allowed deviation (in days) for the serialized component's completion date. This metric defines acceptable thresholds for delays.
WoProjectNumber String The unique project number associated with the serialized component. This number ties serialized items to specific projects for better tracking and reporting.
WorkAreaId Long The unique identifier for the work area associated with the serialized component. This identifier ensures proper segmentation of serialized components by operational zones.
WorkCenterId Long The unique identifier for the work center where the serialized component is processed. This identifier 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 serialized component. This identifier ensures alignment between the work order's overall status and its serialized items.
WoTaskNumber String The unique task number associated with the serialized 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