fx_franchise_order

1,267 rows · 31 columns · page 19 / 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
901 911 POFN-1901 INVFN-1901 13438 12517 2 1 151 17276.0 0.0 315.41 752.71 752.71 0.0 17276.0 INR 0.0 0.04 0.0 4 13438 2026-02-05 22:03:41 0 NULL 1 2026-02-05 22:03:51 12517 1 2026-02-05 22:03:51
902 912 POFN-1902 INVFN-1902 13438 12517 2 1 2 408.0 0.0 7.77 9.71 9.71 0.0 408.0 INR 0.0 0.08 0.0 4 13438 2026-02-05 22:38:22 0 NULL 1 2026-02-05 22:38:58 12517 1 2026-02-05 22:38:58
903 913 POFN-1903 INVFN-1903 12527 12517 2 1 240 28620.0 0.0 531.33 1026.66 1026.66 0.0 28620.0 INR 0.0 0.75 0.0 4 12527 2026-02-06 10:47:44 0 NULL 1 2026-02-06 17:24:17 12517 1 2026-02-06 17:24:17
904 914 POFN-1904 INVFN-1904 12528 12517 2 1 46 6876.0 0.0 126.28 281.02 281.02 0.0 6876.0 INR 0.0 0.25 0.0 4 12528 2026-02-06 17:17:53 0 NULL 1 2026-02-06 17:24:17 12517 1 2026-02-06 17:24:17
905 915 POFN-1905 INVFN-1905 12546 12517 2 2 5 53500.0 0.0 1019.05 1273.81 1273.81 0.0 53500.0 INR 0.0 5.0 250.0 4 12546 2026-02-06 20:20:56 0 NULL 1 2026-02-06 20:29:11 12517 1 2026-02-06 20:29:11
906 916 POFN-1906 INVFN-1906 12532 12517 2 2 4 42800.0 0.0 815.24 1019.05 1019.05 0.0 42800.0 INR 0.0 4.0 200.0 4 12532 2026-02-06 20:21:33 0 NULL 1 2026-02-06 20:37:09 12517 1 2026-02-06 20:37:09
907 917 POFN-1907 INVFN-1907 12521 12517 2 2 2 21400.0 0.0 407.62 509.52 509.52 0.0 21400.0 INR 0.0 2.0 100.0 4 12521 2026-02-06 21:52:01 0 NULL 1 2026-02-06 21:53:07 12517 1 2026-02-06 21:53:07
908 918 POFN-1908 INVFN-1908 14490 12517 2 1 1 2600.0 0.0 49.52 61.9 61.9 0.0 2600.0 INR 0.0 0.5 0.0 4 14490 2026-02-07 13:10:17 0 NULL 1 2026-02-09 11:39:15 12517 1 2026-02-09 11:39:15
909 919 POFN-1909 INVFN-1909 12517 12516 2 1 214 59421.0 0.0 2903.01 0.0 0.0 9064.22 59421.0 INR 0.0 1.82 0.0 4 12517 2026-02-07 16:08:59 0 NULL 1 2026-02-07 16:25:23 12516 1 2026-02-07 16:25:23
910 920 POFN-1910 INVFN-1910 12516 1 2 1 22 34200.0 0.0 1097.14 814.29 814.29 0.0 34200.0 INR 0.0 3.0 0.0 4 12516 2026-02-07 16:10:17 0 NULL 1 2026-02-07 16:10:28 1 1 2026-02-07 16:10:28
911 921 POFN-1911 INVFN-1911 12517 12516 2 1 1 9900.0 0.0 503.39 0.0 0.0 1510.17 9900.0 INR 0.0 2.0 0.0 4 12517 2026-02-07 16:12:17 0 NULL 1 2026-02-07 16:21:59 12516 1 2026-02-07 16:21:59
912 922 POFN-1912 INVFN-1912 12517 12516 2 1 178 298876.0 0.0 17078.63 0.0 0.0 14232.19 298876.0 INR 0.0 56.0 0.0 4 12517 2026-02-07 16:19:38 0 NULL 1 2026-02-07 16:25:20 12516 1 2026-02-07 16:25:20
913 923 POFN-1913 INVFN-1913 12517 12516 2 1 533 28112.0 0.0 1606.4 0.0 0.0 1338.67 28112.0 INR 0.0 2.72 0.0 4 12517 2026-02-07 16:20:22 0 NULL 1 2026-02-07 16:21:49 12516 1 2026-02-07 16:21:49
914 924 POFN-1914 INVFN-1914 12517 12516 2 1 58 69600.0 0.0 3314.29 0.0 0.0 3314.29 69600.0 INR 0.0 14.4 0.0 4 12517 2026-02-07 16:21:22 0 NULL 1 2026-02-07 16:25:17 12516 1 2026-02-07 16:25:17
915 925 POFN-1915 INVFN-1915 12516 1 2 1 170 287060.0 0.0 21777.39 7421.28 7421.28 0.0 287060.0 INR 0.0 9.0 0.0 4 12516 2026-02-07 16:25:00 0 NULL 1 2026-02-07 16:25:08 1 1 2026-02-07 16:25:08
916 926 POFN-1916 INVFN-1916 12517 12516 2 1 37 9592.0 0.0 556.48 0.0 0.0 164.75 9592.0 INR 0.0 0.1 0.0 4 12517 2026-02-07 16:54:50 0 NULL 1 2026-02-07 16:55:02 12516 1 2026-02-07 16:55:02
917 927 POFN-1917 INVFN-1917 12685 12517 2 1 659 95587.0 0.0 1730.02 3907.29 3907.29 0.0 95587.0 INR 0.0 0.06 0.0 4 12685 2026-02-09 11:31:19 0 NULL 1 2026-02-09 11:39:15 12517 1 2026-02-09 11:39:15
918 928 POFN-1918 INVFN-1918 14569 12517 2 1 8 2522.0 0.0 48.23 55.22 55.22 0.0 2522.0 INR 0.0 0.1 0.0 4 14569 2026-02-09 12:23:47 0 NULL 1 2026-02-09 13:14:24 12517 1 2026-02-09 13:14:24
919 929 POFN-1919 INVFN-1919 12516 1 2 1 600 699800.0 0.0 53318.09 16661.9 16661.9 0.0 699800.0 INR 0.0 60.0 0.0 4 12516 2026-02-09 16:23:31 0 NULL 1 2026-02-09 16:23:44 1 1 2026-02-09 16:23:44
920 930 POFN-1920 INVFN-1920 12517 12516 2 1 300 349900.0 0.0 18565.71 0.0 0.0 16661.9 349900.0 INR 0.0 30.0 0.0 4 12517 2026-02-09 16:26:11 0 NULL 1 2026-02-09 16:26:58 12516 1 2026-02-09 16:26:58
921 931 POFN-1921 INVFN-1921 13438 12517 2 1 1 500.0 0.0 8.47 38.14 38.14 0.0 500.0 INR 0.0 0.1 0.0 4 13438 2026-02-10 11:28:57 0 NULL 1 2026-02-10 11:57:50 12517 1 2026-02-10 11:57:50
922 932 POFN-1922 INVFN-1922 13438 12517 2 1 1 750.0 0.0 12.71 57.2 57.2 0.0 750.0 INR 0.0 0.1 0.0 4 13438 2026-02-10 11:37:25 0 NULL 1 2026-02-10 11:57:50 12517 1 2026-02-10 11:57:50
923 933 POFN-1923 INVFN-1923 14569 12517 2 1 1 720.0 0.0 13.71 17.14 17.14 0.0 720.0 INR 0.0 0.15 0.0 4 14569 2026-02-10 13:07:20 0 NULL 1 2026-02-10 14:27:30 12517 1 2026-02-10 14:27:30
924 934 POFN-1924 INVFN-1924 14569 12517 2 1 14 1543.0 0.0 28.33 63.23 63.23 0.0 1543.0 INR 0.0 0.06 0.0 4 14569 2026-02-10 13:21:08 0 NULL 1 2026-02-10 14:27:30 12517 1 2026-02-10 14:27:30
925 935 POFN-1925 INVFN-1925 14569 12517 2 1 10 800.0 0.0 15.24 19.05 19.05 0.0 800.0 INR 0.0 0.09 0.0 4 14569 2026-02-10 13:22:19 0 NULL 1 2026-02-10 14:27:30 12517 1 2026-02-10 14:27:30
926 936 POFN-1926 INVFN-1926 12543 12517 2 1 19 6286.0 0.0 115.99 243.21 243.21 0.0 6286.0 INR 0.0 0.11 0.0 4 12543 2026-02-10 22:40:54 0 NULL 1 2026-02-11 07:27:43 12517 1 2026-02-11 07:27:43
927 937 POFN-1927 INVFN-1927 12545 12517 2 1 65 3120.0 0.0 59.43 74.29 74.29 0.0 3120.0 INR 0.0 0.39 0.0 4 12545 2026-02-11 11:33:57 0 NULL 1 2026-02-11 11:56:55 12517 1 2026-02-11 11:56:55
928 938 POFN-1928 INVFN-1928 12545 12517 2 1 1 204.0 0.0 3.89 4.86 4.86 0.0 204.0 INR 0.0 0.04 0.0 4 12545 2026-02-11 11:36:45 0 NULL 1 2026-02-11 11:56:55 12517 1 2026-02-11 11:56:55
929 939 POFN-1929 INVFN-1929 12544 12517 2 1 6 822.0 0.0 15.66 19.57 19.57 0.0 822.0 INR 0.0 0.08 0.0 4 12544 2026-02-11 11:49:49 0 NULL 1 2026-02-11 11:56:55 12517 1 2026-02-11 11:56:55
930 940 POFN-1930 INVFN-1930 14569 12517 2 1 4 2528.0 0.0 48.15 60.19 60.19 0.0 2528.0 INR 0.0 0.25 0.0 4 14569 2026-02-11 12:41:18 0 NULL 1 2026-02-11 12:52:31 12517 1 2026-02-11 12:52:31
931 941 POFN-1931 INVFN-1931 12555 12554 2 1 3 4320.0 0.0 2.0 102.86 102.86 0.0 4320.0 INR 0.0 0.87 0.0 4 12555 2026-02-11 13:32:24 0 NULL 1 2026-02-11 13:32:40 12554 1 2026-02-11 13:32:40
932 942 POFN-1932 INVFN-1932 12554 12516 2 1 150 174950.0 0.0 9282.86 4165.48 4165.48 0.0 174950.0 INR 0.0 15.0 0.0 4 12554 2026-02-11 15:53:50 0 NULL 2 2026-02-11 15:55:48 12516 0 NULL
933 943 POFN-1933 INVFN-1933 12554 12516 2 1 60 69980.0 0.0 3713.14 1666.19 1666.19 0.0 69980.0 INR 0.0 6.0 0.0 4 12554 2026-02-11 15:56:50 0 NULL 1 2026-02-11 15:57:07 12516 1 2026-02-11 15:57:07
934 944 POFN-1934 INVFN-1934 12555 12554 2 1 30 34990.0 0.0 666.48 833.1 833.1 0.0 34990.0 INR 0.0 3.0 0.0 4 12555 2026-02-11 15:57:49 0 NULL 1 2026-02-11 15:58:09 12554 1 2026-02-11 15:58:09
935 945 POFN-1935 INVFN-1935 14569 12517 2 1 4 2142.0 0.0 37.82 125.6 125.6 0.0 2142.0 INR 0.0 0.11 0.0 4 14569 2026-02-11 18:01:01 0 NULL 1 2026-02-12 08:56:08 12517 1 2026-02-12 08:56:08
936 946 POFN-1936 INVFN-1936 14569 12517 2 1 1 159.0 0.0 2.69 12.13 12.13 0.0 159.0 INR 0.0 0.02 0.0 4 14569 2026-02-11 19:26:04 0 NULL 1 2026-02-12 08:56:08 12517 1 2026-02-12 08:56:08
937 947 POFN-1937 INVFN-1937 13836 12517 2 1 5 1967.0 0.0 36.46 72.02 72.02 0.0 1967.0 INR 0.0 0.02 0.0 4 13836 2026-02-12 15:19:05 0 NULL 1 2026-02-12 15:21:21 12517 1 2026-02-12 15:21:21
938 948 POFN-1938 INVFN-1938 14569 12517 2 1 4 448.0 0.0 8.82 3.43 3.43 0.0 448.0 INR 0.0 0.05 0.0 4 14569 2026-02-12 20:18:43 0 NULL 1 2026-02-13 06:44:19 12517 1 2026-02-13 06:44:19
939 949 POFN-1939 INVFN-1939 12521 12517 2 1 13 1425.0 0.0 24.96 88.54 88.54 0.0 1425.0 INR 0.0 0.02 0.0 4 12521 2026-02-13 14:18:36 0 NULL 1 2026-02-13 14:26:55 12517 1 2026-02-13 14:26:55
940 950 POFN-1940 INVFN-1940 12546 12517 2 1 4 4800.0 0.0 91.43 114.29 114.29 0.0 4800.0 INR 0.0 0.5 0.0 4 12546 2026-02-13 15:07:59 0 NULL 1 2026-02-13 15:09:57 12517 1 2026-02-13 15:09:57
941 951 POFN-1941 INVFN-1941 12545 12517 2 1 8 2573.0 0.0 44.78 166.92 166.92 0.0 2573.0 INR 0.0 0.02 0.0 4 12545 2026-02-13 15:32:07 0 NULL 1 2026-02-13 15:44:53 12517 1 2026-02-13 15:44:53
942 952 POFN-1942 INVFN-1942 12546 12517 2 1 2 1438.0 0.0 27.39 34.24 34.24 0.0 1438.0 INR 0.0 0.3 0.0 4 12546 2026-02-13 15:51:51 0 NULL 1 2026-02-13 15:58:37 12517 1 2026-02-13 15:58:37
943 953 POFN-1943 INVFN-1943 14569 12517 2 1 3 2198.0 0.0 41.87 52.33 52.33 0.0 2198.0 INR 0.0 0.2 0.0 4 14569 2026-02-13 16:07:07 0 NULL 1 2026-02-13 16:29:58 12517 1 2026-02-13 16:29:58
944 954 POFN-1944 INVFN-1944 14569 12517 2 1 2 2499.0 0.0 47.6 59.5 59.5 0.0 2499.0 INR 0.0 0.1 0.0 4 14569 2026-02-13 16:10:33 0 NULL 1 2026-02-13 16:29:58 12517 1 2026-02-13 16:29:58
945 955 POFN-1945 INVFN-1945 14569 12517 2 1 2 441.0 0.0 7.47 33.64 33.64 0.0 441.0 INR 0.0 0.01 0.0 4 14569 2026-02-13 16:22:29 0 NULL 1 2026-02-13 16:29:58 12517 1 2026-02-13 16:29:58
946 956 POFN-1946 INVFN-1946 12526 12517 2 1 240 54713.0 0.0 1011.4 2071.57 2071.57 0.0 54713.0 INR 0.0 0.1 0.0 4 12526 2026-02-13 17:48:09 0 NULL 2 2026-02-13 21:11:48 12517 0 NULL
947 957 POFN-1947 INVFN-1947 12546 12517 2 1 57 3343.0 0.0 62.03 120.73 120.73 0.0 3343.0 INR 0.0 0.06 0.0 4 12546 2026-02-13 18:24:00 0 NULL 1 2026-02-13 18:26:20 12517 1 2026-02-13 18:26:20
948 958 POFN-1948 INVFN-1948 12526 12517 2 1 2 4600.0 0.0 87.62 109.52 109.52 0.0 4600.0 INR 0.0 0.4 0.0 4 12526 2026-02-13 21:30:14 0 NULL 2 2026-02-13 21:30:56 12517 0 NULL
949 959 POFN-1949 INVFN-1949 12526 12517 2 1 235 53193.0 0.0 985.63 1955.64 1955.64 0.0 53193.0 INR 0.0 0.1 0.0 4 12526 2026-02-13 21:38:45 0 NULL 1 2026-02-13 21:39:28 12517 1 2026-02-13 21:39:28
950 960 POFN-1950 INVFN-1950 12526 12517 2 1 3 2998.0 0.0 57.1 71.38 71.38 0.0 2998.0 INR 0.0 0.2 0.0 4 12526 2026-02-13 21:57:11 0 NULL 1 2026-02-13 21:58:28 12517 1 2026-02-13 21:58:28