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