Product_Option

📊 Overview: 29 Fields

8 Indexes

4 Many-to-One Relations

1 One-to-Many Relations

📝 Description

🗨️ Configuration table defining customer-specific product variants, packaging options, and special requirements. Links Products to Customer-specific specifications and pricing.

ℹ️ Table Information

Table ID: 13
UUID: 2E835762FEA7484EB4687878631CFB10
Primary Key: 🔑 ID
Generated: 🕐 2025-12-04T14:33:40Z

📑 Table of Contents

📋 Fields (29)
🔍 Indexes (8)
🔗 Many-to-One Relations (4)
🔗 One-to-Many Relations (1)
🔗 Related Items
- Classes (2)
- Forms (9)

📋 Fields

Field	Type	Constraints	Description
Product ID	`Long Integer`	⚠️ Required, 🚫 Not Null	-
Part No	`String` (30)	⚠️ Required, 🚫 Not Null	-
Tool ID	`Long Integer`	⚠️ Required, 🚫 Not Null	-
Tool No	`String` (5)	⚠️ Required, 🚫 Not Null	-
Material_ID	`Long Integer`	🚫 Not Null	-
Material Name	`String` (80)	🚫 Not Null	-
Price	`Real`	⚠️ Required, 🚫 Not Null	-
Customer Code	`String` (3)	⚠️ Required, 🚫 Not Null	-
Modified_Date	`Date`	🚫 Not Null	-
Currency	`String` (2)	🚫 Not Null	-
INCOTERM	`String` (255)	🚫 Not Null	-
Batch Quantity	`Long Integer`	🚫 Not Null	-
PriceQuantity	`Long Integer`	🚫 Not Null	-
DeliveryCost	`Real`	🚫 Not Null	-
Comments	`String`	🚫 Not Null	-
Consignment	`Boolean`	🚫 Not Null	-
🔑 ID	`Long Integer`	🔑 PK, ✨ Unique, ⚡ Auto, 🚫 Not Null	-
ConsignmentMin	`Long Integer`	🚫 Not Null	-
ConsignmentMax	`Long Integer`	🚫 Not Null	-
CustomerReference	`String` (255)	🚫 Not Null	-
Deconsigned_Stock	`Long Integer`	🚫 Not Null	-
CurrentConsignmentOrder	`String` (255)	🚫 Not Null	-
Con_LastReceived	`Date`	🚫 Not Null	-
MOQ	`Long Integer`	🚫 Not Null	-
DefaultOrderNumber	`String` (255)	🚫 Not Null	-
MOV	`Real`	🚫 Not Null	-
SSLOffsetDays	`Integer`	-	-
SSLOverride	`Long Integer`	🚫 Not Null	-
MigrationID	`Long Integer`	-	-

🔍 Indexes

Field	Type	Kind	Unique
`Material Name`	Keywords	regular	-
`ID`	Keywords	regular	✨ Yes
`Part No`	Keywords	regular	-
`Price`	Keywords	regular	-
`Product ID`	Keywords	regular	-
`Tool No`	Keywords	regular	-
`Customer Code`	Keywords	regular	-
`Material_ID`	Keywords	regular	-

🔗 Many-to-One Relations

Relation Name	Destination Table	Source → Destination	State	Description
`ProductEntity`	Product	`Product ID` → `Product_ID`	Active	-
`MaterialEntity`	Material	`Material_ID` → `Unique_ID`	Active	-
`CustomerEntity`	Customer	`Customer Code` → `Customer_Code`	Active	-
`ToolsEntity`	Tools	`Tool ID` → `Tool_ID`	Active	-

🔗 One-to-Many Relations

Relation Name	Source Table	Source → Destination	State	Description
`Customer_OrderSelection`	Customer_Order	`Product_OptionID` → `ID`	Active	-

📦 Classes

Product_Option - ORDA DataClass class for Product_Option table
Product_OptionEntity - ORDA Entity class for Product_Option table

📄 Forms

BOM - Data source for BOM form
ConsignmentEntry - Data source for ConsignmentEntry form
ConsignmentSSLs - Data source for ConsignmentSSLs form
CustomerInput - Data source for CustomerInput form
CustomerOrderEntry - Data source for CustomerOrderEntry form
Forecast - Data source for Forecast form
OrderOverview - Data source for OrderOverview form
Pricing - Data source for Pricing form
SIMImporter - Data source for SIMImporter form

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