fx_franchise_order_product

4,933 rows · 33 columns · page 40 / 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
1951 1964 2 269 12555 26 Spirulina Cap NULL 2009899 10 190.0 899.0 0.0 0.0 719.2 684.95 34.25 8990.0 1900.0 7192.0 2.5 171.24 2.5 171.24 0.0 0.0 684.95 342.48 7192.0 INR 0 0.0 0.0 2025-11-20 22:15:12
1952 1965 1 270 12517 48 glow face wash NULL 3304999 30 100.0 380.0 0.0 0.0 304.0 257.63 46.37 11400.0 3000.0 9120.0 0.0 0.0 0.0 0.0 18.0 1391.19 257.63 1391.19 9120.0 INR 0 0.0 0.0 2025-11-20 23:13:55
1953 1966 2 270 12517 27 Multicharge Cap NULL 2009899 10 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 14990.0 4500.0 11992.0 0.0 0.0 0.0 0.0 5.0 571.05 1142.1 571.05 11992.0 INR 0 0.0 0.0 2025-11-20 23:13:55
1954 1967 3 270 12517 70 Premium Hand belt NULL 9404 5 600.0 9999.0 0.0 0.0 1440.0 1371.43 68.57 49995.0 3000.0 7200.0 0.0 0.0 0.0 0.0 5.0 342.86 1371.43 342.86 7200.0 INR 0 0.0 0.0 2025-11-20 23:13:55
1955 1968 4 270 12517 49 Anti Dandruff Serum NULL 3304999 10 250.0 999.0 0.0 0.0 799.2 677.29 121.91 9990.0 2500.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-20 23:13:55
1956 1969 5 270 12517 52 Bhoo sanjeevni 5 kg NULL 3103100 5 450.0 1600.0 0.0 0.0 1280.0 1219.05 60.95 8000.0 2250.0 6400.0 0.0 0.0 0.0 0.0 5.0 304.76 1219.05 304.76 6400.0 INR 0 0.0 0.0 2025-11-20 23:13:55
1957 1970 6 270 12517 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 0.0 0.0 0.0 0.0 5.0 571.05 1142.1 571.05 11992.0 INR 0 0.0 0.0 2025-11-20 23:13:55
1958 1971 7 270 12517 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 0.0 0.0 0.0 0.0 5.0 379.05 151.62 379.05 7960.0 INR 0 0.0 0.0 2025-11-20 23:13:55
1959 1972 8 270 12517 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 0.0 0.0 0.0 0.0 5.0 571.05 1142.1 571.05 11992.0 INR 0 0.0 0.0 2025-11-20 23:13:55
1960 1973 9 270 12517 41 Premium Coco Body Lotion NULL 3304300 10 250.0 699.0 0.0 0.0 559.2 473.9 85.3 6990.0 2500.0 5592.0 0.0 0.0 0.0 0.0 18.0 853.02 473.9 853.02 5592.0 INR 0 0.0 0.0 2025-11-20 23:13:55
1961 1974 10 270 12517 47 Premium Hair Care Shampoo NULL 3305109 30 150.0 699.0 0.0 0.0 559.2 532.57 26.63 20970.0 4500.0 16776.0 0.0 0.0 0.0 0.0 5.0 798.86 532.57 798.86 16776.0 INR 0 0.0 0.0 2025-11-20 23:13:55
1962 1975 11 270 12517 46 Root Vitality Hair Oil NULL 3305901 30 54.0 255.0 0.0 0.0 204.0 194.29 9.71 7650.0 1620.0 6120.0 0.0 0.0 0.0 0.0 5.0 291.43 194.29 291.43 6120.0 INR 0 0.0 0.0 2025-11-20 23:13:55
1963 1976 12 270 12517 57 Safe guard 250ml NULL 3105 2 800.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 5000.0 1600.0 4000.0 0.0 0.0 0.0 0.0 5.0 190.48 1904.76 190.48 4000.0 INR 0 0.0 0.0 2025-11-20 23:13:55
1964 1977 13 270 12517 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 0.0 0.0 0.0 0.0 18.0 1706.03 473.9 1706.03 11184.0 INR 0 0.0 0.0 2025-11-20 23:13:55
1965 1978 14 270 12517 53 Terra care 2 kg NULL 3103100 5 450.0 1500.0 0.0 0.0 1200.0 1142.86 57.14 7500.0 2250.0 6000.0 0.0 0.0 0.0 0.0 5.0 285.71 1142.86 285.71 6000.0 INR 0 0.0 0.0 2025-11-20 23:13:55
1966 1979 15 270 12517 54 Wonder grow 100ml NULL 3105 5 500.0 1400.0 0.0 0.0 1120.0 1066.67 53.33 7000.0 2500.0 5600.0 0.0 0.0 0.0 0.0 5.0 266.67 1066.67 266.67 5600.0 INR 0 0.0 0.0 2025-11-20 23:13:55
1967 1980 1 271 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-21 07:28:54
1968 1981 1 272 12516 47 Premium Hair Care Shampoo NULL 3305109 40 150.0 699.0 0.0 0.0 559.2 532.57 26.63 27960.0 6000.0 22368.0 2.5 532.57 2.5 532.57 0.0 0.0 532.57 1065.14 22368.0 INR 0 0.0 0.0 2025-11-21 09:33:32
1969 1982 1 273 12516 28 Ortho Joint Shield NULL 2009899 20 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 29980.0 9000.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-21 09:40:24
1970 1983 1 274 12517 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 0.0 0.0 0.0 0.0 5.0 2642.86 17619.05 2642.86 55500.0 INR 0 0.0 0.0 2025-11-21 10:36:53
1971 1984 2 274 12517 74 EXPLORER BOX NULL NULL 11 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 296967.0 0.0 115489.0 0.0 0.0 0.0 0.0 5.0 5499.48 9999.05 5499.48 115489.0 INR 0 0.0 0.0 2025-11-21 10:36:53
1972 1985 1 275 12555 41 Premium Coco Body Lotion NULL 3304300 30 250.0 699.0 0.0 0.0 559.2 473.9 85.3 20970.0 7500.0 16776.0 9.0 1279.53 9.0 1279.53 0.0 0.0 473.9 2559.05 16776.0 INR 0 0.0 0.0 2025-11-21 14:42:45
1973 1986 1 276 12554 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-21 14:43:41
1974 1987 1 277 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-21 14:44:50
1975 1988 1 278 12555 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-22 13:10:28
1976 1989 1 279 12554 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-22 13:11:20
1977 1990 1 280 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-22 13:12:05
1978 1991 1 281 12516 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-22 13:16:09
1979 1992 1 282 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-23 14:13:16
1980 1993 2 282 12555 6 Asthma Care NULL 30049011 10 250.0 899.0 0.0 0.0 719.2 684.95 34.25 8990.0 2500.0 7192.0 2.5 171.24 2.5 171.24 0.0 0.0 684.95 342.48 7192.0 INR 0 0.0 0.0 2025-11-23 14:13:16
1981 1994 3 282 12555 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-23 14:13:16
1982 1995 1 283 12555 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-24 11:59:58
1983 1996 1 284 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-24 15:08:20
1984 1997 1 285 12555 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-24 18:08:41
1985 1998 1 286 12555 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-25 13:27:10
1986 1999 1 287 12554 49 Anti Dandruff Serum NULL 3304999 10 250.0 999.0 0.0 0.0 799.2 677.29 121.91 9990.0 2500.0 7992.0 9.0 609.56 9.0 609.56 0.0 0.0 677.29 1219.12 7992.0 INR 0 0.0 0.0 2025-11-27 14:00:14
1987 2000 2 287 12554 42 Premium Glow Charm Fairness Cream NULL 33049990 4 80.0 399.0 0.0 0.0 319.2 270.51 48.69 1596.0 320.0 1276.8 9.0 97.39 9.0 97.39 0.0 0.0 270.51 194.77 1276.8 INR 0 0.0 0.0 2025-11-27 14:00:14
1988 2001 3 287 12554 11 Vitamin B12 Drop NULL 2106909 1 190.0 749.0 0.0 0.0 599.2 570.67 28.53 749.0 190.0 599.2 2.5 14.27 2.5 14.27 0.0 0.0 570.67 28.53 599.2 INR 0 0.0 0.0 2025-11-27 14:00:14
1989 2002 1 288 12516 49 Anti Dandruff Serum NULL 3304999 10 250.0 999.0 0.0 0.0 799.2 677.29 121.91 9990.0 2500.0 7992.0 9.0 609.56 9.0 609.56 0.0 0.0 677.29 1219.12 7992.0 INR 0 0.0 0.0 2025-11-27 14:01:30
1990 2003 2 288 12516 42 Premium Glow Charm Fairness Cream NULL 33049990 4 80.0 399.0 0.0 0.0 319.2 270.51 48.69 1596.0 320.0 1276.8 9.0 97.39 9.0 97.39 0.0 0.0 270.51 194.77 1276.8 INR 0 0.0 0.0 2025-11-27 14:01:30
1991 2004 3 288 12516 11 Vitamin B12 Drop NULL 2106909 1 190.0 749.0 0.0 0.0 599.2 570.67 28.53 749.0 190.0 599.2 2.5 14.27 2.5 14.27 0.0 0.0 570.67 28.53 599.2 INR 0 0.0 0.0 2025-11-27 14:01:30
1992 2005 1 289 12555 49 Anti Dandruff Serum NULL 3304999 10 250.0 999.0 0.0 0.0 799.2 677.29 121.91 9990.0 2500.0 7992.0 9.0 609.56 9.0 609.56 0.0 0.0 677.29 1219.12 7992.0 INR 0 0.0 0.0 2025-11-27 14:02:51
1993 2006 2 289 12555 42 Premium Glow Charm Fairness Cream NULL 33049990 4 80.0 399.0 0.0 0.0 319.2 270.51 48.69 1596.0 320.0 1276.8 9.0 97.39 9.0 97.39 0.0 0.0 270.51 194.77 1276.8 INR 0 0.0 0.0 2025-11-27 14:02:51
1994 2007 3 289 12555 11 Vitamin B12 Drop NULL 2106909 1 190.0 749.0 0.0 0.0 599.2 570.67 28.53 749.0 190.0 599.2 2.5 14.27 2.5 14.27 0.0 0.0 570.67 28.53 599.2 INR 0 0.0 0.0 2025-11-27 14:02:51
1995 2008 1 290 12555 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:17:15
1996 2009 2 290 12555 34 Herbo2o Toothpaste NULL 33061090 200 45.0 199.0 0.0 0.0 159.2 134.92 24.28 39800.0 9000.0 31840.0 9.0 2428.47 9.0 2428.47 0.0 0.0 134.92 4856.95 31840.0 INR 0 0.0 0.0 2025-11-28 13:17:15
1997 2010 3 290 12555 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:17:15
1998 2011 4 290 12555 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:17:15
1999 2012 1 291 12554 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:18:20
2000 2013 2 291 12554 34 Herbo2o Toothpaste NULL 33061090 200 45.0 199.0 0.0 0.0 159.2 134.92 24.28 39800.0 9000.0 31840.0 9.0 2428.47 9.0 2428.47 0.0 0.0 134.92 4856.95 31840.0 INR 0 0.0 0.0 2025-11-28 13:18:20