π Overview: 105 Fields 7 Indexes 3 Many-to-One Relations 18 One-to-Many Relations
π¨οΈ Master data table for finished products and components. Stores product specifications, dimensions, materials, cycle times, and quality requirements. Links to Tools, Materials, and Customer data.
Table ID: 10UUID: C860B832DC3A2742AC90F8A95BC2F157Primary Key: π Product_IDGenerated: π 2025-12-04T14:33:37Z Field Type Constraints Description π Product_ID Long Integerπ PK, β¨ Unique, β‘ Auto Primary key - Auto-incremented unique identifier for each product. Our Part No String (50)β οΈ Required, π« Not Null Internal part number assigned by manufacturing company. Mandatory, up to 50 characters. Cust Part No String (50)β οΈ Required, π« Not Null Customerβs own part number for this product. Mandatory, up to 50 characters. Issue No String (5)β οΈ Required, π« Not Null Current revision/issue number of product specification. Mandatory, 5 characters max. Issue Date Dateπ« Not Null Date when current issue/revision of product specification was released. Part Name String (50)β οΈ Required, π« Not Null Descriptive name of the product/part. Mandatory, up to 50 characters. Short Name String (25)β οΈ Required, π« Not Null Abbreviated product name for space-constrained displays. Mandatory, 25 characters max. Conditioned Booleanπ« Not Null Flag indicating whether product requires post-mold conditioning process. QuotedCycle Realπ« Not Null, οΏ½οΏ½οΏ½ Not Modifiable Target cycle time quoted to customer (in seconds). Non-modifiable after initial entry. DefMatID Long Integerπ« Not Null Default material ID - Foreign key to Material table for primary raw material used in production. Price Quan Integerπ« Not Null - NoInBox Long Integerπ« Not Null - Min Order Quan Long Integerπ« Not Null - NumOfSquirts Long Integerπ« Not Null - Drawing No String (25)π« Not Null - Regrnd allwd pc Integerπ« Not Null - Odette_PO String (255)π« Not Null - Packed_Per_Hour Long Integerπ« Not Null - Programme_No String (3)π« Not Null - Tolerance_Low Realπ« Not Null - Tolerance_High Realπ« Not Null - TimePerPallet Integerπ« Not Null - MBType String (255)π« Not Null - MBAmount Integerπ« Not Null - EmojiID Long Integer- - Archive Booleanπ« Not Null - Inspection Issue Integerπ« Not Null - Inspection IssueDate Dateπ« Not Null - Inspection IssuedBy String (20)π« Not Null - Inspect Method1 Stringπ« Not Null - Inspect Method2 Stringπ« Not Null - Inspect Method3 Stringπ« Not Null - Inspect Method4 Stringπ« Not Null - Inspect Method5 Stringπ« Not Null - Patrol Inspect1 Stringπ« Not Null - Patrol Inspect2 Stringπ« Not Null - Patrol Inspect3 Stringπ« Not Null - Patrol Inspect4 Stringπ« Not Null - Conversion_Figure String (50)π« Not Null - Quality_FormNo Integerπ« Not Null - Quality_IssueDate Dateπ« Not Null - Quality_Issuedby String (10)π« Not Null - Quality_ReferenceNo String (10)π« Not Null - Initial_Customer String (3)π« Not Null - OperatorRequired Booleanπ« Not Null - Inspect_Freq_qty Integerπ« Not Null - Inspect_freq_cycle Integerπ« Not Null - Inspect_freq_period String (9)π« Not Null - Extra_Text String (40)π« Not Null - Box_Per_Pallet Integerπ« Not Null - Top_Up_No Integerπ« Not Null - Cond_Cycl_Lght Integerπ« Not Null - Part_No_Colour Integerπ« Not Null - Part_Colour Stringπ« Not Null - Reason_4_Issue_Change String (20)π« Not Null - Danzas_ID Integerπ« Not Null - Cages_per_Mandrell Integerπ« Not Null - Boxes_per_M_Pallet Integerπ« Not Null - Pallet_Type_m String (5)π« Not Null - OurMinimum Long Integerπ« Not Null - Robot_Prg_No String (255)π« Not Null - Pallet_Pic Pictureπ« Not Null - Production_Mandrell String (30)π« Not Null - Mandrells_per_Pallet Integerπ« Not Null - Mandrel_OD Realπ« Not Null - OurBatchSize Long Integerπ« Not Null - PrimaryRoute Integerπ« Not Null - Setup_Sheet Booleanπ« Not Null - Danzas_ID1 Integerπ« Not Null - Danzas_ID2 Integerπ« Not Null - ControlPlanLink1_txt Stringπ« Not Null - ControlPlanLink2_txt Stringπ« Not Null - Water_Squirt_prog_number Realπ« Not Null - RunsPerForecast Long Integerπ« Not Null - StockTowardsForecast Integerπ« Not Null - ForecastQty Integerπ« Not Null - ForecastOutstanding Integerπ« Not Null - CoveredByWheel Integerπ« Not Null - MagicNumber Realπ« Not Null - Field_80 String (255)π« Not Null - RoutedElsewhere Integerπ« Not Null - ConsignmentOrder Booleanπ« Not Null - HoursOverride Realπ« Not Null - Inspect_Freq_MIN Integerπ« Not Null - PlannedRoute Integerπ« Not Null - SecondCode String (255)π« Not Null - UsedSinceBill Long Integerπ« Not Null - WareHouseMethod String (255)π« Not Null - PrioritizeStandardOrders Booleanπ« Not Null - TotalPackTime Realπ« Not Null - TotalPackInstances Long Integerπ« Not Null - TotalPackString String (255)π« Not Null - SecondLocation String (255)π« Not Null - BottomPackTimeTarget Realπ« Not Null - BottomPackTimeOverride Timeπ« Not Null - PalletMethodID Long Integerπ« Not Null - ClosedLoopPercent Realπ« Not Null - ForecastOutstandingCurrentYear Long Integerπ« Not Null - AverageRunLength Realπ« Not Null - SubContainerQty Long Integerπ« Not Null - SubContainerName String (255)π« Not Null - PackingInstructionsFileBlob BLOB Scalar- - PackingInstructionsFileName String (255)- - MigrationID Long Integerπ« Not Null - LastMigration String (255)- -
Field Type Kind Unique MigrationIDKeywords regular - PrimaryRouteCluster regular - Product_IDKeywords regular β¨ Yes DefMatIDKeywords regular - Cust Part NoKeywords regular - EmojiIDKeywords regular - Our Part NoKeywords regular -
Relation Name Destination Table Source β Destination State Description PalletMethodsEntityPalletMethods PalletMethodID β IDActive - EmojisEntityEmojis EmojiID β IDActive - MaterialEntityMaterial DefMatID β Unique_IDActive -
Relation Name Source Table Source β Destination State Description ToolsSelectionTools ProductID β Product_IDActive - Customer_OrderSelectionCustomer_Order Product_ID β Product_IDActive - Product_OptionSelectionProduct_Option Product ID β Product_IDActive - GaugesSelectionGauges Product_ID β Product_IDActive - GrippersSelectionGrippers Product_ID β Product_IDActive - ProductReturnSelectionProductReturn ProductID_l β Product_IDActive - ProductPackagingSelectionProductPackaging ProductID β Product_IDActive - ProductStocktakeSelectionProductStockTake ProductID β Product_IDActive - ConsignmentEntrySelectionConsignmentEntry ProductID β Product_IDActive - BOMSelectionBOM ProductID β Product_IDActive - PalletSelectionPallet ProductID β Product_IDActive - WorksOrderSelectionWorksOrder ProductID_l β Product_IDActive - PackingInstructionFilesSelectionPackingInstructionFiles ProductID β Product_IDActive - WheelCalendarSelectionWheelCalendar ProductID β Product_IDActive - ProductMaterialOptionsSelectionProductMaterialOptions ProductID β Product_IDActive - CofCSelectionCofC ProductID_l β Product_IDActive - ForecastSelectionForecast ProductID β Product_IDActive - QualitySystemProceduresSelectionQualitySystemProcedures ProductID β Product_IDActive -
Product - ORDA DataClass class for Product tableProductEntity - ORDA Entity class for Product table Generated from catalog.4DCatalog Generated at: 2025-12-04T14:33:37Z