fx_franchise_order_product

4,933 rows · 33 columns · page 22 / 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
1051 1064 7 121 12524 47 Premium Hair Care Shampoo NULL 3305109 10 150.0 699.0 0.0 0.0 559.2 532.57 26.63 6990.0 1500.0 5592.0 2.5 133.15 2.5 133.15 0.0 0.0 532.57 266.29 5592.0 INR 0 0.0 0.0 2025-11-09 16:36:10
1052 1065 8 121 12524 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:36:10
1053 1066 9 121 12524 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:36:10
1054 1067 1 122 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 17:07:48
1055 1068 1 123 12540 4 Diabetic Care Capsules NULL 2936900 3 250.0 899.0 0.0 0.0 719.2 684.95 34.25 2697.0 750.0 2157.6 2.5 51.37 2.5 51.37 0.0 0.0 684.95 102.74 2157.6 INR 0 0.0 0.0 2025-11-09 19:11:39
1056 1069 2 123 12540 33 Herbal Soap 100gm NULL 30049011 30 28.0 100.0 0.0 0.0 80.0 76.19 3.81 3000.0 840.0 2400.0 2.5 57.15 2.5 57.15 0.0 0.0 76.19 114.29 2400.0 INR 0 0.0 0.0 2025-11-09 19:11:39
1057 1070 3 123 12540 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-09 19:11:39
1058 1071 4 123 12540 42 Premium Glow Charm Fairness Cream NULL 33049990 2 80.0 399.0 0.0 0.0 319.2 270.51 48.69 798.0 160.0 638.4 9.0 48.69 9.0 48.69 0.0 0.0 270.51 97.38 638.4 INR 0 0.0 0.0 2025-11-09 19:11:39
1059 1072 5 123 12540 46 Root Vitality Hair Oil NULL 3305901 5 54.0 255.0 0.0 0.0 204.0 194.29 9.71 1275.0 270.0 1020.0 2.5 24.29 2.5 24.29 0.0 0.0 194.29 48.57 1020.0 INR 0 0.0 0.0 2025-11-09 19:11:39
1060 1073 6 123 12540 35 Sanitary Pad (15 pcs) NULL 9619001 5 40.0 380.0 0.0 0.0 304.0 304.0 0.0 1900.0 200.0 1520.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 1520.0 INR 0 0.0 0.0 2025-11-09 19:11:39
1061 1074 7 123 12540 44 Vital Glow Face Scrub NULL 3304300 2 71.0 325.0 0.0 0.0 260.0 220.34 39.66 650.0 142.0 520.0 9.0 39.66 9.0 39.66 0.0 0.0 220.34 79.32 520.0 INR 0 0.0 0.0 2025-11-09 19:11:39
1062 1075 1 124 12517 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 0.0 0.0 0.0 0.0 5.0 499.95 9999.05 499.95 10499.0 INR 0 0.0 0.0 2025-11-09 19:37:47
1063 1076 1 125 12525 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 2.5 499.95 2.5 499.95 0.0 0.0 9999.05 999.9 20998.0 INR 0 0.0 0.0 2025-11-09 21:31:07
1064 1077 1 126 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 21:36:02
1065 1078 1 127 12525 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 2.5 499.95 2.5 499.95 0.0 0.0 9999.05 999.9 20998.0 INR 0 0.0 0.0 2025-11-09 21:59:41
1066 1079 1 128 12546 7 Morning Fresh Churan NULL 30049011 15 40.0 199.0 0.0 0.0 159.2 151.62 7.58 2985.0 600.0 2388.0 2.5 56.85 2.5 56.85 0.0 0.0 151.62 113.71 2388.0 INR 0 0.0 0.0 2025-11-10 06:50:30
1067 1080 2 128 12546 46 Root Vitality Hair Oil NULL 3305901 16 54.0 255.0 0.0 0.0 204.0 194.29 9.71 4080.0 864.0 3264.0 2.5 77.72 2.5 77.72 0.0 0.0 194.29 155.43 3264.0 INR 0 0.0 0.0 2025-11-10 06:50:30
1068 1081 1 129 12544 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-10 10:10:06
1069 1082 1 130 12525 40 Bamboo Brush NULL 96032100 2 25.0 110.0 0.0 0.0 88.0 74.58 13.43 220.0 50.0 176.0 9.0 13.43 9.0 13.43 0.0 0.0 74.58 26.85 176.0 INR 0 0.0 0.0 2025-11-10 14:50:14
1070 1083 2 130 12525 4 Diabetic Care Capsules NULL 2936900 1 250.0 899.0 0.0 0.0 719.2 684.95 34.25 899.0 250.0 719.2 2.5 17.12 2.5 17.12 0.0 0.0 684.95 34.25 719.2 INR 0 0.0 0.0 2025-11-10 14:50:14
1071 1084 3 130 12525 38 Dish Wash 500ml NULL 3924101 5 85.0 230.0 0.0 0.0 184.0 155.93 28.07 1150.0 425.0 920.0 9.0 70.17 9.0 70.17 0.0 0.0 155.93 140.34 920.0 INR 0 0.0 0.0 2025-11-10 14:50:14
1072 1085 4 130 12525 39 Fabric Wash 1000ml NULL 3924101 2 150.0 401.0 0.0 0.0 320.8 271.86 48.94 802.0 300.0 641.6 9.0 48.94 9.0 48.94 0.0 0.0 271.86 97.87 641.6 INR 0 0.0 0.0 2025-11-10 14:50:14
1073 1086 5 130 12525 19 Fat loss Juice 500 ml NULL 30049011 1 250.0 1499.0 0.0 0.0 1479.0 1408.57 70.43 1499.0 250.0 1479.0 2.5 35.22 2.5 35.22 0.0 0.0 1408.57 70.43 1479.0 INR 0 0.0 0.0 2025-11-10 14:50:14
1074 1087 6 130 12525 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-10 14:50:14
1075 1088 7 130 12525 34 Herbo2o Toothpaste NULL 33061090 15 45.0 199.0 0.0 0.0 159.2 134.92 24.28 2985.0 675.0 2388.0 9.0 182.13 9.0 182.13 0.0 0.0 134.92 364.27 2388.0 INR 0 0.0 0.0 2025-11-10 14:50:14
1076 1089 8 130 12525 15 Kidney Stone Juice NULL 2009899 1 120.0 349.0 0.0 0.0 279.2 265.9 13.3 349.0 120.0 279.2 2.5 6.65 2.5 6.65 0.0 0.0 265.9 13.3 279.2 INR 0 0.0 0.0 2025-11-10 14:50:14
1077 1090 9 130 12525 16 Liver Care Juice NULL 2009899 1 120.0 349.0 0.0 0.0 279.2 265.9 13.3 349.0 120.0 279.2 2.5 6.65 2.5 6.65 0.0 0.0 265.9 13.3 279.2 INR 0 0.0 0.0 2025-11-10 14:50:14
1078 1091 10 130 12525 7 Morning Fresh Churan NULL 30049011 10 40.0 199.0 0.0 0.0 159.2 151.62 7.58 1990.0 400.0 1592.0 2.5 37.91 2.5 37.91 0.0 0.0 151.62 75.81 1592.0 INR 0 0.0 0.0 2025-11-10 14:50:14
1079 1092 11 130 12525 32 Neem Soap 100gm NULL 34011110 60 10.0 60.0 0.0 0.0 48.0 45.71 2.29 3600.0 600.0 2880.0 2.5 68.57 2.5 68.57 0.0 0.0 45.71 137.14 2880.0 INR 0 0.0 0.0 2025-11-10 14:50:14
1080 1093 12 130 12525 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-10 14:50:14
1081 1094 13 130 12525 46 Root Vitality Hair Oil NULL 3305901 15 54.0 255.0 0.0 0.0 204.0 194.29 9.71 3825.0 810.0 3060.0 2.5 72.86 2.5 72.86 0.0 0.0 194.29 145.71 3060.0 INR 0 0.0 0.0 2025-11-10 14:50:14
1082 1095 1 131 12543 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 2.5 499.95 2.5 499.95 0.0 0.0 9999.05 999.9 20998.0 INR 0 0.0 0.0 2025-11-10 15:17:53
1083 1096 1 132 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-10 15:38:31
1084 1097 1 133 12552 80 BOOSTER KIT NULL NULL 1 0.0 21998.2 0.0 0.0 13699.0 11609.32 2089.68 21998.2 0.0 13699.0 9.0 1044.84 9.0 1044.84 0.0 0.0 11609.32 2089.68 13699.0 INR 0 0.0 0.0 2025-11-10 16:31:44
1085 1098 2 133 12552 73 ENTRY BOX NULL NULL 1 0.0 3998.4 0.0 0.0 3998.4 3808.0 190.4 3998.4 0.0 3998.4 2.5 95.2 2.5 95.2 0.0 0.0 3808.0 190.4 3998.4 INR 0 0.0 0.0 2025-11-10 16:31:44
1086 1099 1 134 12517 80 BOOSTER KIT NULL NULL 1 0.0 21998.2 0.0 0.0 13699.0 11609.32 2089.68 21998.2 0.0 13699.0 0.0 0.0 0.0 0.0 18.0 2089.68 11609.32 2089.68 13699.0 INR 0 0.0 0.0 2025-11-10 16:32:36
1087 1100 1 135 12517 73 ENTRY BOX NULL NULL 1 0.0 3998.4 0.0 0.0 3998.4 3808.0 190.4 3998.4 0.0 3998.4 0.0 0.0 0.0 0.0 5.0 190.4 3808.0 190.4 3998.4 INR 0 0.0 0.0 2025-11-10 16:33:45
1088 1101 1 136 12532 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 2.5 499.95 2.5 499.95 0.0 0.0 9999.05 999.9 20998.0 INR 0 0.0 0.0 2025-11-10 18:07:31
1089 1102 1 137 12517 74 EXPLORER BOX NULL NULL 4 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 107988.0 0.0 41996.0 0.0 0.0 0.0 0.0 5.0 1999.81 9999.05 1999.81 41996.0 INR 0 0.0 0.0 2025-11-10 18:20:37
1090 1103 1 138 12526 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-10 18:33:12
1091 1104 1 139 12685 48 glow face wash NULL 3304999 6 250.0 380.0 0.0 0.0 304.0 257.63 46.37 2280.0 1500.0 1824.0 9.0 139.12 9.0 139.12 0.0 0.0 257.63 278.24 1824.0 INR 0 0.0 0.0 2025-11-10 18:55:28
1092 1105 2 139 12685 27 Multicharge Cap 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-10 18:55:28
1093 1106 3 139 12685 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 2.5 248.5 2.5 248.5 0.0 0.0 3313.33 497.0 10437.0 INR 0 0.0 0.0 2025-11-10 18:55:28
1094 1107 4 139 12685 61 Radiation chip NULL 902221 1 325.0 999.0 0.0 0.0 799.2 677.29 121.91 999.0 325.0 799.2 9.0 60.95 9.0 60.95 0.0 0.0 677.29 121.91 799.2 INR 0 0.0 0.0 2025-11-10 18:55:28
1095 1108 5 139 12685 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-10 18:55:28
1096 1109 6 139 12685 49 Anti Dandruff Serum NULL 3304999 3 250.0 999.0 0.0 0.0 799.2 677.29 121.91 2997.0 750.0 2397.6 9.0 182.87 9.0 182.87 0.0 0.0 677.29 365.74 2397.6 INR 0 0.0 0.0 2025-11-10 18:55:28
1097 1110 7 139 12685 38 Dish Wash 500ml NULL 3924101 6 85.0 230.0 0.0 0.0 184.0 155.93 28.07 1380.0 510.0 1104.0 9.0 84.2 9.0 84.2 0.0 0.0 155.93 168.41 1104.0 INR 0 0.0 0.0 2025-11-10 18:55:28
1098 1111 8 139 12685 39 Fabric Wash 1000ml NULL 3924101 12 150.0 401.0 0.0 0.0 320.8 271.86 48.94 4812.0 1800.0 3849.6 9.0 293.62 9.0 293.62 0.0 0.0 271.86 587.23 3849.6 INR 0 0.0 0.0 2025-11-10 18:55:28
1099 1112 9 139 12685 37 Floor Cleaner 500ml NULL 3924101 3 80.0 199.0 0.0 0.0 159.2 134.92 24.28 597.0 240.0 477.6 9.0 36.42 9.0 36.42 0.0 0.0 134.92 72.85 477.6 INR 0 0.0 0.0 2025-11-10 18:55:28
1100 1113 10 139 12685 33 Herbal Soap 100gm NULL 30049011 100 28.0 100.0 0.0 0.0 80.0 76.19 3.81 10000.0 2800.0 8000.0 2.5 190.47 2.5 190.47 0.0 0.0 76.19 380.95 8000.0 INR 0 0.0 0.0 2025-11-10 18:55:28