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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 251 | 261 | POF-1251 | INVF-1251 | 12552 | 12517 | 2 | 2 | 2 | 37000.0 | 0.0 | 740.0 | 880.95 | 880.95 | 0.0 | 36260.0 | INR | 0.0 | 15000.0 | 0.0 | 4 | 12552 | 2025-11-19 21:38:07 | 0 | NULL | 1 | 2025-11-19 21:39:01 | 12517 | 0 | NULL | ||
| 252 | 262 | POF-1252 | INVF-1252 | 12855 | 12551 | 2 | 1 | 1115 | 56336.0 | 0.0 | 1126.72 | 1516.77 | 1516.77 | 0.0 | 55209.28 | INR | 12140.0 | 12140.0 | 15452.0 | 4 | 12855 | 2025-11-20 12:35:41 | 0 | NULL | 1 | 2025-11-20 12:39:01 | 12551 | 0 | NULL | ||
| 253 | 263 | POF-1253 | INVF-1253 | 12855 | 12551 | 2 | 1 | 20 | 7584.0 | 0.0 | 151.68 | 180.57 | 180.57 | 0.0 | 7432.32 | INR | 2450.0 | 2450.0 | 2540.0 | 4 | 12855 | 2025-11-20 13:59:55 | 0 | NULL | 1 | 2025-11-26 16:40:14 | 12551 | 0 | NULL | ||
| 254 | 264 | POF-1254 | INVF-1254 | 12555 | 12554 | 2 | 1 | 220 | 68912.0 | 0.0 | 1378.24 | 1351.23 | 1351.23 | 0.0 | 67533.76 | INR | 18600.0 | 18600.0 | 22440.0 | 4 | 12555 | 2025-11-20 14:02:23 | 0 | NULL | 1 | 2025-11-20 15:21:39 | 12554 | 0 | NULL | ||
| 255 | 265 | POF-1255 | INVF-1255 | 12554 | 12516 | 2 | 1 | 140 | 32560.0 | 0.0 | 1628.0 | 485.71 | 485.71 | 0.0 | 30932.0 | INR | 7000.0 | 7000.0 | 10840.0 | 4 | 12554 | 2025-11-20 14:04:39 | 0 | NULL | 1 | 2025-11-20 15:21:07 | 12516 | 0 | NULL | ||
| 256 | 266 | POF-1256 | INVF-1256 | 12516 | 1 | 2 | 1 | 100 | 20400.0 | 0.0 | 1632.0 | 485.71 | 485.71 | 0.0 | 18768.0 | INR | 5400.0 | 5400.0 | 10300.0 | 4 | 12516 | 2025-11-20 14:07:37 | 0 | NULL | 1 | 2025-11-20 15:18:58 | 1 | 0 | NULL | ||
| 257 | 267 | POF-1257 | INVF-1257 | 12516 | 1 | 2 | 1 | 40 | 12160.0 | 0.0 | 972.8 | 0.0 | 0.0 | 0.0 | 11187.2 | INR | 1600.0 | 1600.0 | 5440.0 | 4 | 12516 | 2025-11-20 15:20:23 | 0 | NULL | 1 | 2025-11-20 15:20:58 | 1 | 0 | NULL | ||
| 258 | 268 | POF-1258 | INVF-1258 | 12555 | 12554 | 2 | 1 | 20 | 5200.0 | 0.0 | 104.0 | 396.61 | 396.61 | 0.0 | 5096.0 | INR | 1420.0 | 1420.0 | 2720.0 | 4 | 12555 | 2025-11-20 17:46:39 | 0 | NULL | 1 | 2025-11-20 17:46:58 | 12554 | 0 | NULL | ||
| 259 | 269 | POF-1259 | INVF-1259 | 12555 | 12554 | 2 | 1 | 20 | 10384.0 | 0.0 | 207.68 | 247.24 | 247.24 | 0.0 | 10176.32 | INR | 2850.0 | 2850.0 | 4550.0 | 4 | 12555 | 2025-11-20 22:15:12 | 0 | NULL | 1 | 2025-11-20 22:19:33 | 12554 | 0 | NULL | ||
| 260 | 270 | POF-1260 | INVF-1260 | 12517 | 12516 | 2 | 1 | 232 | 129920.0 | 0.0 | 6496.0 | 0.0 | 0.0 | 9742.33 | 123424.0 | INR | 45970.0 | 45970.0 | 46570.0 | 4 | 12517 | 2025-11-20 23:13:55 | 0 | NULL | 1 | 2025-11-21 09:41:39 | 12516 | 0 | NULL | ||
| 261 | 271 | POF-1261 | INVF-1261 | 12517 | 12516 | 2 | 2 | 2 | 37000.0 | 0.0 | 1850.0 | 0.0 | 0.0 | 1761.9 | 35150.0 | INR | 0.0 | 15000.0 | 0.0 | 4 | 12517 | 2025-11-21 07:28:54 | 0 | NULL | 1 | 2025-11-21 08:26:53 | 12516 | 0 | NULL | ||
| 262 | 272 | POF-1262 | INVF-1262 | 12516 | 1 | 2 | 1 | 40 | 22368.0 | 0.0 | 1789.44 | 532.57 | 532.57 | 0.0 | 20578.56 | INR | 6000.0 | 6000.0 | 9600.0 | 4 | 12516 | 2025-11-21 09:33:32 | 0 | NULL | 1 | 2025-11-21 09:33:54 | 1 | 0 | NULL | ||
| 263 | 273 | POF-1263 | INVF-1263 | 12516 | 1 | 2 | 1 | 20 | 23984.0 | 0.0 | 1918.72 | 571.05 | 571.05 | 0.0 | 22065.28 | INR | 9000.0 | 9000.0 | 13000.0 | 4 | 12516 | 2025-11-21 09:40:24 | 0 | NULL | 1 | 2025-11-21 09:40:46 | 1 | 0 | NULL | ||
| 264 | 274 | POF-1264 | INVF-1264 | 12517 | 12516 | 2 | 2 | 14 | 170989.0 | 0.0 | 8549.45 | 0.0 | 0.0 | 8142.34 | 162439.55 | INR | 0.0 | 38500.0 | 0.0 | 4 | 12517 | 2025-11-21 10:36:53 | 0 | NULL | 1 | 2025-11-21 11:25:40 | 12516 | 0 | NULL | ||
| 265 | 275 | POF-1265 | INVF-1265 | 12555 | 12554 | 2 | 1 | 30 | 16776.0 | 0.0 | 335.52 | 1279.53 | 1279.53 | 0.0 | 16440.48 | INR | 7500.0 | 7500.0 | 11100.0 | 4 | 12555 | 2025-11-21 14:42:45 | 0 | NULL | 1 | 2025-11-21 14:46:05 | 12554 | 0 | NULL | ||
| 266 | 276 | POF-1266 | INVF-1266 | 12554 | 12516 | 2 | 1 | 50 | 27960.0 | 0.0 | 1398.0 | 2132.54 | 2132.54 | 0.0 | 26562.0 | INR | 12500.0 | 12500.0 | 18500.0 | 4 | 12554 | 2025-11-21 14:43:41 | 0 | NULL | 1 | 2025-11-21 14:45:40 | 12516 | 0 | NULL | ||
| 267 | 277 | POF-1267 | INVF-1267 | 12516 | 1 | 2 | 1 | 50 | 27960.0 | 0.0 | 2236.8 | 2132.54 | 2132.54 | 0.0 | 25723.2 | INR | 12500.0 | 12500.0 | 18500.0 | 4 | 12516 | 2025-11-21 14:44:50 | 0 | NULL | 1 | 2025-11-21 14:45:09 | 1 | 0 | NULL | ||
| 268 | 278 | POF-1268 | INVF-1268 | 12555 | 12554 | 2 | 2 | 50 | 524950.0 | 0.0 | 10499.0 | 12498.81 | 12498.81 | 0.0 | 514451.0 | INR | 0.0 | 175000.0 | 0.0 | 4 | 12555 | 2025-11-22 13:10:28 | 0 | NULL | 1 | 2025-11-22 13:17:36 | 12554 | 0 | NULL | ||
| 269 | 279 | POF-1269 | INVF-1269 | 12554 | 12516 | 2 | 2 | 50 | 524950.0 | 0.0 | 26247.5 | 12498.81 | 12498.81 | 0.0 | 498702.5 | INR | 0.0 | 175000.0 | 0.0 | 4 | 12554 | 2025-11-22 13:11:20 | 0 | NULL | 1 | 2025-11-22 13:15:22 | 12516 | 0 | NULL | ||
| 270 | 280 | POF-1270 | INVF-1270 | 12516 | 1 | 2 | 2 | 50 | 524950.0 | 0.0 | 41996.0 | 12498.81 | 12498.81 | 0.0 | 482954.0 | INR | 0.0 | 175000.0 | 0.0 | 4 | 12516 | 2025-11-22 13:12:05 | 0 | NULL | 1 | 2025-11-22 13:14:55 | 1 | 0 | NULL | ||
| 271 | 281 | POF-1271 | INVF-1271 | 12516 | 1 | 2 | 2 | 10 | 104990.0 | 0.0 | 8399.2 | 2499.76 | 2499.76 | 0.0 | 96590.8 | INR | 0.0 | 35000.0 | 0.0 | 4 | 12516 | 2025-11-22 13:16:09 | 0 | NULL | 1 | 2025-11-22 13:16:23 | 1 | 0 | NULL | ||
| 272 | 282 | POF-1272 | INVF-1272 | 12555 | 12554 | 2 | 1 | 30 | 22224.0 | 0.0 | 444.48 | 688.63 | 688.63 | 0.0 | 21779.52 | INR | 8000.0 | 8000.0 | 10000.0 | 4 | 12555 | 2025-11-23 14:13:16 | 0 | NULL | 1 | 2025-11-23 14:16:50 | 12554 | 0 | NULL | ||
| 273 | 283 | POF-1273 | INVF-1273 | 12555 | 12554 | 2 | 1 | 10 | 11992.0 | 0.0 | 239.84 | 285.52 | 285.52 | 0.0 | 11752.16 | INR | 2500.0 | 2500.0 | 4750.0 | 4 | 12555 | 2025-11-24 11:59:58 | 0 | NULL | 1 | 2025-11-24 12:00:16 | 12554 | 0 | NULL | ||
| 274 | 284 | POF-1274 | INVF-1274 | 12552 | 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 | 12552 | 2025-11-24 15:08:20 | 0 | NULL | 1 | 2025-11-24 15:23:02 | 12517 | 0 | NULL | ||
| 275 | 285 | POF-1275 | INVF-1275 | 12555 | 12554 | 2 | 1 | 1 | 304.0 | 0.0 | 6.08 | 23.18 | 23.18 | 0.0 | 297.92 | INR | 100.0 | 100.0 | 176.0 | 4 | 12555 | 2025-11-24 18:08:41 | 0 | NULL | 1 | 2025-11-30 09:27:26 | 12554 | 0 | NULL | ||
| 276 | 286 | POF-1276 | INVF-1276 | 12555 | 12554 | 2 | 1 | 1 | 304.0 | 0.0 | 6.08 | 23.18 | 23.18 | 0.0 | 297.92 | INR | 100.0 | 100.0 | 176.0 | 4 | 12555 | 2025-11-25 13:27:10 | 0 | NULL | 1 | 2025-11-30 09:27:26 | 12554 | 0 | NULL | ||
| 277 | 287 | POF-1277 | INVF-1277 | 12554 | 12516 | 2 | 1 | 15 | 9868.0 | 0.0 | 493.4 | 721.21 | 721.21 | 0.0 | 9374.6 | INR | 3010.0 | 3010.0 | 3160.0 | 4 | 12554 | 2025-11-27 14:00:14 | 0 | NULL | 1 | 2025-11-27 14:00:38 | 12516 | 0 | NULL | ||
| 278 | 288 | POF-1278 | INVF-1278 | 12516 | 1 | 2 | 1 | 15 | 9868.0 | 0.0 | 789.44 | 721.21 | 721.21 | 0.0 | 9078.56 | INR | 3010.0 | 3010.0 | 3160.0 | 4 | 12516 | 2025-11-27 14:01:30 | 0 | NULL | 2 | 2025-12-11 12:04:58 | 1 | 0 | NULL | ||
| 279 | 289 | POF-1279 | INVF-1279 | 12555 | 12554 | 2 | 1 | 15 | 9868.0 | 0.0 | 197.36 | 721.21 | 721.21 | 0.0 | 9670.64 | INR | 3010.0 | 3010.0 | 3160.0 | 4 | 12555 | 2025-11-27 14:02:51 | 0 | NULL | 1 | 2025-11-27 14:03:18 | 12554 | 0 | NULL | ||
| 280 | 290 | POF-1280 | INVF-1280 | 12555 | 12554 | 2 | 1 | 320 | 74224.0 | 0.0 | 1484.48 | 5032.45 | 5032.45 | 0.0 | 72739.52 | INR | 22800.0 | 22800.0 | 24300.0 | 4 | 12555 | 2025-11-28 13:17:15 | 0 | NULL | 1 | 2025-11-28 13:21:46 | 12554 | 0 | NULL | ||
| 281 | 291 | POF-1281 | INVF-1281 | 12554 | 12516 | 2 | 1 | 320 | 74224.0 | 0.0 | 3711.2 | 5032.45 | 5032.45 | 0.0 | 70512.8 | INR | 22800.0 | 22800.0 | 24300.0 | 4 | 12554 | 2025-11-28 13:18:20 | 0 | NULL | 1 | 2025-11-28 13:21:31 | 12516 | 0 | NULL | ||
| 282 | 292 | POF-1282 | INVF-1282 | 12516 | 1 | 2 | 1 | 420 | 90144.0 | 0.0 | 7211.52 | 6246.69 | 6246.69 | 0.0 | 82932.48 | INR | 27300.0 | 27300.0 | 28800.0 | 4 | 12516 | 2025-11-28 13:19:22 | 0 | NULL | 1 | 2025-11-28 13:20:57 | 1 | 0 | NULL | ||
| 283 | 293 | POF-1283 | INVF-1283 | 12555 | 12554 | 2 | 1 | 220 | 59264.0 | 0.0 | 1185.28 | 4226.77 | 4226.77 | 0.0 | 58078.72 | INR | 25800.0 | 25800.0 | 26700.0 | 4 | 12555 | 2025-11-28 14:33:54 | 0 | NULL | 1 | 2025-11-28 14:40:05 | 12554 | 0 | NULL | ||
| 284 | 294 | POF-1284 | INVF-1284 | 12554 | 12516 | 2 | 1 | 20 | 8784.0 | 0.0 | 439.2 | 376.61 | 376.61 | 0.0 | 8344.8 | INR | 2300.0 | 2300.0 | 3200.0 | 4 | 12554 | 2025-11-28 14:37:16 | 0 | NULL | 1 | 2025-11-28 14:39:49 | 12516 | 0 | NULL | ||
| 285 | 295 | POF-1285 | INVF-1285 | 12516 | 1 | 2 | 1 | 20 | 8784.0 | 0.0 | 702.72 | 376.61 | 376.61 | 0.0 | 8081.28 | INR | 2300.0 | 2300.0 | 3200.0 | 4 | 12516 | 2025-11-28 14:38:07 | 0 | NULL | 1 | 2025-11-28 14:39:30 | 1 | 0 | NULL | ||
| 286 | 296 | POF-1286 | INVF-1286 | 12551 | 12516 | 2 | 1 | 3 | 912.0 | 0.0 | 45.6 | 69.56 | 69.56 | 0.0 | 866.4 | INR | 300.0 | 300.0 | 528.0 | 4 | 12551 | 2025-11-28 15:12:10 | 0 | NULL | 2 | 2025-12-11 11:39:38 | 12516 | 0 | NULL | ||
| 287 | 297 | POF-1287 | INVF-1287 | 12557 | 12517 | 2 | 1 | 1 | 304.0 | 0.0 | 6.08 | 23.18 | 23.18 | 0.0 | 297.92 | INR | 100.0 | 100.0 | 176.0 | 4 | 12557 | 2025-11-28 16:29:49 | 0 | NULL | 2 | 2025-11-28 16:31:03 | 12517 | 0 | NULL | ||
| 288 | 298 | POF-1288 | INVF-1288 | 12555 | 12554 | 2 | 1 | 10 | 15992.0 | 0.0 | 319.84 | 380.76 | 380.76 | 0.0 | 15672.16 | INR | 5000.0 | 5000.0 | 11000.0 | 4 | 12555 | 2025-11-29 15:18:16 | 0 | NULL | 1 | 2025-11-29 15:18:27 | 12554 | 0 | NULL | ||
| 289 | 299 | POF-1289 | INVF-1289 | 12855 | 12551 | 2 | 1 | 32 | 40960.0 | 0.0 | 819.2 | 975.24 | 975.24 | 0.0 | 40140.8 | INR | 14400.0 | 14400.0 | 19200.0 | 4 | 12855 | 2025-11-29 17:33:41 | 0 | NULL | 1 | 2025-11-29 19:56:16 | 12551 | 0 | NULL | ||
| 290 | 300 | POF-1290 | INVF-1290 | 12551 | 12516 | 2 | 1 | 32 | 40960.0 | 0.0 | 2048.0 | 975.24 | 975.24 | 0.0 | 38912.0 | INR | 14400.0 | 14400.0 | 19200.0 | 4 | 12551 | 2025-11-29 17:41:09 | 0 | NULL | 2 | 2025-12-11 11:39:38 | 12516 | 0 | NULL | ||
| 291 | 301 | POF-1291 | INVF-1291 | 12551 | 12516 | 2 | 1 | 4 | 1216.0 | 0.0 | 60.8 | 92.75 | 92.75 | 0.0 | 1155.2 | INR | 400.0 | 400.0 | 704.0 | 4 | 12551 | 2025-11-29 17:43:50 | 0 | NULL | 2 | 2025-12-11 11:39:38 | 12516 | 0 | NULL | ||
| 292 | 302 | POF-1292 | INVF-1292 | 12551 | 12516 | 2 | 1 | 4 | 1216.0 | 0.0 | 60.8 | 92.75 | 92.75 | 0.0 | 1155.2 | INR | 400.0 | 400.0 | 704.0 | 4 | 12551 | 2025-11-29 18:27:21 | 0 | NULL | 2 | 2025-12-11 11:39:38 | 12516 | 0 | NULL | ||
| 293 | 303 | POF-1293 | INVF-1293 | 12551 | 12516 | 2 | 1 | 11 | 3344.0 | 0.0 | 167.2 | 255.05 | 255.05 | 0.0 | 3176.8 | INR | 1100.0 | 1100.0 | 1936.0 | 4 | 12551 | 2025-11-29 18:42:52 | 0 | NULL | 2 | 2025-12-11 11:39:38 | 12516 | 0 | NULL | ||
| 294 | 304 | POF-1294 | INVF-1294 | 12551 | 12516 | 2 | 1 | 3 | 7437.0 | 0.0 | 371.85 | 177.07 | 177.07 | 0.0 | 7065.15 | INR | 1050.0 | 1050.0 | 4050.0 | 4 | 12551 | 2025-11-29 18:49:03 | 0 | NULL | 2 | 2025-12-11 11:39:38 | 12516 | 0 | NULL | ||
| 295 | 305 | POF-1295 | INVF-1295 | 12855 | 12551 | 2 | 1 | 3 | 4320.0 | 0.0 | 86.4 | 102.86 | 102.86 | 0.0 | 4233.6 | INR | 750.0 | 750.0 | 1770.0 | 4 | 12855 | 2025-11-29 19:18:05 | 0 | NULL | 1 | 2025-11-29 19:56:16 | 12551 | 0 | NULL | ||
| 296 | 306 | POF-1296 | INVF-1296 | 12855 | 12551 | 2 | 1 | 22 | 3502.4 | 0.0 | 70.05 | 267.13 | 267.13 | 0.0 | 3432.35 | INR | 990.0 | 990.0 | 1628.0 | 4 | 12855 | 2025-11-29 19:23:37 | 0 | NULL | 1 | 2025-11-29 19:56:16 | 12551 | 0 | NULL | ||
| 297 | 307 | POF-1297 | INVF-1297 | 12551 | 12516 | 2 | 1 | 54 | 4320.0 | 0.0 | 216.0 | 102.86 | 102.86 | 0.0 | 4104.0 | INR | 1512.0 | 1512.0 | 2052.0 | 4 | 12551 | 2025-11-29 20:19:51 | 0 | NULL | 2 | 2025-12-11 11:39:38 | 12516 | 0 | NULL | ||
| 298 | 308 | POF-1298 | INVF-1298 | 12855 | 12551 | 2 | 1 | 52 | 4160.0 | 0.0 | 83.2 | 99.05 | 99.05 | 0.0 | 4076.8 | INR | 1456.0 | 1456.0 | 1976.0 | 4 | 12855 | 2025-11-29 20:30:26 | 0 | NULL | 1 | 2025-11-29 20:34:29 | 12551 | 0 | NULL | ||
| 299 | 309 | POF-1299 | INVF-1299 | 12555 | 12554 | 2 | 1 | 4 | 14400.0 | 0.0 | 288.0 | 342.86 | 342.86 | 0.0 | 14112.0 | INR | 4000.0 | 4000.0 | 6400.0 | 4 | 12555 | 2025-11-30 09:22:58 | 0 | NULL | 1 | 2025-11-30 09:27:26 | 12554 | 0 | NULL | ||
| 300 | 310 | POF-1300 | INVF-1300 | 12554 | 12516 | 2 | 1 | 4 | 14400.0 | 0.0 | 720.0 | 342.86 | 342.86 | 0.0 | 13680.0 | INR | 4000.0 | 4000.0 | 6400.0 | 4 | 12554 | 2025-11-30 09:24:10 | 0 | NULL | 1 | 2025-11-30 09:26:56 | 12516 | 0 | NULL |