fx_franchise_order_product

4,933 rows · 33 columns · page 79 / 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
3901 3914 21 956 12526 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-02-13 17:48:09
3902 3915 22 956 12526 34 Toothpaste NULL 33061090 6 0.0 199.0 0.0 0.0 159.0 134.75 24.25 1194.0 0.0 954.0 9.0 72.76 9.0 72.76 0.0 0.0 808.47 145.53 954.0 INR 3 2.0 16.17 2026-02-13 17:48:09
3903 3916 23 956 12526 44 Vital Glow Face Scrub NULL 3304300 5 0.0 325.0 0.0 0.0 260.0 220.34 39.66 1625.0 0.0 1300.0 9.0 99.15 9.0 99.15 0.0 0.0 1101.69 198.31 1300.0 INR 3 2.0 22.03 2026-02-13 17:48:09
3904 3917 1 957 12546 38 Dish Wash 500ml NULL 34029099 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-02-13 18:24:00
3905 3918 2 957 12546 7 Morning Fresh Churan NULL 30049011 1 0.0 199.0 0.0 0.0 159.0 151.43 7.57 199.0 0.0 159.0 2.5 3.79 2.5 3.79 0.0 0.0 151.43 7.57 159.0 INR 3 2.0 3.03 2026-02-13 18:24:00
3906 3919 3 957 12546 32 Neem Soap 100gm NULL 34011110 50 0.0 60.0 0.0 0.0 48.0 45.71 2.29 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-02-13 18:24:00
3907 3920 4 957 12546 36 Toilet Cleaner 500ml NULL 3924101 5 0.0 150.0 0.0 0.0 120.0 101.69 18.31 750.0 0.0 600.0 9.0 45.76 9.0 45.76 0.0 0.0 508.47 91.53 600.0 INR 3 2.0 10.17 2026-02-13 18:24:00
3908 3921 1 958 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-02-13 21:30:14
3909 3922 2 958 12526 82 ALKALINE CAPSULE NULL 3402000 1 0.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 2500.0 0.0 2000.0 2.5 47.62 2.5 47.62 0.0 0.0 1904.76 95.24 2000.0 INR 3 2.0 38.1 2026-02-13 21:30:14
3910 3923 1 959 12526 20 Premium Berry Juice 1000ml NULL 2936900 2 0.0 3499.0 0.0 0.0 2600.0 2476.19 123.81 6998.0 0.0 5200.0 2.5 123.81 2.5 123.81 0.0 0.0 4952.38 247.62 5200.0 INR 3 2.0 99.05 2026-02-13 21:38:45
3911 3924 2 959 12526 82 ALKALINE CAPSULE NULL 3402000 2 0.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 5000.0 0.0 4000.0 2.5 95.24 2.5 95.24 0.0 0.0 3809.52 190.48 4000.0 INR 3 2.0 76.19 2026-02-13 21:38:45
3912 3925 3 959 12526 6 Asthma Care 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-02-13 21:38:45
3913 3926 4 959 12526 4 Diabetic Care Capsules NULL 2936900 3 0.0 999.0 0.0 0.0 720.0 685.71 34.29 2997.0 0.0 2160.0 2.5 51.43 2.5 51.43 0.0 0.0 2057.14 102.86 2160.0 INR 3 2.0 41.14 2026-02-13 21:38:45
3914 3927 5 959 12526 38 Dish Wash 500ml NULL 34029099 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-02-13 21:38:45
3915 3928 6 959 12526 39 Fabric Wash 1000ml NULL 34029099 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-02-13 21:38:45
3916 3929 7 959 12526 19 Fat loss Juice 500 ml NULL 30049011 1 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 1499.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-02-13 21:38:45
3917 3930 8 959 12526 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-02-13 21:38:45
3918 3931 9 959 12526 48 Glow bliss face wash NULL 3304999 5 0.0 380.0 0.0 0.0 304.0 257.63 46.37 1900.0 0.0 1520.0 9.0 115.93 9.0 115.93 0.0 0.0 1288.14 231.86 1520.0 INR 3 2.0 25.76 2026-02-13 21:38:45
3919 3932 10 959 12526 33 HALDI CHANDAN SOAP 100gm NULL 30049011 50 0.0 100.0 0.0 0.0 80.0 76.19 3.81 5000.0 0.0 4000.0 2.5 95.24 2.5 95.24 0.0 0.0 3809.53 190.48 4000.0 INR 3 2.0 76.19 2026-02-13 21:38:45
3920 3933 11 959 12526 2 Heart Care Capsules NULL 2936900 1 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 1499.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-02-13 21:38:45
3921 3934 12 959 12526 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-02-13 21:38:45
3922 3935 13 959 12526 28 Ortho Joint Shield NULL 2009899 6 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 8994.0 0.0 7200.0 2.5 171.43 2.5 171.43 0.0 0.0 6857.14 342.86 7200.0 INR 3 2.0 137.14 2026-02-13 21:38:45
3923 3936 14 959 12526 72 Pain Relief Patch NULL 30051090 5 0.0 800.0 0.0 0.0 600.0 571.43 28.57 4000.0 0.0 3000.0 2.5 71.43 2.5 71.43 0.0 0.0 2857.14 142.86 3000.0 INR 3 2.0 57.14 2026-02-13 21:38:45
3924 3937 15 959 12526 94 PAVANA DROPS NULL 30041211 2 0.0 699.0 0.0 0.0 499.0 475.24 23.76 1398.0 0.0 998.0 2.5 23.76 2.5 23.76 0.0 0.0 950.48 47.52 998.0 INR 3 2.0 19.01 2026-02-13 21:38:45
3925 3938 16 959 12526 41 Premium Coco Body Lotion NULL 3304300 10 0.0 699.0 0.0 0.0 559.0 473.73 85.27 6990.0 0.0 5590.0 9.0 426.36 9.0 426.36 0.0 0.0 4737.29 852.71 5590.0 INR 3 2.0 94.75 2026-02-13 21:38:45
3926 3939 17 959 12526 81 PREMIUM GLOW FACE WASH NULL 3404 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-02-13 21:38:45
3927 3940 18 959 12526 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-02-13 21:38:45
3928 3941 19 959 12526 46 Root Vitality Hair Oil NULL 3305901 20 0.0 255.0 0.0 0.0 204.0 194.29 9.71 5100.0 0.0 4080.0 2.5 97.14 2.5 97.14 0.0 0.0 3885.71 194.29 4080.0 INR 3 2.0 77.71 2026-02-13 21:38:45
3929 3942 20 959 12526 95 STRI VEDA NULL 30049011 1 0.0 2500.0 0.0 0.0 1500.0 1428.57 71.43 2500.0 0.0 1500.0 2.5 35.71 2.5 35.71 0.0 0.0 1428.57 71.43 1500.0 INR 3 2.0 28.57 2026-02-13 21:38:45
3930 3943 21 959 12526 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-02-13 21:38:45
3931 3944 22 959 12526 34 Toothpaste NULL 33061090 6 0.0 199.0 0.0 0.0 159.0 134.75 24.25 1194.0 0.0 954.0 9.0 72.76 9.0 72.76 0.0 0.0 808.47 145.53 954.0 INR 3 2.0 16.17 2026-02-13 21:38:45
3932 3945 23 959 12526 44 Vital Glow Face Scrub NULL 3304300 5 0.0 325.0 0.0 0.0 260.0 220.34 39.66 1625.0 0.0 1300.0 9.0 99.15 9.0 99.15 0.0 0.0 1101.69 198.31 1300.0 INR 3 2.0 22.03 2026-02-13 21:38:45
3933 3946 1 960 12526 82 ALKALINE CAPSULE NULL 3402000 1 0.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 2500.0 0.0 2000.0 2.5 47.62 2.5 47.62 0.0 0.0 1904.76 95.24 2000.0 INR 3 2.0 38.1 2026-02-13 21:57:11
3934 3947 2 960 12526 94 PAVANA DROPS NULL 30041211 2 0.0 699.0 0.0 0.0 499.0 475.24 23.76 1398.0 0.0 998.0 2.5 23.76 2.5 23.76 0.0 0.0 950.48 47.52 998.0 INR 3 2.0 19.01 2026-02-13 21:57:11
3935 3948 1 961 12546 52 Bhoo sanjeevni 5 kg NULL 3103100 3 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 4800.0 0.0 3750.0 2.5 89.29 2.5 89.29 0.0 0.0 3571.43 178.57 3750.0 INR 3 2.0 71.43 2026-02-13 23:20:27
3936 3949 2 961 12546 53 Terra care 2 kg NULL 3103100 3 0.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 4500.0 0.0 3450.0 2.5 82.14 2.5 82.14 0.0 0.0 3285.71 164.29 3450.0 INR 3 2.0 65.71 2026-02-13 23:20:27
3937 3950 1 962 12541 38 Dish Wash 500ml NULL 34029099 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-02-14 18:04:42
3938 3951 2 962 12541 39 Fabric Wash 1000ml NULL 34029099 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-02-14 18:04:42
3939 3952 3 962 12541 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-02-14 18:04:42
3940 3953 4 962 12541 33 HALDI CHANDAN SOAP 100gm NULL 30049011 16 0.0 100.0 0.0 0.0 80.0 76.19 3.81 1600.0 0.0 1280.0 2.5 30.48 2.5 30.48 0.0 0.0 1219.05 60.95 1280.0 INR 3 2.0 24.38 2026-02-14 18:04:42
3941 3954 5 962 12541 25 Manicalcium Tablets NULL 2009899 1 0.0 399.0 0.0 0.0 319.0 303.81 15.19 399.0 0.0 319.0 2.5 7.6 2.5 7.6 0.0 0.0 303.81 15.19 319.0 INR 3 2.0 6.08 2026-02-14 18:04:42
3942 3955 6 962 12541 32 Neem Soap 100gm NULL 34011110 24 0.0 60.0 0.0 0.0 48.0 45.71 2.29 1440.0 0.0 1152.0 2.5 27.43 2.5 27.43 0.0 0.0 1097.14 54.86 1152.0 INR 3 2.0 21.94 2026-02-14 18:04:42
3943 3956 7 962 12541 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-02-14 18:04:42
3944 3957 8 962 12541 81 PREMIUM GLOW FACE WASH NULL 3404 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-02-14 18:04:42
3945 3958 9 962 12541 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 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-02-14 18:04:42
3946 3959 10 962 12541 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-02-14 18:04:42
3947 3960 11 962 12541 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-02-14 18:04:42
3948 3961 12 962 12541 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-02-14 18:04:42
3949 3962 13 962 12541 34 Toothpaste NULL 33061090 4 0.0 199.0 0.0 0.0 159.0 134.75 24.25 796.0 0.0 636.0 9.0 48.51 9.0 48.51 0.0 0.0 538.98 97.02 636.0 INR 3 2.0 10.78 2026-02-14 18:04:42
3950 3963 1 963 12542 62 3*6 BED WITH BRACELET NULL 94041000 8 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 103992.0 0.0 63840.0 0.0 0.0 0.0 0.0 3.0 1859.42 61980.58 1859.42 63840.0 INR 3 2.0 1239.61 2026-02-16 15:02:31