fx_franchise_order

1,057 rows · 31 columns · page 2 / 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
51 271 POF-1261 INVF-1261 12517 12516 2 2 2 37000.0 0.0 1850.0 0.0 0.0 1761.9 35150.0 INR 0.0 15000.0 0.0 4 12517 2025-11-21 07:28:54 0 NULL 1 2025-11-21 08:26:53 12516 0 NULL
52 272 POF-1262 INVF-1262 12516 1 2 1 40 22368.0 0.0 1789.44 532.57 532.57 0.0 20578.56 INR 6000.0 6000.0 9600.0 4 12516 2025-11-21 09:33:32 0 NULL 1 2025-11-21 09:33:54 1 0 NULL
53 273 POF-1263 INVF-1263 12516 1 2 1 20 23984.0 0.0 1918.72 571.05 571.05 0.0 22065.28 INR 9000.0 9000.0 13000.0 4 12516 2025-11-21 09:40:24 0 NULL 1 2025-11-21 09:40:46 1 0 NULL
54 274 POF-1264 INVF-1264 12517 12516 2 2 14 170989.0 0.0 8549.45 0.0 0.0 8142.34 162439.55 INR 0.0 38500.0 0.0 4 12517 2025-11-21 10:36:53 0 NULL 1 2025-11-21 11:25:40 12516 0 NULL
55 275 POF-1265 INVF-1265 12555 12554 2 1 30 16776.0 0.0 335.52 1279.53 1279.53 0.0 16440.48 INR 7500.0 7500.0 11100.0 4 12555 2025-11-21 14:42:45 0 NULL 1 2025-11-21 14:46:05 12554 0 NULL
56 276 POF-1266 INVF-1266 12554 12516 2 1 50 27960.0 0.0 1398.0 2132.54 2132.54 0.0 26562.0 INR 12500.0 12500.0 18500.0 4 12554 2025-11-21 14:43:41 0 NULL 1 2025-11-21 14:45:40 12516 0 NULL
57 277 POF-1267 INVF-1267 12516 1 2 1 50 27960.0 0.0 2236.8 2132.54 2132.54 0.0 25723.2 INR 12500.0 12500.0 18500.0 4 12516 2025-11-21 14:44:50 0 NULL 1 2025-11-21 14:45:09 1 0 NULL
58 278 POF-1268 INVF-1268 12555 12554 2 2 50 524950.0 0.0 10499.0 12498.81 12498.81 0.0 514451.0 INR 0.0 175000.0 0.0 4 12555 2025-11-22 13:10:28 0 NULL 1 2025-11-22 13:17:36 12554 0 NULL
59 279 POF-1269 INVF-1269 12554 12516 2 2 50 524950.0 0.0 26247.5 12498.81 12498.81 0.0 498702.5 INR 0.0 175000.0 0.0 4 12554 2025-11-22 13:11:20 0 NULL 1 2025-11-22 13:15:22 12516 0 NULL
60 280 POF-1270 INVF-1270 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-22 13:12:05 0 NULL 1 2025-11-22 13:14:55 1 0 NULL
61 281 POF-1271 INVF-1271 12516 1 2 2 10 104990.0 0.0 8399.2 2499.76 2499.76 0.0 96590.8 INR 0.0 35000.0 0.0 4 12516 2025-11-22 13:16:09 0 NULL 1 2025-11-22 13:16:23 1 0 NULL
62 282 POF-1272 INVF-1272 12555 12554 2 1 30 22224.0 0.0 444.48 688.63 688.63 0.0 21779.52 INR 8000.0 8000.0 10000.0 4 12555 2025-11-23 14:13:16 0 NULL 1 2025-11-23 14:16:50 12554 0 NULL
63 283 POF-1273 INVF-1273 12555 12554 2 1 10 11992.0 0.0 239.84 285.52 285.52 0.0 11752.16 INR 2500.0 2500.0 4750.0 4 12555 2025-11-24 11:59:58 0 NULL 1 2025-11-24 12:00:16 12554 0 NULL
64 284 POF-1274 INVF-1274 12552 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 12552 2025-11-24 15:08:20 0 NULL 1 2025-11-24 15:23:02 12517 0 NULL
65 285 POF-1275 INVF-1275 12555 12554 2 1 1 304.0 0.0 6.08 23.18 23.18 0.0 297.92 INR 100.0 100.0 176.0 4 12555 2025-11-24 18:08:41 0 NULL 1 2025-11-30 09:27:26 12554 0 NULL
66 286 POF-1276 INVF-1276 12555 12554 2 1 1 304.0 0.0 6.08 23.18 23.18 0.0 297.92 INR 100.0 100.0 176.0 4 12555 2025-11-25 13:27:10 0 NULL 1 2025-11-30 09:27:26 12554 0 NULL
67 287 POF-1277 INVF-1277 12554 12516 2 1 15 9868.0 0.0 493.4 721.21 721.21 0.0 9374.6 INR 3010.0 3010.0 3160.0 4 12554 2025-11-27 14:00:14 0 NULL 1 2025-11-27 14:00:38 12516 0 NULL
68 288 POF-1278 INVF-1278 12516 1 2 1 15 9868.0 0.0 789.44 721.21 721.21 0.0 9078.56 INR 3010.0 3010.0 3160.0 4 12516 2025-11-27 14:01:30 0 NULL 2 2025-12-11 12:04:58 1 0 NULL
69 289 POF-1279 INVF-1279 12555 12554 2 1 15 9868.0 0.0 197.36 721.21 721.21 0.0 9670.64 INR 3010.0 3010.0 3160.0 4 12555 2025-11-27 14:02:51 0 NULL 1 2025-11-27 14:03:18 12554 0 NULL
70 290 POF-1280 INVF-1280 12555 12554 2 1 320 74224.0 0.0 1484.48 5032.45 5032.45 0.0 72739.52 INR 22800.0 22800.0 24300.0 4 12555 2025-11-28 13:17:15 0 NULL 1 2025-11-28 13:21:46 12554 0 NULL
71 291 POF-1281 INVF-1281 12554 12516 2 1 320 74224.0 0.0 3711.2 5032.45 5032.45 0.0 70512.8 INR 22800.0 22800.0 24300.0 4 12554 2025-11-28 13:18:20 0 NULL 1 2025-11-28 13:21:31 12516 0 NULL
72 292 POF-1282 INVF-1282 12516 1 2 1 420 90144.0 0.0 7211.52 6246.69 6246.69 0.0 82932.48 INR 27300.0 27300.0 28800.0 4 12516 2025-11-28 13:19:22 0 NULL 1 2025-11-28 13:20:57 1 0 NULL
73 293 POF-1283 INVF-1283 12555 12554 2 1 220 59264.0 0.0 1185.28 4226.77 4226.77 0.0 58078.72 INR 25800.0 25800.0 26700.0 4 12555 2025-11-28 14:33:54 0 NULL 1 2025-11-28 14:40:05 12554 0 NULL
74 294 POF-1284 INVF-1284 12554 12516 2 1 20 8784.0 0.0 439.2 376.61 376.61 0.0 8344.8 INR 2300.0 2300.0 3200.0 4 12554 2025-11-28 14:37:16 0 NULL 1 2025-11-28 14:39:49 12516 0 NULL
75 295 POF-1285 INVF-1285 12516 1 2 1 20 8784.0 0.0 702.72 376.61 376.61 0.0 8081.28 INR 2300.0 2300.0 3200.0 4 12516 2025-11-28 14:38:07 0 NULL 1 2025-11-28 14:39:30 1 0 NULL
76 296 POF-1286 INVF-1286 12551 12516 2 1 3 912.0 0.0 45.6 69.56 69.56 0.0 866.4 INR 300.0 300.0 528.0 4 12551 2025-11-28 15:12:10 0 NULL 2 2025-12-11 11:39:38 12516 0 NULL
77 297 POF-1287 INVF-1287 12557 12517 2 1 1 304.0 0.0 6.08 23.18 23.18 0.0 297.92 INR 100.0 100.0 176.0 4 12557 2025-11-28 16:29:49 0 NULL 2 2025-11-28 16:31:03 12517 0 NULL
78 298 POF-1288 INVF-1288 12555 12554 2 1 10 15992.0 0.0 319.84 380.76 380.76 0.0 15672.16 INR 5000.0 5000.0 11000.0 4 12555 2025-11-29 15:18:16 0 NULL 1 2025-11-29 15:18:27 12554 0 NULL
79 299 POF-1289 INVF-1289 12855 12551 2 1 32 40960.0 0.0 819.2 975.24 975.24 0.0 40140.8 INR 14400.0 14400.0 19200.0 4 12855 2025-11-29 17:33:41 0 NULL 1 2025-11-29 19:56:16 12551 0 NULL
80 300 POF-1290 INVF-1290 12551 12516 2 1 32 40960.0 0.0 2048.0 975.24 975.24 0.0 38912.0 INR 14400.0 14400.0 19200.0 4 12551 2025-11-29 17:41:09 0 NULL 2 2025-12-11 11:39:38 12516 0 NULL
81 301 POF-1291 INVF-1291 12551 12516 2 1 4 1216.0 0.0 60.8 92.75 92.75 0.0 1155.2 INR 400.0 400.0 704.0 4 12551 2025-11-29 17:43:50 0 NULL 2 2025-12-11 11:39:38 12516 0 NULL
82 302 POF-1292 INVF-1292 12551 12516 2 1 4 1216.0 0.0 60.8 92.75 92.75 0.0 1155.2 INR 400.0 400.0 704.0 4 12551 2025-11-29 18:27:21 0 NULL 2 2025-12-11 11:39:38 12516 0 NULL
83 303 POF-1293 INVF-1293 12551 12516 2 1 11 3344.0 0.0 167.2 255.05 255.05 0.0 3176.8 INR 1100.0 1100.0 1936.0 4 12551 2025-11-29 18:42:52 0 NULL 2 2025-12-11 11:39:38 12516 0 NULL
84 304 POF-1294 INVF-1294 12551 12516 2 1 3 7437.0 0.0 371.85 177.07 177.07 0.0 7065.15 INR 1050.0 1050.0 4050.0 4 12551 2025-11-29 18:49:03 0 NULL 2 2025-12-11 11:39:38 12516 0 NULL
85 305 POF-1295 INVF-1295 12855 12551 2 1 3 4320.0 0.0 86.4 102.86 102.86 0.0 4233.6 INR 750.0 750.0 1770.0 4 12855 2025-11-29 19:18:05 0 NULL 1 2025-11-29 19:56:16 12551 0 NULL
86 306 POF-1296 INVF-1296 12855 12551 2 1 22 3502.4 0.0 70.05 267.13 267.13 0.0 3432.35 INR 990.0 990.0 1628.0 4 12855 2025-11-29 19:23:37 0 NULL 1 2025-11-29 19:56:16 12551 0 NULL
87 307 POF-1297 INVF-1297 12551 12516 2 1 54 4320.0 0.0 216.0 102.86 102.86 0.0 4104.0 INR 1512.0 1512.0 2052.0 4 12551 2025-11-29 20:19:51 0 NULL 2 2025-12-11 11:39:38 12516 0 NULL
88 308 POF-1298 INVF-1298 12855 12551 2 1 52 4160.0 0.0 83.2 99.05 99.05 0.0 4076.8 INR 1456.0 1456.0 1976.0 4 12855 2025-11-29 20:30:26 0 NULL 1 2025-11-29 20:34:29 12551 0 NULL
89 309 POF-1299 INVF-1299 12555 12554 2 1 4 14400.0 0.0 288.0 342.86 342.86 0.0 14112.0 INR 4000.0 4000.0 6400.0 4 12555 2025-11-30 09:22:58 0 NULL 1 2025-11-30 09:27:26 12554 0 NULL
90 310 POF-1300 INVF-1300 12554 12516 2 1 4 14400.0 0.0 720.0 342.86 342.86 0.0 13680.0 INR 4000.0 4000.0 6400.0 4 12554 2025-11-30 09:24:10 0 NULL 1 2025-11-30 09:26:56 12516 0 NULL
91 311 POF-1301 INVF-1301 12516 1 2 1 4 14400.0 0.0 1152.0 342.86 342.86 0.0 13248.0 INR 4000.0 4000.0 6400.0 4 12516 2025-11-30 09:25:32 0 NULL 1 2025-11-30 09:25:48 1 0 NULL
92 312 POF-1302 INVF-1302 12555 12554 2 1 1100 63920.0 0.0 1278.4 2357.09 2357.09 0.0 62641.6 INR 18000.0 18000.0 21000.0 4 12555 2025-11-30 15:48:04 0 NULL 1 2025-11-30 15:48:36 12554 0 NULL
93 313 POF-1303 INVF-1303 12555 12554 2 2 6 62994.0 0.0 1259.88 1499.86 1499.86 0.0 61734.12 INR 0.0 21000.0 0.0 4 12555 2025-11-30 19:50:50 0 NULL 1 2025-11-30 19:51:16 12554 0 NULL
94 314 POF-1304 INVF-1304 12555 12554 2 1 5 3996.0 0.0 79.92 304.78 304.78 0.0 3916.08 INR 1625.0 1625.0 2375.0 4 12555 2025-11-30 23:19:31 0 NULL 1 2025-11-30 23:20:14 12554 0 NULL
95 315 POF-1305 INVF-1305 12555 12554 2 1 4 4796.8 0.0 95.94 114.21 114.21 0.0 4700.86 INR 1700.0 1700.0 3100.0 4 12555 2025-11-30 23:27:23 0 NULL 1 2025-11-30 23:27:42 12554 0 NULL
96 316 POF-1306 INVF-1306 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-12-01 16:18:59 0 NULL 1 2025-12-01 16:22:14 12554 0 NULL
97 317 POF-1307 INVF-1307 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-12-01 16:19:41 0 NULL 1 2025-12-01 16:21:35 12516 0 NULL
98 318 POF-1308 INVF-1308 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-12-01 16:20:26 0 NULL 1 2025-12-01 16:21:04 1 0 NULL
99 319 POF-1309 INVF-1309 12855 12551 2 1 46 55200.0 0.0 1104.0 1314.29 1314.29 0.0 54096.0 INR 20700.0 20700.0 27600.0 4 12855 2025-12-01 17:49:50 0 NULL 2 2025-12-06 15:37:15 12551 0 NULL
100 320 POF-1310 INVF-1310 12855 12551 2 1 6 11995.2 0.0 239.9 285.6 285.6 0.0 11755.3 INR 4494.0 4494.0 7494.0 4 12855 2025-12-01 18:03:10 0 NULL 1 2025-12-01 18:38:54 12551 0 NULL