fx_franchise_order_product

4,933 rows · 33 columns · page 39 / 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
1901 1914 3 242 12516 52 Bhoo sanjeevni 5 kg NULL 3103100 50 450.0 1600.0 0.0 0.0 1280.0 1219.05 60.95 80000.0 22500.0 64000.0 2.5 1523.81 2.5 1523.81 0.0 0.0 1219.05 3047.62 64000.0 INR 0 0.0 0.0 2025-11-14 15:33:11
1902 1915 4 242 12516 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-14 15:33:11
1903 1916 5 242 12516 22 Fit Fuel Juice NULL 2009899 10 200.0 1999.0 0.0 0.0 1979.0 1884.76 94.24 19990.0 2000.0 19790.0 2.5 471.19 2.5 471.19 0.0 0.0 1884.76 942.38 19790.0 INR 0 0.0 0.0 2025-11-14 15:33:11
1904 1917 6 242 12516 24 Immunomax 24/7 Caps 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-14 15:33:11
1905 1918 7 242 12516 18 Lady Care Juice 500ml NULL 2009899 20 250.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 29980.0 5000.0 23984.0 2.5 571.05 2.5 571.05 0.0 0.0 1142.1 1142.1 23984.0 INR 0 0.0 0.0 2025-11-14 15:33:11
1906 1919 8 242 12516 35 Sanitary Pad (15 pcs) NULL 9619001 20 40.0 380.0 0.0 0.0 304.0 304.0 0.0 7600.0 800.0 6080.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 6080.0 INR 0 0.0 0.0 2025-11-14 15:33:11
1907 1920 9 242 12516 23 Women Fuel Juice NULL 2202999 10 200.0 1999.0 0.0 0.0 1599.2 1523.05 76.15 19990.0 2000.0 15992.0 2.5 380.76 2.5 380.76 0.0 0.0 1523.05 761.52 15992.0 INR 0 0.0 0.0 2025-11-14 15:33:11
1908 1921 1 243 12516 10 Vitamin D3 Drop NULL 2106909 5 190.0 749.0 0.0 0.0 599.2 570.67 28.53 3745.0 950.0 2996.0 2.5 71.33 2.5 71.33 0.0 0.0 570.67 142.67 2996.0 INR 0 0.0 0.0 2025-11-14 15:37:49
1909 1922 1 244 12516 71 Bio magnetic water pad NULL 9404 10 1000.0 4500.0 0.0 0.0 3600.0 3428.57 171.43 45000.0 10000.0 36000.0 2.5 857.14 2.5 857.14 0.0 0.0 3428.57 1714.29 36000.0 INR 0 0.0 0.0 2025-11-14 15:40:01
1910 1923 1 245 12855 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 15:47:27
1911 1924 1 246 12855 52 Bhoo sanjeevni 5 kg NULL 3103100 8 450.0 1600.0 0.0 0.0 1280.0 1219.05 60.95 12800.0 3600.0 10240.0 2.5 243.81 2.5 243.81 0.0 0.0 1219.05 487.62 10240.0 INR 0 0.0 0.0 2025-11-14 17:24:56
1912 1925 1 247 12855 52 Bhoo sanjeevni 5 kg NULL 3103100 8 450.0 1600.0 0.0 0.0 1280.0 1219.05 60.95 12800.0 3600.0 10240.0 2.5 243.81 2.5 243.81 0.0 0.0 1219.05 487.62 10240.0 INR 0 0.0 0.0 2025-11-14 17:41:01
1913 1926 1 248 12555 70 Premium Hand belt NULL 9404 20 600.0 9999.0 0.0 0.0 1440.0 1371.43 68.57 199980.0 12000.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-17 12:26:01
1914 1927 1 249 12554 70 Premium Hand belt NULL 9404 20 600.0 9999.0 0.0 0.0 1440.0 1371.43 68.57 199980.0 12000.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-17 12:26:25
1915 1928 1 250 12551 3 BP Care Capsules NULL 2936900 5 160.0 599.0 0.0 0.0 479.2 456.38 22.82 2995.0 800.0 2396.0 2.5 57.05 2.5 57.05 0.0 0.0 456.38 114.1 2396.0 INR 0 0.0 0.0 2025-11-18 13:38:15
1916 1929 2 250 12551 4 Diabetic Care Capsules NULL 2936900 5 250.0 899.0 0.0 0.0 719.2 684.95 34.25 4495.0 1250.0 3596.0 2.5 85.62 2.5 85.62 0.0 0.0 684.95 171.24 3596.0 INR 0 0.0 0.0 2025-11-18 13:38:15
1917 1930 3 250 12551 7 Morning Fresh Churan NULL 30049011 10 40.0 199.0 0.0 0.0 159.2 151.62 7.58 1990.0 400.0 1592.0 2.5 37.91 2.5 37.91 0.0 0.0 151.62 75.81 1592.0 INR 0 0.0 0.0 2025-11-18 13:38:15
1918 1931 4 250 12551 32 Neem Soap 100gm NULL 34011110 1110 10.0 60.0 0.0 0.0 48.0 45.71 2.29 66600.0 11100.0 53280.0 2.5 1268.57 2.5 1268.57 0.0 0.0 45.71 2537.14 53280.0 INR 0 0.0 0.0 2025-11-18 13:38:15
1919 1932 5 250 12551 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-18 13:38:15
1920 1933 1 251 12552 77 ELITE COMFORT NULL NULL 2 0.0 53994.0 0.0 0.0 18500.0 17619.05 880.95 107988.0 0.0 37000.0 2.5 880.95 2.5 880.95 0.0 0.0 17619.05 1761.9 37000.0 INR 0 0.0 0.0 2025-11-18 16:12:53
1921 1934 2 251 12552 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-18 16:12:53
1922 1935 1 252 12517 77 ELITE COMFORT NULL NULL 2 0.0 53994.0 0.0 0.0 18500.0 17619.05 880.95 107988.0 0.0 37000.0 0.0 0.0 0.0 0.0 5.0 1761.9 17619.05 1761.9 37000.0 INR 0 0.0 0.0 2025-11-18 17:22:34
1923 1936 2 252 12517 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 0.0 0.0 0.0 0.0 5.0 499.95 9999.05 499.95 10499.0 INR 0 0.0 0.0 2025-11-18 17:22:34
1924 1937 1 253 12555 74 EXPLORER BOX NULL NULL 30 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 809910.0 0.0 314970.0 2.5 7499.28 2.5 7499.28 0.0 0.0 9999.05 14998.57 314970.0 INR 0 0.0 0.0 2025-11-18 22:39:28
1925 1938 1 254 12554 74 EXPLORER BOX NULL NULL 40 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 1079880.0 0.0 419960.0 2.5 9999.05 2.5 9999.05 0.0 0.0 9999.05 19998.1 419960.0 INR 0 0.0 0.0 2025-11-18 22:41:31
1926 1939 1 255 12516 74 EXPLORER BOX NULL NULL 50 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 1349850.0 0.0 524950.0 2.5 12498.81 2.5 12498.81 0.0 0.0 9999.05 24997.62 524950.0 INR 0 0.0 0.0 2025-11-18 22:44:17
1927 1940 1 256 12555 47 Premium Hair Care Shampoo NULL 3305109 10 150.0 699.0 0.0 0.0 559.2 532.57 26.63 6990.0 1500.0 5592.0 2.5 133.15 2.5 133.15 0.0 0.0 532.57 266.29 5592.0 INR 0 0.0 0.0 2025-11-19 14:27:00
1928 1941 1 257 12555 48 glow face wash NULL 3304999 10 100.0 380.0 0.0 0.0 304.0 257.63 46.37 3800.0 1000.0 3040.0 9.0 231.87 9.0 231.87 0.0 0.0 257.63 463.73 3040.0 INR 0 0.0 0.0 2025-11-19 17:59:07
1929 1942 1 258 12555 17 Memory Booster 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-19 18:07:08
1930 1943 2 258 12555 8 Piles Care NULL 30049011 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-19 18:07:08
1931 1944 1 259 12554 8 Piles Care NULL 30049011 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-19 18:08:15
1932 1945 1 260 12516 8 Piles Care NULL 30049011 40 250.0 899.0 0.0 0.0 719.2 684.95 34.25 35960.0 10000.0 28768.0 2.5 684.95 2.5 684.95 0.0 0.0 684.95 1369.9 28768.0 INR 0 0.0 0.0 2025-11-19 18:09:08
1933 1946 1 261 12552 77 ELITE COMFORT NULL NULL 2 0.0 53994.0 0.0 0.0 18500.0 17619.05 880.95 107988.0 0.0 37000.0 2.5 880.95 2.5 880.95 0.0 0.0 17619.05 1761.9 37000.0 INR 0 0.0 0.0 2025-11-19 21:38:07
1934 1947 1 262 12855 48 glow face wash NULL 3304999 11 100.0 380.0 0.0 0.0 304.0 257.63 46.37 4180.0 1100.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-20 12:35:41
1935 1948 2 262 12855 32 Neem Soap 100gm NULL 34011110 1104 10.0 60.0 0.0 0.0 48.0 45.71 2.29 66240.0 11040.0 52992.0 2.5 1261.71 2.5 1261.71 0.0 0.0 45.71 2523.43 52992.0 INR 0 0.0 0.0 2025-11-20 12:35:41
1936 1949 1 263 12855 3 BP Care Capsules NULL 2936900 5 160.0 599.0 0.0 0.0 479.2 456.38 22.82 2995.0 800.0 2396.0 2.5 57.05 2.5 57.05 0.0 0.0 456.38 114.1 2396.0 INR 0 0.0 0.0 2025-11-20 13:59:55
1937 1950 2 263 12855 4 Diabetic Care Capsules NULL 2936900 5 250.0 899.0 0.0 0.0 719.2 684.95 34.25 4495.0 1250.0 3596.0 2.5 85.62 2.5 85.62 0.0 0.0 684.95 171.24 3596.0 INR 0 0.0 0.0 2025-11-20 13:59:55
1938 1951 3 263 12855 7 Morning Fresh Churan NULL 30049011 10 40.0 199.0 0.0 0.0 159.2 151.62 7.58 1990.0 400.0 1592.0 2.5 37.91 2.5 37.91 0.0 0.0 151.62 75.81 1592.0 INR 0 0.0 0.0 2025-11-20 13:59:55
1939 1952 1 264 12555 15 Kidney Stone 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-20 14:02:23
1940 1953 2 264 12555 7 Morning Fresh Churan NULL 30049011 30 40.0 199.0 0.0 0.0 159.2 151.62 7.58 5970.0 1200.0 4776.0 2.5 113.72 2.5 113.72 0.0 0.0 151.62 227.43 4776.0 INR 0 0.0 0.0 2025-11-20 14:02:23
1941 1954 3 264 12555 9 Omega 369 NULL 2936900 20 260.0 999.0 0.0 0.0 799.2 761.14 38.06 19980.0 5200.0 15984.0 2.5 380.57 2.5 380.57 0.0 0.0 761.14 761.14 15984.0 INR 0 0.0 0.0 2025-11-20 14:02:23
1942 1955 4 264 12555 72 Pain Relief Patch NULL 30051090 20 200.0 800.0 0.0 0.0 640.0 609.52 30.48 16000.0 4000.0 12800.0 2.5 304.76 2.5 304.76 0.0 0.0 609.52 609.52 12800.0 INR 0 0.0 0.0 2025-11-20 14:02:23
1943 1956 5 264 12555 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-20 14:02:23
1944 1957 6 264 12555 35 Sanitary Pad (15 pcs) NULL 9619001 40 40.0 380.0 0.0 0.0 304.0 304.0 0.0 15200.0 1600.0 12160.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 12160.0 INR 0 0.0 0.0 2025-11-20 14:02:23
1945 1958 1 265 12554 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-20 14:04:39
1946 1959 2 265 12554 35 Sanitary Pad (15 pcs) NULL 9619001 40 40.0 380.0 0.0 0.0 304.0 304.0 0.0 15200.0 1600.0 12160.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 12160.0 INR 0 0.0 0.0 2025-11-20 14:04:39
1947 1960 1 266 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-20 14:07:37
1948 1961 1 267 12516 35 Sanitary Pad (15 pcs) NULL 9619001 40 40.0 380.0 0.0 0.0 304.0 304.0 0.0 15200.0 1600.0 12160.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 12160.0 INR 0 0.0 0.0 2025-11-20 15:20:23
1949 1962 1 268 12555 44 Vital Glow Face Scrub NULL 3304300 20 71.0 325.0 0.0 0.0 260.0 220.34 39.66 6500.0 1420.0 5200.0 9.0 396.61 9.0 396.61 0.0 0.0 220.34 793.22 5200.0 INR 0 0.0 0.0 2025-11-20 17:46:39
1950 1963 1 269 12555 25 Manicalcium Tablets NULL 2009899 10 95.0 399.0 0.0 0.0 319.2 304.0 15.2 3990.0 950.0 3192.0 2.5 76.0 2.5 76.0 0.0 0.0 304.0 152.0 3192.0 INR 0 0.0 0.0 2025-11-20 22:15:12