fx_franchise_order_product

4,933 rows · 33 columns · page 54 / 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
2651 2664 13 637 12552 50 Sun Screen NULL 330499 1 0.0 699.0 0.0 0.0 559.0 473.73 85.27 699.0 0.0 559.0 9.0 42.64 9.0 42.64 0.0 0.0 473.73 85.27 559.0 INR 3 2.0 9.47 2026-01-08 22:47:06
2652 2665 14 637 12552 36 Toilet Cleaner 500ml NULL 3924101 3 0.0 150.0 0.0 0.0 120.0 101.69 18.31 450.0 0.0 360.0 9.0 27.46 9.0 27.46 0.0 0.0 305.08 54.92 360.0 INR 3 2.0 6.1 2026-01-08 22:47:06
2653 2666 1 638 12534 6 Asthma Care NULL 30049011 1 0.0 999.0 0.0 0.0 720.0 685.71 34.29 999.0 0.0 720.0 2.5 17.14 2.5 17.14 0.0 0.0 685.71 34.29 720.0 INR 3 2.0 13.71 2026-01-09 10:29:26
2654 2667 2 638 12534 4 Diabetic Care Capsules NULL 2936900 2 0.0 999.0 0.0 0.0 720.0 685.71 34.29 1998.0 0.0 1440.0 2.5 34.29 2.5 34.29 0.0 0.0 1371.43 68.57 1440.0 INR 3 2.0 27.43 2026-01-09 10:29:26
2655 2668 3 638 12534 38 Dish Wash 500ml NULL 3924101 2 0.0 230.0 0.0 0.0 184.0 155.93 28.07 460.0 0.0 368.0 9.0 28.07 9.0 28.07 0.0 0.0 311.86 56.14 368.0 INR 3 2.0 6.24 2026-01-09 10:29:26
2656 2669 4 638 12534 39 Fabric Wash 1000ml NULL 3924101 1 0.0 401.0 0.0 0.0 321.0 272.03 48.97 401.0 0.0 321.0 9.0 24.48 9.0 24.48 0.0 0.0 272.03 48.97 321.0 INR 3 2.0 5.44 2026-01-09 10:29:26
2657 2670 5 638 12534 37 Floor Cleaner 500ml NULL 3924101 5 0.0 199.0 0.0 0.0 159.0 134.75 24.25 995.0 0.0 795.0 9.0 60.64 9.0 60.64 0.0 0.0 673.73 121.27 795.0 INR 3 2.0 13.47 2026-01-09 10:29:26
2658 2671 6 638 12534 33 Herbal Soap 100gm NULL 30049011 70 0.0 100.0 0.0 0.0 80.0 76.19 3.81 7000.0 0.0 5600.0 2.5 133.33 2.5 133.33 0.0 0.0 5333.34 266.67 5600.0 INR 3 2.0 106.67 2026-01-09 10:29:26
2659 2672 7 638 12534 34 Herbo2o Toothpaste NULL 33061090 27 0.0 199.0 0.0 0.0 159.0 134.75 24.25 5373.0 0.0 4293.0 9.0 327.43 9.0 327.43 0.0 0.0 3638.14 654.86 4293.0 INR 3 2.0 72.76 2026-01-09 10:29:26
2660 2673 8 638 12534 7 Morning Fresh Churan NULL 30049011 2 0.0 199.0 0.0 0.0 159.0 151.43 7.57 398.0 0.0 318.0 2.5 7.57 2.5 7.57 0.0 0.0 302.86 15.14 318.0 INR 3 2.0 6.06 2026-01-09 10:29:26
2661 2674 9 638 12534 32 Neem Soap 100gm NULL 34011110 66 0.0 60.0 0.0 0.0 48.0 45.71 2.29 3960.0 0.0 3168.0 2.5 75.43 2.5 75.43 0.0 0.0 3017.14 150.86 3168.0 INR 3 2.0 60.34 2026-01-09 10:29:26
2662 2675 10 638 12534 36 Toilet Cleaner 500ml NULL 3924101 7 0.0 150.0 0.0 0.0 120.0 101.69 18.31 1050.0 0.0 840.0 9.0 64.07 9.0 64.07 0.0 0.0 711.86 128.14 840.0 INR 3 2.0 14.24 2026-01-09 10:29:26
2663 2676 1 639 12517 60 Foot patch NULL 30051090 50 0.0 1999.0 0.0 0.0 1599.0 1522.86 76.14 99950.0 0.0 79950.0 0.0 0.0 0.0 0.0 5.0 3807.14 76142.85 3807.14 79950.0 INR 2 6.0 4568.57 2026-01-09 12:50:03
2664 2677 2 639 12517 72 Pain Relief Patch NULL 30051090 50 0.0 800.0 0.0 0.0 600.0 571.43 28.57 40000.0 0.0 30000.0 0.0 0.0 0.0 0.0 5.0 1428.57 28571.43 1428.57 30000.0 INR 2 6.0 1714.29 2026-01-09 12:50:03
2665 2678 3 639 12517 43 Quench Kiss Lip Balm NULL 3304300 40 0.0 199.0 0.0 0.0 159.0 134.75 24.25 7960.0 0.0 6360.0 0.0 0.0 0.0 0.0 18.0 970.17 5389.83 970.17 6360.0 INR 2 6.0 323.39 2026-01-09 12:50:03
2666 2679 4 639 12517 46 Root Vitality Hair Oil NULL 3305901 150 0.0 255.0 0.0 0.0 204.0 194.29 9.71 38250.0 0.0 30600.0 0.0 0.0 0.0 0.0 5.0 1457.14 29142.85 1457.14 30600.0 INR 2 6.0 1748.57 2026-01-09 12:50:03
2667 2680 5 639 12517 1 Stem Cell Powder NULL 2936900 50 0.0 2499.0 0.0 0.0 1999.0 1903.81 95.19 124950.0 0.0 99950.0 0.0 0.0 0.0 0.0 5.0 4759.52 95190.48 4759.52 99950.0 INR 2 6.0 5711.43 2026-01-09 12:50:03
2668 2681 6 639 12517 5 Thyro Care NULL 2936900 50 0.0 999.0 0.0 0.0 720.0 685.71 34.29 49950.0 0.0 36000.0 0.0 0.0 0.0 0.0 5.0 1714.29 34285.71 1714.29 36000.0 INR 2 6.0 2057.14 2026-01-09 12:50:03
2669 2682 1 640 12516 43 Quench Kiss Lip Balm NULL 3304300 30 0.0 199.0 0.0 0.0 159.0 134.75 24.25 5970.0 0.0 4770.0 9.0 363.81 9.0 363.81 0.0 0.0 4042.37 727.63 4770.0 INR 1 8.0 323.39 2026-01-09 12:51:17
2670 2683 1 641 12516 46 Root Vitality Hair Oil NULL 3305901 150 0.0 255.0 0.0 0.0 204.0 194.29 9.71 38250.0 0.0 30600.0 2.5 728.57 2.5 728.57 0.0 0.0 29142.85 1457.14 30600.0 INR 1 8.0 2331.43 2026-01-09 12:53:46
2671 2684 1 642 12538 84 B AND B NULL 94041000 1 0.0 12999.0 0.0 0.0 10500.0 10000.0 500.0 12999.0 0.0 10500.0 2.5 250.0 2.5 250.0 0.0 0.0 10000.0 500.0 10500.0 INR 3 0.0 150.0 2026-01-09 13:07:00
2672 2685 1 643 14079 33 Herbal Soap 100gm NULL 30049011 13 0.0 100.0 0.0 0.0 80.0 76.19 3.81 1300.0 0.0 1040.0 2.5 24.76 2.5 24.76 0.0 0.0 990.48 49.52 1040.0 INR 3 2.0 19.81 2026-01-09 13:57:25
2673 2686 2 643 14079 30 Iron Capsules NULL 30049011 1 0.0 899.0 0.0 0.0 719.0 684.76 34.24 899.0 0.0 719.0 2.5 17.12 2.5 17.12 0.0 0.0 684.76 34.24 719.0 INR 3 2.0 13.7 2026-01-09 13:57:25
2674 2687 3 643 14079 32 Neem Soap 100gm NULL 34011110 10 0.0 60.0 0.0 0.0 48.0 45.71 2.29 600.0 0.0 480.0 2.5 11.43 2.5 11.43 0.0 0.0 457.14 22.86 480.0 INR 3 2.0 9.14 2026-01-09 13:57:25
2675 2688 4 643 14079 26 Spirulina Cap NULL 2009899 1 0.0 899.0 0.0 0.0 719.0 684.76 34.24 899.0 0.0 719.0 2.5 17.12 2.5 17.12 0.0 0.0 684.76 34.24 719.0 INR 3 2.0 13.7 2026-01-09 13:57:25
2676 2689 5 643 14079 50 Sun Screen NULL 330499 1 0.0 699.0 0.0 0.0 559.0 473.73 85.27 699.0 0.0 559.0 9.0 42.64 9.0 42.64 0.0 0.0 473.73 85.27 559.0 INR 3 2.0 9.47 2026-01-09 13:57:25
2677 2690 1 644 12555 61 Radiation chip NULL 902221 2 0.0 999.0 0.0 0.0 500.0 423.73 76.27 1998.0 0.0 1000.0 9.0 76.27 9.0 76.27 0.0 0.0 847.46 152.54 1000.0 INR 3 2.0 16.95 2026-01-09 15:42:18
2678 2691 1 645 12532 38 Dish Wash 500ml NULL 3924101 5 0.0 230.0 0.0 0.0 184.0 155.93 28.07 1150.0 0.0 920.0 0.0 0.0 0.0 0.0 18.0 140.34 779.66 140.34 920.0 INR 3 2.0 15.59 2026-01-09 15:54:54
2679 2692 2 645 12532 37 Floor Cleaner 500ml NULL 3924101 10 0.0 199.0 0.0 0.0 159.0 134.75 24.25 1990.0 0.0 1590.0 0.0 0.0 0.0 0.0 18.0 242.54 1347.46 242.54 1590.0 INR 3 2.0 26.95 2026-01-09 15:54:54
2680 2693 3 645 12532 33 Herbal Soap 100gm NULL 30049011 200 0.0 100.0 0.0 0.0 80.0 76.19 3.81 20000.0 0.0 16000.0 0.0 0.0 0.0 0.0 5.0 761.9 15238.1 761.9 16000.0 INR 3 2.0 304.76 2026-01-09 15:54:54
2681 2694 4 645 12532 34 Herbo2o Toothpaste NULL 33061090 24 0.0 199.0 0.0 0.0 159.0 134.75 24.25 4776.0 0.0 3816.0 0.0 0.0 0.0 0.0 18.0 582.1 3233.9 582.1 3816.0 INR 3 2.0 64.68 2026-01-09 15:54:54
2682 2695 5 645 12532 18 Lady Care Juice 500ml NULL 2009899 1 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 1499.0 0.0 1200.0 0.0 0.0 0.0 0.0 5.0 57.14 1142.86 57.14 1200.0 INR 3 2.0 22.86 2026-01-09 15:54:54
2683 2696 6 645 12532 7 Morning Fresh Churan NULL 30049011 24 0.0 199.0 0.0 0.0 159.0 151.43 7.57 4776.0 0.0 3816.0 0.0 0.0 0.0 0.0 5.0 181.71 3634.29 181.71 3816.0 INR 3 2.0 72.69 2026-01-09 15:54:54
2684 2697 7 645 12532 32 Neem Soap 100gm NULL 34011110 300 0.0 60.0 0.0 0.0 48.0 45.71 2.29 18000.0 0.0 14400.0 0.0 0.0 0.0 0.0 5.0 685.71 13714.29 685.71 14400.0 INR 3 2.0 274.29 2026-01-09 15:54:54
2685 2698 8 645 12532 36 Toilet Cleaner 500ml NULL 3924101 24 0.0 150.0 0.0 0.0 120.0 101.69 18.31 3600.0 0.0 2880.0 0.0 0.0 0.0 0.0 18.0 439.32 2440.68 439.32 2880.0 INR 3 2.0 48.81 2026-01-09 15:54:54
2686 2699 1 646 12554 7 Morning Fresh Churan NULL 30049011 15 0.0 199.0 0.0 0.0 159.0 151.43 7.57 2985.0 0.0 2385.0 2.5 56.79 2.5 56.79 0.0 0.0 2271.43 113.57 2385.0 INR 2 6.0 136.29 2026-01-09 15:57:37
2687 2700 2 646 12554 72 Pain Relief Patch NULL 30051090 10 0.0 800.0 0.0 0.0 600.0 571.43 28.57 8000.0 0.0 6000.0 2.5 142.86 2.5 142.86 0.0 0.0 5714.29 285.71 6000.0 INR 2 6.0 342.86 2026-01-09 15:57:37
2688 2701 1 647 12532 72 Pain Relief Patch NULL 30051090 1 0.0 800.0 0.0 0.0 600.0 571.43 28.57 800.0 0.0 600.0 0.0 0.0 0.0 0.0 5.0 28.57 571.43 28.57 600.0 INR 3 2.0 11.43 2026-01-09 16:43:26
2689 2702 2 647 12532 47 Premium Hair Care Shampoo NULL 3305109 9 0.0 699.0 0.0 0.0 559.0 532.38 26.62 6291.0 0.0 5031.0 0.0 0.0 0.0 0.0 5.0 239.57 4791.43 239.57 5031.0 INR 3 2.0 95.83 2026-01-09 16:43:26
2690 2703 1 648 12532 79 ALKALINE JUG NULL 8421 1 0.0 14499.0 0.0 0.0 9900.0 8389.83 1510.17 14499.0 0.0 9900.0 9.0 755.08 9.0 755.08 0.0 0.0 8389.83 1510.17 9900.0 INR 3 0.0 150.0 2026-01-09 16:49:21
2691 2704 1 649 12554 61 Radiation chip NULL 902221 20 0.0 999.0 0.0 0.0 500.0 423.73 76.27 19980.0 0.0 10000.0 9.0 762.71 9.0 762.71 0.0 0.0 8474.58 1525.42 10000.0 INR 2 6.0 508.47 2026-01-09 17:05:58
2692 2705 1 650 12555 61 Radiation chip NULL 902221 10 0.0 999.0 0.0 0.0 500.0 423.73 76.27 9990.0 0.0 5000.0 9.0 381.36 9.0 381.36 0.0 0.0 4237.29 762.71 5000.0 INR 3 2.0 84.75 2026-01-09 17:06:41
2693 2706 1 651 12532 82 ALKALINE CAPSULE NULL 3402000 1 0.0 2500.0 0.0 0.0 2000.0 1941.75 58.25 2500.0 0.0 2000.0 1.5 29.13 1.5 29.13 0.0 0.0 1941.75 58.25 2000.0 INR 3 2.0 38.84 2026-01-09 17:11:05
2694 2707 1 652 12554 84 B AND B NULL 94041000 10 0.0 12999.0 0.0 0.0 10500.0 10000.0 500.0 129990.0 0.0 105000.0 2.5 2500.0 2.5 2500.0 0.0 0.0 100000.0 5000.0 105000.0 INR 2 0.0 300.0 2026-01-09 17:14:33
2695 2708 1 653 12516 84 B AND B NULL 94041000 10 0.0 12999.0 0.0 0.0 10500.0 10000.0 500.0 129990.0 0.0 105000.0 2.5 2500.0 2.5 2500.0 0.0 0.0 100000.0 5000.0 105000.0 INR 1 0.0 400.0 2026-01-09 17:15:00
2696 2709 1 654 13536 84 B AND B NULL 94041000 2 0.0 12999.0 0.0 0.0 10500.0 10000.0 500.0 25998.0 0.0 21000.0 2.5 500.0 2.5 500.0 0.0 0.0 20000.0 1000.0 21000.0 INR 3 0.0 150.0 2026-01-09 17:15:51
2697 2710 1 655 13536 37 Floor Cleaner 500ml NULL 3924101 10 0.0 199.0 0.0 0.0 159.0 134.75 24.25 1990.0 0.0 1590.0 9.0 121.27 9.0 121.27 0.0 0.0 1347.46 242.54 1590.0 INR 3 2.0 26.95 2026-01-09 17:17:35
2698 2711 2 655 13536 32 Neem Soap 100gm NULL 34011110 27 0.0 60.0 0.0 0.0 48.0 45.71 2.29 1620.0 0.0 1296.0 2.5 30.86 2.5 30.86 0.0 0.0 1234.29 61.71 1296.0 INR 3 2.0 24.69 2026-01-09 17:17:35
2699 2712 3 655 13536 35 Sanitary Pad (15 pcs) NULL 9619001 13 0.0 380.0 0.0 0.0 304.0 304.0 0.0 4940.0 0.0 3952.0 0.0 0.0 0.0 0.0 0.0 0.0 3952.0 0.0 3952.0 INR 3 2.0 79.04 2026-01-09 17:17:35
2700 2713 4 655 13536 36 Toilet Cleaner 500ml NULL 3924101 10 0.0 150.0 0.0 0.0 120.0 101.69 18.31 1500.0 0.0 1200.0 9.0 91.53 9.0 91.53 0.0 0.0 1016.95 183.05 1200.0 INR 3 2.0 20.34 2026-01-09 17:17:35