fx_franchise_order_product

4,933 rows · 33 columns · page 92 / 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
4551 4566 1 1142 12555 49 Anti Dandruff Serum NULL 3304999 5 399.0 999.0 0.0 0.0 799.0 677.12 121.88 4995.0 1995.0 3995.0 9.0 304.7 9.0 304.7 0.0 0.0 3385.59 609.41 3995.0 INR 3 2.0 67.71 2026-05-03 14:00:00
4552 4567 1 1143 14569 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-05-03 23:44:54
4553 4568 2 1143 14569 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-03 23:44:54
4554 4569 3 1143 14569 53 Terra care 2 kg NULL 3103100 1 575.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 1500.0 575.0 1150.0 2.5 27.38 2.5 27.38 0.0 0.0 1095.24 54.76 1150.0 INR 3 2.0 21.9 2026-05-03 23:44:54
4555 4570 1 1144 12516 98 GOLD SANITARY PAD NULL 9610091 90 0.0 250.0 0.0 0.0 0.0 0.0 0.0 22500.0 0.0 0.0 4.5 0.0 4.5 0.0 0.0 0.0 0.0 0.0 0.0 INR 1 0.0 0.0 2026-05-05 13:14:09
4556 4571 1 1145 12554 98 GOLD SANITARY PAD NULL 9610091 90 0.0 250.0 0.0 0.0 0.0 0.0 0.0 22500.0 0.0 0.0 4.5 0.0 4.5 0.0 0.0 0.0 0.0 0.0 0.0 INR 2 0.0 0.0 2026-05-05 13:15:16
4557 4572 1 1146 12555 98 GOLD SANITARY PAD NULL 9610091 90 0.0 250.0 0.0 0.0 0.0 0.0 0.0 22500.0 0.0 0.0 4.5 0.0 4.5 0.0 0.0 0.0 0.0 0.0 0.0 INR 3 0.0 0.0 2026-05-05 13:20:06
4558 4573 1 1147 12516 98 GOLD SANITARY PAD NULL 9610091 50 0.0 250.0 0.0 0.0 0.0 0.0 0.0 12500.0 0.0 0.0 4.5 0.0 4.5 0.0 0.0 0.0 0.0 0.0 0.0 INR 1 0.0 0.0 2026-05-05 18:05:24
4559 4574 1 1148 12554 98 GOLD SANITARY PAD NULL 9610091 50 0.0 250.0 0.0 0.0 0.0 0.0 0.0 12500.0 0.0 0.0 4.5 0.0 4.5 0.0 0.0 0.0 0.0 0.0 0.0 INR 2 0.0 0.0 2026-05-05 18:06:48
4560 4575 1 1149 12554 98 GOLD SANITARY PAD NULL 9610091 50 0.0 250.0 0.0 0.0 0.0 0.0 0.0 12500.0 0.0 0.0 4.5 0.0 4.5 0.0 0.0 0.0 0.0 0.0 0.0 INR 2 0.0 0.0 2026-05-05 18:08:59
4561 4576 1 1150 12555 98 GOLD SANITARY PAD NULL 9610091 45 0.0 250.0 0.0 0.0 0.0 0.0 0.0 11250.0 0.0 0.0 4.5 0.0 4.5 0.0 0.0 0.0 0.0 0.0 0.0 INR 3 0.0 0.0 2026-05-05 18:14:21
4562 4577 1 1151 12526 82 ALKALINE CAPSULE NULL 3402000 2 800.0 2500.0 0.0 0.0 1650.0 1571.43 78.57 5000.0 1600.0 3300.0 2.5 78.57 2.5 78.57 0.0 0.0 3142.86 157.14 3300.0 INR 3 2.0 62.86 2026-05-06 22:19:06
4563 4578 2 1151 12526 48 Glow it multi fruit face wash NULL 3304999 7 160.0 450.0 0.0 0.0 320.0 271.19 48.81 3150.0 1120.0 2240.0 9.0 170.85 9.0 170.85 0.0 0.0 1898.3 341.69 2240.0 INR 3 2.0 37.97 2026-05-06 22:19:06
4564 4579 3 1151 12526 72 Pain Relief Patch NULL 30051090 4 200.0 800.0 0.0 0.0 400.0 380.95 19.05 3200.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-05-06 22:19:06
4565 4580 4 1151 12526 41 Premium Coco Body Lotion NULL 3304300 3 279.0 699.0 0.0 0.0 559.0 473.73 85.27 2097.0 837.0 1677.0 9.0 127.91 9.0 127.91 0.0 0.0 1421.19 255.81 1677.0 INR 3 2.0 28.42 2026-05-06 22:19:06
4566 4581 5 1151 12526 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-05-06 22:19:06
4567 4582 1 1152 12516 98 GOLD SANITARY PAD NULL 9610091 100 0.0 250.0 0.0 0.0 0.0 0.0 0.0 25000.0 0.0 0.0 4.5 0.0 4.5 0.0 0.0 0.0 0.0 0.0 0.0 INR 1 0.0 0.0 2026-05-07 12:07:24
4568 4583 1 1153 12554 98 GOLD SANITARY PAD NULL 9610091 100 0.0 250.0 0.0 0.0 0.0 0.0 0.0 25000.0 0.0 0.0 4.5 0.0 4.5 0.0 0.0 0.0 0.0 0.0 0.0 INR 2 0.0 0.0 2026-05-07 12:09:00
4569 4584 1 1154 12555 98 GOLD SANITARY PAD NULL 9610091 99 0.0 250.0 0.0 0.0 0.0 0.0 0.0 24750.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 INR 3 0.0 0.0 2026-05-07 12:13:34
4570 4585 1 1155 12516 98 GOLD SANITARY PAD NULL 9610091 60 0.0 250.0 0.0 0.0 0.0 0.0 0.0 15000.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 INR 1 0.0 0.0 2026-05-07 16:49:34
4571 4586 1 1156 12554 98 GOLD SANITARY PAD NULL 9610091 60 0.0 250.0 0.0 0.0 0.0 0.0 0.0 15000.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 INR 2 0.0 0.0 2026-05-07 16:51:35
4572 4587 1 1157 12555 98 GOLD SANITARY PAD NULL 9610091 60 0.0 250.0 0.0 0.0 0.0 0.0 0.0 15000.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 INR 3 0.0 0.0 2026-05-07 16:53:27
4573 4588 1 1158 12555 70 Premium Hand belt NULL 9404 2 720.0 2500.0 0.0 0.0 1440.0 1371.43 68.57 5000.0 1440.0 2880.0 2.5 68.57 2.5 68.57 0.0 0.0 2742.86 137.14 2880.0 INR 3 2.0 54.86 2026-05-07 19:40:42
4574 4589 1 1159 12555 20 Premium Berry Juice 1000ml NULL 2936900 5 800.0 3499.0 0.0 0.0 1600.0 1523.81 76.19 17495.0 4000.0 8000.0 2.5 190.48 2.5 190.48 0.0 0.0 7619.05 380.95 8000.0 INR 3 2.0 152.38 2026-05-07 21:55:42
4575 4590 1 1160 12516 98 GOLD SANITARY PAD NULL 9610091 5 0.0 250.0 0.0 0.0 0.0 0.0 0.0 1250.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 INR 1 0.0 0.0 2026-05-07 23:21:54
4576 4591 1 1161 12554 98 GOLD SANITARY PAD NULL 9610091 5 0.0 250.0 0.0 0.0 0.0 0.0 0.0 1250.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 INR 2 0.0 0.0 2026-05-07 23:23:50
4577 4592 1 1162 12555 98 GOLD SANITARY PAD NULL 9610091 9 0.0 250.0 0.0 0.0 0.0 0.0 0.0 2250.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 INR 3 0.0 0.0 2026-05-07 23:26:07
4578 4593 1 1163 12555 98 GOLD SANITARY PAD NULL 9610091 9 0.0 250.0 0.0 0.0 0.0 0.0 0.0 2250.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 INR 3 0.0 0.0 2026-05-07 23:26:08
4579 4594 1 1164 12555 98 GOLD SANITARY PAD NULL 9610091 9 0.0 250.0 0.0 0.0 0.0 0.0 0.0 2250.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 INR 3 0.0 0.0 2026-05-07 23:26:09
4580 4595 1 1165 12526 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-05-08 10:18:19
4581 4596 2 1165 12526 9 Omega 369 NULL 2936900 3 360.0 999.0 0.0 0.0 720.0 685.71 34.29 2997.0 1080.0 2160.0 2.5 51.43 2.5 51.43 0.0 0.0 2057.14 102.86 2160.0 INR 3 2.0 41.14 2026-05-08 10:18:19
4582 4597 3 1165 12526 35 Sanitary Pad (15 pcs) NULL 9619001 5 150.0 380.0 0.0 0.0 304.0 304.0 0.0 1900.0 750.0 1520.0 0.0 0.0 0.0 0.0 0.0 0.0 1520.0 0.0 1520.0 INR 3 2.0 30.4 2026-05-08 10:18:19
4583 4598 4 1165 12526 34 Toothpaste NULL 33061090 6 55.0 199.0 0.0 0.0 159.0 134.75 24.25 1194.0 330.0 954.0 9.0 72.76 9.0 72.76 0.0 0.0 808.47 145.53 954.0 INR 3 2.0 16.17 2026-05-08 10:18:19
4584 4599 1 1166 12526 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-05-08 10:29:39
4585 4600 2 1166 12526 53 Terra care 2 kg NULL 3103100 1 575.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 1500.0 575.0 1150.0 2.5 27.38 2.5 27.38 0.0 0.0 1095.24 54.76 1150.0 INR 3 2.0 21.9 2026-05-08 10:29:39
4586 4601 1 1167 12526 39 Fabric Wash 1000ml NULL 34029099 6 112.0 401.0 0.0 0.0 321.0 272.03 48.97 2406.0 672.0 1926.0 9.0 146.9 9.0 146.9 0.0 0.0 1632.2 293.8 1926.0 INR 3 2.0 32.64 2026-05-08 10:31:16
4587 4602 1 1168 12545 79 ALKALINE JAR NULL 8421 1 3300.0 14499.0 0.0 0.0 6000.0 5084.75 915.25 14499.0 3300.0 6000.0 9.0 457.63 9.0 457.63 0.0 0.0 5084.75 915.25 6000.0 INR 3 2.0 101.69 2026-05-09 13:00:52
4588 4603 2 1168 12545 68 DOUBLE WELLNESS BED 6 BY 6 SET NULL 94041000 1 9250.0 23999.0 0.0 0.0 18500.0 17619.05 880.95 23999.0 9250.0 18500.0 2.5 440.48 2.5 440.48 0.0 0.0 17619.05 880.95 18500.0 INR 3 2.0 352.38 2026-05-09 13:00:52
4589 4604 1 1169 12545 37 Floor Cleaner 500ml NULL 3924101 3 55.0 199.0 0.0 0.0 159.0 134.75 24.25 597.0 165.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-05-09 13:08:28
4590 4605 1 1170 12554 28 Ortho Joint Shield NULL 2009899 27 600.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 40473.0 16200.0 32400.0 2.5 771.43 2.5 771.43 0.0 0.0 30857.14 1542.86 32400.0 INR 2 6.0 1851.43 2026-05-09 18:05:15
4591 4606 1 1171 12555 28 Ortho Joint Shield NULL 2009899 27 600.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 40473.0 16200.0 32400.0 2.5 771.43 2.5 771.43 0.0 0.0 30857.14 1542.86 32400.0 INR 3 2.0 617.14 2026-05-09 18:07:18
4592 4607 1 1172 12555 64 Bio magnetic bracelet NULL 9404 5 1250.0 9999.0 0.0 0.0 2500.0 2427.18 72.82 49995.0 6250.0 12500.0 1.5 182.04 1.5 182.04 0.0 0.0 12135.92 364.08 12500.0 INR 3 2.0 242.72 2026-05-09 22:53:38
4593 4608 1 1173 12555 54 Wonder grow 100ml NULL 3105 5 600.0 1400.0 0.0 0.0 1200.0 1142.86 57.14 7000.0 3000.0 6000.0 2.5 142.86 2.5 142.86 0.0 0.0 5714.29 285.71 6000.0 INR 3 2.0 114.29 2026-05-10 13:31:22
4594 4609 1 1174 12555 56 Micro magic 500ml NULL 3105 9 825.0 2030.0 0.0 0.0 1650.0 1571.43 78.57 18270.0 7425.0 14850.0 2.5 353.57 2.5 353.57 0.0 0.0 14142.86 707.14 14850.0 INR 3 2.0 282.86 2026-05-10 13:41:11
4595 4610 1 1175 14902 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-05-10 21:09:55
4596 4611 2 1175 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-05-10 21:09:55
4597 4612 3 1175 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-05-10 21:09:55
4598 4613 4 1175 14902 33 HALDI CHANDAN SOAP 100gm NULL 30049011 30 35.0 100.0 0.0 0.0 80.0 76.19 3.81 3000.0 1050.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-05-10 21:09:55
4599 4614 5 1175 14902 15 KIDNEY CARE JUICE NULL 2009899 1 150.0 349.0 0.0 0.0 300.0 285.71 14.29 349.0 150.0 300.0 2.5 7.14 2.5 7.14 0.0 0.0 285.71 14.29 300.0 INR 3 2.0 5.71 2026-05-10 21:09:55
4600 4615 6 1175 14902 28 Ortho Joint Shield 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-05-10 21:09:55