fx_franchise_order_product

4,933 rows · 33 columns · page 2 / 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
51 64 1 53 12552 80 BOOSTER KIT NULL NULL 1 0.0 21998.2 0.0 0.0 13699.0 11609.32 2089.68 21998.2 0.0 13699.0 9.0 1044.84 9.0 1044.84 0.0 0.0 11609.32 2089.68 13699.0 INR 0 0.0 0.0 2025-11-07 16:42:50
52 65 2 53 12552 74 EXPLORER BOX NULL NULL 3 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 80991.0 0.0 31497.0 2.5 749.93 2.5 749.93 0.0 0.0 9999.05 1499.86 31497.0 INR 0 0.0 0.0 2025-11-07 16:42:50
53 66 1 54 12540 48 glow face wash NULL 3304999 5 250.0 380.0 0.0 0.0 304.0 257.63 46.37 1900.0 1250.0 1520.0 9.0 115.93 9.0 115.93 0.0 0.0 257.63 231.86 1520.0 INR 0 0.0 0.0 2025-11-07 17:20:25
54 67 2 54 12540 27 Multicharge Cap NULL 2009899 2 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 2998.0 900.0 2398.4 2.5 57.1 2.5 57.1 0.0 0.0 1142.1 114.21 2398.4 INR 0 0.0 0.0 2025-11-07 17:20:25
55 68 3 54 12540 49 Anti Dandruff Serum NULL 3304999 2 250.0 999.0 0.0 0.0 799.2 677.29 121.91 1998.0 500.0 1598.4 9.0 121.91 9.0 121.91 0.0 0.0 677.29 243.82 1598.4 INR 0 0.0 0.0 2025-11-07 17:20:25
56 69 4 54 12540 6 Asthma Care NULL 30049011 2 250.0 899.0 0.0 0.0 719.2 684.95 34.25 1798.0 500.0 1438.4 2.5 34.25 2.5 34.25 0.0 0.0 684.95 68.5 1438.4 INR 0 0.0 0.0 2025-11-07 17:20:25
57 70 5 54 12540 40 Bamboo Brush NULL 96032100 5 25.0 110.0 0.0 0.0 88.0 74.58 13.42 550.0 125.0 440.0 9.0 33.56 9.0 33.56 0.0 0.0 74.58 67.12 440.0 INR 0 0.0 0.0 2025-11-07 17:20:25
58 71 6 54 12540 3 BP Care Capsules NULL 2936900 5 160.0 599.0 0.0 0.0 479.2 456.38 22.82 2995.0 800.0 2396.0 2.5 57.05 2.5 57.05 0.0 0.0 456.38 114.1 2396.0 INR 0 0.0 0.0 2025-11-07 17:20:25
59 72 7 54 12540 4 Diabetic Care Capsules NULL 2936900 1 250.0 899.0 0.0 0.0 719.2 684.95 34.25 899.0 250.0 719.2 2.5 17.12 2.5 17.12 0.0 0.0 684.95 34.25 719.2 INR 0 0.0 0.0 2025-11-07 17:20:25
60 73 8 54 12540 38 Dish Wash 500ml NULL 3924101 6 85.0 230.0 0.0 0.0 184.0 155.93 28.07 1380.0 510.0 1104.0 9.0 84.2 9.0 84.2 0.0 0.0 155.93 168.41 1104.0 INR 0 0.0 0.0 2025-11-07 17:20:25
61 74 9 54 12540 39 Fabric Wash 1000ml NULL 3924101 7 150.0 401.0 0.0 0.0 320.8 271.86 48.94 2807.0 1050.0 2245.6 9.0 171.28 9.0 171.28 0.0 0.0 271.86 342.55 2245.6 INR 0 0.0 0.0 2025-11-07 17:20:25
62 75 10 54 12540 37 Floor Cleaner 500ml NULL 3924101 6 80.0 199.0 0.0 0.0 159.2 134.92 24.29 1194.0 480.0 955.2 9.0 72.86 9.0 72.86 0.0 0.0 134.92 145.71 955.2 INR 0 0.0 0.0 2025-11-07 17:20:25
63 76 11 54 12540 60 Foot patch NULL 30051090 2 500.0 1999.0 0.0 0.0 1599.2 1523.05 76.15 3998.0 1000.0 3198.4 2.5 76.15 2.5 76.15 0.0 0.0 1523.05 152.3 3198.4 INR 0 0.0 0.0 2025-11-07 17:20:25
64 77 12 54 12540 33 Herbal Soap 100gm NULL 30049011 20 28.0 100.0 0.0 0.0 80.0 76.19 3.81 2000.0 560.0 1600.0 2.5 38.09 2.5 38.09 0.0 0.0 76.19 76.19 1600.0 INR 0 0.0 0.0 2025-11-07 17:20:25
65 78 13 54 12540 34 Herbo2o Toothpaste NULL 33061090 19 45.0 199.0 0.0 0.0 159.2 134.92 24.28 3781.0 855.0 3024.8 9.0 230.71 9.0 230.71 0.0 0.0 134.92 461.41 3024.8 INR 0 0.0 0.0 2025-11-07 17:20:25
66 79 14 54 12540 30 Iron Capsules NULL 30049011 5 250.0 899.0 0.0 0.0 719.2 684.95 34.25 4495.0 1250.0 3596.0 2.5 85.62 2.5 85.62 0.0 0.0 684.95 171.24 3596.0 INR 0 0.0 0.0 2025-11-07 17:20:25
67 80 15 54 12540 15 Kidney Stone Juice NULL 2009899 3 120.0 349.0 0.0 0.0 279.2 265.9 13.3 1047.0 360.0 837.6 2.5 19.95 2.5 19.95 0.0 0.0 265.9 39.89 837.6 INR 0 0.0 0.0 2025-11-07 17:20:25
68 81 16 54 12540 18 Lady Care Juice 500ml NULL 2009899 2 250.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 2998.0 500.0 2398.4 2.5 57.1 2.5 57.1 0.0 0.0 1142.1 114.21 2398.4 INR 0 0.0 0.0 2025-11-07 17:20:25
69 82 17 54 12540 12 Melatonin Drop NULL 2106909 3 190.0 749.0 0.0 0.0 599.2 570.67 28.53 2247.0 570.0 1797.6 2.5 42.8 2.5 42.8 0.0 0.0 570.67 85.6 1797.6 INR 0 0.0 0.0 2025-11-07 17:20:25
70 83 18 54 12540 17 Memory Booster Juice NULL 2009899 2 120.0 349.0 0.0 0.0 279.2 265.9 13.29 698.0 240.0 558.4 2.5 13.29 2.5 13.29 0.0 0.0 265.9 26.59 558.4 INR 0 0.0 0.0 2025-11-07 17:20:25
71 84 19 54 12540 7 Morning Fresh Churan NULL 30049011 4 40.0 199.0 0.0 0.0 159.2 151.62 7.58 796.0 160.0 636.8 2.5 15.16 2.5 15.16 0.0 0.0 151.62 30.32 636.8 INR 0 0.0 0.0 2025-11-07 17:20:25
72 85 20 54 12540 32 Neem Soap 100gm NULL 34011110 37 10.0 60.0 0.0 0.0 48.0 45.71 2.29 2220.0 370.0 1776.0 2.5 42.28 2.5 42.28 0.0 0.0 45.71 84.57 1776.0 INR 0 0.0 0.0 2025-11-07 17:20:25
73 86 21 54 12540 9 Omega 369 NULL 2936900 4 260.0 999.0 0.0 0.0 799.2 761.14 38.06 3996.0 1040.0 3196.8 2.5 76.11 2.5 76.11 0.0 0.0 761.14 152.23 3196.8 INR 0 0.0 0.0 2025-11-07 17:20:25
74 87 22 54 12540 72 Pain Relief Patch NULL 30051090 2 200.0 800.0 0.0 0.0 640.0 609.52 30.48 1600.0 400.0 1280.0 2.5 30.48 2.5 30.48 0.0 0.0 609.52 60.95 1280.0 INR 0 0.0 0.0 2025-11-07 17:20:25
75 88 23 54 12540 8 Piles Care NULL 30049011 2 250.0 899.0 0.0 0.0 719.2 684.95 34.25 1798.0 500.0 1438.4 2.5 34.25 2.5 34.25 0.0 0.0 684.95 68.5 1438.4 INR 0 0.0 0.0 2025-11-07 17:20:25
76 89 24 54 12540 47 Premium Hair Care Shampoo NULL 3305109 3 150.0 699.0 0.0 0.0 559.2 532.57 26.63 2097.0 450.0 1677.6 2.5 39.95 2.5 39.95 0.0 0.0 532.57 79.89 1677.6 INR 0 0.0 0.0 2025-11-07 17:20:25
77 90 25 54 12540 45 Premium radiance face serum NULL 3304991 4 300.0 1200.0 0.0 0.0 960.0 813.56 146.44 4800.0 1200.0 3840.0 9.0 292.88 9.0 292.88 0.0 0.0 813.56 585.76 3840.0 INR 0 0.0 0.0 2025-11-07 17:20:25
78 91 26 54 12540 43 Quench Kiss Lip Balm NULL 3304300 2 35.0 199.0 0.0 0.0 159.2 134.92 24.29 398.0 70.0 318.4 9.0 24.29 9.0 24.29 0.0 0.0 134.92 48.57 318.4 INR 0 0.0 0.0 2025-11-07 17:20:25
79 92 27 54 12540 46 Root Vitality Hair Oil NULL 3305901 3 54.0 255.0 0.0 0.0 204.0 194.29 9.71 765.0 162.0 612.0 2.5 14.57 2.5 14.57 0.0 0.0 194.29 29.14 612.0 INR 0 0.0 0.0 2025-11-07 17:20:25
80 93 28 54 12540 35 Sanitary Pad (15 pcs) NULL 9619001 6 40.0 380.0 0.0 0.0 304.0 304.0 0.0 2280.0 240.0 1824.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 1824.0 INR 0 0.0 0.0 2025-11-07 17:20:25
81 94 29 54 12540 29 Shilajith NULL 30049011 2 250.0 1800.0 0.0 0.0 1440.0 1371.43 68.57 3600.0 500.0 2880.0 2.5 68.57 2.5 68.57 0.0 0.0 1371.43 137.14 2880.0 INR 0 0.0 0.0 2025-11-07 17:20:25
82 95 30 54 12540 26 Spirulina Cap NULL 2009899 2 190.0 899.0 0.0 0.0 719.2 684.95 34.25 1798.0 380.0 1438.4 2.5 34.25 2.5 34.25 0.0 0.0 684.95 68.5 1438.4 INR 0 0.0 0.0 2025-11-07 17:20:25
83 96 31 54 12540 1 Stem Cell Powder NULL 2936900 2 749.0 2499.0 0.0 0.0 1999.2 1904.0 95.2 4998.0 1498.0 3998.4 2.5 95.2 2.5 95.2 0.0 0.0 1904.0 190.4 3998.4 INR 0 0.0 0.0 2025-11-07 17:20:25
84 97 32 54 12540 36 Toilet Cleaner 500ml NULL 3924101 6 30.0 150.0 0.0 0.0 120.0 101.69 18.3 900.0 180.0 720.0 9.0 54.91 9.0 54.91 0.0 0.0 101.69 109.83 720.0 INR 0 0.0 0.0 2025-11-07 17:20:25
85 98 33 54 12540 11 Vitamin B12 Drop NULL 2106909 3 190.0 749.0 0.0 0.0 599.2 570.67 28.53 2247.0 570.0 1797.6 2.5 42.8 2.5 42.8 0.0 0.0 570.67 85.6 1797.6 INR 0 0.0 0.0 2025-11-07 17:20:25
86 99 34 54 12540 10 Vitamin D3 Drop NULL 2106909 3 190.0 749.0 0.0 0.0 599.2 570.67 28.53 2247.0 570.0 1797.6 2.5 42.8 2.5 42.8 0.0 0.0 570.67 85.6 1797.6 INR 0 0.0 0.0 2025-11-07 17:20:25
87 100 35 54 12540 23 Women Fuel Juice NULL 2202999 2 200.0 1999.0 0.0 0.0 1599.2 1523.05 76.15 3998.0 400.0 3198.4 2.5 76.15 2.5 76.15 0.0 0.0 1523.05 152.3 3198.4 INR 0 0.0 0.0 2025-11-07 17:20:25
88 101 1 55 12533 48 glow face wash NULL 3304999 7 250.0 380.0 0.0 0.0 304.0 257.63 46.37 2660.0 1750.0 2128.0 9.0 162.31 9.0 162.31 0.0 0.0 257.63 324.61 2128.0 INR 0 0.0 0.0 2025-11-07 18:00:39
89 102 2 55 12533 40 Bamboo Brush NULL 96032100 2 25.0 110.0 0.0 0.0 88.0 74.58 13.43 220.0 50.0 176.0 9.0 13.43 9.0 13.43 0.0 0.0 74.58 26.85 176.0 INR 0 0.0 0.0 2025-11-07 18:00:39
90 103 3 55 12533 3 BP Care Capsules NULL 2936900 5 160.0 599.0 0.0 0.0 479.2 456.38 22.82 2995.0 800.0 2396.0 2.5 57.05 2.5 57.05 0.0 0.0 456.38 114.1 2396.0 INR 0 0.0 0.0 2025-11-07 18:00:39
91 104 4 55 12533 4 Diabetic Care Capsules NULL 2936900 5 250.0 899.0 0.0 0.0 719.2 684.95 34.25 4495.0 1250.0 3596.0 2.5 85.62 2.5 85.62 0.0 0.0 684.95 171.24 3596.0 INR 0 0.0 0.0 2025-11-07 18:00:39
92 105 5 55 12533 38 Dish Wash 500ml NULL 3924101 2 85.0 230.0 0.0 0.0 184.0 155.93 28.07 460.0 170.0 368.0 9.0 28.07 9.0 28.07 0.0 0.0 155.93 56.14 368.0 INR 0 0.0 0.0 2025-11-07 18:00:39
93 106 6 55 12533 39 Fabric Wash 1000ml NULL 3924101 6 150.0 401.0 0.0 0.0 320.8 271.86 48.94 2406.0 900.0 1924.8 9.0 146.81 9.0 146.81 0.0 0.0 271.86 293.61 1924.8 INR 0 0.0 0.0 2025-11-07 18:00:39
94 107 7 55 12533 37 Floor Cleaner 500ml NULL 3924101 5 80.0 199.0 0.0 0.0 159.2 134.92 24.28 995.0 400.0 796.0 9.0 60.71 9.0 60.71 0.0 0.0 134.92 121.42 796.0 INR 0 0.0 0.0 2025-11-07 18:00:39
95 108 8 55 12533 33 Herbal Soap 100gm NULL 30049011 14 28.0 100.0 0.0 0.0 80.0 76.19 3.81 1400.0 392.0 1120.0 2.5 26.66 2.5 26.66 0.0 0.0 76.19 53.33 1120.0 INR 0 0.0 0.0 2025-11-07 18:00:39
96 109 9 55 12533 16 Liver Care Juice NULL 2009899 5 120.0 349.0 0.0 0.0 279.2 265.9 13.3 1745.0 600.0 1396.0 2.5 33.24 2.5 33.24 0.0 0.0 265.9 66.48 1396.0 INR 0 0.0 0.0 2025-11-07 18:00:39
97 110 10 55 12533 12 Melatonin Drop NULL 2106909 3 190.0 749.0 0.0 0.0 599.2 570.67 28.53 2247.0 570.0 1797.6 2.5 42.8 2.5 42.8 0.0 0.0 570.67 85.6 1797.6 INR 0 0.0 0.0 2025-11-07 18:00:39
98 111 11 55 12533 7 Morning Fresh Churan NULL 30049011 22 40.0 199.0 0.0 0.0 159.2 151.62 7.58 4378.0 880.0 3502.4 2.5 83.39 2.5 83.39 0.0 0.0 151.62 166.78 3502.4 INR 0 0.0 0.0 2025-11-07 18:00:39
99 112 12 55 12533 32 Neem Soap 100gm NULL 34011110 27 10.0 60.0 0.0 0.0 48.0 45.71 2.29 1620.0 270.0 1296.0 2.5 30.86 2.5 30.86 0.0 0.0 45.71 61.71 1296.0 INR 0 0.0 0.0 2025-11-07 18:00:39
100 113 13 55 12533 9 Omega 369 NULL 2936900 3 260.0 999.0 0.0 0.0 799.2 761.14 38.06 2997.0 780.0 2397.6 2.5 57.09 2.5 57.09 0.0 0.0 761.14 114.17 2397.6 INR 0 0.0 0.0 2025-11-07 18:00:39