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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 851 | 1071 | POFN-2061 | INVFN-2061 | 12528 | 12517 | 2 | 1 | 263 | 14961.0 | 0.0 | 283.79 | 385.65 | 385.65 | 0.0 | 14961.0 | INR | 0.0 | 0.02 | 0.0 | 4 | 12528 | 2026-04-04 13:46:00 | 0 | NULL | 1 | 2026-04-06 10:46:38 | 12517 | 1 | 2026-04-06 10:46:38 | ||
| 852 | 1072 | POFN-2062 | INVFN-2062 | 13438 | 12517 | 2 | 1 | 1 | 159.0 | 0.0 | 2.69 | 12.13 | 12.13 | 0.0 | 159.0 | INR | 0.0 | 0.01 | 0.0 | 4 | 13438 | 2026-04-07 22:44:23 | 0 | NULL | 1 | 2026-04-07 22:44:45 | 12517 | 1 | 2026-04-07 22:44:45 | ||
| 853 | 1073 | POFN-2063 | INVFN-2063 | 12545 | 12517 | 2 | 1 | 124 | 7534.0 | 0.0 | 140.19 | 262.38 | 262.38 | 0.0 | 7534.0 | INR | 0.0 | 0.05 | 0.0 | 4 | 12545 | 2026-04-08 12:23:36 | 0 | NULL | 1 | 2026-04-08 12:53:41 | 12517 | 1 | 2026-04-08 12:53:41 | ||
| 854 | 1074 | POFN-2064 | INVFN-2064 | 12545 | 12517 | 2 | 1 | 3 | 144.0 | 0.0 | 2.74 | 3.43 | 3.43 | 0.0 | 144.0 | INR | 0.0 | 0.02 | 0.0 | 4 | 12545 | 2026-04-08 12:24:26 | 0 | NULL | 1 | 2026-04-08 12:53:41 | 12517 | 1 | 2026-04-08 12:53:41 | ||
| 855 | 1075 | POFN-2065 | INVFN-2065 | 12516 | 1 | 2 | 1 | 20 | 100000.0 | 0.0 | 7766.99 | 1456.31 | 1456.31 | 0.0 | 100000.0 | INR | 0.0 | 20.0 | 0.0 | 4 | 12516 | 2026-04-08 16:47:53 | 0 | NULL | 1 | 2026-04-08 16:48:34 | 1 | 1 | 2026-04-08 16:48:34 | ||
| 856 | 1076 | POFN-2066 | INVFN-2066 | 12554 | 12516 | 2 | 1 | 20 | 100000.0 | 0.0 | 5825.24 | 1456.31 | 1456.31 | 0.0 | 100000.0 | INR | 0.0 | 20.0 | 0.0 | 4 | 12554 | 2026-04-08 16:51:21 | 0 | NULL | 1 | 2026-04-08 16:56:52 | 12516 | 1 | 2026-04-08 16:56:52 | ||
| 857 | 1077 | POFN-2067 | INVFN-2067 | 12554 | 12516 | 2 | 1 | 20 | 100000.0 | 0.0 | 5825.24 | 1456.31 | 1456.31 | 0.0 | 100000.0 | INR | 0.0 | 20.0 | 0.0 | 4 | 12554 | 2026-04-08 16:55:57 | 0 | NULL | 2 | 2026-04-08 16:56:58 | 12516 | 0 | NULL | ||
| 858 | 1078 | POFN-2068 | INVFN-2068 | 12545 | 12517 | 2 | 1 | 55 | 2640.0 | 0.0 | 50.29 | 62.86 | 62.86 | 0.0 | 2640.0 | INR | 0.0 | 0.33 | 0.0 | 4 | 12545 | 2026-04-10 09:52:53 | 0 | NULL | 1 | 2026-04-10 12:50:32 | 12517 | 1 | 2026-04-10 12:50:32 | ||
| 859 | 1079 | POFN-2069 | INVFN-2069 | 12542 | 12517 | 2 | 1 | 3 | 846.0 | 0.0 | 16.11 | 20.14 | 20.14 | 0.0 | 846.0 | INR | 0.0 | 0.1 | 0.0 | 4 | 12542 | 2026-04-10 09:59:45 | 0 | NULL | 1 | 2026-04-10 12:50:39 | 12517 | 1 | 2026-04-10 12:50:39 | ||
| 860 | 1080 | POFN-2070 | INVFN-2070 | 12526 | 12517 | 2 | 1 | 6 | 4827.0 | 0.0 | 87.52 | 225.52 | 225.52 | 0.0 | 4827.0 | INR | 0.0 | 0.1 | 0.0 | 4 | 12526 | 2026-04-10 20:48:50 | 0 | NULL | 1 | 2026-04-10 21:05:51 | 12517 | 1 | 2026-04-10 21:05:51 | ||
| 861 | 1081 | POFN-2071 | INVFN-2071 | 12545 | 12517 | 2 | 1 | 56 | 5039.0 | 0.0 | 95.98 | 119.98 | 119.98 | 0.0 | 5039.0 | INR | 0.0 | 0.18 | 0.0 | 4 | 12545 | 2026-04-11 17:22:51 | 0 | NULL | 1 | 2026-04-11 17:25:02 | 12517 | 1 | 2026-04-11 17:25:02 | ||
| 862 | 1082 | POFN-2072 | INVFN-2072 | 12548 | 12517 | 2 | 1 | 31 | 1612.0 | 0.0 | 30.7 | 38.38 | 38.38 | 0.0 | 1612.0 | INR | 620.0 | 620.19 | 620.0 | 4 | 12548 | 2026-04-13 22:58:25 | 0 | NULL | 1 | 2026-04-16 17:15:49 | 12517 | 1 | 2026-04-16 17:15:50 | ||
| 863 | 1083 | POFN-2073 | INVFN-2073 | 12516 | 1 | 2 | 1 | 37 | 395900.0 | 0.0 | 30163.81 | 9426.19 | 9426.19 | 0.0 | 395900.0 | INR | 197950.0 | 198024.0 | 197950.0 | 4 | 12516 | 2026-04-14 11:43:44 | 0 | NULL | 1 | 2026-04-14 11:43:53 | 1 | 1 | 2026-04-14 11:43:53 | ||
| 864 | 1084 | POFN-2074 | INVFN-2074 | 12517 | 12516 | 2 | 1 | 50 | 10000.0 | 0.0 | 508.47 | 0.0 | 0.0 | 1525.42 | 10000.0 | INR | 5000.0 | 5001.25 | 5000.0 | 4 | 12517 | 2026-04-16 16:49:00 | 0 | NULL | 1 | 2026-04-16 16:49:37 | 12516 | 1 | 2026-04-16 16:49:37 | ||
| 865 | 1085 | POFN-2075 | INVFN-2075 | 12546 | 12517 | 2 | 1 | 74 | 21900.0 | 0.0 | 411.35 | 666.22 | 666.22 | 0.0 | 21900.0 | INR | 10275.0 | 10276.75 | 10275.0 | 4 | 12546 | 2026-04-16 18:27:52 | 0 | NULL | 1 | 2026-04-16 18:33:03 | 12517 | 1 | 2026-04-16 18:33:04 | ||
| 866 | 1086 | POFN-2076 | INVFN-2076 | 14902 | 12517 | 2 | 1 | 93 | 16171.0 | 0.0 | 303.61 | 495.36 | 495.36 | 0.0 | 16171.0 | INR | 7399.0 | 7399.25 | 7399.0 | 4 | 14902 | 2026-04-17 14:32:34 | 0 | NULL | 1 | 2026-04-17 14:35:26 | 12517 | 1 | 2026-04-17 14:35:26 | ||
| 867 | 1087 | POFN-2077 | INVFN-2077 | 12517 | 12516 | 2 | 1 | 10 | 107000.0 | 0.0 | 6114.29 | 0.0 | 0.0 | 5095.24 | 107000.0 | INR | 53500.0 | 53520.0 | 53500.0 | 4 | 12517 | 2026-04-18 15:47:56 | 0 | NULL | 1 | 2026-04-18 15:48:07 | 12516 | 1 | 2026-04-18 15:48:07 | ||
| 868 | 1088 | POFN-2078 | INVFN-2078 | 12516 | 1 | 2 | 1 | 50 | 125000.0 | 0.0 | 9708.74 | 1820.39 | 1820.39 | 0.0 | 125000.0 | INR | 62500.0 | 62525.0 | 62500.0 | 4 | 12516 | 2026-04-18 17:22:29 | 0 | NULL | 1 | 2026-04-18 17:22:41 | 1 | 1 | 2026-04-18 17:22:41 | ||
| 869 | 1089 | POFN-2079 | INVFN-2079 | 12554 | 12516 | 2 | 1 | 20 | 50000.0 | 0.0 | 2912.62 | 728.16 | 728.16 | 0.0 | 50000.0 | INR | 25000.0 | 25010.0 | 25000.0 | 4 | 12554 | 2026-04-18 17:24:01 | 0 | NULL | 1 | 2026-04-18 17:24:19 | 12516 | 1 | 2026-04-18 17:24:19 | ||
| 870 | 1090 | POFN-2080 | INVFN-2080 | 12555 | 12554 | 2 | 1 | 10 | 25000.0 | 0.0 | 485.44 | 364.08 | 364.08 | 0.0 | 25000.0 | INR | 12500.0 | 12505.0 | 12500.0 | 4 | 12555 | 2026-04-18 17:24:42 | 0 | NULL | 1 | 2026-04-18 17:24:53 | 12554 | 1 | 2026-04-18 17:24:53 | ||
| 871 | 1091 | POFN-2081 | INVFN-2081 | 12554 | 12516 | 2 | 1 | 15 | 24000.0 | 0.0 | 1371.43 | 571.43 | 571.43 | 0.0 | 24000.0 | INR | 12000.0 | 12003.75 | 12000.0 | 4 | 12554 | 2026-04-18 18:20:00 | 0 | NULL | 1 | 2026-04-18 18:20:11 | 12516 | 1 | 2026-04-18 18:20:11 | ||
| 872 | 1092 | POFN-2082 | INVFN-2082 | 12555 | 12554 | 2 | 1 | 10 | 16000.0 | 0.0 | 304.76 | 380.95 | 380.95 | 0.0 | 16000.0 | INR | 8000.0 | 8002.5 | 8000.0 | 4 | 12555 | 2026-04-18 18:21:42 | 0 | NULL | 1 | 2026-04-18 18:21:57 | 12554 | 1 | 2026-04-18 18:21:57 | ||
| 873 | 1093 | POFN-2083 | INVFN-2083 | 12555 | 12554 | 2 | 1 | 5 | 3750.0 | 0.0 | 71.43 | 89.29 | 89.29 | 0.0 | 3750.0 | INR | 1875.0 | 1875.5 | 1875.0 | 4 | 12555 | 2026-04-18 18:27:23 | 0 | NULL | 1 | 2026-04-18 18:28:02 | 12554 | 1 | 2026-04-18 18:28:02 | ||
| 874 | 1095 | POFN-2084 | INVFN-2084 | 12526 | 12517 | 2 | 1 | 46 | 13184.0 | 0.0 | 229.75 | 848.17 | 848.17 | 0.0 | 13184.0 | INR | 5868.0 | 5868.6 | 5868.0 | 4 | 12526 | 2026-04-20 13:57:13 | 0 | NULL | 1 | 2026-04-20 14:09:02 | 12517 | 1 | 2026-04-20 14:09:02 | ||
| 875 | 1096 | POFN-2085 | INVFN-2085 | 12555 | 12554 | 2 | 1 | 4 | 10000.0 | 0.0 | 194.17 | 145.63 | 145.63 | 0.0 | 10000.0 | INR | 5000.0 | 5002.0 | 5000.0 | 4 | 12555 | 2026-04-20 19:40:03 | 0 | NULL | 1 | 2026-04-20 19:40:49 | 12554 | 1 | 2026-04-20 19:40:49 | ||
| 876 | 1097 | POFN-2086 | INVFN-2086 | 12555 | 12554 | 2 | 1 | 4 | 10000.0 | 0.0 | 194.17 | 145.63 | 145.63 | 0.0 | 10000.0 | INR | 5000.0 | 5002.0 | 5000.0 | 4 | 12555 | 2026-04-20 22:37:30 | 0 | NULL | 1 | 2026-04-20 22:39:42 | 12554 | 1 | 2026-04-20 22:39:42 | ||
| 877 | 1098 | POFN-2087 | INVFN-2087 | 12555 | 12554 | 2 | 1 | 2 | 5000.0 | 0.0 | 97.09 | 72.82 | 72.82 | 0.0 | 5000.0 | INR | 2500.0 | 2501.0 | 2500.0 | 4 | 12555 | 2026-04-20 22:55:05 | 0 | NULL | 1 | 2026-04-20 23:05:42 | 12554 | 1 | 2026-04-20 23:05:42 | ||
| 878 | 1099 | POFN-2088 | INVFN-2088 | 12516 | 1 | 2 | 1 | 20 | 50000.0 | 0.0 | 3883.5 | 728.16 | 728.16 | 0.0 | 50000.0 | INR | 25000.0 | 25010.0 | 25000.0 | 4 | 12516 | 2026-04-20 23:01:59 | 0 | NULL | 1 | 2026-04-20 23:02:54 | 1 | 1 | 2026-04-20 23:02:54 | ||
| 879 | 1100 | POFN-2089 | INVFN-2089 | 12554 | 12516 | 2 | 1 | 10 | 25000.0 | 0.0 | 1456.31 | 364.08 | 364.08 | 0.0 | 25000.0 | INR | 12500.0 | 12505.0 | 12500.0 | 4 | 12554 | 2026-04-20 23:07:34 | 0 | NULL | 1 | 2026-04-20 23:08:30 | 12516 | 1 | 2026-04-20 23:08:30 | ||
| 880 | 1101 | POFN-2090 | INVFN-2090 | 12534 | 12517 | 2 | 1 | 2 | 2880.0 | 0.0 | 54.86 | 68.57 | 68.57 | 0.0 | 2880.0 | INR | 1440.0 | 1440.4 | 1440.0 | 4 | 12534 | 2026-04-22 18:46:06 | 0 | NULL | 1 | 2026-04-22 20:06:04 | 12517 | 1 | 2026-04-22 20:06:04 | ||
| 881 | 1102 | POFN-2091 | INVFN-2091 | 12526 | 12517 | 2 | 1 | 8 | 416.0 | 0.0 | 7.92 | 9.9 | 9.9 | 0.0 | 416.0 | INR | 160.0 | 160.05 | 160.0 | 4 | 12526 | 2026-04-22 19:06:56 | 0 | NULL | 1 | 2026-04-22 20:06:04 | 12517 | 1 | 2026-04-22 20:06:04 | ||
| 882 | 1103 | POFN-2092 | INVFN-2092 | 12545 | 12517 | 2 | 1 | 40 | 8721.0 | 0.0 | 158.52 | 397.61 | 397.61 | 0.0 | 8721.0 | INR | 3735.0 | 3735.25 | 3735.0 | 4 | 12545 | 2026-04-23 14:35:45 | 0 | NULL | 1 | 2026-04-23 18:51:23 | 12517 | 1 | 2026-04-23 18:51:23 | ||
| 883 | 1104 | POFN-2093 | INVFN-2093 | 12516 | 1 | 2 | 1 | 5 | 53500.0 | 0.0 | 4076.19 | 1273.81 | 1273.81 | 0.0 | 53500.0 | INR | 26750.0 | 26760.0 | 26750.0 | 4 | 12516 | 2026-04-24 15:23:28 | 0 | NULL | 1 | 2026-04-24 15:24:10 | 1 | 1 | 2026-04-24 15:24:10 | ||
| 884 | 1105 | POFN-2094 | INVFN-2094 | 12554 | 12516 | 2 | 1 | 5 | 53500.0 | 0.0 | 3057.14 | 1273.81 | 1273.81 | 0.0 | 53500.0 | INR | 26750.0 | 26760.0 | 26750.0 | 4 | 12554 | 2026-04-24 15:27:44 | 0 | NULL | 1 | 2026-04-24 15:29:35 | 12516 | 1 | 2026-04-24 15:29:35 | ||
| 885 | 1106 | POFN-2095 | INVFN-2095 | 12555 | 12554 | 2 | 1 | 3 | 32100.0 | 0.0 | 611.43 | 764.29 | 764.29 | 0.0 | 32100.0 | INR | 16050.0 | 16056.0 | 16050.0 | 4 | 12555 | 2026-04-24 15:30:32 | 0 | NULL | 1 | 2026-04-24 15:31:08 | 12554 | 1 | 2026-04-24 15:31:08 | ||
| 886 | 1107 | POFN-2096 | INVFN-2096 | 12554 | 12516 | 2 | 1 | 5 | 8250.0 | 0.0 | 471.43 | 196.43 | 196.43 | 0.0 | 8250.0 | INR | 4000.0 | 4001.25 | 4000.0 | 4 | 12554 | 2026-04-24 15:32:24 | 0 | NULL | 1 | 2026-04-24 15:32:49 | 12516 | 1 | 2026-04-24 15:32:49 | ||
| 887 | 1108 | POFN-2097 | INVFN-2097 | 12555 | 12554 | 2 | 1 | 5 | 8250.0 | 0.0 | 157.14 | 196.43 | 196.43 | 0.0 | 8250.0 | INR | 4000.0 | 4001.25 | 4000.0 | 4 | 12555 | 2026-04-24 15:34:12 | 0 | NULL | 1 | 2026-04-24 15:34:43 | 12554 | 1 | 2026-04-24 15:34:43 | ||
| 888 | 1109 | POFN-2098 | INVFN-2098 | 12516 | 1 | 2 | 1 | 10 | 200000.0 | 0.0 | 14678.9 | 8256.88 | 8256.88 | 0.0 | 200000.0 | INR | 10000.0 | 10010.0 | 10000.0 | 4 | 12516 | 2026-04-24 19:47:26 | 0 | NULL | 1 | 2026-04-24 19:48:03 | 1 | 1 | 2026-04-24 19:48:03 | ||
| 889 | 1110 | POFN-2099 | INVFN-2099 | 12554 | 12516 | 2 | 1 | 10 | 200000.0 | 0.0 | 11009.17 | 8256.88 | 8256.88 | 0.0 | 200000.0 | INR | 10000.0 | 10010.0 | 10000.0 | 4 | 12554 | 2026-04-24 19:49:37 | 0 | NULL | 1 | 2026-04-24 19:50:19 | 12516 | 1 | 2026-04-24 19:50:19 | ||
| 890 | 1111 | POFN-2100 | INVFN-2100 | 12555 | 12554 | 2 | 1 | 10 | 200000.0 | 0.0 | 3669.72 | 8256.88 | 8256.88 | 0.0 | 200000.0 | INR | 10000.0 | 10010.0 | 10000.0 | 4 | 12555 | 2026-04-24 19:54:20 | 0 | NULL | 1 | 2026-04-27 16:25:03 | 12554 | 1 | 2026-04-27 16:25:03 | ||
| 891 | 1112 | POFN-2101 | INVFN-2101 | 12526 | 12517 | 2 | 1 | 34 | 7869.0 | 0.0 | 146.53 | 271.3 | 271.3 | 0.0 | 7869.0 | INR | 3810.0 | 3810.5 | 3810.0 | 4 | 12526 | 2026-04-24 22:11:22 | 0 | NULL | 1 | 2026-04-24 22:14:23 | 12517 | 1 | 2026-04-24 22:14:23 | ||
| 892 | 1113 | POFN-2102 | INVFN-2102 | 12545 | 12517 | 2 | 1 | 4 | 4800.0 | 0.0 | 91.43 | 114.29 | 114.29 | 0.0 | 4800.0 | INR | 2400.0 | 2400.5 | 2400.0 | 4 | 12545 | 2026-04-27 08:50:05 | 0 | NULL | 1 | 2026-04-27 16:24:29 | 12517 | 1 | 2026-04-27 16:24:29 | ||
| 893 | 1114 | POFN-2103 | INVFN-2103 | 12532 | 12517 | 2 | 1 | 12 | 13490.0 | 0.0 | 256.95 | 321.19 | 321.19 | 0.0 | 13490.0 | INR | 6745.0 | 6745.75 | 6745.0 | 4 | 12532 | 2026-04-27 19:51:57 | 0 | NULL | 1 | 2026-04-28 14:33:10 | 12517 | 1 | 2026-04-28 14:33:10 | ||
| 894 | 1115 | POFN-2104 | INVFN-2104 | 12539 | 12517 | 2 | 1 | 1 | 1600.0 | 0.0 | 30.48 | 38.1 | 38.1 | 0.0 | 1600.0 | INR | 800.0 | 800.25 | 800.0 | 4 | 12539 | 2026-04-28 15:41:58 | 0 | NULL | 1 | 2026-04-28 16:39:24 | 12517 | 1 | 2026-04-28 16:39:24 | ||
| 895 | 1116 | POFN-2105 | INVFN-2105 | 12545 | 12517 | 2 | 1 | 1 | 18500.0 | 0.0 | 352.38 | 440.48 | 440.48 | 0.0 | 18500.0 | INR | 9250.0 | 9253.75 | 9250.0 | 4 | 12545 | 2026-04-28 15:48:13 | 0 | NULL | 2 | 2026-04-28 16:39:35 | 12517 | 0 | NULL | ||
| 896 | 1117 | POFN-2106 | INVFN-2106 | 12545 | 12517 | 2 | 1 | 3 | 3120.0 | 0.0 | 59.43 | 74.29 | 74.29 | 0.0 | 3120.0 | INR | 1560.0 | 1560.25 | 1560.0 | 4 | 12545 | 2026-04-28 15:49:15 | 0 | NULL | 1 | 2026-04-28 16:39:25 | 12517 | 1 | 2026-04-28 16:39:25 | ||
| 897 | 1118 | POFN-2107 | INVFN-2107 | 12516 | 1 | 2 | 1 | 101 | 20604.0 | 0.0 | 1569.83 | 490.57 | 490.57 | 0.0 | 20604.0 | INR | 10302.0 | 10306.04 | 10302.0 | 4 | 12516 | 2026-04-28 16:01:08 | 0 | NULL | 1 | 2026-04-28 16:03:05 | 1 | 1 | 2026-04-28 16:03:05 | ||
| 898 | 1119 | POFN-2108 | INVFN-2108 | 12516 | 1 | 2 | 1 | 100 | 20400.0 | 0.0 | 1554.29 | 485.71 | 485.71 | 0.0 | 20400.0 | INR | 10200.0 | 10204.0 | 10200.0 | 4 | 12516 | 2026-04-28 16:04:14 | 0 | NULL | 1 | 2026-04-30 16:46:48 | 1 | 1 | 2026-04-30 16:46:48 | ||
| 899 | 1120 | POFN-2109 | INVFN-2109 | 12517 | 12516 | 2 | 1 | 100 | 20400.0 | 0.0 | 1165.71 | 0.0 | 0.0 | 971.43 | 20400.0 | INR | 10200.0 | 10204.0 | 10200.0 | 4 | 12517 | 2026-04-28 16:07:51 | 0 | NULL | 1 | 2026-04-28 16:08:14 | 12516 | 1 | 2026-04-28 16:08:14 | ||
| 900 | 1121 | POFN-2110 | INVFN-2110 | 12539 | 12517 | 2 | 1 | 3 | 3404.0 | 0.0 | 64.84 | 81.05 | 81.05 | 0.0 | 3404.0 | INR | 1702.0 | 1702.04 | 1702.0 | 4 | 12539 | 2026-04-28 16:11:34 | 0 | NULL | 1 | 2026-04-28 16:35:46 | 12517 | 1 | 2026-04-28 16:35:46 |