fx_franchise_order

1,267 rows · 31 columns · page 4 / 26

Invoice view Excel export
# id orderid invoice_no userid shopee_id purchase_type product_type total_quantity total_amount comm_per dicount_comm total_cgst_amt total_sgst_amount total_igst_amount final_amount _currency total_bv total_pv total_sv payment_type order_by created_on delivery_status delivered_on admin_status admin_processed_on processed_by receipt_path payment_ref_no fran_comm_status fran_comm_credited_on
151 161 POF-1151 INVF-1151 12529 12517 2 2 2 20998.0 0.0 419.96 499.95 499.95 0.0 20578.04 INR 0.0 7000.0 0.0 4 12529 2025-11-11 15:12:47 0 NULL 1 2025-11-11 16:09:56 12517 0 NULL
152 162 POF-1152 INVF-1152 12521 12517 2 2 1 18000.0 0.0 360.0 428.57 428.57 0.0 17640.0 INR 0.0 7500.0 0.0 4 12521 2025-11-11 15:19:45 0 NULL 1 2025-11-11 19:50:46 12517 0 NULL
153 163 POF-1153 INVF-1153 12517 12516 2 2 5 45994.4 0.0 2299.72 0.0 0.0 2190.21 43694.68 INR 0.0 14000.0 0.0 4 12517 2025-11-11 15:51:34 0 NULL 1 2025-11-11 16:08:23 12516 0 NULL
154 164 POF-1154 INVF-1154 12532 12517 2 2 3 31497.0 0.0 629.94 749.93 749.93 0.0 30867.06 INR 0.0 10500.0 0.0 4 12532 2025-11-11 15:59:25 0 NULL 1 2025-11-11 16:09:56 12517 0 NULL
155 165 POF-1155 INVF-1155 12544 12517 2 2 1 10499.0 0.0 209.98 249.97 249.97 0.0 10289.02 INR 0.0 3500.0 0.0 4 12544 2025-11-11 16:17:48 0 NULL 1 2025-11-11 21:41:19 12517 0 NULL
156 166 POF-1156 INVF-1156 12517 12516 2 2 6 86497.0 0.0 4324.85 0.0 0.0 4118.9 82172.15 INR 0.0 10500.0 0.0 4 12517 2025-11-11 16:18:14 0 NULL 1 2025-11-11 19:47:04 12516 0 NULL
157 167 POF-1157 INVF-1157 12555 12554 2 1 102 69855.8 0.0 1397.12 2140.3 2140.3 0.0 68458.68 INR 22970.0 22970.0 23550.0 4 12555 2025-11-11 16:30:18 0 NULL 2 2025-11-12 08:23:36 12554 0 NULL
158 168 POF-1158 INVF-1158 12555 12554 2 1 54 21302.4 0.0 426.05 677.6 677.6 0.0 20876.35 INR 7755.0 7755.0 8155.0 4 12555 2025-11-11 16:34:35 0 NULL 2 2025-11-12 08:23:36 12554 0 NULL
159 169 POF-1159 INVF-1159 12516 1 2 2 5 90000.0 0.0 7200.0 2142.86 2142.86 0.0 82800.0 INR 0.0 37500.0 0.0 4 12516 2025-11-11 16:40:11 0 NULL 1 2025-11-11 19:46:45 1 0 NULL
160 170 POF-1160 INVF-1160 12555 12554 2 1 55 42272.8 0.0 845.46 1252.9 1252.9 0.0 41427.34 INR 14505.0 14505.0 14865.0 4 12555 2025-11-11 16:42:11 0 NULL 2 2025-11-12 08:23:36 12554 0 NULL
161 171 POF-1161 INVF-1161 12555 12554 2 1 100 4800.0 0.0 96.0 114.28 114.28 0.0 4704.0 INR 1000.0 1000.0 1300.0 4 12555 2025-11-11 16:48:11 0 NULL 2 2025-11-12 08:23:36 12554 0 NULL
162 172 POF-1162 INVF-1162 12555 12554 2 1 2 408.0 0.0 8.16 9.71 9.71 0.0 399.84 INR 108.0 108.0 206.0 4 12555 2025-11-11 16:49:07 0 NULL 2 2025-11-12 08:23:36 12554 0 NULL
163 173 POF-1163 INVF-1163 12546 12517 2 2 2 20998.0 0.0 419.96 499.95 499.95 0.0 20578.04 INR 0.0 7000.0 0.0 4 12546 2025-11-11 17:01:10 0 NULL 1 2025-11-11 19:09:41 12517 0 NULL
164 174 POF-1164 INVF-1164 12532 12517 2 1 39 10985.6 0.0 219.71 510.87 510.87 0.0 10765.89 INR 3820.0 3820.0 3940.0 4 12532 2025-11-11 17:02:00 0 NULL 1 2025-11-12 15:26:01 12517 0 NULL
165 175 POF-1165 INVF-1165 12555 12554 2 1 212 125779.2 0.0 2515.58 4139.13 4139.13 0.0 123263.62 INR 42966.0 42966.0 43356.0 4 12555 2025-11-11 17:13:54 0 NULL 2 2025-11-12 08:23:36 12554 0 NULL
166 176 POF-1166 INVF-1166 12533 12517 2 2 3 31497.0 0.0 629.94 749.93 749.93 0.0 30867.06 INR 0.0 10500.0 0.0 4 12533 2025-11-11 17:29:50 0 NULL 1 2025-11-11 19:50:46 12517 0 NULL
167 177 POF-1167 INVF-1167 12554 12516 2 1 8281 3475763.2 0.0 173788.16 115190.1 115190.1 0.0 3301975.04 INR 1252625.0 1252625.0 1258625.0 4 12554 2025-11-11 18:31:23 0 NULL 2 2025-11-11 23:06:07 12516 0 NULL
168 178 POF-1168 INVF-1168 12516 1 2 2 10 180000.0 0.0 14400.0 4285.72 4285.72 0.0 165600.0 INR 0.0 75000.0 0.0 4 12516 2025-11-11 19:45:48 0 NULL 1 2025-11-11 19:46:01 1 0 NULL
169 179 POF-1169 INVF-1169 12516 1 2 1 7192 2423674.4 0.0 193893.95 87779.21 87779.21 0.0 2229780.45 INR 835005.0 835005.0 841005.0 4 12516 2025-11-11 20:02:12 0 NULL 2 2025-11-11 21:20:01 1 0 NULL
170 180 POF-1170 INVF-1170 12516 1 2 1 7192 2423674.4 0.0 193893.95 87779.21 87779.21 0.0 2229780.45 INR 835005.0 835005.0 841005.0 4 12516 2025-11-11 20:02:13 0 NULL 2 2025-11-11 21:20:01 1 0 NULL
171 181 POF-1171 INVF-1171 12517 12516 2 2 5 71697.0 0.0 3584.85 0.0 0.0 4851.48 68112.15 INR 0.0 7000.0 0.0 4 12517 2025-11-11 20:02:56 0 NULL 1 2025-11-11 21:38:49 12516 0 NULL
172 182 POF-1172 INVF-1172 12516 1 2 1 160 222730.0 0.0 17818.4 6100.51 6100.51 0.0 204911.6 INR 75500.0 75500.0 78500.0 4 12516 2025-11-11 21:16:03 0 NULL 1 2025-11-11 21:17:45 1 0 NULL
173 183 POF-1173 INVF-1173 12516 1 2 1 2600 238240.0 0.0 19059.2 11455.75 11455.75 0.0 219180.8 INR 81500.0 81500.0 83000.0 4 12516 2025-11-11 21:22:38 0 NULL 1 2025-11-11 21:22:51 1 0 NULL
174 184 POF-1174 INVF-1174 12554 12516 2 1 2500 222320.0 0.0 11116.0 10241.51 10241.51 0.0 211204.0 INR 77000.0 77000.0 78500.0 4 12554 2025-11-11 21:26:19 0 NULL 1 2025-11-11 21:30:09 12516 0 NULL
175 185 POF-1175 INVF-1175 12555 12554 2 1 2500 222320.0 0.0 4446.4 10241.51 10241.51 0.0 217873.6 INR 77000.0 77000.0 78500.0 4 12555 2025-11-11 21:28:36 0 NULL 1 2025-11-11 21:31:05 12554 0 NULL
176 186 POF-1176 INVF-1176 12526 12517 2 2 5 45994.4 0.0 919.89 1095.11 1095.11 0.0 45074.51 INR 0.0 14000.0 0.0 4 12526 2025-11-11 21:28:53 0 NULL 1 2025-11-12 14:11:25 12517 0 NULL
177 187 POF-1177 INVF-1177 12555 12554 2 2 1 18500.0 0.0 370.0 440.48 440.48 0.0 18130.0 INR 0.0 7500.0 0.0 4 12555 2025-11-11 21:41:34 0 NULL 2 2025-11-12 08:23:36 12554 0 NULL
178 188 POF-1178 INVF-1178 12516 1 2 2 41 484964.0 0.0 38797.12 18733.48 18733.48 0.0 446166.88 INR 0.0 35000.0 0.0 4 12516 2025-11-11 21:43:20 0 NULL 1 2025-11-11 21:43:43 1 0 NULL
179 189 POF-1179 INVF-1179 12554 12516 2 2 1 18500.0 0.0 925.0 440.48 440.48 0.0 17575.0 INR 0.0 7500.0 0.0 4 12554 2025-11-11 21:47:33 0 NULL 1 2025-11-11 21:48:04 12516 0 NULL
180 190 POF-1180 INVF-1180 12516 1 2 1 6311 1416463.6 0.0 113317.09 51798.28 51798.28 0.0 1303146.51 INR 488970.0 488970.0 491370.0 4 12516 2025-11-11 22:11:56 0 NULL 1 2025-11-11 22:34:56 1 0 NULL
181 191 POF-1181 INVF-1181 12516 1 2 1 6311 1420929.2 0.0 113674.34 51611.24 51611.24 0.0 1307254.86 INR 489870.0 489870.0 492270.0 4 12516 2025-11-11 23:32:11 0 NULL 2 2025-11-12 17:47:21 1 0 NULL
182 192 POF-1182 INVF-1182 12554 12516 2 1 6302 1418888.8 0.0 70944.44 51856.01 51856.01 0.0 1347944.36 INR 493920.0 493920.0 496320.0 4 12554 2025-11-11 23:58:07 0 NULL 1 2025-11-12 08:49:54 12516 0 NULL
183 193 POF-1183 INVF-1183 12552 12517 2 2 3 42698.0 0.0 853.96 1735.29 1735.29 0.0 41844.04 INR 0.0 3500.0 0.0 4 12552 2025-11-12 00:14:12 0 NULL 1 2025-11-12 00:14:54 12517 0 NULL
184 194 POF-1184 INVF-1184 12554 12516 2 2 260 3044820.0 0.0 152241.0 108429.34 108429.34 0.0 2892579.0 INR 0.0 175000.0 0.0 4 12554 2025-11-12 06:38:52 0 NULL 1 2025-11-12 06:56:39 12516 0 NULL
185 195 POF-1185 INVF-1185 12555 12554 2 2 240 2832820.0 0.0 56656.4 103381.71 103381.71 0.0 2776163.6 INR 0.0 105000.0 0.0 4 12555 2025-11-12 06:59:00 0 NULL 1 2025-11-12 07:00:16 12554 0 NULL
186 196 POF-1186 INVF-1186 12516 1 2 1 15 30000.0 0.0 2400.0 714.28 714.28 0.0 27600.0 INR 12000.0 12000.0 15000.0 4 12516 2025-11-12 08:29:53 0 NULL 1 2025-11-12 08:30:10 1 0 NULL
187 197 POF-1187 INVF-1187 12516 1 2 1 10 20000.0 0.0 1600.0 476.19 476.19 0.0 18400.0 INR 8000.0 8000.0 10000.0 4 12516 2025-11-12 08:45:26 0 NULL 1 2025-11-12 08:46:42 1 0 NULL
188 198 POF-1188 INVF-1188 12554 12516 2 1 6183 1318368.8 0.0 65918.44 49394.47 49394.47 0.0 1252450.36 INR 458515.0 458515.0 458635.0 4 12554 2025-11-12 09:05:44 0 NULL 2 2025-11-12 16:11:41 12516 0 NULL
189 199 POF-1189 INVF-1189 12516 1 2 2 1 13699.0 0.0 1095.92 1044.84 1044.84 0.0 12603.08 INR 0.0 3000.0 0.0 4 12516 2025-11-12 09:53:05 0 NULL 1 2025-11-12 09:53:17 1 0 NULL
190 200 POF-1190 INVF-1190 12516 1 2 2 1 18000.0 0.0 1440.0 428.57 428.57 0.0 16560.0 INR 0.0 7500.0 0.0 4 12516 2025-11-12 09:59:48 0 NULL 1 2025-11-12 09:59:58 1 0 NULL
191 201 POF-1191 INVF-1191 12516 1 2 1 2550 414280.0 0.0 33142.4 13976.8 13976.8 0.0 381137.6 INR 149400.0 149400.0 150900.0 4 12516 2025-11-12 11:50:42 0 NULL 1 2025-11-12 12:04:42 1 0 NULL
192 202 POF-1192 INVF-1192 12554 12516 2 1 2500 406320.0 0.0 20316.0 13787.27 13787.27 0.0 386004.0 INR 147400.0 147400.0 148900.0 4 12554 2025-11-12 12:13:12 0 NULL 1 2025-11-12 12:13:59 12516 0 NULL
193 203 POF-1193 INVF-1193 12555 12554 2 1 2550 414280.0 0.0 8285.6 13976.8 13976.8 0.0 405994.4 INR 149400.0 149400.0 150900.0 4 12555 2025-11-12 12:22:06 0 NULL 2 2025-12-11 11:38:07 12554 0 NULL
194 204 POF-1194 INVF-1194 12516 1 2 1 2550 414280.0 0.0 33142.4 13976.8 13976.8 0.0 381137.6 INR 149400.0 149400.0 150900.0 4 12516 2025-11-12 12:29:52 0 NULL 1 2025-11-12 12:33:53 1 0 NULL
195 205 POF-1195 INVF-1195 12554 12516 2 1 50 7960.0 0.0 398.0 189.53 189.53 0.0 7562.0 INR 2000.0 2000.0 2450.0 4 12554 2025-11-12 12:37:16 0 NULL 1 2025-11-12 12:37:58 12516 0 NULL
196 206 POF-1196 INVF-1196 12517 12516 2 1 1 80.0 0.0 4.0 0.0 0.0 3.81 76.0 INR 28.0 28.0 38.0 4 12517 2025-11-12 12:37:41 0 NULL 1 2025-11-12 12:42:27 12516 0 NULL
197 207 POF-1197 INVF-1197 12517 12516 2 1 5516 443040.0 0.0 22152.0 0.0 0.0 37800.94 420888.0 INR 124200.0 124200.0 125400.0 4 12517 2025-11-12 12:40:36 0 NULL 1 2025-11-12 13:05:14 12516 0 NULL
198 208 POF-1198 INVF-1198 12516 1 2 1 2000 128000.0 0.0 10240.0 3047.61 3047.61 0.0 117760.0 INR 38000.0 38000.0 41000.0 4 12516 2025-11-12 12:44:00 0 NULL 1 2025-11-12 12:44:15 1 0 NULL
199 209 POF-1199 INVF-1199 12516 1 2 1 2000 128000.0 0.0 10240.0 3047.61 3047.61 0.0 117760.0 INR 38000.0 38000.0 41000.0 4 12516 2025-11-12 12:45:38 0 NULL 1 2025-11-12 12:51:12 1 0 NULL
200 210 POF-1200 INVF-1200 12516 1 2 1 2500 207600.0 0.0 16608.0 9118.8 9118.8 0.0 190992.0 INR 60500.0 60500.0 63500.0 4 12516 2025-11-12 12:53:28 0 NULL 1 2025-11-12 12:54:45 1 0 NULL