fx_franchise_order_product

4,933 rows · 33 columns · page 59 / 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
2901 2914 6 707 12542 43 Quench Kiss Lip Balm NULL 3304300 1 0.0 199.0 0.0 0.0 159.0 134.75 24.25 199.0 0.0 159.0 0.0 0.0 0.0 0.0 18.0 24.25 134.75 24.25 159.0 INR 3 2.0 2.69 2026-01-13 11:00:12
2902 2915 7 707 12542 46 Root Vitality Hair Oil NULL 3305901 2 0.0 255.0 0.0 0.0 204.0 194.29 9.71 510.0 0.0 408.0 0.0 0.0 0.0 0.0 5.0 19.43 388.57 19.43 408.0 INR 3 2.0 7.77 2026-01-13 11:00:12
2903 2916 1 708 12552 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-13 12:19:22
2904 2917 1 709 12517 19 Fat loss Juice 500 ml NULL 30049011 5 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 7495.0 0.0 6000.0 0.0 0.0 0.0 0.0 5.0 285.71 5714.29 285.71 6000.0 INR 2 6.0 342.86 2026-01-13 12:20:20
2905 2918 1 710 12526 20 Premium Berry Juice 1000ml NULL 2936900 1 0.0 3499.0 0.0 0.0 2600.0 2476.19 123.81 3499.0 0.0 2600.0 2.5 61.9 2.5 61.9 0.0 0.0 2476.19 123.81 2600.0 INR 3 2.0 49.52 2026-01-13 12:27:54
2906 2919 2 710 12526 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-13 12:27:54
2907 2920 3 710 12526 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 9.0 70.17 9.0 70.17 0.0 0.0 779.66 140.34 920.0 INR 3 2.0 15.59 2026-01-13 12:27:54
2908 2921 4 710 12526 19 Fat loss Juice 500 ml NULL 30049011 2 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 2998.0 0.0 2400.0 2.5 57.14 2.5 57.14 0.0 0.0 2285.71 114.29 2400.0 INR 3 2.0 45.71 2026-01-13 12:27:54
2909 2922 5 710 12526 7 Morning Fresh Churan NULL 30049011 5 0.0 199.0 0.0 0.0 159.0 151.43 7.57 995.0 0.0 795.0 2.5 18.93 2.5 18.93 0.0 0.0 757.14 37.86 795.0 INR 3 2.0 15.14 2026-01-13 12:27:54
2910 2923 6 710 12526 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-13 12:27:54
2911 2924 7 710 12526 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-13 12:27:54
2912 2925 8 710 12526 11 SOUNDARYA VEDA BRIGARAJ & SHIKAKAI NULL 33051090 1 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 1250.0 0.0 750.0 2.5 17.86 2.5 17.86 0.0 0.0 714.29 35.71 750.0 INR 3 2.0 14.29 2026-01-13 12:27:54
2913 2926 9 710 12526 10 SOUNDARYA VEDA RADIANCE DAY CREAM NULL 33049910 1 0.0 1424.0 0.0 0.0 750.0 714.29 35.71 1424.0 0.0 750.0 2.5 17.86 2.5 17.86 0.0 0.0 714.29 35.71 750.0 INR 3 2.0 14.29 2026-01-13 12:27:54
2914 2927 1 711 12518 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-13 12:54:45
2915 2928 2 711 12518 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-13 12:54:45
2916 2929 3 711 12518 39 Fabric Wash 1000ml NULL 3924101 2 0.0 401.0 0.0 0.0 321.0 272.03 48.97 802.0 0.0 642.0 9.0 48.97 9.0 48.97 0.0 0.0 544.07 97.93 642.0 INR 3 2.0 10.88 2026-01-13 12:54:45
2917 2930 4 711 12518 33 Herbal Soap 100gm NULL 30049011 30 0.0 100.0 0.0 0.0 80.0 76.19 3.81 3000.0 0.0 2400.0 2.5 57.14 2.5 57.14 0.0 0.0 2285.72 114.29 2400.0 INR 3 2.0 45.71 2026-01-13 12:54:45
2918 2931 5 711 12518 81 PREMIUM GLOW FACE WASH NULL 3404 3 0.0 699.0 0.0 0.0 559.0 512.84 46.16 2097.0 0.0 1677.0 4.5 69.23 4.5 69.23 0.0 0.0 1538.53 138.47 1677.0 INR 3 2.0 30.77 2026-01-13 12:54:45
2919 2932 6 711 12518 43 Quench Kiss Lip Balm NULL 3304300 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-13 12:54:45
2920 2933 7 711 12518 11 SOUNDARYA VEDA BRIGARAJ & SHIKAKAI NULL 33051090 3 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 3750.0 0.0 2250.0 2.5 53.57 2.5 53.57 0.0 0.0 2142.86 107.14 2250.0 INR 3 2.0 42.86 2026-01-13 12:54:45
2921 2934 8 711 12518 10 SOUNDARYA VEDA RADIANCE DAY CREAM NULL 33049910 3 0.0 1424.0 0.0 0.0 750.0 714.29 35.71 4272.0 0.0 2250.0 2.5 53.57 2.5 53.57 0.0 0.0 2142.86 107.14 2250.0 INR 3 2.0 42.86 2026-01-13 12:54:45
2922 2935 1 712 13836 38 Dish Wash 500ml NULL 3924101 1 0.0 230.0 0.0 0.0 184.0 155.93 28.07 230.0 0.0 184.0 9.0 14.03 9.0 14.03 0.0 0.0 155.93 28.07 184.0 INR 3 2.0 3.12 2026-01-13 15:00:21
2923 2936 2 712 13836 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-13 15:00:21
2924 2937 3 712 13836 33 Herbal Soap 100gm NULL 30049011 1 0.0 100.0 0.0 0.0 80.0 76.19 3.81 100.0 0.0 80.0 2.5 1.9 2.5 1.9 0.0 0.0 76.19 3.81 80.0 INR 3 2.0 1.52 2026-01-13 15:00:21
2925 2938 4 712 13836 36 Toilet Cleaner 500ml NULL 3924101 1 0.0 150.0 0.0 0.0 120.0 101.69 18.3 150.0 0.0 120.0 9.0 9.15 9.0 9.15 0.0 0.0 101.69 18.3 120.0 INR 3 2.0 2.03 2026-01-13 15:00:21
2926 2939 1 713 13536 48 glow face wash NULL 3304999 6 0.0 380.0 0.0 0.0 304.0 257.63 46.37 2280.0 0.0 1824.0 9.0 139.12 9.0 139.12 0.0 0.0 1545.76 278.24 1824.0 INR 3 2.0 30.92 2026-01-13 16:05:23
2927 2940 2 713 13536 61 Radiation chip NULL 902221 1 0.0 999.0 0.0 0.0 500.0 423.73 76.27 999.0 0.0 500.0 9.0 38.14 9.0 38.14 0.0 0.0 423.73 76.27 500.0 INR 3 2.0 8.47 2026-01-13 16:05:23
2928 2941 3 713 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-13 16:05:23
2929 2942 4 713 13536 38 Dish Wash 500ml NULL 3924101 1 0.0 230.0 0.0 0.0 184.0 155.93 28.07 230.0 0.0 184.0 9.0 14.03 9.0 14.03 0.0 0.0 155.93 28.07 184.0 INR 3 2.0 3.12 2026-01-13 16:05:23
2930 2943 5 713 13536 39 Fabric Wash 1000ml NULL 3924101 2 0.0 401.0 0.0 0.0 321.0 272.03 48.97 802.0 0.0 642.0 9.0 48.97 9.0 48.97 0.0 0.0 544.07 97.93 642.0 INR 3 2.0 10.88 2026-01-13 16:05:23
2931 2944 6 713 13536 37 Floor Cleaner 500ml NULL 3924101 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-13 16:05:23
2932 2945 7 713 13536 33 Herbal Soap 100gm NULL 30049011 3 0.0 100.0 0.0 0.0 80.0 76.19 3.81 300.0 0.0 240.0 2.5 5.71 2.5 5.71 0.0 0.0 228.57 11.43 240.0 INR 3 2.0 4.57 2026-01-13 16:05:23
2933 2946 8 713 13536 34 Herbo2o Toothpaste NULL 33061090 1 0.0 199.0 0.0 0.0 159.0 134.75 24.25 199.0 0.0 159.0 9.0 12.13 9.0 12.13 0.0 0.0 134.75 24.25 159.0 INR 3 2.0 2.69 2026-01-13 16:05:23
2934 2947 9 713 13536 32 Neem Soap 100gm NULL 34011110 4 0.0 60.0 0.0 0.0 48.0 45.71 2.29 240.0 0.0 192.0 2.5 4.57 2.5 4.57 0.0 0.0 182.86 9.14 192.0 INR 3 2.0 3.66 2026-01-13 16:05:23
2935 2948 10 713 13536 41 Premium Coco Body Lotion NULL 3304300 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-13 16:05:23
2936 2949 11 713 13536 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-13 16:05:23
2937 2950 12 713 13536 43 Quench Kiss Lip Balm NULL 3304300 2 0.0 199.0 0.0 0.0 159.0 134.75 24.25 398.0 0.0 318.0 9.0 24.25 9.0 24.25 0.0 0.0 269.49 48.51 318.0 INR 3 2.0 5.39 2026-01-13 16:05:23
2938 2951 13 713 13536 46 Root Vitality Hair Oil NULL 3305901 2 0.0 255.0 0.0 0.0 204.0 194.29 9.71 510.0 0.0 408.0 2.5 9.71 2.5 9.71 0.0 0.0 388.57 19.43 408.0 INR 3 2.0 7.77 2026-01-13 16:05:23
2939 2952 14 713 13536 35 Sanitary Pad (15 pcs) NULL 9619001 4 0.0 380.0 0.0 0.0 304.0 304.0 0.0 1520.0 0.0 1216.0 0.0 0.0 0.0 0.0 0.0 0.0 1216.0 0.0 1216.0 INR 3 2.0 24.32 2026-01-13 16:05:23
2940 2953 15 713 13536 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-13 16:05:23
2941 2954 1 714 13536 34 Herbo2o Toothpaste NULL 33061090 1 0.0 199.0 0.0 0.0 159.0 134.75 24.25 199.0 0.0 159.0 9.0 12.13 9.0 12.13 0.0 0.0 134.75 24.25 159.0 INR 3 2.0 2.69 2026-01-13 16:39:50
2942 2955 1 715 12534 49 Anti Dandruff Serum NULL 3304999 1 0.0 999.0 0.0 0.0 799.0 677.12 121.88 999.0 0.0 799.0 9.0 60.94 9.0 60.94 0.0 0.0 677.12 121.88 799.0 INR 3 2.0 13.54 2026-01-13 18:40:46
2943 2956 2 715 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-13 18:40:46
2944 2957 3 715 12534 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-13 18:40:46
2945 2958 4 715 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-13 18:40:46
2946 2959 5 715 12534 38 Dish Wash 500ml NULL 3924101 8 0.0 230.0 0.0 0.0 184.0 155.93 28.07 1840.0 0.0 1472.0 9.0 112.27 9.0 112.27 0.0 0.0 1247.46 224.54 1472.0 INR 3 2.0 24.95 2026-01-13 18:40:46
2947 2960 6 715 12534 39 Fabric Wash 1000ml NULL 3924101 5 0.0 401.0 0.0 0.0 321.0 272.03 48.97 2005.0 0.0 1605.0 9.0 122.42 9.0 122.42 0.0 0.0 1360.17 244.83 1605.0 INR 3 2.0 27.2 2026-01-13 18:40:46
2948 2961 7 715 12534 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-13 18:40:46
2949 2962 8 715 12534 34 Herbo2o Toothpaste NULL 33061090 22 0.0 199.0 0.0 0.0 159.0 134.75 24.25 4378.0 0.0 3498.0 9.0 266.8 9.0 266.8 0.0 0.0 2964.41 533.59 3498.0 INR 3 2.0 59.29 2026-01-13 18:40:46
2950 2963 9 715 12534 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-13 18:40:46