fx_franchise_order_product

4,933 rows · 33 columns · page 96 / 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
4751 4766 3 1213 12539 43 Quench Kiss Lip Balm NULL 3304300 1 79.0 199.0 0.0 0.0 159.0 134.75 24.25 199.0 79.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-05-29 15:53:20
4752 4767 4 1213 12539 35 Sanitary Pad (15 pcs) NULL 9619001 1 150.0 380.0 0.0 0.0 304.0 304.0 0.0 380.0 150.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-05-29 15:53:20
4753 4768 1 1214 12539 25 Manicalcium Tablets NULL 2009899 3 159.0 399.0 0.0 0.0 319.0 303.81 15.19 1197.0 477.0 957.0 2.5 22.79 2.5 22.79 0.0 0.0 911.43 45.57 957.0 INR 3 2.0 18.23 2026-05-29 16:14:49
4754 4769 1 1215 12526 38 Dish Wash 500ml NULL 34029099 2 65.0 230.0 0.0 0.0 184.0 155.93 28.07 460.0 130.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-05-29 23:55:48
4755 4770 2 1215 12526 48 Glow it multi fruit face wash NULL 3304999 5 160.0 450.0 0.0 0.0 320.0 271.19 48.81 2250.0 800.0 1600.0 9.0 122.03 9.0 122.03 0.0 0.0 1355.93 244.07 1600.0 INR 3 2.0 27.12 2026-05-29 23:55:48
4756 4771 3 1215 12526 25 Manicalcium Tablets NULL 2009899 4 159.0 399.0 0.0 0.0 319.0 303.81 15.19 1596.0 636.0 1276.0 2.5 30.38 2.5 30.38 0.0 0.0 1215.24 60.76 1276.0 INR 3 2.0 24.3 2026-05-29 23:55:48
4757 4772 4 1215 12526 1 Stem Cell Powder NULL 2936900 1 500.0 2499.0 0.0 0.0 1000.0 952.38 47.62 2499.0 500.0 1000.0 2.5 23.81 2.5 23.81 0.0 0.0 952.38 47.62 1000.0 INR 3 2.0 19.05 2026-05-29 23:55:48
4758 4773 5 1215 12526 34 Toothpaste NULL 33061090 6 55.0 199.0 0.0 0.0 159.0 134.75 24.25 1194.0 330.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-05-29 23:55:48
4759 4774 1 1216 12532 65 SINGLE WELLNESS NULL 94041000 1 5350.0 12999.0 0.0 0.0 10700.0 10190.48 509.52 12999.0 5350.0 10700.0 2.5 254.76 2.5 254.76 0.0 0.0 10190.48 509.52 10700.0 INR 3 2.0 203.81 2026-05-30 12:44:21
4760 4775 1 1217 12532 20 Premium Berry Juice 1000ml NULL 2936900 3 800.0 3499.0 0.0 0.0 1600.0 1523.81 76.19 10497.0 2400.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-05-30 13:37:20
4761 4776 2 1217 12532 15 KIDNEY CARE JUICE NULL 2009899 2 150.0 349.0 0.0 0.0 300.0 285.71 14.29 698.0 300.0 600.0 2.5 14.29 2.5 14.29 0.0 0.0 571.43 28.57 600.0 INR 3 2.0 11.43 2026-05-30 13:37:20
4762 4777 3 1217 12532 25 Manicalcium Tablets NULL 2009899 2 159.0 399.0 0.0 0.0 319.0 303.81 15.19 798.0 318.0 638.0 2.5 15.19 2.5 15.19 0.0 0.0 607.62 30.38 638.0 INR 3 2.0 12.15 2026-05-30 13:37:20
4763 4778 4 1217 12532 26 Spirulina Cap NULL 2009899 2 359.0 899.0 0.0 0.0 719.0 684.76 34.24 1798.0 718.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-05-30 13:37:20
4764 4779 1 1218 12526 20 Premium Berry Juice 1000ml NULL 2936900 3 800.0 3499.0 0.0 0.0 1600.0 1523.81 76.19 10497.0 2400.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-05-30 21:41:09
4765 4780 2 1218 12526 10 RADIANCE GLOW DAY CREAM NULL 33049900 1 375.0 1424.0 0.0 0.0 750.0 635.59 114.41 1424.0 375.0 750.0 9.0 57.2 9.0 57.2 0.0 0.0 635.59 114.41 750.0 INR 3 2.0 12.71 2026-05-30 21:41:09
4766 4781 3 1218 12526 34 Toothpaste NULL 33061090 12 55.0 199.0 0.0 0.0 159.0 134.75 24.25 2388.0 660.0 1908.0 9.0 145.53 9.0 145.53 0.0 0.0 1616.95 291.05 1908.0 INR 3 2.0 32.34 2026-05-30 21:41:09
4767 4782 1 1219 12545 20 Premium Berry Juice 1000ml NULL 2936900 3 800.0 3499.0 0.0 0.0 1600.0 1523.81 76.19 10497.0 2400.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-05-31 08:49:43
4768 4783 2 1219 12545 33 HALDI CHANDAN SOAP 100gm NULL 30049011 50 35.0 100.0 0.0 0.0 80.0 76.19 3.81 5000.0 1750.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-05-31 08:49:43
4769 4784 3 1219 12545 15 KIDNEY CARE JUICE NULL 2009899 4 150.0 349.0 0.0 0.0 300.0 285.71 14.29 1396.0 600.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-05-31 08:49:43
4770 4785 4 1219 12545 25 Manicalcium Tablets NULL 2009899 3 159.0 399.0 0.0 0.0 319.0 303.81 15.19 1197.0 477.0 957.0 2.5 22.79 2.5 22.79 0.0 0.0 911.43 45.57 957.0 INR 3 2.0 18.23 2026-05-31 08:49:43
4771 4786 5 1219 12545 26 Spirulina Cap NULL 2009899 3 359.0 899.0 0.0 0.0 719.0 684.76 34.24 2697.0 1077.0 2157.0 2.5 51.36 2.5 51.36 0.0 0.0 2054.29 102.71 2157.0 INR 3 2.0 41.09 2026-05-31 08:49:43
4772 4787 1 1220 12539 20 Premium Berry Juice 1000ml NULL 2936900 2 800.0 3499.0 0.0 0.0 1600.0 1523.81 76.19 6998.0 1600.0 3200.0 2.5 76.19 2.5 76.19 0.0 0.0 3047.62 152.38 3200.0 INR 3 2.0 60.95 2026-05-31 12:39:10
4773 4788 2 1220 12539 94 PAVANA DROPS NULL 30041211 1 249.0 699.0 0.0 0.0 499.0 475.24 23.76 699.0 249.0 499.0 2.5 11.88 2.5 11.88 0.0 0.0 475.24 23.76 499.0 INR 3 2.0 9.5 2026-05-31 12:39:10
4774 4789 3 1220 12539 26 Spirulina Cap NULL 2009899 1 359.0 899.0 0.0 0.0 719.0 684.76 34.24 899.0 359.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-05-31 12:39:10
4775 4790 1 1221 12539 33 HALDI CHANDAN SOAP 100gm NULL 30049011 1 35.0 100.0 0.0 0.0 80.0 76.19 3.81 100.0 35.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-05-31 12:43:52
4776 4791 1 1222 12545 4 Diabetic Care Capsules NULL 2936900 2 360.0 999.0 0.0 0.0 720.0 685.71 34.29 1998.0 720.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-05-31 21:50:53
4777 4792 2 1222 12545 34 Toothpaste NULL 33061090 5 55.0 199.0 0.0 0.0 159.0 134.75 24.25 995.0 275.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-05-31 21:50:53
4778 4793 1 1223 12545 37 Floor Cleaner 500ml NULL 3924101 7 55.0 199.0 0.0 0.0 159.0 134.75 24.25 1393.0 385.0 1113.0 9.0 84.89 9.0 84.89 0.0 0.0 943.22 169.78 1113.0 INR 3 2.0 18.86 2026-05-31 21:51:34
4779 4794 1 1224 12545 72 Pain Relief Patch NULL 30051090 1 200.0 800.0 0.0 0.0 400.0 380.95 19.05 800.0 200.0 400.0 2.5 9.52 2.5 9.52 0.0 0.0 380.95 19.05 400.0 INR 3 2.0 7.62 2026-06-01 12:06:10
4780 4795 2 1224 12545 36 Toilet Cleaner 500ml NULL 3924101 1 42.0 150.0 0.0 0.0 120.0 101.69 18.3 150.0 42.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-06-01 12:06:10
4781 4796 1 1225 12555 20 Premium Berry Juice 1000ml NULL 2936900 1 800.0 3499.0 0.0 0.0 1600.0 1523.81 76.19 3499.0 800.0 1600.0 2.5 38.1 2.5 38.1 0.0 0.0 1523.81 76.19 1600.0 INR 3 2.0 30.48 2026-06-02 17:07:58
4782 4797 1 1226 12516 68 DOUBLE WELLNESS BED 6 BY 6 SET NULL 94041000 10 9250.0 23999.0 0.0 0.0 18500.0 17619.05 880.95 239990.0 92500.0 185000.0 2.5 4404.76 2.5 4404.76 0.0 0.0 176190.48 8809.52 185000.0 INR 1 8.0 14095.24 2026-06-03 14:55:50
4783 4798 1 1227 12554 68 DOUBLE WELLNESS BED 6 BY 6 SET NULL 94041000 10 9250.0 23999.0 0.0 0.0 18500.0 17619.05 880.95 239990.0 92500.0 185000.0 2.5 4404.76 2.5 4404.76 0.0 0.0 176190.48 8809.52 185000.0 INR 2 6.0 10571.43 2026-06-03 17:02:13
4784 4799 1 1228 12554 20 Premium Berry Juice 1000ml NULL 2936900 10 800.0 3499.0 0.0 0.0 1600.0 1523.81 76.19 34990.0 8000.0 16000.0 2.5 380.95 2.5 380.95 0.0 0.0 15238.09 761.9 16000.0 INR 2 6.0 914.29 2026-06-03 17:02:33
4785 4800 1 1229 12555 20 Premium Berry Juice 1000ml NULL 2936900 5 800.0 3499.0 0.0 0.0 1600.0 1523.81 76.19 17495.0 4000.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-06-03 17:04:09
4786 4801 2 1229 12555 68 DOUBLE WELLNESS BED 6 BY 6 SET NULL 94041000 5 9250.0 23999.0 0.0 0.0 18500.0 17619.05 880.95 119995.0 46250.0 92500.0 2.5 2202.38 2.5 2202.38 0.0 0.0 88095.24 4404.76 92500.0 INR 3 2.0 1761.9 2026-06-03 17:04:09
4787 4802 1 1230 12545 52 Bhoo sanjeevni 5 kg NULL 3103100 1 625.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 1600.0 625.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-06-03 21:34:29
4788 4803 2 1230 12545 53 Terra care 2 kg NULL 3103100 1 575.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 1500.0 575.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-06-03 21:34:29
4789 4804 1 1231 12555 96 TRIM VEDA NULL 30049011 4 750.0 2500.0 0.0 0.0 1500.0 1428.57 71.43 10000.0 3000.0 6000.0 2.5 142.86 2.5 142.86 0.0 0.0 5714.29 285.71 6000.0 INR 3 2.0 114.29 2026-06-04 17:20:10
4790 4805 1 1232 12554 64 Bio magnetic bracelet NULL 9404 30 1250.0 9999.0 0.0 0.0 2500.0 2427.18 72.82 299970.0 37500.0 75000.0 1.5 1092.23 1.5 1092.23 0.0 0.0 72815.54 2184.47 75000.0 INR 2 6.0 4368.93 2026-06-05 18:57:52
4791 4806 1 1233 12555 64 Bio magnetic bracelet NULL 9404 10 1250.0 9999.0 0.0 0.0 2500.0 2427.18 72.82 99990.0 12500.0 25000.0 1.5 364.08 1.5 364.08 0.0 0.0 24271.85 728.16 25000.0 INR 3 2.0 485.44 2026-06-05 19:50:33
4792 4807 1 1234 12555 20 Premium Berry Juice 1000ml NULL 2936900 5 800.0 3499.0 0.0 0.0 1600.0 1523.81 76.19 17495.0 4000.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-06-06 12:11:14
4793 4808 1 1235 14902 27 Multicharge Cap NULL 2009899 2 600.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 2998.0 1200.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-06-07 09:38:45
4794 4809 2 1235 14902 52 Bhoo sanjeevni 5 kg NULL 3103100 1 625.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 1600.0 625.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-06-07 09:38:45
4795 4810 3 1235 14902 38 Dish Wash 500ml NULL 34029099 10 65.0 230.0 0.0 0.0 184.0 155.93 28.07 2300.0 650.0 1840.0 9.0 140.34 9.0 140.34 0.0 0.0 1559.32 280.68 1840.0 INR 3 2.0 31.19 2026-06-07 09:38:45
4796 4811 4 1235 14902 39 Fabric Wash 1000ml NULL 34029099 10 112.0 401.0 0.0 0.0 321.0 272.03 48.97 4010.0 1120.0 3210.0 9.0 244.83 9.0 244.83 0.0 0.0 2720.34 489.66 3210.0 INR 3 2.0 54.41 2026-06-07 09:38:45
4797 4812 5 1235 14902 37 Floor Cleaner 500ml NULL 3924101 10 55.0 199.0 0.0 0.0 159.0 134.75 24.25 1990.0 550.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-06-07 09:38:45
4798 4813 6 1235 14902 48 Glow it multi fruit face wash NULL 3304999 2 160.0 450.0 0.0 0.0 320.0 271.19 48.81 900.0 320.0 640.0 9.0 48.81 9.0 48.81 0.0 0.0 542.37 97.63 640.0 INR 3 2.0 10.85 2026-06-07 09:38:45
4799 4814 7 1235 14902 33 HALDI CHANDAN SOAP 100gm NULL 30049011 30 35.0 100.0 0.0 0.0 80.0 76.19 3.81 3000.0 1050.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-06-07 09:38:45
4800 4815 8 1235 14902 17 Memory Booster Juice NULL 2009899 2 150.0 349.0 0.0 0.0 300.0 285.71 14.29 698.0 300.0 600.0 2.5 14.29 2.5 14.29 0.0 0.0 571.43 28.57 600.0 INR 3 2.0 11.43 2026-06-07 09:38:45