I have created a Inventory transfer request with batch items. For example, item A with quantity 3 (batch 1 x 1; batch 2 x 2). Then I copy to Inventory transfer with one item A (batch 2). The open quantity for the item A in ITR is 2 (batch 1 x 1; batch 2 x 1).
Which SQL table should I look for to obtain the open quantity for each batch (batch 1 x 1; batch 2 x 1)?