# MySQL dump of database 'Geesys demo' on host 'localhost'
# Backup Date and Time: 2020-12-17 04:13 pm
# Module name : Import export
# Module Author : Kvvaradha
# http://www.kvcodes.com
# Company: Geesys demo
# User : Administrator
# Compatibility: 2.4.1

SET SQL_MODE='';

# Table Backups kvc_geesys

#------------------------------------------------------------------------------------
    UPDATE  0_sys_prefs SET value='5690' WHERE name='bank_charge_act' ;
UPDATE  0_sys_prefs SET value='2100' WHERE name='creditors_act' ;
UPDATE  0_sys_prefs SET value='1200' WHERE name='debtors_act' ;
UPDATE  0_sys_prefs SET value='5040' WHERE name='default_adj_act' ;
UPDATE  0_sys_prefs SET value='5010' WHERE name='default_cogs_act' ;
UPDATE  0_sys_prefs SET value='4010' WHERE name='default_inv_sales_act' ;
UPDATE  0_sys_prefs SET value='1510' WHERE name='default_inventory_act' ;
UPDATE  0_sys_prefs SET value='5660' WHERE name='default_loss_on_asset_disposal_act' ;
UPDATE  0_sys_prefs SET value='4500' WHERE name='default_prompt_payment_act' ;
UPDATE  0_sys_prefs SET value='4010' WHERE name='default_sales_act' ;
UPDATE  0_sys_prefs SET value='4510' WHERE name='default_sales_discount_act' ;
UPDATE  0_sys_prefs SET value='1530' WHERE name='default_wip_act' ;
UPDATE  0_sys_prefs SET value='2105' WHERE name='deferred_income_act' ;
UPDATE  0_sys_prefs SET value='4450' WHERE name='exchange_diff_act' ;
UPDATE  0_sys_prefs SET value='4430' WHERE name='freight_act' ;
UPDATE  0_sys_prefs SET value='1550' WHERE name='grn_clearing_act' ;
UPDATE  0_sys_prefs SET value='9990' WHERE name='profit_loss_year_act' ;
UPDATE  0_sys_prefs SET value='5060' WHERE name='pyt_discount_act' ;
UPDATE  0_sys_prefs SET value='3590' WHERE name='retained_earnings_act' ;


 # -------------------------------------------------------------------------------------

### Structure of table `chart_class` ### 

 DROP TABLE IF EXISTS 0_chart_class;

