protokoll_2022-01.log 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287
  1. INFO:root:(10298, 11)
  2. INFO:root: Marke Standort Konto_Nr Kostenstelle Absatzkanal Kostenträger Kostenträger_Ebene Konto_Nr_Händler Konto_Nr_SKR51 Marke_HBV Standort_HBV duplicated
  3. 1991 01 01 5003 41 99 70 OP-01-5003-41-99-70 01-01-5003-41-99-70 1844 R10654 True
  4. 1999 04 01 5008 40 99 70 KI-01-5008-40-99-70 04-01-5008-40-99-70 8253 2119 True
  5. 2004 01 01 5008 41 99 70 OP-01-5008-41-99-70 01-01-5008-41-99-70 1844 R10654 True
  6. 2047 01 01 5701 42 99 70 OP-01-5701-42-99-70 01-01-5701-42-99-70 1844 R10654 True
  7. 2223 01 01 5002 41 99 70 OP-01-5002-41-99-70 01-01-5002-41-99-70 1844 R10654 True
  8. 2386 01 01 5005 41 99 70 OP-01-5005-41-99-70 01-01-5005-41-99-70 1844 R10654 True
  9. 2400 04 01 5701 41 99 70 KI-01-5701-41-99-70 04-01-5701-41-99-70 8253 2119 True
  10. 2402 04 01 5701 42 99 70 KI-01-5701-42-99-70 04-01-5701-42-99-70 8253 2119 True
  11. 2405 01 01 5701 41 99 70 OP-01-5701-41-99-70 01-01-5701-41-99-70 1844 R10654 True
  12. 2418 01 01 5801 41 99 70 OP-01-5801-41-99-70 01-01-5801-41-99-70 1844 R10654 True
  13. 3756 04 01 8410 41 10 70 KI-01-8410-41-10-70 04-01-8410-41-10-70 8253 2119 True
  14. 3758 04 01 8410 41 10 70 KI-01-8410-41-15-70 04-01-8410-41-10-70 8253 2119 True
  15. 3762 01 01 8410 41 50 70 OP-01-8410-41-50-70 01-01-8410-41-50-70 1844 R10654 True
  16. 3766 01 01 8410 44 10 70 OP-01-8410-44-10-70 01-01-8410-44-10-70 1844 R10654 True
  17. 3771 01 01 8411 41 10 70 OP-01-8411-41-10-70 01-01-8411-41-10-70 1844 R10654 True
  18. 4109 04 01 8400 41 10 70 KI-01-8400-41-10-70 04-01-8400-41-10-70 8253 2119 True
  19. 4114 04 01 8401 41 10 70 KI-01-8401-41-10-70 04-01-8401-41-10-70 8253 2119 True
  20. 4317 04 01 5002 41 99 70 KI-01-5002-41-99-70 04-01-5002-41-99-70 8253 2119 True
  21. 4326 04 01 5003 41 99 70 KI-01-5003-41-99-70 04-01-5003-41-99-70 8253 2119 True
  22. 4331 04 01 5005 41 99 70 KI-01-5005-41-99-70 04-01-5005-41-99-70 8253 2119 True
  23. 4338 04 01 5008 41 99 70 KI-01-5008-41-99-70 04-01-5008-41-99-70 8253 2119 True
  24. 4339 01 01 5008 40 99 70 OP-01-5008-40-99-70 01-01-5008-40-99-70 1844 R10654 True
  25. 4364 99 01 5701 42 99 70 ZZ-01-5701-42-99-70 99-01-5701-42-99-70 0000 01_ZZ True
  26. 4366 04 01 5801 41 99 70 KI-01-5801-41-99-70 04-01-5801-41-99-70 8253 2119 True
  27. 4637 01 01 7420 42 00 72 OP-01-7420-42-00-72 01-01-7420-42-00-72 1844 R10654 True
  28. 4772 01 01 8420 42 10 70 OP-01-8420-42-10-70 01-01-8420-42-10-70 1844 R10654 True
  29. 5041 01 01 8400 41 10 70 OP-01-8400-41-10-70 01-01-8400-41-10-70 1844 R10654 True
  30. 5043 01 01 8401 41 10 70 OP-01-8401-41-10-70 01-01-8401-41-10-70 1844 R10654 True
  31. 5044 04 01 8410 41 50 70 KI-01-8410-41-50-70 04-01-8410-41-50-70 8253 2119 True
  32. 5046 04 01 8410 44 10 70 KI-01-8410-44-10-70 04-01-8410-44-10-70 8253 2119 True
  33. 5047 04 01 8410 44 10 70 KI-01-8410-44-15-70 04-01-8410-44-10-70 8253 2119 True
  34. 5049 01 01 8410 41 10 70 OP-01-8410-41-10-70 01-01-8410-41-10-70 1844 R10654 True
  35. 5053 01 01 8410 41 91 70 OP-01-8410-41-60-70 01-01-8410-41-91-70 1844 R10654 True
  36. 5058 99 01 8410 41 10 70 ZZ-01-8410-41-10-70 99-01-8410-41-10-70 0000 01_ZZ True
  37. 5062 04 01 8411 41 10 70 KI-01-8411-41-10-70 04-01-8411-41-10-70 8253 2119 True
  38. 5108 04 01 8420 42 10 70 KI-01-8420-42-10-70 04-01-8420-42-10-70 8253 2119 True
  39. 7140 01 01 5003_STK 41 99 70 OP-01-5003_STK-41-99-70 01-01-5003_STK-41-99-70 1844 R10654 True
  40. 7148 04 01 5008_STK 40 99 70 KI-01-5008_STK-40-99-70 04-01-5008_STK-40-99-70 8253 2119 True
  41. 7153 01 01 5008_STK 41 99 70 OP-01-5008_STK-41-99-70 01-01-5008_STK-41-99-70 1844 R10654 True
  42. 7196 01 01 9143 42 99 70 OP-01-5701_STK-42-99-70 01-01-9143-42-99-70 1844 R10654 True
  43. 7372 01 01 5002_STK 41 99 70 OP-01-5002_STK-41-99-70 01-01-5002_STK-41-99-70 1844 R10654 True
  44. 7535 01 01 5005_STK 41 99 70 OP-01-5005_STK-41-99-70 01-01-5005_STK-41-99-70 1844 R10654 True
  45. 7549 04 01 9143 41 99 70 KI-01-5701_STK-41-99-70 04-01-9143-41-99-70 8253 2119 True
  46. 7551 04 01 9143 42 99 70 KI-01-5701_STK-42-99-70 04-01-9143-42-99-70 8253 2119 True
  47. 7554 01 01 9143 41 99 70 OP-01-5701_STK-41-99-70 01-01-9143-41-99-70 1844 R10654 True
  48. 7567 01 01 5801_STK 41 99 70 OP-01-5801_STK-41-99-70 01-01-5801_STK-41-99-70 1844 R10654 True
  49. 8905 04 01 9144 41 10 70 KI-01-8410_STK-41-10-70 04-01-9144-41-10-70 8253 2119 True
  50. 8907 04 01 9144 41 10 70 KI-01-8410_STK-41-15-70 04-01-9144-41-10-70 8253 2119 True
  51. 8911 01 01 9144 41 50 70 OP-01-8410_STK-41-50-70 01-01-9144-41-50-70 1844 R10654 True
  52. 8915 01 01 9144 44 10 70 OP-01-8410_STK-44-10-70 01-01-9144-44-10-70 1844 R10654 True
  53. 8920 01 01 8411_STK 41 10 70 OP-01-8411_STK-41-10-70 01-01-8411_STK-41-10-70 1844 R10654 True
  54. 9258 04 01 8400_STK 41 10 70 KI-01-8400_STK-41-10-70 04-01-8400_STK-41-10-70 8253 2119 True
  55. 9263 04 01 8401_STK 41 10 70 KI-01-8401_STK-41-10-70 04-01-8401_STK-41-10-70 8253 2119 True
  56. 9466 04 01 5002_STK 41 99 70 KI-01-5002_STK-41-99-70 04-01-5002_STK-41-99-70 8253 2119 True
  57. 9475 04 01 5003_STK 41 99 70 KI-01-5003_STK-41-99-70 04-01-5003_STK-41-99-70 8253 2119 True
  58. 9480 04 01 5005_STK 41 99 70 KI-01-5005_STK-41-99-70 04-01-5005_STK-41-99-70 8253 2119 True
  59. 9487 04 01 5008_STK 41 99 70 KI-01-5008_STK-41-99-70 04-01-5008_STK-41-99-70 8253 2119 True
  60. 9488 01 01 5008_STK 40 99 70 OP-01-5008_STK-40-99-70 01-01-5008_STK-40-99-70 1844 R10654 True
  61. 9513 99 01 9143 42 99 70 ZZ-01-5701_STK-42-99-70 99-01-9143-42-99-70 0000 01_ZZ True
  62. 9515 04 01 5801_STK 41 99 70 KI-01-5801_STK-41-99-70 04-01-5801_STK-41-99-70 8253 2119 True
  63. 9786 01 01 7420_STK 42 00 72 OP-01-7420_STK-42-00-72 01-01-7420_STK-42-00-72 1844 R10654 True
  64. 9921 01 01 8420_STK 42 10 70 OP-01-8420_STK-42-10-70 01-01-8420_STK-42-10-70 1844 R10654 True
  65. 10190 01 01 8400_STK 41 10 70 OP-01-8400_STK-41-10-70 01-01-8400_STK-41-10-70 1844 R10654 True
  66. 10192 01 01 8401_STK 41 10 70 OP-01-8401_STK-41-10-70 01-01-8401_STK-41-10-70 1844 R10654 True
  67. 10193 04 01 9144 41 50 70 KI-01-8410_STK-41-50-70 04-01-9144-41-50-70 8253 2119 True
  68. 10195 04 01 9144 44 10 70 KI-01-8410_STK-44-10-70 04-01-9144-44-10-70 8253 2119 True
  69. 10196 04 01 9144 44 10 70 KI-01-8410_STK-44-15-70 04-01-9144-44-10-70 8253 2119 True
  70. 10198 01 01 9144 41 10 70 OP-01-8410_STK-41-10-70 01-01-9144-41-10-70 1844 R10654 True
  71. 10202 01 01 9144 41 91 70 OP-01-8410_STK-41-60-70 01-01-9144-41-91-70 1844 R10654 True
  72. 10207 99 01 9144 41 10 70 ZZ-01-8410_STK-41-10-70 99-01-9144-41-10-70 0000 01_ZZ True
  73. 10211 04 01 8411_STK 41 10 70 KI-01-8411_STK-41-10-70 04-01-8411_STK-41-10-70 8253 2119 True
  74. 10257 04 01 8420_STK 42 10 70 KI-01-8420_STK-42-10-70 04-01-8420_STK-42-10-70 8253 2119 True
  75. INFO:root:Gewinn/Verlustvortrag
  76. INFO:root: amount
  77. Marke Standort
  78. 00 01 3048860.28
  79. 01 01 2471114.00
  80. 04 01 47453786.87
  81. 99 01 -50747122.93
  82. INFO:root:amount 2226638.22
  83. dtype: float64
  84. INFO:root:df_bookings: (1565, 8)
  85. INFO:root:df_combined: (1565, 18)
  86. INFO:root:df_pivot: (1517, 2)
  87. INFO:root:(1517, 9)
  88. INFO:root:Index(['Period01', 'CumulatedYear', 'Konto_Nr_SKR51', 'Marke', 'Standort',
  89. 'Konto_Nr', 'Kostenstelle', 'Absatzkanal', 'Kostenträger'],
  90. dtype='object', name='period')
  91. INFO:root:period Period01 CumulatedYear Konto_Nr_SKR51 Marke Standort Konto_Nr Kostenstelle Absatzkanal Kostenträger
  92. Konto_Nr_SKR51
  93. 00-01-1408-00-00-00 125098.82 125098.82 00-01-1408-00-00-00 00 01 1408 00 00 00
  94. 01-01-0320-26-00-06 -50.00 -50.00 01-01-0320-26-00-06 01 01 0320 26 00 06
  95. 01-01-0320-26-00-20 -80.00 -80.00 01-01-0320-26-00-20 01 01 0320 26 00 20
  96. 01-01-0320-26-00-22 -165.00 -165.00 01-01-0320-26-00-22 01 01 0320 26 00 22
  97. 01-01-0320-26-00-49 -160.00 -160.00 01-01-0320-26-00-49 01 01 0320 26 00 49
  98. INFO:root:df: (1517, 9)
  99. INFO:root:period Period01 CumulatedYear
  100. Kontoart
  101. 1 168623.11 168623.11
  102. 2 -167424.40 -167424.40
  103. 3 1198.71 1198.71
  104. INFO:root:period Period01 CumulatedYear
  105. Kontoart Konto_1
  106. 1 0 -74873.49 -74873.49
  107. 1 441639.72 441639.72
  108. 3 -198143.12 -198143.12
  109. 2 2 2446.57 2446.57
  110. 4 362463.57 362463.57
  111. 5 0.08 0.08
  112. 7 2903651.93 2903651.93
  113. 8 -3437185.26 -3437185.26
  114. 3 0 -3.00 -3.00
  115. 3 -24.00 -24.00
  116. 8 8.00 8.00
  117. 9 1217.71 1217.71
  118. INFO:root:period Period01 CumulatedYear
  119. Konto_Nr
  120. 0210 4452.90 4452.90
  121. 0300 2028.13 2028.13
  122. 0320 -1125.00 -1125.00
  123. 0322 -59839.97 -59839.97
  124. 0322_STK -3.00 -3.00
  125. 0480 1895.18 1895.18
  126. 0640 5453.85 5453.85
  127. 0965 -13286.98 -13286.98
  128. 0970 -2100.00 -2100.00
  129. 0977 -1800.00 -1800.00
  130. 0980 9842.12 9842.12
  131. 0990 -7093.72 -7093.72
  132. 0992 -13300.00 -13300.00
  133. 1000 -634.32 -634.32
  134. 1010 -4292.21 -4292.21
  135. 1200 283524.10 283524.10
  136. 1210 1602.60 1602.60
  137. 1220 1599977.92 1599977.92
  138. 1250 507320.87 507320.87
  139. 1362 -1280.69 -1280.69
  140. 1363 39.00 39.00
  141. 1400 -321898.67 -321898.67
  142. 1401 -59936.60 -59936.60
  143. 1407 -3239.38 -3239.38
  144. 1408 -383155.96 -383155.96
  145. 1571 49.89 49.89
  146. 1572 1613.63 1613.63
  147. 1576 401980.37 401980.37
  148. 1590 -188954.31 -188954.31
  149. 1591 491.80 491.80
  150. 1592 -6665.00 -6665.00
  151. 1600 -637229.50 -637229.50
  152. 1601 4000.88 4000.88
  153. 1718 -163034.78 -163034.78
  154. 1740 579.12 579.12
  155. 1741 48289.45 48289.45
  156. 1742 8143.02 8143.02
  157. 1748 0.00 0.00
  158. 1776 -619267.22 -619267.22
  159. 1779 -1613.63 -1613.63
  160. 1789 -19971.97 -19971.97
  161. 1792 -4750.00 -4750.00
  162. 1795 -48.69 -48.69
  163. 2110 1499.72 1499.72
  164. 2111 747.50 747.50
  165. 2176 200.00 200.00
  166. 2300 -0.66 -0.66
  167. 2650 0.01 0.01
  168. 3000 -803.34 -803.34
  169. 3000_STK -11.00 -11.00
  170. 3010 -235951.39 -235951.39
  171. 3010_STK -8.00 -8.00
  172. 3100 -42130.23 -42130.23
  173. 3100_STK -1.00 -1.00
  174. 3110 16874.68 16874.68
  175. 3110_STK -3.00 -3.00
  176. 3200 43.70 43.70
  177. 3210 1312.00 1312.00
  178. 3220 -4392.00 -4392.00
  179. 3220_STK -1.00 -1.00
  180. 3300 16762.03 16762.03
  181. 3420 -2235.80 -2235.80
  182. 3800 -4208.32 -4208.32
  183. 3850 56585.55 56585.55
  184. 4100 20927.31 20927.31
  185. 4110 3400.00 3400.00
  186. 4135 5187.42 5187.42
  187. 4140 2909.25 2909.25
  188. 4145 6276.04 6276.04
  189. 4200 112363.08 112363.08
  190. 4210 2667.00 2667.00
  191. 4235 4630.00 4630.00
  192. 4240 28366.78 28366.78
  193. 4245 4848.85 4848.85
  194. 4300 26970.00 26970.00
  195. 4350 2100.00 2100.00
  196. 4360 1046.96 1046.96
  197. 4400 29355.04 29355.04
  198. 4412 262.18 262.18
  199. 4413 194.64 194.64
  200. 4414 162.21 162.21
  201. 4420 159.44 159.44
  202. 4430 406.60 406.60
  203. 4431 229.95 229.95
  204. 4440 332.88 332.88
  205. 4500 11019.22 11019.22
  206. 4501 195.00 195.00
  207. 4502 1010.37 1010.37
  208. 4503 7726.46 7726.46
  209. 4570 410.16 410.16
  210. 4588 2222.11 2222.11
  211. 4620 12000.00 12000.00
  212. 4621 1125.00 1125.00
  213. 4622 11964.25 11964.25
  214. 4623 7192.85 7192.85
  215. 4630 1300.00 1300.00
  216. 4640 1691.59 1691.59
  217. 4700 2456.88 2456.88
  218. 4710 1032.08 1032.08
  219. 4715 2189.15 2189.15
  220. 4720 1214.43 1214.43
  221. 4725 800.00 800.00
  222. 4726 571.00 571.00
  223. 4730 1814.45 1814.45
  224. 4740 696.48 696.48
  225. 4770 618.10 618.10
  226. 4775 4192.00 4192.00
  227. 4780 7460.91 7460.91
  228. 4790 11379.15 11379.15
  229. 4800 17453.83 17453.83
  230. 4805 -216.19 -216.19
  231. 4830 84.33 84.33
  232. 4845 64.33 64.33
  233. 5002 7035.54 7035.54
  234. 5003 714.94 714.94
  235. 5004 3288.00 3288.00
  236. 5005 13229.07 13229.07
  237. 5009 2579.78 2579.78
  238. 5501 2497.01 2497.01
  239. 5502 -559.41 -559.41
  240. 5701 -29291.24 -29291.24
  241. 5801 506.39 506.39
  242. 7000 1153554.90 1153554.90
  243. 7010 272984.79 272984.79
  244. 7100 1167967.23 1167967.23
  245. 7110 271640.41 271640.41
  246. 7200 1176.10 1176.10
  247. 7210 2854.00 2854.00
  248. 7220 1874.37 1874.37
  249. 7300 9069.88 9069.88
  250. 7310 95120.77 95120.77
  251. 7420 18298.00 18298.00
  252. 7510 53512.16 53512.16
  253. 7800 -14099.08 -14099.08
  254. 7850 -130301.60 -130301.60
  255. 8000 -1414177.53 -1414177.53
  256. 8001 326495.30 326495.30
  257. 8010 -282547.05 -282547.05
  258. 8011 44226.72 44226.72
  259. 8030 -11090.22 -11090.22
  260. 8100 -1284762.95 -1284762.95
  261. 8110 -332836.86 -332836.86
  262. 8111 77906.86 77906.86
  263. 8112 -77906.86 -77906.86
  264. 8200 -2276.37 -2276.37
  265. 8210 -2910.81 -2910.81
  266. 8220 -1008.40 -1008.40
  267. 8300 -20832.98 -20832.98
  268. 8301 1604.41 1604.41
  269. 8310 -184561.96 -184561.96
  270. 8311 4271.06 4271.06
  271. 8400 -7592.70 -7592.70
  272. 8401 88.20 88.20
  273. 8410 -103945.89 -103945.89
  274. 8411 4913.42 4913.42
  275. 8420 -50226.14 -50226.14
  276. 8500 -585.00 -585.00
  277. 8510 -57014.70 -57014.70
  278. 8520 -19438.38 -19438.38
  279. 8520_STK 5.00 5.00
  280. 8870 -41503.87 -41503.87
  281. 8870_STK 3.00 3.00
  282. 8916 -1472.56 -1472.56
  283. 8999 0.00 0.00
  284. 9130 160.00 160.00
  285. 9143 170.44 170.44
  286. 9144 887.27 887.27
  287. INFO:root:(1126, 21)