fx_franchise_order_product

4,933 rows · 33 columns · page 97 / 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
4801 4816 9 1235 14902 7 Morning Fresh Churan NULL 30049011 10 79.0 199.0 0.0 0.0 179.0 170.48 8.52 1990.0 790.0 1790.0 2.5 42.62 2.5 42.62 0.0 0.0 1704.76 85.24 1790.0 INR 3 2.0 34.1 2026-06-07 09:38:45
4802 4817 10 1235 14902 81 PREMIUM GLOW FACE WASH NULL 3404 1 279.0 699.0 0.0 0.0 559.0 473.73 85.27 699.0 279.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-06-07 09:38:45
4803 4818 11 1235 14902 10 RADIANCE GLOW DAY CREAM NULL 33049900 1 375.0 1424.0 0.0 0.0 750.0 635.59 114.41 1424.0 375.0 750.0 9.0 57.2 9.0 57.2 0.0 0.0 635.59 114.41 750.0 INR 3 2.0 12.71 2026-06-07 09:38:45
4804 4819 12 1235 14902 50 Sun Screen NULL 330499 1 279.0 699.0 0.0 0.0 559.0 473.73 85.27 699.0 279.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-06-07 09:38:45
4805 4820 13 1235 14902 53 Terra care 2 kg NULL 3103100 1 575.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 1500.0 575.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-06-07 09:38:45
4806 4821 14 1235 14902 36 Toilet Cleaner 500ml NULL 3924101 10 42.0 150.0 0.0 0.0 120.0 101.69 18.31 1500.0 420.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-06-07 09:38:45
4807 4822 15 1235 14902 44 Vital Glow Face Scrub NULL 3304300 1 130.0 325.0 0.0 0.0 260.0 220.34 39.66 325.0 130.0 260.0 9.0 19.83 9.0 19.83 0.0 0.0 220.34 39.66 260.0 INR 3 2.0 4.41 2026-06-07 09:38:45
4808 4823 1 1236 14902 1 Stem Cell Powder NULL 2936900 1 500.0 2499.0 0.0 0.0 1000.0 952.38 47.62 2499.0 500.0 1000.0 2.5 23.81 2.5 23.81 0.0 0.0 952.38 47.62 1000.0 INR 3 2.0 19.05 2026-06-07 12:34:40
4809 4824 1 1237 12555 11 BHRINGRAJ & SHIKAKAI NULL 33051090 5 375.0 1250.0 0.0 0.0 750.0 714.29 35.71 6250.0 1875.0 3750.0 2.5 89.29 2.5 89.29 0.0 0.0 3571.43 178.57 3750.0 INR 3 2.0 71.43 2026-06-07 17:17:05
4810 4825 2 1237 12555 49 Anti Dandruff Serum NULL 3304999 5 399.0 999.0 0.0 0.0 799.0 677.12 121.88 4995.0 1995.0 3995.0 9.0 304.7 9.0 304.7 0.0 0.0 3385.59 609.41 3995.0 INR 3 2.0 67.71 2026-06-07 17:17:05
4811 4826 3 1237 12555 60 Foot patch NULL 30051090 5 799.0 1999.0 0.0 0.0 1599.0 1522.86 76.14 9995.0 3995.0 7995.0 2.5 190.36 2.5 190.36 0.0 0.0 7614.29 380.71 7995.0 INR 3 2.0 152.29 2026-06-07 17:17:05
4812 4827 4 1237 12555 9 Omega 369 NULL 2936900 5 360.0 999.0 0.0 0.0 720.0 685.71 34.29 4995.0 1800.0 3600.0 2.5 85.71 2.5 85.71 0.0 0.0 3428.57 171.43 3600.0 INR 3 2.0 68.57 2026-06-07 17:17:05
4813 4828 5 1237 12555 94 PAVANA DROPS NULL 30041211 5 249.0 699.0 0.0 0.0 499.0 475.24 23.76 3495.0 1245.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-06-07 17:17:05
4814 4829 6 1237 12555 12 PREMIUM RADIANCE FACE SERUM NULL 33049990 5 375.0 1250.0 0.0 0.0 750.0 714.29 35.71 6250.0 1875.0 3750.0 2.5 89.29 2.5 89.29 0.0 0.0 3571.43 178.57 3750.0 INR 3 2.0 71.43 2026-06-07 17:17:05
4815 4830 7 1237 12555 65 SINGLE WELLNESS NULL 94041000 2 5350.0 12999.0 0.0 0.0 10700.0 10190.48 509.52 25998.0 10700.0 21400.0 2.5 509.52 2.5 509.52 0.0 0.0 20380.95 1019.05 21400.0 INR 3 2.0 407.62 2026-06-07 17:17:05
4816 4831 8 1237 12555 95 STRI VEDA NULL 30049011 5 750.0 2500.0 0.0 0.0 1500.0 1428.57 71.43 12500.0 3750.0 7500.0 2.5 178.57 2.5 178.57 0.0 0.0 7142.86 357.14 7500.0 INR 3 2.0 142.86 2026-06-07 17:17:05
4817 4832 9 1237 12555 50 Sun Screen NULL 330499 5 279.0 699.0 0.0 0.0 559.0 473.73 85.27 3495.0 1395.0 2795.0 9.0 213.18 9.0 213.18 0.0 0.0 2368.64 426.36 2795.0 INR 3 2.0 47.37 2026-06-07 17:17:05
4818 4833 10 1237 12555 96 TRIM VEDA NULL 30049011 6 750.0 2500.0 0.0 0.0 1500.0 1428.57 71.43 15000.0 4500.0 9000.0 2.5 214.29 2.5 214.29 0.0 0.0 8571.43 428.57 9000.0 INR 3 2.0 171.43 2026-06-07 17:17:05
4819 4834 1 1238 12554 20 Premium Berry Juice 1000ml NULL 2936900 20 800.0 3499.0 0.0 0.0 1600.0 1523.81 76.19 69980.0 16000.0 32000.0 2.5 761.9 2.5 761.9 0.0 0.0 30476.19 1523.81 32000.0 INR 2 6.0 1828.57 2026-06-07 17:21:33
4820 4835 2 1238 12554 31 Vegan Plant Protein Powder NULL 21061000 9 700.0 2999.0 0.0 0.0 1400.0 1333.33 66.67 26991.0 6300.0 12600.0 2.5 300.0 2.5 300.0 0.0 0.0 12000.0 600.0 12600.0 INR 2 6.0 720.0 2026-06-07 17:21:33
4821 4836 3 1238 12554 82 ALKALINE CAPSULE NULL 3402000 10 800.0 2500.0 0.0 0.0 1650.0 1571.43 78.57 25000.0 8000.0 16500.0 2.5 392.86 2.5 392.86 0.0 0.0 15714.29 785.71 16500.0 INR 2 6.0 942.86 2026-06-07 17:21:33
4822 4837 1 1239 12527 31 Vegan Plant Protein Powder NULL 21061000 1 700.0 2999.0 0.0 0.0 1400.0 1333.33 66.67 2999.0 700.0 1400.0 2.5 33.33 2.5 33.33 0.0 0.0 1333.33 66.67 1400.0 INR 3 2.0 26.67 2026-06-08 15:26:48
4823 4838 2 1239 12527 52 Bhoo sanjeevni 5 kg NULL 3103100 5 625.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 8000.0 3125.0 6250.0 2.5 148.81 2.5 148.81 0.0 0.0 5952.38 297.62 6250.0 INR 3 2.0 119.05 2026-06-08 15:26:48
4824 4839 3 1239 12527 37 Floor Cleaner 500ml NULL 3924101 20 55.0 199.0 0.0 0.0 159.0 134.75 24.25 3980.0 1100.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-06-08 15:26:48
4825 4840 4 1239 12527 53 Terra care 2 kg NULL 3103100 5 575.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 7500.0 2875.0 5750.0 2.5 136.9 2.5 136.9 0.0 0.0 5476.19 273.81 5750.0 INR 3 2.0 109.52 2026-06-08 15:26:48
4826 4841 5 1239 12527 36 Toilet Cleaner 500ml NULL 3924101 20 42.0 150.0 0.0 0.0 120.0 101.69 18.31 3000.0 840.0 2400.0 9.0 183.05 9.0 183.05 0.0 0.0 2033.9 366.1 2400.0 INR 3 2.0 40.68 2026-06-08 15:26:48
4827 4842 1 1240 12527 20 Premium Berry Juice 1000ml NULL 2936900 1 800.0 3499.0 0.0 0.0 1600.0 1523.81 76.19 3499.0 800.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-06-10 08:11:53
4828 4843 2 1240 12527 25 Manicalcium Tablets NULL 2009899 1 159.0 399.0 0.0 0.0 319.0 303.81 15.19 399.0 159.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-06-10 08:11:53
4829 4844 1 1241 14079 15 KIDNEY CARE JUICE NULL 2009899 2 150.0 349.0 0.0 0.0 300.0 285.71 14.29 698.0 300.0 600.0 2.5 14.29 2.5 14.29 0.0 0.0 571.43 28.57 600.0 INR 3 2.0 11.43 2026-06-11 18:54:37
4830 4845 1 1242 12527 20 Premium Berry Juice 1000ml NULL 2936900 1 800.0 3499.0 0.0 0.0 1600.0 1523.81 76.19 3499.0 800.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-06-12 12:47:27
4831 4846 1 1243 12527 20 Premium Berry Juice 1000ml NULL 2936900 1 800.0 3499.0 0.0 0.0 1600.0 1523.81 76.19 3499.0 800.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-06-12 19:24:02
4832 4847 1 1244 16410 38 Dish Wash 500ml NULL 34029099 1 65.0 230.0 0.0 0.0 184.0 155.93 28.07 230.0 65.0 184.0 9.0 14.03 9.0 14.03 0.0 0.0 155.93 28.07 184.0 INR 4 4.0 6.24 2026-06-13 13:04:53
4833 4848 2 1244 16410 33 HALDI CHANDAN SOAP 100gm NULL 30049011 3 35.0 100.0 0.0 0.0 80.0 76.19 3.81 300.0 105.0 240.0 2.5 5.71 2.5 5.71 0.0 0.0 228.57 11.43 240.0 INR 4 4.0 9.14 2026-06-13 13:04:53
4834 4849 3 1244 16410 16 Liver Care Juice NULL 2009899 1 150.0 349.0 0.0 0.0 300.0 285.71 14.29 349.0 150.0 300.0 2.5 7.14 2.5 7.14 0.0 0.0 285.71 14.29 300.0 INR 4 4.0 11.43 2026-06-13 13:04:53
4835 4850 4 1244 16410 72 Pain Relief Patch NULL 30051090 1 200.0 800.0 0.0 0.0 400.0 380.95 19.05 800.0 200.0 400.0 2.5 9.52 2.5 9.52 0.0 0.0 380.95 19.05 400.0 INR 4 4.0 15.24 2026-06-13 13:04:53
4836 4851 5 1244 16410 47 Premium Hair Care Shampoo NULL 3305109 1 279.0 699.0 0.0 0.0 559.0 532.38 26.62 699.0 279.0 559.0 2.5 13.31 2.5 13.31 0.0 0.0 532.38 26.62 559.0 INR 4 4.0 21.3 2026-06-13 13:04:53
4837 4852 6 1244 16410 46 Root Vitality Hair Oil NULL 3305901 2 102.0 255.0 0.0 0.0 204.0 194.29 9.71 510.0 204.0 408.0 2.5 9.71 2.5 9.71 0.0 0.0 388.57 19.43 408.0 INR 4 4.0 15.54 2026-06-13 13:04:53
4838 4853 1 1245 16410 37 Floor Cleaner 500ml NULL 3924101 1 55.0 199.0 0.0 0.0 159.0 134.75 24.25 199.0 55.0 159.0 9.0 12.13 9.0 12.13 0.0 0.0 134.75 24.25 159.0 INR 4 4.0 5.39 2026-06-13 13:15:23
4839 4854 2 1245 16410 30 Iron Capsules NULL 30049011 1 359.0 899.0 0.0 0.0 719.0 684.76 34.24 899.0 359.0 719.0 2.5 17.12 2.5 17.12 0.0 0.0 684.76 34.24 719.0 INR 4 4.0 27.39 2026-06-13 13:15:23
4840 4855 3 1245 16410 28 Ortho Joint Shield NULL 2009899 2 600.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 2998.0 1200.0 2400.0 2.5 57.14 2.5 57.14 0.0 0.0 2285.71 114.29 2400.0 INR 4 2.0 45.71 2026-06-13 13:15:23
4841 4856 1 1246 12555 20 Premium Berry Juice 1000ml NULL 2936900 20 800.0 3499.0 0.0 0.0 1600.0 1523.81 76.19 69980.0 16000.0 32000.0 2.5 761.9 2.5 761.9 0.0 0.0 30476.19 1523.81 32000.0 INR 3 2.0 609.52 2026-06-13 13:20:29
4842 4857 1 1247 16410 33 HALDI CHANDAN SOAP 100gm NULL 30049011 2 35.0 100.0 0.0 0.0 80.0 76.19 3.81 200.0 70.0 160.0 2.5 3.81 2.5 3.81 0.0 0.0 152.38 7.62 160.0 INR 4 4.0 6.1 2026-06-13 13:28:28
4843 4858 2 1247 16410 34 HERBO 33 TOOTHPASTE NULL 33061090 2 55.0 199.0 0.0 0.0 159.0 134.75 24.25 398.0 110.0 318.0 9.0 24.25 9.0 24.25 0.0 0.0 269.49 48.51 318.0 INR 4 4.0 10.78 2026-06-13 13:28:28
4844 4859 3 1247 16410 30 Iron Capsules NULL 30049011 1 359.0 899.0 0.0 0.0 719.0 684.76 34.24 899.0 359.0 719.0 2.5 17.12 2.5 17.12 0.0 0.0 684.76 34.24 719.0 INR 4 4.0 27.39 2026-06-13 13:28:28
4845 4860 4 1247 16410 95 STRI VEDA NULL 30049011 1 750.0 2500.0 0.0 0.0 1500.0 1428.57 71.43 2500.0 750.0 1500.0 2.5 35.71 2.5 35.71 0.0 0.0 1428.57 71.43 1500.0 INR 4 4.0 57.14 2026-06-13 13:28:28
4846 4861 1 1248 12527 50 Sun Screen NULL 330499 1 279.0 699.0 0.0 0.0 559.0 473.73 85.27 699.0 279.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-06-15 14:53:17
4847 4862 1 1249 12527 20 Premium Berry Juice 1000ml NULL 2936900 1 800.0 3499.0 0.0 0.0 1600.0 1523.81 76.19 3499.0 800.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-06-15 16:09:37
4848 4863 1 1250 12526 31 Vegan Plant Protein Powder NULL 21061000 1 700.0 2999.0 0.0 0.0 1400.0 1333.33 66.67 2999.0 700.0 1400.0 2.5 33.33 2.5 33.33 0.0 0.0 1333.33 66.67 1400.0 INR 3 2.0 26.67 2026-06-15 22:48:22
4849 4864 2 1250 12526 52 Bhoo sanjeevni 5 kg NULL 3103100 3 625.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 4800.0 1875.0 3750.0 2.5 89.29 2.5 89.29 0.0 0.0 3571.43 178.57 3750.0 INR 3 2.0 71.43 2026-06-15 22:48:22
4850 4865 3 1250 12526 53 Terra care 2 kg NULL 3103100 3 575.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 4500.0 1725.0 3450.0 2.5 82.14 2.5 82.14 0.0 0.0 3285.71 164.29 3450.0 INR 3 2.0 65.71 2026-06-15 22:48:22