diff options
| author | ivan <ivan> | 2004-11-18 05:06:50 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2004-11-18 05:06:50 +0000 |
| commit | 521e7787b230669dc10e6fbd909e70ddb8121990 (patch) | |
| tree | 662f9e42893e6666d538a72b62fc47d5fe6b757d /sql-ledger/sql | |
| parent | 59c328d950e0d5275a1b5cf3357729212dd0e26a (diff) | |
removing files moved in 2.4.4
Diffstat (limited to 'sql-ledger/sql')
| -rw-r--r-- | sql-ledger/sql/Canada-gifi.sql | 754 | ||||
| -rw-r--r-- | sql-ledger/sql/Canada_General-chart.sql | 77 | ||||
| -rw-r--r-- | sql-ledger/sql/Czech_Republic-chart.sql | 317 | ||||
| -rw-r--r-- | sql-ledger/sql/Italy-chart.sql | 179 | ||||
| -rw-r--r-- | sql-ledger/sql/Simplified_Chinese_Default-chart.sql | 78 | ||||
| -rw-r--r-- | sql-ledger/sql/Spain-chart.sql | 132 | ||||
| -rw-r--r-- | sql-ledger/sql/Traditional_Chinese_Default-chart.sql | 78 |
7 files changed, 0 insertions, 1615 deletions
diff --git a/sql-ledger/sql/Canada-gifi.sql b/sql-ledger/sql/Canada-gifi.sql deleted file mode 100644 index fe9641c72..000000000 --- a/sql-ledger/sql/Canada-gifi.sql +++ /dev/null @@ -1,754 +0,0 @@ --- GIFI codes as set by the Canadian Government --- It's a dirty job, but it seems somebody allready did it --- PDF Tammes, Tue , 02 Apr 2002 --- remarks or questions to finance@bermuda-holding.com --- --- From the GIFI documentation: --- --- The GIFI information has to balance. We use the following rules to verify the information you provide. --- total assets = total liabilities + total shareholder equity --- total revenue - total expenses = net non-farming income --- total farm revenue - total farm expenses = net farm income --- --- You have to provide certain line items so that we can verify the above equations. Each GIFI must include: --- balance sheet --- Item 2599 Total assets --- Item 3499 Total liabilities --- Item 3620 Total shareholder equity --- non-farming income and expenses --- Item 8299 Total revenue --- Item 9368 Total expenses --- and/or --- farming income and expenses --- Item 9659 Total farm revenue --- Item 9898 Total farm expenses --- when reporting a breakdown of retained earnings --- Item 3849 Retained earnings/deficit end --- extraordinary items and income taxes --- Item 9999 Net income/loss after taxes and extraordinary items --- If the amount of a required item is NIL, you have to enter 0. --- -INSERT INTO gifi (accno,description) VALUES ('1000', 'Cash & Deposits'); -INSERT INTO gifi (accno,description) VALUES ('1001', 'Cash'); -INSERT INTO gifi (accno,description) VALUES ('1002', 'Deposits In Canadian Banks And Institutions - Canadian Currency'); -INSERT INTO gifi (accno,description) VALUES ('1003', 'Deposits In Canadian Banks And Institutions - Foreign Currency'); -INSERT INTO gifi (accno,description) VALUES ('1004', 'Deposits In Foreign Banks - Canadian Currency'); -INSERT INTO gifi (accno,description) VALUES ('1005', 'Deposits In Foreign Banks - Foreign Currency'); -INSERT INTO gifi (accno,description) VALUES ('1006', 'Credit Union Central Deposits'); -INSERT INTO gifi (accno,description) VALUES ('1007', 'Other Cash Like Instruments - Gold Bullion, Silver Bullion'); -INSERT INTO gifi (accno,description) VALUES ('1060', 'Accounts Receivable'); -INSERT INTO gifi (accno,description) VALUES ('1061', 'Allowance For Doubtfull Accounts Receivable'); -INSERT INTO gifi (accno,description) VALUES ('1062', 'Trade Accounts Receivable'); -INSERT INTO gifi (accno,description) VALUES ('1063', 'Allowance For Doubtfull Trade Accounts Receivable'); -INSERT INTO gifi (accno,description) VALUES ('1064', 'Trade Accounts Receivable Related Parties'); -INSERT INTO gifi (accno,description) VALUES ('1065', 'Allowance For Doubtfull Trade Accounts Receivable Related Parties'); -INSERT INTO gifi (accno,description) VALUES ('1066', 'Taxes Receivable'); -INSERT INTO gifi (accno,description) VALUES ('1067', 'Intrest Receivable'); -INSERT INTO gifi (accno,description) VALUES ('1068', 'Holdbacks Receivable'); -INSERT INTO gifi (accno,description) VALUES ('1069', 'Leases Receivable'); -INSERT INTO gifi (accno,description) VALUES ('1070', 'Allowance For Doubtfull Leases Receivable'); -INSERT INTO gifi (accno,description) VALUES ('1071', 'Accounts Receivable Employees'); -INSERT INTO gifi (accno,description) VALUES ('1072', 'Allowance For Doubtfull Accounts Receivable Employees'); -INSERT INTO gifi (accno,description) VALUES ('1073', 'Accounts Receivable From Members Of NPO'); -INSERT INTO gifi (accno,description) VALUES ('1120', 'Inventories'); -INSERT INTO gifi (accno,description) VALUES ('1121', 'Inventory Of Goods For Sale/Finished Goods'); -INSERT INTO gifi (accno,description) VALUES ('1122', 'Inventory Of Parts And Supplies'); -INSERT INTO gifi (accno,description) VALUES ('1125', 'Work In Progress'); -INSERT INTO gifi (accno,description) VALUES ('1126', 'Raw Materials'); -INSERT INTO gifi (accno,description) VALUES ('1180', 'Short Term Investments'); -INSERT INTO gifi (accno,description) VALUES ('1181', 'Canadian Term Deposits'); -INSERT INTO gifi (accno,description) VALUES ('1182', 'Canadian Shares'); -INSERT INTO gifi (accno,description) VALUES ('1183', 'Canadian Bonds'); -INSERT INTO gifi (accno,description) VALUES ('1184', 'Canadian Treasury Bills'); -INSERT INTO gifi (accno,description) VALUES ('1185', 'Securities Purchased Under Resale Agreement'); -INSERT INTO gifi (accno,description) VALUES ('1186', 'Other Short Term Canadian Investments'); -INSERT INTO gifi (accno,description) VALUES ('1187', 'Short Term Foreign Investments'); -INSERT INTO gifi (accno,description) VALUES ('1240', 'Loans & Notes Receivable'); -INSERT INTO gifi (accno,description) VALUES ('1241', 'Demand Loans Receivable'); -INSERT INTO gifi (accno,description) VALUES ('1242', 'Other Loans Receivable'); -INSERT INTO gifi (accno,description) VALUES ('1243', 'Notes Receivable'); -INSERT INTO gifi (accno,description) VALUES ('1244', 'Mortgages Receivable'); -INSERT INTO gifi (accno,description) VALUES ('1300', 'Due From Shareholder(s)/Director(s)'); -INSERT INTO gifi (accno,description) VALUES ('1301', 'Due From Individual Shareholder(s)'); -INSERT INTO gifi (accno,description) VALUES ('1302', 'Due From Corporate Shareholder(s)'); -INSERT INTO gifi (accno,description) VALUES ('1303', 'Due From Director(s)'); -INSERT INTO gifi (accno,description) VALUES ('1360', 'Investment In Joint Venture(s)/Partnership(s)'); -INSERT INTO gifi (accno,description) VALUES ('1380', 'Due From Joint Venture(s)/Partnership(s)'); -INSERT INTO gifi (accno,description) VALUES ('1400', 'Due From/Investment In Related Parties'); -INSERT INTO gifi (accno,description) VALUES ('1401', 'Demand Notes From Related Parties'); -INSERT INTO gifi (accno,description) VALUES ('1402', 'Interest Receivable From Related Parties'); -INSERT INTO gifi (accno,description) VALUES ('1403', 'Loans/Advances Due From Related Parties'); -INSERT INTO gifi (accno,description) VALUES ('1480', 'Other Current Assets'); -INSERT INTO gifi (accno,description) VALUES ('1481', 'Deferred Income Taxes'); -INSERT INTO gifi (accno,description) VALUES ('1482', 'Accrued Investment Income'); -INSERT INTO gifi (accno,description) VALUES ('1483', 'Taxes Recoverable/Refundable'); -INSERT INTO gifi (accno,description) VALUES ('1484', 'Prepaid Expenses'); -INSERT INTO gifi (accno,description) VALUES ('1485', 'Drilling Advances'); -INSERT INTO gifi (accno,description) VALUES ('1486', 'Security Deposits'); -INSERT INTO gifi (accno,description) VALUES ('1599', 'Total Current Assets'); -INSERT INTO gifi (accno,description) VALUES ('1600', 'Land'); -INSERT INTO gifi (accno,description) VALUES ('1601', 'Land Improvement'); -INSERT INTO gifi (accno,description) VALUES ('1602', 'Accumulated Amortization Of Land & Land Improvement'); -INSERT INTO gifi (accno,description) VALUES ('1620', 'Depletable Assets'); -INSERT INTO gifi (accno,description) VALUES ('1621', 'Accumulated Amortization Of Depletable Assets'); -INSERT INTO gifi (accno,description) VALUES ('1622', 'Petroleum & Natural Gas Properties'); -INSERT INTO gifi (accno,description) VALUES ('1623', 'Accumulated Amortization Of Petroleum & Natural Gas Properties'); -INSERT INTO gifi (accno,description) VALUES ('1624', 'Mining Properties'); -INSERT INTO gifi (accno,description) VALUES ('1625', 'Accumulated Amortization Of Mining Properties'); -INSERT INTO gifi (accno,description) VALUES ('1626', 'Deferred Exporation & Development charges'); -INSERT INTO gifi (accno,description) VALUES ('1627', 'Accumulated Amortization Of Petroleum & Deferred Exporation & Development charges'); -INSERT INTO gifi (accno,description) VALUES ('1628', 'Quarries'); -INSERT INTO gifi (accno,description) VALUES ('1629', 'Accumulated Amortization Of Quarries'); -INSERT INTO gifi (accno,description) VALUES ('1630', 'Gravel Pits'); -INSERT INTO gifi (accno,description) VALUES ('1631', 'Accumulated Amortization Of Gravel Pits'); -INSERT INTO gifi (accno,description) VALUES ('1632', 'Timber Limits'); -INSERT INTO gifi (accno,description) VALUES ('1633', 'Accumulated Amortization Of Timber Limits'); -INSERT INTO gifi (accno,description) VALUES ('1680', 'Buildings'); -INSERT INTO gifi (accno,description) VALUES ('1681', 'Accumulated Amortization Of Buildings'); -INSERT INTO gifi (accno,description) VALUES ('1682', 'Manufacturing And Processing Plant'); -INSERT INTO gifi (accno,description) VALUES ('1683', 'Accumulated Amortization Of Manufacturing and Processing Plant'); -INSERT INTO gifi (accno,description) VALUES ('1684', 'Buildings Under Construction'); -INSERT INTO gifi (accno,description) VALUES ('1740', 'Machinery, Equipment, furniture & fixtures'); -INSERT INTO gifi (accno,description) VALUES ('1741', 'Accumulated Amortization Of Machinery, Equipment, furniture & fixtures'); -INSERT INTO gifi (accno,description) VALUES ('1742', 'Motor Vehicles'); -INSERT INTO gifi (accno,description) VALUES ('1743', 'Accumulated Amortization Of Motor Vehicles'); -INSERT INTO gifi (accno,description) VALUES ('1744', 'Tools and Dies'); -INSERT INTO gifi (accno,description) VALUES ('1745', 'Accumulated Amortization Of Tools and Dies'); -INSERT INTO gifi (accno,description) VALUES ('1746', 'Construction & Excavating Equipment'); -INSERT INTO gifi (accno,description) VALUES ('1747', 'Accumulated Amortization Of Construction & Excavating Equipment'); -INSERT INTO gifi (accno,description) VALUES ('1748', 'Forestry & Logging Equipment'); -INSERT INTO gifi (accno,description) VALUES ('1749', 'Accumulated Amortization Of Forestry & Logging Equipment'); -INSERT INTO gifi (accno,description) VALUES ('1750', 'Fishing Gear & Nets'); -INSERT INTO gifi (accno,description) VALUES ('1751', 'Accumulated Amortization Of Fishing Gear & Nets'); -INSERT INTO gifi (accno,description) VALUES ('1752', 'Mining Equipment'); -INSERT INTO gifi (accno,description) VALUES ('1753', 'Accumulated Amortization Of Mining Equipment'); -INSERT INTO gifi (accno,description) VALUES ('1754', 'Oil & Gas Systems'); -INSERT INTO gifi (accno,description) VALUES ('1755', 'Accumulated Amortization Of Oil & Gas Systems'); -INSERT INTO gifi (accno,description) VALUES ('1756', 'Production Equipment for resource industries'); -INSERT INTO gifi (accno,description) VALUES ('1757', 'Accumulated Amortization Of Production Equipment for resource industries'); -INSERT INTO gifi (accno,description) VALUES ('1758', 'Production Equipment for other industries'); -INSERT INTO gifi (accno,description) VALUES ('1759', 'Accumulated Amortization Of Production Equipment for other industries'); -INSERT INTO gifi (accno,description) VALUES ('1760', 'Exploration Equipment'); -INSERT INTO gifi (accno,description) VALUES ('1761', 'Accumulated Amortization Of Exploration Equipment'); -INSERT INTO gifi (accno,description) VALUES ('1762', 'Shipping Equipment'); -INSERT INTO gifi (accno,description) VALUES ('1763', 'Accumulated Amortization Of Shipping Equipment'); -INSERT INTO gifi (accno,description) VALUES ('1764', 'Ships & Boats'); -INSERT INTO gifi (accno,description) VALUES ('1765', 'Accumulated Amortization Of Ships & Boats'); -INSERT INTO gifi (accno,description) VALUES ('1766', 'Aircraft'); -INSERT INTO gifi (accno,description) VALUES ('1767', 'Accumulated Amortization Of Aircraft'); -INSERT INTO gifi (accno,description) VALUES ('1768', 'Signs'); -INSERT INTO gifi (accno,description) VALUES ('1769', 'Accumulated Amortization Of Signs'); -INSERT INTO gifi (accno,description) VALUES ('1770', 'Small Tools'); -INSERT INTO gifi (accno,description) VALUES ('1771', 'Accumulated Amortization Of Small Tools'); -INSERT INTO gifi (accno,description) VALUES ('1772', 'Radio & Communication Equipment'); -INSERT INTO gifi (accno,description) VALUES ('1773', 'Accumulated Amortization Of Radio & Communication Equipment'); -INSERT INTO gifi (accno,description) VALUES ('1774', 'Computer Equipment/Software'); -INSERT INTO gifi (accno,description) VALUES ('1775', 'Accumulated Amortization Of Computer Equipment/software'); -INSERT INTO gifi (accno,description) VALUES ('1776', 'Musical Instruments'); -INSERT INTO gifi (accno,description) VALUES ('1777', 'Accumulated Amortization Of Musical Instruments'); -INSERT INTO gifi (accno,description) VALUES ('1778', 'Satellites'); -INSERT INTO gifi (accno,description) VALUES ('1779', 'Accumulated Amortization Of Satellites'); -INSERT INTO gifi (accno,description) VALUES ('1780', 'Earth Stations'); -INSERT INTO gifi (accno,description) VALUES ('1781', 'Accumulated Amortization Of Earth Stations'); -INSERT INTO gifi (accno,description) VALUES ('1782', 'Machinery & Equipment Under Construction'); -INSERT INTO gifi (accno,description) VALUES ('1783', 'Transportation Equipment'); -INSERT INTO gifi (accno,description) VALUES ('1784', 'Accumulated Amortization Of Transportation Equipment'); -INSERT INTO gifi (accno,description) VALUES ('1785', 'Other Machinery & Equipment'); -INSERT INTO gifi (accno,description) VALUES ('1786', 'Accumulated Amortization Of Other Machinery & Equipment'); -INSERT INTO gifi (accno,description) VALUES ('1787', 'Furniture & Fixtures'); -INSERT INTO gifi (accno,description) VALUES ('1788', 'Accumulated Amortization Of Furniture & Fixtures'); -INSERT INTO gifi (accno,description) VALUES ('1900', 'Other Tangible Capital Assets'); -INSERT INTO gifi (accno,description) VALUES ('1901', 'Accumulated Amortization Of Other Tangible Capital Assets'); -INSERT INTO gifi (accno,description) VALUES ('1902', 'Logging Roads'); -INSERT INTO gifi (accno,description) VALUES ('1903', 'Accumulated Amortization Of Logging Roads'); -INSERT INTO gifi (accno,description) VALUES ('1904', 'Asphalt & Parking Areas'); -INSERT INTO gifi (accno,description) VALUES ('1905', 'Accumulated Amortization Of Asphalt & Parking Areas'); -INSERT INTO gifi (accno,description) VALUES ('1906', 'Wharves, Docks & Marinas'); -INSERT INTO gifi (accno,description) VALUES ('1907', 'Accumulated Amortization Of Wharves, Docks & Marinas'); -INSERT INTO gifi (accno,description) VALUES ('1908', 'Fences'); -INSERT INTO gifi (accno,description) VALUES ('1909', 'Accumulated Amortization Of Fences'); -INSERT INTO gifi (accno,description) VALUES ('1910', 'Capital Leases - Buildings'); -INSERT INTO gifi (accno,description) VALUES ('1911', 'Accumulated Amortization Of Capital Leases - Buildings'); -INSERT INTO gifi (accno,description) VALUES ('1912', 'Capital Leases - Equipment'); -INSERT INTO gifi (accno,description) VALUES ('1913', 'Accumulated Amortization Of Capital Leases - Equipment'); -INSERT INTO gifi (accno,description) VALUES ('1914', 'Capital Leases - Vehicles'); -INSERT INTO gifi (accno,description) VALUES ('1915', 'Accumulated Amortization Of Capital Leases - Vehicles'); -INSERT INTO gifi (accno,description) VALUES ('1916', 'Capital Leases - Other'); -INSERT INTO gifi (accno,description) VALUES ('1917', 'Accumulated Amortization Of Capital Leases - Other'); -INSERT INTO gifi (accno,description) VALUES ('1918', 'Leasehold Improvements'); -INSERT INTO gifi (accno,description) VALUES ('1919', 'Accumulated Amortization Of Leasehold Improvements'); -INSERT INTO gifi (accno,description) VALUES ('1920', 'Other Capital Assets Under Construction'); -INSERT INTO gifi (accno,description) VALUES ('1921', 'Campsites'); -INSERT INTO gifi (accno,description) VALUES ('1922', 'Accumulated Amortization Of Campsites'); -INSERT INTO gifi (accno,description) VALUES ('2008', 'Total Tangible Capital Assets'); -INSERT INTO gifi (accno,description) VALUES ('2009', 'Total Accumulated Amortization Of Tangible Capital Assets'); -INSERT INTO gifi (accno,description) VALUES ('2010', 'Intangible Assets'); -INSERT INTO gifi (accno,description) VALUES ('2011', 'Accumulated Amortization Of Intangible Assets'); -INSERT INTO gifi (accno,description) VALUES ('2012', 'Goodwill'); -INSERT INTO gifi (accno,description) VALUES ('2013', 'Accumulated Amortization Of Goodwill'); -INSERT INTO gifi (accno,description) VALUES ('2014', 'Quota'); -INSERT INTO gifi (accno,description) VALUES ('2015', 'Accumulated Amortization Of Quota'); -INSERT INTO gifi (accno,description) VALUES ('2016', 'Licences'); -INSERT INTO gifi (accno,description) VALUES ('2017', 'Accumulated Amortization Of Licences'); -INSERT INTO gifi (accno,description) VALUES ('2018', 'Incorporation Costs'); -INSERT INTO gifi (accno,description) VALUES ('2019', 'Accumulated Amortization Of Incorporation Costs'); -INSERT INTO gifi (accno,description) VALUES ('2020', 'Trademarks & Patents'); -INSERT INTO gifi (accno,description) VALUES ('2021', 'Accumulated Amortization Of Trademarks & Patents'); -INSERT INTO gifi (accno,description) VALUES ('2022', 'Customer Lists'); -INSERT INTO gifi (accno,description) VALUES ('2023', 'Accumulated Amortization Of Customer Lists'); -INSERT INTO gifi (accno,description) VALUES ('2024', 'Rights'); -INSERT INTO gifi (accno,description) VALUES ('2025', 'Accumulated Amortization Of Rights'); -INSERT INTO gifi (accno,description) VALUES ('2026', 'Research & Development'); -INSERT INTO gifi (accno,description) VALUES ('2027', 'Accumulated Amortization Of Research & Development'); -INSERT INTO gifi (accno,description) VALUES ('2070', 'Resource Rights'); -INSERT INTO gifi (accno,description) VALUES ('2071', 'Accumulated Amortization Of Resource Rights'); -INSERT INTO gifi (accno,description) VALUES ('2072', 'Timber Rights'); -INSERT INTO gifi (accno,description) VALUES ('2073', 'Accumulated Amortization Of Timber Rights'); -INSERT INTO gifi (accno,description) VALUES ('2074', 'Mining Rights'); -INSERT INTO gifi (accno,description) VALUES ('2075', 'Accumulated Amortization Of Mining Rights'); -INSERT INTO gifi (accno,description) VALUES ('2076', 'Oil & Gas Rights'); -INSERT INTO gifi (accno,description) VALUES ('2077', 'Accumulated Amortization Of Oil & Gas Rights'); -INSERT INTO gifi (accno,description) VALUES ('2078', 'Total Intangible Capital Assets'); -INSERT INTO gifi (accno,description) VALUES ('2079', 'Total Accumulated Amortization Of Intangible Capital Assets'); -INSERT INTO gifi (accno,description) VALUES ('2180', 'Long Term Due From Shareholder(s)/Director(s)'); -INSERT INTO gifi (accno,description) VALUES ('2181', 'Long Term Due From Individual Shareholder(s)'); -INSERT INTO gifi (accno,description) VALUES ('2182', 'Long Term Due From Corporate Shareholder(s)'); -INSERT INTO gifi (accno,description) VALUES ('2183', 'Long Term Due From Director(s)'); -INSERT INTO gifi (accno,description) VALUES ('2200', 'Long Term Investment In Joint Venture(s)/Partnership(s)'); -INSERT INTO gifi (accno,description) VALUES ('2220', 'Long Term Due From Joint Venture(s)/Partnership(s)'); -INSERT INTO gifi (accno,description) VALUES ('2240', 'Long Term Due From/Investment In Related Parties'); -INSERT INTO gifi (accno,description) VALUES ('2241', 'Due From/Investment In Canadian Related Parties'); -INSERT INTO gifi (accno,description) VALUES ('2242', 'Shares In Canadian Related Corporations'); -INSERT INTO gifi (accno,description) VALUES ('2243', 'Loans/Advances To Canadian Related Corporations'); -INSERT INTO gifi (accno,description) VALUES ('2244', 'Investment In Canadian Related Corporations At Cost'); -INSERT INTO gifi (accno,description) VALUES ('2245', 'Investment In Canadian Related Corporations At Equity'); -INSERT INTO gifi (accno,description) VALUES ('2246', 'Due From/Investment In Foreign Related Parties'); -INSERT INTO gifi (accno,description) VALUES ('2247', 'Shares In Foreign Related Corporations'); -INSERT INTO gifi (accno,description) VALUES ('2248', 'Loans/Advances To Foreign Related Corporations'); -INSERT INTO gifi (accno,description) VALUES ('2249', 'Investment In Foreign Related Corporations At Cost'); -INSERT INTO gifi (accno,description) VALUES ('2250', 'Investment In Foreign Related Corporations At Equity'); -INSERT INTO gifi (accno,description) VALUES ('2280', 'Investment In Co-Tenancy'); -INSERT INTO gifi (accno,description) VALUES ('2300', 'Long Term Investments'); -INSERT INTO gifi (accno,description) VALUES ('2301', 'Foreign Shares'); -INSERT INTO gifi (accno,description) VALUES ('2302', 'Other Type Of Foreign Investments'); -INSERT INTO gifi (accno,description) VALUES ('2303', 'Canadian Shares'); -INSERT INTO gifi (accno,description) VALUES ('2304', 'Government Of Canada Debt'); -INSERT INTO gifi (accno,description) VALUES ('2305', 'Canadian Provinvial & Municipal Government Debt'); -INSERT INTO gifi (accno,description) VALUES ('2306', 'Canadian Corporate Bonds & Debentures'); -INSERT INTO gifi (accno,description) VALUES ('2307', 'Debt Securities'); -INSERT INTO gifi (accno,description) VALUES ('2308', 'Equity Securities'); -INSERT INTO gifi (accno,description) VALUES ('2309', 'Securities Purchased Under Resale Agreements'); -INSERT INTO gifi (accno,description) VALUES ('2310', 'Central Credit Union Shares'); -INSERT INTO gifi (accno,description) VALUES ('2311', 'Other Long Term Canadian Investments'); -INSERT INTO gifi (accno,description) VALUES ('2360', 'Long Term Loans'); -INSERT INTO gifi (accno,description) VALUES ('2361', 'Mortgages'); -INSERT INTO gifi (accno,description) VALUES ('2362', 'Personal & Credit Card Loans'); -INSERT INTO gifi (accno,description) VALUES ('2363', 'Business & Government Loans'); -INSERT INTO gifi (accno,description) VALUES ('2364', 'Line Of Credit'); -INSERT INTO gifi (accno,description) VALUES ('2420', 'Other Long Term Assets'); -INSERT INTO gifi (accno,description) VALUES ('2421', 'Deferred Income Taxes / Tax Reserves'); -INSERT INTO gifi (accno,description) VALUES ('2422', 'Deferred Pension Charges'); -INSERT INTO gifi (accno,description) VALUES ('2423', 'Deferred Unrealized Exchange Losses'); -INSERT INTO gifi (accno,description) VALUES ('2424', 'Other Deferred Items/Charges'); -INSERT INTO gifi (accno,description) VALUES ('2425', 'Accumulated Amortization Of Deferred Charges'); -INSERT INTO gifi (accno,description) VALUES ('2426', 'Reserve Fund'); -INSERT INTO gifi (accno,description) VALUES ('2427', 'Cash Surrender Value Of Life Insurance'); -INSERT INTO gifi (accno,description) VALUES ('2589', 'Total Long Term Assets'); -INSERT INTO gifi (accno,description) VALUES ('2590', 'Assets Held In Trust'); -INSERT INTO gifi (accno,description) VALUES ('2599', 'Total Assets'); -INSERT INTO gifi (accno,description) VALUES ('2600', 'Bank Overdraft'); -INSERT INTO gifi (accno,description) VALUES ('2620', 'Amounts Payable & Accrued Liabilities'); -INSERT INTO gifi (accno,description) VALUES ('2621', 'Accounts Payable Trade'); -INSERT INTO gifi (accno,description) VALUES ('2622', 'Accounts Payable To Related Parties'); -INSERT INTO gifi (accno,description) VALUES ('2623', 'Holdbacks Payable'); -INSERT INTO gifi (accno,description) VALUES ('2624', 'Wages Payable'); -INSERT INTO gifi (accno,description) VALUES ('2625', 'Management Fees Payable'); -INSERT INTO gifi (accno,description) VALUES ('2626', 'Bonuses Payable'); -INSERT INTO gifi (accno,description) VALUES ('2627', 'Employee Deductions Payable'); -INSERT INTO gifi (accno,description) VALUES ('2628', 'Withholding Taxes Payable'); -INSERT INTO gifi (accno,description) VALUES ('2629', 'Intrest Payable'); -INSERT INTO gifi (accno,description) VALUES ('2680', 'Taxes Payable'); -INSERT INTO gifi (accno,description) VALUES ('2681', 'Capital Taxes Payable'); -INSERT INTO gifi (accno,description) VALUES ('2682', 'Foreign Taxes Payable'); -INSERT INTO gifi (accno,description) VALUES ('2683', 'Federal Taxes Payable'); -INSERT INTO gifi (accno,description) VALUES ('2684', 'Provincial Taxes Payable'); -INSERT INTO gifi (accno,description) VALUES ('2685', 'GST Payable'); -INSERT INTO gifi (accno,description) VALUES ('2686', 'PST Payable'); -INSERT INTO gifi (accno,description) VALUES ('2700', 'Short Term Debt'); -INSERT INTO gifi (accno,description) VALUES ('2701', 'Loans From Canadian Banks'); -INSERT INTO gifi (accno,description) VALUES ('2702', 'Liability For Securities Sold Short'); -INSERT INTO gifi (accno,description) VALUES ('2703', 'Liability For Securities Sold Under Repurchase Agreements'); -INSERT INTO gifi (accno,description) VALUES ('2704', 'Gold & Silver Certificates'); -INSERT INTO gifi (accno,description) VALUES ('2705', 'Cheques & Other Items In Transit'); -INSERT INTO gifi (accno,description) VALUES ('2706', 'Lien Notes'); -INSERT INTO gifi (accno,description) VALUES ('2770', 'Deferred Income'); -INSERT INTO gifi (accno,description) VALUES ('2780', 'Due To Shareholder(s)/Director(s)'); -INSERT INTO gifi (accno,description) VALUES ('2781', 'Due To Individual Shareholder(s)'); -INSERT INTO gifi (accno,description) VALUES ('2782', 'Due To Corporate Shareholder(s)'); -INSERT INTO gifi (accno,description) VALUES ('2783', 'Due To Director(s)'); -INSERT INTO gifi (accno,description) VALUES ('2840', 'Due To Joint Venture(s)/Partnership(s)'); -INSERT INTO gifi (accno,description) VALUES ('2860', 'Due To Related Parties'); -INSERT INTO gifi (accno,description) VALUES ('2861', 'Demand Notes Due To Related Parties'); -INSERT INTO gifi (accno,description) VALUES ('2862', 'Interest Payable To Related Parties'); -INSERT INTO gifi (accno,description) VALUES ('2863', 'Advances Due To Related Parties'); -INSERT INTO gifi (accno,description) VALUES ('2920', 'Current Portion Of Long Term Liability'); -INSERT INTO gifi (accno,description) VALUES ('2960', 'Other Current Liabilities'); -INSERT INTO gifi (accno,description) VALUES ('2961', 'Deposits Received'); -INSERT INTO gifi (accno,description) VALUES ('2962', 'Dividends Payable'); -INSERT INTO gifi (accno,description) VALUES ('2963', 'Deferred Income Taxes'); -INSERT INTO gifi (accno,description) VALUES ('2964', 'Reserves For Guarantees, Warranties Or Indemnities'); -INSERT INTO gifi (accno,description) VALUES ('2965', 'General Reserves / Provisions'); -INSERT INTO gifi (accno,description) VALUES ('2966', 'Crew Shares'); -INSERT INTO gifi (accno,description) VALUES ('3139', 'Total Current Liabilities'); -INSERT INTO gifi (accno,description) VALUES ('3140', 'Long Term Debt'); -INSERT INTO gifi (accno,description) VALUES ('3141', 'Mortgages'); -INSERT INTO gifi (accno,description) VALUES ('3142', 'Farm Credit Corporation Loan'); -INSERT INTO gifi (accno,description) VALUES ('3143', 'Chartered Bank Loan'); -INSERT INTO gifi (accno,description) VALUES ('3144', 'Credit Union/Caisse Populaire Loan'); -INSERT INTO gifi (accno,description) VALUES ('3145', 'Provincial Government Loan'); -INSERT INTO gifi (accno,description) VALUES ('3146', 'Supply Company Loan'); -INSERT INTO gifi (accno,description) VALUES ('3147', 'Private Loan'); -INSERT INTO gifi (accno,description) VALUES ('3148', 'Central, Leagues And Federation Loans'); -INSERT INTO gifi (accno,description) VALUES ('3149', 'Line Of Credit'); -INSERT INTO gifi (accno,description) VALUES ('3150', 'Liability For Securities Sold Short'); -INSERT INTO gifi (accno,description) VALUES ('3151', 'Liability For Securities Sold Under Repurchase Agreements'); -INSERT INTO gifi (accno,description) VALUES ('3152', 'Lien Notes'); -INSERT INTO gifi (accno,description) VALUES ('3210', 'Bonds And Debentures'); -INSERT INTO gifi (accno,description) VALUES ('3220', 'Deferred Income'); -INSERT INTO gifi (accno,description) VALUES ('3240', 'Deferred Income Taxes'); -INSERT INTO gifi (accno,description) VALUES ('3260', 'Long Term Due To Shareholder(s)/Director(s)'); -INSERT INTO gifi (accno,description) VALUES ('3261', 'Long Term Due To Individual Shareholder(s)'); -INSERT INTO gifi (accno,description) VALUES ('3262', 'Long Term Due To Corporate Shareholder(s)'); -INSERT INTO gifi (accno,description) VALUES ('3263', 'Long Term Due To Director(s)'); -INSERT INTO gifi (accno,description) VALUES ('3280', 'Long Term Due To Joint Venture(s)/Partnership(s)'); -INSERT INTO gifi (accno,description) VALUES ('3300', 'Long Term Due To Related Parties'); -INSERT INTO gifi (accno,description) VALUES ('3301', 'Amounts Owing To Related Canadian Parties'); -INSERT INTO gifi (accno,description) VALUES ('3302', 'Amounts Owing To Related Foreign Parties'); -INSERT INTO gifi (accno,description) VALUES ('3320', 'Other Long Term Liabilities'); -INSERT INTO gifi (accno,description) VALUES ('3321', 'Long Term Obligations/Commitments/Leases'); -INSERT INTO gifi (accno,description) VALUES ('3322', 'Reserves For Guarantees, Warranties Or Indemnities'); -INSERT INTO gifi (accno,description) VALUES ('3323', 'Provision For Site Restoration'); -INSERT INTO gifi (accno,description) VALUES ('3324', 'Contributions To Qualifying Environmental Trust'); -INSERT INTO gifi (accno,description) VALUES ('3325', 'General Provisions / Reserves'); -INSERT INTO gifi (accno,description) VALUES ('3326', 'Preference Shares Restated'); -INSERT INTO gifi (accno,description) VALUES ('3327', 'Member Allocations'); -INSERT INTO gifi (accno,description) VALUES ('3328', 'Deferred Income From Incomplete Contracts'); -INSERT INTO gifi (accno,description) VALUES ('3450', 'Total Long Term Liabilities'); -INSERT INTO gifi (accno,description) VALUES ('3460', 'Subordinated Debt'); -INSERT INTO gifi (accno,description) VALUES ('3470', 'Amounts Held In Trust'); -INSERT INTO gifi (accno,description) VALUES ('3499', 'Total Liabilities'); -INSERT INTO gifi (accno,description) VALUES ('3500', 'Common Shares'); -INSERT INTO gifi (accno,description) VALUES ('3520', 'Preferred Shares'); -INSERT INTO gifi (accno,description) VALUES ('3540', 'Contributed & Other Surplus'); -INSERT INTO gifi (accno,description) VALUES ('3541', 'Contributed Surplus'); -INSERT INTO gifi (accno,description) VALUES ('3542', 'Appraisal Surplus'); -INSERT INTO gifi (accno,description) VALUES ('3543', 'General Reserve'); -INSERT INTO gifi (accno,description) VALUES ('3570', 'Head Office Account'); -INSERT INTO gifi (accno,description) VALUES ('3600', 'Retained Earnings/Deficit'); -INSERT INTO gifi (accno,description) VALUES ('3620', 'Total Shareholder Equity'); -INSERT INTO gifi (accno,description) VALUES ('3640', 'Total Liabilities & Shareholder Equity'); -INSERT INTO gifi (accno,description) VALUES ('3660', 'Retained Earnings/Deficit Start'); -INSERT INTO gifi (accno,description) VALUES ('3680', 'Net Income/Loss'); -INSERT INTO gifi (accno,description) VALUES ('3700', 'Dividend Declared'); -INSERT INTO gifi (accno,description) VALUES ('3701', 'Cash Dividend'); -INSERT INTO gifi (accno,description) VALUES ('3702', 'Patronage Dividend'); -INSERT INTO gifi (accno,description) VALUES ('3720', 'Prior Year Adjustments'); -INSERT INTO gifi (accno,description) VALUES ('3740', 'Other Items Affecting Retained Earnings'); -INSERT INTO gifi (accno,description) VALUES ('3741', 'Share Redemptions'); -INSERT INTO gifi (accno,description) VALUES ('3742', 'Special Reserves'); -INSERT INTO gifi (accno,description) VALUES ('3743', 'Currency Adjustments'); -INSERT INTO gifi (accno,description) VALUES ('3744', 'Unusual Revenue Items'); -INSERT INTO gifi (accno,description) VALUES ('3745', 'Interfund Transfers (NPO)'); -INSERT INTO gifi (accno,description) VALUES ('3849', 'Retained Earnings/Deficit End'); -INSERT INTO gifi (accno,description) VALUES ('8000', 'Trade Sales of Goods and Services'); -INSERT INTO gifi (accno,description) VALUES ('8020', 'Sales To Related Parties'); -INSERT INTO gifi (accno,description) VALUES ('8030', 'Interdivisional Sales'); -INSERT INTO gifi (accno,description) VALUES ('8040', 'Sales From Resource Properties'); -INSERT INTO gifi (accno,description) VALUES ('8041', 'Petroleum & Natural Gas Sales'); -INSERT INTO gifi (accno,description) VALUES ('8042', 'Petroleum & Natural Gas Sales To Related Parties'); -INSERT INTO gifi (accno,description) VALUES ('8043', 'Gas Marketing'); -INSERT INTO gifi (accno,description) VALUES ('8044', 'Processing Revenue'); -INSERT INTO gifi (accno,description) VALUES ('8045', 'Pipeline Revenue'); -INSERT INTO gifi (accno,description) VALUES ('8046', 'Seismic Sales'); -INSERT INTO gifi (accno,description) VALUES ('8047', 'Mining Revenue'); -INSERT INTO gifi (accno,description) VALUES ('8048', 'Coal Revenue'); -INSERT INTO gifi (accno,description) VALUES ('8049', 'Oil Sands Revenue'); -INSERT INTO gifi (accno,description) VALUES ('8050', 'Royalty Income'); -INSERT INTO gifi (accno,description) VALUES ('8051', 'Oil & Gas Partnership/Joint Venture Income/Loss'); -INSERT INTO gifi (accno,description) VALUES ('8052', 'Mining Partnership/Joint Venture Income/Loss'); -INSERT INTO gifi (accno,description) VALUES ('8053', 'Other Production Revenue'); -INSERT INTO gifi (accno,description) VALUES ('8089', 'Total Sales Of Goods And Services'); -INSERT INTO gifi (accno,description) VALUES ('8090', 'Investment Revenue'); -INSERT INTO gifi (accno,description) VALUES ('8091', 'Interest From Foreign Sources'); -INSERT INTO gifi (accno,description) VALUES ('8092', 'Interest From Canadian Bonds And Debentures'); -INSERT INTO gifi (accno,description) VALUES ('8093', 'Interest From Canadian Mortgage Loans'); -INSERT INTO gifi (accno,description) VALUES ('8094', 'Interest From Other Canadian Sources'); -INSERT INTO gifi (accno,description) VALUES ('8095', 'Dividend Income'); -INSERT INTO gifi (accno,description) VALUES ('8096', 'Dividend From Canadian Sources'); -INSERT INTO gifi (accno,description) VALUES ('8097', 'Interest From Foreign Sources'); -INSERT INTO gifi (accno,description) VALUES ('8120', 'Commission Revenue'); -INSERT INTO gifi (accno,description) VALUES ('8121', 'Commission Income On Real Estate Transactions'); -INSERT INTO gifi (accno,description) VALUES ('8140', 'Rental Revenue'); -INSERT INTO gifi (accno,description) VALUES ('8141', 'Real Estate Rental Revenue'); -INSERT INTO gifi (accno,description) VALUES ('8150', 'Vehicle Leasing'); -INSERT INTO gifi (accno,description) VALUES ('8160', 'Fishing Revenue'); -INSERT INTO gifi (accno,description) VALUES ('8161', 'Fish Products'); -INSERT INTO gifi (accno,description) VALUES ('8162', 'Other Marine Products'); -INSERT INTO gifi (accno,description) VALUES ('8163', 'Fishing Grants, Credits & Rebates'); -INSERT INTO gifi (accno,description) VALUES ('8164', 'Fishing Subsidies'); -INSERT INTO gifi (accno,description) VALUES ('8165', 'Compensation For Loss Of Fishing Income/Property'); -INSERT INTO gifi (accno,description) VALUES ('8166', 'Sharesman Income'); -INSERT INTO gifi (accno,description) VALUES ('8210', 'Realized Gains/Losses On Disposal Of Assets'); -INSERT INTO gifi (accno,description) VALUES ('8211', 'Realized Gains/Losses On Sale Of Investments'); -INSERT INTO gifi (accno,description) VALUES ('8212', 'Realized Gains/Losses On Sale Of Resource Properties'); -INSERT INTO gifi (accno,description) VALUES ('8220', 'NPO Amounts Received'); -INSERT INTO gifi (accno,description) VALUES ('8221', 'Membership Fees'); -INSERT INTO gifi (accno,description) VALUES ('8222', 'Assessments'); -INSERT INTO gifi (accno,description) VALUES ('8223', 'Gifts'); -INSERT INTO gifi (accno,description) VALUES ('8224', 'Gross Sales And Revenues From Organizational Activities'); -INSERT INTO gifi (accno,description) VALUES ('8230', 'Other Revenue'); -INSERT INTO gifi (accno,description) VALUES ('8231', 'Foreign Exchange Gains/Losses'); -INSERT INTO gifi (accno,description) VALUES ('8232', 'Income/Loss Of Subsidiaries/Affiliates'); -INSERT INTO gifi (accno,description) VALUES ('8233', 'Income/Loss Of Other Divisions'); -INSERT INTO gifi (accno,description) VALUES ('8234', 'Income/Loss Of Joint Ventures'); -INSERT INTO gifi (accno,description) VALUES ('8235', 'Income/Loss Of Partnerships'); -INSERT INTO gifi (accno,description) VALUES ('8236', 'RealizaTion Of Deferred Revenues'); -INSERT INTO gifi (accno,description) VALUES ('8237', 'Royalty Income Other Than Resource'); -INSERT INTO gifi (accno,description) VALUES ('8238', 'Alberta Royalty Tax Credits'); -INSERT INTO gifi (accno,description) VALUES ('8239', 'Management & Administration Fees'); -INSERT INTO gifi (accno,description) VALUES ('8240', 'Telecommunications Revenues'); -INSERT INTO gifi (accno,description) VALUES ('8241', 'Consulting Fees'); -INSERT INTO gifi (accno,description) VALUES ('8242', 'Subsidies & Grants'); -INSERT INTO gifi (accno,description) VALUES ('8243', 'Sale Of By-Products'); -INSERT INTO gifi (accno,description) VALUES ('8244', 'Deposit Services'); -INSERT INTO gifi (accno,description) VALUES ('8245', 'Credit Services'); -INSERT INTO gifi (accno,description) VALUES ('8246', 'Card Services'); -INSERT INTO gifi (accno,description) VALUES ('8247', 'Patronage Dividends'); -INSERT INTO gifi (accno,description) VALUES ('8248', 'Insurance Recoveries'); -INSERT INTO gifi (accno,description) VALUES ('8249', 'Expense Recoveries'); -INSERT INTO gifi (accno,description) VALUES ('8250', 'Bad Debt Recoveries'); -INSERT INTO gifi (accno,description) VALUES ('8299', 'Total Revenue'); -INSERT INTO gifi (accno,description) VALUES ('8300', 'Opening Inventory'); -INSERT INTO gifi (accno,description) VALUES ('8301', 'Opening Inventory - finished goods'); -INSERT INTO gifi (accno,description) VALUES ('8302', 'Opening Inventory - raw materials'); -INSERT INTO gifi (accno,description) VALUES ('8303', 'Opening Inventory - goods in process'); -INSERT INTO gifi (accno,description) VALUES ('8304', 'Opening Inventory - work in process'); -INSERT INTO gifi (accno,description) VALUES ('8320', 'Purchases / Cost of Materials'); -INSERT INTO gifi (accno,description) VALUES ('8321', 'Purchases Product A'); -INSERT INTO gifi (accno,description) VALUES ('8322', 'Purchases Product B'); -INSERT INTO gifi (accno,description) VALUES ('8331', 'Price Differences & Discounts On Purchases'); -INSERT INTO gifi (accno,description) VALUES ('8340', 'Direct Wages'); -INSERT INTO gifi (accno,description) VALUES ('8350', 'Benefits On Direct Wages'); -INSERT INTO gifi (accno,description) VALUES ('8360', 'Trades & Sub-contracts'); -INSERT INTO gifi (accno,description) VALUES ('8370', 'Production Costs Other Than Resource'); -INSERT INTO gifi (accno,description) VALUES ('8400', 'Resource Production Costs'); -INSERT INTO gifi (accno,description) VALUES ('8401', 'Pipeline Operations'); -INSERT INTO gifi (accno,description) VALUES ('8402', 'Drilling'); -INSERT INTO gifi (accno,description) VALUES ('8403', 'Site Restoration Costs'); -INSERT INTO gifi (accno,description) VALUES ('8404', 'Gross Overriding Royalty'); -INSERT INTO gifi (accno,description) VALUES ('8405', 'Freehold Royalties'); -INSERT INTO gifi (accno,description) VALUES ('8406', 'Other Producing Properties Rental'); -INSERT INTO gifi (accno,description) VALUES ('8407', 'Prospect & Geological'); -INSERT INTO gifi (accno,description) VALUES ('8408', 'Well Operating, Fuel & Equipment'); -INSERT INTO gifi (accno,description) VALUES ('8409', 'Well Abandonment & Dry Holes'); -INSERT INTO gifi (accno,description) VALUES ('8410', 'Other Lease Rentals'); -INSERT INTO gifi (accno,description) VALUES ('8411', 'Exploration Expenses, Aerial Surveys'); -INSERT INTO gifi (accno,description) VALUES ('8412', 'Development Expenses, stripping costs'); -INSERT INTO gifi (accno,description) VALUES ('8435', 'Crown Charges'); -INSERT INTO gifi (accno,description) VALUES ('8436', 'Crown royalties'); -INSERT INTO gifi (accno,description) VALUES ('8437', 'Crown lease rentals'); -INSERT INTO gifi (accno,description) VALUES ('8438', 'Freehold mineral tax'); -INSERT INTO gifi (accno,description) VALUES ('8439', 'Mining taxes'); -INSERT INTO gifi (accno,description) VALUES ('8440', 'Oil and Sand leases'); -INSERT INTO gifi (accno,description) VALUES ('8441', 'Saskatchewan resource surcharge'); -INSERT INTO gifi (accno,description) VALUES ('8450', 'Other Direct Costs'); -INSERT INTO gifi (accno,description) VALUES ('8451', 'Equipment Hire & Operation'); -INSERT INTO gifi (accno,description) VALUES ('8452', 'Log Yard'); -INSERT INTO gifi (accno,description) VALUES ('8453', 'Forestry costs'); -INSERT INTO gifi (accno,description) VALUES ('8454', 'Logging Road costs'); -INSERT INTO gifi (accno,description) VALUES ('8455', 'Stumpage costs'); -INSERT INTO gifi (accno,description) VALUES ('8456', 'Royalty costs'); -INSERT INTO gifi (accno,description) VALUES ('8457', 'Freight In & Customs Duty'); -INSERT INTO gifi (accno,description) VALUES ('8458', 'Inventory Write Down'); -INSERT INTO gifi (accno,description) VALUES ('8459', 'Direct cost amortization of tangible assets'); -INSERT INTO gifi (accno,description) VALUES ('8460', 'Direct cost amortization of natural resource assets'); -INSERT INTO gifi (accno,description) VALUES ('8461', 'Overhead expenses allocated to cost of sales'); -INSERT INTO gifi (accno,description) VALUES ('8500', 'Closing Inventory'); -INSERT INTO gifi (accno,description) VALUES ('8501', 'Closing Inventory - Finished Goods'); -INSERT INTO gifi (accno,description) VALUES ('8502', 'Closing Inventory - Raw Materials'); -INSERT INTO gifi (accno,description) VALUES ('8503', 'Closing Inventory - Goods In Process'); -INSERT INTO gifi (accno,description) VALUES ('8504', 'Closing Inventory - Work In Process'); -INSERT INTO gifi (accno,description) VALUES ('8518', 'Cost Of Sales'); -INSERT INTO gifi (accno,description) VALUES ('8519', 'Gross Profit/Loss'); -INSERT INTO gifi (accno,description) VALUES ('8520', 'Advertising & Promotion'); -INSERT INTO gifi (accno,description) VALUES ('8521', 'Advertising'); -INSERT INTO gifi (accno,description) VALUES ('8522', 'Donations'); -INSERT INTO gifi (accno,description) VALUES ('8523', 'Meals & Entertainment'); -INSERT INTO gifi (accno,description) VALUES ('8524', 'Promotion'); -INSERT INTO gifi (accno,description) VALUES ('8570', 'Amortization Of Intangible Assets'); -INSERT INTO gifi (accno,description) VALUES ('8590', 'Bad Debt Expense'); -INSERT INTO gifi (accno,description) VALUES ('8610', 'Loan Losses'); -INSERT INTO gifi (accno,description) VALUES ('8611', 'Provision for Loan Losses'); -INSERT INTO gifi (accno,description) VALUES ('8620', 'Employee Benefits'); -INSERT INTO gifi (accno,description) VALUES ('8621', 'Group Insurance Benefits'); -INSERT INTO gifi (accno,description) VALUES ('8622', 'Employers Portion Of Employee Benefits'); -INSERT INTO gifi (accno,description) VALUES ('8623', 'Contributions To Deferred Income Plans'); -INSERT INTO gifi (accno,description) VALUES ('8650', 'Amortization Of Natural Resource Assets'); -INSERT INTO gifi (accno,description) VALUES ('8670', 'Amortization Of Tangible Assets'); -INSERT INTO gifi (accno,description) VALUES ('8690', 'Insurance'); -INSERT INTO gifi (accno,description) VALUES ('8691', 'Life Insurance On Executives'); -INSERT INTO gifi (accno,description) VALUES ('8710', 'Interest & Bank Charges'); -INSERT INTO gifi (accno,description) VALUES ('8711', 'Interest On Short Term Debt'); -INSERT INTO gifi (accno,description) VALUES ('8712', 'Interest On Bonds And Debentures'); -INSERT INTO gifi (accno,description) VALUES ('8713', 'Interest On Mortgages'); -INSERT INTO gifi (accno,description) VALUES ('8714', 'Interest On Long Term Debt'); -INSERT INTO gifi (accno,description) VALUES ('8715', 'Bank Charges'); -INSERT INTO gifi (accno,description) VALUES ('8716', 'Credit Card Charges'); -INSERT INTO gifi (accno,description) VALUES ('8717', 'Collection & Credit costs'); -INSERT INTO gifi (accno,description) VALUES ('8760', 'Business Taxes, Licences & Memberships'); -INSERT INTO gifi (accno,description) VALUES ('8761', 'Memberships'); -INSERT INTO gifi (accno,description) VALUES ('8762', 'Business Taxes'); -INSERT INTO gifi (accno,description) VALUES ('8763', 'Franchise Fees'); -INSERT INTO gifi (accno,description) VALUES ('8764', 'Government Fees'); -INSERT INTO gifi (accno,description) VALUES ('8780', 'New Brunswick Tax On Large Corporations'); -INSERT INTO gifi (accno,description) VALUES ('8790', 'Nova Scotia Tax On Large Corporations'); -INSERT INTO gifi (accno,description) VALUES ('8810', 'Office Expenses'); -INSERT INTO gifi (accno,description) VALUES ('8811', 'Office Stationary And Supplies'); -INSERT INTO gifi (accno,description) VALUES ('8812', 'Office Utilities'); -INSERT INTO gifi (accno,description) VALUES ('8813', 'Data Processing'); -INSERT INTO gifi (accno,description) VALUES ('8860', 'Professional Fees'); -INSERT INTO gifi (accno,description) VALUES ('8861', 'Legal Fees'); -INSERT INTO gifi (accno,description) VALUES ('8862', 'Accounting Fees'); -INSERT INTO gifi (accno,description) VALUES ('8863', 'Consulting Fees'); -INSERT INTO gifi (accno,description) VALUES ('8864', 'Architect Fees'); -INSERT INTO gifi (accno,description) VALUES ('8865', 'Appraisal Fees'); -INSERT INTO gifi (accno,description) VALUES ('8866', 'Laboratory Fees'); -INSERT INTO gifi (accno,description) VALUES ('8867', 'Medical Fees'); -INSERT INTO gifi (accno,description) VALUES ('8868', 'Veterinary Fees'); -INSERT INTO gifi (accno,description) VALUES ('8869', 'Brokerage Fees'); -INSERT INTO gifi (accno,description) VALUES ('8870', 'Transfer Fees'); -INSERT INTO gifi (accno,description) VALUES ('8871', 'Management & Administration Fees'); -INSERT INTO gifi (accno,description) VALUES ('8872', 'Refining & Assay'); -INSERT INTO gifi (accno,description) VALUES ('8873', 'Registrar & Transfer Agent Fees'); -INSERT INTO gifi (accno,description) VALUES ('8874', 'Restructuring Costs'); -INSERT INTO gifi (accno,description) VALUES ('8875', 'Security & Exchange Commission Fees'); -INSERT INTO gifi (accno,description) VALUES ('8876', 'Training Expense'); -INSERT INTO gifi (accno,description) VALUES ('8877', 'Studio & Recording'); -INSERT INTO gifi (accno,description) VALUES ('8910', 'Rental'); -INSERT INTO gifi (accno,description) VALUES ('8911', 'Real Estate Rental'); -INSERT INTO gifi (accno,description) VALUES ('8912', 'Occupancy Costs'); -INSERT INTO gifi (accno,description) VALUES ('8913', 'Condominium Fees'); -INSERT INTO gifi (accno,description) VALUES ('8914', 'Equipment Rental'); -INSERT INTO gifi (accno,description) VALUES ('8915', 'Motor Vehicle Rental'); -INSERT INTO gifi (accno,description) VALUES ('8916', 'Moorage (Boat)'); -INSERT INTO gifi (accno,description) VALUES ('8917', 'Storage'); -INSERT INTO gifi (accno,description) VALUES ('8918', 'Quota Rental'); -INSERT INTO gifi (accno,description) VALUES ('8960', 'Repairs & Maintenance - Aircraft'); -INSERT INTO gifi (accno,description) VALUES ('8961', 'Repairs & Maintenance - Buildings'); -INSERT INTO gifi (accno,description) VALUES ('8962', 'Repairs & Maintenance - Vehicles'); -INSERT INTO gifi (accno,description) VALUES ('8963', 'Repairs & Maintenance - Boats'); -INSERT INTO gifi (accno,description) VALUES ('8964', 'Repairs & Maintenance - Machinery & Equipment'); -INSERT INTO gifi (accno,description) VALUES ('9010', 'Other Repairs & Maintenance - Janitor & Yard'); -INSERT INTO gifi (accno,description) VALUES ('9011', 'Machine Shop Expense'); -INSERT INTO gifi (accno,description) VALUES ('9012', 'Road Costs'); -INSERT INTO gifi (accno,description) VALUES ('9013', 'Security'); -INSERT INTO gifi (accno,description) VALUES ('9014', 'Garbage Removal'); -INSERT INTO gifi (accno,description) VALUES ('9060', 'Salaries & Wages'); -INSERT INTO gifi (accno,description) VALUES ('9061', 'Commissions'); -INSERT INTO gifi (accno,description) VALUES ('9062', 'Crew Share'); -INSERT INTO gifi (accno,description) VALUES ('9063', 'Bonuses'); -INSERT INTO gifi (accno,description) VALUES ('9064', 'Director''s Fees'); -INSERT INTO gifi (accno,description) VALUES ('9065', 'Management Salaries'); -INSERT INTO gifi (accno,description) VALUES ('9066', 'Employee Salaries'); -INSERT INTO gifi (accno,description) VALUES ('9110', 'Sub-Contracts'); -INSERT INTO gifi (accno,description) VALUES ('9130', 'Supplies'); -INSERT INTO gifi (accno,description) VALUES ('9131', 'Small Tools'); -INSERT INTO gifi (accno,description) VALUES ('9132', 'Shop Expense'); -INSERT INTO gifi (accno,description) VALUES ('9133', 'Uniforms'); -INSERT INTO gifi (accno,description) VALUES ('9134', 'Laundry'); -INSERT INTO gifi (accno,description) VALUES ('9135', 'Food & Catering'); -INSERT INTO gifi (accno,description) VALUES ('9136', 'Fishing Gear'); -INSERT INTO gifi (accno,description) VALUES ('9137', 'Nets & Traps'); -INSERT INTO gifi (accno,description) VALUES ('9138', 'Salt, Bait & Ice'); -INSERT INTO gifi (accno,description) VALUES ('9139', 'Camp Supplies'); -INSERT INTO gifi (accno,description) VALUES ('9150', 'Computer Related Expenses'); -INSERT INTO gifi (accno,description) VALUES ('9151', 'Upgrade'); -INSERT INTO gifi (accno,description) VALUES ('9152', 'Internet'); -INSERT INTO gifi (accno,description) VALUES ('9180', 'Property Taxes'); -INSERT INTO gifi (accno,description) VALUES ('9200', 'Travel Expenses'); -INSERT INTO gifi (accno,description) VALUES ('9201', 'Meetings & Conventions'); -INSERT INTO gifi (accno,description) VALUES ('9220', 'Utilities'); -INSERT INTO gifi (accno,description) VALUES ('9221', 'Electricity'); -INSERT INTO gifi (accno,description) VALUES ('9222', 'Water'); -INSERT INTO gifi (accno,description) VALUES ('9223', 'Heat'); -INSERT INTO gifi (accno,description) VALUES ('9224', 'Fuel Costs'); -INSERT INTO gifi (accno,description) VALUES ('9225', 'Telephone & Communications'); -INSERT INTO gifi (accno,description) VALUES ('9270', 'Other Expenses'); -INSERT INTO gifi (accno,description) VALUES ('9271', 'Cash Over/Short'); -INSERT INTO gifi (accno,description) VALUES ('9272', 'Reimbursement Of Parent Company Expense'); -INSERT INTO gifi (accno,description) VALUES ('9273', 'Selling Expenses'); -INSERT INTO gifi (accno,description) VALUES ('9274', 'Shipping & Warehouse Expenses'); -INSERT INTO gifi (accno,description) VALUES ('9275', 'Delivery, Freight & Express'); -INSERT INTO gifi (accno,description) VALUES ('9276', 'Warranty Expenses'); -INSERT INTO gifi (accno,description) VALUES ('9277', 'Royalty Expenses - Resident'); -INSERT INTO gifi (accno,description) VALUES ('9278', 'Royalty Expenses - Non-Resident'); -INSERT INTO gifi (accno,description) VALUES ('9279', 'Dumping Charges'); -INSERT INTO gifi (accno,description) VALUES ('9280', 'Land Fill Fees'); -INSERT INTO gifi (accno,description) VALUES ('9281', 'Vehicle Expenses'); -INSERT INTO gifi (accno,description) VALUES ('9282', 'Research & Development'); -INSERT INTO gifi (accno,description) VALUES ('9283', 'Withholding Taxes'); -INSERT INTO gifi (accno,description) VALUES ('9284', 'General & Administrative Expenses'); -INSERT INTO gifi (accno,description) VALUES ('9285', 'Interdivisional Expenses'); -INSERT INTO gifi (accno,description) VALUES ('9286', 'Interfund Transfer (NPO)'); -INSERT INTO gifi (accno,description) VALUES ('9367', 'Total Operating Expenses'); -INSERT INTO gifi (accno,description) VALUES ('9368', 'Total Expenses'); -INSERT INTO gifi (accno,description) VALUES ('9369', 'Net Non-Farming Income'); -INSERT INTO gifi (accno,description) VALUES ('9370', 'Grains And Oilseeds'); -INSERT INTO gifi (accno,description) VALUES ('9371', 'Wheat'); -INSERT INTO gifi (accno,description) VALUES ('9372', 'Oats'); -INSERT INTO gifi (accno,description) VALUES ('9373', 'Barley'); -INSERT INTO gifi (accno,description) VALUES ('9374', 'Mixed Grains'); -INSERT INTO gifi (accno,description) VALUES ('9375', 'Corn'); -INSERT INTO gifi (accno,description) VALUES ('9376', 'Canola'); -INSERT INTO gifi (accno,description) VALUES ('9377', 'Flaxseed'); -INSERT INTO gifi (accno,description) VALUES ('9378', 'Soya Beans'); -INSERT INTO gifi (accno,description) VALUES ('9379', 'Wheat Board Payments'); -INSERT INTO gifi (accno,description) VALUES ('9420', 'Other Crop Revenues'); -INSERT INTO gifi (accno,description) VALUES ('9321', 'Fruit'); -INSERT INTO gifi (accno,description) VALUES ('9322', 'Potatoes'); -INSERT INTO gifi (accno,description) VALUES ('9323', 'Vegetables'); -INSERT INTO gifi (accno,description) VALUES ('9324', 'Tobacco'); -INSERT INTO gifi (accno,description) VALUES ('9325', 'Greenhouse & Nursery Products'); -INSERT INTO gifi (accno,description) VALUES ('9326', 'Forage Crops'); -INSERT INTO gifi (accno,description) VALUES ('9470', 'Livestock & Animal Products Revenue'); -INSERT INTO gifi (accno,description) VALUES ('9471', 'Cattle'); -INSERT INTO gifi (accno,description) VALUES ('9472', 'Swine'); -INSERT INTO gifi (accno,description) VALUES ('9473', 'Poultry'); -INSERT INTO gifi (accno,description) VALUES ('9474', 'Sheep & Lambs'); -INSERT INTO gifi (accno,description) VALUES ('9475', 'Pregnant Mare Urine (PMU)'); -INSERT INTO gifi (accno,description) VALUES ('9476', 'Milk & Cream - Excluding Dairy Subsidies'); -INSERT INTO gifi (accno,description) VALUES ('9477', 'Eggs For Consumption'); -INSERT INTO gifi (accno,description) VALUES ('9478', 'Hatching Eggs'); -INSERT INTO gifi (accno,description) VALUES ('9479', 'Aquaculture'); -INSERT INTO gifi (accno,description) VALUES ('9480', 'Horses - Breeding & Meat'); -INSERT INTO gifi (accno,description) VALUES ('9520', 'Other Commodities'); -INSERT INTO gifi (accno,description) VALUES ('9521', 'Maple Products'); -INSERT INTO gifi (accno,description) VALUES ('9522', 'Artificial Insemination (AI)'); -INSERT INTO gifi (accno,description) VALUES ('9523', 'Semen Production'); -INSERT INTO gifi (accno,description) VALUES ('9524', 'Embryo Production'); -INSERT INTO gifi (accno,description) VALUES ('9540', 'Program Payment Revenues'); -INSERT INTO gifi (accno,description) VALUES ('9541', 'Dairy Subsidies'); -INSERT INTO gifi (accno,description) VALUES ('9542', 'Crop Insurance'); -INSERT INTO gifi (accno,description) VALUES ('9543', 'NISA Payments'); -INSERT INTO gifi (accno,description) VALUES ('9544', 'Disaster Assistance Program Payments'); -INSERT INTO gifi (accno,description) VALUES ('9570', 'Rebates'); -INSERT INTO gifi (accno,description) VALUES ('9571', 'Rebates - Fuel'); -INSERT INTO gifi (accno,description) VALUES ('9572', 'Rebates - Interest'); -INSERT INTO gifi (accno,description) VALUES ('9573', 'Rebates - Property Taxes'); -INSERT INTO gifi (accno,description) VALUES ('9574', 'Resales, Rebates, GST For NISA Eligible Expenses'); -INSERT INTO gifi (accno,description) VALUES ('9575', 'Rebates, GST For NISA Non-Eligible Expenses'); -INSERT INTO gifi (accno,description) VALUES ('9600', 'Other Farm Revenues/Losses'); -INSERT INTO gifi (accno,description) VALUES ('9601', 'Custom Or Contract Work'); -INSERT INTO gifi (accno,description) VALUES ('9602', 'Wood Sales'); -INSERT INTO gifi (accno,description) VALUES ('9603', 'Horse Racing'); -INSERT INTO gifi (accno,description) VALUES ('9604', 'Insurance Proceeds'); -INSERT INTO gifi (accno,description) VALUES ('9605', 'Patronage Dividends'); -INSERT INTO gifi (accno,description) VALUES ('9606', 'Rental Income'); -INSERT INTO gifi (accno,description) VALUES ('9607', 'Interest Income'); -INSERT INTO gifi (accno,description) VALUES ('9608', 'Dividend Income'); -INSERT INTO gifi (accno,description) VALUES ('9609', 'Gains/Losses On Disposal Of Assets'); -INSERT INTO gifi (accno,description) VALUES ('9610', 'Gravel'); -INSERT INTO gifi (accno,description) VALUES ('9611', 'Trucking'); -INSERT INTO gifi (accno,description) VALUES ('9612', 'Resale Of Commodities Purchased'); -INSERT INTO gifi (accno,description) VALUES ('9613', 'Leases'); -INSERT INTO gifi (accno,description) VALUES ('9614', 'Machine Rentals'); -INSERT INTO gifi (accno,description) VALUES ('9615', 'Farming Partnership Income/Loss'); -INSERT INTO gifi (accno,description) VALUES ('9616', 'Farming Joint Venture Income/Loss'); -INSERT INTO gifi (accno,description) VALUES ('9650', 'Non-Farming Income'); -INSERT INTO gifi (accno,description) VALUES ('9659', 'Total Farm Revenue'); -INSERT INTO gifi (accno,description) VALUES ('9660', 'Crop Expenses'); -INSERT INTO gifi (accno,description) VALUES ('9661', 'Containers, Twine And Baling Wire'); -INSERT INTO gifi (accno,description) VALUES ('9662', 'Fertilizers And Lime'); -INSERT INTO gifi (accno,description) VALUES ('9663', 'Pesticides'); -INSERT INTO gifi (accno,description) VALUES ('9664', 'Seeds & Plants'); -INSERT INTO gifi (accno,description) VALUES ('9665', 'Insurance Premiums (Crop) NISA ACS'); -INSERT INTO gifi (accno,description) VALUES ('9710', 'Livestock Expenses'); -INSERT INTO gifi (accno,description) VALUES ('9711', 'Feed, Supplements, Straw & Bedding'); -INSERT INTO gifi (accno,description) VALUES ('9712', 'Livestock Purchases'); -INSERT INTO gifi (accno,description) VALUES ('9713', 'Veterinary Fees, Medicine & Breeding Fees'); -INSERT INTO gifi (accno,description) VALUES ('9760', 'Machinery Expenses'); -INSERT INTO gifi (accno,description) VALUES ('9761', 'Machinery Insurance'); -INSERT INTO gifi (accno,description) VALUES ('9762', 'Machinery Licences'); -INSERT INTO gifi (accno,description) VALUES ('9763', 'Machinery Repairs'); -INSERT INTO gifi (accno,description) VALUES ('9764', 'Machinery Fuel'); -INSERT INTO gifi (accno,description) VALUES ('9765', 'Machinery Lease'); -INSERT INTO gifi (accno,description) VALUES ('9790', 'General Farm Expenses'); -INSERT INTO gifi (accno,description) VALUES ('9791', 'Amortization Of Tangible Assets'); -INSERT INTO gifi (accno,description) VALUES ('9792', 'Advertising, Marketing Costs & Promotion'); -INSERT INTO gifi (accno,description) VALUES ('9793', 'Bad Debt'); -INSERT INTO gifi (accno,description) VALUES ('9794', 'Benefits Related To Employee Salaries'); -INSERT INTO gifi (accno,description) VALUES ('9795', 'Building Repairs & Maintenance'); -INSERT INTO gifi (accno,description) VALUES ('9796', 'Clearing, Levelling & Draining Land'); -INSERT INTO gifi (accno,description) VALUES ('9797', 'Crop Insurance, GRIP and Stabilization Premiums'); -INSERT INTO gifi (accno,description) VALUES ('9798', 'Custom Or Contract Work'); -INSERT INTO gifi (accno,description) VALUES ('9799', 'Electricity'); -INSERT INTO gifi (accno,description) VALUES ('9800', 'Fence Repairs & Maintenance'); -INSERT INTO gifi (accno,description) VALUES ('9801', 'Freight & Trucking'); -INSERT INTO gifi (accno,description) VALUES ('9802', 'Heating Fuel & Curing Fuel'); -INSERT INTO gifi (accno,description) VALUES ('9803', 'Insurance Program Overpayment Recapture'); -INSERT INTO gifi (accno,description) VALUES ('9804', 'Other Insurance Premiums'); -INSERT INTO gifi (accno,description) VALUES ('9805', 'Interest & Bank Charges'); -INSERT INTO gifi (accno,description) VALUES ('9806', 'Marketing Board Fees'); -INSERT INTO gifi (accno,description) VALUES ('9807', 'Membership/Subscription Fees'); -INSERT INTO gifi (accno,description) VALUES ('9808', 'Office Expenses'); -INSERT INTO gifi (accno,description) VALUES ('9809', 'Professional Fees'); -INSERT INTO gifi (accno,description) VALUES ('9810', 'Property Taxes'); -INSERT INTO gifi (accno,description) VALUES ('9811', 'Rent - Land & Buildings'); -INSERT INTO gifi (accno,description) VALUES ('9812', 'Rent - Machinery'); -INSERT INTO gifi (accno,description) VALUES ('9813', 'Other Rental Expenses'); -INSERT INTO gifi (accno,description) VALUES ('9814', 'Salaries & Wages'); -INSERT INTO gifi (accno,description) VALUES ('9815', 'Salaries & Wages Other Than Spouse Or Dependants'); -INSERT INTO gifi (accno,description) VALUES ('9816', 'Salaries & Wages Paid To Dependants'); -INSERT INTO gifi (accno,description) VALUES ('9817', 'Selling Costs'); -INSERT INTO gifi (accno,description) VALUES ('9818', 'Supplies'); -INSERT INTO gifi (accno,description) VALUES ('9819', 'Motor Vehicle Expenses'); -INSERT INTO gifi (accno,description) VALUES ('9820', 'Small Tools'); -INSERT INTO gifi (accno,description) VALUES ('9821', 'Soil Testing'); -INSERT INTO gifi (accno,description) VALUES ('9822', 'Storage/Drying'); -INSERT INTO gifi (accno,description) VALUES ('9823', 'Licences/Permits'); -INSERT INTO gifi (accno,description) VALUES ('9824', 'Telephone'); -INSERT INTO gifi (accno,description) VALUES ('9825', 'Quota Rental'); -INSERT INTO gifi (accno,description) VALUES ('9826', 'Gravel'); -INSERT INTO gifi (accno,description) VALUES ('9827', 'Purchases Of Commodities Resold'); -INSERT INTO gifi (accno,description) VALUES ('9828', 'Salaries & Wages Paid To Spouse'); -INSERT INTO gifi (accno,description) VALUES ('9829', 'Motor Vehicle Interest And Leasing Costs'); -INSERT INTO gifi (accno,description) VALUES ('9830', 'Prepared Feed'); -INSERT INTO gifi (accno,description) VALUES ('9831', 'Custom Feed'); -INSERT INTO gifi (accno,description) VALUES ('9832', 'Amortization Of Intangible Assets'); -INSERT INTO gifi (accno,description) VALUES ('9833', 'Amortization Of Milk Quota'); -INSERT INTO gifi (accno,description) VALUES ('9834', 'Travel Expenses'); -INSERT INTO gifi (accno,description) VALUES ('9835', 'Capital/Business Taxes'); -INSERT INTO gifi (accno,description) VALUES ('9850', 'Non-Farming Expenses'); -INSERT INTO gifi (accno,description) VALUES ('9870', 'Net Inventory Adjustment'); -INSERT INTO gifi (accno,description) VALUES ('9898', 'Total Farm Expenses'); -INSERT INTO gifi (accno,description) VALUES ('9899', 'Net Farm Income'); -INSERT INTO gifi (accno,description) VALUES ('9970', 'Net Income/Loss Before Taxes And Extraordinary Items'); -INSERT INTO gifi (accno,description) VALUES ('9975', 'Extraordinary Items'); -INSERT INTO gifi (accno,description) VALUES ('9976', 'Legal Settlements'); -INSERT INTO gifi (accno,description) VALUES ('9980', 'Unrealized Gains/Losses'); -INSERT INTO gifi (accno,description) VALUES ('9985', 'Unusual Items'); -INSERT INTO gifi (accno,description) VALUES ('9990', 'Current Income Taxes'); -INSERT INTO gifi (accno,description) VALUES ('9995', 'Deferred Income Tax Provision'); -INSERT INTO gifi (accno,description) VALUES ('9999', 'Net Income/Loss After Taxes And Extraordinary Items'); --- This item represents the net amount of: --- Item 9970 - Net income/loss before taxes and extraordinary items minus --- Item 9975 - Extraordinary item(s) minus --- Item 9976 - Legal settlements plus --- Item 9980 - Unrealized gains/losses minus --- Item 9985 - Unusual items minus --- Item 9990 - Current income taxes minus --- Item 9995 - Deferred income tax provision --- and must be reported. --- Any amount reported in this item should be equal to the amount reported at Item 3680 - Net income/loss, --- in the retained earnings section. --- diff --git a/sql-ledger/sql/Canada_General-chart.sql b/sql-ledger/sql/Canada_General-chart.sql deleted file mode 100644 index a0b9e7f37..000000000 --- a/sql-ledger/sql/Canada_General-chart.sql +++ /dev/null @@ -1,77 +0,0 @@ --- General Canadian COA --- sample only -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1000','CURRENT ASSETS','H','1000','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1060','Chequing Account','A','1002','A','AR_paid:AP_paid'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1065','Petty Cash','A','1001','A','AR_paid:AP_paid'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1200','Accounts Receivables','A','1060','A','AR'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1205','Allowance for doubtful accounts','A','1063','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1500','INVENTORY ASSETS','H','1120','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1520','Inventory / General','A','1122','A','IC'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1530','Inventory / Aftermarket Parts','A','1122','A','IC'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1540','Inventory / Computer Parts','A','1122','A','IC'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1800','CAPITAL ASSETS','H','1900','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1820','Office Furniture & Equipment','A','1787','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1825','Accum. Amort. -Furn. & Equip.','A','1788','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1840','Vehicle','A','1742','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1845','Accum. Amort. -Vehicle','A','1743','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2000','CURRENT LIABILITIES','H','2620','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2100','Accounts Payable','A','2621','L','AP'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2160','Federal Taxes Payable','A','2683','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2170','Provincial Taxes Payable','A','2684','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2310','GST','A','2685','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice:CT_tax'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2320','PST','A','2686','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice:CT_tax'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2380','Vacation Pay Payable','A','2624','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2390','WCB Payable','A','2627','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2400','PAYROLL DEDUCTIONS','H','2620','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2410','EI Payable','A','2627','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2420','CPP Payable','A','2627','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2450','Income Tax Payable','A','2628','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2600','LONG TERM LIABILITIES','H','3140','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2620','Bank Loans','A','2701','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2680','Loans from Shareholders','A','2780','L','AP_paid'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3300','SHARE CAPITAL','H','3500','Q',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3350','Common Shares','A','3500','Q',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4000','SALES REVENUE','H','8000','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4020','General Sales','A','8000','I','AR_amount:IC_sale'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4030','Aftermarket Parts','A','8000','I','AR_amount:IC_sale'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4040','Computer Parts','A','8000','I','AR_amount:IC_sale'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4300','CONSULTING REVENUE','H','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4320','Consulting','A','8241','I','AR_amount:IC_income'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4330','Programming','A','8000','I','AR_amount:IC_income'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4340','Shop Labour','A','8000','I','AR_amount:IC_income'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4400','OTHER REVENUE','H','8090','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4430','Shipping & Handling','A','8457','I','IC_income'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4440','Interest','A','8090','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4450','Foreign Exchange Gain','A','8231','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5000','COST OF GOODS SOLD','H','8515','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5010','Purchases','A','8320','E','AP_amount:IC_cogs:IC_expense'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5050','Aftermarket Parts','A','8320','E','AP_amount:IC_cogs'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5060','Computer Parts','A','8320','E','AP_amount:IC_cogs'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5100','Freight','A','8457','E','AP_amount:IC_expense'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5400','PAYROLL EXPENSES','H','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5410','Wages & Salaries','A','9060','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5420','EI Expense','A','8622','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5430','CPP Expense','A','8622','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5440','WCB Expense','A','8622','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5600','GENERAL & ADMINISTRATIVE EXPENSES','H','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5610','Accounting & Legal','A','8862','E','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5615','Advertising & Promotions','A','8520','E','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5620','Bad Debts','A','8590','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5660','Amortization Expense','A','8670','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5680','Income Taxes','A','9990','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5685','Insurance','A','9804','E','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5690','Interest & Bank Charges','A','9805','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5700','Office Supplies','A','8811','E','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5760','Rent','A','9811','E','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5765','Repair & Maintenance','A','8964','E','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5780','Telephone','A','9225','E','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5785','Travel & Entertainment','A','8523','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5790','Utilities','A','8812','E','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5800','Licenses','A','8760','E','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5810','Foreign Exchange Loss','A','8231','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 = '2320'),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'), invnumber = '1000', sonumber = '1000', ponumber = '1000', curr = 'CAD:USD:EUR', weightunit = 'kg'; --- diff --git a/sql-ledger/sql/Czech_Republic-chart.sql b/sql-ledger/sql/Czech_Republic-chart.sql deleted file mode 100644 index c43fed4d3..000000000 --- a/sql-ledger/sql/Czech_Republic-chart.sql +++ /dev/null @@ -1,317 +0,0 @@ --- Czech chart of accounts --- Tomas.Fencl@centrum.cz --- Kompletní úètová osnova platná v roce 2001 --- Osnova má 2 místa pro tvorbu analytik --- -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1000', 'Dlouhodobý nehmotný majetek','A','','A','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1100', 'Zøizovací výdaje','A','','A','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1200', 'Nehmotné výsledky výzkumu a vývoje','A','','A','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1300', 'Software','A','','A','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1400', 'Ocenitelná práva','A','','A','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1800', 'Drobný dlouhodobý nehmotný majetek','A','','A','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1900', 'Ostatní dlouhodobý nehmotný majetek','A','','A','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2000', 'Dlouhodobý Hmotný majetek odpisovaný','H','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2100', 'Stavby','A','','A','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2200', 'Samostatné movité vìci a soubory movitých vìcí','A','','A','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2500', 'Pìstitelské celky trvalých porostù','A','','A','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2600', 'Základní stádo a ta¾ná zvíøata','A','','A','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2800', 'Drobný dlouhodobý hmotný majetek','A','','A','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2900', 'Ostatní dlouhodobý hmotný majetek','A','','A','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3000', 'Dlouhodobý hmotný majetek neodpisovaný','H','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3100', 'Pozemky','A','','A','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3200', 'Umìlecká díla a sbírky','A','','A','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4000', 'Poøízení dlouhodobého nehmotného a hmotného majetku','A','','A','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4100', 'Poøízení dlouhodobého nehmotného majetku','A','','A','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4200', 'Poøízení dlouhodobého hmotného majetku','A','','A','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5000', 'Poskytnuté zálohy na dlouhodobý nehmotný a hmotný majetek','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5100', 'Poskytnuté zálohy na dlouhodobý nehmotný majetek','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5200', 'Poskytnuté zálohy na dlouhodobý hmotný majetek','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6000', 'Dlouhodobý finanèní majetek','H','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6100', 'Podílové cenné papíry a vklady v podnicích s rozhodujícím','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6200', 'Podílové cenné papíry a vklady v podnicích s podstatným','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6300', 'Ostatní dlouhodobé cenné papíry a vklady','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6600', 'Pùjèky podnikùm ve skupinì','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6700', 'Ostatní pùjèky','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6900', 'Ostatní dlouhodobý finanèní majetek','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7000', 'Oprávky k dlouhodobému nehmotnému majetku','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7100', 'Oprávky ke zøizovacím výdajùm','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7200', 'Oprávky k nehmotným výsledkùm výzkumu a vývoje','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7300', 'Oprávky k softwaru','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7400', 'Oprávky k ocenitelným právùm','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7800', 'Oprávky k drobnému dlouhodobému nehmotnému majetku','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7900', 'Oprávky k ostatnímu dlouhodobému nehmotnému majetku','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8000', 'Oprávky k dlouhodobému hmotnému majetku','H','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8100', 'Oprávky ke stavbám','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8200', 'Oprávky k samostatným movitým vìcem a souborùm movitých vìcí','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8500', 'Oprávky k pìstitelským celkùm trvalých porostù','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8600', 'Oprávky k základnímu stádu a ta¾ným zvíøatùm','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8800', 'Oprávky k drobnému dlouhodobému hmotnému majetku','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8900', 'Oprávky k ostatnímu dlouhodobému hmotnému majetku','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9000', 'Opravné polo¾ky k dlouhodobému majetku','H','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9100', 'Opravná polo¾ka k dlouhodobému nehmotnému majetku','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9200', 'Opravná polo¾ka k dlouhodobému hmotnému majetku','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9300', 'Opravná polo¾ka k dlouhodobému nedokonèenému nehmotnému','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9400', 'Opravná polo¾ka k dlouhodobému nedokonèenému hmotnému','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9500', 'Opravná polo¾ka k poskytnutým zálohám','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9600', 'Opravná polo¾ka k dlouhodobému finanènímu majetku','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9700', 'Opravná polo¾ka k nabytému majetku','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9800', 'Oprávky k opravné polo¾ce k nabytému majetku','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('10000', 'Zásoby','H','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('11000', 'Materiál','H','','A','IC'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('11100', 'Poøízení materiálu','A','','A','IC'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('11200', 'Materiál na skladì','A','','A','IC'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('11900', 'Materiál na cestì','A','','A','IC'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('12000', 'Zásoby vlastní výroby','H','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('12100', 'Nedokonèená výroba','A','','A','IC'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('12200', 'Polotovary vlastní výroby','A','','A','IC'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('12300', 'Výrobky','A','','A','IC'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('12400', 'Zvíøata','A','','A','IC'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('13000', 'Zbo¾í','H','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('13100', 'Poøízení zbo¾í','A','','A','IC'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('13200', 'Zbo¾í na skladì a v prodejnách','A','','A','IC'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('13900', 'Zbo¾í na cestì','A','','A','IC'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('19000', 'Opravné polo¾ky k zásobám','H','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('19100', 'Opravná polo¾ka k materiálu','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('19200', 'Opravná polo¾ka k nedokonèené výrobì','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('19300', 'Opravná polo¾ka k polotovarùm vlastní výroby','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('19400', 'Opravná polo¾ka k výrobkùm','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('19500', 'Opravná polo¾ka ke zvíøatùm','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('19600', 'Opravná polo¾ka ke zbo¾í','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('20000', 'Finanèní úèty','H','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('21000', 'Peníze','A','','A','AR_paid:AP_paid'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('21100', 'Pokladna','A','','A','AR_paid:AP_paid'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('21300', 'Ceniny','A','','A','AR_paid:AP_paid'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('22000', 'Úèty v bankách','H','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('22100', 'Bankovní úèty','A','','A','AR_paid:AP_paid'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('22200', 'Bankovní úèty klientù','A','','A','AR_paid:AP_paid'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('23000', 'Bì¾né bankovní úvìry','H','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('23100', 'Krátkodobé bankovní úvìry','A','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('23200', 'Eskontní úvìry','A','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('24000', 'Jiné krátkodobé finanèní výpomoci','H','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('24100', 'Emitované krátkodobé dluhopisy','A','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('24900', 'Ostatní krátkodobé finanèní výpomoci','A','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('25000', 'Krátkodobý finanèní majetek','H','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('25100', 'Majetkové cenné papíry','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('25200', 'Vlastní akcie a vlastní obchodní podíly','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('25300', 'Dlu¾né cenné papíry','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('25500', 'Vlastní dluhopisy','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('25600', 'Ostatní cenné papíry','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('26000', 'Pøevody mezi finanèními úèty','H','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('26100', 'Peníze na cestì','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('29000', 'Opravné polo¾ky ke krátkodobému finanènímu majetku','H','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('29100', 'Opravná polo¾ka k majetkovým cenným papírùm','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('29300', 'Opravná polo¾ka k dlu¾ným cenným papírùm','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('30000', 'Zúètovací vztahy','H','','H',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('31000', 'Pohledávky','H','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('31100', 'Odbìratelé','A','','A','AR'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('31200', 'Smìnky k inkasu','A','','A','AR'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('31300', 'Pohledávky za eskontované cenné papíry','A','','A','AR'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('31400', 'Poskytnuté provozní zálohy','A','','A','AR'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('31500', 'Ostatní pohledávky','A','','A','AR'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('32000', 'Závazky','H','','L','AP'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('32100', 'Dodavatelé','A','','L','AP'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('32200', 'Smìnky k úhradì','A','','L','AP'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('32400', 'Pøijaté zálohy','A','','L','AP'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('32500', 'Ostatní závazky','A','','L','AP'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('32600', ' Závazky vùèi klientùm','A','','L','AP'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('32700', ' Závazky vùèi trhùm','A','','L','AP'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('33000', 'Zúètování se zamìstnanci a institucemi','H','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('33100', 'Zamìstnanci','A','','L','AP'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('33300', 'Ostatní závazky vùèi zamìstnancùm','A','','L','AP'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('33500', 'Pohledávky za zamìstnanci','A','','A','AR'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('33600', 'Zúètování s institucemi sociálního zabezpeèení a zdravotního','A','','L','AP'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('34000', 'Zúètování daní a dotací','H','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('34100', 'Daò z pøíjmù','A','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('34200', 'Ostatní pøímé danì','A','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('34300', 'Daò z pøidané hodnoty - zúètování','A','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('34311', 'DPH 5% vstup','A','','L','AP_tax:IC_taxpart:IC_taxservice:CT_tax'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('34312', 'DPH 22% vstup','A','','L','AP_tax:IC_taxpart:IC_taxservice:CT_tax'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('34321', 'DPH 5% výstup','A','','L','AR_tax:IC_taxpart:IC_taxservice:CT_tax'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('34322', 'DPH 22% výstup','A','','L','AR_tax:IC_taxpart:IC_taxservice:CT_tax'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('34500', 'Ostatní danì a poplatky','A','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('34600', 'Dotace ze státního rozpoètu','A','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('34700', 'Ostatní dotace','A','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('35000', 'Pohledávky ke spoleèníkùm a sdru¾ení','H','','A','AR'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('35100', 'Pohledávky k podnikùm ve skupinì','A','','A','AR'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('35300', 'Pohledávky za upsaný vlastní kapitál','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('35400', 'Pohledávky za spoleèníky pøi úhradì ztráty','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('35500', 'Ostatní pohledávky za spoleèníky','A','','A','AR'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('35800', 'Pohledávky k úèastníkùm sdru¾ení','A','','A','AR'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('36000', 'Závazky ke spoleèníkùm a sdru¾ení','H','','L','AP'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('36100', 'Závazky k podnikùm ve skupinì','A','','L','AP'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('36400', 'Závazky ke spoleèníkùm pøi rozdìlování zisku','A','','L','AP'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('36500', 'Ostatní závazky ke spoleèníkùm','A','','L','AP'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('36600', 'Závazky ke spoleèníkùm a èlenùm dru¾stva ze závislé','A','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('36700', 'Závazky z upsaných nesplacených cenných papírù a vkladù','A','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('36800', 'Závazky k úèastníkùm sdru¾ení','A','','L','AP'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('37000', 'Jiné pohledávky a závazky','H','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('37100', 'Odlo¾ená daòová pohledávka a závazek','A','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('37300', 'Nakoupené opce','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('37400', 'Prodané opce','A','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('37500', 'Pohledávky z emitovaných dluhopisù','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('37700', ' Zúètování obchodù','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('37800', 'Jiné pohledávky','A','','A','AR'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('37900', 'Jiné závazky','A','','L','AP'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('38000', 'Pøechodné úèty aktiv a pasív','H','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('38100', 'Náklady pøí¹tích období','A','','A','AP'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('38200', 'Komplexní náklady pøí¹tích období','A','','A','AP'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('38300', 'Výdaje pøí¹tích období','A','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('38400', 'Výnosy pøí¹tích období','A','','L','AR'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('38500', 'Pøíjmy pøí¹tích období','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('38600', 'Kursové rozdíly aktivní','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('38700', 'Kursové rozdíly pasívní','A','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('38800', 'Dohadné úèty aktivní','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('38900', 'Dohadné úèty pasívní','A','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('39000', 'Opravná polo¾ka k zúètovacím vztahùm a vnitøní zúètování','H','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('39100', 'Opravná polo¾ka k pohledávkám','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('39500', 'Vnitøní zúètování','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('39800', 'Spojovací úèet pøi sdru¾ení','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('40000', 'Kapitálové úèty a dlouhodobé závazky','H','','Q',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('41000', 'Základní kapitál a kapitálové fondy','H','','Q',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('41100', 'Základní kapitál','A','','Q',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('41200', 'Emisní á¾io','A','','Q',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('41300', 'Ostatní kapitálové fondy','A','','Q',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('41400', 'Oceòovací rozdíly z pøecenìní majetku a závazkù','A','','Q',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('42000', 'Fondy ze zisku a pøevedené hospodáøské výsledky','H','','Q',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('42100', 'Zákonný rezervní fond','A','','Q',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('42200', 'Nedìlitelný fond','A','','Q',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('42300', 'Statutární fondy','A','','Q',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('42700', 'Ostatní fondy','A','','Q',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('42800', 'Nerozdìlený zisk minulých let','A','','Q',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('42900', 'Neuhrazená ztráta minulých let','A','','Q',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('43000', 'Hospodáøský výsledek','H','','Q',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('43100', 'Hospodáøský výsledek ve schvalovacím øízení','A','','Q',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('45000', 'Rezervy','H','','Q',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('45100', 'Rezervy zákonné','A','','Q',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('45400', 'Rezerva na kursové ztráty','A','','Q',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('45900', 'Ostatní rezervy','A','','Q',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('46000', 'Bankovní úvìry','H','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('46100', 'Bankovní úvìry','A','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('47000', 'Dlouhodobé závazky','H','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('47100', 'Dlouhodobé závazky k podnikùm ve skupinì','A','','L','AP'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('47300', 'Emitované dluhopisy','A','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('47400', 'Závazky z pronájmu','A','','L','AP'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('47500', 'Dlouhodobé pøijaté zálohy','A','','L','AP'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('47800', 'Dlouhodobé smìnky k úhradì','A','','L','AP'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('47900', 'Ostatní dlouhodobé závazky','A','','L','AP'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('49000', 'Individuální podnikatel','A','','Q',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('49100', 'Úèet individuálního podnikatele','A','','Q',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('50000', 'Spotøebované nákupy','A','','E','AP_amount:IC_COGS'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('50100', 'Spotøeba materiálu','A','','E','AP_amount:IC_COGS'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('50200', 'Spotøeba energie','A','','E','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('50300', 'Spotøeba ostatních neskladovatelných dodávek','A','','E','AP_amount:IC_COGS'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('50400', 'Prodané zbo¾í','A','','E','AP_amount:IC_COGS'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('51000', 'Slu¾by','A','','E','AP_amount:IC_expense'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('51100', 'Opravy a udr¾ování','A','','E','AP_amount:IC_expense'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('51200', 'Cestovné','A','','E','AP_amount:IC_expense'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('51300', 'Náklady na reprezentaci','A','','E','AP_amount:IC_expense'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('51800', 'Ostatní slu¾by','A','','E','AP_amount:IC_expense'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('52000', 'Osobní náklady','A','','E','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('52100', 'Mzdové náklady','A','','E','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('52200', 'Pøíjmy spoleèníkù a èlenù dru¾stva ze závislé èinnosti','A','','E','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('52300', 'Odmìny èlenùm orgánù spoleènosti a dru¾stva','A','','E','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('52400', 'Zákonné sociální poji¹tìní','A','','E','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('52500', 'Ostatní sociální poji¹tìní','A','','E','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('52600', 'Sociální náklady individuálního podnikatele','A','','E','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('52700', 'Zákonné sociální náklady','A','','E','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('52800', 'Ostatní sociální náklady','A','','E','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('53000', 'Danì a poplatky','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('53100', 'Daò silnièní','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('53200', 'Daò z nemovitostí','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('53800', 'Ostatní danì a poplatky','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('54000', 'Jiné provozní náklady','A','','E','AP_amount:IC_expense'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('54100', 'Zùstatková cena prodaného dlouhodobého nehmotného a hmotného','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('54200', 'Prodaný materiál','A','','E','IC_COGS'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('54300', 'Dary','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('54400', 'Smluvní pokuty a úroky z prodlení','A','','E','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('54500', 'Ostatní pokuty a penále','A','','E','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('54600', 'Odpis pohledávky','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('54800', 'Ostatní provozní náklady','A','','E','AP_amount:IC_expense'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('55000', 'Odpisy, rezervy a opravné polo¾ky provozních nákladù','H','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('55100', 'Odpisy dlouhodobého nehmotného a hmotného majetku','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('55200', 'Tvorba zákonných rezerv','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('55400', 'Tvorba ostatních rezerv','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('55500', 'Zúètování komplexních nákladù pøí¹tích období','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('55700', 'Zúètování oprávky k opravné polo¾ce k nabytému majetku','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('55800', 'Tvorba zákonných opravných polo¾ek','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('55900', 'Tvorba opravných polo¾ek','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('56000', 'Finanèní náklady','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('56100', 'Prodané cenné papíry a vklady','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('56200', 'Úroky','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('56300', 'Kursové ztráty','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('56800', 'Ostatní finanèní náklady','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('57000', 'Rezervy a opravné polo¾ky finanèních nákladù','H','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('57400', 'Tvorba rezerv','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('57900', 'Tvorba opravných polo¾ek','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('58000', 'Mimoøádné náklady','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('58100', 'Náklady na zmìnu metody','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('58200', 'Manka a ¹kody','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('58400', 'Tvorba rezerv','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('58800', 'Ostatní mimoøádné náklady','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('58900', 'Tvorba opravných polo¾ek','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('59000', 'Danì z pøíjmù a pøevodové úèty','H','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('59100', 'Daò z pøíjmù z bì¾né èinnosti - splatná','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('59200', 'Daò z pøíjmù z bì¾né èinnosti - odlo¾ená','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('59300', 'Daò z pøíjmù z mimoøádné èinnosti - splatná','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('59400', 'Daò z pøíjmù z mimoøádné èinnosti - odlo¾ené','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('59500', 'Dodateèné odvody danì z pøíjmù','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('59600', 'Pøevod podílu na hospodáøském výsledku spoleèníkùm','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('59700', 'Pøevod provozních nákladù','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('59800', 'Pøevod finanèních nákladù','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('60000', 'Tr¾by za vlastní výkony a zbo¾í','A','','I','AR_amount:IC_sale:IC_Income'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('60100', 'Tr¾by za vlastní výrobky','A','','I','AR_amount:IC_sale'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('60200', 'Tr¾by z prodeje slu¾eb','A','','I','AR_amount:IC_income'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('60400', 'Tr¾by za zbo¾í','A','','I','AR_amount:IC_sale'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('61000', 'Zmìny stavu vnitropodnikových zásob','A','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('61100', 'Zmìna stavu nedokonèené výroby','A','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('61200', 'Zmìna stavu polotovarù','A','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('61300', 'Zmìna stavu výrobkù','A','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('61400', 'Zmìna stavu zvíøat','A','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('62000', 'Aktivace','A','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('62100', 'Aktivace materiálu a zbo¾í','A','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('62200', 'Aktivace vnitropodnikových slu¾eb','A','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('62300', 'Aktivace dlouhodobého nehmotného majetku','A','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('62400', 'Aktivace dlouhodobého hmotného majetku','A','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('64000', 'Jiné provozní výnosy.','A','','I','AR_amount:IC_sale:IC_Income'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('64100', 'Tr¾by z prodeje dlouhodobého nehmotného a hmotného majetku','A','','I','AR_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('64200', 'Tr¾by z prodeje materiálu','A','','I','AR_amount:IC_sale'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('64400', 'Smluvní pokuty a úroky z prodlení','A','','I','AR_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('64600', 'Výnosy z odepsaných pohledávek','A','','I','AR_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('64800', 'Jiné provozní výnosy','A','','I','AR_amount:IC_sale:IC_Income'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('65000', 'Zúètování rezerv a opravných polo¾ek provozních výnosù','H','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('65200', 'Zúètování zákonných rezerv','A','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('65400', 'Zúètování ostatních rezerv','A','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('65500', 'Zúètování komplexních nákladù pøí¹tích období','A','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('65700', 'Zúètování oprávky k opravné polo¾ce k nabytému majetku','A','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('65800', 'Zúètování zákonných opravných polo¾ek','A','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('65900', 'Zúètování opravných polo¾ek','A','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('66000', 'Finanèní výnosy','A','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('66100', 'Tr¾by z prodeje cenných papírù a vkladù','A','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('66200', 'Úroky','A','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('66300', 'Kursové zisky','A','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('66500', 'Výnosy z dlouhodobého finanèního majetku','A','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('66600', 'Výnosy z krátkodobého finanèního majetku','A','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('66800', 'Ostatní finanèní výnosy','A','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('67000', 'Zúètování rezerv a opravných polo¾ek finanèních výnosù','H','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('67400', 'Zúètování rezerv','A','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('67900', 'Zúètování opravných polo¾ek','A','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('68000', 'Mimoøádné výnosy','A','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('68100', 'Výnosy ze zmìny metody','A','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('68400', 'Zúètování rezerv','A','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('68800', 'Ostatní mimoøádné výnosy','A','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('68900', 'Zúètování opravných polo¾ek','A','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('69000', 'Pøevodové úèty','H','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('69700', 'Pøevod provozních výnosù','A','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('69800', 'Pøevod finanèních výnosù','A','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('70000', 'Úèty rozva¾né','H','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('70100', 'Poèáteèní úèet rozva¾ný','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('70200', 'Koneèný úèet rozva¾ný','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('71000', 'Úèet ziskù a ztrát','A','','A',''); --- -insert into tax (chart_id,rate) values ((select id from chart where accno = '34311'),0.05); -insert into tax (chart_id,rate) values ((select id from chart where accno = '34312'),0.22); -insert into tax (chart_id,rate) values ((select id from chart where accno = '34321'),0.05); -insert into tax (chart_id,rate) values ((select id from chart where accno = '34322'),0.22); --- -update defaults set inventory_accno_id = (select id from chart where accno = '13200'), income_accno_id = (select id from chart where accno = '60000'), expense_accno_id = (select id from chart where accno = '50000'), fxgain_accno_id = (select id from chart where accno = '99998'), fxloss_accno_id = (select id from chart where accno = '99999'), invnumber = '1000', sonumber = '5000', ponumber = '1000', curr = 'Kè', weightunit = 'kg'; --- diff --git a/sql-ledger/sql/Italy-chart.sql b/sql-ledger/sql/Italy-chart.sql deleted file mode 100644 index 0af8e9f78..000000000 --- a/sql-ledger/sql/Italy-chart.sql +++ /dev/null @@ -1,179 +0,0 @@ --- --- Chart of Accounts for Italy --- --- From: Luca Venturini <luca@yepa.com> --- 9 Oct 2001 --- --- ('2001101'5 Conto ('6470005' diventa tassa (negativa) --- ('2001102'5 IVA su acquisti diventa Iva su acq. (20%) --- ('2001102'5 Introdotto un conto per ogni aliquota IVA --- ('2001102'7 Modificato numero di conto per la Ritenuta d'acconto --- ('2001103'1 Inseriti Fornitore-test e Consulente-test --- ('2001111'5 Invertito i ruoli di ('6470005' e ('6470010' (erano sbagliati) --- ('2001111'5 Eliminata l'applicabilita' della RA al cliente test --- ('2001112'0 Aggiunto IC_expense al conto ('7005005' (mancava un conto di default per i servizi) -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2010000','COSTI DI RICERCA, DI SVILUPPO E DI PUBBLICITA\'','H','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2010005','Spese di ricerca e di sviluppo','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2010010','Spese di pubblicita\'','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2015000','DIRITTI DI BREV. IND. E DIRITTI DI UTILIZZ DELLE OPERE DELL\'INGEGNO','H','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2015005','Brevetti','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2020005','Concessioni, licenze e diritti simili','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2025005','Avviamento','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2245000','TERRENI E FABBRICATI','H','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2245010','Fabbricati civili','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2250000','IMPIANTI E MACCHINARI','H','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2250005','Impianti generici','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2255000','ATTREZZATURE INDUSTRIALI E COMMERCIALI','H','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2255005','Attrezzature','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2255010','Mobili','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2255015','Macchine d\'ufficio','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2255025','Autovetture','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3005000','RIMANENZE MATERIE PRIME, SUSSIDIARIE E DI CONSUMO','H','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3005005','Rimanenze materie prime','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3020000','RIMANENZE PRODOTTI FINITI E MERCI','H','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3020005','Rimanenze prodotti finiti','A','','A','IC'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4001000','CREDITI VERSO CL. PER FATT. EM. ESIGIBILI ENTRO L\'ESER. SUCC.','H','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4001001','Crediti verso clienti per fatture emesse','A','','A','AR'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4064000','CREDITI VERSO ALTRI - CREDITI D\'IMPOSTA','H','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4064005','IRPEF acconto','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4064020','IRPEG acconto','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4064800','Credito verso erario per IVA','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4400000','DISPONIBILITA\' LIQUIDE','H','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4480105','Banca ...c/c','A','','A','AR_paid:AP_paid'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4480400','Assegni','A','','A','AR_paid:AP_paid'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4480500','Cassa e valori','A','','A','AR_paid:AP_paid'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5005000','CAPITALE','H','','Q',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5005005','Capitale sociale','A','','Q',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5005010','Versamenti in conto capitale','A','','Q',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5020000','RISERVA LEGALE','H','','Q',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5020005','Riserva legale','A','','Q',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5080000','UTILI (PERDITE) PORTATI A NUOVO','H','','Q',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5080005','Utili esercizi precedenti','A','','Q',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5080010','Perdite esercizi precedenti','A','','Q',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5090000','UTILE (PERDITA) DELL\'ESERCIZIO','H','','Q',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5090005','Utile dell\'esercizio','A','','Q',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5090010','Perdita dell\'esercizio','A','','Q',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6200000','TRATTAMENTO DI FINE RAPPORTO DI LAVORO SUBORDINATO','H','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6220005','Trattamento di fine rapporto di lavoro subordinato','A','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6220010','Anticipazioni erogate su trattamento di fine rapporto di lavoro subordinato','A','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6435000','DEBITI VERSO BANCHE ESIGIBILI ENTRO ES. SUCC.','H','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6435005','Banca di ... c/c','A','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6436000','DEBITI VERSO BANCHE ESIGIBILI OLTRE ES. SUCC.','H','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6436005','Mutuo banca di ...','A','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6450000','DEBITI VERSO FORNITORI FATT. RICEVUTE ESIGIBILI ENTRO ES. SUCC.','H','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6450001','Debiti verso fornitori per fatture ricevute','A','','L','AP'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6470000','DEBITI TRIBUTARI','H','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6470005','IRPEF dipendenti','A','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6470010','IRPEF terzi','A','','L','AP_tax:IC_taxservice:CT_tax'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6470015','IVA da versare','A','','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice:CT_tax'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6470020','IVA in sospeso','A','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6470025','IRPEG sul reddito d\'esercizio','A','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6470030','ILOR sul reddito d\'esercizio','A','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6470050','Imposta patrimoniale','A','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6475000','DEBITI VERSO ISTITUTI PREV. ESIGIBILI ENTRO ES. SUCC.','H','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6475005','INPS','A','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6475010','INAIL','A','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6475020','Servizio sanitario nazionale (S.S.N.)','A','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6475025','ENASARCO','A','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6480000','ALTRI DEBITI - IVA C/ERARIO','H','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6480003','IVA su acquisti (4%)','A','','L','AP_tax:IC_taxpart:IC_taxservice:CT_tax'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6480004','IVA su acquisti (10%)','A','','L','AP_tax:IC_taxpart:IC_taxservice:CT_tax'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6480005','IVA su acquisti (20%)','A','','L','AP_tax:IC_taxpart:IC_taxservice:CT_tax'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6480006','IVA a credito su acquisti U.E.','A','','L','AP_tax'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6480010','IVA su fatture emesse','A','','L','AR_tax'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6480011','IVA a debito su acquisti U.E.','A','','L','AR_tax'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6480015','IVA su corrispettivi','A','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6480020','IVA versata','A','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6480025','IVA acconto','A','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6480030','IVA a credito','A','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6480035','IVA ulteriore detrazione','A','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6480040','Crediti d\'imposta diversi','A','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6480045','IVA pro-rata indetraibile','A','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6480050','IVA da contabilità separata','A','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6480055','IVA c/riepilogativo','A','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6600000','RATEI E RISCONTI PASSIVI','H','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6690005','Ratei passivi','A','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('6692005','Risconti passivi','A','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7005000','COSTI PER MATERIE PRIME, SUSSIDIARIE, DI CONSUMO E DI MERCI','H','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7005005','Materie prime','A','','E','AP_amount:IC_cogs:IC_expense'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7005015','Merci destinate alla rivendita','A','','E','AP_amount:IC_cogs'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7005020','Materiali di consumo destinati alla produzione','A','','E','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7005030','Materiali di pulizia','A','','E','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7005035','Combustibile per riscaldamento','A','','E','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7005040','Cancelleria','A','','E','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7005045','Materiale pubblicitario','A','','E','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7005050','Carburanti e lubrificanti','A','','E','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7025000','SPESE DI GESTIONE','H','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7025005','Energia elettrica','A','','E','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7025015','Spese telefoniche','A','','E','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7025025','Spese pubblicità/propaganda','A','','E','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7025030','Spese di assicurazione','A','','E','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7025040','Pulizia locali','A','','E','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7025055','Viaggi e soggiorni amministratori','A','','E','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7025060','Spese di rappresentanza per servizi interamente detraibili','A','','E','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7025065','Altre spese di rappresentanza','A','','E','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7025100','Altri servizi','A','','E','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7028000','CARBURANTI E LUBRIFICANTI PER AUTOTRAZIONE','H','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7028005','Carburanti e lubrificanti autovetture','A','','E','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7028010','Carburanti e lubrificanti autocarri etc.','A','','E','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7030000','COMPENSI PROFESSIONALI','H','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7030005','Consulenza fiscale e tributaria','A','','E','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7030015','Consulenza legale','A','','E','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7030030','Compenso amministratori','A','','E','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7035000','COSTI PER GODIMENTO BENI DI TERZI','H','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7035005','Fitti passivi','A','','E','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7035050','Canoni di leasing','A','','E','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7040000','COSTI PER IL PERSONALE','H','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7040005','Salari e stipendi','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7040010','Oneri sociali INPS','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7040015','Oneri sociali INAIL','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7040020','Oneri sociali C.E.','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7043000','AMMORTAMENTI E SVALUTAZIONI','H','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7043005','Ammortamenti immobilizzazioni immateriali','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7043100','Ammortamenti immobilizzazioni materiali','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7056000','ONERI DIVERSI DI GESTIONE','H','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7056010','Imposta di registro, bolli ,CC.GG., etc.','A','','E','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7056015','Imposta camerale','A','','E','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7056025','Tributi locali diversi','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7056040','Tassa possesso autoveicoli','A','','E','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7260000','INTERESSI E ONERI FINANZIARI','H','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7260020','Interessi passivi bancari','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7260025','Interessi passivi mutui','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7875000','IMPOSTE SUL REDDITO DELL\'ESERCIZIO','H','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7875005','IRPEG corrente','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('7875020','IRPEG differita','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8005000','RICAVI DELLE VENDITE','H','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8005005','Ricavi cessione beni','A','','I','AR_amount:IC_sale'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8015000','RICAVI DELLE PRESTAZIONI','H','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8015005','Ricavi per prestazioni a terzi','A','','I','AR_amount:IC_income'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8015015','Noleggio impianti e macchinari','A','','I','AR_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8041000','INCREMENTI IMMOBILIZZAZIONI IMMATERIALI','H','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8041005','Brevetti','A','','I','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8041010','Spese di costituzione società','A','','I','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8041020','Spese pubblicità e propaganda','A','','I','AP_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8045000','ALTRI RICAVI E PROVENTI','H','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('8045001','Cessione di materie prime, sussidiarie e semilavorati','A','','I','AR_amount'); --- --- foreign exchange gain / loss -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9990000','Foreign Exchange Gain','A','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('9990010','Foreign Exchange Loss','A','','E',''); --- --- insert taxes --- ---Ritenuta d'acconto -INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '6470010'), -0.2); ---IVA Acquisti 4% -INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '6480003'), 0.04); ---IVA Acquisti 10% -INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '6480004'), 0.1); ---IVA Acquisti 20% -INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '6480005'), 0.2); ---IVA Fatture Emesse -INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '6480010'), 0.2); ---IVA su corrispettivi -INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '6480015'), 0.2); --- --- update defaults --- -update defaults set inventory_accno_id = (select id from chart where accno = '3020005'), income_accno_id = (select id from chart where accno = '8005005'), expense_accno_id = (select id from chart where accno = '7005005'), fxgain_accno_id = (select id from chart where accno = '9990000'), fxloss_accno_id = (select id from chart where accno = '9990010'), invnumber = '20010000', sonumber = '1000', ponumber = '1000', curr = 'EUR', weightunit = 'kg'; --- diff --git a/sql-ledger/sql/Simplified_Chinese_Default-chart.sql b/sql-ledger/sql/Simplified_Chinese_Default-chart.sql deleted file mode 100644 index 680adb88d..000000000 --- a/sql-ledger/sql/Simplified_Chinese_Default-chart.sql +++ /dev/null @@ -1,78 +0,0 @@ --- 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) values ('1825','ÀۼƷÖÆÚ¸¶¿î - װ諼°É豸.','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1845','ÀۼƷÖÆÚ¸¶¿î - ÔËÊ乤¾ß','A','','A',''); -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:CT_tax'); -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:CT_tax'); --- --- 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'), invnumber = '1000', sonumber = '1000', ponumber = '1000', curr = 'CAD', weightunit = 'kg'; --- diff --git a/sql-ledger/sql/Spain-chart.sql b/sql-ledger/sql/Spain-chart.sql deleted file mode 100644 index 8c304a8b2..000000000 --- a/sql-ledger/sql/Spain-chart.sql +++ /dev/null @@ -1,132 +0,0 @@ --- Chart of Accounts for Spain (Cuadro del Plan de Contabilidad español) --- From: Federico Montesino Pouzols <fedemp@arrok.com> --- 23 Apr 2002 --- -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('099999999','Grupo 1: financiación básica','H','','',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('100000000','Capital','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('110000000','Reservas','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('120000000','Resultados pendientes de aplicación','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('130000000','Ingresos a distribuir en varios ejercicios','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('140000000','Provisiones para riesgos y gastos','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('150000000','Empréstitos y otras emisiones análogas','A','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('160000000','Deudas a largo plazo con empresas del grupo y asociadas','A','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('170000000','Deudas a largo plazo por prestamos recibidos y otros conceptos','A','','L',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('180000000','Fianzas y depósitos recibidos a largo plazo','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('190000000','Situaciones transitorias de financiación','A','','A',''); --- -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('199999999','Grupo 2: inmovilizado','H','','',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('200000000','Gastos de establecimiento','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('210000000','Inmovilizaciones inmateriales','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('220000000','Inmovilizaciones materiales','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('230000000','Inmovilizaciones materiales en curso','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('240000000','Inversiones financieras en empresas del grupo y asociadas','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('250000000','Otras inversiones financieras permanentes','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('260000000','Fianzas y depósitos constituidos a largo plazo','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('270000000','Gastos a distribuir en varios ejercicios','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('280000000','Amortización acumulada del inmovilizado','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('290000000','Provisiones de inmovilizado','A','','A',''); --- -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('299999999','Grupo 3: existencias','H','','',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('300000000','Comerciales','A','','A','IC'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('310000000','Materias primas','A','','A','IC'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('320000000','Otros aprovisionamientos','A','','A','IC'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('330000000','Productos en curso','A','','A','IC'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('340000000','Productos semiterminados','A','','A','IC'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('350000000','Productos terminados','A','','A','IC'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('360000000','Subproductos, residuos y materiales recuperados','A','','A','IC'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('390000000','Provisiones por depreciación de existencias','A','','A',''); --- -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('399999999','Grupo 4: acreedores y deudores por operaciones de tráfico','H','','',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('400000000','Proveedores','A','','P',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('410000000','Acreedores varios','A','','P',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('430000000','Clientes','A','','P',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('431000000','Clientes, efectos comerciales a cobrar','A','','P',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('440000000','Deudores varios','A','','P',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('460000000','Personal','A','','P',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('470000000','Administraciones públicas','A','','P',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('472000000','Hacienda Pública, IVA soportado','A','','P',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('472000001','IVA soportado 4%','A','','P','AP_tax:IC_taxpart:IC_taxservice:CT_tax'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('472000002','IVA soportado 7%','A','','P','AP_tax:IC_taxpart:IC_taxservice:CT_tax'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('472000003','IVA soportado 16%','A','','P','AP_tax:IC_taxpart:IC_taxservice:CT_tax'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('475100000','Hacienda Pública, acreedor por retenciones practicadas','A','','P',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('473000000','Hacienda Pública, retenciones y pagos a cuenta','A','','P',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('477000000','Hacienda Pública, IVA repercutido','A','','P',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('477000001','IVA repercutido 4%','A','','P','AR_tax:IC_taxpart:IC_taxservice:CT_tax'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('477000002','IVA repercutido 7%','A','','P','AR_tax:IC_taxpart:IC_taxservice:CT_tax'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('477000003','IVA repercutido 16%','A','','P','AR_tax:IC_taxpart:IC_taxservice:CT_tax'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('480000000','Ajustes por periodificación','A','','P',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('490000000','Provisiones por operaciones de tráfico','A','','P',''); --- -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('499999999','Grupo 5: cuentas financieras','H','','',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('500000000','Empréstitos y otras emisiones análogas a corto plazo','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('510000000','Deudas a corto plazo con empresas del grupo y asociadas','A','','P',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('520000000','Deudas a corto plazo por préstamos recibidos y otros conceptos','A','','P',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('530000000','Inversiones financieras a corto plazo en empresas del grupo y asociadas','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('540000000','Otras inversiones financieras temporales','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('550000000','Otras cuentas no bancarias','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('560000000','Fianzas y depósitos recibidos y constituidos a corto plazo','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('569000000','Tesorería','A','','A','AR_paid:AP_paid'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('570000000','Caja, euros','A','','A','AR_paid:AP_paid'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('571000000','Caja, moneda extranjera','A','','A','AR_paid:AP_paid'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('572000000','Bancos e instituciones de crédito, c/c. vista, euros','A','','A','AR_paid:AP_paid:AP_amount:AR_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('573000000','Bancos e instituciones de crédito, c/c. vista, moneda extranjera','A','','A','AR_paid:AP_paid:AP_amount:AR_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('574000000','Bancos e instituciones de crédito, cuentas de ahorro, euros','A','','A','AR_paid:AP_paid:AP_amount:AR_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('575000000','Bancos e instituciones de crédito, cuentas de ahorro, moneda extranjera','A','','A','AR_paid:AP_paid:AP_amount:AR_amount'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('580000000','Ajustes por periodificación','A','','Q',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('590000000','Provisiones financieras','A','','P',''); --- -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('599999999','Grupo 6: compras y gastos','H','','',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('600000000','Compras','A','','E','AP:IC_cogs'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('608000000','Devoluciones de compras y operaciones similares','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('610000000','Variación de existencias','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('620000000','Servicios exteriores','A','','E','IC_expense'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('630000000','Tributos','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('640000000','Gastos de personal','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('650000000','Otros gastos de gestión','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('660000000','Gastos financieros','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('665000000','Descuentos sobre ventas por pronto pago','A','','E','IC_cogs:IC_expense'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('668000000','Diferencias negativas de cambio','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('670000000','Pérdidas procedentes del inmovilizado y gastos excepcionales','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('680000000','Dotaciones para amortizaciones','A','','E',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('690000000','Dotaciones a las provisiones','A','','E',''); --- -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('699999999','Grupo 7: ventas e ingresos','H','','',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('700000000','Ventas de mercaderías, de producción propia, de servicios, etc.','A','','I','AR:IC_sale:IC_income'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('708000000','Devoluciones de ventas y operaciones similares','A','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('710000000','Variación de existencias','A','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('730000000','Trabajos realizados para la empresa','A','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('740000000','Subvenciones a la explotación','A','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('750000000','Otros ingresos de gestión','A','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('760000000','Ingresos financieros','A','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('765000000','Descuentos sobre compras por pronto pago','A','','I','IC_sale:IC_income'); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('768000000','Diferencias positivas de cambio','A','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('770000000','Beneficios procedentes de inmovilizados e ingresos excepcionales','A','','I',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('790000000','Excesos y aplicaciones de provisiones','A','','I',''); --- --- Taxes in Spain --- --- IVA: 4, 7 or 16% --- IVA soportado -INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno = '472000000'), 0.0); -INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno = '472000001'), 0.04); -INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno = '472000002'), 0.07); -INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno = '472000003'), 0.16); --- Recargo equivalente: 0.5, 1 or 4% -INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno = '472000004'), 0.005); -INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno = '472000005'), 0.01); -INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno = '472000006'), 0.04); --- --- IVA repercutido -INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno = '477000000'), 0.0); -INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno = '477000001'), 0.04); -INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno = '477000002'), 0.07); -INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno = '477000003'), 0.16); --- Recargo equivalente: 0.5, 1 or 4% -INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno = '477000004'), 0.005); -INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno = '477000005'), 0.01); -INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno = '477000006'), 0.04); --- --- update defaults --- -update defaults set inventory_accno_id = (select id from chart where accno = '300000000'), income_accno_id = (select id from chart where accno = '700000000'), expense_accno_id = (select id from chart where accno = '600000000'), fxgain_accno_id = (select id from chart where accno = '768000000'), fxloss_accno_id = (select id from chart where accno = '668000000'), invnumber = 'F00000000', sonumber = '100000000', ponumber = '100000000', yearend = '31/12', curr = 'EUR', weightunit = 'Kg', businessnumber = ''; --- diff --git a/sql-ledger/sql/Traditional_Chinese_Default-chart.sql b/sql-ledger/sql/Traditional_Chinese_Default-chart.sql deleted file mode 100644 index 68ebeac17..000000000 --- a/sql-ledger/sql/Traditional_Chinese_Default-chart.sql +++ /dev/null @@ -1,78 +0,0 @@ --- 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) values ('1825','²Öp¤À´Á¥I´Ú - ¸Ë¿X¤Î³]³Æ.','A','','A',''); -insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1845','²Öp¤À´Á¥I´Ú - ¹B¿é¤u¨ã','A','','A',''); -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:CT_tax'); -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:CT_tax'); --- --- 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'), invnumber = '1000', sonumber = '1000', ponumber = '1000', curr = 'USD', weightunit = 'kg'; --- |