summaryrefslogtreecommitdiff
path: root/sql/Sweden_Church_Society-chart.sql
blob: a08691042e5b8ebf975682d020a2c9011ced2db6 (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. INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno ='1130'));
  231. INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '3400'));
  232. INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '4400'));
  233. INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '3960'));
  234. INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '7960'));
  235. INSERT INTO defaults (setting_key, value) VALUES ('curr', 'SEK:EUR:USD');
  236. INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');