fx_franchise_order

1,267 rows · 31 columns · page 25 / 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
1201 1212 POFN-2201 INVFN-2201 12526 12517 2 1 6 954.0 0.0 16.17 72.76 72.76 0.0 954.0 INR 330.0 330.15 330.0 4 12526 2026-05-28 20:44:51 0 NULL 1 2026-05-29 21:03:23 12517 1 2026-05-29 21:03:23
1202 1213 POFN-2202 INVFN-2202 12539 12517 2 1 4 2222.0 0.0 41.95 62.35 62.35 0.0 2222.0 INR 1084.0 1084.05 1084.0 4 12539 2026-05-29 15:53:20 0 NULL 1 2026-05-29 21:03:47 12517 1 2026-05-29 21:03:47
1203 1214 POFN-2203 INVFN-2203 12539 12517 2 1 3 957.0 0.0 18.23 22.79 22.79 0.0 957.0 INR 477.0 477.15 477.0 4 12539 2026-05-29 16:14:49 0 NULL 1 2026-05-29 21:03:47 12517 1 2026-05-29 21:03:47
1204 1215 POFN-2204 INVFN-2204 12526 12517 2 1 18 5198.0 0.0 92.88 277.05 277.05 0.0 5198.0 INR 2396.0 2396.15 2396.0 4 12526 2026-05-29 23:55:48 0 NULL 1 2026-05-30 13:02:08 12517 1 2026-05-30 13:02:08
1205 1216 POFN-2205 INVFN-2205 12532 12517 2 1 1 10700.0 0.0 203.81 254.76 254.76 0.0 10700.0 INR 5350.0 5352.0 5350.0 4 12532 2026-05-30 12:44:21 0 NULL 1 2026-05-30 13:02:23 12517 1 2026-05-30 13:02:23
1206 1217 POFN-2206 INVFN-2206 12532 12517 2 1 9 7476.0 0.0 142.4 178.0 178.0 0.0 7476.0 INR 3736.0 3736.3 3736.0 4 12532 2026-05-30 13:37:20 0 NULL 1 2026-05-30 19:12:05 12517 1 2026-05-30 19:12:05
1207 1218 POFN-2207 INVFN-2207 12526 12517 2 1 16 7458.0 0.0 136.48 317.01 317.01 0.0 7458.0 INR 3435.0 3435.3 3435.0 4 12526 2026-05-30 21:41:09 0 NULL 1 2026-05-30 21:53:58 12517 1 2026-05-30 21:53:58
1208 1219 POFN-2208 INVFN-2208 12545 12517 2 1 63 13114.0 0.0 249.79 312.24 312.24 0.0 13114.0 INR 6304.0 6304.45 6304.0 4 12545 2026-05-31 08:49:43 0 NULL 1 2026-05-31 09:15:43 12517 1 2026-05-31 09:15:43
1209 1220 POFN-2209 INVFN-2209 12539 12517 2 1 4 4418.0 0.0 84.15 105.19 105.19 0.0 4418.0 INR 2208.0 2208.15 2208.0 4 12539 2026-05-31 12:39:10 0 NULL 1 2026-05-31 12:42:32 12517 1 2026-05-31 12:42:32
1210 1221 POFN-2210 INVFN-2210 12539 12517 2 1 1 80.0 0.0 1.52 1.9 1.9 0.0 80.0 INR 35.0 35.01 35.0 4 12539 2026-05-31 12:43:52 0 NULL 1 2026-05-31 12:58:36 12517 1 2026-05-31 12:58:36
1211 1222 POFN-2211 INVFN-2211 12545 12517 2 1 7 2235.0 0.0 40.9 94.92 94.92 0.0 2235.0 INR 995.0 995.12 995.0 4 12545 2026-05-31 21:50:53 0 NULL 1 2026-05-31 22:16:32 12517 1 2026-05-31 22:16:32
1212 1223 POFN-2212 INVFN-2212 12545 12517 2 1 7 1113.0 0.0 18.86 84.89 84.89 0.0 1113.0 INR 385.0 385.08 385.0 4 12545 2026-05-31 21:51:34 0 NULL 1 2026-05-31 22:16:28 12517 1 2026-05-31 22:16:28
1213 1224 POFN-2213 INVFN-2213 12545 12517 2 1 2 520.0 0.0 9.65 18.68 18.68 0.0 520.0 INR 242.0 242.01 242.0 4 12545 2026-06-01 12:06:10 0 NULL 1 2026-06-01 13:30:15 12517 1 2026-06-01 13:30:15
1214 1225 POFN-2214 INVFN-2214 12555 12554 2 1 1 1600.0 0.0 30.48 38.1 38.1 0.0 1600.0 INR 800.0 800.25 800.0 4 12555 2026-06-02 17:07:58 0 NULL 1 2026-06-02 17:08:35 12554 1 2026-06-02 17:08:35
1215 1226 POFN-2215 INVFN-2215 12516 1 2 1 10 185000.0 0.0 14095.24 4404.76 4404.76 0.0 185000.0 INR 92500.0 92537.5 92500.0 4 12516 2026-06-03 14:55:50 0 NULL 1 2026-06-28 15:56:18 1 1 2026-06-28 15:56:18
1216 1227 POFN-2216 INVFN-2216 12554 12516 2 1 10 185000.0 0.0 10571.43 4404.76 4404.76 0.0 185000.0 INR 92500.0 92537.5 92500.0 4 12554 2026-06-03 17:02:13 0 NULL 1 2026-06-03 17:03:11 12516 1 2026-06-03 17:03:11
1217 1228 POFN-2217 INVFN-2217 12554 12516 2 1 10 16000.0 0.0 914.29 380.95 380.95 0.0 16000.0 INR 8000.0 8002.5 8000.0 4 12554 2026-06-03 17:02:33 0 NULL 1 2026-06-03 17:03:11 12516 1 2026-06-03 17:03:11
1218 1229 POFN-2218 INVFN-2218 12555 12554 2 1 10 100500.0 0.0 1914.29 2392.86 2392.86 0.0 100500.0 INR 50250.0 50268.75 50250.0 4 12555 2026-06-03 17:04:09 0 NULL 1 2026-06-03 17:04:28 12554 1 2026-06-03 17:04:28
1219 1230 POFN-2219 INVFN-2219 12545 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 12545 2026-06-03 21:34:29 0 NULL 1 2026-06-03 21:35:34 12517 1 2026-06-03 21:35:34
1220 1231 POFN-2220 INVFN-2220 12555 12554 2 1 4 6000.0 0.0 114.29 142.86 142.86 0.0 6000.0 INR 3000.0 3001.2 3000.0 4 12555 2026-06-04 17:20:10 0 NULL 1 2026-06-04 17:20:45 12554 1 2026-06-04 17:20:45
1221 1232 POFN-2221 INVFN-2221 12554 12516 2 1 30 75000.0 0.0 4368.93 1092.23 1092.23 0.0 75000.0 INR 37500.0 37515.0 37500.0 4 12554 2026-06-05 18:57:52 0 NULL 1 2026-06-05 18:59:23 12516 1 2026-06-05 18:59:23
1222 1233 POFN-2222 INVFN-2222 12555 12554 2 1 10 25000.0 0.0 485.44 364.08 364.08 0.0 25000.0 INR 12500.0 12505.0 12500.0 4 12555 2026-06-05 19:50:33 0 NULL 1 2026-06-05 19:51:25 12554 1 2026-06-05 19:51:25
1223 1234 POFN-2223 INVFN-2223 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-06-06 12:11:14 0 NULL 1 2026-06-06 12:11:40 12554 1 2026-06-06 12:11:40
1224 1235 POFN-2224 INVFN-2224 14902 12517 2 1 92 20198.0 0.0 362.46 1037.42 1037.42 0.0 20198.0 INR 8663.0 8663.02 8663.0 4 14902 2026-06-07 09:38:45 0 NULL 1 2026-06-07 10:19:36 12517 1 2026-06-07 10:19:36
1225 1236 POFN-2225 INVFN-2225 14902 12517 2 1 1 1000.0 0.0 19.05 23.81 23.81 0.0 1000.0 INR 500.0 500.18 500.0 4 14902 2026-06-07 12:34:40 0 NULL 1 2026-06-07 13:53:22 12517 1 2026-06-07 13:53:22
1226 1237 POFN-2226 INVFN-2226 12555 12554 2 1 48 66280.0 0.0 1248.23 1934.31 1934.31 0.0 66280.0 INR 33130.0 33131.8 33130.0 4 12555 2026-06-07 17:17:05 0 NULL 1 2026-06-07 17:17:28 12554 1 2026-06-07 17:17:28
1227 1238 POFN-2227 INVFN-2227 12554 12516 2 1 39 61100.0 0.0 3491.43 1454.76 1454.76 0.0 61100.0 INR 30300.0 30302.5 30300.0 4 12554 2026-06-07 17:21:33 0 NULL 1 2026-06-07 17:21:58 12516 1 2026-06-07 17:21:58
1228 1239 POFN-2228 INVFN-2228 12527 12517 2 1 51 18980.0 0.0 349.81 744.64 744.64 0.0 18980.0 INR 8640.0 8640.22 8640.0 4 12527 2026-06-08 15:26:48 0 NULL 1 2026-06-08 21:23:04 12517 1 2026-06-08 21:23:04
1229 1240 POFN-2229 INVFN-2229 12527 12517 2 1 2 1919.0 0.0 36.55 45.69 45.69 0.0 1919.0 INR 959.0 959.05 959.0 4 12527 2026-06-10 08:11:53 0 NULL 1 2026-06-10 11:40:27 12517 1 2026-06-10 11:40:27
1230 1241 POFN-2230 INVFN-2230 14079 12517 2 1 2 600.0 0.0 11.43 14.29 14.29 0.0 600.0 INR 300.0 300.1 300.0 4 14079 2026-06-11 18:54:37 0 NULL 1 2026-06-12 16:30:04 12517 1 2026-06-12 16:30:04
1231 1242 POFN-2231 INVFN-2231 12527 12517 2 1 1 1600.0 0.0 30.48 38.1 38.1 0.0 1600.0 INR 800.0 800.25 800.0 4 12527 2026-06-12 12:47:27 0 NULL 1 2026-06-12 16:21:54 12517 1 2026-06-12 16:21:54
1232 1243 POFN-2232 INVFN-2232 12527 12517 2 1 1 1600.0 0.0 30.48 38.1 38.1 0.0 1600.0 INR 800.0 800.25 800.0 4 12527 2026-06-12 19:24:02 0 NULL 1 2026-06-12 21:09:56 12517 1 2026-06-12 21:09:56
1233 1244 POFN-2233 INVFN-2233 16410 12555 2 1 9 2091.0 0.0 78.89 59.44 59.44 0.0 2091.0 INR 1003.0 1003.08 1003.0 4 16410 2026-06-13 13:04:53 0 NULL 1 2026-06-13 13:16:13 12555 1 2026-06-13 13:16:13
1234 1245 POFN-2234 INVFN-2234 16410 12555 2 1 4 3278.0 0.0 78.49 86.39 86.39 0.0 3278.0 INR 1614.0 1614.5 1614.0 4 16410 2026-06-13 13:15:23 0 NULL 1 2026-06-13 13:16:13 12555 1 2026-06-13 13:16:13
1235 1246 POFN-2235 INVFN-2235 12555 12554 2 1 20 32000.0 0.0 609.52 761.9 761.9 0.0 32000.0 INR 16000.0 16005.0 16000.0 4 12555 2026-06-13 13:20:29 0 NULL 1 2026-06-13 13:21:00 12554 1 2026-06-13 13:21:00
1236 1247 POFN-2236 INVFN-2236 16410 12555 2 1 6 2697.0 0.0 101.41 80.9 80.9 0.0 2697.0 INR 1289.0 1289.3 1289.0 4 16410 2026-06-13 13:28:28 0 NULL 1 2026-06-13 15:10:01 12555 1 2026-06-13 15:10:01
1237 1248 POFN-2237 INVFN-2237 12527 12517 2 1 1 559.0 0.0 9.47 42.64 42.64 0.0 559.0 INR 279.0 279.11 279.0 4 12527 2026-06-15 14:53:17 0 NULL 1 2026-06-15 16:09:20 12517 1 2026-06-15 16:09:20
1238 1249 POFN-2238 INVFN-2238 12527 12517 2 1 1 1600.0 0.0 30.48 38.1 38.1 0.0 1600.0 INR 800.0 800.25 800.0 4 12527 2026-06-15 16:09:37 0 NULL 1 2026-06-15 21:10:16 12517 1 2026-06-15 21:10:16
1239 1250 POFN-2239 INVFN-2239 12526 12517 2 1 7 8600.0 0.0 163.81 204.76 204.76 0.0 8600.0 INR 4300.0 4300.75 4300.0 4 12526 2026-06-15 22:48:22 0 NULL 1 2026-06-15 22:58:59 12517 1 2026-06-15 22:58:59
1240 1251 POFN-2240 INVFN-2240 12526 12517 2 1 2 3099.0 0.0 59.03 73.79 73.79 0.0 3099.0 INR 1549.0 1549.3 1549.0 4 12526 2026-06-15 23:06:46 0 NULL 1 2026-06-16 08:10:32 12517 1 2026-06-16 08:10:32
1241 1252 POFN-2241 INVFN-2241 16410 12555 2 1 11 6478.0 0.0 199.72 171.03 171.03 0.0 6478.0 INR 3218.0 3218.03 3218.0 4 16410 2026-06-17 10:59:31 0 NULL 1 2026-06-17 11:16:37 12555 1 2026-06-17 11:16:37
1242 1253 POFN-2242 INVFN-2242 12555 12554 2 1 10 7190.0 0.0 136.95 171.19 171.19 0.0 7190.0 INR 3590.0 3591.5 3590.0 4 12555 2026-06-17 11:26:59 0 NULL 1 2026-06-17 11:27:27 12554 1 2026-06-17 11:27:28
1243 1254 POFN-2243 INVFN-2243 12517 12516 2 1 30 6120.0 0.0 349.71 0.0 0.0 291.43 6120.0 INR 3060.0 3061.2 3060.0 4 12517 2026-06-17 11:29:12 0 NULL 1 2026-06-17 11:29:31 12516 1 2026-06-17 11:29:31
1244 1255 POFN-2244 INVFN-2244 12527 12517 2 1 1 1600.0 0.0 30.48 38.1 38.1 0.0 1600.0 INR 800.0 800.25 800.0 4 12527 2026-06-22 10:10:04 0 NULL 1 2026-06-22 11:36:26 12517 1 2026-06-22 11:36:26
1245 1256 POFN-2245 INVFN-2245 12685 12517 2 1 15 5548.0 0.0 102.53 210.79 210.79 0.0 5548.0 INR 2774.0 2774.48 2774.0 4 12685 2026-06-22 18:33:33 0 NULL 1 2026-06-23 00:00:26 12517 1 2026-06-23 00:00:26
1246 1257 POFN-2246 INVFN-2246 12527 12517 2 1 1 1600.0 0.0 30.48 38.1 38.1 0.0 1600.0 INR 800.0 800.25 800.0 4 12527 2026-06-23 09:48:47 0 NULL 1 2026-06-23 11:00:24 12517 1 2026-06-23 11:00:24
1247 1258 POFN-2247 INVFN-2247 12526 12517 2 1 4 736.0 0.0 12.47 56.14 56.14 0.0 736.0 INR 260.0 260.04 260.0 4 12526 2026-06-27 10:07:22 0 NULL 1 2026-06-27 12:35:13 12517 1 2026-06-27 12:35:13
1248 1259 POFN-2248 INVFN-2248 12516 1 2 1 30 198000.0 0.0 15085.71 4714.29 4714.29 0.0 198000.0 INR 99000.0 99020.0 99000.0 4 12516 2026-06-28 15:55:37 0 NULL 1 2026-06-28 15:56:18 1 1 2026-06-28 15:56:18
1249 1260 POFN-2249 INVFN-2249 12554 12516 2 1 11 98500.0 0.0 5628.57 2345.24 2345.24 0.0 98500.0 INR 49250.0 49260.0 49250.0 4 12554 2026-06-28 17:22:54 0 NULL 1 2026-06-28 19:00:51 12516 1 2026-06-28 19:00:51
1250 1261 POFN-2250 INVFN-2250 12555 12554 2 1 7 58900.0 0.0 1121.9 1402.38 1402.38 0.0 58900.0 INR 29450.0 29454.0 29450.0 4 12555 2026-06-28 19:03:22 0 NULL 1 2026-06-28 19:03:58 12554 1 2026-06-28 19:03:58