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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 801 | 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 | ||
| 802 | 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 | ||
| 803 | 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 | ||
| 804 | 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 | ||
| 805 | 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 | ||
| 806 | 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 | ||
| 807 | 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 | ||
| 808 | 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 | ||
| 809 | 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 | ||
| 810 | 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 | ||
| 811 | 821 | POFN-1811 | INVFN-1811 | 12517 | 12516 | 2 | 1 | 1520 | 1022580.0 | 0.0 | 58433.14 | 0.0 | 0.0 | 48694.29 | 964146.86 | INR | 0.0 | 15.0 | 0.0 | 4 | 12517 | 2026-01-25 14:08:05 | 0 | NULL | 1 | 2026-01-25 15:42:38 | 12516 | 0 | NULL | ||
| 812 | 822 | POFN-1812 | INVFN-1812 | 12517 | 12516 | 2 | 1 | 4350 | 2282640.0 | 0.0 | 123248.07 | 0.0 | 0.0 | 134219.74 | 2159391.93 | INR | 0.0 | 25.0 | 0.0 | 4 | 12517 | 2026-01-25 14:17:29 | 0 | NULL | 1 | 2026-01-26 10:10:28 | 12516 | 0 | NULL | ||
| 813 | 823 | POFN-1813 | INVFN-1813 | 12516 | 1 | 2 | 1 | 2090 | 985800.0 | 0.0 | 51739.06 | 43683.39 | 43683.39 | 0.0 | 934060.94 | INR | 0.0 | 50.0 | 0.0 | 4 | 12516 | 2026-01-25 15:00:57 | 0 | NULL | 1 | 2026-01-25 15:05:03 | 1 | 0 | NULL | ||
| 814 | 824 | POFN-1814 | INVFN-1814 | 12516 | 1 | 2 | 1 | 1110 | 856900.0 | 0.0 | 64759.64 | 23702.22 | 23702.22 | 0.0 | 792140.36 | INR | 0.0 | 18.0 | 0.0 | 4 | 12516 | 2026-01-25 15:11:07 | 0 | NULL | 1 | 2026-01-25 15:13:38 | 1 | 0 | NULL | ||
| 815 | 825 | POFN-1815 | INVFN-1815 | 12516 | 1 | 2 | 1 | 60 | 72000.0 | 0.0 | 5485.71 | 1714.29 | 1714.29 | 0.0 | 66514.29 | INR | 0.0 | 15.0 | 0.0 | 4 | 12516 | 2026-01-25 15:18:12 | 0 | NULL | 1 | 2026-01-25 15:18:28 | 1 | 0 | NULL | ||
| 816 | 826 | POFN-1816 | INVFN-1816 | 12516 | 1 | 2 | 1 | 50 | 60000.0 | 0.0 | 4571.43 | 1428.57 | 1428.57 | 0.0 | 55428.57 | INR | 0.0 | 10.0 | 0.0 | 4 | 12516 | 2026-01-25 15:19:57 | 0 | NULL | 1 | 2026-01-25 15:20:16 | 1 | 0 | NULL | ||
| 817 | 827 | POFN-1817 | INVFN-1817 | 12516 | 1 | 2 | 1 | 1200 | 817220.0 | 0.0 | 62264.38 | 19457.62 | 19457.62 | 0.0 | 754955.62 | INR | 0.0 | 12.0 | 0.0 | 4 | 12516 | 2026-01-25 15:27:45 | 0 | NULL | 1 | 2026-01-25 15:29:03 | 1 | 0 | NULL | ||
| 818 | 828 | POFN-1818 | INVFN-1818 | 12516 | 1 | 2 | 1 | 20 | 24000.0 | 0.0 | 1828.57 | 571.43 | 571.43 | 0.0 | 22171.43 | INR | 0.0 | 5.0 | 0.0 | 4 | 12516 | 2026-01-25 15:31:28 | 0 | NULL | 1 | 2026-01-25 15:31:53 | 1 | 0 | NULL | ||
| 819 | 829 | POFN-1819 | INVFN-1819 | 12516 | 1 | 2 | 1 | 100 | 31900.0 | 0.0 | 2430.48 | 759.52 | 759.52 | 0.0 | 29469.52 | INR | 0.0 | 5.0 | 0.0 | 4 | 12516 | 2026-01-25 15:33:41 | 0 | NULL | 1 | 2026-01-25 15:34:09 | 1 | 0 | NULL | ||
| 820 | 830 | POFN-1820 | INVFN-1820 | 12516 | 1 | 2 | 1 | 100 | 55900.0 | 0.0 | 4259.05 | 1330.95 | 1330.95 | 0.0 | 51640.95 | INR | 0.0 | 11.0 | 0.0 | 4 | 12516 | 2026-01-25 15:37:41 | 0 | NULL | 1 | 2026-01-25 15:39:08 | 1 | 0 | NULL | ||
| 821 | 831 | POFN-1821 | INVFN-1821 | 12516 | 1 | 2 | 1 | 20 | 14380.0 | 0.0 | 1095.62 | 342.38 | 342.38 | 0.0 | 13284.38 | INR | 0.0 | 3.0 | 0.0 | 4 | 12516 | 2026-01-25 15:42:04 | 0 | NULL | 1 | 2026-01-25 15:42:22 | 1 | 0 | NULL | ||
| 822 | 832 | POFN-1822 | INVFN-1822 | 12516 | 1 | 2 | 1 | 4600 | 2448840.0 | 0.0 | 176477.9 | 74290.26 | 74290.26 | 0.0 | 2272362.1 | INR | 0.0 | 25.0 | 0.0 | 4 | 12516 | 2026-01-26 10:08:34 | 0 | NULL | 1 | 2026-01-26 10:08:51 | 1 | 0 | NULL | ||
| 823 | 833 | POFN-1823 | INVFN-1823 | 12527 | 12517 | 2 | 1 | 54 | 18248.0 | 0.0 | 329.61 | 883.76 | 883.76 | 0.0 | 17918.39 | INR | 0.0 | 0.33 | 0.0 | 4 | 12527 | 2026-01-26 12:35:50 | 0 | NULL | 1 | 2026-01-26 12:40:24 | 12517 | 0 | NULL | ||
| 824 | 834 | POFN-1824 | INVFN-1824 | 12552 | 12517 | 2 | 1 | 37 | 10133.0 | 0.0 | 185.21 | 436.16 | 436.16 | 0.0 | 9947.79 | INR | 0.0 | 0.02 | 0.0 | 4 | 12552 | 2026-01-26 16:23:07 | 0 | NULL | 1 | 2026-01-26 16:30:00 | 12517 | 0 | NULL | ||
| 825 | 835 | POFN-1825 | INVFN-1825 | 12532 | 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 | 12532 | 2026-01-26 17:49:21 | 0 | NULL | 1 | 2026-01-26 17:51:42 | 12517 | 0 | NULL | ||
| 826 | 836 | POFN-1826 | INVFN-1826 | 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-26 22:14:13 | 0 | NULL | 1 | 2026-01-26 22:14:42 | 12554 | 0 | NULL | ||
| 827 | 837 | POFN-1827 | INVFN-1827 | 12516 | 1 | 2 | 1 | 1450 | 659600.0 | 0.0 | 48915.58 | 24077.64 | 24077.64 | 0.0 | 610684.42 | INR | 0.0 | 8.8 | 0.0 | 4 | 12516 | 2026-01-27 11:41:59 | 0 | NULL | 1 | 2026-01-27 11:47:38 | 1 | 0 | NULL | ||
| 828 | 838 | POFN-1828 | INVFN-1828 | 12516 | 1 | 2 | 1 | 150 | 23850.0 | 0.0 | 1817.14 | 567.86 | 567.86 | 0.0 | 22032.86 | INR | 0.0 | 2.25 | 0.0 | 4 | 12516 | 2026-01-27 11:47:20 | 0 | NULL | 1 | 2026-01-27 11:47:38 | 1 | 0 | NULL | ||
| 829 | 839 | POFN-1829 | INVFN-1829 | 12517 | 12516 | 2 | 1 | 1400 | 561550.0 | 0.0 | 31221.69 | 0.0 | 0.0 | 41188.42 | 530328.31 | INR | 0.0 | 8.25 | 0.0 | 4 | 12517 | 2026-01-27 12:00:09 | 0 | NULL | 1 | 2026-01-27 12:00:28 | 12516 | 0 | NULL | ||
| 830 | 840 | POFN-1830 | INVFN-1830 | 12522 | 12517 | 2 | 1 | 2 | 680.0 | 0.0 | 12.95 | 16.19 | 16.19 | 0.0 | 667.05 | INR | 0.0 | 0.1 | 0.0 | 4 | 12522 | 2026-01-27 12:55:50 | 0 | NULL | 1 | 2026-01-27 13:00:36 | 12517 | 0 | NULL | ||
| 831 | 841 | POFN-1831 | INVFN-1831 | 12516 | 1 | 2 | 1 | 43 | 61920.0 | 0.0 | 0.0 | 1474.29 | 1474.29 | 0.0 | 61920.0 | INR | 0.0 | 0.0 | 0.0 | 4 | 12516 | 2026-01-27 13:07:08 | 0 | NULL | 1 | 2026-01-27 13:07:22 | 1 | 0 | NULL | ||
| 832 | 842 | POFN-1832 | INVFN-1832 | 12517 | 12516 | 2 | 1 | 93 | 83180.0 | 0.0 | 868.47 | 0.0 | 0.0 | 5134.0 | 82311.53 | INR | 0.0 | 0.9 | 0.0 | 4 | 12517 | 2026-01-27 13:10:08 | 0 | NULL | 1 | 2026-01-27 13:10:45 | 12516 | 0 | NULL | ||
| 833 | 843 | POFN-1833 | INVFN-1833 | 12516 | 1 | 2 | 1 | 43 | 11180.0 | 0.0 | 757.97 | 852.71 | 852.71 | 0.0 | 10422.03 | INR | 0.0 | 0.9 | 0.0 | 4 | 12516 | 2026-01-27 13:10:27 | 0 | NULL | 1 | 2026-01-27 13:10:34 | 1 | 0 | NULL | ||
| 834 | 844 | POFN-1834 | INVFN-1834 | 12517 | 12516 | 2 | 1 | 2700 | 599800.0 | 0.0 | 34274.29 | 0.0 | 0.0 | 28561.9 | 565525.71 | INR | 0.0 | 80.0 | 0.0 | 4 | 12517 | 2026-01-27 13:20:50 | 0 | NULL | 1 | 2026-01-27 13:21:43 | 12516 | 0 | NULL | ||
| 835 | 845 | POFN-1835 | INVFN-1835 | 12516 | 1 | 2 | 1 | 200 | 399800.0 | 0.0 | 30460.95 | 9519.05 | 9519.05 | 0.0 | 369339.05 | INR | 0.0 | 80.0 | 0.0 | 4 | 12516 | 2026-01-27 13:21:22 | 0 | NULL | 1 | 2026-01-27 13:21:31 | 1 | 0 | NULL | ||
| 836 | 846 | POFN-1836 | INVFN-1836 | 12516 | 1 | 2 | 1 | 1 | 304.0 | 0.0 | 20.61 | 23.19 | 23.19 | 0.0 | 304.0 | INR | 0.0 | 0.05 | 0.0 | 4 | 12516 | 2026-01-27 18:05:11 | 0 | NULL | 1 | 2026-01-27 18:05:42 | 1 | 1 | 2026-01-27 18:05:42 | ||
| 837 | 847 | POFN-1837 | INVFN-1837 | 12555 | 12554 | 2 | 1 | 4 | 4639.0 | 0.0 | 88.36 | 110.45 | 110.45 | 0.0 | 4639.0 | INR | 0.0 | 0.4 | 0.0 | 4 | 12555 | 2026-01-27 19:35:15 | 0 | NULL | 1 | 2026-01-27 19:35:36 | 12554 | 1 | 2026-01-27 19:35:36 | ||
| 838 | 848 | POFN-1838 | INVFN-1838 | 12554 | 12516 | 2 | 1 | 4 | 4639.0 | 0.0 | 220.9 | 110.45 | 110.45 | 0.0 | 4639.0 | INR | 0.0 | 0.4 | 0.0 | 4 | 12554 | 2026-01-27 19:43:43 | 0 | NULL | 1 | 2026-01-27 19:44:26 | 12516 | 1 | 2026-01-27 19:44:26 | ||
| 839 | 849 | POFN-1839 | INVFN-1839 | 12554 | 12516 | 2 | 1 | 1 | 720.0 | 0.0 | 34.29 | 17.14 | 17.14 | 0.0 | 720.0 | INR | 0.0 | 0.15 | 0.0 | 4 | 12554 | 2026-01-27 20:52:56 | 0 | NULL | 1 | 2026-01-27 20:53:19 | 12516 | 1 | 2026-01-27 20:53:19 | ||
| 840 | 850 | POFN-1840 | INVFN-1840 | 12555 | 12554 | 2 | 1 | 10 | 12500.0 | 0.0 | 238.1 | 297.62 | 297.62 | 0.0 | 12500.0 | INR | 0.0 | 2.5 | 0.0 | 4 | 12555 | 2026-01-28 13:25:47 | 0 | NULL | 1 | 2026-01-28 13:25:57 | 12554 | 1 | 2026-01-28 13:25:57 | ||
| 841 | 851 | POFN-1841 | INVFN-1841 | 12545 | 12517 | 2 | 1 | 37 | 4954.0 | 0.0 | 90.44 | 215.9 | 215.9 | 0.0 | 4954.0 | INR | 0.0 | 0.04 | 0.0 | 4 | 12545 | 2026-01-28 13:42:36 | 0 | NULL | 1 | 2026-01-28 13:44:11 | 12517 | 1 | 2026-01-28 13:44:11 | ||
| 842 | 852 | POFN-1842 | INVFN-1842 | 12534 | 12517 | 2 | 1 | 89 | 22331.0 | 0.0 | 409.93 | 917.36 | 917.36 | 0.0 | 22331.0 | INR | 0.0 | 0.06 | 0.0 | 4 | 12534 | 2026-01-28 17:51:07 | 0 | NULL | 1 | 2026-01-28 18:36:57 | 12517 | 1 | 2026-01-28 18:36:57 | ||
| 843 | 853 | POFN-1843 | INVFN-1843 | 12523 | 12517 | 2 | 1 | 158 | 24062.0 | 0.0 | 442.28 | 973.92 | 973.92 | 0.0 | 24062.0 | INR | 0.0 | 0.15 | 0.0 | 4 | 12523 | 2026-01-28 18:02:24 | 0 | NULL | 1 | 2026-01-28 18:36:57 | 12517 | 1 | 2026-01-28 18:36:57 | ||
| 844 | 854 | POFN-1844 | INVFN-1844 | 13438 | 12517 | 2 | 1 | 2 | 1159.0 | 0.0 | 22.08 | 27.6 | 27.6 | 0.0 | 1159.0 | INR | 0.0 | 0.11 | 0.0 | 4 | 13438 | 2026-01-28 18:34:36 | 0 | NULL | 1 | 2026-01-28 18:36:57 | 12517 | 1 | 2026-01-28 18:36:57 | ||
| 845 | 855 | POFN-1845 | INVFN-1845 | 12547 | 12517 | 2 | 1 | 1 | 48.0 | 0.0 | 0.91 | 1.14 | 1.14 | 0.0 | 48.0 | INR | 0.0 | 0.01 | 0.0 | 4 | 12547 | 2026-01-28 19:57:54 | 0 | NULL | 1 | 2026-01-29 08:03:44 | 12517 | 1 | 2026-01-29 08:03:44 | ||
| 846 | 856 | POFN-1846 | INVFN-1846 | 12516 | 1 | 2 | 1 | 5 | 52500.0 | 0.0 | 400.0 | 1250.0 | 1250.0 | 0.0 | 52500.0 | INR | 0.0 | 15.0 | 0.0 | 4 | 12516 | 2026-01-29 15:38:38 | 0 | NULL | 1 | 2026-01-29 15:38:46 | 1 | 1 | 2026-01-29 15:38:46 | ||
| 847 | 857 | POFN-1847 | INVFN-1847 | 12517 | 12516 | 2 | 1 | 5 | 52500.0 | 0.0 | 300.0 | 0.0 | 0.0 | 2500.0 | 52500.0 | INR | 0.0 | 15.0 | 0.0 | 4 | 12517 | 2026-01-29 15:39:04 | 0 | NULL | 1 | 2026-01-29 15:39:13 | 12516 | 1 | 2026-01-29 15:39:13 | ||
| 848 | 858 | POFN-1848 | INVFN-1848 | 12527 | 12517 | 2 | 1 | 2 | 21000.0 | 0.0 | 150.0 | 500.0 | 500.0 | 0.0 | 21000.0 | INR | 0.0 | 6.0 | 0.0 | 4 | 12527 | 2026-01-29 15:53:35 | 0 | NULL | 1 | 2026-01-29 15:55:04 | 12517 | 1 | 2026-01-29 15:55:04 | ||
| 849 | 859 | POFN-1849 | INVFN-1849 | 12527 | 12517 | 2 | 1 | 1 | 2000.0 | 0.0 | 38.1 | 47.62 | 47.62 | 0.0 | 2000.0 | INR | 0.0 | 0.4 | 0.0 | 4 | 12527 | 2026-01-29 16:06:03 | 0 | NULL | 1 | 2026-01-29 16:08:24 | 12517 | 1 | 2026-01-29 16:08:24 | ||
| 850 | 860 | POFN-1850 | INVFN-1850 | 12521 | 12517 | 2 | 1 | 106 | 17430.0 | 0.0 | 332.74 | 396.6 | 396.6 | 0.0 | 17430.0 | INR | 0.0 | 0.15 | 0.0 | 4 | 12521 | 2026-01-29 22:20:37 | 0 | NULL | 1 | 2026-01-29 22:22:45 | 12517 | 1 | 2026-01-29 22:22:45 |