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