1 # Built by FrontAccounting 2.1.2
2 # http://frontaccounting.net
3 # Company: Training Co.
8 ### Structure of table `0_areas` ###
10 DROP TABLE IF EXISTS `0_areas`;
12 CREATE TABLE `0_areas` (
13 `area_code` int(11) NOT NULL auto_increment,
14 `description` varchar(60) NOT NULL default '',
15 `inactive` tinyint(1) NOT NULL default '0',
16 PRIMARY KEY (`area_code`),
17 UNIQUE KEY `description` (`description`)
18 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
21 ### Data of table `0_areas` ###
23 INSERT INTO `0_areas` VALUES ('1', 'Global', '0');
26 ### Structure of table `0_attachments` ###
28 DROP TABLE IF EXISTS `0_attachments`;
30 CREATE TABLE `0_attachments` (
31 `id` int(11) unsigned NOT NULL auto_increment,
32 `description` varchar(60) NOT NULL default '',
33 `type_no` int(11) NOT NULL default '0',
34 `trans_no` int(11) NOT NULL default '0',
35 `unique_name` varchar(60) NOT NULL default '',
36 `tran_date` date NOT NULL default '0000-00-00',
37 `filename` varchar(60) NOT NULL default '',
38 `filesize` int(11) NOT NULL default '0',
39 `filetype` varchar(60) NOT NULL default '',
41 KEY `type_no` (`type_no`,`trans_no`)
42 ) TYPE=MyISAM AUTO_INCREMENT=1 ;
45 ### Data of table `0_attachments` ###
49 ### Structure of table `0_bank_accounts` ###
51 DROP TABLE IF EXISTS `0_bank_accounts`;
53 CREATE TABLE `0_bank_accounts` (
54 `account_code` varchar(11) NOT NULL default '',
55 `account_type` smallint(6) NOT NULL default '0',
56 `bank_account_name` varchar(60) NOT NULL default '',
57 `bank_account_number` varchar(100) NOT NULL default '',
58 `bank_name` varchar(60) NOT NULL default '',
59 `bank_address` tinytext,
60 `bank_curr_code` char(3) NOT NULL default '',
61 `id` smallint(6) NOT NULL auto_increment,
62 `last_reconciled_date` timestamp NOT NULL default '0000-00-00 00:00:00',
63 `ending_reconcile_balance` double NOT NULL default '0',
64 `inactive` tinyint(1) NOT NULL default '0',
66 KEY `bank_account_name` (`bank_account_name`),
67 KEY `bank_account_number` (`bank_account_number`)
68 ) TYPE=MyISAM AUTO_INCREMENT=3 ;
71 ### Data of table `0_bank_accounts` ###
73 INSERT INTO `0_bank_accounts` VALUES ('1060', '0', 'Current account', '9999999999', 'Wachovia Bank', '', 'USD', '1', '0000-00-00 00:00:00', '0', '0');
74 INSERT INTO `0_bank_accounts` VALUES ('1065', '3', 'Petty Cash account', 'N/A', 'N/A', '', 'USD', '2', '0000-00-00 00:00:00', '0', '0');
77 ### Structure of table `0_bank_trans` ###
79 DROP TABLE IF EXISTS `0_bank_trans`;
81 CREATE TABLE `0_bank_trans` (
82 `id` int(11) NOT NULL auto_increment,
83 `type` smallint(6) default NULL,
84 `trans_no` int(11) default NULL,
85 `bank_act` varchar(11) default NULL,
86 `ref` varchar(40) default NULL,
87 `trans_date` date NOT NULL default '0000-00-00',
88 `amount` double default NULL,
89 `dimension_id` int(11) NOT NULL default '0',
90 `dimension2_id` int(11) NOT NULL default '0',
91 `person_type_id` int(11) NOT NULL default '0',
93 `reconciled` date default NULL,
95 KEY `bank_act` (`bank_act`,`ref`),
96 KEY `type` (`type`,`trans_no`)
97 ) TYPE=InnoDB AUTO_INCREMENT=12 ;
100 ### Data of table `0_bank_trans` ###
102 INSERT INTO `0_bank_trans` VALUES ('1', '22', '4', '1', '1', '2009-06-21', '-3465', '0', '0', '3', '2', '');
103 INSERT INTO `0_bank_trans` VALUES ('2', '26', '1', '1', '', '2009-06-21', '-10', '0', '0', '1', '1', '');
104 INSERT INTO `0_bank_trans` VALUES ('3', '26', '1', '1', '', '2009-06-21', '-20', '0', '0', '1', '0', '');
105 INSERT INTO `0_bank_trans` VALUES ('4', '0', '18', '1', '1', '2009-02-20', '1000', '0', '0', '0', '', '');
106 INSERT INTO `0_bank_trans` VALUES ('5', '0', '19', '1', '2', '2009-02-21', '4000', '0', '0', '0', '', '');
107 INSERT INTO `0_bank_trans` VALUES ('6', '2', '5', '1', '1', '2009-06-21', '100', '0', '0', '4', '3', '');
108 INSERT INTO `0_bank_trans` VALUES ('7', '1', '8', '1', '1', '2009-06-21', '-50', '0', '0', '4', '1', '');
109 INSERT INTO `0_bank_trans` VALUES ('8', '26', '5', '1', '', '2009-06-21', '-10', '0', '0', '1', '1', '');
110 INSERT INTO `0_bank_trans` VALUES ('9', '26', '5', '1', '', '2009-06-21', '-20', '0', '0', '1', '0', '');
111 INSERT INTO `0_bank_trans` VALUES ('10', '26', '7', '1', '', '2009-06-21', '-10', '0', '0', '1', '1', '');
112 INSERT INTO `0_bank_trans` VALUES ('11', '26', '7', '1', '', '2009-06-21', '-20', '0', '0', '1', '0', '');
115 ### Structure of table `0_bom` ###
117 DROP TABLE IF EXISTS `0_bom`;
119 CREATE TABLE `0_bom` (
120 `id` int(11) NOT NULL auto_increment,
121 `parent` char(20) NOT NULL default '',
122 `component` char(20) NOT NULL default '',
123 `workcentre_added` int(11) NOT NULL default '0',
124 `loc_code` char(5) NOT NULL default '',
125 `quantity` double NOT NULL default '1',
126 PRIMARY KEY (`parent`,`component`,`workcentre_added`,`loc_code`),
127 KEY `component` (`component`),
129 KEY `loc_code` (`loc_code`),
130 KEY `parent` (`parent`,`loc_code`),
131 KEY `Parent_2` (`parent`),
132 KEY `workcentre_added` (`workcentre_added`)
133 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
136 ### Data of table `0_bom` ###
138 INSERT INTO `0_bom` VALUES ('1', '3400', '102', '1', 'DEF', '1');
139 INSERT INTO `0_bom` VALUES ('2', '3400', '103', '1', 'DEF', '1');
140 INSERT INTO `0_bom` VALUES ('3', '3400', '104', '1', 'DEF', '1');
143 ### Structure of table `0_budget_trans` ###
145 DROP TABLE IF EXISTS `0_budget_trans`;
147 CREATE TABLE `0_budget_trans` (
148 `counter` int(11) NOT NULL auto_increment,
149 `type` smallint(6) NOT NULL default '0',
150 `type_no` bigint(16) NOT NULL default '1',
151 `tran_date` date NOT NULL default '0000-00-00',
152 `account` varchar(11) NOT NULL default '',
153 `memo_` tinytext NOT NULL,
154 `amount` double NOT NULL default '0',
155 `dimension_id` int(11) default '0',
156 `dimension2_id` int(11) default '0',
157 `person_type_id` int(11) default NULL,
158 `person_id` tinyblob,
159 PRIMARY KEY (`counter`),
160 KEY `Type_and_Number` (`type`,`type_no`)
161 ) TYPE=InnoDB AUTO_INCREMENT=1 ;
164 ### Data of table `0_budget_trans` ###
168 ### Structure of table `0_chart_class` ###
170 DROP TABLE IF EXISTS `0_chart_class`;
172 CREATE TABLE `0_chart_class` (
173 `cid` int(11) NOT NULL default '0',
174 `class_name` varchar(60) NOT NULL default '',
175 `balance_sheet` tinyint(1) NOT NULL default '0',
180 ### Data of table `0_chart_class` ###
182 INSERT INTO `0_chart_class` VALUES ('1', 'Assets', '1');
183 INSERT INTO `0_chart_class` VALUES ('2', 'Liabilities', '2');
184 INSERT INTO `0_chart_class` VALUES ('3', 'Income', '4');
185 INSERT INTO `0_chart_class` VALUES ('4', 'Costs', '6');
188 ### Structure of table `0_chart_master` ###
190 DROP TABLE IF EXISTS `0_chart_master`;
192 CREATE TABLE `0_chart_master` (
193 `account_code` varchar(11) NOT NULL default '',
194 `account_code2` varchar(11) default '',
195 `account_name` varchar(60) NOT NULL default '',
196 `account_type` int(11) NOT NULL default '0',
197 `inactive` tinyint(1) NOT NULL default '0',
198 PRIMARY KEY (`account_code`),
199 KEY `account_code` (`account_code`),
200 KEY `account_name` (`account_name`)
204 ### Data of table `0_chart_master` ###
206 INSERT INTO `0_chart_master` VALUES ('1060', '', 'Checking Account', '1', '0');
207 INSERT INTO `0_chart_master` VALUES ('1065', '', 'Petty Cash', '1', '0');
208 INSERT INTO `0_chart_master` VALUES ('1200', '', 'Accounts Receivables', '1', '0');
209 INSERT INTO `0_chart_master` VALUES ('1205', '', 'Allowance for doubtful accounts', '1', '0');
210 INSERT INTO `0_chart_master` VALUES ('1510', '', 'Inventory', '2', '0');
211 INSERT INTO `0_chart_master` VALUES ('1520', '', 'Stocks of Raw Materials', '2', '0');
212 INSERT INTO `0_chart_master` VALUES ('1530', '', 'Stocks of Work In Progress', '2', '0');
213 INSERT INTO `0_chart_master` VALUES ('1540', '', 'Stocks of Finsihed Goods', '2', '0');
214 INSERT INTO `0_chart_master` VALUES ('1550', '', 'Goods Received Clearing account', '2', '0');
215 INSERT INTO `0_chart_master` VALUES ('1820', '', 'Office Furniture & Equipment', '3', '0');
216 INSERT INTO `0_chart_master` VALUES ('1825', '', 'Accum. Amort. -Furn. & Equip.', '3', '0');
217 INSERT INTO `0_chart_master` VALUES ('1840', '', 'Vehicle', '3', '0');
218 INSERT INTO `0_chart_master` VALUES ('1845', '', 'Accum. Amort. -Vehicle', '3', '0');
219 INSERT INTO `0_chart_master` VALUES ('2100', '', 'Accounts Payable', '4', '0');
220 INSERT INTO `0_chart_master` VALUES ('2110', '', 'Accrued Income Tax - Federal', '4', '0');
221 INSERT INTO `0_chart_master` VALUES ('2120', '', 'Accrued Income Tax - State', '4', '0');
222 INSERT INTO `0_chart_master` VALUES ('2130', '', 'Accrued Franchise Tax', '4', '0');
223 INSERT INTO `0_chart_master` VALUES ('2140', '', 'Accrued Real & Personal Prop Tax', '4', '0');
224 INSERT INTO `0_chart_master` VALUES ('2150', '', 'Sales Tax', '4', '0');
225 INSERT INTO `0_chart_master` VALUES ('2160', '', 'Accrued Use Tax Payable', '4', '0');
226 INSERT INTO `0_chart_master` VALUES ('2210', '', 'Accrued Wages', '4', '0');
227 INSERT INTO `0_chart_master` VALUES ('2220', '', 'Accrued Comp Time', '4', '0');
228 INSERT INTO `0_chart_master` VALUES ('2230', '', 'Accrued Holiday Pay', '4', '0');
229 INSERT INTO `0_chart_master` VALUES ('2240', '', 'Accrued Vacation Pay', '4', '0');
230 INSERT INTO `0_chart_master` VALUES ('2310', '', 'Accr. Benefits - 401K', '4', '0');
231 INSERT INTO `0_chart_master` VALUES ('2320', '', 'Accr. Benefits - Stock Purchase', '4', '0');
232 INSERT INTO `0_chart_master` VALUES ('2330', '', 'Accr. Benefits - Med, Den', '4', '0');
233 INSERT INTO `0_chart_master` VALUES ('2340', '', 'Accr. Benefits - Payroll Taxes', '4', '0');
234 INSERT INTO `0_chart_master` VALUES ('2350', '', 'Accr. Benefits - Credit Union', '4', '0');
235 INSERT INTO `0_chart_master` VALUES ('2360', '', 'Accr. Benefits - Savings Bond', '4', '0');
236 INSERT INTO `0_chart_master` VALUES ('2370', '', 'Accr. Benefits - Garnish', '4', '0');
237 INSERT INTO `0_chart_master` VALUES ('2380', '', 'Accr. Benefits - Charity Cont.', '4', '0');
238 INSERT INTO `0_chart_master` VALUES ('2620', '', 'Bank Loans', '5', '0');
239 INSERT INTO `0_chart_master` VALUES ('2680', '', 'Loans from Shareholders', '5', '0');
240 INSERT INTO `0_chart_master` VALUES ('3350', '', 'Common Shares', '6', '0');
241 INSERT INTO `0_chart_master` VALUES ('3590', '', 'Retained Earnings - prior years', '7', '0');
242 INSERT INTO `0_chart_master` VALUES ('4010', '', 'Sales', '8', '0');
243 INSERT INTO `0_chart_master` VALUES ('4430', '', 'Shipping & Handling', '9', '0');
244 INSERT INTO `0_chart_master` VALUES ('4440', '', 'Interest', '9', '0');
245 INSERT INTO `0_chart_master` VALUES ('4450', '', 'Foreign Exchange Gain', '9', '0');
246 INSERT INTO `0_chart_master` VALUES ('4500', '', 'Prompt Payment Discounts', '9', '0');
247 INSERT INTO `0_chart_master` VALUES ('4510', '', 'Discounts Given', '9', '0');
248 INSERT INTO `0_chart_master` VALUES ('5010', '', 'Cost of Goods Sold - Retail', '10', '0');
249 INSERT INTO `0_chart_master` VALUES ('5020', '', 'Material Usage Varaiance', '10', '0');
250 INSERT INTO `0_chart_master` VALUES ('5030', '', 'Consumable Materials', '10', '0');
251 INSERT INTO `0_chart_master` VALUES ('5040', '', 'Purchase price Variance', '10', '0');
252 INSERT INTO `0_chart_master` VALUES ('5050', '', 'Purchases of materials', '10', '0');
253 INSERT INTO `0_chart_master` VALUES ('5060', '', 'Discounts Received', '10', '0');
254 INSERT INTO `0_chart_master` VALUES ('5100', '', 'Freight', '10', '0');
255 INSERT INTO `0_chart_master` VALUES ('5410', '', 'Wages & Salaries', '11', '0');
256 INSERT INTO `0_chart_master` VALUES ('5420', '', 'Wages - Overtime', '11', '0');
257 INSERT INTO `0_chart_master` VALUES ('5430', '', 'Benefits - Comp Time', '11', '0');
258 INSERT INTO `0_chart_master` VALUES ('5440', '', 'Benefits - Payroll Taxes', '11', '0');
259 INSERT INTO `0_chart_master` VALUES ('5450', '', 'Benefits - Workers Comp', '11', '0');
260 INSERT INTO `0_chart_master` VALUES ('5460', '', 'Benefits - Pension', '11', '0');
261 INSERT INTO `0_chart_master` VALUES ('5470', '', 'Benefits - General Benefits', '11', '0');
262 INSERT INTO `0_chart_master` VALUES ('5510', '', 'Inc Tax Exp - Federal', '11', '0');
263 INSERT INTO `0_chart_master` VALUES ('5520', '', 'Inc Tax Exp - State', '11', '0');
264 INSERT INTO `0_chart_master` VALUES ('5530', '', 'Taxes - Real Estate', '11', '0');
265 INSERT INTO `0_chart_master` VALUES ('5540', '', 'Taxes - Personal Property', '11', '0');
266 INSERT INTO `0_chart_master` VALUES ('5550', '', 'Taxes - Franchise', '11', '0');
267 INSERT INTO `0_chart_master` VALUES ('5560', '', 'Taxes - Foreign Withholding', '11', '0');
268 INSERT INTO `0_chart_master` VALUES ('5610', '', 'Accounting & Legal', '12', '0');
269 INSERT INTO `0_chart_master` VALUES ('5615', '', 'Advertising & Promotions', '12', '0');
270 INSERT INTO `0_chart_master` VALUES ('5620', '', 'Bad Debts', '12', '0');
271 INSERT INTO `0_chart_master` VALUES ('5660', '', 'Amortization Expense', '12', '0');
272 INSERT INTO `0_chart_master` VALUES ('5685', '', 'Insurance', '12', '0');
273 INSERT INTO `0_chart_master` VALUES ('5690', '', 'Interest & Bank Charges', '12', '0');
274 INSERT INTO `0_chart_master` VALUES ('5700', '', 'Office Supplies', '12', '0');
275 INSERT INTO `0_chart_master` VALUES ('5760', '', 'Rent', '12', '0');
276 INSERT INTO `0_chart_master` VALUES ('5765', '', 'Repair & Maintenance', '12', '0');
277 INSERT INTO `0_chart_master` VALUES ('5780', '', 'Telephone', '12', '0');
278 INSERT INTO `0_chart_master` VALUES ('5785', '', 'Travel & Entertainment', '12', '0');
279 INSERT INTO `0_chart_master` VALUES ('5790', '', 'Utilities', '12', '0');
280 INSERT INTO `0_chart_master` VALUES ('5795', '', 'Registrations', '12', '0');
281 INSERT INTO `0_chart_master` VALUES ('5800', '', 'Licenses', '12', '0');
282 INSERT INTO `0_chart_master` VALUES ('5810', '', 'Foreign Exchange Loss', '12', '0');
283 INSERT INTO `0_chart_master` VALUES ('9990', '', 'Year Profit/Loss', '12', '0');
286 ### Structure of table `0_chart_types` ###
288 DROP TABLE IF EXISTS `0_chart_types`;
290 CREATE TABLE `0_chart_types` (
291 `id` int(11) NOT NULL auto_increment,
292 `name` varchar(60) NOT NULL default '',
293 `class_id` tinyint(1) NOT NULL default '0',
294 `parent` int(11) NOT NULL default '-1',
297 ) TYPE=MyISAM AUTO_INCREMENT=13 ;
300 ### Data of table `0_chart_types` ###
302 INSERT INTO `0_chart_types` VALUES ('1', 'Current Assets', '1', '0');
303 INSERT INTO `0_chart_types` VALUES ('2', 'Inventory Assets', '1', '0');
304 INSERT INTO `0_chart_types` VALUES ('3', 'Capital Assets', '1', '0');
305 INSERT INTO `0_chart_types` VALUES ('4', 'Current Liabilities', '2', '0');
306 INSERT INTO `0_chart_types` VALUES ('5', 'Long Term Liabilities', '2', '0');
307 INSERT INTO `0_chart_types` VALUES ('6', 'Share Capital', '2', '0');
308 INSERT INTO `0_chart_types` VALUES ('7', 'Retained Earnings', '2', '0');
309 INSERT INTO `0_chart_types` VALUES ('8', 'Sales Revenue', '3', '0');
310 INSERT INTO `0_chart_types` VALUES ('9', 'Other Revenue', '3', '0');
311 INSERT INTO `0_chart_types` VALUES ('10', 'Cost of Goods Sold', '4', '0');
312 INSERT INTO `0_chart_types` VALUES ('11', 'Payroll Expenses', '4', '0');
313 INSERT INTO `0_chart_types` VALUES ('12', 'General & Administrative expenses', '4', '0');
316 ### Structure of table `0_comments` ###
318 DROP TABLE IF EXISTS `0_comments`;
320 CREATE TABLE `0_comments` (
321 `type` int(11) NOT NULL default '0',
322 `id` int(11) NOT NULL default '0',
323 `date_` date default '0000-00-00',
328 ### Data of table `0_comments` ###
332 ### Structure of table `0_company` ###
334 DROP TABLE IF EXISTS `0_company`;
336 CREATE TABLE `0_company` (
337 `coy_code` int(11) NOT NULL default '1',
338 `coy_name` varchar(60) NOT NULL default '',
339 `gst_no` varchar(25) NOT NULL default '',
340 `coy_no` varchar(25) NOT NULL default '0',
341 `tax_prd` int(11) NOT NULL default '1',
342 `tax_last` int(11) NOT NULL default '1',
343 `postal_address` tinytext NOT NULL,
344 `phone` varchar(30) NOT NULL default '',
345 `fax` varchar(30) NOT NULL default '',
346 `email` varchar(100) NOT NULL default '',
347 `coy_logo` varchar(100) NOT NULL default '',
348 `domicile` varchar(55) NOT NULL default '',
349 `curr_default` char(3) NOT NULL default '',
350 `debtors_act` varchar(11) NOT NULL default '',
351 `pyt_discount_act` varchar(11) NOT NULL default '',
352 `creditors_act` varchar(11) NOT NULL default '',
353 `grn_act` varchar(11) NOT NULL default '',
354 `exchange_diff_act` varchar(11) NOT NULL default '',
355 `purch_exchange_diff_act` varchar(11) NOT NULL default '',
356 `retained_earnings_act` varchar(11) NOT NULL default '',
357 `freight_act` varchar(11) NOT NULL default '',
358 `default_sales_act` varchar(11) NOT NULL default '',
359 `default_sales_discount_act` varchar(11) NOT NULL default '',
360 `default_prompt_payment_act` varchar(11) NOT NULL default '',
361 `default_inventory_act` varchar(11) NOT NULL default '',
362 `default_cogs_act` varchar(11) NOT NULL default '',
363 `default_adj_act` varchar(11) NOT NULL default '',
364 `default_inv_sales_act` varchar(11) NOT NULL default '',
365 `default_assembly_act` varchar(11) NOT NULL default '',
366 `payroll_act` varchar(11) NOT NULL default '',
367 `custom1_name` varchar(60) NOT NULL default '',
368 `custom2_name` varchar(60) NOT NULL default '',
369 `custom3_name` varchar(60) NOT NULL default '',
370 `custom1_value` varchar(100) NOT NULL default '',
371 `custom2_value` varchar(100) NOT NULL default '',
372 `custom3_value` varchar(100) NOT NULL default '',
373 `allow_negative_stock` tinyint(1) NOT NULL default '0',
374 `po_over_receive` int(11) NOT NULL default '10',
375 `po_over_charge` int(11) NOT NULL default '10',
376 `default_credit_limit` int(11) NOT NULL default '1000',
377 `default_workorder_required` int(11) NOT NULL default '20',
378 `default_dim_required` int(11) NOT NULL default '20',
379 `past_due_days` int(11) NOT NULL default '30',
380 `use_dimension` tinyint(1) default '0',
381 `f_year` int(11) NOT NULL default '1',
382 `no_item_list` tinyint(1) NOT NULL default '0',
383 `no_customer_list` tinyint(1) NOT NULL default '0',
384 `no_supplier_list` tinyint(1) NOT NULL default '0',
385 `base_sales` int(11) NOT NULL default '-1',
386 `foreign_codes` tinyint(1) NOT NULL default '0',
387 `accumulate_shipping` tinyint(1) NOT NULL default '0',
388 `legal_text` tinytext NOT NULL,
389 PRIMARY KEY (`coy_code`)
393 ### Data of table `0_company` ###
395 INSERT INTO `0_company` VALUES ('1', 'Training Co.', '9876543', '123456789', '1', '1', 'Address 1\r\nAddress 2\r\nAddress 3', '(222) 111.222.333', '', 'delta@delta.com', 'logo_frontaccounting.jpg', '', 'USD', '1200', '5060', '2100', '1430', '4450', '4220', '2050', '4430', '4010', '4510', '4500', '1510', '5010', '5040', '4010', '1530', '5000', '', '', '', '', '', '', '0', '10', '10', '1000', '20', '20', '30', '1', '2', '0', '0', '0', '1', '0', '0', '');
398 ### Structure of table `0_credit_status` ###
400 DROP TABLE IF EXISTS `0_credit_status`;
402 CREATE TABLE `0_credit_status` (
403 `id` int(11) NOT NULL auto_increment,
404 `reason_description` char(100) NOT NULL default '',
405 `dissallow_invoices` tinyint(1) NOT NULL default '0',
406 `inactive` tinyint(1) NOT NULL default '0',
408 UNIQUE KEY `reason_description` (`reason_description`)
409 ) TYPE=MyISAM AUTO_INCREMENT=5 ;
412 ### Data of table `0_credit_status` ###
414 INSERT INTO `0_credit_status` VALUES ('1', 'Good History', '0', '0');
415 INSERT INTO `0_credit_status` VALUES ('3', 'No more work until payment received', '1', '0');
416 INSERT INTO `0_credit_status` VALUES ('4', 'In liquidation', '1', '0');
419 ### Structure of table `0_currencies` ###
421 DROP TABLE IF EXISTS `0_currencies`;
423 CREATE TABLE `0_currencies` (
424 `currency` varchar(60) NOT NULL default '',
425 `curr_abrev` char(3) NOT NULL default '',
426 `curr_symbol` varchar(10) NOT NULL default '',
427 `country` varchar(100) NOT NULL default '',
428 `hundreds_name` varchar(15) NOT NULL default '',
429 `inactive` tinyint(1) NOT NULL default '0',
430 PRIMARY KEY (`curr_abrev`)
434 ### Data of table `0_currencies` ###
436 INSERT INTO `0_currencies` VALUES ('US Dollars', 'USD', '$', 'United States', 'Cents', '0');
437 INSERT INTO `0_currencies` VALUES ('CA Dollars', 'CAD', '$', 'Canada', 'Cents', '0');
438 INSERT INTO `0_currencies` VALUES ('Euro', 'EUR', '?', 'Europe', 'Cents', '0');
439 INSERT INTO `0_currencies` VALUES ('Pounds', 'GBP', '?', 'England', 'Pence', '0');
440 INSERT INTO `0_currencies` VALUES ('DK Kroner', 'DKK', '?', 'Denmark', 'Ore', '0');
443 ### Structure of table `0_cust_allocations` ###
445 DROP TABLE IF EXISTS `0_cust_allocations`;
447 CREATE TABLE `0_cust_allocations` (
448 `id` int(11) NOT NULL auto_increment,
449 `amt` double unsigned default NULL,
450 `date_alloc` date NOT NULL default '0000-00-00',
451 `trans_no_from` int(11) default NULL,
452 `trans_type_from` int(11) default NULL,
453 `trans_no_to` int(11) default NULL,
454 `trans_type_to` int(11) default NULL,
456 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
459 ### Data of table `0_cust_allocations` ###
461 INSERT INTO `0_cust_allocations` VALUES ('1', '37.68', '2009-06-21', '3', '11', '18', '10');
464 ### Structure of table `0_cust_branch` ###
466 DROP TABLE IF EXISTS `0_cust_branch`;
468 CREATE TABLE `0_cust_branch` (
469 `branch_code` int(11) NOT NULL auto_increment,
470 `debtor_no` int(11) NOT NULL default '0',
471 `br_name` varchar(60) NOT NULL default '',
472 `br_address` tinytext NOT NULL,
473 `area` int(11) default NULL,
474 `salesman` int(11) NOT NULL default '0',
475 `phone` varchar(30) NOT NULL default '',
476 `fax` varchar(30) NOT NULL default '',
477 `contact_name` varchar(60) NOT NULL default '',
478 `email` varchar(100) NOT NULL default '',
479 `default_location` varchar(5) NOT NULL default '',
480 `tax_group_id` int(11) default NULL,
481 `sales_account` varchar(11) default NULL,
482 `sales_discount_account` varchar(11) default NULL,
483 `receivables_account` varchar(11) default NULL,
484 `payment_discount_account` varchar(11) default NULL,
485 `default_ship_via` int(11) NOT NULL default '1',
486 `disable_trans` tinyint(4) NOT NULL default '0',
487 `br_post_address` tinytext NOT NULL,
488 `group_no` int(11) NOT NULL default '0',
489 PRIMARY KEY (`branch_code`,`debtor_no`),
490 KEY `branch_code` (`branch_code`),
491 KEY `br_name` (`br_name`)
492 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
495 ### Data of table `0_cust_branch` ###
497 INSERT INTO `0_cust_branch` VALUES ('1', '1', 'Beefeater Ltd.', '', '1', '1', '', '', 'Main Branch', '', 'DEF', '2', '', '4510', '1200', '4500', '1', '0', 'Address 1\r\nAddress 2\r\nAddress 3', '0');
498 INSERT INTO `0_cust_branch` VALUES ('2', '2', 'Ghostbusters Corp.', 'Address 1\r\nAddress 2\r\nAddress 3', '1', '1', '', '', 'Main Branch', '', 'DEF', '1', '', '4510', '1200', '4500', '1', '0', 'Address 1\r\nAddress 2\r\nAddress 3', '0');
499 INSERT INTO `0_cust_branch` VALUES ('3', '3', 'Brezan', 'Address 1\r\nAddress 2\r\nAddress 3', '1', '1', '', '', 'Main Branch', '', 'DEF', '1', '', '4510', '1200', '4500', '1', '0', 'Address 1\r\nAddress 2\r\nAddress 3', '0');
502 ### Structure of table `0_debtor_trans` ###
504 DROP TABLE IF EXISTS `0_debtor_trans`;
506 CREATE TABLE `0_debtor_trans` (
507 `trans_no` int(11) unsigned NOT NULL default '0',
508 `type` smallint(6) unsigned NOT NULL default '0',
509 `version` tinyint(1) unsigned NOT NULL default '0',
510 `debtor_no` int(11) unsigned default NULL,
511 `branch_code` int(11) NOT NULL default '-1',
512 `tran_date` date NOT NULL default '0000-00-00',
513 `due_date` date NOT NULL default '0000-00-00',
514 `reference` varchar(60) NOT NULL default '',
515 `tpe` int(11) NOT NULL default '0',
516 `order_` int(11) NOT NULL default '0',
517 `ov_amount` double NOT NULL default '0',
518 `ov_gst` double NOT NULL default '0',
519 `ov_freight` double NOT NULL default '0',
520 `ov_freight_tax` double NOT NULL default '0',
521 `ov_discount` double NOT NULL default '0',
522 `alloc` double NOT NULL default '0',
523 `rate` double NOT NULL default '1',
524 `ship_via` int(11) default NULL,
525 `trans_link` int(11) NOT NULL default '0',
526 `dimension_id` int(11) NOT NULL default '0',
527 `dimension2_id` int(11) NOT NULL default '0',
528 PRIMARY KEY (`trans_no`,`type`),
529 KEY `debtor_no` (`debtor_no`,`branch_code`)
533 ### Data of table `0_debtor_trans` ###
535 INSERT INTO `0_debtor_trans` VALUES ('2', '13', '0', '1', '1', '2009-06-21', '2009-06-22', '1', '2', '1', '60.8', '0', '10', '0', '0', '0', '1.6445729799917', '1', '0', '0', '0');
536 INSERT INTO `0_debtor_trans` VALUES ('3', '11', '0', '3', '3', '2009-06-21', '0000-00-00', '1', '2', '3', '35.89', '1.79', '0', '0', '0', '37.68', '1.3932', '1', '18', '2', '0');
537 INSERT INTO `0_debtor_trans` VALUES ('3', '13', '1', '2', '2', '2009-06-21', '2009-06-22', 'auto', '1', '2', '50', '2.5', '0', '0', '0', '0', '1', '1', '17', '0', '0');
538 INSERT INTO `0_debtor_trans` VALUES ('4', '13', '1', '3', '3', '2009-06-21', '2009-07-01', 'auto', '2', '3', '35.89', '1.79', '0', '0', '0', '0', '1.3932', '1', '18', '2', '0');
539 INSERT INTO `0_debtor_trans` VALUES ('5', '13', '1', '2', '2', '2009-06-21', '2009-06-22', 'auto', '1', '5', '50', '0', '5', '0', '0', '0', '1', '1', '19', '0', '0');
540 INSERT INTO `0_debtor_trans` VALUES ('17', '10', '0', '2', '2', '2009-06-21', '2009-06-22', '1', '1', '2', '50', '2.5', '0', '0', '0', '0', '1', '1', '3', '0', '0');
541 INSERT INTO `0_debtor_trans` VALUES ('18', '10', '1', '3', '3', '2009-06-21', '2009-07-01', '2', '2', '3', '35.89', '1.79', '0', '0', '0', '37.68', '1.3932', '1', '4', '2', '0');
542 INSERT INTO `0_debtor_trans` VALUES ('19', '10', '0', '2', '2', '2009-06-21', '2009-06-22', '3', '1', '5', '50', '0', '5', '0', '0', '0', '1', '1', '5', '0', '0');
545 ### Structure of table `0_debtor_trans_details` ###
547 DROP TABLE IF EXISTS `0_debtor_trans_details`;
549 CREATE TABLE `0_debtor_trans_details` (
550 `id` int(11) NOT NULL auto_increment,
551 `debtor_trans_no` int(11) default NULL,
552 `debtor_trans_type` int(11) default NULL,
553 `stock_id` varchar(20) NOT NULL default '',
554 `description` tinytext,
555 `unit_price` double NOT NULL default '0',
556 `unit_tax` double NOT NULL default '0',
557 `quantity` double NOT NULL default '0',
558 `discount_percent` double NOT NULL default '0',
559 `standard_cost` double NOT NULL default '0',
560 `qty_done` double NOT NULL default '0',
562 ) TYPE=InnoDB AUTO_INCREMENT=9 ;
565 ### Data of table `0_debtor_trans_details` ###
567 INSERT INTO `0_debtor_trans_details` VALUES ('1', '2', '13', '102', '17inch VGA Monitor', '30.4', '0', '2', '0', '10', '0');
568 INSERT INTO `0_debtor_trans_details` VALUES ('2', '3', '13', '102', '17inch VGA Monitor', '50', '2.5', '1', '0', '10', '1');
569 INSERT INTO `0_debtor_trans_details` VALUES ('3', '17', '10', '102', '17inch VGA Monitor', '50', '2.5', '1', '0', '10', '0');
570 INSERT INTO `0_debtor_trans_details` VALUES ('4', '4', '13', '102', '17inch VGA Monitor', '35.89', '1.79', '1', '0', '10', '1');
571 INSERT INTO `0_debtor_trans_details` VALUES ('5', '18', '10', '102', '17inch VGA Monitor', '35.89', '1.79', '1', '0', '10', '1');
572 INSERT INTO `0_debtor_trans_details` VALUES ('6', '5', '13', '102', '17inch VGA Monitor', '50', '2.38', '1', '0', '10', '1');
573 INSERT INTO `0_debtor_trans_details` VALUES ('7', '19', '10', '102', '17inch VGA Monitor', '50', '2.38', '1', '0', '10', '0');
574 INSERT INTO `0_debtor_trans_details` VALUES ('8', '3', '11', '102', '17inch VGA Monitor', '35.89', '1.79', '1', '0', '10', '0');
577 ### Structure of table `0_debtors_master` ###
579 DROP TABLE IF EXISTS `0_debtors_master`;
581 CREATE TABLE `0_debtors_master` (
582 `debtor_no` int(11) NOT NULL auto_increment,
583 `name` varchar(60) NOT NULL default '',
585 `email` varchar(100) NOT NULL default '',
586 `tax_id` varchar(55) NOT NULL default '',
587 `curr_code` char(3) NOT NULL default '',
588 `sales_type` int(11) NOT NULL default '1',
589 `dimension_id` int(11) NOT NULL default '0',
590 `dimension2_id` int(11) NOT NULL default '0',
591 `credit_status` int(11) NOT NULL default '0',
592 `payment_terms` int(11) default NULL,
593 `discount` double NOT NULL default '0',
594 `pymt_discount` double NOT NULL default '0',
595 `credit_limit` float NOT NULL default '1000',
596 `inactive` tinyint(1) NOT NULL default '0',
597 PRIMARY KEY (`debtor_no`),
598 UNIQUE KEY `name` (`name`)
599 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
602 ### Data of table `0_debtors_master` ###
604 INSERT INTO `0_debtors_master` VALUES ('1', 'Beefeater Ltd.', 'Addr 1\r\nAddr 2\r\nAddr 3', '', '345678', 'GBP', '2', '0', '0', '1', '3', '0', '0', '1000', '0');
605 INSERT INTO `0_debtors_master` VALUES ('2', 'Ghostbusters Corp.', 'Address 1\r\nAddress 2\r\nAddress 3', '', '2222222', 'USD', '1', '0', '0', '1', '4', '0', '0', '1000', '0');
606 INSERT INTO `0_debtors_master` VALUES ('3', 'Brezan', 'Address 1\r\nAddress 2\r\nAddress 3', '', '7777777', 'EUR', '2', '0', '0', '1', '3', '0', '0', '1000', '0');
609 ### Structure of table `0_dimensions` ###
611 DROP TABLE IF EXISTS `0_dimensions`;
613 CREATE TABLE `0_dimensions` (
614 `id` int(11) NOT NULL auto_increment,
615 `reference` varchar(60) NOT NULL default '',
616 `name` varchar(60) NOT NULL default '',
617 `type_` tinyint(1) NOT NULL default '1',
618 `closed` tinyint(1) NOT NULL default '0',
619 `date_` date NOT NULL default '0000-00-00',
620 `due_date` date NOT NULL default '0000-00-00',
622 UNIQUE KEY `reference` (`reference`)
623 ) TYPE=InnoDB AUTO_INCREMENT=3 ;
626 ### Data of table `0_dimensions` ###
628 INSERT INTO `0_dimensions` VALUES ('1', '1', 'Support', '1', '0', '2009-06-21', '2015-07-11');
629 INSERT INTO `0_dimensions` VALUES ('2', '2', 'Development', '1', '0', '2009-06-21', '2015-07-11');
632 ### Structure of table `0_exchange_rates` ###
634 DROP TABLE IF EXISTS `0_exchange_rates`;
636 CREATE TABLE `0_exchange_rates` (
637 `id` int(11) NOT NULL auto_increment,
638 `curr_code` char(3) NOT NULL default '',
639 `rate_buy` double NOT NULL default '0',
640 `rate_sell` double NOT NULL default '0',
641 `date_` date NOT NULL default '0000-00-00',
643 UNIQUE KEY `curr_code` (`curr_code`,`date_`)
644 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
647 ### Data of table `0_exchange_rates` ###
649 INSERT INTO `0_exchange_rates` VALUES ('1', 'DKK', '0.18717252868313', '0.18717252868313', '2009-06-21');
650 INSERT INTO `0_exchange_rates` VALUES ('2', 'GBP', '1.6445729799917', '1.6445729799917', '2009-06-21');
651 INSERT INTO `0_exchange_rates` VALUES ('3', 'EUR', '1.3932', '1.3932', '2009-06-21');
654 ### Structure of table `0_fiscal_year` ###
656 DROP TABLE IF EXISTS `0_fiscal_year`;
658 CREATE TABLE `0_fiscal_year` (
659 `id` int(11) NOT NULL auto_increment,
660 `begin` date default '0000-00-00',
661 `end` date default '0000-00-00',
662 `closed` tinyint(1) NOT NULL default '0',
664 ) TYPE=InnoDB AUTO_INCREMENT=3 ;
667 ### Data of table `0_fiscal_year` ###
669 INSERT INTO `0_fiscal_year` VALUES ('1', '2008-01-01', '2008-12-31', '0');
670 INSERT INTO `0_fiscal_year` VALUES ('2', '2009-01-01', '2009-12-31', '0');
673 ### Structure of table `0_gl_trans` ###
675 DROP TABLE IF EXISTS `0_gl_trans`;
677 CREATE TABLE `0_gl_trans` (
678 `counter` int(11) NOT NULL auto_increment,
679 `type` smallint(6) NOT NULL default '0',
680 `type_no` bigint(16) NOT NULL default '1',
681 `tran_date` date NOT NULL default '0000-00-00',
682 `account` varchar(11) NOT NULL default '',
683 `memo_` tinytext NOT NULL,
684 `amount` double NOT NULL default '0',
685 `dimension_id` int(11) NOT NULL default '0',
686 `dimension2_id` int(11) NOT NULL default '0',
687 `person_type_id` int(11) default NULL,
688 `person_id` tinyblob,
689 PRIMARY KEY (`counter`),
690 KEY `Type_and_Number` (`type`,`type_no`)
691 ) TYPE=InnoDB AUTO_INCREMENT=84 ;
694 ### Data of table `0_gl_trans` ###
696 INSERT INTO `0_gl_trans` VALUES ('1', '20', '7', '2009-06-21', '2100', '', '-3465', '0', '0', '3', '2');
697 INSERT INTO `0_gl_trans` VALUES ('2', '20', '7', '2009-06-21', '1510', '', '1000', '0', '0', '3', '2');
698 INSERT INTO `0_gl_trans` VALUES ('3', '20', '7', '2009-06-21', '1510', '', '1100', '0', '0', '3', '2');
699 INSERT INTO `0_gl_trans` VALUES ('4', '20', '7', '2009-06-21', '1510', '', '1200', '0', '0', '3', '2');
700 INSERT INTO `0_gl_trans` VALUES ('5', '20', '7', '2009-06-21', '2150', '', '165', '0', '0', '3', '2');
701 INSERT INTO `0_gl_trans` VALUES ('6', '22', '4', '2009-06-21', '2100', '', '3465', '0', '0', '3', '2');
702 INSERT INTO `0_gl_trans` VALUES ('7', '22', '4', '2009-06-21', '1060', '', '-3465', '0', '0', '3', '2');
703 INSERT INTO `0_gl_trans` VALUES ('8', '26', '1', '2009-06-21', '1510', '', '-100', '0', '0', '', '');
704 INSERT INTO `0_gl_trans` VALUES ('9', '26', '1', '2009-06-21', '1510', '', '-110', '0', '0', '', '');
705 INSERT INTO `0_gl_trans` VALUES ('10', '26', '1', '2009-06-21', '1510', '', '-120', '0', '0', '', '');
706 INSERT INTO `0_gl_trans` VALUES ('11', '26', '1', '2009-06-21', '1060', 'Overhead Cost', '-10', '0', '0', '1', '1');
707 INSERT INTO `0_gl_trans` VALUES ('12', '26', '1', '2009-06-21', '1530', 'Overhead Cost', '10', '0', '0', '1', '1');
708 INSERT INTO `0_gl_trans` VALUES ('13', '26', '1', '2009-06-21', '1060', 'Labour Cost', '-20', '0', '0', '1', '0');
709 INSERT INTO `0_gl_trans` VALUES ('14', '26', '1', '2009-06-21', '1530', 'Labour Cost', '20', '0', '0', '1', '0');
710 INSERT INTO `0_gl_trans` VALUES ('15', '26', '1', '2009-06-21', '1510', '', '330', '0', '0', '', '');
711 INSERT INTO `0_gl_trans` VALUES ('16', '13', '2', '2009-06-21', '5010', '', '20', '0', '0', '2', '1');
712 INSERT INTO `0_gl_trans` VALUES ('17', '13', '2', '2009-06-21', '1510', '', '-20', '0', '0', '2', '1');
713 INSERT INTO `0_gl_trans` VALUES ('18', '13', '3', '2009-06-21', '5010', '', '10', '0', '0', '2', '2');
714 INSERT INTO `0_gl_trans` VALUES ('19', '13', '3', '2009-06-21', '1510', '', '-10', '0', '0', '2', '2');
715 INSERT INTO `0_gl_trans` VALUES ('20', '10', '17', '2009-06-21', '4010', '', '-50', '0', '0', '2', '2');
716 INSERT INTO `0_gl_trans` VALUES ('21', '10', '17', '2009-06-21', '1200', '', '52.5', '0', '0', '2', '2');
717 INSERT INTO `0_gl_trans` VALUES ('22', '10', '17', '2009-06-21', '2150', '', '-2.5', '0', '0', '2', '2');
718 INSERT INTO `0_gl_trans` VALUES ('23', '13', '4', '2009-06-21', '5010', '', '10', '2', '0', '2', '3');
719 INSERT INTO `0_gl_trans` VALUES ('24', '13', '4', '2009-06-21', '1510', '', '-10', '0', '0', '2', '3');
720 INSERT INTO `0_gl_trans` VALUES ('25', '10', '18', '2009-06-21', '4010', '', '-50', '2', '0', '2', '3');
721 INSERT INTO `0_gl_trans` VALUES ('26', '10', '18', '2009-06-21', '1200', '', '52.5', '0', '0', '2', '3');
722 INSERT INTO `0_gl_trans` VALUES ('27', '10', '18', '2009-06-21', '2150', '', '-2.5', '0', '0', '2', '3');
723 INSERT INTO `0_gl_trans` VALUES ('28', '0', '18', '2009-02-20', '1060', '', '1000', '0', '0', '', '');
724 INSERT INTO `0_gl_trans` VALUES ('29', '0', '18', '2009-02-20', '3350', '', '-1000', '0', '0', '', '');
725 INSERT INTO `0_gl_trans` VALUES ('30', '0', '19', '2009-02-21', '1060', '', '4000', '0', '0', '', '');
726 INSERT INTO `0_gl_trans` VALUES ('31', '0', '19', '2009-02-21', '3350', '', '-4000', '0', '0', '', '');
727 INSERT INTO `0_gl_trans` VALUES ('32', '26', '3', '2009-06-21', '1510', '', '-20', '0', '0', '', '');
728 INSERT INTO `0_gl_trans` VALUES ('33', '26', '3', '2009-06-21', '1510', '', '-22', '0', '0', '', '');
729 INSERT INTO `0_gl_trans` VALUES ('34', '26', '3', '2009-06-21', '1510', '', '-24', '0', '0', '', '');
730 INSERT INTO `0_gl_trans` VALUES ('35', '26', '3', '2009-06-21', '1540', '', '66', '0', '0', '', '');
731 INSERT INTO `0_gl_trans` VALUES ('36', '2', '5', '2009-06-21', '2150', 'Cash Sales', '-4.76', '0', '0', '4', '3');
732 INSERT INTO `0_gl_trans` VALUES ('37', '2', '5', '2009-06-21', '4010', 'Cash Sales', '-95.24', '0', '0', '4', '3');
733 INSERT INTO `0_gl_trans` VALUES ('38', '2', '5', '2009-06-21', '1060', '', '100', '0', '0', '4', '3');
734 INSERT INTO `0_gl_trans` VALUES ('39', '1', '8', '2009-06-21', '2150', 'Maintenance', '2.38', '0', '0', '4', '1');
735 INSERT INTO `0_gl_trans` VALUES ('40', '1', '8', '2009-06-21', '5765', 'Maintenance', '47.62', '0', '0', '4', '1');
736 INSERT INTO `0_gl_trans` VALUES ('41', '1', '8', '2009-06-21', '1060', '', '-50', '0', '0', '4', '1');
737 INSERT INTO `0_gl_trans` VALUES ('42', '20', '8', '2009-06-21', '2100', '', '-20', '0', '0', '3', '2');
738 INSERT INTO `0_gl_trans` VALUES ('43', '20', '8', '2009-06-21', '2150', '', '0.95', '0', '0', '3', '2');
739 INSERT INTO `0_gl_trans` VALUES ('44', '20', '8', '2009-06-21', '5780', '', '19.05', '0', '0', '3', '2');
740 INSERT INTO `0_gl_trans` VALUES ('45', '26', '4', '2009-06-21', '1510', '', '-40', '0', '0', '', '');
741 INSERT INTO `0_gl_trans` VALUES ('46', '26', '4', '2009-06-21', '1510', '', '-44', '0', '0', '', '');
742 INSERT INTO `0_gl_trans` VALUES ('47', '26', '4', '2009-06-21', '1510', '', '-48', '0', '0', '', '');
743 INSERT INTO `0_gl_trans` VALUES ('48', '26', '4', '2009-06-21', '1540', '', '132', '0', '0', '', '');
744 INSERT INTO `0_gl_trans` VALUES ('49', '26', '2', '2009-06-21', '1510', '', '-20', '0', '0', '', '');
745 INSERT INTO `0_gl_trans` VALUES ('50', '26', '2', '2009-06-21', '1510', '', '-22', '0', '0', '', '');
746 INSERT INTO `0_gl_trans` VALUES ('51', '26', '2', '2009-06-21', '1510', '', '-24', '0', '0', '', '');
747 INSERT INTO `0_gl_trans` VALUES ('52', '26', '2', '2009-06-21', '1540', '', '66', '0', '0', '', '');
748 INSERT INTO `0_gl_trans` VALUES ('53', '26', '5', '2009-06-21', '1510', '', '-50', '0', '0', '', '');
749 INSERT INTO `0_gl_trans` VALUES ('54', '26', '5', '2009-06-21', '1510', '', '-55', '0', '0', '', '');
750 INSERT INTO `0_gl_trans` VALUES ('55', '26', '5', '2009-06-21', '1510', '', '-60', '0', '0', '', '');
751 INSERT INTO `0_gl_trans` VALUES ('56', '26', '5', '2009-06-21', '1060', 'Overhead Cost', '-10', '0', '0', '1', '1');
752 INSERT INTO `0_gl_trans` VALUES ('57', '26', '5', '2009-06-21', '1530', 'Overhead Cost', '10', '0', '0', '1', '1');
753 INSERT INTO `0_gl_trans` VALUES ('58', '26', '5', '2009-06-21', '1060', 'Labour Cost', '-20', '0', '0', '1', '0');
754 INSERT INTO `0_gl_trans` VALUES ('59', '26', '5', '2009-06-21', '1530', 'Labour Cost', '20', '0', '0', '1', '0');
755 INSERT INTO `0_gl_trans` VALUES ('60', '26', '5', '2009-06-21', '1540', '', '165', '0', '0', '', '');
756 INSERT INTO `0_gl_trans` VALUES ('61', '26', '6', '2009-06-21', '1510', '', '50', '0', '0', '', '');
757 INSERT INTO `0_gl_trans` VALUES ('62', '26', '6', '2009-06-21', '1510', '', '55', '0', '0', '', '');
758 INSERT INTO `0_gl_trans` VALUES ('63', '26', '6', '2009-06-21', '1510', '', '60', '0', '0', '', '');
759 INSERT INTO `0_gl_trans` VALUES ('64', '26', '6', '2009-06-21', '1540', '', '-165', '0', '0', '', '');
760 INSERT INTO `0_gl_trans` VALUES ('65', '26', '7', '2009-06-21', '1510', '', '20', '0', '0', '', '');
761 INSERT INTO `0_gl_trans` VALUES ('66', '26', '7', '2009-06-21', '1510', '', '22', '0', '0', '', '');
762 INSERT INTO `0_gl_trans` VALUES ('67', '26', '7', '2009-06-21', '1510', '', '24', '0', '0', '', '');
763 INSERT INTO `0_gl_trans` VALUES ('68', '26', '7', '2009-06-21', '1060', 'Overhead Cost', '-10', '0', '0', '1', '1');
764 INSERT INTO `0_gl_trans` VALUES ('69', '26', '7', '2009-06-21', '1530', 'Overhead Cost', '10', '0', '0', '1', '1');
765 INSERT INTO `0_gl_trans` VALUES ('70', '26', '7', '2009-06-21', '1060', 'Labour Cost', '-20', '0', '0', '1', '0');
766 INSERT INTO `0_gl_trans` VALUES ('71', '26', '7', '2009-06-21', '1530', 'Labour Cost', '20', '0', '0', '1', '0');
767 INSERT INTO `0_gl_trans` VALUES ('72', '26', '7', '2009-06-21', '1540', '', '-66', '0', '0', '', '');
768 INSERT INTO `0_gl_trans` VALUES ('73', '13', '5', '2009-06-21', '5010', '', '10', '0', '0', '2', '2');
769 INSERT INTO `0_gl_trans` VALUES ('74', '13', '5', '2009-06-21', '1510', '', '-10', '0', '0', '2', '2');
770 INSERT INTO `0_gl_trans` VALUES ('75', '10', '19', '2009-06-21', '4010', '', '-47.62', '0', '0', '2', '2');
771 INSERT INTO `0_gl_trans` VALUES ('76', '10', '19', '2009-06-21', '1200', '', '55', '0', '0', '2', '2');
772 INSERT INTO `0_gl_trans` VALUES ('77', '10', '19', '2009-06-21', '4430', '', '-5', '0', '0', '2', '2');
773 INSERT INTO `0_gl_trans` VALUES ('78', '10', '19', '2009-06-21', '2150', '', '-2.38', '0', '0', '2', '2');
774 INSERT INTO `0_gl_trans` VALUES ('79', '11', '3', '2009-06-21', '5010', '', '-10', '2', '0', '2', '3');
775 INSERT INTO `0_gl_trans` VALUES ('80', '11', '3', '2009-06-21', '1510', '', '10', '0', '0', '2', '3');
776 INSERT INTO `0_gl_trans` VALUES ('81', '11', '3', '2009-06-21', '4010', '', '50', '2', '0', '2', '3');
777 INSERT INTO `0_gl_trans` VALUES ('82', '11', '3', '2009-06-21', '1200', '', '-52.5', '0', '0', '2', '3');
778 INSERT INTO `0_gl_trans` VALUES ('83', '11', '3', '2009-06-21', '2150', '', '2.5', '0', '0', '2', '3');
781 ### Structure of table `0_grn_batch` ###
783 DROP TABLE IF EXISTS `0_grn_batch`;
785 CREATE TABLE `0_grn_batch` (
786 `id` int(11) NOT NULL auto_increment,
787 `supplier_id` int(11) NOT NULL default '0',
788 `purch_order_no` int(11) default NULL,
789 `reference` varchar(60) NOT NULL default '',
790 `delivery_date` date NOT NULL default '0000-00-00',
791 `loc_code` varchar(5) default NULL,
793 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
796 ### Data of table `0_grn_batch` ###
798 INSERT INTO `0_grn_batch` VALUES ('1', '2', '1', '1', '2009-06-21', 'DEF');
801 ### Structure of table `0_grn_items` ###
803 DROP TABLE IF EXISTS `0_grn_items`;
805 CREATE TABLE `0_grn_items` (
806 `id` int(11) NOT NULL auto_increment,
807 `grn_batch_id` int(11) default NULL,
808 `po_detail_item` int(11) NOT NULL default '0',
809 `item_code` varchar(20) NOT NULL default '',
810 `description` tinytext,
811 `qty_recd` double NOT NULL default '0',
812 `quantity_inv` double NOT NULL default '0',
814 ) TYPE=InnoDB AUTO_INCREMENT=4 ;
817 ### Data of table `0_grn_items` ###
819 INSERT INTO `0_grn_items` VALUES ('1', '1', '1', '102', '17inch VGA Monitor', '100', '100');
820 INSERT INTO `0_grn_items` VALUES ('2', '1', '2', '103', '32MB VGA Card', '100', '100');
821 INSERT INTO `0_grn_items` VALUES ('3', '1', '3', '104', '52x CD Drive', '100', '100');
824 ### Structure of table `0_groups` ###
826 DROP TABLE IF EXISTS `0_groups`;
828 CREATE TABLE `0_groups` (
829 `id` smallint(6) unsigned NOT NULL auto_increment,
830 `description` varchar(60) NOT NULL default '',
831 `inactive` tinyint(1) NOT NULL default '0',
833 UNIQUE KEY `description` (`description`)
834 ) TYPE=MyISAM AUTO_INCREMENT=4 AUTO_INCREMENT=4 ;
837 ### Data of table `0_groups` ###
839 INSERT INTO `0_groups` VALUES ('1', 'Small', '0');
840 INSERT INTO `0_groups` VALUES ('2', 'Medium', '0');
841 INSERT INTO `0_groups` VALUES ('3', 'Large', '0');
844 ### Structure of table `0_item_codes` ###
846 DROP TABLE IF EXISTS `0_item_codes`;
848 CREATE TABLE `0_item_codes` (
849 `id` int(11) unsigned NOT NULL auto_increment,
850 `item_code` varchar(20) NOT NULL,
851 `stock_id` varchar(20) NOT NULL,
852 `description` varchar(200) NOT NULL default '',
853 `category_id` smallint(6) unsigned NOT NULL,
854 `quantity` double NOT NULL default '1',
855 `is_foreign` tinyint(1) NOT NULL default '0',
856 `inactive` tinyint(1) NOT NULL default '0',
858 UNIQUE KEY `stock_id` (`stock_id`,`item_code`)
859 ) TYPE=MyISAM AUTO_INCREMENT=6 ;
862 ### Data of table `0_item_codes` ###
864 INSERT INTO `0_item_codes` VALUES ('1', '102', '102', '17inch VGA Monitor', '1', '1', '0', '0');
865 INSERT INTO `0_item_codes` VALUES ('2', '103', '103', '32MB VGA Card', '1', '1', '0', '0');
866 INSERT INTO `0_item_codes` VALUES ('3', '104', '104', '52x CD Drive', '1', '1', '0', '0');
867 INSERT INTO `0_item_codes` VALUES ('4', '3400', '3400', 'P4 Business System', '3', '1', '0', '0');
868 INSERT INTO `0_item_codes` VALUES ('5', '201', '201', 'Assembly Labour', '4', '1', '0', '0');
871 ### Structure of table `0_item_tax_type_exemptions` ###
873 DROP TABLE IF EXISTS `0_item_tax_type_exemptions`;
875 CREATE TABLE `0_item_tax_type_exemptions` (
876 `item_tax_type_id` int(11) NOT NULL default '0',
877 `tax_type_id` int(11) NOT NULL default '0',
878 PRIMARY KEY (`item_tax_type_id`,`tax_type_id`)
882 ### Data of table `0_item_tax_type_exemptions` ###
886 ### Structure of table `0_item_tax_types` ###
888 DROP TABLE IF EXISTS `0_item_tax_types`;
890 CREATE TABLE `0_item_tax_types` (
891 `id` int(11) NOT NULL auto_increment,
892 `name` varchar(60) NOT NULL default '',
893 `exempt` tinyint(1) NOT NULL default '0',
895 UNIQUE KEY `name` (`name`)
896 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
899 ### Data of table `0_item_tax_types` ###
901 INSERT INTO `0_item_tax_types` VALUES ('1', 'Regular', '0');
904 ### Structure of table `0_item_units` ###
906 DROP TABLE IF EXISTS `0_item_units`;
908 CREATE TABLE `0_item_units` (
909 `abbr` varchar(20) NOT NULL,
910 `name` varchar(40) NOT NULL,
911 `decimals` tinyint(2) NOT NULL,
912 `inactive` tinyint(1) NOT NULL default '0',
913 PRIMARY KEY (`abbr`),
914 UNIQUE KEY `name` (`name`)
918 ### Data of table `0_item_units` ###
920 INSERT INTO `0_item_units` VALUES ('ea.', 'Each', '0', '0');
921 INSERT INTO `0_item_units` VALUES ('hrs', 'Hours', '1', '0');
924 ### Structure of table `0_loc_stock` ###
926 DROP TABLE IF EXISTS `0_loc_stock`;
928 CREATE TABLE `0_loc_stock` (
929 `loc_code` char(5) NOT NULL default '',
930 `stock_id` char(20) NOT NULL default '',
931 `reorder_level` bigint(20) NOT NULL default '0',
932 PRIMARY KEY (`loc_code`,`stock_id`),
933 KEY `stock_id` (`stock_id`)
937 ### Data of table `0_loc_stock` ###
939 INSERT INTO `0_loc_stock` VALUES ('DEF', '102', '0');
940 INSERT INTO `0_loc_stock` VALUES ('DEF', '103', '0');
941 INSERT INTO `0_loc_stock` VALUES ('DEF', '104', '0');
942 INSERT INTO `0_loc_stock` VALUES ('DEF', '201', '0');
943 INSERT INTO `0_loc_stock` VALUES ('DEF', '3400', '0');
946 ### Structure of table `0_locations` ###
948 DROP TABLE IF EXISTS `0_locations`;
950 CREATE TABLE `0_locations` (
951 `loc_code` varchar(5) NOT NULL default '',
952 `location_name` varchar(60) NOT NULL default '',
953 `delivery_address` tinytext NOT NULL,
954 `phone` varchar(30) NOT NULL default '',
955 `fax` varchar(30) NOT NULL default '',
956 `email` varchar(100) NOT NULL default '',
957 `contact` varchar(30) NOT NULL default '',
958 `inactive` tinyint(1) NOT NULL default '0',
959 PRIMARY KEY (`loc_code`)
963 ### Data of table `0_locations` ###
965 INSERT INTO `0_locations` VALUES ('DEF', 'Default', 'Delivery 1\r\nDelivery 2\r\nDelivery 3', '', '', '', '', '0');
968 ### Structure of table `0_movement_types` ###
970 DROP TABLE IF EXISTS `0_movement_types`;
972 CREATE TABLE `0_movement_types` (
973 `id` int(11) NOT NULL auto_increment,
974 `name` varchar(60) NOT NULL default '',
976 UNIQUE KEY `name` (`name`)
977 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
980 ### Data of table `0_movement_types` ###
982 INSERT INTO `0_movement_types` VALUES ('1', 'Adjustment');
985 ### Structure of table `0_payment_terms` ###
987 DROP TABLE IF EXISTS `0_payment_terms`;
989 CREATE TABLE `0_payment_terms` (
990 `terms_indicator` int(11) NOT NULL auto_increment,
991 `terms` char(80) NOT NULL default '',
992 `days_before_due` smallint(6) NOT NULL default '0',
993 `day_in_following_month` smallint(6) NOT NULL default '0',
994 `inactive` tinyint(1) NOT NULL default '0',
995 PRIMARY KEY (`terms_indicator`),
996 UNIQUE KEY `terms` (`terms`)
997 ) TYPE=MyISAM AUTO_INCREMENT=5 ;
1000 ### Data of table `0_payment_terms` ###
1002 INSERT INTO `0_payment_terms` VALUES ('1', 'Due 15th Of the Following Month', '0', '17', '0');
1003 INSERT INTO `0_payment_terms` VALUES ('2', 'Due By End Of The Following Month', '0', '30', '0');
1004 INSERT INTO `0_payment_terms` VALUES ('3', 'Payment due within 10 days', '10', '0', '0');
1005 INSERT INTO `0_payment_terms` VALUES ('4', 'Cash Only', '1', '0', '0');
1008 ### Structure of table `0_prices` ###
1010 DROP TABLE IF EXISTS `0_prices`;
1012 CREATE TABLE `0_prices` (
1013 `id` int(11) NOT NULL auto_increment,
1014 `stock_id` varchar(20) NOT NULL default '',
1015 `sales_type_id` int(11) NOT NULL default '0',
1016 `curr_abrev` char(3) NOT NULL default '',
1017 `price` double NOT NULL default '0',
1019 UNIQUE KEY `price` (`stock_id`,`sales_type_id`,`curr_abrev`)
1020 ) TYPE=MyISAM AUTO_INCREMENT=5 ;
1023 ### Data of table `0_prices` ###
1025 INSERT INTO `0_prices` VALUES ('1', '3400', '1', 'USD', '100');
1026 INSERT INTO `0_prices` VALUES ('2', '102', '1', 'USD', '50');
1027 INSERT INTO `0_prices` VALUES ('3', '103', '1', 'USD', '55');
1028 INSERT INTO `0_prices` VALUES ('4', '104', '1', 'USD', '60');
1031 ### Structure of table `0_print_profiles` ###
1033 DROP TABLE IF EXISTS `0_print_profiles`;
1035 CREATE TABLE `0_print_profiles` (
1036 `id` smallint(6) unsigned NOT NULL auto_increment,
1037 `profile` varchar(30) NOT NULL,
1038 `report` varchar(5) default NULL,
1039 `printer` tinyint(3) unsigned default NULL,
1041 UNIQUE KEY `profile` (`profile`,`report`)
1042 ) TYPE=MyISAM AUTO_INCREMENT=10 ;
1045 ### Data of table `0_print_profiles` ###
1047 INSERT INTO `0_print_profiles` VALUES ('1', 'Out of office', '', '0');
1048 INSERT INTO `0_print_profiles` VALUES ('2', 'Sales Department', '', '0');
1049 INSERT INTO `0_print_profiles` VALUES ('3', 'Central', '', '2');
1050 INSERT INTO `0_print_profiles` VALUES ('4', 'Sales Department', '104', '2');
1051 INSERT INTO `0_print_profiles` VALUES ('5', 'Sales Department', '105', '2');
1052 INSERT INTO `0_print_profiles` VALUES ('6', 'Sales Department', '107', '2');
1053 INSERT INTO `0_print_profiles` VALUES ('7', 'Sales Department', '109', '2');
1054 INSERT INTO `0_print_profiles` VALUES ('8', 'Sales Department', '110', '2');
1055 INSERT INTO `0_print_profiles` VALUES ('9', 'Sales Department', '201', '2');
1058 ### Structure of table `0_printers` ###
1060 DROP TABLE IF EXISTS `0_printers`;
1062 CREATE TABLE `0_printers` (
1063 `id` tinyint(3) unsigned NOT NULL auto_increment,
1064 `name` varchar(20) NOT NULL,
1065 `description` varchar(60) NOT NULL,
1066 `queue` varchar(20) NOT NULL,
1067 `host` varchar(40) NOT NULL,
1068 `port` smallint(11) unsigned NOT NULL,
1069 `timeout` tinyint(3) unsigned NOT NULL,
1071 UNIQUE KEY `name` (`name`)
1072 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
1075 ### Data of table `0_printers` ###
1077 INSERT INTO `0_printers` VALUES ('1', 'QL500', 'Label printer', 'QL500', 'server', '127', '20');
1078 INSERT INTO `0_printers` VALUES ('2', 'Samsung', 'Main network printer', 'scx4521F', 'server', '515', '5');
1079 INSERT INTO `0_printers` VALUES ('3', 'Local', 'Local print server at user IP', 'lp', '', '515', '10');
1082 ### Structure of table `0_purch_data` ###
1084 DROP TABLE IF EXISTS `0_purch_data`;
1086 CREATE TABLE `0_purch_data` (
1087 `supplier_id` int(11) NOT NULL default '0',
1088 `stock_id` char(20) NOT NULL default '',
1089 `price` double NOT NULL default '0',
1090 `suppliers_uom` char(50) NOT NULL default '',
1091 `conversion_factor` double NOT NULL default '1',
1092 `supplier_description` char(50) NOT NULL default '',
1093 PRIMARY KEY (`supplier_id`,`stock_id`)
1097 ### Data of table `0_purch_data` ###
1099 INSERT INTO `0_purch_data` VALUES ('2', '102', '10', '', '1', '17inch VGA Monitor');
1100 INSERT INTO `0_purch_data` VALUES ('2', '103', '11', '', '1', '32MB VGA Card');
1101 INSERT INTO `0_purch_data` VALUES ('2', '104', '12', '', '1', '52x CD Drive');
1104 ### Structure of table `0_purch_order_details` ###
1106 DROP TABLE IF EXISTS `0_purch_order_details`;
1108 CREATE TABLE `0_purch_order_details` (
1109 `po_detail_item` int(11) NOT NULL auto_increment,
1110 `order_no` int(11) NOT NULL default '0',
1111 `item_code` varchar(20) NOT NULL default '',
1112 `description` tinytext,
1113 `delivery_date` date NOT NULL default '0000-00-00',
1114 `qty_invoiced` double NOT NULL default '0',
1115 `unit_price` double NOT NULL default '0',
1116 `act_price` double NOT NULL default '0',
1117 `std_cost_unit` double NOT NULL default '0',
1118 `quantity_ordered` double NOT NULL default '0',
1119 `quantity_received` double NOT NULL default '0',
1120 PRIMARY KEY (`po_detail_item`)
1121 ) TYPE=InnoDB AUTO_INCREMENT=6 ;
1124 ### Data of table `0_purch_order_details` ###
1126 INSERT INTO `0_purch_order_details` VALUES ('1', '1', '102', '17inch VGA Monitor', '2009-07-01', '100', '10', '10', '10', '100', '100');
1127 INSERT INTO `0_purch_order_details` VALUES ('2', '1', '103', '32MB VGA Card', '2009-07-01', '100', '11', '11', '11', '100', '100');
1128 INSERT INTO `0_purch_order_details` VALUES ('3', '1', '104', '52x CD Drive', '2009-07-01', '100', '12', '12', '12', '100', '100');
1129 INSERT INTO `0_purch_order_details` VALUES ('4', '2', '102', '17inch VGA Monitor', '2009-07-01', '0', '5', '0', '0', '1', '0');
1130 INSERT INTO `0_purch_order_details` VALUES ('5', '2', '103', '32MB VGA Card', '2009-07-01', '0', '5', '0', '0', '1', '0');
1133 ### Structure of table `0_purch_orders` ###
1135 DROP TABLE IF EXISTS `0_purch_orders`;
1137 CREATE TABLE `0_purch_orders` (
1138 `order_no` int(11) NOT NULL auto_increment,
1139 `supplier_id` int(11) NOT NULL default '0',
1140 `comments` tinytext,
1141 `ord_date` date NOT NULL default '0000-00-00',
1142 `reference` tinytext NOT NULL,
1143 `requisition_no` tinytext,
1144 `into_stock_location` varchar(5) NOT NULL default '',
1145 `delivery_address` tinytext NOT NULL,
1146 PRIMARY KEY (`order_no`)
1147 ) TYPE=InnoDB AUTO_INCREMENT=3 ;
1150 ### Data of table `0_purch_orders` ###
1152 INSERT INTO `0_purch_orders` VALUES ('1', '2', '', '2009-06-01', '1', '', 'DEF', 'Delivery 1\r\nDelivery 2\r\nDelivery 3');
1153 INSERT INTO `0_purch_orders` VALUES ('2', '3', '', '2009-06-21', '2', '', 'DEF', 'Delivery 1\r\nDelivery 2\r\nDelivery 3');
1156 ### Structure of table `0_quick_entries` ###
1158 DROP TABLE IF EXISTS `0_quick_entries`;
1160 CREATE TABLE `0_quick_entries` (
1161 `id` smallint(6) unsigned NOT NULL auto_increment,
1162 `type` tinyint(1) NOT NULL default '0',
1163 `description` varchar(60) NOT NULL,
1164 `base_amount` double NOT NULL default '0',
1165 `base_desc` varchar(60) default NULL,
1167 KEY `description` (`description`)
1168 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
1171 ### Data of table `0_quick_entries` ###
1173 INSERT INTO `0_quick_entries` VALUES ('1', '1', 'Maintenance', '0', 'Amount');
1174 INSERT INTO `0_quick_entries` VALUES ('2', '4', 'Phone', '0', 'Amount');
1175 INSERT INTO `0_quick_entries` VALUES ('3', '2', 'Cash Sales', '0', 'Amount');
1178 ### Structure of table `0_quick_entry_lines` ###
1180 DROP TABLE IF EXISTS `0_quick_entry_lines`;
1182 CREATE TABLE `0_quick_entry_lines` (
1183 `id` smallint(6) unsigned NOT NULL auto_increment,
1184 `qid` smallint(6) unsigned NOT NULL,
1185 `amount` double default '0',
1186 `action` varchar(2) NOT NULL,
1187 `dest_id` varchar(11) NOT NULL,
1188 `dimension_id` smallint(6) unsigned default NULL,
1189 `dimension2_id` smallint(6) unsigned default NULL,
1192 ) TYPE=MyISAM AUTO_INCREMENT=8 ;
1195 ### Data of table `0_quick_entry_lines` ###
1197 INSERT INTO `0_quick_entry_lines` VALUES ('1', '1', '0', 't-', '1', '0', '0');
1198 INSERT INTO `0_quick_entry_lines` VALUES ('2', '2', '0', 't-', '1', '0', '0');
1199 INSERT INTO `0_quick_entry_lines` VALUES ('3', '3', '0', 't-', '1', '0', '0');
1200 INSERT INTO `0_quick_entry_lines` VALUES ('4', '3', '0', '=', '4010', '0', '0');
1201 INSERT INTO `0_quick_entry_lines` VALUES ('5', '1', '0', '=', '5765', '0', '0');
1202 INSERT INTO `0_quick_entry_lines` VALUES ('6', '2', '0', '=', '5780', '0', '0');
1205 ### Structure of table `0_recurrent_invoices` ###
1207 DROP TABLE IF EXISTS `0_recurrent_invoices`;
1209 CREATE TABLE `0_recurrent_invoices` (
1210 `id` smallint(6) unsigned NOT NULL auto_increment,
1211 `description` varchar(60) NOT NULL default '',
1212 `order_no` int(11) unsigned NOT NULL,
1213 `debtor_no` int(11) unsigned default NULL,
1214 `group_no` smallint(6) unsigned default NULL,
1215 `days` int(11) NOT NULL default '0',
1216 `monthly` int(11) NOT NULL default '0',
1217 `begin` date NOT NULL default '0000-00-00',
1218 `end` date NOT NULL default '0000-00-00',
1219 `last_sent` date NOT NULL default '0000-00-00',
1221 UNIQUE KEY `description` (`description`)
1222 ) TYPE=InnoDB AUTO_INCREMENT=1 ;
1225 ### Data of table `0_recurrent_invoices` ###
1229 ### Structure of table `0_refs` ###
1231 DROP TABLE IF EXISTS `0_refs`;
1233 CREATE TABLE `0_refs` (
1234 `id` int(11) NOT NULL default '0',
1235 `type` int(11) NOT NULL default '0',
1236 `reference` varchar(100) NOT NULL default '',
1237 PRIMARY KEY (`id`,`type`)
1241 ### Data of table `0_refs` ###
1243 INSERT INTO `0_refs` VALUES ('18', '0', '1');
1244 INSERT INTO `0_refs` VALUES ('19', '0', '2');
1247 ### Structure of table `0_sales_order_details` ###
1249 DROP TABLE IF EXISTS `0_sales_order_details`;
1251 CREATE TABLE `0_sales_order_details` (
1252 `id` int(11) NOT NULL auto_increment,
1253 `order_no` int(11) NOT NULL default '0',
1254 `stk_code` varchar(20) NOT NULL default '',
1255 `description` tinytext,
1256 `qty_sent` double NOT NULL default '0',
1257 `unit_price` double NOT NULL default '0',
1258 `quantity` double NOT NULL default '0',
1259 `discount_percent` double NOT NULL default '0',
1261 ) TYPE=InnoDB AUTO_INCREMENT=6 ;
1264 ### Data of table `0_sales_order_details` ###
1266 INSERT INTO `0_sales_order_details` VALUES ('1', '1', '102', '17inch VGA Monitor', '2', '30.4', '2', '0');
1267 INSERT INTO `0_sales_order_details` VALUES ('2', '2', '102', '17inch VGA Monitor', '1', '50', '1', '0');
1268 INSERT INTO `0_sales_order_details` VALUES ('3', '3', '102', '17inch VGA Monitor', '1', '35.89', '1', '0');
1269 INSERT INTO `0_sales_order_details` VALUES ('4', '4', '102', '17inch VGA Monitor', '0', '21.28', '2', '0');
1270 INSERT INTO `0_sales_order_details` VALUES ('5', '5', '102', '17inch VGA Monitor', '1', '50', '1', '0');
1273 ### Structure of table `0_sales_orders` ###
1275 DROP TABLE IF EXISTS `0_sales_orders`;
1277 CREATE TABLE `0_sales_orders` (
1278 `order_no` int(11) NOT NULL auto_increment,
1279 `version` tinyint(1) unsigned NOT NULL default '0',
1280 `type` tinyint(1) NOT NULL default '0',
1281 `debtor_no` int(11) NOT NULL default '0',
1282 `branch_code` int(11) NOT NULL default '0',
1283 `customer_ref` tinytext NOT NULL,
1284 `comments` tinytext,
1285 `ord_date` date NOT NULL default '0000-00-00',
1286 `order_type` int(11) NOT NULL default '0',
1287 `ship_via` int(11) NOT NULL default '0',
1288 `delivery_address` tinytext NOT NULL,
1289 `contact_phone` varchar(30) default NULL,
1290 `contact_email` varchar(100) default NULL,
1291 `deliver_to` tinytext NOT NULL,
1292 `freight_cost` double NOT NULL default '0',
1293 `from_stk_loc` varchar(5) NOT NULL default '',
1294 `delivery_date` date NOT NULL default '0000-00-00',
1295 PRIMARY KEY (`order_no`)
1296 ) TYPE=InnoDB AUTO_INCREMENT=6 ;
1299 ### Data of table `0_sales_orders` ###
1301 INSERT INTO `0_sales_orders` VALUES ('1', '1', '0', '1', '1', '', '', '2009-06-21', '2', '1', 'Address 1\r\nAddress 2\r\nAddress 3', '', '', 'Beefeater Ltd.', '10', 'DEF', '2009-06-22');
1302 INSERT INTO `0_sales_orders` VALUES ('2', '1', '0', '2', '2', '', '', '2009-06-21', '1', '1', 'Address 1\r\nAddress 2\r\nAddress 3', '', '', 'Ghostbusters Corp.', '0', 'DEF', '2009-06-22');
1303 INSERT INTO `0_sales_orders` VALUES ('3', '1', '0', '3', '3', '', '', '2009-06-21', '2', '1', 'Address 1\r\nAddress 2\r\nAddress 3', '', '', 'Brezan', '0', 'DEF', '2009-07-01');
1304 INSERT INTO `0_sales_orders` VALUES ('4', '0', '0', '1', '1', '', '', '2009-06-21', '2', '1', 'Address 1\r\nAddress 2\r\nAddress 3', '', '', 'Beefeater Ltd.', '0', 'DEF', '2009-06-22');
1305 INSERT INTO `0_sales_orders` VALUES ('5', '1', '0', '2', '2', '', '', '2009-06-21', '1', '1', 'Address 1\r\nAddress 2\r\nAddress 3', '', '', 'Ghostbusters Corp.', '5', 'DEF', '2009-06-22');
1308 ### Structure of table `0_sales_pos` ###
1310 DROP TABLE IF EXISTS `0_sales_pos`;
1312 CREATE TABLE `0_sales_pos` (
1313 `id` smallint(6) unsigned NOT NULL auto_increment,
1314 `pos_name` varchar(30) NOT NULL,
1315 `cash_sale` tinyint(1) NOT NULL,
1316 `credit_sale` tinyint(1) NOT NULL,
1317 `pos_location` varchar(5) NOT NULL,
1318 `pos_account` smallint(6) unsigned NOT NULL,
1319 `inactive` tinyint(1) NOT NULL default '0',
1321 UNIQUE KEY `pos_name` (`pos_name`)
1322 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
1325 ### Data of table `0_sales_pos` ###
1327 INSERT INTO `0_sales_pos` VALUES ('1', 'Default', '1', '1', 'DEF', '2', '0');
1330 ### Structure of table `0_sales_types` ###
1332 DROP TABLE IF EXISTS `0_sales_types`;
1334 CREATE TABLE `0_sales_types` (
1335 `id` int(11) NOT NULL auto_increment,
1336 `sales_type` char(50) NOT NULL default '',
1337 `tax_included` int(1) NOT NULL default '0',
1338 `factor` double NOT NULL default '1',
1339 `inactive` tinyint(1) NOT NULL default '0',
1341 UNIQUE KEY `sales_type` (`sales_type`)
1342 ) TYPE=MyISAM AUTO_INCREMENT=3 ;
1345 ### Data of table `0_sales_types` ###
1347 INSERT INTO `0_sales_types` VALUES ('1', 'Retail', '1', '1', '0');
1348 INSERT INTO `0_sales_types` VALUES ('2', 'Wholesale', '0', '0.7', '0');
1351 ### Structure of table `0_salesman` ###
1353 DROP TABLE IF EXISTS `0_salesman`;
1355 CREATE TABLE `0_salesman` (
1356 `salesman_code` int(11) NOT NULL auto_increment,
1357 `salesman_name` char(60) NOT NULL default '',
1358 `salesman_phone` char(30) NOT NULL default '',
1359 `salesman_fax` char(30) NOT NULL default '',
1360 `salesman_email` varchar(100) NOT NULL default '',
1361 `provision` double NOT NULL default '0',
1362 `break_pt` double NOT NULL default '0',
1363 `provision2` double NOT NULL default '0',
1364 `inactive` tinyint(1) NOT NULL default '0',
1365 PRIMARY KEY (`salesman_code`),
1366 UNIQUE KEY `salesman_name` (`salesman_name`)
1367 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
1370 ### Data of table `0_salesman` ###
1372 INSERT INTO `0_salesman` VALUES ('1', 'Sales Person', '', '', '', '5', '1000', '4', '0');
1375 ### Structure of table `0_shippers` ###
1377 DROP TABLE IF EXISTS `0_shippers`;
1379 CREATE TABLE `0_shippers` (
1380 `shipper_id` int(11) NOT NULL auto_increment,
1381 `shipper_name` varchar(60) NOT NULL default '',
1382 `phone` varchar(30) NOT NULL default '',
1383 `contact` tinytext NOT NULL,
1384 `address` tinytext NOT NULL,
1385 `inactive` tinyint(1) NOT NULL default '0',
1386 PRIMARY KEY (`shipper_id`),
1387 UNIQUE KEY `name` (`shipper_name`)
1388 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
1391 ### Data of table `0_shippers` ###
1393 INSERT INTO `0_shippers` VALUES ('1', 'Default', '', '', '', '0');
1396 ### Structure of table `0_sql_trail` ###
1398 DROP TABLE IF EXISTS `0_sql_trail`;
1400 CREATE TABLE `0_sql_trail` (
1401 `id` int(11) unsigned NOT NULL auto_increment,
1402 `sql` text NOT NULL,
1403 `result` tinyint(1) NOT NULL,
1404 `msg` varchar(255) NOT NULL,
1406 ) TYPE=MyISAM AUTO_INCREMENT=1 ;
1409 ### Data of table `0_sql_trail` ###
1413 ### Structure of table `0_stock_category` ###
1415 DROP TABLE IF EXISTS `0_stock_category`;
1417 CREATE TABLE `0_stock_category` (
1418 `category_id` int(11) NOT NULL auto_increment,
1419 `description` varchar(60) NOT NULL default '',
1420 `stock_act` varchar(11) default NULL,
1421 `cogs_act` varchar(11) default NULL,
1422 `adj_gl_act` varchar(11) default NULL,
1423 `purch_price_var_act` varchar(11) default NULL,
1424 `inactive` tinyint(1) NOT NULL default '0',
1425 PRIMARY KEY (`category_id`),
1426 UNIQUE KEY `description` (`description`)
1427 ) TYPE=MyISAM AUTO_INCREMENT=5 ;
1430 ### Data of table `0_stock_category` ###
1432 INSERT INTO `0_stock_category` VALUES ('1', 'Components', '', '', '', '', '0');
1433 INSERT INTO `0_stock_category` VALUES ('2', 'Charges', '', '', '', '', '0');
1434 INSERT INTO `0_stock_category` VALUES ('3', 'Systems', '', '', '', '', '0');
1435 INSERT INTO `0_stock_category` VALUES ('4', 'Services', '', '', '', '', '0');
1438 ### Structure of table `0_stock_master` ###
1440 DROP TABLE IF EXISTS `0_stock_master`;
1442 CREATE TABLE `0_stock_master` (
1443 `stock_id` varchar(20) NOT NULL default '',
1444 `category_id` int(11) NOT NULL default '0',
1445 `tax_type_id` int(11) NOT NULL default '0',
1446 `description` varchar(200) NOT NULL default '',
1447 `long_description` tinytext NOT NULL,
1448 `units` varchar(20) NOT NULL default 'each',
1449 `mb_flag` char(1) NOT NULL default 'B',
1450 `sales_account` varchar(11) NOT NULL default '',
1451 `cogs_account` varchar(11) NOT NULL default '',
1452 `inventory_account` varchar(11) NOT NULL default '',
1453 `adjustment_account` varchar(11) NOT NULL default '',
1454 `assembly_account` varchar(11) NOT NULL default '',
1455 `dimension_id` int(11) default NULL,
1456 `dimension2_id` int(11) default NULL,
1457 `actual_cost` double NOT NULL default '0',
1458 `last_cost` double NOT NULL default '0',
1459 `material_cost` double NOT NULL default '0',
1460 `labour_cost` double NOT NULL default '0',
1461 `overhead_cost` double NOT NULL default '0',
1462 `inactive` tinyint(1) NOT NULL default '0',
1463 PRIMARY KEY (`stock_id`)
1467 ### Data of table `0_stock_master` ###
1469 INSERT INTO `0_stock_master` VALUES ('102', '1', '1', '17inch VGA Monitor', '', 'ea.', 'B', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0', '10', '0', '0', '0');
1470 INSERT INTO `0_stock_master` VALUES ('103', '1', '1', '32MB VGA Card', '', 'ea.', 'B', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0', '11', '0', '0', '0');
1471 INSERT INTO `0_stock_master` VALUES ('104', '1', '1', '52x CD Drive', '', 'ea.', 'B', '4010', '5010', '1510', '5040', '1530', '0', '0', '0', '0', '12', '0', '0', '0');
1472 INSERT INTO `0_stock_master` VALUES ('201', '4', '1', 'Assembly Labour', '', 'hrs', 'D', '4010', '5010', '5010', '5040', '1530', '0', '0', '0', '0', '0', '0', '0', '0');
1473 INSERT INTO `0_stock_master` VALUES ('3400', '3', '1', 'P4 Business System', '', 'ea.', 'M', '4010', '5010', '1540', '5040', '1530', '0', '0', '0', '0', '33', '3.9999999999999', '2', '0');
1476 ### Structure of table `0_stock_moves` ###
1478 DROP TABLE IF EXISTS `0_stock_moves`;
1480 CREATE TABLE `0_stock_moves` (
1481 `trans_id` int(11) NOT NULL auto_increment,
1482 `trans_no` int(11) NOT NULL default '0',
1483 `stock_id` char(20) NOT NULL default '',
1484 `type` smallint(6) NOT NULL default '0',
1485 `loc_code` char(5) NOT NULL default '',
1486 `tran_date` date NOT NULL default '0000-00-00',
1487 `person_id` int(11) default NULL,
1488 `price` double NOT NULL default '0',
1489 `reference` char(40) NOT NULL default '',
1490 `qty` double NOT NULL default '1',
1491 `discount_percent` double NOT NULL default '0',
1492 `standard_cost` double NOT NULL default '0',
1493 `visible` tinyint(1) NOT NULL default '1',
1494 PRIMARY KEY (`trans_id`),
1495 KEY `type` (`type`,`trans_no`)
1496 ) TYPE=InnoDB AUTO_INCREMENT=37 ;
1499 ### Data of table `0_stock_moves` ###
1501 INSERT INTO `0_stock_moves` VALUES ('1', '1', '102', '25', 'DEF', '2009-06-21', '2', '10', '', '100', '0', '10', '1');
1502 INSERT INTO `0_stock_moves` VALUES ('2', '1', '103', '25', 'DEF', '2009-06-21', '2', '11', '', '100', '0', '11', '1');
1503 INSERT INTO `0_stock_moves` VALUES ('3', '1', '104', '25', 'DEF', '2009-06-21', '2', '12', '', '100', '0', '12', '1');
1504 INSERT INTO `0_stock_moves` VALUES ('4', '1', '102', '26', 'DEF', '2009-06-21', '0', '0', '1', '-10', '0', '0', '1');
1505 INSERT INTO `0_stock_moves` VALUES ('5', '1', '103', '26', 'DEF', '2009-06-21', '0', '0', '1', '-10', '0', '0', '1');
1506 INSERT INTO `0_stock_moves` VALUES ('6', '1', '104', '26', 'DEF', '2009-06-21', '0', '0', '1', '-10', '0', '0', '1');
1507 INSERT INTO `0_stock_moves` VALUES ('7', '1', '3400', '26', 'DEF', '2009-06-21', '0', '0', '1', '10', '0', '0', '1');
1508 INSERT INTO `0_stock_moves` VALUES ('8', '2', '102', '13', 'DEF', '2009-06-21', '0', '30.4', '1', '-2', '0', '10', '1');
1509 INSERT INTO `0_stock_moves` VALUES ('9', '3', '102', '13', 'DEF', '2009-06-21', '0', '50', 'auto', '-1', '0', '10', '1');
1510 INSERT INTO `0_stock_moves` VALUES ('10', '4', '102', '13', 'DEF', '2009-06-21', '0', '35.89', 'auto', '-1', '0', '10', '1');
1511 INSERT INTO `0_stock_moves` VALUES ('11', '3', '102', '26', 'DEF', '2009-06-21', '0', '0', '3', '-2', '0', '0', '1');
1512 INSERT INTO `0_stock_moves` VALUES ('12', '3', '103', '26', 'DEF', '2009-06-21', '0', '0', '3', '-2', '0', '0', '1');
1513 INSERT INTO `0_stock_moves` VALUES ('13', '3', '104', '26', 'DEF', '2009-06-21', '0', '0', '3', '-2', '0', '0', '1');
1514 INSERT INTO `0_stock_moves` VALUES ('14', '3', '3400', '26', 'DEF', '2009-06-21', '0', '0', '3', '2', '0', '0', '1');
1515 INSERT INTO `0_stock_moves` VALUES ('15', '4', '102', '26', 'DEF', '2009-06-21', '0', '0', '4', '-4', '0', '0', '1');
1516 INSERT INTO `0_stock_moves` VALUES ('16', '4', '103', '26', 'DEF', '2009-06-21', '0', '0', '4', '-4', '0', '0', '1');
1517 INSERT INTO `0_stock_moves` VALUES ('17', '4', '104', '26', 'DEF', '2009-06-21', '0', '0', '4', '-4', '0', '0', '1');
1518 INSERT INTO `0_stock_moves` VALUES ('18', '4', '3400', '26', 'DEF', '2009-06-21', '0', '0', '4', '4', '0', '0', '1');
1519 INSERT INTO `0_stock_moves` VALUES ('19', '2', '102', '26', 'DEF', '2009-06-21', '0', '0', '', '-2', '0', '0', '1');
1520 INSERT INTO `0_stock_moves` VALUES ('20', '2', '103', '26', 'DEF', '2009-06-21', '0', '0', '', '-2', '0', '0', '1');
1521 INSERT INTO `0_stock_moves` VALUES ('21', '2', '104', '26', 'DEF', '2009-06-21', '0', '0', '', '-2', '0', '0', '1');
1522 INSERT INTO `0_stock_moves` VALUES ('22', '1', '3400', '29', 'DEF', '2009-06-21', '0', '0', '', '2', '0', '0', '1');
1523 INSERT INTO `0_stock_moves` VALUES ('23', '5', '102', '26', 'DEF', '2009-06-21', '0', '0', '5', '-5', '0', '0', '1');
1524 INSERT INTO `0_stock_moves` VALUES ('24', '5', '103', '26', 'DEF', '2009-06-21', '0', '0', '5', '-5', '0', '0', '1');
1525 INSERT INTO `0_stock_moves` VALUES ('25', '5', '104', '26', 'DEF', '2009-06-21', '0', '0', '5', '-5', '0', '0', '1');
1526 INSERT INTO `0_stock_moves` VALUES ('26', '5', '3400', '26', 'DEF', '2009-06-21', '0', '0', '5', '5', '0', '0', '1');
1527 INSERT INTO `0_stock_moves` VALUES ('27', '6', '102', '26', 'DEF', '2009-06-21', '0', '0', '6', '5', '0', '0', '1');
1528 INSERT INTO `0_stock_moves` VALUES ('28', '6', '103', '26', 'DEF', '2009-06-21', '0', '0', '6', '5', '0', '0', '1');
1529 INSERT INTO `0_stock_moves` VALUES ('29', '6', '104', '26', 'DEF', '2009-06-21', '0', '0', '6', '5', '0', '0', '1');
1530 INSERT INTO `0_stock_moves` VALUES ('30', '6', '3400', '26', 'DEF', '2009-06-21', '0', '0', '6', '-5', '0', '0', '1');
1531 INSERT INTO `0_stock_moves` VALUES ('31', '7', '102', '26', 'DEF', '2009-06-21', '0', '0', '7', '2', '0', '0', '1');
1532 INSERT INTO `0_stock_moves` VALUES ('32', '7', '103', '26', 'DEF', '2009-06-21', '0', '0', '7', '2', '0', '0', '1');
1533 INSERT INTO `0_stock_moves` VALUES ('33', '7', '104', '26', 'DEF', '2009-06-21', '0', '0', '7', '2', '0', '0', '1');
1534 INSERT INTO `0_stock_moves` VALUES ('34', '7', '3400', '26', 'DEF', '2009-06-21', '0', '0', '7', '-2', '0', '0', '1');
1535 INSERT INTO `0_stock_moves` VALUES ('35', '5', '102', '13', 'DEF', '2009-06-21', '0', '50', 'auto', '-1', '0', '10', '1');
1536 INSERT INTO `0_stock_moves` VALUES ('36', '3', '102', '11', 'DEF', '2009-06-21', '0', '37.68', 'Return Ex Inv: 18', '1', '0', '10', '0');
1539 ### Structure of table `0_supp_allocations` ###
1541 DROP TABLE IF EXISTS `0_supp_allocations`;
1543 CREATE TABLE `0_supp_allocations` (
1544 `id` int(11) NOT NULL auto_increment,
1545 `amt` double unsigned default NULL,
1546 `date_alloc` date NOT NULL default '0000-00-00',
1547 `trans_no_from` int(11) default NULL,
1548 `trans_type_from` int(11) default NULL,
1549 `trans_no_to` int(11) default NULL,
1550 `trans_type_to` int(11) default NULL,
1552 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
1555 ### Data of table `0_supp_allocations` ###
1557 INSERT INTO `0_supp_allocations` VALUES ('1', '3465', '2009-06-21', '4', '22', '7', '20');
1560 ### Structure of table `0_supp_invoice_items` ###
1562 DROP TABLE IF EXISTS `0_supp_invoice_items`;
1564 CREATE TABLE `0_supp_invoice_items` (
1565 `id` int(11) NOT NULL auto_increment,
1566 `supp_trans_no` int(11) default NULL,
1567 `supp_trans_type` int(11) default NULL,
1568 `gl_code` varchar(11) NOT NULL default '0',
1569 `grn_item_id` int(11) default NULL,
1570 `po_detail_item_id` int(11) default NULL,
1571 `stock_id` varchar(20) NOT NULL default '',
1572 `description` tinytext,
1573 `quantity` double NOT NULL default '0',
1574 `unit_price` double NOT NULL default '0',
1575 `unit_tax` double NOT NULL default '0',
1578 ) TYPE=InnoDB AUTO_INCREMENT=6 ;
1581 ### Data of table `0_supp_invoice_items` ###
1583 INSERT INTO `0_supp_invoice_items` VALUES ('1', '7', '20', '0', '1', '1', '102', '17inch VGA Monitor', '100', '10', '0.5', '');
1584 INSERT INTO `0_supp_invoice_items` VALUES ('2', '7', '20', '0', '2', '2', '103', '32MB VGA Card', '100', '11', '0.55', '');
1585 INSERT INTO `0_supp_invoice_items` VALUES ('3', '7', '20', '0', '3', '3', '104', '52x CD Drive', '100', '12', '0.6', '');
1586 INSERT INTO `0_supp_invoice_items` VALUES ('4', '8', '20', '2150', '0', '0', '', '', '0', '0.95', '0', 'Phone');
1587 INSERT INTO `0_supp_invoice_items` VALUES ('5', '8', '20', '5780', '0', '0', '', '', '0', '19.05', '0', 'Phone');
1590 ### Structure of table `0_supp_trans` ###
1592 DROP TABLE IF EXISTS `0_supp_trans`;
1594 CREATE TABLE `0_supp_trans` (
1595 `trans_no` int(11) unsigned NOT NULL default '0',
1596 `type` smallint(6) unsigned NOT NULL default '0',
1597 `supplier_id` int(11) unsigned default NULL,
1598 `reference` tinytext NOT NULL,
1599 `supp_reference` varchar(60) NOT NULL default '',
1600 `tran_date` date NOT NULL default '0000-00-00',
1601 `due_date` date NOT NULL default '0000-00-00',
1602 `ov_amount` double NOT NULL default '0',
1603 `ov_discount` double NOT NULL default '0',
1604 `ov_gst` double NOT NULL default '0',
1605 `rate` double NOT NULL default '1',
1606 `alloc` double NOT NULL default '0',
1607 PRIMARY KEY (`trans_no`,`type`),
1608 KEY `supplier_id` (`supplier_id`),
1609 KEY `SupplierID_2` (`supplier_id`,`supp_reference`),
1614 ### Data of table `0_supp_trans` ###
1616 INSERT INTO `0_supp_trans` VALUES ('4', '22', '2', '1', '', '2009-06-21', '2009-06-21', '-3465', '0', '0', '1', '3465');
1617 INSERT INTO `0_supp_trans` VALUES ('7', '20', '2', '1', '5t', '2009-06-21', '2009-07-01', '3300', '0', '165', '1', '3465');
1618 INSERT INTO `0_supp_trans` VALUES ('8', '20', '2', '2', 'cc', '2009-06-21', '2009-07-01', '20', '0', '0', '1', '0');
1621 ### Structure of table `0_suppliers` ###
1623 DROP TABLE IF EXISTS `0_suppliers`;
1625 CREATE TABLE `0_suppliers` (
1626 `supplier_id` int(11) NOT NULL auto_increment,
1627 `supp_name` varchar(60) NOT NULL default '',
1628 `address` tinytext NOT NULL,
1629 `supp_address` tinytext NOT NULL,
1630 `phone` varchar(30) NOT NULL default '',
1631 `fax` varchar(30) NOT NULL default '',
1632 `gst_no` varchar(25) NOT NULL default '',
1633 `contact` varchar(60) NOT NULL default '',
1634 `supp_account_no` varchar(40) NOT NULL default '',
1635 `email` varchar(100) NOT NULL default '',
1636 `website` varchar(100) NOT NULL default '',
1637 `bank_account` varchar(60) NOT NULL default '',
1638 `curr_code` char(3) default NULL,
1639 `payment_terms` int(11) default NULL,
1640 `dimension_id` int(11) default '0',
1641 `dimension2_id` int(11) default '0',
1642 `tax_group_id` int(11) default NULL,
1643 `credit_limit` double NOT NULL default '0',
1644 `purchase_account` varchar(11) default NULL,
1645 `payable_account` varchar(11) default NULL,
1646 `payment_discount_account` varchar(11) default NULL,
1647 `notes` tinytext NOT NULL,
1648 `inactive` tinyint(1) NOT NULL default '0',
1649 PRIMARY KEY (`supplier_id`)
1650 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
1653 ### Data of table `0_suppliers` ###
1655 INSERT INTO `0_suppliers` VALUES ('1', 'Junk Beer ApS', 'Mailing 1\r\nMailing 2\r\nMailing 3', 'Address 1\r\nAddress 2\r\nAddress 3', '+45 55667788', '', '123456', 'Contact', '111', '', '', '', 'DKK', '3', '1', '0', '2', '1', '5010', '2100', '5060', 'A supplier with junk beers.', '0');
1656 INSERT INTO `0_suppliers` VALUES ('2', 'Lucky Luke Inc.', 'Mailing 1\r\nMailing 2\r\nMailing 3', 'Address 1\r\nAddress 2\r\nAddress 3', '(111) 222.333.444', '', '654321', 'Luke', '333', '', '', '', 'USD', '3', '0', '0', '1', '1', '5010', '2100', '5060', '', '0');
1657 INSERT INTO `0_suppliers` VALUES ('3', 'Money Makers Ltd.', 'Mailing 1\r\nMailing 2\r\nMailing 3', 'Address 1\r\nAddress 2\r\nAddress 3', '+44 444 555 666', '', '987654', 'Makers', '222', '', '', '', 'GBP', '3', '0', '0', '2', '1', '5010', '2100', '5060', '', '0');
1660 ### Structure of table `0_sys_types` ###
1662 DROP TABLE IF EXISTS `0_sys_types`;
1664 CREATE TABLE `0_sys_types` (
1665 `type_id` smallint(6) NOT NULL default '0',
1666 `type_name` varchar(60) NOT NULL default '',
1667 `type_no` int(11) NOT NULL default '1',
1668 `next_reference` varchar(100) NOT NULL default '',
1669 PRIMARY KEY (`type_id`)
1673 ### Data of table `0_sys_types` ###
1675 INSERT INTO `0_sys_types` VALUES ('0', 'Journal - GL', '19', '3');
1676 INSERT INTO `0_sys_types` VALUES ('1', 'Payment - GL', '8', '2');
1677 INSERT INTO `0_sys_types` VALUES ('2', 'Receipt - GL', '5', '2');
1678 INSERT INTO `0_sys_types` VALUES ('4', 'Funds Transfer', '3', '1');
1679 INSERT INTO `0_sys_types` VALUES ('10', 'Sales Invoice', '19', '4');
1680 INSERT INTO `0_sys_types` VALUES ('11', 'Credit Note', '3', '2');
1681 INSERT INTO `0_sys_types` VALUES ('12', 'Receipt', '6', '1');
1682 INSERT INTO `0_sys_types` VALUES ('13', 'Delivery', '5', '2');
1683 INSERT INTO `0_sys_types` VALUES ('16', 'Location Transfer', '2', '1');
1684 INSERT INTO `0_sys_types` VALUES ('17', 'Inventory Adjustment', '2', '1');
1685 INSERT INTO `0_sys_types` VALUES ('18', 'Purchase Order', '1', '3');
1686 INSERT INTO `0_sys_types` VALUES ('20', 'Supplier Invoice', '8', '3');
1687 INSERT INTO `0_sys_types` VALUES ('21', 'Supplier Credit Note', '1', '1');
1688 INSERT INTO `0_sys_types` VALUES ('22', 'Supplier Payment', '4', '2');
1689 INSERT INTO `0_sys_types` VALUES ('25', 'Purchase Order Delivery', '1', '2');
1690 INSERT INTO `0_sys_types` VALUES ('26', 'Work Order', '1', '8');
1691 INSERT INTO `0_sys_types` VALUES ('28', 'Work Order Issue', '1', '1');
1692 INSERT INTO `0_sys_types` VALUES ('29', 'Work Order Production', '1', '2');
1693 INSERT INTO `0_sys_types` VALUES ('30', 'Sales Order', '1', '1');
1694 INSERT INTO `0_sys_types` VALUES ('35', 'Cost Update', '1', '1');
1695 INSERT INTO `0_sys_types` VALUES ('40', 'Dimension', '1', '3');
1698 ### Structure of table `0_tax_group_items` ###
1700 DROP TABLE IF EXISTS `0_tax_group_items`;
1702 CREATE TABLE `0_tax_group_items` (
1703 `tax_group_id` int(11) NOT NULL default '0',
1704 `tax_type_id` int(11) NOT NULL default '0',
1705 `rate` double NOT NULL default '0',
1706 PRIMARY KEY (`tax_group_id`,`tax_type_id`)
1710 ### Data of table `0_tax_group_items` ###
1712 INSERT INTO `0_tax_group_items` VALUES ('1', '1', '5');
1715 ### Structure of table `0_tax_groups` ###
1717 DROP TABLE IF EXISTS `0_tax_groups`;
1719 CREATE TABLE `0_tax_groups` (
1720 `id` int(11) NOT NULL auto_increment,
1721 `name` varchar(60) NOT NULL default '',
1722 `tax_shipping` tinyint(1) NOT NULL default '0',
1724 UNIQUE KEY `name` (`name`)
1725 ) TYPE=InnoDB AUTO_INCREMENT=3 ;
1728 ### Data of table `0_tax_groups` ###
1730 INSERT INTO `0_tax_groups` VALUES ('1', 'Tax', '0');
1731 INSERT INTO `0_tax_groups` VALUES ('2', 'Tax Exempt', '0');
1734 ### Structure of table `0_tax_types` ###
1736 DROP TABLE IF EXISTS `0_tax_types`;
1738 CREATE TABLE `0_tax_types` (
1739 `id` int(11) NOT NULL auto_increment,
1740 `rate` double NOT NULL default '0',
1741 `sales_gl_code` varchar(11) NOT NULL default '',
1742 `purchasing_gl_code` varchar(11) NOT NULL default '',
1743 `name` varchar(60) NOT NULL default '',
1745 UNIQUE KEY `name` (`name`,`rate`)
1746 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
1749 ### Data of table `0_tax_types` ###
1751 INSERT INTO `0_tax_types` VALUES ('1', '5', '2150', '2150', 'Tax');
1754 ### Structure of table `0_trans_tax_details` ###
1756 DROP TABLE IF EXISTS `0_trans_tax_details`;
1758 CREATE TABLE `0_trans_tax_details` (
1759 `id` int(11) NOT NULL auto_increment,
1760 `trans_type` smallint(6) default NULL,
1761 `trans_no` int(11) default NULL,
1762 `tran_date` date NOT NULL,
1763 `tax_type_id` int(11) NOT NULL default '0',
1764 `rate` double NOT NULL default '0',
1765 `ex_rate` double NOT NULL default '1',
1766 `included_in_price` tinyint(1) NOT NULL default '0',
1767 `net_amount` double NOT NULL default '0',
1768 `amount` double NOT NULL default '0',
1771 ) TYPE=InnoDB AUTO_INCREMENT=12 ;
1774 ### Data of table `0_trans_tax_details` ###
1776 INSERT INTO `0_trans_tax_details` VALUES ('1', '20', '7', '2009-06-21', '1', '5', '1', '0', '3300', '165', '5t');
1777 INSERT INTO `0_trans_tax_details` VALUES ('2', '13', '3', '2009-06-21', '1', '5', '1', '0', '50', '2.5', 'auto');
1778 INSERT INTO `0_trans_tax_details` VALUES ('3', '10', '17', '2009-06-21', '1', '5', '1', '0', '50', '2.5', '1');
1779 INSERT INTO `0_trans_tax_details` VALUES ('4', '13', '4', '2009-06-21', '1', '5', '1.3932', '0', '35.89', '1.7945', 'auto');
1780 INSERT INTO `0_trans_tax_details` VALUES ('5', '10', '18', '2009-06-21', '1', '5', '1.3932', '0', '35.89', '1.7945', '2');
1781 INSERT INTO `0_trans_tax_details` VALUES ('6', '2', '5', '2009-06-21', '1', '5', '1', '0', '95.2', '4.76', '');
1782 INSERT INTO `0_trans_tax_details` VALUES ('7', '1', '8', '2009-06-21', '1', '5', '1', '0', '-47.6', '-2.38', '');
1783 INSERT INTO `0_trans_tax_details` VALUES ('8', '20', '8', '2009-06-21', '1', '5', '1', '0', '-19', '-0.95', 'cc');
1784 INSERT INTO `0_trans_tax_details` VALUES ('9', '13', '5', '2009-06-21', '1', '5', '1', '1', '47.619047619048', '2.3809523809524', 'auto');
1785 INSERT INTO `0_trans_tax_details` VALUES ('10', '10', '19', '2009-06-21', '1', '5', '1', '1', '47.619047619048', '2.3809523809524', '3');
1786 INSERT INTO `0_trans_tax_details` VALUES ('11', '11', '3', '2009-06-21', '1', '5', '1.3932', '0', '35.89', '1.7945', '1');
1789 ### Structure of table `0_users` ###
1791 DROP TABLE IF EXISTS `0_users`;
1793 CREATE TABLE `0_users` (
1794 `user_id` varchar(60) NOT NULL default '',
1795 `password` varchar(100) NOT NULL default '',
1796 `real_name` varchar(100) NOT NULL default '',
1797 `full_access` int(11) NOT NULL default '1',
1798 `phone` varchar(30) NOT NULL default '',
1799 `email` varchar(100) default NULL,
1800 `language` varchar(20) default NULL,
1801 `date_format` tinyint(1) NOT NULL default '0',
1802 `date_sep` tinyint(1) NOT NULL default '0',
1803 `tho_sep` tinyint(1) NOT NULL default '0',
1804 `dec_sep` tinyint(1) NOT NULL default '0',
1805 `theme` varchar(20) NOT NULL default 'default',
1806 `page_size` varchar(20) NOT NULL default 'A4',
1807 `prices_dec` smallint(6) NOT NULL default '2',
1808 `qty_dec` smallint(6) NOT NULL default '2',
1809 `rates_dec` smallint(6) NOT NULL default '4',
1810 `percent_dec` smallint(6) NOT NULL default '1',
1811 `show_gl` tinyint(1) NOT NULL default '1',
1812 `show_codes` tinyint(1) NOT NULL default '0',
1813 `show_hints` tinyint(1) NOT NULL default '0',
1814 `last_visit_date` datetime default NULL,
1815 `query_size` tinyint(1) default '10',
1816 `graphic_links` tinyint(1) default '1',
1817 `pos` smallint(6) default '1',
1818 `print_profile` varchar(30) NOT NULL default '1',
1819 `rep_popup` tinyint(1) default '1',
1820 PRIMARY KEY (`user_id`)
1824 ### Data of table `0_users` ###
1826 INSERT INTO `0_users` VALUES ('admin', '5f4dcc3b5aa765d61d8327deb882cf99', 'Administrator', '2', '', 'adm@adm.com', 'en_US', '0', '0', '2', '1', 'default', 'Letter', '2', '2', '4', '1', '1', '0', '0', '2009-06-21 13:57:38', '10', '1', '1', '', '1');
1827 INSERT INTO `0_users` VALUES ('demouser', '5f4dcc3b5aa765d61d8327deb882cf99', 'Demo User', '1', '', '', 'en_US', '0', '0', '2', '1', 'default', 'Letter', '2', '2', '4', '1', '1', '0', '0', '', '10', '1', '1', '', '1');
1830 ### Structure of table `0_voided` ###
1832 DROP TABLE IF EXISTS `0_voided`;
1834 CREATE TABLE `0_voided` (
1835 `type` int(11) NOT NULL default '0',
1836 `id` int(11) NOT NULL default '0',
1837 `date_` date NOT NULL default '0000-00-00',
1838 `memo_` tinytext NOT NULL,
1839 UNIQUE KEY `id` (`type`,`id`)
1843 ### Data of table `0_voided` ###
1847 ### Structure of table `0_wo_issue_items` ###
1849 DROP TABLE IF EXISTS `0_wo_issue_items`;
1851 CREATE TABLE `0_wo_issue_items` (
1852 `id` int(11) NOT NULL auto_increment,
1853 `stock_id` varchar(40) default NULL,
1854 `issue_id` int(11) default NULL,
1855 `qty_issued` double default NULL,
1857 ) TYPE=InnoDB AUTO_INCREMENT=1 ;
1860 ### Data of table `0_wo_issue_items` ###
1864 ### Structure of table `0_wo_issues` ###
1866 DROP TABLE IF EXISTS `0_wo_issues`;
1868 CREATE TABLE `0_wo_issues` (
1869 `issue_no` int(11) NOT NULL auto_increment,
1870 `workorder_id` int(11) NOT NULL default '0',
1871 `reference` varchar(100) default NULL,
1872 `issue_date` date default NULL,
1873 `loc_code` varchar(5) default NULL,
1874 `workcentre_id` int(11) default NULL,
1875 PRIMARY KEY (`issue_no`)
1876 ) TYPE=InnoDB AUTO_INCREMENT=1 ;
1879 ### Data of table `0_wo_issues` ###
1883 ### Structure of table `0_wo_manufacture` ###
1885 DROP TABLE IF EXISTS `0_wo_manufacture`;
1887 CREATE TABLE `0_wo_manufacture` (
1888 `id` int(11) NOT NULL auto_increment,
1889 `reference` varchar(100) default NULL,
1890 `workorder_id` int(11) NOT NULL default '0',
1891 `quantity` double NOT NULL default '0',
1892 `date_` date NOT NULL default '0000-00-00',
1894 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
1897 ### Data of table `0_wo_manufacture` ###
1899 INSERT INTO `0_wo_manufacture` VALUES ('1', '1', '2', '2', '2009-06-21');
1902 ### Structure of table `0_wo_requirements` ###
1904 DROP TABLE IF EXISTS `0_wo_requirements`;
1906 CREATE TABLE `0_wo_requirements` (
1907 `id` int(11) NOT NULL auto_increment,
1908 `workorder_id` int(11) NOT NULL default '0',
1909 `stock_id` char(20) NOT NULL default '',
1910 `workcentre` int(11) NOT NULL default '0',
1911 `units_req` double NOT NULL default '1',
1912 `std_cost` double NOT NULL default '0',
1913 `loc_code` char(5) NOT NULL default '',
1914 `units_issued` double NOT NULL default '0',
1916 ) TYPE=InnoDB AUTO_INCREMENT=22 ;
1919 ### Data of table `0_wo_requirements` ###
1921 INSERT INTO `0_wo_requirements` VALUES ('1', '1', '102', '1', '1', '0', 'DEF', '10');
1922 INSERT INTO `0_wo_requirements` VALUES ('2', '1', '103', '1', '1', '0', 'DEF', '10');
1923 INSERT INTO `0_wo_requirements` VALUES ('3', '1', '104', '1', '1', '0', 'DEF', '10');
1924 INSERT INTO `0_wo_requirements` VALUES ('4', '2', '102', '1', '1', '0', 'DEF', '0');
1925 INSERT INTO `0_wo_requirements` VALUES ('5', '2', '103', '1', '1', '0', 'DEF', '0');
1926 INSERT INTO `0_wo_requirements` VALUES ('6', '2', '104', '1', '1', '0', 'DEF', '0');
1927 INSERT INTO `0_wo_requirements` VALUES ('7', '3', '102', '1', '1', '0', 'DEF', '2');
1928 INSERT INTO `0_wo_requirements` VALUES ('8', '3', '103', '1', '1', '0', 'DEF', '2');
1929 INSERT INTO `0_wo_requirements` VALUES ('9', '3', '104', '1', '1', '0', 'DEF', '2');
1930 INSERT INTO `0_wo_requirements` VALUES ('10', '4', '102', '1', '1', '0', 'DEF', '4');
1931 INSERT INTO `0_wo_requirements` VALUES ('11', '4', '103', '1', '1', '0', 'DEF', '4');
1932 INSERT INTO `0_wo_requirements` VALUES ('12', '4', '104', '1', '1', '0', 'DEF', '4');
1933 INSERT INTO `0_wo_requirements` VALUES ('13', '5', '102', '1', '1', '0', 'DEF', '5');
1934 INSERT INTO `0_wo_requirements` VALUES ('14', '5', '103', '1', '1', '0', 'DEF', '5');
1935 INSERT INTO `0_wo_requirements` VALUES ('15', '5', '104', '1', '1', '0', 'DEF', '5');
1936 INSERT INTO `0_wo_requirements` VALUES ('16', '6', '102', '1', '1', '0', 'DEF', '-5');
1937 INSERT INTO `0_wo_requirements` VALUES ('17', '6', '103', '1', '1', '0', 'DEF', '-5');
1938 INSERT INTO `0_wo_requirements` VALUES ('18', '6', '104', '1', '1', '0', 'DEF', '-5');
1939 INSERT INTO `0_wo_requirements` VALUES ('19', '7', '102', '1', '1', '0', 'DEF', '-2');
1940 INSERT INTO `0_wo_requirements` VALUES ('20', '7', '103', '1', '1', '0', 'DEF', '-2');
1941 INSERT INTO `0_wo_requirements` VALUES ('21', '7', '104', '1', '1', '0', 'DEF', '-2');
1944 ### Structure of table `0_workcentres` ###
1946 DROP TABLE IF EXISTS `0_workcentres`;
1948 CREATE TABLE `0_workcentres` (
1949 `id` int(11) NOT NULL auto_increment,
1950 `name` char(40) NOT NULL default '',
1951 `description` char(50) NOT NULL default '',
1952 `inactive` tinyint(1) NOT NULL default '0',
1954 UNIQUE KEY `name` (`name`)
1955 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
1958 ### Data of table `0_workcentres` ###
1960 INSERT INTO `0_workcentres` VALUES ('1', 'Workshop', 'Workshop in Alabama', '0');
1963 ### Structure of table `0_workorders` ###
1965 DROP TABLE IF EXISTS `0_workorders`;
1967 CREATE TABLE `0_workorders` (
1968 `id` int(11) NOT NULL auto_increment,
1969 `wo_ref` varchar(60) NOT NULL default '',
1970 `loc_code` varchar(5) NOT NULL default '',
1971 `units_reqd` double NOT NULL default '1',
1972 `stock_id` varchar(20) NOT NULL default '',
1973 `date_` date NOT NULL default '0000-00-00',
1974 `type` tinyint(4) NOT NULL default '0',
1975 `required_by` date NOT NULL default '0000-00-00',
1976 `released_date` date NOT NULL default '0000-00-00',
1977 `units_issued` double NOT NULL default '0',
1978 `closed` tinyint(1) NOT NULL default '0',
1979 `released` tinyint(1) NOT NULL default '0',
1980 `additional_costs` double NOT NULL default '0',
1982 UNIQUE KEY `wo_ref` (`wo_ref`)
1983 ) TYPE=InnoDB AUTO_INCREMENT=8 ;
1986 ### Data of table `0_workorders` ###
1988 INSERT INTO `0_workorders` VALUES ('1', '1', 'DEF', '10', '3400', '2009-06-21', '0', '2009-06-21', '2009-06-21', '10', '1', '1', '10');
1989 INSERT INTO `0_workorders` VALUES ('2', '2', 'DEF', '3', '3400', '2009-06-21', '2', '2009-07-11', '2009-06-21', '2', '0', '1', '0');
1990 INSERT INTO `0_workorders` VALUES ('3', '3', 'DEF', '2', '3400', '2009-06-21', '0', '2009-06-21', '2009-06-21', '2', '1', '1', '0');
1991 INSERT INTO `0_workorders` VALUES ('4', '4', 'DEF', '4', '3400', '2009-06-21', '0', '2009-06-21', '2009-06-21', '4', '1', '1', '0');
1992 INSERT INTO `0_workorders` VALUES ('5', '5', 'DEF', '5', '3400', '2009-06-21', '0', '2009-06-21', '2009-06-21', '5', '1', '1', '10');
1993 INSERT INTO `0_workorders` VALUES ('6', '6', 'DEF', '-5', '3400', '2009-06-21', '1', '2009-06-21', '2009-06-21', '-5', '1', '1', '0');
1994 INSERT INTO `0_workorders` VALUES ('7', '7', 'DEF', '-2', '3400', '2009-06-21', '1', '2009-06-21', '2009-06-21', '-2', '1', '1', '10');