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

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

📄 Forms

ProductStockTake - Data source for ProductStockTake form

Generated from catalog.4DCatalog Generated at: 2025-12-04T14:34:17Z