π Overview: 139 Fields 10 Indexes 2 Many-to-One Relations 12 One-to-Many Relations
π¨οΈ Master data table for injection molding tools/dies. Stores tool specifications, maintenance history, temperature settings, and production parameters. Links to Products and tracks tool lifecycle.
Table ID: 2UUID: 730DDB789A822A45A2769798BE8BF8C3Primary Key: π Tool_IDGenerated: π 2025-12-04T14:33:31Z Field Type Constraints Description NextUniqueLabelID_l Long Integerπ« Not Null - Approved Booleanπ« Not Null - Short Name Stringπ« Not Null, οΏ½οΏ½οΏ½οΈ Hidden - ProductID Long Integerπ« Not Null - π Tool_ID Long Integerπ PK, β¨ Unique, β‘ Auto, β οΈ Required, π« Not Null, οΏ½οΏ½οΏ½ Not Modifiable - PartNo String (30)π« Not Null - ShortName String (25)π« Not Null, οΏ½οΏ½οΏ½οΈ Hidden - Machine_Type Stringπ« Not Null - NumOfRows Long Integerπ« Not Null - Pallet_Pic Pictureπ« Not Null - Setup_Sheet Booleanπ« Not Null - OperatorRequired Booleanπ« Not Null - Robot_Prg_No String (255)π« Not Null - Pallet_Type_m String (255)π« Not Null - Tool_No String (10)β¨ Unique, β οΈ Required, π« Not Null - Impressions Integerβ οΈ Required, π« Not Null - Date Created Dateπ« Not Null, π Not Enterable - Box_Per_Pallet Integerπ« Not Null - Boxes_Per_M_Pallet Integerπ« Not Null - Archive Booleanπ« Not Null - CycleTimeSecs Realβ οΈ Required, π« Not Null - PartWtGrams Realβ οΈ Required, π« Not Null - RunnerWtGrams Realπ« Not Null - Regrind_MaxPercent Realπ« Not Null - Packed_Per_Hour Long Integerπ« Not Null - Mandrells_per_Pallet Integerπ« Not Null - Packing Box String (20)π« Not Null, οΏ½οΏ½οΏ½οΈ Hidden - Dry_Weight Realπ« Not Null - If on Concess Booleanπ« Not Null - If Concess by N Booleanπ« Not Null - Total No Conces Long Integerπ« Not Null - No Concess Supp Long Integerπ« Not Null - Concess End Dat Dateπ« Not Null - DryWeightText Stringπ« Not Null - ReasonToolOffsite_txt Stringπ« Not Null - IsToolOffsite_b Booleanπ« Not Null - DateToolDueBack_d Dateπ« Not Null - TimePerPallet Integerπ« Not Null - Picture Pictureπ« Not Null - Prodn Quan Min Long Integerπ« Not Null - Production_Mandrell String (255)π« Not Null - Tool_Notes Stringπ« Not Null - Conditioned Booleanπ« Not Null - Type Integerπ« Not Null - Grey box Quan Long Integerπ« Not Null, οΏ½οΏ½οΏ½οΈ Hidden - Cages_per_Mandrell Integerπ« Not Null - Concession No String (20)π« Not Null - Customer Label String (25)π« Not Null - Additional_text_4_label Stringπ« Not Null - Nozzle String (10)π« Not Null - Separator Integerπ« Not Null - Prodn Quan Max Long Integerπ« Not Null - Location String (30)π« Not Null - Tool Mod String (10)π« Not Null - Initial Cust String (3)π« Not Null - Main Tool Booleanπ« Not Null - Additional_text Stringπ« Not Null - UseAddressLabels_b Booleanπ« Not Null - UseUniqueIDLabels_b Booleanπ« Not Null - LabelChoice_s String (35)β οΈ Required, π« Not Null - UseBagLabel_b Booleanπ« Not Null - UseExtraID_b Booleanπ« Not Null - UseLogisticslabel_b Booleanπ« Not Null - NextUniqueIDLogistics_l Long Integerπ« Not Null - Final_Customer String (35)π« Not Null - Weight_kitlabel Realπ« Not Null - Kit_ProductID String (30)π« Not Null - Kit_Quantity Long Integerπ« Not Null - Mandrel_OD Realπ« Not Null - NumOfLayers Long Integerπ« Not Null - BagSealingMethod String (255)π« Not Null - PackedInColumns Booleanπ« Not Null - RC_Sub_Sequence Long Integerπ« Not Null - RC_Additional_Seq Booleanπ« Not Null - RC_Barcode Booleanπ« Not Null - x3_sequence_packsheet Booleanπ« Not Null - x4_sequence_packsheet Booleanπ« Not Null - PackagingInstructionIssueDate Dateπ« Not Null - PackagingInstructionIssueName String (255)π« Not Null - identifier_address String (2)π« Not Null - No_metalpallets_per_box Integerβ οΈ Required, π« Not Null - two_boxnos Booleanπ« Not Null - qty_delivered_flag Booleanπ« Not Null - qty_pricechange Long Integerπ« Not Null - packrange_max Long Integerπ« Not Null - AQP Booleanπ« Not Null - x2_uniqueIDlabels Booleanπ« Not Null - DateChanged Dateπ« Not Null - PackagingInstructionIssueLevel String (255)π« Not Null - IsHandLoaded Booleanπ« Not Null - OddLayerQuantity Long Integerπ« Not Null - SmallSide Booleanπ« Not Null - LargeSide Booleanπ« Not Null - AlternatingLayerQuantA Long Integerπ« Not Null - AlternatingLayerQuantB Long Integerπ« Not Null - ScalesFixedQuant Long Integerπ« Not Null - ExtraPackInfo Stringπ« Not Null - LabelOrigin Booleanπ« Not Null - QRCode Booleanπ« Not Null - Amber Booleanπ« Not Null - RunsSinceApproval Integerπ« Not Null - AmberCheckPercent Integerπ« Not Null - AmberManual Booleanπ« Not Null - AmberManualWhen Dateπ« Not Null - AmberManualWho String (255)π« Not Null - AmberPQITriggered Booleanπ« Not Null - RCText String (255)π« Not Null - ForeCast2015 Long Integerπ« Not Null - ForeCast2015Update Dateπ« Not Null - ProductName String (255)π« Not Null - PicBlob BLOB Scalarπ« Not Null - PicBlobTxt Stringπ« Not Null - LogisticsPrefix String (255)π« Not Null - DataMatrix Booleanπ« Not Null - Regrind Booleanπ« Not Null - RegrindComments String (255)π« Not Null - NotifyQuality Booleanπ« Not Null - NotifyReason String (255)π« Not Null - ToolReady Booleanπ« Not Null - ToolOffsite Booleanπ« Not Null - StatusUpdated String (255)π« Not Null - ToolDueDate Dateπ« Not Null - PlanningWheelCycle Realπ« Not Null - PlanningWheelHours Realπ« Not Null - HotHalfID Long Integerπ« Not Null - HotHalfBooked Booleanπ« Not Null - AmberTriggerTime String (255)π« Not Null - NewCalcedPartWeight Realπ« Not Null - MaintenanceCycleTrigger Long Integerπ« Not Null - UsageWarningDays Long Integerπ« Not Null - ExtraSideLabel Booleanπ« Not Null - QRtype Integerπ« Not Null - RequiresChecking Boolean- - TemperatureTargetMin Realπ« Not Null - TemperatureTargetMax Realπ« Not Null - RobotHeads String (255)- - MigrationID Long Integer- - ToolNoticeObject Object- - ProductionHoldObject Object- -
Field Type Kind Unique MigrationIDKeywords regular - PartNoKeywords regular - ArchiveKeywords regular - ShortNameKeywords regular - two_boxnosKeywords regular - HotHalfIDKeywords regular - Tool_NoKeywords regular - ProductIDKeywords regular - HotHalfBookedKeywords regular - Tool_IDKeywords regular β¨ Yes
Relation Name Destination Table Source β Destination State Description ProductEntityProduct ProductID β Product_IDActive - HotHalfEntityHotHalfs HotHalfID β IDActive -
Relation Name Source Table Source β Destination State Description WorksOrderSelectionWorksOrder ToolID β Tool_IDActive - NonConformanceSelectionNonConformance Tool_ID β Tool_IDActive - ToolLogSelectionToolLog Tool_ID β Tool_IDActive - ApprovalsSelectionApprovals ToolID β Tool_IDActive - BoxLabelsSelectionBoxLabels ToolID β Tool_IDActive - WorkRequestsSelectionWorkRequests ToolID β Tool_IDActive - ToolMaintenanceLogSelectionToolMaintenanceLog ToolID β Tool_IDActive - ToolTemperatureTargetSelectionToolTemperatureTarget ToolID β Tool_IDActive - ToolDocumentSelectionToolDocument ToolID β Tool_IDActive - PlanningWheelSelectionPlanningWheel ToolID β Tool_IDActive - Product_OptionSelectionProduct_Option Tool ID β Tool_IDActive - ToolNoticeSelectionToolNotice ToolID β Tool_IDActive -
Tools - ORDA DataClass class for Tools tableToolsEntity - ORDA Entity class for Tools table Generated from catalog.4DCatalog Generated at: 2025-12-04T14:33:31Z