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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 401 | 411 | POF-1401 | INVF-1401 | 12554 | 12516 | 2 | 1 | 50 | 60000.0 | 0.0 | 3000.0 | 1428.57 | 1428.57 | 0.0 | 57000.0 | INR | 0.0 | 50.0 | 0.0 | 4 | 12554 | 2025-12-19 22:34:31 | 0 | NULL | 1 | 2025-12-19 22:34:48 | 12516 | 0 | NULL | ||
| 402 | 412 | POF-1402 | INVF-1402 | 12555 | 12554 | 2 | 1 | 400 | 200000.0 | 0.0 | 4000.0 | 15254.24 | 15254.24 | 0.0 | 196000.0 | INR | 0.0 | 200.0 | 0.0 | 4 | 12555 | 2025-12-19 22:42:31 | 0 | NULL | 1 | 2025-12-19 22:44:31 | 12554 | 0 | NULL | ||
| 403 | 413 | POF-1403 | INVF-1403 | 12554 | 12516 | 2 | 1 | 400 | 200000.0 | 0.0 | 10000.0 | 15254.24 | 15254.24 | 0.0 | 190000.0 | INR | 0.0 | 200.0 | 0.0 | 4 | 12554 | 2025-12-19 22:42:58 | 0 | NULL | 1 | 2025-12-19 22:44:13 | 12516 | 0 | NULL | ||
| 404 | 414 | POF-1404 | INVF-1404 | 12516 | 1 | 2 | 1 | 400 | 200000.0 | 0.0 | 16000.0 | 15254.24 | 15254.24 | 0.0 | 184000.0 | INR | 0.0 | 200.0 | 0.0 | 4 | 12516 | 2025-12-19 22:43:22 | 0 | NULL | 1 | 2025-12-19 22:43:51 | 1 | 0 | NULL | ||
| 405 | 415 | POF-1405 | INVF-1405 | 12516 | 1 | 2 | 1 | 200 | 100000.0 | 0.0 | 8000.0 | 7627.12 | 7627.12 | 0.0 | 92000.0 | INR | 0.0 | 100.0 | 0.0 | 4 | 12516 | 2025-12-20 10:05:14 | 0 | NULL | 1 | 2025-12-20 10:05:26 | 1 | 0 | NULL | ||
| 406 | 416 | POF-1406 | INVF-1406 | 12554 | 12516 | 2 | 1 | 200 | 100000.0 | 0.0 | 5000.0 | 7627.12 | 7627.12 | 0.0 | 95000.0 | INR | 0.0 | 100.0 | 0.0 | 4 | 12554 | 2025-12-20 10:05:53 | 0 | NULL | 1 | 2025-12-20 10:06:12 | 12516 | 0 | NULL | ||
| 407 | 417 | POF-1407 | INVF-1407 | 12555 | 12554 | 2 | 1 | 200 | 100000.0 | 0.0 | 2000.0 | 7627.12 | 7627.12 | 0.0 | 98000.0 | INR | 0.0 | 100.0 | 0.0 | 4 | 12555 | 2025-12-20 10:06:40 | 0 | NULL | 1 | 2025-12-20 10:06:54 | 12554 | 0 | NULL | ||
| 408 | 418 | POF-1408 | INVF-1408 | 12555 | 12554 | 2 | 1 | 5 | 13000.0 | 0.0 | 260.0 | 309.52 | 309.52 | 0.0 | 12740.0 | INR | 0.0 | 5.0 | 0.0 | 4 | 12555 | 2025-12-20 10:39:39 | 0 | NULL | 1 | 2025-12-20 10:39:53 | 12554 | 0 | NULL | ||
| 409 | 419 | POF-1409 | INVF-1409 | 12516 | 1 | 2 | 1 | 20 | 229790.0 | 0.0 | 18383.2 | 3346.46 | 3346.46 | 0.0 | 211406.8 | INR | 0.0 | 30.0 | 0.0 | 4 | 12516 | 2025-12-21 09:57:14 | 0 | NULL | 1 | 2025-12-21 09:57:42 | 1 | 0 | NULL | ||
| 410 | 420 | POF-1410 | INVF-1410 | 12517 | 12516 | 2 | 1 | 2 | 15960.0 | 0.0 | 798.0 | 0.0 | 0.0 | 464.85 | 15162.0 | INR | 0.0 | 4.0 | 0.0 | 4 | 12517 | 2025-12-21 10:01:00 | 0 | NULL | 2 | 2025-12-21 11:28:04 | 12516 | 0 | NULL | ||
| 411 | 421 | POF-1411 | INVF-1411 | 12554 | 12516 | 2 | 1 | 20 | 229790.0 | 0.0 | 11489.5 | 3346.46 | 3346.46 | 0.0 | 218300.5 | INR | 0.0 | 30.0 | 0.0 | 4 | 12554 | 2025-12-21 11:18:12 | 0 | NULL | 1 | 2025-12-21 11:18:36 | 12516 | 0 | NULL | ||
| 412 | 422 | POF-1412 | INVF-1412 | 12516 | 1 | 2 | 1 | 10 | 79800.0 | 0.0 | 6384.0 | 1162.14 | 1162.14 | 0.0 | 73416.0 | INR | 0.0 | 20.0 | 0.0 | 4 | 12516 | 2025-12-21 11:36:28 | 0 | NULL | 1 | 2025-12-21 11:36:55 | 1 | 0 | NULL | ||
| 413 | 423 | POF-1413 | INVF-1413 | 12554 | 12516 | 2 | 1 | 20 | 229790.0 | 0.0 | 11489.5 | 3346.46 | 3346.46 | 0.0 | 218300.5 | INR | 0.0 | 30.0 | 0.0 | 4 | 12554 | 2025-12-21 11:39:11 | 0 | NULL | 1 | 2025-12-21 11:39:44 | 12516 | 0 | NULL | ||
| 414 | 424 | POF-1414 | INVF-1414 | 12555 | 12554 | 2 | 1 | 30 | 20400.0 | 0.0 | 408.0 | 485.72 | 485.72 | 0.0 | 19992.0 | INR | 0.0 | 1.0 | 0.0 | 4 | 12555 | 2025-12-23 14:15:35 | 0 | NULL | 1 | 2025-12-23 14:15:54 | 12554 | 0 | NULL | ||
| 415 | 425 | POF-1415 | INVF-1415 | 12516 | 1 | 2 | 1 | 10 | 149990.0 | 0.0 | 11999.2 | 2184.32 | 2184.32 | 0.0 | 137990.8 | INR | 0.0 | 30.0 | 0.0 | 4 | 12516 | 2025-12-23 16:54:00 | 0 | NULL | 1 | 2025-12-23 18:03:26 | 1 | 0 | NULL | ||
| 416 | 426 | POF-1416 | INVF-1416 | 12551 | 12516 | 2 | 1 | 22 | 150845.0 | 0.0 | 7542.25 | 2381.61 | 2381.61 | 0.0 | 143302.75 | INR | 0.0 | 4.0 | 0.0 | 4 | 12551 | 2025-12-23 18:04:27 | 0 | NULL | 1 | 2025-12-23 18:04:53 | 12516 | 0 | NULL | ||
| 417 | 427 | POF-1417 | INVF-1417 | 12516 | 1 | 2 | 1 | 40 | 459580.0 | 0.0 | 36766.4 | 6692.91 | 6692.91 | 0.0 | 422813.6 | INR | 0.0 | 60.0 | 0.0 | 4 | 12516 | 2025-12-23 20:05:34 | 0 | NULL | 1 | 2025-12-23 20:05:55 | 1 | 0 | NULL | ||
| 418 | 428 | POF-1418 | INVF-1418 | 12554 | 12516 | 2 | 1 | 40 | 459580.0 | 0.0 | 22979.0 | 6692.91 | 6692.91 | 0.0 | 436601.0 | INR | 0.0 | 60.0 | 0.0 | 4 | 12554 | 2025-12-23 20:06:55 | 0 | NULL | 1 | 2025-12-24 14:49:00 | 12516 | 0 | NULL | ||
| 419 | 429 | POF-1419 | INVF-1419 | 12555 | 12554 | 2 | 1 | 40 | 459580.0 | 0.0 | 9191.6 | 6692.91 | 6692.91 | 0.0 | 450388.4 | INR | 0.0 | 60.0 | 0.0 | 4 | 12555 | 2025-12-23 20:09:09 | 0 | NULL | 1 | 2025-12-23 20:09:46 | 12554 | 0 | NULL | ||
| 420 | 430 | POF-1420 | INVF-1420 | 12555 | 12554 | 2 | 1 | 100 | 12000.0 | 0.0 | 240.0 | 915.25 | 915.25 | 0.0 | 11760.0 | INR | 0.0 | 1.1 | 0.0 | 4 | 12555 | 2025-12-23 22:26:12 | 0 | NULL | 1 | 2025-12-23 22:26:49 | 12554 | 0 | NULL | ||
| 421 | 431 | POF-1421 | INVF-1421 | 12516 | 1 | 2 | 1 | 90 | 111160.0 | 0.0 | 8892.8 | 1722.03 | 1722.03 | 0.0 | 102267.2 | INR | 0.0 | 1.0 | 0.0 | 4 | 12516 | 2025-12-24 14:47:35 | 0 | NULL | 1 | 2025-12-24 14:47:50 | 1 | 0 | NULL | ||
| 422 | 432 | POF-1422 | INVF-1422 | 12554 | 12516 | 2 | 1 | 70 | 105580.0 | 0.0 | 5279.0 | 1589.17 | 1589.17 | 0.0 | 100301.0 | INR | 0.0 | 0.5 | 0.0 | 4 | 12554 | 2025-12-24 14:48:30 | 0 | NULL | 1 | 2025-12-24 14:48:57 | 12516 | 0 | NULL | ||
| 423 | 433 | POF-1423 | INVF-1423 | 12555 | 12554 | 2 | 1 | 70 | 105580.0 | 0.0 | 2111.6 | 1589.17 | 1589.17 | 0.0 | 103468.4 | INR | 0.0 | 0.5 | 0.0 | 4 | 12555 | 2025-12-24 14:50:04 | 0 | NULL | 1 | 2025-12-24 14:50:16 | 12554 | 0 | NULL | ||
| 424 | 434 | POF-1424 | INVF-1424 | 12555 | 12554 | 2 | 1 | 10 | 26000.0 | 0.0 | 520.0 | 619.05 | 619.05 | 0.0 | 25480.0 | INR | 0.0 | 5.0 | 0.0 | 4 | 12555 | 2025-12-24 17:55:29 | 0 | NULL | 1 | 2025-12-24 17:56:33 | 12554 | 0 | NULL | ||
| 425 | 435 | POF-1425 | INVF-1425 | 12554 | 12516 | 2 | 1 | 10 | 26000.0 | 0.0 | 1300.0 | 619.05 | 619.05 | 0.0 | 24700.0 | INR | 0.0 | 5.0 | 0.0 | 4 | 12554 | 2025-12-24 17:56:00 | 0 | NULL | 1 | 2025-12-24 17:56:19 | 12516 | 0 | NULL | ||
| 426 | 436 | POF-1426 | INVF-1426 | 13438 | 12517 | 2 | 1 | 4 | 736.0 | 0.0 | 14.72 | 56.13 | 56.13 | 0.0 | 721.28 | INR | 0.0 | 0.04 | 0.0 | 4 | 13438 | 2025-12-24 18:38:13 | 0 | NULL | 1 | 2025-12-25 11:30:57 | 12517 | 0 | NULL | ||
| 427 | 437 | POF-1427 | INVF-1427 | 13438 | 12517 | 2 | 1 | 53 | 2544.0 | 0.0 | 50.88 | 60.57 | 60.57 | 0.0 | 2493.12 | INR | 0.0 | 0.32 | 0.0 | 4 | 13438 | 2025-12-24 18:42:55 | 0 | NULL | 1 | 2025-12-25 11:30:57 | 12517 | 0 | NULL | ||
| 428 | 438 | POF-1428 | INVF-1428 | 13438 | 12517 | 2 | 1 | 5 | 3884.0 | 0.0 | 77.68 | 159.84 | 159.84 | 0.0 | 3806.32 | INR | 0.0 | 0.09 | 0.0 | 4 | 13438 | 2025-12-24 18:50:57 | 0 | NULL | 1 | 2025-12-25 11:30:57 | 12517 | 0 | NULL | ||
| 429 | 439 | POF-1429 | INVF-1429 | 13438 | 12517 | 2 | 1 | 4 | 636.0 | 0.0 | 12.72 | 48.51 | 48.51 | 0.0 | 623.28 | INR | 0.0 | 0.04 | 0.0 | 4 | 13438 | 2025-12-24 19:01:38 | 0 | NULL | 1 | 2025-12-25 11:30:57 | 12517 | 0 | NULL | ||
| 430 | 440 | POF-1430 | INVF-1430 | 13438 | 12517 | 2 | 1 | 1 | 304.0 | 0.0 | 6.08 | 23.18 | 23.18 | 0.0 | 297.92 | INR | 0.0 | 0.05 | 0.0 | 4 | 13438 | 2025-12-24 19:07:42 | 0 | NULL | 1 | 2025-12-25 11:30:57 | 12517 | 0 | NULL | ||
| 431 | 441 | POF-1431 | INVF-1431 | 13438 | 12517 | 2 | 1 | 1 | 279.0 | 0.0 | 5.58 | 6.64 | 6.64 | 0.0 | 273.42 | INR | 0.0 | 0.05 | 0.0 | 4 | 13438 | 2025-12-24 19:10:21 | 0 | NULL | 1 | 2025-12-25 11:30:58 | 12517 | 0 | NULL | ||
| 432 | 442 | POF-1432 | INVF-1432 | 13438 | 12517 | 2 | 1 | 43 | 2064.0 | 0.0 | 41.28 | 49.15 | 49.15 | 0.0 | 2022.72 | INR | 0.0 | 0.26 | 0.0 | 4 | 13438 | 2025-12-24 19:15:44 | 0 | NULL | 1 | 2025-12-25 11:30:58 | 12517 | 0 | NULL | ||
| 433 | 443 | POF-1433 | INVF-1433 | 13438 | 12517 | 2 | 1 | 10 | 800.0 | 0.0 | 16.0 | 19.05 | 19.05 | 0.0 | 784.0 | INR | 0.0 | 0.09 | 0.0 | 4 | 13438 | 2025-12-25 12:07:07 | 0 | NULL | 2 | 2025-12-25 12:16:58 | 12517 | 0 | NULL | ||
| 434 | 444 | POF-1434 | INVF-1434 | 13438 | 12517 | 2 | 1 | 5 | 600.0 | 0.0 | 12.0 | 45.77 | 45.77 | 0.0 | 588.0 | INR | 0.0 | 0.06 | 0.0 | 4 | 13438 | 2025-12-25 12:08:24 | 0 | NULL | 2 | 2025-12-25 12:16:58 | 12517 | 0 | NULL | ||
| 435 | 445 | POF-1435 | INVF-1435 | 13438 | 12517 | 2 | 1 | 15 | 1400.0 | 0.0 | 28.0 | 64.81 | 64.81 | 0.0 | 1372.0 | INR | 0.0 | 0.06 | 0.0 | 4 | 13438 | 2025-12-25 12:10:14 | 0 | NULL | 1 | 2025-12-25 12:15:36 | 12517 | 0 | NULL | ||
| 436 | 446 | POF-1436 | INVF-1436 | 12517 | 12516 | 2 | 1 | 1 | 7980.0 | 0.0 | 399.0 | 0.0 | 0.0 | 232.43 | 7581.0 | INR | 0.0 | 2.0 | 0.0 | 4 | 12517 | 2025-12-25 12:15:57 | 0 | NULL | 1 | 2025-12-25 12:16:11 | 12516 | 0 | NULL | ||
| 437 | 447 | POF-1437 | INVF-1437 | 13438 | 12517 | 2 | 1 | 1 | 7980.0 | 0.0 | 159.6 | 116.22 | 116.22 | 0.0 | 7820.4 | INR | 0.0 | 2.0 | 0.0 | 4 | 13438 | 2025-12-25 12:17:19 | 0 | NULL | 1 | 2025-12-25 12:17:53 | 12517 | 0 | NULL | ||
| 438 | 448 | POF-1438 | INVF-1438 | 13438 | 12517 | 2 | 1 | 30 | 4770.0 | 0.0 | 95.4 | 363.81 | 363.81 | 0.0 | 4674.6 | INR | 0.0 | 0.75 | 0.0 | 4 | 13438 | 2025-12-25 12:40:02 | 0 | NULL | 1 | 2025-12-25 12:40:17 | 12517 | 0 | NULL | ||
| 439 | 449 | POF-1439 | INVF-1439 | 13438 | 12517 | 2 | 1 | 10 | 1840.0 | 0.0 | 36.8 | 140.34 | 140.34 | 0.0 | 1803.2 | INR | 0.0 | 0.11 | 0.0 | 4 | 13438 | 2025-12-25 12:41:14 | 0 | NULL | 1 | 2025-12-25 12:41:31 | 12517 | 0 | NULL | ||
| 440 | 450 | POF-1440 | INVF-1440 | 13438 | 12517 | 2 | 1 | 10 | 1590.0 | 0.0 | 31.8 | 121.27 | 121.27 | 0.0 | 1558.2 | INR | 0.0 | 0.25 | 0.0 | 4 | 13438 | 2025-12-25 12:48:56 | 0 | NULL | 1 | 2025-12-25 13:02:45 | 12517 | 0 | NULL | ||
| 441 | 451 | POF-1441 | INVF-1441 | 12555 | 12554 | 2 | 1 | 5 | 3600.0 | 0.0 | 72.0 | 85.71 | 85.71 | 0.0 | 3528.0 | INR | 0.0 | 0.75 | 0.0 | 4 | 12555 | 2025-12-25 12:57:23 | 0 | NULL | 1 | 2025-12-25 12:57:31 | 12554 | 0 | NULL | ||
| 442 | 452 | POF-1442 | INVF-1442 | 13438 | 12517 | 2 | 1 | 2 | 318.0 | 0.0 | 6.36 | 7.57 | 7.57 | 0.0 | 311.64 | INR | 0.0 | 0.03 | 0.0 | 4 | 13438 | 2025-12-25 12:58:02 | 0 | NULL | 1 | 2025-12-25 13:02:45 | 12517 | 0 | NULL | ||
| 443 | 453 | POF-1443 | INVF-1443 | 13438 | 12517 | 2 | 1 | 5 | 795.0 | 0.0 | 15.9 | 18.93 | 18.93 | 0.0 | 779.1 | INR | 0.0 | 0.08 | 0.0 | 4 | 13438 | 2025-12-25 13:02:13 | 0 | NULL | 1 | 2025-12-25 13:02:45 | 12517 | 0 | NULL | ||
| 444 | 454 | POF-1444 | INVF-1444 | 12555 | 12554 | 2 | 1 | 20 | 3180.0 | 0.0 | 63.6 | 242.54 | 242.54 | 0.0 | 3116.4 | INR | 0.0 | 0.5 | 0.0 | 4 | 12555 | 2025-12-25 13:51:34 | 0 | NULL | 1 | 2025-12-25 13:51:47 | 12554 | 0 | NULL | ||
| 445 | 455 | POF-1445 | INVF-1445 | 12555 | 12554 | 2 | 1 | 10 | 79800.0 | 0.0 | 1596.0 | 1162.14 | 1162.14 | 0.0 | 78204.0 | INR | 0.0 | 20.0 | 0.0 | 4 | 12555 | 2025-12-25 16:23:34 | 0 | NULL | 1 | 2025-12-25 16:23:44 | 12554 | 0 | NULL | ||
| 446 | 456 | POF-1446 | INVF-1446 | 12554 | 12516 | 2 | 1 | 5 | 49500.0 | 0.0 | 2475.0 | 3775.42 | 3775.42 | 0.0 | 47025.0 | INR | 0.0 | 10.0 | 0.0 | 4 | 12554 | 2025-12-25 16:28:28 | 0 | NULL | 1 | 2025-12-25 16:29:39 | 12516 | 0 | NULL | ||
| 447 | 457 | POF-1447 | INVF-1447 | 12516 | 1 | 2 | 1 | 10 | 99000.0 | 0.0 | 7920.0 | 7550.85 | 7550.85 | 0.0 | 91080.0 | INR | 0.0 | 20.0 | 0.0 | 4 | 12516 | 2025-12-25 16:29:11 | 0 | NULL | 1 | 2025-12-25 16:29:23 | 1 | 0 | NULL | ||
| 448 | 458 | POF-1448 | INVF-1448 | 12555 | 12554 | 2 | 1 | 5 | 49500.0 | 0.0 | 990.0 | 3775.42 | 3775.42 | 0.0 | 48510.0 | INR | 0.0 | 10.0 | 0.0 | 4 | 12555 | 2025-12-25 16:30:55 | 0 | NULL | 1 | 2025-12-25 16:31:10 | 12554 | 0 | NULL | ||
| 449 | 459 | POF-1449 | INVF-1449 | 12517 | 12516 | 2 | 1 | 1 | 7980.0 | 0.0 | 399.0 | 0.0 | 0.0 | 232.43 | 7581.0 | INR | 0.0 | 2.0 | 0.0 | 4 | 12517 | 2025-12-25 17:28:03 | 0 | NULL | 1 | 2025-12-25 17:28:43 | 12516 | 0 | NULL | ||
| 450 | 460 | POF-1450 | INVF-1450 | 12542 | 12517 | 2 | 1 | 1 | 7980.0 | 0.0 | 159.6 | 116.22 | 116.22 | 0.0 | 7820.4 | INR | 0.0 | 2.0 | 0.0 | 4 | 12542 | 2025-12-25 17:29:03 | 0 | NULL | 1 | 2025-12-25 17:29:21 | 12517 | 0 | NULL |