fx_franchise_order

1,057 rows · 31 columns · page 14 / 22

Excel export
# 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 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
652 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
653 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
654 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
655 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
656 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
657 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
658 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
659 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
660 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
661 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
662 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
663 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
664 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
665 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
666 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
667 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
668 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
669 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
670 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
671 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
672 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
673 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
674 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
675 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
676 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
677 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
678 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
679 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
680 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
681 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
682 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
683 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
684 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
685 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
686 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
687 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
688 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
689 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
690 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
691 911 POFN-1901 INVFN-1901 13438 12517 2 1 151 17276.0 0.0 315.41 752.71 752.71 0.0 17276.0 INR 0.0 0.04 0.0 4 13438 2026-02-05 22:03:41 0 NULL 1 2026-02-05 22:03:51 12517 1 2026-02-05 22:03:51
692 912 POFN-1902 INVFN-1902 13438 12517 2 1 2 408.0 0.0 7.77 9.71 9.71 0.0 408.0 INR 0.0 0.08 0.0 4 13438 2026-02-05 22:38:22 0 NULL 1 2026-02-05 22:38:58 12517 1 2026-02-05 22:38:58
693 913 POFN-1903 INVFN-1903 12527 12517 2 1 240 28620.0 0.0 531.33 1026.66 1026.66 0.0 28620.0 INR 0.0 0.75 0.0 4 12527 2026-02-06 10:47:44 0 NULL 1 2026-02-06 17:24:17 12517 1 2026-02-06 17:24:17
694 914 POFN-1904 INVFN-1904 12528 12517 2 1 46 6876.0 0.0 126.28 281.02 281.02 0.0 6876.0 INR 0.0 0.25 0.0 4 12528 2026-02-06 17:17:53 0 NULL 1 2026-02-06 17:24:17 12517 1 2026-02-06 17:24:17
695 915 POFN-1905 INVFN-1905 12546 12517 2 2 5 53500.0 0.0 1019.05 1273.81 1273.81 0.0 53500.0 INR 0.0 5.0 250.0 4 12546 2026-02-06 20:20:56 0 NULL 1 2026-02-06 20:29:11 12517 1 2026-02-06 20:29:11
696 916 POFN-1906 INVFN-1906 12532 12517 2 2 4 42800.0 0.0 815.24 1019.05 1019.05 0.0 42800.0 INR 0.0 4.0 200.0 4 12532 2026-02-06 20:21:33 0 NULL 1 2026-02-06 20:37:09 12517 1 2026-02-06 20:37:09
697 917 POFN-1907 INVFN-1907 12521 12517 2 2 2 21400.0 0.0 407.62 509.52 509.52 0.0 21400.0 INR 0.0 2.0 100.0 4 12521 2026-02-06 21:52:01 0 NULL 1 2026-02-06 21:53:07 12517 1 2026-02-06 21:53:07
698 918 POFN-1908 INVFN-1908 14490 12517 2 1 1 2600.0 0.0 49.52 61.9 61.9 0.0 2600.0 INR 0.0 0.5 0.0 4 14490 2026-02-07 13:10:17 0 NULL 1 2026-02-09 11:39:15 12517 1 2026-02-09 11:39:15
699 919 POFN-1909 INVFN-1909 12517 12516 2 1 214 59421.0 0.0 2903.01 0.0 0.0 9064.22 59421.0 INR 0.0 1.82 0.0 4 12517 2026-02-07 16:08:59 0 NULL 1 2026-02-07 16:25:23 12516 1 2026-02-07 16:25:23
700 920 POFN-1910 INVFN-1910 12516 1 2 1 22 34200.0 0.0 1097.14 814.29 814.29 0.0 34200.0 INR 0.0 3.0 0.0 4 12516 2026-02-07 16:10:17 0 NULL 1 2026-02-07 16:10:28 1 1 2026-02-07 16:10:28