| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287 |
- INFO:root:(10298, 11)
- 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
- 1991 01 01 5003 41 99 70 OP-01-5003-41-99-70 01-01-5003-41-99-70 1844 R10654 True
- 1999 04 01 5008 40 99 70 KI-01-5008-40-99-70 04-01-5008-40-99-70 8253 2119 True
- 2004 01 01 5008 41 99 70 OP-01-5008-41-99-70 01-01-5008-41-99-70 1844 R10654 True
- 2047 01 01 5701 42 99 70 OP-01-5701-42-99-70 01-01-5701-42-99-70 1844 R10654 True
- 2223 01 01 5002 41 99 70 OP-01-5002-41-99-70 01-01-5002-41-99-70 1844 R10654 True
- 2386 01 01 5005 41 99 70 OP-01-5005-41-99-70 01-01-5005-41-99-70 1844 R10654 True
- 2400 04 01 5701 41 99 70 KI-01-5701-41-99-70 04-01-5701-41-99-70 8253 2119 True
- 2402 04 01 5701 42 99 70 KI-01-5701-42-99-70 04-01-5701-42-99-70 8253 2119 True
- 2405 01 01 5701 41 99 70 OP-01-5701-41-99-70 01-01-5701-41-99-70 1844 R10654 True
- 2418 01 01 5801 41 99 70 OP-01-5801-41-99-70 01-01-5801-41-99-70 1844 R10654 True
- 3756 04 01 8410 41 10 70 KI-01-8410-41-10-70 04-01-8410-41-10-70 8253 2119 True
- 3758 04 01 8410 41 10 70 KI-01-8410-41-15-70 04-01-8410-41-10-70 8253 2119 True
- 3762 01 01 8410 41 50 70 OP-01-8410-41-50-70 01-01-8410-41-50-70 1844 R10654 True
- 3766 01 01 8410 44 10 70 OP-01-8410-44-10-70 01-01-8410-44-10-70 1844 R10654 True
- 3771 01 01 8411 41 10 70 OP-01-8411-41-10-70 01-01-8411-41-10-70 1844 R10654 True
- 4109 04 01 8400 41 10 70 KI-01-8400-41-10-70 04-01-8400-41-10-70 8253 2119 True
- 4114 04 01 8401 41 10 70 KI-01-8401-41-10-70 04-01-8401-41-10-70 8253 2119 True
- 4317 04 01 5002 41 99 70 KI-01-5002-41-99-70 04-01-5002-41-99-70 8253 2119 True
- 4326 04 01 5003 41 99 70 KI-01-5003-41-99-70 04-01-5003-41-99-70 8253 2119 True
- 4331 04 01 5005 41 99 70 KI-01-5005-41-99-70 04-01-5005-41-99-70 8253 2119 True
- 4338 04 01 5008 41 99 70 KI-01-5008-41-99-70 04-01-5008-41-99-70 8253 2119 True
- 4339 01 01 5008 40 99 70 OP-01-5008-40-99-70 01-01-5008-40-99-70 1844 R10654 True
- 4364 99 01 5701 42 99 70 ZZ-01-5701-42-99-70 99-01-5701-42-99-70 0000 01_ZZ True
- 4366 04 01 5801 41 99 70 KI-01-5801-41-99-70 04-01-5801-41-99-70 8253 2119 True
- 4637 01 01 7420 42 00 72 OP-01-7420-42-00-72 01-01-7420-42-00-72 1844 R10654 True
- 4772 01 01 8420 42 10 70 OP-01-8420-42-10-70 01-01-8420-42-10-70 1844 R10654 True
- 5041 01 01 8400 41 10 70 OP-01-8400-41-10-70 01-01-8400-41-10-70 1844 R10654 True
- 5043 01 01 8401 41 10 70 OP-01-8401-41-10-70 01-01-8401-41-10-70 1844 R10654 True
- 5044 04 01 8410 41 50 70 KI-01-8410-41-50-70 04-01-8410-41-50-70 8253 2119 True
- 5046 04 01 8410 44 10 70 KI-01-8410-44-10-70 04-01-8410-44-10-70 8253 2119 True
- 5047 04 01 8410 44 10 70 KI-01-8410-44-15-70 04-01-8410-44-10-70 8253 2119 True
- 5049 01 01 8410 41 10 70 OP-01-8410-41-10-70 01-01-8410-41-10-70 1844 R10654 True
- 5053 01 01 8410 41 91 70 OP-01-8410-41-60-70 01-01-8410-41-91-70 1844 R10654 True
- 5058 99 01 8410 41 10 70 ZZ-01-8410-41-10-70 99-01-8410-41-10-70 0000 01_ZZ True
- 5062 04 01 8411 41 10 70 KI-01-8411-41-10-70 04-01-8411-41-10-70 8253 2119 True
- 5108 04 01 8420 42 10 70 KI-01-8420-42-10-70 04-01-8420-42-10-70 8253 2119 True
- 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
- 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
- 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
- 7196 01 01 9143 42 99 70 OP-01-5701_STK-42-99-70 01-01-9143-42-99-70 1844 R10654 True
- 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
- 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
- 7549 04 01 9143 41 99 70 KI-01-5701_STK-41-99-70 04-01-9143-41-99-70 8253 2119 True
- 7551 04 01 9143 42 99 70 KI-01-5701_STK-42-99-70 04-01-9143-42-99-70 8253 2119 True
- 7554 01 01 9143 41 99 70 OP-01-5701_STK-41-99-70 01-01-9143-41-99-70 1844 R10654 True
- 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
- 8905 04 01 9144 41 10 70 KI-01-8410_STK-41-10-70 04-01-9144-41-10-70 8253 2119 True
- 8907 04 01 9144 41 10 70 KI-01-8410_STK-41-15-70 04-01-9144-41-10-70 8253 2119 True
- 8911 01 01 9144 41 50 70 OP-01-8410_STK-41-50-70 01-01-9144-41-50-70 1844 R10654 True
- 8915 01 01 9144 44 10 70 OP-01-8410_STK-44-10-70 01-01-9144-44-10-70 1844 R10654 True
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 9513 99 01 9143 42 99 70 ZZ-01-5701_STK-42-99-70 99-01-9143-42-99-70 0000 01_ZZ True
- 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
- 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
- 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
- 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
- 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
- 10193 04 01 9144 41 50 70 KI-01-8410_STK-41-50-70 04-01-9144-41-50-70 8253 2119 True
- 10195 04 01 9144 44 10 70 KI-01-8410_STK-44-10-70 04-01-9144-44-10-70 8253 2119 True
- 10196 04 01 9144 44 10 70 KI-01-8410_STK-44-15-70 04-01-9144-44-10-70 8253 2119 True
- 10198 01 01 9144 41 10 70 OP-01-8410_STK-41-10-70 01-01-9144-41-10-70 1844 R10654 True
- 10202 01 01 9144 41 91 70 OP-01-8410_STK-41-60-70 01-01-9144-41-91-70 1844 R10654 True
- 10207 99 01 9144 41 10 70 ZZ-01-8410_STK-41-10-70 99-01-9144-41-10-70 0000 01_ZZ True
- 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
- 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
- INFO:root:Gewinn/Verlustvortrag
- INFO:root: amount
- Marke Standort
- 00 01 3048860.28
- 01 01 2471114.00
- 04 01 47453786.87
- 99 01 -50747122.93
- INFO:root:amount 2226638.22
- dtype: float64
- INFO:root:df_bookings: (1565, 8)
- INFO:root:df_combined: (1565, 18)
- INFO:root:df_pivot: (1517, 2)
- INFO:root:(1517, 9)
- INFO:root:Index(['Period01', 'CumulatedYear', 'Konto_Nr_SKR51', 'Marke', 'Standort',
- 'Konto_Nr', 'Kostenstelle', 'Absatzkanal', 'Kostenträger'],
- dtype='object', name='period')
- INFO:root:period Period01 CumulatedYear Konto_Nr_SKR51 Marke Standort Konto_Nr Kostenstelle Absatzkanal Kostenträger
- Konto_Nr_SKR51
- 00-01-1408-00-00-00 125098.82 125098.82 00-01-1408-00-00-00 00 01 1408 00 00 00
- 01-01-0320-26-00-06 -50.00 -50.00 01-01-0320-26-00-06 01 01 0320 26 00 06
- 01-01-0320-26-00-20 -80.00 -80.00 01-01-0320-26-00-20 01 01 0320 26 00 20
- 01-01-0320-26-00-22 -165.00 -165.00 01-01-0320-26-00-22 01 01 0320 26 00 22
- 01-01-0320-26-00-49 -160.00 -160.00 01-01-0320-26-00-49 01 01 0320 26 00 49
- INFO:root:df: (1517, 9)
- INFO:root:period Period01 CumulatedYear
- Kontoart
- 1 168623.11 168623.11
- 2 -167424.40 -167424.40
- 3 1198.71 1198.71
- INFO:root:period Period01 CumulatedYear
- Kontoart Konto_1
- 1 0 -74873.49 -74873.49
- 1 441639.72 441639.72
- 3 -198143.12 -198143.12
- 2 2 2446.57 2446.57
- 4 362463.57 362463.57
- 5 0.08 0.08
- 7 2903651.93 2903651.93
- 8 -3437185.26 -3437185.26
- 3 0 -3.00 -3.00
- 3 -24.00 -24.00
- 8 8.00 8.00
- 9 1217.71 1217.71
- INFO:root:period Period01 CumulatedYear
- Konto_Nr
- 0210 4452.90 4452.90
- 0300 2028.13 2028.13
- 0320 -1125.00 -1125.00
- 0322 -59839.97 -59839.97
- 0322_STK -3.00 -3.00
- 0480 1895.18 1895.18
- 0640 5453.85 5453.85
- 0965 -13286.98 -13286.98
- 0970 -2100.00 -2100.00
- 0977 -1800.00 -1800.00
- 0980 9842.12 9842.12
- 0990 -7093.72 -7093.72
- 0992 -13300.00 -13300.00
- 1000 -634.32 -634.32
- 1010 -4292.21 -4292.21
- 1200 283524.10 283524.10
- 1210 1602.60 1602.60
- 1220 1599977.92 1599977.92
- 1250 507320.87 507320.87
- 1362 -1280.69 -1280.69
- 1363 39.00 39.00
- 1400 -321898.67 -321898.67
- 1401 -59936.60 -59936.60
- 1407 -3239.38 -3239.38
- 1408 -383155.96 -383155.96
- 1571 49.89 49.89
- 1572 1613.63 1613.63
- 1576 401980.37 401980.37
- 1590 -188954.31 -188954.31
- 1591 491.80 491.80
- 1592 -6665.00 -6665.00
- 1600 -637229.50 -637229.50
- 1601 4000.88 4000.88
- 1718 -163034.78 -163034.78
- 1740 579.12 579.12
- 1741 48289.45 48289.45
- 1742 8143.02 8143.02
- 1748 0.00 0.00
- 1776 -619267.22 -619267.22
- 1779 -1613.63 -1613.63
- 1789 -19971.97 -19971.97
- 1792 -4750.00 -4750.00
- 1795 -48.69 -48.69
- 2110 1499.72 1499.72
- 2111 747.50 747.50
- 2176 200.00 200.00
- 2300 -0.66 -0.66
- 2650 0.01 0.01
- 3000 -803.34 -803.34
- 3000_STK -11.00 -11.00
- 3010 -235951.39 -235951.39
- 3010_STK -8.00 -8.00
- 3100 -42130.23 -42130.23
- 3100_STK -1.00 -1.00
- 3110 16874.68 16874.68
- 3110_STK -3.00 -3.00
- 3200 43.70 43.70
- 3210 1312.00 1312.00
- 3220 -4392.00 -4392.00
- 3220_STK -1.00 -1.00
- 3300 16762.03 16762.03
- 3420 -2235.80 -2235.80
- 3800 -4208.32 -4208.32
- 3850 56585.55 56585.55
- 4100 20927.31 20927.31
- 4110 3400.00 3400.00
- 4135 5187.42 5187.42
- 4140 2909.25 2909.25
- 4145 6276.04 6276.04
- 4200 112363.08 112363.08
- 4210 2667.00 2667.00
- 4235 4630.00 4630.00
- 4240 28366.78 28366.78
- 4245 4848.85 4848.85
- 4300 26970.00 26970.00
- 4350 2100.00 2100.00
- 4360 1046.96 1046.96
- 4400 29355.04 29355.04
- 4412 262.18 262.18
- 4413 194.64 194.64
- 4414 162.21 162.21
- 4420 159.44 159.44
- 4430 406.60 406.60
- 4431 229.95 229.95
- 4440 332.88 332.88
- 4500 11019.22 11019.22
- 4501 195.00 195.00
- 4502 1010.37 1010.37
- 4503 7726.46 7726.46
- 4570 410.16 410.16
- 4588 2222.11 2222.11
- 4620 12000.00 12000.00
- 4621 1125.00 1125.00
- 4622 11964.25 11964.25
- 4623 7192.85 7192.85
- 4630 1300.00 1300.00
- 4640 1691.59 1691.59
- 4700 2456.88 2456.88
- 4710 1032.08 1032.08
- 4715 2189.15 2189.15
- 4720 1214.43 1214.43
- 4725 800.00 800.00
- 4726 571.00 571.00
- 4730 1814.45 1814.45
- 4740 696.48 696.48
- 4770 618.10 618.10
- 4775 4192.00 4192.00
- 4780 7460.91 7460.91
- 4790 11379.15 11379.15
- 4800 17453.83 17453.83
- 4805 -216.19 -216.19
- 4830 84.33 84.33
- 4845 64.33 64.33
- 5002 7035.54 7035.54
- 5003 714.94 714.94
- 5004 3288.00 3288.00
- 5005 13229.07 13229.07
- 5009 2579.78 2579.78
- 5501 2497.01 2497.01
- 5502 -559.41 -559.41
- 5701 -29291.24 -29291.24
- 5801 506.39 506.39
- 7000 1153554.90 1153554.90
- 7010 272984.79 272984.79
- 7100 1167967.23 1167967.23
- 7110 271640.41 271640.41
- 7200 1176.10 1176.10
- 7210 2854.00 2854.00
- 7220 1874.37 1874.37
- 7300 9069.88 9069.88
- 7310 95120.77 95120.77
- 7420 18298.00 18298.00
- 7510 53512.16 53512.16
- 7800 -14099.08 -14099.08
- 7850 -130301.60 -130301.60
- 8000 -1414177.53 -1414177.53
- 8001 326495.30 326495.30
- 8010 -282547.05 -282547.05
- 8011 44226.72 44226.72
- 8030 -11090.22 -11090.22
- 8100 -1284762.95 -1284762.95
- 8110 -332836.86 -332836.86
- 8111 77906.86 77906.86
- 8112 -77906.86 -77906.86
- 8200 -2276.37 -2276.37
- 8210 -2910.81 -2910.81
- 8220 -1008.40 -1008.40
- 8300 -20832.98 -20832.98
- 8301 1604.41 1604.41
- 8310 -184561.96 -184561.96
- 8311 4271.06 4271.06
- 8400 -7592.70 -7592.70
- 8401 88.20 88.20
- 8410 -103945.89 -103945.89
- 8411 4913.42 4913.42
- 8420 -50226.14 -50226.14
- 8500 -585.00 -585.00
- 8510 -57014.70 -57014.70
- 8520 -19438.38 -19438.38
- 8520_STK 5.00 5.00
- 8870 -41503.87 -41503.87
- 8870_STK 3.00 3.00
- 8916 -1472.56 -1472.56
- 8999 0.00 0.00
- 9130 160.00 160.00
- 9143 170.44 170.44
- 9144 887.27 887.27
- INFO:root:(1126, 21)
|
