fx_franchise_order

1,057 rows · 31 columns · page 10 / 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
451 671 POFN-1661 INVFN-1661 12552 12517 2 1 76 13935.0 0.0 255.57 578.18 578.18 0.0 13679.43 INR 0.0 0.03 0.0 4 12552 2026-01-09 22:52:53 0 NULL 1 2026-01-09 22:53:52 12517 0 NULL
452 672 POFN-1662 INVFN-1662 13438 12554 2 1 1 10500.0 0.0 150.0 0.0 0.0 500.0 10350.0 INR 0.0 3.0 0.0 4 13438 2026-01-09 22:56:55 0 NULL 1 2026-01-09 22:58:21 12554 0 NULL
453 673 POFN-1663 INVFN-1663 13438 12554 2 1 3 2250.0 0.0 42.86 0.0 0.0 107.14 2207.14 INR 0.0 0.3 0.0 4 13438 2026-01-09 23:19:43 0 NULL 1 2026-01-09 23:21:34 12554 0 NULL
454 674 POFN-1664 INVFN-1664 13438 12554 2 1 21 2959.0 0.0 56.36 0.0 0.0 140.9 2902.64 INR 0.0 0.4 0.0 4 13438 2026-01-09 23:42:17 0 NULL 1 2026-01-09 23:56:53 12554 0 NULL
455 675 POFN-1665 INVFN-1665 13438 12554 2 1 1 750.0 0.0 14.29 0.0 0.0 35.71 735.71 INR 0.0 0.1 0.0 4 13438 2026-01-09 23:56:26 0 NULL 1 2026-01-09 23:57:01 12554 0 NULL
456 676 POFN-1666 INVFN-1666 13438 12554 2 1 5 920.0 0.0 15.59 0.0 0.0 140.34 904.41 INR 0.0 0.06 0.0 4 13438 2026-01-10 11:46:05 0 NULL 1 2026-01-10 11:51:44 12554 0 NULL
457 677 POFN-1667 INVFN-1667 12523 12517 2 1 23 8337.0 0.0 154.54 305.0 305.0 0.0 8182.46 INR 0.0 0.22 0.0 4 12523 2026-01-10 13:53:28 0 NULL 1 2026-01-10 15:40:26 12517 0 NULL
458 678 POFN-1668 INVFN-1668 12517 12516 2 1 30 9120.0 0.0 463.73 0.0 0.0 1391.19 8656.27 INR 0.0 1.5 0.0 4 12517 2026-01-10 15:40:06 0 NULL 1 2026-01-10 15:40:17 12516 0 NULL
459 679 POFN-1669 INVFN-1669 14323 12517 2 1 397 52616.0 0.0 948.75 2589.3 2589.3 0.0 51667.25 INR 0.0 0.34 0.0 4 14323 2026-01-10 16:02:57 0 NULL 1 2026-01-10 16:06:18 12517 0 NULL
460 680 POFN-1670 INVFN-1670 12517 12516 2 1 230 39070.0 0.0 2016.64 0.0 0.0 5459.35 37053.36 INR 0.0 0.45 0.0 4 12517 2026-01-10 16:16:59 0 NULL 2 2026-01-10 16:17:18 12516 0 NULL
461 681 POFN-1671 INVFN-1671 12517 12516 2 1 130 21920.0 0.0 1144.61 0.0 0.0 2843.24 20775.39 INR 0.0 0.45 0.0 4 12517 2026-01-10 16:18:01 0 NULL 1 2026-01-10 16:18:44 12516 0 NULL
462 682 POFN-1672 INVFN-1672 12516 1 2 1 50 7950.0 0.0 605.71 189.29 189.29 0.0 7344.29 INR 0.0 0.75 0.0 4 12516 2026-01-10 16:18:28 0 NULL 1 2026-01-10 16:18:37 1 0 NULL
463 683 POFN-1673 INVFN-1673 12517 12516 2 1 50 6000.0 0.0 305.08 0.0 0.0 915.25 5694.92 INR 0.0 0.55 0.0 4 12517 2026-01-10 16:19:35 0 NULL 1 2026-01-10 16:19:45 12516 0 NULL
464 684 POFN-1674 INVFN-1674 12517 12516 2 1 30 22500.0 0.0 1285.71 0.0 0.0 1071.43 21214.29 INR 0.0 3.0 0.0 4 12517 2026-01-10 16:21:05 0 NULL 1 2026-01-10 16:21:22 12516 0 NULL
465 685 POFN-1675 INVFN-1675 14323 12517 2 1 47 6957.0 0.0 118.58 513.94 513.94 0.0 6838.42 INR 0.0 0.21 0.0 4 14323 2026-01-10 16:26:54 0 NULL 1 2026-01-10 16:28:11 12517 0 NULL
466 686 POFN-1676 INVFN-1676 14323 12517 2 1 45 28660.0 0.0 475.62 1189.48 1189.48 0.0 28184.38 INR 0.0 0.06 0.0 4 14323 2026-01-10 16:46:16 0 NULL 1 2026-01-10 17:00:08 12517 0 NULL
467 687 POFN-1677 INVFN-1677 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-10 16:48:31 0 NULL 1 2026-01-10 16:48:47 12516 0 NULL
468 688 POFN-1678 INVFN-1678 12517 12516 2 1 8 2568.0 0.0 130.58 0.0 0.0 391.73 2437.42 INR 0.0 0.18 0.0 4 12517 2026-01-10 16:55:50 0 NULL 1 2026-01-10 16:55:59 12516 0 NULL
469 689 POFN-1679 INVFN-1679 12516 1 2 1 100 32100.0 0.0 2176.27 2448.31 2448.31 0.0 29923.73 INR 0.0 2.2 0.0 4 12516 2026-01-10 16:59:03 0 NULL 1 2026-01-10 16:59:16 1 0 NULL
470 690 POFN-1680 INVFN-1680 12517 12516 2 1 50 16050.0 0.0 816.1 0.0 0.0 2448.31 15233.9 INR 0.0 1.1 0.0 4 12517 2026-01-10 16:59:53 0 NULL 1 2026-01-10 17:00:00 12516 0 NULL
471 691 POFN-1681 INVFN-1681 13536 12554 2 1 12 2586.0 0.0 43.93 194.72 194.72 0.0 2542.07 INR 0.0 0.06 0.0 4 13536 2026-01-10 17:10:28 0 NULL 1 2026-01-10 17:10:43 12554 0 NULL
472 692 POFN-1682 INVFN-1682 12527 12554 2 1 128 25938.0 0.0 460.32 0.0 0.0 2922.16 25477.68 INR 0.0 0.02 0.0 4 12527 2026-01-10 17:25:56 0 NULL 2 2026-01-13 16:01:10 12554 0 NULL
473 693 POFN-1683 INVFN-1683 12517 12516 2 1 3 54000.0 0.0 1200.0 0.0 0.0 2571.43 52800.0 INR 0.0 12.0 0.0 4 12517 2026-01-12 12:42:24 0 NULL 1 2026-01-12 12:42:37 12516 0 NULL
474 694 POFN-1684 INVFN-1684 12517 12516 2 1 20 35000.0 0.0 1528.57 0.0 0.0 1666.67 33471.43 INR 0.0 1.75 0.0 4 12517 2026-01-12 12:52:57 0 NULL 1 2026-01-12 12:53:07 12516 0 NULL
475 695 POFN-1685 INVFN-1685 13438 12554 2 1 3 1038.0 0.0 19.1 0.0 0.0 82.79 1018.9 INR 0.0 0.02 0.0 4 13438 2026-01-12 13:25:49 0 NULL 2 2026-01-12 13:44:40 12554 0 NULL
476 696 POFN-1686 INVFN-1686 13438 12554 2 1 3 360.0 0.0 6.1 0.0 0.0 54.92 353.9 INR 0.0 0.03 0.0 4 13438 2026-01-12 13:30:25 0 NULL 2 2026-01-12 13:44:40 12554 0 NULL
477 697 POFN-1687 INVFN-1687 13438 12554 2 1 3 360.0 0.0 6.1 0.0 0.0 54.92 353.9 INR 0.0 0.03 0.0 4 13438 2026-01-12 13:31:59 0 NULL 2 2026-01-12 13:44:40 12554 0 NULL
478 698 POFN-1688 INVFN-1688 13438 12517 2 1 10 1878.0 0.0 33.34 105.46 105.46 0.0 1844.66 INR 0.0 0.08 0.0 4 13438 2026-01-12 13:49:36 0 NULL 1 2026-01-12 13:51:15 12517 0 NULL
479 699 POFN-1689 INVFN-1689 13438 12517 2 1 14 672.0 0.0 12.8 16.0 16.0 0.0 659.2 INR 0.0 0.08 0.0 4 13438 2026-01-12 13:55:39 0 NULL 1 2026-01-12 13:56:12 12517 0 NULL
480 700 POFN-1690 INVFN-1690 13836 12517 2 1 28 2483.0 0.0 44.23 135.66 135.66 0.0 2438.77 INR 0.0 0.11 0.0 4 13836 2026-01-12 15:43:39 0 NULL 1 2026-01-12 15:46:55 12517 0 NULL
481 701 POFN-1691 INVFN-1691 12545 12517 2 1 53 5250.0 0.0 93.31 292.3 292.3 0.0 5156.69 INR 0.0 0.05 0.0 4 12545 2026-01-12 15:47:18 0 NULL 1 2026-01-12 15:47:32 12517 0 NULL
482 702 POFN-1692 INVFN-1692 12517 12516 2 1 3 7800.0 0.0 445.71 0.0 0.0 371.43 7354.29 INR 0.0 1.5 0.0 4 12517 2026-01-12 16:49:12 0 NULL 1 2026-01-12 16:49:28 12516 0 NULL
483 703 POFN-1693 INVFN-1693 12532 12517 2 1 62 47079.0 0.0 861.03 1228.03 1228.03 0.0 46217.97 INR 0.0 0.3 0.0 4 12532 2026-01-12 17:02:39 0 NULL 1 2026-01-12 17:35:41 12517 0 NULL
484 704 POFN-1694 INVFN-1694 12517 12516 2 1 30 21580.0 0.0 1233.14 0.0 0.0 1027.62 20346.86 INR 0.0 1.5 0.0 4 12517 2026-01-12 17:34:41 0 NULL 1 2026-01-12 17:35:24 12516 0 NULL
485 705 POFN-1695 INVFN-1695 13836 12517 2 1 14 1532.0 0.0 26.57 101.74 101.74 0.0 1505.43 INR 0.0 0.02 0.0 4 13836 2026-01-12 23:07:20 0 NULL 1 2026-01-12 23:09:07 12517 0 NULL
486 706 POFN-1696 INVFN-1696 12526 12517 2 1 183 19792.0 0.0 368.94 672.43 672.43 0.0 19423.06 INR 0.0 0.06 0.0 4 12526 2026-01-12 23:20:20 0 NULL 1 2026-01-12 23:23:33 12517 0 NULL
487 707 POFN-1697 INVFN-1697 12542 12554 2 1 127 11163.0 0.0 201.3 0.0 0.0 1097.84 10961.7 INR 0.0 0.08 0.0 4 12542 2026-01-13 11:00:12 0 NULL 1 2026-01-13 11:53:15 12554 0 NULL
488 708 POFN-1698 INVFN-1698 12552 12517 2 1 1 720.0 0.0 13.71 17.14 17.14 0.0 706.29 INR 0.0 0.15 0.0 4 12552 2026-01-13 12:19:22 0 NULL 1 2026-01-13 12:20:55 12517 0 NULL
489 709 POFN-1699 INVFN-1699 12517 12516 2 1 5 6000.0 0.0 342.86 0.0 0.0 285.71 5657.14 INR 0.0 1.25 0.0 4 12517 2026-01-13 12:20:20 0 NULL 1 2026-01-13 12:20:39 12516 0 NULL
490 710 POFN-1700 INVFN-1700 12526 12517 2 1 18 11333.0 0.0 214.29 309.37 309.37 0.0 11118.71 INR 0.0 0.1 0.0 4 12526 2026-01-13 12:27:54 0 NULL 1 2026-01-13 12:31:57 12517 0 NULL
491 711 POFN-1701 INVFN-1701 12518 12517 2 1 50 21426.0 0.0 352.01 662.68 662.68 0.0 21073.99 INR 0.0 0.3 0.0 4 12518 2026-01-13 12:54:45 0 NULL 1 2026-01-13 13:02:56 12517 0 NULL
492 712 POFN-1702 INVFN-1702 13836 12517 2 1 4 705.0 0.0 12.12 49.57 49.57 0.0 692.88 INR 0.0 0.01 0.0 4 13836 2026-01-13 15:00:21 0 NULL 1 2026-01-13 15:52:28 12517 0 NULL
493 713 POFN-1703 INVFN-1703 13536 12554 2 1 36 28638.0 0.0 436.1 916.42 916.42 0.0 28201.9 INR 0.0 0.03 0.0 4 13536 2026-01-13 16:05:23 0 NULL 1 2026-01-13 16:05:34 12554 0 NULL
494 714 POFN-1704 INVFN-1704 13536 12554 2 1 1 159.0 0.0 2.69 12.13 12.13 0.0 156.31 INR 0.0 0.02 0.0 4 13536 2026-01-13 16:39:50 0 NULL 1 2026-01-13 16:39:59 12554 0 NULL
495 715 POFN-1705 INVFN-1705 12534 12517 2 1 140 21237.0 0.0 383.16 1039.5 1039.5 0.0 20853.84 INR 0.0 0.19 0.0 4 12534 2026-01-13 18:40:46 0 NULL 1 2026-01-13 18:51:18 12517 0 NULL
496 716 POFN-1706 INVFN-1706 12517 12516 2 1 20 2400.0 0.0 122.03 0.0 0.0 366.1 2277.97 INR 0.0 0.22 0.0 4 12517 2026-01-13 18:51:02 0 NULL 1 2026-01-13 18:51:11 12516 0 NULL
497 717 POFN-1707 INVFN-1707 12517 12516 2 1 400 78400.0 0.0 3986.44 0.0 0.0 11959.32 74413.56 INR 0.0 1.1 0.0 4 12517 2026-01-13 19:20:01 0 NULL 1 2026-01-13 19:24:49 12516 0 NULL
498 718 POFN-1708 INVFN-1708 12516 1 2 1 300 46300.0 0.0 3138.98 3531.36 3531.36 0.0 43161.02 INR 0.0 1.1 0.0 4 12516 2026-01-13 19:24:26 0 NULL 1 2026-01-13 19:24:37 1 0 NULL
499 719 POFN-1709 INVFN-1709 13518 12554 2 1 172 145978.0 0.0 2621.89 3513.08 3513.08 0.0 143356.11 INR 0.0 7.5 0.0 4 13518 2026-01-14 11:53:54 0 NULL 1 2026-01-14 12:03:35 12554 0 NULL
500 720 POFN-1710 INVFN-1710 12554 12516 2 1 153 194320.0 0.0 10306.86 6184.78 6184.78 0.0 184013.14 INR 0.0 9.0 0.0 4 12554 2026-01-14 11:58:39 0 NULL 1 2026-01-14 11:59:31 12516 0 NULL