API tools faq
paste
Advertisement
Guest User

Untitled

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