ProductStockTake
| 📊 Overview: 7 Fields | 1 Indexes | 2 Many-to-One Relations |
📝 Description
🗨️ Transaction table recording physical finished goods inventory counts. Used for periodic stocktakes to verify system quantities against physical stock.
ℹ️ Table Information
- Table ID: 55
- UUID: CD7EC16B6973004E85CD5D29E07127D6
- Primary Key: 🔑
ID - Generated: 🕐 2025-12-04T14:34:17Z
📑 Table of Contents
- 📋 Fields (7)
- 🔍 Indexes (1)
- 🔗 Many-to-One Relations (2)
- 🔗 Related Items
- Forms (1)
📋 Fields
| Field | Type | Constraints | Description |
|---|---|---|---|
| WO | Long Integer | 🚫 Not Null | - |
| ProductID | Long Integer | 🚫 Not Null | - |
| PartsCounted | Long Integer | 🚫 Not Null | - |
| BoxesCounted | Integer | 🚫 Not Null | - |
| ActualStock | Long Integer | 🚫 Not Null | - |
| sDate | Date | 🚫 Not Null | - |
| 🔑 ID | Long Integer | 🔑 PK, ✨ Unique, ⚡ Auto, 🚫 Not Null | - |
🔍 Indexes
| Field | Type | Kind | Unique |
|---|---|---|---|
ID | B-Tree | regular | ✨ Yes |
🔗 Many-to-One Relations
| Relation Name | Destination Table | Source → Destination | State | Description |
|---|---|---|---|---|
WorksOrderEntity | WorksOrder | WO → Works_Order_No | Active | - |
ProductEntity | Product | ProductID → Product_ID | Active | - |
🔗 Related Items
📄 Forms
- ProductStockTake - Data source for ProductStockTake form
Generated from catalog.4DCatalog Generated at: 2025-12-04T14:34:17Z