fx_franchise_order_product

4,933 rows · 33 columns · page 83 / 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
4101 4114 1 1002 12532 20 Premium Berry Juice 1000ml NULL 2936900 3 0.0 3499.0 0.0 0.0 2600.0 2476.19 123.81 10497.0 0.0 7800.0 2.5 185.71 2.5 185.71 0.0 0.0 7428.57 371.43 7800.0 INR 3 2.0 148.57 2026-03-03 17:03:13
4102 4115 2 1002 12532 82 ALKALINE CAPSULE NULL 3402000 3 0.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 7500.0 0.0 6000.0 2.5 142.86 2.5 142.86 0.0 0.0 5714.29 285.71 6000.0 INR 3 2.0 114.29 2026-03-03 17:03:13
4103 4116 3 1002 12532 38 Dish Wash 500ml NULL 34029099 10 0.0 230.0 0.0 0.0 184.0 155.93 28.07 2300.0 0.0 1840.0 9.0 140.34 9.0 140.34 0.0 0.0 1559.32 280.68 1840.0 INR 3 2.0 31.19 2026-03-03 17:03:13
4104 4117 4 1002 12532 39 Fabric Wash 1000ml NULL 34029099 10 0.0 401.0 0.0 0.0 321.0 272.03 48.97 4010.0 0.0 3210.0 9.0 244.83 9.0 244.83 0.0 0.0 2720.34 489.66 3210.0 INR 3 2.0 54.41 2026-03-03 17:03:13
4105 4118 5 1002 12532 19 Fat loss Juice 500 ml NULL 30049011 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-03 17:03:13
4106 4119 6 1002 12532 37 Floor Cleaner 500ml NULL 3924101 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-03 17:03:13
4107 4120 7 1002 12532 48 Glow bliss face wash NULL 3304999 2 0.0 380.0 0.0 0.0 304.0 257.63 46.37 760.0 0.0 608.0 9.0 46.37 9.0 46.37 0.0 0.0 515.25 92.75 608.0 INR 3 2.0 10.31 2026-03-03 17:03:13
4108 4121 8 1002 12532 33 HALDI CHANDAN SOAP 100gm NULL 30049011 200 0.0 100.0 0.0 0.0 80.0 76.19 3.81 20000.0 0.0 16000.0 2.5 380.95 2.5 380.95 0.0 0.0 15238.1 761.9 16000.0 INR 3 2.0 304.76 2026-03-03 17:03:13
4109 4122 9 1002 12532 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-03 17:03:13
4110 4123 10 1002 12532 32 Neem Soap 100gm NULL 34011110 300 0.0 60.0 0.0 0.0 48.0 45.71 2.29 18000.0 0.0 14400.0 2.5 342.86 2.5 342.86 0.0 0.0 13714.29 685.71 14400.0 INR 3 2.0 274.29 2026-03-03 17:03:13
4111 4124 11 1002 12532 72 Pain Relief Patch NULL 30051090 3 0.0 800.0 0.0 0.0 600.0 571.43 28.57 2400.0 0.0 1800.0 2.5 42.86 2.5 42.86 0.0 0.0 1714.29 85.71 1800.0 INR 3 2.0 34.29 2026-03-03 17:03:13
4112 4125 12 1002 12532 94 PAVANA DROPS NULL 30041211 3 0.0 699.0 0.0 0.0 499.0 475.24 23.76 2097.0 0.0 1497.0 2.5 35.64 2.5 35.64 0.0 0.0 1425.71 71.29 1497.0 INR 3 2.0 28.51 2026-03-03 17:03:13
4113 4126 13 1002 12532 10 RADIANCE GLOW DAY CREAM NULL 33049900 1 0.0 1424.0 0.0 0.0 750.0 635.59 114.41 1424.0 0.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-03-03 17:03:13
4114 4127 14 1002 12532 46 Root Vitality Hair Oil NULL 3305901 10 0.0 255.0 0.0 0.0 204.0 194.29 9.71 2550.0 0.0 2040.0 2.5 48.57 2.5 48.57 0.0 0.0 1942.86 97.14 2040.0 INR 3 2.0 38.86 2026-03-03 17:03:13
4115 4128 15 1002 12532 35 Sanitary Pad (15 pcs) NULL 9619001 5 0.0 380.0 0.0 0.0 304.0 304.0 0.0 1900.0 0.0 1520.0 0.0 0.0 0.0 0.0 0.0 0.0 1520.0 0.0 1520.0 INR 3 2.0 30.4 2026-03-03 17:03:13
4116 4129 16 1002 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-03 17:03:13
4117 4130 17 1002 12532 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-03 17:03:13
4118 4131 1 1003 12545 11 BRINGRAJ & SHIKAKAI NULL 33051090 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-04 11:20:53
4119 4132 2 1003 12545 27 Multicharge Cap NULL 2009899 2 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 2998.0 0.0 2400.0 2.5 57.14 2.5 57.14 0.0 0.0 2285.71 114.29 2400.0 INR 3 2.0 45.71 2026-03-04 11:20:53
4120 4133 3 1003 12545 3 BP 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-04 11:20:53
4121 4134 4 1003 12545 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-04 11:20:53
4122 4135 5 1003 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-04 11:20:53
4123 4136 6 1003 12545 37 Floor Cleaner 500ml NULL 3924101 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-04 11:20:53
4124 4137 7 1003 12545 24 Immunomax 24/7 Caps NULL 2009899 2 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 2998.0 0.0 2400.0 2.5 57.14 2.5 57.14 0.0 0.0 2285.71 114.29 2400.0 INR 3 2.0 45.71 2026-03-04 11:20:53
4125 4138 8 1003 12545 30 Iron Capsules NULL 30049011 2 0.0 899.0 0.0 0.0 719.0 684.76 34.24 1798.0 0.0 1438.0 2.5 34.24 2.5 34.24 0.0 0.0 1369.52 68.48 1438.0 INR 3 2.0 27.39 2026-03-04 11:20:53
4126 4139 9 1003 12545 25 Manicalcium Tablets NULL 2009899 2 0.0 399.0 0.0 0.0 319.0 303.81 15.19 798.0 0.0 638.0 2.5 15.19 2.5 15.19 0.0 0.0 607.62 30.38 638.0 INR 3 2.0 12.15 2026-03-04 11:20:53
4127 4140 10 1003 12545 32 Neem Soap 100gm NULL 34011110 7 0.0 60.0 0.0 0.0 48.0 45.71 2.29 420.0 0.0 336.0 2.5 8.0 2.5 8.0 0.0 0.0 320.0 16.0 336.0 INR 3 2.0 6.4 2026-03-04 11:20:53
4128 4141 11 1003 12545 9 Omega 369 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-04 11:20:53
4129 4142 12 1003 12545 94 PAVANA DROPS NULL 30041211 1 0.0 699.0 0.0 0.0 499.0 475.24 23.76 699.0 0.0 499.0 2.5 11.88 2.5 11.88 0.0 0.0 475.24 23.76 499.0 INR 3 2.0 9.5 2026-03-04 11:20:53
4130 4143 13 1003 12545 46 Root Vitality Hair Oil NULL 3305901 4 0.0 255.0 0.0 0.0 204.0 194.29 9.71 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-04 11:20:53
4131 4144 1 1004 12526 31 Vegan Plant Protein Powder NULL 21061000 2 0.0 2999.0 0.0 0.0 2000.0 1904.76 95.24 5998.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-04 23:18:18
4132 4145 2 1004 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-04 23:18:18
4133 4146 3 1004 12526 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-04 23:18:18
4134 4147 4 1004 12526 46 Root Vitality Hair Oil NULL 3305901 5 0.0 255.0 0.0 0.0 204.0 194.29 9.71 1275.0 0.0 1020.0 2.5 24.29 2.5 24.29 0.0 0.0 971.43 48.57 1020.0 INR 3 2.0 19.43 2026-03-04 23:18:18
4135 4148 5 1004 12526 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-04 23:18:18
4136 4149 6 1004 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-04 23:18:18
4137 4150 7 1004 12526 34 Toothpaste NULL 33061090 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-04 23:18:18
4138 4151 1 1005 12527 4 Diabetic Care Capsules NULL 2936900 5 0.0 999.0 0.0 0.0 720.0 685.71 34.29 4995.0 0.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-03-05 15:46:24
4139 4152 2 1005 12527 19 Fat loss Juice 500 ml NULL 30049011 3 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 4497.0 0.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-03-05 15:46:24
4140 4153 3 1005 12527 28 Ortho Joint Shield NULL 2009899 3 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 4497.0 0.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-03-05 15:46:24
4141 4154 1 1006 12532 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 7 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 130900.0 0.0 74900.0 2.5 1783.33 2.5 1783.33 0.0 0.0 71333.33 3566.67 74900.0 INR 3 2.0 1426.67 2026-03-06 15:49:54
4142 4155 1 1007 14902 52 Bhoo sanjeevni 5 kg NULL 3103100 5 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 8000.0 0.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-03-06 21:24:47
4143 4156 2 1007 14902 37 Floor Cleaner 500ml NULL 3924101 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-06 21:24:47
4144 4157 3 1007 14902 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-06 21:24:47
4145 4158 4 1007 14902 53 Terra care 2 kg NULL 3103100 5 0.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 7500.0 0.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-03-06 21:24:47
4146 4159 1 1008 12521 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 1 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 18700.0 0.0 10700.0 2.5 254.76 2.5 254.76 0.0 0.0 10190.48 509.52 10700.0 INR 3 2.0 203.81 2026-03-06 21:57:30
4147 4160 1 1009 12521 20 Premium Berry Juice 1000ml NULL 2936900 1 0.0 3499.0 0.0 0.0 2600.0 2476.19 123.81 3499.0 0.0 2600.0 2.5 61.9 2.5 61.9 0.0 0.0 2476.19 123.81 2600.0 INR 3 2.0 49.52 2026-03-06 21:59:44
4148 4161 2 1009 12521 32 Neem Soap 100gm NULL 34011110 200 0.0 60.0 0.0 0.0 48.0 45.71 2.29 12000.0 0.0 9600.0 2.5 228.57 2.5 228.57 0.0 0.0 9142.86 457.14 9600.0 INR 3 2.0 182.86 2026-03-06 21:59:44
4149 4162 1 1010 12532 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 1 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 18700.0 0.0 10700.0 2.5 254.76 2.5 254.76 0.0 0.0 10190.48 509.52 10700.0 INR 3 2.0 203.81 2026-03-07 17:52:30
4150 4163 1 1011 12526 20 Premium Berry Juice 1000ml NULL 2936900 2 0.0 3499.0 0.0 0.0 2600.0 2476.19 123.81 6998.0 0.0 5200.0 2.5 123.81 2.5 123.81 0.0 0.0 4952.38 247.62 5200.0 INR 3 2.0 99.05 2026-03-07 21:01:56