project QadFinancials > class BMfgInventory > business logic query InventoryOnHandQtyForItem
Parameters
| icDomain | character | |
| icSite | character | |
| icPart | character | |
query condition
each in_mstr where
in_mstr.in_domain = icDomain AND
in_mstr.in_site = icSite AND
in_mstr.in_part = icPart
query resultset tqInventoryOnHandQtyForItem
| field name | data type | db field | description |
|---|
| tcin_domain | character | in_mstr.in_domain | Domain |
| tcin_part | character | in_mstr.in_part | Item Number |
| tdin_qty_nonet | decimal | in_mstr.in_qty_nonet | QOH Non-nettable |
| tdin_qty_oh | decimal | in_mstr.in_qty_oh | Qty On Hand |
| tcin_site | character | in_mstr.in_site | Site |
Internal usage
QadFinancials