fx_franchise_order_product

4,933 rows · 33 columns · page 77 / 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
3801 3814 32 927 12685 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-09 11:31:19
3802 3815 33 927 12685 34 Toothpaste NULL 33061090 30 0.0 199.0 0.0 0.0 159.0 134.75 24.25 5970.0 0.0 4770.0 9.0 363.81 9.0 363.81 0.0 0.0 4042.37 727.63 4770.0 INR 3 2.0 80.85 2026-02-09 11:31:19
3803 3816 34 927 12685 44 Vital Glow Face Scrub NULL 3304300 3 0.0 325.0 0.0 0.0 260.0 220.34 39.66 975.0 0.0 780.0 9.0 59.49 9.0 59.49 0.0 0.0 661.02 118.98 780.0 INR 3 2.0 13.22 2026-02-09 11:31:19
3804 3817 1 928 14569 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-09 12:23:47
3805 3818 2 928 14569 47 Premium Hair Care Shampoo NULL 3305109 2 0.0 699.0 0.0 0.0 559.0 532.38 26.62 1398.0 0.0 1118.0 2.5 26.62 2.5 26.62 0.0 0.0 1064.76 53.24 1118.0 INR 3 2.0 21.3 2026-02-09 12:23:47
3806 3819 3 928 14569 46 Root Vitality Hair Oil NULL 3305901 3 0.0 255.0 0.0 0.0 204.0 194.29 9.71 765.0 0.0 612.0 2.5 14.57 2.5 14.57 0.0 0.0 582.86 29.14 612.0 INR 3 2.0 11.66 2026-02-09 12:23:47
3807 3820 4 928 14569 35 Sanitary Pad (15 pcs) NULL 9619001 2 0.0 380.0 0.0 0.0 304.0 304.0 0.0 760.0 0.0 608.0 0.0 0.0 0.0 0.0 0.0 0.0 608.0 0.0 608.0 INR 3 2.0 12.16 2026-02-09 12:23:47
3808 3821 1 929 12516 94 PAVANA DROPS NULL 30041211 200 0.0 699.0 0.0 0.0 499.0 475.24 23.76 139800.0 0.0 99800.0 2.5 2376.19 2.5 2376.19 0.0 0.0 95047.62 4752.38 99800.0 INR 1 8.0 7603.81 2026-02-09 16:23:31
3809 3822 2 929 12516 95 STRI VEDA NULL 30049011 200 0.0 2500.0 0.0 0.0 1500.0 1428.57 71.43 500000.0 0.0 300000.0 2.5 7142.86 2.5 7142.86 0.0 0.0 285714.28 14285.71 300000.0 INR 1 8.0 22857.14 2026-02-09 16:23:31
3810 3823 3 929 12516 96 TRIM VEDA NULL 30049011 200 0.0 2500.0 0.0 0.0 1500.0 1428.57 71.43 500000.0 0.0 300000.0 2.5 7142.86 2.5 7142.86 0.0 0.0 285714.28 14285.71 300000.0 INR 1 8.0 22857.14 2026-02-09 16:23:31
3811 3824 1 930 12517 94 PAVANA DROPS NULL 30041211 100 0.0 699.0 0.0 0.0 499.0 475.24 23.76 69900.0 0.0 49900.0 0.0 0.0 0.0 0.0 5.0 2376.19 47523.81 2376.19 49900.0 INR 2 6.0 2851.43 2026-02-09 16:26:11
3812 3825 2 930 12517 95 STRI VEDA NULL 30049011 100 0.0 2500.0 0.0 0.0 1500.0 1428.57 71.43 250000.0 0.0 150000.0 0.0 0.0 0.0 0.0 5.0 7142.86 142857.14 7142.86 150000.0 INR 2 5.0 7142.86 2026-02-09 16:26:11
3813 3826 3 930 12517 96 TRIM VEDA NULL 30049011 100 0.0 2500.0 0.0 0.0 1500.0 1428.57 71.43 250000.0 0.0 150000.0 0.0 0.0 0.0 0.0 5.0 7142.86 142857.14 7142.86 150000.0 INR 2 6.0 8571.43 2026-02-09 16:26:11
3814 3827 1 931 13438 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-02-10 11:28:57
3815 3828 1 932 13438 10 RADIANCE GLOW DAY CREAM NULL 33049900 1 0.0 1424.0 0.0 0.0 750.0 635.59 114.41 1424.0 0.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-02-10 11:37:25
3816 3829 1 933 14569 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-02-10 13:07:20
3817 3830 1 934 14569 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-10 13:21:08
3818 3831 2 934 14569 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-10 13:21:08
3819 3832 3 934 14569 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-10 13:21:08
3820 3833 4 934 14569 17 Memory Booster 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-10 13:21:08
3821 3834 5 934 14569 32 Neem Soap 100gm NULL 34011110 10 0.0 60.0 0.0 0.0 48.0 45.71 2.29 600.0 0.0 480.0 2.5 11.43 2.5 11.43 0.0 0.0 457.14 22.86 480.0 INR 3 2.0 9.14 2026-02-10 13:21:08
3822 3835 1 935 14569 33 HALDI CHANDAN SOAP 100gm NULL 30049011 10 0.0 100.0 0.0 0.0 80.0 76.19 3.81 1000.0 0.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-02-10 13:22:19
3823 3836 1 936 12543 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-10 22:40:54
3824 3837 2 936 12543 32 Neem Soap 100gm NULL 34011110 10 0.0 60.0 0.0 0.0 48.0 45.71 2.29 600.0 0.0 480.0 2.5 11.43 2.5 11.43 0.0 0.0 457.14 22.86 480.0 INR 3 2.0 9.14 2026-02-10 22:40:54
3825 3838 3 936 12543 9 Omega 369 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-02-10 22:40:54
3826 3839 4 936 12543 94 PAVANA DROPS NULL 30041211 1 0.0 699.0 0.0 0.0 499.0 475.24 23.76 699.0 0.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-02-10 22:40:54
3827 3840 5 936 12543 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-10 22:40:54
3828 3841 6 936 12543 10 RADIANCE GLOW DAY CREAM NULL 33049900 2 0.0 1424.0 0.0 0.0 750.0 635.59 114.41 2848.0 0.0 1500.0 9.0 114.41 9.0 114.41 0.0 0.0 1271.19 228.81 1500.0 INR 3 2.0 25.42 2026-02-10 22:40:54
3829 3842 7 936 12543 35 Sanitary Pad (15 pcs) NULL 9619001 2 0.0 380.0 0.0 0.0 304.0 304.0 0.0 760.0 0.0 608.0 0.0 0.0 0.0 0.0 0.0 0.0 608.0 0.0 608.0 INR 3 2.0 12.16 2026-02-10 22:40:54
3830 3843 8 936 12543 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-10 22:40:54
3831 3844 1 937 12545 32 Neem Soap 100gm NULL 34011110 65 0.0 60.0 0.0 0.0 48.0 45.71 2.29 3900.0 0.0 3120.0 2.5 74.29 2.5 74.29 0.0 0.0 2971.43 148.57 3120.0 INR 3 2.0 59.43 2026-02-11 11:33:57
3832 3845 1 938 12545 46 Root Vitality Hair Oil NULL 3305901 1 0.0 255.0 0.0 0.0 204.0 194.29 9.71 255.0 0.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-02-11 11:36:45
3833 3846 1 939 12544 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-11 11:49:49
3834 3847 2 939 12544 32 Neem Soap 100gm NULL 34011110 2 0.0 60.0 0.0 0.0 48.0 45.71 2.29 120.0 0.0 96.0 2.5 2.29 2.5 2.29 0.0 0.0 91.43 4.57 96.0 INR 3 2.0 1.83 2026-02-11 11:49:49
3835 3848 3 939 12544 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-11 11:49:49
3836 3849 1 940 14569 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-11 12:41:18
3837 3850 2 940 14569 33 HALDI CHANDAN 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-02-11 12:41:18
3838 3851 3 940 14569 32 Neem Soap 100gm NULL 34011110 1 0.0 60.0 0.0 0.0 48.0 45.71 2.29 60.0 0.0 48.0 2.5 1.14 2.5 1.14 0.0 0.0 45.71 2.29 48.0 INR 3 2.0 0.91 2026-02-11 12:41:18
3839 3852 4 940 14569 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-11 12:41:18
3840 3853 1 941 12555 29 Shilajith NULL 30049011 3 0.0 1800.0 0.0 0.0 1440.0 1371.43 68.57 5400.0 0.0 4320.0 2.5 102.86 2.5 102.86 0.0 0.0 4114.29 205.71 4320.0 INR 3 0.0 2.0 2026-02-11 13:32:24
3841 3854 1 942 12554 94 PAVANA DROPS NULL 30041211 50 0.0 699.0 0.0 0.0 499.0 475.24 23.76 34950.0 0.0 24950.0 2.5 594.05 2.5 594.05 0.0 0.0 23761.9 1188.1 24950.0 INR 2 6.0 1425.71 2026-02-11 15:53:50
3842 3855 2 942 12554 95 STRI VEDA NULL 30049011 50 0.0 2500.0 0.0 0.0 1500.0 1428.57 71.43 125000.0 0.0 75000.0 2.5 1785.71 2.5 1785.71 0.0 0.0 71428.57 3571.43 75000.0 INR 2 5.0 3571.43 2026-02-11 15:53:50
3843 3856 3 942 12554 96 TRIM VEDA NULL 30049011 50 0.0 2500.0 0.0 0.0 1500.0 1428.57 71.43 125000.0 0.0 75000.0 2.5 1785.71 2.5 1785.71 0.0 0.0 71428.57 3571.43 75000.0 INR 2 6.0 4285.71 2026-02-11 15:53:50
3844 3857 1 943 12554 94 PAVANA DROPS NULL 30041211 20 0.0 699.0 0.0 0.0 499.0 475.24 23.76 13980.0 0.0 9980.0 2.5 237.62 2.5 237.62 0.0 0.0 9504.76 475.24 9980.0 INR 2 6.0 570.29 2026-02-11 15:56:50
3845 3858 2 943 12554 95 STRI VEDA NULL 30049011 20 0.0 2500.0 0.0 0.0 1500.0 1428.57 71.43 50000.0 0.0 30000.0 2.5 714.29 2.5 714.29 0.0 0.0 28571.43 1428.57 30000.0 INR 2 5.0 1428.57 2026-02-11 15:56:50
3846 3859 3 943 12554 96 TRIM VEDA NULL 30049011 20 0.0 2500.0 0.0 0.0 1500.0 1428.57 71.43 50000.0 0.0 30000.0 2.5 714.29 2.5 714.29 0.0 0.0 28571.43 1428.57 30000.0 INR 2 6.0 1714.29 2026-02-11 15:56:50
3847 3860 1 944 12555 94 PAVANA DROPS NULL 30041211 10 0.0 699.0 0.0 0.0 499.0 475.24 23.76 6990.0 0.0 4990.0 2.5 118.81 2.5 118.81 0.0 0.0 4752.38 237.62 4990.0 INR 3 2.0 95.05 2026-02-11 15:57:49
3848 3861 2 944 12555 95 STRI VEDA NULL 30049011 10 0.0 2500.0 0.0 0.0 1500.0 1428.57 71.43 25000.0 0.0 15000.0 2.5 357.14 2.5 357.14 0.0 0.0 14285.71 714.29 15000.0 INR 3 2.0 285.71 2026-02-11 15:57:49
3849 3862 3 944 12555 96 TRIM VEDA NULL 30049011 10 0.0 2500.0 0.0 0.0 1500.0 1428.57 71.43 25000.0 0.0 15000.0 2.5 357.14 2.5 357.14 0.0 0.0 14285.71 714.29 15000.0 INR 3 2.0 285.71 2026-02-11 15:57:49
3850 3863 1 945 14569 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-02-11 18:01:01