fx_franchise_order

1,267 rows · 31 columns · page 1 / 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
1 11 POF-1011 INVF-1011 12555 12554 2 0 10 14990.0 0.0 0.0 1143.31 1143.31 0.0 14990.0 INR 0.0 0.0 0.0 4 12555 2025-11-03 11:04:39 0 NULL 2 2025-11-11 16:09:01 12516 0 NULL
2 12 POF-1012 INVF-1012 12555 12554 2 0 5 7495.0 0.0 0.0 571.65 571.65 0.0 7495.0 INR 0.0 0.0 0.0 2 12555 2025-11-03 11:43:40 0 NULL 1 2025-11-03 12:23:04 12554 0 NULL
3 13 POF-1013 INVF-1013 12554 12516 2 0 5 7495.0 0.0 0.0 571.65 571.65 0.0 7495.0 INR 0.0 0.0 0.0 2 12554 2025-11-03 11:46:18 0 NULL 1 2025-11-03 12:22:11 12516 0 NULL
4 14 POF-1014 INVF-1014 12516 1 2 0 10 14990.0 0.0 0.0 1143.31 1143.31 0.0 14990.0 INR 0.0 0.0 0.0 2 12516 2025-11-03 11:48:13 0 NULL 1 2025-11-03 12:21:55 1 0 NULL
5 15 POF-1005 INVF-1005 12516 1 2 2 1 3998.4 0.0 0.0 95.2 95.2 0.0 3998.4 INR 1000.0 0.0 0.0 4 12516 2025-11-06 13:33:53 0 NULL 1 2025-11-06 13:38:02 1 0 NULL
6 16 POF-1006 INVF-1006 12517 12516 2 2 1 3998.4 0.0 0.0 0.0 0.0 190.4 3998.4 INR 1000.0 0.0 0.0 2 12517 2025-11-06 13:38:39 0 NULL 1 2025-11-06 13:38:54 12516 0 NULL
7 17 POF-1007 INVF-1007 12518 12517 2 2 1 3998.4 0.0 0.0 95.2 95.2 0.0 3998.4 INR 1000.0 0.0 0.0 2 12518 2025-11-06 13:39:17 0 NULL 1 2025-11-06 13:39:34 12517 0 NULL
8 18 POF-1008 INVF-1008 12516 1 2 2 1 3998.4 0.0 0.0 95.2 95.2 0.0 3998.4 INR 1000.0 0.0 0.0 2 12516 2025-11-06 13:47:40 0 NULL 1 2025-11-06 13:48:20 1 0 NULL
9 19 POF-1009 INVF-1009 12517 12516 2 2 1 3998.4 0.0 0.0 0.0 0.0 190.4 3998.4 INR 1000.0 0.0 0.0 2 12517 2025-11-06 13:48:47 0 NULL 1 2025-11-06 13:48:56 12516 0 NULL
10 20 POF-1010 INVF-1010 12518 12517 2 2 1 3998.4 0.0 0.0 95.2 95.2 0.0 3998.4 INR 1000.0 0.0 0.0 2 12518 2025-11-06 13:49:11 0 NULL 1 2025-11-06 13:49:27 12517 0 NULL
11 21 POF-1011 INVF-1011 12516 1 2 2 1 3998.4 0.0 0.0 95.2 95.2 0.0 3998.4 INR 1000.0 0.0 0.0 2 12516 2025-11-06 16:26:30 0 NULL 1 2025-11-06 16:27:59 1 0 NULL
12 22 POF-1012 INVF-1012 12517 12516 2 2 1 3998.4 0.0 0.0 0.0 0.0 190.4 3998.4 INR 1000.0 0.0 0.0 2 12517 2025-11-06 16:29:11 0 NULL 1 2025-11-06 16:29:24 12516 0 NULL
13 23 POF-1013 INVF-1013 12516 1 2 1 1 1499.0 0.0 119.92 114.33 114.33 0.0 1379.08 INR 0.0 450.0 200.0 4 12516 2025-11-06 19:26:47 0 NULL 1 2025-11-09 22:37:31 1 0 NULL
14 24 POF-1014 INVF-1014 12516 1 2 1 1 1499.0 0.0 119.92 114.33 114.33 0.0 1379.08 INR 450.0 450.0 650.0 4 12516 2025-11-06 19:31:57 0 NULL 1 2025-11-09 22:37:31 1 0 NULL
15 25 POF-1015 INVF-1015 12555 12554 2 2 1 13699.0 0.0 273.98 1044.84 1044.84 0.0 13425.02 INR 0.0 3000.0 0.0 4 12555 2025-11-06 20:00:24 0 NULL 1 2025-11-06 20:52:48 12554 0 NULL
16 26 POF-1016 INVF-1016 12555 12554 2 1 1 1499.0 0.0 29.98 114.33 114.33 0.0 1469.02 INR 450.0 450.0 650.0 4 12555 2025-11-06 20:02:54 0 NULL 2 2025-11-12 08:23:36 12554 0 NULL
17 27 POF-1017 INVF-1017 12555 12554 2 1 1 1124.25 0.0 22.48 85.75 85.75 0.0 1101.77 INR 450.0 450.0 650.0 4 12555 2025-11-06 20:21:47 0 NULL 2 2025-11-12 08:23:36 12554 0 NULL
18 28 POF-1018 INVF-1018 12555 12554 2 2 1 13699.0 0.0 273.98 1044.84 1044.84 0.0 13425.02 INR 0.0 3000.0 0.0 4 12555 2025-11-06 20:46:06 0 NULL 2 2025-11-12 08:23:36 12554 0 NULL
19 29 POF-1019 INVF-1019 12554 12516 2 2 1 13699.0 0.0 684.95 1044.84 1044.84 0.0 13014.05 INR 0.0 3000.0 0.0 4 12554 2025-11-06 20:48:40 0 NULL 1 2025-11-06 20:50:47 12516 0 NULL
20 30 POF-1020 INVF-1020 12516 1 2 2 1 13699.0 0.0 1095.92 1044.84 1044.84 0.0 12603.08 INR 0.0 3000.0 0.0 4 12516 2025-11-06 20:49:16 0 NULL 1 2025-11-06 20:50:34 1 0 NULL
21 31 POF-1021 INVF-1021 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-06 21:38:46 0 NULL 1 2025-11-06 21:43:28 12517 0 NULL
22 32 POF-1022 INVF-1022 12526 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 12526 2025-11-06 21:39:40 0 NULL 1 2025-11-06 22:27:56 12517 0 NULL
23 33 POF-1023 INVF-1023 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-06 21:41:46 0 NULL 1 2025-11-06 21:43:01 12516 0 NULL
24 34 POF-1024 INVF-1024 12516 1 2 2 3 31497.0 0.0 2519.76 749.93 749.93 0.0 28977.24 INR 0.0 10500.0 0.0 4 12516 2025-11-06 21:42:26 0 NULL 1 2025-11-06 21:42:50 1 0 NULL
25 35 POF-1025 INVF-1025 12516 1 2 2 495 5672343.6 0.0 453787.49 206204.36 206204.36 0.0 5218556.11 INR 0.0 346500.0 0.0 4 12516 2025-11-06 22:17:20 0 NULL 1 2025-11-06 22:36:33 1 0 NULL
26 36 POF-1026 INVF-1026 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-06 22:18:36 0 NULL 1 2025-11-06 22:27:56 12517 0 NULL
27 37 POF-1027 INVF-1027 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-06 22:24:05 0 NULL 1 2025-11-06 22:39:02 12517 0 NULL
28 38 POF-1028 INVF-1028 12516 1 2 2 50 483951.0 0.0 38716.08 15116.0 15116.0 0.0 445234.92 INR 0.0 17500.0 0.0 4 12516 2025-11-06 22:30:58 0 NULL 1 2025-11-06 22:34:03 1 0 NULL
29 39 POF-1029 INVF-1029 12516 1 2 2 25 99960.0 0.0 7996.8 2380.0 2380.0 0.0 91963.2 INR 0.0 25000.0 0.0 4 12516 2025-11-06 22:32:03 0 NULL 1 2025-11-06 22:34:03 1 0 NULL
30 40 POF-1030 INVF-1030 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-06 22:32:50 0 NULL 1 2025-11-06 22:39:02 12517 0 NULL
31 41 POF-1031 INVF-1031 12517 12516 2 2 25 99960.0 0.0 4998.0 0.0 0.0 4760.0 94962.0 INR 0.0 25000.0 0.0 4 12517 2025-11-06 22:33:12 0 NULL 1 2025-11-06 22:36:42 12516 0 NULL
32 42 POF-1032 INVF-1032 12517 12516 2 2 5 92500.0 0.0 4625.0 0.0 0.0 4404.76 87875.0 INR 0.0 37500.0 0.0 4 12517 2025-11-06 22:37:20 0 NULL 1 2025-11-06 22:38:43 12516 0 NULL
33 43 POF-1033 INVF-1033 12517 12516 2 2 25 262475.0 0.0 13123.75 0.0 0.0 12498.81 249351.25 INR 0.0 87500.0 0.0 4 12517 2025-11-06 22:37:36 0 NULL 1 2025-11-06 22:38:43 12516 0 NULL
34 44 POF-1034 INVF-1034 12517 12516 2 2 3 41097.0 0.0 2054.85 0.0 0.0 6269.03 39042.15 INR 0.0 9000.0 0.0 4 12517 2025-11-06 22:38:08 0 NULL 1 2025-11-06 22:38:43 12516 0 NULL
35 45 POF-1035 INVF-1035 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-06 23:02:00 0 NULL 1 2025-11-07 00:02:48 12517 0 NULL
36 46 POF-1036 INVF-1036 12546 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 12546 2025-11-07 09:30:36 0 NULL 1 2025-11-07 11:25:39 12517 0 NULL
37 47 POF-1037 INVF-1037 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 11:03:22 0 NULL 1 2025-11-07 11:25:39 12517 0 NULL
38 48 POF-1038 INVF-1038 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-07 11:19:52 0 NULL 1 2025-11-07 18:39:01 12516 0 NULL
39 49 POF-1039 INVF-1039 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-07 11:23:10 0 NULL 1 2025-11-07 11:25:39 12517 0 NULL
40 50 POF-1040 INVF-1040 12557 12517 2 1 1 48.0 0.0 0.96 1.15 1.15 0.0 47.04 INR 10.0 10.0 13.0 4 12557 2025-11-07 11:38:24 0 NULL 1 2025-11-07 23:56:54 12517 0 NULL
41 51 POF-1041 INVF-1041 12534 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 12534 2025-11-07 11:48:52 0 NULL 1 2025-11-07 18:21:22 12517 0 NULL
42 52 POF-1042 INVF-1042 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 11:56:23 0 NULL 1 2025-11-07 18:21:22 12517 0 NULL
43 53 POF-1043 INVF-1043 12552 12517 2 2 4 45196.0 0.0 903.92 1794.77 1794.77 0.0 44292.08 INR 0.0 10500.0 0.0 4 12552 2025-11-07 16:42:50 0 NULL 1 2025-11-07 18:21:22 12517 0 NULL
44 54 POF-1044 INVF-1044 12540 12517 2 1 184 64256.8 0.0 1285.14 2313.63 2313.63 0.0 62971.66 INR 20390.0 20390.0 22088.0 4 12540 2025-11-07 17:20:25 0 NULL 1 2025-11-08 00:06:24 12517 0 NULL
45 55 POF-1045 INVF-1045 12533 12517 2 1 163 38494.4 0.0 769.89 1309.51 1309.51 0.0 37724.51 INR 13206.0 13206.0 13356.0 4 12533 2025-11-07 18:00:39 0 NULL 1 2025-11-07 23:56:54 12517 0 NULL
46 56 POF-1046 INVF-1046 12532 12517 2 1 697 125815.0 0.0 2516.3 4303.42 4303.42 0.0 123298.7 INR 36173.0 36173.0 36533.0 4 12532 2025-11-07 18:03:06 0 NULL 1 2025-11-08 00:06:27 12517 0 NULL
47 57 POF-1047 INVF-1047 12557 12517 2 1 152 18812.8 0.0 376.26 515.46 515.46 0.0 18436.54 INR 5707.0 5707.0 5837.0 4 12557 2025-11-07 18:20:42 0 NULL 1 2025-11-08 00:06:30 12517 0 NULL
48 58 POF-1048 INVF-1048 12524 12517 2 1 176 58328.0 0.0 1166.56 1652.34 1652.34 0.0 57161.44 INR 13825.0 13825.0 13975.0 4 12524 2025-11-07 18:31:54 0 NULL 1 2025-11-08 00:06:35 12517 0 NULL
49 59 POF-1049 INVF-1049 12516 1 2 1 8160 2186323.6 0.0 174905.89 71656.38 71656.38 0.0 2011417.71 INR 689030.0 689030.0 695630.0 4 12516 2025-11-07 18:37:14 0 NULL 2 2025-11-11 21:20:01 1 0 NULL
50 60 POF-1050 INVF-1050 12516 1 2 1 96 26896.8 0.0 2151.74 1327.64 1327.64 0.0 24745.06 INR 8255.0 8255.0 9255.0 4 12516 2025-11-07 18:50:33 0 NULL 1 2025-11-09 22:37:31 1 0 NULL