MaterialStockTake
| 📊 Overview: 12 Fields | 4 Indexes | 1 Many-to-One Relations |
📝 Description
🗨️ Transaction table recording physical material inventory counts. Used for periodic stocktakes to verify system quantities against actual stock.
ℹ️ Table Information
- Table ID: 53
- UUID: A38A78E19EE7594CADD598417056C9D4
- Primary Key: 🔑
ID - Generated: 🕐 2025-12-04T14:34:15Z
📑 Table of Contents
- 📋 Fields (12)
- 🔍 Indexes (4)
- 🔗 Many-to-One Relations (1)
- 🔗 Related Items
📋 Fields
| Field | Type | Constraints | Description |
|---|---|---|---|
| StockTakeDate | Date | 🚫 Not Null | - |
| RMC | Long Integer | 🚫 Not Null | - |
| MatID | Integer | 🚫 Not Null | - |
| Bags | Real | 🚫 Not Null | - |
| AmountKG | Real | 🚫 Not Null | - |
| RMCID | Long Integer | 🚫 Not Null | - |
| MaterialName | String (255) | 🚫 Not Null | - |
| Location | String (255) | 🚫 Not Null | - |
| 🔑 ID | Long Integer | 🔑 PK, ✨ Unique, ⚡ Auto, 🚫 Not Null | - |
| CountedBy | String (255) | 🚫 Not Null | - |
| PrimaryStockTake | Boolean | 🚫 Not Null | - |
| SavedTimeStamp | String (255) | - | - |
🔍 Indexes
| Field | Type | Kind | Unique |
|---|---|---|---|
MatID | Keywords | regular | - |
StockTakeDate | Keywords | regular | - |
ID | Keywords | regular | ✨ Yes |
PrimaryStockTake | Keywords | regular | - |
🔗 Many-to-One Relations
| Relation Name | Destination Table | Source → Destination | State | Description |
|---|---|---|---|---|
RMCEntity | RMC | RMC → RMCNo_l | Active | - |
🔗 Related Items
📦 Classes
- MaterialStockTake - ORDA DataClass class for MaterialStockTake table
📄 Forms
- BOM_MaterialPrices - Data source for BOM_MaterialPrices form
- MaterialCalendar - Data source for MaterialCalendar form
- MaterialOutlook - Data source for MaterialOutlook form
- RMCs - Data source for RMCs form
- StockTakeInput - Data source for StockTakeInput form
Generated from catalog.4DCatalog Generated at: 2025-12-04T14:34:15Z