Product

📊 Overview: 105 Fields

7 Indexes

3 Many-to-One Relations

18 One-to-Many Relations

📝 Description

🗨️ 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 Information

Table ID: 10
UUID: C860B832DC3A2742AC90F8A95BC2F157
Primary Key: 🔑 Product_ID
Generated: 🕐 2025-12-04T14:33:37Z

📑 Table of Contents

📋 Fields (105)
🔍 Indexes (7)
🔗 Many-to-One Relations (3)
🔗 One-to-Many Relations (18)
🔗 Related Items
- Classes (2)
- Forms (40)

📋 Fields

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

🔍 Indexes

Field	Type	Kind	Unique
`MigrationID`	Keywords	regular	-
`PrimaryRoute`	Cluster	regular	-
`Product_ID`	Keywords	regular	✨ Yes
`DefMatID`	Keywords	regular	-
`Cust Part No`	Keywords	regular	-
`EmojiID`	Keywords	regular	-
`Our Part No`	Keywords	regular	-

🔗 Many-to-One Relations

Relation Name	Destination Table	Source → Destination	State	Description
`PalletMethodsEntity`	PalletMethods	`PalletMethodID` → `ID`	Active	-
`EmojisEntity`	Emojis	`EmojiID` → `ID`	Active	-
`MaterialEntity`	Material	`DefMatID` → `Unique_ID`	Active	-

🔗 One-to-Many Relations

Relation Name	Source Table	Source → Destination	State	Description
`ToolsSelection`	Tools	`ProductID` → `Product_ID`	Active	-
`Customer_OrderSelection`	Customer_Order	`Product_ID` → `Product_ID`	Active	-
`Product_OptionSelection`	Product_Option	`Product ID` → `Product_ID`	Active	-
`GaugesSelection`	Gauges	`Product_ID` → `Product_ID`	Active	-
`GrippersSelection`	Grippers	`Product_ID` → `Product_ID`	Active	-
`ProductReturnSelection`	ProductReturn	`ProductID_l` → `Product_ID`	Active	-
`ProductPackagingSelection`	ProductPackaging	`ProductID` → `Product_ID`	Active	-
`ProductStocktakeSelection`	ProductStockTake	`ProductID` → `Product_ID`	Active	-
`ConsignmentEntrySelection`	ConsignmentEntry	`ProductID` → `Product_ID`	Active	-
`BOMSelection`	BOM	`ProductID` → `Product_ID`	Active	-
`PalletSelection`	Pallet	`ProductID` → `Product_ID`	Active	-
`WorksOrderSelection`	WorksOrder	`ProductID_l` → `Product_ID`	Active	-
`PackingInstructionFilesSelection`	PackingInstructionFiles	`ProductID` → `Product_ID`	Active	-
`WheelCalendarSelection`	WheelCalendar	`ProductID` → `Product_ID`	Active	-
`ProductMaterialOptionsSelection`	ProductMaterialOptions	`ProductID` → `Product_ID`	Active	-
`CofCSelection`	CofC	`ProductID_l` → `Product_ID`	Active	-
`ForecastSelection`	Forecast	`ProductID` → `Product_ID`	Active	-
`QualitySystemProceduresSelection`	QualitySystemProcedures	`ProductID` → `Product_ID`	Active	-

📦 Classes

Product - ORDA DataClass class for Product table
ProductEntity - ORDA Entity class for Product table

📄 Forms

%2AMigration - Data source for %2AMigration form
%2AStockControl - Data source for %2AStockControl form
%2Atest1 - Data source for %2Atest1 form
%2AToolEditor - Data source for %2AToolEditor form
BOM - Data source for BOM form
BOM_MaterialPrices - Data source for BOM_MaterialPrices form
BOM_Output - Data source for BOM_Output form
BOM_Packaging - Data source for BOM_Packaging form
CapacityPlanning - Data source for CapacityPlanning form
ChangeMaterial - Data source for ChangeMaterial form
ConsignmentCallOff - Data source for ConsignmentCallOff form
ConsignmentEntry - Data source for ConsignmentEntry form
ConsignmentSSLs - Data source for ConsignmentSSLs form
CustomerOrderEntry - Data source for CustomerOrderEntry form
EDIgenerator - Data source for EDIgenerator form
Forecast - Data source for Forecast form
ForecastImporter - Data source for ForecastImporter form
LabelPrinting - Data source for LabelPrinting form
Manufacture - Data source for Manufacture form
MaterialOptions - Data source for MaterialOptions form
NewScrapEntry - Data source for NewScrapEntry form
NSKPalletIDs - Data source for NSKPalletIDs form
OrderDelivery - Data source for OrderDelivery form
OrderOverview - Data source for OrderOverview form
PackagingOptions - Data source for PackagingOptions form
PackingLabour - Data source for PackingLabour form
PalletTransfer - Data source for PalletTransfer form
Pricing - Data source for Pricing form
ProductStockTake - Data source for ProductStockTake form
QualitySystemResults - Data source for QualitySystemResults form
QualitySystemTolerances - Data source for QualitySystemTolerances form
QuarantineManager - Data source for QuarantineManager form
RTSUM - Data source for RTSUM form
Scheduler - Data source for Scheduler form
SIMImporter - Data source for SIMImporter form
SNRSUMMARY - Data source for SNRSUMMARY form
StockAtLocation - Data source for StockAtLocation form
ToolDisplay4 - Data source for ToolDisplay4 form
ToolStandardsReview - Data source for ToolStandardsReview form
WarehouseOptions - Data source for WarehouseOptions form

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