fx_franchise_order_product

4,737 rows · 33 columns · page 20 / 95

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 1160 2 153 12542 6 Asthma Care NULL 30049011 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-11 13:44:53
952 1161 3 153 12542 40 Bamboo Brush NULL 96032100 1 25.0 110.0 0.0 0.0 88.0 74.58 13.42 110.0 25.0 88.0 9.0 6.71 9.0 6.71 0.0 0.0 74.58 13.42 88.0 INR 0 0.0 0.0 2025-11-11 13:44:53
953 1162 4 153 12542 52 Bhoo sanjeevni 5 kg NULL 3103100 3 450.0 1600.0 0.0 0.0 1280.0 1219.05 60.95 4800.0 1350.0 3840.0 2.5 91.43 2.5 91.43 0.0 0.0 1219.05 182.86 3840.0 INR 0 0.0 0.0 2025-11-11 13:44:53
954 1163 5 153 12542 38 Dish Wash 500ml NULL 3924101 21 85.0 230.0 0.0 0.0 184.0 155.93 28.07 4830.0 1785.0 3864.0 9.0 294.71 9.0 294.71 0.0 0.0 155.93 589.42 3864.0 INR 0 0.0 0.0 2025-11-11 13:44:53
955 1164 6 153 12542 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-11 13:44:53
956 1165 7 153 12542 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-11 13:44:53
957 1166 8 153 12542 37 Floor Cleaner 500ml NULL 3924101 9 80.0 199.0 0.0 0.0 159.2 134.92 24.28 1791.0 720.0 1432.8 9.0 109.28 9.0 109.28 0.0 0.0 134.92 218.56 1432.8 INR 0 0.0 0.0 2025-11-11 13:44:53
958 1167 9 153 12542 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-11 13:44:53
959 1168 10 153 12542 33 Herbal Soap 100gm NULL 30049011 125 28.0 100.0 0.0 0.0 80.0 76.19 3.81 12500.0 3500.0 10000.0 2.5 238.09 2.5 238.09 0.0 0.0 76.19 476.19 10000.0 INR 0 0.0 0.0 2025-11-11 13:44:53
960 1169 11 153 12542 34 Herbo2o Toothpaste NULL 33061090 33 45.0 199.0 0.0 0.0 159.2 134.92 24.28 6567.0 1485.0 5253.6 9.0 400.7 9.0 400.7 0.0 0.0 134.92 801.4 5253.6 INR 0 0.0 0.0 2025-11-11 13:44:53
961 1170 12 153 12542 16 Liver Care Juice NULL 2009899 3 120.0 349.0 0.0 0.0 279.2 265.9 13.3 1047.0 360.0 837.6 2.5 19.95 2.5 19.95 0.0 0.0 265.9 39.89 837.6 INR 0 0.0 0.0 2025-11-11 13:44:53
962 1171 13 153 12542 17 Memory Booster Juice NULL 2009899 3 120.0 349.0 0.0 0.0 279.2 265.9 13.3 1047.0 360.0 837.6 2.5 19.95 2.5 19.95 0.0 0.0 265.9 39.89 837.6 INR 0 0.0 0.0 2025-11-11 13:44:53
963 1172 14 153 12542 7 Morning Fresh Churan NULL 30049011 14 40.0 199.0 0.0 0.0 159.2 151.62 7.58 2786.0 560.0 2228.8 2.5 53.06 2.5 53.06 0.0 0.0 151.62 106.13 2228.8 INR 0 0.0 0.0 2025-11-11 13:44:53
964 1173 15 153 12542 32 Neem Soap 100gm NULL 34011110 204 10.0 60.0 0.0 0.0 48.0 45.71 2.29 12240.0 2040.0 9792.0 2.5 233.15 2.5 233.15 0.0 0.0 45.71 466.29 9792.0 INR 0 0.0 0.0 2025-11-11 13:44:53
965 1174 16 153 12542 9 Omega 369 NULL 2936900 1 260.0 999.0 0.0 0.0 799.2 761.14 38.06 999.0 260.0 799.2 2.5 19.03 2.5 19.03 0.0 0.0 761.14 38.06 799.2 INR 0 0.0 0.0 2025-11-11 13:44:53
966 1175 17 153 12542 72 Pain Relief Patch NULL 30051090 3 200.0 800.0 0.0 0.0 640.0 609.52 30.48 2400.0 600.0 1920.0 2.5 45.72 2.5 45.72 0.0 0.0 609.52 91.43 1920.0 INR 0 0.0 0.0 2025-11-11 13:44:53
967 1176 18 153 12542 8 Piles Care NULL 30049011 8 250.0 899.0 0.0 0.0 719.2 684.95 34.25 7192.0 2000.0 5753.6 2.5 136.99 2.5 136.99 0.0 0.0 684.95 273.98 5753.6 INR 0 0.0 0.0 2025-11-11 13:44:53
968 1177 19 153 12542 35 Sanitary Pad (15 pcs) NULL 9619001 6 40.0 380.0 0.0 0.0 304.0 304.0 0.0 2280.0 240.0 1824.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 1824.0 INR 0 0.0 0.0 2025-11-11 13:44:53
969 1178 20 153 12542 29 Shilajith NULL 30049011 2 250.0 1800.0 0.0 0.0 1440.0 1371.43 68.57 3600.0 500.0 2880.0 2.5 68.57 2.5 68.57 0.0 0.0 1371.43 137.14 2880.0 INR 0 0.0 0.0 2025-11-11 13:44:53
970 1179 21 153 12542 53 Terra care 2 kg NULL 3103100 1 450.0 1500.0 0.0 0.0 1200.0 1142.86 57.14 1500.0 450.0 1200.0 2.5 28.57 2.5 28.57 0.0 0.0 1142.86 57.14 1200.0 INR 0 0.0 0.0 2025-11-11 13:44:53
971 1180 22 153 12542 36 Toilet Cleaner 500ml NULL 3924101 25 30.0 150.0 0.0 0.0 120.0 101.69 18.31 3750.0 750.0 3000.0 9.0 228.81 9.0 228.81 0.0 0.0 101.69 457.63 3000.0 INR 0 0.0 0.0 2025-11-11 13:44:53
972 1181 1 154 12540 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-11 14:09:03
973 1182 1 155 12517 70 Premium Hand belt NULL 9404 3 600.0 9999.0 0.0 0.0 1440.0 1371.43 68.57 29997.0 1800.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-11 14:09:53
974 1183 2 155 12517 6 Asthma Care NULL 30049011 1 250.0 899.0 0.0 0.0 719.2 684.95 34.25 899.0 250.0 719.2 0.0 0.0 0.0 0.0 5.0 34.25 684.95 34.25 719.2 INR 0 0.0 0.0 2025-11-11 14:09:53
975 1184 3 155 12517 52 Bhoo sanjeevni 5 kg NULL 3103100 3 450.0 1600.0 0.0 0.0 1280.0 1219.05 60.95 4800.0 1350.0 3840.0 0.0 0.0 0.0 0.0 5.0 182.86 1219.05 182.86 3840.0 INR 0 0.0 0.0 2025-11-11 14:09:53
976 1185 4 155 12517 7 Morning Fresh Churan NULL 30049011 14 40.0 199.0 0.0 0.0 159.2 151.62 7.58 2786.0 560.0 2228.8 0.0 0.0 0.0 0.0 5.0 106.13 151.62 106.13 2228.8 INR 0 0.0 0.0 2025-11-11 14:09:53
977 1186 5 155 12517 9 Omega 369 NULL 2936900 1 260.0 999.0 0.0 0.0 799.2 761.14 38.06 999.0 260.0 799.2 0.0 0.0 0.0 0.0 5.0 38.06 761.14 38.06 799.2 INR 0 0.0 0.0 2025-11-11 14:09:53
978 1187 6 155 12517 53 Terra care 2 kg NULL 3103100 1 450.0 1500.0 0.0 0.0 1200.0 1142.86 57.14 1500.0 450.0 1200.0 0.0 0.0 0.0 0.0 5.0 57.14 1142.86 57.14 1200.0 INR 0 0.0 0.0 2025-11-11 14:09:53
979 1188 1 156 12516 70 Premium Hand belt NULL 9404 10 600.0 9999.0 0.0 0.0 1440.0 1371.43 68.57 99990.0 6000.0 14400.0 2.5 342.86 2.5 342.86 0.0 0.0 1371.43 685.71 14400.0 INR 0 0.0 0.0 2025-11-11 14:18:17
980 1189 2 156 12516 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 2.5 171.24 2.5 171.24 0.0 0.0 684.95 342.48 7192.0 INR 0 0.0 0.0 2025-11-11 14:18:17
981 1190 3 156 12516 52 Bhoo sanjeevni 5 kg NULL 3103100 10 450.0 1600.0 0.0 0.0 1280.0 1219.05 60.95 16000.0 4500.0 12800.0 2.5 304.76 2.5 304.76 0.0 0.0 1219.05 609.52 12800.0 INR 0 0.0 0.0 2025-11-11 14:18:17
982 1191 4 156 12516 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 2.5 75.81 2.5 75.81 0.0 0.0 151.62 151.62 3184.0 INR 0 0.0 0.0 2025-11-11 14:18:17
983 1192 5 156 12516 9 Omega 369 NULL 2936900 10 260.0 999.0 0.0 0.0 799.2 761.14 38.06 9990.0 2600.0 7992.0 2.5 190.28 2.5 190.28 0.0 0.0 761.14 380.57 7992.0 INR 0 0.0 0.0 2025-11-11 14:18:17
984 1193 6 156 12516 53 Terra care 2 kg NULL 3103100 10 450.0 1500.0 0.0 0.0 1200.0 1142.86 57.14 15000.0 4500.0 12000.0 2.5 285.71 2.5 285.71 0.0 0.0 1142.86 571.43 12000.0 INR 0 0.0 0.0 2025-11-11 14:18:17
985 1194 1 157 12536 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-11 14:37:27
986 1195 1 158 12530 38 Dish Wash 500ml NULL 3924101 8 85.0 230.0 0.0 0.0 184.0 155.93 28.07 1840.0 680.0 1472.0 9.0 112.27 9.0 112.27 0.0 0.0 155.93 224.54 1472.0 INR 0 0.0 0.0 2025-11-11 15:04:15
987 1196 2 158 12530 39 Fabric Wash 1000ml NULL 3924101 4 150.0 401.0 0.0 0.0 320.8 271.86 48.94 1604.0 600.0 1283.2 9.0 97.87 9.0 97.87 0.0 0.0 271.86 195.74 1283.2 INR 0 0.0 0.0 2025-11-11 15:04:15
988 1197 3 158 12530 37 Floor Cleaner 500ml NULL 3924101 8 80.0 199.0 0.0 0.0 159.2 134.92 24.29 1592.0 640.0 1273.6 9.0 97.14 9.0 97.14 0.0 0.0 134.92 194.28 1273.6 INR 0 0.0 0.0 2025-11-11 15:04:15
989 1198 4 158 12530 33 Herbal Soap 100gm NULL 30049011 20 28.0 100.0 0.0 0.0 80.0 76.19 3.81 2000.0 560.0 1600.0 2.5 38.09 2.5 38.09 0.0 0.0 76.19 76.19 1600.0 INR 0 0.0 0.0 2025-11-11 15:04:15
990 1199 5 158 12530 34 Herbo2o Toothpaste NULL 33061090 16 45.0 199.0 0.0 0.0 159.2 134.92 24.29 3184.0 720.0 2547.2 9.0 194.28 9.0 194.28 0.0 0.0 134.92 388.56 2547.2 INR 0 0.0 0.0 2025-11-11 15:04:15
991 1200 6 158 12530 32 Neem Soap 100gm NULL 34011110 20 10.0 60.0 0.0 0.0 48.0 45.71 2.29 1200.0 200.0 960.0 2.5 22.86 2.5 22.86 0.0 0.0 45.71 45.71 960.0 INR 0 0.0 0.0 2025-11-11 15:04:15
992 1201 7 158 12530 46 Root Vitality Hair Oil NULL 3305901 2 54.0 255.0 0.0 0.0 204.0 194.29 9.71 510.0 108.0 408.0 2.5 9.71 2.5 9.71 0.0 0.0 194.29 19.43 408.0 INR 0 0.0 0.0 2025-11-11 15:04:15
993 1202 8 158 12530 35 Sanitary Pad (15 pcs) NULL 9619001 4 40.0 380.0 0.0 0.0 304.0 304.0 0.0 1520.0 160.0 1216.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 1216.0 INR 0 0.0 0.0 2025-11-11 15:04:15
994 1203 9 158 12530 36 Toilet Cleaner 500ml NULL 3924101 8 30.0 150.0 0.0 0.0 120.0 101.69 18.3 1200.0 240.0 960.0 9.0 73.22 9.0 73.22 0.0 0.0 101.69 146.44 960.0 INR 0 0.0 0.0 2025-11-11 15:04:15
995 1204 1 159 12529 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-11 15:10:17
996 1205 1 160 12517 74 EXPLORER BOX NULL NULL 6 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 161982.0 0.0 62994.0 0.0 0.0 0.0 0.0 5.0 2999.71 9999.05 2999.71 62994.0 INR 0 0.0 0.0 2025-11-11 15:11:39
997 1206 1 161 12529 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-11 15:12:47
998 1207 1 162 12521 76 ELITE BOX NULL NULL 1 0.0 46494.0 0.0 0.0 18000.0 17142.86 857.14 46494.0 0.0 18000.0 2.5 428.57 2.5 428.57 0.0 0.0 17142.86 857.14 18000.0 INR 0 0.0 0.0 2025-11-11 15:19:45
999 1208 1 163 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-11 15:51:34
1000 1209 2 163 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-11 15:51:34