Supplies
| 📊 Overview: 19 Fields | 3 Indexes | 2 Many-to-One Relations | 2 One-to-Many Relations |
📝 Description
🗨️ Master data table for general supplies and consumables used in production (not raw materials). Tracks inventory levels, suppliers, and reorder points.
ℹ️ Table Information
- Table ID: 20
- UUID: B84FAAF4158D23479C7828325B99FDF5
- Primary Key: 🔑
UniqueID_i - Generated: 🕐 2025-12-04T14:33:46Z
📑 Table of Contents
- 📋 Fields (19)
- 🔍 Indexes (3)
- 🔗 Many-to-One Relations (2)
- 🔗 One-to-Many Relations (2)
- 🔗 Related Items
📋 Fields
| 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 | - | - |
🔍 Indexes
| Field | Type | Kind | Unique |
|---|---|---|---|
UniqueID_i | Keywords | regular | ✨ Yes |
MaterialID | Keywords | regular | - |
SupplierID_l | Keywords | regular | - |
🔗 Many-to-One Relations
| Relation Name | Destination Table | Source → Destination | State | Description |
|---|---|---|---|---|
SuppliersEntity | Suppliers | SupplierID_l → SupplierID_l | Active | - |
PackagingCatsEntity | PackagingCats | PackagingCat → ID | Active | - |
🔗 One-to-Many Relations
| Relation Name | Source Table | Source → Destination | State | Description |
|---|---|---|---|---|
ProductPackagingSelection | ProductPackaging | SuppliesID → UniqueID_i | Active | - |
PurchaseInfoSelection | PurchaseInfo | SuppliesID_i → UniqueID_i | Active | - |
🔗 Related Items
📦 Classes
- Supplies - ORDA DataClass class for Supplies table
- SuppliesEntity - ORDA Entity class for Supplies table
📄 Forms
- BOM_MaterialPrices - Data source for BOM_MaterialPrices form
- BOM_Packaging - Data source for BOM_Packaging form
- MaterialCalendar - Data source for MaterialCalendar form
- MaterialOutlook - Data source for MaterialOutlook form
- PackagingOptions - Data source for PackagingOptions form
- SupplyInfo - Data source for SupplyInfo form
- TransferSupply - Data source for TransferSupply form
Generated from catalog.4DCatalog Generated at: 2025-12-04T14:33:46Z