fx_franchise_order

1,267 rows · 31 columns · page 24 / 26

Invoice view 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
1151 1162 POFN-2151 INVFN-2151 12555 12554 2 1 9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 INR 0.0 4.5 0.0 4 12555 2026-05-07 23:26:07 0 NULL 1 2026-05-07 23:26:43 12554 1 2026-05-07 23:26:43
1152 1163 POFN-2152 INVFN-2152 12555 12554 2 1 9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 INR 0.0 4.5 0.0 4 12555 2026-05-07 23:26:08 0 NULL 2 2026-05-07 23:27:00 12554 0 NULL
1153 1164 POFN-2153 INVFN-2153 12555 12554 2 1 9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 INR 0.0 4.5 0.0 4 12555 2026-05-07 23:26:09 0 NULL 2 2026-05-07 23:27:00 12554 0 NULL
1154 1165 POFN-2154 INVFN-2154 12526 12517 2 1 17 5594.0 0.0 103.98 197.41 197.41 0.0 5594.0 INR 2640.0 2640.15 2640.0 4 12526 2026-05-08 10:18:19 0 NULL 1 2026-05-08 11:18:57 12517 1 2026-05-08 11:18:57
1155 1166 POFN-2155 INVFN-2155 12526 12517 2 1 2 2400.0 0.0 45.71 57.14 57.14 0.0 2400.0 INR 1200.0 1200.25 1200.0 4 12526 2026-05-08 10:29:39 0 NULL 1 2026-05-08 11:18:57 12517 1 2026-05-08 11:18:57
1156 1167 POFN-2156 INVFN-2156 12526 12517 2 1 6 1926.0 0.0 32.64 146.9 146.9 0.0 1926.0 INR 672.0 672.13 672.0 4 12526 2026-05-08 10:31:16 0 NULL 1 2026-05-08 11:18:57 12517 1 2026-05-08 11:18:57
1157 1168 POFN-2157 INVFN-2157 12545 12517 2 1 2 24500.0 0.0 454.08 898.1 898.1 0.0 24500.0 INR 12550.0 12553.75 12550.0 4 12545 2026-05-09 13:00:52 0 NULL 1 2026-05-09 15:27:19 12517 1 2026-05-09 15:27:19
1158 1169 POFN-2158 INVFN-2158 12545 12517 2 1 3 477.0 0.0 8.08 36.38 36.38 0.0 477.0 INR 165.0 165.03 165.0 4 12545 2026-05-09 13:08:28 0 NULL 1 2026-05-09 15:27:19 12517 1 2026-05-09 15:27:19
1159 1170 POFN-2159 INVFN-2159 12554 12516 2 1 27 32400.0 0.0 1851.43 771.43 771.43 0.0 32400.0 INR 16200.0 16206.75 16200.0 4 12554 2026-05-09 18:05:15 0 NULL 1 2026-05-09 18:05:38 12516 1 2026-05-09 18:05:38
1160 1171 POFN-2160 INVFN-2160 12555 12554 2 1 27 32400.0 0.0 617.14 771.43 771.43 0.0 32400.0 INR 16200.0 16206.75 16200.0 4 12555 2026-05-09 18:07:18 0 NULL 1 2026-05-09 18:07:40 12554 1 2026-05-09 18:07:40
1161 1172 POFN-2161 INVFN-2161 12555 12554 2 1 5 12500.0 0.0 242.72 182.04 182.04 0.0 12500.0 INR 6250.0 6252.5 6250.0 4 12555 2026-05-09 22:53:38 0 NULL 1 2026-05-09 22:54:12 12554 1 2026-05-09 22:54:12
1162 1173 POFN-2162 INVFN-2162 12555 12554 2 1 5 6000.0 0.0 114.29 142.86 142.86 0.0 6000.0 INR 3000.0 3001.5 3000.0 4 12555 2026-05-10 13:31:22 0 NULL 1 2026-05-10 13:32:11 12554 1 2026-05-10 13:32:11
1163 1174 POFN-2163 INVFN-2163 12555 12554 2 1 9 14850.0 0.0 282.86 353.57 353.57 0.0 14850.0 INR 7425.0 7427.7 7425.0 4 12555 2026-05-10 13:41:11 0 NULL 1 2026-05-10 13:42:43 12554 1 2026-05-10 13:42:43
1164 1175 POFN-2164 INVFN-2164 14902 12517 2 1 51 12447.0 0.0 234.49 361.36 361.36 0.0 12447.0 INR 5843.0 5843.72 5843.0 4 14902 2026-05-10 21:09:55 0 NULL 1 2026-05-10 21:36:07 12517 1 2026-05-10 21:36:07
1165 1176 POFN-2165 INVFN-2165 12545 12517 2 1 18 15419.0 0.0 281.1 681.89 681.89 0.0 15419.0 INR 7999.0 7999.75 7999.0 4 12545 2026-05-10 22:24:18 0 NULL 1 2026-05-11 11:05:59 12517 1 2026-05-11 11:05:59
1166 1177 POFN-2166 INVFN-2166 12545 12517 2 1 21 5682.0 0.0 106.84 169.96 169.96 0.0 5682.0 INR 2763.0 2763.05 2763.0 4 12545 2026-05-11 19:34:07 0 NULL 1 2026-05-11 20:16:29 12517 1 2026-05-11 20:16:29
1167 1178 POFN-2167 INVFN-2167 12539 12517 2 1 26 5821.0 0.0 107.54 222.01 222.01 0.0 5821.0 INR 2665.0 2665.25 2665.0 4 12539 2026-05-11 20:09:59 0 NULL 1 2026-05-11 20:16:29 12517 1 2026-05-11 20:16:29
1168 1179 POFN-2168 INVFN-2168 12532 12517 2 1 275 52440.0 0.0 980.68 1702.99 1702.99 0.0 52440.0 INR 24398.0 24398.3 24398.0 4 12532 2026-05-11 20:16:31 0 NULL 1 2026-05-11 21:32:23 12517 1 2026-05-11 21:32:23
1169 1180 POFN-2169 INVFN-2169 12532 12517 2 1 3 32100.0 0.0 611.43 764.29 764.29 0.0 32100.0 INR 16050.0 16056.0 16050.0 4 12532 2026-05-11 20:20:36 0 NULL 1 2026-05-11 20:40:05 12517 1 2026-05-11 20:40:05
1170 1181 POFN-2170 INVFN-2170 12517 12516 2 1 14 2856.0 0.0 163.2 0.0 0.0 136.0 2856.0 INR 1428.0 1428.56 1428.0 4 12517 2026-05-11 21:30:30 0 NULL 1 2026-05-11 21:31:43 12516 1 2026-05-11 21:31:43
1171 1182 POFN-2171 INVFN-2171 12526 12517 2 1 6 7850.0 0.0 149.52 186.9 186.9 0.0 7850.0 INR 3925.0 3925.3 3925.0 4 12526 2026-05-12 11:11:56 0 NULL 1 2026-05-12 11:53:58 12517 1 2026-05-12 11:53:58
1172 1183 POFN-2172 INVFN-2172 12526 12517 2 1 54 7660.0 0.0 145.9 182.38 182.38 0.0 7660.0 INR 3580.0 3580.3 3580.0 4 12526 2026-05-12 11:16:00 0 NULL 1 2026-05-12 11:53:58 12517 1 2026-05-12 11:53:58
1173 1184 POFN-2173 INVFN-2173 12532 12517 2 1 1 10700.0 0.0 203.81 254.76 254.76 0.0 10700.0 INR 5350.0 5352.0 5350.0 4 12532 2026-05-12 19:28:53 0 NULL 1 2026-05-12 21:02:15 12517 1 2026-05-12 21:02:15
1174 1185 POFN-2174 INVFN-2174 12545 12517 2 1 1 18500.0 0.0 352.38 440.48 440.48 0.0 18500.0 INR 9250.0 9253.75 9250.0 4 12545 2026-05-13 17:01:51 0 NULL 1 2026-05-13 19:38:58 12517 1 2026-05-13 19:38:58
1175 1186 POFN-2175 INVFN-2175 12523 12517 2 1 11 8070.0 0.0 150.57 270.84 270.84 0.0 8070.0 INR 4010.0 4010.2 4010.0 4 12523 2026-05-13 22:20:49 0 NULL 1 2026-05-14 11:19:29 12517 1 2026-05-14 11:19:29
1176 1187 POFN-2176 INVFN-2176 12523 12517 2 1 6 2156.0 0.0 41.07 51.33 51.33 0.0 2156.0 INR 1036.0 1036.3 1036.0 4 12523 2026-05-14 13:20:15 0 NULL 1 2026-05-14 13:37:54 12517 1 2026-05-14 13:37:54
1177 1188 POFN-2177 INVFN-2177 12545 12517 2 1 7 4743.0 0.0 90.01 121.27 121.27 0.0 4743.0 INR 2347.0 2347.03 2347.0 4 12545 2026-05-14 15:35:50 0 NULL 1 2026-05-14 16:27:04 12517 1 2026-05-14 16:27:04
1178 1189 POFN-2178 INVFN-2178 12526 12517 2 1 2 998.0 0.0 19.01 23.76 23.76 0.0 998.0 INR 498.0 498.2 498.0 4 12526 2026-05-15 00:16:17 0 NULL 1 2026-05-15 19:19:52 12517 1 2026-05-15 19:19:52
1179 1190 POFN-2179 INVFN-2179 12545 12517 2 1 9 1809.0 0.0 31.09 127.27 127.27 0.0 1809.0 INR 747.0 747.03 747.0 4 12545 2026-05-15 11:38:09 0 NULL 1 2026-05-15 19:19:52 12517 1 2026-05-15 19:19:52
1180 1191 POFN-2180 INVFN-2180 12545 12517 2 1 18 5240.0 0.0 97.92 171.87 171.87 0.0 5240.0 INR 2494.0 2494.07 2494.0 4 12545 2026-05-17 19:37:35 0 NULL 1 2026-05-17 19:46:17 12517 1 2026-05-17 19:46:17
1181 1192 POFN-2181 INVFN-2181 12545 12517 2 1 2 1440.0 0.0 27.43 34.29 34.29 0.0 1440.0 INR 720.0 720.3 720.0 4 12545 2026-05-18 17:08:32 0 NULL 1 2026-05-18 18:26:05 12517 1 2026-05-18 18:26:05
1182 1193 POFN-2182 INVFN-2182 12545 12517 2 1 2 1470.0 0.0 26.43 74.35 74.35 0.0 1470.0 INR 735.0 735.1 735.0 4 12545 2026-05-20 10:16:46 0 NULL 1 2026-05-20 15:36:37 12517 1 2026-05-20 15:36:37
1183 1194 POFN-2183 INVFN-2183 12545 12517 2 1 5 1536.0 0.0 29.26 36.57 36.57 0.0 1536.0 INR 768.0 768.16 768.0 4 12545 2026-05-20 14:49:37 0 NULL 1 2026-05-20 15:36:37 12517 1 2026-05-20 15:36:37
1184 1195 POFN-2184 INVFN-2184 12532 12517 2 1 32 14749.0 0.0 279.36 390.51 390.51 0.0 14749.0 INR 7264.0 7264.1 7264.0 4 12532 2026-05-20 15:47:17 0 NULL 1 2026-05-20 19:00:59 12517 1 2026-05-20 19:00:59
1185 1196 POFN-2185 INVFN-2185 12545 12517 2 1 1 720.0 0.0 13.71 17.14 17.14 0.0 720.0 INR 360.0 360.15 360.0 4 12545 2026-05-20 15:58:41 0 NULL 1 2026-05-20 19:00:53 12517 1 2026-05-20 19:00:53
1186 1197 POFN-2186 INVFN-2186 12526 12517 2 1 33 17118.0 0.0 319.6 568.9 568.9 0.0 17118.0 INR 8289.0 8289.25 8289.0 4 12526 2026-05-20 21:02:32 0 NULL 1 2026-05-20 21:09:32 12517 1 2026-05-20 21:09:32
1187 1198 POFN-2187 INVFN-2187 12545 12517 2 1 3 1159.0 0.0 22.08 27.6 27.6 0.0 1159.0 INR 579.0 579.11 579.0 4 12545 2026-05-21 05:48:12 0 NULL 1 2026-05-21 11:41:30 12517 1 2026-05-21 11:41:30
1188 1199 POFN-2188 INVFN-2188 12539 12517 2 1 2 1680.0 0.0 32.0 40.0 40.0 0.0 1680.0 INR 835.0 835.01 835.0 4 12539 2026-05-21 14:28:32 0 NULL 1 2026-05-21 16:55:34 12517 1 2026-05-21 16:55:34
1189 1200 POFN-2189 INVFN-2189 14079 12517 2 1 13 1260.0 0.0 24.0 30.0 30.0 0.0 1260.0 INR 570.0 570.05 570.0 4 14079 2026-05-21 19:41:17 0 NULL 1 2026-05-21 21:46:26 12517 1 2026-05-21 21:46:26
1190 1201 POFN-2190 INVFN-2190 12545 12517 2 1 19 3402.0 0.0 64.47 89.34 89.34 0.0 3402.0 INR 1626.0 1626.24 1626.0 4 12545 2026-05-21 20:36:55 0 NULL 1 2026-05-21 21:46:18 12517 1 2026-05-21 21:46:18
1191 1202 POFN-2191 INVFN-2191 12517 12516 2 1 20 6400.0 0.0 325.42 0.0 0.0 976.27 6400.0 INR 3200.0 3201.0 3200.0 4 12517 2026-05-21 21:00:05 0 NULL 1 2026-05-21 21:00:43 12516 1 2026-05-21 21:00:43
1192 1203 POFN-2192 INVFN-2192 12545 12517 2 1 3 1390.0 0.0 23.56 106.02 106.02 0.0 1390.0 INR 695.0 695.1 695.0 4 12545 2026-05-21 21:28:30 0 NULL 1 2026-05-21 21:46:11 12517 1 2026-05-21 21:46:11
1193 1204 POFN-2193 INVFN-2193 12555 12554 2 1 4 10000.0 0.0 194.17 145.63 145.63 0.0 10000.0 INR 5000.0 5002.0 5000.0 4 12555 2026-05-22 14:06:55 0 NULL 1 2026-05-22 14:07:39 12554 1 2026-05-22 14:07:39
1194 1205 POFN-2194 INVFN-2194 12554 12516 2 1 10 25000.0 0.0 1456.31 364.08 364.08 0.0 25000.0 INR 12500.0 12505.0 12500.0 4 12554 2026-05-22 17:41:45 0 NULL 1 2026-05-22 17:42:04 12516 1 2026-05-22 17:42:04
1195 1206 POFN-2195 INVFN-2195 12555 12554 2 1 10 25000.0 0.0 485.44 364.08 364.08 0.0 25000.0 INR 12500.0 12505.0 12500.0 4 12555 2026-05-22 17:43:22 0 NULL 1 2026-05-22 17:44:17 12554 1 2026-05-22 17:44:17
1196 1207 POFN-2196 INVFN-2196 12539 12517 2 1 2 2350.0 0.0 43.19 95.3 95.3 0.0 2350.0 INR 1175.0 1175.1 1175.0 4 12539 2026-05-23 16:18:38 0 NULL 1 2026-05-23 16:22:25 12517 1 2026-05-23 16:22:26
1197 1208 POFN-2197 INVFN-2197 12545 12517 2 1 1 719.0 0.0 13.7 17.12 17.12 0.0 719.0 INR 359.0 359.15 359.0 4 12545 2026-05-23 16:38:13 0 NULL 1 2026-05-23 19:14:37 12517 1 2026-05-23 19:14:37
1198 1209 POFN-2198 INVFN-2198 14902 12517 2 1 16 9893.0 0.0 181.33 413.34 413.34 0.0 9893.0 INR 4764.0 4764.02 4764.0 4 14902 2026-05-24 13:03:29 0 NULL 2 2026-05-24 16:31:26 12517 0 NULL
1199 1210 POFN-2199 INVFN-2199 14902 12517 2 1 16 9893.0 0.0 181.33 413.34 413.34 0.0 9893.0 INR 4764.0 4764.02 4764.0 4 14902 2026-05-24 23:19:14 0 NULL 1 2026-05-24 23:26:33 12517 1 2026-05-24 23:26:33
1200 1211 POFN-2200 INVFN-2200 12539 12517 2 1 3 2641.0 0.0 49.63 79.72 79.72 0.0 2641.0 INR 1272.0 1272.02 1272.0 4 12539 2026-05-28 04:00:28 0 NULL 1 2026-05-28 19:25:13 12517 1 2026-05-28 19:25:13