fx_franchise_order

1,057 rows · 31 columns · page 16 / 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
751 971 POFN-1961 INVFN-1961 14079 12517 2 1 21 1360.0 0.0 25.9 32.38 32.38 0.0 1360.0 INR 0.0 0.06 0.0 4 14079 2026-02-21 22:05:21 0 NULL 1 2026-02-21 22:21:38 12517 1 2026-02-21 22:21:38
752 972 POFN-1962 INVFN-1962 12526 12517 2 1 78 20247.0 0.0 382.34 564.97 564.97 0.0 20247.0 INR 0.0 0.25 0.0 4 12526 2026-02-23 17:08:12 0 NULL 1 2026-02-23 17:10:38 12517 1 2026-02-23 17:10:38
753 973 POFN-1963 INVFN-1963 12526 12517 2 1 6 954.0 0.0 16.17 72.76 72.76 0.0 954.0 INR 0.0 0.15 0.0 4 12526 2026-02-23 17:23:35 0 NULL 1 2026-02-23 17:25:27 12517 1 2026-02-23 17:25:27
754 974 POFN-1964 INVFN-1964 13518 12554 2 1 9 432.0 0.0 8.23 10.29 10.29 0.0 432.0 INR 0.0 0.05 0.0 4 13518 2026-02-24 16:00:37 0 NULL 1 2026-03-16 13:07:23 12554 1 2026-03-16 13:07:23
755 975 POFN-1965 INVFN-1965 12540 12517 2 1 7 1455.0 0.0 26.44 66.54 66.54 0.0 1455.0 INR 0.0 0.08 0.0 4 12540 2026-02-25 14:55:22 0 NULL 1 2026-02-25 15:00:32 12517 1 2026-02-25 15:00:32
756 976 POFN-1966 INVFN-1966 12517 12516 2 1 100 15900.0 0.0 757.14 0.0 0.0 757.14 15900.0 INR 0.0 1.5 0.0 4 12517 2026-02-26 14:28:51 0 NULL 1 2026-03-01 10:32:09 12516 1 2026-03-01 10:32:09
757 977 POFN-1967 INVFN-1967 12516 1 2 1 100 15900.0 0.0 1211.43 378.57 378.57 0.0 15900.0 INR 0.0 1.5 0.0 4 12516 2026-02-26 14:29:32 0 NULL 2 2026-04-08 16:48:55 1 0 NULL
758 978 POFN-1968 INVFN-1968 12548 12517 2 1 130 15519.0 0.0 290.06 508.0 508.0 0.0 15519.0 INR 0.0 0.11 0.0 4 12548 2026-02-26 23:50:58 0 NULL 1 2026-02-27 12:09:43 12517 1 2026-02-27 12:09:43
759 979 POFN-1969 INVFN-1969 12521 12517 2 1 199 18633.0 0.0 353.91 468.67 468.67 0.0 18633.0 INR 0.0 0.25 0.0 4 12521 2026-02-27 19:33:29 0 NULL 1 2026-02-27 19:36:41 12517 1 2026-02-27 19:36:41
760 980 POFN-1970 INVFN-1970 12534 12517 2 1 17 26933.0 0.0 257.14 787.89 787.89 0.0 26933.0 INR 0.0 0.2 0.0 4 12534 2026-02-28 12:40:42 0 NULL 2 2026-02-28 12:44:50 12517 0 NULL
761 981 POFN-1971 INVFN-1971 12534 12517 2 1 15 5933.0 0.0 107.14 287.89 287.89 0.0 5933.0 INR 0.0 0.2 0.0 4 12534 2026-02-28 12:54:38 0 NULL 1 2026-02-28 12:56:59 12517 1 2026-02-28 12:56:59
762 982 POFN-1972 INVFN-1972 12534 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 12534 2026-02-28 12:55:14 0 NULL 1 2026-02-28 12:56:49 12517 1 2026-02-28 12:56:49
763 983 POFN-1973 INVFN-1973 12545 12517 2 1 22 2136.0 0.0 36.91 145.29 145.29 0.0 2136.0 INR 0.0 0.16 0.0 4 12545 2026-02-28 15:22:25 0 NULL 1 2026-02-28 16:18:08 12517 1 2026-02-28 16:18:08
764 984 POFN-1974 INVFN-1974 14902 12517 2 1 78 16279.0 0.0 295.75 745.7 745.7 0.0 16279.0 INR 0.0 0.1 0.0 4 14902 2026-02-28 20:07:12 0 NULL 1 2026-02-28 20:18:04 12517 1 2026-02-28 20:18:04
765 985 POFN-1975 INVFN-1975 12552 12517 2 1 35 4799.0 0.0 90.91 126.85 126.85 0.0 4799.0 INR 0.0 0.02 0.0 4 12552 2026-02-28 21:30:33 0 NULL 1 2026-02-28 21:37:48 12517 1 2026-02-28 21:37:48
766 986 POFN-1976 INVFN-1976 12545 12517 2 1 3 2479.0 0.0 46.05 88.35 88.35 0.0 2479.0 INR 0.0 0.11 0.0 4 12545 2026-03-01 08:59:54 0 NULL 1 2026-03-01 09:02:05 12517 1 2026-03-01 09:02:05
767 987 POFN-1977 INVFN-1977 12516 1 2 1 100 15900.0 0.0 1211.43 378.57 378.57 0.0 15900.0 INR 0.0 1.5 0.0 4 12516 2026-03-01 10:31:13 0 NULL 1 2026-03-01 10:31:38 1 1 2026-03-01 10:31:38
768 988 POFN-1978 INVFN-1978 12521 12517 2 1 2 3200.0 0.0 60.95 76.19 76.19 0.0 3200.0 INR 0.0 0.2 0.0 4 12521 2026-03-01 11:40:59 0 NULL 1 2026-03-01 11:43:41 12517 1 2026-03-01 11:43:41
769 989 POFN-1979 INVFN-1979 12521 12517 2 1 3 5000.0 0.0 95.24 119.05 119.05 0.0 5000.0 INR 0.0 0.25 0.0 4 12521 2026-03-01 15:08:20 0 NULL 1 2026-03-01 15:19:55 12517 1 2026-03-01 15:19:55
770 990 POFN-1980 INVFN-1980 12545 12517 2 1 2 2400.0 0.0 45.71 57.14 57.14 0.0 2400.0 INR 0.0 0.25 0.0 4 12545 2026-03-01 16:14:20 0 NULL 1 2026-03-01 16:38:41 12517 1 2026-03-01 16:38:41
771 991 POFN-1981 INVFN-1981 12526 12517 2 2 2 37500.0 0.0 714.29 892.86 892.86 0.0 37500.0 INR 0.0 4.0 200.0 4 12526 2026-03-01 16:47:37 0 NULL 1 2026-03-01 16:51:46 12517 1 2026-03-01 16:51:40
772 992 POFN-1982 INVFN-1982 12526 12517 2 1 10 2040.0 0.0 38.86 48.57 48.57 0.0 2040.0 INR 0.0 0.4 0.0 4 12526 2026-03-01 16:48:52 0 NULL 1 2026-03-01 16:52:17 12517 1 2026-03-01 16:52:17
773 993 POFN-1983 INVFN-1983 12523 12517 2 1 141 28320.0 0.0 516.75 1241.19 1241.19 0.0 28320.0 INR 0.0 0.21 0.0 4 12523 2026-03-01 18:15:27 0 NULL 1 2026-03-01 21:14:01 12517 1 2026-03-01 21:14:01
774 994 POFN-1984 INVFN-1984 12526 12517 2 2 1 18500.0 0.0 352.38 440.48 440.48 0.0 18500.0 INR 0.0 2.0 100.0 4 12526 2026-03-01 21:17:34 0 NULL 1 2026-03-01 21:22:16 12517 1 2026-03-01 21:22:16
775 995 POFN-1985 INVFN-1985 12526 12517 2 1 5 5519.0 0.0 105.12 131.4 131.4 0.0 5519.0 INR 0.0 0.5 0.0 4 12526 2026-03-01 21:20:53 0 NULL 1 2026-03-01 21:22:41 12517 1 2026-03-01 21:22:41
776 996 POFN-1986 INVFN-1986 12517 12516 2 1 100 20400.0 0.0 1165.71 0.0 0.0 971.43 20400.0 INR 0.0 4.0 0.0 4 12517 2026-03-02 12:33:58 0 NULL 1 2026-03-02 12:36:24 12516 1 2026-03-02 12:36:24
777 997 POFN-1987 INVFN-1987 12516 1 2 1 100 20400.0 0.0 1554.29 485.71 485.71 0.0 20400.0 INR 0.0 4.0 0.0 4 12516 2026-03-02 12:34:19 0 NULL 1 2026-03-02 12:36:14 1 1 2026-03-02 12:36:14
778 998 POFN-1988 INVFN-1988 12539 12517 2 1 112 17772.0 0.0 327.72 692.9 692.9 0.0 17772.0 INR 0.0 0.57 0.0 4 12539 2026-03-02 13:41:09 0 NULL 1 2026-03-02 13:58:20 12517 1 2026-03-02 13:58:20
779 999 POFN-1989 INVFN-1989 14569 12517 2 1 20 3584.0 0.0 68.27 85.33 85.33 0.0 3584.0 INR 0.0 0.25 0.0 4 14569 2026-03-02 21:43:18 0 NULL 1 2026-03-02 22:29:33 12517 1 2026-03-02 22:29:33
780 1000 POFN-1990 INVFN-1990 12521 12517 2 1 7 9100.0 0.0 173.33 216.67 216.67 0.0 9100.0 INR 0.0 0.3 0.0 4 12521 2026-03-02 23:03:40 0 NULL 1 2026-03-02 23:04:40 12517 1 2026-03-02 23:04:40
781 1001 POFN-1991 INVFN-1991 14079 12517 2 1 1 1599.0 0.0 30.46 38.07 38.07 0.0 1599.0 INR 0.0 0.3 0.0 4 14079 2026-03-03 12:47:39 0 NULL 1 2026-03-03 13:16:43 12517 1 2026-03-03 13:16:43
782 1002 POFN-1992 INVFN-1992 12532 12517 2 1 587 64161.0 0.0 1199.75 2086.68 2086.68 0.0 64161.0 INR 0.0 0.3 0.0 4 12532 2026-03-03 17:03:13 0 NULL 1 2026-03-03 17:16:08 12517 1 2026-03-03 17:16:08
783 1003 POFN-1993 INVFN-1993 12545 12517 2 1 33 15628.0 0.0 294.99 439.3 439.3 0.0 15628.0 INR 0.0 0.16 0.0 4 12545 2026-03-04 11:20:53 0 NULL 1 2026-03-04 11:37:58 12517 1 2026-03-04 11:37:58
784 1004 POFN-1994 INVFN-1994 12526 12517 2 1 37 15600.0 0.0 289.21 569.73 569.73 0.0 15600.0 INR 0.0 0.5 0.0 4 12526 2026-03-04 23:18:18 0 NULL 1 2026-03-05 07:19:01 12517 1 2026-03-05 07:19:01
785 1005 POFN-1995 INVFN-1995 12527 12517 2 1 11 10800.0 0.0 205.71 257.14 257.14 0.0 10800.0 INR 0.0 0.75 0.0 4 12527 2026-03-05 15:46:24 0 NULL 1 2026-03-05 15:48:41 12517 1 2026-03-05 15:48:41
786 1006 POFN-1996 INVFN-1996 12532 12517 2 2 7 74900.0 0.0 1426.67 1783.33 1783.33 0.0 74900.0 INR 0.0 7.0 350.0 4 12532 2026-03-06 15:49:54 0 NULL 1 2026-03-06 16:32:26 12517 1 2026-03-06 16:32:26
787 1007 POFN-1997 INVFN-1997 14902 12517 2 1 38 13677.0 0.0 259.51 350.67 350.67 0.0 13677.0 INR 0.0 1.25 0.0 4 14902 2026-03-06 21:24:47 0 NULL 1 2026-03-06 21:28:40 12517 1 2026-03-06 21:28:40
788 1008 POFN-1998 INVFN-1998 12521 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 12521 2026-03-06 21:57:30 0 NULL 1 2026-03-06 22:00:56 12517 1 2026-03-06 22:00:56
789 1009 POFN-1999 INVFN-1999 12521 12517 2 1 201 12200.0 0.0 232.38 290.48 290.48 0.0 12200.0 INR 0.0 1.2 0.0 4 12521 2026-03-06 21:59:44 0 NULL 1 2026-03-06 22:01:06 12517 1 2026-03-06 22:01:06
790 1010 POFN-2000 INVFN-2000 12532 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 12532 2026-03-07 17:52:30 0 NULL 1 2026-03-07 21:06:15 12517 1 2026-03-07 21:06:15
791 1011 POFN-2001 INVFN-2001 12526 12517 2 1 100 18295.0 0.0 338.5 685.05 685.05 0.0 18295.0 INR 0.0 0.2 0.0 4 12526 2026-03-07 21:01:56 0 NULL 1 2026-03-07 21:06:24 12517 1 2026-03-07 21:06:24
792 1012 POFN-2002 INVFN-2002 12526 12517 2 1 27 25489.0 0.0 474.49 882.25 882.25 0.0 25489.0 INR 0.0 0.6 0.0 4 12526 2026-03-09 20:18:47 0 NULL 1 2026-03-09 20:24:25 12517 1 2026-03-09 20:24:25
793 1013 POFN-2003 INVFN-2003 12521 12517 2 1 2 2400.0 0.0 45.71 57.14 57.14 0.0 2400.0 INR 0.0 0.5 0.0 4 12521 2026-03-09 22:11:44 0 NULL 1 2026-03-09 22:12:36 12517 1 2026-03-09 22:12:36
794 1014 POFN-2004 INVFN-2004 12539 12517 2 1 4 2437.0 0.0 46.42 58.02 58.02 0.0 2437.0 INR 0.0 0.15 0.0 4 12539 2026-03-11 20:12:03 0 NULL 1 2026-03-11 20:21:22 12517 1 2026-03-11 20:21:12
795 1015 POFN-2005 INVFN-2005 12539 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 12539 2026-03-11 20:13:26 0 NULL 1 2026-03-11 20:21:12 12517 1 2026-03-11 20:21:12
796 1016 POFN-2006 INVFN-2006 12539 12517 2 1 1 204.0 0.0 3.89 4.86 4.86 0.0 204.0 INR 0.0 0.04 0.0 4 12539 2026-03-11 20:34:48 0 NULL 1 2026-03-11 21:39:37 12517 1 2026-03-11 21:39:37
797 1017 POFN-2007 INVFN-2007 12539 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 12539 2026-03-13 10:54:59 0 NULL 1 2026-03-13 12:01:48 12517 1 2026-03-13 12:01:48
798 1018 POFN-2008 INVFN-2008 14079 12517 2 1 25 2000.0 0.0 38.1 47.62 47.62 0.0 2000.0 INR 0.0 0.22 0.0 4 14079 2026-03-13 14:10:02 0 NULL 1 2026-03-13 14:58:55 12517 1 2026-03-13 14:58:55
799 1019 POFN-2009 INVFN-2009 12526 12517 2 1 51 13208.0 0.0 233.83 758.2 758.2 0.0 13208.0 INR 0.0 0.25 0.0 4 12526 2026-03-13 14:43:10 0 NULL 1 2026-03-13 14:58:51 12517 1 2026-03-13 14:58:51
800 1020 POFN-2010 INVFN-2010 12517 12516 2 1 926 44448.0 0.0 2539.89 0.0 0.0 2116.57 44448.0 INR 0.0 5.56 0.0 4 12517 2026-03-13 17:47:27 0 NULL 1 2026-03-13 17:47:51 12516 1 2026-03-13 17:47:51