X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/91353321a860c4aa5508f7c8cfe69d4c22f33507..bfb17b7159a61d45bf41897860e8813331f528ff:/sql/mebil.sql?ds=inline

diff --git a/sql/mebil.sql b/sql/mebil.sql
index 0d8a101aa..cb9229dee 100644
--- a/sql/mebil.sql
+++ b/sql/mebil.sql
@@ -10,10 +10,68 @@ 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')
+	
+	;