fx_franchise_order_product

4,933 rows · 33 columns · page 29 / 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
1401 1414 45 179 12516 1 Stem Cell Powder NULL 2936900 100 749.0 2499.0 0.0 0.0 1999.2 1904.0 95.2 249900.0 74900.0 199920.0 2.5 4760.0 2.5 4760.0 0.0 0.0 1904.0 9520.0 199920.0 INR 0 0.0 0.0 2025-11-11 20:02:12
1402 1415 46 179 12516 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 20:02:12
1403 1416 47 179 12516 59 T Shirt NULL 61099010 20 0.0 1400.0 0.0 0.0 1120.0 1066.67 53.33 28000.0 0.0 22400.0 2.5 533.34 2.5 533.34 0.0 0.0 1066.67 1066.67 22400.0 INR 0 0.0 0.0 2025-11-11 20:02:12
1404 1417 48 179 12516 53 Terra care 2 kg NULL 3103100 50 450.0 1500.0 0.0 0.0 1200.0 1142.86 57.14 75000.0 22500.0 60000.0 2.5 1428.57 2.5 1428.57 0.0 0.0 1142.86 2857.14 60000.0 INR 0 0.0 0.0 2025-11-11 20:02:12
1405 1418 49 179 12516 5 Thyro Care NULL 2936900 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 20:02:12
1406 1419 50 179 12516 36 Toilet Cleaner 500ml NULL 3924101 100 30.0 150.0 0.0 0.0 120.0 101.69 18.31 15000.0 3000.0 12000.0 9.0 915.25 9.0 915.25 0.0 0.0 101.69 1830.51 12000.0 INR 0 0.0 0.0 2025-11-11 20:02:12
1407 1420 51 179 12516 44 Vital Glow Face Scrub NULL 3304300 50 71.0 325.0 0.0 0.0 260.0 220.34 39.66 16250.0 3550.0 13000.0 9.0 991.52 9.0 991.52 0.0 0.0 220.34 1983.05 13000.0 INR 0 0.0 0.0 2025-11-11 20:02:12
1408 1421 52 179 12516 54 Wonder grow 100ml NULL 3105 50 500.0 1400.0 0.0 0.0 1120.0 1066.67 53.33 70000.0 25000.0 56000.0 2.5 1333.34 2.5 1333.34 0.0 0.0 1066.67 2666.67 56000.0 INR 0 0.0 0.0 2025-11-11 20:02:12
1409 1422 1 180 12516 48 glow face wash NULL 3304999 50 250.0 380.0 0.0 0.0 304.0 257.63 46.37 19000.0 12500.0 15200.0 9.0 1159.32 9.0 1159.32 0.0 0.0 257.63 2318.64 15200.0 INR 0 0.0 0.0 2025-11-11 20:02:13
1410 1423 2 180 12516 27 Multicharge Cap 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 20:02:13
1411 1424 3 180 12516 20 Premium Berry Juice 1000ml NULL 2936900 30 750.0 3499.0 0.0 0.0 3479.0 3313.33 165.67 104970.0 22500.0 104370.0 2.5 2485.0 2.5 2485.0 0.0 0.0 3313.33 4970.0 104370.0 INR 0 0.0 0.0 2025-11-11 20:02:13
1412 1425 4 180 12516 70 Premium Hand belt NULL 9404 20 600.0 9999.0 0.0 0.0 1440.0 1371.43 68.57 199980.0 12000.0 28800.0 2.5 685.72 2.5 685.72 0.0 0.0 1371.43 1371.43 28800.0 INR 0 0.0 0.0 2025-11-11 20:02:13
1413 1426 5 180 12516 61 Radiation chip NULL 902221 50 325.0 999.0 0.0 0.0 799.2 677.29 121.91 49950.0 16250.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 20:02:13
1414 1427 6 180 12516 31 Vegan Plant Protein Powder NULL 21061000 30 1000.0 2999.0 0.0 0.0 2399.2 2284.95 114.25 89970.0 30000.0 71976.0 2.5 1713.71 2.5 1713.71 0.0 0.0 2284.95 3427.43 71976.0 INR 0 0.0 0.0 2025-11-11 20:02:13
1415 1428 7 180 12516 49 Anti Dandruff Serum NULL 3304999 30 250.0 999.0 0.0 0.0 799.2 677.29 121.91 29970.0 7500.0 23976.0 9.0 1828.68 9.0 1828.68 0.0 0.0 677.29 3657.36 23976.0 INR 0 0.0 0.0 2025-11-11 20:02:13
1416 1429 8 180 12516 6 Asthma Care 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 20:02:13
1417 1430 9 180 12516 52 Bhoo sanjeevni 5 kg NULL 3103100 50 450.0 1600.0 0.0 0.0 1280.0 1219.05 60.95 80000.0 22500.0 64000.0 2.5 1523.81 2.5 1523.81 0.0 0.0 1219.05 3047.62 64000.0 INR 0 0.0 0.0 2025-11-11 20:02:13
1418 1431 10 180 12516 3 BP Care Capsules NULL 2936900 40 160.0 599.0 0.0 0.0 479.2 456.38 22.82 23960.0 6400.0 19168.0 2.5 456.38 2.5 456.38 0.0 0.0 456.38 912.76 19168.0 INR 0 0.0 0.0 2025-11-11 20:02:13
1419 1432 11 180 12516 4 Diabetic Care Capsules NULL 2936900 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 20:02:13
1420 1433 12 180 12516 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 20:02:13
1421 1434 13 180 12516 39 Fabric Wash 1000ml NULL 3924101 100 150.0 401.0 0.0 0.0 320.8 271.86 48.94 40100.0 15000.0 32080.0 9.0 2446.78 9.0 2446.78 0.0 0.0 271.86 4893.56 32080.0 INR 0 0.0 0.0 2025-11-11 20:02:13
1422 1435 14 180 12516 19 Fat loss Juice 500 ml NULL 30049011 70 250.0 1499.0 0.0 0.0 1479.0 1408.57 70.43 104930.0 17500.0 103530.0 2.5 2465.0 2.5 2465.0 0.0 0.0 1408.57 4930.0 103530.0 INR 0 0.0 0.0 2025-11-11 20:02:13
1423 1436 15 180 12516 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 20:02:13
1424 1437 16 180 12516 60 Foot patch NULL 30051090 50 500.0 1999.0 0.0 0.0 1599.2 1523.05 76.15 99950.0 25000.0 79960.0 2.5 1903.81 2.5 1903.81 0.0 0.0 1523.05 3807.62 79960.0 INR 0 0.0 0.0 2025-11-11 20:02:13
1425 1438 17 180 12516 58 Green shield 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 20:02:13
1426 1439 18 180 12516 55 Grow master 500ml NULL 3105 30 850.0 2030.0 0.0 0.0 1624.0 1546.67 77.33 60900.0 25500.0 48720.0 2.5 1160.0 2.5 1160.0 0.0 0.0 1546.67 2320.0 48720.0 INR 0 0.0 0.0 2025-11-11 20:02:13
1427 1440 19 180 12516 2 Heart Care Capsules NULL 2936900 30 425.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 44970.0 12750.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 20:02:13
1428 1441 20 180 12516 33 Herbal Soap 100gm NULL 30049011 1500 28.0 100.0 0.0 0.0 80.0 76.19 3.81 150000.0 42000.0 120000.0 2.5 2857.14 2.5 2857.14 0.0 0.0 76.19 5714.29 120000.0 INR 0 0.0 0.0 2025-11-11 20:02:13
1429 1442 21 180 12516 34 Herbo2o Toothpaste NULL 33061090 1000 45.0 199.0 0.0 0.0 159.2 134.92 24.28 199000.0 45000.0 159200.0 9.0 12142.38 9.0 12142.38 0.0 0.0 134.92 24284.75 159200.0 INR 0 0.0 0.0 2025-11-11 20:02:13
1430 1443 22 180 12516 24 Immunomax 24/7 Caps NULL 2009899 50 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 74950.0 22500.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 20:02:13
1431 1444 23 180 12516 30 Iron Capsules 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 20:02:13
1432 1445 24 180 12516 15 Kidney Stone 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 20:02:13
1433 1446 25 180 12516 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 20:02:13
1434 1447 26 180 12516 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 20:02:13
1435 1448 27 180 12516 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 20:02:13
1436 1449 28 180 12516 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 20:02:13
1437 1450 29 180 12516 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 20:02:13
1438 1451 30 180 12516 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 20:02:13
1439 1452 31 180 12516 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 20:02:13
1440 1453 32 180 12516 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 20:02:13
1441 1454 33 180 12516 9 Omega 369 NULL 2936900 50 260.0 999.0 0.0 0.0 799.2 761.14 38.06 49950.0 13000.0 39960.0 2.5 951.43 2.5 951.43 0.0 0.0 761.14 1902.86 39960.0 INR 0 0.0 0.0 2025-11-11 20:02:13
1442 1455 34 180 12516 28 Ortho Joint Shield NULL 2009899 50 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 74950.0 22500.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 20:02:13
1443 1456 35 180 12516 72 Pain Relief Patch NULL 30051090 100 200.0 800.0 0.0 0.0 640.0 609.52 30.48 80000.0 20000.0 64000.0 2.5 1523.81 2.5 1523.81 0.0 0.0 609.52 3047.62 64000.0 INR 0 0.0 0.0 2025-11-11 20:02:13
1444 1457 36 180 12516 8 Piles Care NULL 30049011 1 250.0 899.0 0.0 0.0 719.2 684.95 34.25 899.0 250.0 719.2 2.5 17.12 2.5 17.12 0.0 0.0 684.95 34.25 719.2 INR 0 0.0 0.0 2025-11-11 20:02:13
1445 1458 37 180 12516 41 Premium Coco Body Lotion NULL 3304300 150 250.0 699.0 0.0 0.0 559.2 473.9 85.3 104850.0 37500.0 83880.0 9.0 6397.62 9.0 6397.62 0.0 0.0 473.9 12795.25 83880.0 INR 0 0.0 0.0 2025-11-11 20:02:13
1446 1459 38 180 12516 14 Premium Aloe Vera VEG caps NULL 2936900 100 100.0 359.0 0.0 0.0 287.2 273.52 13.68 35900.0 10000.0 28720.0 2.5 683.81 2.5 683.81 0.0 0.0 273.52 1367.62 28720.0 INR 0 0.0 0.0 2025-11-11 20:02:13
1447 1460 39 180 12516 47 Premium Hair Care Shampoo NULL 3305109 1 150.0 699.0 0.0 0.0 559.2 532.57 26.63 699.0 150.0 559.2 2.5 13.31 2.5 13.31 0.0 0.0 532.57 26.63 559.2 INR 0 0.0 0.0 2025-11-11 20:02:13
1448 1461 40 180 12516 13 Premium NONI VEG caps NULL 2936900 1 150.0 501.0 0.0 0.0 400.8 381.71 19.09 501.0 150.0 400.8 2.5 9.54 2.5 9.54 0.0 0.0 381.71 19.09 400.8 INR 0 0.0 0.0 2025-11-11 20:02:13
1449 1462 41 180 12516 43 Quench Kiss Lip Balm NULL 3304300 1 35.0 199.0 0.0 0.0 159.2 134.92 24.28 199.0 35.0 159.2 9.0 12.14 9.0 12.14 0.0 0.0 134.92 24.28 159.2 INR 0 0.0 0.0 2025-11-11 20:02:13
1450 1463 42 180 12516 35 Sanitary Pad (15 pcs) NULL 9619001 8 40.0 380.0 0.0 0.0 304.0 304.0 0.0 3040.0 320.0 2432.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 2432.0 INR 0 0.0 0.0 2025-11-11 20:02:13