summaryrefslogtreecommitdiff
path: root/sql/Sweden_Church_Society-chart.sql
blob: 4cee4378d85c64dd828c5e9419149fba0a25c5f1 (plain)
  1. -- Johan Hambraeus
  2. -- May 7, 2006
  3. --
  4. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1','Tillg�ngar','H','','','');
  5. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('10','Immateriella anl�ggningstillg�ngar','H','','','');
  6. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1010','Balanserade utgifter','A','','A','');
  7. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1019','Ack avskriningar balanserade utg','A','','C','');
  8. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1060','Hyresr�tt','A','','A','');
  9. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1069','Ack avskrivn hyresr�tt','A','','C','');
  10. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('11','Byggnader och mark','H','','A','');
  11. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1110','Byggnader','A','','A','IC');
  12. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1119','Ack avskrivn byggnader','A','','C','');
  13. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1130','Mark','A','','A','IC');
  14. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1140','Tomter, markomr obebyggda','A','','A','IC');
  15. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1150','Markanl�ggningar','A','','A','IC');
  16. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1159','Ack avskrivn markanl�ggn','A','','C','');
  17. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1190','�vriga byggnader och mark','A','','A','IC');
  18. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('12','Maskiner och inventarier','H','','A','');
  19. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1230','Installationer','A','','A','IC');
  20. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1238','Ack nedskrivn installationer','A','','C','');
  21. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1239','Ack avskrivn installationer','A','','C','');
  22. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1250','Datorer','A','','A','IC');
  23. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1259','Ack avskrivn datorer','A','','C','');
  24. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('13','Finansiella anl�ggningstillg�ngar','H','','A','');
  25. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1370','Uppskjuten skattefordran','A','','A','');
  26. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1380','L�ngfristiga fordringar','A','','A','');
  27. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1400','Fordran hos EFS Gafsele','A','','A','');
  28. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1405','Fordran hos EFS H�lla','A','','A','');
  29. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('15','Kundfordringar','H','','A','');
  30. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1500','Kundfordringar','A','','A','AR');
  31. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('16','�vriga kortfristiga fordringar','H','','A','');
  32. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1600','�vr kortfristiga fordr','A','','A','');
  33. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1710','F�rutbetalda hyror','A','','A','');
  34. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1730','F�rutbet f�rs�kringspremier','A','','A','');
  35. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1740','F�rutbet r�nteutgifter','A','','A','');
  36. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1750','Upplupna hyresinkomster','A','','A','');
  37. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1760','Upplupna inkomstr�ntor','A','','A','');
  38. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1790','�vr interimsfordringar','A','','A','');
  39. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('19','Kassa och Bank','H','','A','');
  40. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1910','Kassa','A','','A','AR_paid:AP_paid');
  41. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1920','Postgiro','A','','A','AR_paid:AP_paid');
  42. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1930','Checkr�kningskonto','A','','A','AR_paid:AP_paid');
  43. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1940','�vriga bankkonto','A','','A','AR_paid:AP_paid');
  44. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1941','Nordea v�rdepappersfond','A','','A','');
  45. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1942','Nordea girokapitalkonto','A','','A','AR_paid:AP_paid');
  46. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2','Eget kapital och skulder','H','','A','');
  47. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('20','Eget kapital','H','','A','');
  48. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2000','Eget kapital EFS �sele','A','','Q','');
  49. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2005','Eget kapital EFS Gafsele','A','','Q','');
  50. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2010','Eget kapital EFS H�lla','A','','Q','');
  51. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2070','�ndam�lsbest�mda medel','A','','Q','');
  52. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2091','Balanserad vinst/f�rlust','A','','Q','');
  53. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2098','Vinst/f�rlust f�reg �r','A','','Q','');
  54. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2099','Redovisat resultat','A','','Q','');
  55. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('22','Avs�ttningar','H','','L','');
  56. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2250','Avs�ttning f�r skatter','A','','L','');
  57. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2290','�vriga avs�ttningar','A','','L','');
  58. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('23','Skulder','H','','L','');
  59. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2300','Skuld till EFS Gafsele','A','','L','');
  60. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2310','Skuld till EFS H�lla','A','','L','');
  61. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2320','Skuld till fam Norlin','A','','L','');
  62. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2330','Checkr�kningskredit','A','','L','');
  63. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2399','�vr l�ngfristiga skulder','A','','L','');
  64. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2440','Leverant�rsskulder','A','','L','AP');
  65. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2499','�vr kortfristiga skulder','A','','L','');
  66. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2960','Upplupna utgiftsr�ntor','A','','L','');
  67. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2971','F�rutbetalda hyresint�kter','A','','L','');
  68. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2972','F�rutbetalda medlemsavgifter','A','','L','');
  69. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2979','�vriga f�rutbetalda int�kter','A','','L','');
  70. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2990','�vr interimsskulder','A','','L','');
  71. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2999','�vr uppl kostn/f�rutbet int�kter','A','','L','');
  72. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3','Int�kter','H','','I','');
  73. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('30','Allm�nna g�vor','H','','I','');
  74. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3000','G�vor via konto','A','','I','AR_amount');
  75. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3005','Minnesg�vor','A','','I','AR_amount');
  76. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3010','Gudstj�nstkollekter','A','','I','AR_amount');
  77. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3015','Fika/kaffe/fester - g�vor','A','','I','AR_amount');
  78. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('31','�ronm�rkta g�vor','H','','I','');
  79. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3100','�ronm�rkta g�vor','A','','I','AR_amount');
  80. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3101','G�vor barnarbete','A','','I','AR_amount');
  81. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3102','G�vor k�rs�ng','A','','I','AR_amount');
  82. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3103','G�vor b�negrupper','A','','I','AR_amount');
  83. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3104','G�vor Alfa-grupper','A','','I','AR_amount');
  84. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3105','�vrigt lokalt arbete','A','','I','AR_amount');
  85. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3106','G�vor till fastighet mm','A','','I','AR_amount');
  86. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3109','G�vor �sele allkristna gemenskap','A','','I','AR_amount');
  87. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3110','G�vor EFS V�sterbotten','A','','I','AR_amount');
  88. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3111','G�vor distriktskonferens','A','','I','AR_amount');
  89. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3112','G�vor Scoutverksamhet','A','','I','AR_amount');
  90. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3120','G�vor EFS riks','A','','I','AR_amount');
  91. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3121','G�vor EFS riks konferens','A','','I','AR_amount');
  92. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3122','G�vor EFS Inre mission','A','','I','AR_amount');
  93. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3123','G�vor EFS Yttre mission','A','','I','AR_amount');
  94. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3130','G�vor Barn i alla l�nder','A','','I','AR_amount');
  95. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3131','G�vor Johannelundsinsamling','A','','I','AR_amount');
  96. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3132','G�vor P�skinsamling','A','','I','AR_amount');
  97. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3133','G�vor Flodv�gens offer','A','','I','AR_amount');
  98. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('33','F�rs�ljningsint�kter','H','','I','');
  99. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3300','F�rs�ljning bokbordet','A','','I','IC_sale');
  100. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3350','F�rs�ljning fika mm','A','','I','IC_sale');
  101. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('34','Medlemsavgifter','H','','I','');
  102. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3400','Medlemsavgifter','A','','I','IC_income');
  103. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3405','Medlemsavgifter Solglimten','A','','I','IC_income');
  104. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('345','Hyresint�kter','H','','I','');
  105. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3450','Hyresint�kter, hyreskontrakt','A','','I','IC_income');
  106. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3460','Hyresint�kter, enstaka tillf�lle','A','','I','IC_income');
  107. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3470','Hyresint Ers�ttning telefonkostnad','A','','I','IC_income');
  108. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('35','Bidrag','H','','I','');
  109. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3510','Erh�llna statliga bidrag','A','','I','AR_amount');
  110. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3520','Erh�llna kommunala bidrag','A','','I','AR_amount');
  111. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3530','Bidrag Svenska kyrkan','A','','I','AR_amount');
  112. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3590','�vriga erh�llna bidrag','A','','I','AR_amount');
  113. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('36','�vriga int�kter','H','','I','');
  114. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3690','�vriga sidoint�ker','A','','I','');
  115. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3731','Kassarabatter','A','','I','');
  116. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3740','�resutj�mning','A','','I','');
  117. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3960','Valuta kursvinst','A','','I','');
  118. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3972','Vinst avyttr fastigheter','A','','I','');
  119. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3973','Vinst avyttr maskiner/inv','A','','I','');
  120. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3990','�vr ers�ttn och int�ker','A','','I','');
  121. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3994','F�rs�kringsers�ttningar','A','','I','');
  122. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4','Utgifter','H','','E','');
  123. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4000','Kostnad f�r predikant','A','','E','AP_amount');
  124. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4050','Reskostnader f�r predikant','A','','E','AP_amount');
  125. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('41','Utgifter �ronm�rkta g�vor','H','','E','');
  126. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4100','Kostnad �ronm�rkta g�vor','A','','E','AP_amount');
  127. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4101','Kostnad barnarbete','A','','E','AP_amount');
  128. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4102','Kostnad k�rer','A','','E','AP_amount');
  129. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4103','Kostnad b�negrupper','A','','E','AP_amount');
  130. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4104','Kostnad Alfa','A','','E','AP_amount');
  131. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4105','Kostnad �vrigt lokalt arbete','A','','E','AP_amount');
  132. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4106','Kostnad Fastighet (s�rskilt)','A','','E','AP_amount');
  133. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4107','Kostnad scouting barnarbete','A','','E','AP_amount');
  134. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4109','�sele allkristna gemenskap','A','','E','AP_amount');
  135. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4110','EFS V�sterbotten','A','','E','AP_amount');
  136. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4111','distriktskonferens','A','','E','AP_amount');
  137. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4120','EFS riks','A','','E','AP_amount');
  138. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4121','EFS riks konferensinsamling','A','','E','AP_amount');
  139. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4122','EFS inre mission','A','','E','AP_amount');
  140. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4123','EFS yttre mission','A','','E','AP_amount');
  141. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4130','Barn i alla l�nder','A','','E','AP_amount');
  142. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4131','Johannelundinsamling','A','','E','AP_amount');
  143. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4132','P�skinsamling','A','','E','AP_amount');
  144. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4133','Till Flodv�gens offer','A','','E','AP_amount');
  145. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('43','Ink�pskostnader mm','H','','E','');
  146. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4300','Ink�p bokbord','A','','E','IC_cogs');
  147. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4350','Ink�p matr fika mm','A','','E','IC_cogs');
  148. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4400','Pren V�rt budskap (distr tidning)','A','','E','IC_expense');
  149. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4600','Inhyrda predikanter/f�rel�sare','A','','E','AP_amount');
  150. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4700','Tidningar, facklitteratur','A','','E','IC_expense');
  151. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4900','F�reningsavgifter','A','','E','IC_expense');
  152. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('50','Lokalkostnader hyrd lokal','H','','E','');
  153. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5010','Lokalhyra','A','','E','');
  154. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5020','El','A','','E','');
  155. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5030','V�rme hyrd lokal','A','','E','');
  156. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5050','Lokaltillbeh�r hyrd lokal','A','','E','');
  157. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5060','St�dning, renh�llning hyrd lokal','A','','E','');
  158. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5070','Reparationer hyrd lokal','A','','E','');
  159. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5090','�vr kostnader hyrd lokal','A','','E','');
  160. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('51','Lokalkostnader egen lokal','H','','E','');
  161. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5120','Belysning','A','','E','');
  162. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5130','V�rme','A','','E','');
  163. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5132','Sotning','A','','E','');
  164. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5140','Vatten och avlopp','A','','E','');
  165. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5160','Renh�lln och st�dning','A','','E','');
  166. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5170','Rep och underh�ll fastighet','A','','E','');
  167. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5191','Fastighetsskatt','A','','E','');
  168. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5192','F�rs�kringsprem fastighet','A','','E','');
  169. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5193','Fastighetssk�tsel och f�rvaltning','A','','E','');
  170. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5199','�vr fastighetskostnader','A','','E','');
  171. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('52','�vriga kostnader','H','','E','');
  172. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5210','Hyra arbetsmaskiner','A','','E','');
  173. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5220','Hyra inventarier','A','','E','');
  174. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5290','�vr hyreskostn anl tillg','A','','E','');
  175. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5390','�vriga br�nslen','A','','E','');
  176. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5410','F�rbrukningsinventarier','A','','E','');
  177. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5460','F�rbrukningsmaterial','A','','E','');
  178. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5480','Arbetskl�der o skyddsmtrl','A','','E','');
  179. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5500','Reparation och underh�ll','A','','E','');
  180. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5710','Frakt och transport','A','','E','');
  181. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5800','Resekostnader','A','','E','');
  182. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5910','Annonsering','A','','E','');
  183. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5930','Reklamtrycksaker','A','','E','');
  184. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5990','�vrig reklam','A','','E','');
  185. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6110','Kontorsmaterial','A','','E','');
  186. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6150','Trycksaker','A','','E','');
  187. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6210','Telefon','A','','E','');
  188. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6250','Porto','A','','E','');
  189. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6310','F�rs�kringar','A','','E','');
  190. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6320','Sj�lvrisker','A','','E','');
  191. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6340','L�mnade skadest�nd','A','','E','');
  192. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('64','F�rvaltningskostnader','H','','E','');
  193. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6490','�vr f�rvaltningskostnader','A','','E','');
  194. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6530','Redovisningstj�nster','A','','E','');
  195. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6540','IT-tj�nster','A','','E','');
  196. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6550','Konsultarvoden','A','','E','');
  197. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('65','Bankkostnader','H','','E','');
  198. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6570','Bankkostnader, Nordea','A','','E','');
  199. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6571','Bankkostnader, Postgirot','A','','E','');
  200. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6572','Bankkostnader, Bankgiro','A','','E','');
  201. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6573','Bankkostnader, F�reningssparbank','A','','E','');
  202. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('658','Fr�mmande tj�nster','H','','E','');
  203. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6580','Advokatkostnader','A','','E','');
  204. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6590','�vr fr�mmande tj�nster','A','','E','');
  205. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7','Avskrivningar och eng�ngskostn','H','','E','');
  206. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7780','Avskrivningar enligt plan','A','','E','');
  207. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7811','Avskrivningar balanserade utgifter','A','','E','');
  208. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7820','Avskrivningar byggnader/mark','A','','E','');
  209. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7821','Avskrivn byggnader','A','','E','');
  210. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7822','Avskrivn byggnadsinv','A','','E','');
  211. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7824','Avskrivn markanl�ggn','A','','E','');
  212. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7829','Avskrivningar �vr byggnader','A','','E','');
  213. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7832','Avskrivn inventarier','A','','E','');
  214. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7833','Avskrivningar installationer','A','','E','');
  215. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7835','Avskrivningar datorer','A','','E','');
  216. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7921','Kostn av eng�ngskarakt�r ','A','','E','');
  217. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7960','Valutakursf�rlust','A','','E','');
  218. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8','Financiella int�kter o kostnader','H','','E','');
  219. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('83','R�nteint�kter','H','','I','');
  220. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8300','R�nteint�kter ','A','','I','');
  221. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8390','�vr finansiella int�kter','A','','I','');
  222. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('84','R�ntekostnader','H','','E','');
  223. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8400','R�ntekostnader','A','','E','');
  224. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8490','�vr finansiella kostnader','A','','E','');
  225. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('891','Skatter','H','','E','');
  226. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8910','�rets skattekostnad','A','','E','');
  227. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('899','Redovisat resultat','H','','E','');
  228. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8999','Redovisat resultat','A','','E','');
  229. --
  230. update defaults set inventory_accno_id = (select id from chart where accno ='1130'), income_accno_id = (select id from chart where accno = '3400'), expense_accno_id = (select id from chart where accno = '4400'), fxgain_accno_id = (select id from chart where accno = '3960'), fxloss_accno_id = (select id from chart where accno = '7960'), curr = 'SEK:EUR:USD', weightunit = 'kg';