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