-- Table of mebil extensions
-- for module 
-- Lx office
DROP TABLE IF EXISTS mebil_mapping;
CREATE TABLE mebil_mapping (
	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 (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');

