fx_franchise_order

1,057 rows · 31 columns · page 9 / 22

Excel export
# 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 621 POFN-1611 INVFN-1611 12526 12517 2 1 24 10896.0 0.0 204.99 323.22 323.22 0.0 10691.01 INR 0.0 0.06 0.0 4 12526 2026-01-07 20:18:12 0 NULL 1 2026-01-07 23:15:15 12517 0 NULL
402 622 POFN-1612 INVFN-1612 12539 12517 2 1 1 10500.0 0.0 150.0 250.0 250.0 0.0 10350.0 INR 0.0 3.0 0.0 4 12539 2026-01-07 21:17:25 0 NULL 1 2026-01-07 22:04:53 12517 0 NULL
403 623 POFN-1613 INVFN-1613 12517 12516 2 1 12 9900.0 0.0 565.71 0.0 0.0 471.43 9334.29 INR 0.0 1.0 0.0 4 12517 2026-01-07 22:10:31 0 NULL 1 2026-01-07 22:11:44 12516 0 NULL
404 624 POFN-1614 INVFN-1614 12516 1 2 1 9 6750.0 0.0 514.29 160.71 160.71 0.0 6235.71 INR 0.0 0.9 0.0 4 12516 2026-01-07 22:11:16 0 NULL 1 2026-01-07 22:11:32 1 0 NULL
405 625 POFN-1615 INVFN-1615 13438 12554 2 1 8 4534.0 0.0 83.23 0.0 0.0 372.28 4450.77 INR 0.0 0.22 0.0 4 13438 2026-01-07 22:12:47 0 NULL 1 2026-01-07 22:52:03 12554 0 NULL
406 626 POFN-1616 INVFN-1616 12554 12516 2 1 10 7200.0 0.0 411.43 171.43 171.43 0.0 6788.57 INR 0.0 1.5 0.0 4 12554 2026-01-07 22:41:59 0 NULL 1 2026-01-07 22:42:37 12516 0 NULL
407 627 POFN-1617 INVFN-1617 13438 12554 2 1 2 1440.0 0.0 27.43 0.0 0.0 68.57 1412.57 INR 0.0 0.3 0.0 4 13438 2026-01-07 22:44:38 0 NULL 1 2026-01-07 22:52:03 12554 0 NULL
408 628 POFN-1618 INVFN-1618 13438 12517 2 1 20 960.0 0.0 18.29 22.86 22.86 0.0 941.71 INR 0.0 0.12 0.0 4 13438 2026-01-07 23:14:20 0 NULL 1 2026-01-07 23:15:10 12517 0 NULL
409 629 POFN-1619 INVFN-1619 13438 12517 2 1 2 608.0 0.0 10.31 46.37 46.37 0.0 597.69 INR 0.0 0.1 0.0 4 13438 2026-01-08 13:02:01 0 NULL 1 2026-01-08 13:59:52 12517 0 NULL
410 630 POFN-1620 INVFN-1620 12517 12516 2 1 30 8370.0 0.0 478.29 0.0 0.0 398.57 7891.71 INR 0.0 1.5 0.0 4 12517 2026-01-08 14:03:13 0 NULL 1 2026-01-08 14:03:23 12516 0 NULL
411 631 POFN-1621 INVFN-1621 12517 12516 2 1 2 5200.0 0.0 297.14 0.0 0.0 247.62 4902.86 INR 0.0 1.0 0.0 4 12517 2026-01-08 14:04:19 0 NULL 1 2026-01-08 14:04:29 12516 0 NULL
412 632 POFN-1622 INVFN-1622 12521 12517 2 1 198 36450.0 0.0 650.38 1520.5 1520.5 0.0 35799.62 INR 0.0 0.06 0.0 4 12521 2026-01-08 17:29:46 0 NULL 1 2026-01-08 20:46:14 12517 0 NULL
413 633 POFN-1623 INVFN-1623 12523 12517 2 1 1 2000.0 0.0 38.83 29.13 29.13 0.0 1961.17 INR 0.0 0.4 0.0 4 12523 2026-01-08 19:11:01 0 NULL 1 2026-01-08 21:30:55 12517 0 NULL
414 634 POFN-1624 INVFN-1624 12517 12516 2 1 120 64630.0 0.0 3669.7 0.0 0.0 3468.36 60960.3 INR 0.0 1.0 0.0 4 12517 2026-01-08 20:41:47 0 NULL 1 2026-01-08 20:45:53 12516 0 NULL
415 635 POFN-1625 INVFN-1625 12516 1 2 1 150 101040.0 0.0 7651.4 2698.77 2698.77 0.0 93388.6 INR 0.0 3.0 0.0 4 12516 2026-01-08 20:44:03 0 NULL 1 2026-01-08 20:45:27 1 0 NULL
416 636 POFN-1626 INVFN-1626 12545 12517 2 1 21 10721.0 0.0 200.04 359.41 359.41 0.0 10520.96 INR 0.0 0.1 0.0 4 12545 2026-01-08 22:07:51 0 NULL 1 2026-01-08 22:24:10 12517 0 NULL
417 637 POFN-1627 INVFN-1627 12552 12517 2 1 24 8819.0 0.0 159.53 421.13 421.13 0.0 8659.47 INR 0.0 0.03 0.0 4 12552 2026-01-08 22:47:06 0 NULL 1 2026-01-08 22:48:03 12517 0 NULL
418 638 POFN-1628 INVFN-1628 12534 12517 2 1 183 17863.0 0.0 326.36 772.45 772.45 0.0 17536.64 INR 0.0 0.08 0.0 4 12534 2026-01-09 10:29:26 0 NULL 1 2026-01-09 11:20:03 12517 0 NULL
419 639 POFN-1629 INVFN-1629 12517 12516 2 1 390 282860.0 0.0 16123.39 0.0 0.0 14136.84 266736.61 INR 0.0 7.5 0.0 4 12517 2026-01-09 12:50:03 0 NULL 1 2026-01-09 12:54:17 12516 0 NULL
420 640 POFN-1630 INVFN-1630 12516 1 2 1 30 4770.0 0.0 323.39 363.81 363.81 0.0 4446.61 INR 0.0 0.36 0.0 4 12516 2026-01-09 12:51:17 0 NULL 1 2026-01-09 12:51:37 1 0 NULL
421 641 POFN-1631 INVFN-1631 12516 1 2 1 150 30600.0 0.0 2331.43 728.57 728.57 0.0 28268.57 INR 0.0 6.0 0.0 4 12516 2026-01-09 12:53:46 0 NULL 1 2026-01-09 12:54:01 1 0 NULL
422 642 POFN-1632 INVFN-1632 12538 12517 2 1 1 10500.0 0.0 150.0 250.0 250.0 0.0 10350.0 INR 0.0 3.0 0.0 4 12538 2026-01-09 13:07:00 0 NULL 1 2026-01-09 14:26:14 12517 0 NULL
423 643 POFN-1633 INVFN-1633 14079 12517 2 1 26 3517.0 0.0 65.82 113.06 113.06 0.0 3451.18 INR 0.0 0.11 0.0 4 14079 2026-01-09 13:57:25 0 NULL 1 2026-01-09 14:26:11 12517 0 NULL
424 644 POFN-1634 INVFN-1634 12555 12554 2 1 2 1000.0 0.0 16.95 76.27 76.27 0.0 983.05 INR 0.0 0.2 0.0 4 12555 2026-01-09 15:42:18 0 NULL 1 2026-01-09 15:42:36 12554 0 NULL
425 645 POFN-1635 INVFN-1635 12532 12554 2 1 588 44622.0 0.0 830.62 0.0 0.0 3090.78 43791.38 INR 0.0 0.26 0.0 4 12532 2026-01-09 15:54:54 0 NULL 1 2026-01-09 15:58:07 12554 0 NULL
426 646 POFN-1636 INVFN-1636 12554 12516 2 1 25 8385.0 0.0 479.14 199.64 199.64 0.0 7905.86 INR 0.0 1.0 0.0 4 12554 2026-01-09 15:57:37 0 NULL 1 2026-01-09 15:57:50 12516 0 NULL
427 647 POFN-1637 INVFN-1637 12532 12554 2 1 10 5631.0 0.0 107.26 0.0 0.0 268.14 5523.74 INR 0.0 0.99 0.0 4 12532 2026-01-09 16:43:26 0 NULL 1 2026-01-09 16:46:05 12554 0 NULL
428 648 POFN-1638 INVFN-1638 12532 12517 2 1 1 9900.0 0.0 150.0 755.08 755.08 0.0 9750.0 INR 0.0 2.0 0.0 4 12532 2026-01-09 16:49:21 0 NULL 1 2026-01-09 17:03:28 12517 0 NULL
429 649 POFN-1639 INVFN-1639 12554 12516 2 1 20 10000.0 0.0 508.47 762.71 762.71 0.0 9491.53 INR 0.0 2.0 0.0 4 12554 2026-01-09 17:05:58 0 NULL 1 2026-01-09 17:06:21 12516 0 NULL
430 650 POFN-1640 INVFN-1640 12555 12554 2 1 10 5000.0 0.0 84.75 381.36 381.36 0.0 4915.25 INR 0.0 1.0 0.0 4 12555 2026-01-09 17:06:41 0 NULL 1 2026-01-09 17:06:55 12554 0 NULL
431 651 POFN-1641 INVFN-1641 12532 12517 2 1 1 2000.0 0.0 38.83 29.13 29.13 0.0 1961.17 INR 0.0 0.4 0.0 4 12532 2026-01-09 17:11:05 0 NULL 1 2026-01-09 17:31:56 12517 0 NULL
432 652 POFN-1642 INVFN-1642 12554 12516 2 1 10 105000.0 0.0 3000.0 2500.0 2500.0 0.0 102000.0 INR 0.0 30.0 0.0 4 12554 2026-01-09 17:14:33 0 NULL 1 2026-01-09 17:15:34 12516 0 NULL
433 653 POFN-1643 INVFN-1643 12516 1 2 1 10 105000.0 0.0 4000.0 2500.0 2500.0 0.0 101000.0 INR 0.0 30.0 0.0 4 12516 2026-01-09 17:15:00 0 NULL 1 2026-01-09 17:15:22 1 0 NULL
434 654 POFN-1644 INVFN-1644 13536 12554 2 1 2 21000.0 0.0 300.0 500.0 500.0 0.0 20700.0 INR 0.0 6.0 0.0 4 13536 2026-01-09 17:15:51 0 NULL 1 2026-01-09 17:16:01 12554 0 NULL
435 655 POFN-1645 INVFN-1645 13536 12554 2 1 60 8038.0 0.0 151.01 243.65 243.65 0.0 7886.99 INR 0.0 0.11 0.0 4 13536 2026-01-09 17:17:35 0 NULL 1 2026-01-09 17:18:47 12554 0 NULL
436 656 POFN-1646 INVFN-1646 12554 12516 2 1 20 2400.0 0.0 122.03 183.05 183.05 0.0 2277.97 INR 0.0 0.22 0.0 4 12554 2026-01-09 17:18:26 0 NULL 1 2026-01-09 17:18:36 12516 0 NULL
437 657 POFN-1647 INVFN-1647 12526 12517 2 1 5 52500.0 0.0 750.0 1250.0 1250.0 0.0 51750.0 INR 0.0 15.0 0.0 4 12526 2026-01-09 17:39:29 0 NULL 1 2026-01-09 17:42:48 12517 0 NULL
438 658 POFN-1648 INVFN-1648 13438 12554 2 1 19 5696.0 0.0 102.49 0.0 0.0 571.74 5593.51 INR 0.0 0.08 0.0 4 13438 2026-01-09 18:45:20 0 NULL 1 2026-01-09 18:48:36 12554 0 NULL
439 659 POFN-1649 INVFN-1649 12554 12516 2 1 20 15000.0 0.0 857.14 357.14 357.14 0.0 14142.86 INR 0.0 2.0 0.0 4 12554 2026-01-09 19:24:22 0 NULL 1 2026-01-09 19:24:47 12516 0 NULL
440 660 POFN-1650 INVFN-1650 12520 12517 2 1 155 18155.0 0.0 339.69 585.19 585.19 0.0 17815.31 INR 0.0 0.11 0.0 4 12520 2026-01-09 19:37:06 0 NULL 1 2026-01-09 19:48:25 12517 0 NULL
441 661 POFN-1651 INVFN-1651 13438 12554 2 1 12 17788.0 0.0 285.3 0.0 0.0 1023.0 17502.7 INR 0.0 0.33 0.0 4 13438 2026-01-09 19:38:29 0 NULL 1 2026-01-09 19:39:54 12554 0 NULL
442 662 POFN-1652 INVFN-1652 12516 1 2 1 5 52500.0 0.0 2000.0 1250.0 1250.0 0.0 50500.0 INR 0.0 15.0 0.0 4 12516 2026-01-09 19:55:43 0 NULL 1 2026-01-09 19:57:00 1 0 NULL
443 663 POFN-1653 INVFN-1653 12517 12516 2 1 3 31500.0 0.0 900.0 0.0 0.0 1500.0 30600.0 INR 0.0 9.0 0.0 4 12517 2026-01-09 19:58:10 0 NULL 1 2026-01-09 19:58:23 12516 0 NULL
444 664 POFN-1654 INVFN-1654 12526 12517 2 1 3 31500.0 0.0 450.0 750.0 750.0 0.0 31050.0 INR 0.0 9.0 0.0 4 12526 2026-01-09 20:05:14 0 NULL 1 2026-01-09 20:05:21 12517 0 NULL
445 665 POFN-1655 INVFN-1655 12517 12516 2 1 8 84000.0 0.0 2400.0 0.0 0.0 4000.0 81600.0 INR 0.0 24.0 0.0 4 12517 2026-01-09 20:21:55 0 NULL 1 2026-01-09 20:22:45 12516 0 NULL
446 666 POFN-1656 INVFN-1656 12516 1 2 1 15 157500.0 0.0 6000.0 3750.0 3750.0 0.0 151500.0 INR 0.0 45.0 0.0 4 12516 2026-01-09 20:22:10 0 NULL 1 2026-01-09 20:22:34 1 0 NULL
447 667 POFN-1657 INVFN-1657 12532 12517 2 1 3 15700.0 0.0 249.05 373.81 373.81 0.0 15450.95 INR 0.0 3.0 0.0 4 12532 2026-01-09 21:44:20 0 NULL 1 2026-01-09 21:51:14 12517 0 NULL
448 668 POFN-1658 INVFN-1658 12517 12516 2 1 3 7800.0 0.0 445.71 0.0 0.0 371.43 7354.29 INR 0.0 1.5 0.0 4 12517 2026-01-09 21:49:36 0 NULL 1 2026-01-09 21:50:14 12516 0 NULL
449 669 POFN-1659 INVFN-1659 12529 12517 2 1 118 33470.0 0.0 529.62 994.53 994.53 0.0 32940.38 INR 0.0 0.15 0.0 4 12529 2026-01-09 22:19:46 0 NULL 1 2026-01-09 22:29:41 12517 0 NULL
450 670 POFN-1660 INVFN-1660 13438 12554 2 1 1 10500.0 0.0 150.0 0.0 0.0 500.0 10350.0 INR 0.0 3.0 0.0 4 13438 2026-01-09 22:42:46 0 NULL 1 2026-01-09 22:58:47 12554 0 NULL