summaryrefslogtreecommitdiff
path: root/sql/Sweden_Church_Society-chart.sql
blob: 11b64e20a2648a976b4f52bae041daa1dbb7f4b3 (plain) 
    

  1. begin;
    2. 

  2. -- Johan Hambraeus
    3. 

  3. -- May 7, 2006
    4. 

  4. --
    5. 

  5. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1','Tillgångar','H','','','');
    6. 

  6. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('10','Immateriella anläggningstillgångar','H','','','');
    7. 

  7. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1010','Balanserade utgifter','A','','A','');
    8. 

  8. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1019','Ack avskriningar balanserade utg','A','','C','');
    9. 

  9. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1060','Hyresrätt','A','','A','');
    10. 

  10. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1069','Ack avskrivn hyresrätt','A','','C','');
    11. 

  11. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('11','Byggnader och mark','H','','A','');
    12. 

  12. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1110','Byggnader','A','','A','IC');
    13. 

  13. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1119','Ack avskrivn byggnader','A','','C','');
    14. 

  14. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1130','Mark','A','','A','IC');
    15. 

  15. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1140','Tomter, markomr obebyggda','A','','A','IC');
    16. 

  16. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1150','Markanläggningar','A','','A','IC');
    17. 

  17. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1159','Ack avskrivn markanläggn','A','','C','');
    18. 

  18. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1190','Övriga byggnader och mark','A','','A','IC');
    19. 

  19. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('12','Maskiner och inventarier','H','','A','');
    20. 

  20. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1230','Installationer','A','','A','IC');
    21. 

  21. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1238','Ack nedskrivn installationer','A','','C','');
    22. 

  22. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1239','Ack avskrivn installationer','A','','C','');
    23. 

  23. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1250','Datorer','A','','A','IC');
    24. 

  24. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1259','Ack avskrivn datorer','A','','C','');
    25. 

  25. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('13','Finansiella anläggningstillgångar','H','','A','');
    26. 

  26. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1370','Uppskjuten skattefordran','A','','A','');
    27. 

  27. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1380','Långfristiga fordringar','A','','A','');
    28. 

  28. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1400','Fordran hos EFS Gafsele','A','','A','');
    29. 

  29. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1405','Fordran hos EFS Hälla','A','','A','');
    30. 

  30. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('15','Kundfordringar','H','','A','');
    31. 

  31. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1500','Kundfordringar','A','','A','AR');
    32. 

  32. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('16','Övriga kortfristiga fordringar','H','','A','');
    33. 

  33. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1600','Övr kortfristiga fordr','A','','A','');
    34. 

  34. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1710','Förutbetalda hyror','A','','A','');
    35. 

  35. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1730','Förutbet försäkringspremier','A','','A','');
    36. 

  36. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1740','Förutbet ränteutgifter','A','','A','');
    37. 

  37. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1750','Upplupna hyresinkomster','A','','A','');
    38. 

  38. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1760','Upplupna inkomsträntor','A','','A','');
    39. 

  39. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1790','Övr interimsfordringar','A','','A','');
    40. 

  40. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('19','Kassa och Bank','H','','A','');
    41. 

  41. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1910','Kassa','A','','A','AR_paid:AP_paid');
    42. 

  42. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1920','Postgiro','A','','A','AR_paid:AP_paid');
    43. 

  43. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1930','Checkräkningskonto','A','','A','AR_paid:AP_paid');
    44. 

  44. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1940','Övriga bankkonto','A','','A','AR_paid:AP_paid');
    45. 

  45. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1941','Nordea värdepappersfond','A','','A','');
    46. 

  46. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1942','Nordea girokapitalkonto','A','','A','AR_paid:AP_paid');
    47. 

  47. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2','Eget kapital och skulder','H','','A','');
    48. 

  48. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('20','Eget kapital','H','','A','');
    49. 

  49. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2000','Eget kapital EFS Åsele','A','','Q','');
    50. 

  50. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2005','Eget kapital EFS Gafsele','A','','Q','');
    51. 

  51. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2010','Eget kapital EFS Hälla','A','','Q','');
    52. 

  52. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2070','Ändamålsbestämda medel','A','','Q','');
    53. 

  53. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2091','Balanserad vinst/förlust','A','','Q','');
    54. 

  54. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2098','Vinst/förlust föreg år','A','','Q','');
    55. 

  55. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2099','Redovisat resultat','A','','Q','');
    56. 

  56. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('22','Avsättningar','H','','L','');
    57. 

  57. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2250','Avsättning för skatter','A','','L','');
    58. 

  58. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2290','Övriga avsättningar','A','','L','');
    59. 

  59. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('23','Skulder','H','','L','');
    60. 

  60. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2300','Skuld till EFS Gafsele','A','','L','');
    61. 

  61. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2310','Skuld till EFS Hälla','A','','L','');
    62. 

  62. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2320','Skuld till fam Norlin','A','','L','');
    63. 

  63. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2330','Checkräkningskredit','A','','L','');
    64. 

  64. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2399','Övr långfristiga skulder','A','','L','');
    65. 

  65. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2440','Leverantörsskulder','A','','L','AP');
    66. 

  66. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2499','Övr kortfristiga skulder','A','','L','');
    67. 

  67. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2960','Upplupna utgiftsräntor','A','','L','');
    68. 

  68. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2971','Förutbetalda hyresintäkter','A','','L','');
    69. 

  69. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2972','Förutbetalda medlemsavgifter','A','','L','');
    70. 

  70. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2979','Övriga förutbetalda intäkter','A','','L','');
    71. 

  71. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2990','Övr interimsskulder','A','','L','');
    72. 

  72. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2999','Övr uppl kostn/förutbet intäkter','A','','L','');
    73. 

  73. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3','Intäkter','H','','I','');
    74. 

  74. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('30','Allmänna gåvor','H','','I','');
    75. 

  75. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3000','Gåvor via konto','A','','I','AR_amount');
    76. 

  76. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3005','Minnesgåvor','A','','I','AR_amount');
    77. 

  77. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3010','Gudstjänstkollekter','A','','I','AR_amount');
    78. 

  78. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3015','Fika/kaffe/fester - gåvor','A','','I','AR_amount');
    79. 

  79. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('31','Öronmärkta gåvor','H','','I','');
    80. 

  80. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3100','Öronmärkta gåvor','A','','I','AR_amount');
    81. 

  81. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3101','Gåvor barnarbete','A','','I','AR_amount');
    82. 

  82. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3102','Gåvor körsång','A','','I','AR_amount');
    83. 

  83. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3103','Gåvor bönegrupper','A','','I','AR_amount');
    84. 

  84. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3104','Gåvor Alfa-grupper','A','','I','AR_amount');
    85. 

  85. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3105','Övrigt lokalt arbete','A','','I','AR_amount');
    86. 

  86. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3106','Gåvor till fastighet mm','A','','I','AR_amount');
    87. 

  87. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3109','Gåvor Åsele allkristna gemenskap','A','','I','AR_amount');
    88. 

  88. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3110','Gåvor EFS Västerbotten','A','','I','AR_amount');
    89. 

  89. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3111','Gåvor distriktskonferens','A','','I','AR_amount');
    90. 

  90. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3112','Gåvor Scoutverksamhet','A','','I','AR_amount');
    91. 

  91. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3120','Gåvor EFS riks','A','','I','AR_amount');
    92. 

  92. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3121','Gåvor EFS riks konferens','A','','I','AR_amount');
    93. 

  93. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3122','Gåvor EFS Inre mission','A','','I','AR_amount');
    94. 

  94. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3123','Gåvor EFS Yttre mission','A','','I','AR_amount');
    95. 

  95. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3130','Gåvor Barn i alla länder','A','','I','AR_amount');
    96. 

  96. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3131','Gåvor Johannelundsinsamling','A','','I','AR_amount');
    97. 

  97. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3132','Gåvor Påskinsamling','A','','I','AR_amount');
    98. 

  98. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3133','Gåvor Flodvågens offer','A','','I','AR_amount');
    99. 

  99. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('33','Försäljningsintäkter','H','','I','');
    100. 

  100. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3300','Försäljning bokbordet','A','','I','IC_sale');
    101. 

  101. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3350','Försäljning fika mm','A','','I','IC_sale');
    102. 

  102. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('34','Medlemsavgifter','H','','I','');
    103. 

  103. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3400','Medlemsavgifter','A','','I','IC_income');
    104. 

  104. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3405','Medlemsavgifter Solglimten','A','','I','IC_income');
    105. 

  105. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('345','Hyresintäkter','H','','I','');
    106. 

  106. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3450','Hyresintäkter, hyreskontrakt','A','','I','IC_income');
    107. 

  107. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3460','Hyresintäkter, enstaka tillfälle','A','','I','IC_income');
    108. 

  108. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3470','Hyresint Ersättning telefonkostnad','A','','I','IC_income');
    109. 

  109. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('35','Bidrag','H','','I','');
    110. 

  110. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3510','Erhållna statliga bidrag','A','','I','AR_amount');
    111. 

  111. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3520','Erhållna kommunala bidrag','A','','I','AR_amount');
    112. 

  112. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3530','Bidrag Svenska kyrkan','A','','I','AR_amount');
    113. 

  113. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3590','Övriga erhållna bidrag','A','','I','AR_amount');
    114. 

  114. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('36','Övriga intäkter','H','','I','');
    115. 

  115. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3690','Övriga sidointäker','A','','I','');
    116. 

  116. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3731','Kassarabatter','A','','I','');
    117. 

  117. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3740','Öresutjämning','A','','I','');
    118. 

  118. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3960','Valuta kursvinst','A','','I','');
    119. 

  119. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3972','Vinst avyttr fastigheter','A','','I','');
    120. 

  120. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3973','Vinst avyttr maskiner/inv','A','','I','');
    121. 

  121. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3990','Övr ersättn och intäker','A','','I','');
    122. 

  122. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3994','Försäkringsersättningar','A','','I','');
    123. 

  123. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4','Utgifter','H','','E','');
    124. 

  124. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4000','Kostnad för predikant','A','','E','AP_amount');
    125. 

  125. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4050','Reskostnader för predikant','A','','E','AP_amount');
    126. 

  126. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('41','Utgifter öronmärkta gåvor','H','','E','');
    127. 

  127. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4100','Kostnad öronmärkta gåvor','A','','E','AP_amount');
    128. 

  128. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4101','Kostnad barnarbete','A','','E','AP_amount');
    129. 

  129. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4102','Kostnad körer','A','','E','AP_amount');
    130. 

  130. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4103','Kostnad bönegrupper','A','','E','AP_amount');
    131. 

  131. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4104','Kostnad Alfa','A','','E','AP_amount');
    132. 

  132. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4105','Kostnad Övrigt lokalt arbete','A','','E','AP_amount');
    133. 

  133. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4106','Kostnad Fastighet (särskilt)','A','','E','AP_amount');
    134. 

  134. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4107','Kostnad scouting barnarbete','A','','E','AP_amount');
    135. 

  135. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4109','Åsele allkristna gemenskap','A','','E','AP_amount');
    136. 

  136. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4110','EFS Västerbotten','A','','E','AP_amount');
    137. 

  137. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4111','distriktskonferens','A','','E','AP_amount');
    138. 

  138. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4120','EFS riks','A','','E','AP_amount');
    139. 

  139. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4121','EFS riks konferensinsamling','A','','E','AP_amount');
    140. 

  140. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4122','EFS inre mission','A','','E','AP_amount');
    141. 

  141. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4123','EFS yttre mission','A','','E','AP_amount');
    142. 

  142. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4130','Barn i alla länder','A','','E','AP_amount');
    143. 

  143. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4131','Johannelundinsamling','A','','E','AP_amount');
    144. 

  144. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4132','Påskinsamling','A','','E','AP_amount');
    145. 

  145. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4133','Till Flodvågens offer','A','','E','AP_amount');
    146. 

  146. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('43','Inköpskostnader mm','H','','E','');
    147. 

  147. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4300','Inköp bokbord','A','','E','IC_cogs');
    148. 

  148. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4350','Inköp matr fika mm','A','','E','IC_cogs');
    149. 

  149. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4400','Pren Vårt budskap (distr tidning)','A','','E','IC_expense');
    150. 

  150. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4600','Inhyrda predikanter/föreläsare','A','','E','AP_amount');
    151. 

  151. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4700','Tidningar, facklitteratur','A','','E','IC_expense');
    152. 

  152. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4900','Föreningsavgifter','A','','E','IC_expense');
    153. 

  153. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('50','Lokalkostnader hyrd lokal','H','','E','');
    154. 

  154. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5010','Lokalhyra','A','','E','');
    155. 

  155. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5020','El','A','','E','');
    156. 

  156. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5030','Värme hyrd lokal','A','','E','');
    157. 

  157. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5050','Lokaltillbehör hyrd lokal','A','','E','');
    158. 

  158. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5060','Städning, renhållning hyrd lokal','A','','E','');
    159. 

  159. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5070','Reparationer hyrd lokal','A','','E','');
    160. 

  160. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5090','Övr kostnader hyrd lokal','A','','E','');
    161. 

  161. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('51','Lokalkostnader egen lokal','H','','E','');
    162. 

  162. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5120','Belysning','A','','E','');
    163. 

  163. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5130','Värme','A','','E','');
    164. 

  164. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5132','Sotning','A','','E','');
    165. 

  165. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5140','Vatten och avlopp','A','','E','');
    166. 

  166. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5160','Renhålln och städning','A','','E','');
    167. 

  167. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5170','Rep och underhåll fastighet','A','','E','');
    168. 

  168. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5191','Fastighetsskatt','A','','E','');
    169. 

  169. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5192','Försäkringsprem fastighet','A','','E','');
    170. 

  170. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5193','Fastighetsskötsel och förvaltning','A','','E','');
    171. 

  171. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5199','Övr fastighetskostnader','A','','E','');
    172. 

  172. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('52','Övriga kostnader','H','','E','');
    173. 

  173. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5210','Hyra arbetsmaskiner','A','','E','');
    174. 

  174. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5220','Hyra inventarier','A','','E','');
    175. 

  175. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5290','Övr hyreskostn anl tillg','A','','E','');
    176. 

  176. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5390','Övriga bränslen','A','','E','');
    177. 

  177. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5410','Förbrukningsinventarier','A','','E','');
    178. 

  178. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5460','Förbrukningsmaterial','A','','E','');
    179. 

  179. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5480','Arbetskläder o skyddsmtrl','A','','E','');
    180. 

  180. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5500','Reparation och underhåll','A','','E','');
    181. 

  181. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5710','Frakt och transport','A','','E','');
    182. 

  182. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5800','Resekostnader','A','','E','');
    183. 

  183. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5910','Annonsering','A','','E','');
    184. 

  184. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5930','Reklamtrycksaker','A','','E','');
    185. 

  185. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5990','Övrig reklam','A','','E','');
    186. 

  186. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6110','Kontorsmaterial','A','','E','');
    187. 

  187. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6150','Trycksaker','A','','E','');
    188. 

  188. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6210','Telefon','A','','E','');
    189. 

  189. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6250','Porto','A','','E','');
    190. 

  190. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6310','Försäkringar','A','','E','');
    191. 

  191. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6320','Självrisker','A','','E','');
    192. 

  192. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6340','Lämnade skadestånd','A','','E','');
    193. 

  193. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('64','Förvaltningskostnader','H','','E','');
    194. 

  194. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6490','Övr förvaltningskostnader','A','','E','');
    195. 

  195. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6530','Redovisningstjänster','A','','E','');
    196. 

  196. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6540','IT-tjänster','A','','E','');
    197. 

  197. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6550','Konsultarvoden','A','','E','');
    198. 

  198. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('65','Bankkostnader','H','','E','');
    199. 

  199. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6570','Bankkostnader, Nordea','A','','E','');
    200. 

  200. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6571','Bankkostnader, Postgirot','A','','E','');
    201. 

  201. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6572','Bankkostnader, Bankgiro','A','','E','');
    202. 

  202. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6573','Bankkostnader, Föreningssparbank','A','','E','');
    203. 

  203. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('658','Främmande tjänster','H','','E','');
    204. 

  204. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6580','Advokatkostnader','A','','E','');
    205. 

  205. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6590','Övr främmande tjänster','A','','E','');
    206. 

  206. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7','Avskrivningar och engångskostn','H','','E','');
    207. 

  207. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7780','Avskrivningar enligt plan','A','','E','');
    208. 

  208. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7811','Avskrivningar balanserade utgifter','A','','E','');
    209. 

  209. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7820','Avskrivningar byggnader/mark','A','','E','');
    210. 

  210. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7821','Avskrivn byggnader','A','','E','');
    211. 

  211. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7822','Avskrivn byggnadsinv','A','','E','');
    212. 

  212. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7824','Avskrivn markanläggn','A','','E','');
    213. 

  213. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7829','Avskrivningar övr byggnader','A','','E','');
    214. 

  214. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7832','Avskrivn inventarier','A','','E','');
    215. 

  215. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7833','Avskrivningar installationer','A','','E','');
    216. 

  216. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7835','Avskrivningar datorer','A','','E','');
    217. 

  217. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7921','Kostn av engångskaraktär ','A','','E','');
    218. 

  218. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7960','Valutakursförlust','A','','E','');
    219. 

  219. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8','Financiella intäkter o kostnader','H','','E','');
    220. 

  220. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('83','Ränteintäkter','H','','I','');
    221. 

  221. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8300','Ränteintäkter ','A','','I','');
    222. 

  222. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8390','Övr finansiella intäkter','A','','I','');
    223. 

  223. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('84','Räntekostnader','H','','E','');
    224. 

  224. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8400','Räntekostnader','A','','E','');
    225. 

  225. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8490','Övr finansiella kostnader','A','','E','');
    226. 

  226. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('891','Skatter','H','','E','');
    227. 

  227. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8910','Årets skattekostnad','A','','E','');
    228. 

  228. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('899','Redovisat resultat','H','','E','');
    229. 

  229. insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8999','Redovisat resultat','A','','E','');
    230. 

  230. --
    231. 

  231. INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno ='1130'));
    232. 

  232. 

  233.  INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '3400'));
    234. 

  234. 

  235.  INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '4400'));
    236. 

  236. 

  237.  INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '3960'));
    238. 

  238. 

  239.  INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '7960'));
    240. 

  240. 

  241.  INSERT INTO defaults (setting_key, value) VALUES ('curr', 'SEK:EUR:USD');
    242. 

  242. 

  243.  INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
    244. 

  244. 

  245. commit;
    246.
generated by cgit v1.2.3 (git 2.46.0) at 2024-11-05 04:18:40 +0000