fx_franchise_order_product

4,933 rows · 33 columns · page 1 / 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
1 28 1 25 12555 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-06 20:00:24
2 27 1 24 12516 27 Multicharge Cap NULL 2009899 1 450.0 1499.0 0.0 0.0 1499.0 1270.34 228.66 1499.0 450.0 1499.0 9.0 114.33 9.0 114.33 0.0 0.0 1270.34 228.66 1499.0 INR 0 0.0 0.0 2025-11-06 19:31:57
3 26 1 23 12516 27 Multicharge Cap NULL 2009899 1 0.0 1499.0 0.0 0.0 1499.0 1270.34 228.66 1499.0 0.0 1499.0 9.0 114.33 9.0 114.33 0.0 0.0 1270.34 228.66 1499.0 INR 0 0.0 0.0 2025-11-06 19:26:47
4 25 1 22 12517 73 ENTRY BOX NULL NULL 1 1000.0 3998.4 0.0 0.0 3998.4 3808.0 190.4 3998.4 1000.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-06 16:29:11
5 24 1 21 12516 73 ENTRY BOX NULL NULL 1 1000.0 3998.4 0.0 0.0 3998.4 3808.0 190.4 3998.4 1000.0 3998.4 2.5 95.2 2.5 95.2 0.0 0.0 3808.0 190.4 3998.4 INR 0 0.0 0.0 2025-11-06 16:26:30
6 23 1 20 12518 73 ENTRY BOX NULL NULL 1 1000.0 3998.4 0.0 0.0 3998.4 3808.0 190.4 3998.4 1000.0 3998.4 2.5 95.2 2.5 95.2 0.0 0.0 3808.0 190.4 3998.4 INR 0 0.0 0.0 2025-11-06 13:49:11
7 22 1 19 12517 73 ENTRY BOX NULL NULL 1 1000.0 3998.4 0.0 0.0 3998.4 3808.0 190.4 3998.4 1000.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-06 13:48:47
8 21 1 18 12516 73 ENTRY BOX NULL NULL 1 1000.0 3998.4 0.0 0.0 3998.4 3808.0 190.4 3998.4 1000.0 3998.4 2.5 95.2 2.5 95.2 0.0 0.0 3808.0 190.4 3998.4 INR 0 0.0 0.0 2025-11-06 13:47:40
9 20 1 17 12518 73 ENTRY BOX NULL NULL 1 1000.0 3998.4 0.0 0.0 3998.4 3808.0 190.4 3998.4 1000.0 3998.4 2.5 95.2 2.5 95.2 0.0 0.0 3808.0 190.4 3998.4 INR 0 0.0 0.0 2025-11-06 13:39:17
10 19 1 16 12517 73 ENTRY BOX NULL NULL 1 1000.0 3998.4 0.0 0.0 3998.4 3808.0 190.4 3998.4 1000.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-06 13:38:39
11 18 1 15 12516 73 ENTRY BOX NULL NULL 1 1000.0 3998.4 0.0 0.0 3998.4 3808.0 190.4 3998.4 1000.0 3998.4 2.5 95.2 2.5 95.2 0.0 0.0 3808.0 190.4 3998.4 INR 0 0.0 0.0 2025-11-06 13:33:53
12 14 1 11 12555 27 Multicharge Cap NULL 2009899 10 0.0 1499.0 0.0 0.0 1499.0 1270.34 228.66 14990.0 0.0 14990.0 9.0 1143.31 9.0 1143.31 0.0 0.0 1270.34 2286.61 14990.0 INR 0 0.0 0.0 2025-11-03 11:04:39
13 15 1 12 12555 27 Multicharge Cap NULL 2009899 5 0.0 1499.0 0.0 0.0 1499.0 1270.34 228.66 7495.0 0.0 7495.0 9.0 571.65 9.0 571.65 0.0 0.0 1270.34 1143.31 7495.0 INR 0 0.0 0.0 2025-11-03 11:43:40
14 16 1 13 12554 27 Multicharge Cap NULL 2009899 5 0.0 1499.0 0.0 0.0 1499.0 1270.34 228.66 7495.0 0.0 7495.0 9.0 571.65 9.0 571.65 0.0 0.0 1270.34 1143.31 7495.0 INR 0 0.0 0.0 2025-11-03 11:46:18
15 17 1 14 12516 27 Multicharge Cap NULL 2009899 10 0.0 1499.0 0.0 0.0 1499.0 1270.34 228.66 14990.0 0.0 14990.0 9.0 1143.31 9.0 1143.31 0.0 0.0 1270.34 2286.61 14990.0 INR 0 0.0 0.0 2025-11-03 11:48:13
16 29 1 26 12555 27 Multicharge Cap NULL 2009899 1 450.0 1499.0 0.0 0.0 1499.0 1270.34 228.66 1499.0 450.0 1499.0 9.0 114.33 9.0 114.33 0.0 0.0 1270.34 228.66 1499.0 INR 0 0.0 0.0 2025-11-06 20:02:54
17 30 1 27 12555 27 Multicharge Cap NULL 2009899 1 450.0 1499.0 0.0 0.0 1124.25 952.75 171.5 1499.0 450.0 1124.25 9.0 85.75 9.0 85.75 0.0 0.0 952.75 171.5 1124.25 INR 0 0.0 0.0 2025-11-06 20:21:47
18 31 1 28 12555 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-06 20:46:06
19 32 1 29 12554 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-06 20:48:40
20 33 1 30 12516 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-06 20:49:16
21 34 1 31 12526 74 EXPLORER BOX NULL NULL 1 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 26997.0 0.0 10499.0 2.5 249.97 2.5 249.97 0.0 0.0 9999.05 499.95 10499.0 INR 0 0.0 0.0 2025-11-06 21:38:46
22 35 1 32 12526 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 2.5 95.2 2.5 95.2 0.0 0.0 3808.0 190.4 3998.4 INR 0 0.0 0.0 2025-11-06 21:39:40
23 36 1 33 12517 74 EXPLORER BOX NULL NULL 2 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 53994.0 0.0 20998.0 0.0 0.0 0.0 0.0 5.0 999.9 9999.05 999.9 20998.0 INR 0 0.0 0.0 2025-11-06 21:41:46
24 37 1 34 12516 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-06 21:42:26
25 38 1 35 12516 80 BOOSTER KIT NULL NULL 99 0.0 21998.2 0.0 0.0 13699.0 11609.32 2089.68 2177821.8 0.0 1356201.0 9.0 103439.06 9.0 103439.06 0.0 0.0 11609.32 206878.12 1356201.0 INR 0 0.0 0.0 2025-11-06 22:17:20
26 39 2 35 12516 77 ELITE COMFORT NULL NULL 99 0.0 53994.0 0.0 0.0 18500.0 17619.05 880.95 5345406.0 0.0 1831500.0 2.5 43607.14 2.5 43607.14 0.0 0.0 17619.05 87214.29 1831500.0 INR 0 0.0 0.0 2025-11-06 22:17:20
27 40 3 35 12516 73 ENTRY BOX NULL NULL 99 0.0 3998.4 0.0 0.0 3998.4 3808.0 190.4 395841.6 0.0 395841.6 2.5 9424.8 2.5 9424.8 0.0 0.0 3808.0 18849.6 395841.6 INR 0 0.0 0.0 2025-11-06 22:17:20
28 41 4 35 12516 74 EXPLORER BOX NULL NULL 99 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 2672703.0 0.0 1039401.0 2.5 24747.65 2.5 24747.65 0.0 0.0 9999.05 49495.29 1039401.0 INR 0 0.0 0.0 2025-11-06 22:17:20
29 42 5 35 12516 75 WELLNESS EXPLORER NULL NULL 99 0.0 22294.6 0.0 0.0 10600.0 10095.24 504.76 2207165.4 0.0 1049400.0 2.5 24985.72 2.5 24985.72 0.0 0.0 10095.24 49971.43 1049400.0 INR 0 0.0 0.0 2025-11-06 22:17:20
30 43 1 36 12557 74 EXPLORER BOX NULL NULL 1 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 26997.0 0.0 10499.0 2.5 249.97 2.5 249.97 0.0 0.0 9999.05 499.95 10499.0 INR 0 0.0 0.0 2025-11-06 22:18:36
31 44 1 37 12557 74 EXPLORER BOX NULL NULL 1 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 26997.0 0.0 10499.0 2.5 249.97 2.5 249.97 0.0 0.0 9999.05 499.95 10499.0 INR 0 0.0 0.0 2025-11-06 22:24:05
32 45 1 38 12516 80 BOOSTER KIT NULL NULL 5 0.0 21998.2 0.0 0.0 13699.0 11609.32 2089.68 109991.0 0.0 68495.0 9.0 5224.19 9.0 5224.19 0.0 0.0 11609.32 10448.39 68495.0 INR 0 0.0 0.0 2025-11-06 22:30:58
33 46 2 38 12516 77 ELITE COMFORT NULL NULL 5 0.0 53994.0 0.0 0.0 18500.0 17619.05 880.95 269970.0 0.0 92500.0 2.5 2202.38 2.5 2202.38 0.0 0.0 17619.05 4404.76 92500.0 INR 0 0.0 0.0 2025-11-06 22:30:58
34 47 3 38 12516 73 ENTRY BOX NULL NULL 15 0.0 3998.4 0.0 0.0 3998.4 3808.0 190.4 59976.0 0.0 59976.0 2.5 1428.0 2.5 1428.0 0.0 0.0 3808.0 2856.0 59976.0 INR 0 0.0 0.0 2025-11-06 22:30:58
35 48 4 38 12516 74 EXPLORER BOX NULL NULL 20 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 539940.0 0.0 209980.0 2.5 4999.52 2.5 4999.52 0.0 0.0 9999.05 9999.05 209980.0 INR 0 0.0 0.0 2025-11-06 22:30:58
36 49 5 38 12516 75 WELLNESS EXPLORER NULL NULL 5 0.0 22294.6 0.0 0.0 10600.0 10095.24 504.76 111473.0 0.0 53000.0 2.5 1261.9 2.5 1261.9 0.0 0.0 10095.24 2523.81 53000.0 INR 0 0.0 0.0 2025-11-06 22:30:58
37 50 1 39 12516 73 ENTRY BOX NULL NULL 25 0.0 3998.4 0.0 0.0 3998.4 3808.0 190.4 99960.0 0.0 99960.0 2.5 2380.0 2.5 2380.0 0.0 0.0 3808.0 4760.0 99960.0 INR 0 0.0 0.0 2025-11-06 22:32:03
38 51 1 40 12542 74 EXPLORER BOX NULL NULL 1 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 26997.0 0.0 10499.0 2.5 249.97 2.5 249.97 0.0 0.0 9999.05 499.95 10499.0 INR 0 0.0 0.0 2025-11-06 22:32:50
39 52 1 41 12517 73 ENTRY BOX NULL NULL 25 0.0 3998.4 0.0 0.0 3998.4 3808.0 190.4 99960.0 0.0 99960.0 0.0 0.0 0.0 0.0 5.0 4760.0 3808.0 4760.0 99960.0 INR 0 0.0 0.0 2025-11-06 22:33:12
40 53 1 42 12517 77 ELITE COMFORT NULL NULL 5 0.0 53994.0 0.0 0.0 18500.0 17619.05 880.95 269970.0 0.0 92500.0 0.0 0.0 0.0 0.0 5.0 4404.76 17619.05 4404.76 92500.0 INR 0 0.0 0.0 2025-11-06 22:37:20
41 54 1 43 12517 74 EXPLORER BOX NULL NULL 25 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 674925.0 0.0 262475.0 0.0 0.0 0.0 0.0 5.0 12498.81 9999.05 12498.81 262475.0 INR 0 0.0 0.0 2025-11-06 22:37:36
42 55 1 44 12517 80 BOOSTER KIT NULL NULL 3 0.0 21998.2 0.0 0.0 13699.0 11609.32 2089.68 65994.6 0.0 41097.0 0.0 0.0 0.0 0.0 18.0 6269.03 11609.32 6269.03 41097.0 INR 0 0.0 0.0 2025-11-06 22:38:08
43 56 1 45 12544 74 EXPLORER BOX NULL NULL 1 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 26997.0 0.0 10499.0 2.5 249.97 2.5 249.97 0.0 0.0 9999.05 499.95 10499.0 INR 0 0.0 0.0 2025-11-06 23:02:00
44 57 1 46 12546 74 EXPLORER BOX NULL NULL 1 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 26997.0 0.0 10499.0 2.5 249.97 2.5 249.97 0.0 0.0 9999.05 499.95 10499.0 INR 0 0.0 0.0 2025-11-07 09:30:36
45 58 1 47 12552 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 2.5 95.2 2.5 95.2 0.0 0.0 3808.0 190.4 3998.4 INR 0 0.0 0.0 2025-11-07 11:03:22
46 59 1 48 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-07 11:19:52
47 60 1 49 12532 74 EXPLORER BOX NULL NULL 1 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 26997.0 0.0 10499.0 2.5 249.97 2.5 249.97 0.0 0.0 9999.05 499.95 10499.0 INR 0 0.0 0.0 2025-11-07 11:23:10
48 61 1 50 12557 32 Neem Soap 100gm NULL 34011110 1 10.0 60.0 0.0 0.0 48.0 45.71 2.29 60.0 10.0 48.0 2.5 1.15 2.5 1.15 0.0 0.0 45.71 2.29 48.0 INR 0 0.0 0.0 2025-11-07 11:38:24
49 62 1 51 12534 74 EXPLORER BOX NULL NULL 1 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 26997.0 0.0 10499.0 2.5 249.97 2.5 249.97 0.0 0.0 9999.05 499.95 10499.0 INR 0 0.0 0.0 2025-11-07 11:48:52
50 63 1 52 12529 74 EXPLORER BOX NULL NULL 2 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 53994.0 0.0 20998.0 2.5 499.95 2.5 499.95 0.0 0.0 9999.05 999.9 20998.0 INR 0 0.0 0.0 2025-11-07 11:56:23