fx_franchise_order

1,267 rows · 31 columns · page 5 / 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
201 211 POF-1201 INVF-1201 12516 1 2 1 9000 639200.0 0.0 51136.0 23570.94 23570.94 0.0 588064.0 INR 179000.0 179000.0 194000.0 4 12516 2025-11-12 13:02:37 0 NULL 1 2025-11-12 13:04:42 1 0 NULL
202 212 POF-1202 INVF-1202 12555 12554 2 1 100 199920.0 0.0 3998.4 4760.0 4760.0 0.0 195921.6 INR 74900.0 74900.0 124900.0 4 12555 2025-11-12 13:10:21 0 NULL 1 2025-11-12 13:11:19 12554 0 NULL
203 213 POF-1203 INVF-1203 12555 12554 2 1 20 14384.0 0.0 287.68 342.48 342.48 0.0 14096.32 INR 5000.0 5000.0 8400.0 4 12555 2025-11-12 13:22:45 0 NULL 1 2025-11-12 13:23:15 12554 0 NULL
204 214 POF-1204 INVF-1204 12555 12554 2 1 20 9584.0 0.0 191.68 228.19 228.19 0.0 9392.32 INR 3200.0 3200.0 4780.0 4 12555 2025-11-12 13:24:03 0 NULL 1 2025-11-12 13:24:23 12554 0 NULL
205 215 POF-1205 INVF-1205 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-12 14:02:23 0 NULL 1 2025-11-12 14:03:38 12516 0 NULL
206 216 POF-1206 INVF-1206 12517 12516 2 1 198 52742.4 0.0 2637.12 0.0 0.0 3789.01 50105.28 INR 19080.0 19080.0 19440.0 4 12517 2025-11-12 14:23:23 0 NULL 1 2025-11-12 15:21:17 12516 0 NULL
207 217 POF-1207 INVF-1207 12516 1 2 1 260 83680.0 0.0 6694.4 3023.14 3023.14 0.0 76985.6 INR 30830.0 30830.0 32030.0 4 12516 2025-11-12 15:14:55 0 NULL 1 2025-11-12 15:18:13 1 0 NULL
208 218 POF-1208 INVF-1208 12516 1 2 1 20 1760.0 0.0 140.8 134.24 134.24 0.0 1619.2 INR 500.0 500.0 660.0 4 12516 2025-11-12 15:20:18 0 NULL 1 2025-11-12 15:20:38 1 0 NULL
209 219 POF-1209 INVF-1209 12527 12517 2 1 200 9600.0 0.0 192.0 228.57 228.57 0.0 9408.0 INR 2000.0 2000.0 2600.0 4 12527 2025-11-12 16:25:14 0 NULL 1 2025-11-12 19:42:37 12517 0 NULL
210 220 POF-1210 INVF-1210 12516 1 2 1 2065 1973996.8 0.0 157919.74 68099.21 68099.21 0.0 1816077.06 INR 783090.0 783090.0 795090.0 4 12516 2025-11-12 17:31:01 0 NULL 1 2025-11-12 17:40:07 1 0 NULL
211 221 POF-1211 INVF-1211 12527 12517 2 1 8 4617.6 0.0 92.35 109.94 109.94 0.0 4525.25 INR 1620.0 1620.0 1865.0 4 12527 2025-11-12 21:35:38 0 NULL 1 2025-11-28 11:35:15 12517 0 NULL
212 222 POF-1212 INVF-1212 12527 12517 2 1 64 16772.8 0.0 335.46 432.76 432.76 0.0 16437.34 INR 3425.0 3425.0 6305.0 4 12527 2025-11-12 21:48:10 0 NULL 1 2025-11-13 10:47:06 12517 0 NULL
213 223 POF-1213 INVF-1213 12535 12516 2 2 18 260991.0 0.0 13049.55 6214.07 6214.07 0.0 247941.45 INR 0.0 31500.0 0.0 4 12535 2025-11-13 12:24:53 0 NULL 1 2025-11-13 12:29:14 12516 0 NULL
214 224 POF-1214 INVF-1214 12620 12535 2 2 13 173992.0 0.0 3479.84 4142.66 4142.66 0.0 170512.16 INR 0.0 28000.0 0.0 4 12620 2025-11-13 12:48:06 0 NULL 2 2025-11-13 12:49:17 12535 0 NULL
215 225 POF-1215 INVF-1215 12620 12535 2 2 18 260991.0 0.0 5219.82 6214.07 6214.07 0.0 255771.18 INR 0.0 31500.0 0.0 4 12620 2025-11-13 12:53:34 0 NULL 1 2025-11-13 12:53:59 12535 0 NULL
216 226 POF-1216 INVF-1216 12555 12554 2 1 50 7960.0 0.0 159.2 189.53 189.53 0.0 7800.8 INR 2000.0 2000.0 2450.0 4 12555 2025-11-13 13:03:27 0 NULL 1 2025-11-13 13:03:52 12554 0 NULL
217 227 POF-1217 INVF-1217 12555 12554 2 1 36 9331.2 0.0 186.62 272.28 272.28 0.0 9144.58 INR 3810.0 3810.0 3990.0 4 12555 2025-11-13 13:19:26 0 NULL 1 2025-11-13 13:19:51 12554 0 NULL
218 228 POF-1218 INVF-1218 12555 12554 2 1 20 11184.0 0.0 223.68 853.01 853.01 0.0 10960.32 INR 5000.0 5000.0 7400.0 4 12555 2025-11-13 14:20:06 0 NULL 1 2025-11-13 14:20:27 12554 0 NULL
219 229 POF-1219 INVF-1219 12555 12554 2 1 10 2040.0 0.0 40.8 48.57 48.57 0.0 1999.2 INR 540.0 540.0 1030.0 4 12555 2025-11-13 14:24:02 0 NULL 1 2025-11-13 14:25:47 12554 0 NULL
220 230 POF-1220 INVF-1220 12554 12516 2 1 20 4080.0 0.0 204.0 97.14 97.14 0.0 3876.0 INR 1080.0 1080.0 2060.0 4 12554 2025-11-13 14:25:14 0 NULL 1 2025-11-13 14:25:29 12516 0 NULL
221 231 POF-1221 INVF-1221 12555 12554 2 1 10 3040.0 0.0 60.8 0.0 0.0 0.0 2979.2 INR 400.0 400.0 1360.0 4 12555 2025-11-13 14:35:15 0 NULL 1 2025-11-13 14:39:08 12554 0 NULL
222 232 POF-1222 INVF-1222 12554 12516 2 1 10 3040.0 0.0 152.0 0.0 0.0 0.0 2888.0 INR 400.0 400.0 1360.0 4 12554 2025-11-13 14:36:11 0 NULL 1 2025-11-13 14:38:51 12516 0 NULL
223 233 POF-1223 INVF-1223 12516 1 2 1 5 1520.0 0.0 121.6 0.0 0.0 0.0 1398.4 INR 200.0 200.0 680.0 4 12516 2025-11-13 14:38:24 0 NULL 1 2025-11-13 14:38:33 1 0 NULL
224 234 POF-1224 INVF-1224 12555 12554 2 1 15 22185.0 0.0 443.7 528.22 528.22 0.0 21741.3 INR 3750.0 3750.0 7125.0 4 12555 2025-11-13 14:44:35 0 NULL 1 2025-11-13 14:50:07 12554 0 NULL
225 235 POF-1225 INVF-1225 12554 12516 2 1 20 29580.0 0.0 1479.0 704.28 704.28 0.0 28101.0 INR 5000.0 5000.0 9500.0 4 12554 2025-11-13 14:46:32 0 NULL 1 2025-11-13 14:49:49 12516 0 NULL
226 236 POF-1226 INVF-1226 12516 1 2 1 10 14790.0 0.0 1183.2 352.14 352.14 0.0 13606.8 INR 2500.0 2500.0 4750.0 4 12516 2025-11-13 14:49:10 0 NULL 1 2025-11-13 14:49:34 1 0 NULL
227 237 POF-1227 INVF-1227 12555 12554 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 12555 2025-11-13 16:02:29 0 NULL 1 2025-11-18 22:46:44 12554 0 NULL
228 238 POF-1228 INVF-1228 12554 12516 2 2 10 104990.0 0.0 5249.5 2499.76 2499.76 0.0 99740.5 INR 0.0 35000.0 0.0 4 12554 2025-11-13 16:03:11 0 NULL 1 2025-11-22 13:16:33 12516 0 NULL
229 239 POF-1229 INVF-1229 12555 12554 2 1 40 49600.0 0.0 992.0 1180.95 1180.95 0.0 48608.0 INR 18000.0 18000.0 21000.0 4 12555 2025-11-14 12:30:19 0 NULL 1 2025-11-14 12:35:05 12554 0 NULL
230 240 POF-1230 INVF-1230 12551 12516 2 1 446 395748.4 0.0 19787.42 11580.99 11580.99 0.0 375960.98 INR 153043.0 153043.0 159043.0 4 12551 2025-11-14 14:45:32 0 NULL 1 2025-11-14 15:40:28 12516 0 NULL
231 241 POF-1231 INVF-1231 12551 12516 2 2 3 55500.0 0.0 2775.0 1321.43 1321.43 0.0 52725.0 INR 0.0 22500.0 0.0 4 12551 2025-11-14 14:49:55 0 NULL 1 2025-11-14 15:36:23 12516 0 NULL
232 242 POF-1232 INVF-1232 12516 1 2 1 170 197968.0 0.0 15837.44 4661.1 4661.1 0.0 182130.56 INR 45800.0 45800.0 54290.0 4 12516 2025-11-14 15:33:11 0 NULL 1 2025-11-14 15:35:55 1 0 NULL
233 243 POF-1233 INVF-1233 12516 1 2 1 5 2996.0 0.0 239.68 71.33 71.33 0.0 2756.32 INR 950.0 950.0 1700.0 4 12516 2025-11-14 15:37:49 0 NULL 1 2025-11-14 15:38:23 1 0 NULL
234 244 POF-1234 INVF-1234 12516 1 2 1 10 36000.0 0.0 2880.0 857.14 857.14 0.0 33120.0 INR 10000.0 10000.0 16000.0 4 12516 2025-11-14 15:40:01 0 NULL 1 2025-11-14 15:40:14 1 0 NULL
235 245 POF-1235 INVF-1235 12855 12551 2 2 3 55500.0 0.0 1110.0 1321.43 1321.43 0.0 54390.0 INR 0.0 22500.0 0.0 4 12855 2025-11-14 15:47:27 0 NULL 1 2025-11-14 15:51:23 12551 0 NULL
236 246 POF-1236 INVF-1236 12855 12551 2 1 8 10240.0 0.0 204.8 243.81 243.81 0.0 10035.2 INR 3600.0 3600.0 4800.0 4 12855 2025-11-14 17:24:56 0 NULL 2 2025-11-14 17:48:02 12551 0 NULL
237 247 POF-1237 INVF-1237 12855 12551 2 1 8 10240.0 0.0 204.8 243.81 243.81 0.0 10035.2 INR 3600.0 3600.0 4800.0 4 12855 2025-11-14 17:41:01 0 NULL 1 2025-11-14 17:48:09 12551 0 NULL
238 248 POF-1238 INVF-1238 12555 12554 2 1 20 28800.0 0.0 576.0 685.72 685.72 0.0 28224.0 INR 12000.0 12000.0 14000.0 4 12555 2025-11-17 12:26:01 0 NULL 1 2025-11-17 12:27:01 12554 0 NULL
239 249 POF-1239 INVF-1239 12554 12516 2 1 20 28800.0 0.0 1440.0 685.72 685.72 0.0 27360.0 INR 12000.0 12000.0 14000.0 4 12554 2025-11-17 12:26:25 0 NULL 1 2025-11-17 12:26:44 12516 0 NULL
240 250 POF-1240 INVF-1240 12551 12516 2 1 1135 61884.0 0.0 3094.2 1473.43 1473.43 0.0 58789.8 INR 13820.0 13820.0 14065.0 4 12551 2025-11-18 13:38:15 0 NULL 1 2025-11-18 13:44:54 12516 0 NULL
241 251 POF-1241 INVF-1241 12552 12517 2 2 3 47499.0 0.0 949.98 1130.92 1130.92 0.0 46549.02 INR 0.0 3500.0 0.0 4 12552 2025-11-18 16:12:53 0 NULL 1 2025-11-18 20:19:35 12517 0 NULL
242 252 POF-1242 INVF-1242 12517 12516 2 2 3 47499.0 0.0 2374.95 0.0 0.0 2261.85 45124.05 INR 0.0 3500.0 0.0 4 12517 2025-11-18 17:22:34 0 NULL 1 2025-11-18 17:52:35 12516 0 NULL
243 253 POF-1243 INVF-1243 12555 12554 2 2 30 314970.0 0.0 6299.4 7499.28 7499.28 0.0 308670.6 INR 0.0 105000.0 0.0 4 12555 2025-11-18 22:39:28 0 NULL 1 2025-11-18 22:46:33 12554 0 NULL
244 254 POF-1244 INVF-1244 12554 12516 2 2 40 419960.0 0.0 20998.0 9999.05 9999.05 0.0 398962.0 INR 0.0 140000.0 0.0 4 12554 2025-11-18 22:41:31 0 NULL 1 2025-11-18 22:45:05 12516 0 NULL
245 255 POF-1245 INVF-1245 12516 1 2 2 50 524950.0 0.0 41996.0 12498.81 12498.81 0.0 482954.0 INR 0.0 175000.0 0.0 4 12516 2025-11-18 22:44:17 0 NULL 1 2025-11-18 22:44:46 1 0 NULL
246 256 POF-1246 INVF-1246 12555 12554 2 1 10 5592.0 0.0 111.84 133.15 133.15 0.0 5480.16 INR 1500.0 1500.0 2400.0 4 12555 2025-11-19 14:27:00 0 NULL 1 2025-11-19 14:28:04 12554 0 NULL
247 257 POF-1247 INVF-1247 12555 12554 2 1 10 3040.0 0.0 60.8 231.87 231.87 0.0 2979.2 INR 1000.0 1000.0 1760.0 4 12555 2025-11-19 17:59:07 0 NULL 1 2025-11-19 18:12:04 12554 0 NULL
248 258 POF-1248 INVF-1248 12555 12554 2 1 40 19968.0 0.0 399.36 475.43 475.43 0.0 19568.64 INR 7400.0 7400.0 10800.0 4 12555 2025-11-19 18:07:08 0 NULL 1 2025-11-19 18:12:05 12554 0 NULL
249 259 POF-1249 INVF-1249 12554 12516 2 1 20 14384.0 0.0 719.2 342.48 342.48 0.0 13664.8 INR 5000.0 5000.0 8400.0 4 12554 2025-11-19 18:08:15 0 NULL 1 2025-11-19 18:10:43 12516 0 NULL
250 260 POF-1250 INVF-1250 12516 1 2 1 40 28768.0 0.0 2301.44 684.95 684.95 0.0 26466.56 INR 10000.0 10000.0 16800.0 4 12516 2025-11-19 18:09:08 0 NULL 1 2025-11-19 18:09:46 1 0 NULL