fx_franchise_order

1,267 rows · 31 columns · page 10 / 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
451 461 POF-1451 INVF-1451 12516 1 2 1 30 239400.0 0.0 19152.0 3486.41 3486.41 0.0 220248.0 INR 0.0 60.0 0.0 4 12516 2025-12-26 11:03:16 0 NULL 1 2025-12-26 11:03:26 1 0 NULL
452 462 POF-1452 INVF-1452 12554 12516 2 1 20 159600.0 0.0 7980.0 2324.27 2324.27 0.0 151620.0 INR 0.0 40.0 0.0 4 12554 2025-12-26 11:03:51 0 NULL 1 2025-12-26 11:04:26 12516 0 NULL
453 463 POF-1453 INVF-1453 12555 12554 2 1 20 159600.0 0.0 3192.0 2324.27 2324.27 0.0 156408.0 INR 0.0 40.0 0.0 4 12555 2025-12-26 11:04:14 0 NULL 1 2025-12-26 11:04:40 12554 0 NULL
454 464 POF-1454 INVF-1454 12555 12554 2 1 10 7190.0 0.0 143.8 171.19 171.19 0.0 7046.2 INR 0.0 1.5 0.0 4 12555 2025-12-26 12:33:09 0 NULL 1 2025-12-26 12:33:24 12554 0 NULL
455 465 POF-1455 INVF-1455 12555 12554 2 1 100 15900.0 0.0 318.0 1212.71 1212.71 0.0 15582.0 INR 0.0 2.5 0.0 4 12555 2025-12-26 12:42:38 0 NULL 1 2025-12-26 12:42:49 12554 0 NULL
456 466 POF-1456 INVF-1456 12542 12554 2 1 53 2544.0 0.0 50.88 0.0 0.0 121.14 2493.12 INR 0.0 0.32 0.0 4 12542 2025-12-26 13:42:23 0 NULL 1 2025-12-26 13:42:53 12554 0 NULL
457 467 POF-1457 INVF-1457 12555 12554 2 1 300 14400.0 0.0 288.0 342.86 342.86 0.0 14112.0 INR 0.0 1.8 0.0 4 12555 2025-12-26 15:16:48 0 NULL 1 2025-12-26 15:17:08 12554 0 NULL
458 468 POF-1458 INVF-1458 12555 12554 2 1 10 12000.0 0.0 240.0 285.71 285.71 0.0 11760.0 INR 0.0 2.5 0.0 4 12555 2025-12-26 15:40:10 0 NULL 1 2025-12-26 15:40:23 12554 0 NULL
459 469 POF-1459 INVF-1459 12555 12554 2 1 50 15200.0 0.0 304.0 0.0 0.0 0.0 14896.0 INR 0.0 2.5 0.0 4 12555 2025-12-26 15:55:05 0 NULL 1 2025-12-26 15:56:46 12554 0 NULL
460 470 POF-1460 INVF-1460 12554 12516 2 1 50 15200.0 0.0 760.0 0.0 0.0 0.0 14440.0 INR 0.0 2.5 0.0 4 12554 2025-12-26 15:55:39 0 NULL 1 2025-12-26 15:56:32 12516 0 NULL
461 471 POF-1461 INVF-1461 12516 1 2 1 50 15200.0 0.0 1216.0 0.0 0.0 0.0 13984.0 INR 0.0 2.5 0.0 4 12516 2025-12-26 15:56:11 0 NULL 1 2025-12-26 15:56:20 1 0 NULL
462 472 POF-1462 INVF-1462 12554 12516 2 1 20 11180.0 0.0 559.0 266.19 266.19 0.0 10621.0 INR 0.0 2.2 0.0 4 12554 2025-12-26 15:58:24 0 NULL 1 2025-12-26 16:00:55 12516 0 NULL
463 473 POF-1463 INVF-1463 12516 1 2 1 50 27950.0 0.0 2236.0 665.48 665.48 0.0 25714.0 INR 0.0 5.5 0.0 4 12516 2025-12-26 16:00:38 0 NULL 1 2025-12-26 16:00:46 1 0 NULL
464 474 POF-1464 INVF-1464 12555 12554 2 1 30 16770.0 0.0 335.4 399.29 399.29 0.0 16434.6 INR 0.0 3.3 0.0 4 12555 2025-12-26 16:01:33 0 NULL 1 2025-12-26 16:04:45 12554 0 NULL
465 475 POF-1465 INVF-1465 12554 12516 2 1 30 16770.0 0.0 838.5 399.29 399.29 0.0 15931.5 INR 0.0 3.3 0.0 4 12554 2025-12-26 16:02:44 0 NULL 1 2025-12-26 16:04:33 12516 0 NULL
466 476 POF-1466 INVF-1466 12551 12516 2 1 3 23940.0 0.0 1197.0 348.64 348.64 0.0 22743.0 INR 0.0 6.0 0.0 4 12551 2025-12-26 17:15:52 0 NULL 1 2025-12-26 17:16:08 12516 0 NULL
467 477 POF-1467 INVF-1467 12555 12554 2 1 10 3190.0 0.0 63.8 75.95 75.95 0.0 3126.2 INR 0.0 0.5 0.0 4 12555 2025-12-26 18:10:18 0 NULL 1 2025-12-26 18:10:30 12554 0 NULL
468 478 POF-1468 INVF-1468 13438 12554 2 1 1 559.0 0.0 11.18 0.0 0.0 85.27 547.82 INR 0.0 0.11 0.0 4 13438 2025-12-26 19:17:59 0 NULL 1 2025-12-26 19:33:53 12554 0 NULL
469 479 POF-1469 INVF-1469 13438 12554 2 1 1 260.0 0.0 5.2 0.0 0.0 39.66 254.8 INR 0.0 0.02 0.0 4 13438 2025-12-26 19:18:39 0 NULL 1 2025-12-26 19:39:37 12554 0 NULL
470 480 POF-1470 INVF-1470 12554 12516 2 1 1 260.0 0.0 13.0 19.83 19.83 0.0 247.0 INR 0.0 0.02 0.0 4 12554 2025-12-26 19:34:29 0 NULL 1 2025-12-26 19:35:04 12516 0 NULL
471 481 POF-1471 INVF-1471 13438 12554 2 1 2 318.0 0.0 6.36 0.0 0.0 15.14 311.64 INR 0.0 0.03 0.0 4 13438 2025-12-26 19:41:37 0 NULL 1 2025-12-26 19:49:59 12554 0 NULL
472 482 POF-1472 INVF-1472 13438 12554 2 1 1 720.0 0.0 14.4 0.0 0.0 34.29 705.6 INR 0.0 0.15 0.0 4 13438 2025-12-26 19:42:11 0 NULL 1 2025-12-26 19:42:36 12554 0 NULL
473 483 POF-1473 INVF-1473 12554 12516 2 1 30 4770.0 0.0 238.5 113.57 113.57 0.0 4531.5 INR 0.0 0.45 0.0 4 12554 2025-12-26 19:43:02 0 NULL 1 2025-12-26 19:43:25 12516 0 NULL
474 484 POF-1474 INVF-1474 13438 12554 2 1 2 558.0 0.0 11.16 0.0 0.0 26.57 546.84 INR 0.0 0.1 0.0 4 13438 2025-12-26 19:48:42 0 NULL 1 2025-12-26 20:02:53 12554 0 NULL
475 485 POF-1475 INVF-1475 12554 12516 2 1 20 4830.0 0.0 241.5 115.0 115.0 0.0 4588.5 INR 0.0 0.4 0.0 4 12554 2025-12-26 19:51:05 0 NULL 1 2025-12-26 19:51:23 12516 0 NULL
476 486 POF-1476 INVF-1476 13438 12554 2 1 2 408.0 0.0 8.16 0.0 0.0 19.43 399.84 INR 0.0 0.08 0.0 4 13438 2025-12-26 19:56:40 0 NULL 1 2025-12-26 20:02:59 12554 0 NULL
477 487 POF-1477 INVF-1477 13438 12554 2 1 2 558.0 0.0 11.16 0.0 0.0 26.57 546.84 INR 0.0 0.1 0.0 4 13438 2025-12-26 19:57:05 0 NULL 1 2025-12-26 20:02:59 12554 0 NULL
478 488 POF-1478 INVF-1478 13438 12554 2 1 1 304.0 0.0 6.08 0.0 0.0 0.0 297.92 INR 0.0 0.05 0.0 4 13438 2025-12-26 20:18:03 0 NULL 1 2025-12-26 20:31:21 12554 0 NULL
479 489 POF-1479 INVF-1479 13438 12554 2 1 1 260.0 0.0 5.2 0.0 0.0 39.66 254.8 INR 0.0 0.02 0.0 4 13438 2025-12-26 20:21:34 0 NULL 1 2025-12-26 20:45:31 12554 0 NULL
480 490 POF-1480 INVF-1480 12554 12516 2 1 10 2600.0 0.0 130.0 198.31 198.31 0.0 2470.0 INR 0.0 0.21 0.0 4 12554 2025-12-26 20:31:42 0 NULL 1 2025-12-26 20:32:10 12516 0 NULL
481 491 POF-1481 INVF-1481 12554 12516 2 1 40 9260.0 0.0 463.0 706.27 706.27 0.0 8797.0 INR 0.0 0.24 0.0 4 12554 2025-12-26 20:46:03 0 NULL 1 2025-12-26 20:48:37 12516 0 NULL
482 492 POF-1482 INVF-1482 12516 1 2 1 51 15359.0 0.0 1228.72 1171.45 1171.45 0.0 14130.28 INR 0.0 0.01 0.0 4 12516 2025-12-26 20:46:56 0 NULL 1 2025-12-26 20:47:39 1 0 NULL
483 493 POF-1483 INVF-1483 12516 1 2 1 50 7950.0 0.0 636.0 606.36 606.36 0.0 7314.0 INR 0.0 0.6 0.0 4 12516 2025-12-26 20:47:16 0 NULL 1 2025-12-26 20:48:24 1 0 NULL
484 494 POF-1484 INVF-1484 12516 1 2 1 100 55900.0 0.0 4472.0 2307.8 2307.8 0.0 51428.0 INR 0.0 11.0 0.0 4 12516 2025-12-26 20:51:57 0 NULL 1 2025-12-26 20:52:13 1 0 NULL
485 495 POF-1485 INVF-1485 12554 12516 2 1 50 27950.0 0.0 1397.5 1153.9 1153.9 0.0 26552.5 INR 0.0 5.5 0.0 4 12554 2025-12-26 20:52:46 0 NULL 1 2025-12-26 20:53:22 12516 0 NULL
486 496 POF-1486 INVF-1486 12554 12516 2 1 10 5590.0 0.0 279.5 230.78 230.78 0.0 5310.5 INR 0.0 1.1 0.0 4 12554 2025-12-26 21:22:15 0 NULL 1 2025-12-26 21:22:45 12516 0 NULL
487 497 POF-1487 INVF-1487 12555 12554 2 1 10 18500.0 0.0 370.0 440.48 440.48 0.0 18130.0 INR 0.0 3.5 0.0 4 12555 2025-12-26 21:35:30 0 NULL 1 2025-12-26 21:35:52 12554 0 NULL
488 498 POF-1488 INVF-1488 12555 12554 2 1 100 8000.0 0.0 160.0 190.48 190.48 0.0 7840.0 INR 0.0 0.9 0.0 4 12555 2025-12-26 21:38:56 0 NULL 1 2025-12-26 21:39:18 12554 0 NULL
489 499 POF-1489 INVF-1489 12517 12516 2 1 1 559.0 0.0 27.95 0.0 0.0 46.16 531.05 INR 0.0 0.11 0.0 4 12517 2025-12-26 21:57:14 0 NULL 2 2025-12-26 21:58:39 12516 0 NULL
490 500 POF-1490 INVF-1490 13438 12554 2 1 160 10880.0 0.0 217.6 0.0 0.0 518.1 10662.4 INR 0.0 0.36 0.0 4 13438 2025-12-26 22:14:06 0 NULL 1 2025-12-26 22:16:47 12554 0 NULL
491 501 POF-1491 INVF-1491 12555 12554 2 1 30 4770.0 0.0 95.4 363.81 363.81 0.0 4674.6 INR 0.0 0.36 0.0 4 12555 2025-12-26 22:30:02 0 NULL 1 2025-12-26 22:30:34 12554 0 NULL
492 502 POF-1492 INVF-1492 12555 12554 2 1 30 4770.0 0.0 95.4 363.81 363.81 0.0 4674.6 INR 0.0 0.33 0.0 4 12555 2025-12-26 22:41:03 0 NULL 1 2025-12-26 22:41:25 12554 0 NULL
493 503 POF-1493 INVF-1493 12542 12554 2 1 6 7516.0 0.0 150.32 0.0 0.0 475.21 7365.68 INR 0.0 0.8 0.0 4 12542 2025-12-26 22:59:07 0 NULL 1 2025-12-26 22:59:32 12554 0 NULL
494 504 POF-1494 INVF-1494 12555 12554 2 1 10 79800.0 0.0 1596.0 1162.14 1162.14 0.0 78204.0 INR 0.0 20.0 0.0 4 12555 2025-12-26 23:11:55 0 NULL 1 2025-12-26 23:12:17 12554 0 NULL
495 505 POF-1495 INVF-1495 12554 12516 2 1 250 50300.0 0.0 2515.0 1197.62 1197.62 0.0 47785.0 INR 0.0 5.0 0.0 4 12554 2025-12-27 08:43:06 0 NULL 1 2025-12-27 08:47:03 12516 0 NULL
496 506 POF-1496 INVF-1496 12516 1 2 1 50 37500.0 0.0 3000.0 892.86 892.86 0.0 34500.0 INR 0.0 5.0 0.0 4 12516 2025-12-27 08:44:34 0 NULL 1 2025-12-27 08:46:39 1 0 NULL
497 507 POF-1497 INVF-1497 12555 12554 2 1 210 20300.0 0.0 406.0 483.33 483.33 0.0 19894.0 INR 0.0 1.0 0.0 4 12555 2025-12-27 09:15:36 0 NULL 1 2025-12-27 09:15:57 12554 0 NULL
498 508 POF-1498 INVF-1498 12542 12554 2 1 375 29245.0 0.0 584.9 0.0 0.0 2531.04 28660.1 INR 0.0 0.22 0.0 4 12542 2025-12-27 16:47:29 0 NULL 1 2025-12-27 16:47:47 12554 0 NULL
499 509 POF-1499 INVF-1499 12554 12516 2 1 30 239400.0 0.0 11970.0 3486.41 3486.41 0.0 227430.0 INR 0.0 60.0 0.0 4 12554 2025-12-27 16:54:24 0 NULL 1 2025-12-27 16:55:45 12516 0 NULL
500 510 POF-1500 INVF-1500 12516 1 2 1 30 239400.0 0.0 19152.0 3486.41 3486.41 0.0 220248.0 INR 0.0 60.0 0.0 4 12516 2025-12-27 16:55:21 0 NULL 1 2025-12-27 16:55:31 1 0 NULL