X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2Fmebil.sql;h=db92f51dca63931fa24680f0cf66503b70c298e6;hb=deb4d2dbb676d7d6f69dfe7815d6e0cb09bd4a44;hp=0d8a101aa95ccba5e02b1664faf9a04dbfa3e44e;hpb=91353321a860c4aa5508f7c8cfe69d4c22f33507;p=kivitendo-erp.git diff --git a/sql/mebil.sql b/sql/mebil.sql index 0d8a101aa..db92f51dc 100644 --- a/sql/mebil.sql +++ b/sql/mebil.sql @@ -10,10 +10,89 @@ CREATE TABLE mebil_mapping ( toacc VARCHAR(200) NOT NULL ); INSERT INTO mebil_mapping (ordering,typ,fromacc,toacc) -VALUES (10,'H','8400','is.netIncome.regular.operatingTC.grossTradingProfit.totalOutput.statutoryDuties'), - (10,'S','1200','is.netIncome.regular.operatingTC.grossTradingProfit.totalOutput.netSales'), - (10,'V','1300','is.netIncome.regular.operatingTC.grossTradingProfit.totalOutput.inventoryIncrease'), - (10,'A','1400','bs.eqLiab.liab.other.thereoffSocSec'), - (20,'X','is.netIncome.regular.operatingTC.grossTradingProfit.totalOutput.statutoryDuties','is.netIncome.regular.operatingTC.grossTradingProfit.totalOutput'), - (20,'X','is.netIncome.regular.operatingTC.grossTradingProfit.totalOutput.netSales','is.netIncome.regular.operatingTC.grossTradingProfit.totalOutput'); +VALUES + (10,'S','0483','bs.ass.fixAss.tan.machinery.gwgsammelposten'), + (10,'S','0484','bs.ass.fixAss.tan.machinery.gwgsammelposten'), + (20,'X','bs.ass.fixAss.tan.machinery.gwgsammelposten','bs.ass.fixAss.tan.machinery'), + (21,'X','bs.ass.fixAss.tan.machinery','bs.ass.fixAss.tan'), + (22,'X','bs.ass.fixAss.tan','bs.ass.fixAss'), + (50,'X','bs.ass.fixAss','bs.ass'), + + (10,'S','1200','bs.ass.currAss.cashEquiv.bank'), + (20,'X','bs.ass.currAss.cashEquiv.bank','bs.ass.currAss.cashEquiv'), + (21,'X','bs.ass.currAss.cashEquiv.bank','bs.ass.currAss'), + + (10,'S','3980','bs.ass.currAss.inventory.finishedAndMerch.merchandise.new'), + (20,'X','bs.ass.currAss.inventory.finishedAndMerch.merchandise.new','bs.ass.currAss.inventory.finishedAndMerch.merchandise'), + (21,'X','bs.ass.currAss.inventory.finishedAndMerch.merchandise','bs.ass.currAss.inventory.finishedAndMerch'), + (22,'X','bs.ass.currAss.inventory.finishedAndMerch','bs.ass.currAss.inventory'), + (23,'X','bs.ass.currAss.inventory','bs.ass.currAss'), + + (10,'S','1400','bs.ass.currAss.receiv.trade'), + (20,'X','bs.ass.currAss.receiv.trade','bs.ass.currAss.receiv'), + + (10,'S','1575','bs.ass.currAss.receiv.other.vat'), + (10,'S','1576','bs.ass.currAss.receiv.other.vat'), + (10,'S','1579','bs.ass.currAss.receiv.other.vat'), + (10,'S','1780','bs.ass.currAss.receiv.other.vat'), + (20,'X','bs.ass.currAss.receiv.other.vat','bs.ass.currAss.receiv.other'), + (21,'X','bs.ass.currAss.receiv.other','bs.ass.currAss.receiv'), + (30,'X','bs.ass.currAss.receiv','bs.ass.currAss'), + + (50,'X','bs.ass.currAss','bs.ass'), + + (10,'H','0800','bs.eqLiab.equity.subscribed.corp'), + (20,'X', 'bs.eqLiab.equity.subscribed.corp','bs.eqLiab.equity.subscribed'), + (40,'X', 'bs.eqLiab.equity.subscribed', 'bs.eqLiab.equity'), + (10,'H','0810','bs.eqLiab.equity.capRes'), + (20,'X', 'bs.eqLiab.equity.capRes', 'bs.eqLiab.equity'), + (50,'X', 'bs.eqLiab.equity', 'bs.eqLiab'), + (10,'H','0970','bs.eqLiab.accruals.other.upTo1year'), + (20,'X', 'bs.eqLiab.accruals.other.upTo1year','bs.eqLiab.accruals.other'), + (21,'X', 'bs.eqLiab.accruals.other','bs.eqLiab.accruals'), + (50,'X', 'bs.eqLiab.accruals','bs.eqLiab'), + (10,'H','1775','bs.eqLiab.liab.other.theroffTax.vat'), + (10,'H','1776','bs.eqLiab.liab.other.theroffTax.vat'), + (20,'X', 'bs.eqLiab.liab.other.theroffTax.vat','bs.eqLiab.liab.other.theroffTax'), + (10,'H','1651','bs.eqLiab.liab.other.theroffTax.operatingTaxes'), + (10,'H','1652','bs.eqLiab.liab.other.theroffTax.operatingTaxes'), + (10,'H','1653','bs.eqLiab.liab.other.theroffTax.operatingTaxes'), + (20,'X', 'bs.eqLiab.liab.other.theroffTax.operatingTaxes','bs.eqLiab.liab.other.theroffTax'), + (21,'X', 'bs.eqLiab.liab.other.theroffTax','bs.eqLiab.liab.other'), + (10,'H','1606','bs.eqLiab.liab.other.profitPartLoans'), + (20,'X', 'bs.eqLiab.liab.other.profitPartLoans','bs.eqLiab.liab.other'), + (22,'X', 'bs.eqLiab.liab.other','bs.eqLiab.liab'), + (50,'X', 'bs.eqLiab.liab','bs.eqLiab'), + + (10,'S','4121','is.netIncome.regular.operatingTC.staff.salaries.managerPartner'), + (20,'X' ,'is.netIncome.regular.operatingTC.staff.salaries.managerPartner','is.netIncome.regular.operatingTC.staff.salaries'), + (21,'X' ,'is.netIncome.regular.operatingTC.staff.salaries','ismi.netIncome.staff'), + (50,'Y' ,'ismi.netIncome.staff','ismi.netIncome'), + (10,'S','3960','is.netIncome.regular.operatingTC.grossTradingProfit.materialServices.material.purchased.generalRateVAT'), + (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,'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') + ;