fx_franchise_order
| # | 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 | 111 | POF-1101 | INVF-1101 | 12516 | 1 | 2 | 1 | 15 | 1200.0 | 0.0 | 96.0 | 28.57 | 28.57 | 0.0 | 1104.0 | INR | 420.0 | 420.0 | 570.0 | 4 | 12516 | 2025-11-09 13:42:51 | 0 | NULL | 1 | 2025-11-09 22:37:31 | 1 | 0 | NULL | ||
| 102 | 112 | POF-1102 | INVF-1102 | 12516 | 1 | 2 | 1 | 30 | 5288.0 | 0.0 | 423.04 | 125.91 | 125.91 | 0.0 | 4864.96 | INR | 1880.0 | 1880.0 | 2380.0 | 4 | 12516 | 2025-11-09 13:54:46 | 0 | NULL | 1 | 2025-11-09 22:37:31 | 1 | 0 | NULL | ||
| 103 | 113 | POF-1103 | INVF-1103 | 12516 | 1 | 2 | 1 | 25 | 3284.0 | 0.0 | 262.72 | 78.19 | 78.19 | 0.0 | 3021.28 | INR | 1130.0 | 1130.0 | 1380.0 | 4 | 12516 | 2025-11-09 14:07:35 | 0 | NULL | 1 | 2025-11-09 22:37:31 | 1 | 0 | NULL | ||
| 104 | 114 | POF-1104 | INVF-1104 | 12516 | 1 | 2 | 1 | 40 | 8160.0 | 0.0 | 652.8 | 194.29 | 194.29 | 0.0 | 7507.2 | INR | 2880.0 | 2880.0 | 3380.0 | 4 | 12516 | 2025-11-09 14:17:22 | 0 | NULL | 1 | 2025-11-09 22:37:31 | 1 | 0 | NULL | ||
| 105 | 115 | POF-1105 | INVF-1105 | 12516 | 1 | 2 | 1 | 1 | 304.0 | 0.0 | 24.32 | 23.18 | 23.18 | 0.0 | 279.68 | INR | 250.0 | 250.0 | 370.0 | 4 | 12516 | 2025-11-09 14:26:51 | 0 | NULL | 1 | 2025-11-09 22:37:31 | 1 | 0 | NULL | ||
| 106 | 116 | POF-1106 | INVF-1106 | 12516 | 1 | 2 | 1 | 10 | 6400.0 | 0.0 | 512.0 | 152.38 | 152.38 | 0.0 | 5888.0 | INR | 2000.0 | 2000.0 | 2800.0 | 4 | 12516 | 2025-11-09 14:29:51 | 0 | NULL | 1 | 2025-11-09 22:37:31 | 1 | 0 | NULL | ||
| 107 | 117 | POF-1107 | INVF-1107 | 12517 | 12516 | 2 | 2 | 2 | 20998.0 | 0.0 | 1049.9 | 0.0 | 0.0 | 999.9 | 19948.1 | INR | 0.0 | 7000.0 | 0.0 | 4 | 12517 | 2025-11-09 15:58:33 | 0 | NULL | 1 | 2025-11-09 22:21:38 | 12516 | 0 | NULL | ||
| 108 | 118 | POF-1108 | INVF-1108 | 12526 | 12517 | 2 | 1 | 180 | 18144.0 | 0.0 | 362.88 | 918.0 | 918.0 | 0.0 | 17781.12 | INR | 5980.0 | 5980.0 | 6280.0 | 4 | 12526 | 2025-11-09 16:16:59 | 0 | NULL | 1 | 2025-11-12 15:26:00 | 12517 | 0 | NULL | ||
| 109 | 119 | POF-1109 | INVF-1109 | 12557 | 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 | 12557 | 2025-11-09 16:21:33 | 0 | NULL | 1 | 2025-11-09 17:09:42 | 12517 | 0 | NULL | ||
| 110 | 120 | POF-1110 | INVF-1110 | 12539 | 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 | 12539 | 2025-11-09 16:35:54 | 0 | NULL | 1 | 2025-11-09 19:39:06 | 12517 | 0 | NULL | ||
| 111 | 121 | POF-1111 | INVF-1111 | 12524 | 12517 | 2 | 1 | 180 | 42996.0 | 0.0 | 859.92 | 2394.23 | 2394.23 | 0.0 | 42136.08 | INR | 15730.0 | 15730.0 | 16030.0 | 4 | 12524 | 2025-11-09 16:36:10 | 0 | NULL | 1 | 2025-11-12 15:26:01 | 12517 | 0 | NULL | ||
| 112 | 122 | POF-1112 | INVF-1112 | 12517 | 12516 | 2 | 2 | 2 | 20998.0 | 0.0 | 1049.9 | 0.0 | 0.0 | 999.9 | 19948.1 | INR | 0.0 | 7000.0 | 0.0 | 4 | 12517 | 2025-11-09 17:07:48 | 0 | NULL | 1 | 2025-11-09 17:08:18 | 12516 | 0 | NULL | ||
| 113 | 123 | POF-1113 | INVF-1113 | 12540 | 12517 | 2 | 1 | 97 | 10656.0 | 0.0 | 213.12 | 278.3 | 278.3 | 0.0 | 10442.88 | INR | 2862.0 | 2862.0 | 2992.0 | 4 | 12540 | 2025-11-09 19:11:39 | 0 | NULL | 1 | 2025-11-12 15:26:01 | 12517 | 0 | NULL | ||
| 114 | 124 | POF-1114 | INVF-1114 | 12517 | 12516 | 2 | 2 | 1 | 10499.0 | 0.0 | 524.95 | 0.0 | 0.0 | 499.95 | 9974.05 | INR | 0.0 | 3500.0 | 0.0 | 4 | 12517 | 2025-11-09 19:37:47 | 0 | NULL | 1 | 2025-11-09 19:38:37 | 12516 | 0 | NULL | ||
| 115 | 125 | POF-1115 | INVF-1115 | 12525 | 12517 | 2 | 2 | 2 | 20998.0 | 0.0 | 419.96 | 499.95 | 499.95 | 0.0 | 20578.04 | INR | 0.0 | 7000.0 | 0.0 | 4 | 12525 | 2025-11-09 21:31:07 | 0 | NULL | 2 | 2025-11-10 18:10:04 | 12517 | 0 | NULL | ||
| 116 | 126 | POF-1116 | INVF-1116 | 12517 | 12516 | 2 | 2 | 2 | 20998.0 | 0.0 | 1049.9 | 0.0 | 0.0 | 999.9 | 19948.1 | INR | 0.0 | 7000.0 | 0.0 | 4 | 12517 | 2025-11-09 21:36:02 | 0 | NULL | 1 | 2025-11-09 22:21:38 | 12516 | 0 | NULL | ||
| 117 | 127 | POF-1117 | INVF-1117 | 12525 | 12517 | 2 | 2 | 2 | 20998.0 | 0.0 | 419.96 | 499.95 | 499.95 | 0.0 | 20578.04 | INR | 0.0 | 7000.0 | 0.0 | 4 | 12525 | 2025-11-09 21:59:41 | 0 | NULL | 1 | 2025-11-09 22:25:19 | 12517 | 0 | NULL | ||
| 118 | 128 | POF-1118 | INVF-1118 | 12546 | 12517 | 2 | 1 | 31 | 5652.0 | 0.0 | 113.04 | 134.57 | 134.57 | 0.0 | 5538.96 | INR | 1464.0 | 1464.0 | 2248.0 | 4 | 12546 | 2025-11-10 06:50:30 | 0 | NULL | 1 | 2025-11-10 18:06:08 | 12517 | 0 | NULL | ||
| 119 | 129 | POF-1119 | INVF-1119 | 12544 | 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 | 12544 | 2025-11-10 10:10:06 | 0 | NULL | 1 | 2025-11-10 14:49:32 | 12517 | 0 | NULL | ||
| 120 | 130 | POF-1120 | INVF-1120 | 12525 | 12517 | 2 | 1 | 164 | 18973.4 | 0.0 | 379.47 | 697.52 | 697.52 | 0.0 | 18593.93 | INR | 5650.0 | 5650.0 | 6385.0 | 4 | 12525 | 2025-11-10 14:50:14 | 0 | NULL | 1 | 2025-11-12 15:26:01 | 12517 | 0 | NULL | ||
| 121 | 131 | POF-1121 | INVF-1121 | 12543 | 12517 | 2 | 2 | 2 | 20998.0 | 0.0 | 419.96 | 499.95 | 499.95 | 0.0 | 20578.04 | INR | 0.0 | 7000.0 | 0.0 | 4 | 12543 | 2025-11-10 15:17:53 | 0 | NULL | 1 | 2025-11-10 16:01:58 | 12517 | 0 | NULL | ||
| 122 | 132 | POF-1122 | INVF-1122 | 12517 | 12516 | 2 | 2 | 2 | 20998.0 | 0.0 | 1049.9 | 0.0 | 0.0 | 999.9 | 19948.1 | INR | 0.0 | 7000.0 | 0.0 | 4 | 12517 | 2025-11-10 15:38:31 | 0 | NULL | 1 | 2025-11-10 16:01:34 | 12516 | 0 | NULL | ||
| 123 | 133 | POF-1123 | INVF-1123 | 12552 | 12517 | 2 | 2 | 2 | 17697.4 | 0.0 | 353.95 | 1140.04 | 1140.04 | 0.0 | 17343.45 | INR | 0.0 | 1000.0 | 0.0 | 4 | 12552 | 2025-11-10 16:31:44 | 0 | NULL | 1 | 2025-11-10 16:34:25 | 12517 | 0 | NULL | ||
| 124 | 134 | POF-1124 | INVF-1124 | 12517 | 12516 | 2 | 2 | 1 | 13699.0 | 0.0 | 684.95 | 0.0 | 0.0 | 2089.68 | 13014.05 | INR | 0.0 | 3000.0 | 0.0 | 4 | 12517 | 2025-11-10 16:32:36 | 0 | NULL | 1 | 2025-11-10 16:32:52 | 12516 | 0 | NULL | ||
| 125 | 135 | POF-1125 | INVF-1125 | 12517 | 12516 | 2 | 2 | 1 | 3998.4 | 0.0 | 199.92 | 0.0 | 0.0 | 190.4 | 3798.48 | INR | 0.0 | 1000.0 | 0.0 | 4 | 12517 | 2025-11-10 16:33:45 | 0 | NULL | 1 | 2025-11-10 16:33:55 | 12516 | 0 | NULL | ||
| 126 | 136 | POF-1126 | INVF-1126 | 12532 | 12517 | 2 | 2 | 2 | 20998.0 | 0.0 | 419.96 | 499.95 | 499.95 | 0.0 | 20578.04 | INR | 0.0 | 7000.0 | 0.0 | 4 | 12532 | 2025-11-10 18:07:31 | 0 | NULL | 1 | 2025-11-10 18:30:15 | 12517 | 0 | NULL | ||
| 127 | 137 | POF-1127 | INVF-1127 | 12517 | 12516 | 2 | 2 | 4 | 41996.0 | 0.0 | 2099.8 | 0.0 | 0.0 | 1999.81 | 39896.2 | INR | 0.0 | 14000.0 | 0.0 | 4 | 12517 | 2025-11-10 18:20:37 | 0 | NULL | 1 | 2025-11-10 18:28:14 | 12516 | 0 | NULL | ||
| 128 | 138 | POF-1128 | INVF-1128 | 12526 | 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 | 12526 | 2025-11-10 18:33:12 | 0 | NULL | 1 | 2025-11-10 18:38:32 | 12517 | 0 | NULL | ||
| 129 | 139 | POF-1129 | INVF-1129 | 12685 | 12517 | 2 | 1 | 230 | 65822.6 | 0.0 | 1316.45 | 2845.26 | 2845.26 | 0.0 | 64506.15 | INR | 22195.0 | 22195.0 | 22555.0 | 4 | 12685 | 2025-11-10 18:55:28 | 0 | NULL | 1 | 2025-11-12 15:26:01 | 12517 | 0 | NULL | ||
| 130 | 140 | POF-1130 | INVF-1130 | 12517 | 12516 | 2 | 2 | 5 | 52495.0 | 0.0 | 2624.75 | 0.0 | 0.0 | 2499.76 | 49870.25 | INR | 0.0 | 17500.0 | 0.0 | 4 | 12517 | 2025-11-10 19:06:03 | 0 | NULL | 1 | 2025-11-10 19:29:14 | 12516 | 0 | NULL | ||
| 131 | 141 | POF-1131 | INVF-1131 | 12536 | 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 | 12536 | 2025-11-10 19:27:00 | 0 | NULL | 1 | 2025-11-10 20:12:12 | 12517 | 0 | NULL | ||
| 132 | 142 | POF-1132 | INVF-1132 | 12529 | 12517 | 2 | 2 | 2 | 20998.0 | 0.0 | 419.96 | 499.95 | 499.95 | 0.0 | 20578.04 | INR | 0.0 | 7000.0 | 0.0 | 4 | 12529 | 2025-11-10 19:45:02 | 0 | NULL | 1 | 2025-11-10 21:35:24 | 12517 | 0 | NULL | ||
| 133 | 143 | POF-1133 | INVF-1133 | 12529 | 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 | 12529 | 2025-11-10 19:46:03 | 0 | NULL | 1 | 2025-11-10 22:41:12 | 12517 | 0 | NULL | ||
| 134 | 144 | POF-1134 | INVF-1134 | 12533 | 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 | 12533 | 2025-11-10 20:08:36 | 0 | NULL | 1 | 2025-11-11 16:09:56 | 12517 | 0 | NULL | ||
| 135 | 145 | POF-1135 | INVF-1135 | 12542 | 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 | 12542 | 2025-11-10 22:10:59 | 0 | NULL | 1 | 2025-11-10 22:16:11 | 12517 | 0 | NULL | ||
| 136 | 146 | POF-1136 | INVF-1136 | 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-10 22:25:50 | 0 | NULL | 1 | 2025-11-10 22:40:20 | 12516 | 0 | NULL | ||
| 137 | 147 | POF-1137 | INVF-1137 | 12544 | 12517 | 2 | 2 | 2 | 20998.0 | 0.0 | 419.96 | 499.95 | 499.95 | 0.0 | 20578.04 | INR | 0.0 | 7000.0 | 0.0 | 4 | 12544 | 2025-11-11 08:05:05 | 0 | NULL | 1 | 2025-11-11 12:19:25 | 12517 | 0 | NULL | ||
| 138 | 148 | POF-1138 | INVF-1138 | 12557 | 12517 | 2 | 1 | 1 | 719.2 | 0.0 | 14.38 | 17.12 | 17.12 | 0.0 | 704.82 | INR | 250.0 | 250.0 | 420.0 | 4 | 12557 | 2025-11-11 11:23:26 | 0 | NULL | 1 | 2025-11-12 15:26:01 | 12517 | 0 | NULL | ||
| 139 | 149 | POF-1139 | INVF-1139 | 12523 | 12517 | 2 | 1 | 111 | 23595.2 | 0.0 | 471.9 | 1436.8 | 1436.8 | 0.0 | 23123.3 | INR | 9500.0 | 9500.0 | 9800.0 | 4 | 12523 | 2025-11-11 13:11:59 | 0 | NULL | 1 | 2025-11-12 15:26:01 | 12517 | 0 | NULL | ||
| 140 | 150 | POF-1140 | INVF-1140 | 12534 | 12517 | 2 | 1 | 102 | 12475.2 | 0.0 | 249.5 | 552.09 | 552.09 | 0.0 | 12225.7 | INR | 3669.0 | 3669.0 | 3819.0 | 4 | 12534 | 2025-11-11 13:16:22 | 0 | NULL | 1 | 2025-11-12 15:26:01 | 12517 | 0 | NULL | ||
| 141 | 151 | POF-1141 | INVF-1141 | 12518 | 12517 | 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 | 12518 | 2025-11-11 13:21:49 | 0 | NULL | 1 | 2025-11-11 19:50:46 | 12517 | 0 | NULL | ||
| 142 | 152 | POF-1142 | INVF-1142 | 12532 | 12517 | 2 | 1 | 30 | 14308.0 | 0.0 | 286.16 | 462.17 | 462.17 | 0.0 | 14021.84 | INR | 4675.0 | 4675.0 | 4750.0 | 4 | 12532 | 2025-11-11 13:39:46 | 0 | NULL | 2 | 2025-11-11 13:44:24 | 12517 | 0 | NULL | ||
| 143 | 153 | POF-1143 | INVF-1143 | 12542 | 12517 | 2 | 1 | 472 | 66230.2 | 0.0 | 1324.6 | 2299.47 | 2299.47 | 0.0 | 64905.6 | INR | 20735.0 | 20735.0 | 21110.0 | 4 | 12542 | 2025-11-11 13:44:53 | 0 | NULL | 1 | 2025-11-11 14:41:31 | 12517 | 0 | NULL | ||
| 144 | 154 | POF-1144 | INVF-1144 | 12540 | 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 | 12540 | 2025-11-11 14:09:03 | 0 | NULL | 1 | 2025-11-11 16:09:56 | 12517 | 0 | NULL | ||
| 145 | 155 | POF-1145 | INVF-1145 | 12517 | 12516 | 2 | 1 | 23 | 13107.2 | 0.0 | 655.36 | 0.0 | 0.0 | 624.15 | 12451.84 | INR | 4670.0 | 4670.0 | 4820.0 | 4 | 12517 | 2025-11-11 14:09:53 | 0 | NULL | 1 | 2025-11-11 14:40:40 | 12516 | 0 | NULL | ||
| 146 | 156 | POF-1146 | INVF-1146 | 12516 | 1 | 2 | 1 | 70 | 57568.0 | 0.0 | 4605.44 | 1370.66 | 1370.66 | 0.0 | 52962.56 | INR | 20900.0 | 20900.0 | 22400.0 | 4 | 12516 | 2025-11-11 14:18:17 | 0 | NULL | 1 | 2025-11-11 14:26:36 | 1 | 0 | NULL | ||
| 147 | 157 | POF-1147 | INVF-1147 | 12536 | 12517 | 2 | 2 | 1 | 3998.4 | 0.0 | 79.97 | 95.2 | 95.2 | 0.0 | 3918.43 | INR | 0.0 | 1000.0 | 0.0 | 4 | 12536 | 2025-11-11 14:37:27 | 0 | NULL | 1 | 2025-11-11 16:09:56 | 12517 | 0 | NULL | ||
| 148 | 158 | POF-1148 | INVF-1148 | 12530 | 12517 | 2 | 1 | 90 | 11720.0 | 0.0 | 234.4 | 645.45 | 645.45 | 0.0 | 11485.6 | INR | 3908.0 | 3908.0 | 4028.0 | 4 | 12530 | 2025-11-11 15:04:15 | 0 | NULL | 1 | 2025-11-12 15:26:01 | 12517 | 0 | NULL | ||
| 149 | 159 | POF-1149 | INVF-1149 | 12529 | 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 | 12529 | 2025-11-11 15:10:17 | 0 | NULL | 1 | 2025-11-11 16:09:56 | 12517 | 0 | NULL | ||
| 150 | 160 | POF-1150 | INVF-1150 | 12517 | 12516 | 2 | 2 | 6 | 62994.0 | 0.0 | 3149.7 | 0.0 | 0.0 | 2999.71 | 59844.3 | INR | 0.0 | 21000.0 | 0.0 | 4 | 12517 | 2025-11-11 15:11:39 | 0 | NULL | 1 | 2025-11-11 16:08:18 | 12516 | 0 | NULL |