epic-ts

[mfinanz.git] / sql / mebil.sql

diff --git a/sql/mebil.sql b/sql/mebil.sql
index 8badc9b94a279375f9de54046ef79f5cf7630295..0d8a101aa95ccba5e02b1664faf9a04dbfa3e44e 100644 (file)
--- a/sql/mebil.sql
+++ b/sql/mebil.sql
@@ -3,9 +3,17 @@
 -- Lx office
 DROP TABLE IF EXISTS mebil_mapping;
 CREATE TABLE mebil_mapping (
-       id      integer NOT NULL,
-       chart_id        integer NOT NULL,
-       xbrl_tag VARCHAR(200) NOT NULL
+       id                      SERIAL PRIMARY KEY,
+       ordering        INTEGER NOT NULL,
+       typ                     CHAR NOT NULL,
+       fromacc         VARCHAR(200) NOT NULL,
+       toacc           VARCHAR(200) NOT NULL
 );
-INSERT INTO mebil_mapping VALUES (1,1,'acc.trans.global');
+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');