fx_franchise_order_product

4,933 rows · 33 columns · page 38 / 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
1851 1864 1 232 12554 35 Sanitary Pad (15 pcs) NULL 9619001 10 40.0 380.0 0.0 0.0 304.0 304.0 0.0 3800.0 400.0 3040.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 3040.0 INR 0 0.0 0.0 2025-11-13 14:36:11
1852 1865 1 233 12516 35 Sanitary Pad (15 pcs) NULL 9619001 5 40.0 380.0 0.0 0.0 304.0 304.0 0.0 1900.0 200.0 1520.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 1520.0 INR 0 0.0 0.0 2025-11-13 14:38:24
1853 1866 1 234 12555 19 Fat loss Juice 500 ml NULL 30049011 15 250.0 1499.0 0.0 0.0 1479.0 1408.57 70.43 22485.0 3750.0 22185.0 2.5 528.22 2.5 528.22 0.0 0.0 1408.57 1056.43 22185.0 INR 0 0.0 0.0 2025-11-13 14:44:35
1854 1867 1 235 12554 19 Fat loss Juice 500 ml NULL 30049011 20 250.0 1499.0 0.0 0.0 1479.0 1408.57 70.43 29980.0 5000.0 29580.0 2.5 704.28 2.5 704.28 0.0 0.0 1408.57 1408.57 29580.0 INR 0 0.0 0.0 2025-11-13 14:46:32
1855 1868 1 236 12516 19 Fat loss Juice 500 ml NULL 30049011 10 250.0 1499.0 0.0 0.0 1479.0 1408.57 70.43 14990.0 2500.0 14790.0 2.5 352.14 2.5 352.14 0.0 0.0 1408.57 704.29 14790.0 INR 0 0.0 0.0 2025-11-13 14:49:10
1856 1869 1 237 12555 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-13 16:02:29
1857 1870 1 238 12554 74 EXPLORER BOX NULL NULL 10 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 269970.0 0.0 104990.0 2.5 2499.76 2.5 2499.76 0.0 0.0 9999.05 4999.52 104990.0 INR 0 0.0 0.0 2025-11-13 16:03:11
1858 1871 1 239 12555 52 Bhoo sanjeevni 5 kg NULL 3103100 20 450.0 1600.0 0.0 0.0 1280.0 1219.05 60.95 32000.0 9000.0 25600.0 2.5 609.52 2.5 609.52 0.0 0.0 1219.05 1219.05 25600.0 INR 0 0.0 0.0 2025-11-14 12:30:19
1859 1872 2 239 12555 53 Terra care 2 kg NULL 3103100 20 450.0 1500.0 0.0 0.0 1200.0 1142.86 57.14 30000.0 9000.0 24000.0 2.5 571.43 2.5 571.43 0.0 0.0 1142.86 1142.86 24000.0 INR 0 0.0 0.0 2025-11-14 12:30:19
1860 1873 1 240 12551 48 glow face wash NULL 3304999 11 250.0 380.0 0.0 0.0 304.0 257.63 46.37 4180.0 2750.0 3344.0 9.0 255.05 9.0 255.05 0.0 0.0 257.63 510.1 3344.0 INR 0 0.0 0.0 2025-11-14 14:45:32
1861 1874 2 240 12551 21 All Fuel Juice NULL 22029990 3 350.0 2499.0 0.0 0.0 2479.0 2360.95 118.05 7497.0 1050.0 7437.0 2.5 177.07 2.5 177.07 0.0 0.0 2360.95 354.14 7437.0 INR 0 0.0 0.0 2025-11-14 14:45:32
1862 1875 3 240 12551 6 Asthma Care NULL 30049011 2 250.0 899.0 0.0 0.0 719.2 684.95 34.25 1798.0 500.0 1438.4 2.5 34.25 2.5 34.25 0.0 0.0 684.95 68.5 1438.4 INR 0 0.0 0.0 2025-11-14 14:45:32
1863 1876 4 240 12551 40 Bamboo Brush NULL 96032100 21 25.0 110.0 0.0 0.0 88.0 74.58 13.42 2310.0 525.0 1848.0 9.0 140.95 9.0 140.95 0.0 0.0 74.58 281.9 1848.0 INR 0 0.0 0.0 2025-11-14 14:45:32
1864 1877 5 240 12551 52 Bhoo sanjeevni 5 kg NULL 3103100 40 450.0 1600.0 0.0 0.0 1280.0 1219.05 60.95 64000.0 18000.0 51200.0 2.5 1219.05 2.5 1219.05 0.0 0.0 1219.05 2438.1 51200.0 INR 0 0.0 0.0 2025-11-14 14:45:32
1865 1878 6 240 12551 71 Bio magnetic water pad NULL 9404 4 1000.0 4500.0 0.0 0.0 3600.0 3428.57 171.43 18000.0 4000.0 14400.0 2.5 342.86 2.5 342.86 0.0 0.0 3428.57 685.71 14400.0 INR 0 0.0 0.0 2025-11-14 14:45:32
1866 1879 7 240 12551 19 Fat loss Juice 500 ml NULL 30049011 3 250.0 1499.0 0.0 0.0 1479.0 1408.57 70.43 4497.0 750.0 4437.0 2.5 105.64 2.5 105.64 0.0 0.0 1408.57 211.29 4437.0 INR 0 0.0 0.0 2025-11-14 14:45:32
1867 1880 8 240 12551 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-14 14:45:32
1868 1881 9 240 12551 60 Foot patch NULL 30051090 2 500.0 1999.0 0.0 0.0 1599.2 1523.05 76.15 3998.0 1000.0 3198.4 2.5 76.15 2.5 76.15 0.0 0.0 1523.05 152.3 3198.4 INR 0 0.0 0.0 2025-11-14 14:45:32
1869 1882 10 240 12551 58 Green shield 250ml NULL 3105 11 800.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 27500.0 8800.0 22000.0 2.5 523.81 2.5 523.81 0.0 0.0 1904.76 1047.62 22000.0 INR 0 0.0 0.0 2025-11-14 14:45:32
1870 1883 11 240 12551 55 Grow master 500ml NULL 3105 20 850.0 2030.0 0.0 0.0 1624.0 1546.67 77.33 40600.0 17000.0 32480.0 2.5 773.34 2.5 773.34 0.0 0.0 1546.67 1546.67 32480.0 INR 0 0.0 0.0 2025-11-14 14:45:32
1871 1884 12 240 12551 2 Heart Care Capsules NULL 2936900 3 425.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 4497.0 1275.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-14 14:45:32
1872 1885 13 240 12551 33 Herbal Soap 100gm NULL 30049011 54 28.0 100.0 0.0 0.0 80.0 76.19 3.81 5400.0 1512.0 4320.0 2.5 102.86 2.5 102.86 0.0 0.0 76.19 205.71 4320.0 INR 0 0.0 0.0 2025-11-14 14:45:32
1873 1886 14 240 12551 34 Herbo2o Toothpaste NULL 33061090 22 45.0 199.0 0.0 0.0 159.2 134.92 24.28 4378.0 990.0 3502.4 9.0 267.13 9.0 267.13 0.0 0.0 134.92 534.26 3502.4 INR 0 0.0 0.0 2025-11-14 14:45:32
1874 1887 15 240 12551 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-14 14:45:32
1875 1888 16 240 12551 30 Iron Capsules NULL 30049011 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-14 14:45:32
1876 1889 17 240 12551 15 Kidney Stone Juice NULL 2009899 3 120.0 349.0 0.0 0.0 279.2 265.9 13.3 1047.0 360.0 837.6 2.5 19.95 2.5 19.95 0.0 0.0 265.9 39.89 837.6 INR 0 0.0 0.0 2025-11-14 14:45:32
1877 1890 18 240 12551 18 Lady Care Juice 500ml NULL 2009899 3 250.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 4497.0 750.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-14 14:45:32
1878 1891 19 240 12551 16 Liver Care Juice NULL 2009899 3 120.0 349.0 0.0 0.0 279.2 265.9 13.3 1047.0 360.0 837.6 2.5 19.95 2.5 19.95 0.0 0.0 265.9 39.89 837.6 INR 0 0.0 0.0 2025-11-14 14:45:32
1879 1892 20 240 12551 25 Manicalcium Tablets NULL 2009899 3 95.0 399.0 0.0 0.0 319.2 304.0 15.2 1197.0 285.0 957.6 2.5 22.8 2.5 22.8 0.0 0.0 304.0 45.6 957.6 INR 0 0.0 0.0 2025-11-14 14:45:32
1880 1893 21 240 12551 12 Melatonin 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-14 14:45:32
1881 1894 22 240 12551 17 Memory Booster Juice NULL 2009899 3 120.0 349.0 0.0 0.0 279.2 265.9 13.3 1047.0 360.0 837.6 2.5 19.95 2.5 19.95 0.0 0.0 265.9 39.89 837.6 INR 0 0.0 0.0 2025-11-14 14:45:32
1882 1895 23 240 12551 56 Micro magic 500ml NULL 3105 20 850.0 2030.0 0.0 0.0 1624.0 1376.27 247.73 40600.0 17000.0 32480.0 9.0 2477.29 9.0 2477.29 0.0 0.0 1376.27 4954.58 32480.0 INR 0 0.0 0.0 2025-11-14 14:45:32
1883 1896 24 240 12551 32 Neem Soap 100gm NULL 34011110 55 10.0 60.0 0.0 0.0 48.0 45.71 2.29 3300.0 550.0 2640.0 2.5 62.85 2.5 62.85 0.0 0.0 45.71 125.71 2640.0 INR 0 0.0 0.0 2025-11-14 14:45:32
1884 1897 25 240 12551 28 Ortho Joint Shield 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-14 14:45:32
1885 1898 26 240 12551 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-14 14:45:32
1886 1899 27 240 12551 13 Premium NONI VEG caps NULL 2936900 1 150.0 501.0 0.0 0.0 400.8 381.71 19.09 501.0 150.0 400.8 2.5 9.54 2.5 9.54 0.0 0.0 381.71 19.09 400.8 INR 0 0.0 0.0 2025-11-14 14:45:32
1887 1900 28 240 12551 57 Safe guard 250ml NULL 3105 21 800.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 52500.0 16800.0 42000.0 2.5 1000.0 2.5 1000.0 0.0 0.0 1904.76 2000.0 42000.0 INR 0 0.0 0.0 2025-11-14 14:45:32
1888 1901 29 240 12551 35 Sanitary Pad (15 pcs) NULL 9619001 4 40.0 380.0 0.0 0.0 304.0 304.0 0.0 1520.0 160.0 1216.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 1216.0 INR 0 0.0 0.0 2025-11-14 14:45:32
1889 1902 30 240 12551 29 Shilajith NULL 30049011 3 250.0 1800.0 0.0 0.0 1440.0 1371.43 68.57 5400.0 750.0 4320.0 2.5 102.86 2.5 102.86 0.0 0.0 1371.43 205.71 4320.0 INR 0 0.0 0.0 2025-11-14 14:45:32
1890 1903 31 240 12551 1 Stem Cell Powder NULL 2936900 6 749.0 2499.0 0.0 0.0 1999.2 1904.0 95.2 14994.0 4494.0 11995.2 2.5 285.6 2.5 285.6 0.0 0.0 1904.0 571.2 11995.2 INR 0 0.0 0.0 2025-11-14 14:45:32
1891 1904 32 240 12551 53 Terra care 2 kg NULL 3103100 46 450.0 1500.0 0.0 0.0 1200.0 1142.86 57.14 69000.0 20700.0 55200.0 2.5 1314.29 2.5 1314.29 0.0 0.0 1142.86 2628.57 55200.0 INR 0 0.0 0.0 2025-11-14 14:45:32
1892 1905 33 240 12551 5 Thyro Care 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-14 14:45:32
1893 1906 34 240 12551 44 Vital Glow Face Scrub NULL 3304300 2 71.0 325.0 0.0 0.0 260.0 220.34 39.66 650.0 142.0 520.0 9.0 39.66 9.0 39.66 0.0 0.0 220.34 79.32 520.0 INR 0 0.0 0.0 2025-11-14 14:45:32
1894 1907 35 240 12551 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-14 14:45:32
1895 1908 36 240 12551 10 Vitamin D3 Drop NULL 2106909 3 190.0 749.0 0.0 0.0 599.2 570.67 28.53 2247.0 570.0 1797.6 2.5 42.8 2.5 42.8 0.0 0.0 570.67 85.6 1797.6 INR 0 0.0 0.0 2025-11-14 14:45:32
1896 1909 37 240 12551 23 Women Fuel Juice NULL 2202999 3 200.0 1999.0 0.0 0.0 1599.2 1523.05 76.15 5997.0 600.0 4797.6 2.5 114.23 2.5 114.23 0.0 0.0 1523.05 228.46 4797.6 INR 0 0.0 0.0 2025-11-14 14:45:32
1897 1910 38 240 12551 54 Wonder grow 100ml NULL 3105 50 500.0 1400.0 0.0 0.0 1120.0 1066.67 53.33 70000.0 25000.0 56000.0 2.5 1333.34 2.5 1333.34 0.0 0.0 1066.67 2666.67 56000.0 INR 0 0.0 0.0 2025-11-14 14:45:32
1898 1911 1 241 12551 77 ELITE COMFORT NULL NULL 3 0.0 53994.0 0.0 0.0 18500.0 17619.05 880.95 161982.0 0.0 55500.0 2.5 1321.43 2.5 1321.43 0.0 0.0 17619.05 2642.86 55500.0 INR 0 0.0 0.0 2025-11-14 14:49:55
1899 1912 1 242 12516 21 All Fuel Juice NULL 22029990 10 350.0 2499.0 0.0 0.0 2479.0 2360.95 118.05 24990.0 3500.0 24790.0 2.5 590.24 2.5 590.24 0.0 0.0 2360.95 1180.48 24790.0 INR 0 0.0 0.0 2025-11-14 15:33:11
1900 1913 2 242 12516 40 Bamboo Brush NULL 96032100 20 25.0 110.0 0.0 0.0 88.0 74.58 13.42 2200.0 500.0 1760.0 9.0 134.24 9.0 134.24 0.0 0.0 74.58 268.47 1760.0 INR 0 0.0 0.0 2025-11-14 15:33:11