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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 301 | 311 | POF-1301 | INVF-1301 | 12516 | 1 | 2 | 1 | 4 | 14400.0 | 0.0 | 1152.0 | 342.86 | 342.86 | 0.0 | 13248.0 | INR | 4000.0 | 4000.0 | 6400.0 | 4 | 12516 | 2025-11-30 09:25:32 | 0 | NULL | 1 | 2025-11-30 09:25:48 | 1 | 0 | NULL | ||
| 302 | 312 | POF-1302 | INVF-1302 | 12555 | 12554 | 2 | 1 | 1100 | 63920.0 | 0.0 | 1278.4 | 2357.09 | 2357.09 | 0.0 | 62641.6 | INR | 18000.0 | 18000.0 | 21000.0 | 4 | 12555 | 2025-11-30 15:48:04 | 0 | NULL | 1 | 2025-11-30 15:48:36 | 12554 | 0 | NULL | ||
| 303 | 313 | POF-1303 | INVF-1303 | 12555 | 12554 | 2 | 2 | 6 | 62994.0 | 0.0 | 1259.88 | 1499.86 | 1499.86 | 0.0 | 61734.12 | INR | 0.0 | 21000.0 | 0.0 | 4 | 12555 | 2025-11-30 19:50:50 | 0 | NULL | 1 | 2025-11-30 19:51:16 | 12554 | 0 | NULL | ||
| 304 | 314 | POF-1304 | INVF-1304 | 12555 | 12554 | 2 | 1 | 5 | 3996.0 | 0.0 | 79.92 | 304.78 | 304.78 | 0.0 | 3916.08 | INR | 1625.0 | 1625.0 | 2375.0 | 4 | 12555 | 2025-11-30 23:19:31 | 0 | NULL | 1 | 2025-11-30 23:20:14 | 12554 | 0 | NULL | ||
| 305 | 315 | POF-1305 | INVF-1305 | 12555 | 12554 | 2 | 1 | 4 | 4796.8 | 0.0 | 95.94 | 114.21 | 114.21 | 0.0 | 4700.86 | INR | 1700.0 | 1700.0 | 3100.0 | 4 | 12555 | 2025-11-30 23:27:23 | 0 | NULL | 1 | 2025-11-30 23:27:42 | 12554 | 0 | NULL | ||
| 306 | 316 | POF-1306 | INVF-1306 | 12555 | 12554 | 2 | 2 | 30 | 314970.0 | 0.0 | 6299.4 | 7499.28 | 7499.28 | 0.0 | 308670.6 | INR | 0.0 | 105000.0 | 0.0 | 4 | 12555 | 2025-12-01 16:18:59 | 0 | NULL | 1 | 2025-12-01 16:22:14 | 12554 | 0 | NULL | ||
| 307 | 317 | POF-1307 | INVF-1307 | 12554 | 12516 | 2 | 2 | 40 | 419960.0 | 0.0 | 20998.0 | 9999.05 | 9999.05 | 0.0 | 398962.0 | INR | 0.0 | 140000.0 | 0.0 | 4 | 12554 | 2025-12-01 16:19:41 | 0 | NULL | 1 | 2025-12-01 16:21:35 | 12516 | 0 | NULL | ||
| 308 | 318 | POF-1308 | INVF-1308 | 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-12-01 16:20:26 | 0 | NULL | 1 | 2025-12-01 16:21:04 | 1 | 0 | NULL | ||
| 309 | 319 | POF-1309 | INVF-1309 | 12855 | 12551 | 2 | 1 | 46 | 55200.0 | 0.0 | 1104.0 | 1314.29 | 1314.29 | 0.0 | 54096.0 | INR | 20700.0 | 20700.0 | 27600.0 | 4 | 12855 | 2025-12-01 17:49:50 | 0 | NULL | 2 | 2025-12-06 15:37:15 | 12551 | 0 | NULL | ||
| 310 | 320 | POF-1310 | INVF-1310 | 12855 | 12551 | 2 | 1 | 6 | 11995.2 | 0.0 | 239.9 | 285.6 | 285.6 | 0.0 | 11755.3 | INR | 4494.0 | 4494.0 | 7494.0 | 4 | 12855 | 2025-12-01 18:03:10 | 0 | NULL | 1 | 2025-12-01 18:38:54 | 12551 | 0 | NULL | ||
| 311 | 321 | POF-1311 | INVF-1311 | 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-12-03 17:17:31 | 0 | NULL | 1 | 2025-12-03 17:21:25 | 12517 | 0 | NULL | ||
| 312 | 322 | POF-1312 | INVF-1312 | 12555 | 12554 | 2 | 1 | 20 | 5584.0 | 0.0 | 111.68 | 132.95 | 132.95 | 0.0 | 5472.32 | INR | 2400.0 | 2400.0 | 3100.0 | 4 | 12555 | 2025-12-04 15:34:41 | 0 | NULL | 1 | 2025-12-04 15:36:59 | 12554 | 0 | NULL | ||
| 313 | 323 | POF-1313 | INVF-1313 | 12554 | 12516 | 2 | 1 | 30 | 8376.0 | 0.0 | 418.8 | 199.43 | 199.43 | 0.0 | 7957.2 | INR | 3600.0 | 3600.0 | 4650.0 | 4 | 12554 | 2025-12-04 15:36:04 | 0 | NULL | 1 | 2025-12-04 15:36:25 | 12516 | 0 | NULL | ||
| 314 | 324 | POF-1314 | INVF-1314 | 12551 | 12516 | 2 | 1 | 58 | 11969.6 | 0.0 | 598.48 | 620.44 | 620.44 | 0.0 | 11371.12 | INR | 3471.0 | 3471.0 | 3666.0 | 4 | 12551 | 2025-12-05 14:21:29 | 0 | NULL | 1 | 2025-12-05 14:25:26 | 12516 | 0 | NULL | ||
| 315 | 325 | POF-1315 | INVF-1315 | 12516 | 1 | 2 | 1 | 60 | 18240.0 | 0.0 | 1459.2 | 1159.32 | 1159.32 | 0.0 | 16780.8 | INR | 5400.0 | 5400.0 | 6360.0 | 4 | 12516 | 2025-12-05 14:23:35 | 0 | NULL | 1 | 2025-12-05 14:25:05 | 1 | 0 | NULL | ||
| 316 | 326 | POF-1316 | INVF-1316 | 12554 | 12516 | 2 | 1 | 10 | 3040.0 | 0.0 | 152.0 | 0.0 | 0.0 | 0.0 | 2888.0 | INR | 400.0 | 400.0 | 1360.0 | 4 | 12554 | 2025-12-05 14:30:49 | 0 | NULL | 1 | 2025-12-07 22:37:06 | 12516 | 0 | NULL | ||
| 317 | 327 | POF-1317 | INVF-1317 | 12551 | 12516 | 2 | 2 | 3 | 54000.0 | 0.0 | 2700.0 | 1285.71 | 1285.71 | 0.0 | 51300.0 | INR | 0.0 | 22500.0 | 0.0 | 4 | 12551 | 2025-12-05 14:34:50 | 0 | NULL | 1 | 2025-12-05 15:50:31 | 12516 | 0 | NULL | ||
| 318 | 328 | POF-1318 | INVF-1318 | 12551 | 12516 | 2 | 1 | 1 | 48.0 | 0.0 | 2.4 | 1.14 | 1.14 | 0.0 | 45.6 | INR | 10.0 | 10.0 | 13.0 | 4 | 12551 | 2025-12-05 15:47:09 | 0 | NULL | 1 | 2025-12-05 15:47:29 | 12516 | 0 | NULL | ||
| 319 | 329 | POF-1319 | INVF-1319 | 12555 | 12554 | 2 | 1 | 30 | 16776.0 | 0.0 | 335.52 | 692.59 | 692.59 | 0.0 | 16440.48 | INR | 8400.0 | 8400.0 | 12000.0 | 4 | 12555 | 2025-12-05 17:28:50 | 0 | NULL | 1 | 2025-12-05 17:32:32 | 12554 | 0 | NULL | ||
| 320 | 330 | POF-1320 | INVF-1320 | 12554 | 12516 | 2 | 1 | 30 | 16776.0 | 0.0 | 838.8 | 692.59 | 692.59 | 0.0 | 15937.2 | INR | 8400.0 | 8400.0 | 12000.0 | 4 | 12554 | 2025-12-05 17:29:37 | 0 | NULL | 1 | 2025-12-05 17:31:52 | 12516 | 0 | NULL | ||
| 321 | 331 | POF-1321 | INVF-1321 | 12516 | 1 | 2 | 1 | 30 | 16776.0 | 0.0 | 1342.08 | 692.59 | 692.59 | 0.0 | 15433.92 | INR | 8400.0 | 8400.0 | 12000.0 | 4 | 12516 | 2025-12-05 17:30:15 | 0 | NULL | 1 | 2025-12-05 17:31:03 | 1 | 0 | NULL | ||
| 322 | 332 | POF-1322 | INVF-1322 | 12555 | 12554 | 2 | 1 | 20 | 3184.0 | 0.0 | 63.68 | 242.85 | 242.85 | 0.0 | 3120.32 | INR | 700.0 | 700.0 | 1300.0 | 4 | 12555 | 2025-12-05 17:35:18 | 0 | NULL | 1 | 2025-12-05 17:36:41 | 12554 | 0 | NULL | ||
| 323 | 333 | POF-1323 | INVF-1323 | 12554 | 12516 | 2 | 1 | 30 | 4776.0 | 0.0 | 238.8 | 364.27 | 364.27 | 0.0 | 4537.2 | INR | 1050.0 | 1050.0 | 1950.0 | 4 | 12554 | 2025-12-05 17:36:01 | 0 | NULL | 1 | 2025-12-05 17:36:23 | 12516 | 0 | NULL | ||
| 324 | 334 | POF-1324 | INVF-1324 | 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-12-05 22:11:30 | 0 | NULL | 1 | 2025-12-06 13:40:13 | 12517 | 0 | NULL | ||
| 325 | 335 | POF-1325 | INVF-1325 | 12555 | 12554 | 2 | 2 | 40 | 419960.0 | 0.0 | 8399.2 | 9999.05 | 9999.05 | 0.0 | 411560.8 | INR | 0.0 | 140000.0 | 0.0 | 4 | 12555 | 2025-12-05 23:04:31 | 0 | NULL | 1 | 2025-12-05 23:08:49 | 12554 | 0 | NULL | ||
| 326 | 336 | POF-1326 | INVF-1326 | 12554 | 12516 | 2 | 2 | 60 | 629940.0 | 0.0 | 31497.0 | 14998.57 | 14998.57 | 0.0 | 598443.0 | INR | 0.0 | 210000.0 | 0.0 | 4 | 12554 | 2025-12-05 23:05:26 | 0 | NULL | 1 | 2025-12-05 23:08:19 | 12516 | 0 | NULL | ||
| 327 | 337 | POF-1327 | INVF-1327 | 12516 | 1 | 2 | 2 | 60 | 629940.0 | 0.0 | 50395.2 | 14998.57 | 14998.57 | 0.0 | 579544.8 | INR | 0.0 | 210000.0 | 0.0 | 4 | 12516 | 2025-12-05 23:06:47 | 0 | NULL | 1 | 2025-12-05 23:07:52 | 1 | 0 | NULL | ||
| 328 | 338 | POF-1328 | INVF-1328 | 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-12-06 13:46:32 | 0 | NULL | 1 | 2025-12-06 13:46:47 | 12517 | 0 | NULL | ||
| 329 | 339 | POF-1329 | INVF-1329 | 12855 | 12551 | 2 | 1 | 58 | 11969.6 | 0.0 | 239.39 | 620.42 | 620.42 | 0.0 | 11730.21 | INR | 3471.0 | 3471.0 | 3666.0 | 4 | 12855 | 2025-12-06 16:28:15 | 0 | NULL | 1 | 2025-12-06 16:36:57 | 12551 | 0 | NULL | ||
| 330 | 340 | POF-1330 | INVF-1330 | 12555 | 12554 | 2 | 1 | 20 | 14384.0 | 0.0 | 287.68 | 342.48 | 342.48 | 0.0 | 14096.32 | INR | 5000.0 | 5000.0 | 8400.0 | 4 | 12555 | 2025-12-07 22:35:52 | 0 | NULL | 1 | 2025-12-07 22:37:41 | 12554 | 0 | NULL | ||
| 331 | 341 | POF-1331 | INVF-1331 | 12554 | 12516 | 2 | 1 | 30 | 21576.0 | 0.0 | 1078.8 | 513.71 | 513.71 | 0.0 | 20497.2 | INR | 7500.0 | 7500.0 | 12600.0 | 4 | 12554 | 2025-12-07 22:36:33 | 0 | NULL | 1 | 2025-12-07 22:36:58 | 12516 | 0 | NULL | ||
| 332 | 342 | POF-1332 | INVF-1332 | 12855 | 12551 | 2 | 2 | 3 | 54000.0 | 0.0 | 1080.0 | 1285.71 | 1285.71 | 0.0 | 52920.0 | INR | 0.0 | 22500.0 | 0.0 | 4 | 12855 | 2025-12-08 13:51:53 | 0 | NULL | 1 | 2025-12-08 14:08:14 | 12551 | 0 | NULL | ||
| 333 | 343 | POF-1333 | INVF-1333 | 12855 | 12551 | 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 | 12855 | 2025-12-08 14:00:52 | 0 | NULL | 2 | 2025-12-08 14:08:27 | 12551 | 0 | NULL | ||
| 334 | 344 | POF-1334 | INVF-1334 | 12855 | 12551 | 2 | 1 | 4 | 8638.4 | 0.0 | 172.77 | 205.68 | 205.68 | 0.0 | 8465.63 | INR | 2500.0 | 2500.0 | 3700.0 | 4 | 12855 | 2025-12-08 14:19:43 | 0 | NULL | 1 | 2025-12-08 14:21:41 | 12551 | 0 | NULL | ||
| 335 | 345 | POF-1335 | INVF-1335 | 12855 | 12551 | 2 | 1 | 122 | 184960.0 | 0.0 | 3699.2 | 6107.76 | 6107.76 | 0.0 | 181260.8 | INR | 84600.0 | 84600.0 | 90600.0 | 4 | 12855 | 2025-12-08 14:34:32 | 0 | NULL | 1 | 2025-12-08 14:35:43 | 12551 | 0 | NULL | ||
| 336 | 346 | POF-1336 | INVF-1336 | 12855 | 12551 | 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 | 12855 | 2025-12-08 16:37:48 | 0 | NULL | 2 | 2025-12-08 16:39:48 | 12551 | 0 | NULL | ||
| 337 | 347 | POF-1337 | INVF-1337 | 12551 | 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 | 12551 | 2025-12-08 16:41:42 | 0 | NULL | 2 | 2025-12-11 11:39:38 | 12516 | 0 | NULL | ||
| 338 | 348 | POF-1338 | INVF-1338 | 12551 | 12516 | 2 | 1 | 4 | 1216.0 | 0.0 | 60.8 | 0.0 | 0.0 | 0.0 | 1155.2 | INR | 160.0 | 160.0 | 544.0 | 4 | 12551 | 2025-12-10 19:06:32 | 0 | NULL | 2 | 2025-12-11 11:39:38 | 12516 | 0 | NULL | ||
| 339 | 349 | POF-1339 | INVF-1339 | 12855 | 12551 | 2 | 1 | 4 | 1216.0 | 0.0 | 24.32 | 0.0 | 0.0 | 0.0 | 1191.68 | INR | 160.0 | 160.0 | 544.0 | 4 | 12855 | 2025-12-10 19:13:43 | 0 | NULL | 1 | 2025-12-10 19:16:53 | 12551 | 0 | NULL | ||
| 340 | 350 | POF-1340 | INVF-1340 | 12555 | 12554 | 2 | 2 | 10 | 104990.0 | 0.0 | 2099.8 | 2499.76 | 2499.76 | 0.0 | 102890.2 | INR | 0.0 | 35000.0 | 0.0 | 4 | 12555 | 2025-12-11 11:37:50 | 0 | NULL | 1 | 2025-12-11 11:38:03 | 12554 | 0 | NULL | ||
| 341 | 351 | POF-1341 | INVF-1341 | 12555 | 12554 | 2 | 1 | 30 | 9120.0 | 0.0 | 182.4 | 0.0 | 0.0 | 0.0 | 8937.6 | INR | 1200.0 | 1200.0 | 4080.0 | 4 | 12555 | 2025-12-11 12:03:19 | 0 | NULL | 1 | 2025-12-11 12:05:58 | 12554 | 0 | NULL | ||
| 342 | 352 | POF-1342 | INVF-1342 | 12554 | 12516 | 2 | 1 | 50 | 15200.0 | 0.0 | 760.0 | 0.0 | 0.0 | 0.0 | 14440.0 | INR | 2000.0 | 2000.0 | 6800.0 | 4 | 12554 | 2025-12-11 12:03:53 | 0 | NULL | 1 | 2025-12-11 12:05:44 | 12516 | 0 | NULL | ||
| 343 | 353 | POF-1343 | INVF-1343 | 12516 | 1 | 2 | 1 | 60 | 18240.0 | 0.0 | 1459.2 | 0.0 | 0.0 | 0.0 | 16780.8 | INR | 2400.0 | 2400.0 | 8160.0 | 4 | 12516 | 2025-12-11 12:04:31 | 0 | NULL | 1 | 2025-12-11 12:05:25 | 1 | 0 | NULL | ||
| 344 | 354 | POF-1344 | INVF-1344 | 12555 | 12554 | 2 | 1 | 10 | 23992.0 | 0.0 | 479.84 | 571.24 | 571.24 | 0.0 | 23512.16 | INR | 10000.0 | 10000.0 | 15000.0 | 4 | 12555 | 2025-12-13 15:30:09 | 0 | NULL | 1 | 2025-12-13 15:32:08 | 12554 | 0 | NULL | ||
| 345 | 355 | POF-1345 | INVF-1345 | 12555 | 12554 | 2 | 2 | 10 | 104990.0 | 0.0 | 2099.8 | 2499.76 | 2499.76 | 0.0 | 102890.2 | INR | 0.0 | 35000.0 | 0.0 | 4 | 12555 | 2025-12-13 16:28:16 | 0 | NULL | 1 | 2025-12-13 16:28:31 | 12554 | 0 | NULL | ||
| 346 | 356 | POF-1346 | INVF-1346 | 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-12-14 12:30:31 | 0 | NULL | 1 | 2025-12-14 12:43:50 | 12517 | 0 | NULL | ||
| 347 | 357 | POF-1347 | INVF-1347 | 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-12-14 12:48:00 | 0 | NULL | 1 | 2025-12-14 12:53:09 | 12517 | 0 | NULL | ||
| 348 | 358 | POF-1348 | INVF-1348 | 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-12-14 12:55:28 | 0 | NULL | 1 | 2025-12-14 13:00:21 | 12517 | 0 | NULL | ||
| 349 | 359 | POF-1349 | INVF-1349 | 12555 | 12554 | 2 | 2 | 20 | 209980.0 | 0.0 | 4199.6 | 4999.52 | 4999.52 | 0.0 | 205780.4 | INR | 0.0 | 70000.0 | 0.0 | 4 | 12555 | 2025-12-14 15:49:37 | 0 | NULL | 1 | 2025-12-14 15:54:04 | 12554 | 0 | NULL | ||
| 350 | 360 | POF-1350 | INVF-1350 | 12554 | 12516 | 2 | 2 | 20 | 209980.0 | 0.0 | 10499.0 | 4999.52 | 4999.52 | 0.0 | 199481.0 | INR | 0.0 | 70000.0 | 0.0 | 4 | 12554 | 2025-12-14 15:51:12 | 0 | NULL | 1 | 2025-12-14 15:53:33 | 12516 | 0 | NULL |