fx_franchise_order

1,267 rows · 31 columns · page 11 / 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
501 511 POF-1501 INVF-1501 12542 12554 2 1 2 15960.0 0.0 319.2 0.0 0.0 464.85 15640.8 INR 0.0 4.0 0.0 4 12542 2025-12-27 16:56:02 0 NULL 1 2025-12-27 16:56:13 12554 0 NULL
502 512 POF-1502 INVF-1502 12542 12554 2 1 1 7980.0 0.0 159.6 0.0 0.0 232.43 7820.4 INR 0.0 2.0 0.0 4 12542 2025-12-27 17:04:56 0 NULL 1 2025-12-27 20:01:22 12554 0 NULL
503 513 POF-1503 INVF-1503 13438 12554 2 1 2 718.0 0.0 14.36 0.0 0.0 70.41 703.64 INR 0.0 0.01 0.0 4 13438 2025-12-27 20:00:35 0 NULL 1 2025-12-27 20:01:22 12554 0 NULL
504 514 POF-1504 INVF-1504 13438 12554 2 1 1 7980.0 0.0 159.6 0.0 0.0 232.43 7820.4 INR 0.0 2.0 0.0 4 13438 2025-12-27 20:13:25 0 NULL 1 2025-12-27 20:14:32 12554 0 NULL
505 515 POF-1505 INVF-1505 12542 12554 2 1 5 39900.0 0.0 798.0 0.0 0.0 1162.14 39102.0 INR 0.0 10.0 0.0 4 12542 2025-12-29 10:45:08 0 NULL 1 2025-12-29 11:23:09 12554 0 NULL
506 516 POF-1506 INVF-1506 12554 12516 2 1 10 79800.0 0.0 3990.0 1162.14 1162.14 0.0 75810.0 INR 0.0 20.0 0.0 4 12554 2025-12-29 10:58:37 0 NULL 1 2025-12-29 11:00:59 12516 0 NULL
507 517 POF-1507 INVF-1507 12516 1 2 1 1 7980.0 0.0 638.4 116.21 116.21 0.0 7341.6 INR 0.0 2.0 0.0 4 12516 2025-12-29 10:59:11 0 NULL 1 2025-12-29 10:59:27 1 0 NULL
508 518 POF-1508 INVF-1508 12516 1 2 1 5 39900.0 0.0 3192.0 581.07 581.07 0.0 36708.0 INR 0.0 10.0 0.0 4 12516 2025-12-29 11:00:17 0 NULL 1 2025-12-29 11:00:38 1 0 NULL
509 519 POF-1509 INVF-1509 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-29 13:03:02 0 NULL 1 2025-12-29 13:03:38 12554 0 NULL
510 520 POF-1510 INVF-1510 12554 12516 2 1 30 22500.0 0.0 1125.0 535.71 535.71 0.0 21375.0 INR 0.0 3.0 0.0 4 12554 2025-12-30 11:22:32 0 NULL 1 2025-12-30 11:28:38 12516 0 NULL
511 521 POF-1511 INVF-1511 12516 1 2 1 40 30000.0 0.0 2400.0 714.29 714.29 0.0 27600.0 INR 0.0 4.0 0.0 4 12516 2025-12-30 11:24:31 0 NULL 1 2025-12-30 11:24:41 1 0 NULL
512 522 POF-1512 INVF-1512 12555 12554 2 1 30 22500.0 0.0 450.0 535.71 535.71 0.0 22050.0 INR 0.0 3.0 0.0 4 12555 2025-12-30 11:31:11 0 NULL 1 2025-12-30 11:31:29 12554 0 NULL
513 523 POF-1513 INVF-1513 12555 12554 2 1 10 7200.0 0.0 144.0 171.43 171.43 0.0 7056.0 INR 0.0 1.5 0.0 4 12555 2025-12-30 16:58:51 0 NULL 1 2025-12-30 16:59:04 12554 0 NULL
514 524 POF-1514 INVF-1514 12555 12554 2 1 50 6000.0 0.0 120.0 457.63 457.63 0.0 5880.0 INR 0.0 0.55 0.0 4 12555 2025-12-30 18:37:35 0 NULL 1 2025-12-30 18:37:58 12554 0 NULL
515 525 POF-1515 INVF-1515 12555 12554 2 1 500 24000.0 0.0 480.0 571.43 571.43 0.0 23520.0 INR 0.0 3.0 0.0 4 12555 2025-12-30 22:52:30 0 NULL 1 2025-12-30 22:55:46 12554 0 NULL
516 526 POF-1516 INVF-1516 12554 12516 2 1 1000 48000.0 0.0 2400.0 1142.86 1142.86 0.0 45600.0 INR 0.0 6.0 0.0 4 12554 2025-12-30 22:53:18 0 NULL 1 2025-12-30 22:55:23 12516 0 NULL
517 527 POF-1517 INVF-1517 12516 1 2 1 1500 72000.0 0.0 5760.0 1714.29 1714.29 0.0 66240.0 INR 0.0 9.0 0.0 4 12516 2025-12-30 22:54:07 0 NULL 1 2025-12-30 22:54:59 1 0 NULL
518 528 POF-1518 INVF-1518 12542 12554 2 1 2 15960.0 0.0 319.2 0.0 0.0 464.85 15640.8 INR 0.0 4.0 0.0 4 12542 2025-12-31 11:26:11 0 NULL 1 2025-12-31 11:36:59 12554 0 NULL
519 529 POF-1519 INVF-1519 12555 12554 2 1 15 119700.0 0.0 2394.0 1743.2 1743.2 0.0 117306.0 INR 0.0 30.0 0.0 4 12555 2025-12-31 12:02:14 0 NULL 1 2025-12-31 12:02:32 12554 0 NULL
520 530 POF-1520 INVF-1520 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 2026-01-01 13:22:12 0 NULL 1 2026-01-01 13:22:56 12554 0 NULL
521 531 POF-1521 INVF-1521 12555 12554 2 1 10 7500.0 0.0 150.0 178.57 178.57 0.0 7350.0 INR 0.0 1.0 0.0 4 12555 2026-01-01 13:30:52 0 NULL 1 2026-01-01 13:31:22 12554 0 NULL
522 532 POF-1522 INVF-1522 12542 12554 2 1 10 79800.0 0.0 1596.0 0.0 0.0 2324.27 78204.0 INR 0.0 20.0 0.0 4 12542 2026-01-01 15:28:02 0 NULL 1 2026-01-01 15:47:04 12554 0 NULL
523 533 POF-1523 INVF-1523 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 2026-01-01 15:45:33 0 NULL 1 2026-01-01 15:46:43 12516 0 NULL
524 534 POF-1524 INVF-1524 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 2026-01-01 15:46:16 0 NULL 1 2026-01-01 15:46:30 1 0 NULL
525 535 POF-1525 INVF-1525 12555 12554 2 1 30 309590.0 0.0 6191.8 4508.59 4508.59 0.0 303398.2 INR 0.0 30.0 0.0 4 12555 2026-01-01 16:26:55 0 NULL 1 2026-01-01 16:28:43 12554 0 NULL
526 536 POF-1526 INVF-1526 12554 12516 2 1 10 79800.0 0.0 3990.0 1162.14 1162.14 0.0 75810.0 INR 0.0 20.0 0.0 4 12554 2026-01-01 16:27:51 0 NULL 1 2026-01-01 16:28:18 12516 0 NULL
527 537 POF-1527 INVF-1527 12555 12554 2 1 5 39900.0 0.0 798.0 581.07 581.07 0.0 39102.0 INR 0.0 10.0 0.0 4 12555 2026-01-01 22:47:09 0 NULL 2 2026-01-01 22:50:33 12554 0 NULL
528 538 POF-1528 INVF-1528 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 2026-01-01 22:48:02 0 NULL 1 2026-01-02 11:18:35 12516 0 NULL
529 539 POF-1529 INVF-1529 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 2026-01-01 22:48:42 0 NULL 1 2026-01-02 11:18:27 1 0 NULL
530 540 POF-1530 INVF-1530 12555 12554 2 1 3 23940.0 0.0 478.8 348.64 348.64 0.0 23461.2 INR 0.0 6.0 0.0 4 12555 2026-01-01 22:50:54 0 NULL 1 2026-01-01 22:51:12 12554 0 NULL
531 541 POF-1531 INVF-1531 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 2026-01-02 11:17:13 0 NULL 2 2026-01-02 11:18:37 12516 0 NULL
532 542 POF-1532 INVF-1532 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 2026-01-02 11:20:49 0 NULL 1 2026-01-02 11:21:06 12554 0 NULL
533 543 POF-1533 INVF-1533 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 2026-01-02 16:48:57 0 NULL 1 2026-01-02 16:49:07 1 0 NULL
534 544 POF-1534 INVF-1534 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 2026-01-02 16:49:26 0 NULL 1 2026-01-02 16:49:40 12516 0 NULL
535 545 POF-1535 INVF-1535 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 2026-01-02 16:50:22 0 NULL 1 2026-01-02 16:50:34 12554 0 NULL
536 546 POF-1536 INVF-1536 13438 12554 2 1 3 612.0 0.0 12.24 0.0 0.0 29.14 599.76 INR 0.0 0.12 0.0 4 13438 2026-01-02 17:08:48 0 NULL 1 2026-01-02 17:15:02 12554 0 NULL
537 547 POF-1537 INVF-1537 12554 12516 2 1 10 7500.0 0.0 375.0 178.57 178.57 0.0 7125.0 INR 0.0 1.0 0.0 4 12554 2026-01-02 17:23:29 0 NULL 1 2026-01-02 17:23:41 12516 0 NULL
538 548 POF-1538 INVF-1538 13438 12554 2 1 2 1500.0 0.0 30.0 0.0 0.0 71.43 1470.0 INR 0.0 0.2 0.0 4 13438 2026-01-02 17:27:48 0 NULL 1 2026-01-02 17:29:09 12554 0 NULL
539 549 POF-1539 INVF-1539 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 2026-01-02 17:42:07 0 NULL 1 2026-01-02 17:42:17 12554 0 NULL
540 550 POF-1540 INVF-1540 12554 12516 2 1 10 1590.0 0.0 79.5 121.27 121.27 0.0 1510.5 INR 0.0 0.12 0.0 4 12554 2026-01-02 17:52:14 0 NULL 1 2026-01-02 17:53:04 12516 0 NULL
541 551 POF-1541 INVF-1541 12554 12516 2 1 10 12500.0 0.0 625.0 297.62 297.62 0.0 11875.0 INR 0.0 2.5 0.0 4 12554 2026-01-02 18:01:14 0 NULL 1 2026-01-02 18:01:25 12516 0 NULL
542 552 POF-1542 INVF-1542 12527 12554 2 1 454 105189.0 0.0 2103.78 0.0 0.0 4599.54 103085.22 INR 0.0 0.55 0.0 4 12527 2026-01-02 18:05:33 0 NULL 1 2026-01-02 18:34:05 12554 0 NULL
543 553 POF-1543 INVF-1543 12554 12516 2 1 30 17480.0 0.0 874.0 416.19 416.19 0.0 16606.0 INR 0.0 2.5 0.0 4 12554 2026-01-02 18:07:44 0 NULL 1 2026-01-02 18:07:55 12516 0 NULL
544 554 POF-1544 INVF-1544 12527 12554 2 1 13 8182.0 0.0 163.64 0.0 0.0 389.62 8018.36 INR 0.0 1.25 0.0 4 12527 2026-01-02 18:11:12 0 NULL 1 2026-01-02 18:20:33 12554 0 NULL
545 555 POF-1545 INVF-1545 12554 12516 2 1 1000 64000.0 0.0 3200.0 1523.81 1523.81 0.0 60800.0 INR 0.0 3.0 0.0 4 12554 2026-01-02 18:21:33 0 NULL 1 2026-01-02 18:21:46 12516 0 NULL
546 556 POF-1546 INVF-1546 12554 12516 2 1 110 271410.0 0.0 13570.5 5677.28 5677.28 0.0 257839.5 INR 0.0 2.2 0.0 4 12554 2026-01-02 18:24:32 0 NULL 1 2026-01-02 18:33:45 12516 0 NULL
547 557 POF-1547 INVF-1547 12516 1 2 1 20 159600.0 0.0 12768.0 2324.27 2324.27 0.0 146832.0 INR 0.0 40.0 0.0 4 12516 2026-01-02 18:25:20 0 NULL 1 2026-01-02 18:26:09 1 0 NULL
548 558 POF-1548 INVF-1548 12516 1 2 1 5 74995.0 0.0 5999.6 1092.16 1092.16 0.0 68995.4 INR 0.0 15.0 0.0 4 12516 2026-01-02 18:33:21 0 NULL 1 2026-01-02 18:33:29 1 0 NULL
549 559 POF-1549 INVF-1549 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 2026-01-02 18:51:12 0 NULL 1 2026-01-02 18:51:22 12554 0 NULL
550 560 POF-1550 INVF-1550 13438 12554 2 1 5 32479.0 0.0 649.58 0.0 0.0 1014.98 31829.42 INR 0.0 0.11 0.0 4 13438 2026-01-02 19:04:52 0 NULL 1 2026-01-02 19:15:27 12554 0 NULL