fx_franchise_order
| # | id | orderid | invoice_no | userid | shopee_id | purchase_type | product_type | total_quantity | total_amount | comm_per | dicount_comm | total_cgst_amt | total_sgst_amount | total_igst_amount | final_amount | _currency | total_bv | total_pv | total_sv | payment_type | order_by | created_on | delivery_status | delivered_on | admin_status | admin_processed_on | processed_by | receipt_path | payment_ref_no | fran_comm_status | fran_comm_credited_on |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 351 | 361 | POF-1351 | INVF-1351 | 12516 | 1 | 2 | 2 | 20 | 209980.0 | 0.0 | 16798.4 | 4999.52 | 4999.52 | 0.0 | 193181.6 | INR | 0.0 | 70000.0 | 0.0 | 4 | 12516 | 2025-12-14 15:52:13 | 0 | NULL | 1 | 2025-12-14 15:52:45 | 1 | 0 | NULL | ||
| 352 | 362 | POF-1352 | INVF-1352 | 12518 | 12517 | 2 | 1 | 101 | 72639.2 | 0.0 | 1452.78 | 1729.51 | 1729.51 | 0.0 | 71186.42 | INR | 0.0 | 50.5 | 0.0 | 4 | 12518 | 2025-12-16 15:39:27 | 0 | NULL | 2 | 2025-12-19 21:07:15 | 12517 | 0 | NULL | ||
| 353 | 363 | POF-1353 | INVF-1353 | 12555 | 12554 | 2 | 1 | 10 | 7192.0 | 0.0 | 143.84 | 171.24 | 171.24 | 0.0 | 7048.16 | INR | 0.0 | 5.0 | 0.0 | 4 | 12555 | 2025-12-16 16:37:33 | 0 | NULL | 1 | 2025-12-16 16:37:50 | 12554 | 0 | NULL | ||
| 354 | 364 | POF-1354 | INVF-1354 | 12516 | 1 | 2 | 1 | 20 | 209988.0 | 0.0 | 16799.04 | 3058.07 | 3058.07 | 0.0 | 193188.96 | INR | 0.0 | 30.0 | 0.0 | 4 | 12516 | 2025-12-17 12:02:36 | 0 | NULL | 1 | 2025-12-21 11:38:03 | 1 | 0 | NULL | ||
| 355 | 365 | POF-1355 | INVF-1355 | 12516 | 1 | 2 | 1 | 20 | 209988.0 | 0.0 | 16799.04 | 3058.07 | 3058.07 | 0.0 | 193188.96 | INR | 0.0 | 30.0 | 0.0 | 4 | 12516 | 2025-12-17 12:08:01 | 0 | NULL | 1 | 2025-12-17 12:09:09 | 1 | 0 | NULL | ||
| 356 | 366 | POF-1356 | INVF-1356 | 12554 | 12516 | 2 | 1 | 20 | 209988.0 | 0.0 | 10499.4 | 3058.07 | 3058.07 | 0.0 | 199488.6 | INR | 0.0 | 30.0 | 0.0 | 4 | 12554 | 2025-12-17 12:10:20 | 0 | NULL | 1 | 2025-12-17 12:11:02 | 12516 | 0 | NULL | ||
| 357 | 367 | POF-1357 | INVF-1357 | 12555 | 12554 | 2 | 1 | 20 | 209988.0 | 0.0 | 4199.76 | 3058.07 | 3058.07 | 0.0 | 205788.24 | INR | 0.0 | 30.0 | 0.0 | 4 | 12555 | 2025-12-17 12:12:24 | 0 | NULL | 1 | 2025-12-17 12:14:00 | 12554 | 0 | NULL | ||
| 358 | 368 | POF-1358 | INVF-1358 | 12555 | 12554 | 2 | 1 | 8 | 78595.2 | 0.0 | 1571.9 | 1144.59 | 1144.59 | 0.0 | 77023.3 | INR | 0.0 | 9.0 | 0.0 | 4 | 12555 | 2025-12-17 12:13:42 | 0 | NULL | 2 | 2025-12-23 20:09:52 | 12554 | 0 | NULL | ||
| 359 | 369 | POF-1359 | INVF-1359 | 12555 | 12554 | 2 | 1 | 10 | 7992.0 | 0.0 | 159.84 | 609.56 | 609.56 | 0.0 | 7832.16 | INR | 0.0 | 5.0 | 0.0 | 4 | 12555 | 2025-12-17 13:54:51 | 0 | NULL | 1 | 2025-12-17 13:55:08 | 12554 | 0 | NULL | ||
| 360 | 370 | POF-1360 | INVF-1360 | 12555 | 12554 | 2 | 1 | 100 | 79920.0 | 0.0 | 1598.4 | 6095.59 | 6095.59 | 0.0 | 78321.6 | INR | 0.0 | 50.0 | 0.0 | 4 | 12555 | 2025-12-17 14:55:12 | 0 | NULL | 1 | 2025-12-17 14:56:36 | 12554 | 0 | NULL | ||
| 361 | 371 | POF-1361 | INVF-1361 | 12554 | 12516 | 2 | 1 | 100 | 79920.0 | 0.0 | 3996.0 | 6095.59 | 6095.59 | 0.0 | 75924.0 | INR | 0.0 | 50.0 | 0.0 | 4 | 12554 | 2025-12-17 14:55:38 | 0 | NULL | 1 | 2025-12-17 14:56:20 | 12516 | 0 | NULL | ||
| 362 | 372 | POF-1362 | INVF-1362 | 12516 | 1 | 2 | 1 | 100 | 79920.0 | 0.0 | 6393.6 | 6095.59 | 6095.59 | 0.0 | 73526.4 | INR | 0.0 | 50.0 | 0.0 | 4 | 12516 | 2025-12-17 14:55:58 | 0 | NULL | 1 | 2025-12-17 14:56:10 | 1 | 0 | NULL | ||
| 363 | 373 | POF-1363 | INVF-1363 | 12555 | 12554 | 2 | 1 | 60 | 62400.0 | 0.0 | 1248.0 | 1485.7 | 1485.7 | 0.0 | 61152.0 | INR | 0.0 | 5.0 | 0.0 | 4 | 12555 | 2025-12-17 21:29:33 | 0 | NULL | 1 | 2025-12-18 11:39:33 | 12554 | 0 | NULL | ||
| 364 | 374 | POF-1364 | INVF-1364 | 12516 | 1 | 2 | 1 | 800 | 698000.0 | 0.0 | 55840.0 | 19242.14 | 19242.14 | 0.0 | 642160.0 | INR | 0.0 | 50.0 | 0.0 | 4 | 12516 | 2025-12-17 21:41:08 | 0 | NULL | 1 | 2025-12-17 21:41:31 | 1 | 0 | NULL | ||
| 365 | 375 | POF-1365 | INVF-1365 | 12554 | 12516 | 2 | 1 | 450 | 409000.0 | 0.0 | 20450.0 | 11049.62 | 11049.62 | 0.0 | 388550.0 | INR | 0.0 | 25.0 | 0.0 | 4 | 12554 | 2025-12-17 21:44:19 | 0 | NULL | 1 | 2025-12-17 21:46:23 | 12516 | 0 | NULL | ||
| 366 | 376 | POF-1366 | INVF-1366 | 12516 | 1 | 2 | 1 | 100 | 120000.0 | 0.0 | 9600.0 | 2857.14 | 2857.14 | 0.0 | 110400.0 | INR | 0.0 | 100.0 | 0.0 | 4 | 12516 | 2025-12-17 21:45:35 | 0 | NULL | 1 | 2025-12-17 21:45:55 | 1 | 0 | NULL | ||
| 367 | 377 | POF-1367 | INVF-1367 | 12555 | 12554 | 2 | 1 | 700 | 674000.0 | 0.0 | 13480.0 | 18670.7 | 18670.7 | 0.0 | 660520.0 | INR | 0.0 | 50.0 | 0.0 | 4 | 12555 | 2025-12-17 21:53:22 | 0 | NULL | 1 | 2025-12-18 08:23:47 | 12554 | 0 | NULL | ||
| 368 | 378 | POF-1368 | INVF-1368 | 12555 | 12554 | 2 | 1 | 410 | 374000.0 | 0.0 | 7480.0 | 11527.84 | 11527.84 | 0.0 | 366520.0 | INR | 0.0 | 25.0 | 0.0 | 4 | 12555 | 2025-12-18 08:12:33 | 0 | NULL | 2 | 2025-12-18 13:38:10 | 12554 | 0 | NULL | ||
| 369 | 379 | POF-1369 | INVF-1369 | 12554 | 12516 | 2 | 1 | 700 | 674000.0 | 0.0 | 33700.0 | 18670.7 | 18670.7 | 0.0 | 640300.0 | INR | 0.0 | 50.0 | 0.0 | 4 | 12554 | 2025-12-18 08:16:30 | 0 | NULL | 1 | 2025-12-18 08:23:04 | 12516 | 0 | NULL | ||
| 370 | 380 | POF-1370 | INVF-1370 | 12516 | 1 | 2 | 1 | 700 | 674000.0 | 0.0 | 53920.0 | 18670.7 | 18670.7 | 0.0 | 620080.0 | INR | 0.0 | 50.0 | 0.0 | 4 | 12516 | 2025-12-18 08:18:58 | 0 | NULL | 1 | 2025-12-18 08:22:30 | 1 | 0 | NULL | ||
| 371 | 381 | POF-1371 | INVF-1371 | 12555 | 12554 | 2 | 1 | 40 | 28800.0 | 0.0 | 576.0 | 685.71 | 685.71 | 0.0 | 28224.0 | INR | 0.0 | 20.0 | 0.0 | 4 | 12555 | 2025-12-18 11:38:57 | 0 | NULL | 1 | 2025-12-18 11:39:26 | 12554 | 0 | NULL | ||
| 372 | 382 | POF-1372 | INVF-1372 | 12555 | 12554 | 2 | 1 | 50 | 25000.0 | 0.0 | 500.0 | 1906.78 | 1906.78 | 0.0 | 24500.0 | INR | 0.0 | 25.0 | 0.0 | 4 | 12555 | 2025-12-18 15:30:09 | 0 | NULL | 1 | 2025-12-18 15:30:20 | 12554 | 0 | NULL | ||
| 373 | 383 | POF-1373 | INVF-1373 | 12554 | 12516 | 2 | 1 | 100 | 50000.0 | 0.0 | 2500.0 | 3813.56 | 3813.56 | 0.0 | 47500.0 | INR | 0.0 | 50.0 | 0.0 | 4 | 12554 | 2025-12-18 17:03:38 | 0 | NULL | 1 | 2025-12-18 17:04:00 | 12516 | 0 | NULL | ||
| 374 | 384 | POF-1374 | INVF-1374 | 12555 | 12554 | 2 | 1 | 100 | 50000.0 | 0.0 | 1000.0 | 3813.56 | 3813.56 | 0.0 | 49000.0 | INR | 0.0 | 50.0 | 0.0 | 4 | 12555 | 2025-12-18 17:04:29 | 0 | NULL | 1 | 2025-12-18 17:04:40 | 12554 | 0 | NULL | ||
| 375 | 385 | POF-1375 | INVF-1375 | 12516 | 1 | 2 | 1 | 200 | 100000.0 | 0.0 | 8000.0 | 7627.12 | 7627.12 | 0.0 | 92000.0 | INR | 0.0 | 100.0 | 0.0 | 4 | 12516 | 2025-12-18 18:35:31 | 0 | NULL | 1 | 2025-12-18 18:37:23 | 1 | 0 | NULL | ||
| 376 | 386 | POF-1376 | INVF-1376 | 12554 | 12516 | 2 | 1 | 200 | 100000.0 | 0.0 | 5000.0 | 7627.12 | 7627.12 | 0.0 | 95000.0 | INR | 0.0 | 100.0 | 0.0 | 4 | 12554 | 2025-12-18 18:37:45 | 0 | NULL | 1 | 2025-12-18 18:38:00 | 12516 | 0 | NULL | ||
| 377 | 387 | POF-1377 | INVF-1377 | 12555 | 12554 | 2 | 1 | 200 | 100000.0 | 0.0 | 2000.0 | 7627.12 | 7627.12 | 0.0 | 98000.0 | INR | 0.0 | 100.0 | 0.0 | 4 | 12555 | 2025-12-18 18:38:26 | 0 | NULL | 1 | 2025-12-18 18:38:42 | 12554 | 0 | NULL | ||
| 378 | 388 | POF-1378 | INVF-1378 | 12516 | 1 | 2 | 1 | 100 | 72000.0 | 0.0 | 5760.0 | 1714.29 | 1714.29 | 0.0 | 66240.0 | INR | 0.0 | 50.0 | 0.0 | 4 | 12516 | 2025-12-18 18:54:57 | 0 | NULL | 1 | 2025-12-18 18:55:06 | 1 | 0 | NULL | ||
| 379 | 389 | POF-1379 | INVF-1379 | 12554 | 12516 | 2 | 1 | 100 | 72000.0 | 0.0 | 3600.0 | 1714.29 | 1714.29 | 0.0 | 68400.0 | INR | 0.0 | 50.0 | 0.0 | 4 | 12554 | 2025-12-18 18:55:22 | 0 | NULL | 1 | 2025-12-18 18:55:56 | 12516 | 0 | NULL | ||
| 380 | 390 | POF-1380 | INVF-1380 | 12555 | 12554 | 2 | 1 | 50 | 36000.0 | 0.0 | 720.0 | 857.14 | 857.14 | 0.0 | 35280.0 | INR | 0.0 | 25.0 | 0.0 | 4 | 12555 | 2025-12-18 18:55:44 | 0 | NULL | 1 | 2025-12-18 18:56:09 | 12554 | 0 | NULL | ||
| 381 | 391 | POF-1381 | INVF-1381 | 12555 | 12554 | 2 | 1 | 50 | 25000.0 | 0.0 | 500.0 | 1906.78 | 1906.78 | 0.0 | 24500.0 | INR | 0.0 | 25.0 | 0.0 | 4 | 12555 | 2025-12-19 08:19:38 | 0 | NULL | 1 | 2025-12-19 08:26:48 | 12554 | 0 | NULL | ||
| 382 | 392 | POF-1382 | INVF-1382 | 12516 | 1 | 2 | 1 | 600 | 322000.0 | 0.0 | 25760.0 | 20782.09 | 20782.09 | 0.0 | 296240.0 | INR | 0.0 | 50.0 | 0.0 | 4 | 12516 | 2025-12-19 08:20:54 | 0 | NULL | 1 | 2025-12-19 08:22:29 | 1 | 0 | NULL | ||
| 383 | 393 | POF-1383 | INVF-1383 | 12554 | 12516 | 2 | 1 | 500 | 272000.0 | 0.0 | 13600.0 | 16968.53 | 16968.53 | 0.0 | 258400.0 | INR | 0.0 | 50.0 | 0.0 | 4 | 12554 | 2025-12-19 08:23:11 | 0 | NULL | 1 | 2025-12-19 08:26:08 | 12516 | 0 | NULL | ||
| 384 | 394 | POF-1384 | INVF-1384 | 12555 | 12554 | 2 | 1 | 450 | 247000.0 | 0.0 | 4940.0 | 15061.75 | 15061.75 | 0.0 | 242060.0 | INR | 0.0 | 50.0 | 0.0 | 4 | 12555 | 2025-12-19 08:25:03 | 0 | NULL | 2 | 2025-12-19 08:26:43 | 12554 | 0 | NULL | ||
| 385 | 395 | POF-1385 | INVF-1385 | 12555 | 12554 | 2 | 1 | 450 | 247000.0 | 0.0 | 4940.0 | 15061.75 | 15061.75 | 0.0 | 242060.0 | INR | 0.0 | 50.0 | 0.0 | 4 | 12555 | 2025-12-19 08:25:38 | 0 | NULL | 1 | 2025-12-19 08:26:37 | 12554 | 0 | NULL | ||
| 386 | 396 | POF-1386 | INVF-1386 | 12555 | 12554 | 2 | 1 | 600 | 322000.0 | 0.0 | 6440.0 | 20782.08 | 20782.08 | 0.0 | 315560.0 | INR | 0.0 | 25.0 | 0.0 | 4 | 12555 | 2025-12-19 13:12:41 | 0 | NULL | 1 | 2025-12-19 13:25:06 | 12554 | 0 | NULL | ||
| 387 | 397 | POF-1387 | INVF-1387 | 12554 | 12516 | 2 | 1 | 500 | 250000.0 | 0.0 | 12500.0 | 19067.8 | 19067.8 | 0.0 | 237500.0 | INR | 0.0 | 250.0 | 0.0 | 4 | 12554 | 2025-12-19 13:21:26 | 0 | NULL | 1 | 2025-12-19 13:24:46 | 12516 | 0 | NULL | ||
| 388 | 398 | POF-1388 | INVF-1388 | 12554 | 12516 | 2 | 1 | 100 | 72000.0 | 0.0 | 3600.0 | 1714.28 | 1714.28 | 0.0 | 68400.0 | INR | 0.0 | 25.0 | 0.0 | 4 | 12554 | 2025-12-19 13:21:57 | 0 | NULL | 1 | 2025-12-19 13:24:52 | 12516 | 0 | NULL | ||
| 389 | 399 | POF-1389 | INVF-1389 | 12516 | 1 | 2 | 1 | 600 | 322000.0 | 0.0 | 25760.0 | 20782.08 | 20782.08 | 0.0 | 296240.0 | INR | 0.0 | 25.0 | 0.0 | 4 | 12516 | 2025-12-19 13:22:48 | 0 | NULL | 1 | 2025-12-19 13:24:30 | 1 | 0 | NULL | ||
| 390 | 400 | POF-1390 | INVF-1390 | 12555 | 12554 | 2 | 1 | 400 | 200000.0 | 0.0 | 4000.0 | 15254.24 | 15254.24 | 0.0 | 196000.0 | INR | 0.0 | 200.0 | 0.0 | 4 | 12555 | 2025-12-19 18:45:44 | 0 | NULL | 1 | 2025-12-19 18:47:55 | 12554 | 0 | NULL | ||
| 391 | 401 | POF-1391 | INVF-1391 | 12554 | 12516 | 2 | 1 | 400 | 200000.0 | 0.0 | 10000.0 | 15254.24 | 15254.24 | 0.0 | 190000.0 | INR | 0.0 | 200.0 | 0.0 | 4 | 12554 | 2025-12-19 18:46:10 | 0 | NULL | 1 | 2025-12-19 18:47:35 | 12516 | 0 | NULL | ||
| 392 | 402 | POF-1392 | INVF-1392 | 12516 | 1 | 2 | 1 | 400 | 200000.0 | 0.0 | 16000.0 | 15254.24 | 15254.24 | 0.0 | 184000.0 | INR | 0.0 | 200.0 | 0.0 | 4 | 12516 | 2025-12-19 18:46:31 | 0 | NULL | 1 | 2025-12-19 18:47:13 | 1 | 0 | NULL | ||
| 393 | 403 | POF-1393 | INVF-1393 | 12516 | 1 | 2 | 1 | 100 | 72000.0 | 0.0 | 5760.0 | 1714.29 | 1714.29 | 0.0 | 66240.0 | INR | 0.0 | 50.0 | 0.0 | 4 | 12516 | 2025-12-19 20:45:46 | 0 | NULL | 1 | 2025-12-19 20:48:41 | 1 | 0 | NULL | ||
| 394 | 404 | POF-1394 | INVF-1394 | 12554 | 12516 | 2 | 1 | 100 | 72000.0 | 0.0 | 3600.0 | 1714.29 | 1714.29 | 0.0 | 68400.0 | INR | 0.0 | 50.0 | 0.0 | 4 | 12554 | 2025-12-19 20:46:36 | 0 | NULL | 1 | 2025-12-19 20:49:12 | 12516 | 0 | NULL | ||
| 395 | 405 | POF-1395 | INVF-1395 | 12555 | 12554 | 2 | 1 | 100 | 72000.0 | 0.0 | 1440.0 | 1714.29 | 1714.29 | 0.0 | 70560.0 | INR | 0.0 | 50.0 | 0.0 | 4 | 12555 | 2025-12-19 20:47:30 | 0 | NULL | 1 | 2025-12-19 20:49:38 | 12554 | 0 | NULL | ||
| 396 | 406 | POF-1396 | INVF-1396 | 12554 | 12516 | 2 | 1 | 30 | 36000.0 | 0.0 | 1800.0 | 857.14 | 857.14 | 0.0 | 34200.0 | INR | 0.0 | 30.0 | 0.0 | 4 | 12554 | 2025-12-19 22:26:44 | 0 | NULL | 1 | 2025-12-19 22:28:01 | 12516 | 0 | NULL | ||
| 397 | 407 | POF-1397 | INVF-1397 | 12516 | 1 | 2 | 1 | 50 | 60000.0 | 0.0 | 4800.0 | 1428.57 | 1428.57 | 0.0 | 55200.0 | INR | 0.0 | 50.0 | 0.0 | 4 | 12516 | 2025-12-19 22:27:41 | 0 | NULL | 1 | 2025-12-19 22:27:51 | 1 | 0 | NULL | ||
| 398 | 408 | POF-1398 | INVF-1398 | 12555 | 12554 | 2 | 1 | 50 | 60000.0 | 0.0 | 1200.0 | 1428.57 | 1428.57 | 0.0 | 58800.0 | INR | 0.0 | 50.0 | 0.0 | 4 | 12555 | 2025-12-19 22:28:59 | 0 | NULL | 1 | 2025-12-19 22:35:04 | 12554 | 0 | NULL | ||
| 399 | 409 | POF-1399 | INVF-1399 | 12554 | 12516 | 2 | 1 | 50 | 60000.0 | 0.0 | 3000.0 | 1428.57 | 1428.57 | 0.0 | 57000.0 | INR | 0.0 | 50.0 | 0.0 | 4 | 12554 | 2025-12-19 22:30:32 | 0 | NULL | 1 | 2025-12-19 22:30:45 | 12516 | 0 | NULL | ||
| 400 | 410 | POF-1400 | INVF-1400 | 12516 | 1 | 2 | 1 | 50 | 60000.0 | 0.0 | 4800.0 | 1428.57 | 1428.57 | 0.0 | 55200.0 | INR | 0.0 | 50.0 | 0.0 | 4 | 12516 | 2025-12-19 22:32:59 | 0 | NULL | 1 | 2025-12-19 22:33:10 | 1 | 0 | NULL |