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

📋 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	-

📄 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