fx_franchise_order

1,057 rows · 31 columns · page 13 / 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
601 821 POFN-1811 INVFN-1811 12517 12516 2 1 1520 1022580.0 0.0 58433.14 0.0 0.0 48694.29 964146.86 INR 0.0 15.0 0.0 4 12517 2026-01-25 14:08:05 0 NULL 1 2026-01-25 15:42:38 12516 0 NULL
602 822 POFN-1812 INVFN-1812 12517 12516 2 1 4350 2282640.0 0.0 123248.07 0.0 0.0 134219.74 2159391.93 INR 0.0 25.0 0.0 4 12517 2026-01-25 14:17:29 0 NULL 1 2026-01-26 10:10:28 12516 0 NULL
603 823 POFN-1813 INVFN-1813 12516 1 2 1 2090 985800.0 0.0 51739.06 43683.39 43683.39 0.0 934060.94 INR 0.0 50.0 0.0 4 12516 2026-01-25 15:00:57 0 NULL 1 2026-01-25 15:05:03 1 0 NULL
604 824 POFN-1814 INVFN-1814 12516 1 2 1 1110 856900.0 0.0 64759.64 23702.22 23702.22 0.0 792140.36 INR 0.0 18.0 0.0 4 12516 2026-01-25 15:11:07 0 NULL 1 2026-01-25 15:13:38 1 0 NULL
605 825 POFN-1815 INVFN-1815 12516 1 2 1 60 72000.0 0.0 5485.71 1714.29 1714.29 0.0 66514.29 INR 0.0 15.0 0.0 4 12516 2026-01-25 15:18:12 0 NULL 1 2026-01-25 15:18:28 1 0 NULL
606 826 POFN-1816 INVFN-1816 12516 1 2 1 50 60000.0 0.0 4571.43 1428.57 1428.57 0.0 55428.57 INR 0.0 10.0 0.0 4 12516 2026-01-25 15:19:57 0 NULL 1 2026-01-25 15:20:16 1 0 NULL
607 827 POFN-1817 INVFN-1817 12516 1 2 1 1200 817220.0 0.0 62264.38 19457.62 19457.62 0.0 754955.62 INR 0.0 12.0 0.0 4 12516 2026-01-25 15:27:45 0 NULL 1 2026-01-25 15:29:03 1 0 NULL
608 828 POFN-1818 INVFN-1818 12516 1 2 1 20 24000.0 0.0 1828.57 571.43 571.43 0.0 22171.43 INR 0.0 5.0 0.0 4 12516 2026-01-25 15:31:28 0 NULL 1 2026-01-25 15:31:53 1 0 NULL
609 829 POFN-1819 INVFN-1819 12516 1 2 1 100 31900.0 0.0 2430.48 759.52 759.52 0.0 29469.52 INR 0.0 5.0 0.0 4 12516 2026-01-25 15:33:41 0 NULL 1 2026-01-25 15:34:09 1 0 NULL
610 830 POFN-1820 INVFN-1820 12516 1 2 1 100 55900.0 0.0 4259.05 1330.95 1330.95 0.0 51640.95 INR 0.0 11.0 0.0 4 12516 2026-01-25 15:37:41 0 NULL 1 2026-01-25 15:39:08 1 0 NULL
611 831 POFN-1821 INVFN-1821 12516 1 2 1 20 14380.0 0.0 1095.62 342.38 342.38 0.0 13284.38 INR 0.0 3.0 0.0 4 12516 2026-01-25 15:42:04 0 NULL 1 2026-01-25 15:42:22 1 0 NULL
612 832 POFN-1822 INVFN-1822 12516 1 2 1 4600 2448840.0 0.0 176477.9 74290.26 74290.26 0.0 2272362.1 INR 0.0 25.0 0.0 4 12516 2026-01-26 10:08:34 0 NULL 1 2026-01-26 10:08:51 1 0 NULL
613 833 POFN-1823 INVFN-1823 12527 12517 2 1 54 18248.0 0.0 329.61 883.76 883.76 0.0 17918.39 INR 0.0 0.33 0.0 4 12527 2026-01-26 12:35:50 0 NULL 1 2026-01-26 12:40:24 12517 0 NULL
614 834 POFN-1824 INVFN-1824 12552 12517 2 1 37 10133.0 0.0 185.21 436.16 436.16 0.0 9947.79 INR 0.0 0.02 0.0 4 12552 2026-01-26 16:23:07 0 NULL 1 2026-01-26 16:30:00 12517 0 NULL
615 835 POFN-1825 INVFN-1825 12532 12517 2 1 5 1605.0 0.0 27.2 122.42 122.42 0.0 1577.8 INR 0.0 0.11 0.0 4 12532 2026-01-26 17:49:21 0 NULL 1 2026-01-26 17:51:42 12517 0 NULL
616 836 POFN-1826 INVFN-1826 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-26 22:14:13 0 NULL 1 2026-01-26 22:14:42 12554 0 NULL
617 837 POFN-1827 INVFN-1827 12516 1 2 1 1450 659600.0 0.0 48915.58 24077.64 24077.64 0.0 610684.42 INR 0.0 8.8 0.0 4 12516 2026-01-27 11:41:59 0 NULL 1 2026-01-27 11:47:38 1 0 NULL
618 838 POFN-1828 INVFN-1828 12516 1 2 1 150 23850.0 0.0 1817.14 567.86 567.86 0.0 22032.86 INR 0.0 2.25 0.0 4 12516 2026-01-27 11:47:20 0 NULL 1 2026-01-27 11:47:38 1 0 NULL
619 839 POFN-1829 INVFN-1829 12517 12516 2 1 1400 561550.0 0.0 31221.69 0.0 0.0 41188.42 530328.31 INR 0.0 8.25 0.0 4 12517 2026-01-27 12:00:09 0 NULL 1 2026-01-27 12:00:28 12516 0 NULL
620 840 POFN-1830 INVFN-1830 12522 12517 2 1 2 680.0 0.0 12.95 16.19 16.19 0.0 667.05 INR 0.0 0.1 0.0 4 12522 2026-01-27 12:55:50 0 NULL 1 2026-01-27 13:00:36 12517 0 NULL
621 841 POFN-1831 INVFN-1831 12516 1 2 1 43 61920.0 0.0 0.0 1474.29 1474.29 0.0 61920.0 INR 0.0 0.0 0.0 4 12516 2026-01-27 13:07:08 0 NULL 1 2026-01-27 13:07:22 1 0 NULL
622 842 POFN-1832 INVFN-1832 12517 12516 2 1 93 83180.0 0.0 868.47 0.0 0.0 5134.0 82311.53 INR 0.0 0.9 0.0 4 12517 2026-01-27 13:10:08 0 NULL 1 2026-01-27 13:10:45 12516 0 NULL
623 843 POFN-1833 INVFN-1833 12516 1 2 1 43 11180.0 0.0 757.97 852.71 852.71 0.0 10422.03 INR 0.0 0.9 0.0 4 12516 2026-01-27 13:10:27 0 NULL 1 2026-01-27 13:10:34 1 0 NULL
624 844 POFN-1834 INVFN-1834 12517 12516 2 1 2700 599800.0 0.0 34274.29 0.0 0.0 28561.9 565525.71 INR 0.0 80.0 0.0 4 12517 2026-01-27 13:20:50 0 NULL 1 2026-01-27 13:21:43 12516 0 NULL
625 845 POFN-1835 INVFN-1835 12516 1 2 1 200 399800.0 0.0 30460.95 9519.05 9519.05 0.0 369339.05 INR 0.0 80.0 0.0 4 12516 2026-01-27 13:21:22 0 NULL 1 2026-01-27 13:21:31 1 0 NULL
626 846 POFN-1836 INVFN-1836 12516 1 2 1 1 304.0 0.0 20.61 23.19 23.19 0.0 304.0 INR 0.0 0.05 0.0 4 12516 2026-01-27 18:05:11 0 NULL 1 2026-01-27 18:05:42 1 1 2026-01-27 18:05:42
627 847 POFN-1837 INVFN-1837 12555 12554 2 1 4 4639.0 0.0 88.36 110.45 110.45 0.0 4639.0 INR 0.0 0.4 0.0 4 12555 2026-01-27 19:35:15 0 NULL 1 2026-01-27 19:35:36 12554 1 2026-01-27 19:35:36
628 848 POFN-1838 INVFN-1838 12554 12516 2 1 4 4639.0 0.0 220.9 110.45 110.45 0.0 4639.0 INR 0.0 0.4 0.0 4 12554 2026-01-27 19:43:43 0 NULL 1 2026-01-27 19:44:26 12516 1 2026-01-27 19:44:26
629 849 POFN-1839 INVFN-1839 12554 12516 2 1 1 720.0 0.0 34.29 17.14 17.14 0.0 720.0 INR 0.0 0.15 0.0 4 12554 2026-01-27 20:52:56 0 NULL 1 2026-01-27 20:53:19 12516 1 2026-01-27 20:53:19
630 850 POFN-1840 INVFN-1840 12555 12554 2 1 10 12500.0 0.0 238.1 297.62 297.62 0.0 12500.0 INR 0.0 2.5 0.0 4 12555 2026-01-28 13:25:47 0 NULL 1 2026-01-28 13:25:57 12554 1 2026-01-28 13:25:57
631 851 POFN-1841 INVFN-1841 12545 12517 2 1 37 4954.0 0.0 90.44 215.9 215.9 0.0 4954.0 INR 0.0 0.04 0.0 4 12545 2026-01-28 13:42:36 0 NULL 1 2026-01-28 13:44:11 12517 1 2026-01-28 13:44:11
632 852 POFN-1842 INVFN-1842 12534 12517 2 1 89 22331.0 0.0 409.93 917.36 917.36 0.0 22331.0 INR 0.0 0.06 0.0 4 12534 2026-01-28 17:51:07 0 NULL 1 2026-01-28 18:36:57 12517 1 2026-01-28 18:36:57
633 853 POFN-1843 INVFN-1843 12523 12517 2 1 158 24062.0 0.0 442.28 973.92 973.92 0.0 24062.0 INR 0.0 0.15 0.0 4 12523 2026-01-28 18:02:24 0 NULL 1 2026-01-28 18:36:57 12517 1 2026-01-28 18:36:57
634 854 POFN-1844 INVFN-1844 13438 12517 2 1 2 1159.0 0.0 22.08 27.6 27.6 0.0 1159.0 INR 0.0 0.11 0.0 4 13438 2026-01-28 18:34:36 0 NULL 1 2026-01-28 18:36:57 12517 1 2026-01-28 18:36:57
635 855 POFN-1845 INVFN-1845 12547 12517 2 1 1 48.0 0.0 0.91 1.14 1.14 0.0 48.0 INR 0.0 0.01 0.0 4 12547 2026-01-28 19:57:54 0 NULL 1 2026-01-29 08:03:44 12517 1 2026-01-29 08:03:44
636 856 POFN-1846 INVFN-1846 12516 1 2 1 5 52500.0 0.0 400.0 1250.0 1250.0 0.0 52500.0 INR 0.0 15.0 0.0 4 12516 2026-01-29 15:38:38 0 NULL 1 2026-01-29 15:38:46 1 1 2026-01-29 15:38:46
637 857 POFN-1847 INVFN-1847 12517 12516 2 1 5 52500.0 0.0 300.0 0.0 0.0 2500.0 52500.0 INR 0.0 15.0 0.0 4 12517 2026-01-29 15:39:04 0 NULL 1 2026-01-29 15:39:13 12516 1 2026-01-29 15:39:13
638 858 POFN-1848 INVFN-1848 12527 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 12527 2026-01-29 15:53:35 0 NULL 1 2026-01-29 15:55:04 12517 1 2026-01-29 15:55:04
639 859 POFN-1849 INVFN-1849 12527 12517 2 1 1 2000.0 0.0 38.1 47.62 47.62 0.0 2000.0 INR 0.0 0.4 0.0 4 12527 2026-01-29 16:06:03 0 NULL 1 2026-01-29 16:08:24 12517 1 2026-01-29 16:08:24
640 860 POFN-1850 INVFN-1850 12521 12517 2 1 106 17430.0 0.0 332.74 396.6 396.6 0.0 17430.0 INR 0.0 0.15 0.0 4 12521 2026-01-29 22:20:37 0 NULL 1 2026-01-29 22:22:45 12517 1 2026-01-29 22:22:45
641 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
642 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
643 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
644 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
645 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
646 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
647 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
648 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
649 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
650 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