MaterialLog
| 📊 Overview: 8 Fields | 1 Indexes |
📝 Description
🗨️ Audit table recording material movements, receipts, and usage. Provides complete traceability for raw material inventory transactions.
ℹ️ Table Information
- Table ID: 74
- UUID: 7B19F335B56E4242828DF5D0077F42E6
- Primary Key: 🔑
ID - Generated: 🕐 2025-12-04T14:34:36Z
📑 Table of Contents
- 📋 Fields (8)
- 🔍 Indexes (1)
- 🔗 Related Items
- Forms (1)
📋 Fields
| Field | Type | Constraints | Description |
|---|---|---|---|
| 🔑 ID | Long Integer | 🔑 PK, ✨ Unique, ⚡ Auto | - |
| RMC | Long Integer | 🚫 Not Null | - |
| MoveDate | Date | 🚫 Not Null | - |
| From | String (255) | 🚫 Not Null | - |
| ToLocation | String (255) | 🚫 Not Null | - |
| Who | String (255) | 🚫 Not Null | - |
| PalletNumber | Integer | 🚫 Not Null | - |
| Qty | Integer | 🚫 Not Null | - |
🔍 Indexes
| Field | Type | Kind | Unique |
|---|---|---|---|
ID | Keywords | regular | ✨ Yes |
🔗 Related Items
📄 Forms
- MaterialManagement - Data source for MaterialManagement form
Generated from catalog.4DCatalog Generated at: 2025-12-04T14:34:36Z