fx_franchise_order_product

4,933 rows · 33 columns · page 34 / 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
1651 1664 52 192 12554 54 Wonder grow 100ml NULL 3105 20 500.0 1400.0 0.0 0.0 1120.0 1066.67 53.33 28000.0 10000.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 23:58:07
1652 1665 1 193 12552 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 9.0 1044.84 9.0 1044.84 0.0 0.0 11609.32 2089.68 13699.0 INR 0 0.0 0.0 2025-11-12 00:14:12
1653 1666 2 193 12552 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-12 00:14:12
1654 1667 3 193 12552 74 EXPLORER BOX NULL NULL 1 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 26997.0 0.0 10499.0 2.5 249.97 2.5 249.97 0.0 0.0 9999.05 499.95 10499.0 INR 0 0.0 0.0 2025-11-12 00:14:12
1655 1668 1 194 12554 80 BOOSTER KIT NULL NULL 50 0.0 21998.2 0.0 0.0 13699.0 11609.32 2089.68 1099910.0 0.0 684950.0 9.0 52241.95 9.0 52241.95 0.0 0.0 11609.32 104483.9 684950.0 INR 0 0.0 0.0 2025-11-12 06:38:52
1656 1669 2 194 12554 76 ELITE BOX NULL NULL 10 0.0 46494.0 0.0 0.0 18000.0 17142.86 857.14 464940.0 0.0 180000.0 2.5 4285.72 2.5 4285.72 0.0 0.0 17142.86 8571.43 180000.0 INR 0 0.0 0.0 2025-11-12 06:38:52
1657 1670 3 194 12554 77 ELITE COMFORT NULL NULL 50 0.0 53994.0 0.0 0.0 18500.0 17619.05 880.95 2699700.0 0.0 925000.0 2.5 22023.81 2.5 22023.81 0.0 0.0 17619.05 44047.62 925000.0 INR 0 0.0 0.0 2025-11-12 06:38:52
1658 1671 4 194 12554 73 ENTRY BOX NULL NULL 50 0.0 3998.4 0.0 0.0 3998.4 3808.0 190.4 199920.0 0.0 199920.0 2.5 4760.0 2.5 4760.0 0.0 0.0 3808.0 9520.0 199920.0 INR 0 0.0 0.0 2025-11-12 06:38:52
1659 1672 5 194 12554 74 EXPLORER BOX NULL NULL 50 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 1349850.0 0.0 524950.0 2.5 12498.81 2.5 12498.81 0.0 0.0 9999.05 24997.62 524950.0 INR 0 0.0 0.0 2025-11-12 06:38:52
1660 1673 6 194 12554 75 WELLNESS EXPLORER NULL NULL 50 0.0 22294.6 0.0 0.0 10600.0 10095.24 504.76 1114730.0 0.0 530000.0 2.5 12619.05 2.5 12619.05 0.0 0.0 10095.24 25238.1 530000.0 INR 0 0.0 0.0 2025-11-12 06:38:52
1661 1674 1 195 12555 80 BOOSTER KIT NULL NULL 50 0.0 21998.2 0.0 0.0 13699.0 11609.32 2089.68 1099910.0 0.0 684950.0 9.0 52241.95 9.0 52241.95 0.0 0.0 11609.32 104483.9 684950.0 INR 0 0.0 0.0 2025-11-12 06:59:00
1662 1675 2 195 12555 76 ELITE BOX NULL NULL 10 0.0 46494.0 0.0 0.0 18000.0 17142.86 857.14 464940.0 0.0 180000.0 2.5 4285.72 2.5 4285.72 0.0 0.0 17142.86 8571.43 180000.0 INR 0 0.0 0.0 2025-11-12 06:59:00
1663 1676 3 195 12555 77 ELITE COMFORT NULL NULL 50 0.0 53994.0 0.0 0.0 18500.0 17619.05 880.95 2699700.0 0.0 925000.0 2.5 22023.81 2.5 22023.81 0.0 0.0 17619.05 44047.62 925000.0 INR 0 0.0 0.0 2025-11-12 06:59:00
1664 1677 4 195 12555 73 ENTRY BOX NULL NULL 50 0.0 3998.4 0.0 0.0 3998.4 3808.0 190.4 199920.0 0.0 199920.0 2.5 4760.0 2.5 4760.0 0.0 0.0 3808.0 9520.0 199920.0 INR 0 0.0 0.0 2025-11-12 06:59:00
1665 1678 5 195 12555 74 EXPLORER BOX NULL NULL 50 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 1349850.0 0.0 524950.0 2.5 12498.81 2.5 12498.81 0.0 0.0 9999.05 24997.62 524950.0 INR 0 0.0 0.0 2025-11-12 06:59:00
1666 1679 6 195 12555 75 WELLNESS EXPLORER NULL NULL 30 0.0 22294.6 0.0 0.0 10600.0 10095.24 504.76 668838.0 0.0 318000.0 2.5 7571.43 2.5 7571.43 0.0 0.0 10095.24 15142.86 318000.0 INR 0 0.0 0.0 2025-11-12 06:59:00
1667 1680 1 196 12516 58 Green shield 250ml NULL 3105 15 800.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 37500.0 12000.0 30000.0 2.5 714.28 2.5 714.28 0.0 0.0 1904.76 1428.57 30000.0 INR 0 0.0 0.0 2025-11-12 08:29:53
1668 1681 1 197 12516 58 Green shield 250ml NULL 3105 10 800.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 25000.0 8000.0 20000.0 2.5 476.19 2.5 476.19 0.0 0.0 1904.76 952.38 20000.0 INR 0 0.0 0.0 2025-11-12 08:45:26
1669 1682 1 198 12554 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-12 09:05:44
1670 1683 2 198 12554 27 Multicharge Cap NULL 2009899 1 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 1499.0 450.0 1199.2 2.5 28.55 2.5 28.55 0.0 0.0 1142.1 57.1 1199.2 INR 0 0.0 0.0 2025-11-12 09:05:44
1671 1684 3 198 12554 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-12 09:05:44
1672 1685 4 198 12554 70 Premium Hand belt NULL 9404 10 600.0 9999.0 0.0 0.0 1440.0 1371.43 68.57 99990.0 6000.0 14400.0 2.5 342.86 2.5 342.86 0.0 0.0 1371.43 685.71 14400.0 INR 0 0.0 0.0 2025-11-12 09:05:44
1673 1686 5 198 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-12 09:05:44
1674 1687 6 198 12554 31 Vegan Plant Protein Powder NULL 21061000 20 1000.0 2999.0 0.0 0.0 2399.2 2284.95 114.25 59980.0 20000.0 47984.0 2.5 1142.47 2.5 1142.47 0.0 0.0 2284.95 2284.95 47984.0 INR 0 0.0 0.0 2025-11-12 09:05:44
1675 1688 7 198 12554 49 Anti Dandruff Serum NULL 3304999 20 250.0 999.0 0.0 0.0 799.2 677.29 121.91 19980.0 5000.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-12 09:05:44
1676 1689 8 198 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-12 09:05:44
1677 1690 9 198 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-12 09:05:44
1678 1691 10 198 12554 3 BP Care Capsules NULL 2936900 20 160.0 599.0 0.0 0.0 479.2 456.38 22.82 11980.0 3200.0 9584.0 2.5 228.19 2.5 228.19 0.0 0.0 456.38 456.38 9584.0 INR 0 0.0 0.0 2025-11-12 09:05:44
1679 1692 11 198 12554 4 Diabetic Care Capsules NULL 2936900 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-12 09:05:44
1680 1693 12 198 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-12 09:05:44
1681 1694 13 198 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-12 09:05:44
1682 1695 14 198 12554 19 Fat loss Juice 500 ml NULL 30049011 10 250.0 1499.0 0.0 0.0 1479.0 1408.57 70.43 14990.0 2500.0 14790.0 2.5 352.14 2.5 352.14 0.0 0.0 1408.57 704.29 14790.0 INR 0 0.0 0.0 2025-11-12 09:05:44
1683 1696 15 198 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-12 09:05:44
1684 1697 16 198 12554 60 Foot patch NULL 30051090 20 500.0 1999.0 0.0 0.0 1599.2 1523.05 76.15 39980.0 10000.0 31984.0 2.5 761.52 2.5 761.52 0.0 0.0 1523.05 1523.05 31984.0 INR 0 0.0 0.0 2025-11-12 09:05:44
1685 1698 17 198 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-12 09:05:44
1686 1699 18 198 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-12 09:05:44
1687 1700 19 198 12554 2 Heart Care Capsules NULL 2936900 20 425.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 29980.0 8500.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-12 09:05:44
1688 1701 20 198 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-12 09:05:44
1689 1702 21 198 12554 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-12 09:05:44
1690 1703 22 198 12554 24 Immunomax 24/7 Caps NULL 2009899 4 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 5996.0 1800.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-12 09:05:44
1691 1704 23 198 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-12 09:05:44
1692 1705 24 198 12554 15 Kidney Stone Juice NULL 2009899 20 120.0 349.0 0.0 0.0 279.2 265.9 13.29 6980.0 2400.0 5584.0 2.5 132.95 2.5 132.95 0.0 0.0 265.9 265.9 5584.0 INR 0 0.0 0.0 2025-11-12 09:05:44
1693 1706 25 198 12554 18 Lady Care Juice 500ml NULL 2009899 10 250.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 14990.0 2500.0 11992.0 2.5 285.52 2.5 285.52 0.0 0.0 1142.1 571.05 11992.0 INR 0 0.0 0.0 2025-11-12 09:05:44
1694 1707 26 198 12554 16 Liver Care Juice NULL 2009899 20 120.0 349.0 0.0 0.0 279.2 265.9 13.29 6980.0 2400.0 5584.0 2.5 132.95 2.5 132.95 0.0 0.0 265.9 265.9 5584.0 INR 0 0.0 0.0 2025-11-12 09:05:44
1695 1708 27 198 12554 25 Manicalcium Tablets NULL 2009899 10 95.0 399.0 0.0 0.0 319.2 304.0 15.2 3990.0 950.0 3192.0 2.5 76.0 2.5 76.0 0.0 0.0 304.0 152.0 3192.0 INR 0 0.0 0.0 2025-11-12 09:05:44
1696 1709 28 198 12554 12 Melatonin Drop NULL 2106909 10 190.0 749.0 0.0 0.0 599.2 570.67 28.53 7490.0 1900.0 5992.0 2.5 142.66 2.5 142.66 0.0 0.0 570.67 285.33 5992.0 INR 0 0.0 0.0 2025-11-12 09:05:44
1697 1710 29 198 12554 17 Memory Booster Juice NULL 2009899 20 120.0 349.0 0.0 0.0 279.2 265.9 13.29 6980.0 2400.0 5584.0 2.5 132.95 2.5 132.95 0.0 0.0 265.9 265.9 5584.0 INR 0 0.0 0.0 2025-11-12 09:05:44
1698 1711 30 198 12554 56 Micro magic 500ml NULL 3105 20 850.0 2030.0 0.0 0.0 1624.0 1376.27 247.73 40600.0 17000.0 32480.0 9.0 2477.29 9.0 2477.29 0.0 0.0 1376.27 4954.58 32480.0 INR 0 0.0 0.0 2025-11-12 09:05:44
1699 1712 31 198 12554 7 Morning Fresh Churan NULL 30049011 30 40.0 199.0 0.0 0.0 159.2 151.62 7.58 5970.0 1200.0 4776.0 2.5 113.72 2.5 113.72 0.0 0.0 151.62 227.43 4776.0 INR 0 0.0 0.0 2025-11-12 09:05:44
1700 1713 32 198 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-12 09:05:44