📊 Overview: 19 Fields 3 Indexes 2 Many-to-One Relations 2 One-to-Many Relations
🗨️ Master data table for general supplies and consumables used in production (not raw materials). Tracks inventory levels, suppliers, and reorder points.
Table ID: 20UUID: B84FAAF4158D23479C7828325B99FDF5Primary Key: 🔑 UniqueID_iGenerated: 🕐 2025-12-04T14:33:46Z Field Type Constraints Description 🔑 UniqueID_i Integer🔑 PK, ✨ Unique, ⚡ Auto, ⚠️ Required, 🚫 Not Null - Name_s String (31)🚫 Not Null - Ref_s String (20)🚫 Not Null - Description_txt String🚫 Not Null - Price_r Real🚫 Not Null - PriceQuantity_l Long Integer🚫 Not Null - MinOrderQty_r Real🚫 Not Null - SupplierID_l Long Integer🚫 Not Null - UnitOfSale_s String (20)🚫 Not Null - StockQty_r Real🚫 Not Null - AdditionalInfo_txt String🚫 Not Null - Currency_s String (3)🚫 Not Null - IsPackaging Boolean🚫 Not Null - PackagingCat Long Integer🚫 Not Null - RawMaterial Boolean🚫 Not Null - MaterialID Long Integer🚫 Not Null - ReuseTimes Integer🚫 Not Null - MarginDeduction Boolean🚫 Not Null - MigrationID Long Integer- -
Field Type Kind Unique UniqueID_iKeywords regular ✨ Yes MaterialIDKeywords regular - SupplierID_lKeywords regular -
Relation Name Destination Table Source → Destination State Description SuppliersEntitySuppliers SupplierID_l → SupplierID_lActive - PackagingCatsEntityPackagingCats PackagingCat → IDActive -
Relation Name Source Table Source → Destination State Description ProductPackagingSelectionProductPackaging SuppliesID → UniqueID_iActive - PurchaseInfoSelectionPurchaseInfo SuppliesID_i → UniqueID_iActive -
Generated from catalog.4DCatalog Generated at: 2025-12-04T14:33:46Z