fx_franchise_order_product

4,933 rows · 33 columns · page 52 / 99

Invoice view Excel export
# id sr_no order_id userid product_id product_name prod_desc hsn_no product_qty product_bv product_MRP discount_per discount_amount prod_dis_amt prod_before_gst_amt prod_gst_amount total_mrp total_bv total_price cgst_per cgst_amount sgst_per sgst_amount igst_per igst_amount total_before_gst_amount total_gst_amount final_amount _currency fr_category comm_per comm_amount created_on
2551 2564 3 610 12518 3 BP Care Capsules NULL 2936900 2 0.0 999.0 0.0 0.0 720.0 685.71 34.29 1998.0 0.0 1440.0 0.0 0.0 0.0 0.0 5.0 68.57 1371.43 68.57 1440.0 INR 3 2.0 27.43 2026-01-07 16:39:49
2552 2565 4 610 12518 4 Diabetic Care Capsules NULL 2936900 2 0.0 999.0 0.0 0.0 720.0 685.71 34.29 1998.0 0.0 1440.0 0.0 0.0 0.0 0.0 5.0 68.57 1371.43 68.57 1440.0 INR 3 2.0 27.43 2026-01-07 16:39:49
2553 2566 5 610 12518 37 Floor Cleaner 500ml NULL 3924101 5 0.0 199.0 0.0 0.0 159.0 134.75 24.25 995.0 0.0 795.0 0.0 0.0 0.0 0.0 18.0 121.27 673.73 121.27 795.0 INR 3 2.0 13.47 2026-01-07 16:39:49
2554 2567 6 610 12518 7 Morning Fresh Churan NULL 30049011 5 0.0 199.0 0.0 0.0 159.0 151.43 7.57 995.0 0.0 795.0 0.0 0.0 0.0 0.0 5.0 37.86 757.14 37.86 795.0 INR 3 2.0 15.14 2026-01-07 16:39:49
2555 2568 7 610 12518 12 P RADIANCE FACE SERUM NULL 33049990 2 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 2500.0 0.0 1500.0 0.0 0.0 0.0 0.0 5.0 71.43 1428.57 71.43 1500.0 INR 3 2.0 28.57 2026-01-07 16:39:49
2556 2569 8 610 12518 41 Premium Coco Body Lotion NULL 3304300 3 0.0 699.0 0.0 0.0 559.0 473.73 85.27 2097.0 0.0 1677.0 0.0 0.0 0.0 0.0 18.0 255.81 1421.19 255.81 1677.0 INR 3 2.0 28.42 2026-01-07 16:39:49
2557 2570 9 610 12518 46 Root Vitality Hair Oil NULL 3305901 5 0.0 255.0 0.0 0.0 204.0 194.29 9.71 1275.0 0.0 1020.0 0.0 0.0 0.0 0.0 5.0 48.57 971.43 48.57 1020.0 INR 3 2.0 19.43 2026-01-07 16:39:49
2558 2571 10 610 12518 26 Spirulina Cap NULL 2009899 2 0.0 899.0 0.0 0.0 719.0 684.76 34.24 1798.0 0.0 1438.0 0.0 0.0 0.0 0.0 5.0 68.48 1369.52 68.48 1438.0 INR 3 2.0 27.39 2026-01-07 16:39:49
2559 2572 11 610 12518 50 Sun Screen NULL 330499 2 0.0 699.0 0.0 0.0 559.0 473.73 85.27 1398.0 0.0 1118.0 0.0 0.0 0.0 0.0 18.0 170.54 947.46 170.54 1118.0 INR 3 2.0 18.95 2026-01-07 16:39:49
2560 2573 12 610 12518 36 Toilet Cleaner 500ml NULL 3924101 5 0.0 150.0 0.0 0.0 120.0 101.69 18.31 750.0 0.0 600.0 0.0 0.0 0.0 0.0 18.0 91.53 508.47 91.53 600.0 INR 3 2.0 10.17 2026-01-07 16:39:49
2561 2574 13 610 12518 44 Vital Glow Face Scrub NULL 3304300 3 0.0 325.0 0.0 0.0 260.0 220.34 39.66 975.0 0.0 780.0 0.0 0.0 0.0 0.0 18.0 118.98 661.02 118.98 780.0 INR 3 2.0 13.22 2026-01-07 16:39:49
2562 2575 1 611 12555 53 Terra care 2 kg NULL 3103100 5 0.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 7500.0 0.0 5750.0 2.5 136.9 2.5 136.9 0.0 0.0 5476.19 273.81 5750.0 INR 3 2.0 109.52 2026-01-07 16:42:40
2563 2576 1 612 12554 52 Bhoo sanjeevni 5 kg NULL 3103100 15 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 24000.0 0.0 18750.0 2.5 446.43 2.5 446.43 0.0 0.0 17857.14 892.86 18750.0 INR 2 6.0 1071.43 2026-01-07 16:44:29
2564 2577 2 612 12554 53 Terra care 2 kg NULL 3103100 15 0.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 22500.0 0.0 17250.0 2.5 410.71 2.5 410.71 0.0 0.0 16428.57 821.43 17250.0 INR 2 6.0 985.71 2026-01-07 16:44:29
2565 2578 1 613 12555 52 Bhoo sanjeevni 5 kg NULL 3103100 10 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 16000.0 0.0 12500.0 2.5 297.62 2.5 297.62 0.0 0.0 11904.76 595.24 12500.0 INR 3 2.0 238.1 2026-01-07 16:45:06
2566 2579 1 614 12518 34 Herbo2o Toothpaste NULL 33061090 15 0.0 199.0 0.0 0.0 159.0 134.75 24.25 2985.0 0.0 2385.0 0.0 0.0 0.0 0.0 18.0 363.81 2021.19 363.81 2385.0 INR 3 2.0 40.42 2026-01-07 16:46:34
2567 2580 1 615 12555 52 Bhoo sanjeevni 5 kg NULL 3103100 5 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 8000.0 0.0 6250.0 2.5 148.81 2.5 148.81 0.0 0.0 5952.38 297.62 6250.0 INR 3 2.0 119.05 2026-01-07 17:17:06
2568 2581 2 615 12555 53 Terra care 2 kg NULL 3103100 10 0.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 15000.0 0.0 11500.0 2.5 273.81 2.5 273.81 0.0 0.0 10952.38 547.62 11500.0 INR 3 2.0 219.05 2026-01-07 17:17:06
2569 2582 1 616 12554 52 Bhoo sanjeevni 5 kg NULL 3103100 6 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 9600.0 0.0 7500.0 2.5 178.57 2.5 178.57 0.0 0.0 7142.86 357.14 7500.0 INR 2 6.0 428.57 2026-01-07 17:17:52
2570 2583 1 617 12555 52 Bhoo sanjeevni 5 kg NULL 3103100 5 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 8000.0 0.0 6250.0 2.5 148.81 2.5 148.81 0.0 0.0 5952.38 297.62 6250.0 INR 3 2.0 119.05 2026-01-07 17:19:28
2571 2584 1 618 12554 84 B AND B NULL 94041000 1 0.0 12999.0 0.0 0.0 10500.0 10000.0 500.0 12999.0 0.0 10500.0 2.5 250.0 2.5 250.0 0.0 0.0 10000.0 500.0 10500.0 INR 2 0.0 300.0 2026-01-07 18:11:09
2572 2585 1 619 12555 84 B AND B NULL 94041000 1 0.0 12999.0 0.0 0.0 10500.0 10000.0 500.0 12999.0 0.0 10500.0 2.5 250.0 2.5 250.0 0.0 0.0 10000.0 500.0 10500.0 INR 3 0.0 150.0 2026-01-07 18:11:43
2573 2586 2 619 12555 32 Neem Soap 100gm NULL 34011110 1 0.0 60.0 0.0 0.0 48.0 45.71 2.29 60.0 0.0 48.0 2.5 1.14 2.5 1.14 0.0 0.0 45.71 2.29 48.0 INR 3 2.0 0.91 2026-01-07 18:11:43
2574 2587 1 620 12546 48 glow face wash NULL 3304999 5 0.0 380.0 0.0 0.0 304.0 257.63 46.37 1900.0 0.0 1520.0 0.0 0.0 0.0 0.0 18.0 231.86 1288.14 231.86 1520.0 INR 3 2.0 25.76 2026-01-07 19:23:04
2575 2588 2 620 12546 20 Premium Berry Juice 1000ml NULL 2936900 1 0.0 3499.0 0.0 0.0 2600.0 2476.19 123.81 3499.0 0.0 2600.0 0.0 0.0 0.0 0.0 5.0 123.81 2476.19 123.81 2600.0 INR 3 2.0 49.52 2026-01-07 19:23:04
2576 2589 3 620 12546 84 B AND B NULL 94041000 1 0.0 12999.0 0.0 0.0 10500.0 10000.0 500.0 12999.0 0.0 10500.0 0.0 0.0 0.0 0.0 5.0 500.0 10000.0 500.0 10500.0 INR 3 0.0 150.0 2026-01-07 19:23:04
2577 2590 4 620 12546 33 Herbal Soap 100gm NULL 30049011 30 0.0 100.0 0.0 0.0 80.0 76.19 3.81 3000.0 0.0 2400.0 0.0 0.0 0.0 0.0 5.0 114.29 2285.72 114.29 2400.0 INR 3 2.0 45.71 2026-01-07 19:23:04
2578 2591 5 620 12546 15 KIDNEY CARE JUICE NULL 2009899 5 0.0 349.0 0.0 0.0 279.0 265.71 13.29 1745.0 0.0 1395.0 0.0 0.0 0.0 0.0 5.0 66.43 1328.57 66.43 1395.0 INR 3 2.0 26.57 2026-01-07 19:23:04
2579 2592 6 620 12546 7 Morning Fresh Churan NULL 30049011 30 0.0 199.0 0.0 0.0 159.0 151.43 7.57 5970.0 0.0 4770.0 0.0 0.0 0.0 0.0 5.0 227.14 4542.86 227.14 4770.0 INR 3 2.0 90.86 2026-01-07 19:23:04
2580 2593 7 620 12546 47 Premium Hair Care Shampoo NULL 3305109 3 0.0 699.0 0.0 0.0 559.0 532.38 26.62 2097.0 0.0 1677.0 0.0 0.0 0.0 0.0 5.0 79.86 1597.14 79.86 1677.0 INR 3 2.0 31.94 2026-01-07 19:23:04
2581 2594 8 620 12546 46 Root Vitality Hair Oil NULL 3305901 4 0.0 255.0 0.0 0.0 204.0 194.29 9.71 1020.0 0.0 816.0 0.0 0.0 0.0 0.0 5.0 38.86 777.14 38.86 816.0 INR 3 2.0 15.54 2026-01-07 19:23:04
2582 2595 9 620 12546 50 Sun Screen NULL 330499 3 0.0 699.0 0.0 0.0 559.0 473.73 85.27 2097.0 0.0 1677.0 0.0 0.0 0.0 0.0 18.0 255.81 1421.19 255.81 1677.0 INR 3 2.0 28.42 2026-01-07 19:23:04
2583 2596 10 620 12546 36 Toilet Cleaner 500ml NULL 3924101 10 0.0 150.0 0.0 0.0 120.0 101.69 18.31 1500.0 0.0 1200.0 0.0 0.0 0.0 0.0 18.0 183.05 1016.95 183.05 1200.0 INR 3 2.0 20.34 2026-01-07 19:23:04
2584 2597 1 621 12526 48 glow face wash NULL 3304999 4 0.0 380.0 0.0 0.0 304.0 257.63 46.37 1520.0 0.0 1216.0 9.0 92.75 9.0 92.75 0.0 0.0 1030.51 185.49 1216.0 INR 3 2.0 20.61 2026-01-07 20:18:12
2585 2598 2 621 12526 20 Premium Berry Juice 1000ml NULL 2936900 2 0.0 3499.0 0.0 0.0 2600.0 2476.19 123.81 6998.0 0.0 5200.0 2.5 123.81 2.5 123.81 0.0 0.0 4952.38 247.62 5200.0 INR 3 2.0 99.05 2026-01-07 20:18:12
2586 2599 3 621 12526 19 Fat loss Juice 500 ml NULL 30049011 2 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 2998.0 0.0 2400.0 2.5 57.14 2.5 57.14 0.0 0.0 2285.71 114.29 2400.0 INR 3 2.0 45.71 2026-01-07 20:18:12
2587 2600 4 621 12526 33 Herbal Soap 100gm NULL 30049011 5 0.0 100.0 0.0 0.0 80.0 76.19 3.81 500.0 0.0 400.0 2.5 9.52 2.5 9.52 0.0 0.0 380.95 19.05 400.0 INR 3 2.0 7.62 2026-01-07 20:18:12
2588 2601 5 621 12526 18 Lady Care Juice 500ml NULL 2009899 1 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 1499.0 0.0 1200.0 2.5 28.57 2.5 28.57 0.0 0.0 1142.86 57.14 1200.0 INR 3 2.0 22.86 2026-01-07 20:18:12
2589 2602 6 621 12526 32 Neem Soap 100gm NULL 34011110 10 0.0 60.0 0.0 0.0 48.0 45.71 2.29 600.0 0.0 480.0 2.5 11.43 2.5 11.43 0.0 0.0 457.14 22.86 480.0 INR 3 2.0 9.14 2026-01-07 20:18:12
2590 2603 1 622 12539 84 B AND B NULL 94041000 1 0.0 12999.0 0.0 0.0 10500.0 10000.0 500.0 12999.0 0.0 10500.0 2.5 250.0 2.5 250.0 0.0 0.0 10000.0 500.0 10500.0 INR 3 0.0 150.0 2026-01-07 21:17:25
2591 2604 1 623 12517 19 Fat loss Juice 500 ml NULL 30049011 2 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 2998.0 0.0 2400.0 0.0 0.0 0.0 0.0 5.0 114.29 2285.71 114.29 2400.0 INR 2 6.0 137.14 2026-01-07 22:10:31
2592 2605 2 623 12517 10 SOUNDARYA VEDA RADIANCE DAY CREAM NULL 33049910 10 0.0 1424.0 0.0 0.0 750.0 714.29 35.71 14240.0 0.0 7500.0 0.0 0.0 0.0 0.0 5.0 357.14 7142.86 357.14 7500.0 INR 2 6.0 428.57 2026-01-07 22:10:31
2593 2606 1 624 12516 10 SOUNDARYA VEDA RADIANCE DAY CREAM NULL 33049910 9 0.0 1424.0 0.0 0.0 750.0 714.29 35.71 12816.0 0.0 6750.0 2.5 160.71 2.5 160.71 0.0 0.0 6428.57 321.43 6750.0 INR 1 8.0 514.29 2026-01-07 22:11:16
2594 2607 1 625 13438 32 Neem Soap 100gm NULL 34011110 1 0.0 60.0 0.0 0.0 48.0 45.71 2.29 60.0 0.0 48.0 0.0 0.0 0.0 0.0 5.0 2.29 45.71 2.29 48.0 INR 3 2.0 0.91 2026-01-07 22:12:47
2595 2608 2 625 13438 81 PREMIUM GLOW FACE WASH NULL 3404 2 0.0 699.0 0.0 0.0 559.0 512.84 46.16 1398.0 0.0 1118.0 0.0 0.0 0.0 0.0 9.0 92.31 1025.69 92.31 1118.0 INR 3 2.0 20.51 2026-01-07 22:12:47
2596 2609 3 625 13438 10 SOUNDARYA VEDA RADIANCE DAY CREAM NULL 33049910 3 0.0 1424.0 0.0 0.0 750.0 714.29 35.71 4272.0 0.0 2250.0 0.0 0.0 0.0 0.0 5.0 107.14 2142.86 107.14 2250.0 INR 3 2.0 42.86 2026-01-07 22:12:47
2597 2610 4 625 13438 50 Sun Screen NULL 330499 2 0.0 699.0 0.0 0.0 559.0 473.73 85.27 1398.0 0.0 1118.0 0.0 0.0 0.0 0.0 18.0 170.54 947.46 170.54 1118.0 INR 3 2.0 18.95 2026-01-07 22:12:47
2598 2611 1 626 12554 9 Omega 369 NULL 2936900 10 0.0 999.0 0.0 0.0 720.0 685.71 34.29 9990.0 0.0 7200.0 2.5 171.43 2.5 171.43 0.0 0.0 6857.14 342.86 7200.0 INR 2 6.0 411.43 2026-01-07 22:41:59
2599 2612 1 627 13438 9 Omega 369 NULL 2936900 2 0.0 999.0 0.0 0.0 720.0 685.71 34.29 1998.0 0.0 1440.0 0.0 0.0 0.0 0.0 5.0 68.57 1371.43 68.57 1440.0 INR 3 2.0 27.43 2026-01-07 22:44:38
2600 2613 1 628 13438 32 Neem Soap 100gm NULL 34011110 20 0.0 60.0 0.0 0.0 48.0 45.71 2.29 1200.0 0.0 960.0 2.5 22.86 2.5 22.86 0.0 0.0 914.29 45.71 960.0 INR 3 2.0 18.29 2026-01-07 23:14:20