MaterialStock
| 📊 Overview: 12 Fields | 7 Indexes | 3 Many-to-One Relations |
📝 Description
🗨️ Inventory table tracking current raw material stock levels by material type, batch, and location. Updated by receipts and consumption transactions.
ℹ️ Table Information
- Table ID: 48
- UUID: C11E4B61162CA04E8020762F66A8FC50
- Primary Key: 🔑
ID - Generated: 🕐 2025-12-04T14:34:11Z
📑 Table of Contents
- 📋 Fields (12)
- 🔍 Indexes (7)
- 🔗 Many-to-One Relations (3)
- 🔗 Related Items
📋 Fields
| Field | Type | Constraints | Description |
|---|---|---|---|
| MaterialID | Long Integer | 🚫 Not Null | - |
| RMC | Long Integer | 🚫 Not Null | - |
| Location | String (255) | 🚫 Not Null | - |
| Quantity | Real | 🚫 Not Null | - |
| PalletNumber | Long Integer | 🚫 Not Null | - |
| MaterialName | String (255) | 🚫 Not Null | - |
| 🔑 ID | Long Integer | 🔑 PK, ✨ Unique, ⚡ Auto, 🚫 Not Null | - |
| LastMoveDate | Date | 🚫 Not Null | - |
| Comment | String (125) | 🚫 Not Null | - |
| LocationID | String | - | - |
| LabelsPrinted | Boolean | - | - |
| SheetsPrinted | Boolean | - | - |
🔍 Indexes
| Field | Type | Kind | Unique |
|---|---|---|---|
LabelsPrinted | Keywords | regular | - |
LocationID | Keywords | regular | - |
ID | Keywords | regular | ✨ Yes |
PalletNumber | Keywords | regular | - |
SheetsPrinted | Keywords | regular | - |
RMC | Keywords | regular | - |
MaterialID | Keywords | regular | - |
🔗 Many-to-One Relations
| Relation Name | Destination Table | Source → Destination | State | Description |
|---|---|---|---|---|
MaterialEntity | Material | MaterialID → Unique_ID | Active | - |
RMCEntity | RMC | RMC → RMCNo_l | Active | - |
LocationEntity | Location | LocationID → ID | Active | - |
🔗 Related Items
📦 Classes
- MaterialStock - ORDA DataClass class for MaterialStock table
- MaterialStockEntity - ORDA Entity class for MaterialStock table
📄 Forms
- CreateRMC - Data source for CreateRMC form
- MaterialManagement - Data source for MaterialManagement form
- RMCs - Data source for RMCs form
- StockTakeInput - Data source for StockTakeInput form
Generated from catalog.4DCatalog Generated at: 2025-12-04T14:34:11Z