fx_franchise_order_product

4,933 rows · 33 columns · page 48 / 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
2351 2364 1 513 13438 81 PREMIUM GLOW FACE WASH NULL 3404 1 0.0 699.0 0.0 0.0 559.0 512.84 46.16 699.0 0.0 559.0 0.0 0.0 0.0 0.0 9.0 46.16 512.84 46.16 559.0 INR 0 0.0 0.0 2025-12-27 20:00:35
2352 2365 2 513 13438 43 Quench Kiss Lip Balm NULL 3304300 1 0.0 199.0 0.0 0.0 159.0 134.75 24.25 199.0 0.0 159.0 0.0 0.0 0.0 0.0 18.0 24.25 134.75 24.25 159.0 INR 0 0.0 0.0 2025-12-27 20:00:35
2353 2366 1 514 13438 62 3*6 BED WITH BRACELET NULL 94041000 1 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 12999.0 0.0 7980.0 0.0 0.0 0.0 0.0 3.0 232.43 7747.57 232.43 7980.0 INR 0 0.0 0.0 2025-12-27 20:13:25
2354 2367 1 515 12542 62 3*6 BED WITH BRACELET NULL 94041000 5 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 64995.0 0.0 39900.0 0.0 0.0 0.0 0.0 3.0 1162.14 7747.57 1162.14 39900.0 INR 0 0.0 0.0 2025-12-29 10:45:08
2355 2368 1 516 12554 62 3*6 BED WITH BRACELET NULL 94041000 10 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 129990.0 0.0 79800.0 1.5 1162.14 1.5 1162.14 0.0 0.0 7747.57 2324.27 79800.0 INR 0 0.0 0.0 2025-12-29 10:58:37
2356 2369 1 517 12516 62 3*6 BED WITH BRACELET NULL 94041000 1 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 12999.0 0.0 7980.0 1.5 116.21 1.5 116.21 0.0 0.0 7747.57 232.43 7980.0 INR 0 0.0 0.0 2025-12-29 10:59:11
2357 2370 1 518 12516 62 3*6 BED WITH BRACELET NULL 94041000 5 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 64995.0 0.0 39900.0 1.5 581.07 1.5 581.07 0.0 0.0 7747.57 1162.14 39900.0 INR 0 0.0 0.0 2025-12-29 11:00:17
2358 2371 1 519 12555 30 Iron Capsules NULL 30049011 10 0.0 899.0 0.0 0.0 719.0 684.76 34.24 8990.0 0.0 7190.0 2.5 171.19 2.5 171.19 0.0 0.0 684.76 342.38 7190.0 INR 0 0.0 0.0 2025-12-29 13:03:02
2359 2372 1 520 12554 10 SOUNDARYA VEDA RADIANCE DAY CREAM NULL 33049910 30 0.0 1424.0 0.0 0.0 750.0 714.29 35.71 42720.0 0.0 22500.0 2.5 535.71 2.5 535.71 0.0 0.0 714.29 1071.43 22500.0 INR 0 0.0 0.0 2025-12-30 11:22:32
2360 2373 1 521 12516 10 SOUNDARYA VEDA RADIANCE DAY CREAM NULL 33049910 40 0.0 1424.0 0.0 0.0 750.0 714.29 35.71 56960.0 0.0 30000.0 2.5 714.29 2.5 714.29 0.0 0.0 714.29 1428.57 30000.0 INR 0 0.0 0.0 2025-12-30 11:24:31
2361 2374 1 522 12555 10 SOUNDARYA VEDA RADIANCE DAY CREAM NULL 33049910 30 0.0 1424.0 0.0 0.0 750.0 714.29 35.71 42720.0 0.0 22500.0 2.5 535.71 2.5 535.71 0.0 0.0 714.29 1071.43 22500.0 INR 0 0.0 0.0 2025-12-30 11:31:11
2362 2375 1 523 12555 4 Diabetic Care Capsules NULL 2936900 10 0.0 999.0 0.0 0.0 720.0 685.71 34.29 9990.0 0.0 7200.0 2.5 171.43 2.5 171.43 0.0 0.0 685.71 342.86 7200.0 INR 0 0.0 0.0 2025-12-30 16:58:51
2363 2376 1 524 12555 36 Toilet Cleaner 500ml NULL 3924101 50 0.0 150.0 0.0 0.0 120.0 101.69 18.31 7500.0 0.0 6000.0 9.0 457.63 9.0 457.63 0.0 0.0 101.69 915.25 6000.0 INR 0 0.0 0.0 2025-12-30 18:37:35
2364 2377 1 525 12555 32 Neem Soap 100gm NULL 34011110 500 0.0 60.0 0.0 0.0 48.0 45.71 2.29 30000.0 0.0 24000.0 2.5 571.43 2.5 571.43 0.0 0.0 45.71 1142.86 24000.0 INR 0 0.0 0.0 2025-12-30 22:52:30
2365 2378 1 526 12554 32 Neem Soap 100gm NULL 34011110 1000 0.0 60.0 0.0 0.0 48.0 45.71 2.29 60000.0 0.0 48000.0 2.5 1142.86 2.5 1142.86 0.0 0.0 45.71 2285.71 48000.0 INR 0 0.0 0.0 2025-12-30 22:53:18
2366 2379 1 527 12516 32 Neem Soap 100gm NULL 34011110 1500 0.0 60.0 0.0 0.0 48.0 45.71 2.29 90000.0 0.0 72000.0 2.5 1714.29 2.5 1714.29 0.0 0.0 45.71 3428.57 72000.0 INR 0 0.0 0.0 2025-12-30 22:54:07
2367 2380 1 528 12542 62 3*6 BED WITH BRACELET NULL 94041000 2 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 25998.0 0.0 15960.0 0.0 0.0 0.0 0.0 3.0 464.85 7747.57 464.85 15960.0 INR 0 0.0 0.0 2025-12-31 11:26:11
2368 2381 1 529 12555 62 3*6 BED WITH BRACELET NULL 94041000 15 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 194985.0 0.0 119700.0 1.5 1743.2 1.5 1743.2 0.0 0.0 7747.57 3486.41 119700.0 INR 0 0.0 0.0 2025-12-31 12:02:14
2369 2382 1 530 12555 62 3*6 BED WITH BRACELET NULL 94041000 10 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 129990.0 0.0 79800.0 1.5 1162.14 1.5 1162.14 0.0 0.0 7747.57 2324.27 79800.0 INR 0 0.0 0.0 2026-01-01 13:22:12
2370 2383 1 531 12555 12 P RADIANCE FACE SERUM NULL 33049990 10 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 12500.0 0.0 7500.0 2.5 178.57 2.5 178.57 0.0 0.0 714.29 357.14 7500.0 INR 0 0.0 0.0 2026-01-01 13:30:52
2371 2384 1 532 12542 62 3*6 BED WITH BRACELET NULL 94041000 10 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 129990.0 0.0 79800.0 0.0 0.0 0.0 0.0 3.0 2324.27 7747.57 2324.27 79800.0 INR 0 0.0 0.0 2026-01-01 15:28:02
2372 2385 1 533 12554 62 3*6 BED WITH BRACELET NULL 94041000 20 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 259980.0 0.0 159600.0 1.5 2324.27 1.5 2324.27 0.0 0.0 7747.57 4648.54 159600.0 INR 0 0.0 0.0 2026-01-01 15:45:33
2373 2386 1 534 12516 62 3*6 BED WITH BRACELET NULL 94041000 30 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 389970.0 0.0 239400.0 1.5 3486.41 1.5 3486.41 0.0 0.0 7747.57 6972.82 239400.0 INR 0 0.0 0.0 2026-01-01 15:46:16
2374 2387 1 535 12555 62 3*6 BED WITH BRACELET NULL 94041000 20 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 259980.0 0.0 159600.0 1.5 2324.27 1.5 2324.27 0.0 0.0 7747.57 4648.54 159600.0 INR 0 0.0 0.0 2026-01-01 16:26:55
2375 2388 2 535 12555 63 6*6 bio magnetic bed WITH bracelet NULL 94041000 10 0.0 21999.0 0.0 0.0 14999.0 14562.14 436.86 219990.0 0.0 149990.0 1.5 2184.32 1.5 2184.32 0.0 0.0 14562.14 4368.64 149990.0 INR 0 0.0 0.0 2026-01-01 16:26:55
2376 2389 1 536 12554 62 3*6 BED WITH BRACELET NULL 94041000 10 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 129990.0 0.0 79800.0 1.5 1162.14 1.5 1162.14 0.0 0.0 7747.57 2324.27 79800.0 INR 0 0.0 0.0 2026-01-01 16:27:51
2377 2390 1 537 12555 62 3*6 BED WITH BRACELET NULL 94041000 5 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 64995.0 0.0 39900.0 1.5 581.07 1.5 581.07 0.0 0.0 7747.57 1162.14 39900.0 INR 0 0.0 0.0 2026-01-01 22:47:09
2378 2391 1 538 12554 62 3*6 BED WITH BRACELET NULL 94041000 30 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 389970.0 0.0 239400.0 1.5 3486.41 1.5 3486.41 0.0 0.0 7747.57 6972.82 239400.0 INR 0 0.0 0.0 2026-01-01 22:48:02
2379 2392 1 539 12516 62 3*6 BED WITH BRACELET NULL 94041000 30 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 389970.0 0.0 239400.0 1.5 3486.41 1.5 3486.41 0.0 0.0 7747.57 6972.82 239400.0 INR 0 0.0 0.0 2026-01-01 22:48:42
2380 2393 1 540 12555 62 3*6 BED WITH BRACELET NULL 94041000 3 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 38997.0 0.0 23940.0 1.5 348.64 1.5 348.64 0.0 0.0 7747.57 697.28 23940.0 INR 0 0.0 0.0 2026-01-01 22:50:54
2381 2394 1 541 12554 62 3*6 BED WITH BRACELET NULL 94041000 30 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 389970.0 0.0 239400.0 1.5 3486.41 1.5 3486.41 0.0 0.0 7747.57 6972.82 239400.0 INR 0 0.0 0.0 2026-01-02 11:17:13
2382 2395 1 542 12555 62 3*6 BED WITH BRACELET NULL 94041000 20 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 259980.0 0.0 159600.0 1.5 2324.27 1.5 2324.27 0.0 0.0 7747.57 4648.54 159600.0 INR 0 0.0 0.0 2026-01-02 11:20:49
2383 2396 1 543 12516 62 3*6 BED WITH BRACELET NULL 94041000 30 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 389970.0 0.0 239400.0 1.5 3486.41 1.5 3486.41 0.0 0.0 7747.57 6972.82 239400.0 INR 0 0.0 0.0 2026-01-02 16:48:57
2384 2397 1 544 12554 62 3*6 BED WITH BRACELET NULL 94041000 30 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 389970.0 0.0 239400.0 1.5 3486.41 1.5 3486.41 0.0 0.0 7747.57 6972.82 239400.0 INR 0 0.0 0.0 2026-01-02 16:49:26
2385 2398 1 545 12555 62 3*6 BED WITH BRACELET NULL 94041000 20 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 259980.0 0.0 159600.0 1.5 2324.27 1.5 2324.27 0.0 0.0 7747.57 4648.54 159600.0 INR 0 0.0 0.0 2026-01-02 16:50:22
2386 2399 1 546 13438 46 Root Vitality Hair Oil NULL 3305901 3 0.0 255.0 0.0 0.0 204.0 194.29 9.71 765.0 0.0 612.0 0.0 0.0 0.0 0.0 5.0 29.14 194.29 29.14 612.0 INR 0 0.0 0.0 2026-01-02 17:08:48
2387 2400 1 547 12554 10 SOUNDARYA VEDA RADIANCE DAY CREAM NULL 33049910 10 0.0 1424.0 0.0 0.0 750.0 714.29 35.71 14240.0 0.0 7500.0 2.5 178.57 2.5 178.57 0.0 0.0 714.29 357.14 7500.0 INR 0 0.0 0.0 2026-01-02 17:23:29
2388 2401 1 548 13438 10 SOUNDARYA VEDA RADIANCE DAY CREAM NULL 33049910 2 0.0 1424.0 0.0 0.0 750.0 714.29 35.71 2848.0 0.0 1500.0 0.0 0.0 0.0 0.0 5.0 71.43 714.29 71.43 1500.0 INR 0 0.0 0.0 2026-01-02 17:27:48
2389 2402 1 549 12555 62 3*6 BED WITH BRACELET NULL 94041000 10 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 129990.0 0.0 79800.0 1.5 1162.14 1.5 1162.14 0.0 0.0 7747.57 2324.27 79800.0 INR 0 0.0 0.0 2026-01-02 17:42:07
2390 2403 1 550 12554 43 Quench Kiss Lip Balm NULL 3304300 10 0.0 199.0 0.0 0.0 159.0 134.75 24.25 1990.0 0.0 1590.0 9.0 121.27 9.0 121.27 0.0 0.0 134.75 242.54 1590.0 INR 0 0.0 0.0 2026-01-02 17:52:14
2391 2404 1 551 12554 52 Bhoo sanjeevni 5 kg NULL 3103100 10 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 16000.0 0.0 12500.0 2.5 297.62 2.5 297.62 0.0 0.0 1190.48 595.24 12500.0 INR 0 0.0 0.0 2026-01-02 18:01:14
2392 2405 1 552 12527 62 3*6 BED WITH BRACELET NULL 94041000 6 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 77994.0 0.0 47880.0 0.0 0.0 0.0 0.0 3.0 1394.56 7747.57 1394.56 47880.0 INR 0 0.0 0.0 2026-01-02 18:05:33
2393 2406 2 552 12527 63 6*6 bio magnetic bed WITH bracelet NULL 94041000 1 0.0 21999.0 0.0 0.0 14999.0 14562.14 436.86 21999.0 0.0 14999.0 0.0 0.0 0.0 0.0 3.0 436.86 14562.14 436.86 14999.0 INR 0 0.0 0.0 2026-01-02 18:05:33
2394 2407 3 552 12527 52 Bhoo sanjeevni 5 kg NULL 3103100 5 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 8000.0 0.0 6250.0 0.0 0.0 0.0 0.0 5.0 297.62 1190.48 297.62 6250.0 INR 0 0.0 0.0 2026-01-02 18:05:33
2395 2408 4 552 12527 19 Fat loss Juice 500 ml NULL 30049011 2 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 2998.0 0.0 2400.0 0.0 0.0 0.0 0.0 5.0 114.29 1142.86 114.29 2400.0 INR 0 0.0 0.0 2026-01-02 18:05:33
2396 2409 5 552 12527 33 Herbal Soap 100gm NULL 30049011 100 0.0 100.0 0.0 0.0 80.0 76.19 3.81 10000.0 0.0 8000.0 0.0 0.0 0.0 0.0 5.0 380.95 76.19 380.95 8000.0 INR 0 0.0 0.0 2026-01-02 18:05:33
2397 2410 6 552 12527 32 Neem Soap 100gm NULL 34011110 300 0.0 60.0 0.0 0.0 48.0 45.71 2.29 18000.0 0.0 14400.0 0.0 0.0 0.0 0.0 5.0 685.71 45.71 685.71 14400.0 INR 0 0.0 0.0 2026-01-02 18:05:33
2398 2411 7 552 12527 41 Premium Coco Body Lotion NULL 3304300 5 0.0 699.0 0.0 0.0 559.0 473.73 85.27 3495.0 0.0 2795.0 0.0 0.0 0.0 0.0 18.0 426.36 473.73 426.36 2795.0 INR 0 0.0 0.0 2026-01-02 18:05:33
2399 2412 8 552 12527 43 Quench Kiss Lip Balm NULL 3304300 10 0.0 199.0 0.0 0.0 159.0 134.75 24.25 1990.0 0.0 1590.0 0.0 0.0 0.0 0.0 18.0 242.54 134.75 242.54 1590.0 INR 0 0.0 0.0 2026-01-02 18:05:33
2400 2413 9 552 12527 46 Root Vitality Hair Oil NULL 3305901 20 0.0 255.0 0.0 0.0 204.0 194.29 9.71 5100.0 0.0 4080.0 0.0 0.0 0.0 0.0 5.0 194.29 194.29 194.29 4080.0 INR 0 0.0 0.0 2026-01-02 18:05:33