fx_franchise_order_product

4,933 rows · 33 columns · page 44 / 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
2151 2164 4 377 12555 2 Heart Care Capsules NULL 2936900 100 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 149900.0 0.0 120000.0 2.5 2857.14 2.5 2857.14 0.0 0.0 1142.86 5714.28 120000.0 INR 0 0.0 0.0 2025-12-17 21:53:22
2152 2165 5 377 12555 24 Immunomax 24/7 Caps NULL 2009899 100 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 149900.0 0.0 120000.0 2.5 2857.14 2.5 2857.14 0.0 0.0 1142.86 5714.28 120000.0 INR 0 0.0 0.0 2025-12-17 21:53:22
2153 2166 6 377 12555 8 Piles Care NULL 30049011 100 0.0 999.0 0.0 0.0 720.0 685.71 34.29 99900.0 0.0 72000.0 2.5 1714.29 2.5 1714.29 0.0 0.0 685.71 3428.58 72000.0 INR 0 0.0 0.0 2025-12-17 21:53:22
2154 2167 7 377 12555 5 Thyro Care NULL 2936900 100 0.0 999.0 0.0 0.0 720.0 685.71 34.29 99900.0 0.0 72000.0 2.5 1714.29 2.5 1714.29 0.0 0.0 685.71 3428.58 72000.0 INR 0 0.0 0.0 2025-12-17 21:53:22
2155 2168 1 378 12555 27 Multicharge Cap NULL 2009899 50 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 74950.0 0.0 60000.0 2.5 1428.57 2.5 1428.57 0.0 0.0 1142.86 2857.14 60000.0 INR 0 0.0 0.0 2025-12-18 08:12:33
2156 2169 2 378 12555 61 Radiation chip NULL 902221 100 0.0 999.0 0.0 0.0 500.0 423.73 76.27 99900.0 0.0 50000.0 9.0 3813.56 9.0 3813.56 0.0 0.0 423.73 7627.12 50000.0 INR 0 0.0 0.0 2025-12-18 08:12:33
2157 2170 3 378 12555 19 Fat loss Juice 500 ml NULL 30049011 50 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 74950.0 0.0 60000.0 2.5 1428.57 2.5 1428.57 0.0 0.0 1142.86 2857.14 60000.0 INR 0 0.0 0.0 2025-12-18 08:12:33
2158 2171 4 378 12555 2 Heart Care Capsules NULL 2936900 60 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 89940.0 0.0 72000.0 2.5 1714.29 2.5 1714.29 0.0 0.0 1142.86 3428.58 72000.0 INR 0 0.0 0.0 2025-12-18 08:12:33
2159 2172 5 378 12555 24 Immunomax 24/7 Caps NULL 2009899 50 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 74950.0 0.0 60000.0 2.5 1428.57 2.5 1428.57 0.0 0.0 1142.86 2857.14 60000.0 INR 0 0.0 0.0 2025-12-18 08:12:33
2160 2173 6 378 12555 8 Piles Care NULL 30049011 50 0.0 999.0 0.0 0.0 720.0 685.71 34.29 49950.0 0.0 36000.0 2.5 857.14 2.5 857.14 0.0 0.0 685.71 1714.28 36000.0 INR 0 0.0 0.0 2025-12-18 08:12:33
2161 2174 7 378 12555 5 Thyro Care NULL 2936900 50 0.0 999.0 0.0 0.0 720.0 685.71 34.29 49950.0 0.0 36000.0 2.5 857.14 2.5 857.14 0.0 0.0 685.71 1714.28 36000.0 INR 0 0.0 0.0 2025-12-18 08:12:33
2162 2175 1 379 12554 27 Multicharge Cap NULL 2009899 100 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 149900.0 0.0 120000.0 2.5 2857.14 2.5 2857.14 0.0 0.0 1142.86 5714.28 120000.0 INR 0 0.0 0.0 2025-12-18 08:16:30
2163 2176 2 379 12554 61 Radiation chip NULL 902221 100 0.0 999.0 0.0 0.0 500.0 423.73 76.27 99900.0 0.0 50000.0 9.0 3813.56 9.0 3813.56 0.0 0.0 423.73 7627.12 50000.0 INR 0 0.0 0.0 2025-12-18 08:16:30
2164 2177 3 379 12554 19 Fat loss Juice 500 ml NULL 30049011 100 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 149900.0 0.0 120000.0 2.5 2857.14 2.5 2857.14 0.0 0.0 1142.86 5714.28 120000.0 INR 0 0.0 0.0 2025-12-18 08:16:30
2165 2178 4 379 12554 2 Heart Care Capsules NULL 2936900 100 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 149900.0 0.0 120000.0 2.5 2857.14 2.5 2857.14 0.0 0.0 1142.86 5714.28 120000.0 INR 0 0.0 0.0 2025-12-18 08:16:30
2166 2179 5 379 12554 24 Immunomax 24/7 Caps NULL 2009899 100 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 149900.0 0.0 120000.0 2.5 2857.14 2.5 2857.14 0.0 0.0 1142.86 5714.28 120000.0 INR 0 0.0 0.0 2025-12-18 08:16:30
2167 2180 6 379 12554 8 Piles Care NULL 30049011 100 0.0 999.0 0.0 0.0 720.0 685.71 34.29 99900.0 0.0 72000.0 2.5 1714.29 2.5 1714.29 0.0 0.0 685.71 3428.58 72000.0 INR 0 0.0 0.0 2025-12-18 08:16:30
2168 2181 7 379 12554 5 Thyro Care NULL 2936900 100 0.0 999.0 0.0 0.0 720.0 685.71 34.29 99900.0 0.0 72000.0 2.5 1714.29 2.5 1714.29 0.0 0.0 685.71 3428.58 72000.0 INR 0 0.0 0.0 2025-12-18 08:16:30
2169 2182 1 380 12516 27 Multicharge Cap NULL 2009899 100 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 149900.0 0.0 120000.0 2.5 2857.14 2.5 2857.14 0.0 0.0 1142.86 5714.28 120000.0 INR 0 0.0 0.0 2025-12-18 08:18:58
2170 2183 2 380 12516 61 Radiation chip NULL 902221 100 0.0 999.0 0.0 0.0 500.0 423.73 76.27 99900.0 0.0 50000.0 9.0 3813.56 9.0 3813.56 0.0 0.0 423.73 7627.12 50000.0 INR 0 0.0 0.0 2025-12-18 08:18:58
2171 2184 3 380 12516 19 Fat loss Juice 500 ml NULL 30049011 100 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 149900.0 0.0 120000.0 2.5 2857.14 2.5 2857.14 0.0 0.0 1142.86 5714.28 120000.0 INR 0 0.0 0.0 2025-12-18 08:18:58
2172 2185 4 380 12516 2 Heart Care Capsules NULL 2936900 100 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 149900.0 0.0 120000.0 2.5 2857.14 2.5 2857.14 0.0 0.0 1142.86 5714.28 120000.0 INR 0 0.0 0.0 2025-12-18 08:18:58
2173 2186 5 380 12516 24 Immunomax 24/7 Caps NULL 2009899 100 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 149900.0 0.0 120000.0 2.5 2857.14 2.5 2857.14 0.0 0.0 1142.86 5714.28 120000.0 INR 0 0.0 0.0 2025-12-18 08:18:58
2174 2187 6 380 12516 8 Piles Care NULL 30049011 100 0.0 999.0 0.0 0.0 720.0 685.71 34.29 99900.0 0.0 72000.0 2.5 1714.29 2.5 1714.29 0.0 0.0 685.71 3428.58 72000.0 INR 0 0.0 0.0 2025-12-18 08:18:58
2175 2188 7 380 12516 5 Thyro Care NULL 2936900 100 0.0 999.0 0.0 0.0 720.0 685.71 34.29 99900.0 0.0 72000.0 2.5 1714.29 2.5 1714.29 0.0 0.0 685.71 3428.58 72000.0 INR 0 0.0 0.0 2025-12-18 08:18:58
2176 2189 1 381 12555 4 Diabetic Care Capsules NULL 2936900 40 0.0 999.0 0.0 0.0 720.0 685.71 34.29 39960.0 0.0 28800.0 2.5 685.71 2.5 685.71 0.0 0.0 685.71 1371.42 28800.0 INR 0 0.0 0.0 2025-12-18 11:38:57
2177 2190 1 382 12555 61 Radiation chip NULL 902221 50 0.0 999.0 0.0 0.0 500.0 423.73 76.27 49950.0 0.0 25000.0 9.0 1906.78 9.0 1906.78 0.0 0.0 423.73 3813.56 25000.0 INR 0 0.0 0.0 2025-12-18 15:30:09
2178 2191 1 383 12554 61 Radiation chip NULL 902221 100 0.0 999.0 0.0 0.0 500.0 423.73 76.27 99900.0 0.0 50000.0 9.0 3813.56 9.0 3813.56 0.0 0.0 423.73 7627.12 50000.0 INR 0 0.0 0.0 2025-12-18 17:03:38
2179 2192 1 384 12555 61 Radiation chip NULL 902221 100 0.0 999.0 0.0 0.0 500.0 423.73 76.27 99900.0 0.0 50000.0 9.0 3813.56 9.0 3813.56 0.0 0.0 423.73 7627.12 50000.0 INR 0 0.0 0.0 2025-12-18 17:04:29
2180 2193 1 385 12516 61 Radiation chip NULL 902221 200 0.0 999.0 0.0 0.0 500.0 423.73 76.27 199800.0 0.0 100000.0 9.0 7627.12 9.0 7627.12 0.0 0.0 423.73 15254.24 100000.0 INR 0 0.0 0.0 2025-12-18 18:35:31
2181 2194 1 386 12554 61 Radiation chip NULL 902221 200 0.0 999.0 0.0 0.0 500.0 423.73 76.27 199800.0 0.0 100000.0 9.0 7627.12 9.0 7627.12 0.0 0.0 423.73 15254.24 100000.0 INR 0 0.0 0.0 2025-12-18 18:37:45
2182 2195 1 387 12555 61 Radiation chip NULL 902221 200 0.0 999.0 0.0 0.0 500.0 423.73 76.27 199800.0 0.0 100000.0 9.0 7627.12 9.0 7627.12 0.0 0.0 423.73 15254.24 100000.0 INR 0 0.0 0.0 2025-12-18 18:38:26
2183 2196 1 388 12516 4 Diabetic Care Capsules NULL 2936900 100 0.0 999.0 0.0 0.0 720.0 685.71 34.29 99900.0 0.0 72000.0 2.5 1714.29 2.5 1714.29 0.0 0.0 685.71 3428.58 72000.0 INR 0 0.0 0.0 2025-12-18 18:54:57
2184 2197 1 389 12554 4 Diabetic Care Capsules NULL 2936900 100 0.0 999.0 0.0 0.0 720.0 685.71 34.29 99900.0 0.0 72000.0 2.5 1714.29 2.5 1714.29 0.0 0.0 685.71 3428.58 72000.0 INR 0 0.0 0.0 2025-12-18 18:55:22
2185 2198 1 390 12555 4 Diabetic Care Capsules NULL 2936900 50 0.0 999.0 0.0 0.0 720.0 685.71 34.29 49950.0 0.0 36000.0 2.5 857.14 2.5 857.14 0.0 0.0 685.71 1714.28 36000.0 INR 0 0.0 0.0 2025-12-18 18:55:44
2186 2199 1 391 12555 61 Radiation chip NULL 902221 50 0.0 999.0 0.0 0.0 500.0 423.73 76.27 49950.0 0.0 25000.0 9.0 1906.78 9.0 1906.78 0.0 0.0 423.73 3813.56 25000.0 INR 0 0.0 0.0 2025-12-19 08:19:38
2187 2200 1 392 12516 61 Radiation chip NULL 902221 500 0.0 999.0 0.0 0.0 500.0 423.73 76.27 499500.0 0.0 250000.0 9.0 19067.8 9.0 19067.8 0.0 0.0 423.73 38135.6 250000.0 INR 0 0.0 0.0 2025-12-19 08:20:54
2188 2201 2 392 12516 4 Diabetic Care Capsules NULL 2936900 100 0.0 999.0 0.0 0.0 720.0 685.71 34.29 99900.0 0.0 72000.0 2.5 1714.29 2.5 1714.29 0.0 0.0 685.71 3428.58 72000.0 INR 0 0.0 0.0 2025-12-19 08:20:54
2189 2202 1 393 12554 61 Radiation chip NULL 902221 400 0.0 999.0 0.0 0.0 500.0 423.73 76.27 399600.0 0.0 200000.0 9.0 15254.24 9.0 15254.24 0.0 0.0 423.73 30508.48 200000.0 INR 0 0.0 0.0 2025-12-19 08:23:11
2190 2203 2 393 12554 4 Diabetic Care Capsules NULL 2936900 100 0.0 999.0 0.0 0.0 720.0 685.71 34.29 99900.0 0.0 72000.0 2.5 1714.29 2.5 1714.29 0.0 0.0 685.71 3428.58 72000.0 INR 0 0.0 0.0 2025-12-19 08:23:11
2191 2204 1 394 12555 61 Radiation chip NULL 902221 350 0.0 999.0 0.0 0.0 500.0 423.73 76.27 349650.0 0.0 175000.0 9.0 13347.46 9.0 13347.46 0.0 0.0 423.73 26694.92 175000.0 INR 0 0.0 0.0 2025-12-19 08:25:03
2192 2205 2 394 12555 4 Diabetic Care Capsules NULL 2936900 100 0.0 999.0 0.0 0.0 720.0 685.71 34.29 99900.0 0.0 72000.0 2.5 1714.29 2.5 1714.29 0.0 0.0 685.71 3428.58 72000.0 INR 0 0.0 0.0 2025-12-19 08:25:03
2193 2206 1 395 12555 61 Radiation chip NULL 902221 350 0.0 999.0 0.0 0.0 500.0 423.73 76.27 349650.0 0.0 175000.0 9.0 13347.46 9.0 13347.46 0.0 0.0 423.73 26694.92 175000.0 INR 0 0.0 0.0 2025-12-19 08:25:38
2194 2207 2 395 12555 4 Diabetic Care Capsules NULL 2936900 100 0.0 999.0 0.0 0.0 720.0 685.71 34.29 99900.0 0.0 72000.0 2.5 1714.29 2.5 1714.29 0.0 0.0 685.71 3428.58 72000.0 INR 0 0.0 0.0 2025-12-19 08:25:38
2195 2208 1 396 12555 61 Radiation chip NULL 902221 500 0.0 999.0 0.0 0.0 500.0 423.73 76.27 499500.0 0.0 250000.0 9.0 19067.8 9.0 19067.8 0.0 0.0 423.73 38135.6 250000.0 INR 0 0.0 0.0 2025-12-19 13:12:41
2196 2209 2 396 12555 4 Diabetic Care Capsules NULL 2936900 50 0.0 999.0 0.0 0.0 720.0 685.71 34.29 49950.0 0.0 36000.0 2.5 857.14 2.5 857.14 0.0 0.0 685.71 1714.28 36000.0 INR 0 0.0 0.0 2025-12-19 13:12:41
2197 2210 3 396 12555 8 Piles Care NULL 30049011 50 0.0 999.0 0.0 0.0 720.0 685.71 34.29 49950.0 0.0 36000.0 2.5 857.14 2.5 857.14 0.0 0.0 685.71 1714.28 36000.0 INR 0 0.0 0.0 2025-12-19 13:12:41
2198 2211 1 397 12554 61 Radiation chip NULL 902221 500 0.0 999.0 0.0 0.0 500.0 423.73 76.27 499500.0 0.0 250000.0 9.0 19067.8 9.0 19067.8 0.0 0.0 423.73 38135.6 250000.0 INR 0 0.0 0.0 2025-12-19 13:21:26
2199 2212 1 398 12554 4 Diabetic Care Capsules NULL 2936900 50 0.0 999.0 0.0 0.0 720.0 685.71 34.29 49950.0 0.0 36000.0 2.5 857.14 2.5 857.14 0.0 0.0 685.71 1714.28 36000.0 INR 0 0.0 0.0 2025-12-19 13:21:57
2200 2213 2 398 12554 8 Piles Care NULL 30049011 50 0.0 999.0 0.0 0.0 720.0 685.71 34.29 49950.0 0.0 36000.0 2.5 857.14 2.5 857.14 0.0 0.0 685.71 1714.28 36000.0 INR 0 0.0 0.0 2025-12-19 13:21:57