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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 751 | 761 | POFN-1751 | INVFN-1751 | 12533 | 12517 | 2 | 1 | 39 | 13633.0 | 0.0 | 206.79 | 396.62 | 396.62 | 0.0 | 13426.21 | INR | 0.0 | 0.02 | 0.0 | 4 | 12533 | 2026-01-16 20:47:38 | 0 | NULL | 1 | 2026-01-16 20:50:18 | 12517 | 0 | NULL | ||
| 752 | 762 | POFN-1752 | INVFN-1752 | 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-16 20:57:23 | 0 | NULL | 1 | 2026-01-16 21:04:04 | 12554 | 0 | NULL | ||
| 753 | 763 | POFN-1753 | INVFN-1753 | 13536 | 12554 | 2 | 1 | 27 | 3841.0 | 0.0 | 68.96 | 196.48 | 196.48 | 0.0 | 3772.04 | INR | 0.0 | 0.11 | 0.0 | 4 | 13536 | 2026-01-16 21:01:38 | 0 | NULL | 1 | 2026-01-16 21:04:04 | 12554 | 0 | NULL | ||
| 754 | 764 | POFN-1754 | INVFN-1754 | 12554 | 12516 | 2 | 1 | 2 | 21000.0 | 0.0 | 600.0 | 500.0 | 500.0 | 0.0 | 20400.0 | INR | 0.0 | 6.0 | 0.0 | 4 | 12554 | 2026-01-16 21:02:57 | 0 | NULL | 1 | 2026-01-16 21:03:36 | 12516 | 0 | NULL | ||
| 755 | 765 | POFN-1755 | INVFN-1755 | 13438 | 12517 | 2 | 1 | 79 | 10158.0 | 0.0 | 182.91 | 506.26 | 506.26 | 0.0 | 9975.09 | INR | 0.0 | 0.11 | 0.0 | 4 | 13438 | 2026-01-16 21:03:04 | 0 | NULL | 1 | 2026-01-16 21:05:53 | 12517 | 0 | NULL | ||
| 756 | 766 | POFN-1756 | INVFN-1756 | 12517 | 12516 | 2 | 1 | 6 | 3000.0 | 0.0 | 152.54 | 0.0 | 0.0 | 457.63 | 2847.46 | INR | 0.0 | 0.6 | 0.0 | 4 | 12517 | 2026-01-16 21:05:25 | 0 | NULL | 1 | 2026-01-16 21:05:40 | 12516 | 0 | NULL | ||
| 757 | 767 | POFN-1757 | INVFN-1757 | 13438 | 12517 | 2 | 1 | 10 | 2040.0 | 0.0 | 38.86 | 48.57 | 48.57 | 0.0 | 2001.14 | INR | 0.0 | 0.4 | 0.0 | 4 | 13438 | 2026-01-16 21:15:42 | 0 | NULL | 1 | 2026-01-16 21:16:48 | 12517 | 0 | NULL | ||
| 758 | 768 | POFN-1758 | INVFN-1758 | 13438 | 12517 | 2 | 1 | 20 | 3180.0 | 0.0 | 53.9 | 242.54 | 242.54 | 0.0 | 3126.1 | INR | 0.0 | 0.5 | 0.0 | 4 | 13438 | 2026-01-16 21:18:50 | 0 | NULL | 1 | 2026-01-16 21:28:32 | 12517 | 0 | NULL | ||
| 759 | 769 | POFN-1759 | INVFN-1759 | 12529 | 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 | 12529 | 2026-01-16 21:30:39 | 0 | NULL | 1 | 2026-01-16 21:41:40 | 12517 | 0 | NULL | ||
| 760 | 770 | POFN-1760 | INVFN-1760 | 12529 | 12517 | 2 | 1 | 21 | 1008.0 | 0.0 | 19.2 | 24.0 | 24.0 | 0.0 | 988.8 | INR | 0.0 | 0.13 | 0.0 | 4 | 12529 | 2026-01-16 21:32:28 | 0 | NULL | 1 | 2026-01-16 21:38:04 | 12517 | 0 | NULL | ||
| 761 | 771 | POFN-1761 | INVFN-1761 | 12529 | 12517 | 2 | 1 | 1 | 304.0 | 0.0 | 5.15 | 23.19 | 23.19 | 0.0 | 298.85 | INR | 0.0 | 0.05 | 0.0 | 4 | 12529 | 2026-01-16 21:33:03 | 0 | NULL | 1 | 2026-01-16 21:38:04 | 12517 | 0 | NULL | ||
| 762 | 772 | POFN-1762 | INVFN-1762 | 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-16 21:38:49 | 0 | NULL | 1 | 2026-01-16 21:39:05 | 12516 | 0 | NULL | ||
| 763 | 773 | POFN-1763 | INVFN-1763 | 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-16 21:40:20 | 0 | NULL | 1 | 2026-01-16 21:40:57 | 12516 | 0 | NULL | ||
| 764 | 774 | POFN-1764 | INVFN-1764 | 13438 | 12517 | 2 | 1 | 5 | 795.0 | 0.0 | 15.14 | 18.93 | 18.93 | 0.0 | 779.86 | INR | 0.0 | 0.08 | 0.0 | 4 | 13438 | 2026-01-16 21:45:16 | 0 | NULL | 1 | 2026-01-16 21:47:42 | 12517 | 0 | NULL | ||
| 765 | 775 | POFN-1765 | INVFN-1765 | 13438 | 12517 | 2 | 1 | 20 | 1600.0 | 0.0 | 30.48 | 38.1 | 38.1 | 0.0 | 1569.52 | INR | 0.0 | 0.18 | 0.0 | 4 | 13438 | 2026-01-16 21:46:46 | 0 | NULL | 1 | 2026-01-16 21:47:42 | 12517 | 0 | NULL | ||
| 766 | 776 | POFN-1766 | INVFN-1766 | 12546 | 12517 | 2 | 1 | 7 | 2669.0 | 0.0 | 50.79 | 64.65 | 64.65 | 0.0 | 2618.21 | INR | 0.0 | 0.15 | 0.0 | 4 | 12546 | 2026-01-16 22:27:40 | 0 | NULL | 1 | 2026-01-16 23:00:06 | 12517 | 0 | NULL | ||
| 767 | 777 | POFN-1767 | INVFN-1767 | 12546 | 12517 | 2 | 1 | 84 | 4032.0 | 0.0 | 76.8 | 96.0 | 96.0 | 0.0 | 3955.2 | INR | 0.0 | 0.5 | 0.0 | 4 | 12546 | 2026-01-16 22:42:08 | 0 | NULL | 1 | 2026-01-16 23:00:06 | 12517 | 0 | NULL | ||
| 768 | 778 | POFN-1768 | INVFN-1768 | 12516 | 1 | 2 | 1 | 6 | 63000.0 | 0.0 | 2400.0 | 1500.0 | 1500.0 | 0.0 | 60600.0 | INR | 0.0 | 18.0 | 0.0 | 4 | 12516 | 2026-01-16 23:00:58 | 0 | NULL | 1 | 2026-01-16 23:01:16 | 1 | 0 | NULL | ||
| 769 | 779 | POFN-1769 | INVFN-1769 | 12517 | 12516 | 2 | 1 | 9 | 55000.0 | 0.0 | 1942.86 | 0.0 | 0.0 | 2619.05 | 53057.14 | INR | 0.0 | 12.0 | 0.0 | 4 | 12517 | 2026-01-16 23:02:35 | 0 | NULL | 1 | 2026-01-16 23:03:04 | 12516 | 0 | NULL | ||
| 770 | 780 | POFN-1770 | INVFN-1770 | 13438 | 12517 | 2 | 1 | 1 | 2600.0 | 0.0 | 49.52 | 61.9 | 61.9 | 0.0 | 2550.48 | INR | 0.0 | 0.5 | 0.0 | 4 | 13438 | 2026-01-16 23:08:15 | 0 | NULL | 1 | 2026-01-16 23:09:21 | 12517 | 0 | NULL | ||
| 771 | 781 | POFN-1771 | INVFN-1771 | 12554 | 12516 | 2 | 1 | 2 | 21000.0 | 0.0 | 600.0 | 500.0 | 500.0 | 0.0 | 20400.0 | INR | 0.0 | 6.0 | 0.0 | 4 | 12554 | 2026-01-16 23:10:15 | 0 | NULL | 1 | 2026-01-16 23:10:38 | 12516 | 0 | NULL | ||
| 772 | 782 | POFN-1772 | INVFN-1772 | 13536 | 12554 | 2 | 1 | 14 | 1120.0 | 0.0 | 21.62 | 19.43 | 19.43 | 0.0 | 1098.38 | INR | 0.0 | 0.05 | 0.0 | 4 | 13536 | 2026-01-16 23:24:06 | 0 | NULL | 1 | 2026-01-16 23:24:28 | 12554 | 0 | NULL | ||
| 773 | 783 | POFN-1773 | INVFN-1773 | 13536 | 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 | 13536 | 2026-01-16 23:26:14 | 0 | NULL | 1 | 2026-01-16 23:26:46 | 12554 | 0 | NULL | ||
| 774 | 784 | POFN-1774 | INVFN-1774 | 13536 | 12554 | 2 | 1 | 2 | 408.0 | 0.0 | 7.77 | 9.71 | 9.71 | 0.0 | 400.23 | INR | 0.0 | 0.08 | 0.0 | 4 | 13536 | 2026-01-16 23:30:01 | 0 | NULL | 1 | 2026-01-16 23:31:00 | 12554 | 0 | NULL | ||
| 775 | 785 | POFN-1775 | INVFN-1775 | 12516 | 1 | 2 | 1 | 50 | 130000.0 | 0.0 | 9904.76 | 3095.24 | 3095.24 | 0.0 | 120095.24 | INR | 0.0 | 25.0 | 0.0 | 4 | 12516 | 2026-01-19 12:28:56 | 0 | NULL | 1 | 2026-01-19 12:30:59 | 1 | 0 | NULL | ||
| 776 | 786 | POFN-1776 | INVFN-1776 | 12516 | 1 | 2 | 1 | 30 | 36000.0 | 0.0 | 2742.86 | 857.14 | 857.14 | 0.0 | 33257.14 | INR | 0.0 | 7.5 | 0.0 | 4 | 12516 | 2026-01-19 12:31:58 | 0 | NULL | 1 | 2026-01-19 12:32:10 | 1 | 0 | NULL | ||
| 777 | 787 | POFN-1777 | INVFN-1777 | 12517 | 12516 | 2 | 1 | 60 | 85785.0 | 0.0 | 4902.0 | 0.0 | 0.0 | 4085.0 | 80883.0 | INR | 0.0 | 2.25 | 0.0 | 4 | 12517 | 2026-01-19 12:38:48 | 0 | NULL | 1 | 2026-01-19 12:38:59 | 12516 | 0 | NULL | ||
| 778 | 788 | POFN-1778 | INVFN-1778 | 12516 | 1 | 2 | 1 | 20 | 5200.0 | 0.0 | 352.54 | 396.61 | 396.61 | 0.0 | 4847.46 | INR | 0.0 | 0.42 | 0.0 | 4 | 12516 | 2026-01-19 14:51:47 | 0 | NULL | 1 | 2026-01-19 14:53:34 | 1 | 0 | NULL | ||
| 779 | 789 | POFN-1779 | INVFN-1779 | 12517 | 12516 | 2 | 1 | 15 | 3900.0 | 0.0 | 198.31 | 0.0 | 0.0 | 594.92 | 3701.69 | INR | 0.0 | 0.32 | 0.0 | 4 | 12517 | 2026-01-19 14:54:13 | 0 | NULL | 1 | 2026-01-19 14:54:29 | 12516 | 0 | NULL | ||
| 780 | 790 | POFN-1780 | INVFN-1780 | 12529 | 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 | 12529 | 2026-01-19 14:57:39 | 0 | NULL | 1 | 2026-01-19 15:06:45 | 12517 | 0 | NULL | ||
| 781 | 791 | POFN-1781 | INVFN-1781 | 12529 | 12517 | 2 | 1 | 3 | 622.0 | 0.0 | 10.54 | 47.44 | 47.44 | 0.0 | 611.46 | INR | 0.0 | 0.05 | 0.0 | 4 | 12529 | 2026-01-19 15:00:04 | 0 | NULL | 1 | 2026-01-19 15:06:45 | 12517 | 0 | NULL | ||
| 782 | 792 | POFN-1782 | INVFN-1782 | 12528 | 12517 | 2 | 1 | 143 | 17988.0 | 0.0 | 331.51 | 706.37 | 706.37 | 0.0 | 17656.49 | INR | 0.0 | 0.08 | 0.0 | 4 | 12528 | 2026-01-19 15:15:09 | 0 | NULL | 1 | 2026-01-19 16:13:52 | 12517 | 0 | NULL | ||
| 783 | 793 | POFN-1783 | INVFN-1783 | 12543 | 12517 | 2 | 1 | 3 | 11058.0 | 0.0 | 160.63 | 263.29 | 263.29 | 0.0 | 10897.37 | INR | 0.0 | 0.1 | 0.0 | 4 | 12543 | 2026-01-19 19:13:18 | 0 | NULL | 1 | 2026-01-19 19:32:27 | 12517 | 0 | NULL | ||
| 784 | 794 | POFN-1784 | INVFN-1784 | 12549 | 12517 | 2 | 1 | 24 | 10141.0 | 0.0 | 185.3 | 437.92 | 437.92 | 0.0 | 9955.7 | INR | 0.0 | 0.04 | 0.0 | 4 | 12549 | 2026-01-19 19:58:07 | 0 | NULL | 1 | 2026-01-19 20:00:52 | 12517 | 0 | NULL | ||
| 785 | 795 | POFN-1785 | INVFN-1785 | 13536 | 12554 | 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 | 13536 | 2026-01-20 13:18:44 | 0 | NULL | 1 | 2026-01-20 13:19:01 | 12554 | 0 | NULL | ||
| 786 | 796 | POFN-1786 | INVFN-1786 | 12855 | 12551 | 2 | 1 | 1 | 7980.0 | 0.0 | 154.95 | 116.21 | 116.21 | 0.0 | 7825.05 | INR | 0.0 | 2.0 | 0.0 | 4 | 12855 | 2026-01-20 13:38:02 | 0 | NULL | 1 | 2026-01-20 13:39:33 | 12551 | 0 | NULL | ||
| 787 | 797 | POFN-1787 | INVFN-1787 | 12551 | 12516 | 2 | 1 | 5 | 9192.0 | 0.0 | 534.11 | 145.07 | 145.07 | 0.0 | 8657.89 | INR | 0.0 | 0.12 | 0.0 | 4 | 12551 | 2026-01-20 13:56:00 | 0 | NULL | 2 | 2026-04-18 16:16:51 | 12516 | 0 | NULL | ||
| 788 | 798 | POFN-1788 | INVFN-1788 | 12551 | 12516 | 2 | 1 | 6 | 10791.0 | 0.0 | 625.48 | 183.14 | 183.14 | 0.0 | 10165.52 | INR | 0.0 | 0.12 | 0.0 | 4 | 12551 | 2026-01-20 14:20:30 | 0 | NULL | 2 | 2026-04-18 16:16:51 | 12516 | 0 | NULL | ||
| 789 | 799 | POFN-1789 | INVFN-1789 | 12855 | 12551 | 2 | 1 | 4 | 3606.0 | 0.0 | 68.69 | 85.86 | 85.86 | 0.0 | 3537.31 | INR | 0.0 | 0.08 | 0.0 | 4 | 12855 | 2026-01-20 17:05:17 | 0 | NULL | 1 | 2026-01-20 18:33:00 | 12551 | 0 | NULL | ||
| 790 | 800 | POFN-1790 | INVFN-1790 | 12529 | 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 | 12529 | 2026-01-20 17:52:52 | 0 | NULL | 1 | 2026-01-21 13:44:30 | 12517 | 0 | NULL | ||
| 791 | 801 | POFN-1791 | INVFN-1791 | 12517 | 12516 | 2 | 1 | 10 | 20000.0 | 0.0 | 1165.05 | 0.0 | 0.0 | 582.52 | 18834.95 | INR | 0.0 | 4.0 | 0.0 | 4 | 12517 | 2026-01-21 15:02:00 | 0 | NULL | 1 | 2026-01-21 15:02:17 | 12516 | 0 | NULL | ||
| 792 | 802 | POFN-1792 | INVFN-1792 | 14079 | 12517 | 2 | 1 | 42 | 3931.0 | 0.0 | 71.85 | 169.19 | 169.19 | 0.0 | 3859.15 | INR | 0.0 | 0.01 | 0.0 | 4 | 14079 | 2026-01-21 22:59:50 | 0 | NULL | 1 | 2026-01-22 11:34:48 | 12517 | 0 | NULL | ||
| 793 | 803 | POFN-1793 | INVFN-1793 | 12855 | 12551 | 2 | 1 | 1 | 14999.0 | 0.0 | 150.0 | 218.43 | 218.43 | 0.0 | 14849.0 | INR | 0.0 | 3.0 | 0.0 | 4 | 12855 | 2026-01-23 13:25:41 | 0 | NULL | 1 | 2026-01-23 13:28:26 | 12551 | 0 | NULL | ||
| 794 | 804 | POFN-1794 | INVFN-1794 | 12541 | 12517 | 2 | 1 | 72 | 9568.0 | 0.0 | 169.65 | 542.68 | 542.68 | 0.0 | 9398.35 | INR | 0.0 | 0.01 | 0.0 | 4 | 12541 | 2026-01-23 16:20:15 | 0 | NULL | 1 | 2026-01-23 16:38:31 | 12517 | 0 | NULL | ||
| 795 | 805 | POFN-1795 | INVFN-1795 | 12541 | 12517 | 2 | 1 | 5 | 782.0 | 0.0 | 14.52 | 28.06 | 28.06 | 0.0 | 767.48 | INR | 0.0 | 0.05 | 0.0 | 4 | 12541 | 2026-01-23 16:22:51 | 0 | NULL | 1 | 2026-01-23 16:38:31 | 12517 | 0 | NULL | ||
| 796 | 806 | POFN-1796 | INVFN-1796 | 12546 | 12517 | 2 | 1 | 84 | 9234.0 | 0.0 | 172.64 | 300.92 | 300.92 | 0.0 | 9061.36 | INR | 0.0 | 0.11 | 0.0 | 4 | 12546 | 2026-01-23 16:33:47 | 0 | NULL | 1 | 2026-01-23 16:41:55 | 12517 | 0 | NULL | ||
| 797 | 807 | POFN-1797 | INVFN-1797 | 12517 | 12516 | 2 | 1 | 10 | 1590.0 | 0.0 | 90.86 | 0.0 | 0.0 | 75.71 | 1499.14 | INR | 0.0 | 0.15 | 0.0 | 4 | 12517 | 2026-01-23 16:41:23 | 0 | NULL | 1 | 2026-01-23 16:41:35 | 12516 | 0 | NULL | ||
| 798 | 808 | POFN-1798 | INVFN-1798 | 14079 | 12517 | 2 | 1 | 15 | 4626.0 | 0.0 | 86.77 | 143.67 | 143.67 | 0.0 | 4539.23 | INR | 0.0 | 0.12 | 0.0 | 4 | 14079 | 2026-01-23 16:50:06 | 0 | NULL | 1 | 2026-01-23 16:50:48 | 12517 | 0 | NULL | ||
| 799 | 809 | POFN-1799 | INVFN-1799 | 14569 | 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 | 14569 | 2026-01-23 17:29:26 | 0 | NULL | 1 | 2026-01-23 17:33:55 | 12517 | 0 | NULL | ||
| 800 | 810 | POFN-1800 | INVFN-1800 | 13438 | 12517 | 2 | 1 | 37 | 5274.0 | 0.0 | 100.46 | 125.57 | 125.57 | 0.0 | 5173.54 | INR | 0.0 | 0.4 | 0.0 | 4 | 13438 | 2026-01-23 19:05:41 | 0 | NULL | 1 | 2026-01-23 19:29:14 | 12517 | 0 | NULL |