1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
|
-- Default chart of accounts
-- sample only
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('11','Raha','H','','A','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1101','Kassa','A','','A','AR_paid:AP_paid');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1102','Pangakonto','A','','A','AR_paid:AP_paid');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('13','Nuded ja ettemaksed','H','','A','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1310','Nuded ostjate vastu','A','','A','AR');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1320','Sisendkibemaks (18%)','A','','L','AP_tax:IC_taxpart:IC_taxservice');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1330','Arveldused aruandvate isikutega','A','','A','AP_paid');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('14','Varud','H','','A','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1410','Tooraine ja materjal','A','','A','AP_amount');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1430','Valmistoodang','A','','A','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1440','Mgiks ostetud kaubad','A','','A','IC');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('17','Materiaalne phivara','H','','A','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1730','Masinad ja seadmed','A','','A','AP_amount');
insert into chart (accno,description,charttype,gifi_accno,category,link,contra) values ('1731','Masinate ja seadmete kulum','A','','A','','1');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1740','Muu materiaalne phivara ','A','','A','AP_amount');
insert into chart (accno,description,charttype,gifi_accno,category,link,contra) values ('1741','Muu materiaalse phivara kulum','A','','A','','1');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2110','Lhiajalised laenud','A','','L','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('21','Laenukohustused','H','','L','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('22','Vlad ja ettemaksed','H','','L','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2210','Vlad tarnijatele','A','','L','AP');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2220','Vlad tvtjatele','A','','L','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('223','Maksuvlad','H','','L','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2230','Arvestatud kibemaks (18%)','A','','L','AR_tax:IC_taxpart:IC_taxservice');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2231','Ettevtte tulumaks','A','','L','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2232','Kinnipeetud tulumaks','A','','L','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2233','sotsiaalmaks','A','','L','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2234','Ttuskindlustusmaksed','A','','L','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2235','Kogumispension','A','','L','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2240','Arveldused aruandvate isikutega','A','','L','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2241','Muud vlad','A','','L','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('24','Pikaajalised laenukohustused','H','','L','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2410','Pikaajalised laenud','A','','L','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('27','OMAKAPITAL','H','','Q','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2710','Osakapital nimivrtuses','A','','Q','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2760','Eelmiste perioodide jaotamata kasum','A','','Q','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('31','Mgitulud','H','','I','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3101','Tulud kaupade mgist','A','','I','AR_amount:IC_sale');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3102','Tulud teenuste mgist','A','','I','AR_amount:IC_income');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('35','Muud ritulud','H','','I','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3501','Kasum valuutakursi muutustest','A','','I','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('37','Finanstulud','H','','I','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3701','Intressitulud','A','','I','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('40','Tootmiskulud','H','','E','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4001','Materjalikulu','A','','E','AP_amount:IC_expense');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4002','Palgakulud','A','','E','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4003','Sotsiaalmaksu kulu','A','','E','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4004','Tandja ttuskindlustusmakse kulu','A','','E','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('42','Mdud toodangu (kaupade, teenuste) kulud','H','','E','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4201','Mdud kaupade kulu','A','','E','AP_amount:IC_cogs');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4202','Mdud teenuste kulu','A','','E','AP_amount:IC_expense');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('43','Turustuskulud','H','','E','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4301','Reklaamikulud','A','','E','AP_amount:IC_expense');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('44','ldhalduskulud','H','','E','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4401','Panga teenustasud','A','','E','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4402','Siduvahendite ktusekulu','A','','E','AP_amount:IC_expense');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4403','Siduvahendite muud kulud','A','','E','AP_amount:IC_expense');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4404','Palgakulud','A','','E','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4405','Sotsiaalmaksu kulu','A','','E','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('46','Muud rikulud','H','','E','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4601','Kahjum valuutakursi muutustest','A','','E','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('48','Finantskulud','H','','E','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4801','Intressikulud','A','','E','');
--
insert into tax (chart_id,rate) values ((select id from chart where accno = '1320'),0.18);
insert into tax (chart_id,rate) values ((select id from chart where accno = '2230'),0.18);
--
insert into defaults (fldname, fldvalue) values ('inventory_accno_id', (select id from chart where accno = '1440'));
insert into defaults (fldname, fldvalue) values ('income_accno_id', (select id from chart where accno = '3101'));
insert into defaults (fldname, fldvalue) values ('expense_accno_id', (select id from chart where accno = '4201'));
insert into defaults (fldname, fldvalue) values ('fxgain_accno_id', (select id from chart where accno = '3501'));
insert into defaults (fldname, fldvalue) values ('fxloss_accno_id', (select id from chart where accno = '4601'));
insert into defaults (fldname, fldvalue) values ('weightunit', 'kg');
INSERT INTO defaults (fldname, fldvalue) VALUES ('precision', '2');
--
INSERT INTO curr (rn, curr, precision) VALUES (1,'EEK',2);
INSERT INTO curr (rn, curr, precision) VALUES (2,'EUR',2);
INSERT INTO curr (rn, curr, precision) VALUES (3,'USD',2);
--
|
