1-- Default chart of accounts -- sample only
2insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2190','Ӧ������˰','A','','L','');
3insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2600','���ڸ�ծ','H','','L','');
4insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3300','�ɷ��ʱ�','H','','Q','');
5insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3500','����ӯ��','H','','Q','');
6insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4000','����ӯ��','H','','I','');
7insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4300','��ѯӯ��','H','','I','');
8insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4400','����ӯ��','H','','I','');
9insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5000','�����ɱ�','H','','E','');
10insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5400','н��֧��','H','','E','');
11insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5600','�ճ�������֧��','H','','E','');
12insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1205','���ʱ���','A','','A','');
13insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1000','�����ʲ�','H','','A','');
14insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1800','�ʱ��ʲ�','H','','A','');
15insert into chart (accno,description,charttype,gifi_accno,category,link,contra) values ('1825','�ۼƷ��ڸ��� - װ諼��豸.','A','','A','','1');
16insert into chart (accno,description,charttype,gifi_accno,category,link,contra) values ('1845','�ۼƷ��ڸ��� - ���乤��','A','','A','','1');
17insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2000','������ծ','H','','L','');
18insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2620','����','A','','L','');
19insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3600','����ӯ��','A','','Q','');
20insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2160','Ӧ����˾˰','A','','L','');
21insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3590','����ӯ�� - ȥ���','A','','Q','');
22insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3350','��ͨ�ɷ�','A','','Q','');
23insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1500','����ʲ�','H','','A','');
24insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5615','�������','A','','E','AP_amount');
25insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5790','����','A','','E','AP_amount');
26insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5700','�칫��Ʒ','A','','E','AP_amount');
27insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5800','Ȩ����','A','','E','AP_amount');
28insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5610','��Ʒ���','A','','E','AP_amount');
29insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5685','����','A','','E','AP_amount');
30insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5660','����֧��','A','','E','');
31insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5620','����','A','','E','');
32insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5680','����˰','A','','E','');
33insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5690','��Ϣ������������','A','','E','');
34insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5410','�','A','','E','');
35insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5420','����֧��','A','','E','');
36insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5430','���ݽ�֧��','A','','E','');
37insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5440','������֧��','A','','E','');
38insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5470','Ա������','A','','E','');
39insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4030','���� / ����','A','','I','AR_amount:IC_sale');
40insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4440','��Ϣ','A','','I','');
41insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5100','�˷�','A','','E','AP_amount:IC_expense');
42insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5760','���','A','','E','AP_amount');
43insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1530','��� / ����','A','','A','IC');
44insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1540','��� / ��������','A','','A','IC');
45insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4040','���� / ��������','A','','I','AR_amount:IC_sale');
46insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5030','�����ɱ� / ����','A','','E','AP_amount:IC_cogs');
47insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5010','�ɹ�','A','','E','AP_amount:IC_cogs:IC_expense');
48insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5040','�����ɱ� / �����г����','A','','E','AP_amount:IC_cogs');
49insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1065','���ý�','A','','A','AR_paid:AP_paid');
50insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1820','�칫��װ諼��豸','A','','A','AP_amount');
51insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5785','�÷Ѽ�����','A','','E','');
52insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2680','�ɶ�����','A','','L','AP_paid');
53insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5795','ע���','A','','E','AP_amount');
54insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5780','���ŷ�','A','','E','AP_amount');
55insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5781','��·���߷�','A','','E','AP_amount:IC_expense');
56insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5765','ά�޹����','A','','E','AP_amount');
57insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2311','�ط�˰','A','','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
58insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4430','������','A','','I','IC_income');
59insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1520','��� / Ӳ��','A','','A','IC');
60insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5020','�����ɱ� / Ӳ��','A','','E','AP_amount:IC_cogs');
61insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2100','Ӧ���ʿ�','A','','L','AP');
62insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1840','���乤��','A','','A','AP_amount');
63insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4330','��ʽ���','A','','I','AR_amount:IC_income');
64insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4020','���� / Ӳ��','A','','I','AR_amount:IC_sale');
65insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4320','��ѯ','A','','I','AR_amount:IC_income');
66insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1200','Ӧ���ʿ�','A','','A','AR');
67insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1061','֧Ʊ��ͷ','A','','A','AR_paid:AP_paid');
68insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2310','��Ʒ����˰','A','','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
69--
70-- exchange rate
71insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4450','Foreign Exchange Gain','A','','I','');
72insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5810','Foreign Exchange Loss','A','','E','');
73--
74insert into tax (chart_id,rate) values ((select id from chart where accno = '2310'),0.07);
75insert into tax (chart_id,rate) values ((select id from chart where accno = '2311'),0.08);
76--
77INSERT INTO defaults (fldname, fldvalue) VALUES ('inventory_accno_id', (SELECT id FROM chart WHERE accno = '1520'));
78INSERT INTO defaults (fldname, fldvalue) VALUES ('income_accno_id', (SELECT id FROM chart WHERE accno = '4020'));
79INSERT INTO defaults (fldname, fldvalue) VALUES ('expense_accno_id', (SELECT id FROM chart WHERE accno = '5010'));
80INSERT INTO defaults (fldname, fldvalue) VALUES ('fxgain_accno_id', (SELECT id FROM chart WHERE accno = '4450'));
81INSERT INTO defaults (fldname, fldvalue) VALUES ('fxloss_accno_id', (SELECT id FROM chart WHERE accno = '5810'));
82INSERT INTO defaults (fldname, fldvalue) VALUES ('weightunit', 'kg');
83INSERT INTO defaults (fldname, fldvalue) VALUES ('precision', '2');
84--
85INSERT INTO curr (rn, curr, prec) VALUES (1,'CNY',2);
86INSERT INTO curr (rn, curr, prec) VALUES (2,'USD',2);
87INSERT INTO curr (rn, curr, prec) VALUES (3,'EUR',2);
88
89