sql/Pg-upgrade2/mebil_v1.sql

   1 -- @tag: mebil_v1
   2 -- @description: mebil-DB
   3 -- @depends:
   4
   5 -- Table of mebil extensions
   6 -- for module
   7 -- Lx office
   8 DROP TABLE IF EXISTS mebil_mapping;
   9 CREATE TABLE mebil_mapping (
  10         id                      SERIAL PRIMARY KEY,
  11         ordering        INTEGER NOT NULL,
  12         typ                     CHAR NOT NULL,
  13         fromacc         VARCHAR(200) NOT NULL,
  14         toacc           VARCHAR(200) NOT NULL
  15 );
  16 INSERT INTO mebil_mapping (ordering,typ,fromacc,toacc)
  17 VALUES
  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'),
  24
  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'),
  28
  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'),
  34
  35         (10,'S','1400','bs.ass.currAss.receiv.trade'),
  36         (20,'X','bs.ass.currAss.receiv.trade','bs.ass.currAss.receiv'),
  37
  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'),
  45
  46         (50,'X','bs.ass.currAss','bs.ass'),
  47
  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'),
  70
  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'),
  80
  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'),
  99
 100         (0,'C','de-gaap-ci.bsAss','hbst.transfer.bsAss.name')
 101         ;
 102