tnLTGZuL

1-- pg_00_sol.common.sql created at 2017-04-21 16:06:59
2
3DROP TABLE IF EXISTS sol_accounting_costcenter;
4CREATE TABLE sol_accounting_costcenter (company_code CHARACTER VARYING(20) NOT NULL, no CHARACTER VARYING(20) NOT NULL, name CHARACTER VARYING(100) NOT NULL, PRIMARY KEY (company_code, no));
5
6DROP TABLE IF EXISTS sol_accounting_costobject;
7CREATE TABLE sol_accounting_costobject (company_code CHARACTER VARYING(20) NOT NULL, no CHARACTER VARYING(20) NOT NULL, name CHARACTER VARYING(100) NOT NULL, PRIMARY KEY (company_code, no));
8
9DROP TABLE IF EXISTS sol_accounting_gl_account;
10CREATE TABLE sol_accounting_gl_account (company_code CHARACTER VARYING(20) NOT NULL, no CHARACTER VARYING(20) NOT NULL, name CHARACTER VARYING(100) NOT NULL, PRIMARY KEY (company_code, no));
11
12DROP TABLE IF EXISTS sol_common_fx;
13CREATE TABLE sol_common_fx (currency_code CHARACTER VARYING(20) NOT NULL, currency_exchange_rate CHARACTER VARYING(10) NOT NULL, currency_symbol CHARACTER VARYING(10) NULL, currency_description CHARACTER VARYING(50) NULL, time CHARACTER VARYING(14) NOT NULL, PRIMARY KEY (currency_code));
14
15DROP TABLE IF EXISTS sol_company;
16CREATE TABLE sol_company (code CHARACTER VARYING(20) NOT NULL, name CHARACTER VARYING(150) NULL, street CHARACTER VARYING(150) NULL, zipcode CHARACTER VARYING(20) NULL, city CHARACTER VARYING(50) NULL, country_code CHARACTER VARYING(50) NULL, gln CHARACTER VARYING(15) NULL, PRIMARY KEY (code));
17
18DROP TABLE IF EXISTS sol_invoice_item;
19CREATE TABLE sol_invoice_item (company_code CHARACTER VARYING(20) NOT NULL, no CHARACTER VARYING(20) NOT NULL, description CHARACTER VARYING(150) NOT NULL, unit_name CHARACTER VARYING(50) NULL, unit_price NUMERIC(18,4) NULL, cost_center_no CHARACTER VARYING(50) NULL, cost_object_no CHARACTER VARYING(50) NULL, gl_account_no CHARACTER VARYING(50) NULL, vendor_no CHARACTER VARYING(50) NULL, PRIMARY KEY (company_code, no));
20
21DROP TABLE IF EXISTS sol_invoice_po_line;
22CREATE TABLE sol_invoice_po_line (company_code CHARACTER VARYING(20) NOT NULL, vendor_no CHARACTER VARYING(20) NOT NULL, purchase_order_no CHARACTER VARYING(20) NOT NULL, line_no CHARACTER VARYING(20) NOT NULL, item_no CHARACTER VARYING(20) NULL, item_description CHARACTER VARYING(150) NULL, cost_center_no CHARACTER VARYING(20) NULL, cost_object_no CHARACTER VARYING(20) NULL, gl_account_no CHARACTER VARYING(20) NULL, quantity INTEGER NULL, quantity_unit CHARACTER VARYING(5) NULL, unit_price NUMERIC(18,4) NULL, discount NUMERIC(18,4) NULL, line_amount NUMERIC(18,4) NULL, currency_code CHARACTER VARYING(5) NULL, delivery_note_no CHARACTER VARYING(10) NULL, delivery_note_date DATE NULL, received INTEGER NOT NULL, PRIMARY KEY (company_code, vendor_no, purchase_order_no, line_no));
23
24DROP TABLE IF EXISTS sol_project;
25CREATE TABLE sol_project (company_code CHARACTER VARYING(20) NOT NULL, no CHARACTER VARYING(20) NOT NULL, name CHARACTER VARYING(100) NULL, PRIMARY KEY (company_code, no));
26
27DROP TABLE IF EXISTS sol_trade_charge;
28CREATE TABLE sol_trade_charge (code CHARACTER VARYING(10) NOT NULL, language CHARACTER VARYING(10) NOT NULL, description CHARACTER VARYING(100) NULL, docxfield CHARACTER VARYING(50) NULL, PRIMARY KEY (code, language));
29
30DROP TABLE IF EXISTS sol_units;
31CREATE TABLE sol_units (code CHARACTER VARYING(10) NOT NULL, language CHARACTER VARYING(10) NOT NULL, description CHARACTER VARYING(100) NULL, symbol CHARACTER VARYING(20) NULL, PRIMARY KEY (code, language));
32
33DROP TABLE IF EXISTS sol_vat_rates;
34CREATE TABLE sol_vat_rates (country CHARACTER VARYING(20) NOT NULL, start_date DATE NOT NULL, vat_rates CHARACTER VARYING(100) NOT NULL, PRIMARY KEY (country, start_date, vat_rates));
35
36DROP TABLE IF EXISTS sol_vendor;
37CREATE TABLE sol_vendor (company_code CHARACTER VARYING(20) NOT NULL, no CHARACTER VARYING(20) NOT NULL, name CHARACTER VARYING(100) NULL, street CHARACTER VARYING(150) NULL, zipcode CHARACTER VARYING(10) NULL, city CHARACTER VARYING(50) NULL, iban CHARACTER VARYING(100) NULL, bic CHARACTER VARYING(20) NULL, country_code CHARACTER VARYING(10) NULL, vat_id CHARACTER VARYING(30) NULL, due_days INTEGER NULL, tax_no CHARACTER VARYING(30) NULL, gln CHARACTER VARYING(15) NULL, PRIMARY KEY (company_code, no));
38
39DROP TABLE IF EXISTS sol_vendor_terms_of_payment;
40CREATE TABLE sol_vendor_terms_of_payment (company_code CHARACTER VARYING(20) NOT NULL, vendor_no CHARACTER VARYING(10) NOT NULL, cash_discount_days INTEGER NOT NULL, cash_discount_rate NUMERIC(18,4) NOT NULL, PRIMARY KEY (company_code, vendor_no, cash_discount_days));
41
42INSERT INTO sol_common_fx (currency_code, currency_exchange_rate, currency_symbol, currency_description, time) VALUES ('AUD', '1.5301', '$', 'Australian dollar', '20151103000000');
43INSERT INTO sol_common_fx (currency_code, currency_exchange_rate, currency_symbol, currency_description, time) VALUES ('BG', '1.9558', 'лв', 'Bulgarian lev', '20151103000000');
44INSERT INTO sol_common_fx (currency_code, currency_exchange_rate, currency_symbol, currency_description, time) VALUES ('BRL', '4.1813', 'R$', 'Brasilian real', '20151103000000');
45INSERT INTO sol_common_fx (currency_code, currency_exchange_rate, currency_symbol, currency_description, time) VALUES ('CAD', '1.4406', '$', 'Canadian dollar', '20151103000000');
46INSERT INTO sol_common_fx (currency_code, currency_exchange_rate, currency_symbol, currency_description, time) VALUES ('CHF', '1.0869', 'CHF', 'Swiss franc', '20151103000000');
47INSERT INTO sol_common_fx (currency_code, currency_exchange_rate, currency_symbol, currency_description, time) VALUES ('CNY', '6.9545', 'Â¥', 'Chinese yuan renminbi', '20151103000000');
48INSERT INTO sol_common_fx (currency_code, currency_exchange_rate, currency_symbol, currency_description, time) VALUES ('CZK', '27.100', 'Kč', 'Czech koruna', '20151103000000');
49INSERT INTO sol_common_fx (currency_code, currency_exchange_rate, currency_symbol, currency_description, time) VALUES ('DKK', '7.4587', 'kr', 'Danish krone', '20151103000000');
50INSERT INTO sol_common_fx (currency_code, currency_exchange_rate, currency_symbol, currency_description, time) VALUES ('EUR', '1', '€', 'Euro', '20151103000000');
51INSERT INTO sol_common_fx (currency_code, currency_exchange_rate, currency_symbol, currency_description, time) VALUES ('GBP', '0.71315', '£', 'Pound sterling', '20151103000000');
52INSERT INTO sol_common_fx (currency_code, currency_exchange_rate, currency_symbol, currency_description, time) VALUES ('HKD', '8.5065', '$', 'Hong Kong dollar', '20151103000000');
53INSERT INTO sol_common_fx (currency_code, currency_exchange_rate, currency_symbol, currency_description, time) VALUES ('HRK', '7.5860', 'k', 'Croatian kuna', '20151103000000');
54INSERT INTO sol_common_fx (currency_code, currency_exchange_rate, currency_symbol, currency_description, time) VALUES ('HUF', '313.48', 'Ft', 'Hungarian forint', '20151103000000');
55INSERT INTO sol_common_fx (currency_code, currency_exchange_rate, currency_symbol, currency_description, time) VALUES ('IDR', '14936.68', 'Rp', 'Indonesian rupiah', '20151103000000');
56INSERT INTO sol_common_fx (currency_code, currency_exchange_rate, currency_symbol, currency_description, time) VALUES ('ILS', '4.2544', '₪', 'Israeli shekel', '20151103000000');
57INSERT INTO sol_common_fx (currency_code, currency_exchange_rate, currency_symbol, currency_description, time) VALUES ('INR', '72.1429', 'INR', 'Indian rupee', '20151103000000');
58INSERT INTO sol_common_fx (currency_code, currency_exchange_rate, currency_symbol, currency_description, time) VALUES ('JPY', '132.65', 'Â¥', 'Japanese ye', '20151103000000');
59INSERT INTO sol_common_fx (currency_code, currency_exchange_rate, currency_symbol, currency_description, time) VALUES ('KRW', '1245.49', 'â‚©', 'South Korean wo', '20151103000000');
60INSERT INTO sol_common_fx (currency_code, currency_exchange_rate, currency_symbol, currency_description, time) VALUES ('MX', '18.1848', '$', 'Mexican peso', '20151103000000');
61INSERT INTO sol_common_fx (currency_code, currency_exchange_rate, currency_symbol, currency_description, time) VALUES ('MYR', '4.7104', 'RM', 'Malaysian ringgit', '20151103000000');
62INSERT INTO sol_common_fx (currency_code, currency_exchange_rate, currency_symbol, currency_description, time) VALUES ('NOK', '9.3410', 'kr', 'Norwegian krone', '20151103000000');
63INSERT INTO sol_common_fx (currency_code, currency_exchange_rate, currency_symbol, currency_description, time) VALUES ('NZD', '1.6364', '$', 'New Zealand dollar', '20151103000000');
64INSERT INTO sol_common_fx (currency_code, currency_exchange_rate, currency_symbol, currency_description, time) VALUES ('PHP', '51.495', '₱', 'Philippine peso', '20151103000000');
65INSERT INTO sol_common_fx (currency_code, currency_exchange_rate, currency_symbol, currency_description, time) VALUES ('PL', '4.2540', 'zł', 'Polish zloty', '20151103000000');
66INSERT INTO sol_common_fx (currency_code, currency_exchange_rate, currency_symbol, currency_description, time) VALUES ('RO', '4.4345', 'kr', 'Romanian leu', '20151103000000');
67INSERT INTO sol_common_fx (currency_code, currency_exchange_rate, currency_symbol, currency_description, time) VALUES ('RUB', '69.5445', 'руб', 'Russian rouble', '20151103000000');
68INSERT INTO sol_common_fx (currency_code, currency_exchange_rate, currency_symbol, currency_description, time) VALUES ('SEK', '9.3935', 'kr', 'Swedish krona', '20151103000000');
69INSERT INTO sol_common_fx (currency_code, currency_exchange_rate, currency_symbol, currency_description, time) VALUES ('SGD', '1.5363', '$', 'Singapore dollar', '20151103000000');
70INSERT INTO sol_common_fx (currency_code, currency_exchange_rate, currency_symbol, currency_description, time) VALUES ('THB', '39.048', '฿', 'Thai baht', '20151103000000');
71INSERT INTO sol_common_fx (currency_code, currency_exchange_rate, currency_symbol, currency_description, time) VALUES ('TRY', '3.1222', 'TRY', 'Turkish lira', '20151103000000');
72INSERT INTO sol_common_fx (currency_code, currency_exchange_rate, currency_symbol, currency_description, time) VALUES ('USD', '1.0976', '$', 'US dollar', '20151103000000');
73INSERT INTO sol_common_fx (currency_code, currency_exchange_rate, currency_symbol, currency_description, time) VALUES ('ZAR', '15.2542', 'R', 'South African rand', '20151103000000');
74
75INSERT INTO sol_trade_charge (code, language, description, docxfield) VALUES ('AA', 'DE', 'Werbekostenzuschuß', '');
76INSERT INTO sol_trade_charge (code, language, description, docxfield) VALUES ('AA', 'EN', 'Advertising allowance', '');
77INSERT INTO sol_trade_charge (code, language, description, docxfield) VALUES ('AAA', 'DE', 'Telekommunikationsgebühren', '');
78INSERT INTO sol_trade_charge (code, language, description, docxfield) VALUES ('AAA', 'EN', 'Telecommunication charges', '');
79INSERT INTO sol_trade_charge (code, language, description, docxfield) VALUES ('AAB', 'DE', 'Warenrücksendung', '');
80INSERT INTO sol_trade_charge (code, language, description, docxfield) VALUES ('AAB', 'EN', 'Returned goods charges', '');
81INSERT INTO sol_trade_charge (code, language, description, docxfield) VALUES ('AAC', 'DE', 'Anpassungskoste', '');
82INSERT INTO sol_trade_charge (code, language, description, docxfield) VALUES ('AAC', 'EN', 'Modification costs', '');
83INSERT INTO sol_trade_charge (code, language, description, docxfield) VALUES ('AAH', 'DE', 'Abwicklungskosten', '');
84INSERT INTO sol_trade_charge (code, language, description, docxfield) VALUES ('AAH', 'EN', 'Processing surcharge', '');
85INSERT INTO sol_trade_charge (code, language, description, docxfield) VALUES ('AAT', 'DE', 'Schnelle Lieferung', '');
86INSERT INTO sol_trade_charge (code, language, description, docxfield) VALUES ('AAT', 'EN', 'Rush delivery', '');
87INSERT INTO sol_trade_charge (code, language, description, docxfield) VALUES ('ABK', 'DE', 'Sonstige Koste', 'INV_SPECIAL_CHARGE');
88INSERT INTO sol_trade_charge (code, language, description, docxfield) VALUES ('ABK', 'EN', 'Miscellaneous Charge', 'INV_SPECIAL_CHARGE');
89INSERT INTO sol_trade_charge (code, language, description, docxfield) VALUES ('ABW', 'DE', 'Zoll', 'INV_CUSTOMS_CHARGE');
90INSERT INTO sol_trade_charge (code, language, description, docxfield) VALUES ('ABW', 'EN', 'Customs duty charge', 'INV_CUSTOMS_CHARGE');
91INSERT INTO sol_trade_charge (code, language, description, docxfield) VALUES ('ADR', 'DE', 'Andere Dienste', '');
92INSERT INTO sol_trade_charge (code, language, description, docxfield) VALUES ('ADR', 'EN', 'Other services', '');
93INSERT INTO sol_trade_charge (code, language, description, docxfield) VALUES ('AEO', 'DE', 'Sammel- und Recylingservice', '');
94INSERT INTO sol_trade_charge (code, language, description, docxfield) VALUES ('AEO', 'EN', 'Collection and recycling service', '');
95INSERT INTO sol_trade_charge (code, language, description, docxfield) VALUES ('AJ', 'DE', 'Anpassungsgebühr', '');
96INSERT INTO sol_trade_charge (code, language, description, docxfield) VALUES ('AJ', 'EN', 'Adjustments', '');
97INSERT INTO sol_trade_charge (code, language, description, docxfield) VALUES ('FC', 'DE', 'Frachtkoste', '');
98INSERT INTO sol_trade_charge (code, language, description, docxfield) VALUES ('FC', 'EN', 'Freight charge', '');
99INSERT INTO sol_trade_charge (code, language, description, docxfield) VALUES ('IAA', 'DE', 'Installatio', '');
100INSERT INTO sol_trade_charge (code, language, description, docxfield) VALUES ('IAA', 'EN', 'Installatio', '');
101INSERT INTO sol_trade_charge (code, language, description, docxfield) VALUES ('I', 'DE', 'Versicherung', 'INV_INSURANCE_CHARGE');
102INSERT INTO sol_trade_charge (code, language, description, docxfield) VALUES ('I', 'EN', 'Insurance', 'INV_INSURANCE_CHARGE');
103INSERT INTO sol_trade_charge (code, language, description, docxfield) VALUES ('MAC', 'DE', 'Mindermengenzuschlag', 'INV_SMALL_VOL_CHARGE');
104INSERT INTO sol_trade_charge (code, language, description, docxfield) VALUES ('MAC', 'EN', 'Minimum order/minimum billing charge', 'INV_SMALL_VOL_CHARGE');
105INSERT INTO sol_trade_charge (code, language, description, docxfield) VALUES ('NAA', 'DE', 'Einwegbehälter', '');
106INSERT INTO sol_trade_charge (code, language, description, docxfield) VALUES ('NAA', 'EN', 'Non-returnable containers', '');
107INSERT INTO sol_trade_charge (code, language, description, docxfield) VALUES ('PAB', 'DE', 'Portokoste', 'INV_POSTAL_CHARGE');
108INSERT INTO sol_trade_charge (code, language, description, docxfield) VALUES ('PAB', 'EN', 'Postage charge', 'INV_POSTAL_CHARGE');
109INSERT INTO sol_trade_charge (code, language, description, docxfield) VALUES ('PC', 'DE', 'Verpacke', 'INV_PACKING_CHARGE');
110INSERT INTO sol_trade_charge (code, language, description, docxfield) VALUES ('PC', 'EN', 'Packing', 'INV_PACKING_CHARGE');
111INSERT INTO sol_trade_charge (code, language, description, docxfield) VALUES ('RAA', 'DE', 'Rückvergütung', '');
112INSERT INTO sol_trade_charge (code, language, description, docxfield) VALUES ('RAA', 'EN', 'Rebate', '');
113INSERT INTO sol_trade_charge (code, language, description, docxfield) VALUES ('SC', 'DE', 'Sonstiger Aufschlag', '');
114INSERT INTO sol_trade_charge (code, language, description, docxfield) VALUES ('SC', 'EN', 'Surcharge', '');
115
116INSERT INTO sol_units (code, language, description, symbol) VALUES ('C62', 'DE', 'Eins (Stück)', 'Stk.');
117INSERT INTO sol_units (code, language, description, symbol) VALUES ('C62', 'EN', 'One (Unit)', 'Unit');
118INSERT INTO sol_units (code, language, description, symbol) VALUES ('DAY', 'DE', 'Tag', 'Tag(e)');
119INSERT INTO sol_units (code, language, description, symbol) VALUES ('DAY', 'EN', 'Day', 'Day(s)');
120INSERT INTO sol_units (code, language, description, symbol) VALUES ('HAR', 'DE', 'Hektar', 'ha');
121INSERT INTO sol_units (code, language, description, symbol) VALUES ('HAR', 'EN', 'hectare', 'ha');
122INSERT INTO sol_units (code, language, description, symbol) VALUES ('HUR', 'DE', 'Stunde', 'Std.');
123INSERT INTO sol_units (code, language, description, symbol) VALUES ('HUR', 'EN', 'Hour', 'h');
124INSERT INTO sol_units (code, language, description, symbol) VALUES ('KGM', 'DE', 'Kilogramm', 'kg');
125INSERT INTO sol_units (code, language, description, symbol) VALUES ('KGM', 'EN', 'kilogram', 'kg');
126INSERT INTO sol_units (code, language, description, symbol) VALUES ('KTM', 'DE', 'Kilometer', 'km');
127INSERT INTO sol_units (code, language, description, symbol) VALUES ('KTM', 'EN', 'kilometre', 'km');
128INSERT INTO sol_units (code, language, description, symbol) VALUES ('KWH', 'DE', 'Kilowattstunde', 'kWh');
129INSERT INTO sol_units (code, language, description, symbol) VALUES ('KWH', 'EN', 'kilowatt hour', 'kWh');
130INSERT INTO sol_units (code, language, description, symbol) VALUES ('LS', 'DE', 'Pauschale', 'pausch.');
131INSERT INTO sol_units (code, language, description, symbol) VALUES ('LS', 'EN', 'lump sum', 'lump s.');
132INSERT INTO sol_units (code, language, description, symbol) VALUES ('LTR', 'DE', 'Liter', 'l');
133INSERT INTO sol_units (code, language, description, symbol) VALUES ('LTR', 'EN', 'litre', 'l');
134INSERT INTO sol_units (code, language, description, symbol) VALUES ('MI', 'DE', 'Minute', 'mi');
135INSERT INTO sol_units (code, language, description, symbol) VALUES ('MI', 'EN', 'minute', 'mi');
136INSERT INTO sol_units (code, language, description, symbol) VALUES ('MMK', 'DE', 'Quadratmillimeter', 'mm²');
137INSERT INTO sol_units (code, language, description, symbol) VALUES ('MMK', 'EN', 'square millimetre', 'mm²');
138INSERT INTO sol_units (code, language, description, symbol) VALUES ('MMT', 'DE', 'Millimeter', 'mm');
139INSERT INTO sol_units (code, language, description, symbol) VALUES ('MMT', 'EN', 'millimetre', 'mm');
140INSERT INTO sol_units (code, language, description, symbol) VALUES ('MTK', 'DE', 'Quadratmeter', 'm²');
141INSERT INTO sol_units (code, language, description, symbol) VALUES ('MTK', 'EN', 'square meter', 'm²');
142INSERT INTO sol_units (code, language, description, symbol) VALUES ('MTQ', 'DE', 'Kubikmeter', 'm³');
143INSERT INTO sol_units (code, language, description, symbol) VALUES ('MTQ', 'EN', 'cubic metre', 'm³');
144INSERT INTO sol_units (code, language, description, symbol) VALUES ('MTR', 'DE', 'Meter', 'm');
145INSERT INTO sol_units (code, language, description, symbol) VALUES ('MTR', 'EN', 'metre', 'm');
146INSERT INTO sol_units (code, language, description, symbol) VALUES ('NAR', 'DE', 'Anzahl Artikel', 'Anz.');
147INSERT INTO sol_units (code, language, description, symbol) VALUES ('NAR', 'EN', 'number of articles', 'art.');
148INSERT INTO sol_units (code, language, description, symbol) VALUES ('NPR', 'DE', 'Anzahl Paare', 'Pr.');
149INSERT INTO sol_units (code, language, description, symbol) VALUES ('NPR', 'EN', 'number of pairs', 'prs.');
150INSERT INTO sol_units (code, language, description, symbol) VALUES ('P1', 'DE', 'Prozent', '%');
151INSERT INTO sol_units (code, language, description, symbol) VALUES ('P1', 'EN', 'percent', '%');
152INSERT INTO sol_units (code, language, description, symbol) VALUES ('SET', 'DE', 'Set', 'Set(s)');
153INSERT INTO sol_units (code, language, description, symbol) VALUES ('SET', 'EN', 'Set', 'set(s)');
154INSERT INTO sol_units (code, language, description, symbol) VALUES ('TNE', 'DE', 'Tonne', 't');
155INSERT INTO sol_units (code, language, description, symbol) VALUES ('TNE', 'EN', 'tonne', 't');
156INSERT INTO sol_units (code, language, description, symbol) VALUES ('WEE', 'DE', 'Woche', 'Woche(n)');
157INSERT INTO sol_units (code, language, description, symbol) VALUES ('WEE', 'EN', 'week', 'wk');
158
159INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('AT', '2008-01-01', '20;12;10');
160INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('BE', '2008-01-01', '21;12;6');
161INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('BG', '2008-01-01', '20;7');
162INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('BG', '2011-04-01', '20;9');
163INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('CH', '2008-01-01', '7.6;3.6;2.4');
164INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('CH', '2011-01-01', '8;3.8;2.5');
165INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('CY', '2008-01-01', '15;8;5');
166INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('CZ', '2008-01-01', '19;5');
167INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('CZ', '2012-01-01', '20;14');
168INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('DE', '2008-01-01', '19;7;10.7');
169INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('DK', '2008-01-01', '25');
170INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('EE', '2008-01-01', '18;5');
171INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('EE', '2009-07-01', '20;9');
172INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('EL', '2008-01-01', '19;9;4.5');
173INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('EL', '2011-01-01', '23;13;6.5');
174INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('ES', '2008-01-01', '16;7;4');
175INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('ES', '2010-07-01', '18;8;4');
176INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('ES', '2012-09-01', '21;10;4');
177INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('FI', '2008-01-01', '22;17;8');
178INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('FI', '2010-07-01', '23;13;9');
179INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('FR', '2008-01-01', '19.6;5.5;2.1');
180INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('FR', '2012-04-01', '19.6;7;5.5;2.1');
181INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('HU', '2008-01-01', '20;5');
182INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('HU', '2012-01-01', '27;18;5');
183INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('IE', '2008-01-01', '21;13.5;4.8');
184INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('IE', '2012-01-01', '23;13.5;9;4.8');
185INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('IT', '2008-01-01', '20;10;4');
186INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('IT', '2011-09-17', '21;10;4');
187INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('LT', '2008-01-01', '18;9;5');
188INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('LT', '2012-01-01', '21;9;5');
189INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('LU', '2008-01-01', '15;12;6;3');
190INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('LV', '2008-01-01', '18;5');
191INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('LV', '2012-01-01', '21;12');
192INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('ME', '2008-01-01', '17;7');
193INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('ME', '2012-01-01', '17;8');
194INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('MT', '2008-01-01', '18;5');
195INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('MT', '2011-01-01', '18;7;5');
196INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('NL', '2008-01-01', '19;6');
197INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('NL', '2012-10-01', '21;6');
198INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('NO', '2008-01-01', '23;11.11');
199INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('NO', '2011-01-01', '25;11;7');
200INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('PL', '2008-01-01', '22;7;3');
201INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('PL', '2011-01-01', '23;8;5');
202INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('PT', '2008-01-01', '21;12;5');
203INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('PT', '2011-01-01', '23;13;6');
204INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('RU', '2008-01-01', '18;10');
205INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('RO', '2008-01-01', '19;9');
206INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('RO', '2010-07-01', '24;9;5');
207INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('RS', '2008-01-01', '18;8');
208INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('RS', '2011-01-01', '20;8');
209INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('SE', '2008-01-01', '25;12;6');
210INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('SI', '2008-01-01', '20;8.5');
211INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('SK', '2008-01-01', '19;10');
212INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('SK', '2011-01-01', '20;10');
213INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('UK', '2008-01-01', '17.5;5');
214INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('UK', '2008-12-01', '15;5');
215INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('UK', '2010-01-01', '17.5;5');
216INSERT INTO sol_vat_rates (country, start_date, vat_rates) VALUES ('UK', '2011-01-04', '20;5');