fx_franchise_order_product

4,933 rows · 33 columns · page 26 / 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
1251 1264 16 170 12555 36 Toilet Cleaner 500ml NULL 3924101 3 30.0 150.0 0.0 0.0 120.0 101.69 18.31 450.0 90.0 360.0 9.0 27.46 9.0 27.46 0.0 0.0 101.69 54.92 360.0 INR 0 0.0 0.0 2025-11-11 16:42:11
1252 1265 17 170 12555 44 Vital Glow Face Scrub NULL 3304300 3 71.0 325.0 0.0 0.0 260.0 220.34 39.66 975.0 213.0 780.0 9.0 59.49 9.0 59.49 0.0 0.0 220.34 118.98 780.0 INR 0 0.0 0.0 2025-11-11 16:42:11
1253 1266 18 170 12555 54 Wonder grow 100ml NULL 3105 3 500.0 1400.0 0.0 0.0 1120.0 1066.67 53.33 4200.0 1500.0 3360.0 2.5 80.0 2.5 80.0 0.0 0.0 1066.67 160.0 3360.0 INR 0 0.0 0.0 2025-11-11 16:42:11
1254 1267 1 171 12555 32 Neem Soap 100gm NULL 34011110 100 10.0 60.0 0.0 0.0 48.0 45.71 2.29 6000.0 1000.0 4800.0 2.5 114.28 2.5 114.28 0.0 0.0 45.71 228.57 4800.0 INR 0 0.0 0.0 2025-11-11 16:48:11
1255 1268 1 172 12555 46 Root Vitality Hair Oil NULL 3305901 2 54.0 255.0 0.0 0.0 204.0 194.29 9.71 510.0 108.0 408.0 2.5 9.71 2.5 9.71 0.0 0.0 194.29 19.43 408.0 INR 0 0.0 0.0 2025-11-11 16:49:07
1256 1269 1 173 12546 74 EXPLORER BOX NULL NULL 2 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 53994.0 0.0 20998.0 2.5 499.95 2.5 499.95 0.0 0.0 9999.05 999.9 20998.0 INR 0 0.0 0.0 2025-11-11 17:01:10
1257 1270 1 174 12532 48 glow face wash NULL 3304999 2 250.0 380.0 0.0 0.0 304.0 257.63 46.38 760.0 500.0 608.0 9.0 46.38 9.0 46.38 0.0 0.0 257.63 92.75 608.0 INR 0 0.0 0.0 2025-11-11 17:02:00
1258 1271 2 174 12532 37 Floor Cleaner 500ml NULL 3924101 8 80.0 199.0 0.0 0.0 159.2 134.92 24.29 1592.0 640.0 1273.6 9.0 97.14 9.0 97.14 0.0 0.0 134.92 194.28 1273.6 INR 0 0.0 0.0 2025-11-11 17:02:00
1259 1272 3 174 12532 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 17:02:00
1260 1273 4 174 12532 34 Herbo2o Toothpaste NULL 33061090 12 45.0 199.0 0.0 0.0 159.2 134.92 24.29 2388.0 540.0 1910.4 9.0 145.71 9.0 145.71 0.0 0.0 134.92 291.42 1910.4 INR 0 0.0 0.0 2025-11-11 17:02:00
1261 1274 5 174 12532 7 Morning Fresh Churan NULL 30049011 5 40.0 199.0 0.0 0.0 159.2 151.62 7.58 995.0 200.0 796.0 2.5 18.95 2.5 18.95 0.0 0.0 151.62 37.9 796.0 INR 0 0.0 0.0 2025-11-11 17:02:00
1262 1275 6 174 12532 72 Pain Relief Patch NULL 30051090 1 200.0 800.0 0.0 0.0 640.0 609.52 30.48 800.0 200.0 640.0 2.5 15.24 2.5 15.24 0.0 0.0 609.52 30.48 640.0 INR 0 0.0 0.0 2025-11-11 17:02:00
1263 1276 7 174 12532 36 Toilet Cleaner 500ml NULL 3924101 8 30.0 150.0 0.0 0.0 120.0 101.69 18.3 1200.0 240.0 960.0 9.0 73.22 9.0 73.22 0.0 0.0 101.69 146.44 960.0 INR 0 0.0 0.0 2025-11-11 17:02:00
1264 1277 1 175 12555 48 glow face wash NULL 3304999 10 250.0 380.0 0.0 0.0 304.0 257.63 46.37 3800.0 2500.0 3040.0 9.0 231.87 9.0 231.87 0.0 0.0 257.63 463.73 3040.0 INR 0 0.0 0.0 2025-11-11 17:13:54
1265 1278 2 175 12555 27 Multicharge Cap 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 17:13:54
1266 1279 3 175 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 17:13:54
1267 1280 4 175 12555 70 Premium Hand belt NULL 9404 4 600.0 9999.0 0.0 0.0 1440.0 1371.43 68.57 39996.0 2400.0 5760.0 2.5 137.15 2.5 137.15 0.0 0.0 1371.43 274.29 5760.0 INR 0 0.0 0.0 2025-11-11 17:13:54
1268 1281 5 175 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 17:13:54
1269 1282 6 175 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 17:13:54
1270 1283 7 175 12555 49 Anti Dandruff Serum NULL 3304999 3 250.0 999.0 0.0 0.0 799.2 677.29 121.91 2997.0 750.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 17:13:54
1271 1284 8 175 12555 3 BP Care Capsules NULL 2936900 4 160.0 599.0 0.0 0.0 479.2 456.38 22.82 2396.0 640.0 1916.8 2.5 45.64 2.5 45.64 0.0 0.0 456.38 91.28 1916.8 INR 0 0.0 0.0 2025-11-11 17:13:54
1272 1285 9 175 12555 4 Diabetic Care Capsules NULL 2936900 10 250.0 899.0 0.0 0.0 719.2 684.95 34.25 8990.0 2500.0 7192.0 2.5 171.24 2.5 171.24 0.0 0.0 684.95 342.48 7192.0 INR 0 0.0 0.0 2025-11-11 17:13:54
1273 1286 10 175 12555 38 Dish Wash 500ml NULL 3924101 20 85.0 230.0 0.0 0.0 184.0 155.93 28.07 4600.0 1700.0 3680.0 9.0 280.68 9.0 280.68 0.0 0.0 155.93 561.36 3680.0 INR 0 0.0 0.0 2025-11-11 17:13:54
1274 1287 11 175 12555 19 Fat loss Juice 500 ml NULL 30049011 5 250.0 1499.0 0.0 0.0 1479.0 1408.57 70.43 7495.0 1250.0 7395.0 2.5 176.07 2.5 176.07 0.0 0.0 1408.57 352.14 7395.0 INR 0 0.0 0.0 2025-11-11 17:13:54
1275 1288 12 175 12555 37 Floor Cleaner 500ml NULL 3924101 10 80.0 199.0 0.0 0.0 159.2 134.92 24.29 1990.0 800.0 1592.0 9.0 121.42 9.0 121.42 0.0 0.0 134.92 242.85 1592.0 INR 0 0.0 0.0 2025-11-11 17:13:54
1276 1289 13 175 12555 2 Heart Care Capsules NULL 2936900 5 425.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 7495.0 2125.0 5996.0 2.5 142.76 2.5 142.76 0.0 0.0 1142.1 285.52 5996.0 INR 0 0.0 0.0 2025-11-11 17:13:54
1277 1290 14 175 12555 33 Herbal Soap 100gm NULL 30049011 20 28.0 100.0 0.0 0.0 80.0 76.19 3.81 2000.0 560.0 1600.0 2.5 38.09 2.5 38.09 0.0 0.0 76.19 76.19 1600.0 INR 0 0.0 0.0 2025-11-11 17:13:54
1278 1291 15 175 12555 34 Herbo2o Toothpaste NULL 33061090 10 45.0 199.0 0.0 0.0 159.2 134.92 24.29 1990.0 450.0 1592.0 9.0 121.42 9.0 121.42 0.0 0.0 134.92 242.85 1592.0 INR 0 0.0 0.0 2025-11-11 17:13:54
1279 1292 16 175 12555 24 Immunomax 24/7 Caps NULL 2009899 5 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 7495.0 2250.0 5996.0 2.5 142.76 2.5 142.76 0.0 0.0 1142.1 285.52 5996.0 INR 0 0.0 0.0 2025-11-11 17:13:54
1280 1293 17 175 12555 30 Iron Capsules NULL 30049011 4 250.0 899.0 0.0 0.0 719.2 684.95 34.25 3596.0 1000.0 2876.8 2.5 68.5 2.5 68.5 0.0 0.0 684.95 136.99 2876.8 INR 0 0.0 0.0 2025-11-11 17:13:54
1281 1294 18 175 12555 15 Kidney Stone Juice NULL 2009899 6 120.0 349.0 0.0 0.0 279.2 265.9 13.29 2094.0 720.0 1675.2 2.5 39.88 2.5 39.88 0.0 0.0 265.9 79.77 1675.2 INR 0 0.0 0.0 2025-11-11 17:13:54
1282 1295 19 175 12555 18 Lady Care Juice 500ml NULL 2009899 4 250.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 5996.0 1000.0 4796.8 2.5 114.21 2.5 114.21 0.0 0.0 1142.1 228.42 4796.8 INR 0 0.0 0.0 2025-11-11 17:13:54
1283 1296 20 175 12555 16 Liver Care Juice NULL 2009899 4 120.0 349.0 0.0 0.0 279.2 265.9 13.29 1396.0 480.0 1116.8 2.5 26.59 2.5 26.59 0.0 0.0 265.9 53.18 1116.8 INR 0 0.0 0.0 2025-11-11 17:13:54
1284 1297 21 175 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 17:13:54
1285 1298 22 175 12555 12 Melatonin Drop NULL 2106909 5 190.0 749.0 0.0 0.0 599.2 570.67 28.53 3745.0 950.0 2996.0 2.5 71.33 2.5 71.33 0.0 0.0 570.67 142.67 2996.0 INR 0 0.0 0.0 2025-11-11 17:13:54
1286 1299 23 175 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 17:13:54
1287 1300 24 175 12555 7 Morning Fresh Churan NULL 30049011 5 40.0 199.0 0.0 0.0 159.2 151.62 7.58 995.0 200.0 796.0 2.5 18.95 2.5 18.95 0.0 0.0 151.62 37.9 796.0 INR 0 0.0 0.0 2025-11-11 17:13:54
1288 1301 25 175 12555 32 Neem Soap 100gm NULL 34011110 4 10.0 60.0 0.0 0.0 48.0 45.71 2.29 240.0 40.0 192.0 2.5 4.57 2.5 4.57 0.0 0.0 45.71 9.14 192.0 INR 0 0.0 0.0 2025-11-11 17:13:54
1289 1302 26 175 12555 9 Omega 369 NULL 2936900 4 260.0 999.0 0.0 0.0 799.2 761.14 38.06 3996.0 1040.0 3196.8 2.5 76.11 2.5 76.11 0.0 0.0 761.14 152.23 3196.8 INR 0 0.0 0.0 2025-11-11 17:13:54
1290 1303 27 175 12555 28 Ortho Joint Shield NULL 2009899 3 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 4497.0 1350.0 3597.6 2.5 85.66 2.5 85.66 0.0 0.0 1142.1 171.31 3597.6 INR 0 0.0 0.0 2025-11-11 17:13:54
1291 1304 28 175 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 17:13:54
1292 1305 29 175 12555 41 Premium Coco Body Lotion NULL 3304300 4 250.0 699.0 0.0 0.0 559.2 473.9 85.3 2796.0 1000.0 2236.8 9.0 170.6 9.0 170.6 0.0 0.0 473.9 341.21 2236.8 INR 0 0.0 0.0 2025-11-11 17:13:54
1293 1306 30 175 12555 13 Premium NONI VEG caps NULL 2936900 4 150.0 501.0 0.0 0.0 400.8 381.71 19.09 2004.0 600.0 1603.2 2.5 38.17 2.5 38.17 0.0 0.0 381.71 76.34 1603.2 INR 0 0.0 0.0 2025-11-11 17:13:54
1294 1307 31 175 12555 43 Quench Kiss Lip Balm NULL 3304300 4 35.0 199.0 0.0 0.0 159.2 134.92 24.29 796.0 140.0 636.8 9.0 48.57 9.0 48.57 0.0 0.0 134.92 97.14 636.8 INR 0 0.0 0.0 2025-11-11 17:13:54
1295 1308 32 175 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 17:13:54
1296 1309 33 175 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 17:13:54
1297 1310 34 175 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 17:13:54
1298 1311 35 175 12555 1 Stem Cell Powder NULL 2936900 5 749.0 2499.0 0.0 0.0 1999.2 1904.0 95.2 12495.0 3745.0 9996.0 2.5 238.0 2.5 238.0 0.0 0.0 1904.0 476.0 9996.0 INR 0 0.0 0.0 2025-11-11 17:13:54
1299 1312 36 175 12555 50 Sun Screen NULL 330499 4 250.0 699.0 0.0 0.0 559.2 473.9 85.3 2796.0 1000.0 2236.8 9.0 170.6 9.0 170.6 0.0 0.0 473.9 341.21 2236.8 INR 0 0.0 0.0 2025-11-11 17:13:54
1300 1313 37 175 12555 5 Thyro Care NULL 2936900 4 250.0 899.0 0.0 0.0 719.2 684.95 34.25 3596.0 1000.0 2876.8 2.5 68.5 2.5 68.5 0.0 0.0 684.95 136.99 2876.8 INR 0 0.0 0.0 2025-11-11 17:13:54