fx_franchise_order

1,267 rows · 31 columns · page 7 / 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
301 311 POF-1301 INVF-1301 12516 1 2 1 4 14400.0 0.0 1152.0 342.86 342.86 0.0 13248.0 INR 4000.0 4000.0 6400.0 4 12516 2025-11-30 09:25:32 0 NULL 1 2025-11-30 09:25:48 1 0 NULL
302 312 POF-1302 INVF-1302 12555 12554 2 1 1100 63920.0 0.0 1278.4 2357.09 2357.09 0.0 62641.6 INR 18000.0 18000.0 21000.0 4 12555 2025-11-30 15:48:04 0 NULL 1 2025-11-30 15:48:36 12554 0 NULL
303 313 POF-1303 INVF-1303 12555 12554 2 2 6 62994.0 0.0 1259.88 1499.86 1499.86 0.0 61734.12 INR 0.0 21000.0 0.0 4 12555 2025-11-30 19:50:50 0 NULL 1 2025-11-30 19:51:16 12554 0 NULL
304 314 POF-1304 INVF-1304 12555 12554 2 1 5 3996.0 0.0 79.92 304.78 304.78 0.0 3916.08 INR 1625.0 1625.0 2375.0 4 12555 2025-11-30 23:19:31 0 NULL 1 2025-11-30 23:20:14 12554 0 NULL
305 315 POF-1305 INVF-1305 12555 12554 2 1 4 4796.8 0.0 95.94 114.21 114.21 0.0 4700.86 INR 1700.0 1700.0 3100.0 4 12555 2025-11-30 23:27:23 0 NULL 1 2025-11-30 23:27:42 12554 0 NULL
306 316 POF-1306 INVF-1306 12555 12554 2 2 30 314970.0 0.0 6299.4 7499.28 7499.28 0.0 308670.6 INR 0.0 105000.0 0.0 4 12555 2025-12-01 16:18:59 0 NULL 1 2025-12-01 16:22:14 12554 0 NULL
307 317 POF-1307 INVF-1307 12554 12516 2 2 40 419960.0 0.0 20998.0 9999.05 9999.05 0.0 398962.0 INR 0.0 140000.0 0.0 4 12554 2025-12-01 16:19:41 0 NULL 1 2025-12-01 16:21:35 12516 0 NULL
308 318 POF-1308 INVF-1308 12516 1 2 2 50 524950.0 0.0 41996.0 12498.81 12498.81 0.0 482954.0 INR 0.0 175000.0 0.0 4 12516 2025-12-01 16:20:26 0 NULL 1 2025-12-01 16:21:04 1 0 NULL
309 319 POF-1309 INVF-1309 12855 12551 2 1 46 55200.0 0.0 1104.0 1314.29 1314.29 0.0 54096.0 INR 20700.0 20700.0 27600.0 4 12855 2025-12-01 17:49:50 0 NULL 2 2025-12-06 15:37:15 12551 0 NULL
310 320 POF-1310 INVF-1310 12855 12551 2 1 6 11995.2 0.0 239.9 285.6 285.6 0.0 11755.3 INR 4494.0 4494.0 7494.0 4 12855 2025-12-01 18:03:10 0 NULL 1 2025-12-01 18:38:54 12551 0 NULL
311 321 POF-1311 INVF-1311 12552 12517 2 2 1 10499.0 0.0 209.98 249.97 249.97 0.0 10289.02 INR 0.0 3500.0 0.0 4 12552 2025-12-03 17:17:31 0 NULL 1 2025-12-03 17:21:25 12517 0 NULL
312 322 POF-1312 INVF-1312 12555 12554 2 1 20 5584.0 0.0 111.68 132.95 132.95 0.0 5472.32 INR 2400.0 2400.0 3100.0 4 12555 2025-12-04 15:34:41 0 NULL 1 2025-12-04 15:36:59 12554 0 NULL
313 323 POF-1313 INVF-1313 12554 12516 2 1 30 8376.0 0.0 418.8 199.43 199.43 0.0 7957.2 INR 3600.0 3600.0 4650.0 4 12554 2025-12-04 15:36:04 0 NULL 1 2025-12-04 15:36:25 12516 0 NULL
314 324 POF-1314 INVF-1314 12551 12516 2 1 58 11969.6 0.0 598.48 620.44 620.44 0.0 11371.12 INR 3471.0 3471.0 3666.0 4 12551 2025-12-05 14:21:29 0 NULL 1 2025-12-05 14:25:26 12516 0 NULL
315 325 POF-1315 INVF-1315 12516 1 2 1 60 18240.0 0.0 1459.2 1159.32 1159.32 0.0 16780.8 INR 5400.0 5400.0 6360.0 4 12516 2025-12-05 14:23:35 0 NULL 1 2025-12-05 14:25:05 1 0 NULL
316 326 POF-1316 INVF-1316 12554 12516 2 1 10 3040.0 0.0 152.0 0.0 0.0 0.0 2888.0 INR 400.0 400.0 1360.0 4 12554 2025-12-05 14:30:49 0 NULL 1 2025-12-07 22:37:06 12516 0 NULL
317 327 POF-1317 INVF-1317 12551 12516 2 2 3 54000.0 0.0 2700.0 1285.71 1285.71 0.0 51300.0 INR 0.0 22500.0 0.0 4 12551 2025-12-05 14:34:50 0 NULL 1 2025-12-05 15:50:31 12516 0 NULL
318 328 POF-1318 INVF-1318 12551 12516 2 1 1 48.0 0.0 2.4 1.14 1.14 0.0 45.6 INR 10.0 10.0 13.0 4 12551 2025-12-05 15:47:09 0 NULL 1 2025-12-05 15:47:29 12516 0 NULL
319 329 POF-1319 INVF-1319 12555 12554 2 1 30 16776.0 0.0 335.52 692.59 692.59 0.0 16440.48 INR 8400.0 8400.0 12000.0 4 12555 2025-12-05 17:28:50 0 NULL 1 2025-12-05 17:32:32 12554 0 NULL
320 330 POF-1320 INVF-1320 12554 12516 2 1 30 16776.0 0.0 838.8 692.59 692.59 0.0 15937.2 INR 8400.0 8400.0 12000.0 4 12554 2025-12-05 17:29:37 0 NULL 1 2025-12-05 17:31:52 12516 0 NULL
321 331 POF-1321 INVF-1321 12516 1 2 1 30 16776.0 0.0 1342.08 692.59 692.59 0.0 15433.92 INR 8400.0 8400.0 12000.0 4 12516 2025-12-05 17:30:15 0 NULL 1 2025-12-05 17:31:03 1 0 NULL
322 332 POF-1322 INVF-1322 12555 12554 2 1 20 3184.0 0.0 63.68 242.85 242.85 0.0 3120.32 INR 700.0 700.0 1300.0 4 12555 2025-12-05 17:35:18 0 NULL 1 2025-12-05 17:36:41 12554 0 NULL
323 333 POF-1323 INVF-1323 12554 12516 2 1 30 4776.0 0.0 238.8 364.27 364.27 0.0 4537.2 INR 1050.0 1050.0 1950.0 4 12554 2025-12-05 17:36:01 0 NULL 1 2025-12-05 17:36:23 12516 0 NULL
324 334 POF-1324 INVF-1324 12552 12517 2 2 1 10499.0 0.0 209.98 249.97 249.97 0.0 10289.02 INR 0.0 3500.0 0.0 4 12552 2025-12-05 22:11:30 0 NULL 1 2025-12-06 13:40:13 12517 0 NULL
325 335 POF-1325 INVF-1325 12555 12554 2 2 40 419960.0 0.0 8399.2 9999.05 9999.05 0.0 411560.8 INR 0.0 140000.0 0.0 4 12555 2025-12-05 23:04:31 0 NULL 1 2025-12-05 23:08:49 12554 0 NULL
326 336 POF-1326 INVF-1326 12554 12516 2 2 60 629940.0 0.0 31497.0 14998.57 14998.57 0.0 598443.0 INR 0.0 210000.0 0.0 4 12554 2025-12-05 23:05:26 0 NULL 1 2025-12-05 23:08:19 12516 0 NULL
327 337 POF-1327 INVF-1327 12516 1 2 2 60 629940.0 0.0 50395.2 14998.57 14998.57 0.0 579544.8 INR 0.0 210000.0 0.0 4 12516 2025-12-05 23:06:47 0 NULL 1 2025-12-05 23:07:52 1 0 NULL
328 338 POF-1328 INVF-1328 12552 12517 2 2 1 10499.0 0.0 209.98 249.97 249.97 0.0 10289.02 INR 0.0 3500.0 0.0 4 12552 2025-12-06 13:46:32 0 NULL 1 2025-12-06 13:46:47 12517 0 NULL
329 339 POF-1329 INVF-1329 12855 12551 2 1 58 11969.6 0.0 239.39 620.42 620.42 0.0 11730.21 INR 3471.0 3471.0 3666.0 4 12855 2025-12-06 16:28:15 0 NULL 1 2025-12-06 16:36:57 12551 0 NULL
330 340 POF-1330 INVF-1330 12555 12554 2 1 20 14384.0 0.0 287.68 342.48 342.48 0.0 14096.32 INR 5000.0 5000.0 8400.0 4 12555 2025-12-07 22:35:52 0 NULL 1 2025-12-07 22:37:41 12554 0 NULL
331 341 POF-1331 INVF-1331 12554 12516 2 1 30 21576.0 0.0 1078.8 513.71 513.71 0.0 20497.2 INR 7500.0 7500.0 12600.0 4 12554 2025-12-07 22:36:33 0 NULL 1 2025-12-07 22:36:58 12516 0 NULL
332 342 POF-1332 INVF-1332 12855 12551 2 2 3 54000.0 0.0 1080.0 1285.71 1285.71 0.0 52920.0 INR 0.0 22500.0 0.0 4 12855 2025-12-08 13:51:53 0 NULL 1 2025-12-08 14:08:14 12551 0 NULL
333 343 POF-1333 INVF-1333 12855 12551 2 2 1 18000.0 0.0 360.0 428.57 428.57 0.0 17640.0 INR 0.0 7500.0 0.0 4 12855 2025-12-08 14:00:52 0 NULL 2 2025-12-08 14:08:27 12551 0 NULL
334 344 POF-1334 INVF-1334 12855 12551 2 1 4 8638.4 0.0 172.77 205.68 205.68 0.0 8465.63 INR 2500.0 2500.0 3700.0 4 12855 2025-12-08 14:19:43 0 NULL 1 2025-12-08 14:21:41 12551 0 NULL
335 345 POF-1335 INVF-1335 12855 12551 2 1 122 184960.0 0.0 3699.2 6107.76 6107.76 0.0 181260.8 INR 84600.0 84600.0 90600.0 4 12855 2025-12-08 14:34:32 0 NULL 1 2025-12-08 14:35:43 12551 0 NULL
336 346 POF-1336 INVF-1336 12855 12551 2 2 1 18500.0 0.0 370.0 440.48 440.48 0.0 18130.0 INR 0.0 7500.0 0.0 4 12855 2025-12-08 16:37:48 0 NULL 2 2025-12-08 16:39:48 12551 0 NULL
337 347 POF-1337 INVF-1337 12551 12516 2 2 1 18500.0 0.0 925.0 440.48 440.48 0.0 17575.0 INR 0.0 7500.0 0.0 4 12551 2025-12-08 16:41:42 0 NULL 2 2025-12-11 11:39:38 12516 0 NULL
338 348 POF-1338 INVF-1338 12551 12516 2 1 4 1216.0 0.0 60.8 0.0 0.0 0.0 1155.2 INR 160.0 160.0 544.0 4 12551 2025-12-10 19:06:32 0 NULL 2 2025-12-11 11:39:38 12516 0 NULL
339 349 POF-1339 INVF-1339 12855 12551 2 1 4 1216.0 0.0 24.32 0.0 0.0 0.0 1191.68 INR 160.0 160.0 544.0 4 12855 2025-12-10 19:13:43 0 NULL 1 2025-12-10 19:16:53 12551 0 NULL
340 350 POF-1340 INVF-1340 12555 12554 2 2 10 104990.0 0.0 2099.8 2499.76 2499.76 0.0 102890.2 INR 0.0 35000.0 0.0 4 12555 2025-12-11 11:37:50 0 NULL 1 2025-12-11 11:38:03 12554 0 NULL
341 351 POF-1341 INVF-1341 12555 12554 2 1 30 9120.0 0.0 182.4 0.0 0.0 0.0 8937.6 INR 1200.0 1200.0 4080.0 4 12555 2025-12-11 12:03:19 0 NULL 1 2025-12-11 12:05:58 12554 0 NULL
342 352 POF-1342 INVF-1342 12554 12516 2 1 50 15200.0 0.0 760.0 0.0 0.0 0.0 14440.0 INR 2000.0 2000.0 6800.0 4 12554 2025-12-11 12:03:53 0 NULL 1 2025-12-11 12:05:44 12516 0 NULL
343 353 POF-1343 INVF-1343 12516 1 2 1 60 18240.0 0.0 1459.2 0.0 0.0 0.0 16780.8 INR 2400.0 2400.0 8160.0 4 12516 2025-12-11 12:04:31 0 NULL 1 2025-12-11 12:05:25 1 0 NULL
344 354 POF-1344 INVF-1344 12555 12554 2 1 10 23992.0 0.0 479.84 571.24 571.24 0.0 23512.16 INR 10000.0 10000.0 15000.0 4 12555 2025-12-13 15:30:09 0 NULL 1 2025-12-13 15:32:08 12554 0 NULL
345 355 POF-1345 INVF-1345 12555 12554 2 2 10 104990.0 0.0 2099.8 2499.76 2499.76 0.0 102890.2 INR 0.0 35000.0 0.0 4 12555 2025-12-13 16:28:16 0 NULL 1 2025-12-13 16:28:31 12554 0 NULL
346 356 POF-1346 INVF-1346 12552 12517 2 2 1 10499.0 0.0 209.98 249.97 249.97 0.0 10289.02 INR 0.0 3500.0 0.0 4 12552 2025-12-14 12:30:31 0 NULL 1 2025-12-14 12:43:50 12517 0 NULL
347 357 POF-1347 INVF-1347 12552 12517 2 2 1 10499.0 0.0 209.98 249.97 249.97 0.0 10289.02 INR 0.0 3500.0 0.0 4 12552 2025-12-14 12:48:00 0 NULL 1 2025-12-14 12:53:09 12517 0 NULL
348 358 POF-1348 INVF-1348 12552 12517 2 2 1 10499.0 0.0 209.98 249.97 249.97 0.0 10289.02 INR 0.0 3500.0 0.0 4 12552 2025-12-14 12:55:28 0 NULL 1 2025-12-14 13:00:21 12517 0 NULL
349 359 POF-1349 INVF-1349 12555 12554 2 2 20 209980.0 0.0 4199.6 4999.52 4999.52 0.0 205780.4 INR 0.0 70000.0 0.0 4 12555 2025-12-14 15:49:37 0 NULL 1 2025-12-14 15:54:04 12554 0 NULL
350 360 POF-1350 INVF-1350 12554 12516 2 2 20 209980.0 0.0 10499.0 4999.52 4999.52 0.0 199481.0 INR 0.0 70000.0 0.0 4 12554 2025-12-14 15:51:12 0 NULL 1 2025-12-14 15:53:33 12516 0 NULL