WorksOrder

📊 Overview: 85 Fields 18 Indexes 4 Many-to-One Relations 14 One-to-Many Relations

📝 Description

🗨️ Transaction table for manufacturing works orders. Tracks production runs, quantities, machine assignments, cycle times, and completion status. Links Customer_Orders to production execution.

ℹ️ Table Information

  • Table ID: 4
  • UUID: 305DC4E1E3339443B76C086981BBCB7C
  • Primary Key: 🔑 Works_Order_No
  • Generated: 🕐 2025-12-04T14:33:32Z

📑 Table of Contents

📋 Fields

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

🔍 Indexes

Field Type Kind Unique
OEEgenerated Keywords regular -
Raised_Job_Card Keywords regular -
Machine_Started Keywords regular -
MaterialID Keywords regular -
No_In_Stock Keywords regular -
NewSystem Cluster regular -
Machine_No Keywords regular -
Part_No Keywords regular -
Customer_Code Keywords regular -
Works_Order_No Keywords regular ✨ Yes
ToolID Keywords regular -
Issue_No Keywords regular -
Machine_Completed Keywords regular -
ProductID_l Keywords regular -
Packing_Completed Keywords regular -
Robot Cluster regular -
MigrationID Keywords regular -
AutomaticStock Cluster regular -

🔗 Many-to-One Relations

Relation Name Destination Table Source → Destination State Description
CustomerEntity Customer Customer_Code → Customer_Code Active -
ToolsEntity Tools ToolID → Tool_ID Active -
ProductEntity Product ProductID_l → Product_ID Active -
MaterialEntity Material MaterialID → Unique_ID Active -

🔗 One-to-Many Relations

Relation Name Source Table Source → Destination State Description
Stock_MovementSelection Stock_Movement Works_Order_No_l → Works_Order_No Active -
CofCSelection CofC Works_Order_No → Works_Order_No Active -
Finished_StockSelection Finished_Stock Works_Order_No → Works_Order_No Active -
ProductReturnWorksOrderSelection ProductReturnWorksOrder Works_Order_No_l → Works_Order_No Active -
BoxLabelsSelection BoxLabels WorksOrder → Works_Order_No Active -
MaterialCheckHistorySelection MaterialCheckHistory WorksOrder → Works_Order_No Active -
RealTimeSelection RealTime WorksOrder → Works_Order_No Active -
ProductStockTakeSelection ProductStockTake WO → Works_Order_No Active -
ScrapSelection Scrap WorksOrder → Works_Order_No Active -
RTSUMSelection RTSUM WorksOrder → Works_Order_No Active -
RealTimeSensorExceptionsSelection RealTimeSensorExceptions WorksOrder → Works_Order_No Active -
WheelCalendarSelection WheelCalendar WorksOrder → Works_Order_No Active -
ShiftSummaryDetailSelection ShiftSummaryDetail WorksOrder → Works_Order_No Active -
ToolNoticeWorksOrderSelection ToolNoticeWorksOrder WorksOrder → Works_Order_No Active -

🔗 Related Items

📦 Classes

📄 Forms

Generated from catalog.4DCatalog Generated at: 2025-12-04T14:33:32Z

This site uses Just the Docs, a documentation theme for Jekyll.