fx_franchise_order_product

4,933 rows · 33 columns · page 81 / 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
4001 4014 9 978 12548 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-26 23:50:58
4002 4015 10 978 12548 53 Terra care 2 kg NULL 3103100 1 0.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 1500.0 0.0 1150.0 2.5 27.38 2.5 27.38 0.0 0.0 1095.24 54.76 1150.0 INR 3 2.0 21.9 2026-02-26 23:50:58
4003 4016 11 978 12548 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-02-26 23:50:58
4004 4017 1 979 12521 6 Asthma Care NULL 30049011 2 0.0 899.0 0.0 0.0 719.0 684.76 34.24 1798.0 0.0 1438.0 2.5 34.24 2.5 34.24 0.0 0.0 1369.52 68.48 1438.0 INR 3 2.0 27.39 2026-02-27 19:33:29
4005 4018 2 979 12521 52 Bhoo sanjeevni 5 kg NULL 3103100 1 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 1600.0 0.0 1250.0 2.5 29.76 2.5 29.76 0.0 0.0 1190.48 59.52 1250.0 INR 3 2.0 23.81 2026-02-27 19:33:29
4006 4019 3 979 12521 33 HALDI CHANDAN SOAP 100gm NULL 30049011 18 0.0 100.0 0.0 0.0 80.0 76.19 3.81 1800.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-02-27 19:33:29
4007 4020 4 979 12521 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-27 19:33:29
4008 4021 5 979 12521 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-27 19:33:29
4009 4022 6 979 12521 32 Neem Soap 100gm NULL 34011110 170 0.0 60.0 0.0 0.0 48.0 45.71 2.29 10200.0 0.0 8160.0 2.5 194.29 2.5 194.29 0.0 0.0 7771.43 388.57 8160.0 INR 3 2.0 155.43 2026-02-27 19:33:29
4010 4023 7 979 12521 28 Ortho Joint Shield NULL 2009899 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-27 19:33:29
4011 4024 8 979 12521 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-02-27 19:33:29
4012 4025 9 979 12521 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-02-27 19:33:29
4013 4026 10 979 12521 53 Terra care 2 kg NULL 3103100 1 0.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 1500.0 0.0 1150.0 2.5 27.38 2.5 27.38 0.0 0.0 1095.24 54.76 1150.0 INR 3 2.0 21.9 2026-02-27 19:33:29
4014 4027 1 980 12534 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-02-28 12:40:42
4015 4028 2 980 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-02-28 12:40:42
4016 4029 3 980 12534 72 Pain Relief Patch NULL 30051090 3 0.0 800.0 0.0 0.0 600.0 571.43 28.57 2400.0 0.0 1800.0 2.5 42.86 2.5 42.86 0.0 0.0 1714.29 85.71 1800.0 INR 3 2.0 34.29 2026-02-28 12:40:42
4017 4030 4 980 12534 81 PREMIUM GLOW FACE WASH NULL 3404 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-02-28 12:40:42
4018 4031 5 980 12534 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-02-28 12:40:42
4019 4032 1 981 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-02-28 12:54:38
4020 4033 2 981 12534 72 Pain Relief Patch NULL 30051090 3 0.0 800.0 0.0 0.0 600.0 571.43 28.57 2400.0 0.0 1800.0 2.5 42.86 2.5 42.86 0.0 0.0 1714.29 85.71 1800.0 INR 3 2.0 34.29 2026-02-28 12:54:38
4021 4034 3 981 12534 81 PREMIUM GLOW FACE WASH NULL 3404 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-02-28 12:54:38
4022 4035 4 981 12534 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-02-28 12:54:38
4023 4036 1 982 12534 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 2 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 37400.0 0.0 21400.0 2.5 509.52 2.5 509.52 0.0 0.0 20380.95 1019.05 21400.0 INR 3 2.0 407.62 2026-02-28 12:55:14
4024 4037 1 983 12545 32 Neem Soap 100gm NULL 34011110 7 0.0 60.0 0.0 0.0 48.0 45.71 2.29 420.0 0.0 336.0 2.5 8.0 2.5 8.0 0.0 0.0 320.0 16.0 336.0 INR 3 2.0 6.4 2026-02-28 15:22:25
4025 4038 2 983 12545 36 Toilet Cleaner 500ml NULL 3924101 15 0.0 150.0 0.0 0.0 120.0 101.69 18.31 2250.0 0.0 1800.0 9.0 137.29 9.0 137.29 0.0 0.0 1525.42 274.58 1800.0 INR 3 2.0 30.51 2026-02-28 15:22:25
4026 4039 1 984 14902 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-28 20:07:12
4027 4040 2 984 14902 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-02-28 20:07:12
4028 4041 3 984 14902 39 Fabric Wash 1000ml NULL 34029099 12 0.0 401.0 0.0 0.0 321.0 272.03 48.97 4812.0 0.0 3852.0 9.0 293.8 9.0 293.8 0.0 0.0 3264.41 587.59 3852.0 INR 3 2.0 65.29 2026-02-28 20:07:12
4029 4042 4 984 14902 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-02-28 20:07:12
4030 4043 5 984 14902 48 Glow bliss face wash NULL 3304999 1 0.0 380.0 0.0 0.0 304.0 257.63 46.37 380.0 0.0 304.0 9.0 23.19 9.0 23.19 0.0 0.0 257.63 46.37 304.0 INR 3 2.0 5.15 2026-02-28 20:07:12
4031 4044 6 984 14902 33 HALDI CHANDAN SOAP 100gm NULL 30049011 24 0.0 100.0 0.0 0.0 80.0 76.19 3.81 2400.0 0.0 1920.0 2.5 45.71 2.5 45.71 0.0 0.0 1828.57 91.43 1920.0 INR 3 2.0 36.57 2026-02-28 20:07:12
4032 4045 7 984 14902 15 KIDNEY CARE JUICE NULL 2009899 4 0.0 349.0 0.0 0.0 279.0 265.71 13.29 1396.0 0.0 1116.0 2.5 26.57 2.5 26.57 0.0 0.0 1062.86 53.14 1116.0 INR 3 2.0 21.26 2026-02-28 20:07:12
4033 4046 8 984 14902 16 Liver Care Juice NULL 2009899 1 0.0 349.0 0.0 0.0 279.0 265.71 13.29 349.0 0.0 279.0 2.5 6.64 2.5 6.64 0.0 0.0 265.71 13.29 279.0 INR 3 2.0 5.31 2026-02-28 20:07:12
4034 4047 9 984 14902 32 Neem Soap 100gm NULL 34011110 5 0.0 60.0 0.0 0.0 48.0 45.71 2.29 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-02-28 20:07:12
4035 4048 10 984 14902 9 Omega 369 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-28 20:07:12
4036 4049 11 984 14902 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-02-28 20:07:12
4037 4050 12 984 14902 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-02-28 20:07:12
4038 4051 13 984 14902 36 Toilet Cleaner 500ml NULL 3924101 9 0.0 150.0 0.0 0.0 120.0 101.69 18.31 1350.0 0.0 1080.0 9.0 82.37 9.0 82.37 0.0 0.0 915.25 164.75 1080.0 INR 3 2.0 18.31 2026-02-28 20:07:12
4039 4052 1 985 12552 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-28 21:30:33
4040 4053 2 985 12552 33 HALDI CHANDAN SOAP 100gm NULL 30049011 15 0.0 100.0 0.0 0.0 80.0 76.19 3.81 1500.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-28 21:30:33
4041 4054 3 985 12552 32 Neem Soap 100gm NULL 34011110 15 0.0 60.0 0.0 0.0 48.0 45.71 2.29 900.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-02-28 21:30:33
4042 4055 4 985 12552 28 Ortho Joint Shield NULL 2009899 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-28 21:30:33
4043 4056 5 985 12552 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-02-28 21:30:33
4044 4057 6 985 12552 36 Toilet Cleaner 500ml NULL 3924101 2 0.0 150.0 0.0 0.0 120.0 101.69 18.31 300.0 0.0 240.0 9.0 18.31 9.0 18.31 0.0 0.0 203.39 36.61 240.0 INR 3 2.0 4.07 2026-02-28 21:30:33
4045 4058 1 986 12545 27 Multicharge Cap NULL 2009899 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-03-01 08:59:54
4046 4059 2 986 12545 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-03-01 08:59:54
4047 4060 3 986 12545 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-03-01 08:59:54
4048 4061 1 987 12516 7 Morning Fresh Churan NULL 30049011 100 0.0 199.0 0.0 0.0 159.0 151.43 7.57 19900.0 0.0 15900.0 2.5 378.57 2.5 378.57 0.0 0.0 15142.86 757.14 15900.0 INR 1 8.0 1211.43 2026-03-01 10:31:13
4049 4062 1 988 12521 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-03-01 11:40:59
4050 4063 2 988 12521 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-03-01 11:40:59