fx_franchise_order

1,057 rows · 31 columns · page 19 / 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
901 1122 POFN-2111 INVFN-2111 12539 12517 2 1 6 2220.0 0.0 42.29 52.86 52.86 0.0 2220.0 INR 1110.0 1110.2 1110.0 4 12539 2026-04-28 17:29:13 0 NULL 1 2026-04-28 17:32:53 12517 1 2026-04-28 17:32:53
902 1123 POFN-2112 INVFN-2112 12526 12517 2 1 40 35039.0 0.0 624.91 1896.66 1896.66 0.0 35039.0 INR 17921.0 17921.06 17921.0 4 12526 2026-04-28 20:45:38 0 NULL 1 2026-04-28 21:18:05 12517 1 2026-04-28 21:18:05
903 1124 POFN-2113 INVFN-2113 12523 12517 2 1 148 25138.0 0.0 461.17 1039.73 1039.73 0.0 25138.0 INR 11583.0 11583.36 11583.0 4 12523 2026-04-29 15:31:48 0 NULL 1 2026-04-29 16:34:20 12517 1 2026-04-29 16:34:20
904 1125 POFN-2114 INVFN-2114 12545 12517 2 1 38 7588.0 0.0 137.93 345.66 345.66 0.0 7588.0 INR 3395.0 3395.38 3395.0 4 12545 2026-04-29 15:44:54 0 NULL 2 2026-04-29 16:19:58 12517 0 NULL
905 1126 POFN-2115 INVFN-2115 12545 12517 2 1 38 7588.0 0.0 137.93 345.66 345.66 0.0 7588.0 INR 3395.0 3395.38 3395.0 4 12545 2026-04-29 15:44:54 0 NULL 1 2026-04-29 16:34:20 12517 1 2026-04-29 16:34:20
906 1127 POFN-2116 INVFN-2116 12545 12517 2 1 95 4940.0 0.0 94.1 117.62 117.62 0.0 4940.0 INR 1900.0 1900.57 1900.0 4 12545 2026-04-29 16:23:26 0 NULL 1 2026-04-29 16:34:20 12517 1 2026-04-29 16:34:20
907 1128 POFN-2117 INVFN-2117 12526 12517 2 1 51 21492.0 0.0 405.36 612.07 612.07 0.0 21492.0 INR 10517.0 10517.22 10517.0 4 12526 2026-04-29 23:10:31 0 NULL 1 2026-04-30 00:16:41 12517 1 2026-04-30 00:16:41
908 1129 POFN-2118 INVFN-2118 12545 12517 2 1 8 3969.0 0.0 75.6 94.5 94.5 0.0 3969.0 INR 1934.0 1934.15 1934.0 4 12545 2026-04-30 05:47:14 0 NULL 1 2026-04-30 09:38:23 12517 1 2026-04-30 09:38:23
909 1130 POFN-2119 INVFN-2119 12545 12517 2 1 3 1362.0 0.0 24.6 66.11 66.11 0.0 1362.0 INR 584.0 584.04 584.0 4 12545 2026-04-30 09:06:55 0 NULL 1 2026-04-30 09:38:23 12517 1 2026-04-30 09:38:23
910 1131 POFN-2120 INVFN-2120 12552 12517 2 1 6 6719.0 0.0 127.98 159.98 159.98 0.0 6719.0 INR 3359.0 3359.15 3359.0 4 12552 2026-04-30 09:29:27 0 NULL 1 2026-04-30 09:38:23 12517 1 2026-04-30 09:38:23
911 1132 POFN-2121 INVFN-2121 12545 12517 2 1 4 2560.0 0.0 46.75 111.32 111.32 0.0 2560.0 INR 1280.0 1280.15 1280.0 4 12545 2026-04-30 09:52:30 0 NULL 1 2026-04-30 11:41:29 12517 1 2026-04-30 11:41:29
912 1133 POFN-2122 INVFN-2122 12545 12517 2 1 1 720.0 0.0 13.71 17.14 17.14 0.0 720.0 INR 0.0 0.15 0.0 4 12545 2026-04-30 09:59:04 0 NULL 1 2026-04-30 11:41:24 12517 1 2026-04-30 11:41:24
913 1134 POFN-2123 INVFN-2123 12545 12517 2 1 1 400.0 0.0 7.62 9.52 9.52 0.0 400.0 INR 200.0 200.03 200.0 4 12545 2026-04-30 10:17:31 0 NULL 1 2026-04-30 11:41:17 12517 1 2026-04-30 11:41:17
914 1135 POFN-2124 INVFN-2124 12545 12517 2 1 2 1440.0 0.0 27.43 34.29 34.29 0.0 1440.0 INR 720.0 720.3 720.0 4 12545 2026-04-30 12:51:54 0 NULL 1 2026-04-30 14:43:55 12517 1 2026-04-30 14:43:55
915 1136 POFN-2125 INVFN-2125 12527 12517 2 1 44 11098.0 0.0 204.72 431.07 431.07 0.0 11098.0 INR 5058.0 5058.5 5058.0 4 12527 2026-04-30 14:26:25 0 NULL 1 2026-04-30 14:43:55 12517 1 2026-04-30 14:43:55
916 1137 POFN-2126 INVFN-2126 12545 12517 2 1 32 7440.0 0.0 129.12 491.91 491.91 0.0 7440.0 INR 2810.0 2810.25 2810.0 4 12545 2026-04-30 16:42:02 0 NULL 1 2026-04-30 17:42:19 12517 1 2026-04-30 17:42:19
917 1138 POFN-2127 INVFN-2127 12545 12517 2 1 1 1200.0 0.0 22.86 28.57 28.57 0.0 1200.0 INR 600.0 600.2 600.0 4 12545 2026-04-30 19:49:47 0 NULL 1 2026-04-30 21:19:17 12517 1 2026-04-30 21:19:17
918 1139 POFN-2128 INVFN-2128 12552 12517 2 1 4 3900.0 0.0 74.29 92.86 92.86 0.0 3900.0 INR 1950.0 1950.2 1950.0 4 12552 2026-04-30 21:40:36 0 NULL 1 2026-04-30 21:59:29 12517 1 2026-04-30 21:59:29
919 1140 POFN-2129 INVFN-2129 12545 12517 2 1 1 719.0 0.0 13.7 17.12 17.12 0.0 719.0 INR 359.0 359.15 359.0 4 12545 2026-04-30 22:59:05 0 NULL 1 2026-05-01 11:25:07 12517 1 2026-05-01 11:25:07
920 1141 POFN-2130 INVFN-2130 12552 12517 2 1 10 800.0 0.0 15.24 19.05 19.05 0.0 800.0 INR 350.0 350.09 350.0 4 12552 2026-05-02 11:18:11 0 NULL 1 2026-05-02 11:20:51 12517 1 2026-05-02 11:20:51
921 1142 POFN-2131 INVFN-2131 12555 12554 2 1 5 3995.0 0.0 67.71 304.7 304.7 0.0 3995.0 INR 1995.0 1995.75 1995.0 4 12555 2026-05-03 14:00:00 0 NULL 1 2026-05-03 14:01:42 12554 1 2026-05-03 14:01:42
922 1143 POFN-2132 INVFN-2132 14569 12517 2 1 12 3200.0 0.0 60.95 76.19 76.19 0.0 3200.0 INR 1550.0 1550.25 1550.0 4 14569 2026-05-03 23:44:54 0 NULL 1 2026-05-04 18:22:44 12517 1 2026-05-04 18:22:44
923 1144 POFN-2133 INVFN-2133 12516 1 2 1 90 0.0 0.0 0.0 0.0 0.0 0.0 0.0 INR 0.0 45.0 0.0 4 12516 2026-05-05 13:14:09 0 NULL 1 2026-05-05 13:14:42 1 1 2026-05-05 13:14:42
924 1145 POFN-2134 INVFN-2134 12554 12516 2 1 90 0.0 0.0 0.0 0.0 0.0 0.0 0.0 INR 0.0 45.0 0.0 4 12554 2026-05-05 13:15:16 0 NULL 1 2026-05-05 13:17:12 12516 1 2026-05-05 13:17:12
925 1146 POFN-2135 INVFN-2135 12555 12554 2 1 90 0.0 0.0 0.0 0.0 0.0 0.0 0.0 INR 0.0 45.0 0.0 4 12555 2026-05-05 13:20:06 0 NULL 1 2026-05-05 13:22:06 12554 1 2026-05-05 13:22:06
926 1147 POFN-2136 INVFN-2136 12516 1 2 1 50 0.0 0.0 0.0 0.0 0.0 0.0 0.0 INR 0.0 25.0 0.0 4 12516 2026-05-05 18:05:24 0 NULL 1 2026-05-05 18:06:17 1 1 2026-05-05 18:06:17
927 1148 POFN-2137 INVFN-2137 12554 12516 2 1 50 0.0 0.0 0.0 0.0 0.0 0.0 0.0 INR 0.0 25.0 0.0 4 12554 2026-05-05 18:06:48 0 NULL 2 2026-05-05 18:09:29 12516 0 NULL
928 1149 POFN-2138 INVFN-2138 12554 12516 2 1 50 0.0 0.0 0.0 0.0 0.0 0.0 0.0 INR 0.0 25.0 0.0 4 12554 2026-05-05 18:08:59 0 NULL 1 2026-05-05 18:09:26 12516 1 2026-05-05 18:09:26
929 1150 POFN-2139 INVFN-2139 12555 12554 2 1 45 0.0 0.0 0.0 0.0 0.0 0.0 0.0 INR 0.0 22.5 0.0 4 12555 2026-05-05 18:14:21 0 NULL 1 2026-05-05 18:15:29 12554 1 2026-05-05 18:15:29
930 1151 POFN-2140 INVFN-2140 12526 12517 2 1 26 10857.0 0.0 198.58 463.99 463.99 0.0 10857.0 INR 5377.0 5377.4 5377.0 4 12526 2026-05-06 22:19:06 0 NULL 1 2026-05-07 15:42:41 12517 1 2026-05-07 15:42:41
931 1152 POFN-2141 INVFN-2141 12516 1 2 1 100 0.0 0.0 0.0 0.0 0.0 0.0 0.0 INR 0.0 50.0 0.0 4 12516 2026-05-07 12:07:24 0 NULL 1 2026-05-07 12:07:36 1 1 2026-05-07 12:07:36
932 1153 POFN-2142 INVFN-2142 12554 12516 2 1 100 0.0 0.0 0.0 0.0 0.0 0.0 0.0 INR 0.0 50.0 0.0 4 12554 2026-05-07 12:09:00 0 NULL 1 2026-05-07 12:14:28 12516 1 2026-05-07 12:14:28
933 1154 POFN-2143 INVFN-2143 12555 12554 2 1 99 0.0 0.0 0.0 0.0 0.0 0.0 0.0 INR 0.0 49.5 0.0 4 12555 2026-05-07 12:13:34 0 NULL 1 2026-05-07 12:15:46 12554 1 2026-05-07 12:15:46
934 1155 POFN-2144 INVFN-2144 12516 1 2 1 60 0.0 0.0 0.0 0.0 0.0 0.0 0.0 INR 0.0 30.0 0.0 4 12516 2026-05-07 16:49:34 0 NULL 1 2026-05-07 16:50:03 1 1 2026-05-07 16:50:03
935 1156 POFN-2145 INVFN-2145 12554 12516 2 1 60 0.0 0.0 0.0 0.0 0.0 0.0 0.0 INR 0.0 30.0 0.0 4 12554 2026-05-07 16:51:35 0 NULL 1 2026-05-07 16:52:24 12516 1 2026-05-07 16:52:24
936 1157 POFN-2146 INVFN-2146 12555 12554 2 1 60 0.0 0.0 0.0 0.0 0.0 0.0 0.0 INR 0.0 30.0 0.0 4 12555 2026-05-07 16:53:27 0 NULL 1 2026-05-07 16:55:18 12554 1 2026-05-07 16:55:18
937 1158 POFN-2147 INVFN-2147 12555 12554 2 1 2 2880.0 0.0 54.86 68.57 68.57 0.0 2880.0 INR 1440.0 1440.4 1440.0 4 12555 2026-05-07 19:40:42 0 NULL 1 2026-05-07 19:41:29 12554 1 2026-05-07 19:41:29
938 1159 POFN-2148 INVFN-2148 12555 12554 2 1 5 8000.0 0.0 152.38 190.48 190.48 0.0 8000.0 INR 4000.0 4001.25 4000.0 4 12555 2026-05-07 21:55:42 0 NULL 1 2026-05-07 21:56:04 12554 1 2026-05-07 21:56:04
939 1160 POFN-2149 INVFN-2149 12516 1 2 1 5 0.0 0.0 0.0 0.0 0.0 0.0 0.0 INR 0.0 2.5 0.0 4 12516 2026-05-07 23:21:54 0 NULL 1 2026-05-07 23:22:20 1 1 2026-05-07 23:22:20
940 1161 POFN-2150 INVFN-2150 12554 12516 2 1 5 0.0 0.0 0.0 0.0 0.0 0.0 0.0 INR 0.0 2.5 0.0 4 12554 2026-05-07 23:23:50 0 NULL 1 2026-05-07 23:24:32 12516 1 2026-05-07 23:24:32
941 1162 POFN-2151 INVFN-2151 12555 12554 2 1 9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 INR 0.0 4.5 0.0 4 12555 2026-05-07 23:26:07 0 NULL 1 2026-05-07 23:26:43 12554 1 2026-05-07 23:26:43
942 1163 POFN-2152 INVFN-2152 12555 12554 2 1 9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 INR 0.0 4.5 0.0 4 12555 2026-05-07 23:26:08 0 NULL 2 2026-05-07 23:27:00 12554 0 NULL
943 1164 POFN-2153 INVFN-2153 12555 12554 2 1 9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 INR 0.0 4.5 0.0 4 12555 2026-05-07 23:26:09 0 NULL 2 2026-05-07 23:27:00 12554 0 NULL
944 1165 POFN-2154 INVFN-2154 12526 12517 2 1 17 5594.0 0.0 103.98 197.41 197.41 0.0 5594.0 INR 2640.0 2640.15 2640.0 4 12526 2026-05-08 10:18:19 0 NULL 1 2026-05-08 11:18:57 12517 1 2026-05-08 11:18:57
945 1166 POFN-2155 INVFN-2155 12526 12517 2 1 2 2400.0 0.0 45.71 57.14 57.14 0.0 2400.0 INR 1200.0 1200.25 1200.0 4 12526 2026-05-08 10:29:39 0 NULL 1 2026-05-08 11:18:57 12517 1 2026-05-08 11:18:57
946 1167 POFN-2156 INVFN-2156 12526 12517 2 1 6 1926.0 0.0 32.64 146.9 146.9 0.0 1926.0 INR 672.0 672.13 672.0 4 12526 2026-05-08 10:31:16 0 NULL 1 2026-05-08 11:18:57 12517 1 2026-05-08 11:18:57
947 1168 POFN-2157 INVFN-2157 12545 12517 2 1 2 24500.0 0.0 454.08 898.1 898.1 0.0 24500.0 INR 12550.0 12553.75 12550.0 4 12545 2026-05-09 13:00:52 0 NULL 1 2026-05-09 15:27:19 12517 1 2026-05-09 15:27:19
948 1169 POFN-2158 INVFN-2158 12545 12517 2 1 3 477.0 0.0 8.08 36.38 36.38 0.0 477.0 INR 165.0 165.03 165.0 4 12545 2026-05-09 13:08:28 0 NULL 1 2026-05-09 15:27:19 12517 1 2026-05-09 15:27:19
949 1170 POFN-2159 INVFN-2159 12554 12516 2 1 27 32400.0 0.0 1851.43 771.43 771.43 0.0 32400.0 INR 16200.0 16206.75 16200.0 4 12554 2026-05-09 18:05:15 0 NULL 1 2026-05-09 18:05:38 12516 1 2026-05-09 18:05:38
950 1171 POFN-2160 INVFN-2160 12555 12554 2 1 27 32400.0 0.0 617.14 771.43 771.43 0.0 32400.0 INR 16200.0 16206.75 16200.0 4 12555 2026-05-09 18:07:18 0 NULL 1 2026-05-09 18:07:40 12554 1 2026-05-09 18:07:40