fx_franchise_order

1,057 rows · 31 columns · page 3 / 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
101 321 POF-1311 INVF-1311 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-12-03 17:17:31 0 NULL 1 2025-12-03 17:21:25 12517 0 NULL
102 322 POF-1312 INVF-1312 12555 12554 2 1 20 5584.0 0.0 111.68 132.95 132.95 0.0 5472.32 INR 2400.0 2400.0 3100.0 4 12555 2025-12-04 15:34:41 0 NULL 1 2025-12-04 15:36:59 12554 0 NULL
103 323 POF-1313 INVF-1313 12554 12516 2 1 30 8376.0 0.0 418.8 199.43 199.43 0.0 7957.2 INR 3600.0 3600.0 4650.0 4 12554 2025-12-04 15:36:04 0 NULL 1 2025-12-04 15:36:25 12516 0 NULL
104 324 POF-1314 INVF-1314 12551 12516 2 1 58 11969.6 0.0 598.48 620.44 620.44 0.0 11371.12 INR 3471.0 3471.0 3666.0 4 12551 2025-12-05 14:21:29 0 NULL 1 2025-12-05 14:25:26 12516 0 NULL
105 325 POF-1315 INVF-1315 12516 1 2 1 60 18240.0 0.0 1459.2 1159.32 1159.32 0.0 16780.8 INR 5400.0 5400.0 6360.0 4 12516 2025-12-05 14:23:35 0 NULL 1 2025-12-05 14:25:05 1 0 NULL
106 326 POF-1316 INVF-1316 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-12-05 14:30:49 0 NULL 1 2025-12-07 22:37:06 12516 0 NULL
107 327 POF-1317 INVF-1317 12551 12516 2 2 3 54000.0 0.0 2700.0 1285.71 1285.71 0.0 51300.0 INR 0.0 22500.0 0.0 4 12551 2025-12-05 14:34:50 0 NULL 1 2025-12-05 15:50:31 12516 0 NULL
108 328 POF-1318 INVF-1318 12551 12516 2 1 1 48.0 0.0 2.4 1.14 1.14 0.0 45.6 INR 10.0 10.0 13.0 4 12551 2025-12-05 15:47:09 0 NULL 1 2025-12-05 15:47:29 12516 0 NULL
109 329 POF-1319 INVF-1319 12555 12554 2 1 30 16776.0 0.0 335.52 692.59 692.59 0.0 16440.48 INR 8400.0 8400.0 12000.0 4 12555 2025-12-05 17:28:50 0 NULL 1 2025-12-05 17:32:32 12554 0 NULL
110 330 POF-1320 INVF-1320 12554 12516 2 1 30 16776.0 0.0 838.8 692.59 692.59 0.0 15937.2 INR 8400.0 8400.0 12000.0 4 12554 2025-12-05 17:29:37 0 NULL 1 2025-12-05 17:31:52 12516 0 NULL
111 331 POF-1321 INVF-1321 12516 1 2 1 30 16776.0 0.0 1342.08 692.59 692.59 0.0 15433.92 INR 8400.0 8400.0 12000.0 4 12516 2025-12-05 17:30:15 0 NULL 1 2025-12-05 17:31:03 1 0 NULL
112 332 POF-1322 INVF-1322 12555 12554 2 1 20 3184.0 0.0 63.68 242.85 242.85 0.0 3120.32 INR 700.0 700.0 1300.0 4 12555 2025-12-05 17:35:18 0 NULL 1 2025-12-05 17:36:41 12554 0 NULL
113 333 POF-1323 INVF-1323 12554 12516 2 1 30 4776.0 0.0 238.8 364.27 364.27 0.0 4537.2 INR 1050.0 1050.0 1950.0 4 12554 2025-12-05 17:36:01 0 NULL 1 2025-12-05 17:36:23 12516 0 NULL
114 334 POF-1324 INVF-1324 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-12-05 22:11:30 0 NULL 1 2025-12-06 13:40:13 12517 0 NULL
115 335 POF-1325 INVF-1325 12555 12554 2 2 40 419960.0 0.0 8399.2 9999.05 9999.05 0.0 411560.8 INR 0.0 140000.0 0.0 4 12555 2025-12-05 23:04:31 0 NULL 1 2025-12-05 23:08:49 12554 0 NULL
116 336 POF-1326 INVF-1326 12554 12516 2 2 60 629940.0 0.0 31497.0 14998.57 14998.57 0.0 598443.0 INR 0.0 210000.0 0.0 4 12554 2025-12-05 23:05:26 0 NULL 1 2025-12-05 23:08:19 12516 0 NULL
117 337 POF-1327 INVF-1327 12516 1 2 2 60 629940.0 0.0 50395.2 14998.57 14998.57 0.0 579544.8 INR 0.0 210000.0 0.0 4 12516 2025-12-05 23:06:47 0 NULL 1 2025-12-05 23:07:52 1 0 NULL
118 338 POF-1328 INVF-1328 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-12-06 13:46:32 0 NULL 1 2025-12-06 13:46:47 12517 0 NULL
119 339 POF-1329 INVF-1329 12855 12551 2 1 58 11969.6 0.0 239.39 620.42 620.42 0.0 11730.21 INR 3471.0 3471.0 3666.0 4 12855 2025-12-06 16:28:15 0 NULL 1 2025-12-06 16:36:57 12551 0 NULL
120 340 POF-1330 INVF-1330 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-12-07 22:35:52 0 NULL 1 2025-12-07 22:37:41 12554 0 NULL
121 341 POF-1331 INVF-1331 12554 12516 2 1 30 21576.0 0.0 1078.8 513.71 513.71 0.0 20497.2 INR 7500.0 7500.0 12600.0 4 12554 2025-12-07 22:36:33 0 NULL 1 2025-12-07 22:36:58 12516 0 NULL
122 342 POF-1332 INVF-1332 12855 12551 2 2 3 54000.0 0.0 1080.0 1285.71 1285.71 0.0 52920.0 INR 0.0 22500.0 0.0 4 12855 2025-12-08 13:51:53 0 NULL 1 2025-12-08 14:08:14 12551 0 NULL
123 343 POF-1333 INVF-1333 12855 12551 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 12855 2025-12-08 14:00:52 0 NULL 2 2025-12-08 14:08:27 12551 0 NULL
124 344 POF-1334 INVF-1334 12855 12551 2 1 4 8638.4 0.0 172.77 205.68 205.68 0.0 8465.63 INR 2500.0 2500.0 3700.0 4 12855 2025-12-08 14:19:43 0 NULL 1 2025-12-08 14:21:41 12551 0 NULL
125 345 POF-1335 INVF-1335 12855 12551 2 1 122 184960.0 0.0 3699.2 6107.76 6107.76 0.0 181260.8 INR 84600.0 84600.0 90600.0 4 12855 2025-12-08 14:34:32 0 NULL 1 2025-12-08 14:35:43 12551 0 NULL
126 346 POF-1336 INVF-1336 12855 12551 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 12855 2025-12-08 16:37:48 0 NULL 2 2025-12-08 16:39:48 12551 0 NULL
127 347 POF-1337 INVF-1337 12551 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 12551 2025-12-08 16:41:42 0 NULL 2 2025-12-11 11:39:38 12516 0 NULL
128 348 POF-1338 INVF-1338 12551 12516 2 1 4 1216.0 0.0 60.8 0.0 0.0 0.0 1155.2 INR 160.0 160.0 544.0 4 12551 2025-12-10 19:06:32 0 NULL 2 2025-12-11 11:39:38 12516 0 NULL
129 349 POF-1339 INVF-1339 12855 12551 2 1 4 1216.0 0.0 24.32 0.0 0.0 0.0 1191.68 INR 160.0 160.0 544.0 4 12855 2025-12-10 19:13:43 0 NULL 1 2025-12-10 19:16:53 12551 0 NULL
130 350 POF-1340 INVF-1340 12555 12554 2 2 10 104990.0 0.0 2099.8 2499.76 2499.76 0.0 102890.2 INR 0.0 35000.0 0.0 4 12555 2025-12-11 11:37:50 0 NULL 1 2025-12-11 11:38:03 12554 0 NULL
131 351 POF-1341 INVF-1341 12555 12554 2 1 30 9120.0 0.0 182.4 0.0 0.0 0.0 8937.6 INR 1200.0 1200.0 4080.0 4 12555 2025-12-11 12:03:19 0 NULL 1 2025-12-11 12:05:58 12554 0 NULL
132 352 POF-1342 INVF-1342 12554 12516 2 1 50 15200.0 0.0 760.0 0.0 0.0 0.0 14440.0 INR 2000.0 2000.0 6800.0 4 12554 2025-12-11 12:03:53 0 NULL 1 2025-12-11 12:05:44 12516 0 NULL
133 353 POF-1343 INVF-1343 12516 1 2 1 60 18240.0 0.0 1459.2 0.0 0.0 0.0 16780.8 INR 2400.0 2400.0 8160.0 4 12516 2025-12-11 12:04:31 0 NULL 1 2025-12-11 12:05:25 1 0 NULL
134 354 POF-1344 INVF-1344 12555 12554 2 1 10 23992.0 0.0 479.84 571.24 571.24 0.0 23512.16 INR 10000.0 10000.0 15000.0 4 12555 2025-12-13 15:30:09 0 NULL 1 2025-12-13 15:32:08 12554 0 NULL
135 355 POF-1345 INVF-1345 12555 12554 2 2 10 104990.0 0.0 2099.8 2499.76 2499.76 0.0 102890.2 INR 0.0 35000.0 0.0 4 12555 2025-12-13 16:28:16 0 NULL 1 2025-12-13 16:28:31 12554 0 NULL
136 356 POF-1346 INVF-1346 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-12-14 12:30:31 0 NULL 1 2025-12-14 12:43:50 12517 0 NULL
137 357 POF-1347 INVF-1347 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-12-14 12:48:00 0 NULL 1 2025-12-14 12:53:09 12517 0 NULL
138 358 POF-1348 INVF-1348 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-12-14 12:55:28 0 NULL 1 2025-12-14 13:00:21 12517 0 NULL
139 359 POF-1349 INVF-1349 12555 12554 2 2 20 209980.0 0.0 4199.6 4999.52 4999.52 0.0 205780.4 INR 0.0 70000.0 0.0 4 12555 2025-12-14 15:49:37 0 NULL 1 2025-12-14 15:54:04 12554 0 NULL
140 360 POF-1350 INVF-1350 12554 12516 2 2 20 209980.0 0.0 10499.0 4999.52 4999.52 0.0 199481.0 INR 0.0 70000.0 0.0 4 12554 2025-12-14 15:51:12 0 NULL 1 2025-12-14 15:53:33 12516 0 NULL
141 361 POF-1351 INVF-1351 12516 1 2 2 20 209980.0 0.0 16798.4 4999.52 4999.52 0.0 193181.6 INR 0.0 70000.0 0.0 4 12516 2025-12-14 15:52:13 0 NULL 1 2025-12-14 15:52:45 1 0 NULL
142 362 POF-1352 INVF-1352 12518 12517 2 1 101 72639.2 0.0 1452.78 1729.51 1729.51 0.0 71186.42 INR 0.0 50.5 0.0 4 12518 2025-12-16 15:39:27 0 NULL 2 2025-12-19 21:07:15 12517 0 NULL
143 363 POF-1353 INVF-1353 12555 12554 2 1 10 7192.0 0.0 143.84 171.24 171.24 0.0 7048.16 INR 0.0 5.0 0.0 4 12555 2025-12-16 16:37:33 0 NULL 1 2025-12-16 16:37:50 12554 0 NULL
144 364 POF-1354 INVF-1354 12516 1 2 1 20 209988.0 0.0 16799.04 3058.07 3058.07 0.0 193188.96 INR 0.0 30.0 0.0 4 12516 2025-12-17 12:02:36 0 NULL 1 2025-12-21 11:38:03 1 0 NULL
145 365 POF-1355 INVF-1355 12516 1 2 1 20 209988.0 0.0 16799.04 3058.07 3058.07 0.0 193188.96 INR 0.0 30.0 0.0 4 12516 2025-12-17 12:08:01 0 NULL 1 2025-12-17 12:09:09 1 0 NULL
146 366 POF-1356 INVF-1356 12554 12516 2 1 20 209988.0 0.0 10499.4 3058.07 3058.07 0.0 199488.6 INR 0.0 30.0 0.0 4 12554 2025-12-17 12:10:20 0 NULL 1 2025-12-17 12:11:02 12516 0 NULL
147 367 POF-1357 INVF-1357 12555 12554 2 1 20 209988.0 0.0 4199.76 3058.07 3058.07 0.0 205788.24 INR 0.0 30.0 0.0 4 12555 2025-12-17 12:12:24 0 NULL 1 2025-12-17 12:14:00 12554 0 NULL
148 368 POF-1358 INVF-1358 12555 12554 2 1 8 78595.2 0.0 1571.9 1144.59 1144.59 0.0 77023.3 INR 0.0 9.0 0.0 4 12555 2025-12-17 12:13:42 0 NULL 2 2025-12-23 20:09:52 12554 0 NULL
149 369 POF-1359 INVF-1359 12555 12554 2 1 10 7992.0 0.0 159.84 609.56 609.56 0.0 7832.16 INR 0.0 5.0 0.0 4 12555 2025-12-17 13:54:51 0 NULL 1 2025-12-17 13:55:08 12554 0 NULL
150 370 POF-1360 INVF-1360 12555 12554 2 1 100 79920.0 0.0 1598.4 6095.59 6095.59 0.0 78321.6 INR 0.0 50.0 0.0 4 12555 2025-12-17 14:55:12 0 NULL 1 2025-12-17 14:56:36 12554 0 NULL