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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 501 | 511 | POF-1501 | INVF-1501 | 12542 | 12554 | 2 | 1 | 2 | 15960.0 | 0.0 | 319.2 | 0.0 | 0.0 | 464.85 | 15640.8 | INR | 0.0 | 4.0 | 0.0 | 4 | 12542 | 2025-12-27 16:56:02 | 0 | NULL | 1 | 2025-12-27 16:56:13 | 12554 | 0 | NULL | ||
| 502 | 512 | POF-1502 | INVF-1502 | 12542 | 12554 | 2 | 1 | 1 | 7980.0 | 0.0 | 159.6 | 0.0 | 0.0 | 232.43 | 7820.4 | INR | 0.0 | 2.0 | 0.0 | 4 | 12542 | 2025-12-27 17:04:56 | 0 | NULL | 1 | 2025-12-27 20:01:22 | 12554 | 0 | NULL | ||
| 503 | 513 | POF-1503 | INVF-1503 | 13438 | 12554 | 2 | 1 | 2 | 718.0 | 0.0 | 14.36 | 0.0 | 0.0 | 70.41 | 703.64 | INR | 0.0 | 0.01 | 0.0 | 4 | 13438 | 2025-12-27 20:00:35 | 0 | NULL | 1 | 2025-12-27 20:01:22 | 12554 | 0 | NULL | ||
| 504 | 514 | POF-1504 | INVF-1504 | 13438 | 12554 | 2 | 1 | 1 | 7980.0 | 0.0 | 159.6 | 0.0 | 0.0 | 232.43 | 7820.4 | INR | 0.0 | 2.0 | 0.0 | 4 | 13438 | 2025-12-27 20:13:25 | 0 | NULL | 1 | 2025-12-27 20:14:32 | 12554 | 0 | NULL | ||
| 505 | 515 | POF-1505 | INVF-1505 | 12542 | 12554 | 2 | 1 | 5 | 39900.0 | 0.0 | 798.0 | 0.0 | 0.0 | 1162.14 | 39102.0 | INR | 0.0 | 10.0 | 0.0 | 4 | 12542 | 2025-12-29 10:45:08 | 0 | NULL | 1 | 2025-12-29 11:23:09 | 12554 | 0 | NULL | ||
| 506 | 516 | POF-1506 | INVF-1506 | 12554 | 12516 | 2 | 1 | 10 | 79800.0 | 0.0 | 3990.0 | 1162.14 | 1162.14 | 0.0 | 75810.0 | INR | 0.0 | 20.0 | 0.0 | 4 | 12554 | 2025-12-29 10:58:37 | 0 | NULL | 1 | 2025-12-29 11:00:59 | 12516 | 0 | NULL | ||
| 507 | 517 | POF-1507 | INVF-1507 | 12516 | 1 | 2 | 1 | 1 | 7980.0 | 0.0 | 638.4 | 116.21 | 116.21 | 0.0 | 7341.6 | INR | 0.0 | 2.0 | 0.0 | 4 | 12516 | 2025-12-29 10:59:11 | 0 | NULL | 1 | 2025-12-29 10:59:27 | 1 | 0 | NULL | ||
| 508 | 518 | POF-1508 | INVF-1508 | 12516 | 1 | 2 | 1 | 5 | 39900.0 | 0.0 | 3192.0 | 581.07 | 581.07 | 0.0 | 36708.0 | INR | 0.0 | 10.0 | 0.0 | 4 | 12516 | 2025-12-29 11:00:17 | 0 | NULL | 1 | 2025-12-29 11:00:38 | 1 | 0 | NULL | ||
| 509 | 519 | POF-1509 | INVF-1509 | 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-29 13:03:02 | 0 | NULL | 1 | 2025-12-29 13:03:38 | 12554 | 0 | NULL | ||
| 510 | 520 | POF-1510 | INVF-1510 | 12554 | 12516 | 2 | 1 | 30 | 22500.0 | 0.0 | 1125.0 | 535.71 | 535.71 | 0.0 | 21375.0 | INR | 0.0 | 3.0 | 0.0 | 4 | 12554 | 2025-12-30 11:22:32 | 0 | NULL | 1 | 2025-12-30 11:28:38 | 12516 | 0 | NULL | ||
| 511 | 521 | POF-1511 | INVF-1511 | 12516 | 1 | 2 | 1 | 40 | 30000.0 | 0.0 | 2400.0 | 714.29 | 714.29 | 0.0 | 27600.0 | INR | 0.0 | 4.0 | 0.0 | 4 | 12516 | 2025-12-30 11:24:31 | 0 | NULL | 1 | 2025-12-30 11:24:41 | 1 | 0 | NULL | ||
| 512 | 522 | POF-1512 | INVF-1512 | 12555 | 12554 | 2 | 1 | 30 | 22500.0 | 0.0 | 450.0 | 535.71 | 535.71 | 0.0 | 22050.0 | INR | 0.0 | 3.0 | 0.0 | 4 | 12555 | 2025-12-30 11:31:11 | 0 | NULL | 1 | 2025-12-30 11:31:29 | 12554 | 0 | NULL | ||
| 513 | 523 | POF-1513 | INVF-1513 | 12555 | 12554 | 2 | 1 | 10 | 7200.0 | 0.0 | 144.0 | 171.43 | 171.43 | 0.0 | 7056.0 | INR | 0.0 | 1.5 | 0.0 | 4 | 12555 | 2025-12-30 16:58:51 | 0 | NULL | 1 | 2025-12-30 16:59:04 | 12554 | 0 | NULL | ||
| 514 | 524 | POF-1514 | INVF-1514 | 12555 | 12554 | 2 | 1 | 50 | 6000.0 | 0.0 | 120.0 | 457.63 | 457.63 | 0.0 | 5880.0 | INR | 0.0 | 0.55 | 0.0 | 4 | 12555 | 2025-12-30 18:37:35 | 0 | NULL | 1 | 2025-12-30 18:37:58 | 12554 | 0 | NULL | ||
| 515 | 525 | POF-1515 | INVF-1515 | 12555 | 12554 | 2 | 1 | 500 | 24000.0 | 0.0 | 480.0 | 571.43 | 571.43 | 0.0 | 23520.0 | INR | 0.0 | 3.0 | 0.0 | 4 | 12555 | 2025-12-30 22:52:30 | 0 | NULL | 1 | 2025-12-30 22:55:46 | 12554 | 0 | NULL | ||
| 516 | 526 | POF-1516 | INVF-1516 | 12554 | 12516 | 2 | 1 | 1000 | 48000.0 | 0.0 | 2400.0 | 1142.86 | 1142.86 | 0.0 | 45600.0 | INR | 0.0 | 6.0 | 0.0 | 4 | 12554 | 2025-12-30 22:53:18 | 0 | NULL | 1 | 2025-12-30 22:55:23 | 12516 | 0 | NULL | ||
| 517 | 527 | POF-1517 | INVF-1517 | 12516 | 1 | 2 | 1 | 1500 | 72000.0 | 0.0 | 5760.0 | 1714.29 | 1714.29 | 0.0 | 66240.0 | INR | 0.0 | 9.0 | 0.0 | 4 | 12516 | 2025-12-30 22:54:07 | 0 | NULL | 1 | 2025-12-30 22:54:59 | 1 | 0 | NULL | ||
| 518 | 528 | POF-1518 | INVF-1518 | 12542 | 12554 | 2 | 1 | 2 | 15960.0 | 0.0 | 319.2 | 0.0 | 0.0 | 464.85 | 15640.8 | INR | 0.0 | 4.0 | 0.0 | 4 | 12542 | 2025-12-31 11:26:11 | 0 | NULL | 1 | 2025-12-31 11:36:59 | 12554 | 0 | NULL | ||
| 519 | 529 | POF-1519 | INVF-1519 | 12555 | 12554 | 2 | 1 | 15 | 119700.0 | 0.0 | 2394.0 | 1743.2 | 1743.2 | 0.0 | 117306.0 | INR | 0.0 | 30.0 | 0.0 | 4 | 12555 | 2025-12-31 12:02:14 | 0 | NULL | 1 | 2025-12-31 12:02:32 | 12554 | 0 | NULL | ||
| 520 | 530 | POF-1520 | INVF-1520 | 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 | 2026-01-01 13:22:12 | 0 | NULL | 1 | 2026-01-01 13:22:56 | 12554 | 0 | NULL | ||
| 521 | 531 | POF-1521 | INVF-1521 | 12555 | 12554 | 2 | 1 | 10 | 7500.0 | 0.0 | 150.0 | 178.57 | 178.57 | 0.0 | 7350.0 | INR | 0.0 | 1.0 | 0.0 | 4 | 12555 | 2026-01-01 13:30:52 | 0 | NULL | 1 | 2026-01-01 13:31:22 | 12554 | 0 | NULL | ||
| 522 | 532 | POF-1522 | INVF-1522 | 12542 | 12554 | 2 | 1 | 10 | 79800.0 | 0.0 | 1596.0 | 0.0 | 0.0 | 2324.27 | 78204.0 | INR | 0.0 | 20.0 | 0.0 | 4 | 12542 | 2026-01-01 15:28:02 | 0 | NULL | 1 | 2026-01-01 15:47:04 | 12554 | 0 | NULL | ||
| 523 | 533 | POF-1523 | INVF-1523 | 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 | 2026-01-01 15:45:33 | 0 | NULL | 1 | 2026-01-01 15:46:43 | 12516 | 0 | NULL | ||
| 524 | 534 | POF-1524 | INVF-1524 | 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 | 2026-01-01 15:46:16 | 0 | NULL | 1 | 2026-01-01 15:46:30 | 1 | 0 | NULL | ||
| 525 | 535 | POF-1525 | INVF-1525 | 12555 | 12554 | 2 | 1 | 30 | 309590.0 | 0.0 | 6191.8 | 4508.59 | 4508.59 | 0.0 | 303398.2 | INR | 0.0 | 30.0 | 0.0 | 4 | 12555 | 2026-01-01 16:26:55 | 0 | NULL | 1 | 2026-01-01 16:28:43 | 12554 | 0 | NULL | ||
| 526 | 536 | POF-1526 | INVF-1526 | 12554 | 12516 | 2 | 1 | 10 | 79800.0 | 0.0 | 3990.0 | 1162.14 | 1162.14 | 0.0 | 75810.0 | INR | 0.0 | 20.0 | 0.0 | 4 | 12554 | 2026-01-01 16:27:51 | 0 | NULL | 1 | 2026-01-01 16:28:18 | 12516 | 0 | NULL | ||
| 527 | 537 | POF-1527 | INVF-1527 | 12555 | 12554 | 2 | 1 | 5 | 39900.0 | 0.0 | 798.0 | 581.07 | 581.07 | 0.0 | 39102.0 | INR | 0.0 | 10.0 | 0.0 | 4 | 12555 | 2026-01-01 22:47:09 | 0 | NULL | 2 | 2026-01-01 22:50:33 | 12554 | 0 | NULL | ||
| 528 | 538 | POF-1528 | INVF-1528 | 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 | 2026-01-01 22:48:02 | 0 | NULL | 1 | 2026-01-02 11:18:35 | 12516 | 0 | NULL | ||
| 529 | 539 | POF-1529 | INVF-1529 | 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 | 2026-01-01 22:48:42 | 0 | NULL | 1 | 2026-01-02 11:18:27 | 1 | 0 | NULL | ||
| 530 | 540 | POF-1530 | INVF-1530 | 12555 | 12554 | 2 | 1 | 3 | 23940.0 | 0.0 | 478.8 | 348.64 | 348.64 | 0.0 | 23461.2 | INR | 0.0 | 6.0 | 0.0 | 4 | 12555 | 2026-01-01 22:50:54 | 0 | NULL | 1 | 2026-01-01 22:51:12 | 12554 | 0 | NULL | ||
| 531 | 541 | POF-1531 | INVF-1531 | 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 | 2026-01-02 11:17:13 | 0 | NULL | 2 | 2026-01-02 11:18:37 | 12516 | 0 | NULL | ||
| 532 | 542 | POF-1532 | INVF-1532 | 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 | 2026-01-02 11:20:49 | 0 | NULL | 1 | 2026-01-02 11:21:06 | 12554 | 0 | NULL | ||
| 533 | 543 | POF-1533 | INVF-1533 | 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 | 2026-01-02 16:48:57 | 0 | NULL | 1 | 2026-01-02 16:49:07 | 1 | 0 | NULL | ||
| 534 | 544 | POF-1534 | INVF-1534 | 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 | 2026-01-02 16:49:26 | 0 | NULL | 1 | 2026-01-02 16:49:40 | 12516 | 0 | NULL | ||
| 535 | 545 | POF-1535 | INVF-1535 | 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 | 2026-01-02 16:50:22 | 0 | NULL | 1 | 2026-01-02 16:50:34 | 12554 | 0 | NULL | ||
| 536 | 546 | POF-1536 | INVF-1536 | 13438 | 12554 | 2 | 1 | 3 | 612.0 | 0.0 | 12.24 | 0.0 | 0.0 | 29.14 | 599.76 | INR | 0.0 | 0.12 | 0.0 | 4 | 13438 | 2026-01-02 17:08:48 | 0 | NULL | 1 | 2026-01-02 17:15:02 | 12554 | 0 | NULL | ||
| 537 | 547 | POF-1537 | INVF-1537 | 12554 | 12516 | 2 | 1 | 10 | 7500.0 | 0.0 | 375.0 | 178.57 | 178.57 | 0.0 | 7125.0 | INR | 0.0 | 1.0 | 0.0 | 4 | 12554 | 2026-01-02 17:23:29 | 0 | NULL | 1 | 2026-01-02 17:23:41 | 12516 | 0 | NULL | ||
| 538 | 548 | POF-1538 | INVF-1538 | 13438 | 12554 | 2 | 1 | 2 | 1500.0 | 0.0 | 30.0 | 0.0 | 0.0 | 71.43 | 1470.0 | INR | 0.0 | 0.2 | 0.0 | 4 | 13438 | 2026-01-02 17:27:48 | 0 | NULL | 1 | 2026-01-02 17:29:09 | 12554 | 0 | NULL | ||
| 539 | 549 | POF-1539 | INVF-1539 | 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 | 2026-01-02 17:42:07 | 0 | NULL | 1 | 2026-01-02 17:42:17 | 12554 | 0 | NULL | ||
| 540 | 550 | POF-1540 | INVF-1540 | 12554 | 12516 | 2 | 1 | 10 | 1590.0 | 0.0 | 79.5 | 121.27 | 121.27 | 0.0 | 1510.5 | INR | 0.0 | 0.12 | 0.0 | 4 | 12554 | 2026-01-02 17:52:14 | 0 | NULL | 1 | 2026-01-02 17:53:04 | 12516 | 0 | NULL | ||
| 541 | 551 | POF-1541 | INVF-1541 | 12554 | 12516 | 2 | 1 | 10 | 12500.0 | 0.0 | 625.0 | 297.62 | 297.62 | 0.0 | 11875.0 | INR | 0.0 | 2.5 | 0.0 | 4 | 12554 | 2026-01-02 18:01:14 | 0 | NULL | 1 | 2026-01-02 18:01:25 | 12516 | 0 | NULL | ||
| 542 | 552 | POF-1542 | INVF-1542 | 12527 | 12554 | 2 | 1 | 454 | 105189.0 | 0.0 | 2103.78 | 0.0 | 0.0 | 4599.54 | 103085.22 | INR | 0.0 | 0.55 | 0.0 | 4 | 12527 | 2026-01-02 18:05:33 | 0 | NULL | 1 | 2026-01-02 18:34:05 | 12554 | 0 | NULL | ||
| 543 | 553 | POF-1543 | INVF-1543 | 12554 | 12516 | 2 | 1 | 30 | 17480.0 | 0.0 | 874.0 | 416.19 | 416.19 | 0.0 | 16606.0 | INR | 0.0 | 2.5 | 0.0 | 4 | 12554 | 2026-01-02 18:07:44 | 0 | NULL | 1 | 2026-01-02 18:07:55 | 12516 | 0 | NULL | ||
| 544 | 554 | POF-1544 | INVF-1544 | 12527 | 12554 | 2 | 1 | 13 | 8182.0 | 0.0 | 163.64 | 0.0 | 0.0 | 389.62 | 8018.36 | INR | 0.0 | 1.25 | 0.0 | 4 | 12527 | 2026-01-02 18:11:12 | 0 | NULL | 1 | 2026-01-02 18:20:33 | 12554 | 0 | NULL | ||
| 545 | 555 | POF-1545 | INVF-1545 | 12554 | 12516 | 2 | 1 | 1000 | 64000.0 | 0.0 | 3200.0 | 1523.81 | 1523.81 | 0.0 | 60800.0 | INR | 0.0 | 3.0 | 0.0 | 4 | 12554 | 2026-01-02 18:21:33 | 0 | NULL | 1 | 2026-01-02 18:21:46 | 12516 | 0 | NULL | ||
| 546 | 556 | POF-1546 | INVF-1546 | 12554 | 12516 | 2 | 1 | 110 | 271410.0 | 0.0 | 13570.5 | 5677.28 | 5677.28 | 0.0 | 257839.5 | INR | 0.0 | 2.2 | 0.0 | 4 | 12554 | 2026-01-02 18:24:32 | 0 | NULL | 1 | 2026-01-02 18:33:45 | 12516 | 0 | NULL | ||
| 547 | 557 | POF-1547 | INVF-1547 | 12516 | 1 | 2 | 1 | 20 | 159600.0 | 0.0 | 12768.0 | 2324.27 | 2324.27 | 0.0 | 146832.0 | INR | 0.0 | 40.0 | 0.0 | 4 | 12516 | 2026-01-02 18:25:20 | 0 | NULL | 1 | 2026-01-02 18:26:09 | 1 | 0 | NULL | ||
| 548 | 558 | POF-1548 | INVF-1548 | 12516 | 1 | 2 | 1 | 5 | 74995.0 | 0.0 | 5999.6 | 1092.16 | 1092.16 | 0.0 | 68995.4 | INR | 0.0 | 15.0 | 0.0 | 4 | 12516 | 2026-01-02 18:33:21 | 0 | NULL | 1 | 2026-01-02 18:33:29 | 1 | 0 | NULL | ||
| 549 | 559 | POF-1549 | INVF-1549 | 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 | 2026-01-02 18:51:12 | 0 | NULL | 1 | 2026-01-02 18:51:22 | 12554 | 0 | NULL | ||
| 550 | 560 | POF-1550 | INVF-1550 | 13438 | 12554 | 2 | 1 | 5 | 32479.0 | 0.0 | 649.58 | 0.0 | 0.0 | 1014.98 | 31829.42 | INR | 0.0 | 0.11 | 0.0 | 4 | 13438 | 2026-01-02 19:04:52 | 0 | NULL | 1 | 2026-01-02 19:15:27 | 12554 | 0 | NULL |