fx_franchise_order_product

4,933 rows · 33 columns · page 36 / 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
1751 1764 6 204 12516 32 Neem Soap 100gm NULL 34011110 1000 10.0 60.0 0.0 0.0 48.0 45.71 2.29 60000.0 10000.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-11-12 12:29:52
1752 1765 7 204 12516 1 Stem Cell Powder NULL 2936900 100 749.0 2499.0 0.0 0.0 1999.2 1904.0 95.2 249900.0 74900.0 199920.0 2.5 4760.0 2.5 4760.0 0.0 0.0 1904.0 9520.0 199920.0 INR 0 0.0 0.0 2025-11-12 12:29:52
1753 1766 8 204 12516 36 Toilet Cleaner 500ml NULL 3924101 100 30.0 150.0 0.0 0.0 120.0 101.69 18.31 15000.0 3000.0 12000.0 9.0 915.25 9.0 915.25 0.0 0.0 101.69 1830.51 12000.0 INR 0 0.0 0.0 2025-11-12 12:29:52
1754 1767 1 205 12554 7 Morning Fresh Churan NULL 30049011 50 40.0 199.0 0.0 0.0 159.2 151.62 7.58 9950.0 2000.0 7960.0 2.5 189.53 2.5 189.53 0.0 0.0 151.62 379.05 7960.0 INR 0 0.0 0.0 2025-11-12 12:37:16
1755 1768 1 206 12517 33 Herbal Soap 100gm NULL 30049011 1 28.0 100.0 0.0 0.0 80.0 76.19 3.81 100.0 28.0 80.0 0.0 0.0 0.0 0.0 5.0 3.81 76.19 3.81 80.0 INR 0 0.0 0.0 2025-11-12 12:37:41
1756 1769 1 207 12517 52 Bhoo sanjeevni 5 kg NULL 3103100 8 450.0 1600.0 0.0 0.0 1280.0 1219.05 60.95 12800.0 3600.0 10240.0 0.0 0.0 0.0 0.0 5.0 487.62 1219.05 487.62 10240.0 INR 0 0.0 0.0 2025-11-12 12:40:36
1757 1770 2 207 12517 33 Herbal Soap 100gm NULL 30049011 1500 28.0 100.0 0.0 0.0 80.0 76.19 3.81 150000.0 42000.0 120000.0 0.0 0.0 0.0 0.0 5.0 5714.29 76.19 5714.29 120000.0 INR 0 0.0 0.0 2025-11-12 12:40:36
1758 1771 3 207 12517 34 Herbo2o Toothpaste NULL 33061090 1000 45.0 199.0 0.0 0.0 159.2 134.92 24.28 199000.0 45000.0 159200.0 0.0 0.0 0.0 0.0 18.0 24284.75 134.92 24284.75 159200.0 INR 0 0.0 0.0 2025-11-12 12:40:36
1759 1772 4 207 12517 32 Neem Soap 100gm NULL 34011110 3000 10.0 60.0 0.0 0.0 48.0 45.71 2.29 180000.0 30000.0 144000.0 0.0 0.0 0.0 0.0 5.0 6857.14 45.71 6857.14 144000.0 INR 0 0.0 0.0 2025-11-12 12:40:36
1760 1773 5 207 12517 53 Terra care 2 kg NULL 3103100 8 450.0 1500.0 0.0 0.0 1200.0 1142.86 57.14 12000.0 3600.0 9600.0 0.0 0.0 0.0 0.0 5.0 457.14 1142.86 457.14 9600.0 INR 0 0.0 0.0 2025-11-12 12:40:36
1761 1774 1 208 12516 33 Herbal Soap 100gm NULL 30049011 1000 28.0 100.0 0.0 0.0 80.0 76.19 3.81 100000.0 28000.0 80000.0 2.5 1904.76 2.5 1904.76 0.0 0.0 76.19 3809.52 80000.0 INR 0 0.0 0.0 2025-11-12 12:44:00
1762 1775 2 208 12516 32 Neem Soap 100gm NULL 34011110 1000 10.0 60.0 0.0 0.0 48.0 45.71 2.29 60000.0 10000.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-11-12 12:44:00
1763 1776 1 209 12516 33 Herbal Soap 100gm NULL 30049011 1000 28.0 100.0 0.0 0.0 80.0 76.19 3.81 100000.0 28000.0 80000.0 2.5 1904.76 2.5 1904.76 0.0 0.0 76.19 3809.52 80000.0 INR 0 0.0 0.0 2025-11-12 12:45:38
1764 1777 2 209 12516 32 Neem Soap 100gm NULL 34011110 1000 10.0 60.0 0.0 0.0 48.0 45.71 2.29 60000.0 10000.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-11-12 12:45:38
1765 1778 1 210 12516 33 Herbal Soap 100gm NULL 30049011 1000 28.0 100.0 0.0 0.0 80.0 76.19 3.81 100000.0 28000.0 80000.0 2.5 1904.76 2.5 1904.76 0.0 0.0 76.19 3809.52 80000.0 INR 0 0.0 0.0 2025-11-12 12:53:28
1766 1779 2 210 12516 34 Herbo2o Toothpaste NULL 33061090 500 45.0 199.0 0.0 0.0 159.2 134.92 24.28 99500.0 22500.0 79600.0 9.0 6071.19 9.0 6071.19 0.0 0.0 134.92 12142.37 79600.0 INR 0 0.0 0.0 2025-11-12 12:53:28
1767 1780 3 210 12516 32 Neem Soap 100gm NULL 34011110 1000 10.0 60.0 0.0 0.0 48.0 45.71 2.29 60000.0 10000.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-11-12 12:53:28
1768 1781 1 211 12516 33 Herbal Soap 100gm NULL 30049011 3000 28.0 100.0 0.0 0.0 80.0 76.19 3.81 300000.0 84000.0 240000.0 2.5 5714.28 2.5 5714.28 0.0 0.0 76.19 11428.57 240000.0 INR 0 0.0 0.0 2025-11-12 13:02:37
1769 1782 2 211 12516 34 Herbo2o Toothpaste NULL 33061090 1000 45.0 199.0 0.0 0.0 159.2 134.92 24.28 199000.0 45000.0 159200.0 9.0 12142.38 9.0 12142.38 0.0 0.0 134.92 24284.75 159200.0 INR 0 0.0 0.0 2025-11-12 13:02:37
1770 1783 3 211 12516 32 Neem Soap 100gm NULL 34011110 5000 10.0 60.0 0.0 0.0 48.0 45.71 2.29 300000.0 50000.0 240000.0 2.5 5714.28 2.5 5714.28 0.0 0.0 45.71 11428.57 240000.0 INR 0 0.0 0.0 2025-11-12 13:02:37
1771 1784 1 212 12555 1 Stem Cell Powder NULL 2936900 100 749.0 2499.0 0.0 0.0 1999.2 1904.0 95.2 249900.0 74900.0 199920.0 2.5 4760.0 2.5 4760.0 0.0 0.0 1904.0 9520.0 199920.0 INR 0 0.0 0.0 2025-11-12 13:10:21
1772 1785 1 213 12555 4 Diabetic Care Capsules NULL 2936900 20 250.0 899.0 0.0 0.0 719.2 684.95 34.25 17980.0 5000.0 14384.0 2.5 342.48 2.5 342.48 0.0 0.0 684.95 684.95 14384.0 INR 0 0.0 0.0 2025-11-12 13:22:45
1773 1786 1 214 12555 3 BP Care Capsules NULL 2936900 20 160.0 599.0 0.0 0.0 479.2 456.38 22.82 11980.0 3200.0 9584.0 2.5 228.19 2.5 228.19 0.0 0.0 456.38 456.38 9584.0 INR 0 0.0 0.0 2025-11-12 13:24:03
1774 1787 1 215 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-12 14:02:23
1775 1788 2 215 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-12 14:02:23
1776 1789 1 216 12517 48 glow face wash NULL 3304999 18 250.0 380.0 0.0 0.0 304.0 257.63 46.37 6840.0 4500.0 5472.0 0.0 0.0 0.0 0.0 18.0 834.71 257.63 834.71 5472.0 INR 0 0.0 0.0 2025-11-12 14:23:23
1777 1790 2 216 12517 70 Premium Hand belt NULL 9404 5 600.0 9999.0 0.0 0.0 1440.0 1371.43 68.57 49995.0 3000.0 7200.0 0.0 0.0 0.0 0.0 5.0 342.86 1371.43 342.86 7200.0 INR 0 0.0 0.0 2025-11-12 14:23:23
1778 1791 3 216 12517 40 Bamboo Brush NULL 96032100 10 25.0 110.0 0.0 0.0 88.0 74.58 13.42 1100.0 250.0 880.0 0.0 0.0 0.0 0.0 18.0 134.24 74.58 134.24 880.0 INR 0 0.0 0.0 2025-11-12 14:23:23
1779 1792 4 216 12517 7 Morning Fresh Churan NULL 30049011 34 40.0 199.0 0.0 0.0 159.2 151.62 7.58 6766.0 1360.0 5412.8 0.0 0.0 0.0 0.0 5.0 257.75 151.62 257.75 5412.8 INR 0 0.0 0.0 2025-11-12 14:23:23
1780 1793 5 216 12517 41 Premium Coco Body Lotion NULL 3304300 3 250.0 699.0 0.0 0.0 559.2 473.9 85.3 2097.0 750.0 1677.6 0.0 0.0 0.0 0.0 18.0 255.91 473.9 255.91 1677.6 INR 0 0.0 0.0 2025-11-12 14:23:23
1781 1794 6 216 12517 42 Premium Glow Charm Fairness Cream NULL 33049990 8 80.0 399.0 0.0 0.0 319.2 270.51 48.69 3192.0 640.0 2553.6 0.0 0.0 0.0 0.0 18.0 389.53 270.51 389.53 2553.6 INR 0 0.0 0.0 2025-11-12 14:23:23
1782 1795 7 216 12517 43 Quench Kiss Lip Balm NULL 3304300 10 35.0 199.0 0.0 0.0 159.2 134.92 24.29 1990.0 350.0 1592.0 0.0 0.0 0.0 0.0 18.0 242.85 134.92 242.85 1592.0 INR 0 0.0 0.0 2025-11-12 14:23:23
1783 1796 8 216 12517 46 Root Vitality Hair Oil NULL 3305901 100 54.0 255.0 0.0 0.0 204.0 194.29 9.71 25500.0 5400.0 20400.0 0.0 0.0 0.0 0.0 5.0 971.43 194.29 971.43 20400.0 INR 0 0.0 0.0 2025-11-12 14:23:23
1784 1797 9 216 12517 11 Vitamin B12 Drop NULL 2106909 7 190.0 749.0 0.0 0.0 599.2 570.67 28.53 5243.0 1330.0 4194.4 0.0 0.0 0.0 0.0 5.0 199.73 570.67 199.73 4194.4 INR 0 0.0 0.0 2025-11-12 14:23:23
1785 1798 10 216 12517 54 Wonder grow 100ml NULL 3105 3 500.0 1400.0 0.0 0.0 1120.0 1066.67 53.33 4200.0 1500.0 3360.0 0.0 0.0 0.0 0.0 5.0 160.0 1066.67 160.0 3360.0 INR 0 0.0 0.0 2025-11-12 14:23:23
1786 1799 1 217 12516 48 glow face wash NULL 3304999 20 250.0 380.0 0.0 0.0 304.0 257.63 46.37 7600.0 5000.0 6080.0 9.0 463.73 9.0 463.73 0.0 0.0 257.63 927.46 6080.0 INR 0 0.0 0.0 2025-11-12 15:14:55
1787 1800 2 217 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-12 15:14:55
1788 1801 3 217 12516 7 Morning Fresh Churan NULL 30049011 50 40.0 199.0 0.0 0.0 159.2 151.62 7.58 9950.0 2000.0 7960.0 2.5 189.53 2.5 189.53 0.0 0.0 151.62 379.05 7960.0 INR 0 0.0 0.0 2025-11-12 15:14:55
1789 1802 4 217 12516 41 Premium Coco Body Lotion NULL 3304300 10 250.0 699.0 0.0 0.0 559.2 473.9 85.3 6990.0 2500.0 5592.0 9.0 426.51 9.0 426.51 0.0 0.0 473.9 853.02 5592.0 INR 0 0.0 0.0 2025-11-12 15:14:55
1790 1803 5 217 12516 42 Premium Glow Charm Fairness Cream NULL 33049990 20 80.0 399.0 0.0 0.0 319.2 270.51 48.69 7980.0 1600.0 6384.0 9.0 486.92 9.0 486.92 0.0 0.0 270.51 973.83 6384.0 INR 0 0.0 0.0 2025-11-12 15:14:55
1791 1804 6 217 12516 43 Quench Kiss Lip Balm NULL 3304300 10 35.0 199.0 0.0 0.0 159.2 134.92 24.29 1990.0 350.0 1592.0 9.0 121.42 9.0 121.42 0.0 0.0 134.92 242.85 1592.0 INR 0 0.0 0.0 2025-11-12 15:14:55
1792 1805 7 217 12516 46 Root Vitality Hair Oil NULL 3305901 120 54.0 255.0 0.0 0.0 204.0 194.29 9.71 30600.0 6480.0 24480.0 2.5 582.86 2.5 582.86 0.0 0.0 194.29 1165.71 24480.0 INR 0 0.0 0.0 2025-11-12 15:14:55
1793 1806 8 217 12516 11 Vitamin B12 Drop NULL 2106909 10 190.0 749.0 0.0 0.0 599.2 570.67 28.53 7490.0 1900.0 5992.0 2.5 142.66 2.5 142.66 0.0 0.0 570.67 285.33 5992.0 INR 0 0.0 0.0 2025-11-12 15:14:55
1794 1807 9 217 12516 54 Wonder grow 100ml NULL 3105 10 500.0 1400.0 0.0 0.0 1120.0 1066.67 53.33 14000.0 5000.0 11200.0 2.5 266.67 2.5 266.67 0.0 0.0 1066.67 533.33 11200.0 INR 0 0.0 0.0 2025-11-12 15:14:55
1795 1808 1 218 12516 40 Bamboo Brush NULL 96032100 20 25.0 110.0 0.0 0.0 88.0 74.58 13.42 2200.0 500.0 1760.0 9.0 134.24 9.0 134.24 0.0 0.0 74.58 268.47 1760.0 INR 0 0.0 0.0 2025-11-12 15:20:18
1796 1809 1 219 12527 32 Neem Soap 100gm NULL 34011110 200 10.0 60.0 0.0 0.0 48.0 45.71 2.29 12000.0 2000.0 9600.0 2.5 228.57 2.5 228.57 0.0 0.0 45.71 457.14 9600.0 INR 0 0.0 0.0 2025-11-12 16:25:14
1797 1810 1 220 12516 48 glow face wash NULL 3304999 50 250.0 380.0 0.0 0.0 304.0 257.63 46.37 19000.0 12500.0 15200.0 9.0 1159.32 9.0 1159.32 0.0 0.0 257.63 2318.64 15200.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1798 1811 2 220 12516 61 Radiation chip NULL 902221 109 325.0 999.0 0.0 0.0 799.2 677.29 121.91 108891.0 35425.0 87112.8 9.0 6644.19 9.0 6644.19 0.0 0.0 677.29 13288.39 87112.8 INR 0 0.0 0.0 2025-11-12 17:31:01
1799 1812 3 220 12516 31 Vegan Plant Protein Powder NULL 21061000 50 1000.0 2999.0 0.0 0.0 2399.2 2284.95 114.25 149950.0 50000.0 119960.0 2.5 2856.19 2.5 2856.19 0.0 0.0 2284.95 5712.38 119960.0 INR 0 0.0 0.0 2025-11-12 17:31:01
1800 1813 4 220 12516 49 Anti Dandruff Serum NULL 3304999 50 250.0 999.0 0.0 0.0 799.2 677.29 121.91 49950.0 12500.0 39960.0 9.0 3047.8 9.0 3047.8 0.0 0.0 677.29 6095.59 39960.0 INR 0 0.0 0.0 2025-11-12 17:31:01