fx_franchise_order_product

4,933 rows · 33 columns · page 20 / 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
951 964 1 103 12526 73 ENTRY BOX NULL NULL 3 0.0 3998.4 0.0 0.0 3998.4 3808.0 190.4 11995.2 0.0 11995.2 2.5 285.6 2.5 285.6 0.0 0.0 3808.0 571.2 11995.2 INR 0 0.0 0.0 2025-11-08 16:25:14
952 965 1 104 12548 52 Bhoo sanjeevni 5 kg NULL 3103100 5 450.0 1600.0 0.0 0.0 1280.0 1219.05 60.95 8000.0 2250.0 6400.0 2.5 152.38 2.5 152.38 0.0 0.0 1219.05 304.76 6400.0 INR 0 0.0 0.0 2025-11-08 16:46:05
953 966 2 104 12548 33 Herbal Soap 100gm NULL 30049011 50 28.0 100.0 0.0 0.0 80.0 76.19 3.81 5000.0 1400.0 4000.0 2.5 95.24 2.5 95.24 0.0 0.0 76.19 190.48 4000.0 INR 0 0.0 0.0 2025-11-08 16:46:05
954 967 3 104 12548 53 Terra care 2 kg NULL 3103100 5 450.0 1500.0 0.0 0.0 1200.0 1142.86 57.14 7500.0 2250.0 6000.0 2.5 142.85 2.5 142.85 0.0 0.0 1142.86 285.71 6000.0 INR 0 0.0 0.0 2025-11-08 16:46:05
955 968 1 105 12532 74 EXPLORER BOX NULL NULL 1 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 26997.0 0.0 10499.0 2.5 249.97 2.5 249.97 0.0 0.0 9999.05 499.95 10499.0 INR 0 0.0 0.0 2025-11-09 09:46:23
956 969 1 106 12517 20 Premium Berry Juice 1000ml NULL 2936900 3 750.0 3499.0 0.0 0.0 3479.0 3313.33 165.67 10497.0 2250.0 10437.0 0.0 0.0 0.0 0.0 5.0 497.0 3313.33 497.0 10437.0 INR 0 0.0 0.0 2025-11-09 12:02:35
957 970 2 106 12517 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 0.0 0.0 0.0 0.0 18.0 609.56 677.29 609.56 3996.0 INR 0 0.0 0.0 2025-11-09 12:02:35
958 971 3 106 12517 31 Vegan Plant Protein Powder NULL 21061000 3 1000.0 2999.0 0.0 0.0 2399.2 2284.95 114.25 8997.0 3000.0 7197.6 0.0 0.0 0.0 0.0 5.0 342.74 2284.95 342.74 7197.6 INR 0 0.0 0.0 2025-11-09 12:02:35
959 972 4 106 12517 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 0.0 0.0 0.0 0.0 18.0 1219.12 677.29 1219.12 7992.0 INR 0 0.0 0.0 2025-11-09 12:02:35
960 973 5 106 12517 6 Asthma Care NULL 30049011 10 250.0 899.0 0.0 0.0 719.2 684.95 34.25 8990.0 2500.0 7192.0 0.0 0.0 0.0 0.0 5.0 342.48 684.95 342.48 7192.0 INR 0 0.0 0.0 2025-11-09 12:02:35
961 974 6 106 12517 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 0.0 0.0 0.0 0.0 18.0 268.47 74.58 268.47 1760.0 INR 0 0.0 0.0 2025-11-09 12:02:35
962 975 7 106 12517 3 BP Care Capsules NULL 2936900 20 160.0 599.0 0.0 0.0 479.2 456.38 22.82 11980.0 3200.0 9584.0 0.0 0.0 0.0 0.0 5.0 456.38 456.38 456.38 9584.0 INR 0 0.0 0.0 2025-11-09 12:02:35
963 976 8 106 12517 4 Diabetic Care Capsules NULL 2936900 20 250.0 899.0 0.0 0.0 719.2 684.95 34.25 17980.0 5000.0 14384.0 0.0 0.0 0.0 0.0 5.0 684.95 684.95 684.95 14384.0 INR 0 0.0 0.0 2025-11-09 12:02:35
964 977 9 106 12517 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 0.0 0.0 0.0 0.0 5.0 380.76 1523.05 380.76 7996.0 INR 0 0.0 0.0 2025-11-09 12:02:35
965 978 10 106 12517 2 Heart Care Capsules NULL 2936900 10 425.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 14990.0 4250.0 11992.0 0.0 0.0 0.0 0.0 5.0 571.05 1142.1 571.05 11992.0 INR 0 0.0 0.0 2025-11-09 12:02:35
966 979 11 106 12517 33 Herbal Soap 100gm NULL 30049011 500 28.0 100.0 0.0 0.0 80.0 76.19 3.81 50000.0 14000.0 40000.0 0.0 0.0 0.0 0.0 5.0 1904.76 76.19 1904.76 40000.0 INR 0 0.0 0.0 2025-11-09 12:02:35
967 980 12 106 12517 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 0.0 0.0 0.0 0.0 18.0 7285.42 134.92 7285.42 47760.0 INR 0 0.0 0.0 2025-11-09 12:02:35
968 981 13 106 12517 30 Iron Capsules NULL 30049011 10 250.0 899.0 0.0 0.0 719.2 684.95 34.25 8990.0 2500.0 7192.0 0.0 0.0 0.0 0.0 5.0 342.48 684.95 342.48 7192.0 INR 0 0.0 0.0 2025-11-09 12:02:35
969 982 14 106 12517 15 Kidney Stone Juice NULL 2009899 10 120.0 349.0 0.0 0.0 279.2 265.9 13.29 3490.0 1200.0 2792.0 0.0 0.0 0.0 0.0 5.0 132.95 265.9 132.95 2792.0 INR 0 0.0 0.0 2025-11-09 12:02:35
970 983 15 106 12517 16 Liver Care Juice NULL 2009899 10 120.0 349.0 0.0 0.0 279.2 265.9 13.29 3490.0 1200.0 2792.0 0.0 0.0 0.0 0.0 5.0 132.95 265.9 132.95 2792.0 INR 0 0.0 0.0 2025-11-09 12:02:35
971 984 16 106 12517 12 Melatonin Drop NULL 2106909 10 190.0 749.0 0.0 0.0 599.2 570.67 28.53 7490.0 1900.0 5992.0 0.0 0.0 0.0 0.0 5.0 285.33 570.67 285.33 5992.0 INR 0 0.0 0.0 2025-11-09 12:02:35
972 985 17 106 12517 17 Memory Booster Juice NULL 2009899 20 120.0 349.0 0.0 0.0 279.2 265.9 13.29 6980.0 2400.0 5584.0 0.0 0.0 0.0 0.0 5.0 265.9 265.9 265.9 5584.0 INR 0 0.0 0.0 2025-11-09 12:02:35
973 986 18 106 12517 7 Morning Fresh Churan NULL 30049011 20 40.0 199.0 0.0 0.0 159.2 151.62 7.58 3980.0 800.0 3184.0 0.0 0.0 0.0 0.0 5.0 151.62 151.62 151.62 3184.0 INR 0 0.0 0.0 2025-11-09 12:02:35
974 987 19 106 12517 32 Neem Soap 100gm NULL 34011110 600 10.0 60.0 0.0 0.0 48.0 45.71 2.29 36000.0 6000.0 28800.0 0.0 0.0 0.0 0.0 5.0 1371.43 45.71 1371.43 28800.0 INR 0 0.0 0.0 2025-11-09 12:02:35
975 988 20 106 12517 9 Omega 369 NULL 2936900 20 260.0 999.0 0.0 0.0 799.2 761.14 38.06 19980.0 5200.0 15984.0 0.0 0.0 0.0 0.0 5.0 761.14 761.14 761.14 15984.0 INR 0 0.0 0.0 2025-11-09 12:02:35
976 989 21 106 12517 28 Ortho Joint Shield NULL 2009899 3 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 4497.0 1350.0 3597.6 0.0 0.0 0.0 0.0 5.0 171.31 1142.1 171.31 3597.6 INR 0 0.0 0.0 2025-11-09 12:02:35
977 990 22 106 12517 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 0.0 0.0 0.0 0.0 5.0 152.38 609.52 152.38 3200.0 INR 0 0.0 0.0 2025-11-09 12:02:35
978 991 23 106 12517 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 0.0 0.0 0.0 0.0 5.0 684.95 684.95 684.95 14384.0 INR 0 0.0 0.0 2025-11-09 12:02:35
979 992 24 106 12517 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 0.0 0.0 0.0 0.0 5.0 532.57 532.57 532.57 11184.0 INR 0 0.0 0.0 2025-11-09 12:02:35
980 993 25 106 12517 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 0.0 0.0 0.0 0.0 5.0 291.43 194.29 291.43 6120.0 INR 0 0.0 0.0 2025-11-09 12:02:35
981 994 26 106 12517 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-09 12:02:35
982 995 27 106 12517 29 Shilajith NULL 30049011 3 250.0 1800.0 0.0 0.0 1440.0 1371.43 68.57 5400.0 750.0 4320.0 0.0 0.0 0.0 0.0 5.0 205.71 1371.43 205.71 4320.0 INR 0 0.0 0.0 2025-11-09 12:02:35
983 996 28 106 12517 26 Spirulina Cap NULL 2009899 10 190.0 899.0 0.0 0.0 719.2 684.95 34.25 8990.0 1900.0 7192.0 0.0 0.0 0.0 0.0 5.0 342.48 684.95 342.48 7192.0 INR 0 0.0 0.0 2025-11-09 12:02:35
984 997 29 106 12517 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 0.0 0.0 0.0 0.0 5.0 380.8 1904.0 380.8 7996.8 INR 0 0.0 0.0 2025-11-09 12:02:35
985 998 30 106 12517 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 0.0 0.0 0.0 0.0 18.0 1706.03 473.9 1706.03 11184.0 INR 0 0.0 0.0 2025-11-09 12:02:35
986 999 31 106 12517 5 Thyro Care NULL 2936900 20 250.0 899.0 0.0 0.0 719.2 684.95 34.25 17980.0 5000.0 14384.0 0.0 0.0 0.0 0.0 5.0 684.95 684.95 684.95 14384.0 INR 0 0.0 0.0 2025-11-09 12:02:35
987 1000 32 106 12517 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 0.0 0.0 0.0 0.0 18.0 198.31 220.34 198.31 1300.0 INR 0 0.0 0.0 2025-11-09 12:02:35
988 1001 33 106 12517 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 0.0 0.0 0.0 0.0 5.0 256.8 570.67 256.8 5392.8 INR 0 0.0 0.0 2025-11-09 12:02:35
989 1002 1 107 12517 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 0.0 0.0 0.0 0.0 5.0 285.52 1142.1 285.52 5996.0 INR 0 0.0 0.0 2025-11-09 12:31:27
990 1003 2 107 12517 20 Premium Berry Juice 1000ml NULL 2936900 5 750.0 3499.0 0.0 0.0 3479.0 3313.33 165.67 17495.0 3750.0 17395.0 0.0 0.0 0.0 0.0 5.0 828.33 3313.33 828.33 17395.0 INR 0 0.0 0.0 2025-11-09 12:31:27
991 1004 3 107 12517 31 Vegan Plant Protein Powder NULL 21061000 4 1000.0 2999.0 0.0 0.0 2399.2 2284.95 114.25 11996.0 4000.0 9596.8 0.0 0.0 0.0 0.0 5.0 456.99 2284.95 456.99 9596.8 INR 0 0.0 0.0 2025-11-09 12:31:27
992 1005 4 107 12517 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 0.0 0.0 0.0 0.0 18.0 18303.86 10168.81 18303.86 119992.0 INR 0 0.0 0.0 2025-11-09 12:31:27
993 1006 5 107 12517 6 Asthma Care NULL 30049011 5 250.0 899.0 0.0 0.0 719.2 684.95 34.25 4495.0 1250.0 3596.0 0.0 0.0 0.0 0.0 5.0 171.24 684.95 171.24 3596.0 INR 0 0.0 0.0 2025-11-09 12:31:27
994 1007 6 107 12517 3 BP Care Capsules NULL 2936900 5 160.0 599.0 0.0 0.0 479.2 456.38 22.82 2995.0 800.0 2396.0 0.0 0.0 0.0 0.0 5.0 114.1 456.38 114.1 2396.0 INR 0 0.0 0.0 2025-11-09 12:31:27
995 1008 7 107 12517 4 Diabetic Care Capsules NULL 2936900 5 250.0 899.0 0.0 0.0 719.2 684.95 34.25 4495.0 1250.0 3596.0 0.0 0.0 0.0 0.0 5.0 171.24 684.95 171.24 3596.0 INR 0 0.0 0.0 2025-11-09 12:31:27
996 1009 8 107 12517 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 0.0 0.0 0.0 0.0 18.0 5613.56 155.93 5613.56 36800.0 INR 0 0.0 0.0 2025-11-09 12:31:27
997 1010 9 107 12517 39 Fabric Wash 1000ml NULL 3924101 96 150.0 401.0 0.0 0.0 320.8 271.86 48.94 38496.0 14400.0 30796.8 0.0 0.0 0.0 0.0 18.0 4697.82 271.86 4697.82 30796.8 INR 0 0.0 0.0 2025-11-09 12:31:27
998 1011 10 107 12517 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 0.0 0.0 0.0 0.0 5.0 352.14 1408.57 352.14 7395.0 INR 0 0.0 0.0 2025-11-09 12:31:27
999 1012 11 107 12517 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 0.0 0.0 0.0 0.0 18.0 4856.95 134.92 4856.95 31840.0 INR 0 0.0 0.0 2025-11-09 12:31:27
1000 1013 12 107 12517 2 Heart Care Capsules NULL 2936900 4 425.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 5996.0 1700.0 4796.8 0.0 0.0 0.0 0.0 5.0 228.42 1142.1 228.42 4796.8 INR 0 0.0 0.0 2025-11-09 12:31:27