com_product_stock
| # | id | userid | product_id | total_quantity | rcvd_qty | order_rcvd_qty | Order_app_qty | actual_stock_need |
|---|---|---|---|---|---|---|---|---|
| 101 | 213 | 12516 | 10 | 5 | 334 | 334 | 313 | 21 |
| 102 | 212 | 12516 | 11 | 5 | 334 | 334 | 329 | 5 |
| 103 | 187 | 12516 | 12 | 0 | 273 | 273 | 254 | 19 |
| 104 | 199 | 12516 | 13 | 28 | 72 | 72 | 44 | 28 |
| 105 | 197 | 12516 | 14 | 44 | 65 | 65 | 21 | 44 |
| 106 | 183 | 12516 | 15 | 17 | 286 | 286 | 268 | 18 |
| 107 | 185 | 12516 | 16 | 21 | 341 | 341 | 320 | 21 |
| 108 | 188 | 12516 | 17 | 33 | 377 | 377 | 344 | 33 |
| 109 | 184 | 12516 | 18 | 15 | 251 | 251 | 236 | 15 |
| 110 | 172 | 12516 | 19 | 15 | 342 | 342 | 327 | 15 |
| 111 | 158 | 12516 | 20 | 17 | 430 | 420 | 368 | 52 |
| 112 | 163 | 12516 | 21 | 7 | 15 | 15 | 8 | 7 |
| 113 | 173 | 12516 | 22 | 6 | 14 | 14 | 8 | 6 |
| 114 | 214 | 12516 | 23 | 7 | 16 | 16 | 9 | 7 |
| 115 | 181 | 12516 | 24 | 57 | 282 | 282 | 225 | 57 |
| 116 | 186 | 12516 | 25 | 37 | 298 | 298 | 261 | 37 |
| 117 | 206 | 12516 | 26 | 55 | 245 | 245 | 190 | 55 |
| 118 | 129 | 12516 | 27 | 99 | 414 | 414 | 315 | 99 |
| 119 | 193 | 12516 | 28 | 0 | 232 | 232 | 205 | 27 |
| 120 | 205 | 12516 | 29 | 10 | 112 | 112 | 102 | 10 |
| 121 | 182 | 12516 | 30 | 17 | 220 | 220 | 203 | 17 |
| 122 | 161 | 12516 | 31 | 60 | 199 | 199 | 130 | 69 |
| 123 | 191 | 12516 | 32 | 3424 | 20303 | 20303 | 15953 | 4350 |
| 124 | 179 | 12516 | 33 | 2422 | 13264 | 13264 | 10842 | 2422 |
| 125 | 180 | 12516 | 34 | 699 | 4497 | 4497 | 3798 | 699 |
| 126 | 204 | 12516 | 35 | 97 | 1772 | 1772 | 1675 | 97 |
| 127 | 211 | 12516 | 36 | 24 | 1680 | 1680 | 1656 | 24 |
| 128 | 174 | 12516 | 37 | 148 | 1225 | 1225 | 1077 | 148 |
| 129 | 170 | 12516 | 38 | 47 | 1100 | 1100 | 1053 | 47 |
| 130 | 171 | 12516 | 39 | 20 | 1069 | 1069 | 1049 | 20 |
| 131 | 165 | 12516 | 40 | 9 | 145 | 145 | 136 | 9 |
| 132 | 196 | 12516 | 41 | 8 | 276 | 276 | 268 | 8 |
| 133 | 888 | 12516 | 42 | 8 | 30 | 30 | 22 | 8 |
| 134 | 201 | 12516 | 43 | 77 | 469 | 469 | 392 | 77 |
| 135 | 300 | 12516 | 44 | 6 | 198 | 198 | 192 | 6 |
| 136 | 200 | 12516 | 45 | 0 | 16 | 16 | 16 | 0 |
| 137 | 202 | 12516 | 46 | 0 | 1060 | 859 | 856 | 3 |
| 138 | 198 | 12516 | 47 | 6 | 438 | 438 | 421 | 17 |
| 139 | 157 | 12516 | 48 | 54 | 553 | 503 | 429 | 74 |
| 140 | 299 | 12516 | 49 | 75 | 255 | 255 | 180 | 75 |
| 141 | 207 | 12516 | 50 | 68 | 354 | 354 | 286 | 68 |
| 142 | 166 | 12516 | 52 | 13 | 348 | 348 | 335 | 13 |
| 143 | 209 | 12516 | 53 | 0 | 331 | 301 | 306 | -5 |
| 144 | 215 | 12516 | 54 | 4 | 275 | 275 | 271 | 4 |
| 145 | 177 | 12516 | 55 | 70 | 213 | 213 | 143 | 70 |
| 146 | 189 | 12516 | 56 | 75 | 204 | 204 | 129 | 75 |
| 147 | 203 | 12516 | 57 | 52 | 204 | 204 | 152 | 52 |
| 148 | 176 | 12516 | 58 | 29 | 179 | 179 | 150 | 29 |
| 149 | 208 | 12516 | 59 | 5 | 6 | 6 | 1 | 5 |
| 150 | 175 | 12516 | 60 | 59 | 248 | 248 | 189 | 59 |