fx_franchise_order_product

4,933 rows · 33 columns · page 56 / 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
2751 2764 4 671 12552 33 Herbal Soap 100gm NULL 30049011 8 0.0 100.0 0.0 0.0 80.0 76.19 3.81 800.0 0.0 640.0 2.5 15.24 2.5 15.24 0.0 0.0 609.52 30.48 640.0 INR 3 2.0 12.19 2026-01-09 22:52:53
2752 2765 5 671 12552 34 Herbo2o Toothpaste NULL 33061090 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 22:52:53
2753 2766 6 671 12552 17 Memory Booster Juice NULL 2009899 2 0.0 349.0 0.0 0.0 279.0 265.71 13.29 698.0 0.0 558.0 2.5 13.29 2.5 13.29 0.0 0.0 531.43 26.57 558.0 INR 3 2.0 10.63 2026-01-09 22:52:53
2754 2767 7 671 12552 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 22:52:53
2755 2768 8 671 12552 32 Neem Soap 100gm NULL 34011110 32 0.0 60.0 0.0 0.0 48.0 45.71 2.29 1920.0 0.0 1536.0 2.5 36.57 2.5 36.57 0.0 0.0 1462.86 73.14 1536.0 INR 3 2.0 29.26 2026-01-09 22:52:53
2756 2769 9 671 12552 81 PREMIUM GLOW FACE WASH NULL 3404 1 0.0 699.0 0.0 0.0 559.0 512.84 46.16 699.0 0.0 559.0 4.5 23.08 4.5 23.08 0.0 0.0 512.84 46.16 559.0 INR 3 2.0 10.26 2026-01-09 22:52:53
2757 2770 10 671 12552 43 Quench Kiss Lip Balm NULL 3304300 3 0.0 199.0 0.0 0.0 159.0 134.75 24.25 597.0 0.0 477.0 9.0 36.38 9.0 36.38 0.0 0.0 404.24 72.76 477.0 INR 3 2.0 8.08 2026-01-09 22:52:53
2758 2771 11 671 12552 46 Root Vitality Hair Oil NULL 3305901 5 0.0 255.0 0.0 0.0 204.0 194.29 9.71 1275.0 0.0 1020.0 2.5 24.29 2.5 24.29 0.0 0.0 971.43 48.57 1020.0 INR 3 2.0 19.43 2026-01-09 22:52:53
2759 2772 12 671 12552 35 Sanitary Pad (15 pcs) NULL 9619001 1 0.0 380.0 0.0 0.0 304.0 304.0 0.0 380.0 0.0 304.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 304.0 INR 3 2.0 6.08 2026-01-09 22:52:53
2760 2773 13 671 12552 1 Stem Cell Powder NULL 2936900 1 0.0 2499.0 0.0 0.0 1999.0 1903.81 95.19 2499.0 0.0 1999.0 2.5 47.6 2.5 47.6 0.0 0.0 1903.81 95.19 1999.0 INR 3 2.0 38.08 2026-01-09 22:52:53
2761 2774 14 671 12552 50 Sun Screen NULL 330499 2 0.0 699.0 0.0 0.0 559.0 473.73 85.27 1398.0 0.0 1118.0 9.0 85.27 9.0 85.27 0.0 0.0 947.46 170.54 1118.0 INR 3 2.0 18.95 2026-01-09 22:52:53
2762 2775 15 671 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-09 22:52:53
2763 2776 1 672 13438 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 0.0 0.0 0.0 0.0 5.0 500.0 10000.0 500.0 10500.0 INR 3 0.0 150.0 2026-01-09 22:56:55
2764 2777 1 673 13438 12 P RADIANCE FACE SERUM NULL 33049990 3 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 3750.0 0.0 2250.0 0.0 0.0 0.0 0.0 5.0 107.14 2142.86 107.14 2250.0 INR 3 2.0 42.86 2026-01-09 23:19:43
2765 2778 1 674 13438 32 Neem Soap 100gm NULL 34011110 20 0.0 60.0 0.0 0.0 48.0 45.71 2.29 1200.0 0.0 960.0 0.0 0.0 0.0 0.0 5.0 45.71 914.29 45.71 960.0 INR 3 2.0 18.29 2026-01-09 23:42:17
2766 2779 2 674 13438 1 Stem Cell Powder NULL 2936900 1 0.0 2499.0 0.0 0.0 1999.0 1903.81 95.19 2499.0 0.0 1999.0 0.0 0.0 0.0 0.0 5.0 95.19 1903.81 95.19 1999.0 INR 3 2.0 38.08 2026-01-09 23:42:17
2767 2780 1 675 13438 12 P RADIANCE FACE SERUM NULL 33049990 1 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 1250.0 0.0 750.0 0.0 0.0 0.0 0.0 5.0 35.71 714.29 35.71 750.0 INR 3 2.0 14.29 2026-01-09 23:56:26
2768 2781 1 676 13438 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-10 11:46:05
2769 2782 1 677 12523 48 glow face wash NULL 3304999 3 0.0 380.0 0.0 0.0 304.0 257.63 46.37 1140.0 0.0 912.0 9.0 69.56 9.0 69.56 0.0 0.0 772.88 139.12 912.0 INR 3 2.0 15.46 2026-01-10 13:53:28
2770 2783 2 677 12523 3 BP Care Capsules NULL 2936900 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-10 13:53:28
2771 2784 3 677 12523 4 Diabetic Care Capsules NULL 2936900 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-10 13:53:28
2772 2785 4 677 12523 15 KIDNEY CARE JUICE NULL 2009899 2 0.0 349.0 0.0 0.0 279.0 265.71 13.29 698.0 0.0 558.0 2.5 13.29 2.5 13.29 0.0 0.0 531.43 26.57 558.0 INR 3 2.0 10.63 2026-01-10 13:53:28
2773 2786 5 677 12523 7 Morning Fresh Churan NULL 30049011 10 0.0 199.0 0.0 0.0 159.0 151.43 7.57 1990.0 0.0 1590.0 2.5 37.86 2.5 37.86 0.0 0.0 1514.29 75.71 1590.0 INR 3 2.0 30.29 2026-01-10 13:53:28
2774 2787 6 677 12523 9 Omega 369 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-10 13:53:28
2775 2788 7 677 12523 8 Piles 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-10 13:53:28
2776 2789 8 677 12523 47 Premium Hair Care Shampoo NULL 3305109 1 0.0 699.0 0.0 0.0 559.0 532.38 26.62 699.0 0.0 559.0 2.5 13.31 2.5 13.31 0.0 0.0 532.38 26.62 559.0 INR 3 2.0 10.65 2026-01-10 13:53:28
2777 2790 9 677 12523 50 Sun Screen NULL 330499 2 0.0 699.0 0.0 0.0 559.0 473.73 85.27 1398.0 0.0 1118.0 9.0 85.27 9.0 85.27 0.0 0.0 947.46 170.54 1118.0 INR 3 2.0 18.95 2026-01-10 13:53:28
2778 2791 1 678 12517 48 glow face wash NULL 3304999 30 0.0 380.0 0.0 0.0 304.0 257.63 46.37 11400.0 0.0 9120.0 0.0 0.0 0.0 0.0 18.0 1391.19 7728.81 1391.19 9120.0 INR 2 6.0 463.73 2026-01-10 15:40:06
2779 2792 1 679 14323 48 glow face wash NULL 3304999 2 0.0 380.0 0.0 0.0 304.0 257.63 46.37 760.0 0.0 608.0 9.0 46.37 9.0 46.37 0.0 0.0 515.25 92.75 608.0 INR 3 2.0 10.31 2026-01-10 16:02:57
2780 2793 2 679 14323 38 Dish Wash 500ml NULL 3924101 41 0.0 230.0 0.0 0.0 184.0 155.93 28.07 9430.0 0.0 7544.0 9.0 575.39 9.0 575.39 0.0 0.0 6393.22 1150.78 7544.0 INR 3 2.0 127.86 2026-01-10 16:02:57
2781 2794 3 679 14323 37 Floor Cleaner 500ml NULL 3924101 33 0.0 199.0 0.0 0.0 159.0 134.75 24.25 6567.0 0.0 5247.0 9.0 400.19 9.0 400.19 0.0 0.0 4446.61 800.39 5247.0 INR 3 2.0 88.93 2026-01-10 16:02:57
2782 2795 4 679 14323 60 Foot patch NULL 30051090 2 0.0 1999.0 0.0 0.0 1599.0 1522.86 76.14 3998.0 0.0 3198.0 2.5 76.14 2.5 76.14 0.0 0.0 3045.71 152.29 3198.0 INR 3 2.0 60.91 2026-01-10 16:02:57
2783 2796 5 679 14323 33 Herbal Soap 100gm NULL 30049011 100 0.0 100.0 0.0 0.0 80.0 76.19 3.81 10000.0 0.0 8000.0 2.5 190.48 2.5 190.48 0.0 0.0 7619.05 380.95 8000.0 INR 3 2.0 152.38 2026-01-10 16:02:57
2784 2797 6 679 14323 34 Herbo2o Toothpaste NULL 33061090 48 0.0 199.0 0.0 0.0 159.0 134.75 24.25 9552.0 0.0 7632.0 9.0 582.1 9.0 582.1 0.0 0.0 6467.8 1164.2 7632.0 INR 3 2.0 129.36 2026-01-10 16:02:57
2785 2798 7 679 14323 7 Morning Fresh Churan NULL 30049011 8 0.0 199.0 0.0 0.0 159.0 151.43 7.57 1592.0 0.0 1272.0 2.5 30.29 2.5 30.29 0.0 0.0 1211.43 60.57 1272.0 INR 3 2.0 24.23 2026-01-10 16:02:57
2786 2799 8 679 14323 32 Neem Soap 100gm NULL 34011110 100 0.0 60.0 0.0 0.0 48.0 45.71 2.29 6000.0 0.0 4800.0 2.5 114.29 2.5 114.29 0.0 0.0 4571.43 228.57 4800.0 INR 3 2.0 91.43 2026-01-10 16:02:57
2787 2800 9 679 14323 72 Pain Relief Patch NULL 30051090 2 0.0 800.0 0.0 0.0 600.0 571.43 28.57 1600.0 0.0 1200.0 2.5 28.57 2.5 28.57 0.0 0.0 1142.86 57.14 1200.0 INR 3 2.0 22.86 2026-01-10 16:02:57
2788 2801 10 679 14323 46 Root Vitality Hair Oil NULL 3305901 10 0.0 255.0 0.0 0.0 204.0 194.29 9.71 2550.0 0.0 2040.0 2.5 48.57 2.5 48.57 0.0 0.0 1942.86 97.14 2040.0 INR 3 2.0 38.86 2026-01-10 16:02:57
2789 2802 11 679 14323 35 Sanitary Pad (15 pcs) NULL 9619001 15 0.0 380.0 0.0 0.0 304.0 304.0 0.0 5700.0 0.0 4560.0 0.0 0.0 0.0 0.0 0.0 0.0 4560.0 0.0 4560.0 INR 3 2.0 91.2 2026-01-10 16:02:57
2790 2803 12 679 14323 50 Sun Screen NULL 330499 5 0.0 699.0 0.0 0.0 559.0 473.73 85.27 3495.0 0.0 2795.0 9.0 213.18 9.0 213.18 0.0 0.0 2368.64 426.36 2795.0 INR 3 2.0 47.37 2026-01-10 16:02:57
2791 2804 13 679 14323 36 Toilet Cleaner 500ml NULL 3924101 31 0.0 150.0 0.0 0.0 120.0 101.69 18.31 4650.0 0.0 3720.0 9.0 283.73 9.0 283.73 0.0 0.0 3152.54 567.46 3720.0 INR 3 2.0 63.05 2026-01-10 16:02:57
2792 2805 1 680 12517 38 Dish Wash 500ml NULL 3924101 100 0.0 230.0 0.0 0.0 184.0 155.93 28.07 23000.0 0.0 18400.0 0.0 0.0 0.0 0.0 18.0 2806.78 15593.22 2806.78 18400.0 INR 2 6.0 935.59 2026-01-10 16:16:59
2793 2806 2 680 12517 37 Floor Cleaner 500ml NULL 3924101 100 0.0 199.0 0.0 0.0 159.0 134.75 24.25 19900.0 0.0 15900.0 0.0 0.0 0.0 0.0 18.0 2425.42 13474.58 2425.42 15900.0 INR 2 6.0 808.47 2026-01-10 16:16:59
2794 2807 3 680 12517 7 Morning Fresh Churan NULL 30049011 30 0.0 199.0 0.0 0.0 159.0 151.43 7.57 5970.0 0.0 4770.0 0.0 0.0 0.0 0.0 5.0 227.14 4542.86 227.14 4770.0 INR 2 6.0 272.57 2026-01-10 16:16:59
2795 2808 1 681 12517 38 Dish Wash 500ml NULL 3924101 50 0.0 230.0 0.0 0.0 184.0 155.93 28.07 11500.0 0.0 9200.0 0.0 0.0 0.0 0.0 18.0 1403.39 7796.61 1403.39 9200.0 INR 2 6.0 467.8 2026-01-10 16:18:01
2796 2809 2 681 12517 37 Floor Cleaner 500ml NULL 3924101 50 0.0 199.0 0.0 0.0 159.0 134.75 24.25 9950.0 0.0 7950.0 0.0 0.0 0.0 0.0 18.0 1212.71 6737.29 1212.71 7950.0 INR 2 6.0 404.24 2026-01-10 16:18:01
2797 2810 3 681 12517 7 Morning Fresh Churan NULL 30049011 30 0.0 199.0 0.0 0.0 159.0 151.43 7.57 5970.0 0.0 4770.0 0.0 0.0 0.0 0.0 5.0 227.14 4542.86 227.14 4770.0 INR 2 6.0 272.57 2026-01-10 16:18:01
2798 2811 1 682 12516 7 Morning Fresh Churan NULL 30049011 50 0.0 199.0 0.0 0.0 159.0 151.43 7.57 9950.0 0.0 7950.0 2.5 189.29 2.5 189.29 0.0 0.0 7571.43 378.57 7950.0 INR 1 8.0 605.71 2026-01-10 16:18:28
2799 2812 1 683 12517 36 Toilet Cleaner 500ml NULL 3924101 50 0.0 150.0 0.0 0.0 120.0 101.69 18.31 7500.0 0.0 6000.0 0.0 0.0 0.0 0.0 18.0 915.25 5084.74 915.25 6000.0 INR 2 6.0 305.08 2026-01-10 16:19:35
2800 2813 1 684 12517 12 P RADIANCE FACE SERUM NULL 33049990 30 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 37500.0 0.0 22500.0 0.0 0.0 0.0 0.0 5.0 1071.43 21428.57 1071.43 22500.0 INR 2 6.0 1285.71 2026-01-10 16:21:05