1-- Default chart of accounts 2-- charset: ISO-8859-1 3-- http://www.nif.idrett.no/ftp/Lover/doc/kontoplan.htm 4-- http://www.legemiddelverket.no/rundskriv/frahtil/1999/ik-1499.htm 5-- sample only 6insert into chart (accno,description,charttype,gifi_accno,category,link) values ('10', 'Immaterielle eiendeler', 'H', '', 'A', ''); 7insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1000', 'Forskning og utvikling', 'A','', 'A', ''); 8insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1030', 'Patenter', 'A','', 'A', ''); 9insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1040', 'Lisenser', 'A','', 'A', ''); 10insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1050', 'Varemerker', 'A','', 'A', ''); 11insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1060', 'Andre rettigheter', 'A','', 'A', ''); 12insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1070', 'Utsatt skattefordel', 'A','', 'A', ''); 13insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1080', 'Goodwill', 'A','', 'A', ''); 14insert into chart (accno,description,charttype,gifi_accno,category,link) values ('11', 'Varige driftsmidler', 'H', '', 'A', ''); 15insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1100', 'Bygninger', 'A','', 'A', ''); 16insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1120', 'Bygningsmessige anlegg', 'A','', 'A', ''); 17insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1140', 'Jord- og skogbrukseiendommer', 'A','', 'A', ''); 18insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1150', 'Tomter og andre grunnarealer', 'A','', 'A', ''); 19insert into chart (accno,description,charttype,gifi_accno,category,link) values ('12', 'Transportmidler, inventar, maskiner o.l.', 'H', '', 'A', ''); 20insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1200', 'Maskiner og anlegg', 'A','', 'A', ''); 21insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1210', 'Maskiner og anlegg under utførelse', 'A','', 'A', ''); 22insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1230', 'Biler', 'A','', 'A', ''); 23insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1240', 'Andre transportmidler', 'A','', 'A', ''); 24insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1250', 'Inventar', 'A','', 'A', 'IC'); 25insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1260', 'Fast bygningsinventar med annen avskrivning', 'A','', 'A', ''); 26insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1270', 'Verktøy mv.', 'A','', 'A', ''); 27insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1280', 'Kontormaskiner', 'A','', 'A', ''); 28insert into chart (accno,description,charttype,gifi_accno,category,link) values ('13', 'Finansielle anleggsmidler', 'H', '', 'A', ''); 29insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1300', 'Investeringer i datterselskaper', 'A','', 'A', ''); 30insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1350', 'Investeringer i aksjer og andeler', 'A','', 'A', ''); 31insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1360', 'Obligasjoner', 'A','', 'A', ''); 32insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1370', 'Fordringer på eiere, styremedlemmer mv.', 'A','', 'A', ''); 33insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1380', 'Fordringer på ansatte', 'A','', 'A', ''); 34insert into chart (accno,description,charttype,gifi_accno,category,link) 35values ('1390', 'Andre langsiktige fordringer', 'A','', 'A', ''); 36insert into chart (accno,description,charttype,gifi_accno,category,link) 37values ('14', 'Varer', 'H', '', 'A', ''); 38insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1400', 'Råvarer og innkjøpte halvfabrikata', 'A','', 'A', 'IC'); 39insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1420', 'Varer under tilvirkning', 'A','', 'A', 'IC'); 40insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1440', 'Ferdige egentilvirkede varer', 'A','', 'A', 'IC'); 41insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1460', 'Innkjøpte varer for videresalg', 'A','', 'A', 'IC'); 42insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1480', 'Forskuddsbetaling til leverandører', 'A','', 'A', ''); 43insert into chart (accno,description,charttype,gifi_accno,category,link) values ('15', 'Fordringer', 'H', '', 'A', ''); 44insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1500', 'Kundefordringer', 'A','', 'A', 'AR'); 45insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1520', 'Andre kortsiktige fordringer', 'A','', 'A', ''); 46insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1530', 'Opptjente, ikke fakturerte driftsinntekter', 'A','', 'A', ''); 47insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1570', 'Andre kortsiktige fordringer', 'A','', 'A', ''); 48insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1580', 'Avsetning tap på fordringer', 'A','', 'A', ''); 49insert into chart (accno,description,charttype,gifi_accno,category,link) values ('17', 'Andre fordringer', 'H', '', 'A', ''); 50insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1700', 'Forskuddsbetalt leie', 'A','', 'A', ''); 51insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1710', 'Forskuddsbetalt rente', 'A','', 'A', ''); 52insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1720', 'Forskuddsbetalt lønn', 'A','', 'A', ''); 53insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1750', 'Påløpte leieinntekter', 'A','', 'A', ''); 54insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1760', 'Påløpte renteinntekter', 'A','', 'A', ''); 55insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1780', 'Krav på innbetaling av selskapskapital', 'A','', 'A', ''); 56insert into chart (accno,description,charttype,gifi_accno,category,link) values ('18', 'Investeringer', 'H', '', 'A', ''); 57insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1800', 'Aksjer & andeler i foretak i samme kons.', 'A','', 'A', ''); 58insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1810', 'Markesdbaserte aksjer', 'A','', 'A', ''); 59insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1820', 'Andre aksjer', 'A','', 'A', ''); 60insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1830', 'Markedsbaserte obligasjoner', 'A','', 'A', ''); 61insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1840', 'Andre obligasjoner', 'A','', 'A', ''); 62insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1850', 'Markedsbaserte sertifikater', 'A','', 'A', ''); 63insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1860', 'Andre sertifikater', 'A','', 'A', ''); 64insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1880', 'Andre finansielle instrumenter', 'A','', 'A', ''); 65insert into chart (accno,description,charttype,gifi_accno,category,link) values ('19', 'Bankinnskudd, kontanter o.l.', 'H', '', 'A', ''); 66insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1900', 'Kontanter', 'A','', 'A', 'AR_paid:AP_paid'); 67insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1910', 'Kasse', 'A','', 'A', 'AR_paid:AP_paid'); 68insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1920', 'Bankinnskudd', 'A','', 'A', 'AR_paid:AP_paid'); 69insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1950', 'Bankinnskudd for skattetrekk', 'A','', 'A', 'AR_paid:AP_paid'); 70insert into chart (accno,description,charttype,gifi_accno,category,link) values ('20', 'Egenkapital', 'H', '', 'Q', ''); 71insert into chart (accno,description,charttype,gifi_accno,category,link) values ('200', 'Innskutt egenkapital', 'H', '', 'Q', ''); 72insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2000', 'Aksjekapital', 'A','', 'Q', ''); 73insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2010', 'Egne aksjer', 'A','', 'Q', ''); 74insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2020', 'Overkursfond', 'A','', 'Q', ''); 75insert into chart (accno,description,charttype,gifi_accno,category,link) values ('204', 'Opptj. egenkapital', 'H', '', 'Q', ''); 76insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2040', 'Fond for vurderingsforskjeller', 'A','', 'Q', ''); 77insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2050', 'Annen egenkapital', 'A','', 'Q', ''); 78insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2080', 'Udisponert overskudd', 'A','', 'Q', ''); 79insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2090', 'Udekket tap', 'A','', 'Q', ''); 80insert into chart (accno,description,charttype,gifi_accno,category,link) values ('210', 'Avsetninger for forpliktelser', 'H', '', 'L', ''); 81insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2100', 'Pensjonsforpliktelser', 'A','', 'L', ''); 82insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2120', 'Utsatt skatt', 'A','', 'L', ''); 83insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2140', 'Avsetn. for garanti- & serviceforpl.', 'A','', 'L', ''); 84insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2180', 'Andre avsetninger for forpiktelser', 'A','', 'L', ''); 85insert into chart (accno,description,charttype,gifi_accno,category,link) values ('220', 'Annen langsiktig gjeld', 'H', '', 'L', ''); 86insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2200', 'Konvertible lån', 'A','', 'L', ''); 87insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2210', 'Obligsjonslån', 'A','', 'L', ''); 88insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2220', 'Gjeld til kredittinstitusjoner', 'A','', 'L', ''); 89insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2240', 'Pantelån', 'A','', 'L', ''); 90insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2260', 'Gjeld til selskap i samme konsern', 'A','', 'L', ''); 91insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2270', 'Andre valutalån', 'A','', 'L', ''); 92insert into chart (accno,description,charttype,gifi_accno,category,link) values ('230', 'Kortsiktig gjeld', 'H', '', 'L', ''); 93insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2300', 'Konvertible lån', 'A','', 'L', ''); 94insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2320', 'Sertifikatlån', 'A','', 'L', ''); 95insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2340', 'Andre valutalån', 'A','', 'L', ''); 96insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2360', 'Byggelån', 'A','', 'L', ''); 97insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2380', 'Kassakreditt', 'A','', 'L', ''); 98insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2400', 'Leverandørgjeld', 'A','', 'L', 'AP'); 99insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2500', 'Avsatt betalbar skatt', 'A','', 'L', ''); 100insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2510', 'Skattebetaling', 'A','', 'L', ''); 101insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2600', 'Skattetrekk', 'A','', 'L', ''); 102insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2620', 'Påleggstrekk', 'A','', 'L', ''); 103insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2630', 'Bidragstrekk', 'A','', 'L', ''); 104insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2640', 'Trygdetrekk', 'A','', 'L', ''); 105insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2650', 'Forsikringstrekk', 'A','', 'L', ''); 106insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2660', 'Fagforeningstrekk', 'A','', 'L', ''); 107insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2690', 'Andre trekk', 'A','', 'L', ''); 108insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2710', 'Utgående 24% mva', 'A','', 'L', 'AR_tax:IC_taxpart:IC_taxservice'); 109insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2715', 'Utgående 12% mva', 'A','', 'L', 'AR_tax:IC_taxpart:IC_taxservice'); 110insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2717', 'Beregnet avgift utlandet', 'A','', 'L', ''); 111insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2720', 'Inngående 24% mva', 'A','', 'L', 'AP_tax:IC_taxpart:IC_taxservice'); 112insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2725', 'Inngående 12% mva', 'A','', 'L', 'AP_tax:IC_taxpart:IC_taxservice'); 113insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2745', 'Grunnlag 1 tjenester utlandet', 'A','', 'L', ''); 114insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2746', 'Grunnlag 2 tjenester utlandet', 'A','', 'L', ''); 115insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2750', 'Oppgjørskonto merverdiavgift', 'A','', 'L', ''); 116insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2770', 'Påløpt arbeidsgiveravgift', 'A','', 'L', ''); 117insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2780', 'Skyldig arbeidsgiveravgift', 'A','', 'L', ''); 118insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2781', 'Arb.giv.avg. pål. feriep.', 'A','', 'L', ''); 119insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2800', 'Avsatt utbytte', 'A','', 'L', ''); 120insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2900', 'Forskudd fra kunder', 'A','', 'L', ''); 121insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2910', 'Skyldig lønn', 'A','', 'L', ''); 122insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2920', 'Skyldig feriepenger', 'A','', 'L', ''); 123insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2930', 'Gjeld til ansatte og aksjonærer', 'A','', 'L', ''); 124insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2950', 'Påløpte renter', 'A','', 'L', ''); 125insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2960', 'Påløpte kostn. og forskuddsbet. inskudd', 'A','', 'L', ''); 126insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3', 'Salgs- og driftsinntekter', 'H', '', 'I', ''); 127insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3010', 'Salgsinntekter, 24% mva', 'A','', 'I', 'AR_amount:IC_sale'); 128insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3019', 'Frakt', 'A','', 'I', 'IC_income'); 129insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3020', 'Salgsinntekter, 12% mva', 'A','', 'I', 'AR_amount:IC_sale'); 130insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3060', 'Uttak av varer', 'A','', 'I', ''); 131insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3080', 'Rabatter og andre salgsinntektsreduksjon', 'A','', 'I', ''); 132insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3099', 'Miljøavgift', 'A','', 'I', ''); 133insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3110', 'Salgsinntekter, avgiftsfrie', 'A','', 'I', 'AR_amount:IC_sale'); 134insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3160', 'Uttak av varer', 'A','', 'I', ''); 135insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3180', 'Rabatter og andre salgsinntektsreduksjon', 'A','', 'I', ''); 136insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3300', 'Spes. offent. avg. tilvirk./solgte varer', 'A','', 'I', ''); 137insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3400', 'Spes. offent. avg. tilvirk./solgte varer', 'A','', 'I', ''); 138insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3440', 'Spes. offentlige tilskudd for tjenester', 'A','', 'I', ''); 139insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3500', 'Uopptjente inntekter garanti', 'A','', 'I', ''); 140insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3510', 'Uopptjente inntekter service', 'A','', 'I', ''); 141insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3600', 'Leieinntekter fast eiendom', 'A','', 'I', ''); 142insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3610', 'Leieinntekter andre varige driftsmidler', 'A','', 'I', ''); 143insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3620', 'Andre leieinntekter', 'A','', 'I', ''); 144insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3700', 'Provisjonsinntekter', 'A','', 'I', ''); 145insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3800', 'Gevinst ved avgang av anleggsmidler', 'A','', 'I', ''); 146insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3900', 'Andre driftsrelaterte inntekter', 'A','', 'I', ''); 147insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4', 'Varekostnad', 'H', '', 'I', ''); 148insert into chart (accno,description,charttype,gifi_accno,category,link) values ('40', 'Råvarer og halvfabrikata', 'H', '', 'I', ''); 149insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4010', 'Innkjøp varer, avgiftspliktig 24% mva', 'A','', 'E', 'AP_amount:IC_cogs:IC_expense'); 150insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4020', 'Innkjøp varer, avgiftspliktig 12% mva', 'A','', 'E', 'AP_amount:IC_cogs:IC_expense'); 151insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4060', 'Innkjøpsprisreduksjoner', 'A','', 'E', ''); 152insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4070', 'Frakt, toll og spedisjon', 'A','', 'E', ''); 153insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4090', 'Beholdningsendring', 'A','', 'E', ''); 154insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4110', 'Innkjøp varer, avgiftsfritt', 'A','', 'E', ''); 155insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4160', 'Frakt, toll og spedisjon', 'A','', 'E', ''); 156insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4170', 'Frakt, toll og spedisjon, avgiftsfritt', 'A','', 'E', ''); 157insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4180', 'Innkjøpsprisreduksjoner', 'A','', 'E', ''); 158insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4190', 'Beholdningsendring', 'A','', 'E', ''); 159insert into chart (accno,description,charttype,gifi_accno,category,link) values ('43', 'Varer for videresalg', 'H', '', 'I', ''); 160insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4310', 'Innkjøp av varer for videresalg, 24% mva', 'A','', 'E', 'AP_amount:IC_cogs:IC_expense'); 161insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4320', 'Innkjøp av varer for videresalg, 12% mva', 'A','', 'E', 'AP_amount:IC_cogs:IC_expense'); 162insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4360', 'Frakt, toll m.m. vedr. innkjøp av varer for videresalg', 'A','', 'E', ''); 163insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4370', 'Rabatter m.m. vedr. innkjøp av varer for videresalg', 'A','', 'E', ''); 164insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4380', 'Varekostnad', 'A','', 'E', ''); 165insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4390', 'Beholdningsendring varer for videresalg', 'A','', 'E', ''); 166insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5', 'Lønnskostnader', 'H', '', 'I', ''); 167insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5010', 'Faste lønninger', 'A','', 'E', ''); 168insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5090', 'Periodiseringskonto lønn', 'A','', 'E', ''); 169insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5190', 'Påløpne feriepenger', 'A','', 'E', ''); 170insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5210', 'Fri bil', 'A','', 'E', ''); 171insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5220', 'Fri telefon', 'A','', 'E', ''); 172insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5230', 'Fri avis', 'A','', 'E', ''); 173insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5240', 'Fri losji og bolig', 'A','', 'E', ''); 174insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5250', 'Rentefordel', 'A','', 'E', ''); 175insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5260', 'Smusstillegg', 'A','', 'E', ''); 176insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5280', 'Andre fordeler i arbeidsforhold', 'A','', 'E', ''); 177insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5291', 'Motkonto for gruppe 52', 'A','', 'E', ''); 178insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5330', 'Godtgj. til styre- og bedriftsforsamling', 'A','', 'E', ''); 179insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5410', 'Arbeidsgiveravgift', 'A','', 'E', ''); 180insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5411', 'Arb.giv.avg. pål. feriep.', 'A','', 'E', ''); 181insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5420', 'Innberetningspliktige pensjonskostnader', 'A','', 'E', ''); 182insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5430', 'Premie pensjonsordning', 'A','', 'E', ''); 183insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5500', 'Andre kostnadsgodtgjørelser', 'A','', 'E', ''); 184insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5510', 'Overtidsmat etter regning', 'A','', 'E', ''); 185insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5520', 'Kantinekostnader', 'A','', 'E', ''); 186insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5800', 'Refusjon av sykepenger', 'A','', 'E', ''); 187insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5820', 'Refusjon av arbeidsgiveravgift', 'A','', 'E', ''); 188insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5920', 'Yrkesskadeforsikring', 'A','', 'E', ''); 189insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5930', 'Andre ikke arb.giv.avg.pliktige forsikr.', 'A','', 'E', ''); 190insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5950', 'Personalforsikring', 'A','', 'E', ''); 191insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5960', 'Gaver til ansatte', 'A','', 'E', ''); 192insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6', 'Andre driftskostnader, av- og nedskrivninger', 'H', '', 'I', ''); 193insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6000', 'Avskrivning på bygn. & annen fast eiend.', 'A','', 'E', ''); 194insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6010', 'Avskrivning på transportmidler, maskiner', 'A','', 'E', ''); 195insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6020', 'Avskrivning på immaterielle eiendeler', 'A','', 'E', ''); 196insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6050', 'Nedskr. varige driftsmidl. & imat. eiend', 'A','', 'E', ''); 197insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6100', 'Frakter, transportkostnader og forsikring', 'A','', 'E', ''); 198insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6110', 'Toll og spedisjonskostnader ved forsend', 'A','', 'E', ''); 199insert into chart (accno,description,charttype,gifi_accno,category,link) values ('62', 'Energi, brensel o.l. vedr. produksjon', 'H', '', 'I', ''); 200insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6200', 'Elektrisitet', 'A','', 'E', 'AP_amount'); 201insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6260', 'Vann', 'A','', 'E', 'AP_amount'); 202insert into chart (accno,description,charttype,gifi_accno,category,link) values ('63', 'Kostnader. vedr. lokaler', 'H', '', 'I', ''); 203insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6300', 'Leie lokaler', 'A','', 'E', 'AP_amount'); 204insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6320', 'Renovasjon, vann, avløp mv.', 'A','', 'E', 'AP_amount'); 205insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6340', 'Lys, varme', 'A','', 'E', 'AP_amount'); 206insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6360', 'Renhold', 'A','', 'E', ''); 207insert into chart (accno,description,charttype,gifi_accno,category,link) values ('64', 'Leie av maskiner, inventar o.l.', 'H', '', 'I', ''); 208insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6400', 'Leie av driftsmidler', 'A','', 'E', ''); 209insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6430', 'Leie andre kontormaskiner', 'A','', 'E', ''); 210insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6540', 'Inventar', 'A','', 'E', ''); 211insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6550', 'Driftsmaterialer', 'A','', 'E', ''); 212insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6560', 'Rekvisita', 'A','', 'E', 'AP_amount'); 213insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6570', 'Arbeidsklær og verneutstyr', 'A','', 'E', 'AP_amount'); 214insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6600', 'Reparasjoner og vedlikehold bygninger', 'A','', 'E', ''); 215insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6620', 'Reparasjoner og vedlikehold utstyr', 'A','', 'E', ''); 216insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6700', 'Revisjonshonorar', 'A','', 'E', ''); 217insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6720', 'Honorar for økonomisk & juridisk bistand', 'A','', 'E', ''); 218insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6750', 'Honorar regnskapsfører', 'A','', 'E', ''); 219insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6800', 'Kontorrekvisita', 'A','', 'E', 'AP_amount'); 220insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6820', 'Trykksaker', 'A','', 'E', ''); 221insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6840', 'Aviser, tidsskrifter, bøker mv.', 'A','', 'E', ''); 222insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6860', 'Møter, kurs, oppdatering mv.', 'A','', 'E', ''); 223insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6900', 'Telefon', 'A','', 'E', ''); 224insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6940', 'Porto', 'A','', 'E', ''); 225insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7000', 'Drivstoff', 'A','', 'E', ''); 226insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7020', 'Vedlikehold', 'A','', 'E', ''); 227insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7040', 'Forsikringer', 'A','', 'E', ''); 228insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7100', 'Bilgodtgjørelse, oppgavepliktig', 'A','', 'E', ''); 229insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7105', 'Øreavrunding', 'A','', 'E', ''); 230insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7130', 'Reisekostnader, oppgavepliktige', 'A','', 'E', ''); 231insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7140', 'Reisekostnader, ikke oppgavepliktig', 'A','', 'E', ''); 232insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7150', 'Diettkostnader, oppgaveplikig', 'A','', 'E', ''); 233insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7160', 'Diettkostnader, ikke oppgavepliktig', 'A','', 'E', ''); 234insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7200', 'Provisjonskostnader, oppgavepliktige', 'A','', 'E', ''); 235insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7210', 'Provisjonskostnader, ikke oppgavepliktig', 'A','', 'E', ''); 236insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7300', 'Salgskostnader', 'A','', 'E', ''); 237insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7320', 'Reklamekostnader', 'A','', 'E', ''); 238insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7350', 'Representasjon, fradragsberettiget', 'A','', 'E', ''); 239insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7360', 'Representasjon, ikke fradragsberettiget', 'A','', 'E', ''); 240insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7400', 'Kontingenter og gaver', 'A','', 'E', ''); 241insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7500', 'Forsikringspremier', 'A','', 'E', ''); 242insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7550', 'Garanti- og servicekostnader', 'A','', 'E', ''); 243insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7600', 'Lisenesavgifter og royalties', 'A','', 'E', ''); 244insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7700', 'Styre- og bedriftsforsamlingsmøter', 'A','', 'E', ''); 245insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7710', 'Generalforsamling', 'A','', 'E', ''); 246insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7730', 'Kostnader ved egne aksjer', 'A','', 'E', ''); 247insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7750', 'Eiendoms- og festeavgift', 'A','', 'E', ''); 248insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7770', 'Bank og kortgebyrer', 'A','', 'E', ''); 249insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7800', 'Tap ved avgang anleggsmidler', 'A','', 'E', ''); 250insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7820', 'Innkommet på tidligere nedskrevne fordri', 'A','', 'E', ''); 251insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7830', 'Tap på fordringer', 'A','', 'E', ''); 252insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7850', 'Tap pga. brannskade', 'A','', 'E', ''); 253insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7860', 'Tap på kontrakter', 'A','', 'E', ''); 254insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7900', 'Beholdningsendring anlegg under utførels', 'A','', 'E', ''); 255insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7990', 'Andre driftskostnader', 'A','', 'E', ''); 256insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8', 'Finansinntekter og -kostnader, skatter, m.m.', 'H', '', 'I', ''); 257insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8000', 'Inntekter på investeringer i datterselskap', 'A','', 'E', ''); 258insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8040', 'Renteinntekter, skattefrie', 'A','', 'E', ''); 259insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8050', 'Annen renteinntekt', 'A','', 'E', ''); 260insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8060', 'Purregebyr, kunder', 'A','', 'E', ''); 261insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8070', 'Renteinntekter, kunder', 'A','', 'E', ''); 262insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8080', 'Agio gevinst', 'A','', 'E', ''); 263insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8090', 'Andre finansinntekter', 'A','', 'E', ''); 264insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8100', 'Verdired. av markedsbas.finans. omløps.', 'A','', 'E', ''); 265insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8110', 'Nedskrivn. av andre finansielle omløps.', 'A','', 'E', ''); 266insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8120', 'Nedskrivning av finansielle anleggsmidl.', 'A','', 'E', ''); 267insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8140', 'Rentekostnader, ikke fradragsberettigede', 'A','', 'E', ''); 268insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8150', 'Annen rentekostnad', 'A','', 'E', ''); 269insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8160', 'Purregebyr. leverandør', 'A','', 'E', ''); 270insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8180', 'Agio tap', 'A','', 'E', ''); 271insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8300', 'Betalbar skatt', 'A','', 'E', ''); 272insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8320', 'Utsatt skatt', 'A','', 'E', ''); 273insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8350', 'Skattekostnad', 'A','', 'E', ''); 274insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8600', 'Betalbar skatt', 'A','', 'E', ''); 275insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8620', 'Utsatt skatt', 'A','', 'E', ''); 276insert into chart (accno,description,charttype,gifi_accno,category,link) values ('880', 'Fond for vurderingsforskjeller', 'H', '', 'E', ''); 277insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8800', 'Årsresultat', 'A','', 'E', ''); 278insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8900', 'Overføringer fond for vurderingsforskjel', 'A','', 'E', ''); 279insert into chart (accno,description,charttype,gifi_accno,category,link) values ('892', 'Utbytte', 'H', '', 'E', ''); 280insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8920', 'Avsatt utbytte/renter på grunnfondsbevis', 'A','', 'E', ''); 281insert into chart (accno,description,charttype,gifi_accno,category,link) values ('893', 'Konsernbidrag', 'H', '', 'E', ''); 282insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8930', 'Konsernbidrag', 'A','', 'E', ''); 283insert into chart (accno,description,charttype,gifi_accno,category,link) values ('891', 'Annen egenkapital', 'H', '', 'E', ''); 284insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8910', 'Overføringer felleseid andelskapital for', 'A','', 'E', ''); 285insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8940', 'Aksjonærbidrag', 'A','', 'E', ''); 286insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8950', 'Fondsemisjon', 'A','', 'E', ''); 287insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8960', 'Overføringer annen egenkapital', 'A','', 'E', ''); 288insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8980', 'Avsatt til fri egenkapital', 'A','', 'E', ''); 289insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8990', 'Udekket tap', 'A','', 'E', ''); 290-- 291insert into tax (chart_id,rate) values ((select id from chart where accno = '2710'),0.24); 292insert into tax (chart_id,rate) values ((select id from chart where accno = '2715'),0.12); 293insert into tax (chart_id,rate) values ((select id from chart where accno = '2720'),0.24); 294insert into tax (chart_id,rate) values ((select id from chart where accno = '2725'),0.12); 295-- 296INSERT INTO defaults (fldname, fldvalue) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE accno = '1250')); 297INSERT INTO defaults (fldname, fldvalue) VALUES ('income_accno_id', (SELECT id FROM chart WHERE accno = '3010')); 298INSERT INTO defaults (fldname, fldvalue) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE accno = '4010')); 299INSERT INTO defaults (fldname, fldvalue) VALUES ('fxgain_accno_id', (SELECT id FROM chart WHERE accno = '8080')); 300INSERT INTO defaults (fldname, fldvalue) VALUES ('fxloss_accno_id', (SELECT id FROM chart WHERE accno = '8180')); 301INSERT INTO defaults (fldname, fldvalue) VALUES ('weightunit', 'kg'); 302INSERT INTO defaults (fldname, fldvalue) VALUES ('precision', '2'); 303-- 304INSERT INTO curr (rn, curr, prec) VALUES (1,'NOK',2); 305INSERT INTO curr (rn, curr, prec) VALUES (2,'EUR',2); 306INSERT INTO curr (rn, curr, prec) VALUES (3,'USD',2); 307 308