-- Default chart of accounts -- sample only
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2190','���I�ұo�|','A','','L','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2600','�����t��','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','�O�d�վl','H','','Q','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4000','�P��վl','H','','I','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4300','�Ը߬վl','H','','I','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4400','�䥦�վl','H','','I','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5000','�f�P����','H','','E','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5400','�~���X','H','','E','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5600','��`�κ޲z��X','H','','E','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1205','�b�b�Ʃ�','A','','A','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1000','�y�ʸ겣','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','�֭p�����I�� - �˿X�γ]��.','A','','A','','1');
insert into chart (accno,description,charttype,gifi_accno,category,link,contra) values ('1845','�֭p�����I�� - �B��u��','A','','A','','1');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2000','�y�ʭt��','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','�y�ʬվl','A','','Q','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2160','���I���q�|','A','','L','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3590','�O�d�վl - �h�~��','A','','Q','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3350','���q�ѥ�','A','','Q','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1500','�s�f�겣','H','','A','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5615','�s�i��P','A','','E','AP_amount');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5790','�u��','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','�v�Q��','A','','E','AP_amount');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5610','�|�p�k��','A','','E','AP_amount');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5685','�O�I','A','','E','AP_amount');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5660','������X','A','','E','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5620','�a�b','A','','E','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5680','�ұo�|','A','','E','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5690','�Q���λȦ����O','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','�O�I��X','A','','E','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5430','�h�����X','A','','E','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5440','���v����X','A','','E','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5470','���u�֧Q','A','','E','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4030','�P�� / �n��','A','','I','AR_amount:IC_sale');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4440','�Q��','A','','I','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5100','�B�O','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','�w�s / �n��','A','','A','IC');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1540','�w�s / �G�ť����s��','A','','A','IC');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4040','�P�� / �G�ť����s��','A','','I','AR_amount:IC_sale');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5030','�f�P���� / �n��','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','�f�P���� / �G�ť����s��','A','','E','AP_amount:IC_cogs');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1065','�s�Ϊ�','A','','A','AR_paid:AP_paid');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1820','�줽�Ǹ˿X�γ]��','A','','A','AP_amount');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5785','�ȶO�ήT��','A','','E','');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2680','�ѪF�U��','A','','L','AP_paid');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5795','���U�O','A','','E','AP_amount');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5780','�q�H�O','A','','E','AP_amount');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5781','�����s�u�O','A','','E','AP_amount:IC_expense');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5765','���׺޲z�O','A','','E','AP_amount');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2311','�a��|','A','','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4430','�B�P�O','A','','I','IC_income');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1520','�w�s / �w��','A','','A','IC');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5020','�f�P���� / �w��','A','','E','AP_amount:IC_cogs');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2100','���I�b��','A','','L','AP');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1840','�B��u��','A','','A','AP_amount');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4330','�{���]�p','A','','I','AR_amount:IC_income');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4020','�P�� / �w��','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','�����b��','A','','A','AR');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1061','�䲼���Y','A','','A','AR_paid:AP_paid');
insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2310','�ӫ~�A�ȵ|','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);
--
update defaults set inventory_accno_id = (select id from chart where accno = '1520'), income_accno_id = (select id from chart where accno = '4020'), expense_accno_id = (select id from chart where accno = '5010'), fxgain_accno_id = (select id from chart where accno = '4450'), fxloss_accno_id = (select id from chart where accno = '5810'), curr = 'USD', weightunit = 'kg';
--