π Overview: 26 Fields 9 Indexes 3 Many-to-One Relations 11 One-to-Many Relations
π¨οΈ Master data table for raw materials and resins used in production. Stores material specifications, suppliers, batch tracking, and quality certificates. Referenced by Products and MaterialStock.
Table ID: 11UUID: 13EE0980326D984887426E4CEDD50A30Primary Key: π Unique_IDGenerated: π 2025-12-04T14:33:38Z Field Type Constraints Description π Unique_ID Long Integerπ PK, β¨ Unique, β‘ Auto, π« Not Null, οΏ½οΏ½οΏ½ Not Modifiable - MaterialName String (80)π« Not Null - Customers Name String (35)π« Not Null - In Stock Long Integerπ« Not Null - Supplier Code String (3)π« Not Null - Supplier Name String (25)π« Not Null - Current Booleanπ« Not Null - Short Name String (35)π« Not Null - Archive Booleanπ« Not Null - Colour_l Long Integerπ« Not Null - Manufacturer_s String (20)π« Not Null - UsageMatID Long Integerπ« Not Null - SafetyStockTarget Integerπ« Not Null - BOM_Price Realπ« Not Null - LossPercent Realπ« Not Null - UsageMatID2 Long Integerπ« Not Null - UsageMatID2Percent Realπ« Not Null - Calendar_Price Realπ« Not Null - UsageMatID3 Long Integerπ« Not Null - UsageMatID3Percent Realπ« Not Null - FontColour Long Integerπ« Not Null - BOM_Comment String (255)π« Not Null - SharedMaterialSource Booleanπ« Not Null - LeadTimeDays Long Integer- - MigrationID Long Integer- - LastMigration String (255)- -
Field Type Kind Unique UsageMatID3Keywords regular - UsageMatIDKeywords regular - CurrentKeywords regular - ArchiveKeywords regular - MigrationIDKeywords regular - UsageMatID2Keywords regular - MaterialNameKeywords regular - Unique_IDKeywords regular β¨ Yes Customers NameKeywords regular -
Relation Name Destination Table Source β Destination State Description UsageMat1EntityMaterial UsageMatID β Unique_IDActive - UsageMat2EntityMaterial UsageMatID2 β Unique_IDActive - UsageMat3EntityMaterial UsageMatID3 β Unique_IDActive -
Relation Name Source Table Source β Destination State Description Customer_OrderSelectionCustomer_Order Material_ID β Unique_IDActive - Product_OptionSelectionProduct_Option Material_ID β Unique_IDActive - RMCSelectionRMC MaterialID_l β Unique_IDActive - WheelCalendarSelectionWheelCalendar MatID β Unique_IDActive - BOMSelectionBOM MaterialID β Unique_IDActive - MaterialCheckHistorySelectionMaterialCheckHistory MaterialID β Unique_IDActive - PlanningWheelSelectionPlanningWheel MaterialID β Unique_IDActive - ProductMaterialOptionsSelectionProductMaterialOptions MaterialID β Unique_IDActive - MaterialStockSelectionMaterialStock MaterialID β Unique_IDActive - ProductSelectionProduct DefMatID β Unique_IDActive - WorksOrderSelectionWorksOrder MaterialID β Unique_IDActive -
Generated from catalog.4DCatalog Generated at: 2025-12-04T14:33:38Z