fx_franchise_order

1,267 rows · 31 columns · page 13 / 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
601 611 POFN-1601 INVFN-1601 12555 12554 2 1 5 5750.0 0.0 109.52 136.9 136.9 0.0 5640.48 INR 0.0 1.25 0.0 4 12555 2026-01-07 16:42:40 0 NULL 1 2026-01-07 16:45:21 12554 0 NULL
602 612 POFN-1602 INVFN-1602 12554 12516 2 1 30 36000.0 0.0 2057.14 857.14 857.14 0.0 33942.86 INR 0.0 3.75 0.0 4 12554 2026-01-07 16:44:29 0 NULL 1 2026-01-07 16:44:42 12516 0 NULL
603 613 POFN-1603 INVFN-1603 12555 12554 2 1 10 12500.0 0.0 238.1 297.62 297.62 0.0 12261.9 INR 0.0 2.5 0.0 4 12555 2026-01-07 16:45:06 0 NULL 1 2026-01-07 16:45:21 12554 0 NULL
604 614 POFN-1604 INVFN-1604 12518 12517 2 1 15 2385.0 0.0 40.42 0.0 0.0 363.81 2344.58 INR 0.0 0.38 0.0 4 12518 2026-01-07 16:46:34 0 NULL 1 2026-01-07 17:22:33 12517 0 NULL
605 615 POFN-1605 INVFN-1605 12555 12554 2 1 15 17750.0 0.0 338.1 422.62 422.62 0.0 17411.9 INR 0.0 2.5 0.0 4 12555 2026-01-07 17:17:06 0 NULL 1 2026-01-07 17:17:16 12554 0 NULL
606 616 POFN-1606 INVFN-1606 12554 12516 2 1 6 7500.0 0.0 428.57 178.57 178.57 0.0 7071.43 INR 0.0 1.5 0.0 4 12554 2026-01-07 17:17:52 0 NULL 1 2026-01-07 17:18:07 12516 0 NULL
607 617 POFN-1607 INVFN-1607 12555 12554 2 1 5 6250.0 0.0 119.05 148.81 148.81 0.0 6130.95 INR 0.0 1.25 0.0 4 12555 2026-01-07 17:19:28 0 NULL 1 2026-01-07 17:19:44 12554 0 NULL
608 618 POFN-1608 INVFN-1608 12554 12516 2 1 1 10500.0 0.0 300.0 250.0 250.0 0.0 10200.0 INR 0.0 3.0 0.0 4 12554 2026-01-07 18:11:09 0 NULL 1 2026-01-07 18:11:21 12516 0 NULL
609 619 POFN-1609 INVFN-1609 12555 12554 2 1 2 10548.0 0.0 150.91 251.14 251.14 0.0 10397.09 INR 0.0 0.01 0.0 4 12555 2026-01-07 18:11:43 0 NULL 1 2026-01-07 18:11:52 12554 0 NULL
610 620 POFN-1610 INVFN-1610 12546 12517 2 1 92 28555.0 0.0 484.68 0.0 0.0 1821.11 28070.32 INR 0.0 0.11 0.0 4 12546 2026-01-07 19:23:04 0 NULL 1 2026-01-08 14:04:42 12517 0 NULL
611 621 POFN-1611 INVFN-1611 12526 12517 2 1 24 10896.0 0.0 204.99 323.22 323.22 0.0 10691.01 INR 0.0 0.06 0.0 4 12526 2026-01-07 20:18:12 0 NULL 1 2026-01-07 23:15:15 12517 0 NULL
612 622 POFN-1612 INVFN-1612 12539 12517 2 1 1 10500.0 0.0 150.0 250.0 250.0 0.0 10350.0 INR 0.0 3.0 0.0 4 12539 2026-01-07 21:17:25 0 NULL 1 2026-01-07 22:04:53 12517 0 NULL
613 623 POFN-1613 INVFN-1613 12517 12516 2 1 12 9900.0 0.0 565.71 0.0 0.0 471.43 9334.29 INR 0.0 1.0 0.0 4 12517 2026-01-07 22:10:31 0 NULL 1 2026-01-07 22:11:44 12516 0 NULL
614 624 POFN-1614 INVFN-1614 12516 1 2 1 9 6750.0 0.0 514.29 160.71 160.71 0.0 6235.71 INR 0.0 0.9 0.0 4 12516 2026-01-07 22:11:16 0 NULL 1 2026-01-07 22:11:32 1 0 NULL
615 625 POFN-1615 INVFN-1615 13438 12554 2 1 8 4534.0 0.0 83.23 0.0 0.0 372.28 4450.77 INR 0.0 0.22 0.0 4 13438 2026-01-07 22:12:47 0 NULL 1 2026-01-07 22:52:03 12554 0 NULL
616 626 POFN-1616 INVFN-1616 12554 12516 2 1 10 7200.0 0.0 411.43 171.43 171.43 0.0 6788.57 INR 0.0 1.5 0.0 4 12554 2026-01-07 22:41:59 0 NULL 1 2026-01-07 22:42:37 12516 0 NULL
617 627 POFN-1617 INVFN-1617 13438 12554 2 1 2 1440.0 0.0 27.43 0.0 0.0 68.57 1412.57 INR 0.0 0.3 0.0 4 13438 2026-01-07 22:44:38 0 NULL 1 2026-01-07 22:52:03 12554 0 NULL
618 628 POFN-1618 INVFN-1618 13438 12517 2 1 20 960.0 0.0 18.29 22.86 22.86 0.0 941.71 INR 0.0 0.12 0.0 4 13438 2026-01-07 23:14:20 0 NULL 1 2026-01-07 23:15:10 12517 0 NULL
619 629 POFN-1619 INVFN-1619 13438 12517 2 1 2 608.0 0.0 10.31 46.37 46.37 0.0 597.69 INR 0.0 0.1 0.0 4 13438 2026-01-08 13:02:01 0 NULL 1 2026-01-08 13:59:52 12517 0 NULL
620 630 POFN-1620 INVFN-1620 12517 12516 2 1 30 8370.0 0.0 478.29 0.0 0.0 398.57 7891.71 INR 0.0 1.5 0.0 4 12517 2026-01-08 14:03:13 0 NULL 1 2026-01-08 14:03:23 12516 0 NULL
621 631 POFN-1621 INVFN-1621 12517 12516 2 1 2 5200.0 0.0 297.14 0.0 0.0 247.62 4902.86 INR 0.0 1.0 0.0 4 12517 2026-01-08 14:04:19 0 NULL 1 2026-01-08 14:04:29 12516 0 NULL
622 632 POFN-1622 INVFN-1622 12521 12517 2 1 198 36450.0 0.0 650.38 1520.5 1520.5 0.0 35799.62 INR 0.0 0.06 0.0 4 12521 2026-01-08 17:29:46 0 NULL 1 2026-01-08 20:46:14 12517 0 NULL
623 633 POFN-1623 INVFN-1623 12523 12517 2 1 1 2000.0 0.0 38.83 29.13 29.13 0.0 1961.17 INR 0.0 0.4 0.0 4 12523 2026-01-08 19:11:01 0 NULL 1 2026-01-08 21:30:55 12517 0 NULL
624 634 POFN-1624 INVFN-1624 12517 12516 2 1 120 64630.0 0.0 3669.7 0.0 0.0 3468.36 60960.3 INR 0.0 1.0 0.0 4 12517 2026-01-08 20:41:47 0 NULL 1 2026-01-08 20:45:53 12516 0 NULL
625 635 POFN-1625 INVFN-1625 12516 1 2 1 150 101040.0 0.0 7651.4 2698.77 2698.77 0.0 93388.6 INR 0.0 3.0 0.0 4 12516 2026-01-08 20:44:03 0 NULL 1 2026-01-08 20:45:27 1 0 NULL
626 636 POFN-1626 INVFN-1626 12545 12517 2 1 21 10721.0 0.0 200.04 359.41 359.41 0.0 10520.96 INR 0.0 0.1 0.0 4 12545 2026-01-08 22:07:51 0 NULL 1 2026-01-08 22:24:10 12517 0 NULL
627 637 POFN-1627 INVFN-1627 12552 12517 2 1 24 8819.0 0.0 159.53 421.13 421.13 0.0 8659.47 INR 0.0 0.03 0.0 4 12552 2026-01-08 22:47:06 0 NULL 1 2026-01-08 22:48:03 12517 0 NULL
628 638 POFN-1628 INVFN-1628 12534 12517 2 1 183 17863.0 0.0 326.36 772.45 772.45 0.0 17536.64 INR 0.0 0.08 0.0 4 12534 2026-01-09 10:29:26 0 NULL 1 2026-01-09 11:20:03 12517 0 NULL
629 639 POFN-1629 INVFN-1629 12517 12516 2 1 390 282860.0 0.0 16123.39 0.0 0.0 14136.84 266736.61 INR 0.0 7.5 0.0 4 12517 2026-01-09 12:50:03 0 NULL 1 2026-01-09 12:54:17 12516 0 NULL
630 640 POFN-1630 INVFN-1630 12516 1 2 1 30 4770.0 0.0 323.39 363.81 363.81 0.0 4446.61 INR 0.0 0.36 0.0 4 12516 2026-01-09 12:51:17 0 NULL 1 2026-01-09 12:51:37 1 0 NULL
631 641 POFN-1631 INVFN-1631 12516 1 2 1 150 30600.0 0.0 2331.43 728.57 728.57 0.0 28268.57 INR 0.0 6.0 0.0 4 12516 2026-01-09 12:53:46 0 NULL 1 2026-01-09 12:54:01 1 0 NULL
632 642 POFN-1632 INVFN-1632 12538 12517 2 1 1 10500.0 0.0 150.0 250.0 250.0 0.0 10350.0 INR 0.0 3.0 0.0 4 12538 2026-01-09 13:07:00 0 NULL 1 2026-01-09 14:26:14 12517 0 NULL
633 643 POFN-1633 INVFN-1633 14079 12517 2 1 26 3517.0 0.0 65.82 113.06 113.06 0.0 3451.18 INR 0.0 0.11 0.0 4 14079 2026-01-09 13:57:25 0 NULL 1 2026-01-09 14:26:11 12517 0 NULL
634 644 POFN-1634 INVFN-1634 12555 12554 2 1 2 1000.0 0.0 16.95 76.27 76.27 0.0 983.05 INR 0.0 0.2 0.0 4 12555 2026-01-09 15:42:18 0 NULL 1 2026-01-09 15:42:36 12554 0 NULL
635 645 POFN-1635 INVFN-1635 12532 12554 2 1 588 44622.0 0.0 830.62 0.0 0.0 3090.78 43791.38 INR 0.0 0.26 0.0 4 12532 2026-01-09 15:54:54 0 NULL 1 2026-01-09 15:58:07 12554 0 NULL
636 646 POFN-1636 INVFN-1636 12554 12516 2 1 25 8385.0 0.0 479.14 199.64 199.64 0.0 7905.86 INR 0.0 1.0 0.0 4 12554 2026-01-09 15:57:37 0 NULL 1 2026-01-09 15:57:50 12516 0 NULL
637 647 POFN-1637 INVFN-1637 12532 12554 2 1 10 5631.0 0.0 107.26 0.0 0.0 268.14 5523.74 INR 0.0 0.99 0.0 4 12532 2026-01-09 16:43:26 0 NULL 1 2026-01-09 16:46:05 12554 0 NULL
638 648 POFN-1638 INVFN-1638 12532 12517 2 1 1 9900.0 0.0 150.0 755.08 755.08 0.0 9750.0 INR 0.0 2.0 0.0 4 12532 2026-01-09 16:49:21 0 NULL 1 2026-01-09 17:03:28 12517 0 NULL
639 649 POFN-1639 INVFN-1639 12554 12516 2 1 20 10000.0 0.0 508.47 762.71 762.71 0.0 9491.53 INR 0.0 2.0 0.0 4 12554 2026-01-09 17:05:58 0 NULL 1 2026-01-09 17:06:21 12516 0 NULL
640 650 POFN-1640 INVFN-1640 12555 12554 2 1 10 5000.0 0.0 84.75 381.36 381.36 0.0 4915.25 INR 0.0 1.0 0.0 4 12555 2026-01-09 17:06:41 0 NULL 1 2026-01-09 17:06:55 12554 0 NULL
641 651 POFN-1641 INVFN-1641 12532 12517 2 1 1 2000.0 0.0 38.83 29.13 29.13 0.0 1961.17 INR 0.0 0.4 0.0 4 12532 2026-01-09 17:11:05 0 NULL 1 2026-01-09 17:31:56 12517 0 NULL
642 652 POFN-1642 INVFN-1642 12554 12516 2 1 10 105000.0 0.0 3000.0 2500.0 2500.0 0.0 102000.0 INR 0.0 30.0 0.0 4 12554 2026-01-09 17:14:33 0 NULL 1 2026-01-09 17:15:34 12516 0 NULL
643 653 POFN-1643 INVFN-1643 12516 1 2 1 10 105000.0 0.0 4000.0 2500.0 2500.0 0.0 101000.0 INR 0.0 30.0 0.0 4 12516 2026-01-09 17:15:00 0 NULL 1 2026-01-09 17:15:22 1 0 NULL
644 654 POFN-1644 INVFN-1644 13536 12554 2 1 2 21000.0 0.0 300.0 500.0 500.0 0.0 20700.0 INR 0.0 6.0 0.0 4 13536 2026-01-09 17:15:51 0 NULL 1 2026-01-09 17:16:01 12554 0 NULL
645 655 POFN-1645 INVFN-1645 13536 12554 2 1 60 8038.0 0.0 151.01 243.65 243.65 0.0 7886.99 INR 0.0 0.11 0.0 4 13536 2026-01-09 17:17:35 0 NULL 1 2026-01-09 17:18:47 12554 0 NULL
646 656 POFN-1646 INVFN-1646 12554 12516 2 1 20 2400.0 0.0 122.03 183.05 183.05 0.0 2277.97 INR 0.0 0.22 0.0 4 12554 2026-01-09 17:18:26 0 NULL 1 2026-01-09 17:18:36 12516 0 NULL
647 657 POFN-1647 INVFN-1647 12526 12517 2 1 5 52500.0 0.0 750.0 1250.0 1250.0 0.0 51750.0 INR 0.0 15.0 0.0 4 12526 2026-01-09 17:39:29 0 NULL 1 2026-01-09 17:42:48 12517 0 NULL
648 658 POFN-1648 INVFN-1648 13438 12554 2 1 19 5696.0 0.0 102.49 0.0 0.0 571.74 5593.51 INR 0.0 0.08 0.0 4 13438 2026-01-09 18:45:20 0 NULL 1 2026-01-09 18:48:36 12554 0 NULL
649 659 POFN-1649 INVFN-1649 12554 12516 2 1 20 15000.0 0.0 857.14 357.14 357.14 0.0 14142.86 INR 0.0 2.0 0.0 4 12554 2026-01-09 19:24:22 0 NULL 1 2026-01-09 19:24:47 12516 0 NULL
650 660 POFN-1650 INVFN-1650 12520 12517 2 1 155 18155.0 0.0 339.69 585.19 585.19 0.0 17815.31 INR 0.0 0.11 0.0 4 12520 2026-01-09 19:37:06 0 NULL 1 2026-01-09 19:48:25 12517 0 NULL