fx_franchise_order_product

4,933 rows · 33 columns · page 3 / 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
101 114 14 55 12533 28 Ortho Joint Shield NULL 2009899 1 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 1499.0 450.0 1199.2 2.5 28.55 2.5 28.55 0.0 0.0 1142.1 57.1 1199.2 INR 0 0.0 0.0 2025-11-07 18:00:39
102 115 15 55 12533 13 Premium NONI VEG caps NULL 2936900 3 150.0 501.0 0.0 0.0 400.8 381.71 19.09 1503.0 450.0 1202.4 2.5 28.63 2.5 28.63 0.0 0.0 381.71 57.26 1202.4 INR 0 0.0 0.0 2025-11-07 18:00:39
103 116 16 55 12533 46 Root Vitality Hair Oil NULL 3305901 21 54.0 255.0 0.0 0.0 204.0 194.29 9.71 5355.0 1134.0 4284.0 2.5 102.0 2.5 102.0 0.0 0.0 194.29 204.0 4284.0 INR 0 0.0 0.0 2025-11-07 18:00:39
104 117 17 55 12533 35 Sanitary Pad (15 pcs) NULL 9619001 10 40.0 380.0 0.0 0.0 304.0 304.0 0.0 3800.0 400.0 3040.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 3040.0 INR 0 0.0 0.0 2025-11-07 18:00:39
105 118 18 55 12533 50 Sun Screen NULL 330499 3 250.0 699.0 0.0 0.0 559.2 473.9 85.3 2097.0 750.0 1677.6 9.0 127.95 9.0 127.95 0.0 0.0 473.9 255.91 1677.6 INR 0 0.0 0.0 2025-11-07 18:00:39
106 119 19 55 12533 36 Toilet Cleaner 500ml NULL 3924101 15 30.0 150.0 0.0 0.0 120.0 101.69 18.31 2250.0 450.0 1800.0 9.0 137.29 9.0 137.29 0.0 0.0 101.69 274.58 1800.0 INR 0 0.0 0.0 2025-11-07 18:00:39
107 120 20 55 12533 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 18:00:39
108 121 21 55 12533 10 Vitamin D3 Drop NULL 2106909 1 190.0 749.0 0.0 0.0 599.2 570.67 28.53 749.0 190.0 599.2 2.5 14.27 2.5 14.27 0.0 0.0 570.67 28.53 599.2 INR 0 0.0 0.0 2025-11-07 18:00:39
109 122 1 56 12532 48 glow face wash NULL 3304999 4 250.0 380.0 0.0 0.0 304.0 257.63 46.37 1520.0 1000.0 1216.0 9.0 92.75 9.0 92.75 0.0 0.0 257.63 185.49 1216.0 INR 0 0.0 0.0 2025-11-07 18:03:06
110 123 2 56 12532 27 Multicharge Cap NULL 2009899 1 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 1499.0 450.0 1199.2 2.5 28.55 2.5 28.55 0.0 0.0 1142.1 57.1 1199.2 INR 0 0.0 0.0 2025-11-07 18:03:06
111 124 3 56 12532 20 Premium Berry Juice 1000ml NULL 2936900 1 750.0 3499.0 0.0 0.0 3479.0 3313.33 165.67 3499.0 750.0 3479.0 2.5 82.83 2.5 82.83 0.0 0.0 3313.33 165.67 3479.0 INR 0 0.0 0.0 2025-11-07 18:03:06
112 125 4 56 12532 70 Premium Hand belt NULL 9404 2 600.0 9999.0 0.0 0.0 7999.2 7618.29 380.92 19998.0 1200.0 15998.4 2.5 380.92 2.5 380.92 0.0 0.0 7618.29 761.83 15998.4 INR 0 0.0 0.0 2025-11-07 18:03:06
113 126 5 56 12532 61 Radiation chip NULL 902221 5 325.0 999.0 0.0 0.0 799.2 677.29 121.91 4995.0 1625.0 3996.0 9.0 304.78 9.0 304.78 0.0 0.0 677.29 609.56 3996.0 INR 0 0.0 0.0 2025-11-07 18:03:06
114 127 6 56 12532 31 Vegan Plant Protein Powder NULL 21061000 1 1000.0 2999.0 0.0 0.0 2399.2 2284.95 114.25 2999.0 1000.0 2399.2 2.5 57.12 2.5 57.12 0.0 0.0 2284.95 114.25 2399.2 INR 0 0.0 0.0 2025-11-07 18:03:06
115 128 7 56 12532 49 Anti Dandruff Serum NULL 3304999 1 250.0 999.0 0.0 0.0 799.2 677.29 121.91 999.0 250.0 799.2 9.0 60.95 9.0 60.95 0.0 0.0 677.29 121.91 799.2 INR 0 0.0 0.0 2025-11-07 18:03:06
116 129 8 56 12532 6 Asthma Care NULL 30049011 7 250.0 899.0 0.0 0.0 719.2 684.95 34.25 6293.0 1750.0 5034.4 2.5 119.86 2.5 119.86 0.0 0.0 684.95 239.73 5034.4 INR 0 0.0 0.0 2025-11-07 18:03:06
117 130 9 56 12532 40 Bamboo Brush NULL 96032100 4 25.0 110.0 0.0 0.0 88.0 74.58 13.42 440.0 100.0 352.0 9.0 26.84 9.0 26.84 0.0 0.0 74.58 53.69 352.0 INR 0 0.0 0.0 2025-11-07 18:03:06
118 131 10 56 12532 3 BP Care Capsules NULL 2936900 2 160.0 599.0 0.0 0.0 479.2 456.38 22.82 1198.0 320.0 958.4 2.5 22.82 2.5 22.82 0.0 0.0 456.38 45.64 958.4 INR 0 0.0 0.0 2025-11-07 18:03:06
119 132 11 56 12532 4 Diabetic Care Capsules NULL 2936900 6 250.0 899.0 0.0 0.0 719.2 684.95 34.25 5394.0 1500.0 4315.2 2.5 102.75 2.5 102.75 0.0 0.0 684.95 205.49 4315.2 INR 0 0.0 0.0 2025-11-07 18:03:06
120 133 12 56 12532 38 Dish Wash 500ml NULL 3924101 10 85.0 230.0 0.0 0.0 184.0 155.93 28.07 2300.0 850.0 1840.0 9.0 140.34 9.0 140.34 0.0 0.0 155.93 280.68 1840.0 INR 0 0.0 0.0 2025-11-07 18:03:06
121 134 13 56 12532 39 Fabric Wash 1000ml NULL 3924101 11 150.0 401.0 0.0 0.0 320.8 271.86 48.94 4411.0 1650.0 3528.8 9.0 269.14 9.0 269.14 0.0 0.0 271.86 538.29 3528.8 INR 0 0.0 0.0 2025-11-07 18:03:06
122 135 14 56 12532 60 Foot patch NULL 30051090 4 500.0 1999.0 0.0 0.0 1599.2 1523.05 76.15 7996.0 2000.0 6396.8 2.5 152.31 2.5 152.31 0.0 0.0 1523.05 304.61 6396.8 INR 0 0.0 0.0 2025-11-07 18:03:06
123 136 15 56 12532 33 Herbal Soap 100gm NULL 30049011 153 28.0 100.0 0.0 0.0 80.0 76.19 3.81 15300.0 4284.0 12240.0 2.5 291.43 2.5 291.43 0.0 0.0 76.19 582.86 12240.0 INR 0 0.0 0.0 2025-11-07 18:03:06
124 137 16 56 12532 34 Herbo2o Toothpaste NULL 33061090 74 45.0 199.0 0.0 0.0 159.2 134.92 24.28 14726.0 3330.0 11780.8 9.0 898.53 9.0 898.53 0.0 0.0 134.92 1797.07 11780.8 INR 0 0.0 0.0 2025-11-07 18:03:06
125 138 17 56 12532 30 Iron Capsules NULL 30049011 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 18:03:06
126 139 18 56 12532 16 Liver Care 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 18:03:06
127 140 19 56 12532 25 Manicalcium Tablets NULL 2009899 5 95.0 399.0 0.0 0.0 319.2 304.0 15.2 1995.0 475.0 1596.0 2.5 38.0 2.5 38.0 0.0 0.0 304.0 76.0 1596.0 INR 0 0.0 0.0 2025-11-07 18:03:06
128 141 20 56 12532 12 Melatonin Drop NULL 2106909 1 190.0 749.0 0.0 0.0 599.2 570.67 28.53 749.0 190.0 599.2 2.5 14.27 2.5 14.27 0.0 0.0 570.67 28.53 599.2 INR 0 0.0 0.0 2025-11-07 18:03:06
129 142 21 56 12532 7 Morning Fresh Churan NULL 30049011 9 40.0 199.0 0.0 0.0 159.2 151.62 7.58 1791.0 360.0 1432.8 2.5 34.12 2.5 34.12 0.0 0.0 151.62 68.23 1432.8 INR 0 0.0 0.0 2025-11-07 18:03:06
130 143 22 56 12532 32 Neem Soap 100gm NULL 34011110 353 10.0 60.0 0.0 0.0 48.0 45.71 2.29 21180.0 3530.0 16944.0 2.5 403.43 2.5 403.43 0.0 0.0 45.71 806.86 16944.0 INR 0 0.0 0.0 2025-11-07 18:03:06
131 144 23 56 12532 9 Omega 369 NULL 2936900 5 260.0 999.0 0.0 0.0 799.2 761.14 38.06 4995.0 1300.0 3996.0 2.5 95.14 2.5 95.14 0.0 0.0 761.14 190.29 3996.0 INR 0 0.0 0.0 2025-11-07 18:03:06
132 145 24 56 12532 28 Ortho Joint Shield NULL 2009899 3 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 4497.0 1350.0 3597.6 2.5 85.66 2.5 85.66 0.0 0.0 1142.1 171.31 3597.6 INR 0 0.0 0.0 2025-11-07 18:03:06
133 146 25 56 12532 72 Pain Relief Patch NULL 30051090 1 200.0 800.0 0.0 0.0 640.0 609.52 30.48 800.0 200.0 640.0 2.5 15.24 2.5 15.24 0.0 0.0 609.52 30.48 640.0 INR 0 0.0 0.0 2025-11-07 18:03:06
134 147 26 56 12532 8 Piles Care NULL 30049011 4 250.0 899.0 0.0 0.0 719.2 684.95 34.25 3596.0 1000.0 2876.8 2.5 68.5 2.5 68.5 0.0 0.0 684.95 136.99 2876.8 INR 0 0.0 0.0 2025-11-07 18:03:06
135 148 27 56 12532 41 Premium Coco Body Lotion NULL 3304300 2 250.0 699.0 0.0 0.0 559.2 473.9 85.3 1398.0 500.0 1118.4 9.0 85.3 9.0 85.3 0.0 0.0 473.9 170.6 1118.4 INR 0 0.0 0.0 2025-11-07 18:03:06
136 149 28 56 12532 47 Premium Hair Care Shampoo NULL 3305109 1 150.0 699.0 0.0 0.0 559.2 532.57 26.63 699.0 150.0 559.2 2.5 13.31 2.5 13.31 0.0 0.0 532.57 26.63 559.2 INR 0 0.0 0.0 2025-11-07 18:03:06
137 150 29 56 12532 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 18:03:06
138 151 30 56 12532 35 Sanitary Pad (15 pcs) NULL 9619001 10 40.0 380.0 0.0 0.0 304.0 304.0 0.0 3800.0 400.0 3040.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 3040.0 INR 0 0.0 0.0 2025-11-07 18:03:06
139 152 31 56 12532 29 Shilajith NULL 30049011 1 250.0 1800.0 0.0 0.0 1440.0 1371.43 68.57 1800.0 250.0 1440.0 2.5 34.28 2.5 34.28 0.0 0.0 1371.43 68.57 1440.0 INR 0 0.0 0.0 2025-11-07 18:03:06
140 153 32 56 12532 26 Spirulina Cap NULL 2009899 4 190.0 899.0 0.0 0.0 719.2 684.95 34.25 3596.0 760.0 2876.8 2.5 68.5 2.5 68.5 0.0 0.0 684.95 136.99 2876.8 INR 0 0.0 0.0 2025-11-07 18:03:06
141 154 33 56 12532 1 Stem Cell Powder NULL 2936900 3 749.0 2499.0 0.0 0.0 1999.2 1904.0 95.2 7497.0 2247.0 5997.6 2.5 142.8 2.5 142.8 0.0 0.0 1904.0 285.6 5997.6 INR 0 0.0 0.0 2025-11-07 18:03:06
142 155 34 56 12532 50 Sun Screen NULL 330499 3 250.0 699.0 0.0 0.0 559.2 473.9 85.3 2097.0 750.0 1677.6 9.0 127.95 9.0 127.95 0.0 0.0 473.9 255.91 1677.6 INR 0 0.0 0.0 2025-11-07 18:03:06
143 156 1 57 12557 48 glow face wash NULL 3304999 2 250.0 380.0 0.0 0.0 304.0 257.63 46.38 760.0 500.0 608.0 9.0 46.38 9.0 46.38 0.0 0.0 257.63 92.75 608.0 INR 0 0.0 0.0 2025-11-07 18:20:42
144 157 2 57 12557 27 Multicharge Cap NULL 2009899 1 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 1499.0 450.0 1199.2 2.5 28.55 2.5 28.55 0.0 0.0 1142.1 57.1 1199.2 INR 0 0.0 0.0 2025-11-07 18:20:42
145 158 3 57 12557 4 Diabetic Care Capsules NULL 2936900 6 250.0 899.0 0.0 0.0 719.2 684.95 34.25 5394.0 1500.0 4315.2 2.5 102.75 2.5 102.75 0.0 0.0 684.95 205.49 4315.2 INR 0 0.0 0.0 2025-11-07 18:20:42
146 159 4 57 12557 33 Herbal Soap 100gm NULL 30049011 30 28.0 100.0 0.0 0.0 80.0 76.19 3.81 3000.0 840.0 2400.0 2.5 57.15 2.5 57.15 0.0 0.0 76.19 114.29 2400.0 INR 0 0.0 0.0 2025-11-07 18:20:42
147 160 5 57 12557 34 Herbo2o Toothpaste NULL 33061090 1 45.0 199.0 0.0 0.0 159.2 134.92 24.28 199.0 45.0 159.2 9.0 12.14 9.0 12.14 0.0 0.0 134.92 24.28 159.2 INR 0 0.0 0.0 2025-11-07 18:20:42
148 161 6 57 12557 17 Memory Booster Juice NULL 2009899 1 120.0 349.0 0.0 0.0 279.2 265.9 13.3 349.0 120.0 279.2 2.5 6.65 2.5 6.65 0.0 0.0 265.9 13.3 279.2 INR 0 0.0 0.0 2025-11-07 18:20:42
149 162 7 57 12557 7 Morning Fresh Churan NULL 30049011 5 40.0 199.0 0.0 0.0 159.2 151.62 7.58 995.0 200.0 796.0 2.5 18.95 2.5 18.95 0.0 0.0 151.62 37.9 796.0 INR 0 0.0 0.0 2025-11-07 18:20:42
150 163 8 57 12557 32 Neem Soap 100gm NULL 34011110 92 10.0 60.0 0.0 0.0 48.0 45.71 2.29 5520.0 920.0 4416.0 2.5 105.14 2.5 105.14 0.0 0.0 45.71 210.29 4416.0 INR 0 0.0 0.0 2025-11-07 18:20:42