fx_franchise_order_product

4,933 rows · 33 columns · page 12 / 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
551 564 6 79 12518 3 BP Care Capsules NULL 2936900 1 160.0 599.0 0.0 0.0 479.2 456.38 22.82 599.0 160.0 479.2 2.5 11.41 2.5 11.41 0.0 0.0 456.38 22.82 479.2 INR 0 0.0 0.0 2025-11-07 21:51:44
552 565 7 79 12518 4 Diabetic Care Capsules NULL 2936900 3 250.0 899.0 0.0 0.0 719.2 684.95 34.25 2697.0 750.0 2157.6 2.5 51.37 2.5 51.37 0.0 0.0 684.95 102.74 2157.6 INR 0 0.0 0.0 2025-11-07 21:51:44
553 566 8 79 12518 38 Dish Wash 500ml NULL 3924101 3 85.0 230.0 0.0 0.0 184.0 155.93 28.07 690.0 255.0 552.0 9.0 42.1 9.0 42.1 0.0 0.0 155.93 84.2 552.0 INR 0 0.0 0.0 2025-11-07 21:51:44
554 567 9 79 12518 39 Fabric Wash 1000ml NULL 3924101 4 150.0 401.0 0.0 0.0 320.8 271.86 48.94 1604.0 600.0 1283.2 9.0 97.87 9.0 97.87 0.0 0.0 271.86 195.74 1283.2 INR 0 0.0 0.0 2025-11-07 21:51:44
555 568 10 79 12518 37 Floor Cleaner 500ml NULL 3924101 5 80.0 199.0 0.0 0.0 159.2 134.92 24.28 995.0 400.0 796.0 9.0 60.71 9.0 60.71 0.0 0.0 134.92 121.42 796.0 INR 0 0.0 0.0 2025-11-07 21:51:44
556 569 11 79 12518 33 Herbal Soap 100gm NULL 30049011 30 28.0 100.0 0.0 0.0 80.0 76.19 3.81 3000.0 840.0 2400.0 2.5 57.15 2.5 57.15 0.0 0.0 76.19 114.29 2400.0 INR 0 0.0 0.0 2025-11-07 21:51:44
557 570 12 79 12518 34 Herbo2o Toothpaste NULL 33061090 14 45.0 199.0 0.0 0.0 159.2 134.92 24.29 2786.0 630.0 2228.8 9.0 170.0 9.0 170.0 0.0 0.0 134.92 339.99 2228.8 INR 0 0.0 0.0 2025-11-07 21:51:44
558 571 13 79 12518 7 Morning Fresh Churan NULL 30049011 1 40.0 199.0 0.0 0.0 159.2 151.62 7.58 199.0 40.0 159.2 2.5 3.79 2.5 3.79 0.0 0.0 151.62 7.58 159.2 INR 0 0.0 0.0 2025-11-07 21:51:44
559 572 14 79 12518 32 Neem Soap 100gm NULL 34011110 82 10.0 60.0 0.0 0.0 48.0 45.71 2.29 4920.0 820.0 3936.0 2.5 93.72 2.5 93.72 0.0 0.0 45.71 187.43 3936.0 INR 0 0.0 0.0 2025-11-07 21:51:44
560 573 15 79 12518 9 Omega 369 NULL 2936900 2 260.0 999.0 0.0 0.0 799.2 761.14 38.05 1998.0 520.0 1598.4 2.5 38.05 2.5 38.05 0.0 0.0 761.14 76.11 1598.4 INR 0 0.0 0.0 2025-11-07 21:51:44
561 574 16 79 12518 41 Premium Coco Body Lotion NULL 3304300 1 250.0 699.0 0.0 0.0 559.2 473.9 85.3 699.0 250.0 559.2 9.0 42.65 9.0 42.65 0.0 0.0 473.9 85.3 559.2 INR 0 0.0 0.0 2025-11-07 21:51:44
562 575 17 79 12518 14 Premium Aloe Vera VEG caps NULL 2936900 1 100.0 359.0 0.0 0.0 287.2 273.52 13.68 359.0 100.0 287.2 2.5 6.84 2.5 6.84 0.0 0.0 273.52 13.68 287.2 INR 0 0.0 0.0 2025-11-07 21:51:44
563 576 18 79 12518 13 Premium NONI VEG caps NULL 2936900 2 150.0 501.0 0.0 0.0 400.8 381.71 19.09 1002.0 300.0 801.6 2.5 19.09 2.5 19.09 0.0 0.0 381.71 38.17 801.6 INR 0 0.0 0.0 2025-11-07 21:51:44
564 577 19 79 12518 46 Root Vitality Hair Oil NULL 3305901 2 54.0 255.0 0.0 0.0 204.0 194.29 9.71 510.0 108.0 408.0 2.5 9.71 2.5 9.71 0.0 0.0 194.29 19.43 408.0 INR 0 0.0 0.0 2025-11-07 21:51:44
565 578 20 79 12518 35 Sanitary Pad (15 pcs) NULL 9619001 3 40.0 380.0 0.0 0.0 304.0 304.0 0.0 1140.0 120.0 912.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 912.0 INR 0 0.0 0.0 2025-11-07 21:51:44
566 579 21 79 12518 1 Stem Cell Powder NULL 2936900 1 749.0 2499.0 0.0 0.0 1999.2 1904.0 95.2 2499.0 749.0 1999.2 2.5 47.6 2.5 47.6 0.0 0.0 1904.0 95.2 1999.2 INR 0 0.0 0.0 2025-11-07 21:51:44
567 580 22 79 12518 50 Sun Screen NULL 330499 1 250.0 699.0 0.0 0.0 559.2 473.9 85.3 699.0 250.0 559.2 9.0 42.65 9.0 42.65 0.0 0.0 473.9 85.3 559.2 INR 0 0.0 0.0 2025-11-07 21:51:44
568 581 23 79 12518 44 Vital Glow Face Scrub NULL 3304300 1 71.0 325.0 0.0 0.0 260.0 220.34 39.66 325.0 71.0 260.0 9.0 19.83 9.0 19.83 0.0 0.0 220.34 39.66 260.0 INR 0 0.0 0.0 2025-11-07 21:51:44
569 582 24 79 12518 11 Vitamin B12 Drop NULL 2106909 2 190.0 749.0 0.0 0.0 599.2 570.67 28.54 1498.0 380.0 1198.4 2.5 28.54 2.5 28.54 0.0 0.0 570.67 57.07 1198.4 INR 0 0.0 0.0 2025-11-07 21:51:44
570 583 25 79 12518 10 Vitamin D3 Drop NULL 2106909 1 190.0 749.0 0.0 0.0 599.2 570.67 28.53 749.0 190.0 599.2 2.5 14.27 2.5 14.27 0.0 0.0 570.67 28.53 599.2 INR 0 0.0 0.0 2025-11-07 21:51:44
571 584 1 80 12552 73 ENTRY BOX NULL NULL 1 0.0 3998.4 0.0 0.0 3998.4 3808.0 190.4 3998.4 0.0 3998.4 2.5 95.2 2.5 95.2 0.0 0.0 3808.0 190.4 3998.4 INR 0 0.0 0.0 2025-11-07 22:06:15
572 585 1 81 12516 48 glow face wash NULL 3304999 51 250.0 380.0 0.0 0.0 304.0 257.63 46.37 19380.0 12750.0 15504.0 9.0 1182.51 9.0 1182.51 0.0 0.0 257.63 2365.02 15504.0 INR 0 0.0 0.0 2025-11-07 22:39:17
573 586 2 81 12516 27 Multicharge Cap NULL 2009899 7 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 10493.0 3150.0 8394.4 2.5 199.87 2.5 199.87 0.0 0.0 1142.1 399.73 8394.4 INR 0 0.0 0.0 2025-11-07 22:39:17
574 587 3 81 12516 20 Premium Berry Juice 1000ml NULL 2936900 10 750.0 3499.0 0.0 0.0 3479.0 3313.33 165.67 34990.0 7500.0 34790.0 2.5 828.34 2.5 828.34 0.0 0.0 3313.33 1656.67 34790.0 INR 0 0.0 0.0 2025-11-07 22:39:17
575 588 4 81 12516 70 Premium Hand belt NULL 9404 18 600.0 9999.0 0.0 0.0 7999.2 7618.29 380.91 179982.0 10800.0 143985.6 2.5 3428.23 2.5 3428.23 0.0 0.0 7618.29 6856.46 143985.6 INR 0 0.0 0.0 2025-11-07 22:39:17
576 589 5 81 12516 61 Radiation chip NULL 902221 10 325.0 999.0 0.0 0.0 799.2 677.29 121.91 9990.0 3250.0 7992.0 9.0 609.56 9.0 609.56 0.0 0.0 677.29 1219.12 7992.0 INR 0 0.0 0.0 2025-11-07 22:39:17
577 590 6 81 12516 31 Vegan Plant Protein Powder NULL 21061000 2 1000.0 2999.0 0.0 0.0 2399.2 2284.95 114.25 5998.0 2000.0 4798.4 2.5 114.25 2.5 114.25 0.0 0.0 2284.95 228.5 4798.4 INR 0 0.0 0.0 2025-11-07 22:39:17
578 591 7 81 12516 79 ALKALINE JUG NULL 8421 5 3500.0 14999.0 0.0 0.0 11999.2 10168.81 1830.39 74995.0 17500.0 59996.0 9.0 4575.97 9.0 4575.97 0.0 0.0 10168.81 9151.93 59996.0 INR 0 0.0 0.0 2025-11-07 22:39:17
579 592 8 81 12516 21 All Fuel Juice NULL 22029990 5 350.0 2499.0 0.0 0.0 2479.0 2360.95 118.05 12495.0 1750.0 12395.0 2.5 295.12 2.5 295.12 0.0 0.0 2360.95 590.24 12395.0 INR 0 0.0 0.0 2025-11-07 22:39:17
580 593 9 81 12516 6 Asthma Care NULL 30049011 24 250.0 899.0 0.0 0.0 719.2 684.95 34.25 21576.0 6000.0 17260.8 2.5 410.97 2.5 410.97 0.0 0.0 684.95 821.94 17260.8 INR 0 0.0 0.0 2025-11-07 22:39:17
581 594 10 81 12516 40 Bamboo Brush NULL 96032100 85 25.0 110.0 0.0 0.0 88.0 74.58 13.42 9350.0 2125.0 7480.0 9.0 570.51 9.0 570.51 0.0 0.0 74.58 1141.02 7480.0 INR 0 0.0 0.0 2025-11-07 22:39:17
582 595 11 81 12516 52 Bhoo sanjeevni 5 kg NULL 3103100 68 450.0 1600.0 0.0 0.0 1280.0 1219.05 60.95 108800.0 30600.0 87040.0 2.5 2072.38 2.5 2072.38 0.0 0.0 1219.05 4144.76 87040.0 INR 0 0.0 0.0 2025-11-07 22:39:17
583 596 12 81 12516 71 Bio magnetic water pad NULL 9404 6 1000.0 4500.0 0.0 0.0 3600.0 3428.57 171.43 27000.0 6000.0 21600.0 2.5 514.28 2.5 514.28 0.0 0.0 3428.57 1028.57 21600.0 INR 0 0.0 0.0 2025-11-07 22:39:17
584 597 13 81 12516 3 BP Care Capsules NULL 2936900 74 160.0 599.0 0.0 0.0 479.2 456.38 22.82 44326.0 11840.0 35460.8 2.5 844.3 2.5 844.3 0.0 0.0 456.38 1688.61 35460.8 INR 0 0.0 0.0 2025-11-07 22:39:17
585 598 14 81 12516 4 Diabetic Care Capsules NULL 2936900 45 250.0 899.0 0.0 0.0 719.2 684.95 34.25 40455.0 11250.0 32364.0 2.5 770.57 2.5 770.57 0.0 0.0 684.95 1541.14 32364.0 INR 0 0.0 0.0 2025-11-07 22:39:17
586 599 15 81 12516 38 Dish Wash 500ml NULL 3924101 197 85.0 230.0 0.0 0.0 184.0 155.93 28.07 45310.0 16745.0 36248.0 9.0 2764.68 9.0 2764.68 0.0 0.0 155.93 5529.36 36248.0 INR 0 0.0 0.0 2025-11-07 22:39:17
587 600 16 81 12516 39 Fabric Wash 1000ml NULL 3924101 166 150.0 401.0 0.0 0.0 320.8 271.86 48.94 66566.0 24900.0 53252.8 9.0 4061.66 9.0 4061.66 0.0 0.0 271.86 8123.31 53252.8 INR 0 0.0 0.0 2025-11-07 22:39:17
588 601 17 81 12516 19 Fat loss Juice 500 ml NULL 30049011 7 250.0 1499.0 0.0 0.0 1479.0 1408.57 70.43 10493.0 1750.0 10353.0 2.5 246.5 2.5 246.5 0.0 0.0 1408.57 493.0 10353.0 INR 0 0.0 0.0 2025-11-07 22:39:17
589 602 18 81 12516 22 Fit Fuel Juice NULL 2009899 4 200.0 1999.0 0.0 0.0 1979.0 1884.76 94.24 7996.0 800.0 7916.0 2.5 188.47 2.5 188.47 0.0 0.0 1884.76 376.95 7916.0 INR 0 0.0 0.0 2025-11-07 22:39:17
590 603 19 81 12516 37 Floor Cleaner 500ml NULL 3924101 125 80.0 199.0 0.0 0.0 159.2 134.92 24.28 24875.0 10000.0 19900.0 9.0 1517.8 9.0 1517.8 0.0 0.0 134.92 3035.59 19900.0 INR 0 0.0 0.0 2025-11-07 22:39:17
591 604 20 81 12516 60 Foot patch NULL 30051090 52 500.0 1999.0 0.0 0.0 1599.2 1523.05 76.15 103948.0 26000.0 83158.4 2.5 1979.96 2.5 1979.96 0.0 0.0 1523.05 3959.92 83158.4 INR 0 0.0 0.0 2025-11-07 22:39:17
592 605 21 81 12516 58 Green shield 250ml NULL 3105 14 800.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 35000.0 11200.0 28000.0 2.5 666.66 2.5 666.66 0.0 0.0 1904.76 1333.33 28000.0 INR 0 0.0 0.0 2025-11-07 22:39:17
593 606 22 81 12516 55 Grow master 500ml NULL 3105 33 850.0 2030.0 0.0 0.0 1624.0 1546.67 77.33 66990.0 28050.0 53592.0 2.5 1276.0 2.5 1276.0 0.0 0.0 1546.67 2552.0 53592.0 INR 0 0.0 0.0 2025-11-07 22:39:17
594 607 23 81 12516 2 Heart Care Capsules NULL 2936900 10 425.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 14990.0 4250.0 11992.0 2.5 285.52 2.5 285.52 0.0 0.0 1142.1 571.05 11992.0 INR 0 0.0 0.0 2025-11-07 22:39:17
595 608 24 81 12516 33 Herbal Soap 100gm NULL 30049011 1593 28.0 100.0 0.0 0.0 80.0 76.19 3.81 159300.0 44604.0 127440.0 2.5 3034.28 2.5 3034.28 0.0 0.0 76.19 6068.57 127440.0 INR 0 0.0 0.0 2025-11-07 22:39:17
596 609 25 81 12516 34 Herbo2o Toothpaste NULL 33061090 597 45.0 199.0 0.0 0.0 159.2 134.92 24.28 118803.0 26865.0 95042.4 9.0 7248.99 9.0 7248.99 0.0 0.0 134.92 14497.99 95042.4 INR 0 0.0 0.0 2025-11-07 22:39:17
597 610 26 81 12516 24 Immunomax 24/7 Caps NULL 2009899 3 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 4497.0 1350.0 3597.6 2.5 85.66 2.5 85.66 0.0 0.0 1142.1 171.31 3597.6 INR 0 0.0 0.0 2025-11-07 22:39:17
598 611 27 81 12516 30 Iron Capsules NULL 30049011 15 250.0 899.0 0.0 0.0 719.2 684.95 34.25 13485.0 3750.0 10788.0 2.5 256.86 2.5 256.86 0.0 0.0 684.95 513.71 10788.0 INR 0 0.0 0.0 2025-11-07 22:39:17
599 612 28 81 12516 15 Kidney Stone Juice NULL 2009899 11 120.0 349.0 0.0 0.0 279.2 265.9 13.3 3839.0 1320.0 3071.2 2.5 73.12 2.5 73.12 0.0 0.0 265.9 146.25 3071.2 INR 0 0.0 0.0 2025-11-07 22:39:17
600 613 29 81 12516 18 Lady Care Juice 500ml NULL 2009899 16 250.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 23984.0 4000.0 19187.2 2.5 456.84 2.5 456.84 0.0 0.0 1142.1 913.68 19187.2 INR 0 0.0 0.0 2025-11-07 22:39:17