fx_franchise_order_product

4,933 rows · 33 columns · page 18 / 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
851 864 15 91 12548 35 Sanitary Pad (15 pcs) NULL 9619001 3 40.0 380.0 0.0 0.0 304.0 304.0 0.0 1140.0 120.0 912.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 912.0 INR 0 0.0 0.0 2025-11-07 23:54:32
852 865 16 91 12548 1 Stem Cell Powder NULL 2936900 2 749.0 2499.0 0.0 0.0 1999.2 1904.0 95.2 4998.0 1498.0 3998.4 2.5 95.2 2.5 95.2 0.0 0.0 1904.0 190.4 3998.4 INR 0 0.0 0.0 2025-11-07 23:54:32
853 866 17 91 12548 50 Sun Screen NULL 330499 3 250.0 699.0 0.0 0.0 559.2 473.9 85.3 2097.0 750.0 1677.6 9.0 127.95 9.0 127.95 0.0 0.0 473.9 255.91 1677.6 INR 0 0.0 0.0 2025-11-07 23:54:32
854 867 18 91 12548 53 Terra care 2 kg NULL 3103100 4 450.0 1500.0 0.0 0.0 1200.0 1142.86 57.14 6000.0 1800.0 4800.0 2.5 114.28 2.5 114.28 0.0 0.0 1142.86 228.57 4800.0 INR 0 0.0 0.0 2025-11-07 23:54:32
855 868 19 91 12548 36 Toilet Cleaner 500ml NULL 3924101 1 30.0 150.0 0.0 0.0 120.0 101.69 18.31 150.0 30.0 120.0 9.0 9.15 9.0 9.15 0.0 0.0 101.69 18.31 120.0 INR 0 0.0 0.0 2025-11-07 23:54:32
856 869 20 91 12548 11 Vitamin B12 Drop NULL 2106909 1 190.0 749.0 0.0 0.0 599.2 570.67 28.53 749.0 190.0 599.2 2.5 14.27 2.5 14.27 0.0 0.0 570.67 28.53 599.2 INR 0 0.0 0.0 2025-11-07 23:54:32
857 870 1 92 12517 49 Anti Dandruff Serum NULL 3304999 20 250.0 999.0 0.0 0.0 799.2 677.29 121.91 19980.0 5000.0 15984.0 0.0 0.0 0.0 0.0 18.0 2438.24 677.29 2438.24 15984.0 INR 0 0.0 0.0 2025-11-08 00:04:03
858 871 2 92 12517 44 Vital Glow Face Scrub NULL 3304300 20 71.0 325.0 0.0 0.0 260.0 220.34 39.66 6500.0 1420.0 5200.0 0.0 0.0 0.0 0.0 18.0 793.22 220.34 793.22 5200.0 INR 0 0.0 0.0 2025-11-08 00:04:03
859 872 1 93 12516 49 Anti Dandruff Serum NULL 3304999 25 250.0 999.0 0.0 0.0 799.2 677.29 121.91 24975.0 6250.0 19980.0 9.0 1523.9 9.0 1523.9 0.0 0.0 677.29 3047.8 19980.0 INR 0 0.0 0.0 2025-11-08 00:05:04
860 873 2 93 12516 44 Vital Glow Face Scrub NULL 3304300 25 71.0 325.0 0.0 0.0 260.0 220.34 39.66 8125.0 1775.0 6500.0 9.0 495.76 9.0 495.76 0.0 0.0 220.34 991.53 6500.0 INR 0 0.0 0.0 2025-11-08 00:05:04
861 874 1 94 12517 48 glow face wash NULL 3304999 50 250.0 380.0 0.0 0.0 304.0 257.63 46.37 19000.0 12500.0 15200.0 0.0 0.0 0.0 0.0 18.0 2318.64 257.63 2318.64 15200.0 INR 0 0.0 0.0 2025-11-08 00:08:24
862 875 1 95 12516 48 glow face wash NULL 3304999 50 250.0 380.0 0.0 0.0 304.0 257.63 46.37 19000.0 12500.0 15200.0 9.0 1159.32 9.0 1159.32 0.0 0.0 257.63 2318.64 15200.0 INR 0 0.0 0.0 2025-11-08 00:08:40
863 876 1 96 12517 44 Vital Glow Face Scrub NULL 3304300 50 71.0 325.0 0.0 0.0 260.0 220.34 39.66 16250.0 3550.0 13000.0 0.0 0.0 0.0 0.0 18.0 1983.05 220.34 1983.05 13000.0 INR 0 0.0 0.0 2025-11-08 00:11:02
864 877 1 97 12516 44 Vital Glow Face Scrub NULL 3304300 50 71.0 325.0 0.0 0.0 260.0 220.34 39.66 16250.0 3550.0 13000.0 9.0 991.52 9.0 991.52 0.0 0.0 220.34 1983.05 13000.0 INR 0 0.0 0.0 2025-11-08 00:11:41
865 878 1 98 12530 48 glow face wash NULL 3304999 2 250.0 380.0 0.0 0.0 304.0 257.63 46.38 760.0 500.0 608.0 9.0 46.38 9.0 46.38 0.0 0.0 257.63 92.75 608.0 INR 0 0.0 0.0 2025-11-08 00:24:38
866 879 2 98 12530 38 Dish Wash 500ml NULL 3924101 3 85.0 230.0 0.0 0.0 184.0 155.93 28.07 690.0 255.0 552.0 9.0 42.1 9.0 42.1 0.0 0.0 155.93 84.2 552.0 INR 0 0.0 0.0 2025-11-08 00:24:38
867 880 3 98 12530 37 Floor Cleaner 500ml NULL 3924101 2 80.0 199.0 0.0 0.0 159.2 134.92 24.29 398.0 160.0 318.4 9.0 24.29 9.0 24.29 0.0 0.0 134.92 48.57 318.4 INR 0 0.0 0.0 2025-11-08 00:24:38
868 881 4 98 12530 34 Herbo2o Toothpaste NULL 33061090 20 45.0 199.0 0.0 0.0 159.2 134.92 24.28 3980.0 900.0 3184.0 9.0 242.84 9.0 242.84 0.0 0.0 134.92 485.69 3184.0 INR 0 0.0 0.0 2025-11-08 00:24:38
869 882 5 98 12530 46 Root Vitality Hair Oil NULL 3305901 6 54.0 255.0 0.0 0.0 204.0 194.29 9.71 1530.0 324.0 1224.0 2.5 29.14 2.5 29.14 0.0 0.0 194.29 58.29 1224.0 INR 0 0.0 0.0 2025-11-08 00:24:38
870 883 6 98 12530 36 Toilet Cleaner 500ml NULL 3924101 13 30.0 150.0 0.0 0.0 120.0 101.69 18.31 1950.0 390.0 1560.0 9.0 118.98 9.0 118.98 0.0 0.0 101.69 237.97 1560.0 INR 0 0.0 0.0 2025-11-08 00:24:38
871 884 1 99 12521 79 ALKALINE JUG NULL 8421 1 3500.0 14999.0 0.0 0.0 11999.2 10168.81 1830.39 14999.0 3500.0 11999.2 9.0 915.2 9.0 915.2 0.0 0.0 10168.81 1830.39 11999.2 INR 0 0.0 0.0 2025-11-08 00:35:07
872 885 2 99 12521 3 BP Care Capsules NULL 2936900 2 160.0 599.0 0.0 0.0 479.2 456.38 22.82 1198.0 320.0 958.4 2.5 22.82 2.5 22.82 0.0 0.0 456.38 45.64 958.4 INR 0 0.0 0.0 2025-11-08 00:35:07
873 886 3 99 12521 38 Dish Wash 500ml NULL 3924101 3 85.0 230.0 0.0 0.0 184.0 155.93 28.07 690.0 255.0 552.0 9.0 42.1 9.0 42.1 0.0 0.0 155.93 84.2 552.0 INR 0 0.0 0.0 2025-11-08 00:35:07
874 887 4 99 12521 39 Fabric Wash 1000ml NULL 3924101 3 150.0 401.0 0.0 0.0 320.8 271.86 48.94 1203.0 450.0 962.4 9.0 73.41 9.0 73.41 0.0 0.0 271.86 146.81 962.4 INR 0 0.0 0.0 2025-11-08 00:35:07
875 888 5 99 12521 60 Foot patch NULL 30051090 1 500.0 1999.0 0.0 0.0 1599.2 1523.05 76.15 1999.0 500.0 1599.2 2.5 38.08 2.5 38.08 0.0 0.0 1523.05 76.15 1599.2 INR 0 0.0 0.0 2025-11-08 00:35:07
876 889 6 99 12521 33 Herbal Soap 100gm NULL 30049011 24 28.0 100.0 0.0 0.0 80.0 76.19 3.81 2400.0 672.0 1920.0 2.5 45.72 2.5 45.72 0.0 0.0 76.19 91.43 1920.0 INR 0 0.0 0.0 2025-11-08 00:35:07
877 890 7 99 12521 7 Morning Fresh Churan NULL 30049011 6 40.0 199.0 0.0 0.0 159.2 151.62 7.58 1194.0 240.0 955.2 2.5 22.75 2.5 22.75 0.0 0.0 151.62 45.49 955.2 INR 0 0.0 0.0 2025-11-08 00:35:07
878 891 8 99 12521 32 Neem Soap 100gm NULL 34011110 50 10.0 60.0 0.0 0.0 48.0 45.71 2.29 3000.0 500.0 2400.0 2.5 57.15 2.5 57.15 0.0 0.0 45.71 114.29 2400.0 INR 0 0.0 0.0 2025-11-08 00:35:07
879 892 9 99 12521 72 Pain Relief Patch NULL 30051090 1 200.0 800.0 0.0 0.0 640.0 609.52 30.48 800.0 200.0 640.0 2.5 15.24 2.5 15.24 0.0 0.0 609.52 30.48 640.0 INR 0 0.0 0.0 2025-11-08 00:35:07
880 893 10 99 12521 35 Sanitary Pad (15 pcs) NULL 9619001 3 40.0 380.0 0.0 0.0 304.0 304.0 0.0 1140.0 120.0 912.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 912.0 INR 0 0.0 0.0 2025-11-08 00:35:07
881 894 11 99 12521 1 Stem Cell Powder NULL 2936900 2 749.0 2499.0 0.0 0.0 1999.2 1904.0 95.2 4998.0 1498.0 3998.4 2.5 95.2 2.5 95.2 0.0 0.0 1904.0 190.4 3998.4 INR 0 0.0 0.0 2025-11-08 00:35:07
882 895 1 100 12527 33 Herbal Soap 100gm NULL 30049011 154 28.0 100.0 0.0 0.0 80.0 76.19 3.81 15400.0 4312.0 12320.0 2.5 293.33 2.5 293.33 0.0 0.0 76.19 586.67 12320.0 INR 0 0.0 0.0 2025-11-08 02:09:55
883 896 2 100 12527 34 Herbo2o Toothpaste NULL 33061090 36 45.0 199.0 0.0 0.0 159.2 134.92 24.28 7164.0 1620.0 5731.2 9.0 437.12 9.0 437.12 0.0 0.0 134.92 874.25 5731.2 INR 0 0.0 0.0 2025-11-08 02:09:55
884 897 3 100 12527 32 Neem Soap 100gm NULL 34011110 236 10.0 60.0 0.0 0.0 48.0 45.71 2.29 14160.0 2360.0 11328.0 2.5 269.71 2.5 269.71 0.0 0.0 45.71 539.43 11328.0 INR 0 0.0 0.0 2025-11-08 02:09:55
885 898 1 101 12527 70 Premium Hand belt NULL 9404 1 600.0 9999.0 0.0 0.0 1440.0 1371.43 68.57 9999.0 600.0 1440.0 2.5 34.28 2.5 34.28 0.0 0.0 1371.43 68.57 1440.0 INR 0 0.0 0.0 2025-11-08 02:21:46
886 899 2 101 12527 6 Asthma Care NULL 30049011 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
887 900 3 101 12527 3 BP Care Capsules NULL 2936900 10 160.0 599.0 0.0 0.0 479.2 456.38 22.82 5990.0 1600.0 4792.0 2.5 114.09 2.5 114.09 0.0 0.0 456.38 228.19 4792.0 INR 0 0.0 0.0 2025-11-08 02:21:46
888 901 4 101 12527 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 2.5 85.62 2.5 85.62 0.0 0.0 684.95 171.24 3596.0 INR 0 0.0 0.0 2025-11-08 02:21:46
889 902 5 101 12527 38 Dish Wash 500ml NULL 3924101 49 85.0 230.0 0.0 0.0 184.0 155.93 28.07 11270.0 4165.0 9016.0 9.0 687.66 9.0 687.66 0.0 0.0 155.93 1375.32 9016.0 INR 0 0.0 0.0 2025-11-08 02:21:46
890 903 6 101 12527 39 Fabric Wash 1000ml NULL 3924101 25 150.0 401.0 0.0 0.0 320.8 271.86 48.94 10025.0 3750.0 8020.0 9.0 611.7 9.0 611.7 0.0 0.0 271.86 1223.39 8020.0 INR 0 0.0 0.0 2025-11-08 02:21:46
891 904 7 101 12527 37 Floor Cleaner 500ml NULL 3924101 22 80.0 199.0 0.0 0.0 159.2 134.92 24.28 4378.0 1760.0 3502.4 9.0 267.13 9.0 267.13 0.0 0.0 134.92 534.26 3502.4 INR 0 0.0 0.0 2025-11-08 02:21:46
892 905 8 101 12527 60 Foot patch NULL 30051090 2 500.0 1999.0 0.0 0.0 1599.2 1523.05 76.15 3998.0 1000.0 3198.4 2.5 76.15 2.5 76.15 0.0 0.0 1523.05 152.3 3198.4 INR 0 0.0 0.0 2025-11-08 02:21:46
893 906 9 101 12527 7 Morning Fresh Churan NULL 30049011 19 40.0 199.0 0.0 0.0 159.2 151.62 7.58 3781.0 760.0 3024.8 2.5 72.02 2.5 72.02 0.0 0.0 151.62 144.04 3024.8 INR 0 0.0 0.0 2025-11-08 02:21:46
894 907 10 101 12527 9 Omega 369 NULL 2936900 2 260.0 999.0 0.0 0.0 799.2 761.14 38.05 1998.0 520.0 1598.4 2.5 38.05 2.5 38.05 0.0 0.0 761.14 76.11 1598.4 INR 0 0.0 0.0 2025-11-08 02:21:46
895 908 11 101 12527 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 2.5 85.66 2.5 85.66 0.0 0.0 1142.1 171.31 3597.6 INR 0 0.0 0.0 2025-11-08 02:21:46
896 909 12 101 12527 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 02:21:46
897 910 13 101 12527 8 Piles Care NULL 30049011 5 250.0 899.0 0.0 0.0 719.2 684.95 34.25 4495.0 1250.0 3596.0 2.5 85.62 2.5 85.62 0.0 0.0 684.95 171.24 3596.0 INR 0 0.0 0.0 2025-11-08 02:21:46
898 911 14 101 12527 47 Premium Hair Care Shampoo NULL 3305109 3 150.0 699.0 0.0 0.0 559.2 532.57 26.63 2097.0 450.0 1677.6 2.5 39.95 2.5 39.95 0.0 0.0 532.57 79.89 1677.6 INR 0 0.0 0.0 2025-11-08 02:21:46
899 912 15 101 12527 35 Sanitary Pad (15 pcs) NULL 9619001 26 40.0 380.0 0.0 0.0 304.0 304.0 0.0 9880.0 1040.0 7904.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 7904.0 INR 0 0.0 0.0 2025-11-08 02:21:46
900 913 16 101 12527 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 02:21:46