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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 451 | 461 | POF-1451 | INVF-1451 | 12516 | 1 | 2 | 1 | 30 | 239400.0 | 0.0 | 19152.0 | 3486.41 | 3486.41 | 0.0 | 220248.0 | INR | 0.0 | 60.0 | 0.0 | 4 | 12516 | 2025-12-26 11:03:16 | 0 | NULL | 1 | 2025-12-26 11:03:26 | 1 | 0 | NULL | ||
| 452 | 462 | POF-1452 | INVF-1452 | 12554 | 12516 | 2 | 1 | 20 | 159600.0 | 0.0 | 7980.0 | 2324.27 | 2324.27 | 0.0 | 151620.0 | INR | 0.0 | 40.0 | 0.0 | 4 | 12554 | 2025-12-26 11:03:51 | 0 | NULL | 1 | 2025-12-26 11:04:26 | 12516 | 0 | NULL | ||
| 453 | 463 | POF-1453 | INVF-1453 | 12555 | 12554 | 2 | 1 | 20 | 159600.0 | 0.0 | 3192.0 | 2324.27 | 2324.27 | 0.0 | 156408.0 | INR | 0.0 | 40.0 | 0.0 | 4 | 12555 | 2025-12-26 11:04:14 | 0 | NULL | 1 | 2025-12-26 11:04:40 | 12554 | 0 | NULL | ||
| 454 | 464 | POF-1454 | INVF-1454 | 12555 | 12554 | 2 | 1 | 10 | 7190.0 | 0.0 | 143.8 | 171.19 | 171.19 | 0.0 | 7046.2 | INR | 0.0 | 1.5 | 0.0 | 4 | 12555 | 2025-12-26 12:33:09 | 0 | NULL | 1 | 2025-12-26 12:33:24 | 12554 | 0 | NULL | ||
| 455 | 465 | POF-1455 | INVF-1455 | 12555 | 12554 | 2 | 1 | 100 | 15900.0 | 0.0 | 318.0 | 1212.71 | 1212.71 | 0.0 | 15582.0 | INR | 0.0 | 2.5 | 0.0 | 4 | 12555 | 2025-12-26 12:42:38 | 0 | NULL | 1 | 2025-12-26 12:42:49 | 12554 | 0 | NULL | ||
| 456 | 466 | POF-1456 | INVF-1456 | 12542 | 12554 | 2 | 1 | 53 | 2544.0 | 0.0 | 50.88 | 0.0 | 0.0 | 121.14 | 2493.12 | INR | 0.0 | 0.32 | 0.0 | 4 | 12542 | 2025-12-26 13:42:23 | 0 | NULL | 1 | 2025-12-26 13:42:53 | 12554 | 0 | NULL | ||
| 457 | 467 | POF-1457 | INVF-1457 | 12555 | 12554 | 2 | 1 | 300 | 14400.0 | 0.0 | 288.0 | 342.86 | 342.86 | 0.0 | 14112.0 | INR | 0.0 | 1.8 | 0.0 | 4 | 12555 | 2025-12-26 15:16:48 | 0 | NULL | 1 | 2025-12-26 15:17:08 | 12554 | 0 | NULL | ||
| 458 | 468 | POF-1458 | INVF-1458 | 12555 | 12554 | 2 | 1 | 10 | 12000.0 | 0.0 | 240.0 | 285.71 | 285.71 | 0.0 | 11760.0 | INR | 0.0 | 2.5 | 0.0 | 4 | 12555 | 2025-12-26 15:40:10 | 0 | NULL | 1 | 2025-12-26 15:40:23 | 12554 | 0 | NULL | ||
| 459 | 469 | POF-1459 | INVF-1459 | 12555 | 12554 | 2 | 1 | 50 | 15200.0 | 0.0 | 304.0 | 0.0 | 0.0 | 0.0 | 14896.0 | INR | 0.0 | 2.5 | 0.0 | 4 | 12555 | 2025-12-26 15:55:05 | 0 | NULL | 1 | 2025-12-26 15:56:46 | 12554 | 0 | NULL | ||
| 460 | 470 | POF-1460 | INVF-1460 | 12554 | 12516 | 2 | 1 | 50 | 15200.0 | 0.0 | 760.0 | 0.0 | 0.0 | 0.0 | 14440.0 | INR | 0.0 | 2.5 | 0.0 | 4 | 12554 | 2025-12-26 15:55:39 | 0 | NULL | 1 | 2025-12-26 15:56:32 | 12516 | 0 | NULL | ||
| 461 | 471 | POF-1461 | INVF-1461 | 12516 | 1 | 2 | 1 | 50 | 15200.0 | 0.0 | 1216.0 | 0.0 | 0.0 | 0.0 | 13984.0 | INR | 0.0 | 2.5 | 0.0 | 4 | 12516 | 2025-12-26 15:56:11 | 0 | NULL | 1 | 2025-12-26 15:56:20 | 1 | 0 | NULL | ||
| 462 | 472 | POF-1462 | INVF-1462 | 12554 | 12516 | 2 | 1 | 20 | 11180.0 | 0.0 | 559.0 | 266.19 | 266.19 | 0.0 | 10621.0 | INR | 0.0 | 2.2 | 0.0 | 4 | 12554 | 2025-12-26 15:58:24 | 0 | NULL | 1 | 2025-12-26 16:00:55 | 12516 | 0 | NULL | ||
| 463 | 473 | POF-1463 | INVF-1463 | 12516 | 1 | 2 | 1 | 50 | 27950.0 | 0.0 | 2236.0 | 665.48 | 665.48 | 0.0 | 25714.0 | INR | 0.0 | 5.5 | 0.0 | 4 | 12516 | 2025-12-26 16:00:38 | 0 | NULL | 1 | 2025-12-26 16:00:46 | 1 | 0 | NULL | ||
| 464 | 474 | POF-1464 | INVF-1464 | 12555 | 12554 | 2 | 1 | 30 | 16770.0 | 0.0 | 335.4 | 399.29 | 399.29 | 0.0 | 16434.6 | INR | 0.0 | 3.3 | 0.0 | 4 | 12555 | 2025-12-26 16:01:33 | 0 | NULL | 1 | 2025-12-26 16:04:45 | 12554 | 0 | NULL | ||
| 465 | 475 | POF-1465 | INVF-1465 | 12554 | 12516 | 2 | 1 | 30 | 16770.0 | 0.0 | 838.5 | 399.29 | 399.29 | 0.0 | 15931.5 | INR | 0.0 | 3.3 | 0.0 | 4 | 12554 | 2025-12-26 16:02:44 | 0 | NULL | 1 | 2025-12-26 16:04:33 | 12516 | 0 | NULL | ||
| 466 | 476 | POF-1466 | INVF-1466 | 12551 | 12516 | 2 | 1 | 3 | 23940.0 | 0.0 | 1197.0 | 348.64 | 348.64 | 0.0 | 22743.0 | INR | 0.0 | 6.0 | 0.0 | 4 | 12551 | 2025-12-26 17:15:52 | 0 | NULL | 1 | 2025-12-26 17:16:08 | 12516 | 0 | NULL | ||
| 467 | 477 | POF-1467 | INVF-1467 | 12555 | 12554 | 2 | 1 | 10 | 3190.0 | 0.0 | 63.8 | 75.95 | 75.95 | 0.0 | 3126.2 | INR | 0.0 | 0.5 | 0.0 | 4 | 12555 | 2025-12-26 18:10:18 | 0 | NULL | 1 | 2025-12-26 18:10:30 | 12554 | 0 | NULL | ||
| 468 | 478 | POF-1468 | INVF-1468 | 13438 | 12554 | 2 | 1 | 1 | 559.0 | 0.0 | 11.18 | 0.0 | 0.0 | 85.27 | 547.82 | INR | 0.0 | 0.11 | 0.0 | 4 | 13438 | 2025-12-26 19:17:59 | 0 | NULL | 1 | 2025-12-26 19:33:53 | 12554 | 0 | NULL | ||
| 469 | 479 | POF-1469 | INVF-1469 | 13438 | 12554 | 2 | 1 | 1 | 260.0 | 0.0 | 5.2 | 0.0 | 0.0 | 39.66 | 254.8 | INR | 0.0 | 0.02 | 0.0 | 4 | 13438 | 2025-12-26 19:18:39 | 0 | NULL | 1 | 2025-12-26 19:39:37 | 12554 | 0 | NULL | ||
| 470 | 480 | POF-1470 | INVF-1470 | 12554 | 12516 | 2 | 1 | 1 | 260.0 | 0.0 | 13.0 | 19.83 | 19.83 | 0.0 | 247.0 | INR | 0.0 | 0.02 | 0.0 | 4 | 12554 | 2025-12-26 19:34:29 | 0 | NULL | 1 | 2025-12-26 19:35:04 | 12516 | 0 | NULL | ||
| 471 | 481 | POF-1471 | INVF-1471 | 13438 | 12554 | 2 | 1 | 2 | 318.0 | 0.0 | 6.36 | 0.0 | 0.0 | 15.14 | 311.64 | INR | 0.0 | 0.03 | 0.0 | 4 | 13438 | 2025-12-26 19:41:37 | 0 | NULL | 1 | 2025-12-26 19:49:59 | 12554 | 0 | NULL | ||
| 472 | 482 | POF-1472 | INVF-1472 | 13438 | 12554 | 2 | 1 | 1 | 720.0 | 0.0 | 14.4 | 0.0 | 0.0 | 34.29 | 705.6 | INR | 0.0 | 0.15 | 0.0 | 4 | 13438 | 2025-12-26 19:42:11 | 0 | NULL | 1 | 2025-12-26 19:42:36 | 12554 | 0 | NULL | ||
| 473 | 483 | POF-1473 | INVF-1473 | 12554 | 12516 | 2 | 1 | 30 | 4770.0 | 0.0 | 238.5 | 113.57 | 113.57 | 0.0 | 4531.5 | INR | 0.0 | 0.45 | 0.0 | 4 | 12554 | 2025-12-26 19:43:02 | 0 | NULL | 1 | 2025-12-26 19:43:25 | 12516 | 0 | NULL | ||
| 474 | 484 | POF-1474 | INVF-1474 | 13438 | 12554 | 2 | 1 | 2 | 558.0 | 0.0 | 11.16 | 0.0 | 0.0 | 26.57 | 546.84 | INR | 0.0 | 0.1 | 0.0 | 4 | 13438 | 2025-12-26 19:48:42 | 0 | NULL | 1 | 2025-12-26 20:02:53 | 12554 | 0 | NULL | ||
| 475 | 485 | POF-1475 | INVF-1475 | 12554 | 12516 | 2 | 1 | 20 | 4830.0 | 0.0 | 241.5 | 115.0 | 115.0 | 0.0 | 4588.5 | INR | 0.0 | 0.4 | 0.0 | 4 | 12554 | 2025-12-26 19:51:05 | 0 | NULL | 1 | 2025-12-26 19:51:23 | 12516 | 0 | NULL | ||
| 476 | 486 | POF-1476 | INVF-1476 | 13438 | 12554 | 2 | 1 | 2 | 408.0 | 0.0 | 8.16 | 0.0 | 0.0 | 19.43 | 399.84 | INR | 0.0 | 0.08 | 0.0 | 4 | 13438 | 2025-12-26 19:56:40 | 0 | NULL | 1 | 2025-12-26 20:02:59 | 12554 | 0 | NULL | ||
| 477 | 487 | POF-1477 | INVF-1477 | 13438 | 12554 | 2 | 1 | 2 | 558.0 | 0.0 | 11.16 | 0.0 | 0.0 | 26.57 | 546.84 | INR | 0.0 | 0.1 | 0.0 | 4 | 13438 | 2025-12-26 19:57:05 | 0 | NULL | 1 | 2025-12-26 20:02:59 | 12554 | 0 | NULL | ||
| 478 | 488 | POF-1478 | INVF-1478 | 13438 | 12554 | 2 | 1 | 1 | 304.0 | 0.0 | 6.08 | 0.0 | 0.0 | 0.0 | 297.92 | INR | 0.0 | 0.05 | 0.0 | 4 | 13438 | 2025-12-26 20:18:03 | 0 | NULL | 1 | 2025-12-26 20:31:21 | 12554 | 0 | NULL | ||
| 479 | 489 | POF-1479 | INVF-1479 | 13438 | 12554 | 2 | 1 | 1 | 260.0 | 0.0 | 5.2 | 0.0 | 0.0 | 39.66 | 254.8 | INR | 0.0 | 0.02 | 0.0 | 4 | 13438 | 2025-12-26 20:21:34 | 0 | NULL | 1 | 2025-12-26 20:45:31 | 12554 | 0 | NULL | ||
| 480 | 490 | POF-1480 | INVF-1480 | 12554 | 12516 | 2 | 1 | 10 | 2600.0 | 0.0 | 130.0 | 198.31 | 198.31 | 0.0 | 2470.0 | INR | 0.0 | 0.21 | 0.0 | 4 | 12554 | 2025-12-26 20:31:42 | 0 | NULL | 1 | 2025-12-26 20:32:10 | 12516 | 0 | NULL | ||
| 481 | 491 | POF-1481 | INVF-1481 | 12554 | 12516 | 2 | 1 | 40 | 9260.0 | 0.0 | 463.0 | 706.27 | 706.27 | 0.0 | 8797.0 | INR | 0.0 | 0.24 | 0.0 | 4 | 12554 | 2025-12-26 20:46:03 | 0 | NULL | 1 | 2025-12-26 20:48:37 | 12516 | 0 | NULL | ||
| 482 | 492 | POF-1482 | INVF-1482 | 12516 | 1 | 2 | 1 | 51 | 15359.0 | 0.0 | 1228.72 | 1171.45 | 1171.45 | 0.0 | 14130.28 | INR | 0.0 | 0.01 | 0.0 | 4 | 12516 | 2025-12-26 20:46:56 | 0 | NULL | 1 | 2025-12-26 20:47:39 | 1 | 0 | NULL | ||
| 483 | 493 | POF-1483 | INVF-1483 | 12516 | 1 | 2 | 1 | 50 | 7950.0 | 0.0 | 636.0 | 606.36 | 606.36 | 0.0 | 7314.0 | INR | 0.0 | 0.6 | 0.0 | 4 | 12516 | 2025-12-26 20:47:16 | 0 | NULL | 1 | 2025-12-26 20:48:24 | 1 | 0 | NULL | ||
| 484 | 494 | POF-1484 | INVF-1484 | 12516 | 1 | 2 | 1 | 100 | 55900.0 | 0.0 | 4472.0 | 2307.8 | 2307.8 | 0.0 | 51428.0 | INR | 0.0 | 11.0 | 0.0 | 4 | 12516 | 2025-12-26 20:51:57 | 0 | NULL | 1 | 2025-12-26 20:52:13 | 1 | 0 | NULL | ||
| 485 | 495 | POF-1485 | INVF-1485 | 12554 | 12516 | 2 | 1 | 50 | 27950.0 | 0.0 | 1397.5 | 1153.9 | 1153.9 | 0.0 | 26552.5 | INR | 0.0 | 5.5 | 0.0 | 4 | 12554 | 2025-12-26 20:52:46 | 0 | NULL | 1 | 2025-12-26 20:53:22 | 12516 | 0 | NULL | ||
| 486 | 496 | POF-1486 | INVF-1486 | 12554 | 12516 | 2 | 1 | 10 | 5590.0 | 0.0 | 279.5 | 230.78 | 230.78 | 0.0 | 5310.5 | INR | 0.0 | 1.1 | 0.0 | 4 | 12554 | 2025-12-26 21:22:15 | 0 | NULL | 1 | 2025-12-26 21:22:45 | 12516 | 0 | NULL | ||
| 487 | 497 | POF-1487 | INVF-1487 | 12555 | 12554 | 2 | 1 | 10 | 18500.0 | 0.0 | 370.0 | 440.48 | 440.48 | 0.0 | 18130.0 | INR | 0.0 | 3.5 | 0.0 | 4 | 12555 | 2025-12-26 21:35:30 | 0 | NULL | 1 | 2025-12-26 21:35:52 | 12554 | 0 | NULL | ||
| 488 | 498 | POF-1488 | INVF-1488 | 12555 | 12554 | 2 | 1 | 100 | 8000.0 | 0.0 | 160.0 | 190.48 | 190.48 | 0.0 | 7840.0 | INR | 0.0 | 0.9 | 0.0 | 4 | 12555 | 2025-12-26 21:38:56 | 0 | NULL | 1 | 2025-12-26 21:39:18 | 12554 | 0 | NULL | ||
| 489 | 499 | POF-1489 | INVF-1489 | 12517 | 12516 | 2 | 1 | 1 | 559.0 | 0.0 | 27.95 | 0.0 | 0.0 | 46.16 | 531.05 | INR | 0.0 | 0.11 | 0.0 | 4 | 12517 | 2025-12-26 21:57:14 | 0 | NULL | 2 | 2025-12-26 21:58:39 | 12516 | 0 | NULL | ||
| 490 | 500 | POF-1490 | INVF-1490 | 13438 | 12554 | 2 | 1 | 160 | 10880.0 | 0.0 | 217.6 | 0.0 | 0.0 | 518.1 | 10662.4 | INR | 0.0 | 0.36 | 0.0 | 4 | 13438 | 2025-12-26 22:14:06 | 0 | NULL | 1 | 2025-12-26 22:16:47 | 12554 | 0 | NULL | ||
| 491 | 501 | POF-1491 | INVF-1491 | 12555 | 12554 | 2 | 1 | 30 | 4770.0 | 0.0 | 95.4 | 363.81 | 363.81 | 0.0 | 4674.6 | INR | 0.0 | 0.36 | 0.0 | 4 | 12555 | 2025-12-26 22:30:02 | 0 | NULL | 1 | 2025-12-26 22:30:34 | 12554 | 0 | NULL | ||
| 492 | 502 | POF-1492 | INVF-1492 | 12555 | 12554 | 2 | 1 | 30 | 4770.0 | 0.0 | 95.4 | 363.81 | 363.81 | 0.0 | 4674.6 | INR | 0.0 | 0.33 | 0.0 | 4 | 12555 | 2025-12-26 22:41:03 | 0 | NULL | 1 | 2025-12-26 22:41:25 | 12554 | 0 | NULL | ||
| 493 | 503 | POF-1493 | INVF-1493 | 12542 | 12554 | 2 | 1 | 6 | 7516.0 | 0.0 | 150.32 | 0.0 | 0.0 | 475.21 | 7365.68 | INR | 0.0 | 0.8 | 0.0 | 4 | 12542 | 2025-12-26 22:59:07 | 0 | NULL | 1 | 2025-12-26 22:59:32 | 12554 | 0 | NULL | ||
| 494 | 504 | POF-1494 | INVF-1494 | 12555 | 12554 | 2 | 1 | 10 | 79800.0 | 0.0 | 1596.0 | 1162.14 | 1162.14 | 0.0 | 78204.0 | INR | 0.0 | 20.0 | 0.0 | 4 | 12555 | 2025-12-26 23:11:55 | 0 | NULL | 1 | 2025-12-26 23:12:17 | 12554 | 0 | NULL | ||
| 495 | 505 | POF-1495 | INVF-1495 | 12554 | 12516 | 2 | 1 | 250 | 50300.0 | 0.0 | 2515.0 | 1197.62 | 1197.62 | 0.0 | 47785.0 | INR | 0.0 | 5.0 | 0.0 | 4 | 12554 | 2025-12-27 08:43:06 | 0 | NULL | 1 | 2025-12-27 08:47:03 | 12516 | 0 | NULL | ||
| 496 | 506 | POF-1496 | INVF-1496 | 12516 | 1 | 2 | 1 | 50 | 37500.0 | 0.0 | 3000.0 | 892.86 | 892.86 | 0.0 | 34500.0 | INR | 0.0 | 5.0 | 0.0 | 4 | 12516 | 2025-12-27 08:44:34 | 0 | NULL | 1 | 2025-12-27 08:46:39 | 1 | 0 | NULL | ||
| 497 | 507 | POF-1497 | INVF-1497 | 12555 | 12554 | 2 | 1 | 210 | 20300.0 | 0.0 | 406.0 | 483.33 | 483.33 | 0.0 | 19894.0 | INR | 0.0 | 1.0 | 0.0 | 4 | 12555 | 2025-12-27 09:15:36 | 0 | NULL | 1 | 2025-12-27 09:15:57 | 12554 | 0 | NULL | ||
| 498 | 508 | POF-1498 | INVF-1498 | 12542 | 12554 | 2 | 1 | 375 | 29245.0 | 0.0 | 584.9 | 0.0 | 0.0 | 2531.04 | 28660.1 | INR | 0.0 | 0.22 | 0.0 | 4 | 12542 | 2025-12-27 16:47:29 | 0 | NULL | 1 | 2025-12-27 16:47:47 | 12554 | 0 | NULL | ||
| 499 | 509 | POF-1499 | INVF-1499 | 12554 | 12516 | 2 | 1 | 30 | 239400.0 | 0.0 | 11970.0 | 3486.41 | 3486.41 | 0.0 | 227430.0 | INR | 0.0 | 60.0 | 0.0 | 4 | 12554 | 2025-12-27 16:54:24 | 0 | NULL | 1 | 2025-12-27 16:55:45 | 12516 | 0 | NULL | ||
| 500 | 510 | POF-1500 | INVF-1500 | 12516 | 1 | 2 | 1 | 30 | 239400.0 | 0.0 | 19152.0 | 3486.41 | 3486.41 | 0.0 | 220248.0 | INR | 0.0 | 60.0 | 0.0 | 4 | 12516 | 2025-12-27 16:55:21 | 0 | NULL | 1 | 2025-12-27 16:55:31 | 1 | 0 | NULL |