fx_franchise_order_product

4,933 rows · 33 columns · page 87 / 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
4301 4314 2 1055 12545 55 Grow master 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-27 19:13:13
4302 4315 3 1055 12545 33 HALDI CHANDAN SOAP 100gm NULL 30049011 2 0.0 100.0 0.0 0.0 80.0 76.19 3.81 200.0 0.0 160.0 2.5 3.81 2.5 3.81 0.0 0.0 152.38 7.62 160.0 INR 3 2.0 3.05 2026-03-27 19:13:13
4303 4316 4 1055 12545 32 Neem Soap 100gm NULL 34011110 10 0.0 60.0 0.0 0.0 48.0 45.71 2.29 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:13:13
4304 4317 5 1055 12545 9 Omega 369 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-27 19:13:13
4305 4318 6 1055 12545 46 Root Vitality Hair Oil NULL 3305901 2 0.0 255.0 0.0 0.0 204.0 194.29 9.71 510.0 0.0 408.0 2.5 9.71 2.5 9.71 0.0 0.0 388.57 19.43 408.0 INR 3 2.0 7.77 2026-03-27 19:13:13
4306 4319 7 1055 12545 36 Toilet Cleaner 500ml NULL 3924101 2 0.0 150.0 0.0 0.0 120.0 101.69 18.31 300.0 0.0 240.0 9.0 18.31 9.0 18.31 0.0 0.0 203.39 36.61 240.0 INR 3 2.0 4.07 2026-03-27 19:13:13
4307 4320 1 1056 12545 32 Neem Soap 100gm NULL 34011110 4 0.0 60.0 0.0 0.0 48.0 45.71 2.29 240.0 0.0 192.0 2.5 4.57 2.5 4.57 0.0 0.0 182.86 9.14 192.0 INR 3 2.0 3.66 2026-03-27 21:29:24
4308 4321 2 1056 12545 46 Root Vitality Hair Oil NULL 3305901 2 0.0 255.0 0.0 0.0 204.0 194.29 9.71 510.0 0.0 408.0 2.5 9.71 2.5 9.71 0.0 0.0 388.57 19.43 408.0 INR 3 2.0 7.77 2026-03-27 21:29:24
4309 4322 3 1056 12545 34 Toothpaste NULL 33061090 3 0.0 199.0 0.0 0.0 159.0 134.75 24.25 597.0 0.0 477.0 9.0 36.38 9.0 36.38 0.0 0.0 404.24 72.76 477.0 INR 3 2.0 8.08 2026-03-27 21:29:24
4310 4323 1 1057 12526 82 ALKALINE CAPSULE NULL 3402000 1 0.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 2500.0 0.0 2000.0 2.5 47.62 2.5 47.62 0.0 0.0 1904.76 95.24 2000.0 INR 3 2.0 38.1 2026-03-27 21:29:57
4311 4324 2 1057 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-27 21:29:57
4312 4325 3 1057 12526 50 Sun Screen NULL 330499 3 0.0 699.0 0.0 0.0 559.0 473.73 85.27 2097.0 0.0 1677.0 9.0 127.91 9.0 127.91 0.0 0.0 1421.19 255.81 1677.0 INR 3 2.0 28.42 2026-03-27 21:29:57
4313 4326 4 1057 12526 44 Vital Glow Face Scrub NULL 3304300 5 0.0 325.0 0.0 0.0 260.0 220.34 39.66 1625.0 0.0 1300.0 9.0 99.15 9.0 99.15 0.0 0.0 1101.69 198.31 1300.0 INR 3 2.0 22.03 2026-03-27 21:29:57
4314 4327 1 1058 12516 48 Glow it multi fruit face wash NULL 3304999 50 0.0 450.0 0.0 0.0 320.0 271.19 48.81 22500.0 0.0 16000.0 9.0 1220.34 9.0 1220.34 0.0 0.0 13559.32 2440.68 16000.0 INR 1 8.0 1084.75 2026-03-27 21:43:39
4315 4328 1 1059 12517 48 Glow it multi fruit face wash NULL 3304999 50 0.0 450.0 0.0 0.0 320.0 271.19 48.81 22500.0 0.0 16000.0 0.0 0.0 0.0 0.0 18.0 2440.68 13559.32 2440.68 16000.0 INR 2 6.0 813.56 2026-03-27 21:45:18
4316 4329 1 1060 12526 48 Glow it multi fruit face wash NULL 3304999 10 0.0 450.0 0.0 0.0 320.0 271.19 48.81 4500.0 0.0 3200.0 9.0 244.07 9.0 244.07 0.0 0.0 2711.86 488.14 3200.0 INR 3 2.0 54.24 2026-03-27 22:03:26
4317 4330 1 1061 12521 52 Bhoo sanjeevni 5 kg NULL 3103100 2 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 3200.0 0.0 2500.0 2.5 59.52 2.5 59.52 0.0 0.0 2380.95 119.05 2500.0 INR 3 2.0 47.62 2026-03-27 22:56:16
4318 4331 2 1061 12521 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-27 22:56:16
4319 4332 1 1062 12521 32 Neem Soap 100gm NULL 34011110 65 0.0 60.0 0.0 0.0 48.0 45.71 2.29 3900.0 0.0 3120.0 2.5 74.29 2.5 74.29 0.0 0.0 2971.43 148.57 3120.0 INR 3 2.0 59.43 2026-03-27 23:12:00
4320 4333 1 1063 12517 70 Premium Hand belt NULL 9404 25 0.0 2500.0 0.0 0.0 1440.0 1371.43 68.57 62500.0 0.0 36000.0 0.0 0.0 0.0 0.0 5.0 1714.29 34285.71 1714.29 36000.0 INR 2 6.0 2057.14 2026-03-30 12:20:17
4321 4334 1 1064 12516 70 Premium Hand belt NULL 9404 20 0.0 2500.0 0.0 0.0 1440.0 1371.43 68.57 50000.0 0.0 28800.0 2.5 685.71 2.5 685.71 0.0 0.0 27428.57 1371.43 28800.0 INR 1 8.0 2194.29 2026-03-30 12:20:39
4322 4335 1 1065 12548 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-30 18:51:16
4323 4336 2 1065 12548 2 Heart Care Capsules NULL 2936900 1 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 1499.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-30 18:51:16
4324 4337 1 1066 12526 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-30 21:11:48
4325 4338 2 1066 12526 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-30 21:11:48
4326 4339 3 1066 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-30 21:11:48
4327 4340 4 1066 12526 30 Iron Capsules 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-30 21:11:48
4328 4341 5 1066 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-30 21:11:48
4329 4342 6 1066 12526 32 Neem Soap 100gm NULL 34011110 35 0.0 60.0 0.0 0.0 48.0 45.71 2.29 2100.0 0.0 1680.0 2.5 40.0 2.5 40.0 0.0 0.0 1600.0 80.0 1680.0 INR 3 2.0 32.0 2026-03-30 21:11:48
4330 4343 7 1066 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-30 21:11:48
4331 4344 8 1066 12526 94 PAVANA DROPS NULL 30041211 2 0.0 699.0 0.0 0.0 499.0 475.24 23.76 1398.0 0.0 998.0 2.5 23.76 2.5 23.76 0.0 0.0 950.48 47.52 998.0 INR 3 2.0 19.01 2026-03-30 21:11:48
4332 4345 9 1066 12526 46 Root Vitality Hair Oil NULL 3305901 6 0.0 255.0 0.0 0.0 204.0 194.29 9.71 1530.0 0.0 1224.0 2.5 29.14 2.5 29.14 0.0 0.0 1165.71 58.29 1224.0 INR 3 2.0 23.31 2026-03-30 21:11:48
4333 4346 10 1066 12526 95 STRI VEDA NULL 30049011 1 0.0 2500.0 0.0 0.0 1500.0 1428.57 71.43 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-30 21:11:48
4334 4347 11 1066 12526 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-30 21:11:48
4335 4348 1 1067 12539 4 Diabetic Care Capsules NULL 2936900 6 0.0 999.0 0.0 0.0 720.0 685.71 34.29 5994.0 0.0 4320.0 2.5 102.86 2.5 102.86 0.0 0.0 4114.29 205.71 4320.0 INR 3 2.0 82.29 2026-03-31 19:17:39
4336 4349 2 1067 12539 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-31 19:17:39
4337 4350 3 1067 12539 32 Neem Soap 100gm NULL 34011110 1 0.0 60.0 0.0 0.0 48.0 45.71 2.29 60.0 0.0 48.0 2.5 1.14 2.5 1.14 0.0 0.0 45.71 2.29 48.0 INR 3 2.0 0.91 2026-03-31 19:17:39
4338 4351 1 1068 14079 15 KIDNEY CARE 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-04-01 21:29:53
4339 4352 1 1069 12521 49 Anti Dandruff Serum NULL 3304999 1 0.0 999.0 0.0 0.0 799.0 677.12 121.88 999.0 0.0 799.0 9.0 60.94 9.0 60.94 0.0 0.0 677.12 121.88 799.0 INR 3 2.0 13.54 2026-04-03 16:14:54
4340 4353 2 1069 12521 55 Grow master 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-04-03 16:14:54
4341 4354 3 1069 12521 32 Neem Soap 100gm NULL 34011110 6 0.0 60.0 0.0 0.0 48.0 45.71 2.29 360.0 0.0 288.0 2.5 6.86 2.5 6.86 0.0 0.0 274.29 13.71 288.0 INR 3 2.0 5.49 2026-04-03 16:14:54
4342 4355 4 1069 12521 81 PREMIUM GLOW FACE WASH NULL 3404 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-04-03 16:14:54
4343 4356 5 1069 12521 43 Quench Kiss Lip Balm NULL 3304300 1 0.0 199.0 0.0 0.0 159.0 134.75 24.25 199.0 0.0 159.0 9.0 12.13 9.0 12.13 0.0 0.0 134.75 24.25 159.0 INR 3 2.0 2.69 2026-04-03 16:14:54
4344 4357 6 1069 12521 46 Root Vitality Hair Oil NULL 3305901 1 0.0 255.0 0.0 0.0 204.0 194.29 9.71 255.0 0.0 204.0 2.5 4.86 2.5 4.86 0.0 0.0 194.29 9.71 204.0 INR 3 2.0 3.89 2026-04-03 16:14:54
4345 4358 1 1070 12526 82 ALKALINE CAPSULE NULL 3402000 1 0.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 2500.0 0.0 2000.0 2.5 47.62 2.5 47.62 0.0 0.0 1904.76 95.24 2000.0 INR 3 2.0 38.1 2026-04-03 20:56:09
4346 4359 2 1070 12526 49 Anti Dandruff Serum NULL 3304999 1 0.0 999.0 0.0 0.0 799.0 677.12 121.88 999.0 0.0 799.0 9.0 60.94 9.0 60.94 0.0 0.0 677.12 121.88 799.0 INR 3 2.0 13.54 2026-04-03 20:56:09
4347 4360 3 1070 12526 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-04-03 20:56:09
4348 4361 4 1070 12526 39 Fabric Wash 1000ml NULL 34029099 5 0.0 401.0 0.0 0.0 321.0 272.03 48.97 2005.0 0.0 1605.0 9.0 122.42 9.0 122.42 0.0 0.0 1360.17 244.83 1605.0 INR 3 2.0 27.2 2026-04-03 20:56:09
4349 4362 5 1070 12526 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-04-03 20:56:09
4350 4363 6 1070 12526 33 HALDI CHANDAN SOAP 100gm NULL 30049011 20 0.0 100.0 0.0 0.0 80.0 76.19 3.81 2000.0 0.0 1600.0 2.5 38.1 2.5 38.1 0.0 0.0 1523.81 76.19 1600.0 INR 3 2.0 30.48 2026-04-03 20:56:09