fx_franchise_order_product

4,933 rows · 33 columns · page 21 / 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
1001 1014 13 107 12517 33 Herbal Soap 100gm NULL 30049011 5 28.0 100.0 0.0 0.0 80.0 76.19 3.81 500.0 140.0 400.0 0.0 0.0 0.0 0.0 5.0 19.05 76.19 19.05 400.0 INR 0 0.0 0.0 2025-11-09 12:31:27
1002 1015 14 107 12517 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 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
1003 1016 15 107 12517 30 Iron Capsules 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
1004 1017 16 107 12517 15 Kidney Stone Juice NULL 2009899 5 120.0 349.0 0.0 0.0 279.2 265.9 13.3 1745.0 600.0 1396.0 0.0 0.0 0.0 0.0 5.0 66.48 265.9 66.48 1396.0 INR 0 0.0 0.0 2025-11-09 12:31:27
1005 1018 17 107 12517 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 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
1006 1019 18 107 12517 16 Liver Care Juice NULL 2009899 5 120.0 349.0 0.0 0.0 279.2 265.9 13.3 1745.0 600.0 1396.0 0.0 0.0 0.0 0.0 5.0 66.48 265.9 66.48 1396.0 INR 0 0.0 0.0 2025-11-09 12:31:27
1007 1020 19 107 12517 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 0.0 0.0 0.0 0.0 5.0 76.0 304.0 76.0 1596.0 INR 0 0.0 0.0 2025-11-09 12:31:27
1008 1021 20 107 12517 12 Melatonin Drop NULL 2106909 4 190.0 749.0 0.0 0.0 599.2 570.67 28.53 2996.0 760.0 2396.8 0.0 0.0 0.0 0.0 5.0 114.13 570.67 114.13 2396.8 INR 0 0.0 0.0 2025-11-09 12:31:27
1009 1022 21 107 12517 7 Morning Fresh Churan NULL 30049011 5 40.0 199.0 0.0 0.0 159.2 151.62 7.58 995.0 200.0 796.0 0.0 0.0 0.0 0.0 5.0 37.9 151.62 37.9 796.0 INR 0 0.0 0.0 2025-11-09 12:31:27
1010 1023 22 107 12517 32 Neem Soap 100gm NULL 34011110 1 10.0 60.0 0.0 0.0 48.0 45.71 2.29 60.0 10.0 48.0 0.0 0.0 0.0 0.0 5.0 2.29 45.71 2.29 48.0 INR 0 0.0 0.0 2025-11-09 12:31:27
1011 1024 23 107 12517 9 Omega 369 NULL 2936900 5 260.0 999.0 0.0 0.0 799.2 761.14 38.06 4995.0 1300.0 3996.0 0.0 0.0 0.0 0.0 5.0 190.29 761.14 190.29 3996.0 INR 0 0.0 0.0 2025-11-09 12:31:27
1012 1025 24 107 12517 28 Ortho Joint Shield 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
1013 1026 25 107 12517 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 0.0 0.0 0.0 0.0 5.0 68.38 273.52 68.38 1436.0 INR 0 0.0 0.0 2025-11-09 12:31:27
1014 1027 26 107 12517 13 Premium NONI VEG caps NULL 2936900 6 150.0 501.0 0.0 0.0 400.8 381.71 19.09 3006.0 900.0 2404.8 0.0 0.0 0.0 0.0 5.0 114.51 381.71 114.51 2404.8 INR 0 0.0 0.0 2025-11-09 12:31:27
1015 1028 27 107 12517 29 Shilajith NULL 30049011 5 250.0 1800.0 0.0 0.0 1440.0 1371.43 68.57 9000.0 1250.0 7200.0 0.0 0.0 0.0 0.0 5.0 342.86 1371.43 342.86 7200.0 INR 0 0.0 0.0 2025-11-09 12:31:27
1016 1029 28 107 12517 26 Spirulina Cap NULL 2009899 5 190.0 899.0 0.0 0.0 719.2 684.95 34.25 4495.0 950.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
1017 1030 29 107 12517 5 Thyro Care NULL 2936900 3 250.0 899.0 0.0 0.0 719.2 684.95 34.25 2697.0 750.0 2157.6 0.0 0.0 0.0 0.0 5.0 102.74 684.95 102.74 2157.6 INR 0 0.0 0.0 2025-11-09 12:31:27
1018 1031 30 107 12517 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 0.0 0.0 0.0 0.0 18.0 3661.02 101.69 3661.02 24000.0 INR 0 0.0 0.0 2025-11-09 12:31:27
1019 1032 1 108 12516 20 Premium Berry Juice 1000ml NULL 2936900 2 750.0 3499.0 0.0 0.0 3479.0 3313.33 165.66 6998.0 1500.0 6958.0 2.5 165.66 2.5 165.66 0.0 0.0 3313.33 331.33 6958.0 INR 0 0.0 0.0 2025-11-09 13:31:28
1020 1033 2 108 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-09 13:31:28
1021 1034 3 108 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-09 13:31:28
1022 1035 1 109 12516 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-09 13:35:25
1023 1036 1 110 12516 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-09 13:37:52
1024 1037 1 111 12516 33 Herbal Soap 100gm NULL 30049011 15 28.0 100.0 0.0 0.0 80.0 76.19 3.81 1500.0 420.0 1200.0 2.5 28.57 2.5 28.57 0.0 0.0 76.19 57.14 1200.0 INR 0 0.0 0.0 2025-11-09 13:42:51
1025 1038 1 112 12516 33 Herbal Soap 100gm NULL 30049011 10 28.0 100.0 0.0 0.0 80.0 76.19 3.81 1000.0 280.0 800.0 2.5 19.05 2.5 19.05 0.0 0.0 76.19 38.1 800.0 INR 0 0.0 0.0 2025-11-09 13:54:46
1026 1039 2 112 12516 32 Neem Soap 100gm NULL 34011110 10 10.0 60.0 0.0 0.0 48.0 45.71 2.29 600.0 100.0 480.0 2.5 11.43 2.5 11.43 0.0 0.0 45.71 22.86 480.0 INR 0 0.0 0.0 2025-11-09 13:54:46
1027 1040 3 112 12516 13 Premium NONI VEG caps NULL 2936900 10 150.0 501.0 0.0 0.0 400.8 381.71 19.09 5010.0 1500.0 4008.0 2.5 95.43 2.5 95.43 0.0 0.0 381.71 190.86 4008.0 INR 0 0.0 0.0 2025-11-09 13:54:46
1028 1041 1 113 12516 33 Herbal Soap 100gm NULL 30049011 10 28.0 100.0 0.0 0.0 80.0 76.19 3.81 1000.0 280.0 800.0 2.5 19.05 2.5 19.05 0.0 0.0 76.19 38.1 800.0 INR 0 0.0 0.0 2025-11-09 14:07:35
1029 1042 2 113 12516 32 Neem Soap 100gm NULL 34011110 10 10.0 60.0 0.0 0.0 48.0 45.71 2.29 600.0 100.0 480.0 2.5 11.43 2.5 11.43 0.0 0.0 45.71 22.86 480.0 INR 0 0.0 0.0 2025-11-09 14:07:35
1030 1043 3 113 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-09 14:07:35
1031 1044 1 114 12516 33 Herbal Soap 100gm NULL 30049011 10 28.0 100.0 0.0 0.0 80.0 76.19 3.81 1000.0 280.0 800.0 2.5 19.05 2.5 19.05 0.0 0.0 76.19 38.1 800.0 INR 0 0.0 0.0 2025-11-09 14:17:22
1032 1045 2 114 12516 32 Neem Soap 100gm NULL 34011110 10 10.0 60.0 0.0 0.0 48.0 45.71 2.29 600.0 100.0 480.0 2.5 11.43 2.5 11.43 0.0 0.0 45.71 22.86 480.0 INR 0 0.0 0.0 2025-11-09 14:17:22
1033 1046 3 114 12516 14 Premium Aloe Vera VEG caps NULL 2936900 10 100.0 359.0 0.0 0.0 287.2 273.52 13.68 3590.0 1000.0 2872.0 2.5 68.38 2.5 68.38 0.0 0.0 273.52 136.76 2872.0 INR 0 0.0 0.0 2025-11-09 14:17:22
1034 1047 4 114 12516 13 Premium NONI VEG caps NULL 2936900 10 150.0 501.0 0.0 0.0 400.8 381.71 19.09 5010.0 1500.0 4008.0 2.5 95.43 2.5 95.43 0.0 0.0 381.71 190.86 4008.0 INR 0 0.0 0.0 2025-11-09 14:17:22
1035 1048 1 115 12516 48 glow face wash NULL 3304999 1 250.0 380.0 0.0 0.0 304.0 257.63 46.37 380.0 250.0 304.0 9.0 23.18 9.0 23.18 0.0 0.0 257.63 46.37 304.0 INR 0 0.0 0.0 2025-11-09 14:26:51
1036 1049 1 116 12516 72 Pain Relief Patch NULL 30051090 10 200.0 800.0 0.0 0.0 640.0 609.52 30.48 8000.0 2000.0 6400.0 2.5 152.38 2.5 152.38 0.0 0.0 609.52 304.76 6400.0 INR 0 0.0 0.0 2025-11-09 14:29:51
1037 1050 1 117 12517 74 EXPLORER BOX NULL NULL 2 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 53994.0 0.0 20998.0 0.0 0.0 0.0 0.0 5.0 999.9 9999.05 999.9 20998.0 INR 0 0.0 0.0 2025-11-09 15:58:33
1038 1051 1 118 12526 38 Dish Wash 500ml NULL 3924101 20 85.0 230.0 0.0 0.0 184.0 155.93 28.07 4600.0 1700.0 3680.0 9.0 280.68 9.0 280.68 0.0 0.0 155.93 561.36 3680.0 INR 0 0.0 0.0 2025-11-09 16:16:59
1039 1052 2 118 12526 37 Floor Cleaner 500ml NULL 3924101 20 80.0 199.0 0.0 0.0 159.2 134.92 24.28 3980.0 1600.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-09 16:16:59
1040 1053 3 118 12526 32 Neem Soap 100gm NULL 34011110 100 10.0 60.0 0.0 0.0 48.0 45.71 2.29 6000.0 1000.0 4800.0 2.5 114.28 2.5 114.28 0.0 0.0 45.71 228.57 4800.0 INR 0 0.0 0.0 2025-11-09 16:16:59
1041 1054 4 118 12526 46 Root Vitality Hair Oil NULL 3305901 20 54.0 255.0 0.0 0.0 204.0 194.29 9.71 5100.0 1080.0 4080.0 2.5 97.14 2.5 97.14 0.0 0.0 194.29 194.29 4080.0 INR 0 0.0 0.0 2025-11-09 16:16:59
1042 1055 5 118 12526 36 Toilet Cleaner 500ml NULL 3924101 20 30.0 150.0 0.0 0.0 120.0 101.69 18.3 3000.0 600.0 2400.0 9.0 183.05 9.0 183.05 0.0 0.0 101.69 366.1 2400.0 INR 0 0.0 0.0 2025-11-09 16:16:59
1043 1056 1 119 12557 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 16:21:33
1044 1057 1 120 12539 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 16:35:54
1045 1058 1 121 12524 70 Premium Hand belt NULL 9404 5 600.0 9999.0 0.0 0.0 1440.0 1371.43 68.57 49995.0 3000.0 7200.0 2.5 171.43 2.5 171.43 0.0 0.0 1371.43 342.86 7200.0 INR 0 0.0 0.0 2025-11-09 16:36:10
1046 1059 2 121 12524 40 Bamboo Brush NULL 96032100 10 25.0 110.0 0.0 0.0 88.0 74.58 13.42 1100.0 250.0 880.0 9.0 67.12 9.0 67.12 0.0 0.0 74.58 134.24 880.0 INR 0 0.0 0.0 2025-11-09 16:36:10
1047 1060 3 121 12524 38 Dish Wash 500ml NULL 3924101 20 85.0 230.0 0.0 0.0 184.0 155.93 28.07 4600.0 1700.0 3680.0 9.0 280.68 9.0 280.68 0.0 0.0 155.93 561.36 3680.0 INR 0 0.0 0.0 2025-11-09 16:36:10
1048 1061 4 121 12524 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-09 16:36:10
1049 1062 5 121 12524 37 Floor Cleaner 500ml NULL 3924101 20 80.0 199.0 0.0 0.0 159.2 134.92 24.28 3980.0 1600.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-09 16:36:10
1050 1063 6 121 12524 34 Herbo2o Toothpaste NULL 33061090 50 45.0 199.0 0.0 0.0 159.2 134.92 24.28 9950.0 2250.0 7960.0 9.0 607.12 9.0 607.12 0.0 0.0 134.92 1214.24 7960.0 INR 0 0.0 0.0 2025-11-09 16:36:10