sql/Simplified-Chinese_Default-chart.sql



-- Default chart of accounts -- sample only
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2190','Ӧ������˰','A','','L','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2600','���ڸ�ծ','H','','L','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3300','�ɷ��ʱ�','H','','Q','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3500','����ӯ��','H','','Q','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4000','����ӯ��','H','','I','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4300','��ѯӯ��','H','','I','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4400','����ӯ��','H','','I','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5000','�����ɱ�','H','','E','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5400','н��֧��','H','','E','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5600','�ճ�������֧��','H','','E','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1205','���ʱ���','A','','A','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1000','�����ʲ�','H','','A','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1800','�ʱ��ʲ�','H','','A','');
insert into chart (accno,description,charttype,gifi_accno,category,link,contra) values ('1825','�ۼƷ��ڸ��� - װ諼��豸.','A','','A','','1');
insert into chart (accno,description,charttype,gifi_accno,category,link,contra) values ('1845','�ۼƷ��ڸ��� - ���乤��','A','','A','','1');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2000','������ծ','H','','L','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2620','���н��','A','','L','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3600','����ӯ��','A','','Q','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2160','Ӧ����˾˰','A','','L','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3590','����ӯ�� - ȥ���','A','','Q','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3350','��ͨ�ɷ�','A','','Q','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1500','����ʲ�','H','','A','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5615','�������','A','','E','AP_amount');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5790','����','A','','E','AP_amount');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5700','�칫��Ʒ','A','','E','AP_amount');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5800','Ȩ����','A','','E','AP_amount');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5610','��Ʒ���','A','','E','AP_amount');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5685','����','A','','E','AP_amount');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5660','����֧��','A','','E','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5620','����','A','','E','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5680','����˰','A','','E','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5690','��Ϣ������������','A','','E','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5410','н��','A','','E','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5420','����֧��','A','','E','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5430','���ݽ�֧��','A','','E','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5440','������֧��','A','','E','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5470','Ա������','A','','E','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4030','���� / ����','A','','I','AR_amount:IC_sale');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4440','��Ϣ','A','','I','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5100','�˷�','A','','E','AP_amount:IC_expense');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5760','���','A','','E','AP_amount');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1530','��� / ����','A','','A','IC');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1540','��� / �����г����','A','','A','IC');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4040','���� / �����г����','A','','I','AR_amount:IC_sale');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5030','�����ɱ� / ����','A','','E','AP_amount:IC_cogs');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5010','�ɹ�','A','','E','AP_amount:IC_cogs:IC_expense');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5040','�����ɱ� / �����г����','A','','E','AP_amount:IC_cogs');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1065','���ý�','A','','A','AR_paid:AP_paid');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1820','�칫��װ諼��豸','A','','A','AP_amount');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5785','�÷Ѽ�����','A','','E','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2680','�ɶ�����','A','','L','AP_paid');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5795','ע���','A','','E','AP_amount');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5780','���ŷ�','A','','E','AP_amount');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5781','��·���߷�','A','','E','AP_amount:IC_expense');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5765','ά�޹�����','A','','E','AP_amount');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2311','�ط�˰','A','','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4430','������','A','','I','IC_income');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1520','��� / Ӳ��','A','','A','IC');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5020','�����ɱ� / Ӳ��','A','','E','AP_amount:IC_cogs');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2100','Ӧ���ʿ�','A','','L','AP');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1840','���乤��','A','','A','AP_amount');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4330','��ʽ���','A','','I','AR_amount:IC_income');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4020','���� / Ӳ��','A','','I','AR_amount:IC_sale');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4320','��ѯ','A','','I','AR_amount:IC_income');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1200','Ӧ���ʿ�','A','','A','AR');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1061','֧Ʊ��ͷ','A','','A','AR_paid:AP_paid');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2310','��Ʒ����˰','A','','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
--
-- exchange rate
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4450','Foreign Exchange Gain','A','','I','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5810','Foreign Exchange Loss','A','','E','');
--
insert into tax (chart_id,rate) values ((select id from chart where accno = '2310'),0.07);
insert into tax (chart_id,rate) values ((select id from chart where accno = '2311'),0.08);
--
INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1520'));

 INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '4020'));

 INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '5010'));

 INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '4450'));

 INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '5810'));

 INSERT INTO defaults (setting_key, value) VALUES ('curr', 'CAD');

 INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
--