fx_franchise_order_product

4,933 rows · 33 columns · page 14 / 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
651 664 19 82 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:56:50
652 665 20 82 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:56:50
653 666 21 82 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:56:50
654 667 22 82 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:56:50
655 668 23 82 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:56:50
656 669 24 82 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:56:50
657 670 25 82 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:56:50
658 671 26 82 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:56:50
659 672 27 82 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:56:50
660 673 28 82 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:56:50
661 674 29 82 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:56:50
662 675 30 82 12516 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 2.5 305.79 2.5 305.79 0.0 0.0 265.9 611.58 12843.2 INR 0 0.0 0.0 2025-11-07 22:56:50
663 676 31 82 12516 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 2.5 174.8 2.5 174.8 0.0 0.0 304.0 349.6 7341.6 INR 0 0.0 0.0 2025-11-07 22:56:50
664 677 32 82 12516 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 2.5 542.13 2.5 542.13 0.0 0.0 570.67 1084.27 22769.6 INR 0 0.0 0.0 2025-11-07 22:56:50
665 678 33 82 12516 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 2.5 345.68 2.5 345.68 0.0 0.0 265.9 691.35 14518.4 INR 0 0.0 0.0 2025-11-07 22:56:50
666 679 34 82 12516 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 9.0 2972.74 9.0 2972.74 0.0 0.0 1376.27 5945.49 38976.0 INR 0 0.0 0.0 2025-11-07 22:56:50
667 680 35 82 12516 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 2.5 595.11 2.5 595.11 0.0 0.0 151.62 1190.21 24994.4 INR 0 0.0 0.0 2025-11-07 22:56:50
668 681 36 82 12516 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 2.5 3568.0 2.5 3568.0 0.0 0.0 45.71 7136.0 149856.0 INR 0 0.0 0.0 2025-11-07 22:56:50
669 682 37 82 12516 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 2.5 1084.63 2.5 1084.63 0.0 0.0 761.14 2169.26 45554.4 INR 0 0.0 0.0 2025-11-07 22:56:50
670 683 38 82 12516 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 2.5 399.74 2.5 399.74 0.0 0.0 1142.1 799.47 16788.8 INR 0 0.0 0.0 2025-11-07 22:56:50
671 684 39 82 12516 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 2.5 792.38 2.5 792.38 0.0 0.0 609.52 1584.76 33280.0 INR 0 0.0 0.0 2025-11-07 22:56:50
672 685 40 82 12516 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 2.5 839.07 2.5 839.07 0.0 0.0 684.95 1678.13 35240.8 INR 0 0.0 0.0 2025-11-07 22:56:50
673 686 41 82 12516 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 9.0 1066.27 9.0 1066.27 0.0 0.0 473.9 2132.54 13980.0 INR 0 0.0 0.0 2025-11-07 22:56:50
674 687 42 82 12516 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 2.5 34.19 2.5 34.19 0.0 0.0 273.52 68.38 1436.0 INR 0 0.0 0.0 2025-11-07 22:56:50
675 688 43 82 12516 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 2.5 1038.52 2.5 1038.52 0.0 0.0 532.57 2077.03 43617.6 INR 0 0.0 0.0 2025-11-07 22:56:50
676 689 44 82 12516 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 2.5 257.65 2.5 257.65 0.0 0.0 381.71 515.31 10821.6 INR 0 0.0 0.0 2025-11-07 22:56:50
677 690 45 82 12516 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 9.0 1171.53 9.0 1171.53 0.0 0.0 813.56 2343.05 15360.0 INR 0 0.0 0.0 2025-11-07 22:56:50
678 691 46 82 12516 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 9.0 182.13 9.0 182.13 0.0 0.0 134.92 364.27 2388.0 INR 0 0.0 0.0 2025-11-07 22:56:50
679 692 47 82 12516 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 2.5 286.57 2.5 286.57 0.0 0.0 194.29 573.14 12036.0 INR 0 0.0 0.0 2025-11-07 22:56:50
680 693 48 82 12516 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 2.5 1142.86 2.5 1142.86 0.0 0.0 1904.76 2285.71 48000.0 INR 0 0.0 0.0 2025-11-07 22:56:50
681 694 49 82 12516 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 22:56:50
682 695 50 82 12516 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 2.5 720.0 2.5 720.0 0.0 0.0 1371.43 1440.0 30240.0 INR 0 0.0 0.0 2025-11-07 22:56:50
683 696 51 82 12516 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 2.5 513.72 2.5 513.72 0.0 0.0 684.95 1027.43 21576.0 INR 0 0.0 0.0 2025-11-07 22:56:50
684 697 52 82 12516 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 2.5 2618.0 2.5 2618.0 0.0 0.0 1904.0 5236.0 109956.0 INR 0 0.0 0.0 2025-11-07 22:56:50
685 698 53 82 12516 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 9.0 1876.63 9.0 1876.63 0.0 0.0 473.9 3753.27 24604.8 INR 0 0.0 0.0 2025-11-07 22:56:50
686 699 54 82 12516 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 2.5 26.66 2.5 26.66 0.0 0.0 1066.67 53.33 1120.0 INR 0 0.0 0.0 2025-11-07 22:56:50
687 700 55 82 12516 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 2.5 2028.57 2.5 2028.57 0.0 0.0 1142.86 4057.14 85200.0 INR 0 0.0 0.0 2025-11-07 22:56:50
688 701 56 82 12516 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 2.5 359.6 2.5 359.6 0.0 0.0 684.95 719.2 15103.2 INR 0 0.0 0.0 2025-11-07 22:56:50
689 702 57 82 12516 36 Toilet Cleaner 500ml NULL 3924101 180 30.0 150.0 0.0 0.0 120.0 101.69 18.31 27000.0 5400.0 21600.0 9.0 1647.46 9.0 1647.46 0.0 0.0 101.69 3294.92 21600.0 INR 0 0.0 0.0 2025-11-07 22:56:50
690 703 58 82 12516 11 Vitamin B12 Drop NULL 2106909 126 190.0 749.0 0.0 0.0 599.2 570.67 28.53 94374.0 23940.0 75499.2 2.5 1797.6 2.5 1797.6 0.0 0.0 570.67 3595.2 75499.2 INR 0 0.0 0.0 2025-11-07 22:56:50
691 704 59 82 12516 10 Vitamin D3 Drop NULL 2106909 131 190.0 749.0 0.0 0.0 599.2 570.67 28.53 98119.0 24890.0 78495.2 2.5 1868.93 2.5 1868.93 0.0 0.0 570.67 3737.87 78495.2 INR 0 0.0 0.0 2025-11-07 22:56:50
692 705 60 82 12516 23 Women Fuel Juice NULL 2202999 6 200.0 1999.0 0.0 0.0 1599.2 1523.05 76.15 11994.0 1200.0 9595.2 2.5 228.46 2.5 228.46 0.0 0.0 1523.05 456.91 9595.2 INR 0 0.0 0.0 2025-11-07 22:56:50
693 706 61 82 12516 54 Wonder grow 100ml NULL 3105 55 500.0 1400.0 0.0 0.0 1120.0 1066.67 53.33 77000.0 27500.0 61600.0 2.5 1466.66 2.5 1466.66 0.0 0.0 1066.67 2933.33 61600.0 INR 0 0.0 0.0 2025-11-07 22:56:50
694 707 1 83 12526 74 EXPLORER BOX NULL NULL 1 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 26997.0 0.0 10499.0 2.5 249.97 2.5 249.97 0.0 0.0 9999.05 499.95 10499.0 INR 0 0.0 0.0 2025-11-07 23:02:42
695 708 1 84 12517 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 0.0 0.0 0.0 0.0 18.0 2365.02 257.63 2365.02 15504.0 INR 0 0.0 0.0 2025-11-07 23:11:39
696 709 2 84 12517 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 0.0 0.0 0.0 0.0 5.0 399.73 1142.1 399.73 8394.4 INR 0 0.0 0.0 2025-11-07 23:11:39
697 710 3 84 12517 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 0.0 0.0 0.0 0.0 5.0 1656.67 3313.33 1656.67 34790.0 INR 0 0.0 0.0 2025-11-07 23:11:39
698 711 4 84 12517 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 0.0 0.0 0.0 0.0 5.0 6856.46 7618.29 6856.46 143985.6 INR 0 0.0 0.0 2025-11-07 23:11:39
699 712 5 84 12517 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 0.0 0.0 0.0 0.0 18.0 1219.12 677.29 1219.12 7992.0 INR 0 0.0 0.0 2025-11-07 23:11:39
700 713 6 84 12517 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 0.0 0.0 0.0 0.0 5.0 228.5 2284.95 228.5 4798.4 INR 0 0.0 0.0 2025-11-07 23:11:39