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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 51 | 61 | POF-1051 | INVF-1051 | 12546 | 12517 | 2 | 1 | 707 | 91834.0 | 0.0 | 1836.68 | 3127.25 | 3127.25 | 0.0 | 89997.32 | INR | 22362.0 | 22362.0 | 22662.0 | 4 | 12546 | 2025-11-07 18:56:18 | 0 | NULL | 1 | 2025-11-08 00:06:35 | 12517 | 0 | NULL | ||
| 52 | 62 | POF-1052 | INVF-1052 | 12537 | 12517 | 2 | 1 | 187 | 39278.4 | 0.0 | 785.57 | 843.33 | 843.33 | 0.0 | 38492.83 | INR | 12540.0 | 12540.0 | 14040.0 | 4 | 12537 | 2025-11-07 19:35:22 | 0 | NULL | 1 | 2025-11-08 00:06:35 | 12517 | 0 | NULL | ||
| 53 | 63 | POF-1053 | INVF-1053 | 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-07 19:49:03 | 0 | NULL | 1 | 2025-11-07 20:52:28 | 12517 | 0 | NULL | ||
| 54 | 64 | POF-1054 | INVF-1054 | 12529 | 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 | 12529 | 2025-11-07 19:50:02 | 0 | NULL | 1 | 2025-11-07 20:53:20 | 12517 | 0 | NULL | ||
| 55 | 65 | POF-1055 | INVF-1055 | 12526 | 12517 | 2 | 1 | 519 | 102808.8 | 0.0 | 2056.18 | 3738.62 | 3738.62 | 0.0 | 100752.62 | INR | 35134.0 | 35134.0 | 35734.0 | 4 | 12526 | 2025-11-07 19:52:39 | 0 | NULL | 1 | 2025-11-08 00:07:17 | 12517 | 0 | NULL | ||
| 56 | 66 | POF-1056 | INVF-1056 | 12536 | 12517 | 2 | 1 | 207 | 51154.4 | 0.0 | 1023.09 | 1592.62 | 1592.62 | 0.0 | 50131.31 | INR | 11800.0 | 11800.0 | 11905.0 | 4 | 12536 | 2025-11-07 20:05:13 | 0 | NULL | 1 | 2025-11-08 00:09:45 | 12517 | 0 | NULL | ||
| 57 | 67 | POF-1057 | INVF-1057 | 12528 | 12517 | 2 | 1 | 267 | 52476.0 | 0.0 | 1049.52 | 2005.95 | 2005.95 | 0.0 | 51426.48 | INR | 12458.0 | 12458.0 | 12908.0 | 4 | 12528 | 2025-11-07 20:12:29 | 0 | NULL | 1 | 2025-11-08 00:07:17 | 12517 | 0 | NULL | ||
| 58 | 68 | POF-1058 | INVF-1058 | 12522 | 12517 | 2 | 1 | 563 | 101669.4 | 0.0 | 2033.39 | 3805.41 | 3805.41 | 0.0 | 99636.01 | INR | 32522.0 | 32522.0 | 32672.0 | 4 | 12522 | 2025-11-07 20:12:32 | 0 | NULL | 1 | 2025-11-08 00:09:56 | 12517 | 0 | NULL | ||
| 59 | 69 | POF-1059 | INVF-1059 | 12529 | 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 | 12529 | 2025-11-07 20:17:38 | 0 | NULL | 1 | 2025-11-07 20:53:31 | 12517 | 0 | NULL | ||
| 60 | 70 | POF-1060 | INVF-1060 | 12517 | 12516 | 2 | 1 | 6 | 384.0 | 0.0 | 19.2 | 0.0 | 0.0 | 18.29 | 364.8 | INR | 114.0 | 114.0 | 123.0 | 4 | 12517 | 2025-11-07 20:21:33 | 0 | NULL | 2 | 2025-11-09 22:21:50 | 12516 | 0 | NULL | ||
| 61 | 71 | POF-1061 | INVF-1061 | 12517 | 12516 | 2 | 1 | 1 | 559.2 | 0.0 | 27.96 | 0.0 | 0.0 | 26.63 | 531.24 | INR | 150.0 | 150.0 | 240.0 | 4 | 12517 | 2025-11-07 20:24:05 | 0 | NULL | 2 | 2025-11-09 22:22:00 | 12516 | 0 | NULL | ||
| 62 | 72 | POF-1062 | INVF-1062 | 12517 | 12516 | 2 | 1 | 190 | 36818.4 | 0.0 | 1840.92 | 0.0 | 0.0 | 2855.68 | 34977.48 | INR | 13183.0 | 13183.0 | 13333.0 | 4 | 12517 | 2025-11-07 20:37:03 | 0 | NULL | 2 | 2025-11-09 22:22:00 | 12516 | 0 | NULL | ||
| 63 | 73 | POF-1063 | INVF-1063 | 12552 | 12517 | 2 | 1 | 69 | 27122.4 | 0.0 | 542.45 | 1363.7 | 1363.7 | 0.0 | 26579.95 | INR | 9628.0 | 9628.0 | 9778.0 | 4 | 12552 | 2025-11-07 20:37:03 | 0 | NULL | 1 | 2025-11-08 00:07:17 | 12517 | 0 | NULL | ||
| 64 | 74 | POF-1064 | INVF-1064 | 12525 | 12517 | 2 | 1 | 279 | 107182.4 | 0.0 | 2143.65 | 3314.82 | 3314.82 | 0.0 | 105038.75 | INR | 28929.0 | 28929.0 | 29289.0 | 4 | 12525 | 2025-11-07 20:41:37 | 0 | NULL | 1 | 2025-11-08 00:12:34 | 12517 | 0 | NULL | ||
| 65 | 75 | POF-1065 | INVF-1065 | 12517 | 12516 | 2 | 1 | 472 | 85907.8 | 0.0 | 4295.39 | 0.0 | 0.0 | 5535.96 | 81612.41 | INR | 20735.0 | 20735.0 | 21110.0 | 4 | 12517 | 2025-11-07 20:52:07 | 0 | NULL | 2 | 2025-11-09 22:22:00 | 12516 | 0 | NULL | ||
| 66 | 76 | POF-1066 | INVF-1066 | 12517 | 12516 | 2 | 1 | 46 | 7446.4 | 0.0 | 372.32 | 0.0 | 0.0 | 1007.47 | 7074.08 | INR | 2529.0 | 2529.0 | 2724.0 | 4 | 12517 | 2025-11-07 20:59:30 | 0 | NULL | 2 | 2025-11-09 22:22:00 | 12516 | 0 | NULL | ||
| 67 | 77 | POF-1067 | INVF-1067 | 12523 | 12517 | 2 | 1 | 585 | 72554.4 | 0.0 | 1451.09 | 2582.48 | 2582.48 | 0.0 | 71103.31 | INR | 22301.0 | 22301.0 | 22601.0 | 4 | 12523 | 2025-11-07 21:02:50 | 0 | NULL | 1 | 2025-11-08 00:07:17 | 12517 | 0 | NULL | ||
| 68 | 78 | POF-1068 | INVF-1068 | 12520 | 12517 | 2 | 1 | 222 | 63525.4 | 0.0 | 1270.51 | 2265.82 | 2265.82 | 0.0 | 62254.89 | INR | 20481.0 | 20481.0 | 21131.0 | 4 | 12520 | 2025-11-07 21:04:47 | 0 | NULL | 1 | 2025-11-08 00:12:34 | 12517 | 0 | NULL | ||
| 69 | 79 | POF-1069 | INVF-1069 | 12518 | 12517 | 2 | 1 | 170 | 44416.0 | 0.0 | 888.32 | 1562.69 | 1562.69 | 0.0 | 43527.68 | INR | 10808.0 | 10808.0 | 10958.0 | 4 | 12518 | 2025-11-07 21:51:44 | 0 | NULL | 1 | 2025-11-08 00:12:34 | 12517 | 0 | NULL | ||
| 70 | 80 | POF-1070 | INVF-1070 | 12552 | 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 | 12552 | 2025-11-07 22:06:15 | 0 | NULL | 1 | 2025-11-08 00:07:17 | 12517 | 0 | NULL | ||
| 71 | 81 | POF-1071 | INVF-1071 | 12516 | 1 | 2 | 1 | 8247 | 2249471.6 | 0.0 | 179957.73 | 72511.94 | 72511.94 | 0.0 | 2069513.87 | INR | 703220.0 | 703220.0 | 709820.0 | 4 | 12516 | 2025-11-07 22:39:17 | 0 | NULL | 1 | 2025-11-07 22:39:35 | 1 | 0 | NULL | ||
| 72 | 82 | POF-1072 | INVF-1072 | 12516 | 1 | 2 | 1 | 8247 | 2249471.6 | 0.0 | 179957.73 | 72511.94 | 72511.94 | 0.0 | 2069513.87 | INR | 703220.0 | 703220.0 | 709820.0 | 4 | 12516 | 2025-11-07 22:56:50 | 0 | NULL | 2 | 2025-11-11 21:20:01 | 1 | 0 | NULL | ||
| 73 | 83 | POF-1073 | INVF-1073 | 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-07 23:02:42 | 0 | NULL | 1 | 2025-11-08 00:07:17 | 12517 | 0 | NULL | ||
| 74 | 84 | POF-1074 | INVF-1074 | 12517 | 12516 | 2 | 1 | 8247 | 2249471.6 | 0.0 | 112473.58 | 0.0 | 0.0 | 145023.88 | 2136998.02 | INR | 703220.0 | 703220.0 | 709820.0 | 4 | 12517 | 2025-11-07 23:11:39 | 0 | NULL | 1 | 2025-11-07 23:12:01 | 12516 | 0 | NULL | ||
| 75 | 85 | POF-1075 | INVF-1075 | 12534 | 12517 | 2 | 1 | 135 | 38632.6 | 0.0 | 772.65 | 1286.06 | 1286.06 | 0.0 | 37859.95 | INR | 10103.0 | 10103.0 | 10273.0 | 4 | 12534 | 2025-11-07 23:24:21 | 0 | NULL | 1 | 2025-11-08 00:09:56 | 12517 | 0 | NULL | ||
| 76 | 86 | POF-1076 | INVF-1076 | 12529 | 12517 | 2 | 1 | 40 | 18631.2 | 0.0 | 372.62 | 443.6 | 443.6 | 0.0 | 18258.58 | INR | 5702.0 | 5702.0 | 6212.0 | 4 | 12529 | 2025-11-07 23:32:19 | 0 | NULL | 1 | 2025-11-08 00:07:17 | 12517 | 0 | NULL | ||
| 77 | 87 | POF-1077 | INVF-1077 | 12543 | 12517 | 2 | 1 | 59 | 6676.0 | 0.0 | 133.52 | 224.47 | 224.47 | 0.0 | 6542.48 | INR | 1815.0 | 1815.0 | 2391.0 | 4 | 12543 | 2025-11-07 23:34:58 | 0 | NULL | 1 | 2025-11-08 00:07:17 | 12517 | 0 | NULL | ||
| 78 | 88 | POF-1078 | INVF-1078 | 12544 | 12517 | 2 | 1 | 123 | 26633.6 | 0.0 | 532.67 | 1091.37 | 1091.37 | 0.0 | 26100.93 | INR | 7845.0 | 7845.0 | 7995.0 | 4 | 12544 | 2025-11-07 23:38:29 | 0 | NULL | 1 | 2025-11-08 00:07:17 | 12517 | 0 | NULL | ||
| 79 | 89 | POF-1079 | INVF-1079 | 12557 | 12517 | 2 | 1 | 149 | 18244.8 | 0.0 | 364.9 | 474.65 | 474.65 | 0.0 | 17879.9 | INR | 5555.0 | 5555.0 | 5895.0 | 4 | 12557 | 2025-11-07 23:42:17 | 0 | NULL | 1 | 2025-11-12 15:26:00 | 12517 | 0 | NULL | ||
| 80 | 90 | POF-1080 | INVF-1080 | 12685 | 12517 | 2 | 1 | 190 | 36818.4 | 0.0 | 736.37 | 1427.84 | 1427.84 | 0.0 | 36082.03 | INR | 13183.0 | 13183.0 | 13333.0 | 4 | 12685 | 2025-11-07 23:47:34 | 0 | NULL | 1 | 2025-11-12 15:26:00 | 12517 | 0 | NULL | ||
| 81 | 91 | POF-1081 | INVF-1081 | 12548 | 12517 | 2 | 1 | 186 | 36338.4 | 0.0 | 726.77 | 1391.23 | 1391.23 | 0.0 | 35611.63 | INR | 13063.0 | 13063.0 | 13213.0 | 4 | 12548 | 2025-11-07 23:54:32 | 0 | NULL | 1 | 2025-11-08 00:09:56 | 12517 | 0 | NULL | ||
| 82 | 92 | POF-1082 | INVF-1082 | 12517 | 12516 | 2 | 1 | 40 | 21184.0 | 0.0 | 1059.2 | 0.0 | 0.0 | 3231.46 | 20124.8 | INR | 6420.0 | 6420.0 | 7720.0 | 4 | 12517 | 2025-11-08 00:04:03 | 0 | NULL | 1 | 2025-11-08 00:05:39 | 12516 | 0 | NULL | ||
| 83 | 93 | POF-1083 | INVF-1083 | 12516 | 1 | 2 | 1 | 50 | 26480.0 | 0.0 | 2118.4 | 2019.66 | 2019.66 | 0.0 | 24361.6 | INR | 8025.0 | 8025.0 | 9650.0 | 4 | 12516 | 2025-11-08 00:05:04 | 0 | NULL | 1 | 2025-11-08 00:05:14 | 1 | 0 | NULL | ||
| 84 | 94 | POF-1084 | INVF-1084 | 12517 | 12516 | 2 | 1 | 50 | 15200.0 | 0.0 | 760.0 | 0.0 | 0.0 | 2318.64 | 14440.0 | INR | 12500.0 | 12500.0 | 18500.0 | 4 | 12517 | 2025-11-08 00:08:24 | 0 | NULL | 1 | 2025-11-08 00:09:19 | 12516 | 0 | NULL | ||
| 85 | 95 | POF-1085 | INVF-1085 | 12516 | 1 | 2 | 1 | 50 | 15200.0 | 0.0 | 1216.0 | 1159.32 | 1159.32 | 0.0 | 13984.0 | INR | 12500.0 | 12500.0 | 18500.0 | 4 | 12516 | 2025-11-08 00:08:40 | 0 | NULL | 1 | 2025-11-08 00:09:12 | 1 | 0 | NULL | ||
| 86 | 96 | POF-1086 | INVF-1086 | 12517 | 12516 | 2 | 1 | 50 | 13000.0 | 0.0 | 650.0 | 0.0 | 0.0 | 1983.05 | 12350.0 | INR | 3550.0 | 3550.0 | 6800.0 | 4 | 12517 | 2025-11-08 00:11:02 | 0 | NULL | 1 | 2025-11-08 00:12:07 | 12516 | 0 | NULL | ||
| 87 | 97 | POF-1087 | INVF-1087 | 12516 | 1 | 2 | 1 | 50 | 13000.0 | 0.0 | 1040.0 | 991.52 | 991.52 | 0.0 | 11960.0 | INR | 3550.0 | 3550.0 | 6800.0 | 4 | 12516 | 2025-11-08 00:11:41 | 0 | NULL | 1 | 2025-11-08 00:12:01 | 1 | 0 | NULL | ||
| 88 | 98 | POF-1088 | INVF-1088 | 12530 | 12517 | 2 | 1 | 46 | 7446.4 | 0.0 | 148.93 | 503.74 | 503.74 | 0.0 | 7297.47 | INR | 2529.0 | 2529.0 | 2724.0 | 4 | 12530 | 2025-11-08 00:24:38 | 0 | NULL | 1 | 2025-11-08 00:24:54 | 12517 | 0 | NULL | ||
| 89 | 99 | POF-1089 | INVF-1089 | 12521 | 12517 | 2 | 1 | 96 | 26896.8 | 0.0 | 537.94 | 1327.64 | 1327.64 | 0.0 | 26358.86 | INR | 8255.0 | 8255.0 | 9255.0 | 4 | 12521 | 2025-11-08 00:35:07 | 0 | NULL | 1 | 2025-11-08 00:35:32 | 12517 | 0 | NULL | ||
| 90 | 100 | POF-1090 | INVF-1090 | 12527 | 12517 | 2 | 1 | 426 | 29379.2 | 0.0 | 587.58 | 1000.17 | 1000.17 | 0.0 | 28791.62 | INR | 8292.0 | 8292.0 | 9000.0 | 4 | 12527 | 2025-11-08 02:09:55 | 0 | NULL | 1 | 2025-11-08 02:13:10 | 12517 | 0 | NULL | ||
| 91 | 101 | POF-1091 | INVF-1091 | 12527 | 12517 | 2 | 1 | 214 | 72516.8 | 0.0 | 1450.34 | 2798.45 | 2798.45 | 0.0 | 71066.46 | INR | 25361.0 | 25361.0 | 25796.0 | 4 | 12527 | 2025-11-08 02:21:46 | 0 | NULL | 1 | 2025-11-08 02:22:54 | 12517 | 0 | NULL | ||
| 92 | 102 | POF-1092 | INVF-1092 | 12516 | 1 | 2 | 1 | 2795 | 749494.2 | 0.0 | 59959.54 | 33188.29 | 33188.29 | 0.0 | 689534.66 | INR | 236442.0 | 236442.0 | 237792.0 | 4 | 12516 | 2025-11-08 13:26:29 | 0 | NULL | 1 | 2025-11-08 13:27:54 | 1 | 0 | NULL | ||
| 93 | 103 | POF-1093 | INVF-1093 | 12526 | 12517 | 2 | 2 | 3 | 11995.2 | 0.0 | 239.9 | 285.6 | 285.6 | 0.0 | 11755.3 | INR | 0.0 | 3000.0 | 0.0 | 4 | 12526 | 2025-11-08 16:25:14 | 0 | NULL | 1 | 2025-11-08 16:55:55 | 12517 | 0 | NULL | ||
| 94 | 104 | POF-1094 | INVF-1094 | 12548 | 12517 | 2 | 1 | 60 | 16400.0 | 0.0 | 328.0 | 390.48 | 390.48 | 0.0 | 16072.0 | INR | 5900.0 | 5900.0 | 6650.0 | 4 | 12548 | 2025-11-08 16:46:05 | 0 | NULL | 1 | 2025-11-08 16:48:23 | 12517 | 0 | NULL | ||
| 95 | 105 | POF-1095 | INVF-1095 | 12532 | 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 | 12532 | 2025-11-09 09:46:23 | 0 | NULL | 1 | 2025-11-09 19:01:05 | 12517 | 0 | NULL | ||
| 96 | 106 | POF-1096 | INVF-1096 | 12517 | 12516 | 2 | 1 | 1955 | 393665.8 | 0.0 | 19683.29 | 0.0 | 0.0 | 23614.21 | 373982.51 | INR | 113706.0 | 113706.0 | 115056.0 | 4 | 12517 | 2025-11-09 12:02:35 | 0 | NULL | 1 | 2025-11-09 12:18:03 | 12516 | 0 | NULL | ||
| 97 | 107 | POF-1097 | INVF-1097 | 12517 | 12516 | 2 | 1 | 823 | 348599.6 | 0.0 | 17429.98 | 0.0 | 0.0 | 42141.34 | 331169.62 | INR | 120085.0 | 120085.0 | 123085.0 | 4 | 12517 | 2025-11-09 12:31:27 | 0 | NULL | 1 | 2025-11-09 22:40:57 | 12516 | 0 | NULL | ||
| 98 | 108 | POF-1098 | INVF-1098 | 12516 | 1 | 2 | 1 | 12 | 10398.0 | 0.0 | 831.84 | 247.57 | 247.57 | 0.0 | 9566.16 | INR | 2750.0 | 2750.0 | 3000.0 | 4 | 12516 | 2025-11-09 13:31:28 | 0 | NULL | 1 | 2025-11-09 22:39:20 | 1 | 0 | NULL | ||
| 99 | 109 | POF-1099 | INVF-1099 | 12516 | 1 | 2 | 1 | 50 | 4000.0 | 0.0 | 320.0 | 95.24 | 95.24 | 0.0 | 3680.0 | INR | 1400.0 | 1400.0 | 1900.0 | 4 | 12516 | 2025-11-09 13:35:25 | 0 | NULL | 1 | 2025-11-09 22:37:31 | 1 | 0 | NULL | ||
| 100 | 110 | POF-1100 | INVF-1100 | 12516 | 1 | 2 | 1 | 50 | 4000.0 | 0.0 | 320.0 | 95.24 | 95.24 | 0.0 | 3680.0 | INR | 1400.0 | 1400.0 | 1900.0 | 4 | 12516 | 2025-11-09 13:37:52 | 0 | NULL | 1 | 2025-11-09 22:37:31 | 1 | 0 | NULL |