fx_franchise_order_product

4,933 rows · 33 columns · page 19 / 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
901 914 17 101 12527 5 Thyro Care NULL 2936900 2 250.0 899.0 0.0 0.0 719.2 684.95 34.25 1798.0 500.0 1438.4 2.5 34.25 2.5 34.25 0.0 0.0 684.95 68.5 1438.4 INR 0 0.0 0.0 2025-11-08 02:21:46
902 915 18 101 12527 36 Toilet Cleaner 500ml NULL 3924101 29 30.0 150.0 0.0 0.0 120.0 101.69 18.31 4350.0 870.0 3480.0 9.0 265.43 9.0 265.43 0.0 0.0 101.69 530.85 3480.0 INR 0 0.0 0.0 2025-11-08 02:21:46
903 916 1 102 12516 27 Multicharge Cap NULL 2009899 5 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 7495.0 2250.0 5996.0 2.5 142.76 2.5 142.76 0.0 0.0 1142.1 285.52 5996.0 INR 0 0.0 0.0 2025-11-08 13:26:29
904 917 2 102 12516 20 Premium Berry Juice 1000ml NULL 2936900 8 750.0 3499.0 0.0 0.0 3479.0 3313.33 165.67 27992.0 6000.0 27832.0 2.5 662.66 2.5 662.66 0.0 0.0 3313.33 1325.33 27832.0 INR 0 0.0 0.0 2025-11-08 13:26:29
905 918 3 102 12516 61 Radiation chip NULL 902221 5 325.0 999.0 0.0 0.0 799.2 677.29 121.91 4995.0 1625.0 3996.0 9.0 304.78 9.0 304.78 0.0 0.0 677.29 609.56 3996.0 INR 0 0.0 0.0 2025-11-08 13:26:29
906 919 4 102 12516 31 Vegan Plant Protein Powder NULL 21061000 7 1000.0 2999.0 0.0 0.0 2399.2 2284.95 114.25 20993.0 7000.0 16794.4 2.5 399.87 2.5 399.87 0.0 0.0 2284.95 799.73 16794.4 INR 0 0.0 0.0 2025-11-08 13:26:29
907 920 5 102 12516 79 ALKALINE JUG NULL 8421 10 3500.0 14999.0 0.0 0.0 11999.2 10168.81 1830.39 149990.0 35000.0 119992.0 9.0 9151.93 9.0 9151.93 0.0 0.0 10168.81 18303.86 119992.0 INR 0 0.0 0.0 2025-11-08 13:26:29
908 921 6 102 12516 49 Anti Dandruff Serum NULL 3304999 10 250.0 999.0 0.0 0.0 799.2 677.29 121.91 9990.0 2500.0 7992.0 9.0 609.56 9.0 609.56 0.0 0.0 677.29 1219.12 7992.0 INR 0 0.0 0.0 2025-11-08 13:26:29
909 922 7 102 12516 6 Asthma Care NULL 30049011 15 250.0 899.0 0.0 0.0 719.2 684.95 34.25 13485.0 3750.0 10788.0 2.5 256.86 2.5 256.86 0.0 0.0 684.95 513.71 10788.0 INR 0 0.0 0.0 2025-11-08 13:26:29
910 923 8 102 12516 40 Bamboo Brush NULL 96032100 20 25.0 110.0 0.0 0.0 88.0 74.58 13.42 2200.0 500.0 1760.0 9.0 134.24 9.0 134.24 0.0 0.0 74.58 268.47 1760.0 INR 0 0.0 0.0 2025-11-08 13:26:29
911 924 9 102 12516 3 BP Care Capsules NULL 2936900 25 160.0 599.0 0.0 0.0 479.2 456.38 22.82 14975.0 4000.0 11980.0 2.5 285.24 2.5 285.24 0.0 0.0 456.38 570.48 11980.0 INR 0 0.0 0.0 2025-11-08 13:26:29
912 925 10 102 12516 4 Diabetic Care Capsules NULL 2936900 25 250.0 899.0 0.0 0.0 719.2 684.95 34.25 22475.0 6250.0 17980.0 2.5 428.1 2.5 428.1 0.0 0.0 684.95 856.19 17980.0 INR 0 0.0 0.0 2025-11-08 13:26:29
913 926 11 102 12516 38 Dish Wash 500ml NULL 3924101 200 85.0 230.0 0.0 0.0 184.0 155.93 28.07 46000.0 17000.0 36800.0 9.0 2806.78 9.0 2806.78 0.0 0.0 155.93 5613.56 36800.0 INR 0 0.0 0.0 2025-11-08 13:26:29
914 927 12 102 12516 39 Fabric Wash 1000ml NULL 3924101 100 150.0 401.0 0.0 0.0 320.8 271.86 48.94 40100.0 15000.0 32080.0 9.0 2446.78 9.0 2446.78 0.0 0.0 271.86 4893.56 32080.0 INR 0 0.0 0.0 2025-11-08 13:26:29
915 928 13 102 12516 19 Fat loss Juice 500 ml NULL 30049011 5 250.0 1499.0 0.0 0.0 1479.0 1408.57 70.43 7495.0 1250.0 7395.0 2.5 176.07 2.5 176.07 0.0 0.0 1408.57 352.14 7395.0 INR 0 0.0 0.0 2025-11-08 13:26:29
916 929 14 102 12516 37 Floor Cleaner 500ml NULL 3924101 200 80.0 199.0 0.0 0.0 159.2 134.92 24.28 39800.0 16000.0 31840.0 9.0 2428.47 9.0 2428.47 0.0 0.0 134.92 4856.95 31840.0 INR 0 0.0 0.0 2025-11-08 13:26:29
917 930 15 102 12516 60 Foot patch NULL 30051090 5 500.0 1999.0 0.0 0.0 1599.2 1523.05 76.15 9995.0 2500.0 7996.0 2.5 190.38 2.5 190.38 0.0 0.0 1523.05 380.76 7996.0 INR 0 0.0 0.0 2025-11-08 13:26:29
918 931 16 102 12516 2 Heart Care Capsules NULL 2936900 14 425.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 20986.0 5950.0 16788.8 2.5 399.74 2.5 399.74 0.0 0.0 1142.1 799.47 16788.8 INR 0 0.0 0.0 2025-11-08 13:26:29
919 932 17 102 12516 33 Herbal Soap 100gm NULL 30049011 502 28.0 100.0 0.0 0.0 80.0 76.19 3.81 50200.0 14056.0 40160.0 2.5 956.19 2.5 956.19 0.0 0.0 76.19 1912.38 40160.0 INR 0 0.0 0.0 2025-11-08 13:26:29
920 933 18 102 12516 34 Herbo2o Toothpaste NULL 33061090 300 45.0 199.0 0.0 0.0 159.2 134.92 24.28 59700.0 13500.0 47760.0 9.0 3642.71 9.0 3642.71 0.0 0.0 134.92 7285.42 47760.0 INR 0 0.0 0.0 2025-11-08 13:26:29
921 934 19 102 12516 24 Immunomax 24/7 Caps NULL 2009899 5 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 7495.0 2250.0 5996.0 2.5 142.76 2.5 142.76 0.0 0.0 1142.1 285.52 5996.0 INR 0 0.0 0.0 2025-11-08 13:26:29
922 935 20 102 12516 30 Iron Capsules NULL 30049011 15 250.0 899.0 0.0 0.0 719.2 684.95 34.25 13485.0 3750.0 10788.0 2.5 256.86 2.5 256.86 0.0 0.0 684.95 513.71 10788.0 INR 0 0.0 0.0 2025-11-08 13:26:29
923 936 21 102 12516 15 Kidney Stone Juice NULL 2009899 15 120.0 349.0 0.0 0.0 279.2 265.9 13.3 5235.0 1800.0 4188.0 2.5 99.72 2.5 99.72 0.0 0.0 265.9 199.43 4188.0 INR 0 0.0 0.0 2025-11-08 13:26:29
924 937 22 102 12516 18 Lady Care Juice 500ml NULL 2009899 5 250.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 7495.0 1250.0 5996.0 2.5 142.76 2.5 142.76 0.0 0.0 1142.1 285.52 5996.0 INR 0 0.0 0.0 2025-11-08 13:26:29
925 938 23 102 12516 16 Liver Care Juice NULL 2009899 15 120.0 349.0 0.0 0.0 279.2 265.9 13.3 5235.0 1800.0 4188.0 2.5 99.72 2.5 99.72 0.0 0.0 265.9 199.43 4188.0 INR 0 0.0 0.0 2025-11-08 13:26:29
926 939 24 102 12516 25 Manicalcium Tablets NULL 2009899 5 95.0 399.0 0.0 0.0 319.2 304.0 15.2 1995.0 475.0 1596.0 2.5 38.0 2.5 38.0 0.0 0.0 304.0 76.0 1596.0 INR 0 0.0 0.0 2025-11-08 13:26:29
927 940 25 102 12516 12 Melatonin Drop NULL 2106909 15 190.0 749.0 0.0 0.0 599.2 570.67 28.53 11235.0 2850.0 8988.0 2.5 214.0 2.5 214.0 0.0 0.0 570.67 428.0 8988.0 INR 0 0.0 0.0 2025-11-08 13:26:29
928 941 26 102 12516 17 Memory Booster Juice NULL 2009899 25 120.0 349.0 0.0 0.0 279.2 265.9 13.3 8725.0 3000.0 6980.0 2.5 166.19 2.5 166.19 0.0 0.0 265.9 332.38 6980.0 INR 0 0.0 0.0 2025-11-08 13:26:29
929 942 27 102 12516 7 Morning Fresh Churan NULL 30049011 25 40.0 199.0 0.0 0.0 159.2 151.62 7.58 4975.0 1000.0 3980.0 2.5 94.76 2.5 94.76 0.0 0.0 151.62 189.52 3980.0 INR 0 0.0 0.0 2025-11-08 13:26:29
930 943 28 102 12516 32 Neem Soap 100gm NULL 34011110 601 10.0 60.0 0.0 0.0 48.0 45.71 2.29 36060.0 6010.0 28848.0 2.5 686.86 2.5 686.86 0.0 0.0 45.71 1373.71 28848.0 INR 0 0.0 0.0 2025-11-08 13:26:29
931 944 29 102 12516 9 Omega 369 NULL 2936900 25 260.0 999.0 0.0 0.0 799.2 761.14 38.06 24975.0 6500.0 19980.0 2.5 475.71 2.5 475.71 0.0 0.0 761.14 951.43 19980.0 INR 0 0.0 0.0 2025-11-08 13:26:29
932 945 30 102 12516 28 Ortho Joint Shield NULL 2009899 8 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 11992.0 3600.0 9593.6 2.5 228.42 2.5 228.42 0.0 0.0 1142.1 456.84 9593.6 INR 0 0.0 0.0 2025-11-08 13:26:29
933 946 31 102 12516 72 Pain Relief Patch NULL 30051090 5 200.0 800.0 0.0 0.0 640.0 609.52 30.48 4000.0 1000.0 3200.0 2.5 76.19 2.5 76.19 0.0 0.0 609.52 152.38 3200.0 INR 0 0.0 0.0 2025-11-08 13:26:29
934 947 32 102 12516 8 Piles Care NULL 30049011 20 250.0 899.0 0.0 0.0 719.2 684.95 34.25 17980.0 5000.0 14384.0 2.5 342.48 2.5 342.48 0.0 0.0 684.95 684.95 14384.0 INR 0 0.0 0.0 2025-11-08 13:26:29
935 948 33 102 12516 41 Premium Coco Body Lotion NULL 3304300 1 250.0 699.0 0.0 0.0 559.2 473.9 85.3 699.0 250.0 559.2 9.0 42.65 9.0 42.65 0.0 0.0 473.9 85.3 559.2 INR 0 0.0 0.0 2025-11-08 13:26:29
936 949 34 102 12516 14 Premium Aloe Vera VEG caps NULL 2936900 5 100.0 359.0 0.0 0.0 287.2 273.52 13.68 1795.0 500.0 1436.0 2.5 34.19 2.5 34.19 0.0 0.0 273.52 68.38 1436.0 INR 0 0.0 0.0 2025-11-08 13:26:29
937 950 35 102 12516 47 Premium Hair Care Shampoo NULL 3305109 20 150.0 699.0 0.0 0.0 559.2 532.57 26.63 13980.0 3000.0 11184.0 2.5 266.29 2.5 266.29 0.0 0.0 532.57 532.57 11184.0 INR 0 0.0 0.0 2025-11-08 13:26:29
938 951 36 102 12516 13 Premium NONI VEG caps NULL 2936900 5 150.0 501.0 0.0 0.0 400.8 381.71 19.09 2505.0 750.0 2004.0 2.5 47.72 2.5 47.72 0.0 0.0 381.71 95.43 2004.0 INR 0 0.0 0.0 2025-11-08 13:26:29
939 952 37 102 12516 43 Quench Kiss Lip Balm NULL 3304300 5 35.0 199.0 0.0 0.0 159.2 134.92 24.28 995.0 175.0 796.0 9.0 60.71 9.0 60.71 0.0 0.0 134.92 121.42 796.0 INR 0 0.0 0.0 2025-11-08 13:26:29
940 953 38 102 12516 46 Root Vitality Hair Oil NULL 3305901 30 54.0 255.0 0.0 0.0 204.0 194.29 9.71 7650.0 1620.0 6120.0 2.5 145.72 2.5 145.72 0.0 0.0 194.29 291.43 6120.0 INR 0 0.0 0.0 2025-11-08 13:26:29
941 954 39 102 12516 35 Sanitary Pad (15 pcs) NULL 9619001 200 40.0 380.0 0.0 0.0 304.0 304.0 0.0 76000.0 8000.0 60800.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 60800.0 INR 0 0.0 0.0 2025-11-08 13:26:29
942 955 40 102 12516 29 Shilajith NULL 30049011 8 250.0 1800.0 0.0 0.0 1440.0 1371.43 68.57 14400.0 2000.0 11520.0 2.5 274.29 2.5 274.29 0.0 0.0 1371.43 548.57 11520.0 INR 0 0.0 0.0 2025-11-08 13:26:29
943 956 41 102 12516 26 Spirulina Cap NULL 2009899 15 190.0 899.0 0.0 0.0 719.2 684.95 34.25 13485.0 2850.0 10788.0 2.5 256.86 2.5 256.86 0.0 0.0 684.95 513.71 10788.0 INR 0 0.0 0.0 2025-11-08 13:26:29
944 957 42 102 12516 1 Stem Cell Powder NULL 2936900 4 749.0 2499.0 0.0 0.0 1999.2 1904.0 95.2 9996.0 2996.0 7996.8 2.5 190.4 2.5 190.4 0.0 0.0 1904.0 380.8 7996.8 INR 0 0.0 0.0 2025-11-08 13:26:29
945 958 43 102 12516 50 Sun Screen NULL 330499 20 250.0 699.0 0.0 0.0 559.2 473.9 85.3 13980.0 5000.0 11184.0 9.0 853.01 9.0 853.01 0.0 0.0 473.9 1706.03 11184.0 INR 0 0.0 0.0 2025-11-08 13:26:29
946 959 44 102 12516 5 Thyro Care NULL 2936900 25 250.0 899.0 0.0 0.0 719.2 684.95 34.25 22475.0 6250.0 17980.0 2.5 428.1 2.5 428.1 0.0 0.0 684.95 856.19 17980.0 INR 0 0.0 0.0 2025-11-08 13:26:29
947 960 45 102 12516 36 Toilet Cleaner 500ml NULL 3924101 200 30.0 150.0 0.0 0.0 120.0 101.69 18.31 30000.0 6000.0 24000.0 9.0 1830.51 9.0 1830.51 0.0 0.0 101.69 3661.02 24000.0 INR 0 0.0 0.0 2025-11-08 13:26:29
948 961 46 102 12516 44 Vital Glow Face Scrub NULL 3304300 5 71.0 325.0 0.0 0.0 260.0 220.34 39.66 1625.0 355.0 1300.0 9.0 99.16 9.0 99.16 0.0 0.0 220.34 198.31 1300.0 INR 0 0.0 0.0 2025-11-08 13:26:29
949 962 47 102 12516 11 Vitamin B12 Drop NULL 2106909 3 190.0 749.0 0.0 0.0 599.2 570.67 28.53 2247.0 570.0 1797.6 2.5 42.8 2.5 42.8 0.0 0.0 570.67 85.6 1797.6 INR 0 0.0 0.0 2025-11-08 13:26:29
950 963 48 102 12516 10 Vitamin D3 Drop NULL 2106909 9 190.0 749.0 0.0 0.0 599.2 570.67 28.53 6741.0 1710.0 5392.8 2.5 128.4 2.5 128.4 0.0 0.0 570.67 256.8 5392.8 INR 0 0.0 0.0 2025-11-08 13:26:29