fx_franchise_order_product

4,933 rows · 33 columns · page 30 / 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
1451 1464 43 180 12516 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 20:02:13
1452 1465 44 180 12516 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 20:02:13
1453 1466 45 180 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:13
1454 1467 46 180 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:13
1455 1468 47 180 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:13
1456 1469 48 180 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:13
1457 1470 49 180 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:13
1458 1471 50 180 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:13
1459 1472 51 180 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:13
1460 1473 52 180 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:13
1461 1474 1 181 12517 80 BOOSTER KIT NULL NULL 1 0.0 21998.2 0.0 0.0 13699.0 11609.32 2089.68 21998.2 0.0 13699.0 0.0 0.0 0.0 0.0 18.0 2089.68 11609.32 2089.68 13699.0 INR 0 0.0 0.0 2025-11-11 20:02:56
1462 1475 2 181 12517 77 ELITE COMFORT NULL NULL 2 0.0 53994.0 0.0 0.0 18500.0 17619.05 880.95 107988.0 0.0 37000.0 0.0 0.0 0.0 0.0 5.0 1761.9 17619.05 1761.9 37000.0 INR 0 0.0 0.0 2025-11-11 20:02:56
1463 1476 3 181 12517 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 0.0 0.0 0.0 0.0 5.0 999.9 9999.05 999.9 20998.0 INR 0 0.0 0.0 2025-11-11 20:02:56
1464 1477 1 182 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 21:16:03
1465 1478 2 182 12516 27 Multicharge Cap 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 21:16:03
1466 1479 3 182 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 21:16:03
1467 1480 4 182 12516 70 Premium Hand belt NULL 9404 30 600.0 9999.0 0.0 0.0 1440.0 1371.43 68.57 299970.0 18000.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 21:16:03
1468 1481 1 183 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 21:22:38
1469 1482 2 183 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 21:22:38
1470 1483 3 183 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 21:22:38
1471 1484 4 183 12516 33 Herbal Soap 100gm NULL 30049011 1000 28.0 100.0 0.0 0.0 80.0 76.19 3.81 100000.0 28000.0 80000.0 2.5 1904.76 2.5 1904.76 0.0 0.0 76.19 3809.52 80000.0 INR 0 0.0 0.0 2025-11-11 21:22:38
1472 1485 5 183 12516 34 Herbo2o Toothpaste NULL 33061090 200 45.0 199.0 0.0 0.0 159.2 134.92 24.28 39800.0 9000.0 31840.0 9.0 2428.47 9.0 2428.47 0.0 0.0 134.92 4856.95 31840.0 INR 0 0.0 0.0 2025-11-11 21:22:38
1473 1486 6 183 12516 32 Neem Soap 100gm NULL 34011110 1000 10.0 60.0 0.0 0.0 48.0 45.71 2.29 60000.0 10000.0 48000.0 2.5 1142.86 2.5 1142.86 0.0 0.0 45.71 2285.71 48000.0 INR 0 0.0 0.0 2025-11-11 21:22:38
1474 1487 7 183 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 21:22:38
1475 1488 1 184 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 21:26:19
1476 1489 2 184 12554 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 21:26:19
1477 1490 3 184 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 21:26:19
1478 1491 4 184 12554 33 Herbal Soap 100gm NULL 30049011 1000 28.0 100.0 0.0 0.0 80.0 76.19 3.81 100000.0 28000.0 80000.0 2.5 1904.76 2.5 1904.76 0.0 0.0 76.19 3809.52 80000.0 INR 0 0.0 0.0 2025-11-11 21:26:19
1479 1492 5 184 12554 34 Herbo2o Toothpaste NULL 33061090 100 45.0 199.0 0.0 0.0 159.2 134.92 24.28 19900.0 4500.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 21:26:19
1480 1493 6 184 12554 32 Neem Soap 100gm NULL 34011110 1000 10.0 60.0 0.0 0.0 48.0 45.71 2.29 60000.0 10000.0 48000.0 2.5 1142.86 2.5 1142.86 0.0 0.0 45.71 2285.71 48000.0 INR 0 0.0 0.0 2025-11-11 21:26:19
1481 1494 7 184 12554 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 21:26:19
1482 1495 1 185 12555 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 21:28:36
1483 1496 2 185 12555 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 21:28:36
1484 1497 3 185 12555 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 21:28:36
1485 1498 4 185 12555 33 Herbal Soap 100gm NULL 30049011 1000 28.0 100.0 0.0 0.0 80.0 76.19 3.81 100000.0 28000.0 80000.0 2.5 1904.76 2.5 1904.76 0.0 0.0 76.19 3809.52 80000.0 INR 0 0.0 0.0 2025-11-11 21:28:36
1486 1499 5 185 12555 34 Herbo2o Toothpaste NULL 33061090 100 45.0 199.0 0.0 0.0 159.2 134.92 24.28 19900.0 4500.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 21:28:36
1487 1500 6 185 12555 32 Neem Soap 100gm NULL 34011110 1000 10.0 60.0 0.0 0.0 48.0 45.71 2.29 60000.0 10000.0 48000.0 2.5 1142.86 2.5 1142.86 0.0 0.0 45.71 2285.71 48000.0 INR 0 0.0 0.0 2025-11-11 21:28:36
1488 1501 7 185 12555 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 21:28:36
1489 1502 1 186 12526 73 ENTRY BOX NULL NULL 1 0.0 3998.4 0.0 0.0 3998.4 3808.0 190.4 3998.4 0.0 3998.4 2.5 95.2 2.5 95.2 0.0 0.0 3808.0 190.4 3998.4 INR 0 0.0 0.0 2025-11-11 21:28:53
1490 1503 2 186 12526 74 EXPLORER BOX NULL NULL 4 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 107988.0 0.0 41996.0 2.5 999.9 2.5 999.9 0.0 0.0 9999.05 1999.81 41996.0 INR 0 0.0 0.0 2025-11-11 21:28:53
1491 1504 1 187 12555 77 ELITE COMFORT NULL NULL 1 0.0 53994.0 0.0 0.0 18500.0 17619.05 880.95 53994.0 0.0 18500.0 2.5 440.48 2.5 440.48 0.0 0.0 17619.05 880.95 18500.0 INR 0 0.0 0.0 2025-11-11 21:41:34
1492 1505 1 188 12516 80 BOOSTER KIT NULL NULL 10 0.0 21998.2 0.0 0.0 13699.0 11609.32 2089.68 219982.0 0.0 136990.0 9.0 10448.39 9.0 10448.39 0.0 0.0 11609.32 20896.78 136990.0 INR 0 0.0 0.0 2025-11-11 21:43:20
1493 1506 2 188 12516 76 ELITE BOX NULL NULL 1 0.0 46494.0 0.0 0.0 18000.0 17142.86 857.14 46494.0 0.0 18000.0 2.5 428.57 2.5 428.57 0.0 0.0 17142.86 857.14 18000.0 INR 0 0.0 0.0 2025-11-11 21:43:20
1494 1507 3 188 12516 77 ELITE COMFORT NULL NULL 10 0.0 53994.0 0.0 0.0 18500.0 17619.05 880.95 539940.0 0.0 185000.0 2.5 4404.76 2.5 4404.76 0.0 0.0 17619.05 8809.52 185000.0 INR 0 0.0 0.0 2025-11-11 21:43:20
1495 1508 4 188 12516 73 ENTRY BOX NULL NULL 10 0.0 3998.4 0.0 0.0 3998.4 3808.0 190.4 39984.0 0.0 39984.0 2.5 952.0 2.5 952.0 0.0 0.0 3808.0 1904.0 39984.0 INR 0 0.0 0.0 2025-11-11 21:43:20
1496 1509 5 188 12516 74 EXPLORER BOX NULL NULL 10 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 269970.0 0.0 104990.0 2.5 2499.76 2.5 2499.76 0.0 0.0 9999.05 4999.52 104990.0 INR 0 0.0 0.0 2025-11-11 21:43:20
1497 1510 1 189 12554 77 ELITE COMFORT NULL NULL 1 0.0 53994.0 0.0 0.0 18500.0 17619.05 880.95 53994.0 0.0 18500.0 2.5 440.48 2.5 440.48 0.0 0.0 17619.05 880.95 18500.0 INR 0 0.0 0.0 2025-11-11 21:47:33
1498 1511 1 190 12516 48 glow face wash NULL 3304999 30 250.0 380.0 0.0 0.0 304.0 257.63 46.37 11400.0 7500.0 9120.0 9.0 695.6 9.0 695.6 0.0 0.0 257.63 1391.19 9120.0 INR 0 0.0 0.0 2025-11-11 22:11:56
1499 1512 2 190 12516 27 Multicharge Cap NULL 2009899 20 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 29980.0 9000.0 23984.0 2.5 571.05 2.5 571.05 0.0 0.0 1142.1 1142.1 23984.0 INR 0 0.0 0.0 2025-11-11 22:11:56
1500 1513 3 190 12516 20 Premium Berry Juice 1000ml NULL 2936900 10 750.0 3499.0 0.0 0.0 3479.0 3313.33 165.67 34990.0 7500.0 34790.0 2.5 828.34 2.5 828.34 0.0 0.0 3313.33 1656.67 34790.0 INR 0 0.0 0.0 2025-11-11 22:11:56