fx_franchise_order_product

4,933 rows · 33 columns · page 24 / 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
1151 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
1152 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
1153 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
1154 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
1155 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
1156 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
1157 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
1158 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
1159 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
1160 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
1161 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
1162 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
1163 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
1164 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
1165 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
1166 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
1167 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
1168 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
1169 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
1170 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
1171 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
1172 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
1173 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
1174 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
1175 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
1176 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
1177 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
1178 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
1179 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
1180 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
1181 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
1182 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
1183 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
1184 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
1185 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
1186 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
1187 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
1188 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
1189 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
1190 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
1191 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
1192 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
1193 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
1194 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
1195 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
1196 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
1197 1210 1 164 12532 74 EXPLORER BOX NULL NULL 3 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 80991.0 0.0 31497.0 2.5 749.93 2.5 749.93 0.0 0.0 9999.05 1499.86 31497.0 INR 0 0.0 0.0 2025-11-11 15:59:25
1198 1211 1 165 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-11 16:17:48
1199 1212 1 166 12517 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 0.0 0.0 0.0 0.0 5.0 857.14 17142.86 857.14 18000.0 INR 0 0.0 0.0 2025-11-11 16:18:14
1200 1213 2 166 12517 77 ELITE COMFORT NULL NULL 2 0.0 53994.0 0.0 0.0 18500.0 17619.05 880.95 107988.0 0.0 37000.0 0.0 0.0 0.0 0.0 5.0 1761.9 17619.05 1761.9 37000.0 INR 0 0.0 0.0 2025-11-11 16:18:14