fx_franchise_order

1,057 rows · 31 columns · page 12 / 22

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
551 771 POFN-1761 INVFN-1761 12529 12517 2 1 1 304.0 0.0 5.15 23.19 23.19 0.0 298.85 INR 0.0 0.05 0.0 4 12529 2026-01-16 21:33:03 0 NULL 1 2026-01-16 21:38:04 12517 0 NULL
552 772 POFN-1762 INVFN-1762 12517 12516 2 1 3 31500.0 0.0 900.0 0.0 0.0 1500.0 30600.0 INR 0.0 9.0 0.0 4 12517 2026-01-16 21:38:49 0 NULL 1 2026-01-16 21:39:05 12516 0 NULL
553 773 POFN-1763 INVFN-1763 12517 12516 2 1 1 10500.0 0.0 300.0 0.0 0.0 500.0 10200.0 INR 0.0 3.0 0.0 4 12517 2026-01-16 21:40:20 0 NULL 1 2026-01-16 21:40:57 12516 0 NULL
554 774 POFN-1764 INVFN-1764 13438 12517 2 1 5 795.0 0.0 15.14 18.93 18.93 0.0 779.86 INR 0.0 0.08 0.0 4 13438 2026-01-16 21:45:16 0 NULL 1 2026-01-16 21:47:42 12517 0 NULL
555 775 POFN-1765 INVFN-1765 13438 12517 2 1 20 1600.0 0.0 30.48 38.1 38.1 0.0 1569.52 INR 0.0 0.18 0.0 4 13438 2026-01-16 21:46:46 0 NULL 1 2026-01-16 21:47:42 12517 0 NULL
556 776 POFN-1766 INVFN-1766 12546 12517 2 1 7 2669.0 0.0 50.79 64.65 64.65 0.0 2618.21 INR 0.0 0.15 0.0 4 12546 2026-01-16 22:27:40 0 NULL 1 2026-01-16 23:00:06 12517 0 NULL
557 777 POFN-1767 INVFN-1767 12546 12517 2 1 84 4032.0 0.0 76.8 96.0 96.0 0.0 3955.2 INR 0.0 0.5 0.0 4 12546 2026-01-16 22:42:08 0 NULL 1 2026-01-16 23:00:06 12517 0 NULL
558 778 POFN-1768 INVFN-1768 12516 1 2 1 6 63000.0 0.0 2400.0 1500.0 1500.0 0.0 60600.0 INR 0.0 18.0 0.0 4 12516 2026-01-16 23:00:58 0 NULL 1 2026-01-16 23:01:16 1 0 NULL
559 779 POFN-1769 INVFN-1769 12517 12516 2 1 9 55000.0 0.0 1942.86 0.0 0.0 2619.05 53057.14 INR 0.0 12.0 0.0 4 12517 2026-01-16 23:02:35 0 NULL 1 2026-01-16 23:03:04 12516 0 NULL
560 780 POFN-1770 INVFN-1770 13438 12517 2 1 1 2600.0 0.0 49.52 61.9 61.9 0.0 2550.48 INR 0.0 0.5 0.0 4 13438 2026-01-16 23:08:15 0 NULL 1 2026-01-16 23:09:21 12517 0 NULL
561 781 POFN-1771 INVFN-1771 12554 12516 2 1 2 21000.0 0.0 600.0 500.0 500.0 0.0 20400.0 INR 0.0 6.0 0.0 4 12554 2026-01-16 23:10:15 0 NULL 1 2026-01-16 23:10:38 12516 0 NULL
562 782 POFN-1772 INVFN-1772 13536 12554 2 1 14 1120.0 0.0 21.62 19.43 19.43 0.0 1098.38 INR 0.0 0.05 0.0 4 13536 2026-01-16 23:24:06 0 NULL 1 2026-01-16 23:24:28 12554 0 NULL
563 783 POFN-1773 INVFN-1773 13536 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 13536 2026-01-16 23:26:14 0 NULL 1 2026-01-16 23:26:46 12554 0 NULL
564 784 POFN-1774 INVFN-1774 13536 12554 2 1 2 408.0 0.0 7.77 9.71 9.71 0.0 400.23 INR 0.0 0.08 0.0 4 13536 2026-01-16 23:30:01 0 NULL 1 2026-01-16 23:31:00 12554 0 NULL
565 785 POFN-1775 INVFN-1775 12516 1 2 1 50 130000.0 0.0 9904.76 3095.24 3095.24 0.0 120095.24 INR 0.0 25.0 0.0 4 12516 2026-01-19 12:28:56 0 NULL 1 2026-01-19 12:30:59 1 0 NULL
566 786 POFN-1776 INVFN-1776 12516 1 2 1 30 36000.0 0.0 2742.86 857.14 857.14 0.0 33257.14 INR 0.0 7.5 0.0 4 12516 2026-01-19 12:31:58 0 NULL 1 2026-01-19 12:32:10 1 0 NULL
567 787 POFN-1777 INVFN-1777 12517 12516 2 1 60 85785.0 0.0 4902.0 0.0 0.0 4085.0 80883.0 INR 0.0 2.25 0.0 4 12517 2026-01-19 12:38:48 0 NULL 1 2026-01-19 12:38:59 12516 0 NULL
568 788 POFN-1778 INVFN-1778 12516 1 2 1 20 5200.0 0.0 352.54 396.61 396.61 0.0 4847.46 INR 0.0 0.42 0.0 4 12516 2026-01-19 14:51:47 0 NULL 1 2026-01-19 14:53:34 1 0 NULL
569 789 POFN-1779 INVFN-1779 12517 12516 2 1 15 3900.0 0.0 198.31 0.0 0.0 594.92 3701.69 INR 0.0 0.32 0.0 4 12517 2026-01-19 14:54:13 0 NULL 1 2026-01-19 14:54:29 12516 0 NULL
570 790 POFN-1780 INVFN-1780 12529 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 12529 2026-01-19 14:57:39 0 NULL 1 2026-01-19 15:06:45 12517 0 NULL
571 791 POFN-1781 INVFN-1781 12529 12517 2 1 3 622.0 0.0 10.54 47.44 47.44 0.0 611.46 INR 0.0 0.05 0.0 4 12529 2026-01-19 15:00:04 0 NULL 1 2026-01-19 15:06:45 12517 0 NULL
572 792 POFN-1782 INVFN-1782 12528 12517 2 1 143 17988.0 0.0 331.51 706.37 706.37 0.0 17656.49 INR 0.0 0.08 0.0 4 12528 2026-01-19 15:15:09 0 NULL 1 2026-01-19 16:13:52 12517 0 NULL
573 793 POFN-1783 INVFN-1783 12543 12517 2 1 3 11058.0 0.0 160.63 263.29 263.29 0.0 10897.37 INR 0.0 0.1 0.0 4 12543 2026-01-19 19:13:18 0 NULL 1 2026-01-19 19:32:27 12517 0 NULL
574 794 POFN-1784 INVFN-1784 12549 12517 2 1 24 10141.0 0.0 185.3 437.92 437.92 0.0 9955.7 INR 0.0 0.04 0.0 4 12549 2026-01-19 19:58:07 0 NULL 1 2026-01-19 20:00:52 12517 0 NULL
575 795 POFN-1785 INVFN-1785 13536 12554 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 13536 2026-01-20 13:18:44 0 NULL 1 2026-01-20 13:19:01 12554 0 NULL
576 796 POFN-1786 INVFN-1786 12855 12551 2 1 1 7980.0 0.0 154.95 116.21 116.21 0.0 7825.05 INR 0.0 2.0 0.0 4 12855 2026-01-20 13:38:02 0 NULL 1 2026-01-20 13:39:33 12551 0 NULL
577 797 POFN-1787 INVFN-1787 12551 12516 2 1 5 9192.0 0.0 534.11 145.07 145.07 0.0 8657.89 INR 0.0 0.12 0.0 4 12551 2026-01-20 13:56:00 0 NULL 2 2026-04-18 16:16:51 12516 0 NULL
578 798 POFN-1788 INVFN-1788 12551 12516 2 1 6 10791.0 0.0 625.48 183.14 183.14 0.0 10165.52 INR 0.0 0.12 0.0 4 12551 2026-01-20 14:20:30 0 NULL 2 2026-04-18 16:16:51 12516 0 NULL
579 799 POFN-1789 INVFN-1789 12855 12551 2 1 4 3606.0 0.0 68.69 85.86 85.86 0.0 3537.31 INR 0.0 0.08 0.0 4 12855 2026-01-20 17:05:17 0 NULL 1 2026-01-20 18:33:00 12551 0 NULL
580 800 POFN-1790 INVFN-1790 12529 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 12529 2026-01-20 17:52:52 0 NULL 1 2026-01-21 13:44:30 12517 0 NULL
581 801 POFN-1791 INVFN-1791 12517 12516 2 1 10 20000.0 0.0 1165.05 0.0 0.0 582.52 18834.95 INR 0.0 4.0 0.0 4 12517 2026-01-21 15:02:00 0 NULL 1 2026-01-21 15:02:17 12516 0 NULL
582 802 POFN-1792 INVFN-1792 14079 12517 2 1 42 3931.0 0.0 71.85 169.19 169.19 0.0 3859.15 INR 0.0 0.01 0.0 4 14079 2026-01-21 22:59:50 0 NULL 1 2026-01-22 11:34:48 12517 0 NULL
583 803 POFN-1793 INVFN-1793 12855 12551 2 1 1 14999.0 0.0 150.0 218.43 218.43 0.0 14849.0 INR 0.0 3.0 0.0 4 12855 2026-01-23 13:25:41 0 NULL 1 2026-01-23 13:28:26 12551 0 NULL
584 804 POFN-1794 INVFN-1794 12541 12517 2 1 72 9568.0 0.0 169.65 542.68 542.68 0.0 9398.35 INR 0.0 0.01 0.0 4 12541 2026-01-23 16:20:15 0 NULL 1 2026-01-23 16:38:31 12517 0 NULL
585 805 POFN-1795 INVFN-1795 12541 12517 2 1 5 782.0 0.0 14.52 28.06 28.06 0.0 767.48 INR 0.0 0.05 0.0 4 12541 2026-01-23 16:22:51 0 NULL 1 2026-01-23 16:38:31 12517 0 NULL
586 806 POFN-1796 INVFN-1796 12546 12517 2 1 84 9234.0 0.0 172.64 300.92 300.92 0.0 9061.36 INR 0.0 0.11 0.0 4 12546 2026-01-23 16:33:47 0 NULL 1 2026-01-23 16:41:55 12517 0 NULL
587 807 POFN-1797 INVFN-1797 12517 12516 2 1 10 1590.0 0.0 90.86 0.0 0.0 75.71 1499.14 INR 0.0 0.15 0.0 4 12517 2026-01-23 16:41:23 0 NULL 1 2026-01-23 16:41:35 12516 0 NULL
588 808 POFN-1798 INVFN-1798 14079 12517 2 1 15 4626.0 0.0 86.77 143.67 143.67 0.0 4539.23 INR 0.0 0.12 0.0 4 14079 2026-01-23 16:50:06 0 NULL 1 2026-01-23 16:50:48 12517 0 NULL
589 809 POFN-1799 INVFN-1799 14569 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 14569 2026-01-23 17:29:26 0 NULL 1 2026-01-23 17:33:55 12517 0 NULL
590 810 POFN-1800 INVFN-1800 13438 12517 2 1 37 5274.0 0.0 100.46 125.57 125.57 0.0 5173.54 INR 0.0 0.4 0.0 4 13438 2026-01-23 19:05:41 0 NULL 1 2026-01-23 19:29:14 12517 0 NULL
591 811 POFN-1801 INVFN-1801 13438 12517 2 1 1 600.0 0.0 11.43 14.29 14.29 0.0 588.57 INR 0.0 0.1 0.0 4 13438 2026-01-23 19:40:26 0 NULL 1 2026-01-23 19:41:41 12517 0 NULL
592 812 POFN-1802 INVFN-1802 13438 12517 2 1 25 2480.0 0.0 48.69 22.86 22.86 0.0 2431.31 INR 0.0 0.25 0.0 4 13438 2026-01-23 20:08:26 0 NULL 1 2026-01-23 20:09:14 12517 0 NULL
593 813 POFN-1803 INVFN-1803 14569 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 14569 2026-01-23 20:08:45 0 NULL 1 2026-01-23 20:09:14 12517 0 NULL
594 814 POFN-1804 INVFN-1804 12521 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 12521 2026-01-23 21:52:46 0 NULL 1 2026-01-23 21:59:00 12517 0 NULL
595 815 POFN-1805 INVFN-1805 12546 12517 2 1 37 4390.0 0.0 82.36 136.0 136.0 0.0 4307.64 INR 0.0 0.06 0.0 4 12546 2026-01-23 22:38:03 0 NULL 1 2026-01-23 22:41:58 12517 0 NULL
596 816 POFN-1806 INVFN-1806 12527 12517 2 1 9 5325.0 0.0 99.62 172.06 172.06 0.0 5225.38 INR 0.0 0.11 0.0 4 12527 2026-01-24 16:56:15 0 NULL 1 2026-01-26 10:17:50 12517 0 NULL
597 817 POFN-1807 INVFN-1807 12527 12517 2 1 9 5805.0 0.0 108.76 183.49 183.49 0.0 5696.24 INR 0.0 0.11 0.0 4 12527 2026-01-24 17:03:00 0 NULL 1 2026-01-25 11:56:13 12517 0 NULL
598 818 POFN-1808 INVFN-1808 12517 12516 2 1 1990 955400.0 0.0 45980.3 0.0 0.0 87366.79 909419.7 INR 0.0 45.0 0.0 4 12517 2026-01-25 13:47:25 0 NULL 1 2026-01-25 15:06:12 12516 0 NULL
599 819 POFN-1809 INVFN-1809 12517 12516 2 1 1174 1047256.0 0.0 59520.52 0.0 0.0 55247.28 987735.48 INR 0.0 18.0 0.0 4 12517 2026-01-25 14:01:40 0 NULL 1 2026-01-25 15:20:30 12516 0 NULL
600 820 POFN-1810 INVFN-1810 12542 12517 2 1 200 9600.0 0.0 182.86 228.57 228.57 0.0 9417.14 INR 0.0 1.2 0.0 4 12542 2026-01-25 14:05:04 0 NULL 1 2026-01-25 14:32:01 12517 0 NULL