sql/mebil.sql

   1 -- Table of mebil extensions
   2 -- for module
   3 -- Lx office
   4 DROP TABLE IF EXISTS mebil_mapping;
   5 CREATE TABLE mebil_mapping (
   6         id                      SERIAL PRIMARY KEY,
   7         ordering        INTEGER NOT NULL,
   8         typ                     CHAR NOT NULL,
   9         fromacc         VARCHAR(200) NOT NULL,
  10         toacc           VARCHAR(200) NOT NULL
  11 );
  12 INSERT INTO mebil_mapping (ordering,typ,fromacc,toacc)
  13 VALUES (10,'H','8400','is.netIncome.regular.operatingTC.grossTradingProfit.totalOutput.statutoryDuties'),
  14        (10,'S','1200','is.netIncome.regular.operatingTC.grossTradingProfit.totalOutput.netSales'),
  15        (10,'V','1300','is.netIncome.regular.operatingTC.grossTradingProfit.totalOutput.inventoryIncrease'),
  16        (10,'A','1400','bs.eqLiab.liab.other.thereoffSocSec'),
  17        (20,'X','is.netIncome.regular.operatingTC.grossTradingProfit.totalOutput.statutoryDuties','is.netIncome.regular.operatingTC.grossTradingProfit.totalOutput'),
  18        (20,'X','is.netIncome.regular.operatingTC.grossTradingProfit.totalOutput.netSales','is.netIncome.regular.operatingTC.grossTradingProfit.totalOutput');
  19