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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 851 | 861 | POFN-1851 | INVFN-1851 | 12548 | 12517 | 2 | 1 | 161 | 15596.0 | 0.0 | 282.81 | 727.86 | 727.86 | 0.0 | 15596.0 | INR | 0.0 | 0.11 | 0.0 | 4 | 12548 | 2026-01-29 22:23:28 | 0 | NULL | 1 | 2026-01-30 08:12:53 | 12517 | 1 | 2026-01-30 08:12:53 | ||
| 852 | 862 | POFN-1852 | INVFN-1852 | 12547 | 12517 | 2 | 1 | 69 | 18254.0 | 0.0 | 342.6 | 562.06 | 562.06 | 0.0 | 18254.0 | INR | 0.0 | 0.02 | 0.0 | 4 | 12547 | 2026-01-29 22:53:00 | 0 | NULL | 1 | 2026-01-30 08:12:53 | 12517 | 1 | 2026-01-30 08:12:53 | ||
| 853 | 863 | POFN-1853 | INVFN-1853 | 12525 | 12517 | 2 | 1 | 20 | 2524.0 | 0.0 | 47.31 | 79.14 | 79.14 | 0.0 | 2524.0 | INR | 0.0 | 0.04 | 0.0 | 4 | 12525 | 2026-01-29 22:56:45 | 0 | NULL | 1 | 2026-01-30 08:12:53 | 12517 | 1 | 2026-01-30 08:12:53 | ||
| 854 | 864 | POFN-1854 | INVFN-1854 | 12528 | 12517 | 2 | 1 | 92 | 11155.0 | 0.0 | 211.77 | 283.19 | 283.19 | 0.0 | 11155.0 | INR | 0.0 | 0.25 | 0.0 | 4 | 12528 | 2026-01-30 12:08:52 | 0 | NULL | 1 | 2026-01-30 12:29:42 | 12517 | 1 | 2026-01-30 12:29:42 | ||
| 855 | 865 | POFN-1855 | INVFN-1855 | 12532 | 12517 | 2 | 1 | 386 | 62018.0 | 0.0 | 1167.65 | 1817.72 | 1817.72 | 0.0 | 62018.0 | INR | 0.0 | 0.04 | 0.0 | 4 | 12532 | 2026-01-30 16:41:49 | 0 | NULL | 1 | 2026-01-30 16:45:44 | 12517 | 1 | 2026-01-30 16:45:44 | ||
| 856 | 866 | POFN-1856 | INVFN-1856 | 12546 | 12517 | 2 | 1 | 77 | 11609.0 | 0.0 | 217.25 | 373.2 | 373.2 | 0.0 | 11609.0 | INR | 0.0 | 0.02 | 0.0 | 4 | 12546 | 2026-01-30 18:00:07 | 0 | NULL | 1 | 2026-01-30 18:01:16 | 12517 | 1 | 2026-01-30 18:01:16 | ||
| 857 | 867 | POFN-1857 | INVFN-1857 | 14490 | 12517 | 2 | 1 | 19 | 1911.0 | 0.0 | 33.4 | 120.57 | 120.57 | 0.0 | 1911.0 | INR | 0.0 | 0.06 | 0.0 | 4 | 14490 | 2026-01-30 20:09:40 | 0 | NULL | 1 | 2026-01-30 21:15:46 | 12517 | 1 | 2026-01-30 21:15:46 | ||
| 858 | 868 | POFN-1858 | INVFN-1858 | 12552 | 12517 | 2 | 1 | 80 | 14271.0 | 0.0 | 263.82 | 539.93 | 539.93 | 0.0 | 14271.0 | INR | 0.0 | 0.03 | 0.0 | 4 | 12552 | 2026-01-30 21:11:22 | 0 | NULL | 1 | 2026-01-30 21:15:46 | 12517 | 1 | 2026-01-30 21:15:46 | ||
| 859 | 869 | POFN-1859 | INVFN-1859 | 12525 | 12517 | 2 | 1 | 1 | 80.0 | 0.0 | 1.52 | 1.9 | 1.9 | 0.0 | 80.0 | INR | 0.0 | 0.01 | 0.0 | 4 | 12525 | 2026-01-30 22:12:30 | 0 | NULL | 1 | 2026-01-31 08:29:36 | 12517 | 1 | 2026-01-31 08:29:36 | ||
| 860 | 870 | POFN-1860 | INVFN-1860 | 12526 | 12517 | 2 | 1 | 46 | 13862.0 | 0.0 | 257.53 | 492.63 | 492.63 | 0.0 | 13862.0 | INR | 0.0 | 0.15 | 0.0 | 4 | 12526 | 2026-01-31 00:12:12 | 0 | NULL | 1 | 2026-01-31 08:29:36 | 12517 | 1 | 2026-01-31 08:29:36 | ||
| 861 | 871 | POFN-1861 | INVFN-1861 | 12516 | 1 | 2 | 2 | 2 | 21400.0 | 0.0 | 0.0 | 509.52 | 509.52 | 0.0 | 21400.0 | INR | 0.0 | 2.0 | 100.0 | 4 | 12516 | 2026-01-31 13:25:20 | 0 | NULL | 1 | 2026-01-31 13:25:30 | 1 | 1 | 2026-01-31 13:25:30 | ||
| 862 | 872 | POFN-1862 | INVFN-1862 | 12554 | 12516 | 2 | 2 | 2 | 21400.0 | 0.0 | 0.0 | 509.52 | 509.52 | 0.0 | 21400.0 | INR | 0.0 | 2.0 | 100.0 | 4 | 12554 | 2026-01-31 13:25:59 | 0 | NULL | 1 | 2026-01-31 13:26:15 | 12516 | 1 | 2026-01-31 13:26:15 | ||
| 863 | 873 | POFN-1863 | INVFN-1863 | 12555 | 12554 | 2 | 2 | 2 | 21400.0 | 0.0 | 0.0 | 509.52 | 509.52 | 0.0 | 21400.0 | INR | 0.0 | 2.0 | 100.0 | 4 | 12555 | 2026-01-31 13:26:38 | 0 | NULL | 1 | 2026-01-31 13:26:59 | 12554 | 1 | 2026-01-31 13:26:59 | ||
| 864 | 874 | POFN-1864 | INVFN-1864 | 12516 | 1 | 2 | 2 | 4 | 42800.0 | 0.0 | 0.0 | 1019.05 | 1019.05 | 0.0 | 42800.0 | INR | 0.0 | 4.0 | 200.0 | 4 | 12516 | 2026-01-31 13:33:35 | 0 | NULL | 1 | 2026-01-31 13:33:49 | 1 | 1 | 2026-01-31 13:33:49 | ||
| 865 | 875 | POFN-1865 | INVFN-1865 | 12517 | 12516 | 2 | 2 | 1 | 10700.0 | 0.0 | 0.0 | 0.0 | 0.0 | 509.52 | 10700.0 | INR | 0.0 | 1.0 | 50.0 | 4 | 12517 | 2026-01-31 13:39:06 | 0 | NULL | 1 | 2026-01-31 13:39:20 | 12516 | 1 | 2026-01-31 13:39:20 | ||
| 866 | 876 | POFN-1866 | INVFN-1866 | 12554 | 12516 | 2 | 2 | 2 | 21400.0 | 0.0 | 0.0 | 509.52 | 509.52 | 0.0 | 21400.0 | INR | 0.0 | 2.0 | 100.0 | 4 | 12554 | 2026-01-31 13:55:44 | 0 | NULL | 1 | 2026-01-31 13:56:02 | 12516 | 1 | 2026-01-31 13:56:02 | ||
| 867 | 877 | POFN-1867 | INVFN-1867 | 12555 | 12554 | 2 | 2 | 2 | 21400.0 | 0.0 | 0.0 | 509.52 | 509.52 | 0.0 | 21400.0 | INR | 0.0 | 2.0 | 100.0 | 4 | 12555 | 2026-01-31 13:56:23 | 0 | NULL | 1 | 2026-01-31 13:56:40 | 12554 | 1 | 2026-01-31 13:56:40 | ||
| 868 | 878 | POFN-1868 | INVFN-1868 | 12555 | 12554 | 2 | 1 | 5 | 13000.0 | 0.0 | 247.62 | 309.52 | 309.52 | 0.0 | 13000.0 | INR | 0.0 | 2.5 | 0.0 | 4 | 12555 | 2026-01-31 14:00:54 | 0 | NULL | 1 | 2026-01-31 14:01:07 | 12554 | 1 | 2026-01-31 14:01:07 | ||
| 869 | 879 | POFN-1869 | INVFN-1869 | 12554 | 12516 | 2 | 2 | 1 | 10700.0 | 0.0 | 0.0 | 254.76 | 254.76 | 0.0 | 10700.0 | INR | 0.0 | 1.0 | 50.0 | 4 | 12554 | 2026-01-31 14:10:48 | 0 | NULL | 1 | 2026-01-31 14:11:08 | 12516 | 1 | 2026-01-31 14:11:08 | ||
| 870 | 880 | POFN-1870 | INVFN-1870 | 12555 | 12554 | 2 | 2 | 1 | 10700.0 | 0.0 | 0.0 | 254.76 | 254.76 | 0.0 | 10700.0 | INR | 0.0 | 1.0 | 50.0 | 4 | 12555 | 2026-01-31 14:12:23 | 0 | NULL | 1 | 2026-01-31 14:12:46 | 12554 | 1 | 2026-01-31 14:12:46 | ||
| 871 | 881 | POFN-1871 | INVFN-1871 | 12548 | 12517 | 2 | 1 | 47 | 5552.0 | 0.0 | 99.14 | 297.55 | 297.55 | 0.0 | 5552.0 | INR | 0.0 | 0.12 | 0.0 | 4 | 12548 | 2026-01-31 15:32:23 | 0 | NULL | 1 | 2026-01-31 15:38:05 | 12517 | 1 | 2026-01-31 15:38:05 | ||
| 872 | 882 | POFN-1872 | INVFN-1872 | 12516 | 1 | 2 | 2 | 5 | 53500.0 | 0.0 | 0.0 | 1273.81 | 1273.81 | 0.0 | 53500.0 | INR | 0.0 | 5.0 | 250.0 | 4 | 12516 | 2026-01-31 17:11:37 | 0 | NULL | 1 | 2026-01-31 17:11:46 | 1 | 1 | 2026-01-31 17:11:46 | ||
| 873 | 883 | POFN-1873 | INVFN-1873 | 12554 | 12516 | 2 | 2 | 5 | 53500.0 | 0.0 | 0.0 | 1273.81 | 1273.81 | 0.0 | 53500.0 | INR | 0.0 | 5.0 | 250.0 | 4 | 12554 | 2026-01-31 17:12:05 | 0 | NULL | 1 | 2026-01-31 17:12:16 | 12516 | 1 | 2026-01-31 17:12:16 | ||
| 874 | 884 | POFN-1874 | INVFN-1874 | 12555 | 12554 | 2 | 2 | 3 | 32100.0 | 0.0 | 0.0 | 764.29 | 764.29 | 0.0 | 32100.0 | INR | 0.0 | 3.0 | 150.0 | 4 | 12555 | 2026-01-31 17:12:56 | 0 | NULL | 1 | 2026-01-31 17:13:05 | 12554 | 1 | 2026-01-31 17:13:05 | ||
| 875 | 885 | POFN-1875 | INVFN-1875 | 12555 | 12554 | 2 | 2 | 2 | 21400.0 | 0.0 | 0.0 | 509.52 | 509.52 | 0.0 | 21400.0 | INR | 0.0 | 2.0 | 100.0 | 4 | 12555 | 2026-01-31 17:16:09 | 0 | NULL | 1 | 2026-01-31 17:16:22 | 12554 | 1 | 2026-01-31 17:16:22 | ||
| 876 | 886 | POFN-1876 | INVFN-1876 | 12534 | 12517 | 2 | 1 | 2 | 21000.0 | 0.0 | 150.0 | 500.0 | 500.0 | 0.0 | 21000.0 | INR | 0.0 | 6.0 | 0.0 | 4 | 12534 | 2026-01-31 17:29:07 | 0 | NULL | 1 | 2026-01-31 18:42:17 | 12517 | 1 | 2026-01-31 18:42:17 | ||
| 877 | 887 | POFN-1877 | INVFN-1877 | 12516 | 1 | 2 | 2 | 170 | 1975000.0 | 0.0 | 0.0 | 47023.81 | 47023.81 | 0.0 | 1975000.0 | INR | 0.0 | 150.0 | 7500.0 | 4 | 12516 | 2026-01-31 17:30:46 | 0 | NULL | 1 | 2026-01-31 17:30:58 | 1 | 1 | 2026-01-31 17:30:58 | ||
| 878 | 888 | POFN-1878 | INVFN-1878 | 12517 | 12516 | 2 | 2 | 100 | 1070000.0 | 0.0 | 300.0 | 0.0 | 0.0 | 50952.38 | 1070000.0 | INR | 0.0 | 100.0 | 5000.0 | 4 | 12517 | 2026-01-31 18:55:11 | 0 | NULL | 1 | 2026-01-31 18:55:25 | 12516 | 1 | 2026-01-31 18:55:25 | ||
| 879 | 889 | POFN-1879 | INVFN-1879 | 14490 | 12517 | 2 | 1 | 37 | 3960.0 | 0.0 | 70.14 | 226.49 | 226.49 | 0.0 | 3960.0 | INR | 0.0 | 0.18 | 0.0 | 4 | 14490 | 2026-01-31 19:04:03 | 0 | NULL | 1 | 2026-01-31 19:58:29 | 12517 | 1 | 2026-01-31 19:58:29 | ||
| 880 | 890 | POFN-1880 | INVFN-1880 | 12526 | 12517 | 2 | 1 | 1 | 304.0 | 0.0 | 5.15 | 23.19 | 23.19 | 0.0 | 304.0 | INR | 0.0 | 0.05 | 0.0 | 4 | 12526 | 2026-01-31 20:09:21 | 0 | NULL | 1 | 2026-01-31 20:40:39 | 12517 | 1 | 2026-01-31 20:40:39 | ||
| 881 | 891 | POFN-1881 | INVFN-1881 | 12526 | 12517 | 2 | 1 | 199 | 30294.0 | 0.0 | 561.99 | 1097.24 | 1097.24 | 0.0 | 30294.0 | INR | 0.0 | 0.1 | 0.0 | 4 | 12526 | 2026-01-31 21:01:36 | 0 | NULL | 1 | 2026-01-31 21:10:25 | 12517 | 1 | 2026-01-31 21:10:25 | ||
| 882 | 892 | POFN-1882 | INVFN-1882 | 12517 | 12516 | 2 | 2 | 20 | 370000.0 | 0.0 | 500.0 | 0.0 | 0.0 | 17619.05 | 370000.0 | INR | 0.0 | 40.0 | 2000.0 | 4 | 12517 | 2026-01-31 21:52:00 | 0 | NULL | 1 | 2026-01-31 21:52:25 | 12516 | 1 | 2026-01-31 21:52:25 | ||
| 883 | 893 | POFN-1883 | INVFN-1883 | 12516 | 1 | 2 | 2 | 15 | 281250.0 | 0.0 | 0.0 | 6696.43 | 6696.43 | 0.0 | 281250.0 | INR | 0.0 | 30.0 | 1500.0 | 4 | 12516 | 2026-01-31 22:12:28 | 0 | NULL | 1 | 2026-01-31 22:12:49 | 1 | 1 | 2026-01-31 22:12:49 | ||
| 884 | 894 | POFN-1884 | INVFN-1884 | 12517 | 12516 | 2 | 2 | 10 | 187500.0 | 0.0 | 500.0 | 0.0 | 0.0 | 8928.57 | 187500.0 | INR | 0.0 | 20.0 | 1000.0 | 4 | 12517 | 2026-01-31 22:13:39 | 0 | NULL | 1 | 2026-01-31 22:14:10 | 12516 | 1 | 2026-01-31 22:14:10 | ||
| 885 | 895 | POFN-1885 | INVFN-1885 | 12552 | 12517 | 2 | 1 | 1 | 1200.0 | 0.0 | 22.86 | 28.57 | 28.57 | 0.0 | 1200.0 | INR | 0.0 | 0.25 | 0.0 | 4 | 12552 | 2026-01-31 22:26:29 | 0 | NULL | 1 | 2026-01-31 22:33:08 | 12517 | 1 | 2026-01-31 22:33:08 | ||
| 886 | 896 | POFN-1886 | INVFN-1886 | 13438 | 12517 | 2 | 1 | 4 | 648.0 | 0.0 | 11.84 | 28.02 | 28.02 | 0.0 | 648.0 | INR | 0.0 | 0.02 | 0.0 | 4 | 13438 | 2026-01-31 23:06:52 | 0 | NULL | 1 | 2026-01-31 23:07:30 | 12517 | 1 | 2026-01-31 23:07:30 | ||
| 887 | 897 | POFN-1887 | INVFN-1887 | 12517 | 12516 | 2 | 1 | 40 | 30000.0 | 0.0 | 1349.88 | 0.0 | 0.0 | 3002.42 | 30000.0 | INR | 0.0 | 2.0 | 0.0 | 4 | 12517 | 2026-02-02 13:04:59 | 0 | NULL | 1 | 2026-02-02 13:06:05 | 12516 | 1 | 2026-02-02 13:06:05 | ||
| 888 | 898 | POFN-1888 | INVFN-1888 | 12516 | 1 | 2 | 1 | 25 | 18750.0 | 0.0 | 1334.14 | 1036.62 | 1036.62 | 0.0 | 18750.0 | INR | 0.0 | 1.0 | 0.0 | 4 | 12516 | 2026-02-02 13:05:48 | 0 | NULL | 1 | 2026-02-02 13:05:56 | 1 | 1 | 2026-02-02 13:05:56 | ||
| 889 | 899 | POFN-1889 | INVFN-1889 | 12517 | 12516 | 2 | 1 | 1 | 750.0 | 0.0 | 35.71 | 0.0 | 0.0 | 35.71 | 750.0 | INR | 0.0 | 0.1 | 0.0 | 4 | 12517 | 2026-02-02 13:50:53 | 0 | NULL | 1 | 2026-02-02 13:51:05 | 12516 | 1 | 2026-02-02 13:51:05 | ||
| 890 | 900 | POFN-1890 | INVFN-1890 | 12554 | 12516 | 2 | 2 | 2 | 21400.0 | 0.0 | 1019.05 | 509.52 | 509.52 | 0.0 | 21400.0 | INR | 0.0 | 2.0 | 100.0 | 4 | 12554 | 2026-02-02 16:08:14 | 0 | NULL | 2 | 2026-04-18 16:16:51 | 12516 | 0 | NULL | ||
| 891 | 901 | POFN-1891 | INVFN-1891 | 13518 | 12554 | 2 | 1 | 13 | 10801.0 | 0.0 | 202.96 | 326.52 | 326.52 | 0.0 | 10801.0 | INR | 0.0 | 0.1 | 0.0 | 4 | 13518 | 2026-02-02 16:31:09 | 0 | NULL | 1 | 2026-02-02 17:07:20 | 12554 | 1 | 2026-02-02 17:07:20 | ||
| 892 | 902 | POFN-1892 | INVFN-1892 | 12554 | 12516 | 2 | 1 | 20 | 5580.0 | 0.0 | 265.71 | 132.86 | 132.86 | 0.0 | 5580.0 | INR | 0.0 | 1.0 | 0.0 | 4 | 12554 | 2026-02-02 17:06:55 | 0 | NULL | 1 | 2026-02-02 17:07:09 | 12516 | 1 | 2026-02-02 17:07:09 | ||
| 893 | 903 | POFN-1893 | INVFN-1893 | 14079 | 12517 | 2 | 1 | 11 | 4620.0 | 0.0 | 85.52 | 171.96 | 171.96 | 0.0 | 4620.0 | INR | 0.0 | 0.02 | 0.0 | 4 | 14079 | 2026-02-03 00:20:38 | 0 | NULL | 1 | 2026-02-03 14:30:37 | 12517 | 1 | 2026-02-03 14:30:37 | ||
| 894 | 904 | POFN-1894 | INVFN-1894 | 12534 | 12517 | 2 | 2 | 1 | 10700.0 | 0.0 | 203.81 | 254.76 | 254.76 | 0.0 | 10700.0 | INR | 0.0 | 1.0 | 50.0 | 4 | 12534 | 2026-02-03 13:41:23 | 0 | NULL | 1 | 2026-02-03 14:30:37 | 12517 | 1 | 2026-02-03 14:30:37 | ||
| 895 | 905 | POFN-1895 | INVFN-1895 | 12534 | 12517 | 2 | 2 | 1 | 10700.0 | 0.0 | 203.81 | 254.76 | 254.76 | 0.0 | 10700.0 | INR | 0.0 | 1.0 | 50.0 | 4 | 12534 | 2026-02-03 14:26:06 | 0 | NULL | 1 | 2026-02-03 15:11:57 | 12517 | 1 | 2026-02-03 15:11:57 | ||
| 896 | 906 | POFN-1896 | INVFN-1896 | 12554 | 12516 | 2 | 1 | 8 | 11980.0 | 0.0 | 597.9 | 285.24 | 285.24 | 0.0 | 11980.0 | INR | 0.0 | 0.0 | 0.0 | 4 | 12554 | 2026-02-03 15:32:58 | 0 | NULL | 1 | 2026-02-03 15:33:18 | 12516 | 1 | 2026-02-03 15:33:18 | ||
| 897 | 907 | POFN-1897 | INVFN-1897 | 12543 | 12517 | 2 | 1 | 10 | 5117.0 | 0.0 | 93.1 | 231.01 | 231.01 | 0.0 | 5117.0 | INR | 0.0 | 0.02 | 0.0 | 4 | 12543 | 2026-02-04 00:37:24 | 0 | NULL | 1 | 2026-02-04 12:14:27 | 12517 | 1 | 2026-02-04 12:14:27 | ||
| 898 | 908 | POFN-1898 | INVFN-1898 | 12532 | 12517 | 2 | 1 | 4 | 10400.0 | 0.0 | 198.1 | 247.62 | 247.62 | 0.0 | 10400.0 | INR | 0.0 | 2.0 | 0.0 | 4 | 12532 | 2026-02-04 20:21:19 | 0 | NULL | 1 | 2026-02-04 20:30:15 | 12517 | 1 | 2026-02-04 20:30:15 | ||
| 899 | 909 | POFN-1899 | INVFN-1899 | 12528 | 12517 | 2 | 1 | 169 | 17387.0 | 0.0 | 319.65 | 702.25 | 702.25 | 0.0 | 17387.0 | INR | 0.0 | 0.62 | 0.0 | 4 | 12528 | 2026-02-05 15:01:23 | 0 | NULL | 1 | 2026-02-05 17:05:18 | 12517 | 1 | 2026-02-05 17:05:18 | ||
| 900 | 910 | POFN-1900 | INVFN-1900 | 12548 | 12517 | 2 | 1 | 21 | 10520.0 | 0.0 | 193.41 | 424.65 | 424.65 | 0.0 | 10520.0 | INR | 0.0 | 0.75 | 0.0 | 4 | 12548 | 2026-02-05 15:35:25 | 0 | NULL | 1 | 2026-02-05 17:05:18 | 12517 | 1 | 2026-02-05 17:05:18 |