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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 651 | 661 | POFN-1651 | INVFN-1651 | 13438 | 12554 | 2 | 1 | 12 | 17788.0 | 0.0 | 285.3 | 0.0 | 0.0 | 1023.0 | 17502.7 | INR | 0.0 | 0.33 | 0.0 | 4 | 13438 | 2026-01-09 19:38:29 | 0 | NULL | 1 | 2026-01-09 19:39:54 | 12554 | 0 | NULL | ||
| 652 | 662 | POFN-1652 | INVFN-1652 | 12516 | 1 | 2 | 1 | 5 | 52500.0 | 0.0 | 2000.0 | 1250.0 | 1250.0 | 0.0 | 50500.0 | INR | 0.0 | 15.0 | 0.0 | 4 | 12516 | 2026-01-09 19:55:43 | 0 | NULL | 1 | 2026-01-09 19:57:00 | 1 | 0 | NULL | ||
| 653 | 663 | POFN-1653 | INVFN-1653 | 12517 | 12516 | 2 | 1 | 3 | 31500.0 | 0.0 | 900.0 | 0.0 | 0.0 | 1500.0 | 30600.0 | INR | 0.0 | 9.0 | 0.0 | 4 | 12517 | 2026-01-09 19:58:10 | 0 | NULL | 1 | 2026-01-09 19:58:23 | 12516 | 0 | NULL | ||
| 654 | 664 | POFN-1654 | INVFN-1654 | 12526 | 12517 | 2 | 1 | 3 | 31500.0 | 0.0 | 450.0 | 750.0 | 750.0 | 0.0 | 31050.0 | INR | 0.0 | 9.0 | 0.0 | 4 | 12526 | 2026-01-09 20:05:14 | 0 | NULL | 1 | 2026-01-09 20:05:21 | 12517 | 0 | NULL | ||
| 655 | 665 | POFN-1655 | INVFN-1655 | 12517 | 12516 | 2 | 1 | 8 | 84000.0 | 0.0 | 2400.0 | 0.0 | 0.0 | 4000.0 | 81600.0 | INR | 0.0 | 24.0 | 0.0 | 4 | 12517 | 2026-01-09 20:21:55 | 0 | NULL | 1 | 2026-01-09 20:22:45 | 12516 | 0 | NULL | ||
| 656 | 666 | POFN-1656 | INVFN-1656 | 12516 | 1 | 2 | 1 | 15 | 157500.0 | 0.0 | 6000.0 | 3750.0 | 3750.0 | 0.0 | 151500.0 | INR | 0.0 | 45.0 | 0.0 | 4 | 12516 | 2026-01-09 20:22:10 | 0 | NULL | 1 | 2026-01-09 20:22:34 | 1 | 0 | NULL | ||
| 657 | 667 | POFN-1657 | INVFN-1657 | 12532 | 12517 | 2 | 1 | 3 | 15700.0 | 0.0 | 249.05 | 373.81 | 373.81 | 0.0 | 15450.95 | INR | 0.0 | 3.0 | 0.0 | 4 | 12532 | 2026-01-09 21:44:20 | 0 | NULL | 1 | 2026-01-09 21:51:14 | 12517 | 0 | NULL | ||
| 658 | 668 | POFN-1658 | INVFN-1658 | 12517 | 12516 | 2 | 1 | 3 | 7800.0 | 0.0 | 445.71 | 0.0 | 0.0 | 371.43 | 7354.29 | INR | 0.0 | 1.5 | 0.0 | 4 | 12517 | 2026-01-09 21:49:36 | 0 | NULL | 1 | 2026-01-09 21:50:14 | 12516 | 0 | NULL | ||
| 659 | 669 | POFN-1659 | INVFN-1659 | 12529 | 12517 | 2 | 1 | 118 | 33470.0 | 0.0 | 529.62 | 994.53 | 994.53 | 0.0 | 32940.38 | INR | 0.0 | 0.15 | 0.0 | 4 | 12529 | 2026-01-09 22:19:46 | 0 | NULL | 1 | 2026-01-09 22:29:41 | 12517 | 0 | NULL | ||
| 660 | 670 | POFN-1660 | INVFN-1660 | 13438 | 12554 | 2 | 1 | 1 | 10500.0 | 0.0 | 150.0 | 0.0 | 0.0 | 500.0 | 10350.0 | INR | 0.0 | 3.0 | 0.0 | 4 | 13438 | 2026-01-09 22:42:46 | 0 | NULL | 1 | 2026-01-09 22:58:47 | 12554 | 0 | NULL | ||
| 661 | 671 | POFN-1661 | INVFN-1661 | 12552 | 12517 | 2 | 1 | 76 | 13935.0 | 0.0 | 255.57 | 578.18 | 578.18 | 0.0 | 13679.43 | INR | 0.0 | 0.03 | 0.0 | 4 | 12552 | 2026-01-09 22:52:53 | 0 | NULL | 1 | 2026-01-09 22:53:52 | 12517 | 0 | NULL | ||
| 662 | 672 | POFN-1662 | INVFN-1662 | 13438 | 12554 | 2 | 1 | 1 | 10500.0 | 0.0 | 150.0 | 0.0 | 0.0 | 500.0 | 10350.0 | INR | 0.0 | 3.0 | 0.0 | 4 | 13438 | 2026-01-09 22:56:55 | 0 | NULL | 1 | 2026-01-09 22:58:21 | 12554 | 0 | NULL | ||
| 663 | 673 | POFN-1663 | INVFN-1663 | 13438 | 12554 | 2 | 1 | 3 | 2250.0 | 0.0 | 42.86 | 0.0 | 0.0 | 107.14 | 2207.14 | INR | 0.0 | 0.3 | 0.0 | 4 | 13438 | 2026-01-09 23:19:43 | 0 | NULL | 1 | 2026-01-09 23:21:34 | 12554 | 0 | NULL | ||
| 664 | 674 | POFN-1664 | INVFN-1664 | 13438 | 12554 | 2 | 1 | 21 | 2959.0 | 0.0 | 56.36 | 0.0 | 0.0 | 140.9 | 2902.64 | INR | 0.0 | 0.4 | 0.0 | 4 | 13438 | 2026-01-09 23:42:17 | 0 | NULL | 1 | 2026-01-09 23:56:53 | 12554 | 0 | NULL | ||
| 665 | 675 | POFN-1665 | INVFN-1665 | 13438 | 12554 | 2 | 1 | 1 | 750.0 | 0.0 | 14.29 | 0.0 | 0.0 | 35.71 | 735.71 | INR | 0.0 | 0.1 | 0.0 | 4 | 13438 | 2026-01-09 23:56:26 | 0 | NULL | 1 | 2026-01-09 23:57:01 | 12554 | 0 | NULL | ||
| 666 | 676 | POFN-1666 | INVFN-1666 | 13438 | 12554 | 2 | 1 | 5 | 920.0 | 0.0 | 15.59 | 0.0 | 0.0 | 140.34 | 904.41 | INR | 0.0 | 0.06 | 0.0 | 4 | 13438 | 2026-01-10 11:46:05 | 0 | NULL | 1 | 2026-01-10 11:51:44 | 12554 | 0 | NULL | ||
| 667 | 677 | POFN-1667 | INVFN-1667 | 12523 | 12517 | 2 | 1 | 23 | 8337.0 | 0.0 | 154.54 | 305.0 | 305.0 | 0.0 | 8182.46 | INR | 0.0 | 0.22 | 0.0 | 4 | 12523 | 2026-01-10 13:53:28 | 0 | NULL | 1 | 2026-01-10 15:40:26 | 12517 | 0 | NULL | ||
| 668 | 678 | POFN-1668 | INVFN-1668 | 12517 | 12516 | 2 | 1 | 30 | 9120.0 | 0.0 | 463.73 | 0.0 | 0.0 | 1391.19 | 8656.27 | INR | 0.0 | 1.5 | 0.0 | 4 | 12517 | 2026-01-10 15:40:06 | 0 | NULL | 1 | 2026-01-10 15:40:17 | 12516 | 0 | NULL | ||
| 669 | 679 | POFN-1669 | INVFN-1669 | 14323 | 12517 | 2 | 1 | 397 | 52616.0 | 0.0 | 948.75 | 2589.3 | 2589.3 | 0.0 | 51667.25 | INR | 0.0 | 0.34 | 0.0 | 4 | 14323 | 2026-01-10 16:02:57 | 0 | NULL | 1 | 2026-01-10 16:06:18 | 12517 | 0 | NULL | ||
| 670 | 680 | POFN-1670 | INVFN-1670 | 12517 | 12516 | 2 | 1 | 230 | 39070.0 | 0.0 | 2016.64 | 0.0 | 0.0 | 5459.35 | 37053.36 | INR | 0.0 | 0.45 | 0.0 | 4 | 12517 | 2026-01-10 16:16:59 | 0 | NULL | 2 | 2026-01-10 16:17:18 | 12516 | 0 | NULL | ||
| 671 | 681 | POFN-1671 | INVFN-1671 | 12517 | 12516 | 2 | 1 | 130 | 21920.0 | 0.0 | 1144.61 | 0.0 | 0.0 | 2843.24 | 20775.39 | INR | 0.0 | 0.45 | 0.0 | 4 | 12517 | 2026-01-10 16:18:01 | 0 | NULL | 1 | 2026-01-10 16:18:44 | 12516 | 0 | NULL | ||
| 672 | 682 | POFN-1672 | INVFN-1672 | 12516 | 1 | 2 | 1 | 50 | 7950.0 | 0.0 | 605.71 | 189.29 | 189.29 | 0.0 | 7344.29 | INR | 0.0 | 0.75 | 0.0 | 4 | 12516 | 2026-01-10 16:18:28 | 0 | NULL | 1 | 2026-01-10 16:18:37 | 1 | 0 | NULL | ||
| 673 | 683 | POFN-1673 | INVFN-1673 | 12517 | 12516 | 2 | 1 | 50 | 6000.0 | 0.0 | 305.08 | 0.0 | 0.0 | 915.25 | 5694.92 | INR | 0.0 | 0.55 | 0.0 | 4 | 12517 | 2026-01-10 16:19:35 | 0 | NULL | 1 | 2026-01-10 16:19:45 | 12516 | 0 | NULL | ||
| 674 | 684 | POFN-1674 | INVFN-1674 | 12517 | 12516 | 2 | 1 | 30 | 22500.0 | 0.0 | 1285.71 | 0.0 | 0.0 | 1071.43 | 21214.29 | INR | 0.0 | 3.0 | 0.0 | 4 | 12517 | 2026-01-10 16:21:05 | 0 | NULL | 1 | 2026-01-10 16:21:22 | 12516 | 0 | NULL | ||
| 675 | 685 | POFN-1675 | INVFN-1675 | 14323 | 12517 | 2 | 1 | 47 | 6957.0 | 0.0 | 118.58 | 513.94 | 513.94 | 0.0 | 6838.42 | INR | 0.0 | 0.21 | 0.0 | 4 | 14323 | 2026-01-10 16:26:54 | 0 | NULL | 1 | 2026-01-10 16:28:11 | 12517 | 0 | NULL | ||
| 676 | 686 | POFN-1676 | INVFN-1676 | 14323 | 12517 | 2 | 1 | 45 | 28660.0 | 0.0 | 475.62 | 1189.48 | 1189.48 | 0.0 | 28184.38 | INR | 0.0 | 0.06 | 0.0 | 4 | 14323 | 2026-01-10 16:46:16 | 0 | NULL | 1 | 2026-01-10 17:00:08 | 12517 | 0 | NULL | ||
| 677 | 687 | POFN-1677 | INVFN-1677 | 12517 | 12516 | 2 | 1 | 1 | 10500.0 | 0.0 | 300.0 | 0.0 | 0.0 | 500.0 | 10200.0 | INR | 0.0 | 3.0 | 0.0 | 4 | 12517 | 2026-01-10 16:48:31 | 0 | NULL | 1 | 2026-01-10 16:48:47 | 12516 | 0 | NULL | ||
| 678 | 688 | POFN-1678 | INVFN-1678 | 12517 | 12516 | 2 | 1 | 8 | 2568.0 | 0.0 | 130.58 | 0.0 | 0.0 | 391.73 | 2437.42 | INR | 0.0 | 0.18 | 0.0 | 4 | 12517 | 2026-01-10 16:55:50 | 0 | NULL | 1 | 2026-01-10 16:55:59 | 12516 | 0 | NULL | ||
| 679 | 689 | POFN-1679 | INVFN-1679 | 12516 | 1 | 2 | 1 | 100 | 32100.0 | 0.0 | 2176.27 | 2448.31 | 2448.31 | 0.0 | 29923.73 | INR | 0.0 | 2.2 | 0.0 | 4 | 12516 | 2026-01-10 16:59:03 | 0 | NULL | 1 | 2026-01-10 16:59:16 | 1 | 0 | NULL | ||
| 680 | 690 | POFN-1680 | INVFN-1680 | 12517 | 12516 | 2 | 1 | 50 | 16050.0 | 0.0 | 816.1 | 0.0 | 0.0 | 2448.31 | 15233.9 | INR | 0.0 | 1.1 | 0.0 | 4 | 12517 | 2026-01-10 16:59:53 | 0 | NULL | 1 | 2026-01-10 17:00:00 | 12516 | 0 | NULL | ||
| 681 | 691 | POFN-1681 | INVFN-1681 | 13536 | 12554 | 2 | 1 | 12 | 2586.0 | 0.0 | 43.93 | 194.72 | 194.72 | 0.0 | 2542.07 | INR | 0.0 | 0.06 | 0.0 | 4 | 13536 | 2026-01-10 17:10:28 | 0 | NULL | 1 | 2026-01-10 17:10:43 | 12554 | 0 | NULL | ||
| 682 | 692 | POFN-1682 | INVFN-1682 | 12527 | 12554 | 2 | 1 | 128 | 25938.0 | 0.0 | 460.32 | 0.0 | 0.0 | 2922.16 | 25477.68 | INR | 0.0 | 0.02 | 0.0 | 4 | 12527 | 2026-01-10 17:25:56 | 0 | NULL | 2 | 2026-01-13 16:01:10 | 12554 | 0 | NULL | ||
| 683 | 693 | POFN-1683 | INVFN-1683 | 12517 | 12516 | 2 | 1 | 3 | 54000.0 | 0.0 | 1200.0 | 0.0 | 0.0 | 2571.43 | 52800.0 | INR | 0.0 | 12.0 | 0.0 | 4 | 12517 | 2026-01-12 12:42:24 | 0 | NULL | 1 | 2026-01-12 12:42:37 | 12516 | 0 | NULL | ||
| 684 | 694 | POFN-1684 | INVFN-1684 | 12517 | 12516 | 2 | 1 | 20 | 35000.0 | 0.0 | 1528.57 | 0.0 | 0.0 | 1666.67 | 33471.43 | INR | 0.0 | 1.75 | 0.0 | 4 | 12517 | 2026-01-12 12:52:57 | 0 | NULL | 1 | 2026-01-12 12:53:07 | 12516 | 0 | NULL | ||
| 685 | 695 | POFN-1685 | INVFN-1685 | 13438 | 12554 | 2 | 1 | 3 | 1038.0 | 0.0 | 19.1 | 0.0 | 0.0 | 82.79 | 1018.9 | INR | 0.0 | 0.02 | 0.0 | 4 | 13438 | 2026-01-12 13:25:49 | 0 | NULL | 2 | 2026-01-12 13:44:40 | 12554 | 0 | NULL | ||
| 686 | 696 | POFN-1686 | INVFN-1686 | 13438 | 12554 | 2 | 1 | 3 | 360.0 | 0.0 | 6.1 | 0.0 | 0.0 | 54.92 | 353.9 | INR | 0.0 | 0.03 | 0.0 | 4 | 13438 | 2026-01-12 13:30:25 | 0 | NULL | 2 | 2026-01-12 13:44:40 | 12554 | 0 | NULL | ||
| 687 | 697 | POFN-1687 | INVFN-1687 | 13438 | 12554 | 2 | 1 | 3 | 360.0 | 0.0 | 6.1 | 0.0 | 0.0 | 54.92 | 353.9 | INR | 0.0 | 0.03 | 0.0 | 4 | 13438 | 2026-01-12 13:31:59 | 0 | NULL | 2 | 2026-01-12 13:44:40 | 12554 | 0 | NULL | ||
| 688 | 698 | POFN-1688 | INVFN-1688 | 13438 | 12517 | 2 | 1 | 10 | 1878.0 | 0.0 | 33.34 | 105.46 | 105.46 | 0.0 | 1844.66 | INR | 0.0 | 0.08 | 0.0 | 4 | 13438 | 2026-01-12 13:49:36 | 0 | NULL | 1 | 2026-01-12 13:51:15 | 12517 | 0 | NULL | ||
| 689 | 699 | POFN-1689 | INVFN-1689 | 13438 | 12517 | 2 | 1 | 14 | 672.0 | 0.0 | 12.8 | 16.0 | 16.0 | 0.0 | 659.2 | INR | 0.0 | 0.08 | 0.0 | 4 | 13438 | 2026-01-12 13:55:39 | 0 | NULL | 1 | 2026-01-12 13:56:12 | 12517 | 0 | NULL | ||
| 690 | 700 | POFN-1690 | INVFN-1690 | 13836 | 12517 | 2 | 1 | 28 | 2483.0 | 0.0 | 44.23 | 135.66 | 135.66 | 0.0 | 2438.77 | INR | 0.0 | 0.11 | 0.0 | 4 | 13836 | 2026-01-12 15:43:39 | 0 | NULL | 1 | 2026-01-12 15:46:55 | 12517 | 0 | NULL | ||
| 691 | 701 | POFN-1691 | INVFN-1691 | 12545 | 12517 | 2 | 1 | 53 | 5250.0 | 0.0 | 93.31 | 292.3 | 292.3 | 0.0 | 5156.69 | INR | 0.0 | 0.05 | 0.0 | 4 | 12545 | 2026-01-12 15:47:18 | 0 | NULL | 1 | 2026-01-12 15:47:32 | 12517 | 0 | NULL | ||
| 692 | 702 | POFN-1692 | INVFN-1692 | 12517 | 12516 | 2 | 1 | 3 | 7800.0 | 0.0 | 445.71 | 0.0 | 0.0 | 371.43 | 7354.29 | INR | 0.0 | 1.5 | 0.0 | 4 | 12517 | 2026-01-12 16:49:12 | 0 | NULL | 1 | 2026-01-12 16:49:28 | 12516 | 0 | NULL | ||
| 693 | 703 | POFN-1693 | INVFN-1693 | 12532 | 12517 | 2 | 1 | 62 | 47079.0 | 0.0 | 861.03 | 1228.03 | 1228.03 | 0.0 | 46217.97 | INR | 0.0 | 0.3 | 0.0 | 4 | 12532 | 2026-01-12 17:02:39 | 0 | NULL | 1 | 2026-01-12 17:35:41 | 12517 | 0 | NULL | ||
| 694 | 704 | POFN-1694 | INVFN-1694 | 12517 | 12516 | 2 | 1 | 30 | 21580.0 | 0.0 | 1233.14 | 0.0 | 0.0 | 1027.62 | 20346.86 | INR | 0.0 | 1.5 | 0.0 | 4 | 12517 | 2026-01-12 17:34:41 | 0 | NULL | 1 | 2026-01-12 17:35:24 | 12516 | 0 | NULL | ||
| 695 | 705 | POFN-1695 | INVFN-1695 | 13836 | 12517 | 2 | 1 | 14 | 1532.0 | 0.0 | 26.57 | 101.74 | 101.74 | 0.0 | 1505.43 | INR | 0.0 | 0.02 | 0.0 | 4 | 13836 | 2026-01-12 23:07:20 | 0 | NULL | 1 | 2026-01-12 23:09:07 | 12517 | 0 | NULL | ||
| 696 | 706 | POFN-1696 | INVFN-1696 | 12526 | 12517 | 2 | 1 | 183 | 19792.0 | 0.0 | 368.94 | 672.43 | 672.43 | 0.0 | 19423.06 | INR | 0.0 | 0.06 | 0.0 | 4 | 12526 | 2026-01-12 23:20:20 | 0 | NULL | 1 | 2026-01-12 23:23:33 | 12517 | 0 | NULL | ||
| 697 | 707 | POFN-1697 | INVFN-1697 | 12542 | 12554 | 2 | 1 | 127 | 11163.0 | 0.0 | 201.3 | 0.0 | 0.0 | 1097.84 | 10961.7 | INR | 0.0 | 0.08 | 0.0 | 4 | 12542 | 2026-01-13 11:00:12 | 0 | NULL | 1 | 2026-01-13 11:53:15 | 12554 | 0 | NULL | ||
| 698 | 708 | POFN-1698 | INVFN-1698 | 12552 | 12517 | 2 | 1 | 1 | 720.0 | 0.0 | 13.71 | 17.14 | 17.14 | 0.0 | 706.29 | INR | 0.0 | 0.15 | 0.0 | 4 | 12552 | 2026-01-13 12:19:22 | 0 | NULL | 1 | 2026-01-13 12:20:55 | 12517 | 0 | NULL | ||
| 699 | 709 | POFN-1699 | INVFN-1699 | 12517 | 12516 | 2 | 1 | 5 | 6000.0 | 0.0 | 342.86 | 0.0 | 0.0 | 285.71 | 5657.14 | INR | 0.0 | 1.25 | 0.0 | 4 | 12517 | 2026-01-13 12:20:20 | 0 | NULL | 1 | 2026-01-13 12:20:39 | 12516 | 0 | NULL | ||
| 700 | 710 | POFN-1700 | INVFN-1700 | 12526 | 12517 | 2 | 1 | 18 | 11333.0 | 0.0 | 214.29 | 309.37 | 309.37 | 0.0 | 11118.71 | INR | 0.0 | 0.1 | 0.0 | 4 | 12526 | 2026-01-13 12:27:54 | 0 | NULL | 1 | 2026-01-13 12:31:57 | 12517 | 0 | NULL |