fx_franchise_order

1,267 rows · 31 columns · page 17 / 26

Invoice view 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
801 811 POFN-1801 INVFN-1801 13438 12517 2 1 1 600.0 0.0 11.43 14.29 14.29 0.0 588.57 INR 0.0 0.1 0.0 4 13438 2026-01-23 19:40:26 0 NULL 1 2026-01-23 19:41:41 12517 0 NULL
802 812 POFN-1802 INVFN-1802 13438 12517 2 1 25 2480.0 0.0 48.69 22.86 22.86 0.0 2431.31 INR 0.0 0.25 0.0 4 13438 2026-01-23 20:08:26 0 NULL 1 2026-01-23 20:09:14 12517 0 NULL
803 813 POFN-1803 INVFN-1803 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 20:08:45 0 NULL 1 2026-01-23 20:09:14 12517 0 NULL
804 814 POFN-1804 INVFN-1804 12521 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 12521 2026-01-23 21:52:46 0 NULL 1 2026-01-23 21:59:00 12517 0 NULL
805 815 POFN-1805 INVFN-1805 12546 12517 2 1 37 4390.0 0.0 82.36 136.0 136.0 0.0 4307.64 INR 0.0 0.06 0.0 4 12546 2026-01-23 22:38:03 0 NULL 1 2026-01-23 22:41:58 12517 0 NULL
806 816 POFN-1806 INVFN-1806 12527 12517 2 1 9 5325.0 0.0 99.62 172.06 172.06 0.0 5225.38 INR 0.0 0.11 0.0 4 12527 2026-01-24 16:56:15 0 NULL 1 2026-01-26 10:17:50 12517 0 NULL
807 817 POFN-1807 INVFN-1807 12527 12517 2 1 9 5805.0 0.0 108.76 183.49 183.49 0.0 5696.24 INR 0.0 0.11 0.0 4 12527 2026-01-24 17:03:00 0 NULL 1 2026-01-25 11:56:13 12517 0 NULL
808 818 POFN-1808 INVFN-1808 12517 12516 2 1 1990 955400.0 0.0 45980.3 0.0 0.0 87366.79 909419.7 INR 0.0 45.0 0.0 4 12517 2026-01-25 13:47:25 0 NULL 1 2026-01-25 15:06:12 12516 0 NULL
809 819 POFN-1809 INVFN-1809 12517 12516 2 1 1174 1047256.0 0.0 59520.52 0.0 0.0 55247.28 987735.48 INR 0.0 18.0 0.0 4 12517 2026-01-25 14:01:40 0 NULL 1 2026-01-25 15:20:30 12516 0 NULL
810 820 POFN-1810 INVFN-1810 12542 12517 2 1 200 9600.0 0.0 182.86 228.57 228.57 0.0 9417.14 INR 0.0 1.2 0.0 4 12542 2026-01-25 14:05:04 0 NULL 1 2026-01-25 14:32:01 12517 0 NULL
811 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
812 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
813 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
814 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
815 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
816 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
817 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
818 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
819 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
820 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
821 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
822 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
823 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
824 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
825 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
826 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
827 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
828 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
829 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
830 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
831 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
832 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
833 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
834 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
835 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
836 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
837 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
838 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
839 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
840 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
841 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
842 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
843 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
844 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
845 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
846 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
847 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
848 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
849 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
850 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