fx_franchise_order

1,267 rows · 31 columns · page 8 / 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
351 361 POF-1351 INVF-1351 12516 1 2 2 20 209980.0 0.0 16798.4 4999.52 4999.52 0.0 193181.6 INR 0.0 70000.0 0.0 4 12516 2025-12-14 15:52:13 0 NULL 1 2025-12-14 15:52:45 1 0 NULL
352 362 POF-1352 INVF-1352 12518 12517 2 1 101 72639.2 0.0 1452.78 1729.51 1729.51 0.0 71186.42 INR 0.0 50.5 0.0 4 12518 2025-12-16 15:39:27 0 NULL 2 2025-12-19 21:07:15 12517 0 NULL
353 363 POF-1353 INVF-1353 12555 12554 2 1 10 7192.0 0.0 143.84 171.24 171.24 0.0 7048.16 INR 0.0 5.0 0.0 4 12555 2025-12-16 16:37:33 0 NULL 1 2025-12-16 16:37:50 12554 0 NULL
354 364 POF-1354 INVF-1354 12516 1 2 1 20 209988.0 0.0 16799.04 3058.07 3058.07 0.0 193188.96 INR 0.0 30.0 0.0 4 12516 2025-12-17 12:02:36 0 NULL 1 2025-12-21 11:38:03 1 0 NULL
355 365 POF-1355 INVF-1355 12516 1 2 1 20 209988.0 0.0 16799.04 3058.07 3058.07 0.0 193188.96 INR 0.0 30.0 0.0 4 12516 2025-12-17 12:08:01 0 NULL 1 2025-12-17 12:09:09 1 0 NULL
356 366 POF-1356 INVF-1356 12554 12516 2 1 20 209988.0 0.0 10499.4 3058.07 3058.07 0.0 199488.6 INR 0.0 30.0 0.0 4 12554 2025-12-17 12:10:20 0 NULL 1 2025-12-17 12:11:02 12516 0 NULL
357 367 POF-1357 INVF-1357 12555 12554 2 1 20 209988.0 0.0 4199.76 3058.07 3058.07 0.0 205788.24 INR 0.0 30.0 0.0 4 12555 2025-12-17 12:12:24 0 NULL 1 2025-12-17 12:14:00 12554 0 NULL
358 368 POF-1358 INVF-1358 12555 12554 2 1 8 78595.2 0.0 1571.9 1144.59 1144.59 0.0 77023.3 INR 0.0 9.0 0.0 4 12555 2025-12-17 12:13:42 0 NULL 2 2025-12-23 20:09:52 12554 0 NULL
359 369 POF-1359 INVF-1359 12555 12554 2 1 10 7992.0 0.0 159.84 609.56 609.56 0.0 7832.16 INR 0.0 5.0 0.0 4 12555 2025-12-17 13:54:51 0 NULL 1 2025-12-17 13:55:08 12554 0 NULL
360 370 POF-1360 INVF-1360 12555 12554 2 1 100 79920.0 0.0 1598.4 6095.59 6095.59 0.0 78321.6 INR 0.0 50.0 0.0 4 12555 2025-12-17 14:55:12 0 NULL 1 2025-12-17 14:56:36 12554 0 NULL
361 371 POF-1361 INVF-1361 12554 12516 2 1 100 79920.0 0.0 3996.0 6095.59 6095.59 0.0 75924.0 INR 0.0 50.0 0.0 4 12554 2025-12-17 14:55:38 0 NULL 1 2025-12-17 14:56:20 12516 0 NULL
362 372 POF-1362 INVF-1362 12516 1 2 1 100 79920.0 0.0 6393.6 6095.59 6095.59 0.0 73526.4 INR 0.0 50.0 0.0 4 12516 2025-12-17 14:55:58 0 NULL 1 2025-12-17 14:56:10 1 0 NULL
363 373 POF-1363 INVF-1363 12555 12554 2 1 60 62400.0 0.0 1248.0 1485.7 1485.7 0.0 61152.0 INR 0.0 5.0 0.0 4 12555 2025-12-17 21:29:33 0 NULL 1 2025-12-18 11:39:33 12554 0 NULL
364 374 POF-1364 INVF-1364 12516 1 2 1 800 698000.0 0.0 55840.0 19242.14 19242.14 0.0 642160.0 INR 0.0 50.0 0.0 4 12516 2025-12-17 21:41:08 0 NULL 1 2025-12-17 21:41:31 1 0 NULL
365 375 POF-1365 INVF-1365 12554 12516 2 1 450 409000.0 0.0 20450.0 11049.62 11049.62 0.0 388550.0 INR 0.0 25.0 0.0 4 12554 2025-12-17 21:44:19 0 NULL 1 2025-12-17 21:46:23 12516 0 NULL
366 376 POF-1366 INVF-1366 12516 1 2 1 100 120000.0 0.0 9600.0 2857.14 2857.14 0.0 110400.0 INR 0.0 100.0 0.0 4 12516 2025-12-17 21:45:35 0 NULL 1 2025-12-17 21:45:55 1 0 NULL
367 377 POF-1367 INVF-1367 12555 12554 2 1 700 674000.0 0.0 13480.0 18670.7 18670.7 0.0 660520.0 INR 0.0 50.0 0.0 4 12555 2025-12-17 21:53:22 0 NULL 1 2025-12-18 08:23:47 12554 0 NULL
368 378 POF-1368 INVF-1368 12555 12554 2 1 410 374000.0 0.0 7480.0 11527.84 11527.84 0.0 366520.0 INR 0.0 25.0 0.0 4 12555 2025-12-18 08:12:33 0 NULL 2 2025-12-18 13:38:10 12554 0 NULL
369 379 POF-1369 INVF-1369 12554 12516 2 1 700 674000.0 0.0 33700.0 18670.7 18670.7 0.0 640300.0 INR 0.0 50.0 0.0 4 12554 2025-12-18 08:16:30 0 NULL 1 2025-12-18 08:23:04 12516 0 NULL
370 380 POF-1370 INVF-1370 12516 1 2 1 700 674000.0 0.0 53920.0 18670.7 18670.7 0.0 620080.0 INR 0.0 50.0 0.0 4 12516 2025-12-18 08:18:58 0 NULL 1 2025-12-18 08:22:30 1 0 NULL
371 381 POF-1371 INVF-1371 12555 12554 2 1 40 28800.0 0.0 576.0 685.71 685.71 0.0 28224.0 INR 0.0 20.0 0.0 4 12555 2025-12-18 11:38:57 0 NULL 1 2025-12-18 11:39:26 12554 0 NULL
372 382 POF-1372 INVF-1372 12555 12554 2 1 50 25000.0 0.0 500.0 1906.78 1906.78 0.0 24500.0 INR 0.0 25.0 0.0 4 12555 2025-12-18 15:30:09 0 NULL 1 2025-12-18 15:30:20 12554 0 NULL
373 383 POF-1373 INVF-1373 12554 12516 2 1 100 50000.0 0.0 2500.0 3813.56 3813.56 0.0 47500.0 INR 0.0 50.0 0.0 4 12554 2025-12-18 17:03:38 0 NULL 1 2025-12-18 17:04:00 12516 0 NULL
374 384 POF-1374 INVF-1374 12555 12554 2 1 100 50000.0 0.0 1000.0 3813.56 3813.56 0.0 49000.0 INR 0.0 50.0 0.0 4 12555 2025-12-18 17:04:29 0 NULL 1 2025-12-18 17:04:40 12554 0 NULL
375 385 POF-1375 INVF-1375 12516 1 2 1 200 100000.0 0.0 8000.0 7627.12 7627.12 0.0 92000.0 INR 0.0 100.0 0.0 4 12516 2025-12-18 18:35:31 0 NULL 1 2025-12-18 18:37:23 1 0 NULL
376 386 POF-1376 INVF-1376 12554 12516 2 1 200 100000.0 0.0 5000.0 7627.12 7627.12 0.0 95000.0 INR 0.0 100.0 0.0 4 12554 2025-12-18 18:37:45 0 NULL 1 2025-12-18 18:38:00 12516 0 NULL
377 387 POF-1377 INVF-1377 12555 12554 2 1 200 100000.0 0.0 2000.0 7627.12 7627.12 0.0 98000.0 INR 0.0 100.0 0.0 4 12555 2025-12-18 18:38:26 0 NULL 1 2025-12-18 18:38:42 12554 0 NULL
378 388 POF-1378 INVF-1378 12516 1 2 1 100 72000.0 0.0 5760.0 1714.29 1714.29 0.0 66240.0 INR 0.0 50.0 0.0 4 12516 2025-12-18 18:54:57 0 NULL 1 2025-12-18 18:55:06 1 0 NULL
379 389 POF-1379 INVF-1379 12554 12516 2 1 100 72000.0 0.0 3600.0 1714.29 1714.29 0.0 68400.0 INR 0.0 50.0 0.0 4 12554 2025-12-18 18:55:22 0 NULL 1 2025-12-18 18:55:56 12516 0 NULL
380 390 POF-1380 INVF-1380 12555 12554 2 1 50 36000.0 0.0 720.0 857.14 857.14 0.0 35280.0 INR 0.0 25.0 0.0 4 12555 2025-12-18 18:55:44 0 NULL 1 2025-12-18 18:56:09 12554 0 NULL
381 391 POF-1381 INVF-1381 12555 12554 2 1 50 25000.0 0.0 500.0 1906.78 1906.78 0.0 24500.0 INR 0.0 25.0 0.0 4 12555 2025-12-19 08:19:38 0 NULL 1 2025-12-19 08:26:48 12554 0 NULL
382 392 POF-1382 INVF-1382 12516 1 2 1 600 322000.0 0.0 25760.0 20782.09 20782.09 0.0 296240.0 INR 0.0 50.0 0.0 4 12516 2025-12-19 08:20:54 0 NULL 1 2025-12-19 08:22:29 1 0 NULL
383 393 POF-1383 INVF-1383 12554 12516 2 1 500 272000.0 0.0 13600.0 16968.53 16968.53 0.0 258400.0 INR 0.0 50.0 0.0 4 12554 2025-12-19 08:23:11 0 NULL 1 2025-12-19 08:26:08 12516 0 NULL
384 394 POF-1384 INVF-1384 12555 12554 2 1 450 247000.0 0.0 4940.0 15061.75 15061.75 0.0 242060.0 INR 0.0 50.0 0.0 4 12555 2025-12-19 08:25:03 0 NULL 2 2025-12-19 08:26:43 12554 0 NULL
385 395 POF-1385 INVF-1385 12555 12554 2 1 450 247000.0 0.0 4940.0 15061.75 15061.75 0.0 242060.0 INR 0.0 50.0 0.0 4 12555 2025-12-19 08:25:38 0 NULL 1 2025-12-19 08:26:37 12554 0 NULL
386 396 POF-1386 INVF-1386 12555 12554 2 1 600 322000.0 0.0 6440.0 20782.08 20782.08 0.0 315560.0 INR 0.0 25.0 0.0 4 12555 2025-12-19 13:12:41 0 NULL 1 2025-12-19 13:25:06 12554 0 NULL
387 397 POF-1387 INVF-1387 12554 12516 2 1 500 250000.0 0.0 12500.0 19067.8 19067.8 0.0 237500.0 INR 0.0 250.0 0.0 4 12554 2025-12-19 13:21:26 0 NULL 1 2025-12-19 13:24:46 12516 0 NULL
388 398 POF-1388 INVF-1388 12554 12516 2 1 100 72000.0 0.0 3600.0 1714.28 1714.28 0.0 68400.0 INR 0.0 25.0 0.0 4 12554 2025-12-19 13:21:57 0 NULL 1 2025-12-19 13:24:52 12516 0 NULL
389 399 POF-1389 INVF-1389 12516 1 2 1 600 322000.0 0.0 25760.0 20782.08 20782.08 0.0 296240.0 INR 0.0 25.0 0.0 4 12516 2025-12-19 13:22:48 0 NULL 1 2025-12-19 13:24:30 1 0 NULL
390 400 POF-1390 INVF-1390 12555 12554 2 1 400 200000.0 0.0 4000.0 15254.24 15254.24 0.0 196000.0 INR 0.0 200.0 0.0 4 12555 2025-12-19 18:45:44 0 NULL 1 2025-12-19 18:47:55 12554 0 NULL
391 401 POF-1391 INVF-1391 12554 12516 2 1 400 200000.0 0.0 10000.0 15254.24 15254.24 0.0 190000.0 INR 0.0 200.0 0.0 4 12554 2025-12-19 18:46:10 0 NULL 1 2025-12-19 18:47:35 12516 0 NULL
392 402 POF-1392 INVF-1392 12516 1 2 1 400 200000.0 0.0 16000.0 15254.24 15254.24 0.0 184000.0 INR 0.0 200.0 0.0 4 12516 2025-12-19 18:46:31 0 NULL 1 2025-12-19 18:47:13 1 0 NULL
393 403 POF-1393 INVF-1393 12516 1 2 1 100 72000.0 0.0 5760.0 1714.29 1714.29 0.0 66240.0 INR 0.0 50.0 0.0 4 12516 2025-12-19 20:45:46 0 NULL 1 2025-12-19 20:48:41 1 0 NULL
394 404 POF-1394 INVF-1394 12554 12516 2 1 100 72000.0 0.0 3600.0 1714.29 1714.29 0.0 68400.0 INR 0.0 50.0 0.0 4 12554 2025-12-19 20:46:36 0 NULL 1 2025-12-19 20:49:12 12516 0 NULL
395 405 POF-1395 INVF-1395 12555 12554 2 1 100 72000.0 0.0 1440.0 1714.29 1714.29 0.0 70560.0 INR 0.0 50.0 0.0 4 12555 2025-12-19 20:47:30 0 NULL 1 2025-12-19 20:49:38 12554 0 NULL
396 406 POF-1396 INVF-1396 12554 12516 2 1 30 36000.0 0.0 1800.0 857.14 857.14 0.0 34200.0 INR 0.0 30.0 0.0 4 12554 2025-12-19 22:26:44 0 NULL 1 2025-12-19 22:28:01 12516 0 NULL
397 407 POF-1397 INVF-1397 12516 1 2 1 50 60000.0 0.0 4800.0 1428.57 1428.57 0.0 55200.0 INR 0.0 50.0 0.0 4 12516 2025-12-19 22:27:41 0 NULL 1 2025-12-19 22:27:51 1 0 NULL
398 408 POF-1398 INVF-1398 12555 12554 2 1 50 60000.0 0.0 1200.0 1428.57 1428.57 0.0 58800.0 INR 0.0 50.0 0.0 4 12555 2025-12-19 22:28:59 0 NULL 1 2025-12-19 22:35:04 12554 0 NULL
399 409 POF-1399 INVF-1399 12554 12516 2 1 50 60000.0 0.0 3000.0 1428.57 1428.57 0.0 57000.0 INR 0.0 50.0 0.0 4 12554 2025-12-19 22:30:32 0 NULL 1 2025-12-19 22:30:45 12516 0 NULL
400 410 POF-1400 INVF-1400 12516 1 2 1 50 60000.0 0.0 4800.0 1428.57 1428.57 0.0 55200.0 INR 0.0 50.0 0.0 4 12516 2025-12-19 22:32:59 0 NULL 1 2025-12-19 22:33:10 1 0 NULL