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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 601 | 611 | POFN-1601 | INVFN-1601 | 12555 | 12554 | 2 | 1 | 5 | 5750.0 | 0.0 | 109.52 | 136.9 | 136.9 | 0.0 | 5640.48 | INR | 0.0 | 1.25 | 0.0 | 4 | 12555 | 2026-01-07 16:42:40 | 0 | NULL | 1 | 2026-01-07 16:45:21 | 12554 | 0 | NULL | ||
| 602 | 612 | POFN-1602 | INVFN-1602 | 12554 | 12516 | 2 | 1 | 30 | 36000.0 | 0.0 | 2057.14 | 857.14 | 857.14 | 0.0 | 33942.86 | INR | 0.0 | 3.75 | 0.0 | 4 | 12554 | 2026-01-07 16:44:29 | 0 | NULL | 1 | 2026-01-07 16:44:42 | 12516 | 0 | NULL | ||
| 603 | 613 | POFN-1603 | INVFN-1603 | 12555 | 12554 | 2 | 1 | 10 | 12500.0 | 0.0 | 238.1 | 297.62 | 297.62 | 0.0 | 12261.9 | INR | 0.0 | 2.5 | 0.0 | 4 | 12555 | 2026-01-07 16:45:06 | 0 | NULL | 1 | 2026-01-07 16:45:21 | 12554 | 0 | NULL | ||
| 604 | 614 | POFN-1604 | INVFN-1604 | 12518 | 12517 | 2 | 1 | 15 | 2385.0 | 0.0 | 40.42 | 0.0 | 0.0 | 363.81 | 2344.58 | INR | 0.0 | 0.38 | 0.0 | 4 | 12518 | 2026-01-07 16:46:34 | 0 | NULL | 1 | 2026-01-07 17:22:33 | 12517 | 0 | NULL | ||
| 605 | 615 | POFN-1605 | INVFN-1605 | 12555 | 12554 | 2 | 1 | 15 | 17750.0 | 0.0 | 338.1 | 422.62 | 422.62 | 0.0 | 17411.9 | INR | 0.0 | 2.5 | 0.0 | 4 | 12555 | 2026-01-07 17:17:06 | 0 | NULL | 1 | 2026-01-07 17:17:16 | 12554 | 0 | NULL | ||
| 606 | 616 | POFN-1606 | INVFN-1606 | 12554 | 12516 | 2 | 1 | 6 | 7500.0 | 0.0 | 428.57 | 178.57 | 178.57 | 0.0 | 7071.43 | INR | 0.0 | 1.5 | 0.0 | 4 | 12554 | 2026-01-07 17:17:52 | 0 | NULL | 1 | 2026-01-07 17:18:07 | 12516 | 0 | NULL | ||
| 607 | 617 | POFN-1607 | INVFN-1607 | 12555 | 12554 | 2 | 1 | 5 | 6250.0 | 0.0 | 119.05 | 148.81 | 148.81 | 0.0 | 6130.95 | INR | 0.0 | 1.25 | 0.0 | 4 | 12555 | 2026-01-07 17:19:28 | 0 | NULL | 1 | 2026-01-07 17:19:44 | 12554 | 0 | NULL | ||
| 608 | 618 | POFN-1608 | INVFN-1608 | 12554 | 12516 | 2 | 1 | 1 | 10500.0 | 0.0 | 300.0 | 250.0 | 250.0 | 0.0 | 10200.0 | INR | 0.0 | 3.0 | 0.0 | 4 | 12554 | 2026-01-07 18:11:09 | 0 | NULL | 1 | 2026-01-07 18:11:21 | 12516 | 0 | NULL | ||
| 609 | 619 | POFN-1609 | INVFN-1609 | 12555 | 12554 | 2 | 1 | 2 | 10548.0 | 0.0 | 150.91 | 251.14 | 251.14 | 0.0 | 10397.09 | INR | 0.0 | 0.01 | 0.0 | 4 | 12555 | 2026-01-07 18:11:43 | 0 | NULL | 1 | 2026-01-07 18:11:52 | 12554 | 0 | NULL | ||
| 610 | 620 | POFN-1610 | INVFN-1610 | 12546 | 12517 | 2 | 1 | 92 | 28555.0 | 0.0 | 484.68 | 0.0 | 0.0 | 1821.11 | 28070.32 | INR | 0.0 | 0.11 | 0.0 | 4 | 12546 | 2026-01-07 19:23:04 | 0 | NULL | 1 | 2026-01-08 14:04:42 | 12517 | 0 | NULL | ||
| 611 | 621 | POFN-1611 | INVFN-1611 | 12526 | 12517 | 2 | 1 | 24 | 10896.0 | 0.0 | 204.99 | 323.22 | 323.22 | 0.0 | 10691.01 | INR | 0.0 | 0.06 | 0.0 | 4 | 12526 | 2026-01-07 20:18:12 | 0 | NULL | 1 | 2026-01-07 23:15:15 | 12517 | 0 | NULL | ||
| 612 | 622 | POFN-1612 | INVFN-1612 | 12539 | 12517 | 2 | 1 | 1 | 10500.0 | 0.0 | 150.0 | 250.0 | 250.0 | 0.0 | 10350.0 | INR | 0.0 | 3.0 | 0.0 | 4 | 12539 | 2026-01-07 21:17:25 | 0 | NULL | 1 | 2026-01-07 22:04:53 | 12517 | 0 | NULL | ||
| 613 | 623 | POFN-1613 | INVFN-1613 | 12517 | 12516 | 2 | 1 | 12 | 9900.0 | 0.0 | 565.71 | 0.0 | 0.0 | 471.43 | 9334.29 | INR | 0.0 | 1.0 | 0.0 | 4 | 12517 | 2026-01-07 22:10:31 | 0 | NULL | 1 | 2026-01-07 22:11:44 | 12516 | 0 | NULL | ||
| 614 | 624 | POFN-1614 | INVFN-1614 | 12516 | 1 | 2 | 1 | 9 | 6750.0 | 0.0 | 514.29 | 160.71 | 160.71 | 0.0 | 6235.71 | INR | 0.0 | 0.9 | 0.0 | 4 | 12516 | 2026-01-07 22:11:16 | 0 | NULL | 1 | 2026-01-07 22:11:32 | 1 | 0 | NULL | ||
| 615 | 625 | POFN-1615 | INVFN-1615 | 13438 | 12554 | 2 | 1 | 8 | 4534.0 | 0.0 | 83.23 | 0.0 | 0.0 | 372.28 | 4450.77 | INR | 0.0 | 0.22 | 0.0 | 4 | 13438 | 2026-01-07 22:12:47 | 0 | NULL | 1 | 2026-01-07 22:52:03 | 12554 | 0 | NULL | ||
| 616 | 626 | POFN-1616 | INVFN-1616 | 12554 | 12516 | 2 | 1 | 10 | 7200.0 | 0.0 | 411.43 | 171.43 | 171.43 | 0.0 | 6788.57 | INR | 0.0 | 1.5 | 0.0 | 4 | 12554 | 2026-01-07 22:41:59 | 0 | NULL | 1 | 2026-01-07 22:42:37 | 12516 | 0 | NULL | ||
| 617 | 627 | POFN-1617 | INVFN-1617 | 13438 | 12554 | 2 | 1 | 2 | 1440.0 | 0.0 | 27.43 | 0.0 | 0.0 | 68.57 | 1412.57 | INR | 0.0 | 0.3 | 0.0 | 4 | 13438 | 2026-01-07 22:44:38 | 0 | NULL | 1 | 2026-01-07 22:52:03 | 12554 | 0 | NULL | ||
| 618 | 628 | POFN-1618 | INVFN-1618 | 13438 | 12517 | 2 | 1 | 20 | 960.0 | 0.0 | 18.29 | 22.86 | 22.86 | 0.0 | 941.71 | INR | 0.0 | 0.12 | 0.0 | 4 | 13438 | 2026-01-07 23:14:20 | 0 | NULL | 1 | 2026-01-07 23:15:10 | 12517 | 0 | NULL | ||
| 619 | 629 | POFN-1619 | INVFN-1619 | 13438 | 12517 | 2 | 1 | 2 | 608.0 | 0.0 | 10.31 | 46.37 | 46.37 | 0.0 | 597.69 | INR | 0.0 | 0.1 | 0.0 | 4 | 13438 | 2026-01-08 13:02:01 | 0 | NULL | 1 | 2026-01-08 13:59:52 | 12517 | 0 | NULL | ||
| 620 | 630 | POFN-1620 | INVFN-1620 | 12517 | 12516 | 2 | 1 | 30 | 8370.0 | 0.0 | 478.29 | 0.0 | 0.0 | 398.57 | 7891.71 | INR | 0.0 | 1.5 | 0.0 | 4 | 12517 | 2026-01-08 14:03:13 | 0 | NULL | 1 | 2026-01-08 14:03:23 | 12516 | 0 | NULL | ||
| 621 | 631 | POFN-1621 | INVFN-1621 | 12517 | 12516 | 2 | 1 | 2 | 5200.0 | 0.0 | 297.14 | 0.0 | 0.0 | 247.62 | 4902.86 | INR | 0.0 | 1.0 | 0.0 | 4 | 12517 | 2026-01-08 14:04:19 | 0 | NULL | 1 | 2026-01-08 14:04:29 | 12516 | 0 | NULL | ||
| 622 | 632 | POFN-1622 | INVFN-1622 | 12521 | 12517 | 2 | 1 | 198 | 36450.0 | 0.0 | 650.38 | 1520.5 | 1520.5 | 0.0 | 35799.62 | INR | 0.0 | 0.06 | 0.0 | 4 | 12521 | 2026-01-08 17:29:46 | 0 | NULL | 1 | 2026-01-08 20:46:14 | 12517 | 0 | NULL | ||
| 623 | 633 | POFN-1623 | INVFN-1623 | 12523 | 12517 | 2 | 1 | 1 | 2000.0 | 0.0 | 38.83 | 29.13 | 29.13 | 0.0 | 1961.17 | INR | 0.0 | 0.4 | 0.0 | 4 | 12523 | 2026-01-08 19:11:01 | 0 | NULL | 1 | 2026-01-08 21:30:55 | 12517 | 0 | NULL | ||
| 624 | 634 | POFN-1624 | INVFN-1624 | 12517 | 12516 | 2 | 1 | 120 | 64630.0 | 0.0 | 3669.7 | 0.0 | 0.0 | 3468.36 | 60960.3 | INR | 0.0 | 1.0 | 0.0 | 4 | 12517 | 2026-01-08 20:41:47 | 0 | NULL | 1 | 2026-01-08 20:45:53 | 12516 | 0 | NULL | ||
| 625 | 635 | POFN-1625 | INVFN-1625 | 12516 | 1 | 2 | 1 | 150 | 101040.0 | 0.0 | 7651.4 | 2698.77 | 2698.77 | 0.0 | 93388.6 | INR | 0.0 | 3.0 | 0.0 | 4 | 12516 | 2026-01-08 20:44:03 | 0 | NULL | 1 | 2026-01-08 20:45:27 | 1 | 0 | NULL | ||
| 626 | 636 | POFN-1626 | INVFN-1626 | 12545 | 12517 | 2 | 1 | 21 | 10721.0 | 0.0 | 200.04 | 359.41 | 359.41 | 0.0 | 10520.96 | INR | 0.0 | 0.1 | 0.0 | 4 | 12545 | 2026-01-08 22:07:51 | 0 | NULL | 1 | 2026-01-08 22:24:10 | 12517 | 0 | NULL | ||
| 627 | 637 | POFN-1627 | INVFN-1627 | 12552 | 12517 | 2 | 1 | 24 | 8819.0 | 0.0 | 159.53 | 421.13 | 421.13 | 0.0 | 8659.47 | INR | 0.0 | 0.03 | 0.0 | 4 | 12552 | 2026-01-08 22:47:06 | 0 | NULL | 1 | 2026-01-08 22:48:03 | 12517 | 0 | NULL | ||
| 628 | 638 | POFN-1628 | INVFN-1628 | 12534 | 12517 | 2 | 1 | 183 | 17863.0 | 0.0 | 326.36 | 772.45 | 772.45 | 0.0 | 17536.64 | INR | 0.0 | 0.08 | 0.0 | 4 | 12534 | 2026-01-09 10:29:26 | 0 | NULL | 1 | 2026-01-09 11:20:03 | 12517 | 0 | NULL | ||
| 629 | 639 | POFN-1629 | INVFN-1629 | 12517 | 12516 | 2 | 1 | 390 | 282860.0 | 0.0 | 16123.39 | 0.0 | 0.0 | 14136.84 | 266736.61 | INR | 0.0 | 7.5 | 0.0 | 4 | 12517 | 2026-01-09 12:50:03 | 0 | NULL | 1 | 2026-01-09 12:54:17 | 12516 | 0 | NULL | ||
| 630 | 640 | POFN-1630 | INVFN-1630 | 12516 | 1 | 2 | 1 | 30 | 4770.0 | 0.0 | 323.39 | 363.81 | 363.81 | 0.0 | 4446.61 | INR | 0.0 | 0.36 | 0.0 | 4 | 12516 | 2026-01-09 12:51:17 | 0 | NULL | 1 | 2026-01-09 12:51:37 | 1 | 0 | NULL | ||
| 631 | 641 | POFN-1631 | INVFN-1631 | 12516 | 1 | 2 | 1 | 150 | 30600.0 | 0.0 | 2331.43 | 728.57 | 728.57 | 0.0 | 28268.57 | INR | 0.0 | 6.0 | 0.0 | 4 | 12516 | 2026-01-09 12:53:46 | 0 | NULL | 1 | 2026-01-09 12:54:01 | 1 | 0 | NULL | ||
| 632 | 642 | POFN-1632 | INVFN-1632 | 12538 | 12517 | 2 | 1 | 1 | 10500.0 | 0.0 | 150.0 | 250.0 | 250.0 | 0.0 | 10350.0 | INR | 0.0 | 3.0 | 0.0 | 4 | 12538 | 2026-01-09 13:07:00 | 0 | NULL | 1 | 2026-01-09 14:26:14 | 12517 | 0 | NULL | ||
| 633 | 643 | POFN-1633 | INVFN-1633 | 14079 | 12517 | 2 | 1 | 26 | 3517.0 | 0.0 | 65.82 | 113.06 | 113.06 | 0.0 | 3451.18 | INR | 0.0 | 0.11 | 0.0 | 4 | 14079 | 2026-01-09 13:57:25 | 0 | NULL | 1 | 2026-01-09 14:26:11 | 12517 | 0 | NULL | ||
| 634 | 644 | POFN-1634 | INVFN-1634 | 12555 | 12554 | 2 | 1 | 2 | 1000.0 | 0.0 | 16.95 | 76.27 | 76.27 | 0.0 | 983.05 | INR | 0.0 | 0.2 | 0.0 | 4 | 12555 | 2026-01-09 15:42:18 | 0 | NULL | 1 | 2026-01-09 15:42:36 | 12554 | 0 | NULL | ||
| 635 | 645 | POFN-1635 | INVFN-1635 | 12532 | 12554 | 2 | 1 | 588 | 44622.0 | 0.0 | 830.62 | 0.0 | 0.0 | 3090.78 | 43791.38 | INR | 0.0 | 0.26 | 0.0 | 4 | 12532 | 2026-01-09 15:54:54 | 0 | NULL | 1 | 2026-01-09 15:58:07 | 12554 | 0 | NULL | ||
| 636 | 646 | POFN-1636 | INVFN-1636 | 12554 | 12516 | 2 | 1 | 25 | 8385.0 | 0.0 | 479.14 | 199.64 | 199.64 | 0.0 | 7905.86 | INR | 0.0 | 1.0 | 0.0 | 4 | 12554 | 2026-01-09 15:57:37 | 0 | NULL | 1 | 2026-01-09 15:57:50 | 12516 | 0 | NULL | ||
| 637 | 647 | POFN-1637 | INVFN-1637 | 12532 | 12554 | 2 | 1 | 10 | 5631.0 | 0.0 | 107.26 | 0.0 | 0.0 | 268.14 | 5523.74 | INR | 0.0 | 0.99 | 0.0 | 4 | 12532 | 2026-01-09 16:43:26 | 0 | NULL | 1 | 2026-01-09 16:46:05 | 12554 | 0 | NULL | ||
| 638 | 648 | POFN-1638 | INVFN-1638 | 12532 | 12517 | 2 | 1 | 1 | 9900.0 | 0.0 | 150.0 | 755.08 | 755.08 | 0.0 | 9750.0 | INR | 0.0 | 2.0 | 0.0 | 4 | 12532 | 2026-01-09 16:49:21 | 0 | NULL | 1 | 2026-01-09 17:03:28 | 12517 | 0 | NULL | ||
| 639 | 649 | POFN-1639 | INVFN-1639 | 12554 | 12516 | 2 | 1 | 20 | 10000.0 | 0.0 | 508.47 | 762.71 | 762.71 | 0.0 | 9491.53 | INR | 0.0 | 2.0 | 0.0 | 4 | 12554 | 2026-01-09 17:05:58 | 0 | NULL | 1 | 2026-01-09 17:06:21 | 12516 | 0 | NULL | ||
| 640 | 650 | POFN-1640 | INVFN-1640 | 12555 | 12554 | 2 | 1 | 10 | 5000.0 | 0.0 | 84.75 | 381.36 | 381.36 | 0.0 | 4915.25 | INR | 0.0 | 1.0 | 0.0 | 4 | 12555 | 2026-01-09 17:06:41 | 0 | NULL | 1 | 2026-01-09 17:06:55 | 12554 | 0 | NULL | ||
| 641 | 651 | POFN-1641 | INVFN-1641 | 12532 | 12517 | 2 | 1 | 1 | 2000.0 | 0.0 | 38.83 | 29.13 | 29.13 | 0.0 | 1961.17 | INR | 0.0 | 0.4 | 0.0 | 4 | 12532 | 2026-01-09 17:11:05 | 0 | NULL | 1 | 2026-01-09 17:31:56 | 12517 | 0 | NULL | ||
| 642 | 652 | POFN-1642 | INVFN-1642 | 12554 | 12516 | 2 | 1 | 10 | 105000.0 | 0.0 | 3000.0 | 2500.0 | 2500.0 | 0.0 | 102000.0 | INR | 0.0 | 30.0 | 0.0 | 4 | 12554 | 2026-01-09 17:14:33 | 0 | NULL | 1 | 2026-01-09 17:15:34 | 12516 | 0 | NULL | ||
| 643 | 653 | POFN-1643 | INVFN-1643 | 12516 | 1 | 2 | 1 | 10 | 105000.0 | 0.0 | 4000.0 | 2500.0 | 2500.0 | 0.0 | 101000.0 | INR | 0.0 | 30.0 | 0.0 | 4 | 12516 | 2026-01-09 17:15:00 | 0 | NULL | 1 | 2026-01-09 17:15:22 | 1 | 0 | NULL | ||
| 644 | 654 | POFN-1644 | INVFN-1644 | 13536 | 12554 | 2 | 1 | 2 | 21000.0 | 0.0 | 300.0 | 500.0 | 500.0 | 0.0 | 20700.0 | INR | 0.0 | 6.0 | 0.0 | 4 | 13536 | 2026-01-09 17:15:51 | 0 | NULL | 1 | 2026-01-09 17:16:01 | 12554 | 0 | NULL | ||
| 645 | 655 | POFN-1645 | INVFN-1645 | 13536 | 12554 | 2 | 1 | 60 | 8038.0 | 0.0 | 151.01 | 243.65 | 243.65 | 0.0 | 7886.99 | INR | 0.0 | 0.11 | 0.0 | 4 | 13536 | 2026-01-09 17:17:35 | 0 | NULL | 1 | 2026-01-09 17:18:47 | 12554 | 0 | NULL | ||
| 646 | 656 | POFN-1646 | INVFN-1646 | 12554 | 12516 | 2 | 1 | 20 | 2400.0 | 0.0 | 122.03 | 183.05 | 183.05 | 0.0 | 2277.97 | INR | 0.0 | 0.22 | 0.0 | 4 | 12554 | 2026-01-09 17:18:26 | 0 | NULL | 1 | 2026-01-09 17:18:36 | 12516 | 0 | NULL | ||
| 647 | 657 | POFN-1647 | INVFN-1647 | 12526 | 12517 | 2 | 1 | 5 | 52500.0 | 0.0 | 750.0 | 1250.0 | 1250.0 | 0.0 | 51750.0 | INR | 0.0 | 15.0 | 0.0 | 4 | 12526 | 2026-01-09 17:39:29 | 0 | NULL | 1 | 2026-01-09 17:42:48 | 12517 | 0 | NULL | ||
| 648 | 658 | POFN-1648 | INVFN-1648 | 13438 | 12554 | 2 | 1 | 19 | 5696.0 | 0.0 | 102.49 | 0.0 | 0.0 | 571.74 | 5593.51 | INR | 0.0 | 0.08 | 0.0 | 4 | 13438 | 2026-01-09 18:45:20 | 0 | NULL | 1 | 2026-01-09 18:48:36 | 12554 | 0 | NULL | ||
| 649 | 659 | POFN-1649 | INVFN-1649 | 12554 | 12516 | 2 | 1 | 20 | 15000.0 | 0.0 | 857.14 | 357.14 | 357.14 | 0.0 | 14142.86 | INR | 0.0 | 2.0 | 0.0 | 4 | 12554 | 2026-01-09 19:24:22 | 0 | NULL | 1 | 2026-01-09 19:24:47 | 12516 | 0 | NULL | ||
| 650 | 660 | POFN-1650 | INVFN-1650 | 12520 | 12517 | 2 | 1 | 155 | 18155.0 | 0.0 | 339.69 | 585.19 | 585.19 | 0.0 | 17815.31 | INR | 0.0 | 0.11 | 0.0 | 4 | 12520 | 2026-01-09 19:37:06 | 0 | NULL | 1 | 2026-01-09 19:48:25 | 12517 | 0 | NULL |