fx_franchise_order_product

4,933 rows · 33 columns · page 41 / 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
2001 2014 3 291 12554 12 Melatonin Drop NULL 2106909 10 190.0 749.0 0.0 0.0 599.2 570.67 28.53 7490.0 1900.0 5992.0 2.5 142.66 2.5 142.66 0.0 0.0 570.67 285.33 5992.0 INR 0 0.0 0.0 2025-11-28 13:18:20
2002 2015 4 291 12554 10 Vitamin D3 Drop NULL 2106909 10 190.0 749.0 0.0 0.0 599.2 570.67 28.53 7490.0 1900.0 5992.0 2.5 142.66 2.5 142.66 0.0 0.0 570.67 285.33 5992.0 INR 0 0.0 0.0 2025-11-28 13:18:20
2003 2016 1 292 12516 48 glow face wash NULL 3304999 100 100.0 380.0 0.0 0.0 304.0 257.63 46.37 38000.0 10000.0 30400.0 9.0 2318.64 9.0 2318.64 0.0 0.0 257.63 4637.29 30400.0 INR 0 0.0 0.0 2025-11-28 13:19:22
2004 2017 2 292 12516 34 Herbo2o Toothpaste NULL 33061090 300 45.0 199.0 0.0 0.0 159.2 134.92 24.28 59700.0 13500.0 47760.0 9.0 3642.71 9.0 3642.71 0.0 0.0 134.92 7285.42 47760.0 INR 0 0.0 0.0 2025-11-28 13:19:22
2005 2018 3 292 12516 12 Melatonin Drop NULL 2106909 10 190.0 749.0 0.0 0.0 599.2 570.67 28.53 7490.0 1900.0 5992.0 2.5 142.66 2.5 142.66 0.0 0.0 570.67 285.33 5992.0 INR 0 0.0 0.0 2025-11-28 13:19:22
2006 2019 4 292 12516 10 Vitamin D3 Drop NULL 2106909 10 190.0 749.0 0.0 0.0 599.2 570.67 28.53 7490.0 1900.0 5992.0 2.5 142.66 2.5 142.66 0.0 0.0 570.67 285.33 5992.0 INR 0 0.0 0.0 2025-11-28 13:19:22
2007 2020 1 293 12555 38 Dish Wash 500ml NULL 3924101 100 85.0 230.0 0.0 0.0 184.0 155.93 28.07 23000.0 8500.0 18400.0 9.0 1403.39 9.0 1403.39 0.0 0.0 155.93 2806.78 18400.0 INR 0 0.0 0.0 2025-11-28 14:33:54
2008 2021 2 293 12555 39 Fabric Wash 1000ml NULL 3924101 100 150.0 401.0 0.0 0.0 320.8 271.86 48.94 40100.0 15000.0 32080.0 9.0 2446.78 9.0 2446.78 0.0 0.0 271.86 4893.56 32080.0 INR 0 0.0 0.0 2025-11-28 14:33:54
2009 2022 3 293 12555 42 Premium Glow Charm Fairness Cream NULL 33049990 10 80.0 399.0 0.0 0.0 319.2 270.51 48.69 3990.0 800.0 3192.0 9.0 243.46 9.0 243.46 0.0 0.0 270.51 486.92 3192.0 INR 0 0.0 0.0 2025-11-28 14:33:54
2010 2023 4 293 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-28 14:33:54
2011 2024 1 294 12554 42 Premium Glow Charm Fairness Cream NULL 33049990 10 80.0 399.0 0.0 0.0 319.2 270.51 48.69 3990.0 800.0 3192.0 9.0 243.46 9.0 243.46 0.0 0.0 270.51 486.92 3192.0 INR 0 0.0 0.0 2025-11-28 14:37:16
2012 2025 2 294 12554 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-28 14:37:16
2013 2026 1 295 12516 42 Premium Glow Charm Fairness Cream NULL 33049990 10 80.0 399.0 0.0 0.0 319.2 270.51 48.69 3990.0 800.0 3192.0 9.0 243.46 9.0 243.46 0.0 0.0 270.51 486.92 3192.0 INR 0 0.0 0.0 2025-11-28 14:38:07
2014 2027 2 295 12516 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-28 14:38:07
2015 2028 1 296 12551 48 glow face wash NULL 3304999 3 100.0 380.0 0.0 0.0 304.0 257.63 46.37 1140.0 300.0 912.0 9.0 69.56 9.0 69.56 0.0 0.0 257.63 139.12 912.0 INR 0 0.0 0.0 2025-11-28 15:12:10
2016 2029 1 297 12557 48 glow face wash NULL 3304999 1 100.0 380.0 0.0 0.0 304.0 257.63 46.37 380.0 100.0 304.0 9.0 23.18 9.0 23.18 0.0 0.0 257.63 46.37 304.0 INR 0 0.0 0.0 2025-11-28 16:29:49
2017 2030 1 298 12555 60 Foot patch NULL 30051090 10 500.0 1999.0 0.0 0.0 1599.2 1523.05 76.15 19990.0 5000.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-29 15:18:16
2018 2031 1 299 12855 52 Bhoo sanjeevni 5 kg NULL 3103100 32 450.0 1600.0 0.0 0.0 1280.0 1219.05 60.95 51200.0 14400.0 40960.0 2.5 975.24 2.5 975.24 0.0 0.0 1219.05 1950.48 40960.0 INR 0 0.0 0.0 2025-11-29 17:33:41
2019 2032 1 300 12551 52 Bhoo sanjeevni 5 kg NULL 3103100 32 450.0 1600.0 0.0 0.0 1280.0 1219.05 60.95 51200.0 14400.0 40960.0 2.5 975.24 2.5 975.24 0.0 0.0 1219.05 1950.48 40960.0 INR 0 0.0 0.0 2025-11-29 17:41:09
2020 2033 1 301 12551 48 glow face wash NULL 3304999 4 100.0 380.0 0.0 0.0 304.0 257.63 46.37 1520.0 400.0 1216.0 9.0 92.75 9.0 92.75 0.0 0.0 257.63 185.49 1216.0 INR 0 0.0 0.0 2025-11-29 17:43:50
2021 2034 1 302 12551 48 glow face wash NULL 3304999 4 100.0 380.0 0.0 0.0 304.0 257.63 46.37 1520.0 400.0 1216.0 9.0 92.75 9.0 92.75 0.0 0.0 257.63 185.49 1216.0 INR 0 0.0 0.0 2025-11-29 18:27:21
2022 2035 1 303 12551 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-29 18:42:52
2023 2036 1 304 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-29 18:49:03
2024 2037 1 305 12855 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-29 19:18:05
2025 2038 1 306 12855 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-29 19:23:37
2026 2039 1 307 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-29 20:19:51
2027 2040 1 308 12855 33 Herbal Soap 100gm NULL 30049011 52 28.0 100.0 0.0 0.0 80.0 76.19 3.81 5200.0 1456.0 4160.0 2.5 99.05 2.5 99.05 0.0 0.0 76.19 198.1 4160.0 INR 0 0.0 0.0 2025-11-29 20:30:26
2028 2041 1 309 12555 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-30 09:22:58
2029 2042 1 310 12554 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-30 09:24:10
2030 2043 1 311 12516 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-30 09:25:32
2031 2044 1 312 12555 37 Floor Cleaner 500ml NULL 3924101 100 80.0 199.0 0.0 0.0 159.2 134.92 24.28 19900.0 8000.0 15920.0 9.0 1214.23 9.0 1214.23 0.0 0.0 134.92 2428.47 15920.0 INR 0 0.0 0.0 2025-11-30 15:48:04
2032 2045 2 312 12555 32 Neem Soap 100gm NULL 34011110 1000 10.0 60.0 0.0 0.0 48.0 45.71 2.29 60000.0 10000.0 48000.0 2.5 1142.86 2.5 1142.86 0.0 0.0 45.71 2285.71 48000.0 INR 0 0.0 0.0 2025-11-30 15:48:04
2033 2046 1 313 12555 74 EXPLORER BOX NULL NULL 6 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 161982.0 0.0 62994.0 2.5 1499.86 2.5 1499.86 0.0 0.0 9999.05 2999.71 62994.0 INR 0 0.0 0.0 2025-11-30 19:50:50
2034 2047 1 314 12555 61 Radiation chip NULL 902221 5 325.0 999.0 0.0 0.0 799.2 677.29 121.91 4995.0 1625.0 3996.0 9.0 304.78 9.0 304.78 0.0 0.0 677.29 609.56 3996.0 INR 0 0.0 0.0 2025-11-30 23:19:31
2035 2048 1 315 12555 2 Heart Care Capsules NULL 2936900 4 425.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 5996.0 1700.0 4796.8 2.5 114.21 2.5 114.21 0.0 0.0 1142.1 228.42 4796.8 INR 0 0.0 0.0 2025-11-30 23:27:23
2036 2049 1 316 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-12-01 16:18:59
2037 2050 1 317 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-12-01 16:19:41
2038 2051 1 318 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-12-01 16:20:26
2039 2052 1 319 12855 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-12-01 17:49:50
2040 2053 1 320 12855 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-12-01 18:03:10
2041 2054 1 321 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-12-03 17:17:31
2042 2055 1 322 12555 16 Liver Care 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-12-04 15:34:41
2043 2056 1 323 12554 16 Liver Care Juice NULL 2009899 30 120.0 349.0 0.0 0.0 279.2 265.9 13.3 10470.0 3600.0 8376.0 2.5 199.43 2.5 199.43 0.0 0.0 265.9 398.86 8376.0 INR 0 0.0 0.0 2025-12-04 15:36:04
2044 2057 1 324 12551 48 glow face wash NULL 3304999 5 100.0 380.0 0.0 0.0 304.0 257.63 46.37 1900.0 500.0 1520.0 9.0 115.93 9.0 115.93 0.0 0.0 257.63 231.86 1520.0 INR 0 0.0 0.0 2025-12-05 14:21:29
2045 2058 2 324 12551 33 Herbal Soap 100gm NULL 30049011 10 28.0 100.0 0.0 0.0 80.0 76.19 3.81 1000.0 280.0 800.0 2.5 19.05 2.5 19.05 0.0 0.0 76.19 38.1 800.0 INR 0 0.0 0.0 2025-12-05 14:21:29
2046 2059 3 324 12551 34 Herbo2o Toothpaste NULL 33061090 6 45.0 199.0 0.0 0.0 159.2 134.92 24.29 1194.0 270.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-12-05 14:21:29
2047 2060 4 324 12551 32 Neem Soap 100gm NULL 34011110 10 10.0 60.0 0.0 0.0 48.0 45.71 2.29 600.0 100.0 480.0 2.5 11.43 2.5 11.43 0.0 0.0 45.71 22.86 480.0 INR 0 0.0 0.0 2025-12-05 14:21:29
2048 2061 5 324 12551 41 Premium Coco Body Lotion NULL 3304300 2 250.0 699.0 0.0 0.0 559.2 473.9 85.3 1398.0 500.0 1118.4 9.0 85.3 9.0 85.3 0.0 0.0 473.9 170.6 1118.4 INR 0 0.0 0.0 2025-12-05 14:21:29
2049 2062 6 324 12551 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-12-05 14:21:29
2050 2063 7 324 12551 43 Quench Kiss Lip Balm NULL 3304300 10 35.0 199.0 0.0 0.0 159.2 134.92 24.29 1990.0 350.0 1592.0 9.0 121.42 9.0 121.42 0.0 0.0 134.92 242.85 1592.0 INR 0 0.0 0.0 2025-12-05 14:21:29