fx_franchise_order_product

4,933 rows · 33 columns · page 15 / 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
701 714 7 84 12517 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 0.0 0.0 0.0 0.0 18.0 9151.93 10168.81 9151.93 59996.0 INR 0 0.0 0.0 2025-11-07 23:11:39
702 715 8 84 12517 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 0.0 0.0 0.0 0.0 5.0 590.24 2360.95 590.24 12395.0 INR 0 0.0 0.0 2025-11-07 23:11:39
703 716 9 84 12517 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 0.0 0.0 0.0 0.0 5.0 821.94 684.95 821.94 17260.8 INR 0 0.0 0.0 2025-11-07 23:11:39
704 717 10 84 12517 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 0.0 0.0 0.0 0.0 18.0 1141.02 74.58 1141.02 7480.0 INR 0 0.0 0.0 2025-11-07 23:11:39
705 718 11 84 12517 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 0.0 0.0 0.0 0.0 5.0 4144.76 1219.05 4144.76 87040.0 INR 0 0.0 0.0 2025-11-07 23:11:39
706 719 12 84 12517 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 0.0 0.0 0.0 0.0 5.0 1028.57 3428.57 1028.57 21600.0 INR 0 0.0 0.0 2025-11-07 23:11:39
707 720 13 84 12517 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 0.0 0.0 0.0 0.0 5.0 1688.61 456.38 1688.61 35460.8 INR 0 0.0 0.0 2025-11-07 23:11:39
708 721 14 84 12517 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 0.0 0.0 0.0 0.0 5.0 1541.14 684.95 1541.14 32364.0 INR 0 0.0 0.0 2025-11-07 23:11:39
709 722 15 84 12517 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 0.0 0.0 0.0 0.0 18.0 5529.36 155.93 5529.36 36248.0 INR 0 0.0 0.0 2025-11-07 23:11:39
710 723 16 84 12517 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 0.0 0.0 0.0 0.0 18.0 8123.31 271.86 8123.31 53252.8 INR 0 0.0 0.0 2025-11-07 23:11:39
711 724 17 84 12517 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 0.0 0.0 0.0 0.0 5.0 493.0 1408.57 493.0 10353.0 INR 0 0.0 0.0 2025-11-07 23:11:39
712 725 18 84 12517 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 0.0 0.0 0.0 0.0 5.0 376.95 1884.76 376.95 7916.0 INR 0 0.0 0.0 2025-11-07 23:11:39
713 726 19 84 12517 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 0.0 0.0 0.0 0.0 18.0 3035.59 134.92 3035.59 19900.0 INR 0 0.0 0.0 2025-11-07 23:11:39
714 727 20 84 12517 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 0.0 0.0 0.0 0.0 5.0 3959.92 1523.05 3959.92 83158.4 INR 0 0.0 0.0 2025-11-07 23:11:39
715 728 21 84 12517 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 0.0 0.0 0.0 0.0 5.0 1333.33 1904.76 1333.33 28000.0 INR 0 0.0 0.0 2025-11-07 23:11:39
716 729 22 84 12517 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 0.0 0.0 0.0 0.0 5.0 2552.0 1546.67 2552.0 53592.0 INR 0 0.0 0.0 2025-11-07 23:11:39
717 730 23 84 12517 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 0.0 0.0 0.0 0.0 5.0 571.05 1142.1 571.05 11992.0 INR 0 0.0 0.0 2025-11-07 23:11:39
718 731 24 84 12517 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 0.0 0.0 0.0 0.0 5.0 6068.57 76.19 6068.57 127440.0 INR 0 0.0 0.0 2025-11-07 23:11:39
719 732 25 84 12517 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 0.0 0.0 0.0 0.0 18.0 14497.99 134.92 14497.99 95042.4 INR 0 0.0 0.0 2025-11-07 23:11:39
720 733 26 84 12517 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 0.0 0.0 0.0 0.0 5.0 171.31 1142.1 171.31 3597.6 INR 0 0.0 0.0 2025-11-07 23:11:39
721 734 27 84 12517 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 0.0 0.0 0.0 0.0 5.0 513.71 684.95 513.71 10788.0 INR 0 0.0 0.0 2025-11-07 23:11:39
722 735 28 84 12517 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 0.0 0.0 0.0 0.0 5.0 146.25 265.9 146.25 3071.2 INR 0 0.0 0.0 2025-11-07 23:11:39
723 736 29 84 12517 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 0.0 0.0 0.0 0.0 5.0 913.68 1142.1 913.68 19187.2 INR 0 0.0 0.0 2025-11-07 23:11:39
724 737 30 84 12517 16 Liver Care Juice NULL 2009899 46 120.0 349.0 0.0 0.0 279.2 265.9 13.3 16054.0 5520.0 12843.2 0.0 0.0 0.0 0.0 5.0 611.58 265.9 611.58 12843.2 INR 0 0.0 0.0 2025-11-07 23:11:39
725 738 31 84 12517 25 Manicalcium Tablets NULL 2009899 23 95.0 399.0 0.0 0.0 319.2 304.0 15.2 9177.0 2185.0 7341.6 0.0 0.0 0.0 0.0 5.0 349.6 304.0 349.6 7341.6 INR 0 0.0 0.0 2025-11-07 23:11:39
726 739 32 84 12517 12 Melatonin Drop NULL 2106909 38 190.0 749.0 0.0 0.0 599.2 570.67 28.53 28462.0 7220.0 22769.6 0.0 0.0 0.0 0.0 5.0 1084.27 570.67 1084.27 22769.6 INR 0 0.0 0.0 2025-11-07 23:11:39
727 740 33 84 12517 17 Memory Booster Juice NULL 2009899 52 120.0 349.0 0.0 0.0 279.2 265.9 13.3 18148.0 6240.0 14518.4 0.0 0.0 0.0 0.0 5.0 691.35 265.9 691.35 14518.4 INR 0 0.0 0.0 2025-11-07 23:11:39
728 741 34 84 12517 56 Micro magic 500ml NULL 3105 24 850.0 2030.0 0.0 0.0 1624.0 1376.27 247.73 48720.0 20400.0 38976.0 0.0 0.0 0.0 0.0 18.0 5945.49 1376.27 5945.49 38976.0 INR 0 0.0 0.0 2025-11-07 23:11:39
729 742 35 84 12517 7 Morning Fresh Churan NULL 30049011 157 40.0 199.0 0.0 0.0 159.2 151.62 7.58 31243.0 6280.0 24994.4 0.0 0.0 0.0 0.0 5.0 1190.21 151.62 1190.21 24994.4 INR 0 0.0 0.0 2025-11-07 23:11:39
730 743 36 84 12517 32 Neem Soap 100gm NULL 34011110 3122 10.0 60.0 0.0 0.0 48.0 45.71 2.29 187320.0 31220.0 149856.0 0.0 0.0 0.0 0.0 5.0 7136.0 45.71 7136.0 149856.0 INR 0 0.0 0.0 2025-11-07 23:11:39
731 744 37 84 12517 9 Omega 369 NULL 2936900 57 260.0 999.0 0.0 0.0 799.2 761.14 38.06 56943.0 14820.0 45554.4 0.0 0.0 0.0 0.0 5.0 2169.26 761.14 2169.26 45554.4 INR 0 0.0 0.0 2025-11-07 23:11:39
732 745 38 84 12517 28 Ortho Joint Shield NULL 2009899 14 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 20986.0 6300.0 16788.8 0.0 0.0 0.0 0.0 5.0 799.47 1142.1 799.47 16788.8 INR 0 0.0 0.0 2025-11-07 23:11:39
733 746 39 84 12517 72 Pain Relief Patch NULL 30051090 52 200.0 800.0 0.0 0.0 640.0 609.52 30.48 41600.0 10400.0 33280.0 0.0 0.0 0.0 0.0 5.0 1584.76 609.52 1584.76 33280.0 INR 0 0.0 0.0 2025-11-07 23:11:39
734 747 40 84 12517 8 Piles Care NULL 30049011 49 250.0 899.0 0.0 0.0 719.2 684.95 34.25 44051.0 12250.0 35240.8 0.0 0.0 0.0 0.0 5.0 1678.13 684.95 1678.13 35240.8 INR 0 0.0 0.0 2025-11-07 23:11:39
735 748 41 84 12517 41 Premium Coco Body Lotion NULL 3304300 25 250.0 699.0 0.0 0.0 559.2 473.9 85.3 17475.0 6250.0 13980.0 0.0 0.0 0.0 0.0 18.0 2132.54 473.9 2132.54 13980.0 INR 0 0.0 0.0 2025-11-07 23:11:39
736 749 42 84 12517 14 Premium Aloe Vera VEG caps NULL 2936900 5 100.0 359.0 0.0 0.0 287.2 273.52 13.68 1795.0 500.0 1436.0 0.0 0.0 0.0 0.0 5.0 68.38 273.52 68.38 1436.0 INR 0 0.0 0.0 2025-11-07 23:11:39
737 750 43 84 12517 47 Premium Hair Care Shampoo NULL 3305109 78 150.0 699.0 0.0 0.0 559.2 532.57 26.63 54522.0 11700.0 43617.6 0.0 0.0 0.0 0.0 5.0 2077.03 532.57 2077.03 43617.6 INR 0 0.0 0.0 2025-11-07 23:11:39
738 751 44 84 12517 13 Premium NONI VEG caps NULL 2936900 27 150.0 501.0 0.0 0.0 400.8 381.71 19.09 13527.0 4050.0 10821.6 0.0 0.0 0.0 0.0 5.0 515.31 381.71 515.31 10821.6 INR 0 0.0 0.0 2025-11-07 23:11:39
739 752 45 84 12517 45 Premium radiance face serum NULL 3304991 16 300.0 1200.0 0.0 0.0 960.0 813.56 146.44 19200.0 4800.0 15360.0 0.0 0.0 0.0 0.0 18.0 2343.05 813.56 2343.05 15360.0 INR 0 0.0 0.0 2025-11-07 23:11:39
740 753 46 84 12517 43 Quench Kiss Lip Balm NULL 3304300 15 35.0 199.0 0.0 0.0 159.2 134.92 24.28 2985.0 525.0 2388.0 0.0 0.0 0.0 0.0 18.0 364.27 134.92 364.27 2388.0 INR 0 0.0 0.0 2025-11-07 23:11:39
741 754 47 84 12517 46 Root Vitality Hair Oil NULL 3305901 59 54.0 255.0 0.0 0.0 204.0 194.29 9.71 15045.0 3186.0 12036.0 0.0 0.0 0.0 0.0 5.0 573.14 194.29 573.14 12036.0 INR 0 0.0 0.0 2025-11-07 23:11:39
742 755 48 84 12517 57 Safe guard 250ml NULL 3105 24 800.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 60000.0 19200.0 48000.0 0.0 0.0 0.0 0.0 5.0 2285.71 1904.76 2285.71 48000.0 INR 0 0.0 0.0 2025-11-07 23:11:39
743 756 49 84 12517 35 Sanitary Pad (15 pcs) NULL 9619001 370 40.0 380.0 0.0 0.0 304.0 304.0 0.0 140600.0 14800.0 112480.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 112480.0 INR 0 0.0 0.0 2025-11-07 23:11:39
744 757 50 84 12517 29 Shilajith NULL 30049011 21 250.0 1800.0 0.0 0.0 1440.0 1371.43 68.57 37800.0 5250.0 30240.0 0.0 0.0 0.0 0.0 5.0 1440.0 1371.43 1440.0 30240.0 INR 0 0.0 0.0 2025-11-07 23:11:39
745 758 51 84 12517 26 Spirulina Cap NULL 2009899 30 190.0 899.0 0.0 0.0 719.2 684.95 34.25 26970.0 5700.0 21576.0 0.0 0.0 0.0 0.0 5.0 1027.43 684.95 1027.43 21576.0 INR 0 0.0 0.0 2025-11-07 23:11:39
746 759 52 84 12517 1 Stem Cell Powder NULL 2936900 55 749.0 2499.0 0.0 0.0 1999.2 1904.0 95.2 137445.0 41195.0 109956.0 0.0 0.0 0.0 0.0 5.0 5236.0 1904.0 5236.0 109956.0 INR 0 0.0 0.0 2025-11-07 23:11:39
747 760 53 84 12517 50 Sun Screen NULL 330499 44 250.0 699.0 0.0 0.0 559.2 473.9 85.3 30756.0 11000.0 24604.8 0.0 0.0 0.0 0.0 18.0 3753.27 473.9 3753.27 24604.8 INR 0 0.0 0.0 2025-11-07 23:11:39
748 761 54 84 12517 59 T Shirt NULL 61099010 1 0.0 1400.0 0.0 0.0 1120.0 1066.67 53.33 1400.0 0.0 1120.0 0.0 0.0 0.0 0.0 5.0 53.33 1066.67 53.33 1120.0 INR 0 0.0 0.0 2025-11-07 23:11:39
749 762 55 84 12517 53 Terra care 2 kg NULL 3103100 71 450.0 1500.0 0.0 0.0 1200.0 1142.86 57.14 106500.0 31950.0 85200.0 0.0 0.0 0.0 0.0 5.0 4057.14 1142.86 4057.14 85200.0 INR 0 0.0 0.0 2025-11-07 23:11:39
750 763 56 84 12517 5 Thyro Care NULL 2936900 21 250.0 899.0 0.0 0.0 719.2 684.95 34.25 18879.0 5250.0 15103.2 0.0 0.0 0.0 0.0 5.0 719.2 684.95 719.2 15103.2 INR 0 0.0 0.0 2025-11-07 23:11:39