fx_franchise_order_product

4,933 rows · 33 columns · page 95 / 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
4701 4716 8 1197 12526 10 RADIANCE GLOW DAY CREAM NULL 33049900 3 375.0 1424.0 0.0 0.0 750.0 635.59 114.41 4272.0 1125.0 2250.0 9.0 171.61 9.0 171.61 0.0 0.0 1906.78 343.22 2250.0 INR 3 2.0 38.14 2026-05-20 21:02:32
4702 4717 9 1197 12526 35 Sanitary Pad (15 pcs) NULL 9619001 5 150.0 380.0 0.0 0.0 304.0 304.0 0.0 1900.0 750.0 1520.0 0.0 0.0 0.0 0.0 0.0 0.0 1520.0 0.0 1520.0 INR 3 2.0 30.4 2026-05-20 21:02:32
4703 4718 1 1198 12545 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-21 05:48:12
4704 4719 2 1198 12545 47 Premium Hair Care Shampoo NULL 3305109 1 279.0 699.0 0.0 0.0 559.0 532.38 26.62 699.0 279.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-05-21 05:48:12
4705 4720 1 1199 12539 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-05-21 14:28:32
4706 4721 2 1199 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-21 14:28:32
4707 4722 1 1200 14079 33 HALDI CHANDAN SOAP 100gm NULL 30049011 12 35.0 100.0 0.0 0.0 80.0 76.19 3.81 1200.0 420.0 960.0 2.5 22.86 2.5 22.86 0.0 0.0 914.29 45.71 960.0 INR 3 2.0 18.29 2026-05-21 19:41:17
4708 4723 2 1200 14079 15 KIDNEY CARE JUICE NULL 2009899 1 150.0 349.0 0.0 0.0 300.0 285.71 14.29 349.0 150.0 300.0 2.5 7.14 2.5 7.14 0.0 0.0 285.71 14.29 300.0 INR 3 2.0 5.71 2026-05-21 19:41:17
4709 4724 1 1201 12545 37 Floor Cleaner 500ml NULL 3924101 1 55.0 199.0 0.0 0.0 159.0 134.75 24.25 199.0 55.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-21 20:36:55
4710 4725 2 1201 12545 33 HALDI CHANDAN SOAP 100gm NULL 30049011 10 35.0 100.0 0.0 0.0 80.0 76.19 3.81 1000.0 350.0 800.0 2.5 19.05 2.5 19.05 0.0 0.0 761.9 38.1 800.0 INR 3 2.0 15.24 2026-05-21 20:36:55
4711 4726 3 1201 12545 9 Omega 369 NULL 2936900 1 360.0 999.0 0.0 0.0 720.0 685.71 34.29 999.0 360.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-05-21 20:36:55
4712 4727 4 1201 12545 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-21 20:36:55
4713 4728 5 1201 12545 46 Root Vitality Hair Oil NULL 3305901 6 102.0 255.0 0.0 0.0 204.0 194.29 9.71 1530.0 612.0 1224.0 2.5 29.14 2.5 29.14 0.0 0.0 1165.71 58.29 1224.0 INR 3 2.0 23.31 2026-05-21 20:36:55
4714 4729 1 1202 12517 48 Glow it multi fruit face wash NULL 3304999 20 160.0 450.0 0.0 0.0 320.0 271.19 48.81 9000.0 3200.0 6400.0 0.0 0.0 0.0 0.0 18.0 976.27 5423.73 976.27 6400.0 INR 2 6.0 325.42 2026-05-21 21:00:05
4715 4730 1 1203 12545 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-05-21 21:28:30
4716 4731 2 1203 12545 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-21 21:28:30
4717 4732 1 1204 12555 64 Bio magnetic bracelet NULL 9404 4 1250.0 9999.0 0.0 0.0 2500.0 2427.18 72.82 39996.0 5000.0 10000.0 1.5 145.63 1.5 145.63 0.0 0.0 9708.74 291.26 10000.0 INR 3 2.0 194.17 2026-05-22 14:06:55
4718 4733 1 1205 12554 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 2 6.0 1456.31 2026-05-22 17:41:45
4719 4734 1 1206 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-05-22 17:43:22
4720 4735 1 1207 12539 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-05-23 16:18:38
4721 4736 2 1207 12539 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-23 16:18:38
4722 4737 1 1208 12545 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-23 16:38:13
4723 4738 1 1209 14902 49 Anti Dandruff Serum NULL 3304999 1 399.0 999.0 0.0 0.0 799.0 677.12 121.88 999.0 399.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-05-24 13:03:29
4724 4739 2 1209 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-05-24 13:03:29
4725 4740 3 1209 14902 39 Fabric Wash 1000ml NULL 34029099 2 112.0 401.0 0.0 0.0 321.0 272.03 48.97 802.0 224.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-05-24 13:03:29
4726 4741 4 1209 14902 37 Floor Cleaner 500ml NULL 3924101 2 55.0 199.0 0.0 0.0 159.0 134.75 24.25 398.0 110.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-05-24 13:03:29
4727 4742 5 1209 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-05-24 13:03:29
4728 4743 6 1209 14902 28 Ortho Joint Shield 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-05-24 13:03:29
4729 4744 7 1209 14902 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-24 13:03:29
4730 4745 8 1209 14902 46 Root Vitality Hair Oil NULL 3305901 1 102.0 255.0 0.0 0.0 204.0 194.29 9.71 255.0 102.0 204.0 2.5 4.86 2.5 4.86 0.0 0.0 194.29 9.71 204.0 INR 3 2.0 3.89 2026-05-24 13:03:29
4731 4746 9 1209 14902 95 STRI VEDA NULL 30049011 1 750.0 2500.0 0.0 0.0 1500.0 1428.57 71.43 2500.0 750.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-05-24 13:03:29
4732 4747 10 1209 14902 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-05-24 13:03:29
4733 4748 11 1209 14902 36 Toilet Cleaner 500ml NULL 3924101 2 42.0 150.0 0.0 0.0 120.0 101.69 18.31 300.0 84.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-05-24 13:03:29
4734 4749 1 1210 14902 49 Anti Dandruff Serum NULL 3304999 1 399.0 999.0 0.0 0.0 799.0 677.12 121.88 999.0 399.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-05-24 23:19:14
4735 4750 2 1210 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-05-24 23:19:14
4736 4751 3 1210 14902 39 Fabric Wash 1000ml NULL 34029099 2 112.0 401.0 0.0 0.0 321.0 272.03 48.97 802.0 224.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-05-24 23:19:14
4737 4752 4 1210 14902 37 Floor Cleaner 500ml NULL 3924101 2 55.0 199.0 0.0 0.0 159.0 134.75 24.25 398.0 110.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-05-24 23:19:14
4738 4753 5 1210 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-05-24 23:19:14
4739 4754 6 1210 14902 28 Ortho Joint Shield 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-05-24 23:19:14
4740 4755 7 1210 14902 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-24 23:19:14
4741 4756 8 1210 14902 46 Root Vitality Hair Oil NULL 3305901 1 102.0 255.0 0.0 0.0 204.0 194.29 9.71 255.0 102.0 204.0 2.5 4.86 2.5 4.86 0.0 0.0 194.29 9.71 204.0 INR 3 2.0 3.89 2026-05-24 23:19:14
4742 4757 9 1210 14902 95 STRI VEDA NULL 30049011 1 750.0 2500.0 0.0 0.0 1500.0 1428.57 71.43 2500.0 750.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-05-24 23:19:14
4743 4758 10 1210 14902 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-05-24 23:19:14
4744 4759 11 1210 14902 36 Toilet Cleaner 500ml NULL 3924101 2 42.0 150.0 0.0 0.0 120.0 101.69 18.31 300.0 84.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-05-24 23:19:14
4745 4760 1 1211 12539 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-05-28 04:00:28
4746 4761 2 1211 12539 4 Diabetic Care Capsules NULL 2936900 1 360.0 999.0 0.0 0.0 720.0 685.71 34.29 999.0 360.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-05-28 04:00:28
4747 4762 3 1211 12539 39 Fabric Wash 1000ml NULL 34029099 1 112.0 401.0 0.0 0.0 321.0 272.03 48.97 401.0 112.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-05-28 04:00:28
4748 4763 1 1212 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-28 20:44:51
4749 4764 1 1213 12539 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-05-29 15:53:20
4750 4765 2 1213 12539 37 Floor Cleaner 500ml NULL 3924101 1 55.0 199.0 0.0 0.0 159.0 134.75 24.25 199.0 55.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