Input
iVBORw0KGgoAAAANSUhEUgAAAXoAAAA0CAIAAAAL52RvAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAScQAAEnEB89x6jgAAABJ0RVh0U29mdHdhcmUAR3JlZW5zaG90XlUIBQAADRxJREFUeF7tnd+OFccRh/0GzhvEb4DfwH4D+w3sN0jewFxxhxIpcGEJCS4s+WKJsYR9w14kYq8WIWE2CgqKMVqL4FUQ8kIisCVL5NtTvZXa6j/TZ2fm7J51fWqNTtdU93QPU7+pnjNneetNEATBSgi5CYJgRYTcBEGwIk5Gbv7y5D83Hu2nSrAOPHny5O7du7u7u6keBMuzarl5/OLn97/49q0/fUNJpmAdCLkJxrNSubn37NVvPv2baM2ycvPjT7+c395DqhCsZApWSMhNMJ6Vys0n2z+o1iwlN1anWIgla7BCQm6C8ayH3Lz96Y62Crk5EUJugvGsh9zYViE3J0LITTCekJugi5CbYDwhN0EXITfBeEJugi5CboLxhNwEXYTcBOMZkJsff/rlj988+3jz+/e/+Na+MkN59/OH2Nl779mr5D3EycoN4zy/vff72/9iLmz5/OWjF2lfMETITTCeAbn54KvvbKjXyjvXHhDAgy/gLSU3f7j3b3SBgq7ZVmgcSmHLoABdffDcaaUW7PSAqibXEuz965P/Skmmxe8wRLlEvJJ1AbvUv92zok2sdvNZ+0mmCnaEM70GGXITjGdAbj7a3HXx2SiEbmpWYSm5sZ7t8t6f/5naZBCHTq2KBZ+GLljNRQTxRGLUIiW5LrB2TmCy1kEN1f+31/6erEffNvrd7SfJmuHm2HPEYxByE4xnQG6463LRE8+EHGJhCxYbD1LaiQatrHOyVrCe7dKQm3Of/yN3luLsRGxqk2GdmXWeKLkBWHkalGCwg+QUJesiv1M7pXZuUSLrttbZzf7+PocAPiRTk9evX4s/JFOdTjdFBsMhUn3Bsp3s7e25TsTCNtVLFH0GW4GM2Z09LNYo1R7Ef0LGPip2CjKh3ORKUSs2RC3ucFRtCsNnF6i1fnJtcsUlFDce7du97d++ow7W2YmFPQmsWPMUjBOuDpTaFMYzq9wQCTdv3rx8+fIFA9XNzU0X7QLGra2tK1euJNdDsOzs7CSnDPG5detWqjd5+PCh+Lspi5HRpnqT27dvi7/t5LPPPsPCNtVLFH0WPV24f/9+qpeQI7JN9QXSUI1S7UFOwsWLFxsyxy5xvnPnTjLVGSs37nKfUG6UpQ6huDAmU0g7jmIVh3hO1qPkckNah8QwknvPXrHNVYA1kTq3Vzc2hXFZEtC/7qW4JRXHZcy6F21KO2ZgPrkhfuR6LcK1zkWfXBdwfWNMuxcQltaC6BTDI+2+cGEwR4BLly6Jc1FuYPBUoIk6qgnlph3808oNzoOjHXSwnFm5sTpiH4g4iFh1oxQ7d3JDVNsHukVc3pTrkWKF6eqD58lqcCfNjtAdZXBUY5hJbrglLi7sA4gHG0gciyQC+8bGRjId1Rr2Wn9SJHqQvcWYlFYwGBtWAWtyM9iJRL4wodwAelpM+kAOqsoiSCtnVBibOBT/cTmrsreYVemJaiig5czKjX2uVEttBKsmjDBZDdaBbnui2uVWRR0Bm7zQc02Viksqd1qKI5+QOeSGa1Qu1sYdG7sNLV1AuZRHwV8UB89kOgSjSlVjIpqVSILjPBetUz+NdU2jk5FyI93WVnOTyw1In6xtncbpHDvXp3A25ebYo/rgq++S1WDlJl/v1LAaUewWbHrSWHO56ciSyvZPitRIoCZhDrmRoILOe6PeS2uRI2j8ODkQI7HBluBJ1gyJLtxkeG7KB10sBsC20YnkZWzzTopS4ij6YAE9CUWxk4G58yP+tZOmp6vxjyui6XqQY6E4ToYanE25cd/pJGsFO6qimhxPbuzX25SiHNgUrD0vt2768OvHttpzTkYyudxoll67UedIatNzfTfCVe/JxXCVvXII6aQoN9pJMYZlajjwIe+kODZH0QcL8EG0DHKZFglwoxLn4lChR27UhxmJRf/5amlmkbMpN2QKtkmyVphJbtAXbUXJ11P2C6zG0yWB3uxTHlsk2ZmbyeVG79Kd1ysRLv498qSPhFJ9gVoat2WJZInMXCngoItFJzL+Y3RSlBJH0QcL8IEjivLmCxyZmlOWRbtRcgMbGxv4XL9+Xao9s8jpkhuu9S8fvTi/vcdNVd6j1eJeojslcmMFguLG7Ir9cmdCuQGrehwoWQ+xe3skw50HKStYRgmTy40EBnSupDQqamFjKYaQWORzcXUgd2x2SQxLRLkpH3RxtBP35EJTm1onPYFa9MEC8lkfUWn8C3JW3bwW7cbKDfOSI+KmTTTZ6WRAbh6/+Pnjze/dJd4op1Nu+su0cuNewLHv1Ljcx71uU8MtqSgr+w8t5pObVB9CL/Fa2FjU2Q5YLPJZcxMbMHID10VWrhRw0MVhJ3oU24m00pdQ8k6KUuIo+mCBVKk8yZKz6k5R7mYpnqsikjMyKhlezz+EoyU35P+1nxrVyhxy4x6CzCo3xee1x5YbsCsg+wWZndS57vdlnPL2vLI8FfPJTecdUqOi5yovhpBYUuUwpHVpJk1IWKQK4uCmfNBF1ommGD2diIVtqpco+mCBVFkgj71B+5ez6k6R+NTOm4wZ3EyL6DeDmgMuRVVuuN86rSEq0AsKd1Suey3Wh2pqX+J4cuNatQ8hWIFg2DrUwZLaH2WM3NjB299J2D7zxzo1mIu2kkL/ad/MzCc3nX2yfBD/HrmR12HBaplYUsWEmazmarrghrdo8f9OdFTiJk00P4Jat2xTvUTRBwukyiHu8fnccqMndqknxEpVbuwPf9ovm6gbpRaxwonIzfgUYIzcuBdwZNHkjJ0PX9x50DLr233K5HKjF26PfAjyrCR/oSZHbvs2y4DF0Y6Eq6yeiGpZmLjwlph3Uz7o4mgn8mAYZ4nbwU70oKleQlo5HyyQKoegp/JIRU7L3HKzlHNOVW7sBd1+Tc56nkK5oSTrcRkjN2Cby5m039M3Xrex2BcCXWn8uHRCJpcbkDhpvL3ikMAevNa5z0vPulASpG2qLCBWxSj+7qF1rhSwcPed6ETYOv+8E1EEmqR6CRHWomqkikGFG5FdS7khpO0F3Y7wfs+VyY1rMvK7m5FyYx/TyM+y7Jqo81mvbUKy6V4sYr7JbzbmkBuJDahFgkPVgTt548GBqpJdSYEYU+UQffzhtAk65QZ0Ii4fgbwTXX/ZNZdFQ9rJnxhT5Sg6C1lbrbfcJGsF67mU3BxvEdEjN278/Q9HioyUG6ZpX+ez6jP4uo3gxEVSJDsqytxLqjnkRtMQqP2emECyQqCBTVw5NQE6vH79ujjkHYo9VQ6RMUDeW7/cLNuJGPHPzycSg529uXIdHLgiNyB9CustN+0I7/c8hnCAC7aedMB9zZy/87IUI+UG3GuHWnpet3HP7HUA2K2Kzb2kmkNuQKMLWIygERxC4LMsT1wYa/ICiMvW1harCbbYtas8VQHZlSoGxAJSxdAvN7BUJ0xHh8oUdnZ2FjPe3dzcFCN7XWoDsitVMji69rlmcuOeFDSyA/fUs60g9sZO6Xxs4bSvs5WL8DEJzni5cVPQIk+O29ijoy+2STHrmYmZ5AaIK1kCFCFc88BjGSJPN3Kw1xYp4pAqHSwlNzWKnUBj1kwhnzLI3lQpoVqwZnID9s75zrUHeWAgSfkbgNxj5e8Hk1DkEZ4/78RTeiYfkReX80WBUzSK/l1ktv2tcCsu3xqHFsbLDeQ/QTjX8bqNE5T8GY0dG0mQnJY5mE9uBDIUUhKCk1s08cYHllHtw9GEENrY2MCZLZ+xpH0lcINU6YAB4O8if5JOFJSRkYvuMGs+17QSeg7NGcg7kYa1nhmbONQGaVnKOacqN/kLrCiI/AcGH3792L74XyvFb6BrP/zRMvib7GIpLiXc2k0KnjIR+UGGnUhtPTKJ3OSDGUy40A67jCrKk1PVkcvGBnPLTfBroCo33PMHpYGCT0ML8nyhtqzQUhSpPC3KS3I9Su2hSa0U059J5CbPtorHsrgTW0u+nJDNtKQKuQnGU5Ub4PrOX2O1hQyImCGQ7MpLi3vQoHBXL/pLqf1pmBuP9hutGguTPE1rlOKAJ5EbsP0MPoFyz7nQlLSjhP1nmmlJFXITjKclNwLXPRKgmQ4xT9hwC7U3Zz4TP+rD1U+QNy56/OmBbulKOqQQUbUbuFBsxYEGv6tiJAyvoVaMvDFgBiZt2Q6ugBowcj3i4JiZqUxQ5pisFThv6kxpn8bjEXITjGdYbs4SxCFxjnxIIaRZ3M2RC+RwFNUaZCtZ14eQm2A8vy65OUHsmm4wWzmFhNwE4wm5WQUsA+13TKvJp6Yl5CYYT8jNKmDhplrz3oiHzSdIyE0wnpCb2bn37JVNbdovXp9aQm6C8YTczAhrqPPbe1Zr1jS1gZCbYDwhNxODoCAr7x79i/FS3q7/x3Wnn5CbYDwhNxPjJEYLWjPH6zArI+QmGE/IzcQ4lZHy0ebu+uY1QshNMJ6Qm4nR957ZfrL9w9UHz9fxa++cly9fPn36NP/zUUHQT8hNEAQrIuQmCIIVEXITBMFKePPmf4GyDTAL6GK4AAAAAElFTkSuQmCC
Weekly Challenge #188
C:\Users\stanl\AppData\Local\Temp\Engine_12260_7a737f2fc9cc44c1ad510720d0a5b91b_\Engine_18404_4695585f54ca410990b0027ef4c1224e_.yxdb
Single
Profile
C:\Users\stanl\AppData\Local\Temp\Engine_12260_7a737f2fc9cc44c1ad510720d0a5b91b_\Engine_18404_c086f44ec5ba4905b53b02c92cbc47a0_.yxdb
Single
Profile
111-81-41019
06/30/2019
1910007001
06/17/2019
KR
6960950
696095
P1
111-81-41019
06/30/2019
1910026000
07/12/2019
KR
15485620
1548562
P1
111-81-41019
06/30/2019
1910261006
07/01/2019
KR
14626760
1462676
P1
111-81-41019
06/30/2019
5110006019
07/12/2019
RE
96541270
9654127
P1
111-81-41019
06/30/2019
5110029001
07/25/2019
RE
104791530
10479153
P1
111-81-41019
06/30/2019
5110466063
07/01/2019
RE
102625940
10262594
P1
116-85-36080
06/16/2019
5140482033
07/01/2019
RE
2640000
264000
P1
117-86-38534
06/01/2019
5160429030
06/26/2019
RE
56000
5600
P1
117-86-38534
06/24/2019
5148466117
06/29/2019
RE
60000
6000
P1
117-86-38534
06/16/2019
5800476217
06/01/2019
RE
840000
84000
P1
118-81-03897
06/02/2019
5400446089
06/12/2019
RE
8717721
871772
P1
118-81-03897
06/01/2019
5140446090
06/12/2019
RE
5500000
550000
P1
119-81-52311
06/20/2019
5100089038
06/30/2019
RE
187000
18700
P1
119-81-52311
06/03/2019
5180474010
06/15/2019
RE
5739000
573900
P1
119-81-77493
06/30/2019
5110006036
07/13/2019
RE
112769579
11276958
P1
119-81-77493
06/30/2019
5107466049
07/29/2019
RE
118361369
11836136
P1
123-43-92508
06/30/2019
1780003001
06/30/2019
KG
-6909960
-690990
P1
123-43-92508
06/30/2019
1708013000
07/15/2019
KG
-10
-1
P1
123-43-92508
06/17/2019
1704076001
06/30/2019
KG
-141719460
-14171950
P1
123-43-92508
06/30/2019
1707076006
06/30/2019
KG
-10
-1
P1
123-43-92508
06/30/2019
1720082001
07/31/2019
KG
-100249420
-10024940
P1
123-43-92508
06/10/2019
1901004000
06/10/2019
KR
736238700
73623870
P1
123-43-92508
06/30/2019
1903027000
07/15/2019
KR
8642
1
P1
123-43-92508
06/10/2019
1900007001
07/15/2019
KR
118482
11850
P1
123-43-92508
06/11/2019
1900209004
06/11/2019
KR
4465995000
446599500
P1
174-06-37093
06/02/2019
1908807006
06/26/2018
KR
825500
82550
P9
174-06-37093
06/01/2019
1940257043
06/30/2018
KR
1411000
141100
P9
174-06-37093
06/02/2019
1970268016
06/30/2018
KR
875000
87500
P9
191-01-77441
06/23/2019
1900257027
06/30/2019
KR
22164000
2216400
P1
192-82-04066
06/07/2019
1900406000
06/13/2019
KR
4250000000
425000000
P1
192-82-04066
06/26/2019
1800256000
06/30/2019
KR
556479040
55647904
P1
192-82-04066
06/29/2019
1900268001
06/30/2019
KR
881163058
88116305
P1
204-71-37125
06/29/2019
1904013007
06/30/2019
KR
51812290
5181229
P1
204-71-37125
06/30/2019
1910249007
06/30/2019
KR
9005940
900594
P1
204-71-37125
06/28/2019
1900257007
07/31/2019
KR
14173910
1417391
P1
407-86-09872
06/29/2019
5100110015
07/28/2019
RE
1827273
182727
P1
407-86-09872
06/01/2019
5100112000
06/04/2019
RE
535922230
53592223
P1
407-86-09872
06/01/2019
5100144003
06/02/2019
RE
529659150
52965915
P1
814-81-61910
06/18/2019
1980005001
06/26/2018
KR
830000
83000
P1
814-81-61910
06/18/2019
1908248004
06/30/2018
KR
830000
83000
P1
814-81-61910
06/17/2019
1400253005
06/28/2018
KR
830000
83000
P1
814-81-61910
06/22/2019
5400029011
06/25/2018
RE
1800000
180000
P1
814-81-61910
06/17/2019
5104485003
06/29/2018
RE
180000
18000
P1
814-81-61910
06/17/2019
5107485004
06/29/2018
RE
18760000
1876000
P1
814-81-61910
06/17/2019
5120485005
06/29/2018
RE
15176000
1517600
P1
814-81-61910
06/24/2019
5900485036
06/29/2018
RE
9200000
920000
P1
----------------------------------------------------------------------------------------------------
(21)( 1 )Pag.
[Report Name 20 Form 3 (1)] (2002.4.12. Revised)
----------------------------------------------------------------------------------------------------
| Tax Invoice Summary by Vendor (BB) |
| |
| |
| ( Ye Pe ) |
| 1. Reporter Details (Company Code Details) |
----------------------------------------------------------------------------------------------------
|(1)ID no. |111-22-33333 |(2)Co. name |Company LLC |
----------------------------------------------------------------------------------------------------
|(3)Rep. |###### |(4)Location |## ## #### 152 (> |
----------------------------------------------------------------------------------------------------
|(5)Transaction |2019YY 06MM 01DD ~ 2019YY 06MM 30DD|(6)Report.d|19YY 07MM 04DD |
----------------------------------------------------------------------------------------------------
| 2. Grand Total of Taxes |
|---------------------------------------------------------------------------------------------------
|
| |
| 0001 0001 | | | |1|3|0|7|4|8|8|0|6|6|9| | | | |1|3|0|7|4|8|7|2|0|6|
|--------------------------------------------------------------------------------------------------|
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| 0000 0 | | | | | | | | | | | | | |0| | | | | | | | | | | | | |0|
| |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| 0000 0 | | | | | | | | | | | | | |0| | | | | | | | | | | | | |0|
| |
| 0000 0000 | | | | | | | | | | | | | |0| | | | | | | | | | | | | |0|
|--------------------------------------------------------------------------------------------------|
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| 0001 0001 | | | |1|3|0|7|4|8|8|0|6|6|9| | | | |1|3|0|7|4|8|7|2|0|6|
| |
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| 0000 0000 | | | | | | | | | | | | | |0| | | | | | | | | | | | | |0|
| |
| 0001 0001 | | | |1|3|0|7|4|8|8|0|6|6|9| | | | |1|3|0|7|4|8|7|2|0|6|
|--------------------------------------------------------------------------------------------------|
|---------------------------------------------------------------------------------------------------
|(11) |(12) |(13)Vendor |(14) |(15)Base amount |(16)Tax amount |Rema|
|Seq. |ID no. | Name | No. | Tr TeHM HuTt Th On | Tr TeHM HuTt Th On |rks |
|---------------------------------------------------------------------------------------------------
| 1 |191-01-77441|#.####> | 1 | | | | | | |2|2|1|6|4|0|0|0| | | | | | |2|2|1|6|4|0|0 | |
----------------------------------------------------------------------------------------------------
| Doc number Type Post date Document Dt Base amt Tax Code Tax amt |
----------------------------------------------------------------------------------------------------
| 1900257027 KR 2019-06-23 2019-06-30 22,164,000 P1 2,216,400 |
----------------------------------------------------------------------------------------------------
| 2 |192-82-04066|#### #> | 4 | | | | |5|7|7|2|6|8|0|4|9|8| | | | |5|7|7|2|6|8|0|4|9 | |
----------------------------------------------------------------------------------------------------
| Doc number Type Post date Document Dt Base amt Tax Code Tax amt |
----------------------------------------------------------------------------------------------------
| 1900406000 KR 2019-06-07 2019-06-13 4,250,000,000 P1 425,000,000 |
| 1900013009 KR 2019-06-28 2019-06-30 85,038,400 P2 8,503,840 |
| 1800256000 KR 2019-06-26 2019-06-30 556,479,040 P1 55,647,904 |
| 1900268001 KR 2019-06-29 2019-06-30 881,163,058 P1 88,116,305 |
----------------------------------------------------------------------------------------------------
| 3 |204-71-37125|######>| 4 | | | | | | |7|7|1|7|0|7|9|5| | | | | | |7|7|1|7|0|7|8 | |
----------------------------------------------------------------------------------------------------
| Doc number Type Post date Document Dt Base amt Tax Code Tax amt |
----------------------------------------------------------------------------------------------------
| 1904013007 KR 2019-06-29 2019-06-30 51,812,290 P1 5,181,229 |
| 1900013216 KR 2019-06-30 2019-07-14 2,178,655 P6 217,864 |
| 1910249007 KR 2019-06-30 2019-06-30 9,005,940 P1 900,594 |
| 1900257007 KR 2019-06-28 2019-07-31 14,173,910 P1 1,417,391 |
----------------------------------------------------------------------------------------------------
| 4 |186-01-58638|#### #> | 2 | | | | | | | |6|2|8|7|7|3|7| | | | | | | | | | | | |0 | |
----------------------------------------------------------------------------------------------------
| Doc number Type Post date Document Dt Base amt Tax Code Tax amt |
----------------------------------------------------------------------------------------------------
| 1702007002 KG 2019-06-30 2019-07-12 10- P0 0 |
| 1900035007 KR 2019-06-30 2019-07-12 6,287,747 P0 0 |
----------------------------------------------------------------------------------------------------
| 5 |102-82-00168|#### #> | | | | | | | | | | | | | |0| | | | | | | | | | | | | |0 | |
|---------------------------------------------------------------------------------------------------
| Doc number Type Post date Tax Inv No Tax Inv Dt Base amt Tax Code Tax amt |
----------------------------------------------------------------------------------------------------
| 6 |407-86-09872|######>| 4 | | | | |1|5|9|7|4|1|3|1|7|3| | | | |1|5|9|7|4|1|3|1|7 | |
----------------------------------------------------------------------------------------------------
| Doc number Type Post date Document Dt Base amt Tax Code Tax amt |
----------------------------------------------------------------------------------------------------
| 5100110015 RE 2019-06-29 2019-07-28 1,827,273 P1 182,727 |
| 5100112000 RE 2019-06-01 2019-06-04 535,922,230 P1 53,592,223 |
| 5100144003 RE 2019-06-01 2019-06-02 529,659,150 P1 52,965,915 |
| 5100182032 RE 2018-06-01 2019-06-07 530,004,520 P7 53,000,452 |
----------------------------------------------------------------------------------------------------
| 7 |117-86-38534|#### #> | 3 | | | | | | | | |9|5|6|0|0|0| | | | | | | | |9|5|6|0|0 | |
----------------------------------------------------------------------------------------------------
| Doc number Type Post date Document Dt Base amt Tax Code Tax amt |
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
(21)( 2 )Pag.
[Report Name 20 Form 3 (1)] (2002.4.12. Revised)
----------------------------------------------------------------------------------------------------
| Tax Invoice Summary by Vendor (BB) |
| |
| |
| ( Ye Pe ) |
| 1. Reporter Details (Company Code Details) |
| 5160429030 RE 2019-06-01 2019-06-26 56,000 P1 5,600 |
| 5148466117 RE 2019-06-24 2019-06-29 60,000 P1 6,000 |
| 5800476217 RE 2019-06-16 2019-06-01 840,000 P1 84,000 |
----------------------------------------------------------------------------------------------------
| 8 |814-81-61910|(#)#### | 9 | | | | | | |5|2|9|5|6|0|0|0| | | | | | |5|2|9|5|6|0|0 | |
----------------------------------------------------------------------------------------------------
| Doc number Type Post date Document Dt Base amt Tax Code Tax amt |
----------------------------------------------------------------------------------------------------
| 1980005001 KR 2019-06-18 2018-06-26 830,000 P1 83,000 |
| 1908248004 KR 2019-06-18 2018-06-30 830,000 P1 83,000 |
| 1400253005 KR 2019-06-17 2018-06-28 830,000 P1 83,000 |
| 5400029011 RE 2019-06-22 2018-06-25 1,800,000 P1 180,000 |
| 5140478015 RE 2019-06-18 2018-06-01 5,350,000 P7 535,000 |
| 5104485003 RE 2019-06-17 2018-06-29 180,000 P1 18,000 |
| 5107485004 RE 2019-06-17 2018-06-29 18,760,000 P1 1,876,000 |
| 5120485005 RE 2019-06-17 2018-06-29 15,176,000 P1 1,517,600 |
| 5900485036 RE 2019-06-24 2018-06-29 9,200,000 P1 920,000 |
----------------------------------------------------------------------------------------------------
| 9 |174-06-37093|######>| 3 | | | | | | | |3|1|1|1|5|0|0| | | | | | | |3|1|1|1|5|0 | |
----------------------------------------------------------------------------------------------------
| Doc number Type Post date Document Dt Base amt Tax Code Tax amt |
----------------------------------------------------------------------------------------------------
| 1908807006 KR 2019-06-02 2018-06-26 825,500 P9 82,550 |
| 1940257043 KR 2019-06-01 2018-06-30 1,411,000 P9 141,100 |
| 1970268016 KR 2019-06-02 2018-06-30 875,000 P9 87,500 |
----------------------------------------------------------------------------------------------------
| 10 |118-81-03897|######>| 2 | | | | | | |1|4|2|1|7|7|2|1| | | | | | |1|4|2|1|7|7|2 | |
----------------------------------------------------------------------------------------------------
| Doc number Type Post date Document Dt Base amt Tax Code Tax amt |
----------------------------------------------------------------------------------------------------
| 5400446089 RE 2019-06-02 2019-06-12 8,717,721 P1 871,772 |
| 5140446090 RE 2019-06-01 2019-06-12 5,500,000 P1 550,000 |
----------------------------------------------------------------------------------------------------
| 11 |116-85-36080|(#)####>| 1 | | | | | | | |2|6|4|0|0|0|0| | | | | | | |2|6|4|0|0|0 | |
----------------------------------------------------------------------------------------------------
| Doc number Type Post date Document Dt Base amt Tax Code Tax amt |
----------------------------------------------------------------------------------------------------
| 5140482033 RE 2019-06-16 2019-07-01 2,640,000 P1 264,000 |
----------------------------------------------------------------------------------------------------
| 12 |111-81-41019|(#)####>| 6 | | | | | |3|4|1|0|3|2|0|7|0| | | | | |3|4|1|0|3|2|0|7 | |
----------------------------------------------------------------------------------------------------
| Doc number Type Post date Document Dt Base amt Tax Code Tax amt |
----------------------------------------------------------------------------------------------------
| 1910007001 KR 2019-06-30 2019-06-17 6,960,950 P1 696,095 |
| 1910026000 KR 2019-06-30 2019-07-12 15,485,620 P1 1,548,562 |
| 1910261006 KR 2019-06-30 2019-07-01 14,626,760 P1 1,462,676 |
| 5110006019 RE 2019-06-30 2019-07-12 96,541,270 P1 9,654,127 |
| 5110029001 RE 2019-06-30 2019-07-25 104,791,530 P1 10,479,153 |
| 5110466063 RE 2019-06-30 2019-07-01 102,625,940 P1 10,262,594 |
----------------------------------------------------------------------------------------------------
| 13 |119-81-52311|(#)####>| 2 | | | | | | | |5|9|2|6|0|0|0| | | | | | | |5|9|2|6|0|0 | |
----------------------------------------------------------------------------------------------------
| Doc number Type Post date Document Dt Base amt Tax Code Tax amt |
----------------------------------------------------------------------------------------------------
| 5100089038 RE 2019-06-20 2019-06-30 187,000 P1 18,700 |
| 5180474010 RE 2019-06-03 2019-06-15 5,739,000 P1 573,900 |
----------------------------------------------------------------------------------------------------
| 14 |119-81-77493|######>| 2 | | | | | |2|3|1|1|3|0|9|4|8| | | | | |2|3|1|1|3|0|9|4 | |
----------------------------------------------------------------------------------------------------
| Doc number Type Post date Document Dt Base amt Tax Code Tax amt |
----------------------------------------------------------------------------------------------------
| 5110006036 RE 2019-06-30 2019-07-13 112,769,579 P1 11,276,958 |
| 5107466049 RE 2019-06-30 2019-07-29 118,361,369 P1 11,836,136 |
----------------------------------------------------------------------------------------------------
| 15 |123-43-92508|#### | 15 | | |1|4|9|1|6|8|1|8|2|9|1|9| | |1|4|9|1|6|8|1|5|8|2|0 | |
----------------------------------------------------------------------------------------------------
| Doc number Type Post date Document Dt Base amt Tax Code Tax amt |
----------------------------------------------------------------------------------------------------
| 1780003001 KG 2019-06-30 2019-06-30 6,909,960- P1 690,990- |
| 1708013000 KG 2019-06-30 2019-07-15 10- P1 1- |
| 1704076001 KG 2019-06-17 2019-06-30 141,719,460- P1 14,171,950- |
| 1707076006 KG 2019-06-30 2019-06-30 10- P1 1- |
| 1720082001 KG 2019-06-30 2019-07-31 100,249,420- P1 10,024,940- |
| 1901004000 KR 2019-06-10 2019-06-10 736,238,700 P1 73,623,870 |
| 1903027000 KR 2019-06-30 2019-07-15 8,642 P1 1 |
| 1900007001 KR 2019-06-10 2019-07-15 118,482 P1 11,850 |
| 1900209004 KR 2019-06-11 2019-06-11 4,465,995,000 P1 446,599,500 |
----------------------------------------------------------------------------------------------------
Field_1
ParseComplex
Field_1
Warn
Field_1_Matched
VAT
New Field
Int32
4
Empty
if isnull([VAT]) then [Row-1:VAT] else [VAT] endif
if isnull([VAT]) then [Row-1:VAT] else [VAT] endif
REGEX_Match([Field_1],'.*?\d{4}-\d{2}-\d{2}\s*\d{4}-\d{2}-\d{2}.*?' )
Custom
=
True
fixed
2019-11-08 20:51:38
0
2019-11-08 20:51:38
2019-11-08 20:51:38
REGEX_Match([Field_1],'.*?\d{4}-\d{2}-\d{2}\s*\d{4}-\d{2}-\d{2}.*?' )
Field_1
ParseSimple
Field_1
Warn
Field_1_Matched
Name columns, change type and re-order
Text
If CONTAINS([_currentfield_],'-') THEN
tonumber('-'+REPLACECHAR([_currentfield_],',-',''))
ELSE
tonumber(REPLACE([_CUrrentfield_],',',''))
ENDIF
Convert numeric fields
If CONTAINS([_currentfield_],'-') THEN
tonumber('-'+REPLACECH...
[Tax Code] in('P1', 'P9')
Custom
=
Tax Code
True
fixed
2019-11-04 17:37:28
0
2019-11-04 17:37:28
2019-11-04 17:37:28
[Tax Code] in('P1', 'P9')
Horizontal
challenge_188_sjg