fx_franchise_order_product

4,933 rows · 33 columns · page 27 / 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
1301 1314 38 175 12555 36 Toilet Cleaner 500ml NULL 3924101 6 30.0 150.0 0.0 0.0 120.0 101.69 18.3 900.0 180.0 720.0 9.0 54.91 9.0 54.91 0.0 0.0 101.69 109.83 720.0 INR 0 0.0 0.0 2025-11-11 17:13:54
1302 1315 39 175 12555 44 Vital Glow Face Scrub NULL 3304300 6 71.0 325.0 0.0 0.0 260.0 220.34 39.66 1950.0 426.0 1560.0 9.0 118.98 9.0 118.98 0.0 0.0 220.34 237.97 1560.0 INR 0 0.0 0.0 2025-11-11 17:13:54
1303 1316 1 176 12533 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 2.5 749.93 2.5 749.93 0.0 0.0 9999.05 1499.86 31497.0 INR 0 0.0 0.0 2025-11-11 17:29:50
1304 1317 1 177 12554 48 glow face wash NULL 3304999 200 250.0 380.0 0.0 0.0 304.0 257.63 46.37 76000.0 50000.0 60800.0 9.0 4637.29 9.0 4637.29 0.0 0.0 257.63 9274.58 60800.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1305 1318 2 177 12554 27 Multicharge Cap NULL 2009899 100 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 149900.0 45000.0 119920.0 2.5 2855.24 2.5 2855.24 0.0 0.0 1142.1 5710.48 119920.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1306 1319 3 177 12554 20 Premium Berry Juice 1000ml NULL 2936900 50 750.0 3499.0 0.0 0.0 3479.0 3313.33 165.67 174950.0 37500.0 173950.0 2.5 4141.66 2.5 4141.66 0.0 0.0 3313.33 8283.33 173950.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1307 1320 4 177 12554 70 Premium Hand belt NULL 9404 60 600.0 9999.0 0.0 0.0 1440.0 1371.43 68.57 599940.0 36000.0 86400.0 2.5 2057.14 2.5 2057.14 0.0 0.0 1371.43 4114.29 86400.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1308 1321 5 177 12554 61 Radiation chip NULL 902221 20 325.0 999.0 0.0 0.0 799.2 677.29 121.91 19980.0 6500.0 15984.0 9.0 1219.12 9.0 1219.12 0.0 0.0 677.29 2438.24 15984.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1309 1322 6 177 12554 31 Vegan Plant Protein Powder NULL 21061000 50 1000.0 2999.0 0.0 0.0 2399.2 2284.95 114.25 149950.0 50000.0 119960.0 2.5 2856.19 2.5 2856.19 0.0 0.0 2284.95 5712.38 119960.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1310 1323 7 177 12554 49 Anti Dandruff Serum NULL 3304999 50 250.0 999.0 0.0 0.0 799.2 677.29 121.91 49950.0 12500.0 39960.0 9.0 3047.8 9.0 3047.8 0.0 0.0 677.29 6095.59 39960.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1311 1324 8 177 12554 6 Asthma Care NULL 30049011 20 250.0 899.0 0.0 0.0 719.2 684.95 34.25 17980.0 5000.0 14384.0 2.5 342.48 2.5 342.48 0.0 0.0 684.95 684.95 14384.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1312 1325 9 177 12554 52 Bhoo sanjeevni 5 kg NULL 3103100 20 450.0 1600.0 0.0 0.0 1280.0 1219.05 60.95 32000.0 9000.0 25600.0 2.5 609.52 2.5 609.52 0.0 0.0 1219.05 1219.05 25600.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1313 1326 10 177 12554 3 BP Care Capsules NULL 2936900 50 160.0 599.0 0.0 0.0 479.2 456.38 22.82 29950.0 8000.0 23960.0 2.5 570.48 2.5 570.48 0.0 0.0 456.38 1140.95 23960.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1314 1327 11 177 12554 4 Diabetic Care Capsules NULL 2936900 40 250.0 899.0 0.0 0.0 719.2 684.95 34.25 35960.0 10000.0 28768.0 2.5 684.95 2.5 684.95 0.0 0.0 684.95 1369.9 28768.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1315 1328 12 177 12554 38 Dish Wash 500ml NULL 3924101 100 85.0 230.0 0.0 0.0 184.0 155.93 28.07 23000.0 8500.0 18400.0 9.0 1403.39 9.0 1403.39 0.0 0.0 155.93 2806.78 18400.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1316 1329 13 177 12554 39 Fabric Wash 1000ml NULL 3924101 50 150.0 401.0 0.0 0.0 320.8 271.86 48.94 20050.0 7500.0 16040.0 9.0 1223.39 9.0 1223.39 0.0 0.0 271.86 2446.78 16040.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1317 1330 14 177 12554 19 Fat loss Juice 500 ml NULL 30049011 50 250.0 1499.0 0.0 0.0 1479.0 1408.57 70.43 74950.0 12500.0 73950.0 2.5 1760.71 2.5 1760.71 0.0 0.0 1408.57 3521.43 73950.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1318 1331 15 177 12554 37 Floor Cleaner 500ml NULL 3924101 100 80.0 199.0 0.0 0.0 159.2 134.92 24.28 19900.0 8000.0 15920.0 9.0 1214.23 9.0 1214.23 0.0 0.0 134.92 2428.47 15920.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1319 1332 16 177 12554 60 Foot patch NULL 30051090 30 500.0 1999.0 0.0 0.0 1599.2 1523.05 76.15 59970.0 15000.0 47976.0 2.5 1142.29 2.5 1142.29 0.0 0.0 1523.05 2284.57 47976.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1320 1333 17 177 12554 58 Green shield 250ml NULL 3105 20 800.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 50000.0 16000.0 40000.0 2.5 952.38 2.5 952.38 0.0 0.0 1904.76 1904.76 40000.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1321 1334 18 177 12554 55 Grow master 500ml NULL 3105 20 850.0 2030.0 0.0 0.0 1624.0 1546.67 77.33 40600.0 17000.0 32480.0 2.5 773.34 2.5 773.34 0.0 0.0 1546.67 1546.67 32480.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1322 1335 19 177 12554 2 Heart Care Capsules NULL 2936900 50 425.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 74950.0 21250.0 59960.0 2.5 1427.62 2.5 1427.62 0.0 0.0 1142.1 2855.24 59960.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1323 1336 20 177 12554 33 Herbal Soap 100gm NULL 30049011 2000 28.0 100.0 0.0 0.0 80.0 76.19 3.81 200000.0 56000.0 160000.0 2.5 3809.53 2.5 3809.53 0.0 0.0 76.19 7619.05 160000.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1324 1337 21 177 12554 34 Herbo2o Toothpaste NULL 33061090 1001 45.0 199.0 0.0 0.0 159.2 134.92 24.28 199199.0 45045.0 159359.2 9.0 12154.51 9.0 12154.51 0.0 0.0 134.92 24309.03 159359.2 INR 0 0.0 0.0 2025-11-11 18:31:23
1325 1338 22 177 12554 24 Immunomax 24/7 Caps NULL 2009899 30 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 44970.0 13500.0 35976.0 2.5 856.57 2.5 856.57 0.0 0.0 1142.1 1713.14 35976.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1326 1339 23 177 12554 30 Iron Capsules NULL 30049011 30 250.0 899.0 0.0 0.0 719.2 684.95 34.25 26970.0 7500.0 21576.0 2.5 513.72 2.5 513.72 0.0 0.0 684.95 1027.43 21576.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1327 1340 24 177 12554 15 Kidney Stone Juice NULL 2009899 50 120.0 349.0 0.0 0.0 279.2 265.9 13.3 17450.0 6000.0 13960.0 2.5 332.38 2.5 332.38 0.0 0.0 265.9 664.76 13960.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1328 1341 25 177 12554 18 Lady Care Juice 500ml NULL 2009899 50 250.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 74950.0 12500.0 59960.0 2.5 1427.62 2.5 1427.62 0.0 0.0 1142.1 2855.24 59960.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1329 1342 26 177 12554 16 Liver Care Juice NULL 2009899 50 120.0 349.0 0.0 0.0 279.2 265.9 13.3 17450.0 6000.0 13960.0 2.5 332.38 2.5 332.38 0.0 0.0 265.9 664.76 13960.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1330 1343 27 177 12554 25 Manicalcium Tablets NULL 2009899 50 95.0 399.0 0.0 0.0 319.2 304.0 15.2 19950.0 4750.0 15960.0 2.5 380.0 2.5 380.0 0.0 0.0 304.0 760.0 15960.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1331 1344 28 177 12554 12 Melatonin Drop NULL 2106909 50 190.0 749.0 0.0 0.0 599.2 570.67 28.53 37450.0 9500.0 29960.0 2.5 713.34 2.5 713.34 0.0 0.0 570.67 1426.67 29960.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1332 1345 29 177 12554 17 Memory Booster Juice NULL 2009899 100 120.0 349.0 0.0 0.0 279.2 265.9 13.3 34900.0 12000.0 27920.0 2.5 664.76 2.5 664.76 0.0 0.0 265.9 1329.52 27920.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1333 1346 30 177 12554 56 Micro magic 500ml NULL 3105 30 850.0 2030.0 0.0 0.0 1624.0 1376.27 247.73 60900.0 25500.0 48720.0 9.0 3715.93 9.0 3715.93 0.0 0.0 1376.27 7431.86 48720.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1334 1347 31 177 12554 7 Morning Fresh Churan NULL 30049011 100 40.0 199.0 0.0 0.0 159.2 151.62 7.58 19900.0 4000.0 15920.0 2.5 379.05 2.5 379.05 0.0 0.0 151.62 758.1 15920.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1335 1348 32 177 12554 32 Neem Soap 100gm NULL 34011110 2000 10.0 60.0 0.0 0.0 48.0 45.71 2.29 120000.0 20000.0 96000.0 2.5 2285.72 2.5 2285.72 0.0 0.0 45.71 4571.43 96000.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1336 1349 33 177 12554 9 Omega 369 NULL 2936900 34 260.0 999.0 0.0 0.0 799.2 761.14 38.06 33966.0 8840.0 27172.8 2.5 646.97 2.5 646.97 0.0 0.0 761.14 1293.94 27172.8 INR 0 0.0 0.0 2025-11-11 18:31:23
1337 1350 34 177 12554 28 Ortho Joint Shield NULL 2009899 30 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 44970.0 13500.0 35976.0 2.5 856.57 2.5 856.57 0.0 0.0 1142.1 1713.14 35976.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1338 1351 35 177 12554 72 Pain Relief Patch NULL 30051090 150 200.0 800.0 0.0 0.0 640.0 609.52 30.48 120000.0 30000.0 96000.0 2.5 2285.72 2.5 2285.72 0.0 0.0 609.52 4571.43 96000.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1339 1352 36 177 12554 8 Piles Care NULL 30049011 50 250.0 899.0 0.0 0.0 719.2 684.95 34.25 44950.0 12500.0 35960.0 2.5 856.19 2.5 856.19 0.0 0.0 684.95 1712.38 35960.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1340 1353 37 177 12554 41 Premium Coco Body Lotion NULL 3304300 200 250.0 699.0 0.0 0.0 559.2 473.9 85.3 139800.0 50000.0 111840.0 9.0 8530.17 9.0 8530.17 0.0 0.0 473.9 17060.34 111840.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1341 1354 38 177 12554 14 Premium Aloe Vera VEG caps NULL 2936900 50 100.0 359.0 0.0 0.0 287.2 273.52 13.68 17950.0 5000.0 14360.0 2.5 341.9 2.5 341.9 0.0 0.0 273.52 683.81 14360.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1342 1355 39 177 12554 47 Premium Hair Care Shampoo NULL 3305109 30 150.0 699.0 0.0 0.0 559.2 532.57 26.63 20970.0 4500.0 16776.0 2.5 399.43 2.5 399.43 0.0 0.0 532.57 798.86 16776.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1343 1356 40 177 12554 13 Premium NONI VEG caps NULL 2936900 30 150.0 501.0 0.0 0.0 400.8 381.71 19.09 15030.0 4500.0 12024.0 2.5 286.29 2.5 286.29 0.0 0.0 381.71 572.57 12024.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1344 1357 41 177 12554 43 Quench Kiss Lip Balm NULL 3304300 6 35.0 199.0 0.0 0.0 159.2 134.92 24.29 1194.0 210.0 955.2 9.0 72.86 9.0 72.86 0.0 0.0 134.92 145.71 955.2 INR 0 0.0 0.0 2025-11-11 18:31:23
1345 1358 42 177 12554 57 Safe guard 250ml NULL 3105 30 800.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 75000.0 24000.0 60000.0 2.5 1428.57 2.5 1428.57 0.0 0.0 1904.76 2857.14 60000.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1346 1359 43 177 12554 35 Sanitary Pad (15 pcs) NULL 9619001 10 40.0 380.0 0.0 0.0 304.0 304.0 0.0 3800.0 400.0 3040.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 3040.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1347 1360 44 177 12554 29 Shilajith NULL 30049011 30 250.0 1800.0 0.0 0.0 1440.0 1371.43 68.57 54000.0 7500.0 43200.0 2.5 1028.57 2.5 1028.57 0.0 0.0 1371.43 2057.14 43200.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1348 1361 45 177 12554 26 Spirulina Cap NULL 2009899 50 190.0 899.0 0.0 0.0 719.2 684.95 34.25 44950.0 9500.0 35960.0 2.5 856.19 2.5 856.19 0.0 0.0 684.95 1712.38 35960.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1349 1362 46 177 12554 1 Stem Cell Powder NULL 2936900 500 749.0 2499.0 0.0 0.0 1999.2 1904.0 95.2 1249500.0 374500.0 999600.0 2.5 23800.0 2.5 23800.0 0.0 0.0 1904.0 47600.0 999600.0 INR 0 0.0 0.0 2025-11-11 18:31:23
1350 1363 47 177 12554 50 Sun Screen NULL 330499 200 250.0 699.0 0.0 0.0 559.2 473.9 85.3 139800.0 50000.0 111840.0 9.0 8530.17 9.0 8530.17 0.0 0.0 473.9 17060.34 111840.0 INR 0 0.0 0.0 2025-11-11 18:31:23