fx_franchise_order_product

4,933 rows · 33 columns · page 23 / 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
1101 1114 11 139 12685 34 Herbo2o Toothpaste NULL 33061090 12 45.0 199.0 0.0 0.0 159.2 134.92 24.29 2388.0 540.0 1910.4 9.0 145.71 9.0 145.71 0.0 0.0 134.92 291.42 1910.4 INR 0 0.0 0.0 2025-11-10 18:55:28
1102 1115 12 139 12685 32 Neem Soap 100gm NULL 34011110 60 10.0 60.0 0.0 0.0 48.0 45.71 2.29 3600.0 600.0 2880.0 2.5 68.57 2.5 68.57 0.0 0.0 45.71 137.14 2880.0 INR 0 0.0 0.0 2025-11-10 18:55:28
1103 1116 13 139 12685 28 Ortho Joint Shield NULL 2009899 5 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 7495.0 2250.0 5996.0 2.5 142.76 2.5 142.76 0.0 0.0 1142.1 285.52 5996.0 INR 0 0.0 0.0 2025-11-10 18:55:28
1104 1117 14 139 12685 11 Vitamin B12 Drop NULL 2106909 6 190.0 749.0 0.0 0.0 599.2 570.67 28.53 4494.0 1140.0 3595.2 2.5 85.6 2.5 85.6 0.0 0.0 570.67 171.2 3595.2 INR 0 0.0 0.0 2025-11-10 18:55:28
1105 1118 15 139 12685 10 Vitamin D3 Drop NULL 2106909 6 190.0 749.0 0.0 0.0 599.2 570.67 28.53 4494.0 1140.0 3595.2 2.5 85.6 2.5 85.6 0.0 0.0 570.67 171.2 3595.2 INR 0 0.0 0.0 2025-11-10 18:55:28
1106 1119 16 139 12685 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 2.5 80.0 2.5 80.0 0.0 0.0 1066.67 160.0 3360.0 INR 0 0.0 0.0 2025-11-10 18:55:28
1107 1120 1 140 12517 74 EXPLORER BOX NULL NULL 5 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 134985.0 0.0 52495.0 0.0 0.0 0.0 0.0 5.0 2499.76 9999.05 2499.76 52495.0 INR 0 0.0 0.0 2025-11-10 19:06:03
1108 1121 1 141 12536 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-10 19:27:00
1109 1122 1 142 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-10 19:45:02
1110 1123 1 143 12529 77 ELITE COMFORT NULL NULL 2 0.0 53994.0 0.0 0.0 18500.0 17619.05 880.95 107988.0 0.0 37000.0 2.5 880.95 2.5 880.95 0.0 0.0 17619.05 1761.9 37000.0 INR 0 0.0 0.0 2025-11-10 19:46:03
1111 1124 1 144 12533 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-10 20:08:36
1112 1125 1 145 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-10 22:10:59
1113 1126 1 146 12517 77 ELITE COMFORT NULL NULL 2 0.0 53994.0 0.0 0.0 18500.0 17619.05 880.95 107988.0 0.0 37000.0 0.0 0.0 0.0 0.0 5.0 1761.9 17619.05 1761.9 37000.0 INR 0 0.0 0.0 2025-11-10 22:25:50
1114 1127 1 147 12544 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-11 08:05:05
1115 1128 1 148 12557 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-11 11:23:26
1116 1129 1 149 12523 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-11 13:11:59
1117 1130 2 149 12523 38 Dish Wash 500ml NULL 3924101 20 85.0 230.0 0.0 0.0 184.0 155.93 28.07 4600.0 1700.0 3680.0 9.0 280.68 9.0 280.68 0.0 0.0 155.93 561.36 3680.0 INR 0 0.0 0.0 2025-11-11 13:11:59
1118 1131 3 149 12523 37 Floor Cleaner 500ml NULL 3924101 40 80.0 199.0 0.0 0.0 159.2 134.92 24.28 7960.0 3200.0 6368.0 9.0 485.69 9.0 485.69 0.0 0.0 134.92 971.39 6368.0 INR 0 0.0 0.0 2025-11-11 13:11:59
1119 1132 4 149 12523 2 Heart Care Capsules NULL 2936900 1 425.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 1499.0 425.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-11 13:11:59
1120 1133 5 149 12523 34 Herbo2o Toothpaste NULL 33061090 3 45.0 199.0 0.0 0.0 159.2 134.92 24.28 597.0 135.0 477.6 9.0 36.42 9.0 36.42 0.0 0.0 134.92 72.85 477.6 INR 0 0.0 0.0 2025-11-11 13:11:59
1121 1134 6 149 12523 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-11 13:11:59
1122 1135 7 149 12523 18 Lady Care Juice 500ml NULL 2009899 1 250.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 1499.0 250.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-11 13:11:59
1123 1136 8 149 12523 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-11 13:11:59
1124 1137 9 149 12523 42 Premium Glow Charm Fairness Cream NULL 33049990 6 80.0 399.0 0.0 0.0 319.2 270.51 48.69 2394.0 480.0 1915.2 9.0 146.07 9.0 146.07 0.0 0.0 270.51 292.15 1915.2 INR 0 0.0 0.0 2025-11-11 13:11:59
1125 1138 10 149 12523 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-11 13:11:59
1126 1139 11 149 12523 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-11 13:11:59
1127 1140 12 149 12523 46 Root Vitality Hair Oil NULL 3305901 10 54.0 255.0 0.0 0.0 204.0 194.29 9.71 2550.0 540.0 2040.0 2.5 48.57 2.5 48.57 0.0 0.0 194.29 97.14 2040.0 INR 0 0.0 0.0 2025-11-11 13:11:59
1128 1141 13 149 12523 36 Toilet Cleaner 500ml NULL 3924101 20 30.0 150.0 0.0 0.0 120.0 101.69 18.3 3000.0 600.0 2400.0 9.0 183.05 9.0 183.05 0.0 0.0 101.69 366.1 2400.0 INR 0 0.0 0.0 2025-11-11 13:11:59
1129 1142 1 150 12534 4 Diabetic Care Capsules NULL 2936900 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-11 13:16:22
1130 1143 2 150 12534 37 Floor Cleaner 500ml NULL 3924101 8 80.0 199.0 0.0 0.0 159.2 134.92 24.29 1592.0 640.0 1273.6 9.0 97.14 9.0 97.14 0.0 0.0 134.92 194.28 1273.6 INR 0 0.0 0.0 2025-11-11 13:16:22
1131 1144 3 150 12534 34 Herbo2o Toothpaste NULL 33061090 7 45.0 199.0 0.0 0.0 159.2 134.92 24.28 1393.0 315.0 1114.4 9.0 85.0 9.0 85.0 0.0 0.0 134.92 169.99 1114.4 INR 0 0.0 0.0 2025-11-11 13:16:22
1132 1145 4 150 12534 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-11 13:16:22
1133 1146 5 150 12534 7 Morning Fresh Churan NULL 30049011 8 40.0 199.0 0.0 0.0 159.2 151.62 7.58 1592.0 320.0 1273.6 2.5 30.32 2.5 30.32 0.0 0.0 151.62 60.65 1273.6 INR 0 0.0 0.0 2025-11-11 13:16:22
1134 1147 6 150 12534 32 Neem Soap 100gm NULL 34011110 50 10.0 60.0 0.0 0.0 48.0 45.71 2.29 3000.0 500.0 2400.0 2.5 57.15 2.5 57.15 0.0 0.0 45.71 114.29 2400.0 INR 0 0.0 0.0 2025-11-11 13:16:22
1135 1148 7 150 12534 8 Piles Care 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-11 13:16:22
1136 1149 8 150 12534 43 Quench Kiss Lip Balm NULL 3304300 8 35.0 199.0 0.0 0.0 159.2 134.92 24.29 1592.0 280.0 1273.6 9.0 97.14 9.0 97.14 0.0 0.0 134.92 194.28 1273.6 INR 0 0.0 0.0 2025-11-11 13:16:22
1137 1150 9 150 12534 46 Root Vitality Hair Oil NULL 3305901 6 54.0 255.0 0.0 0.0 204.0 194.29 9.71 1530.0 324.0 1224.0 2.5 29.14 2.5 29.14 0.0 0.0 194.29 58.29 1224.0 INR 0 0.0 0.0 2025-11-11 13:16:22
1138 1151 10 150 12534 36 Toilet Cleaner 500ml NULL 3924101 10 30.0 150.0 0.0 0.0 120.0 101.69 18.3 1500.0 300.0 1200.0 9.0 91.53 9.0 91.53 0.0 0.0 101.69 183.05 1200.0 INR 0 0.0 0.0 2025-11-11 13:16:22
1139 1152 1 151 12518 77 ELITE COMFORT NULL NULL 1 0.0 53994.0 0.0 0.0 18500.0 17619.05 880.95 53994.0 0.0 18500.0 2.5 440.48 2.5 440.48 0.0 0.0 17619.05 880.95 18500.0 INR 0 0.0 0.0 2025-11-11 13:21:49
1140 1153 1 152 12532 38 Dish Wash 500ml NULL 3924101 5 85.0 230.0 0.0 0.0 184.0 155.93 28.07 1150.0 425.0 920.0 9.0 70.17 9.0 70.17 0.0 0.0 155.93 140.34 920.0 INR 0 0.0 0.0 2025-11-11 13:39:46
1141 1154 2 152 12532 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-11 13:39:46
1142 1155 3 152 12532 60 Foot patch NULL 30051090 5 500.0 1999.0 0.0 0.0 1599.2 1523.05 76.15 9995.0 2500.0 7996.0 2.5 190.38 2.5 190.38 0.0 0.0 1523.05 380.76 7996.0 INR 0 0.0 0.0 2025-11-11 13:39:46
1143 1156 4 152 12532 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-11 13:39:46
1144 1157 5 152 12532 72 Pain Relief Patch NULL 30051090 5 200.0 800.0 0.0 0.0 640.0 609.52 30.48 4000.0 1000.0 3200.0 2.5 76.19 2.5 76.19 0.0 0.0 609.52 152.38 3200.0 INR 0 0.0 0.0 2025-11-11 13:39:46
1145 1158 6 152 12532 36 Toilet Cleaner 500ml NULL 3924101 5 30.0 150.0 0.0 0.0 120.0 101.69 18.31 750.0 150.0 600.0 9.0 45.77 9.0 45.77 0.0 0.0 101.69 91.53 600.0 INR 0 0.0 0.0 2025-11-11 13:39:46
1146 1159 1 153 12542 70 Premium Hand belt NULL 9404 3 600.0 9999.0 0.0 0.0 1440.0 1371.43 68.57 29997.0 1800.0 4320.0 2.5 102.86 2.5 102.86 0.0 0.0 1371.43 205.71 4320.0 INR 0 0.0 0.0 2025-11-11 13:44:53
1147 1160 2 153 12542 6 Asthma Care 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-11 13:44:53
1148 1161 3 153 12542 40 Bamboo Brush NULL 96032100 1 25.0 110.0 0.0 0.0 88.0 74.58 13.42 110.0 25.0 88.0 9.0 6.71 9.0 6.71 0.0 0.0 74.58 13.42 88.0 INR 0 0.0 0.0 2025-11-11 13:44:53
1149 1162 4 153 12542 52 Bhoo sanjeevni 5 kg NULL 3103100 3 450.0 1600.0 0.0 0.0 1280.0 1219.05 60.95 4800.0 1350.0 3840.0 2.5 91.43 2.5 91.43 0.0 0.0 1219.05 182.86 3840.0 INR 0 0.0 0.0 2025-11-11 13:44:53
1150 1163 5 153 12542 38 Dish Wash 500ml NULL 3924101 21 85.0 230.0 0.0 0.0 184.0 155.93 28.07 4830.0 1785.0 3864.0 9.0 294.71 9.0 294.71 0.0 0.0 155.93 589.42 3864.0 INR 0 0.0 0.0 2025-11-11 13:44:53