fx_franchise_order
| # | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 701 | 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 | ||
| 702 | 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 | ||
| 703 | 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 | ||
| 704 | 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 | ||
| 705 | 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 | ||
| 706 | 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 | ||
| 707 | 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 | ||
| 708 | 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 | ||
| 709 | 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 | ||
| 710 | 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 | ||
| 711 | 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 | ||
| 712 | 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 | ||
| 713 | 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 | ||
| 714 | 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 | ||
| 715 | 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 | ||
| 716 | 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 | ||
| 717 | 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 | ||
| 718 | 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 | ||
| 719 | 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 | ||
| 720 | 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 | ||
| 721 | 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 | ||
| 722 | 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 | ||
| 723 | 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 | ||
| 724 | 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 | ||
| 725 | 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 | ||
| 726 | 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 | ||
| 727 | 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 | ||
| 728 | 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 | ||
| 729 | 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 | ||
| 730 | 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 | ||
| 731 | 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 | ||
| 732 | 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 | ||
| 733 | 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 | ||
| 734 | 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 | ||
| 735 | 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 | ||
| 736 | 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 | ||
| 737 | 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 | ||
| 738 | 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 | ||
| 739 | 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 | ||
| 740 | 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 | ||
| 741 | 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 | ||
| 742 | 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 | ||
| 743 | 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 | ||
| 744 | 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 | ||
| 745 | 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 | ||
| 746 | 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 | ||
| 747 | 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 | ||
| 748 | 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 | ||
| 749 | 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 | ||
| 750 | 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 |