fx_franchise_order

1,057 rows · 31 columns · page 11 / 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
501 721 POFN-1711 INVFN-1711 12516 1 2 1 100 125000.0 0.0 9523.81 2976.19 2976.19 0.0 115476.19 INR 0.0 25.0 0.0 4 12516 2026-01-14 11:59:11 0 NULL 1 2026-01-14 11:59:19 1 0 NULL
502 722 POFN-1712 INVFN-1712 13518 12554 2 1 64 42820.0 0.0 677.05 1538.89 1538.89 0.0 42142.95 INR 0.0 1.5 0.0 4 13518 2026-01-14 12:02:54 0 NULL 1 2026-01-14 12:03:37 12554 0 NULL
503 723 POFN-1713 INVFN-1713 13836 12517 2 1 4 320.0 0.0 6.1 7.62 7.62 0.0 313.9 INR 0.0 0.04 0.0 4 13836 2026-01-14 13:08:16 0 NULL 1 2026-01-14 13:12:36 12517 0 NULL
504 724 POFN-1714 INVFN-1714 12551 12516 2 1 40 74000.0 0.0 4228.57 1761.9 1761.9 0.0 69771.43 INR 0.0 7.0 0.0 4 12551 2026-01-14 16:35:44 0 NULL 1 2026-01-14 16:37:28 12516 0 NULL
505 725 POFN-1715 INVFN-1715 12517 12516 2 1 13 3380.0 0.0 171.86 0.0 0.0 515.59 3208.14 INR 0.0 0.27 0.0 4 12517 2026-01-14 16:37:48 0 NULL 1 2026-01-14 16:37:58 12516 0 NULL
506 726 POFN-1716 INVFN-1716 12521 12517 2 1 3 926.0 0.0 17.64 22.05 22.05 0.0 908.36 INR 0.0 0.15 0.0 4 12521 2026-01-14 16:41:06 0 NULL 1 2026-01-14 17:12:01 12517 0 NULL
507 727 POFN-1717 INVFN-1717 14323 12517 2 1 15 3900.0 0.0 66.1 297.46 297.46 0.0 3833.9 INR 0.0 0.32 0.0 4 14323 2026-01-14 16:42:28 0 NULL 1 2026-01-14 17:15:32 12517 0 NULL
508 728 POFN-1718 INVFN-1718 12516 1 2 1 10 2600.0 0.0 176.27 198.31 198.31 0.0 2423.73 INR 0.0 0.21 0.0 4 12516 2026-01-14 17:13:08 0 NULL 1 2026-01-14 17:13:33 1 0 NULL
509 729 POFN-1719 INVFN-1719 12517 12516 2 1 10 2600.0 0.0 132.2 0.0 0.0 396.61 2467.8 INR 0.0 0.21 0.0 4 12517 2026-01-14 17:14:36 0 NULL 1 2026-01-14 17:15:10 12516 0 NULL
510 730 POFN-1720 INVFN-1720 14079 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 14079 2026-01-14 21:27:07 0 NULL 1 2026-01-15 06:27:32 12517 0 NULL
511 731 POFN-1721 INVFN-1721 13438 12517 2 1 25 1200.0 0.0 22.86 28.57 28.57 0.0 1177.14 INR 0.0 0.15 0.0 4 13438 2026-01-15 09:56:02 0 NULL 1 2026-01-15 10:17:38 12517 0 NULL
512 732 POFN-1722 INVFN-1722 13438 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 13438 2026-01-15 10:03:25 0 NULL 1 2026-01-15 10:17:38 12517 0 NULL
513 733 POFN-1723 INVFN-1723 13438 12517 2 1 1 719.0 0.0 13.7 17.12 17.12 0.0 705.3 INR 0.0 0.15 0.0 4 13438 2026-01-15 10:05:10 0 NULL 1 2026-01-15 10:17:38 12517 0 NULL
514 734 POFN-1724 INVFN-1724 13438 12517 2 1 1 559.0 0.0 9.47 42.64 42.64 0.0 549.53 INR 0.0 0.1 0.0 4 13438 2026-01-15 10:07:31 0 NULL 1 2026-01-15 10:17:38 12517 0 NULL
515 735 POFN-1725 INVFN-1725 13438 12517 2 1 1 559.0 0.0 10.65 13.31 13.31 0.0 548.35 INR 0.0 0.11 0.0 4 13438 2026-01-15 10:08:44 0 NULL 1 2026-01-15 10:17:38 12517 0 NULL
516 736 POFN-1726 INVFN-1726 13438 12517 2 1 5 1605.0 0.0 27.2 122.42 122.42 0.0 1577.8 INR 0.0 0.11 0.0 4 13438 2026-01-15 10:10:34 0 NULL 1 2026-01-15 10:17:38 12517 0 NULL
517 737 POFN-1727 INVFN-1727 14032 12517 2 1 21 4052.0 0.0 70.32 268.09 268.09 0.0 3981.68 INR 0.0 0.03 0.0 4 14032 2026-01-15 13:01:40 0 NULL 1 2026-01-15 13:07:23 12517 0 NULL
518 738 POFN-1728 INVFN-1728 14428 12517 2 1 35 7669.0 0.0 145.74 0.0 0.0 381.87 7523.26 INR 0.0 0.1 0.0 4 14428 2026-01-15 13:05:03 0 NULL 1 2026-01-15 13:09:39 12517 0 NULL
519 739 POFN-1729 INVFN-1729 12517 12516 2 1 10 12000.0 0.0 685.71 0.0 0.0 571.43 11314.29 INR 0.0 2.5 0.0 4 12517 2026-01-15 13:08:41 0 NULL 1 2026-01-15 13:09:20 12516 0 NULL
520 740 POFN-1730 INVFN-1730 12552 12517 2 1 7 1261.0 0.0 21.71 87.84 87.84 0.0 1239.29 INR 0.0 0.01 0.0 4 12552 2026-01-15 14:11:52 0 NULL 1 2026-01-15 15:37:46 12517 0 NULL
521 741 POFN-1731 INVFN-1731 13438 12517 2 1 2 1440.0 0.0 27.43 34.29 34.29 0.0 1412.57 INR 0.0 0.3 0.0 4 13438 2026-01-15 15:05:23 0 NULL 1 2026-01-15 15:37:46 12517 0 NULL
522 742 POFN-1732 INVFN-1732 13438 12517 2 1 3 477.0 0.0 8.08 36.38 36.38 0.0 468.92 INR 0.0 0.03 0.0 4 13438 2026-01-15 15:06:01 0 NULL 1 2026-01-15 15:37:46 12517 0 NULL
523 743 POFN-1733 INVFN-1733 12546 12517 2 1 10 12000.0 0.0 228.57 285.71 285.71 0.0 11771.43 INR 0.0 1.25 0.0 4 12546 2026-01-15 20:23:10 0 NULL 1 2026-01-15 20:52:17 12517 0 NULL
524 744 POFN-1734 INVFN-1734 12517 12516 2 1 10 12000.0 0.0 685.71 0.0 0.0 571.43 11314.29 INR 0.0 1.25 0.0 4 12517 2026-01-15 20:51:21 0 NULL 1 2026-01-15 20:51:56 12516 0 NULL
525 745 POFN-1735 INVFN-1735 12529 12517 2 1 2 318.0 0.0 6.06 7.57 7.57 0.0 311.94 INR 0.0 0.03 0.0 4 12529 2026-01-15 20:59:59 0 NULL 1 2026-01-15 21:23:02 12517 0 NULL
526 746 POFN-1736 INVFN-1736 12543 12517 2 1 14 10208.0 0.0 194.44 243.05 243.05 0.0 10013.56 INR 0.0 0.15 0.0 4 12543 2026-01-15 22:30:14 0 NULL 1 2026-01-16 08:56:46 12517 0 NULL
527 747 POFN-1737 INVFN-1737 13438 12517 2 1 30 1440.0 0.0 27.43 34.29 34.29 0.0 1412.57 INR 0.0 0.18 0.0 4 13438 2026-01-16 11:22:56 0 NULL 1 2026-01-16 11:52:27 12517 0 NULL
528 748 POFN-1738 INVFN-1738 13438 12517 2 1 60 3600.0 0.0 66.05 148.67 148.67 0.0 3533.95 INR 0.0 0.11 0.0 4 13438 2026-01-16 11:33:52 0 NULL 1 2026-01-16 11:52:27 12517 0 NULL
529 749 POFN-1739 INVFN-1739 13438 12517 2 1 69 17067.0 0.0 303.05 957.31 957.31 0.0 16763.95 INR 0.0 0.01 0.0 4 13438 2026-01-16 12:14:48 0 NULL 1 2026-01-16 12:16:58 12517 0 NULL
530 750 POFN-1740 INVFN-1740 13836 12517 2 1 5 5077.0 0.0 96.7 120.88 120.88 0.0 4980.3 INR 0.0 0.15 0.0 4 13836 2026-01-16 12:52:34 0 NULL 1 2026-01-16 12:56:00 12517 0 NULL
531 751 POFN-1741 INVFN-1741 12527 12517 2 1 139 29498.0 0.0 525.94 1600.4 1600.4 0.0 28972.06 INR 0.0 0.1 0.0 4 12527 2026-01-16 12:58:14 0 NULL 1 2026-01-16 13:48:53 12517 0 NULL
532 752 POFN-1742 INVFN-1742 12525 12517 2 1 5 2381.0 0.0 42.87 118.65 118.65 0.0 2338.13 INR 0.0 0.11 0.0 4 12525 2026-01-16 13:31:06 0 NULL 1 2026-01-16 13:48:53 12517 0 NULL
533 753 POFN-1743 INVFN-1743 12541 12517 2 1 60 7848.0 0.0 143.59 334.27 334.27 0.0 7704.41 INR 0.0 0.02 0.0 4 12541 2026-01-16 13:50:17 0 NULL 1 2026-01-16 15:54:44 12517 0 NULL
534 754 POFN-1744 INVFN-1744 12541 12517 2 1 15 1443.0 0.0 25.46 84.88 84.88 0.0 1417.54 INR 0.0 0.02 0.0 4 12541 2026-01-16 13:54:30 0 NULL 1 2026-01-16 15:26:47 12517 0 NULL
535 755 POFN-1745 INVFN-1745 14323 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 14323 2026-01-16 15:17:08 0 NULL 1 2026-01-16 15:26:47 12517 0 NULL
536 756 POFN-1746 INVFN-1746 13836 12517 2 1 152 10287.0 0.0 191.17 364.28 364.28 0.0 10095.83 INR 0.0 0.07 0.0 4 13836 2026-01-16 15:34:09 0 NULL 1 2026-01-16 15:52:54 12517 0 NULL
537 757 POFN-1747 INVFN-1747 12517 12516 2 1 20 6080.0 0.0 309.15 0.0 0.0 927.46 5770.85 INR 0.0 1.0 0.0 4 12517 2026-01-16 15:53:49 0 NULL 1 2026-01-16 15:54:10 12516 0 NULL
538 758 POFN-1748 INVFN-1748 12532 12517 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 12532 2026-01-16 19:12:03 0 NULL 1 2026-01-16 20:46:02 12517 0 NULL
539 759 POFN-1749 INVFN-1749 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 20:36:12 0 NULL 1 2026-01-16 20:43:25 12516 0 NULL
540 760 POFN-1750 INVFN-1750 12552 12517 2 1 22 5560.0 0.0 100.07 278.24 278.24 0.0 5459.93 INR 0.0 0.11 0.0 4 12552 2026-01-16 20:46:34 0 NULL 1 2026-01-16 20:50:18 12517 0 NULL
541 761 POFN-1751 INVFN-1751 12533 12517 2 1 39 13633.0 0.0 206.79 396.62 396.62 0.0 13426.21 INR 0.0 0.02 0.0 4 12533 2026-01-16 20:47:38 0 NULL 1 2026-01-16 20:50:18 12517 0 NULL
542 762 POFN-1752 INVFN-1752 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-16 20:57:23 0 NULL 1 2026-01-16 21:04:04 12554 0 NULL
543 763 POFN-1753 INVFN-1753 13536 12554 2 1 27 3841.0 0.0 68.96 196.48 196.48 0.0 3772.04 INR 0.0 0.11 0.0 4 13536 2026-01-16 21:01:38 0 NULL 1 2026-01-16 21:04:04 12554 0 NULL
544 764 POFN-1754 INVFN-1754 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 21:02:57 0 NULL 1 2026-01-16 21:03:36 12516 0 NULL
545 765 POFN-1755 INVFN-1755 13438 12517 2 1 79 10158.0 0.0 182.91 506.26 506.26 0.0 9975.09 INR 0.0 0.11 0.0 4 13438 2026-01-16 21:03:04 0 NULL 1 2026-01-16 21:05:53 12517 0 NULL
546 766 POFN-1756 INVFN-1756 12517 12516 2 1 6 3000.0 0.0 152.54 0.0 0.0 457.63 2847.46 INR 0.0 0.6 0.0 4 12517 2026-01-16 21:05:25 0 NULL 1 2026-01-16 21:05:40 12516 0 NULL
547 767 POFN-1757 INVFN-1757 13438 12517 2 1 10 2040.0 0.0 38.86 48.57 48.57 0.0 2001.14 INR 0.0 0.4 0.0 4 13438 2026-01-16 21:15:42 0 NULL 1 2026-01-16 21:16:48 12517 0 NULL
548 768 POFN-1758 INVFN-1758 13438 12517 2 1 20 3180.0 0.0 53.9 242.54 242.54 0.0 3126.1 INR 0.0 0.5 0.0 4 13438 2026-01-16 21:18:50 0 NULL 1 2026-01-16 21:28:32 12517 0 NULL
549 769 POFN-1759 INVFN-1759 12529 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 12529 2026-01-16 21:30:39 0 NULL 1 2026-01-16 21:41:40 12517 0 NULL
550 770 POFN-1760 INVFN-1760 12529 12517 2 1 21 1008.0 0.0 19.2 24.0 24.0 0.0 988.8 INR 0.0 0.13 0.0 4 12529 2026-01-16 21:32:28 0 NULL 1 2026-01-16 21:38:04 12517 0 NULL