fx_franchise_order

1,057 rows · 31 columns · page 1 / 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
1 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
2 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
3 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
4 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
5 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
6 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
7 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
8 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
9 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
10 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
11 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
12 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
13 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
14 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
15 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
16 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
17 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
18 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
19 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
20 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
21 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
22 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
23 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
24 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
25 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
26 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
27 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
28 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
29 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
30 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
31 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
32 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
33 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
34 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
35 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
36 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
37 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
38 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
39 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
40 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
41 261 POF-1251 INVF-1251 12552 12517 2 2 2 37000.0 0.0 740.0 880.95 880.95 0.0 36260.0 INR 0.0 15000.0 0.0 4 12552 2025-11-19 21:38:07 0 NULL 1 2025-11-19 21:39:01 12517 0 NULL
42 262 POF-1252 INVF-1252 12855 12551 2 1 1115 56336.0 0.0 1126.72 1516.77 1516.77 0.0 55209.28 INR 12140.0 12140.0 15452.0 4 12855 2025-11-20 12:35:41 0 NULL 1 2025-11-20 12:39:01 12551 0 NULL
43 263 POF-1253 INVF-1253 12855 12551 2 1 20 7584.0 0.0 151.68 180.57 180.57 0.0 7432.32 INR 2450.0 2450.0 2540.0 4 12855 2025-11-20 13:59:55 0 NULL 1 2025-11-26 16:40:14 12551 0 NULL
44 264 POF-1254 INVF-1254 12555 12554 2 1 220 68912.0 0.0 1378.24 1351.23 1351.23 0.0 67533.76 INR 18600.0 18600.0 22440.0 4 12555 2025-11-20 14:02:23 0 NULL 1 2025-11-20 15:21:39 12554 0 NULL
45 265 POF-1255 INVF-1255 12554 12516 2 1 140 32560.0 0.0 1628.0 485.71 485.71 0.0 30932.0 INR 7000.0 7000.0 10840.0 4 12554 2025-11-20 14:04:39 0 NULL 1 2025-11-20 15:21:07 12516 0 NULL
46 266 POF-1256 INVF-1256 12516 1 2 1 100 20400.0 0.0 1632.0 485.71 485.71 0.0 18768.0 INR 5400.0 5400.0 10300.0 4 12516 2025-11-20 14:07:37 0 NULL 1 2025-11-20 15:18:58 1 0 NULL
47 267 POF-1257 INVF-1257 12516 1 2 1 40 12160.0 0.0 972.8 0.0 0.0 0.0 11187.2 INR 1600.0 1600.0 5440.0 4 12516 2025-11-20 15:20:23 0 NULL 1 2025-11-20 15:20:58 1 0 NULL
48 268 POF-1258 INVF-1258 12555 12554 2 1 20 5200.0 0.0 104.0 396.61 396.61 0.0 5096.0 INR 1420.0 1420.0 2720.0 4 12555 2025-11-20 17:46:39 0 NULL 1 2025-11-20 17:46:58 12554 0 NULL
49 269 POF-1259 INVF-1259 12555 12554 2 1 20 10384.0 0.0 207.68 247.24 247.24 0.0 10176.32 INR 2850.0 2850.0 4550.0 4 12555 2025-11-20 22:15:12 0 NULL 1 2025-11-20 22:19:33 12554 0 NULL
50 270 POF-1260 INVF-1260 12517 12516 2 1 232 129920.0 0.0 6496.0 0.0 0.0 9742.33 123424.0 INR 45970.0 45970.0 46570.0 4 12517 2025-11-20 23:13:55 0 NULL 1 2025-11-21 09:41:39 12516 0 NULL