fx_franchise_order

1,057 rows · 31 columns · page 4 / 22

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 371 POF-1361 INVF-1361 12554 12516 2 1 100 79920.0 0.0 3996.0 6095.59 6095.59 0.0 75924.0 INR 0.0 50.0 0.0 4 12554 2025-12-17 14:55:38 0 NULL 1 2025-12-17 14:56:20 12516 0 NULL
152 372 POF-1362 INVF-1362 12516 1 2 1 100 79920.0 0.0 6393.6 6095.59 6095.59 0.0 73526.4 INR 0.0 50.0 0.0 4 12516 2025-12-17 14:55:58 0 NULL 1 2025-12-17 14:56:10 1 0 NULL
153 373 POF-1363 INVF-1363 12555 12554 2 1 60 62400.0 0.0 1248.0 1485.7 1485.7 0.0 61152.0 INR 0.0 5.0 0.0 4 12555 2025-12-17 21:29:33 0 NULL 1 2025-12-18 11:39:33 12554 0 NULL
154 374 POF-1364 INVF-1364 12516 1 2 1 800 698000.0 0.0 55840.0 19242.14 19242.14 0.0 642160.0 INR 0.0 50.0 0.0 4 12516 2025-12-17 21:41:08 0 NULL 1 2025-12-17 21:41:31 1 0 NULL
155 375 POF-1365 INVF-1365 12554 12516 2 1 450 409000.0 0.0 20450.0 11049.62 11049.62 0.0 388550.0 INR 0.0 25.0 0.0 4 12554 2025-12-17 21:44:19 0 NULL 1 2025-12-17 21:46:23 12516 0 NULL
156 376 POF-1366 INVF-1366 12516 1 2 1 100 120000.0 0.0 9600.0 2857.14 2857.14 0.0 110400.0 INR 0.0 100.0 0.0 4 12516 2025-12-17 21:45:35 0 NULL 1 2025-12-17 21:45:55 1 0 NULL
157 377 POF-1367 INVF-1367 12555 12554 2 1 700 674000.0 0.0 13480.0 18670.7 18670.7 0.0 660520.0 INR 0.0 50.0 0.0 4 12555 2025-12-17 21:53:22 0 NULL 1 2025-12-18 08:23:47 12554 0 NULL
158 378 POF-1368 INVF-1368 12555 12554 2 1 410 374000.0 0.0 7480.0 11527.84 11527.84 0.0 366520.0 INR 0.0 25.0 0.0 4 12555 2025-12-18 08:12:33 0 NULL 2 2025-12-18 13:38:10 12554 0 NULL
159 379 POF-1369 INVF-1369 12554 12516 2 1 700 674000.0 0.0 33700.0 18670.7 18670.7 0.0 640300.0 INR 0.0 50.0 0.0 4 12554 2025-12-18 08:16:30 0 NULL 1 2025-12-18 08:23:04 12516 0 NULL
160 380 POF-1370 INVF-1370 12516 1 2 1 700 674000.0 0.0 53920.0 18670.7 18670.7 0.0 620080.0 INR 0.0 50.0 0.0 4 12516 2025-12-18 08:18:58 0 NULL 1 2025-12-18 08:22:30 1 0 NULL
161 381 POF-1371 INVF-1371 12555 12554 2 1 40 28800.0 0.0 576.0 685.71 685.71 0.0 28224.0 INR 0.0 20.0 0.0 4 12555 2025-12-18 11:38:57 0 NULL 1 2025-12-18 11:39:26 12554 0 NULL
162 382 POF-1372 INVF-1372 12555 12554 2 1 50 25000.0 0.0 500.0 1906.78 1906.78 0.0 24500.0 INR 0.0 25.0 0.0 4 12555 2025-12-18 15:30:09 0 NULL 1 2025-12-18 15:30:20 12554 0 NULL
163 383 POF-1373 INVF-1373 12554 12516 2 1 100 50000.0 0.0 2500.0 3813.56 3813.56 0.0 47500.0 INR 0.0 50.0 0.0 4 12554 2025-12-18 17:03:38 0 NULL 1 2025-12-18 17:04:00 12516 0 NULL
164 384 POF-1374 INVF-1374 12555 12554 2 1 100 50000.0 0.0 1000.0 3813.56 3813.56 0.0 49000.0 INR 0.0 50.0 0.0 4 12555 2025-12-18 17:04:29 0 NULL 1 2025-12-18 17:04:40 12554 0 NULL
165 385 POF-1375 INVF-1375 12516 1 2 1 200 100000.0 0.0 8000.0 7627.12 7627.12 0.0 92000.0 INR 0.0 100.0 0.0 4 12516 2025-12-18 18:35:31 0 NULL 1 2025-12-18 18:37:23 1 0 NULL
166 386 POF-1376 INVF-1376 12554 12516 2 1 200 100000.0 0.0 5000.0 7627.12 7627.12 0.0 95000.0 INR 0.0 100.0 0.0 4 12554 2025-12-18 18:37:45 0 NULL 1 2025-12-18 18:38:00 12516 0 NULL
167 387 POF-1377 INVF-1377 12555 12554 2 1 200 100000.0 0.0 2000.0 7627.12 7627.12 0.0 98000.0 INR 0.0 100.0 0.0 4 12555 2025-12-18 18:38:26 0 NULL 1 2025-12-18 18:38:42 12554 0 NULL
168 388 POF-1378 INVF-1378 12516 1 2 1 100 72000.0 0.0 5760.0 1714.29 1714.29 0.0 66240.0 INR 0.0 50.0 0.0 4 12516 2025-12-18 18:54:57 0 NULL 1 2025-12-18 18:55:06 1 0 NULL
169 389 POF-1379 INVF-1379 12554 12516 2 1 100 72000.0 0.0 3600.0 1714.29 1714.29 0.0 68400.0 INR 0.0 50.0 0.0 4 12554 2025-12-18 18:55:22 0 NULL 1 2025-12-18 18:55:56 12516 0 NULL
170 390 POF-1380 INVF-1380 12555 12554 2 1 50 36000.0 0.0 720.0 857.14 857.14 0.0 35280.0 INR 0.0 25.0 0.0 4 12555 2025-12-18 18:55:44 0 NULL 1 2025-12-18 18:56:09 12554 0 NULL
171 391 POF-1381 INVF-1381 12555 12554 2 1 50 25000.0 0.0 500.0 1906.78 1906.78 0.0 24500.0 INR 0.0 25.0 0.0 4 12555 2025-12-19 08:19:38 0 NULL 1 2025-12-19 08:26:48 12554 0 NULL
172 392 POF-1382 INVF-1382 12516 1 2 1 600 322000.0 0.0 25760.0 20782.09 20782.09 0.0 296240.0 INR 0.0 50.0 0.0 4 12516 2025-12-19 08:20:54 0 NULL 1 2025-12-19 08:22:29 1 0 NULL
173 393 POF-1383 INVF-1383 12554 12516 2 1 500 272000.0 0.0 13600.0 16968.53 16968.53 0.0 258400.0 INR 0.0 50.0 0.0 4 12554 2025-12-19 08:23:11 0 NULL 1 2025-12-19 08:26:08 12516 0 NULL
174 394 POF-1384 INVF-1384 12555 12554 2 1 450 247000.0 0.0 4940.0 15061.75 15061.75 0.0 242060.0 INR 0.0 50.0 0.0 4 12555 2025-12-19 08:25:03 0 NULL 2 2025-12-19 08:26:43 12554 0 NULL
175 395 POF-1385 INVF-1385 12555 12554 2 1 450 247000.0 0.0 4940.0 15061.75 15061.75 0.0 242060.0 INR 0.0 50.0 0.0 4 12555 2025-12-19 08:25:38 0 NULL 1 2025-12-19 08:26:37 12554 0 NULL
176 396 POF-1386 INVF-1386 12555 12554 2 1 600 322000.0 0.0 6440.0 20782.08 20782.08 0.0 315560.0 INR 0.0 25.0 0.0 4 12555 2025-12-19 13:12:41 0 NULL 1 2025-12-19 13:25:06 12554 0 NULL
177 397 POF-1387 INVF-1387 12554 12516 2 1 500 250000.0 0.0 12500.0 19067.8 19067.8 0.0 237500.0 INR 0.0 250.0 0.0 4 12554 2025-12-19 13:21:26 0 NULL 1 2025-12-19 13:24:46 12516 0 NULL
178 398 POF-1388 INVF-1388 12554 12516 2 1 100 72000.0 0.0 3600.0 1714.28 1714.28 0.0 68400.0 INR 0.0 25.0 0.0 4 12554 2025-12-19 13:21:57 0 NULL 1 2025-12-19 13:24:52 12516 0 NULL
179 399 POF-1389 INVF-1389 12516 1 2 1 600 322000.0 0.0 25760.0 20782.08 20782.08 0.0 296240.0 INR 0.0 25.0 0.0 4 12516 2025-12-19 13:22:48 0 NULL 1 2025-12-19 13:24:30 1 0 NULL
180 400 POF-1390 INVF-1390 12555 12554 2 1 400 200000.0 0.0 4000.0 15254.24 15254.24 0.0 196000.0 INR 0.0 200.0 0.0 4 12555 2025-12-19 18:45:44 0 NULL 1 2025-12-19 18:47:55 12554 0 NULL
181 401 POF-1391 INVF-1391 12554 12516 2 1 400 200000.0 0.0 10000.0 15254.24 15254.24 0.0 190000.0 INR 0.0 200.0 0.0 4 12554 2025-12-19 18:46:10 0 NULL 1 2025-12-19 18:47:35 12516 0 NULL
182 402 POF-1392 INVF-1392 12516 1 2 1 400 200000.0 0.0 16000.0 15254.24 15254.24 0.0 184000.0 INR 0.0 200.0 0.0 4 12516 2025-12-19 18:46:31 0 NULL 1 2025-12-19 18:47:13 1 0 NULL
183 403 POF-1393 INVF-1393 12516 1 2 1 100 72000.0 0.0 5760.0 1714.29 1714.29 0.0 66240.0 INR 0.0 50.0 0.0 4 12516 2025-12-19 20:45:46 0 NULL 1 2025-12-19 20:48:41 1 0 NULL
184 404 POF-1394 INVF-1394 12554 12516 2 1 100 72000.0 0.0 3600.0 1714.29 1714.29 0.0 68400.0 INR 0.0 50.0 0.0 4 12554 2025-12-19 20:46:36 0 NULL 1 2025-12-19 20:49:12 12516 0 NULL
185 405 POF-1395 INVF-1395 12555 12554 2 1 100 72000.0 0.0 1440.0 1714.29 1714.29 0.0 70560.0 INR 0.0 50.0 0.0 4 12555 2025-12-19 20:47:30 0 NULL 1 2025-12-19 20:49:38 12554 0 NULL
186 406 POF-1396 INVF-1396 12554 12516 2 1 30 36000.0 0.0 1800.0 857.14 857.14 0.0 34200.0 INR 0.0 30.0 0.0 4 12554 2025-12-19 22:26:44 0 NULL 1 2025-12-19 22:28:01 12516 0 NULL
187 407 POF-1397 INVF-1397 12516 1 2 1 50 60000.0 0.0 4800.0 1428.57 1428.57 0.0 55200.0 INR 0.0 50.0 0.0 4 12516 2025-12-19 22:27:41 0 NULL 1 2025-12-19 22:27:51 1 0 NULL
188 408 POF-1398 INVF-1398 12555 12554 2 1 50 60000.0 0.0 1200.0 1428.57 1428.57 0.0 58800.0 INR 0.0 50.0 0.0 4 12555 2025-12-19 22:28:59 0 NULL 1 2025-12-19 22:35:04 12554 0 NULL
189 409 POF-1399 INVF-1399 12554 12516 2 1 50 60000.0 0.0 3000.0 1428.57 1428.57 0.0 57000.0 INR 0.0 50.0 0.0 4 12554 2025-12-19 22:30:32 0 NULL 1 2025-12-19 22:30:45 12516 0 NULL
190 410 POF-1400 INVF-1400 12516 1 2 1 50 60000.0 0.0 4800.0 1428.57 1428.57 0.0 55200.0 INR 0.0 50.0 0.0 4 12516 2025-12-19 22:32:59 0 NULL 1 2025-12-19 22:33:10 1 0 NULL
191 411 POF-1401 INVF-1401 12554 12516 2 1 50 60000.0 0.0 3000.0 1428.57 1428.57 0.0 57000.0 INR 0.0 50.0 0.0 4 12554 2025-12-19 22:34:31 0 NULL 1 2025-12-19 22:34:48 12516 0 NULL
192 412 POF-1402 INVF-1402 12555 12554 2 1 400 200000.0 0.0 4000.0 15254.24 15254.24 0.0 196000.0 INR 0.0 200.0 0.0 4 12555 2025-12-19 22:42:31 0 NULL 1 2025-12-19 22:44:31 12554 0 NULL
193 413 POF-1403 INVF-1403 12554 12516 2 1 400 200000.0 0.0 10000.0 15254.24 15254.24 0.0 190000.0 INR 0.0 200.0 0.0 4 12554 2025-12-19 22:42:58 0 NULL 1 2025-12-19 22:44:13 12516 0 NULL
194 414 POF-1404 INVF-1404 12516 1 2 1 400 200000.0 0.0 16000.0 15254.24 15254.24 0.0 184000.0 INR 0.0 200.0 0.0 4 12516 2025-12-19 22:43:22 0 NULL 1 2025-12-19 22:43:51 1 0 NULL
195 415 POF-1405 INVF-1405 12516 1 2 1 200 100000.0 0.0 8000.0 7627.12 7627.12 0.0 92000.0 INR 0.0 100.0 0.0 4 12516 2025-12-20 10:05:14 0 NULL 1 2025-12-20 10:05:26 1 0 NULL
196 416 POF-1406 INVF-1406 12554 12516 2 1 200 100000.0 0.0 5000.0 7627.12 7627.12 0.0 95000.0 INR 0.0 100.0 0.0 4 12554 2025-12-20 10:05:53 0 NULL 1 2025-12-20 10:06:12 12516 0 NULL
197 417 POF-1407 INVF-1407 12555 12554 2 1 200 100000.0 0.0 2000.0 7627.12 7627.12 0.0 98000.0 INR 0.0 100.0 0.0 4 12555 2025-12-20 10:06:40 0 NULL 1 2025-12-20 10:06:54 12554 0 NULL
198 418 POF-1408 INVF-1408 12555 12554 2 1 5 13000.0 0.0 260.0 309.52 309.52 0.0 12740.0 INR 0.0 5.0 0.0 4 12555 2025-12-20 10:39:39 0 NULL 1 2025-12-20 10:39:53 12554 0 NULL
199 419 POF-1409 INVF-1409 12516 1 2 1 20 229790.0 0.0 18383.2 3346.46 3346.46 0.0 211406.8 INR 0.0 30.0 0.0 4 12516 2025-12-21 09:57:14 0 NULL 1 2025-12-21 09:57:42 1 0 NULL
200 420 POF-1410 INVF-1410 12517 12516 2 1 2 15960.0 0.0 798.0 0.0 0.0 464.85 15162.0 INR 0.0 4.0 0.0 4 12517 2025-12-21 10:01:00 0 NULL 2 2025-12-21 11:28:04 12516 0 NULL