fx_franchise_order_product

4,933 rows · 33 columns · page 86 / 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
4251 4264 1 1048 12526 6 Asthma Care NULL 30049011 1 0.0 899.0 0.0 0.0 719.0 684.76 34.24 899.0 0.0 719.0 2.5 17.12 2.5 17.12 0.0 0.0 684.76 34.24 719.0 INR 3 2.0 13.7 2026-03-24 20:47:23
4252 4265 2 1048 12526 60 Foot patch NULL 30051090 1 0.0 1999.0 0.0 0.0 1599.0 1522.86 76.14 1999.0 0.0 1599.0 2.5 38.07 2.5 38.07 0.0 0.0 1522.86 76.14 1599.0 INR 3 2.0 30.46 2026-03-24 20:47:23
4253 4266 3 1048 12526 33 HALDI CHANDAN SOAP 100gm NULL 30049011 30 0.0 100.0 0.0 0.0 80.0 76.19 3.81 3000.0 0.0 2400.0 2.5 57.14 2.5 57.14 0.0 0.0 2285.72 114.29 2400.0 INR 3 2.0 45.71 2026-03-24 20:47:23
4254 4267 4 1048 12526 16 Liver Care Juice NULL 2009899 4 0.0 349.0 0.0 0.0 279.0 265.71 13.29 1396.0 0.0 1116.0 2.5 26.57 2.5 26.57 0.0 0.0 1062.86 53.14 1116.0 INR 3 2.0 21.26 2026-03-24 20:47:23
4255 4268 5 1048 12526 25 Manicalcium Tablets NULL 2009899 1 0.0 399.0 0.0 0.0 319.0 303.81 15.19 399.0 0.0 319.0 2.5 7.6 2.5 7.6 0.0 0.0 303.81 15.19 319.0 INR 3 2.0 6.08 2026-03-24 20:47:23
4256 4269 6 1048 12526 72 Pain Relief Patch NULL 30051090 2 0.0 800.0 0.0 0.0 600.0 571.43 28.57 1600.0 0.0 1200.0 2.5 28.57 2.5 28.57 0.0 0.0 1142.86 57.14 1200.0 INR 3 2.0 22.86 2026-03-24 20:47:23
4257 4270 7 1048 12526 12 PREMIUM RADIANCE FACE SERUM NULL 33049990 1 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 1250.0 0.0 750.0 2.5 17.86 2.5 17.86 0.0 0.0 714.29 35.71 750.0 INR 3 2.0 14.29 2026-03-24 20:47:23
4258 4271 8 1048 12526 43 Quench Kiss Lip Balm NULL 3304300 2 0.0 199.0 0.0 0.0 159.0 134.75 24.25 398.0 0.0 318.0 9.0 24.25 9.0 24.25 0.0 0.0 269.49 48.51 318.0 INR 3 2.0 5.39 2026-03-24 20:47:23
4259 4272 9 1048 12526 34 Toothpaste NULL 33061090 12 0.0 199.0 0.0 0.0 159.0 134.75 24.25 2388.0 0.0 1908.0 9.0 145.53 9.0 145.53 0.0 0.0 1616.95 291.05 1908.0 INR 3 2.0 32.34 2026-03-24 20:47:23
4260 4273 1 1049 12532 82 ALKALINE CAPSULE NULL 3402000 2 0.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 5000.0 0.0 4000.0 2.5 95.24 2.5 95.24 0.0 0.0 3809.52 190.48 4000.0 INR 3 2.0 76.19 2026-03-24 20:49:23
4261 4274 2 1049 12532 4 Diabetic Care Capsules NULL 2936900 2 0.0 999.0 0.0 0.0 720.0 685.71 34.29 1998.0 0.0 1440.0 2.5 34.29 2.5 34.29 0.0 0.0 1371.43 68.57 1440.0 INR 3 2.0 27.43 2026-03-24 20:49:23
4262 4275 3 1049 12532 72 Pain Relief Patch NULL 30051090 2 0.0 800.0 0.0 0.0 600.0 571.43 28.57 1600.0 0.0 1200.0 2.5 28.57 2.5 28.57 0.0 0.0 1142.86 57.14 1200.0 INR 3 2.0 22.86 2026-03-24 20:49:23
4263 4276 4 1049 12532 94 PAVANA DROPS NULL 30041211 5 0.0 699.0 0.0 0.0 499.0 475.24 23.76 3495.0 0.0 2495.0 2.5 59.4 2.5 59.4 0.0 0.0 2376.19 118.81 2495.0 INR 3 2.0 47.52 2026-03-24 20:49:23
4264 4277 5 1049 12532 46 Root Vitality Hair Oil NULL 3305901 12 0.0 255.0 0.0 0.0 204.0 194.29 9.71 3060.0 0.0 2448.0 2.5 58.29 2.5 58.29 0.0 0.0 2331.43 116.57 2448.0 INR 3 2.0 46.63 2026-03-24 20:49:23
4265 4278 6 1049 12532 36 Toilet Cleaner 500ml NULL 3924101 12 0.0 150.0 0.0 0.0 120.0 101.69 18.31 1800.0 0.0 1440.0 9.0 109.83 9.0 109.83 0.0 0.0 1220.34 219.66 1440.0 INR 3 2.0 24.41 2026-03-24 20:49:23
4266 4279 1 1050 12545 12 PREMIUM RADIANCE FACE SERUM NULL 33049990 2 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 2500.0 0.0 1500.0 2.5 35.71 2.5 35.71 0.0 0.0 1428.57 71.43 1500.0 INR 3 2.0 28.57 2026-03-24 22:01:23
4267 4280 1 1051 12523 82 ALKALINE CAPSULE NULL 3402000 2 0.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 5000.0 0.0 4000.0 2.5 95.24 2.5 95.24 0.0 0.0 3809.52 190.48 4000.0 INR 3 2.0 76.19 2026-03-25 15:15:31
4268 4281 2 1051 12523 52 Bhoo sanjeevni 5 kg NULL 3103100 1 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 1600.0 0.0 1250.0 2.5 29.76 2.5 29.76 0.0 0.0 1190.48 59.52 1250.0 INR 3 2.0 23.81 2026-03-25 15:15:31
4269 4282 3 1051 12523 4 Diabetic Care Capsules NULL 2936900 1 0.0 999.0 0.0 0.0 720.0 685.71 34.29 999.0 0.0 720.0 2.5 17.14 2.5 17.14 0.0 0.0 685.71 34.29 720.0 INR 3 2.0 13.71 2026-03-25 15:15:31
4270 4283 4 1051 12523 37 Floor Cleaner 500ml NULL 3924101 15 0.0 199.0 0.0 0.0 159.0 134.75 24.25 2985.0 0.0 2385.0 9.0 181.91 9.0 181.91 0.0 0.0 2021.19 363.81 2385.0 INR 3 2.0 40.42 2026-03-25 15:15:31
4271 4284 5 1051 12523 7 Morning Fresh Churan NULL 30049011 10 0.0 199.0 0.0 0.0 159.0 151.43 7.57 1990.0 0.0 1590.0 2.5 37.86 2.5 37.86 0.0 0.0 1514.29 75.71 1590.0 INR 3 2.0 30.29 2026-03-25 15:15:31
4272 4285 6 1051 12523 32 Neem Soap 100gm NULL 34011110 25 0.0 60.0 0.0 0.0 48.0 45.71 2.29 1500.0 0.0 1200.0 2.5 28.57 2.5 28.57 0.0 0.0 1142.86 57.14 1200.0 INR 3 2.0 22.86 2026-03-25 15:15:31
4273 4286 7 1051 12523 43 Quench Kiss Lip Balm NULL 3304300 20 0.0 199.0 0.0 0.0 159.0 134.75 24.25 3980.0 0.0 3180.0 9.0 242.54 9.0 242.54 0.0 0.0 2694.92 485.08 3180.0 INR 3 2.0 53.9 2026-03-25 15:15:31
4274 4287 8 1051 12523 10 RADIANCE GLOW DAY CREAM NULL 33049900 2 0.0 1424.0 0.0 0.0 750.0 635.59 114.41 2848.0 0.0 1500.0 9.0 114.41 9.0 114.41 0.0 0.0 1271.19 228.81 1500.0 INR 3 2.0 25.42 2026-03-25 15:15:31
4275 4288 9 1051 12523 46 Root Vitality Hair Oil NULL 3305901 15 0.0 255.0 0.0 0.0 204.0 194.29 9.71 3825.0 0.0 3060.0 2.5 72.86 2.5 72.86 0.0 0.0 2914.29 145.71 3060.0 INR 3 2.0 58.29 2026-03-25 15:15:31
4276 4289 10 1051 12523 53 Terra care 2 kg NULL 3103100 2 0.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 3000.0 0.0 2300.0 2.5 54.76 2.5 54.76 0.0 0.0 2190.48 109.52 2300.0 INR 3 2.0 43.81 2026-03-25 15:15:31
4277 4290 11 1051 12523 36 Toilet Cleaner 500ml NULL 3924101 10 0.0 150.0 0.0 0.0 120.0 101.69 18.31 1500.0 0.0 1200.0 9.0 91.53 9.0 91.53 0.0 0.0 1016.95 183.05 1200.0 INR 3 2.0 20.34 2026-03-25 15:15:31
4278 4291 12 1051 12523 34 Toothpaste NULL 33061090 10 0.0 199.0 0.0 0.0 159.0 134.75 24.25 1990.0 0.0 1590.0 9.0 121.27 9.0 121.27 0.0 0.0 1347.46 242.54 1590.0 INR 3 2.0 26.95 2026-03-25 15:15:31
4279 4292 13 1051 12523 54 Wonder grow 100ml NULL 3105 1 0.0 1400.0 0.0 0.0 1200.0 1142.86 57.14 1400.0 0.0 1200.0 2.5 28.57 2.5 28.57 0.0 0.0 1142.86 57.14 1200.0 INR 3 2.0 22.86 2026-03-25 15:15:31
4280 4293 1 1052 12548 52 Bhoo sanjeevni 5 kg NULL 3103100 1 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 1600.0 0.0 1250.0 2.5 29.76 2.5 29.76 0.0 0.0 1190.48 59.52 1250.0 INR 3 2.0 23.81 2026-03-26 07:51:58
4281 4294 2 1052 12548 4 Diabetic Care Capsules NULL 2936900 1 0.0 999.0 0.0 0.0 720.0 685.71 34.29 999.0 0.0 720.0 2.5 17.14 2.5 17.14 0.0 0.0 685.71 34.29 720.0 INR 3 2.0 13.71 2026-03-26 07:51:58
4282 4295 3 1052 12548 56 Micro magic 500ml NULL 3105 1 0.0 2030.0 0.0 0.0 1650.0 1571.43 78.57 2030.0 0.0 1650.0 2.5 39.29 2.5 39.29 0.0 0.0 1571.43 78.57 1650.0 INR 3 2.0 31.43 2026-03-26 07:51:58
4283 4296 4 1052 12548 43 Quench Kiss Lip Balm NULL 3304300 2 0.0 199.0 0.0 0.0 159.0 134.75 24.25 398.0 0.0 318.0 9.0 24.25 9.0 24.25 0.0 0.0 269.49 48.51 318.0 INR 3 2.0 5.39 2026-03-26 07:51:58
4284 4297 5 1052 12548 50 Sun Screen NULL 330499 1 0.0 699.0 0.0 0.0 559.0 473.73 85.27 699.0 0.0 559.0 9.0 42.64 9.0 42.64 0.0 0.0 473.73 85.27 559.0 INR 3 2.0 9.47 2026-03-26 07:51:58
4285 4298 6 1052 12548 53 Terra care 2 kg NULL 3103100 1 0.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 1500.0 0.0 1150.0 2.5 27.38 2.5 27.38 0.0 0.0 1095.24 54.76 1150.0 INR 3 2.0 21.9 2026-03-26 07:51:58
4286 4299 7 1052 12548 34 Toothpaste NULL 33061090 2 0.0 199.0 0.0 0.0 159.0 134.75 24.25 398.0 0.0 318.0 9.0 24.25 9.0 24.25 0.0 0.0 269.49 48.51 318.0 INR 3 2.0 5.39 2026-03-26 07:51:58
4287 4300 1 1053 12526 60 Foot patch NULL 30051090 1 0.0 1999.0 0.0 0.0 1599.0 1522.86 76.14 1999.0 0.0 1599.0 2.5 38.07 2.5 38.07 0.0 0.0 1522.86 76.14 1599.0 INR 3 2.0 30.46 2026-03-26 22:37:16
4288 4301 2 1053 12526 17 Memory Booster Juice NULL 2009899 2 0.0 349.0 0.0 0.0 279.0 265.71 13.29 698.0 0.0 558.0 2.5 13.29 2.5 13.29 0.0 0.0 531.43 26.57 558.0 INR 3 2.0 10.63 2026-03-26 22:37:16
4289 4302 3 1053 12526 44 Vital Glow Face Scrub NULL 3304300 4 0.0 325.0 0.0 0.0 260.0 220.34 39.66 1300.0 0.0 1040.0 9.0 79.32 9.0 79.32 0.0 0.0 881.36 158.64 1040.0 INR 3 2.0 17.63 2026-03-26 22:37:16
4290 4303 1 1054 12545 52 Bhoo sanjeevni 5 kg NULL 3103100 1 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 1600.0 0.0 1250.0 2.5 29.76 2.5 29.76 0.0 0.0 1190.48 59.52 1250.0 INR 3 2.0 23.81 2026-03-27 19:10:08
4291 4304 2 1054 12545 38 Dish Wash 500ml NULL 34029099 5 0.0 230.0 0.0 0.0 184.0 155.93 28.07 1150.0 0.0 920.0 9.0 70.17 9.0 70.17 0.0 0.0 779.66 140.34 920.0 INR 3 2.0 15.59 2026-03-27 19:10:08
4292 4305 3 1054 12545 39 Fabric Wash 1000ml NULL 34029099 3 0.0 401.0 0.0 0.0 321.0 272.03 48.97 1203.0 0.0 963.0 9.0 73.45 9.0 73.45 0.0 0.0 816.1 146.9 963.0 INR 3 2.0 16.32 2026-03-27 19:10:08
4293 4306 4 1054 12545 37 Floor Cleaner 500ml NULL 3924101 5 0.0 199.0 0.0 0.0 159.0 134.75 24.25 995.0 0.0 795.0 9.0 60.64 9.0 60.64 0.0 0.0 673.73 121.27 795.0 INR 3 2.0 13.47 2026-03-27 19:10:08
4294 4307 5 1054 12545 33 HALDI CHANDAN SOAP 100gm NULL 30049011 6 0.0 100.0 0.0 0.0 80.0 76.19 3.81 600.0 0.0 480.0 2.5 11.43 2.5 11.43 0.0 0.0 457.14 22.86 480.0 INR 3 2.0 9.14 2026-03-27 19:10:08
4295 4308 6 1054 12545 32 Neem Soap 100gm NULL 34011110 17 0.0 60.0 0.0 0.0 48.0 45.71 2.29 1020.0 0.0 816.0 2.5 19.43 2.5 19.43 0.0 0.0 777.14 38.86 816.0 INR 3 2.0 15.54 2026-03-27 19:10:08
4296 4309 7 1054 12545 9 Omega 369 NULL 2936900 3 0.0 999.0 0.0 0.0 720.0 685.71 34.29 2997.0 0.0 2160.0 2.5 51.43 2.5 51.43 0.0 0.0 2057.14 102.86 2160.0 INR 3 2.0 41.14 2026-03-27 19:10:08
4297 4310 8 1054 12545 53 Terra care 2 kg NULL 3103100 1 0.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 1500.0 0.0 1150.0 2.5 27.38 2.5 27.38 0.0 0.0 1095.24 54.76 1150.0 INR 3 2.0 21.9 2026-03-27 19:10:08
4298 4311 9 1054 12545 36 Toilet Cleaner 500ml NULL 3924101 5 0.0 150.0 0.0 0.0 120.0 101.69 18.31 750.0 0.0 600.0 9.0 45.76 9.0 45.76 0.0 0.0 508.47 91.53 600.0 INR 3 2.0 10.17 2026-03-27 19:10:08
4299 4312 10 1054 12545 34 Toothpaste NULL 33061090 13 0.0 199.0 0.0 0.0 159.0 134.75 24.25 2587.0 0.0 2067.0 9.0 157.65 9.0 157.65 0.0 0.0 1751.7 315.31 2067.0 INR 3 2.0 35.03 2026-03-27 19:10:08
4300 4313 1 1055 12545 39 Fabric Wash 1000ml NULL 34029099 1 0.0 401.0 0.0 0.0 321.0 272.03 48.97 401.0 0.0 321.0 9.0 24.48 9.0 24.48 0.0 0.0 272.03 48.97 321.0 INR 3 2.0 5.44 2026-03-27 19:13:13