-- MySQL dump 10.13 Distrib 5.5.62, for Linux (x86_64)
-- Host: localhost Database: weberp
-- ------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
-- Table structure for table `accountgroups`
DROP TABLE IF EXISTS `accountgroups`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `accountgroups` (
`groupname` char(30) NOT NULL DEFAULT '',
`sectioninaccounts` int(11) NOT NULL DEFAULT '0',
`pandl` tinyint(4) NOT NULL DEFAULT '1',
`sequenceintb` smallint(6) NOT NULL DEFAULT '0',
`parentgroupname` varchar(30) NOT NULL,
PRIMARY KEY (`groupname`),
KEY `SequenceInTB` (`sequenceintb`),
KEY `sectioninaccounts` (`sectioninaccounts`),
KEY `parentgroupname` (`parentgroupname`),
CONSTRAINT `accountgroups_ibfk_1` FOREIGN KEY (`sectioninaccounts`) REFERENCES `accountsection` (`sectionid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Dumping data for table `accountgroups`
LOCK TABLES `accountgroups` WRITE;
/*!40000 ALTER TABLE `accountgroups` DISABLE KEYS */;
INSERT INTO `accountgroups` VALUES ('Cost of Goods Sold',2,1,5000,''),('Current Assets',20,0,1000,''),('Financed',50,0,3000,''),('Fixed Assets',10,0,500,''),('Giveaways',5,1,6000,'Promotions'),('Income Tax',5,1,9000,''),('Liabilities',30,0,2000,''),('Marketing Expenses',5,1,6000,''),('Operating Expenses',5,1,7000,''),('Other Revenue and Expenses',5,1,8000,''),('Outward Freight',2,1,5000,'Cost of Goods Sold'),('Promotions',5,1,6000,'Marketing Expenses'),('Revenue',1,1,4000,''),('Sales',1,1,10,'');
/*!40000 ALTER TABLE `accountgroups` ENABLE KEYS */;
-- Table structure for table `accountsection`
DROP TABLE IF EXISTS `accountsection`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `accountsection` (
`sectionid` int(11) NOT NULL DEFAULT '0',
`sectionname` text NOT NULL,
PRIMARY KEY (`sectionid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Dumping data for table `accountsection`
LOCK TABLES `accountsection` WRITE;
/*!40000 ALTER TABLE `accountsection` DISABLE KEYS */;
INSERT INTO `accountsection` VALUES (1,'Income'),(2,'Cost Of Sales'),(5,'Overheads'),(10,'Fixed Assets'),(15,'Inventory'),(20,'Amounts Receivable'),(25,'Cash'),(30,'Amounts Payable'),(50,'Financed By');
/*!40000 ALTER TABLE `accountsection` ENABLE KEYS */;
-- Table structure for table `areas`
DROP TABLE IF EXISTS `areas`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
`areacode` char(3) NOT NULL,
`areadescription` varchar(25) NOT NULL DEFAULT '',
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Dumping data for table `areas`
LOCK TABLES `areas` WRITE;
/*!40000 ALTER TABLE `areas` DISABLE KEYS */;
/*!40000 ALTER TABLE `areas` ENABLE KEYS */;
-- Table structure for table `assetmanager`
DROP TABLE IF EXISTS `assetmanager`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `assetmanager` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`stockid` varchar(20) NOT NULL DEFAULT '',
`serialno` varchar(30) NOT NULL DEFAULT '',
`location` varchar(15) NOT NULL DEFAULT '',
`cost` double NOT NULL DEFAULT '0',
`depn` double NOT NULL DEFAULT '0',
`datepurchased` date NOT NULL DEFAULT '1000-01-01',
`disposalvalue` int(11) NOT NULL DEFAULT '0',
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Dumping data for table `assetmanager`
LOCK TABLES `assetmanager` WRITE;
/*!40000 ALTER TABLE `assetmanager` DISABLE KEYS */;
/*!40000 ALTER TABLE `assetmanager` ENABLE KEYS */;
-- Table structure for table `audittrail`
DROP TABLE IF EXISTS `audittrail`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `audittrail` (
`transactiondate` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
`userid` varchar(20) NOT NULL DEFAULT '',
KEY `transactiondate` (`transactiondate`),
KEY `transactiondate_2` (`transactiondate`),
KEY `transactiondate_3` (`transactiondate`),
CONSTRAINT `audittrail_ibfk_1` FOREIGN KEY (`userid`) REFERENCES `www_users` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Dumping data for table `audittrail`
LOCK TABLES `audittrail` WRITE;
/*!40000 ALTER TABLE `audittrail` DISABLE KEYS */;
/*!40000 ALTER TABLE `audittrail` ENABLE KEYS */;
-- Table structure for table `bankaccounts`
DROP TABLE IF EXISTS `bankaccounts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bankaccounts` (
`accountcode` varchar(20) NOT NULL DEFAULT '0',
`currcode` char(3) NOT NULL,
`invoice` smallint(2) NOT NULL DEFAULT '0',
`bankaccountcode` varchar(50) NOT NULL DEFAULT '',
`bankaccountname` char(50) NOT NULL DEFAULT '',
`bankaccountnumber` char(50) NOT NULL DEFAULT '',
`bankaddress` char(50) DEFAULT NULL,
`importformat` varchar(10) NOT NULL DEFAULT '''''',
PRIMARY KEY (`accountcode`),
KEY `currcode` (`currcode`),
KEY `BankAccountName` (`bankaccountname`),
KEY `BankAccountNumber` (`bankaccountnumber`),
CONSTRAINT `bankaccounts_ibfk_1` FOREIGN KEY (`accountcode`) REFERENCES `chartmaster` (`accountcode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Dumping data for table `bankaccounts`
LOCK TABLES `bankaccounts` WRITE;
/*!40000 ALTER TABLE `bankaccounts` DISABLE KEYS */;
INSERT INTO `bankaccounts` VALUES ('1010','GBP',2,'123','GBP account','123','',''),('1030','AUD',2,'12445','Cheque Account','124455667789','123 Straight Street',''),('1040','AUD',0,'','Savings Account','','',''),('1060','USD',1,'','USD Bank Account','123','','GIFTS');
/*!40000 ALTER TABLE `bankaccounts` ENABLE KEYS */;
-- Table structure for table `bankaccountusers`
DROP TABLE IF EXISTS `bankaccountusers`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bankaccountusers` (
`accountcode` varchar(20) NOT NULL COMMENT 'Bank account code',
`userid` varchar(20) NOT NULL COMMENT 'User code'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Dumping data for table `bankaccountusers`
LOCK TABLES `bankaccountusers` WRITE;
/*!40000 ALTER TABLE `bankaccountusers` DISABLE KEYS */;
/*!40000 ALTER TABLE `bankaccountusers` ENABLE KEYS */;
-- Table structure for table `banktrans`
DROP TABLE IF EXISTS `banktrans`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `banktrans` (
`banktransid` bigint(20) NOT NULL AUTO_INCREMENT,
`type` smallint(6) NOT NULL DEFAULT '0',
`transno` bigint(20) NOT NULL DEFAULT '0',
`bankact` varchar(20) NOT NULL DEFAULT '0',
`ref` varchar(50) NOT NULL DEFAULT '',
`amountcleared` double NOT NULL DEFAULT '0',
`exrate` double NOT NULL DEFAULT '1' COMMENT 'From bank account currency to payment currency',
`functionalexrate` double NOT NULL DEFAULT '1' COMMENT 'Account currency to functional currency',
`transdate` date NOT NULL DEFAULT '1000-01-01',
`banktranstype` varchar(30) NOT NULL DEFAULT '',
`amount` double NOT NULL DEFAULT '0',
`currcode` char(3) NOT NULL DEFAULT '',
`chequeno` varchar(16) NOT NULL DEFAULT '',
PRIMARY KEY (`banktransid`),
KEY `BankAct` (`bankact`,`ref`),
KEY `TransDate` (`transdate`),
KEY `TransType` (`banktranstype`),
KEY `Type` (`type`,`transno`),
KEY `CurrCode` (`currcode`),
CONSTRAINT `banktrans_ibfk_1` FOREIGN KEY (`type`) REFERENCES `systypes` (`typeid`),
CONSTRAINT `banktrans_ibfk_2` FOREIGN KEY (`bankact`) REFERENCES `bankaccounts` (`accountcode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Dumping data for table `banktrans`
LOCK TABLES `banktrans` WRITE;
/*!40000 ALTER TABLE `banktrans` DISABLE KEYS */;
/*!40000 ALTER TABLE `banktrans` ENABLE KEYS */;
-- Table structure for table `bom`
DROP TABLE IF EXISTS `bom`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
`parent` char(20) NOT NULL DEFAULT '',
`sequence` int(11) NOT NULL DEFAULT '0',
`component` char(20) NOT NULL DEFAULT '',
`workcentreadded` char(5) NOT NULL DEFAULT '',
`loccode` char(5) NOT NULL DEFAULT '',
`effectiveafter` date NOT NULL DEFAULT '1000-01-01',
`effectiveto` date NOT NULL DEFAULT '9999-12-31',
`quantity` double NOT NULL DEFAULT '1',
`autoissue` tinyint(4) NOT NULL DEFAULT '0',
`remark` varchar(500) NOT NULL DEFAULT '',
`digitals` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`parent`,`component`,`workcentreadded`,`loccode`),
KEY `Component` (`component`),
KEY `EffectiveAfter` (`effectiveafter`),
KEY `EffectiveTo` (`effectiveto`),
KEY `LocCode` (`loccode`),
KEY `Parent` (`parent`,`effectiveafter`,`effectiveto`,`loccode`),
KEY `Parent_2` (`parent`),
KEY `WorkCentreAdded` (`workcentreadded`),
CONSTRAINT `bom_ibfk_1` FOREIGN KEY (`parent`) REFERENCES `stockmaster` (`stockid`),
CONSTRAINT `bom_ibfk_2` FOREIGN KEY (`component`) REFERENCES `stockmaster` (`stockid`),
CONSTRAINT `bom_ibfk_3` FOREIGN KEY (`workcentreadded`) REFERENCES `workcentres` (`code`),
CONSTRAINT `bom_ibfk_4` FOREIGN KEY (`loccode`) REFERENCES `locations` (`loccode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Dumping data for table `bom`
/*!40000 ALTER TABLE `bom` DISABLE KEYS */;
/*!40000 ALTER TABLE `bom` ENABLE KEYS */;
-- Table structure for table `chartdetails`
DROP TABLE IF EXISTS `chartdetails`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chartdetails` (
`accountcode` varchar(20) NOT NULL DEFAULT '0',
`period` smallint(6) NOT NULL DEFAULT '0',
`budget` double NOT NULL DEFAULT '0',
`actual` double NOT NULL DEFAULT '0',
`bfwd` double NOT NULL DEFAULT '0',
`bfwdbudget` double NOT NULL DEFAULT '0',
PRIMARY KEY (`accountcode`,`period`),
CONSTRAINT `chartdetails_ibfk_1` FOREIGN KEY (`accountcode`) REFERENCES `chartmaster` (`accountcode`),
CONSTRAINT `chartdetails_ibfk_2` FOREIGN KEY (`period`) REFERENCES `periods` (`periodno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Dumping data for table `chartdetails`
LOCK TABLES `chartdetails` WRITE;
/*!40000 ALTER TABLE `chartdetails` DISABLE KEYS */;
/*!40000 ALTER TABLE `chartdetails` ENABLE KEYS */;
-- Table structure for table `chartmaster`
DROP TABLE IF EXISTS `chartmaster`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chartmaster` (
`accountcode` varchar(20) NOT NULL DEFAULT '0',
`accountname` char(50) NOT NULL DEFAULT '',
`group_` char(30) NOT NULL DEFAULT '',
`cashflowsactivity` tinyint(1) NOT NULL DEFAULT '-1' COMMENT 'Cash flows activity',
PRIMARY KEY (`accountcode`),
KEY `AccountName` (`accountname`),
CONSTRAINT `chartmaster_ibfk_1` FOREIGN KEY (`group_`) REFERENCES `accountgroups` (`groupname`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Dumping data for table `chartmaster`
LOCK TABLES `chartmaster` WRITE;
/*!40000 ALTER TABLE `chartmaster` DISABLE KEYS */;
INSERT INTO `chartmaster` VALUES ('1','Default Sales/Discounts','Sales',-1),('1010','Petty Cash','Current Assets',-1),('1020','Cash on Hand','Current Assets',-1),('1030','Cheque Accounts','Current Assets',-1),('1040','Savings Accounts','Current Assets',-1),('1050','Payroll Accounts','Current Assets',-1),('1060','Special Accounts','Current Assets',-1),('1070','Money Market Investments','Current Assets',-1),('1080','Short-Term Investments (< 90 days)','Current Assets',-1),('1090','Interest Receivable','Current Assets',-1),('1100','Accounts Receivable','Current Assets',-1),('1150','Allowance for Doubtful Accounts','Current Assets',-1),('1200','Notes Receivable','Current Assets',-1),('1250','Income Tax Receivable','Current Assets',-1),('1300','Prepaid Expenses','Current Assets',-1),('1350','Advances','Current Assets',-1),('1400','Supplies Inventory','Current Assets',-1),('1420','Raw Material Inventory','Current Assets',-1),('1440','Work in Progress Inventory','Current Assets',-1),('1460','Finished Goods Inventory','Current Assets',-1),('1500','Land','Fixed Assets',-1),('1550','Bonds','Fixed Assets',-1),('1600','Buildings','Fixed Assets',-1),('1620','Accumulated Depreciation of Buildings','Fixed Assets',-1),('1650','Equipment','Fixed Assets',-1),('1670','Accumulated Depreciation of Equipment','Fixed Assets',-1),('1700','Furniture & Fixtures','Fixed Assets',-1),('1710','Accumulated Depreciation of Furniture & Fixtures','Fixed Assets',-1),('1720','Office Equipment','Fixed Assets',-1),('1730','Accumulated Depreciation of Office Equipment','Fixed Assets',-1),('1740','Software','Fixed Assets',-1),('1750','Accumulated Depreciation of Software','Fixed Assets',-1),('1760','Vehicles','Fixed Assets',-1),('1770','Accumulated Depreciation Vehicles','Fixed Assets',-1),('1780','Other Depreciable Property','Fixed Assets',-1),('1790','Accumulated Depreciation of Other Depreciable Prop','Fixed Assets',-1),('1800','Patents','Fixed Assets',-1),('1850','Goodwill','Fixed Assets',-1),('1900','Future Income Tax Receivable','Current Assets',-1),('2010','Bank Indedebtedness (overdraft)','Liabilities',-1),('2020','Retainers or Advances on Work','Liabilities',-1),('2050','Interest Payable','Liabilities',-1),('2100','Accounts Payable','Liabilities',-1),('2150','Goods Received Suspense','Liabilities',-1),('2200','Short-Term Loan Payable','Liabilities',-1),('2230','Current Portion of Long-Term Debt Payable','Liabilities',-1),('2250','Income Tax Payable','Liabilities',-1),('2300','GST Payable','Liabilities',-1),('2310','GST Recoverable','Liabilities',-1),('2320','PST Payable','Liabilities',-1),('2330','PST Recoverable (commission)','Liabilities',-1),('2340','Payroll Tax Payable','Liabilities',-1),('2350','Withholding Income Tax Payable','Liabilities',-1),('2360','Other Taxes Payable','Liabilities',-1),('2400','Employee Salaries Payable','Liabilities',-1),('2410','Management Salaries Payable','Liabilities',-1),('2420','Director / Partner Fees Payable','Liabilities',-1),('2450','Health Benefits Payable','Liabilities',-1),('2460','Pension Benefits Payable','Liabilities',-1),('2480','Employment Insurance Premiums Payable','Liabilities',-1),('2500','Land Payable','Liabilities',-1),('2550','Long-Term Bank Loan','Liabilities',-1),('2560','Notes Payable','Liabilities',-1),('2600','Building & Equipment Payable','Liabilities',-1),('2700','Furnishing & Fixture Payable','Liabilities',-1),('2720','Office Equipment Payable','Liabilities',-1),('2740','Vehicle Payable','Liabilities',-1),('2760','Other Property Payable','Liabilities',-1),('2800','Shareholder Loans','Liabilities',-1),('2900','Suspense','Liabilities',-1),('3100','Capital Stock','Financed',-1),('3200','Capital Surplus / Dividends','Financed',-1),('3300','Dividend Taxes Payable','Financed',-1),('3400','Dividend Taxes Refundable','Financed',-1),('3500','Retained Earnings','Financed',-1),('4100','Product / Service Sales','Revenue',-1),('4200','Sales Exchange Gains/Losses','Revenue',-1),('4500','Consulting Services','Revenue',-1),('4600','Rentals','Revenue',-1),('4700','Finance Charge Income','Revenue',-1),('4800','Sales Returns & Allowances','Revenue',-1),('4900','Sales Discounts','Revenue',-1),('5000','Cost of Sales','Cost of Goods Sold',-1),('5100','Production Expenses','Cost of Goods Sold',-1),('5200','Purchases Exchange Gains/Losses','Cost of Goods Sold',-1),('5500','Direct Labour Costs','Cost of Goods Sold',-1),('5600','Freight Charges','Outward Freight',-1),('5700','Inventory Adjustment','Cost of Goods Sold',-1),('5800','Purchase Returns & Allowances','Cost of Goods Sold',-1),('5900','Purchase Discounts','Cost of Goods Sold',-1),('6100','Advertising','Marketing Expenses',-1),('6150','Promotion','Promotions',-1),('6200','Communications','Marketing Expenses',-1),('6250','Meeting Expenses','Marketing Expenses',-1),('6300','Travelling Expenses','Marketing Expenses',-1),('6400','Delivery Expenses','Marketing Expenses',-1),('6500','Sales Salaries & Commission','Marketing Expenses',-1),('6550','Sales Salaries & Commission Deductions','Marketing Expenses',-1),('6590','Benefits','Marketing Expenses',-1),('6600','Other Selling Expenses','Marketing Expenses',-1),('6700','Permits, Licenses & License Fees','Marketing Expenses',-1),('6800','Research & Development','Marketing Expenses',-1),('6900','Professional Services','Marketing Expenses',-1),('7020','Support Salaries & Wages','Operating Expenses',-1),('7030','Support Salary & Wage Deductions','Operating Expenses',-1),('7040','Management Salaries','Operating Expenses',-1),('7050','Management Salary deductions','Operating Expenses',-1),('7060','Director / Partner Fees','Operating Expenses',-1),('7070','Director / Partner Deductions','Operating Expenses',-1),('7080','Payroll Tax','Operating Expenses',-1),('7090','Benefits','Operating Expenses',-1),('7100','Training & Education Expenses','Operating Expenses',-1),('7150','Dues & Subscriptions','Operating Expenses',-1),('7200','Accounting Fees','Operating Expenses',-1),('7210','Audit Fees','Operating Expenses',-1),('7220','Banking Fees','Operating Expenses',-1),('7230','Credit Card Fees','Operating Expenses',-1),('7240','Consulting Fees','Operating Expenses',-1),('7260','Legal Fees','Operating Expenses',-1),('7280','Other Professional Fees','Operating Expenses',-1),('7300','Business Tax','Operating Expenses',-1),('7350','Property Tax','Operating Expenses',-1),('7390','Corporation Capital Tax','Operating Expenses',-1),('7400','Office Rent','Operating Expenses',-1),('7450','Equipment Rental','Operating Expenses',-1),('7500','Office Supplies','Operating Expenses',-1),('7550','Office Repair & Maintenance','Operating Expenses',-1),('7600','Automotive Expenses','Operating Expenses',-1),('7610','Communication Expenses','Operating Expenses',-1),('7620','Insurance Expenses','Operating Expenses',-1),('7630','Postage & Courier Expenses','Operating Expenses',-1),('7640','Miscellaneous Expenses','Operating Expenses',-1),('7650','Travel Expenses','Operating Expenses',-1),('7660','Utilities','Operating Expenses',-1),('7700','Ammortization Expenses','Operating Expenses',-1),('7750','Depreciation Expenses','Operating Expenses',-1),('7800','Interest Expense','Operating Expenses',-1),('7900','Bad Debt Expense','Operating Expenses',-1),('8100','Gain on Sale of Assets','Other Revenue and Expenses',-1),('8200','Interest Income','Other Revenue and Expenses',-1),('8300','Recovery on Bad Debt','Other Revenue and Expenses',-1),('8400','Other Revenue','Other Revenue and Expenses',-1),('8500','Loss on Sale of Assets','Other Revenue and Expenses',-1),('8600','Charitable Contributions','Other Revenue and Expenses',-1),('8900','Other Expenses','Other Revenue and Expenses',-1),('9100','Income Tax Provision','Income Tax',-1);
/*!40000 ALTER TABLE `chartmaster` ENABLE KEYS */;
-- Table structure for table `cogsglpostings`
DROP TABLE IF EXISTS `cogsglpostings`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cogsglpostings` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`area` char(3) NOT NULL DEFAULT '',
`stkcat` varchar(6) NOT NULL DEFAULT '',
`glcode` varchar(20) NOT NULL DEFAULT '0',
`salestype` char(2) NOT NULL DEFAULT 'AN',
UNIQUE KEY `Area_StkCat` (`area`,`stkcat`,`salestype`),
KEY `SalesType` (`salestype`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Dumping data for table `cogsglpostings`
LOCK TABLES `cogsglpostings` WRITE;
/*!40000 ALTER TABLE `cogsglpostings` DISABLE KEYS */;
INSERT INTO `cogsglpostings` VALUES (5,'AN','ANY','5000','AN'),(6,'123','ANY','6100','AN');
/*!40000 ALTER TABLE `cogsglpostings` ENABLE KEYS */;
-- Table structure for table `companies`
DROP TABLE IF EXISTS `companies`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `companies` (
`coycode` int(11) NOT NULL DEFAULT '1',
`coyname` varchar(50) NOT NULL DEFAULT '',
`gstno` varchar(20) NOT NULL DEFAULT '',
`companynumber` varchar(20) NOT NULL DEFAULT '0',
`regoffice1` varchar(40) NOT NULL DEFAULT '',
`regoffice2` varchar(40) NOT NULL DEFAULT '',
`regoffice3` varchar(40) NOT NULL DEFAULT '',
`regoffice4` varchar(40) NOT NULL DEFAULT '',
`regoffice5` varchar(20) NOT NULL DEFAULT '',
`regoffice6` varchar(15) NOT NULL DEFAULT '',
`telephone` varchar(25) NOT NULL DEFAULT '',
`fax` varchar(25) NOT NULL DEFAULT '',
`email` varchar(55) NOT NULL DEFAULT '',
`currencydefault` varchar(4) NOT NULL DEFAULT '',
`debtorsact` varchar(20) NOT NULL DEFAULT '70000',
`pytdiscountact` varchar(20) NOT NULL DEFAULT '55000',
`creditorsact` varchar(20) NOT NULL DEFAULT '80000',
`payrollact` varchar(20) NOT NULL DEFAULT '84000',
`grnact` varchar(20) NOT NULL DEFAULT '72000',
`exchangediffact` varchar(20) NOT NULL DEFAULT '65000',
`purchasesexchangediffact` varchar(20) NOT NULL DEFAULT '0',
`retainedearnings` varchar(20) NOT NULL DEFAULT '90000',
`gllink_debtors` tinyint(1) DEFAULT '1',
`gllink_creditors` tinyint(1) DEFAULT '1',
`gllink_stock` tinyint(1) DEFAULT '1',
`freightact` varchar(20) NOT NULL DEFAULT '0',
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Dumping data for table `companies`
LOCK TABLES `companies` WRITE;
/*!40000 ALTER TABLE `companies` DISABLE KEYS */;
INSERT INTO `companies` VALUES (1,'[[site_name]]','not entered yet','','123 Web Way','PO Box 123','Queen Street','Melbourne','Victoria 3043','Australia','+61 3 4567 8901','+61 3 4567 8902','weberp@weberpdemo.com','USD','1100','4900','2100','2400','2150','4200','5200','3500',1,1,1,'5600');
/*!40000 ALTER TABLE `companies` ENABLE KEYS */;
-- Table structure for table `config`
DROP TABLE IF EXISTS `config`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
`confname` varchar(35) NOT NULL DEFAULT '',
`confvalue` text NOT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Dumping data for table `config`
LOCK TABLES `config` WRITE;
/*!40000 ALTER TABLE `config` DISABLE KEYS */;
INSERT INTO `config` VALUES ('AllowOrderLineItemNarrative','1'),('AllowSalesOfZeroCostItems','0'),('AutoAuthorisePO','1'),('AutoCreateWOs','1'),('AutoDebtorNo','0'),('AutoIssue','1'),('AutoSupplierNo','0'),('CheckCreditLimits','1'),('Check_Price_Charged_vs_Order_Price','1'),('Check_Qty_Charged_vs_Del_Qty','1'),('CountryOfOperation','US'),('CreditingControlledItems_MustExist','0'),('DB_Maintenance','0'),('DB_Maintenance_LastRun','2015-08-14'),('DefaultBlindPackNote','1'),('DefaultCreditLimit','1000'),('DefaultCustomerType','1'),('DefaultDateFormat','d/m/Y'),('DefaultDisplayRecordsMax','50'),('DefaultFactoryLocation','MEL'),('DefaultPriceList','DE'),('DefaultSupplierType','1'),('DefaultTaxCategory','1'),('Default_Shipper','1'),('DefineControlledOnWOEntry','1'),('DispatchCutOffTime','14'),('DoFreightCalc','0'),('EDIHeaderMsgId','D:01B:UN:EAN010'),('EDIReference','WEBERP'),('EDI_Incoming_Orders','companies/weberpdemo/EDI_Incoming_Orders'),('EDI_MsgPending','companies/weberpdemo/EDI_Pending'),('EDI_MsgSent','companies/weberpdemo/EDI_Sent'),('ExchangeRateFeed','Google'),('Extended_CustomerInfo','1'),('Extended_SupplierInfo','1'),('FactoryManagerEmail','manager@company.com'),('FreightChargeAppliesIfLessThan','1000'),('FreightTaxCategory','1'),('FrequentlyOrderedItems','0'),('geocode_integration','0'),('GoogleTranslatorAPIKey',''),('HTTPS_Only','0'),('InventoryManagerEmail','test@company.com'),('InvoicePortraitFormat','0'),('InvoiceQuantityDefault','1'),('ItemDescriptionLanguages',',fr_FR.utf8,'),('LastDayOfWeek','0'),('LogPath',''),('LogSeverity','0'),('MaxImageSize','300'),('MaxSerialItemsIssued','50'),('MonthsAuditTrail','1'),('NumberOfMonthMustBeShown','6'),('NumberOfPeriodsOfStockUsage','12'),('OverChargeProportion','30'),('OverReceiveProportion','20'),('PackNoteFormat','1'),('PageLength','48'),('part_pics_dir','companies/weberpdemo/part_pics'),('PastDueDays1','30'),('PastDueDays2','60'),('PO_AllowSameItemMultipleTimes','1'),('ProhibitJournalsToControlAccounts','1'),('ProhibitNegativeStock','0'),('ProhibitPostingsBefore','2013-12-31'),('PurchasingManagerEmail','test@company.com'),('QualityCOAText',''),('QualityLogSamples','0'),('QualityProdSpecText',''),('QuickEntries','10'),('RadioBeaconFileCounter','/home/RadioBeacon/FileCounter'),('RadioBeaconFTP_user_name','RadioBeacon ftp server user name'),('RadioBeaconHomeDir','/home/RadioBeacon'),('RadioBeaconStockLocation','BL'),('RadioBraconFTP_server','192.168.2.2'),('RadioBreaconFilePrefix','ORDXX'),('RadionBeaconFTP_user_pass','Radio Beacon remote ftp server password'),('reports_dir','companies/weberpdemo/EDI_Incoming_Orders'),('RequirePickingNote','0'),('RomalpaClause','Ownership will not pass to the buyer until the goods have been paid for in full.'),('ShopAboutUs','This web-shop software has been developed by Logic Works Ltd for webERP. For support contact Phil Daintree by rn<a href=\\\"mailto:support@logicworks.co.nz\\\">email</a>rn'),('ShopAllowBankTransfer','1'),('ShopAllowCreditCards','1'),('ShopAllowPayPal','1'),('ShopAllowSurcharges','1'),('ShopBankTransferSurcharge','0.0'),('ShopBranchCode','ANGRY'),('ShopContactUs','For support contact Logic Works Ltd by rn<a href=\\\"mailto:support@logicworks.co.nz\\\">email</a>'),('ShopCreditCardBankAccount','1030'),('ShopCreditCardGateway','SwipeHQ'),('ShopCreditCardSurcharge','2.95'),('ShopDebtorNo','ANGRY'),('ShopFreightMethod','NoFreight'),('ShopFreightPolicy','Shipping information'),('ShopManagerEmail','shopmanager@yourdomain.com'),('ShopMode','test'),('ShopName','webERP Demo Store'),('ShopPayFlowMerchant',''),('ShopPayFlowPassword',''),('ShopPayFlowUser',''),('ShopPayFlowVendor',''),('ShopPayPalBankAccount','1040'),('ShopPaypalCommissionAccount','1'),('ShopPayPalPassword',''),('ShopPayPalProPassword',''),('ShopPayPalProSignature',''),('ShopPayPalProUser',''),('ShopPayPalSignature',''),('ShopPayPalSurcharge','3.4'),('ShopPayPalUser',''),('ShopPrivacyStatement','<h2>We are committed to protecting your privacy.</h2><p>We recognise that your personal information is confidential and we understand that it is important for you to know how we treat your personal information. Please read on for more information about our Privacy Policy.</p><ul><li><h2>1. What information do we collect and how do we use it?</h2><br />We use the information it collects from you for the following purposes:<ul><li>To assist us in providing you with a quality service</li><li>To respond to, and process, your request</li><li>To notify competition winners or fulfil promotional obligations</li><li>To inform you of, and provide you with, new and existing products and services offered by us from time to time </li></ul><p>Any information we collect will not be used in ways that you have not consented to.</p><p>If you send us an email, we will store your email address and the contents of the email. This information will only be used for the purpose for which you have provided it. Electronic mail submitted to us is handled and saved according to the provisions of the the relevant statues.</p><p>When we offer contests and promotions, customers who choose to enter are asked to provide personal information. This information may then be used by us to notify winners, or to fulfil promotional obligations.</p><p>We may use the information we collect to occasionally notify you about important functionality changes to our website, new and special offers we think you will find valuable. If at any stage you no longer wish to receive these notifications you may opt out by sending us an email.</p><p>We do monitor this website in order to identify user trends and to improve the site if necessary. Any of this information, such as the type of site browser your computer has, will be used only in aggregate form and your individual details will not be identified.</p></li><li><h2>2. How do we store and protect your personal information and who has access to that information?</h2><p>As required by statute, we follow strict procedures when storing and using the information you have provided.</p><p>We do not sell, trade or rent your personal information to others. We may provide aggregate statistics about our customers and website trends. However, these statistics will not have any personal information which would identify you.</p><p>Only specific employees within our company are able to access your personal data.</p><p>This policy means that we may require proof of identity before we disclose any information to you.</p></li><li><h2>3. What should I do if I want to change my details or if I don’t want to be contacted any more?</h2><p>At any stage you have the right to access and amend or update your personal details. If you do not want to receive any communications from us you may opt out by contacting us see <a href=\\\"index.php?Page=ContactUs\\\">the Contact Us Page</a></p></li><li><h2>4. What happens if we decide to change this Privacy Policy?</h2><p>If we change any aspect of our Privacy Policy we will post these changes on this page so that you are always aware of how we are treating your personal information.</p></li><li><h2>5. How can you contact us if you have any questions, comments or concerns about our Privacy Policy?</h2><p>We welcome any questions or comments you may have please email us via the contact details provided on our <a href=\\\"index.php?Page=ContactUs\\\">Contact Us Page</a></p></li></ul><p>Please also refer to our <a href=\\\"index.php?Page=TermsAndConditions\\\">Terms and Conditions</a> for more information.</p>'),('ShopShowOnlyAvailableItems','0'),('ShopShowQOHColumn','1'),('ShopStockLocations','MEL,TOR'),('ShopSurchargeStockID','PAYTSURCHARGE'),('ShopSwipeHQAPIKey',''),('ShopSwipeHQMerchantID',''),('ShopTermsConditions','<p>These terms cover the use of this website. Use includes visits to our sites, purchases on our sites, participation in our database and promotions. These terms of use apply to you when you use our websites. Please read these terms carefully - if you need to refer to them again they can be accessed from the link at the bottom of any page of our websites.</p><br /><ul><li><h2>1. Content</h2><p>While we endeavour to supply accurate information on this site, errors and omissions may occur. We do not accept any liability, direct or indirect, for any loss or damage which may directly or indirectly result from any advice, opinion, information, representation or omission whether negligent or otherwise, contained on this site. You are solely responsible for the actions you take in reliance on the content on, or accessed, through this site.</p><p>We reserve the right to make changes to the content on this site at any time and without notice.</p><p>To the extent permitted by law, we make no warranties in relation to the merchantability, fitness for purpose, freedom from computer virus, accuracy or availability of this web site or any other web site.</p></li><li><h2>2. Making a contract with us</h2><p>When you place an order with us, you are making an offer to buy goods. We will send you an e-mail to confirm that we have received and accepted your order, which indicates that a contract has been made between us. We will take payment from you when we accept your order. In the unlikely event that the goods are no longer available, we will refund your payment to the account it originated from, and advise that the goods are no longer available.</p><p>An order is placed on our website via adding a product to the shopping cart and proceeding through our checkout process. The checkout process includes giving us delivery and any other relevant details for your order, entering payment information and submitting your order. The final step consists of a confirmation page with full details of your order, which you are able to print as a receipt of your order. We will also email you with confirmation of your order.</p><p>We reserve the right to refuse or cancel any orders that we believe, solely by our own judgement, to be placed for commercial purposes, e.g. any kind of reseller. We also reserve the right to refuse or cancel any orders that we believe, solely by our own judgement, to have been placed fraudulently.</p><p>We reserve the right to limit the number of an item customers can purchase in a single transaction.</p></li><li><h2>3. Payment options</h2><p>We currently accept the following credit cards:</p><ul><li>Visa</li><li>MasterCard</li><li>American Express</li></ul>You can also pay using PayPal and internet bank transfer. Surcharges may apply for payment by PayPal or credit cards.</p></li><li><h2>4. Pricing</h2><p>All prices listed are inclusive of relevant taxes. All prices are correct when published. Please note that we reserve the right to alter prices at any time for any reason. If this should happen after you have ordered a product, we will contact you prior to processing your order. Online and in store pricing may differ.</p></li><li><h2>5. Website and Credit Card Security</h2><p>We want you to have a safe and secure shopping experience online. All payments via our sites are processed using SSL (Secure Socket Layer) protocol, whereby sensitive information is encrypted to protect your privacy.</p><p>You can help to protect your details from unauthorised access by logging out each time you finish using the site, particularly if you are doing so from a public or shared computer.</p><p>For security purposes certain transactions may require proof of identification.</p></li><li><h2>6. Delivery and Delivery Charges</h2><p>We do not deliver to Post Office boxes.</p><p>Please note that a signature is required for all deliveries. The goods become the recipient’s property and responsibility once they have been signed for at the time of delivery. If goods are lost or damaged in transit, please contact us within 7 business days <a href=\\\"index.php?Page=ContactUs\\\">see Contact Us page for contact details</a>. We will use this delivery information to make a claim against our courier company. We will offer you the choice of a replacement or a full refund, once we have received confirmation from our courier company that delivery was not successful.</p></li><li><h2>7. Restricted Products</h2><p>Some products on our site carry an age restriction, if a product you have selected is R16 or R18 a message will appear in the cart asking you to confirm you are an appropriate age to purchase the item(s). Confirming this means that you are of an eligible age to purchase the selected product(s). You are also agreeing that you are not purchasing the item on behalf of a person who is not the appropriate age.</p></li><li><h2>8. Delivery Period</h2><p>Delivery lead time for products may vary. Deliveries to rural addresses may take longer. You will receive an email that confirms that your order has been dispatched.</p><p>To ensure successful delivery, please provide a delivery address where someone will be present during business hours to sign for the receipt of your package. You can track your order by entering the tracking number emailed to you in the dispatch email at the Courier\\\'s web-site.</p></li><li><h2>9. Disclaimer</h2><p>Our websites are intended to provide information for people shopping our products and accessing our services, including making purchases via our website and registering on our database to receive e-mails from us.</p><p>While we endeavour to supply accurate information on this site, errors and omissions may occur. We do not accept any liability, direct or indirect, for any loss or damage which may directly or indirectly result from any advice, opinion, information, representation or omission whether negligent or otherwise, contained on this site. You are solely responsible for the actions you take in reliance on the content on, or accessed, through this site.</p><p>We reserve the right to make changes to the content on this site at any time and without notice.</p><p>To the extent permitted by law, we make no warranties in relation to the merchantability, fitness for purpose, freedom from computer virus, accuracy or availability of this web site or any other web site.</p></li><li><h2>10. Links</h2><p>Please note that although this site has some hyperlinks to other third party websites, these sites have not been prepared by us are not under our control. The links are only provided as a convenience, and do not imply that we endorse, check, or approve of the third party site. We are not responsible for the privacy principles or content of these third party sites. We are not responsible for the availability of any of these links.</p></li><li><h2>11. Jurisdiction</h2><p>This website is governed by, and is to be interpreted in accordance with, the laws of ????.</p></li><li><h2>12. Changes to this Agreement</h2><p>We reserve the right to alter, modify or update these terms of use. These terms apply to your order. We may change our terms and conditions at any time, so please do not assume that the same terms will apply to future orders.</p></li></ul>'),('ShopTitle','Shop Home'),('ShortcutMenu','0'),('ShowStockidOnImages','0'),('ShowValueOnGRN','1'),('Show_Settled_LastMonth','1'),('SmtpSetting','0'),('SO_AllowSameItemMultipleTimes','1'),('StandardCostDecimalPlaces','2'),('StockUsageShowZeroWithinPeriodRange','0'),('TaxAuthorityReferenceName',''),('UpdateCurrencyRatesDaily','0'),('VersionNumber','4.15.2'),('WeightedAverageCosting','0'),('WikiApp','DokuWiki'),('WikiPath','wiki'),('WorkingDaysWeek','5'),('YearEnd','3');
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
-- Table structure for table `contractbom`
DROP TABLE IF EXISTS `contractbom`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `contractbom` (
`contractref` varchar(20) NOT NULL DEFAULT '0',
`stockid` varchar(20) NOT NULL DEFAULT '',
`workcentreadded` char(5) NOT NULL DEFAULT '',
`quantity` double NOT NULL DEFAULT '1',
PRIMARY KEY (`contractref`,`stockid`,`workcentreadded`),
KEY `Stockid` (`stockid`),
KEY `ContractRef` (`contractref`),
KEY `WorkCentreAdded` (`workcentreadded`),
CONSTRAINT `contractbom_ibfk_1` FOREIGN KEY (`workcentreadded`) REFERENCES `workcentres` (`code`),
CONSTRAINT `contractbom_ibfk_3` FOREIGN KEY (`stockid`) REFERENCES `stockmaster` (`stockid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Dumping data for table `contractbom`
LOCK TABLES `contractbom` WRITE;
/*!40000 ALTER TABLE `contractbom` DISABLE KEYS */;
/*!40000 ALTER TABLE `contractbom` ENABLE KEYS */;
-- Table structure for table `contractcharges`
DROP TABLE IF EXISTS `contractcharges`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `contractcharges` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`contractref` varchar(20) NOT NULL,
`transtype` smallint(6) NOT NULL DEFAULT '20',
`transno` int(11) NOT NULL DEFAULT '0',
`amount` double NOT NULL DEFAULT '0',
`narrative` text NOT NULL,
It is recommended that you Edit text format, this type of Fix handles quite a lot in one request