CREATE TABLE `0_chart_class` (
  `cid` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  `class_name` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ctype` tinyint(1) NOT NULL DEFAULT '0',
  `inactive` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`cid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO 0_chart_class VALUES("1","Assets","1","0"),
 ("2","Liabilities","2","0"),
 ("3","Income","4","0"),
 ("4","Costs","6","0");

 # -------------------------------------------------------------------------------------

### Structure of table `chart_master` ### 

 DROP TABLE IF EXISTS 0_chart_master;

CREATE TABLE `0_chart_master` (
  `account_code` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `account_code2` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `account_name` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `account_type` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `inactive` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`account_code`),
  KEY `account_name` (`account_name`),
  KEY `accounts_by_type` (`account_type`,`account_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO 0_chart_master VALUES("1010","","name","18","0"),
 ("1060","","Checking Account","1","0"),
 ("1065","","Petty Cash","1","0"),
 ("1200","","Accounts Receivables","1","0"),
 ("1205","","Allowance for doubtful accounts","1","0"),
 ("1510","","Inventory","2","0"),
 ("1520","","Stocks of Raw Materials","2","0"),
 ("1530","","Stocks of Work In Progress","2","0"),
 ("1540","","Stocks of Finished Goods","2","0"),
 ("1550","","Goods Received Clearing account","2","0"),
 ("1820","","Office Furniture &amp; Equipment","3","0"),
 ("1825","","Accum. Amort. -Furn. &amp; Equip.","3","0"),
 ("1840","","Vehicle","3","0"),
 ("1845","","Accum. Amort. -Vehicle","3","0"),
 ("2100","","Accounts Payable","4","0"),
 ("2105","","Deferred Income","4","0"),
 ("2110","","Accrued Income Tax - Federal","4","0"),
 ("2120","","Accrued Income Tax - State","4","0"),
 ("2130","","Accrued Franchise Tax","4","0"),
 ("2140","","Accrued Real &amp; Personal Prop Tax","4","0"),
 ("2150","","Sales Tax","4","0"),
 ("2160","","Accrued Use Tax Payable","4","0"),
 ("2210","","Accrued Wages","4","0"),
 ("2220","","Accrued Comp Time","4","0"),
 ("2230","","Accrued Holiday Pay","4","0"),
 ("2240","","Accrued Vacation Pay","4","0"),
 ("2310","","Accr. Benefits - 401K","4","0"),
 ("2320","","Accr. Benefits - Stock Purchase","4","0"),
 ("2330","","Accr. Benefits - Med, Den","4","0"),
 ("2340","","Accr. Benefits - Payroll Taxes","4","0"),
 ("2350","","Accr. Benefits - Credit Union","4","0"),
 ("2360","","Accr. Benefits - Savings Bond","4","0"),
 ("2370","","Accr. Benefits - Garnish","4","0"),
 ("2380","","Accr. Benefits - Charity Cont.","4","0"),
 ("2620","","Bank Loans","5","0"),
 ("2680","","Loans from Shareholders","5","0"),
 ("3350","","Common Shares","6","0"),
 ("3590","","Retained Earnings - prior years","7","0"),
 ("4010","","Sales","8","0"),
 ("4430","","Shipping &amp; Handling","9","0"),
 ("4440","","Interest","9","0"),
 ("4450","","Foreign Exchange Gain","9","0"),
 ("4500","","Prompt Payment Discounts","9","0"),
 ("4510","","Discounts Given","9","0"),
 ("5010","","Cost of Goods Sold - Retail","10","0"),
 ("5020","","Material Usage Varaiance","10","0"),
 ("5030","","Consumable Materials","10","0"),
 ("5040","","Purchase price Variance","10","0"),
 ("5050","","Purchases of materials","10","0"),
 ("5060","","Discounts Received","10","0"),
 ("5100","","Freight","10","0"),
 ("5410","","Wages &amp; Salaries","11","0"),
 ("5420","","Wages - Overtime","11","0"),
 ("5430","","Benefits - Comp Time","11","0"),
 ("5440","","Benefits - Payroll Taxes","11","0"),
 ("5450","","Benefits - Workers Comp","11","0"),
 ("5460","","Benefits - Pension","11","0"),
 ("5470","","Benefits - General Benefits","11","0"),
 ("5510","","Inc Tax Exp - Federal","11","0"),
 ("5520","","Inc Tax Exp - State","11","0"),
 ("5530","","Taxes - Real Estate","11","0"),
 ("5540","","Taxes - Personal Property","11","0"),
 ("5550","","Taxes - Franchise","11","0"),
 ("5560","","Taxes - Foreign Withholding","11","0"),
 ("5610","","Accounting &amp; Legal","12","0"),
 ("5615","","Advertising &amp; Promotions","12","0"),
 ("5620","","Bad Debts","12","0"),
 ("5660","","Amortization Expense","12","0"),
 ("5685","","Insurance","12","0"),
 ("5690","","Interest &amp; Bank Charges","12","0"),
 ("5700","","Office Supplies","12","0"),
 ("5760","","Rent","12","0"),
 ("5765","","Repair &amp; Maintenance","12","0"),
 ("5780","","Telephone","12","0"),
 ("5785","","Travel &amp; Entertainment","12","0"),
 ("5790","","Utilities","12","0"),
 ("5795","","Registrations","12","0"),
 ("5800","","Licenses","12","0"),
 ("5810","","Foreign Exchange Loss","12","0"),
 ("9990","","Year Profit/Loss","12","0");

 # -------------------------------------------------------------------------------------

### Structure of table `chart_types` ### 

 DROP TABLE IF EXISTS 0_chart_types;

CREATE TABLE `0_chart_types` (
  `id` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `class_id` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `parent` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-1',
  `inactive` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `class_id` (`class_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO 0_chart_types VALUES("1","Current Assets","1","","0"),
 ("10","Cost of Goods Sold","4","","0"),
 ("11","Payroll Expenses","4","","0"),
 ("12","General &amp; Administrative expenses","4","","0"),
 ("2","Inventory Assets","1","","0"),
 ("3","Capital Assets","1","","0"),
 ("4","Current Liabilities","2","","0"),
 ("5","Long Term Liabilities","2","","0"),
 ("6","Share Capital","2","","0"),
 ("7","Retained Earnings","2","","0"),
 ("8","Sales Revenue","3","","0"),
 ("9","Other Revenue","3","","0");

 # -------------------------------------------------------------------------------------

