+---------+----------+-----+--------+-------+-----+------+-----------+
| Bill No | totalamt | Loc | Item # | price | qty | type | ProdTotal |
+---------+----------+-----+--------+-------+-----+------+-----------+
|       1 |    10300 | S01 |    260 |  1500 |   3 | M    |      4500 |
|       1 |    10300 | S01 |    261 |  1500 |   2 | M    |      3000 |
|       1 |    10300 | S01 |     96 |   700 |   4 | 1    |      2800 |
|       2 |      540 | S02 |    260 |   140 |   1 | M    |       140 |
|       2 |      540 | S02 |    999 |    10 |   1 | 1    |        10 |
|       2 |      540 | S02 |    111 |   190 |   2 | M    |       380 |
|       2 |      540 | S02 |    888 |    10 |   1 | 1    |        10 |
|       3 |      150 | S02 |    222 |   140 |   1 | 1    |       140 |
|       3 |      150 | S02 |    999 |    10 |   1 | 1    |        10 |
|       4 |     4000 | S01 |   1054 |  1200 |   1 | M    |      1200 |
|       4 |     4000 | S01 |     96 |   700 |   1 | 1    |       700 |
|       4 |     4000 | S01 |     96 |   700 |   3 | 1    |      2100 |
|       5 |     3300 | S01 |    640 |  1200 |   1 | 1    |      1200 |
|       5 |     3300 | S01 |     96 |   700 |   3 | 1    |      2100 |
+---------+----------+-----+--------+-------+-----+------+-----------+