2 -- @description: mebil-DB
5 -- Table of mebil extensions
8 DROP TABLE IF EXISTS mebil_mapping;
9 CREATE TABLE mebil_mapping (
10 id SERIAL PRIMARY KEY,
11 ordering INTEGER NOT NULL,
13 fromacc VARCHAR(200) NOT NULL,
14 toacc VARCHAR(200) NOT NULL
16 INSERT INTO mebil_mapping (ordering,typ,fromacc,toacc)
18 (10,'S','0483','bs.ass.fixAss.tan.machinery.gwgsammelposten'),
19 (10,'S','0484','bs.ass.fixAss.tan.machinery.gwgsammelposten'),
20 (20,'X','bs.ass.fixAss.tan.machinery.gwgsammelposten','bs.ass.fixAss.tan.machinery'),
21 (21,'X','bs.ass.fixAss.tan.machinery','bs.ass.fixAss.tan'),
22 (22,'X','bs.ass.fixAss.tan','bs.ass.fixAss'),
23 (50,'X','bs.ass.fixAss','bs.ass'),
25 (10,'S','1200','bs.ass.currAss.cashEquiv.bank'),
26 (20,'X','bs.ass.currAss.cashEquiv.bank','bs.ass.currAss.cashEquiv'),
27 (21,'X','bs.ass.currAss.cashEquiv.bank','bs.ass.currAss'),
29 (10,'S','3980','bs.ass.currAss.inventory.finishedAndMerch.merchandise.new'),
30 (20,'X','bs.ass.currAss.inventory.finishedAndMerch.merchandise.new','bs.ass.currAss.inventory.finishedAndMerch.merchandise'),
31 (21,'X','bs.ass.currAss.inventory.finishedAndMerch.merchandise','bs.ass.currAss.inventory.finishedAndMerch'),
32 (22,'X','bs.ass.currAss.inventory.finishedAndMerch','bs.ass.currAss.inventory'),
33 (23,'X','bs.ass.currAss.inventory','bs.ass.currAss'),
35 (10,'S','1400','bs.ass.currAss.receiv.trade'),
36 (20,'X','bs.ass.currAss.receiv.trade','bs.ass.currAss.receiv'),
38 (10,'S','1575','bs.ass.currAss.receiv.other.vat'),
39 (10,'S','1576','bs.ass.currAss.receiv.other.vat'),
40 (10,'S','1579','bs.ass.currAss.receiv.other.vat'),
41 (10,'S','1780','bs.ass.currAss.receiv.other.vat'),
42 (20,'X','bs.ass.currAss.receiv.other.vat','bs.ass.currAss.receiv.other'),
43 (21,'X','bs.ass.currAss.receiv.other','bs.ass.currAss.receiv'),
44 (30,'X','bs.ass.currAss.receiv','bs.ass.currAss'),
46 (50,'X','bs.ass.currAss','bs.ass'),
48 (10,'H','0800','bs.eqLiab.equity.subscribed.corp'),
49 (20,'X', 'bs.eqLiab.equity.subscribed.corp','bs.eqLiab.equity.subscribed'),
50 (40,'X', 'bs.eqLiab.equity.subscribed', 'bs.eqLiab.equity'),
51 (10,'H','0810','bs.eqLiab.equity.capRes'),
52 (20,'X', 'bs.eqLiab.equity.capRes', 'bs.eqLiab.equity'),
53 (50,'X', 'bs.eqLiab.equity', 'bs.eqLiab'),
54 (10,'H','0970','bs.eqLiab.accruals.other.upTo1year'),
55 (20,'X', 'bs.eqLiab.accruals.other.upTo1year','bs.eqLiab.accruals.other'),
56 (21,'X', 'bs.eqLiab.accruals.other','bs.eqLiab.accruals'),
57 (50,'X', 'bs.eqLiab.accruals','bs.eqLiab'),
58 (10,'H','1775','bs.eqLiab.liab.other.theroffTax.vat'),
59 (10,'H','1776','bs.eqLiab.liab.other.theroffTax.vat'),
60 (20,'X', 'bs.eqLiab.liab.other.theroffTax.vat','bs.eqLiab.liab.other.theroffTax'),
61 (10,'H','1651','bs.eqLiab.liab.other.theroffTax.operatingTaxes'),
62 (10,'H','1652','bs.eqLiab.liab.other.theroffTax.operatingTaxes'),
63 (10,'H','1653','bs.eqLiab.liab.other.theroffTax.operatingTaxes'),
64 (20,'X', 'bs.eqLiab.liab.other.theroffTax.operatingTaxes','bs.eqLiab.liab.other.theroffTax'),
65 (21,'X', 'bs.eqLiab.liab.other.theroffTax','bs.eqLiab.liab.other'),
66 (10,'H','1606','bs.eqLiab.liab.other.profitPartLoans'),
67 (20,'X', 'bs.eqLiab.liab.other.profitPartLoans','bs.eqLiab.liab.other'),
68 (22,'X', 'bs.eqLiab.liab.other','bs.eqLiab.liab'),
69 (50,'X', 'bs.eqLiab.liab','bs.eqLiab'),
71 (10,'S','4121','is.netIncome.regular.operatingTC.staff.salaries.managerPartner'),
72 (20,'X' ,'is.netIncome.regular.operatingTC.staff.salaries.managerPartner','is.netIncome.regular.operatingTC.staff.salaries'),
73 (21,'X' ,'is.netIncome.regular.operatingTC.staff.salaries','ismi.netIncome.staff'),
74 (50,'Y' ,'ismi.netIncome.staff','ismi.netIncome'),
75 (10,'S','3960','is.netIncome.regular.operatingTC.grossTradingProfit.materialServices.material.purchased.generalRateVAT'),
76 (20,'X', 'is.netIncome.regular.operatingTC.grossTradingProfit.materialServices.material.purchased.generalRateVAT','is.netIncome.regular.operatingTC.grossTradingProfit.materialServices.material.purchased'),
77 (21,'X', 'is.netIncome.regular.operatingTC.grossTradingProfit.materialServices.material.purchased','is.netIncome.regular.operatingTC.grossTradingProfit.materialServices.material'),
78 (22,'X', 'is.netIncome.regular.operatingTC.grossTradingProfit.materialServices.material','ismi.netIncome.materialServices'),
79 (50,'Y', 'ismi.netIncome.materialServices','ismi.netIncome'),
81 (50,'X','bs.ass.fixAss.tan.machinery.gwgsammelposten','all'),
82 (10,'R','ACC=0482:START=2016:VALUES=negative','grossCost.beginning'),
83 (10,'R','ACC=0484:START=2017:VALUES=negative','grossCost.beginning'),
84 (50,'X','grossCost.beginning','gross'),
85 (50,'X','gross.addition','gross'),
86 (10,'R','ACC=0483:START=YEAR:VALUES=negative','gross.addition'),
87 (52,'X','grossCost.beginning','accDepr'),
88 (52,'X','gross.addition','accDepr'),
89 (52,'Y','all','accDepr'),
90 (50,'X','grossCost.beginning','accDepr.beginning'),
91 (50,'Y','all_Prev_period','accDepr.beginning'),
92 (50,'X','all_Prev_period','accDepr.DeprPeriod'),
93 (50,'X','gross.addition','accDepr.DeprPeriod'),
94 (50,'Y','all','accDepr.DeprPeriod'),
95 (60,'X','accDepr.DeprPeriod','accDepr.DeprPeriod.regular'),
96 (10,'R','ACC=0482:END=PY:INVERT=true','all_Prev_period'),
97 (10,'R','ACC=0483:END=PY:INVERT=true','all_Prev_period'),
98 (10,'R','ACC=0484:END=PY:INVERT=true','all_Prev_period'),
100 (0,'C','de-gaap-ci.bsAss','hbst.transfer.bsAss.name')