fx_franchise_order_product

4,933 rows · 33 columns · page 37 / 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
1801 1814 5 220 12516 3 BP Care Capsules NULL 2936900 100 160.0 599.0 0.0 0.0 479.2 456.38 22.82 59900.0 16000.0 47920.0 2.5 1140.95 2.5 1140.95 0.0 0.0 456.38 2281.9 47920.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1802 1815 6 220 12516 4 Diabetic Care Capsules NULL 2936900 100 250.0 899.0 0.0 0.0 719.2 684.95 34.25 89900.0 25000.0 71920.0 2.5 1712.38 2.5 1712.38 0.0 0.0 684.95 3424.76 71920.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1803 1816 7 220 12516 60 Foot patch NULL 30051090 100 500.0 1999.0 0.0 0.0 1599.2 1523.05 76.15 199900.0 50000.0 159920.0 2.5 3807.62 2.5 3807.62 0.0 0.0 1523.05 7615.24 159920.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1804 1817 8 220 12516 58 Green shield 250ml NULL 3105 100 800.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 250000.0 80000.0 200000.0 2.5 4761.9 2.5 4761.9 0.0 0.0 1904.76 9523.81 200000.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1805 1818 9 220 12516 55 Grow master 500ml NULL 3105 100 850.0 2030.0 0.0 0.0 1624.0 1546.67 77.33 203000.0 85000.0 162400.0 2.5 3866.66 2.5 3866.66 0.0 0.0 1546.67 7733.33 162400.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1806 1819 10 220 12516 2 Heart Care Capsules NULL 2936900 50 425.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 74950.0 21250.0 59960.0 2.5 1427.62 2.5 1427.62 0.0 0.0 1142.1 2855.24 59960.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1807 1820 11 220 12516 30 Iron Capsules NULL 30049011 30 250.0 899.0 0.0 0.0 719.2 684.95 34.25 26970.0 7500.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-12 17:31:01
1808 1821 12 220 12516 15 Kidney Stone Juice NULL 2009899 50 120.0 349.0 0.0 0.0 279.2 265.9 13.3 17450.0 6000.0 13960.0 2.5 332.38 2.5 332.38 0.0 0.0 265.9 664.76 13960.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1809 1822 13 220 12516 18 Lady Care Juice 500ml NULL 2009899 10 250.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 14990.0 2500.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-12 17:31:01
1810 1823 14 220 12516 16 Liver Care Juice NULL 2009899 50 120.0 349.0 0.0 0.0 279.2 265.9 13.3 17450.0 6000.0 13960.0 2.5 332.38 2.5 332.38 0.0 0.0 265.9 664.76 13960.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1811 1824 15 220 12516 25 Manicalcium Tablets NULL 2009899 50 95.0 399.0 0.0 0.0 319.2 304.0 15.2 19950.0 4750.0 15960.0 2.5 380.0 2.5 380.0 0.0 0.0 304.0 760.0 15960.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1812 1825 16 220 12516 12 Melatonin Drop NULL 2106909 50 190.0 749.0 0.0 0.0 599.2 570.67 28.53 37450.0 9500.0 29960.0 2.5 713.34 2.5 713.34 0.0 0.0 570.67 1426.67 29960.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1813 1826 17 220 12516 17 Memory Booster Juice NULL 2009899 50 120.0 349.0 0.0 0.0 279.2 265.9 13.3 17450.0 6000.0 13960.0 2.5 332.38 2.5 332.38 0.0 0.0 265.9 664.76 13960.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1814 1827 18 220 12516 56 Micro magic 500ml NULL 3105 100 850.0 2030.0 0.0 0.0 1624.0 1376.27 247.73 203000.0 85000.0 162400.0 9.0 12386.44 9.0 12386.44 0.0 0.0 1376.27 24772.88 162400.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1815 1828 19 220 12516 28 Ortho Joint Shield NULL 2009899 10 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 14990.0 4500.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-12 17:31:01
1816 1829 20 220 12516 72 Pain Relief Patch NULL 30051090 50 200.0 800.0 0.0 0.0 640.0 609.52 30.48 40000.0 10000.0 32000.0 2.5 761.9 2.5 761.9 0.0 0.0 609.52 1523.81 32000.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1817 1830 21 220 12516 41 Premium Coco Body Lotion NULL 3304300 50 250.0 699.0 0.0 0.0 559.2 473.9 85.3 34950.0 12500.0 27960.0 9.0 2132.54 9.0 2132.54 0.0 0.0 473.9 4265.08 27960.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1818 1831 22 220 12516 14 Premium Aloe Vera VEG caps NULL 2936900 30 100.0 359.0 0.0 0.0 287.2 273.52 13.68 10770.0 3000.0 8616.0 2.5 205.15 2.5 205.15 0.0 0.0 273.52 410.29 8616.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1819 1832 23 220 12516 43 Quench Kiss Lip Balm NULL 3304300 50 35.0 199.0 0.0 0.0 159.2 134.92 24.28 9950.0 1750.0 7960.0 9.0 607.12 9.0 607.12 0.0 0.0 134.92 1214.24 7960.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1820 1833 24 220 12516 46 Root Vitality Hair Oil NULL 3305901 100 54.0 255.0 0.0 0.0 204.0 194.29 9.71 25500.0 5400.0 20400.0 2.5 485.71 2.5 485.71 0.0 0.0 194.29 971.43 20400.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1821 1834 25 220 12516 57 Safe guard 250ml NULL 3105 100 800.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 250000.0 80000.0 200000.0 2.5 4761.9 2.5 4761.9 0.0 0.0 1904.76 9523.81 200000.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1822 1835 26 220 12516 35 Sanitary Pad (15 pcs) NULL 9619001 6 40.0 380.0 0.0 0.0 304.0 304.0 0.0 2280.0 240.0 1824.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 1824.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1823 1836 27 220 12516 29 Shilajith NULL 30049011 20 250.0 1800.0 0.0 0.0 1440.0 1371.43 68.57 36000.0 5000.0 28800.0 2.5 685.72 2.5 685.72 0.0 0.0 1371.43 1371.43 28800.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1824 1837 28 220 12516 26 Spirulina Cap NULL 2009899 100 190.0 899.0 0.0 0.0 719.2 684.95 34.25 89900.0 19000.0 71920.0 2.5 1712.38 2.5 1712.38 0.0 0.0 684.95 3424.76 71920.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1825 1838 29 220 12516 50 Sun Screen NULL 330499 100 250.0 699.0 0.0 0.0 559.2 473.9 85.3 69900.0 25000.0 55920.0 9.0 4265.09 9.0 4265.09 0.0 0.0 473.9 8530.17 55920.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1826 1839 30 220 12516 59 T Shirt NULL 61099010 5 0.0 1400.0 0.0 0.0 1120.0 1066.67 53.33 7000.0 0.0 5600.0 2.5 133.34 2.5 133.34 0.0 0.0 1066.67 266.67 5600.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1827 1840 31 220 12516 53 Terra care 2 kg NULL 3103100 100 450.0 1500.0 0.0 0.0 1200.0 1142.86 57.14 150000.0 45000.0 120000.0 2.5 2857.14 2.5 2857.14 0.0 0.0 1142.86 5714.29 120000.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1828 1841 32 220 12516 5 Thyro Care NULL 2936900 20 250.0 899.0 0.0 0.0 719.2 684.95 34.25 17980.0 5000.0 14384.0 2.5 342.48 2.5 342.48 0.0 0.0 684.95 684.95 14384.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1829 1842 33 220 12516 44 Vital Glow Face Scrub NULL 3304300 25 71.0 325.0 0.0 0.0 260.0 220.34 39.66 8125.0 1775.0 6500.0 9.0 495.76 9.0 495.76 0.0 0.0 220.34 991.53 6500.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1830 1843 34 220 12516 54 Wonder grow 100ml NULL 3105 100 500.0 1400.0 0.0 0.0 1120.0 1066.67 53.33 140000.0 50000.0 112000.0 2.5 2666.66 2.5 2666.66 0.0 0.0 1066.67 5333.33 112000.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1831 1844 1 221 12527 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-12 21:35:38
1832 1845 2 221 12527 46 Root Vitality Hair Oil NULL 3305901 5 54.0 255.0 0.0 0.0 204.0 194.29 9.71 1275.0 270.0 1020.0 2.5 24.29 2.5 24.29 0.0 0.0 194.29 48.57 1020.0 INR 0 0.0 0.0 2025-11-12 21:35:38
1833 1846 1 222 12527 2 Heart Care Capsules NULL 2936900 1 425.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 1499.0 425.0 1199.2 2.5 28.55 2.5 28.55 0.0 0.0 1142.1 57.1 1199.2 INR 0 0.0 0.0 2025-11-12 21:48:10
1834 1847 2 222 12527 34 Herbo2o Toothpaste NULL 33061090 30 45.0 199.0 0.0 0.0 159.2 134.92 24.28 5970.0 1350.0 4776.0 9.0 364.27 9.0 364.27 0.0 0.0 134.92 728.54 4776.0 INR 0 0.0 0.0 2025-11-12 21:48:10
1835 1848 3 222 12527 47 Premium Hair Care Shampoo NULL 3305109 3 150.0 699.0 0.0 0.0 559.2 532.57 26.63 2097.0 450.0 1677.6 2.5 39.95 2.5 39.95 0.0 0.0 532.57 79.89 1677.6 INR 0 0.0 0.0 2025-11-12 21:48:10
1836 1849 4 222 12527 35 Sanitary Pad (15 pcs) NULL 9619001 30 40.0 380.0 0.0 0.0 304.0 304.0 0.0 11400.0 1200.0 9120.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 9120.0 INR 0 0.0 0.0 2025-11-12 21:48:10
1837 1850 1 223 12535 77 ELITE COMFORT NULL NULL 9 0.0 53994.0 0.0 0.0 18500.0 17619.05 880.95 485946.0 0.0 166500.0 2.5 3964.28 2.5 3964.28 0.0 0.0 17619.05 7928.57 166500.0 INR 0 0.0 0.0 2025-11-13 12:24:53
1838 1851 2 223 12535 74 EXPLORER BOX NULL NULL 9 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 242973.0 0.0 94491.0 2.5 2249.78 2.5 2249.78 0.0 0.0 9999.05 4499.57 94491.0 INR 0 0.0 0.0 2025-11-13 12:24:53
1839 1852 1 224 12620 76 ELITE BOX NULL NULL 5 0.0 46494.0 0.0 0.0 18000.0 17142.86 857.14 232470.0 0.0 90000.0 2.5 2142.86 2.5 2142.86 0.0 0.0 17142.86 4285.71 90000.0 INR 0 0.0 0.0 2025-11-13 12:48:06
1840 1853 2 224 12620 74 EXPLORER BOX NULL NULL 8 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 215976.0 0.0 83992.0 2.5 1999.81 2.5 1999.81 0.0 0.0 9999.05 3999.62 83992.0 INR 0 0.0 0.0 2025-11-13 12:48:06
1841 1854 1 225 12620 77 ELITE COMFORT NULL NULL 9 0.0 53994.0 0.0 0.0 18500.0 17619.05 880.95 485946.0 0.0 166500.0 2.5 3964.28 2.5 3964.28 0.0 0.0 17619.05 7928.57 166500.0 INR 0 0.0 0.0 2025-11-13 12:53:34
1842 1855 2 225 12620 74 EXPLORER BOX NULL NULL 9 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 242973.0 0.0 94491.0 2.5 2249.78 2.5 2249.78 0.0 0.0 9999.05 4499.57 94491.0 INR 0 0.0 0.0 2025-11-13 12:53:34
1843 1856 1 226 12555 7 Morning Fresh Churan NULL 30049011 50 40.0 199.0 0.0 0.0 159.2 151.62 7.58 9950.0 2000.0 7960.0 2.5 189.53 2.5 189.53 0.0 0.0 151.62 379.05 7960.0 INR 0 0.0 0.0 2025-11-13 13:03:27
1844 1857 1 227 12555 15 Kidney Stone Juice NULL 2009899 20 120.0 349.0 0.0 0.0 279.2 265.9 13.29 6980.0 2400.0 5584.0 2.5 132.95 2.5 132.95 0.0 0.0 265.9 265.9 5584.0 INR 0 0.0 0.0 2025-11-13 13:19:26
1845 1858 2 227 12555 16 Liver Care Juice NULL 2009899 10 120.0 349.0 0.0 0.0 279.2 265.9 13.29 3490.0 1200.0 2792.0 2.5 66.47 2.5 66.47 0.0 0.0 265.9 132.95 2792.0 INR 0 0.0 0.0 2025-11-13 13:19:26
1846 1859 3 227 12555 43 Quench Kiss Lip Balm NULL 3304300 6 35.0 199.0 0.0 0.0 159.2 134.92 24.29 1194.0 210.0 955.2 9.0 72.86 9.0 72.86 0.0 0.0 134.92 145.71 955.2 INR 0 0.0 0.0 2025-11-13 13:19:26
1847 1860 1 228 12555 50 Sun Screen NULL 330499 20 250.0 699.0 0.0 0.0 559.2 473.9 85.3 13980.0 5000.0 11184.0 9.0 853.01 9.0 853.01 0.0 0.0 473.9 1706.03 11184.0 INR 0 0.0 0.0 2025-11-13 14:20:06
1848 1861 1 229 12555 46 Root Vitality Hair Oil NULL 3305901 10 54.0 255.0 0.0 0.0 204.0 194.29 9.71 2550.0 540.0 2040.0 2.5 48.57 2.5 48.57 0.0 0.0 194.29 97.14 2040.0 INR 0 0.0 0.0 2025-11-13 14:24:02
1849 1862 1 230 12554 46 Root Vitality Hair Oil NULL 3305901 20 54.0 255.0 0.0 0.0 204.0 194.29 9.71 5100.0 1080.0 4080.0 2.5 97.14 2.5 97.14 0.0 0.0 194.29 194.29 4080.0 INR 0 0.0 0.0 2025-11-13 14:25:14
1850 1863 1 231 12555 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:35:15