fx_franchise_order_product

4,933 rows · 33 columns · page 25 / 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
1201 1214 3 166 12517 74 EXPLORER BOX NULL NULL 3 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 80991.0 0.0 31497.0 0.0 0.0 0.0 0.0 5.0 1499.86 9999.05 1499.86 31497.0 INR 0 0.0 0.0 2025-11-11 16:18:14
1202 1215 1 167 12555 48 glow face wash NULL 3304999 5 250.0 380.0 0.0 0.0 304.0 257.63 46.37 1900.0 1250.0 1520.0 9.0 115.93 9.0 115.93 0.0 0.0 257.63 231.86 1520.0 INR 0 0.0 0.0 2025-11-11 16:30:18
1203 1216 2 167 12555 20 Premium Berry Juice 1000ml NULL 2936900 3 750.0 3499.0 0.0 0.0 3479.0 3313.33 165.67 10497.0 2250.0 10437.0 2.5 248.5 2.5 248.5 0.0 0.0 3313.33 497.0 10437.0 INR 0 0.0 0.0 2025-11-11 16:30:18
1204 1217 3 167 12555 70 Premium Hand belt NULL 9404 3 600.0 9999.0 0.0 0.0 1440.0 1371.43 68.57 29997.0 1800.0 4320.0 2.5 102.86 2.5 102.86 0.0 0.0 1371.43 205.71 4320.0 INR 0 0.0 0.0 2025-11-11 16:30:18
1205 1218 4 167 12555 61 Radiation chip NULL 902221 3 325.0 999.0 0.0 0.0 799.2 677.29 121.91 2997.0 975.0 2397.6 9.0 182.87 9.0 182.87 0.0 0.0 677.29 365.74 2397.6 INR 0 0.0 0.0 2025-11-11 16:30:18
1206 1219 5 167 12555 31 Vegan Plant Protein Powder NULL 21061000 3 1000.0 2999.0 0.0 0.0 2399.2 2284.95 114.25 8997.0 3000.0 7197.6 2.5 171.37 2.5 171.37 0.0 0.0 2284.95 342.74 7197.6 INR 0 0.0 0.0 2025-11-11 16:30:18
1207 1220 6 167 12555 6 Asthma Care NULL 30049011 3 250.0 899.0 0.0 0.0 719.2 684.95 34.25 2697.0 750.0 2157.6 2.5 51.37 2.5 51.37 0.0 0.0 684.95 102.74 2157.6 INR 0 0.0 0.0 2025-11-11 16:30:18
1208 1221 7 167 12555 52 Bhoo sanjeevni 5 kg NULL 3103100 3 450.0 1600.0 0.0 0.0 1280.0 1219.05 60.95 4800.0 1350.0 3840.0 2.5 91.43 2.5 91.43 0.0 0.0 1219.05 182.86 3840.0 INR 0 0.0 0.0 2025-11-11 16:30:18
1209 1222 8 167 12555 3 BP Care Capsules NULL 2936900 5 160.0 599.0 0.0 0.0 479.2 456.38 22.82 2995.0 800.0 2396.0 2.5 57.05 2.5 57.05 0.0 0.0 456.38 114.1 2396.0 INR 0 0.0 0.0 2025-11-11 16:30:18
1210 1223 9 167 12555 4 Diabetic Care Capsules NULL 2936900 5 250.0 899.0 0.0 0.0 719.2 684.95 34.25 4495.0 1250.0 3596.0 2.5 85.62 2.5 85.62 0.0 0.0 684.95 171.24 3596.0 INR 0 0.0 0.0 2025-11-11 16:30:18
1211 1224 10 167 12555 38 Dish Wash 500ml NULL 3924101 3 85.0 230.0 0.0 0.0 184.0 155.93 28.07 690.0 255.0 552.0 9.0 42.1 9.0 42.1 0.0 0.0 155.93 84.2 552.0 INR 0 0.0 0.0 2025-11-11 16:30:18
1212 1225 11 167 12555 39 Fabric Wash 1000ml NULL 3924101 3 150.0 401.0 0.0 0.0 320.8 271.86 48.94 1203.0 450.0 962.4 9.0 73.41 9.0 73.41 0.0 0.0 271.86 146.81 962.4 INR 0 0.0 0.0 2025-11-11 16:30:18
1213 1226 12 167 12555 19 Fat loss Juice 500 ml NULL 30049011 3 250.0 1499.0 0.0 0.0 1479.0 1408.57 70.43 4497.0 750.0 4437.0 2.5 105.64 2.5 105.64 0.0 0.0 1408.57 211.29 4437.0 INR 0 0.0 0.0 2025-11-11 16:30:18
1214 1227 13 167 12555 22 Fit Fuel Juice NULL 2009899 3 200.0 1999.0 0.0 0.0 1979.0 1884.76 94.24 5997.0 600.0 5937.0 2.5 141.35 2.5 141.35 0.0 0.0 1884.76 282.71 5937.0 INR 0 0.0 0.0 2025-11-11 16:30:18
1215 1228 14 167 12555 37 Floor Cleaner 500ml NULL 3924101 3 80.0 199.0 0.0 0.0 159.2 134.92 24.28 597.0 240.0 477.6 9.0 36.42 9.0 36.42 0.0 0.0 134.92 72.85 477.6 INR 0 0.0 0.0 2025-11-11 16:30:18
1216 1229 15 167 12555 60 Foot patch NULL 30051090 3 500.0 1999.0 0.0 0.0 1599.2 1523.05 76.15 5997.0 1500.0 4797.6 2.5 114.23 2.5 114.23 0.0 0.0 1523.05 228.46 4797.6 INR 0 0.0 0.0 2025-11-11 16:30:18
1217 1230 16 167 12555 58 Green shield 250ml NULL 3105 2 800.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 5000.0 1600.0 4000.0 2.5 95.24 2.5 95.24 0.0 0.0 1904.76 190.48 4000.0 INR 0 0.0 0.0 2025-11-11 16:30:18
1218 1231 17 167 12555 55 Grow master 500ml NULL 3105 2 850.0 2030.0 0.0 0.0 1624.0 1546.67 77.33 4060.0 1700.0 3248.0 2.5 77.33 2.5 77.33 0.0 0.0 1546.67 154.67 3248.0 INR 0 0.0 0.0 2025-11-11 16:30:18
1219 1232 18 167 12555 2 Heart Care Capsules NULL 2936900 2 425.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 2998.0 850.0 2398.4 2.5 57.1 2.5 57.1 0.0 0.0 1142.1 114.21 2398.4 INR 0 0.0 0.0 2025-11-11 16:30:18
1220 1233 19 167 12555 33 Herbal Soap 100gm NULL 30049011 25 28.0 100.0 0.0 0.0 80.0 76.19 3.81 2500.0 700.0 2000.0 2.5 47.62 2.5 47.62 0.0 0.0 76.19 95.24 2000.0 INR 0 0.0 0.0 2025-11-11 16:30:18
1221 1234 20 167 12555 34 Herbo2o Toothpaste NULL 33061090 20 45.0 199.0 0.0 0.0 159.2 134.92 24.28 3980.0 900.0 3184.0 9.0 242.84 9.0 242.84 0.0 0.0 134.92 485.69 3184.0 INR 0 0.0 0.0 2025-11-11 16:30:18
1222 1235 1 168 12555 24 Immunomax 24/7 Caps NULL 2009899 2 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 2998.0 900.0 2398.4 2.5 57.1 2.5 57.1 0.0 0.0 1142.1 114.21 2398.4 INR 0 0.0 0.0 2025-11-11 16:34:35
1223 1236 2 168 12555 30 Iron Capsules NULL 30049011 2 250.0 899.0 0.0 0.0 719.2 684.95 34.25 1798.0 500.0 1438.4 2.5 34.25 2.5 34.25 0.0 0.0 684.95 68.5 1438.4 INR 0 0.0 0.0 2025-11-11 16:34:35
1224 1237 3 168 12555 15 Kidney Stone Juice NULL 2009899 5 120.0 349.0 0.0 0.0 279.2 265.9 13.3 1745.0 600.0 1396.0 2.5 33.24 2.5 33.24 0.0 0.0 265.9 66.48 1396.0 INR 0 0.0 0.0 2025-11-11 16:34:35
1225 1238 4 168 12555 18 Lady Care Juice 500ml NULL 2009899 2 250.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 2998.0 500.0 2398.4 2.5 57.1 2.5 57.1 0.0 0.0 1142.1 114.21 2398.4 INR 0 0.0 0.0 2025-11-11 16:34:35
1226 1239 5 168 12555 16 Liver Care Juice NULL 2009899 5 120.0 349.0 0.0 0.0 279.2 265.9 13.3 1745.0 600.0 1396.0 2.5 33.24 2.5 33.24 0.0 0.0 265.9 66.48 1396.0 INR 0 0.0 0.0 2025-11-11 16:34:35
1227 1240 6 168 12555 25 Manicalcium Tablets NULL 2009899 3 95.0 399.0 0.0 0.0 319.2 304.0 15.2 1197.0 285.0 957.6 2.5 22.8 2.5 22.8 0.0 0.0 304.0 45.6 957.6 INR 0 0.0 0.0 2025-11-11 16:34:35
1228 1241 7 168 12555 12 Melatonin Drop NULL 2106909 3 190.0 749.0 0.0 0.0 599.2 570.67 28.53 2247.0 570.0 1797.6 2.5 42.8 2.5 42.8 0.0 0.0 570.67 85.6 1797.6 INR 0 0.0 0.0 2025-11-11 16:34:35
1229 1242 8 168 12555 17 Memory Booster Juice NULL 2009899 3 120.0 349.0 0.0 0.0 279.2 265.9 13.3 1047.0 360.0 837.6 2.5 19.95 2.5 19.95 0.0 0.0 265.9 39.89 837.6 INR 0 0.0 0.0 2025-11-11 16:34:35
1230 1243 9 168 12555 56 Micro magic 500ml NULL 3105 2 850.0 2030.0 0.0 0.0 1624.0 1376.27 247.73 4060.0 1700.0 3248.0 9.0 247.73 9.0 247.73 0.0 0.0 1376.27 495.46 3248.0 INR 0 0.0 0.0 2025-11-11 16:34:35
1231 1244 10 168 12555 7 Morning Fresh Churan NULL 30049011 3 40.0 199.0 0.0 0.0 159.2 151.62 7.58 597.0 120.0 477.6 2.5 11.37 2.5 11.37 0.0 0.0 151.62 22.74 477.6 INR 0 0.0 0.0 2025-11-11 16:34:35
1232 1245 11 168 12555 32 Neem Soap 100gm NULL 34011110 20 10.0 60.0 0.0 0.0 48.0 45.71 2.29 1200.0 200.0 960.0 2.5 22.86 2.5 22.86 0.0 0.0 45.71 45.71 960.0 INR 0 0.0 0.0 2025-11-11 16:34:35
1233 1246 12 168 12555 9 Omega 369 NULL 2936900 2 260.0 999.0 0.0 0.0 799.2 761.14 38.05 1998.0 520.0 1598.4 2.5 38.05 2.5 38.05 0.0 0.0 761.14 76.11 1598.4 INR 0 0.0 0.0 2025-11-11 16:34:35
1234 1247 13 168 12555 28 Ortho Joint Shield NULL 2009899 2 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 2998.0 900.0 2398.4 2.5 57.1 2.5 57.1 0.0 0.0 1142.1 114.21 2398.4 INR 0 0.0 0.0 2025-11-11 16:34:35
1235 1248 1 169 12516 76 ELITE BOX NULL NULL 5 0.0 46494.0 0.0 0.0 18000.0 17142.86 857.14 232470.0 0.0 90000.0 2.5 2142.86 2.5 2142.86 0.0 0.0 17142.86 4285.71 90000.0 INR 0 0.0 0.0 2025-11-11 16:40:11
1236 1249 1 170 12555 72 Pain Relief Patch NULL 30051090 5 200.0 800.0 0.0 0.0 640.0 609.52 30.48 4000.0 1000.0 3200.0 2.5 76.19 2.5 76.19 0.0 0.0 609.52 152.38 3200.0 INR 0 0.0 0.0 2025-11-11 16:42:11
1237 1250 2 170 12555 8 Piles Care NULL 30049011 3 250.0 899.0 0.0 0.0 719.2 684.95 34.25 2697.0 750.0 2157.6 2.5 51.37 2.5 51.37 0.0 0.0 684.95 102.74 2157.6 INR 0 0.0 0.0 2025-11-11 16:42:11
1238 1251 3 170 12555 41 Premium Coco Body Lotion NULL 3304300 3 250.0 699.0 0.0 0.0 559.2 473.9 85.3 2097.0 750.0 1677.6 9.0 127.95 9.0 127.95 0.0 0.0 473.9 255.91 1677.6 INR 0 0.0 0.0 2025-11-11 16:42:11
1239 1252 4 170 12555 14 Premium Aloe Vera VEG caps NULL 2936900 3 100.0 359.0 0.0 0.0 287.2 273.52 13.68 1077.0 300.0 861.6 2.5 20.52 2.5 20.52 0.0 0.0 273.52 41.03 861.6 INR 0 0.0 0.0 2025-11-11 16:42:11
1240 1253 5 170 12555 47 Premium Hair Care Shampoo NULL 3305109 3 150.0 699.0 0.0 0.0 559.2 532.57 26.63 2097.0 450.0 1677.6 2.5 39.95 2.5 39.95 0.0 0.0 532.57 79.89 1677.6 INR 0 0.0 0.0 2025-11-11 16:42:11
1241 1254 6 170 12555 13 Premium NONI VEG caps NULL 2936900 3 150.0 501.0 0.0 0.0 400.8 381.71 19.09 1503.0 450.0 1202.4 2.5 28.63 2.5 28.63 0.0 0.0 381.71 57.26 1202.4 INR 0 0.0 0.0 2025-11-11 16:42:11
1242 1255 7 170 12555 43 Quench Kiss Lip Balm NULL 3304300 3 35.0 199.0 0.0 0.0 159.2 134.92 24.28 597.0 105.0 477.6 9.0 36.42 9.0 36.42 0.0 0.0 134.92 72.85 477.6 INR 0 0.0 0.0 2025-11-11 16:42:11
1243 1256 8 170 12555 57 Safe guard 250ml NULL 3105 3 800.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 7500.0 2400.0 6000.0 2.5 142.85 2.5 142.85 0.0 0.0 1904.76 285.71 6000.0 INR 0 0.0 0.0 2025-11-11 16:42:11
1244 1257 9 170 12555 35 Sanitary Pad (15 pcs) NULL 9619001 2 40.0 380.0 0.0 0.0 304.0 304.0 0.0 760.0 80.0 608.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 608.0 INR 0 0.0 0.0 2025-11-11 16:42:11
1245 1258 10 170 12555 29 Shilajith NULL 30049011 3 250.0 1800.0 0.0 0.0 1440.0 1371.43 68.57 5400.0 750.0 4320.0 2.5 102.86 2.5 102.86 0.0 0.0 1371.43 205.71 4320.0 INR 0 0.0 0.0 2025-11-11 16:42:11
1246 1259 11 170 12555 26 Spirulina Cap NULL 2009899 3 190.0 899.0 0.0 0.0 719.2 684.95 34.25 2697.0 570.0 2157.6 2.5 51.37 2.5 51.37 0.0 0.0 684.95 102.74 2157.6 INR 0 0.0 0.0 2025-11-11 16:42:11
1247 1260 12 170 12555 1 Stem Cell Powder NULL 2936900 3 749.0 2499.0 0.0 0.0 1999.2 1904.0 95.2 7497.0 2247.0 5997.6 2.5 142.8 2.5 142.8 0.0 0.0 1904.0 285.6 5997.6 INR 0 0.0 0.0 2025-11-11 16:42:11
1248 1261 13 170 12555 50 Sun Screen NULL 330499 3 250.0 699.0 0.0 0.0 559.2 473.9 85.3 2097.0 750.0 1677.6 9.0 127.95 9.0 127.95 0.0 0.0 473.9 255.91 1677.6 INR 0 0.0 0.0 2025-11-11 16:42:11
1249 1262 14 170 12555 53 Terra care 2 kg NULL 3103100 3 450.0 1500.0 0.0 0.0 1200.0 1142.86 57.14 4500.0 1350.0 3600.0 2.5 85.72 2.5 85.72 0.0 0.0 1142.86 171.43 3600.0 INR 0 0.0 0.0 2025-11-11 16:42:11
1250 1263 15 170 12555 5 Thyro Care NULL 2936900 3 250.0 899.0 0.0 0.0 719.2 684.95 34.25 2697.0 750.0 2157.6 2.5 51.37 2.5 51.37 0.0 0.0 684.95 102.74 2157.6 INR 0 0.0 0.0 2025-11-11 16:42:11