fx_franchise_order

1,057 rows · 31 columns · page 17 / 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
801 1021 POFN-2011 INVFN-2011 14902 12517 2 1 8 10500.0 0.0 200.0 250.0 250.0 0.0 10500.0 INR 0.0 0.75 0.0 4 14902 2026-03-13 22:12:48 0 NULL 1 2026-03-13 22:18:19 12517 1 2026-03-13 22:18:19
802 1022 POFN-2012 INVFN-2012 14569 12517 2 1 4 4800.0 0.0 91.43 114.29 114.29 0.0 4800.0 INR 0.0 0.5 0.0 4 14569 2026-03-14 10:25:41 0 NULL 1 2026-03-14 11:18:55 12517 1 2026-03-14 11:18:55
803 1023 POFN-2013 INVFN-2013 14569 12517 2 2 4 66450.0 0.0 1265.71 1582.14 1582.14 0.0 66450.0 INR 0.0 1.0 50.0 4 14569 2026-03-14 10:31:53 0 NULL 1 2026-03-14 11:18:55 12517 1 2026-03-14 11:18:55
804 1024 POFN-2014 INVFN-2014 14569 12517 2 1 1 1650.0 0.0 31.43 39.29 39.29 0.0 1650.0 INR 0.0 0.3 0.0 4 14569 2026-03-14 11:30:41 0 NULL 1 2026-03-14 11:40:53 12517 1 2026-03-14 11:40:53
805 1025 POFN-2015 INVFN-2015 14569 12517 2 1 1 1650.0 0.0 31.43 39.29 39.29 0.0 1650.0 INR 0.0 0.3 0.0 4 14569 2026-03-14 11:31:41 0 NULL 1 2026-03-14 11:40:53 12517 1 2026-03-14 11:40:53
806 1026 POFN-2016 INVFN-2016 14569 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 14569 2026-03-14 11:36:44 0 NULL 1 2026-03-14 11:40:53 12517 1 2026-03-14 11:40:53
807 1027 POFN-2017 INVFN-2017 14569 12517 2 2 2 29200.0 0.0 556.19 695.24 695.24 0.0 29200.0 INR 0.0 1.0 50.0 4 14569 2026-03-14 12:24:42 0 NULL 1 2026-03-14 12:46:12 12517 1 2026-03-14 12:46:12
808 1028 POFN-2018 INVFN-2018 12545 12517 2 1 5 2495.0 0.0 47.52 59.4 59.4 0.0 2495.0 INR 0.0 0.5 0.0 4 12545 2026-03-14 12:57:35 0 NULL 1 2026-03-14 12:59:42 12517 1 2026-03-14 12:59:42
809 1029 POFN-2019 INVFN-2019 12526 12517 2 1 76 7164.0 0.0 132.45 270.67 270.67 0.0 7164.0 INR 0.0 0.3 0.0 4 12526 2026-03-14 20:28:05 0 NULL 1 2026-03-14 20:30:14 12517 1 2026-03-14 20:30:14
810 1030 POFN-2020 INVFN-2020 14569 12517 2 1 15 5356.0 0.0 99.67 186.18 186.18 0.0 5356.0 INR 0.0 0.15 0.0 4 14569 2026-03-14 20:34:24 0 NULL 1 2026-03-14 22:20:36 12517 1 2026-03-14 22:20:36
811 1031 POFN-2021 INVFN-2021 14569 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 14569 2026-03-14 20:40:24 0 NULL 1 2026-03-14 22:20:36 12517 1 2026-03-14 22:20:36
812 1032 POFN-2022 INVFN-2022 14569 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 14569 2026-03-15 10:39:46 0 NULL 1 2026-03-15 11:37:48 12517 1 2026-03-15 11:37:48
813 1033 POFN-2023 INVFN-2023 12545 12517 2 1 3 2749.0 0.0 50.79 104.8 104.8 0.0 2749.0 INR 0.0 0.3 0.0 4 12545 2026-03-16 06:26:04 0 NULL 1 2026-03-16 12:26:36 12517 1 2026-03-16 12:26:36
814 1034 POFN-2024 INVFN-2024 12542 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 12542 2026-03-16 13:02:58 0 NULL 1 2026-03-16 13:03:46 12517 1 2026-03-16 13:03:46
815 1035 POFN-2025 INVFN-2025 12539 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 12539 2026-03-16 14:47:31 0 NULL 1 2026-03-16 14:52:19 12517 1 2026-03-16 14:52:19
816 1036 POFN-2026 INVFN-2026 12516 1 2 2 15 277500.0 0.0 0.0 6607.14 6607.14 0.0 277500.0 INR 0.0 30.0 1500.0 4 12516 2026-03-16 14:56:35 0 NULL 1 2026-03-16 14:56:45 1 1 2026-03-16 14:56:45
817 1037 POFN-2027 INVFN-2027 12545 12517 2 1 23 2214.0 0.0 38.83 136.13 136.13 0.0 2214.0 INR 0.0 0.25 0.0 4 12545 2026-03-16 20:49:50 0 NULL 1 2026-03-16 20:52:36 12517 1 2026-03-16 20:52:36
818 1038 POFN-2028 INVFN-2028 12533 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 12533 2026-03-16 20:55:37 0 NULL 1 2026-03-16 20:57:39 12517 1 2026-03-16 20:57:39
819 1039 POFN-2029 INVFN-2029 12521 12517 2 2 3 40150.0 0.0 764.76 955.95 955.95 0.0 40150.0 INR 0.0 2.0 100.0 4 12521 2026-03-16 20:56:25 0 NULL 1 2026-03-16 20:57:54 12517 1 2026-03-16 20:57:54
820 1040 POFN-2030 INVFN-2030 14902 12517 2 1 48 13863.0 0.0 257.96 482.47 482.47 0.0 13863.0 INR 0.0 0.04 0.0 4 14902 2026-03-16 22:58:45 0 NULL 1 2026-03-16 23:02:11 12517 1 2026-03-16 23:02:11
821 1041 POFN-2031 INVFN-2031 12517 12516 2 2 10 185000.0 0.0 8809.52 0.0 0.0 8809.52 185000.0 INR 0.0 20.0 1000.0 4 12517 2026-03-17 12:24:06 0 NULL 1 2026-03-17 12:25:48 12516 1 2026-03-17 12:25:48
822 1042 POFN-2032 INVFN-2032 14079 12517 2 1 3 1278.0 0.0 24.34 30.43 30.43 0.0 1278.0 INR 0.0 0.15 0.0 4 14079 2026-03-18 22:46:17 0 NULL 1 2026-03-19 06:18:33 12517 1 2026-03-19 06:18:33
823 1043 POFN-2033 INVFN-2033 14569 12517 2 1 4 5419.0 0.0 103.22 129.02 129.02 0.0 5419.0 INR 0.0 0.3 0.0 4 14569 2026-03-19 22:17:39 0 NULL 1 2026-03-20 08:50:41 12517 1 2026-03-20 08:50:41
824 1044 POFN-2034 INVFN-2034 12521 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 12521 2026-03-20 23:25:40 0 NULL 1 2026-03-21 00:00:56 12517 1 2026-03-21 00:00:56
825 1045 POFN-2035 INVFN-2035 12548 12517 2 1 32 5440.0 0.0 103.62 129.52 129.52 0.0 5440.0 INR 0.0 0.18 0.0 4 12548 2026-03-20 23:30:39 0 NULL 1 2026-03-21 00:00:56 12517 1 2026-03-21 00:00:56
826 1046 POFN-2036 INVFN-2036 12545 12517 2 1 2 1500.0 0.0 25.42 114.41 114.41 0.0 1500.0 INR 0.0 0.2 0.0 4 12545 2026-03-24 06:10:51 0 NULL 2 2026-03-24 21:57:15 12517 0 NULL
827 1047 POFN-2037 INVFN-2037 12517 12516 2 1 10 7500.0 0.0 428.57 0.0 0.0 357.14 7500.0 INR 0.0 1.0 0.0 4 12517 2026-03-24 15:41:18 0 NULL 1 2026-03-24 15:41:46 12516 1 2026-03-24 15:41:46
828 1048 POFN-2038 INVFN-2038 12526 12517 2 1 54 10329.0 0.0 192.07 362.71 362.71 0.0 10329.0 INR 0.0 0.3 0.0 4 12526 2026-03-24 20:47:23 0 NULL 1 2026-03-24 21:17:13 12517 1 2026-03-24 21:17:13
829 1049 POFN-2039 INVFN-2039 12532 12517 2 1 35 13023.0 0.0 245.04 385.62 385.62 0.0 13023.0 INR 0.0 0.13 0.0 4 12532 2026-03-24 20:49:23 0 NULL 1 2026-03-24 21:17:22 12517 1 2026-03-24 21:17:22
830 1050 POFN-2040 INVFN-2040 12545 12517 2 1 2 1500.0 0.0 28.57 35.71 35.71 0.0 1500.0 INR 0.0 0.2 0.0 4 12545 2026-03-24 22:01:23 0 NULL 1 2026-03-25 09:23:11 12517 1 2026-03-25 09:23:11
831 1051 POFN-2041 INVFN-2041 12523 12517 2 1 114 25175.0 0.0 458.84 1116.41 1116.41 0.0 25175.0 INR 0.0 0.3 0.0 4 12523 2026-03-25 15:15:31 0 NULL 1 2026-03-25 15:47:26 12517 1 2026-03-25 15:47:26
832 1052 POFN-2042 INVFN-2042 12548 12517 2 1 9 5965.0 0.0 111.11 204.72 204.72 0.0 5965.0 INR 0.0 0.05 0.0 4 12548 2026-03-26 07:51:58 0 NULL 1 2026-03-26 10:51:56 12517 1 2026-03-26 10:51:56
833 1053 POFN-2043 INVFN-2043 12526 12517 2 1 7 3197.0 0.0 58.71 130.68 130.68 0.0 3197.0 INR 0.0 0.08 0.0 4 12526 2026-03-26 22:37:16 0 NULL 1 2026-03-27 05:17:11 12517 1 2026-03-27 05:17:11
834 1054 POFN-2044 INVFN-2044 12545 12517 2 1 59 11201.0 0.0 202.14 547.1 547.1 0.0 11201.0 INR 0.0 0.32 0.0 4 12545 2026-03-27 19:10:08 0 NULL 1 2026-03-27 19:15:12 12517 1 2026-03-27 19:15:12
835 1055 POFN-2045 INVFN-2045 12545 12517 2 1 19 3979.0 0.0 74.61 124.17 124.17 0.0 3979.0 INR 0.0 0.02 0.0 4 12545 2026-03-27 19:13:13 0 NULL 1 2026-03-27 19:15:12 12517 1 2026-03-27 19:15:12
836 1056 POFN-2046 INVFN-2046 12545 12517 2 1 9 1077.0 0.0 19.51 50.67 50.67 0.0 1077.0 INR 0.0 0.08 0.0 4 12545 2026-03-27 21:29:24 0 NULL 1 2026-03-27 21:29:35 12517 1 2026-03-27 21:29:35
837 1057 POFN-2047 INVFN-2047 12526 12517 2 1 11 6177.0 0.0 111.41 303.25 303.25 0.0 6177.0 INR 0.0 0.1 0.0 4 12526 2026-03-27 21:29:57 0 NULL 1 2026-03-27 21:30:17 12517 1 2026-03-27 21:30:17
838 1058 POFN-2048 INVFN-2048 12516 1 2 1 50 16000.0 0.0 1084.75 1220.34 1220.34 0.0 16000.0 INR 0.0 2.5 0.0 4 12516 2026-03-27 21:43:39 0 NULL 1 2026-03-27 21:44:08 1 1 2026-03-27 21:44:08
839 1059 POFN-2049 INVFN-2049 12517 12516 2 1 50 16000.0 0.0 813.56 0.0 0.0 2440.68 16000.0 INR 0.0 2.5 0.0 4 12517 2026-03-27 21:45:18 0 NULL 1 2026-03-27 21:45:35 12516 1 2026-03-27 21:45:35
840 1060 POFN-2050 INVFN-2050 12526 12517 2 1 10 3200.0 0.0 54.24 244.07 244.07 0.0 3200.0 INR 0.0 0.5 0.0 4 12526 2026-03-27 22:03:26 0 NULL 1 2026-03-27 22:03:45 12517 1 2026-03-27 22:03:45
841 1061 POFN-2051 INVFN-2051 12521 12517 2 1 4 4800.0 0.0 91.43 114.29 114.29 0.0 4800.0 INR 0.0 0.5 0.0 4 12521 2026-03-27 22:56:16 0 NULL 1 2026-03-27 23:01:44 12517 1 2026-03-27 23:01:44
842 1062 POFN-2052 INVFN-2052 12521 12517 2 1 65 3120.0 0.0 59.43 74.29 74.29 0.0 3120.0 INR 0.0 0.39 0.0 4 12521 2026-03-27 23:12:00 0 NULL 1 2026-03-28 08:27:12 12517 1 2026-03-28 08:27:12
843 1063 POFN-2053 INVFN-2053 12517 12516 2 1 25 36000.0 0.0 2057.14 0.0 0.0 1714.29 36000.0 INR 0.0 5.0 0.0 4 12517 2026-03-30 12:20:17 0 NULL 1 2026-03-30 12:21:09 12516 1 2026-03-30 12:21:09
844 1064 POFN-2054 INVFN-2054 12516 1 2 1 20 28800.0 0.0 2194.29 685.71 685.71 0.0 28800.0 INR 0.0 4.0 0.0 4 12516 2026-03-30 12:20:39 0 NULL 1 2026-03-30 12:20:54 1 1 2026-03-30 12:20:54
845 1065 POFN-2055 INVFN-2055 12548 12517 2 1 3 5200.0 0.0 99.05 123.81 123.81 0.0 5200.0 INR 0.0 0.2 0.0 4 12548 2026-03-30 18:51:16 0 NULL 1 2026-03-30 19:35:33 12517 1 2026-03-30 19:35:33
846 1066 POFN-2056 INVFN-2056 12526 12517 2 1 90 15435.0 0.0 291.07 440.68 440.68 0.0 15435.0 INR 0.0 0.06 0.0 4 12526 2026-03-30 21:11:48 0 NULL 1 2026-03-30 22:10:15 12517 1 2026-03-30 22:10:15
847 1067 POFN-2057 INVFN-2057 12539 12517 2 1 9 4926.0 0.0 93.83 117.29 117.29 0.0 4926.0 INR 0.0 0.01 0.0 4 12539 2026-03-31 19:17:39 0 NULL 1 2026-03-31 19:34:13 12517 1 2026-03-31 19:34:13
848 1068 POFN-2058 INVFN-2058 14079 12517 2 1 2 558.0 0.0 10.63 13.29 13.29 0.0 558.0 INR 0.0 0.1 0.0 4 14079 2026-04-01 21:29:53 0 NULL 1 2026-04-01 22:03:27 12517 1 2026-04-01 22:03:27
849 1069 POFN-2059 INVFN-2059 12521 12517 2 1 11 3659.0 0.0 66.51 166.7 166.7 0.0 3659.0 INR 0.0 0.04 0.0 4 12521 2026-04-03 16:14:54 0 NULL 1 2026-04-03 16:17:00 12517 1 2026-04-03 16:17:00
850 1070 POFN-2060 INVFN-2060 12526 12517 2 1 100 14268.0 0.0 261.46 597.51 597.51 0.0 14268.0 INR 0.0 0.06 0.0 4 12526 2026-04-03 20:56:09 0 NULL 1 2026-04-03 21:05:17 12517 1 2026-04-03 21:05:17