Table: WHSInventReserve
or
View: WHSInventReserveView
Range:
HierarchyLevel ->
0 (Item level)
1 (Site level)
2 (Warehouse level)
...
So on
Field to return value for On hand qty
AvailPhysical
Table: WHSInventReserve
or
View: WHSInventReserveView
Range:
HierarchyLevel ->
0 (Item level)
1 (Site level)
2 (Warehouse level)
...
So on
Field to return value for On hand qty
AvailPhysical
Refrence: sys.dm_db_missing_index_details (Transact-SQL) - SQL Server | Microsoft Learn