📊 Overview: 85 Fields 18 Indexes 4 Many-to-One Relations 14 One-to-Many Relations
🗨️ Transaction table for manufacturing works orders. Tracks production runs, quantities, machine assignments, cycle times, and completion status. Links Customer_Orders to production execution.
Table ID: 4UUID: 305DC4E1E3339443B76C086981BBCB7CPrimary Key: 🔑 Works_Order_NoGenerated: 🕐 2025-12-04T14:33:32Z Field Type Constraints Description 🔑 Works_Order_No Long Integer🔑 PK, ✨ Unique, ⚡ Auto, ⚠️ Required, 🚫 Not Null - Part_No String (30)⚠️ Required, 🚫 Not Null - Customer_Code String (3)⚠️ Required, 🚫 Not Null - Production_Target Long Integer⚠️ Required, 🚫 Not Null - Parts_Packed Long Integer🚫 Not Null - Raised_Job_Card Boolean🚫 Not Null - Machine_Completed Boolean🚫 Not Null - RouteCards Boolean🚫 Not Null - Notes String🚫 Not Null - Labels Boolean🚫 Not Null - SequencedNo Integer🚫 Not Null - Quantity_Manufactured Long Integer🚫 Not Null - ToolID Long Integer🚫 Not Null - Tool_No String (5)🚫 Not Null - No_In_Stock Long Integer🚫 Not Null - MaterialName String (80)⚠️ Required, 🚫 Not Null - MaterialID Long Integer⚠️ Required, 🚫 Not Null - Issue_No String (5)🚫 Not Null - ProductID_l Long Integer🚫 Not Null - Packing_Completed Boolean🚫 Not Null - Calculated_Scrap Long Integer🚫 Not Null - Label_Text String (80)🚫 Not Null - RMC_Nos String (61)🚫 Not Null - Machine_No Integer🚫 Not Null - Completed_Date Date🚫 Not Null - Packing_Box_No Long Integer🚫 Not Null - Machine_Started Boolean🚫 Not Null - WorkInProgress Long Integer🚫 Not Null - Current_Production_Quantity Long Integer🚫 Not Null - UpdatePartsMadeDate Date🚫 Not Null - Is_a_Trial Boolean🚫 Not Null - Parts_Delivered Long Integer🚫 Not Null - Date_Created Date🚫 Not Null - Quarantine_Finished_Stock Long Integer🚫 Not Null - DrawingNo String (25)🚫 Not Null - Start_Date Date🚫 Not Null - PackingSheetPrinted Boolean🚫 Not Null - Cycle_Time Real🚫 Not Null - Entered_Parts_Scrap Long Integer🚫 Not Null - Fin_Initals String (30)🚫 Not Null - Part_Weight Real🚫 Not Null - Runner_Weight Real🚫 Not Null - Weight_Initals String (30)🚫 Not Null - Dry_Weight Real🚫 Not Null - Fin_Packed_Date Date🚫 Not Null - Production_Chart_Status Boolean🚫 Not Null - Production_Chart_DateSent Date🚫 Not Null - Quarantined_b Boolean🚫 Not Null - Quarantine_UnpackedWIP_Stock Long Integer🚫 Not Null - ReturnsScrap_l Long Integer🚫 Not Null - Quarantine_Returned_Stock_l Long Integer🚫 Not Null - Barcodenum_Part String🚫 Not Null - Barcodepicture_part String🚫 Not Null - Barcodenum_quantity String🚫 Not Null - Barcodepicture_quantity String🚫 Not Null - Barcodenum_supplierid String🚫 Not Null - Barcodepicture_supplierid String🚫 Not Null - Barcodenum_labelid String🚫 Not Null - Barcodepicture_labelid String🚫 Not Null - Barcodepicture_workorder String🚫 Not Null - Barcodenum_worksorder String🚫 Not Null - Cycle_Flag Boolean🚫 Not Null - AmberQuarantine Boolean🚫 Not Null - StartTime Time🚫 Not Null - FinishTime Time🚫 Not Null - rFtime Real🚫 Not Null - rStime Real🚫 Not Null - SetDate Date🚫 Not Null - FirstOffCompleted Boolean🚫 Not Null - FirstOffComments String🚫 Not Null - Impressions Integer🚫 Not Null - NewSystem Boolean🚫 Not Null - AutomaticStock Boolean🚫 Not Null - Robot Boolean🚫 Not Null - QuarantineReason String (255)🚫 Not Null - FirstOffWeightsChecked Boolean🚫 Not Null - PlannedMaterialID Long Integer🚫 Not Null - Regrind Boolean🚫 Not Null - MaterialCheckedBy String (255)🚫 Not Null - MaterialCheckComment String (255)🚫 Not Null - OEEgenerated Boolean🚫 Not Null - LastProcessedRealTimeID Long Integer- - FixedDate Date- - MigrationID Long Integer- - LastMigration String (255)- -
Field Type Kind Unique OEEgeneratedKeywords regular - Raised_Job_CardKeywords regular - Machine_StartedKeywords regular - MaterialIDKeywords regular - No_In_StockKeywords regular - NewSystemCluster regular - Machine_NoKeywords regular - Part_NoKeywords regular - Customer_CodeKeywords regular - Works_Order_NoKeywords regular ✨ Yes ToolIDKeywords regular - Issue_NoKeywords regular - Machine_CompletedKeywords regular - ProductID_lKeywords regular - Packing_CompletedKeywords regular - RobotCluster regular - MigrationIDKeywords regular - AutomaticStockCluster regular -
Relation Name Destination Table Source → Destination State Description CustomerEntityCustomer Customer_Code → Customer_CodeActive - ToolsEntityTools ToolID → Tool_IDActive - ProductEntityProduct ProductID_l → Product_IDActive - MaterialEntityMaterial MaterialID → Unique_IDActive -
Relation Name Source Table Source → Destination State Description Stock_MovementSelectionStock_Movement Works_Order_No_l → Works_Order_NoActive - CofCSelectionCofC Works_Order_No → Works_Order_NoActive - Finished_StockSelectionFinished_Stock Works_Order_No → Works_Order_NoActive - ProductReturnWorksOrderSelectionProductReturnWorksOrder Works_Order_No_l → Works_Order_NoActive - BoxLabelsSelectionBoxLabels WorksOrder → Works_Order_NoActive - MaterialCheckHistorySelectionMaterialCheckHistory WorksOrder → Works_Order_NoActive - RealTimeSelectionRealTime WorksOrder → Works_Order_NoActive - ProductStockTakeSelectionProductStockTake WO → Works_Order_NoActive - ScrapSelectionScrap WorksOrder → Works_Order_NoActive - RTSUMSelectionRTSUM WorksOrder → Works_Order_NoActive - RealTimeSensorExceptionsSelectionRealTimeSensorExceptions WorksOrder → Works_Order_NoActive - WheelCalendarSelectionWheelCalendar WorksOrder → Works_Order_NoActive - ShiftSummaryDetailSelectionShiftSummaryDetail WorksOrder → Works_Order_NoActive - ToolNoticeWorksOrderSelectionToolNoticeWorksOrder WorksOrder → Works_Order_NoActive -
Generated from catalog.4DCatalog Generated at: 2025-12-04T14:33:32Z