X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2Fmebil.sql;h=db92f51dca63931fa24680f0cf66503b70c298e6;hb=deb4d2dbb676d7d6f69dfe7815d6e0cb09bd4a44;hp=cb9229dee454adc3f01a6430acfefe8c7ab2bd32;hpb=bfb17b7159a61d45bf41897860e8813331f528ff;p=kivitendo-erp.git diff --git a/sql/mebil.sql b/sql/mebil.sql index cb9229dee..db92f51dc 100644 --- a/sql/mebil.sql +++ b/sql/mebil.sql @@ -72,6 +72,27 @@ VALUES (20,'X', 'is.netIncome.regular.operatingTC.grossTradingProfit.materialServices.material.purchased.generalRateVAT','is.netIncome.regular.operatingTC.grossTradingProfit.materialServices.material.purchased'), (21,'X', 'is.netIncome.regular.operatingTC.grossTradingProfit.materialServices.material.purchased','is.netIncome.regular.operatingTC.grossTradingProfit.materialServices.material'), (22,'X', 'is.netIncome.regular.operatingTC.grossTradingProfit.materialServices.material','ismi.netIncome.materialServices'), - (50,'Y', 'ismi.netIncome.materialServices','ismi.netIncome') + (50,'Y', 'ismi.netIncome.materialServices','ismi.netIncome'), + (50,'X','bs.ass.fixAss.tan.machinery.gwgsammelposten','all'), + (10,'R','ACC=0482:START=2016:VALUES=negative','grossCost.beginning'), + (10,'R','ACC=0484:START=2017:VALUES=negative','grossCost.beginning'), + (50,'X','grossCost.beginning','gross'), + (50,'X','gross.addition','gross'), + (10,'R','ACC=0483:START=YEAR:VALUES=negative','gross.addition'), + (52,'X','grossCost.beginning','accDepr'), + (52,'X','gross.addition','accDepr'), + (52,'Y','all','accDepr'), + (50,'X','grossCost.beginning','accDepr.beginning'), + (50,'Y','all_Prev_period','accDepr.beginning'), + (50,'X','all_Prev_period','accDepr.DeprPeriod'), + (50,'X','gross.addition','accDepr.DeprPeriod'), + (50,'Y','all','accDepr.DeprPeriod'), + (60,'X','accDepr.DeprPeriod','accDepr.DeprPeriod.regular'), + (10,'R','ACC=0482:END=PY:INVERT=true','all_Prev_period'), + (10,'R','ACC=0483:END=PY:INVERT=true','all_Prev_period'), + (10,'R','ACC=0484:END=PY:INVERT=true','all_Prev_period'), + + (0,'C','de-gaap-ci.bsAss','hbst.transfer.bsAss.name') ; +