fx_franchise_order_product

4,933 rows · 33 columns · page 88 / 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
4351 4364 7 1070 12526 16 Liver Care Juice NULL 2009899 2 0.0 349.0 0.0 0.0 279.0 265.71 13.29 698.0 0.0 558.0 2.5 13.29 2.5 13.29 0.0 0.0 531.43 26.57 558.0 INR 3 2.0 10.63 2026-04-03 20:56:09
4352 4365 8 1070 12526 25 Manicalcium Tablets NULL 2009899 1 0.0 399.0 0.0 0.0 319.0 303.81 15.19 399.0 0.0 319.0 2.5 7.6 2.5 7.6 0.0 0.0 303.81 15.19 319.0 INR 3 2.0 6.08 2026-04-03 20:56:09
4353 4366 9 1070 12526 17 Memory Booster Juice NULL 2009899 1 0.0 349.0 0.0 0.0 279.0 265.71 13.29 349.0 0.0 279.0 2.5 6.64 2.5 6.64 0.0 0.0 265.71 13.29 279.0 INR 3 2.0 5.31 2026-04-03 20:56:09
4354 4367 10 1070 12526 32 Neem Soap 100gm NULL 34011110 50 0.0 60.0 0.0 0.0 48.0 45.71 2.29 3000.0 0.0 2400.0 2.5 57.14 2.5 57.14 0.0 0.0 2285.72 114.29 2400.0 INR 3 2.0 45.71 2026-04-03 20:56:09
4355 4368 11 1070 12526 72 Pain Relief Patch NULL 30051090 2 0.0 800.0 0.0 0.0 600.0 571.43 28.57 1600.0 0.0 1200.0 2.5 28.57 2.5 28.57 0.0 0.0 1142.86 57.14 1200.0 INR 3 2.0 22.86 2026-04-03 20:56:09
4356 4369 12 1070 12526 94 PAVANA DROPS NULL 30041211 2 0.0 699.0 0.0 0.0 499.0 475.24 23.76 1398.0 0.0 998.0 2.5 23.76 2.5 23.76 0.0 0.0 950.48 47.52 998.0 INR 3 2.0 19.01 2026-04-03 20:56:09
4357 4370 13 1070 12526 43 Quench Kiss Lip Balm NULL 3304300 5 0.0 199.0 0.0 0.0 159.0 134.75 24.25 995.0 0.0 795.0 9.0 60.64 9.0 60.64 0.0 0.0 673.73 121.27 795.0 INR 3 2.0 13.47 2026-04-03 20:56:09
4358 4371 1 1071 12528 39 Fabric Wash 1000ml NULL 34029099 1 0.0 401.0 0.0 0.0 321.0 272.03 48.97 401.0 0.0 321.0 9.0 24.48 9.0 24.48 0.0 0.0 272.03 48.97 321.0 INR 3 2.0 5.44 2026-04-04 13:46:00
4359 4372 2 1071 12528 33 HALDI CHANDAN SOAP 100gm NULL 30049011 60 0.0 100.0 0.0 0.0 80.0 76.19 3.81 6000.0 0.0 4800.0 2.5 114.29 2.5 114.29 0.0 0.0 4571.43 228.57 4800.0 INR 3 2.0 91.43 2026-04-04 13:46:00
4360 4373 3 1071 12528 32 Neem Soap 100gm NULL 34011110 200 0.0 60.0 0.0 0.0 48.0 45.71 2.29 12000.0 0.0 9600.0 2.5 228.57 2.5 228.57 0.0 0.0 9142.86 457.14 9600.0 INR 3 2.0 182.86 2026-04-04 13:46:00
4361 4374 4 1071 12528 36 Toilet Cleaner 500ml NULL 3924101 2 0.0 150.0 0.0 0.0 120.0 101.69 18.31 300.0 0.0 240.0 9.0 18.31 9.0 18.31 0.0 0.0 203.39 36.61 240.0 INR 3 2.0 4.07 2026-04-04 13:46:00
4362 4375 1 1072 13438 37 Floor Cleaner 500ml NULL 3924101 1 0.0 199.0 0.0 0.0 159.0 134.75 24.25 199.0 0.0 159.0 9.0 12.13 9.0 12.13 0.0 0.0 134.75 24.25 159.0 INR 3 2.0 2.69 2026-04-07 22:44:23
4363 4376 1 1073 12545 38 Dish Wash 500ml NULL 34029099 1 0.0 230.0 0.0 0.0 184.0 155.93 28.07 230.0 0.0 184.0 9.0 14.03 9.0 14.03 0.0 0.0 155.93 28.07 184.0 INR 3 2.0 3.12 2026-04-08 12:23:36
4364 4377 2 1073 12545 39 Fabric Wash 1000ml NULL 34029099 1 0.0 401.0 0.0 0.0 321.0 272.03 48.97 401.0 0.0 321.0 9.0 24.48 9.0 24.48 0.0 0.0 272.03 48.97 321.0 INR 3 2.0 5.44 2026-04-08 12:23:36
4365 4378 3 1073 12545 37 Floor Cleaner 500ml NULL 3924101 1 0.0 199.0 0.0 0.0 159.0 134.75 24.25 199.0 0.0 159.0 9.0 12.13 9.0 12.13 0.0 0.0 134.75 24.25 159.0 INR 3 2.0 2.69 2026-04-08 12:23:36
4366 4379 4 1073 12545 33 HALDI CHANDAN SOAP 100gm NULL 30049011 15 0.0 100.0 0.0 0.0 80.0 76.19 3.81 1500.0 0.0 1200.0 2.5 28.57 2.5 28.57 0.0 0.0 1142.86 57.14 1200.0 INR 3 2.0 22.86 2026-04-08 12:23:36
4367 4380 5 1073 12545 32 Neem Soap 100gm NULL 34011110 99 0.0 60.0 0.0 0.0 48.0 45.71 2.29 5940.0 0.0 4752.0 2.5 113.14 2.5 113.14 0.0 0.0 4525.72 226.29 4752.0 INR 3 2.0 90.51 2026-04-08 12:23:36
4368 4381 6 1073 12545 36 Toilet Cleaner 500ml NULL 3924101 5 0.0 150.0 0.0 0.0 120.0 101.69 18.31 750.0 0.0 600.0 9.0 45.76 9.0 45.76 0.0 0.0 508.47 91.53 600.0 INR 3 2.0 10.17 2026-04-08 12:23:36
4369 4382 7 1073 12545 34 Toothpaste NULL 33061090 2 0.0 199.0 0.0 0.0 159.0 134.75 24.25 398.0 0.0 318.0 9.0 24.25 9.0 24.25 0.0 0.0 269.49 48.51 318.0 INR 3 2.0 5.39 2026-04-08 12:23:36
4370 4383 1 1074 12545 32 Neem Soap 100gm NULL 34011110 3 0.0 60.0 0.0 0.0 48.0 45.71 2.29 180.0 0.0 144.0 2.5 3.43 2.5 3.43 0.0 0.0 137.14 6.86 144.0 INR 3 2.0 2.74 2026-04-08 12:24:26
4371 4384 1 1075 12516 64 Bio magnetic bracelet NULL 9404 20 0.0 9999.0 0.0 0.0 5000.0 4854.37 145.63 199980.0 0.0 100000.0 1.5 1456.31 1.5 1456.31 0.0 0.0 97087.38 2912.62 100000.0 INR 1 8.0 7766.99 2026-04-08 16:47:53
4372 4385 1 1076 12554 64 Bio magnetic bracelet NULL 9404 20 0.0 9999.0 0.0 0.0 5000.0 4854.37 145.63 199980.0 0.0 100000.0 1.5 1456.31 1.5 1456.31 0.0 0.0 97087.38 2912.62 100000.0 INR 2 6.0 5825.24 2026-04-08 16:51:21
4373 4386 1 1077 12554 64 Bio magnetic bracelet NULL 9404 20 0.0 9999.0 0.0 0.0 5000.0 4854.37 145.63 199980.0 0.0 100000.0 1.5 1456.31 1.5 1456.31 0.0 0.0 97087.38 2912.62 100000.0 INR 2 6.0 5825.24 2026-04-08 16:55:57
4374 4387 1 1078 12545 32 Neem Soap 100gm NULL 34011110 55 0.0 60.0 0.0 0.0 48.0 45.71 2.29 3300.0 0.0 2640.0 2.5 62.86 2.5 62.86 0.0 0.0 2514.29 125.71 2640.0 INR 3 2.0 50.29 2026-04-10 09:52:53
4375 4388 1 1079 12542 32 Neem Soap 100gm NULL 34011110 2 0.0 60.0 0.0 0.0 48.0 45.71 2.29 120.0 0.0 96.0 2.5 2.29 2.5 2.29 0.0 0.0 91.43 4.57 96.0 INR 3 2.0 1.83 2026-04-10 09:59:45
4376 4389 2 1079 12542 12 PREMIUM RADIANCE FACE SERUM NULL 33049990 1 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 1250.0 0.0 750.0 2.5 17.86 2.5 17.86 0.0 0.0 714.29 35.71 750.0 INR 3 2.0 14.29 2026-04-10 09:59:45
4377 4390 1 1080 12526 49 Anti Dandruff Serum NULL 3304999 1 0.0 999.0 0.0 0.0 799.0 677.12 121.88 999.0 0.0 799.0 9.0 60.94 9.0 60.94 0.0 0.0 677.12 121.88 799.0 INR 3 2.0 13.54 2026-04-10 20:48:50
4378 4391 2 1080 12526 6 Asthma Care NULL 30049011 1 0.0 899.0 0.0 0.0 719.0 684.76 34.24 899.0 0.0 719.0 2.5 17.12 2.5 17.12 0.0 0.0 684.76 34.24 719.0 INR 3 2.0 13.7 2026-04-10 20:48:50
4379 4392 3 1080 12526 52 Bhoo sanjeevni 5 kg NULL 3103100 1 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 1600.0 0.0 1250.0 2.5 29.76 2.5 29.76 0.0 0.0 1190.48 59.52 1250.0 INR 3 2.0 23.81 2026-04-10 20:48:50
4380 4393 4 1080 12526 81 PREMIUM GLOW FACE WASH NULL 3404 1 0.0 699.0 0.0 0.0 559.0 473.73 85.27 699.0 0.0 559.0 9.0 42.64 9.0 42.64 0.0 0.0 473.73 85.27 559.0 INR 3 2.0 9.47 2026-04-10 20:48:50
4381 4394 5 1080 12526 12 PREMIUM RADIANCE FACE SERUM NULL 33049990 1 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 1250.0 0.0 750.0 2.5 17.86 2.5 17.86 0.0 0.0 714.29 35.71 750.0 INR 3 2.0 14.29 2026-04-10 20:48:50
4382 4395 6 1080 12526 10 RADIANCE GLOW DAY CREAM NULL 33049900 1 0.0 1424.0 0.0 0.0 750.0 635.59 114.41 1424.0 0.0 750.0 9.0 57.2 9.0 57.2 0.0 0.0 635.59 114.41 750.0 INR 3 2.0 12.71 2026-04-10 20:48:50
4383 4396 1 1081 12545 60 Foot patch NULL 30051090 1 0.0 1999.0 0.0 0.0 1599.0 1522.86 76.14 1999.0 0.0 1599.0 2.5 38.07 2.5 38.07 0.0 0.0 1522.86 76.14 1599.0 INR 3 2.0 30.46 2026-04-11 17:22:51
4384 4397 2 1081 12545 33 HALDI CHANDAN SOAP 100gm NULL 30049011 25 0.0 100.0 0.0 0.0 80.0 76.19 3.81 2500.0 0.0 2000.0 2.5 47.62 2.5 47.62 0.0 0.0 1904.76 95.24 2000.0 INR 3 2.0 38.1 2026-04-11 17:22:51
4385 4398 3 1081 12545 32 Neem Soap 100gm NULL 34011110 30 0.0 60.0 0.0 0.0 48.0 45.71 2.29 1800.0 0.0 1440.0 2.5 34.29 2.5 34.29 0.0 0.0 1371.43 68.57 1440.0 INR 3 2.0 27.43 2026-04-11 17:22:51
4386 4399 1 1082 12548 32 Neem Soap 100gm NULL 34011110 31 20.0 60.0 0.0 0.0 52.0 49.52 2.48 1860.0 620.0 1612.0 2.5 38.38 2.5 38.38 0.0 0.0 1535.24 76.76 1612.0 INR 3 2.0 30.7 2026-04-13 22:58:25
4387 4400 1 1083 12516 65 SINGLE MAGNETIC BED SET NULL 94041000 37 5350.0 12999.0 0.0 0.0 10700.0 10190.48 509.52 480963.0 197950.0 395900.0 2.5 9426.19 2.5 9426.19 0.0 0.0 377047.62 18852.38 395900.0 INR 1 8.0 30163.81 2026-04-14 11:43:44
4388 4401 1 1084 12517 61 Radiation chip NULL 902221 50 100.0 999.0 0.0 0.0 200.0 169.49 30.51 49950.0 5000.0 10000.0 0.0 0.0 0.0 0.0 18.0 1525.42 8474.58 1525.42 10000.0 INR 2 6.0 508.47 2026-04-16 16:49:00
4389 4402 1 1085 12546 52 Bhoo sanjeevni 5 kg NULL 3103100 7 625.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 11200.0 4375.0 8750.0 2.5 208.33 2.5 208.33 0.0 0.0 8333.33 416.67 8750.0 INR 3 2.0 166.67 2026-04-16 18:27:52
4390 4403 2 1085 12546 38 Dish Wash 500ml NULL 34029099 15 65.0 230.0 0.0 0.0 184.0 155.93 28.07 3450.0 975.0 2760.0 9.0 210.51 9.0 210.51 0.0 0.0 2338.98 421.02 2760.0 INR 3 2.0 46.78 2026-04-16 18:27:52
4391 4404 3 1085 12546 32 Neem Soap 100gm NULL 34011110 45 20.0 60.0 0.0 0.0 52.0 49.52 2.48 2700.0 900.0 2340.0 2.5 55.71 2.5 55.71 0.0 0.0 2228.57 111.43 2340.0 INR 3 2.0 44.57 2026-04-16 18:27:52
4392 4405 4 1085 12546 53 Terra care 2 kg NULL 3103100 7 575.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 10500.0 4025.0 8050.0 2.5 191.67 2.5 191.67 0.0 0.0 7666.67 383.33 8050.0 INR 3 2.0 153.33 2026-04-16 18:27:52
4393 4406 1 1086 14902 52 Bhoo sanjeevni 5 kg NULL 3103100 1 625.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 1600.0 625.0 1250.0 2.5 29.76 2.5 29.76 0.0 0.0 1190.48 59.52 1250.0 INR 3 2.0 23.81 2026-04-17 14:32:34
4394 4407 2 1086 14902 4 Diabetic Care Capsules NULL 2936900 1 360.0 999.0 0.0 0.0 720.0 685.71 34.29 999.0 360.0 720.0 2.5 17.14 2.5 17.14 0.0 0.0 685.71 34.29 720.0 INR 3 2.0 13.71 2026-04-17 14:32:34
4395 4408 3 1086 14902 38 Dish Wash 500ml NULL 34029099 3 65.0 230.0 0.0 0.0 184.0 155.93 28.07 690.0 195.0 552.0 9.0 42.1 9.0 42.1 0.0 0.0 467.8 84.2 552.0 INR 3 2.0 9.36 2026-04-17 14:32:34
4396 4409 4 1086 14902 39 Fabric Wash 1000ml NULL 34029099 3 112.0 401.0 0.0 0.0 321.0 272.03 48.97 1203.0 336.0 963.0 9.0 73.45 9.0 73.45 0.0 0.0 816.1 146.9 963.0 INR 3 2.0 16.32 2026-04-17 14:32:34
4397 4410 5 1086 14902 37 Floor Cleaner 500ml NULL 3924101 2 55.0 199.0 0.0 0.0 159.0 134.75 24.25 398.0 110.0 318.0 9.0 24.25 9.0 24.25 0.0 0.0 269.49 48.51 318.0 INR 3 2.0 5.39 2026-04-17 14:32:34
4398 4411 6 1086 14902 60 Foot patch NULL 30051090 1 799.0 1999.0 0.0 0.0 1599.0 1522.86 76.14 1999.0 799.0 1599.0 2.5 38.07 2.5 38.07 0.0 0.0 1522.86 76.14 1599.0 INR 3 2.0 30.46 2026-04-17 14:32:34
4399 4412 7 1086 14902 48 Glow it multi fruit face wash NULL 3304999 3 160.0 450.0 0.0 0.0 320.0 271.19 48.81 1350.0 480.0 960.0 9.0 73.22 9.0 73.22 0.0 0.0 813.56 146.44 960.0 INR 3 2.0 16.27 2026-04-17 14:32:34
4400 4413 8 1086 14902 33 HALDI CHANDAN SOAP 100gm NULL 30049011 20 35.0 100.0 0.0 0.0 80.0 76.19 3.81 2000.0 700.0 1600.0 2.5 38.1 2.5 38.1 0.0 0.0 1523.81 76.19 1600.0 INR 3 2.0 30.48 2026-04-17 14:32:34