ConsignmentHistory
| 📊 Overview: 6 Fields | 1 Indexes |
📝 Description
🗨️ Audit table tracking historical changes to consignment stock levels. Records additions, usage, returns, and adjustments over time.
- Table ID: 73
- UUID: C0E7A8FCF0E83E42B41416BAD0691019
- Primary Key: 🔑
ID - Generated: 🕐 2025-12-04T14:34:35Z
📑 Table of Contents
📋 Fields
| Field | Type | Constraints | Description |
| 🔑 ID | Long Integer | 🔑 PK, ✨ Unique, ⚡ Auto | - |
| UsageDate | Date | 🚫 Not Null | - |
| FromDate | Date | 🚫 Not Null | - |
| Quantity | Long Integer | 🚫 Not Null | - |
| ProductID | Long Integer | 🚫 Not Null | - |
| Customer | String (255) | 🚫 Not Null | - |
🔍 Indexes
| Field | Type | Kind | Unique |
ID | Keywords | regular | ✨ Yes |
Generated from catalog.4DCatalog Generated at: 2025-12-04T14:34:35Z