fx_franchise_order

1,267 rows · 31 columns · page 3 / 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
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