Finished_Stock
| 📊 Overview: 12 Fields | 6 Indexes | 2 Many-to-One Relations |
📝 Description
🗨️ Inventory table tracking current finished goods stock levels by product and location. Updated by Stock_Movement transactions, used for availability checks and planning.
ℹ️ Table Information
- Table ID: 12
- UUID: 51AABC1ABE247B49864812D98CE6E30B
- Primary Key: 🔑
ID - Generated: 🕐 2025-12-04T14:33:39Z
📑 Table of Contents
- 📋 Fields (12)
- 🔍 Indexes (6)
- 🔗 Many-to-One Relations (2)
- 🔗 Related Items
- Forms (9)
📋 Fields
| Field | Type | Constraints | Description |
|---|---|---|---|
| FinishedStockID | Long Integer | ⚠️ Required, 🚫 Not Null | - |
| ProductID_l | Long Integer | ⚠️ Required, 🚫 Not Null | - |
| Reuse_Issue_No | String (5) | 🚫 Not Null | - |
| MaterialID | Integer | 🚫 Not Null | - |
| Stock_Quantity | Long Integer | 🚫 Not Null | - |
| Reuse_NoOfBoxes | Long Integer | 🚫 Not Null | - |
| Reuse_PartBoxQty | Long Integer | 🚫 Not Null | - |
| Reuse_WIP | Long Integer | 🚫 Not Null | - |
| LocationID_l | Long Integer | 🚫 Not Null | - |
| Works_Order_No | Long Integer | 🚫 Not Null | - |
| 🔑 ID | Long Integer | 🔑 PK, ✨ Unique, ⚡ Auto, 🚫 Not Null | - |
| Pallet_ID | Long Integer | 🚫 Not Null | - |
🔍 Indexes
| Field | Type | Kind | Unique |
|---|---|---|---|
ID | Keywords | regular | ✨ Yes |
LocationID_l | Keywords | regular | - |
ProductID_l | Keywords | regular | - |
Works_Order_No | Keywords | regular | - |
FinishedStockID | Keywords | regular | - |
MaterialID | Keywords | regular | - |
🔗 Many-to-One Relations
| Relation Name | Destination Table | Source → Destination | State | Description |
|---|---|---|---|---|
WorksOrderEntity | WorksOrder | Works_Order_No → Works_Order_No | Active | - |
Stock_LocationEntity | Stock_Location | LocationID_l → StockLocationID_l | Active | - |
🔗 Related Items
📄 Forms
- %2AStockControl - Data source for %2AStockControl form
- CancelAdviceNote - Data source for CancelAdviceNote form
- ConsignmentCallOff - Data source for ConsignmentCallOff form
- ConsignmentSSLs - Data source for ConsignmentSSLs form
- OrderDelivery - Data source for OrderDelivery form
- OrderOverview - Data source for OrderOverview form
- ProductStockTake - Data source for ProductStockTake form
- QuarantineManager - Data source for QuarantineManager form
- SNRSUMMARY - Data source for SNRSUMMARY form
Generated from catalog.4DCatalog Generated at: 2025-12-04T14:33:39Z