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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 151 | 161 | POF-1151 | INVF-1151 | 12529 | 12517 | 2 | 2 | 2 | 20998.0 | 0.0 | 419.96 | 499.95 | 499.95 | 0.0 | 20578.04 | INR | 0.0 | 7000.0 | 0.0 | 4 | 12529 | 2025-11-11 15:12:47 | 0 | NULL | 1 | 2025-11-11 16:09:56 | 12517 | 0 | NULL | ||
| 152 | 162 | POF-1152 | INVF-1152 | 12521 | 12517 | 2 | 2 | 1 | 18000.0 | 0.0 | 360.0 | 428.57 | 428.57 | 0.0 | 17640.0 | INR | 0.0 | 7500.0 | 0.0 | 4 | 12521 | 2025-11-11 15:19:45 | 0 | NULL | 1 | 2025-11-11 19:50:46 | 12517 | 0 | NULL | ||
| 153 | 163 | POF-1153 | INVF-1153 | 12517 | 12516 | 2 | 2 | 5 | 45994.4 | 0.0 | 2299.72 | 0.0 | 0.0 | 2190.21 | 43694.68 | INR | 0.0 | 14000.0 | 0.0 | 4 | 12517 | 2025-11-11 15:51:34 | 0 | NULL | 1 | 2025-11-11 16:08:23 | 12516 | 0 | NULL | ||
| 154 | 164 | POF-1154 | INVF-1154 | 12532 | 12517 | 2 | 2 | 3 | 31497.0 | 0.0 | 629.94 | 749.93 | 749.93 | 0.0 | 30867.06 | INR | 0.0 | 10500.0 | 0.0 | 4 | 12532 | 2025-11-11 15:59:25 | 0 | NULL | 1 | 2025-11-11 16:09:56 | 12517 | 0 | NULL | ||
| 155 | 165 | POF-1155 | INVF-1155 | 12544 | 12517 | 2 | 2 | 1 | 10499.0 | 0.0 | 209.98 | 249.97 | 249.97 | 0.0 | 10289.02 | INR | 0.0 | 3500.0 | 0.0 | 4 | 12544 | 2025-11-11 16:17:48 | 0 | NULL | 1 | 2025-11-11 21:41:19 | 12517 | 0 | NULL | ||
| 156 | 166 | POF-1156 | INVF-1156 | 12517 | 12516 | 2 | 2 | 6 | 86497.0 | 0.0 | 4324.85 | 0.0 | 0.0 | 4118.9 | 82172.15 | INR | 0.0 | 10500.0 | 0.0 | 4 | 12517 | 2025-11-11 16:18:14 | 0 | NULL | 1 | 2025-11-11 19:47:04 | 12516 | 0 | NULL | ||
| 157 | 167 | POF-1157 | INVF-1157 | 12555 | 12554 | 2 | 1 | 102 | 69855.8 | 0.0 | 1397.12 | 2140.3 | 2140.3 | 0.0 | 68458.68 | INR | 22970.0 | 22970.0 | 23550.0 | 4 | 12555 | 2025-11-11 16:30:18 | 0 | NULL | 2 | 2025-11-12 08:23:36 | 12554 | 0 | NULL | ||
| 158 | 168 | POF-1158 | INVF-1158 | 12555 | 12554 | 2 | 1 | 54 | 21302.4 | 0.0 | 426.05 | 677.6 | 677.6 | 0.0 | 20876.35 | INR | 7755.0 | 7755.0 | 8155.0 | 4 | 12555 | 2025-11-11 16:34:35 | 0 | NULL | 2 | 2025-11-12 08:23:36 | 12554 | 0 | NULL | ||
| 159 | 169 | POF-1159 | INVF-1159 | 12516 | 1 | 2 | 2 | 5 | 90000.0 | 0.0 | 7200.0 | 2142.86 | 2142.86 | 0.0 | 82800.0 | INR | 0.0 | 37500.0 | 0.0 | 4 | 12516 | 2025-11-11 16:40:11 | 0 | NULL | 1 | 2025-11-11 19:46:45 | 1 | 0 | NULL | ||
| 160 | 170 | POF-1160 | INVF-1160 | 12555 | 12554 | 2 | 1 | 55 | 42272.8 | 0.0 | 845.46 | 1252.9 | 1252.9 | 0.0 | 41427.34 | INR | 14505.0 | 14505.0 | 14865.0 | 4 | 12555 | 2025-11-11 16:42:11 | 0 | NULL | 2 | 2025-11-12 08:23:36 | 12554 | 0 | NULL | ||
| 161 | 171 | POF-1161 | INVF-1161 | 12555 | 12554 | 2 | 1 | 100 | 4800.0 | 0.0 | 96.0 | 114.28 | 114.28 | 0.0 | 4704.0 | INR | 1000.0 | 1000.0 | 1300.0 | 4 | 12555 | 2025-11-11 16:48:11 | 0 | NULL | 2 | 2025-11-12 08:23:36 | 12554 | 0 | NULL | ||
| 162 | 172 | POF-1162 | INVF-1162 | 12555 | 12554 | 2 | 1 | 2 | 408.0 | 0.0 | 8.16 | 9.71 | 9.71 | 0.0 | 399.84 | INR | 108.0 | 108.0 | 206.0 | 4 | 12555 | 2025-11-11 16:49:07 | 0 | NULL | 2 | 2025-11-12 08:23:36 | 12554 | 0 | NULL | ||
| 163 | 173 | POF-1163 | INVF-1163 | 12546 | 12517 | 2 | 2 | 2 | 20998.0 | 0.0 | 419.96 | 499.95 | 499.95 | 0.0 | 20578.04 | INR | 0.0 | 7000.0 | 0.0 | 4 | 12546 | 2025-11-11 17:01:10 | 0 | NULL | 1 | 2025-11-11 19:09:41 | 12517 | 0 | NULL | ||
| 164 | 174 | POF-1164 | INVF-1164 | 12532 | 12517 | 2 | 1 | 39 | 10985.6 | 0.0 | 219.71 | 510.87 | 510.87 | 0.0 | 10765.89 | INR | 3820.0 | 3820.0 | 3940.0 | 4 | 12532 | 2025-11-11 17:02:00 | 0 | NULL | 1 | 2025-11-12 15:26:01 | 12517 | 0 | NULL | ||
| 165 | 175 | POF-1165 | INVF-1165 | 12555 | 12554 | 2 | 1 | 212 | 125779.2 | 0.0 | 2515.58 | 4139.13 | 4139.13 | 0.0 | 123263.62 | INR | 42966.0 | 42966.0 | 43356.0 | 4 | 12555 | 2025-11-11 17:13:54 | 0 | NULL | 2 | 2025-11-12 08:23:36 | 12554 | 0 | NULL | ||
| 166 | 176 | POF-1166 | INVF-1166 | 12533 | 12517 | 2 | 2 | 3 | 31497.0 | 0.0 | 629.94 | 749.93 | 749.93 | 0.0 | 30867.06 | INR | 0.0 | 10500.0 | 0.0 | 4 | 12533 | 2025-11-11 17:29:50 | 0 | NULL | 1 | 2025-11-11 19:50:46 | 12517 | 0 | NULL | ||
| 167 | 177 | POF-1167 | INVF-1167 | 12554 | 12516 | 2 | 1 | 8281 | 3475763.2 | 0.0 | 173788.16 | 115190.1 | 115190.1 | 0.0 | 3301975.04 | INR | 1252625.0 | 1252625.0 | 1258625.0 | 4 | 12554 | 2025-11-11 18:31:23 | 0 | NULL | 2 | 2025-11-11 23:06:07 | 12516 | 0 | NULL | ||
| 168 | 178 | POF-1168 | INVF-1168 | 12516 | 1 | 2 | 2 | 10 | 180000.0 | 0.0 | 14400.0 | 4285.72 | 4285.72 | 0.0 | 165600.0 | INR | 0.0 | 75000.0 | 0.0 | 4 | 12516 | 2025-11-11 19:45:48 | 0 | NULL | 1 | 2025-11-11 19:46:01 | 1 | 0 | NULL | ||
| 169 | 179 | POF-1169 | INVF-1169 | 12516 | 1 | 2 | 1 | 7192 | 2423674.4 | 0.0 | 193893.95 | 87779.21 | 87779.21 | 0.0 | 2229780.45 | INR | 835005.0 | 835005.0 | 841005.0 | 4 | 12516 | 2025-11-11 20:02:12 | 0 | NULL | 2 | 2025-11-11 21:20:01 | 1 | 0 | NULL | ||
| 170 | 180 | POF-1170 | INVF-1170 | 12516 | 1 | 2 | 1 | 7192 | 2423674.4 | 0.0 | 193893.95 | 87779.21 | 87779.21 | 0.0 | 2229780.45 | INR | 835005.0 | 835005.0 | 841005.0 | 4 | 12516 | 2025-11-11 20:02:13 | 0 | NULL | 2 | 2025-11-11 21:20:01 | 1 | 0 | NULL | ||
| 171 | 181 | POF-1171 | INVF-1171 | 12517 | 12516 | 2 | 2 | 5 | 71697.0 | 0.0 | 3584.85 | 0.0 | 0.0 | 4851.48 | 68112.15 | INR | 0.0 | 7000.0 | 0.0 | 4 | 12517 | 2025-11-11 20:02:56 | 0 | NULL | 1 | 2025-11-11 21:38:49 | 12516 | 0 | NULL | ||
| 172 | 182 | POF-1172 | INVF-1172 | 12516 | 1 | 2 | 1 | 160 | 222730.0 | 0.0 | 17818.4 | 6100.51 | 6100.51 | 0.0 | 204911.6 | INR | 75500.0 | 75500.0 | 78500.0 | 4 | 12516 | 2025-11-11 21:16:03 | 0 | NULL | 1 | 2025-11-11 21:17:45 | 1 | 0 | NULL | ||
| 173 | 183 | POF-1173 | INVF-1173 | 12516 | 1 | 2 | 1 | 2600 | 238240.0 | 0.0 | 19059.2 | 11455.75 | 11455.75 | 0.0 | 219180.8 | INR | 81500.0 | 81500.0 | 83000.0 | 4 | 12516 | 2025-11-11 21:22:38 | 0 | NULL | 1 | 2025-11-11 21:22:51 | 1 | 0 | NULL | ||
| 174 | 184 | POF-1174 | INVF-1174 | 12554 | 12516 | 2 | 1 | 2500 | 222320.0 | 0.0 | 11116.0 | 10241.51 | 10241.51 | 0.0 | 211204.0 | INR | 77000.0 | 77000.0 | 78500.0 | 4 | 12554 | 2025-11-11 21:26:19 | 0 | NULL | 1 | 2025-11-11 21:30:09 | 12516 | 0 | NULL | ||
| 175 | 185 | POF-1175 | INVF-1175 | 12555 | 12554 | 2 | 1 | 2500 | 222320.0 | 0.0 | 4446.4 | 10241.51 | 10241.51 | 0.0 | 217873.6 | INR | 77000.0 | 77000.0 | 78500.0 | 4 | 12555 | 2025-11-11 21:28:36 | 0 | NULL | 1 | 2025-11-11 21:31:05 | 12554 | 0 | NULL | ||
| 176 | 186 | POF-1176 | INVF-1176 | 12526 | 12517 | 2 | 2 | 5 | 45994.4 | 0.0 | 919.89 | 1095.11 | 1095.11 | 0.0 | 45074.51 | INR | 0.0 | 14000.0 | 0.0 | 4 | 12526 | 2025-11-11 21:28:53 | 0 | NULL | 1 | 2025-11-12 14:11:25 | 12517 | 0 | NULL | ||
| 177 | 187 | POF-1177 | INVF-1177 | 12555 | 12554 | 2 | 2 | 1 | 18500.0 | 0.0 | 370.0 | 440.48 | 440.48 | 0.0 | 18130.0 | INR | 0.0 | 7500.0 | 0.0 | 4 | 12555 | 2025-11-11 21:41:34 | 0 | NULL | 2 | 2025-11-12 08:23:36 | 12554 | 0 | NULL | ||
| 178 | 188 | POF-1178 | INVF-1178 | 12516 | 1 | 2 | 2 | 41 | 484964.0 | 0.0 | 38797.12 | 18733.48 | 18733.48 | 0.0 | 446166.88 | INR | 0.0 | 35000.0 | 0.0 | 4 | 12516 | 2025-11-11 21:43:20 | 0 | NULL | 1 | 2025-11-11 21:43:43 | 1 | 0 | NULL | ||
| 179 | 189 | POF-1179 | INVF-1179 | 12554 | 12516 | 2 | 2 | 1 | 18500.0 | 0.0 | 925.0 | 440.48 | 440.48 | 0.0 | 17575.0 | INR | 0.0 | 7500.0 | 0.0 | 4 | 12554 | 2025-11-11 21:47:33 | 0 | NULL | 1 | 2025-11-11 21:48:04 | 12516 | 0 | NULL | ||
| 180 | 190 | POF-1180 | INVF-1180 | 12516 | 1 | 2 | 1 | 6311 | 1416463.6 | 0.0 | 113317.09 | 51798.28 | 51798.28 | 0.0 | 1303146.51 | INR | 488970.0 | 488970.0 | 491370.0 | 4 | 12516 | 2025-11-11 22:11:56 | 0 | NULL | 1 | 2025-11-11 22:34:56 | 1 | 0 | NULL | ||
| 181 | 191 | POF-1181 | INVF-1181 | 12516 | 1 | 2 | 1 | 6311 | 1420929.2 | 0.0 | 113674.34 | 51611.24 | 51611.24 | 0.0 | 1307254.86 | INR | 489870.0 | 489870.0 | 492270.0 | 4 | 12516 | 2025-11-11 23:32:11 | 0 | NULL | 2 | 2025-11-12 17:47:21 | 1 | 0 | NULL | ||
| 182 | 192 | POF-1182 | INVF-1182 | 12554 | 12516 | 2 | 1 | 6302 | 1418888.8 | 0.0 | 70944.44 | 51856.01 | 51856.01 | 0.0 | 1347944.36 | INR | 493920.0 | 493920.0 | 496320.0 | 4 | 12554 | 2025-11-11 23:58:07 | 0 | NULL | 1 | 2025-11-12 08:49:54 | 12516 | 0 | NULL | ||
| 183 | 193 | POF-1183 | INVF-1183 | 12552 | 12517 | 2 | 2 | 3 | 42698.0 | 0.0 | 853.96 | 1735.29 | 1735.29 | 0.0 | 41844.04 | INR | 0.0 | 3500.0 | 0.0 | 4 | 12552 | 2025-11-12 00:14:12 | 0 | NULL | 1 | 2025-11-12 00:14:54 | 12517 | 0 | NULL | ||
| 184 | 194 | POF-1184 | INVF-1184 | 12554 | 12516 | 2 | 2 | 260 | 3044820.0 | 0.0 | 152241.0 | 108429.34 | 108429.34 | 0.0 | 2892579.0 | INR | 0.0 | 175000.0 | 0.0 | 4 | 12554 | 2025-11-12 06:38:52 | 0 | NULL | 1 | 2025-11-12 06:56:39 | 12516 | 0 | NULL | ||
| 185 | 195 | POF-1185 | INVF-1185 | 12555 | 12554 | 2 | 2 | 240 | 2832820.0 | 0.0 | 56656.4 | 103381.71 | 103381.71 | 0.0 | 2776163.6 | INR | 0.0 | 105000.0 | 0.0 | 4 | 12555 | 2025-11-12 06:59:00 | 0 | NULL | 1 | 2025-11-12 07:00:16 | 12554 | 0 | NULL | ||
| 186 | 196 | POF-1186 | INVF-1186 | 12516 | 1 | 2 | 1 | 15 | 30000.0 | 0.0 | 2400.0 | 714.28 | 714.28 | 0.0 | 27600.0 | INR | 12000.0 | 12000.0 | 15000.0 | 4 | 12516 | 2025-11-12 08:29:53 | 0 | NULL | 1 | 2025-11-12 08:30:10 | 1 | 0 | NULL | ||
| 187 | 197 | POF-1187 | INVF-1187 | 12516 | 1 | 2 | 1 | 10 | 20000.0 | 0.0 | 1600.0 | 476.19 | 476.19 | 0.0 | 18400.0 | INR | 8000.0 | 8000.0 | 10000.0 | 4 | 12516 | 2025-11-12 08:45:26 | 0 | NULL | 1 | 2025-11-12 08:46:42 | 1 | 0 | NULL | ||
| 188 | 198 | POF-1188 | INVF-1188 | 12554 | 12516 | 2 | 1 | 6183 | 1318368.8 | 0.0 | 65918.44 | 49394.47 | 49394.47 | 0.0 | 1252450.36 | INR | 458515.0 | 458515.0 | 458635.0 | 4 | 12554 | 2025-11-12 09:05:44 | 0 | NULL | 2 | 2025-11-12 16:11:41 | 12516 | 0 | NULL | ||
| 189 | 199 | POF-1189 | INVF-1189 | 12516 | 1 | 2 | 2 | 1 | 13699.0 | 0.0 | 1095.92 | 1044.84 | 1044.84 | 0.0 | 12603.08 | INR | 0.0 | 3000.0 | 0.0 | 4 | 12516 | 2025-11-12 09:53:05 | 0 | NULL | 1 | 2025-11-12 09:53:17 | 1 | 0 | NULL | ||
| 190 | 200 | POF-1190 | INVF-1190 | 12516 | 1 | 2 | 2 | 1 | 18000.0 | 0.0 | 1440.0 | 428.57 | 428.57 | 0.0 | 16560.0 | INR | 0.0 | 7500.0 | 0.0 | 4 | 12516 | 2025-11-12 09:59:48 | 0 | NULL | 1 | 2025-11-12 09:59:58 | 1 | 0 | NULL | ||
| 191 | 201 | POF-1191 | INVF-1191 | 12516 | 1 | 2 | 1 | 2550 | 414280.0 | 0.0 | 33142.4 | 13976.8 | 13976.8 | 0.0 | 381137.6 | INR | 149400.0 | 149400.0 | 150900.0 | 4 | 12516 | 2025-11-12 11:50:42 | 0 | NULL | 1 | 2025-11-12 12:04:42 | 1 | 0 | NULL | ||
| 192 | 202 | POF-1192 | INVF-1192 | 12554 | 12516 | 2 | 1 | 2500 | 406320.0 | 0.0 | 20316.0 | 13787.27 | 13787.27 | 0.0 | 386004.0 | INR | 147400.0 | 147400.0 | 148900.0 | 4 | 12554 | 2025-11-12 12:13:12 | 0 | NULL | 1 | 2025-11-12 12:13:59 | 12516 | 0 | NULL | ||
| 193 | 203 | POF-1193 | INVF-1193 | 12555 | 12554 | 2 | 1 | 2550 | 414280.0 | 0.0 | 8285.6 | 13976.8 | 13976.8 | 0.0 | 405994.4 | INR | 149400.0 | 149400.0 | 150900.0 | 4 | 12555 | 2025-11-12 12:22:06 | 0 | NULL | 2 | 2025-12-11 11:38:07 | 12554 | 0 | NULL | ||
| 194 | 204 | POF-1194 | INVF-1194 | 12516 | 1 | 2 | 1 | 2550 | 414280.0 | 0.0 | 33142.4 | 13976.8 | 13976.8 | 0.0 | 381137.6 | INR | 149400.0 | 149400.0 | 150900.0 | 4 | 12516 | 2025-11-12 12:29:52 | 0 | NULL | 1 | 2025-11-12 12:33:53 | 1 | 0 | NULL | ||
| 195 | 205 | POF-1195 | INVF-1195 | 12554 | 12516 | 2 | 1 | 50 | 7960.0 | 0.0 | 398.0 | 189.53 | 189.53 | 0.0 | 7562.0 | INR | 2000.0 | 2000.0 | 2450.0 | 4 | 12554 | 2025-11-12 12:37:16 | 0 | NULL | 1 | 2025-11-12 12:37:58 | 12516 | 0 | NULL | ||
| 196 | 206 | POF-1196 | INVF-1196 | 12517 | 12516 | 2 | 1 | 1 | 80.0 | 0.0 | 4.0 | 0.0 | 0.0 | 3.81 | 76.0 | INR | 28.0 | 28.0 | 38.0 | 4 | 12517 | 2025-11-12 12:37:41 | 0 | NULL | 1 | 2025-11-12 12:42:27 | 12516 | 0 | NULL | ||
| 197 | 207 | POF-1197 | INVF-1197 | 12517 | 12516 | 2 | 1 | 5516 | 443040.0 | 0.0 | 22152.0 | 0.0 | 0.0 | 37800.94 | 420888.0 | INR | 124200.0 | 124200.0 | 125400.0 | 4 | 12517 | 2025-11-12 12:40:36 | 0 | NULL | 1 | 2025-11-12 13:05:14 | 12516 | 0 | NULL | ||
| 198 | 208 | POF-1198 | INVF-1198 | 12516 | 1 | 2 | 1 | 2000 | 128000.0 | 0.0 | 10240.0 | 3047.61 | 3047.61 | 0.0 | 117760.0 | INR | 38000.0 | 38000.0 | 41000.0 | 4 | 12516 | 2025-11-12 12:44:00 | 0 | NULL | 1 | 2025-11-12 12:44:15 | 1 | 0 | NULL | ||
| 199 | 209 | POF-1199 | INVF-1199 | 12516 | 1 | 2 | 1 | 2000 | 128000.0 | 0.0 | 10240.0 | 3047.61 | 3047.61 | 0.0 | 117760.0 | INR | 38000.0 | 38000.0 | 41000.0 | 4 | 12516 | 2025-11-12 12:45:38 | 0 | NULL | 1 | 2025-11-12 12:51:12 | 1 | 0 | NULL | ||
| 200 | 210 | POF-1200 | INVF-1200 | 12516 | 1 | 2 | 1 | 2500 | 207600.0 | 0.0 | 16608.0 | 9118.8 | 9118.8 | 0.0 | 190992.0 | INR | 60500.0 | 60500.0 | 63500.0 | 4 | 12516 | 2025-11-12 12:53:28 | 0 | NULL | 1 | 2025-11-12 12:54:45 | 1 | 0 | NULL |