fx_franchise_order_product

4,933 rows · 33 columns · page 91 / 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
4501 4516 5 1125 12545 46 Root Vitality Hair Oil NULL 3305901 10 102.0 255.0 0.0 0.0 204.0 194.29 9.71 2550.0 1020.0 2040.0 2.5 48.57 2.5 48.57 0.0 0.0 1942.86 97.14 2040.0 INR 3 2.0 38.86 2026-04-29 15:44:54
4502 4517 6 1125 12545 35 Sanitary Pad (15 pcs) NULL 9619001 2 150.0 380.0 0.0 0.0 304.0 304.0 0.0 760.0 300.0 608.0 0.0 0.0 0.0 0.0 0.0 0.0 608.0 0.0 608.0 INR 3 2.0 12.16 2026-04-29 15:44:54
4503 4518 7 1125 12545 50 Sun Screen NULL 330499 1 279.0 699.0 0.0 0.0 559.0 473.73 85.27 699.0 279.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-29 15:44:54
4504 4519 8 1125 12545 34 Toothpaste NULL 33061090 15 55.0 199.0 0.0 0.0 159.0 134.75 24.25 2985.0 825.0 2385.0 9.0 181.91 9.0 181.91 0.0 0.0 2021.19 363.81 2385.0 INR 3 2.0 40.42 2026-04-29 15:44:54
4505 4520 1 1126 12545 33 HALDI CHANDAN SOAP 100gm NULL 30049011 5 35.0 100.0 0.0 0.0 80.0 76.19 3.81 500.0 175.0 400.0 2.5 9.52 2.5 9.52 0.0 0.0 380.95 19.05 400.0 INR 3 2.0 7.62 2026-04-29 15:44:54
4506 4521 2 1126 12545 30 Iron Capsules NULL 30049011 1 359.0 899.0 0.0 0.0 719.0 684.76 34.24 899.0 359.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-29 15:44:54
4507 4522 3 1126 12545 72 Pain Relief Patch NULL 30051090 1 200.0 800.0 0.0 0.0 400.0 380.95 19.05 800.0 200.0 400.0 2.5 9.52 2.5 9.52 0.0 0.0 380.95 19.05 400.0 INR 3 2.0 7.62 2026-04-29 15:44:54
4508 4523 4 1126 12545 43 Quench Kiss Lip Balm NULL 3304300 3 79.0 199.0 0.0 0.0 159.0 134.75 24.25 597.0 237.0 477.0 9.0 36.38 9.0 36.38 0.0 0.0 404.24 72.76 477.0 INR 3 2.0 8.08 2026-04-29 15:44:54
4509 4524 5 1126 12545 46 Root Vitality Hair Oil NULL 3305901 10 102.0 255.0 0.0 0.0 204.0 194.29 9.71 2550.0 1020.0 2040.0 2.5 48.57 2.5 48.57 0.0 0.0 1942.86 97.14 2040.0 INR 3 2.0 38.86 2026-04-29 15:44:54
4510 4525 6 1126 12545 35 Sanitary Pad (15 pcs) NULL 9619001 2 150.0 380.0 0.0 0.0 304.0 304.0 0.0 760.0 300.0 608.0 0.0 0.0 0.0 0.0 0.0 0.0 608.0 0.0 608.0 INR 3 2.0 12.16 2026-04-29 15:44:54
4511 4526 7 1126 12545 50 Sun Screen NULL 330499 1 279.0 699.0 0.0 0.0 559.0 473.73 85.27 699.0 279.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-29 15:44:54
4512 4527 8 1126 12545 34 Toothpaste NULL 33061090 15 55.0 199.0 0.0 0.0 159.0 134.75 24.25 2985.0 825.0 2385.0 9.0 181.91 9.0 181.91 0.0 0.0 2021.19 363.81 2385.0 INR 3 2.0 40.42 2026-04-29 15:44:54
4513 4528 1 1127 12545 32 Neem Soap 100gm NULL 34011110 95 20.0 60.0 0.0 0.0 52.0 49.52 2.48 5700.0 1900.0 4940.0 2.5 117.62 2.5 117.62 0.0 0.0 4704.76 235.24 4940.0 INR 3 2.0 94.1 2026-04-29 16:23:26
4514 4529 1 1128 12526 27 Multicharge Cap NULL 2009899 3 600.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 4497.0 1800.0 3600.0 2.5 85.71 2.5 85.71 0.0 0.0 3428.57 171.43 3600.0 INR 3 2.0 68.57 2026-04-29 23:10:31
4515 4530 2 1128 12526 82 ALKALINE CAPSULE NULL 3402000 4 800.0 2500.0 0.0 0.0 1650.0 1571.43 78.57 10000.0 3200.0 6600.0 2.5 157.14 2.5 157.14 0.0 0.0 6285.71 314.29 6600.0 INR 3 2.0 125.71 2026-04-29 23:10:31
4516 4531 3 1128 12526 4 Diabetic Care Capsules NULL 2936900 2 360.0 999.0 0.0 0.0 720.0 685.71 34.29 1998.0 720.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-29 23:10:31
4517 4532 4 1128 12526 33 HALDI CHANDAN SOAP 100gm NULL 30049011 25 35.0 100.0 0.0 0.0 80.0 76.19 3.81 2500.0 875.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-29 23:10:31
4518 4533 5 1128 12526 2 Heart Care Capsules NULL 2936900 1 600.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 1499.0 600.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-29 23:10:31
4519 4534 6 1128 12526 43 Quench Kiss Lip Balm NULL 3304300 5 79.0 199.0 0.0 0.0 159.0 134.75 24.25 995.0 395.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-29 23:10:31
4520 4535 7 1128 12526 46 Root Vitality Hair Oil NULL 3305901 5 102.0 255.0 0.0 0.0 204.0 194.29 9.71 1275.0 510.0 1020.0 2.5 24.29 2.5 24.29 0.0 0.0 971.43 48.57 1020.0 INR 3 2.0 19.43 2026-04-29 23:10:31
4521 4536 8 1128 12526 26 Spirulina Cap NULL 2009899 1 359.0 899.0 0.0 0.0 719.0 684.76 34.24 899.0 359.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-29 23:10:31
4522 4537 9 1128 12526 1 Stem Cell Powder NULL 2936900 3 500.0 2499.0 0.0 0.0 1000.0 952.38 47.62 7497.0 1500.0 3000.0 2.5 71.43 2.5 71.43 0.0 0.0 2857.14 142.86 3000.0 INR 3 2.0 57.14 2026-04-29 23:10:31
4523 4538 10 1128 12526 50 Sun Screen NULL 330499 2 279.0 699.0 0.0 0.0 559.0 473.73 85.27 1398.0 558.0 1118.0 9.0 85.27 9.0 85.27 0.0 0.0 947.46 170.54 1118.0 INR 3 2.0 18.95 2026-04-29 23:10:31
4524 4539 1 1129 12545 82 ALKALINE CAPSULE NULL 3402000 1 800.0 2500.0 0.0 0.0 1650.0 1571.43 78.57 2500.0 800.0 1650.0 2.5 39.29 2.5 39.29 0.0 0.0 1571.43 78.57 1650.0 INR 3 2.0 31.43 2026-04-30 05:47:14
4525 4540 2 1129 12545 33 HALDI CHANDAN SOAP 100gm NULL 30049011 5 35.0 100.0 0.0 0.0 80.0 76.19 3.81 500.0 175.0 400.0 2.5 9.52 2.5 9.52 0.0 0.0 380.95 19.05 400.0 INR 3 2.0 7.62 2026-04-30 05:47:14
4526 4541 3 1129 12545 2 Heart Care Capsules NULL 2936900 1 600.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 1499.0 600.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-30 05:47:14
4527 4542 4 1129 12545 26 Spirulina Cap NULL 2009899 1 359.0 899.0 0.0 0.0 719.0 684.76 34.24 899.0 359.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-30 05:47:14
4528 4543 1 1130 12545 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-30 09:06:55
4529 4544 2 1130 12545 39 Fabric Wash 1000ml NULL 34029099 2 112.0 401.0 0.0 0.0 321.0 272.03 48.97 802.0 224.0 642.0 9.0 48.97 9.0 48.97 0.0 0.0 544.07 97.93 642.0 INR 3 2.0 10.88 2026-04-30 09:06:55
4530 4545 1 1131 12552 27 Multicharge Cap NULL 2009899 1 600.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 1499.0 600.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-30 09:29:27
4531 4546 2 1131 12552 2 Heart Care Capsules NULL 2936900 4 600.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 5996.0 2400.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-30 09:29:27
4532 4547 3 1131 12552 26 Spirulina Cap NULL 2009899 1 359.0 899.0 0.0 0.0 719.0 684.76 34.24 899.0 359.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-30 09:29:27
4533 4548 1 1132 12545 20 Premium Berry Juice 1000ml NULL 2936900 1 800.0 3499.0 0.0 0.0 1600.0 1523.81 76.19 3499.0 800.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-30 09:52:30
4534 4549 2 1132 12545 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-30 09:52:30
4535 4550 1 1133 12545 8 Piles Care NULL 30049011 1 0.0 999.0 0.0 0.0 720.0 685.71 34.29 999.0 0.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-30 09:59:04
4536 4551 1 1134 12545 72 Pain Relief Patch NULL 30051090 1 200.0 800.0 0.0 0.0 400.0 380.95 19.05 800.0 200.0 400.0 2.5 9.52 2.5 9.52 0.0 0.0 380.95 19.05 400.0 INR 3 2.0 7.62 2026-04-30 10:17:31
4537 4552 1 1135 12545 3 BP Care Capsules NULL 2936900 2 360.0 999.0 0.0 0.0 720.0 685.71 34.29 1998.0 720.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-30 12:51:54
4538 4553 1 1136 12527 2 Heart Care Capsules NULL 2936900 2 600.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 2998.0 1200.0 2400.0 2.5 57.14 2.5 57.14 0.0 0.0 2285.71 114.29 2400.0 INR 3 2.0 45.71 2026-04-30 14:26:25
4539 4554 2 1136 12527 46 Root Vitality Hair Oil NULL 3305901 20 102.0 255.0 0.0 0.0 204.0 194.29 9.71 5100.0 2040.0 4080.0 2.5 97.14 2.5 97.14 0.0 0.0 3885.71 194.29 4080.0 INR 3 2.0 77.71 2026-04-30 14:26:25
4540 4555 3 1136 12527 26 Spirulina Cap NULL 2009899 2 359.0 899.0 0.0 0.0 719.0 684.76 34.24 1798.0 718.0 1438.0 2.5 34.24 2.5 34.24 0.0 0.0 1369.52 68.48 1438.0 INR 3 2.0 27.39 2026-04-30 14:26:25
4541 4556 4 1136 12527 34 Toothpaste NULL 33061090 20 55.0 199.0 0.0 0.0 159.0 134.75 24.25 3980.0 1100.0 3180.0 9.0 242.54 9.0 242.54 0.0 0.0 2694.92 485.08 3180.0 INR 3 2.0 53.9 2026-04-30 14:26:25
4542 4557 1 1137 12545 39 Fabric Wash 1000ml NULL 34029099 10 112.0 401.0 0.0 0.0 321.0 272.03 48.97 4010.0 1120.0 3210.0 9.0 244.83 9.0 244.83 0.0 0.0 2720.34 489.66 3210.0 INR 3 2.0 54.41 2026-04-30 16:42:02
4543 4558 2 1137 12545 9 Omega 369 NULL 2936900 2 360.0 999.0 0.0 0.0 720.0 685.71 34.29 1998.0 720.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-30 16:42:02
4544 4559 3 1137 12545 36 Toilet Cleaner 500ml NULL 3924101 10 42.0 150.0 0.0 0.0 120.0 101.69 18.31 1500.0 420.0 1200.0 9.0 91.53 9.0 91.53 0.0 0.0 1016.95 183.05 1200.0 INR 3 2.0 20.34 2026-04-30 16:42:02
4545 4560 4 1137 12545 34 Toothpaste NULL 33061090 10 55.0 199.0 0.0 0.0 159.0 134.75 24.25 1990.0 550.0 1590.0 9.0 121.27 9.0 121.27 0.0 0.0 1347.46 242.54 1590.0 INR 3 2.0 26.95 2026-04-30 16:42:02
4546 4561 1 1138 12545 2 Heart Care Capsules NULL 2936900 1 600.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 1499.0 600.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-30 19:49:47
4547 4562 1 1139 12552 2 Heart Care Capsules NULL 2936900 2 600.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 2998.0 1200.0 2400.0 2.5 57.14 2.5 57.14 0.0 0.0 2285.71 114.29 2400.0 INR 3 2.0 45.71 2026-04-30 21:40:36
4548 4563 2 1139 12552 12 PREMIUM RADIANCE FACE SERUM NULL 33049990 2 375.0 1250.0 0.0 0.0 750.0 714.29 35.71 2500.0 750.0 1500.0 2.5 35.71 2.5 35.71 0.0 0.0 1428.57 71.43 1500.0 INR 3 2.0 28.57 2026-04-30 21:40:36
4549 4564 1 1140 12545 26 Spirulina Cap NULL 2009899 1 359.0 899.0 0.0 0.0 719.0 684.76 34.24 899.0 359.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-30 22:59:05
4550 4565 1 1141 12552 33 HALDI CHANDAN SOAP 100gm NULL 30049011 10 35.0 100.0 0.0 0.0 80.0 76.19 3.81 1000.0 350.0 800.0 2.5 19.05 2.5 19.05 0.0 0.0 761.9 38.1 800.0 INR 3 2.0 15.24 2026-05-02 11:18:11