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` ###
47 ### Structure of table `0_audit_trail` ###
49 DROP TABLE IF EXISTS `0_audit_trail`;
51 CREATE TABLE `0_audit_trail` (
52 `id` int(11) NOT NULL AUTO_INCREMENT,
53 `type` smallint(6) unsigned NOT NULL default '0',
54 `trans_no` int(11) unsigned NOT NULL default '0',
55 `user` smallint(6) unsigned NOT NULL default '0',
56 `stamp` timestamp NOT NULL,
57 `description` varchar(60) default NULL,
58 `fiscal_year` int(11) NOT NULL,
59 `gl_date` date NOT NULL default '0000-00-00',
60 `gl_seq` int(11) unsigned default NULL,
62 KEY (`fiscal_year`, `gl_seq`)
65 ### Data of table `0_audit_trail` ###
71 ### Structure of table `0_bank_accounts` ###
73 DROP TABLE IF EXISTS `0_bank_accounts`;
75 CREATE TABLE `0_bank_accounts` (
76 `account_code` varchar(11) NOT NULL default '',
77 `account_type` smallint(6) NOT NULL default '0',
78 `bank_account_name` varchar(60) NOT NULL default '',
79 `bank_account_number` varchar(100) NOT NULL default '',
80 `bank_name` varchar(60) NOT NULL default '',
81 `bank_address` tinytext,
82 `bank_curr_code` char(3) NOT NULL default '',
83 `id` smallint(6) NOT NULL auto_increment,
84 `last_reconciled_date` timestamp NOT NULL default '0000-00-00 00:00:00',
85 `ending_reconcile_balance` double NOT NULL default '0',
86 `inactive` tinyint(1) NOT NULL default '0',
88 KEY `bank_account_name` (`bank_account_name`),
89 KEY `bank_account_number` (`bank_account_number`)
90 ) TYPE=MyISAM AUTO_INCREMENT=3 ;
93 ### Data of table `0_bank_accounts` ###
95 INSERT INTO `0_bank_accounts` VALUES ('1060', '0', 'Current account', '9999999999', 'Wachovia Bank', '', 'USD', '1', '0000-00-00 00:00:00', '0', '0');
96 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');
99 ### Structure of table `0_bank_trans` ###
101 DROP TABLE IF EXISTS `0_bank_trans`;
103 CREATE TABLE `0_bank_trans` (
104 `id` int(11) NOT NULL auto_increment,
105 `type` smallint(6) default NULL,
106 `trans_no` int(11) default NULL,
107 `bank_act` varchar(11) default NULL,
108 `ref` varchar(40) default NULL,
109 `trans_date` date NOT NULL default '0000-00-00',
110 `bank_trans_type_id` int(10) unsigned default NULL,
111 `amount` double default NULL,
112 `dimension_id` int(11) NOT NULL default '0',
113 `dimension2_id` int(11) NOT NULL default '0',
114 `person_type_id` int(11) NOT NULL default '0',
115 `person_id` tinyblob,
116 `reconciled` date default NULL,
118 KEY `bank_act` (`bank_act`,`ref`),
119 KEY `type` (`type`,`trans_no`)
120 ) TYPE=InnoDB AUTO_INCREMENT=12 ;
123 ### Data of table `0_bank_trans` ###
125 INSERT INTO `0_bank_trans` VALUES ('1', '22', '4', '1', '1', '2009-06-21', '', '-3465', '0', '0', '3', '2', '');
126 INSERT INTO `0_bank_trans` VALUES ('2', '26', '1', '1', '', '2009-06-21', '', '-10', '0', '0', '1', '1', '');
127 INSERT INTO `0_bank_trans` VALUES ('3', '26', '1', '1', '', '2009-06-21', '', '-20', '0', '0', '1', '0', '');
128 INSERT INTO `0_bank_trans` VALUES ('4', '0', '18', '1', '1', '2009-02-20', '', '1000', '0', '0', '0', '', '');
129 INSERT INTO `0_bank_trans` VALUES ('5', '0', '19', '1', '2', '2009-02-21', '', '4000', '0', '0', '0', '', '');
130 INSERT INTO `0_bank_trans` VALUES ('6', '2', '5', '1', '1', '2009-06-21', '', '100', '0', '0', '4', '3', '');
131 INSERT INTO `0_bank_trans` VALUES ('7', '1', '8', '1', '1', '2009-06-21', '', '-50', '0', '0', '4', '1', '');
132 INSERT INTO `0_bank_trans` VALUES ('8', '26', '5', '1', '', '2009-06-21', '', '-10', '0', '0', '1', '1', '');
133 INSERT INTO `0_bank_trans` VALUES ('9', '26', '5', '1', '', '2009-06-21', '', '-20', '0', '0', '1', '0', '');
134 INSERT INTO `0_bank_trans` VALUES ('10', '26', '7', '1', '', '2009-06-21', '', '-10', '0', '0', '1', '1', '');
135 INSERT INTO `0_bank_trans` VALUES ('11', '26', '7', '1', '', '2009-06-21', '', '-20', '0', '0', '1', '0', '');
138 ### Structure of table `0_bom` ###
140 DROP TABLE IF EXISTS `0_bom`;
142 CREATE TABLE `0_bom` (
143 `id` int(11) NOT NULL auto_increment,
144 `parent` char(20) NOT NULL default '',
145 `component` char(20) NOT NULL default '',
146 `workcentre_added` int(11) NOT NULL default '0',
147 `loc_code` char(5) NOT NULL default '',
148 `quantity` double NOT NULL default '1',
149 PRIMARY KEY (`parent`,`component`,`workcentre_added`,`loc_code`),
150 KEY `component` (`component`),
152 KEY `loc_code` (`loc_code`),
153 KEY `parent` (`parent`,`loc_code`),
154 KEY `Parent_2` (`parent`),
155 KEY `workcentre_added` (`workcentre_added`)
156 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
159 ### Data of table `0_bom` ###
161 INSERT INTO `0_bom` VALUES ('1', '3400', '102', '1', 'DEF', '1');
162 INSERT INTO `0_bom` VALUES ('2', '3400', '103', '1', 'DEF', '1');
163 INSERT INTO `0_bom` VALUES ('3', '3400', '104', '1', 'DEF', '1');
166 ### Structure of table `0_budget_trans` ###
168 DROP TABLE IF EXISTS `0_budget_trans`;
170 CREATE TABLE `0_budget_trans` (
171 `counter` int(11) NOT NULL auto_increment,
172 `type` smallint(6) NOT NULL default '0',
173 `type_no` bigint(16) NOT NULL default '1',
174 `tran_date` date NOT NULL default '0000-00-00',
175 `account` varchar(11) NOT NULL default '',
176 `memo_` tinytext NOT NULL,
177 `amount` double NOT NULL default '0',
178 `dimension_id` int(11) default '0',
179 `dimension2_id` int(11) default '0',
180 `person_type_id` int(11) default NULL,
181 `person_id` tinyblob,
182 PRIMARY KEY (`counter`),
183 KEY `Type_and_Number` (`type`,`type_no`)
184 ) TYPE=InnoDB AUTO_INCREMENT=1 ;
187 ### Data of table `0_budget_trans` ###
191 ### Structure of table `0_chart_class` ###
193 DROP TABLE IF EXISTS `0_chart_class`;
195 CREATE TABLE `0_chart_class` (
196 `cid` int(11) NOT NULL default '0',
197 `class_name` varchar(60) NOT NULL default '',
198 `ctype` tinyint(1) NOT NULL default '0',
199 `inactive` tinyint(1) NOT NULL default '0',
204 ### Data of table `0_chart_class` ###
206 INSERT INTO `0_chart_class` VALUES ('1', 'Assets', '1', '0');
207 INSERT INTO `0_chart_class` VALUES ('2', 'Liabilities', '2', '0');
208 INSERT INTO `0_chart_class` VALUES ('3', 'Income', '4', '0');
209 INSERT INTO `0_chart_class` VALUES ('4', 'Costs', '6', '0');
212 ### Structure of table `0_chart_master` ###
214 DROP TABLE IF EXISTS `0_chart_master`;
216 CREATE TABLE `0_chart_master` (
217 `account_code` varchar(11) NOT NULL default '',
218 `account_code2` varchar(11) default '',
219 `account_name` varchar(60) NOT NULL default '',
220 `account_type` int(11) NOT NULL default '0',
221 `inactive` tinyint(1) NOT NULL default '0',
222 PRIMARY KEY (`account_code`),
223 KEY `account_code` (`account_code`),
224 KEY `account_name` (`account_name`)
228 ### Data of table `0_chart_master` ###
230 INSERT INTO `0_chart_master` VALUES ('1060', '', 'Checking Account', '1', '0');
231 INSERT INTO `0_chart_master` VALUES ('1065', '', 'Petty Cash', '1', '0');
232 INSERT INTO `0_chart_master` VALUES ('1200', '', 'Accounts Receivables', '1', '0');
233 INSERT INTO `0_chart_master` VALUES ('1205', '', 'Allowance for doubtful accounts', '1', '0');
234 INSERT INTO `0_chart_master` VALUES ('1510', '', 'Inventory', '2', '0');
235 INSERT INTO `0_chart_master` VALUES ('1520', '', 'Stocks of Raw Materials', '2', '0');
236 INSERT INTO `0_chart_master` VALUES ('1530', '', 'Stocks of Work In Progress', '2', '0');
237 INSERT INTO `0_chart_master` VALUES ('1540', '', 'Stocks of Finsihed Goods', '2', '0');
238 INSERT INTO `0_chart_master` VALUES ('1550', '', 'Goods Received Clearing account', '2', '0');
239 INSERT INTO `0_chart_master` VALUES ('1820', '', 'Office Furniture & Equipment', '3', '0');
240 INSERT INTO `0_chart_master` VALUES ('1825', '', 'Accum. Amort. -Furn. & Equip.', '3', '0');
241 INSERT INTO `0_chart_master` VALUES ('1840', '', 'Vehicle', '3', '0');
242 INSERT INTO `0_chart_master` VALUES ('1845', '', 'Accum. Amort. -Vehicle', '3', '0');
243 INSERT INTO `0_chart_master` VALUES ('2100', '', 'Accounts Payable', '4', '0');
244 INSERT INTO `0_chart_master` VALUES ('2110', '', 'Accrued Income Tax - Federal', '4', '0');
245 INSERT INTO `0_chart_master` VALUES ('2120', '', 'Accrued Income Tax - State', '4', '0');
246 INSERT INTO `0_chart_master` VALUES ('2130', '', 'Accrued Franchise Tax', '4', '0');
247 INSERT INTO `0_chart_master` VALUES ('2140', '', 'Accrued Real & Personal Prop Tax', '4', '0');
248 INSERT INTO `0_chart_master` VALUES ('2150', '', 'Sales Tax', '4', '0');
249 INSERT INTO `0_chart_master` VALUES ('2160', '', 'Accrued Use Tax Payable', '4', '0');
250 INSERT INTO `0_chart_master` VALUES ('2210', '', 'Accrued Wages', '4', '0');
251 INSERT INTO `0_chart_master` VALUES ('2220', '', 'Accrued Comp Time', '4', '0');
252 INSERT INTO `0_chart_master` VALUES ('2230', '', 'Accrued Holiday Pay', '4', '0');
253 INSERT INTO `0_chart_master` VALUES ('2240', '', 'Accrued Vacation Pay', '4', '0');
254 INSERT INTO `0_chart_master` VALUES ('2310', '', 'Accr. Benefits - 401K', '4', '0');
255 INSERT INTO `0_chart_master` VALUES ('2320', '', 'Accr. Benefits - Stock Purchase', '4', '0');
256 INSERT INTO `0_chart_master` VALUES ('2330', '', 'Accr. Benefits - Med, Den', '4', '0');
257 INSERT INTO `0_chart_master` VALUES ('2340', '', 'Accr. Benefits - Payroll Taxes', '4', '0');
258 INSERT INTO `0_chart_master` VALUES ('2350', '', 'Accr. Benefits - Credit Union', '4', '0');
259 INSERT INTO `0_chart_master` VALUES ('2360', '', 'Accr. Benefits - Savings Bond', '4', '0');
260 INSERT INTO `0_chart_master` VALUES ('2370', '', 'Accr. Benefits - Garnish', '4', '0');
261 INSERT INTO `0_chart_master` VALUES ('2380', '', 'Accr. Benefits - Charity Cont.', '4', '0');
262 INSERT INTO `0_chart_master` VALUES ('2620', '', 'Bank Loans', '5', '0');
263 INSERT INTO `0_chart_master` VALUES ('2680', '', 'Loans from Shareholders', '5', '0');
264 INSERT INTO `0_chart_master` VALUES ('3350', '', 'Common Shares', '6', '0');
265 INSERT INTO `0_chart_master` VALUES ('3590', '', 'Retained Earnings - prior years', '7', '0');
266 INSERT INTO `0_chart_master` VALUES ('4010', '', 'Sales', '8', '0');
267 INSERT INTO `0_chart_master` VALUES ('4430', '', 'Shipping & Handling', '9', '0');
268 INSERT INTO `0_chart_master` VALUES ('4440', '', 'Interest', '9', '0');
269 INSERT INTO `0_chart_master` VALUES ('4450', '', 'Foreign Exchange Gain', '9', '0');
270 INSERT INTO `0_chart_master` VALUES ('4500', '', 'Prompt Payment Discounts', '9', '0');
271 INSERT INTO `0_chart_master` VALUES ('4510', '', 'Discounts Given', '9', '0');
272 INSERT INTO `0_chart_master` VALUES ('5010', '', 'Cost of Goods Sold - Retail', '10', '0');
273 INSERT INTO `0_chart_master` VALUES ('5020', '', 'Material Usage Varaiance', '10', '0');
274 INSERT INTO `0_chart_master` VALUES ('5030', '', 'Consumable Materials', '10', '0');
275 INSERT INTO `0_chart_master` VALUES ('5040', '', 'Purchase price Variance', '10', '0');
276 INSERT INTO `0_chart_master` VALUES ('5050', '', 'Purchases of materials', '10', '0');
277 INSERT INTO `0_chart_master` VALUES ('5060', '', 'Discounts Received', '10', '0');
278 INSERT INTO `0_chart_master` VALUES ('5100', '', 'Freight', '10', '0');
279 INSERT INTO `0_chart_master` VALUES ('5410', '', 'Wages & Salaries', '11', '0');
280 INSERT INTO `0_chart_master` VALUES ('5420', '', 'Wages - Overtime', '11', '0');
281 INSERT INTO `0_chart_master` VALUES ('5430', '', 'Benefits - Comp Time', '11', '0');
282 INSERT INTO `0_chart_master` VALUES ('5440', '', 'Benefits - Payroll Taxes', '11', '0');
283 INSERT INTO `0_chart_master` VALUES ('5450', '', 'Benefits - Workers Comp', '11', '0');
284 INSERT INTO `0_chart_master` VALUES ('5460', '', 'Benefits - Pension', '11', '0');
285 INSERT INTO `0_chart_master` VALUES ('5470', '', 'Benefits - General Benefits', '11', '0');
286 INSERT INTO `0_chart_master` VALUES ('5510', '', 'Inc Tax Exp - Federal', '11', '0');
287 INSERT INTO `0_chart_master` VALUES ('5520', '', 'Inc Tax Exp - State', '11', '0');
288 INSERT INTO `0_chart_master` VALUES ('5530', '', 'Taxes - Real Estate', '11', '0');
289 INSERT INTO `0_chart_master` VALUES ('5540', '', 'Taxes - Personal Property', '11', '0');
290 INSERT INTO `0_chart_master` VALUES ('5550', '', 'Taxes - Franchise', '11', '0');
291 INSERT INTO `0_chart_master` VALUES ('5560', '', 'Taxes - Foreign Withholding', '11', '0');
292 INSERT INTO `0_chart_master` VALUES ('5610', '', 'Accounting & Legal', '12', '0');
293 INSERT INTO `0_chart_master` VALUES ('5615', '', 'Advertising & Promotions', '12', '0');
294 INSERT INTO `0_chart_master` VALUES ('5620', '', 'Bad Debts', '12', '0');
295 INSERT INTO `0_chart_master` VALUES ('5660', '', 'Amortization Expense', '12', '0');
296 INSERT INTO `0_chart_master` VALUES ('5685', '', 'Insurance', '12', '0');
297 INSERT INTO `0_chart_master` VALUES ('5690', '', 'Interest & Bank Charges', '12', '0');
298 INSERT INTO `0_chart_master` VALUES ('5700', '', 'Office Supplies', '12', '0');
299 INSERT INTO `0_chart_master` VALUES ('5760', '', 'Rent', '12', '0');
300 INSERT INTO `0_chart_master` VALUES ('5765', '', 'Repair & Maintenance', '12', '0');
301 INSERT INTO `0_chart_master` VALUES ('5780', '', 'Telephone', '12', '0');
302 INSERT INTO `0_chart_master` VALUES ('5785', '', 'Travel & Entertainment', '12', '0');
303 INSERT INTO `0_chart_master` VALUES ('5790', '', 'Utilities', '12', '0');
304 INSERT INTO `0_chart_master` VALUES ('5795', '', 'Registrations', '12', '0');
305 INSERT INTO `0_chart_master` VALUES ('5800', '', 'Licenses', '12', '0');
306 INSERT INTO `0_chart_master` VALUES ('5810', '', 'Foreign Exchange Loss', '12', '0');
307 INSERT INTO `0_chart_master` VALUES ('9990', '', 'Year Profit/Loss', '12', '0');
309 ### Structure of table `0_chart_types` ###
311 DROP TABLE IF EXISTS `0_chart_types`;
313 CREATE TABLE `0_chart_types` (
314 `id` int(11) NOT NULL auto_increment,
315 `name` varchar(60) NOT NULL default '',
316 `class_id` tinyint(1) NOT NULL default '0',
317 `parent` int(11) NOT NULL default '-1',
318 `inactive` tinyint(1) NOT NULL default '0',
321 ) TYPE=MyISAM AUTO_INCREMENT=13 ;
324 ### Data of table `0_chart_types` ###
326 INSERT INTO `0_chart_types` VALUES ('1', 'Current Assets', '1', '-1', '0');
327 INSERT INTO `0_chart_types` VALUES ('2', 'Inventory Assets', '1', '-1', '0');
328 INSERT INTO `0_chart_types` VALUES ('3', 'Capital Assets', '1', '-1', '0');
329 INSERT INTO `0_chart_types` VALUES ('4', 'Current Liabilities', '2', '-1', '0');
330 INSERT INTO `0_chart_types` VALUES ('5', 'Long Term Liabilities', '2', '-1', '0');
331 INSERT INTO `0_chart_types` VALUES ('6', 'Share Capital', '2', '-1', '0');
332 INSERT INTO `0_chart_types` VALUES ('7', 'Retained Earnings', '2', '-1', '0');
333 INSERT INTO `0_chart_types` VALUES ('8', 'Sales Revenue', '3', '-1', '0');
334 INSERT INTO `0_chart_types` VALUES ('9', 'Other Revenue', '3', '-1', '0');
335 INSERT INTO `0_chart_types` VALUES ('10', 'Cost of Goods Sold', '4', '-1', '0');
336 INSERT INTO `0_chart_types` VALUES ('11', 'Payroll Expenses', '4', '-1', '0');
337 INSERT INTO `0_chart_types` VALUES ('12', 'General & Administrative expenses', '4', '-1', '0');
340 ### Structure of table `0_comments` ###
342 DROP TABLE IF EXISTS `0_comments`;
344 CREATE TABLE `0_comments` (
345 `type` int(11) NOT NULL default '0',
346 `id` int(11) NOT NULL default '0',
347 `date_` date default '0000-00-00',
352 ### Data of table `0_comments` ###
356 ### Structure of table `0_company` ###
358 DROP TABLE IF EXISTS `0_company`;
360 CREATE TABLE `0_company` (
361 `coy_code` int(11) NOT NULL default '1',
362 `coy_name` varchar(60) NOT NULL default '',
363 `gst_no` varchar(25) NOT NULL default '',
364 `coy_no` varchar(25) NOT NULL default '0',
365 `tax_prd` int(11) NOT NULL default '1',
366 `tax_last` int(11) NOT NULL default '1',
367 `postal_address` tinytext NOT NULL,
368 `phone` varchar(30) NOT NULL default '',
369 `fax` varchar(30) NOT NULL default '',
370 `email` varchar(100) NOT NULL default '',
371 `coy_logo` varchar(100) NOT NULL default '',
372 `domicile` varchar(55) NOT NULL default '',
373 `curr_default` char(3) NOT NULL default '',
374 `debtors_act` varchar(11) NOT NULL default '',
375 `pyt_discount_act` varchar(11) NOT NULL default '',
376 `creditors_act` varchar(11) NOT NULL default '',
377 `bank_charge_act` varchar(11) NOT NULL default '',
378 `exchange_diff_act` varchar(11) NOT NULL default '',
379 `profit_loss_year_act` varchar(11) NOT NULL default '',
380 `retained_earnings_act` varchar(11) NOT NULL default '',
381 `freight_act` varchar(11) NOT NULL default '',
382 `default_sales_act` varchar(11) NOT NULL default '',
383 `default_sales_discount_act` varchar(11) NOT NULL default '',
384 `default_prompt_payment_act` varchar(11) NOT NULL default '',
385 `default_inventory_act` varchar(11) NOT NULL default '',
386 `default_cogs_act` varchar(11) NOT NULL default '',
387 `default_adj_act` varchar(11) NOT NULL default '',
388 `default_inv_sales_act` varchar(11) NOT NULL default '',
389 `default_assembly_act` varchar(11) NOT NULL default '',
390 `payroll_act` varchar(11) NOT NULL default '',
391 `allow_negative_stock` tinyint(1) NOT NULL default '0',
392 `po_over_receive` int(11) NOT NULL default '10',
393 `po_over_charge` int(11) NOT NULL default '10',
394 `default_credit_limit` int(11) NOT NULL default '1000',
395 `default_workorder_required` int(11) NOT NULL default '20',
396 `default_dim_required` int(11) NOT NULL default '20',
397 `past_due_days` int(11) NOT NULL default '30',
398 `use_dimension` tinyint(1) default '0',
399 `f_year` int(11) NOT NULL default '1',
400 `no_item_list` tinyint(1) NOT NULL default '0',
401 `no_customer_list` tinyint(1) NOT NULL default '0',
402 `no_supplier_list` tinyint(1) NOT NULL default '0',
403 `base_sales` int(11) NOT NULL default '-1',
404 `foreign_codes` tinyint(1) NOT NULL default '0',
405 `accumulate_shipping` tinyint(1) NOT NULL default '0',
406 `legal_text` tinytext NOT NULL,
407 `default_delivery_required` smallint(6) NOT NULL default '1',
408 `version_id` varchar(11) NOT NULL default '',
409 `time_zone` tinyint(1) NOT NULL default '0',
410 `add_pct` int(5) NOT NULL default '-1',
411 `round_to` int(5) NOT NULL default '1',
412 PRIMARY KEY (`coy_code`)
415 ### Data of table `0_company` ###
417 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', '5690', '4450', '9990', '3590', '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', '', '1', '2.2', '0', '-1', '1');
419 ### Structure of table `0_credit_status` ###
421 DROP TABLE IF EXISTS `0_credit_status`;
423 CREATE TABLE `0_credit_status` (
424 `id` int(11) NOT NULL auto_increment,
425 `reason_description` char(100) NOT NULL default '',
426 `dissallow_invoices` tinyint(1) NOT NULL default '0',
427 `inactive` tinyint(1) NOT NULL default '0',
429 UNIQUE KEY `reason_description` (`reason_description`)
430 ) TYPE=MyISAM AUTO_INCREMENT=5 ;
433 ### Data of table `0_credit_status` ###
435 INSERT INTO `0_credit_status` VALUES ('1', 'Good History', '0', '0');
436 INSERT INTO `0_credit_status` VALUES ('3', 'No more work until payment received', '1', '0');
437 INSERT INTO `0_credit_status` VALUES ('4', 'In liquidation', '1', '0');
440 ### Structure of table `0_currencies` ###
442 DROP TABLE IF EXISTS `0_currencies`;
444 CREATE TABLE `0_currencies` (
445 `currency` varchar(60) NOT NULL default '',
446 `curr_abrev` char(3) NOT NULL default '',
447 `curr_symbol` varchar(10) NOT NULL default '',
448 `country` varchar(100) NOT NULL default '',
449 `hundreds_name` varchar(15) NOT NULL default '',
450 `auto_update` tinyint(1) NOT NULL default '1',
451 `inactive` tinyint(1) NOT NULL default '0',
452 PRIMARY KEY (`curr_abrev`)
456 ### Data of table `0_currencies` ###
458 INSERT INTO `0_currencies` VALUES ('US Dollars', 'USD', '$', 'United States', 'Cents', '1', '0');
459 INSERT INTO `0_currencies` VALUES ('CA Dollars', 'CAD', '$', 'Canada', 'Cents', '1', '0');
460 INSERT INTO `0_currencies` VALUES ('Euro', 'EUR', '?', 'Europe', 'Cents', '1', '0');
461 INSERT INTO `0_currencies` VALUES ('Pounds', 'GBP', '?', 'England', 'Pence', '1', '0');
462 INSERT INTO `0_currencies` VALUES ('DK Kroner', 'DKK', '?', 'Denmark', 'Ore', '1', '0');
464 ### Structure of table `0_cust_allocations` ###
466 DROP TABLE IF EXISTS `0_cust_allocations`;
468 CREATE TABLE `0_cust_allocations` (
469 `id` int(11) NOT NULL auto_increment,
470 `amt` double unsigned default NULL,
471 `date_alloc` date NOT NULL default '0000-00-00',
472 `trans_no_from` int(11) default NULL,
473 `trans_type_from` int(11) default NULL,
474 `trans_no_to` int(11) default NULL,
475 `trans_type_to` int(11) default NULL,
477 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
480 ### Data of table `0_cust_allocations` ###
482 INSERT INTO `0_cust_allocations` VALUES ('1', '37.68', '2009-06-21', '3', '11', '18', '10');
485 ### Structure of table `0_cust_branch` ###
487 DROP TABLE IF EXISTS `0_cust_branch`;
489 CREATE TABLE `0_cust_branch` (
490 `branch_code` int(11) NOT NULL auto_increment,
491 `debtor_no` int(11) NOT NULL default '0',
492 `br_name` varchar(60) NOT NULL default '',
493 `br_address` tinytext NOT NULL,
494 `area` int(11) default NULL,
495 `salesman` int(11) NOT NULL default '0',
496 `phone` varchar(30) NOT NULL default '',
497 `fax` varchar(30) NOT NULL default '',
498 `contact_name` varchar(60) NOT NULL default '',
499 `email` varchar(100) NOT NULL default '',
500 `default_location` varchar(5) NOT NULL default '',
501 `tax_group_id` int(11) default NULL,
502 `sales_account` varchar(11) default NULL,
503 `sales_discount_account` varchar(11) default NULL,
504 `receivables_account` varchar(11) default NULL,
505 `payment_discount_account` varchar(11) default NULL,
506 `default_ship_via` int(11) NOT NULL default '1',
507 `disable_trans` tinyint(4) NOT NULL default '0',
508 `br_post_address` tinytext NOT NULL,
509 `group_no` int(11) NOT NULL default '0',
510 `inactive` tinyint(1) NOT NULL default '0',
511 PRIMARY KEY (`branch_code`,`debtor_no`),
512 KEY `branch_code` (`branch_code`),
513 KEY `br_name` (`br_name`)
514 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
517 ### Data of table `0_cust_branch` ###
519 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', '0');
520 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', '0');
521 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', '0');
524 ### Structure of table `0_debtor_trans` ###
526 DROP TABLE IF EXISTS `0_debtor_trans`;
528 CREATE TABLE `0_debtor_trans` (
529 `trans_no` int(11) unsigned NOT NULL default '0',
530 `type` smallint(6) unsigned NOT NULL default '0',
531 `version` tinyint(1) unsigned NOT NULL default '0',
532 `debtor_no` int(11) unsigned default NULL,
533 `branch_code` int(11) NOT NULL default '-1',
534 `tran_date` date NOT NULL default '0000-00-00',
535 `due_date` date NOT NULL default '0000-00-00',
536 `reference` varchar(60) NOT NULL default '',
537 `tpe` int(11) NOT NULL default '0',
538 `order_` int(11) NOT NULL default '0',
539 `ov_amount` double NOT NULL default '0',
540 `ov_gst` double NOT NULL default '0',
541 `ov_freight` double NOT NULL default '0',
542 `ov_freight_tax` double NOT NULL default '0',
543 `ov_discount` double NOT NULL default '0',
544 `alloc` double NOT NULL default '0',
545 `rate` double NOT NULL default '1',
546 `ship_via` int(11) default NULL,
547 `trans_link` int(11) NOT NULL default '0',
548 `dimension_id` int(11) NOT NULL default '0',
549 `dimension2_id` int(11) NOT NULL default '0',
550 PRIMARY KEY (`trans_no`,`type`),
551 KEY `debtor_no` (`debtor_no`,`branch_code`)
555 ### Data of table `0_debtor_trans` ###
557 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');
558 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');
559 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');
560 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');
561 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');
562 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');
563 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');
564 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');
567 ### Structure of table `0_debtor_trans_details` ###
569 DROP TABLE IF EXISTS `0_debtor_trans_details`;
571 CREATE TABLE `0_debtor_trans_details` (
572 `id` int(11) NOT NULL auto_increment,
573 `debtor_trans_no` int(11) default NULL,
574 `debtor_trans_type` int(11) default NULL,
575 `stock_id` varchar(20) NOT NULL default '',
576 `description` tinytext,
577 `unit_price` double NOT NULL default '0',
578 `unit_tax` double NOT NULL default '0',
579 `quantity` double NOT NULL default '0',
580 `discount_percent` double NOT NULL default '0',
581 `standard_cost` double NOT NULL default '0',
582 `qty_done` double NOT NULL default '0',
584 ) TYPE=InnoDB AUTO_INCREMENT=9 ;
587 ### Data of table `0_debtor_trans_details` ###
589 INSERT INTO `0_debtor_trans_details` VALUES ('1', '2', '13', '102', '17inch VGA Monitor', '30.4', '0', '2', '0', '10', '0');
590 INSERT INTO `0_debtor_trans_details` VALUES ('2', '3', '13', '102', '17inch VGA Monitor', '50', '2.5', '1', '0', '10', '1');
591 INSERT INTO `0_debtor_trans_details` VALUES ('3', '17', '10', '102', '17inch VGA Monitor', '50', '2.5', '1', '0', '10', '0');
592 INSERT INTO `0_debtor_trans_details` VALUES ('4', '4', '13', '102', '17inch VGA Monitor', '35.89', '1.79', '1', '0', '10', '1');
593 INSERT INTO `0_debtor_trans_details` VALUES ('5', '18', '10', '102', '17inch VGA Monitor', '35.89', '1.79', '1', '0', '10', '1');
594 INSERT INTO `0_debtor_trans_details` VALUES ('6', '5', '13', '102', '17inch VGA Monitor', '50', '2.38', '1', '0', '10', '1');
595 INSERT INTO `0_debtor_trans_details` VALUES ('7', '19', '10', '102', '17inch VGA Monitor', '50', '2.38', '1', '0', '10', '0');
596 INSERT INTO `0_debtor_trans_details` VALUES ('8', '3', '11', '102', '17inch VGA Monitor', '35.89', '1.79', '1', '0', '10', '0');
599 ### Structure of table `0_debtors_master` ###
601 DROP TABLE IF EXISTS `0_debtors_master`;
603 CREATE TABLE `0_debtors_master` (
604 `debtor_no` int(11) NOT NULL auto_increment,
605 `name` varchar(80) NOT NULL default '',
607 `email` varchar(100) NOT NULL default '',
608 `tax_id` varchar(55) NOT NULL default '',
609 `curr_code` char(3) NOT NULL default '',
610 `sales_type` int(11) NOT NULL default '1',
611 `dimension_id` int(11) NOT NULL default '0',
612 `dimension2_id` int(11) NOT NULL default '0',
613 `credit_status` int(11) NOT NULL default '0',
614 `payment_terms` int(11) default NULL,
615 `discount` double NOT NULL default '0',
616 `pymt_discount` double NOT NULL default '0',
617 `credit_limit` float NOT NULL default '1000',
618 `inactive` tinyint(1) NOT NULL default '0',
619 PRIMARY KEY (`debtor_no`),
620 UNIQUE KEY `name` (`name`)
621 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
624 ### Data of table `0_debtors_master` ###
626 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');
627 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');
628 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');
631 ### Structure of table `0_dimensions` ###
633 DROP TABLE IF EXISTS `0_dimensions`;
635 CREATE TABLE `0_dimensions` (
636 `id` int(11) NOT NULL auto_increment,
637 `reference` varchar(60) NOT NULL default '',
638 `name` varchar(60) NOT NULL default '',
639 `type_` tinyint(1) NOT NULL default '1',
640 `closed` tinyint(1) NOT NULL default '0',
641 `date_` date NOT NULL default '0000-00-00',
642 `due_date` date NOT NULL default '0000-00-00',
644 UNIQUE KEY `reference` (`reference`)
645 ) TYPE=InnoDB AUTO_INCREMENT=3 ;
648 ### Data of table `0_dimensions` ###
650 INSERT INTO `0_dimensions` VALUES ('1', '1', 'Support', '1', '0', '2009-06-21', '2015-07-11');
651 INSERT INTO `0_dimensions` VALUES ('2', '2', 'Development', '1', '0', '2009-06-21', '2015-07-11');
654 ### Structure of table `0_exchange_rates` ###
656 DROP TABLE IF EXISTS `0_exchange_rates`;
658 CREATE TABLE `0_exchange_rates` (
659 `id` int(11) NOT NULL auto_increment,
660 `curr_code` char(3) NOT NULL default '',
661 `rate_buy` double NOT NULL default '0',
662 `rate_sell` double NOT NULL default '0',
663 `date_` date NOT NULL default '0000-00-00',
665 UNIQUE KEY `curr_code` (`curr_code`,`date_`)
666 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
669 ### Data of table `0_exchange_rates` ###
671 INSERT INTO `0_exchange_rates` VALUES ('1', 'DKK', '0.18717252868313', '0.18717252868313', '2009-06-21');
672 INSERT INTO `0_exchange_rates` VALUES ('2', 'GBP', '1.6445729799917', '1.6445729799917', '2009-06-21');
673 INSERT INTO `0_exchange_rates` VALUES ('3', 'EUR', '1.3932', '1.3932', '2009-06-21');
676 ### Structure of table `0_fiscal_year` ###
678 DROP TABLE IF EXISTS `0_fiscal_year`;
680 CREATE TABLE `0_fiscal_year` (
681 `id` int(11) NOT NULL auto_increment,
682 `begin` date default '0000-00-00',
683 `end` date default '0000-00-00',
684 `closed` tinyint(1) NOT NULL default '0',
686 ) TYPE=InnoDB AUTO_INCREMENT=3 ;
689 ### Data of table `0_fiscal_year` ###
691 INSERT INTO `0_fiscal_year` VALUES ('1', '2008-01-01', '2008-12-31', '0');
692 INSERT INTO `0_fiscal_year` VALUES ('2', '2009-01-01', '2009-12-31', '0');
695 ### Structure of table `0_gl_trans` ###
697 DROP TABLE IF EXISTS `0_gl_trans`;
699 CREATE TABLE `0_gl_trans` (
700 `counter` int(11) NOT NULL auto_increment,
701 `type` smallint(6) NOT NULL default '0',
702 `type_no` bigint(16) NOT NULL default '1',
703 `tran_date` date NOT NULL default '0000-00-00',
704 `account` varchar(11) NOT NULL default '',
705 `memo_` tinytext NOT NULL,
706 `amount` double NOT NULL default '0',
707 `dimension_id` int(11) NOT NULL default '0',
708 `dimension2_id` int(11) NOT NULL default '0',
709 `person_type_id` int(11) default NULL,
710 `person_id` tinyblob,
711 PRIMARY KEY (`counter`),
712 KEY `Type_and_Number` (`type`,`type_no`)
713 ) TYPE=InnoDB AUTO_INCREMENT=84 ;
716 ### Data of table `0_gl_trans` ###
718 INSERT INTO `0_gl_trans` VALUES ('1', '20', '7', '2009-06-21', '2100', '', '-3465', '0', '0', '3', '2');
719 INSERT INTO `0_gl_trans` VALUES ('2', '20', '7', '2009-06-21', '1510', '', '1000', '0', '0', '3', '2');
720 INSERT INTO `0_gl_trans` VALUES ('3', '20', '7', '2009-06-21', '1510', '', '1100', '0', '0', '3', '2');
721 INSERT INTO `0_gl_trans` VALUES ('4', '20', '7', '2009-06-21', '1510', '', '1200', '0', '0', '3', '2');
722 INSERT INTO `0_gl_trans` VALUES ('5', '20', '7', '2009-06-21', '2150', '', '165', '0', '0', '3', '2');
723 INSERT INTO `0_gl_trans` VALUES ('6', '22', '4', '2009-06-21', '2100', '', '3465', '0', '0', '3', '2');
724 INSERT INTO `0_gl_trans` VALUES ('7', '22', '4', '2009-06-21', '1060', '', '-3465', '0', '0', '3', '2');
725 INSERT INTO `0_gl_trans` VALUES ('8', '26', '1', '2009-06-21', '1510', '', '-100', '0', '0', '', '');
726 INSERT INTO `0_gl_trans` VALUES ('9', '26', '1', '2009-06-21', '1510', '', '-110', '0', '0', '', '');
727 INSERT INTO `0_gl_trans` VALUES ('10', '26', '1', '2009-06-21', '1510', '', '-120', '0', '0', '', '');
728 INSERT INTO `0_gl_trans` VALUES ('11', '26', '1', '2009-06-21', '1060', 'Overhead Cost', '-10', '0', '0', '1', '1');
729 INSERT INTO `0_gl_trans` VALUES ('12', '26', '1', '2009-06-21', '1530', 'Overhead Cost', '10', '0', '0', '1', '1');
730 INSERT INTO `0_gl_trans` VALUES ('13', '26', '1', '2009-06-21', '1060', 'Labour Cost', '-20', '0', '0', '1', '0');
731 INSERT INTO `0_gl_trans` VALUES ('14', '26', '1', '2009-06-21', '1530', 'Labour Cost', '20', '0', '0', '1', '0');
732 INSERT INTO `0_gl_trans` VALUES ('15', '26', '1', '2009-06-21', '1510', '', '330', '0', '0', '', '');
733 INSERT INTO `0_gl_trans` VALUES ('16', '13', '2', '2009-06-21', '5010', '', '20', '0', '0', '2', '1');
734 INSERT INTO `0_gl_trans` VALUES ('17', '13', '2', '2009-06-21', '1510', '', '-20', '0', '0', '2', '1');
735 INSERT INTO `0_gl_trans` VALUES ('18', '13', '3', '2009-06-21', '5010', '', '10', '0', '0', '2', '2');
736 INSERT INTO `0_gl_trans` VALUES ('19', '13', '3', '2009-06-21', '1510', '', '-10', '0', '0', '2', '2');
737 INSERT INTO `0_gl_trans` VALUES ('20', '10', '17', '2009-06-21', '4010', '', '-50', '0', '0', '2', '2');
738 INSERT INTO `0_gl_trans` VALUES ('21', '10', '17', '2009-06-21', '1200', '', '52.5', '0', '0', '2', '2');
739 INSERT INTO `0_gl_trans` VALUES ('22', '10', '17', '2009-06-21', '2150', '', '-2.5', '0', '0', '2', '2');
740 INSERT INTO `0_gl_trans` VALUES ('23', '13', '4', '2009-06-21', '5010', '', '10', '2', '0', '2', '3');
741 INSERT INTO `0_gl_trans` VALUES ('24', '13', '4', '2009-06-21', '1510', '', '-10', '0', '0', '2', '3');
742 INSERT INTO `0_gl_trans` VALUES ('25', '10', '18', '2009-06-21', '4010', '', '-50', '2', '0', '2', '3');
743 INSERT INTO `0_gl_trans` VALUES ('26', '10', '18', '2009-06-21', '1200', '', '52.5', '0', '0', '2', '3');
744 INSERT INTO `0_gl_trans` VALUES ('27', '10', '18', '2009-06-21', '2150', '', '-2.5', '0', '0', '2', '3');
745 INSERT INTO `0_gl_trans` VALUES ('28', '0', '18', '2009-02-20', '1060', '', '1000', '0', '0', '', '');
746 INSERT INTO `0_gl_trans` VALUES ('29', '0', '18', '2009-02-20', '3350', '', '-1000', '0', '0', '', '');
747 INSERT INTO `0_gl_trans` VALUES ('30', '0', '19', '2009-02-21', '1060', '', '4000', '0', '0', '', '');
748 INSERT INTO `0_gl_trans` VALUES ('31', '0', '19', '2009-02-21', '3350', '', '-4000', '0', '0', '', '');
749 INSERT INTO `0_gl_trans` VALUES ('32', '26', '3', '2009-06-21', '1510', '', '-20', '0', '0', '', '');
750 INSERT INTO `0_gl_trans` VALUES ('33', '26', '3', '2009-06-21', '1510', '', '-22', '0', '0', '', '');
751 INSERT INTO `0_gl_trans` VALUES ('34', '26', '3', '2009-06-21', '1510', '', '-24', '0', '0', '', '');
752 INSERT INTO `0_gl_trans` VALUES ('35', '26', '3', '2009-06-21', '1540', '', '66', '0', '0', '', '');
753 INSERT INTO `0_gl_trans` VALUES ('36', '2', '5', '2009-06-21', '2150', 'Cash Sales', '-4.76', '0', '0', '4', '3');
754 INSERT INTO `0_gl_trans` VALUES ('37', '2', '5', '2009-06-21', '4010', 'Cash Sales', '-95.24', '0', '0', '4', '3');
755 INSERT INTO `0_gl_trans` VALUES ('38', '2', '5', '2009-06-21', '1060', '', '100', '0', '0', '4', '3');
756 INSERT INTO `0_gl_trans` VALUES ('39', '1', '8', '2009-06-21', '2150', 'Maintenance', '2.38', '0', '0', '4', '1');
757 INSERT INTO `0_gl_trans` VALUES ('40', '1', '8', '2009-06-21', '5765', 'Maintenance', '47.62', '0', '0', '4', '1');
758 INSERT INTO `0_gl_trans` VALUES ('41', '1', '8', '2009-06-21', '1060', '', '-50', '0', '0', '4', '1');
759 INSERT INTO `0_gl_trans` VALUES ('42', '20', '8', '2009-06-21', '2100', '', '-20', '0', '0', '3', '2');
760 INSERT INTO `0_gl_trans` VALUES ('43', '20', '8', '2009-06-21', '2150', '', '0.95', '0', '0', '3', '2');
761 INSERT INTO `0_gl_trans` VALUES ('44', '20', '8', '2009-06-21', '5780', '', '19.05', '0', '0', '3', '2');
762 INSERT INTO `0_gl_trans` VALUES ('45', '26', '4', '2009-06-21', '1510', '', '-40', '0', '0', '', '');
763 INSERT INTO `0_gl_trans` VALUES ('46', '26', '4', '2009-06-21', '1510', '', '-44', '0', '0', '', '');
764 INSERT INTO `0_gl_trans` VALUES ('47', '26', '4', '2009-06-21', '1510', '', '-48', '0', '0', '', '');
765 INSERT INTO `0_gl_trans` VALUES ('48', '26', '4', '2009-06-21', '1540', '', '132', '0', '0', '', '');
766 INSERT INTO `0_gl_trans` VALUES ('49', '26', '2', '2009-06-21', '1510', '', '-20', '0', '0', '', '');
767 INSERT INTO `0_gl_trans` VALUES ('50', '26', '2', '2009-06-21', '1510', '', '-22', '0', '0', '', '');
768 INSERT INTO `0_gl_trans` VALUES ('51', '26', '2', '2009-06-21', '1510', '', '-24', '0', '0', '', '');
769 INSERT INTO `0_gl_trans` VALUES ('52', '26', '2', '2009-06-21', '1540', '', '66', '0', '0', '', '');
770 INSERT INTO `0_gl_trans` VALUES ('53', '26', '5', '2009-06-21', '1510', '', '-50', '0', '0', '', '');
771 INSERT INTO `0_gl_trans` VALUES ('54', '26', '5', '2009-06-21', '1510', '', '-55', '0', '0', '', '');
772 INSERT INTO `0_gl_trans` VALUES ('55', '26', '5', '2009-06-21', '1510', '', '-60', '0', '0', '', '');
773 INSERT INTO `0_gl_trans` VALUES ('56', '26', '5', '2009-06-21', '1060', 'Overhead Cost', '-10', '0', '0', '1', '1');
774 INSERT INTO `0_gl_trans` VALUES ('57', '26', '5', '2009-06-21', '1530', 'Overhead Cost', '10', '0', '0', '1', '1');
775 INSERT INTO `0_gl_trans` VALUES ('58', '26', '5', '2009-06-21', '1060', 'Labour Cost', '-20', '0', '0', '1', '0');
776 INSERT INTO `0_gl_trans` VALUES ('59', '26', '5', '2009-06-21', '1530', 'Labour Cost', '20', '0', '0', '1', '0');
777 INSERT INTO `0_gl_trans` VALUES ('60', '26', '5', '2009-06-21', '1540', '', '165', '0', '0', '', '');
778 INSERT INTO `0_gl_trans` VALUES ('61', '26', '6', '2009-06-21', '1510', '', '50', '0', '0', '', '');
779 INSERT INTO `0_gl_trans` VALUES ('62', '26', '6', '2009-06-21', '1510', '', '55', '0', '0', '', '');
780 INSERT INTO `0_gl_trans` VALUES ('63', '26', '6', '2009-06-21', '1510', '', '60', '0', '0', '', '');
781 INSERT INTO `0_gl_trans` VALUES ('64', '26', '6', '2009-06-21', '1540', '', '-165', '0', '0', '', '');
782 INSERT INTO `0_gl_trans` VALUES ('65', '26', '7', '2009-06-21', '1510', '', '20', '0', '0', '', '');
783 INSERT INTO `0_gl_trans` VALUES ('66', '26', '7', '2009-06-21', '1510', '', '22', '0', '0', '', '');
784 INSERT INTO `0_gl_trans` VALUES ('67', '26', '7', '2009-06-21', '1510', '', '24', '0', '0', '', '');
785 INSERT INTO `0_gl_trans` VALUES ('68', '26', '7', '2009-06-21', '1060', 'Overhead Cost', '-10', '0', '0', '1', '1');
786 INSERT INTO `0_gl_trans` VALUES ('69', '26', '7', '2009-06-21', '1530', 'Overhead Cost', '10', '0', '0', '1', '1');
787 INSERT INTO `0_gl_trans` VALUES ('70', '26', '7', '2009-06-21', '1060', 'Labour Cost', '-20', '0', '0', '1', '0');
788 INSERT INTO `0_gl_trans` VALUES ('71', '26', '7', '2009-06-21', '1530', 'Labour Cost', '20', '0', '0', '1', '0');
789 INSERT INTO `0_gl_trans` VALUES ('72', '26', '7', '2009-06-21', '1540', '', '-66', '0', '0', '', '');
790 INSERT INTO `0_gl_trans` VALUES ('73', '13', '5', '2009-06-21', '5010', '', '10', '0', '0', '2', '2');
791 INSERT INTO `0_gl_trans` VALUES ('74', '13', '5', '2009-06-21', '1510', '', '-10', '0', '0', '2', '2');
792 INSERT INTO `0_gl_trans` VALUES ('75', '10', '19', '2009-06-21', '4010', '', '-47.62', '0', '0', '2', '2');
793 INSERT INTO `0_gl_trans` VALUES ('76', '10', '19', '2009-06-21', '1200', '', '55', '0', '0', '2', '2');
794 INSERT INTO `0_gl_trans` VALUES ('77', '10', '19', '2009-06-21', '4430', '', '-5', '0', '0', '2', '2');
795 INSERT INTO `0_gl_trans` VALUES ('78', '10', '19', '2009-06-21', '2150', '', '-2.38', '0', '0', '2', '2');
796 INSERT INTO `0_gl_trans` VALUES ('79', '11', '3', '2009-06-21', '5010', '', '-10', '2', '0', '2', '3');
797 INSERT INTO `0_gl_trans` VALUES ('80', '11', '3', '2009-06-21', '1510', '', '10', '0', '0', '2', '3');
798 INSERT INTO `0_gl_trans` VALUES ('81', '11', '3', '2009-06-21', '4010', '', '50', '2', '0', '2', '3');
799 INSERT INTO `0_gl_trans` VALUES ('82', '11', '3', '2009-06-21', '1200', '', '-52.5', '0', '0', '2', '3');
800 INSERT INTO `0_gl_trans` VALUES ('83', '11', '3', '2009-06-21', '2150', '', '2.5', '0', '0', '2', '3');
803 ### Structure of table `0_grn_batch` ###
805 DROP TABLE IF EXISTS `0_grn_batch`;
807 CREATE TABLE `0_grn_batch` (
808 `id` int(11) NOT NULL auto_increment,
809 `supplier_id` int(11) NOT NULL default '0',
810 `purch_order_no` int(11) default NULL,
811 `reference` varchar(60) NOT NULL default '',
812 `delivery_date` date NOT NULL default '0000-00-00',
813 `loc_code` varchar(5) default NULL,
815 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
818 ### Data of table `0_grn_batch` ###
820 INSERT INTO `0_grn_batch` VALUES ('1', '2', '1', '1', '2009-06-21', 'DEF');
823 ### Structure of table `0_grn_items` ###
825 DROP TABLE IF EXISTS `0_grn_items`;
827 CREATE TABLE `0_grn_items` (
828 `id` int(11) NOT NULL auto_increment,
829 `grn_batch_id` int(11) default NULL,
830 `po_detail_item` int(11) NOT NULL default '0',
831 `item_code` varchar(20) NOT NULL default '',
832 `description` tinytext,
833 `qty_recd` double NOT NULL default '0',
834 `quantity_inv` double NOT NULL default '0',
836 ) TYPE=InnoDB AUTO_INCREMENT=4 ;
839 ### Data of table `0_grn_items` ###
841 INSERT INTO `0_grn_items` VALUES ('1', '1', '1', '102', '17inch VGA Monitor', '100', '100');
842 INSERT INTO `0_grn_items` VALUES ('2', '1', '2', '103', '32MB VGA Card', '100', '100');
843 INSERT INTO `0_grn_items` VALUES ('3', '1', '3', '104', '52x CD Drive', '100', '100');
846 ### Structure of table `0_groups` ###
848 DROP TABLE IF EXISTS `0_groups`;
850 CREATE TABLE `0_groups` (
851 `id` smallint(6) unsigned NOT NULL auto_increment,
852 `description` varchar(60) NOT NULL default '',
853 `inactive` tinyint(1) NOT NULL default '0',
855 UNIQUE KEY `description` (`description`)
856 ) TYPE=MyISAM AUTO_INCREMENT=4 AUTO_INCREMENT=4 ;
859 ### Data of table `0_groups` ###
861 INSERT INTO `0_groups` VALUES ('1', 'Small', '0');
862 INSERT INTO `0_groups` VALUES ('2', 'Medium', '0');
863 INSERT INTO `0_groups` VALUES ('3', 'Large', '0');
866 ### Structure of table `0_item_codes` ###
868 DROP TABLE IF EXISTS `0_item_codes`;
870 CREATE TABLE `0_item_codes` (
871 `id` int(11) unsigned NOT NULL auto_increment,
872 `item_code` varchar(20) NOT NULL,
873 `stock_id` varchar(20) NOT NULL,
874 `description` varchar(200) NOT NULL default '',
875 `category_id` smallint(6) unsigned NOT NULL,
876 `quantity` double NOT NULL default '1',
877 `is_foreign` tinyint(1) NOT NULL default '0',
878 `inactive` tinyint(1) NOT NULL default '0',
880 UNIQUE KEY `stock_id` (`stock_id`,`item_code`)
881 ) TYPE=MyISAM AUTO_INCREMENT=6 ;
884 ### Data of table `0_item_codes` ###
886 INSERT INTO `0_item_codes` VALUES ('1', '102', '102', '17inch VGA Monitor', '1', '1', '0', '0');
887 INSERT INTO `0_item_codes` VALUES ('2', '103', '103', '32MB VGA Card', '1', '1', '0', '0');
888 INSERT INTO `0_item_codes` VALUES ('3', '104', '104', '52x CD Drive', '1', '1', '0', '0');
889 INSERT INTO `0_item_codes` VALUES ('4', '3400', '3400', 'P4 Business System', '3', '1', '0', '0');
890 INSERT INTO `0_item_codes` VALUES ('5', '201', '201', 'Assembly Labour', '4', '1', '0', '0');
893 ### Structure of table `0_item_tax_type_exemptions` ###
895 DROP TABLE IF EXISTS `0_item_tax_type_exemptions`;
897 CREATE TABLE `0_item_tax_type_exemptions` (
898 `item_tax_type_id` int(11) NOT NULL default '0',
899 `tax_type_id` int(11) NOT NULL default '0',
900 PRIMARY KEY (`item_tax_type_id`,`tax_type_id`)
904 ### Data of table `0_item_tax_type_exemptions` ###
908 ### Structure of table `0_item_tax_types` ###
910 DROP TABLE IF EXISTS `0_item_tax_types`;
912 CREATE TABLE `0_item_tax_types` (
913 `id` int(11) NOT NULL auto_increment,
914 `name` varchar(60) NOT NULL default '',
915 `exempt` tinyint(1) NOT NULL default '0',
916 `inactive` tinyint(1) NOT NULL default '0',
918 UNIQUE KEY `name` (`name`)
919 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
922 ### Data of table `0_item_tax_types` ###
924 INSERT INTO `0_item_tax_types` VALUES ('1', 'Regular', '0', '0');
926 ### Structure of table `0_item_units` ###
928 DROP TABLE IF EXISTS `0_item_units`;
930 CREATE TABLE `0_item_units` (
931 `abbr` varchar(20) NOT NULL,
932 `name` varchar(40) NOT NULL,
933 `decimals` tinyint(2) NOT NULL,
934 `inactive` tinyint(1) NOT NULL default '0',
935 PRIMARY KEY (`abbr`),
936 UNIQUE KEY `name` (`name`)
940 ### Data of table `0_item_units` ###
942 INSERT INTO `0_item_units` VALUES ('ea.', 'Each', '0', '0');
943 INSERT INTO `0_item_units` VALUES ('hrs', 'Hours', '1', '0');
946 ### Structure of table `0_loc_stock` ###
948 DROP TABLE IF EXISTS `0_loc_stock`;
950 CREATE TABLE `0_loc_stock` (
951 `loc_code` char(5) NOT NULL default '',
952 `stock_id` char(20) NOT NULL default '',
953 `reorder_level` bigint(20) NOT NULL default '0',
954 PRIMARY KEY (`loc_code`,`stock_id`),
955 KEY `stock_id` (`stock_id`)
959 ### Data of table `0_loc_stock` ###
961 INSERT INTO `0_loc_stock` VALUES ('DEF', '102', '0');
962 INSERT INTO `0_loc_stock` VALUES ('DEF', '103', '0');
963 INSERT INTO `0_loc_stock` VALUES ('DEF', '104', '0');
964 INSERT INTO `0_loc_stock` VALUES ('DEF', '201', '0');
965 INSERT INTO `0_loc_stock` VALUES ('DEF', '3400', '0');
968 ### Structure of table `0_locations` ###
970 DROP TABLE IF EXISTS `0_locations`;
972 CREATE TABLE `0_locations` (
973 `loc_code` varchar(5) NOT NULL default '',
974 `location_name` varchar(60) NOT NULL default '',
975 `delivery_address` tinytext NOT NULL,
976 `phone` varchar(30) NOT NULL default '',
977 `fax` varchar(30) NOT NULL default '',
978 `email` varchar(100) NOT NULL default '',
979 `contact` varchar(30) NOT NULL default '',
980 `inactive` tinyint(1) NOT NULL default '0',
981 PRIMARY KEY (`loc_code`)
985 ### Data of table `0_locations` ###
987 INSERT INTO `0_locations` VALUES ('DEF', 'Default', 'Delivery 1\r\nDelivery 2\r\nDelivery 3', '', '', '', '', '0');
990 ### Structure of table `0_movement_types` ###
992 DROP TABLE IF EXISTS `0_movement_types`;
994 CREATE TABLE `0_movement_types` (
995 `id` int(11) NOT NULL auto_increment,
996 `name` varchar(60) NOT NULL default '',
997 `inactive` tinyint(1) NOT NULL default '0',
999 UNIQUE KEY `name` (`name`)
1000 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
1003 ### Data of table `0_movement_types` ###
1005 INSERT INTO `0_movement_types` VALUES ('1', 'Adjustment', '0');
1008 ### Structure of table `0_payment_terms` ###
1010 DROP TABLE IF EXISTS `0_payment_terms`;
1012 CREATE TABLE `0_payment_terms` (
1013 `terms_indicator` int(11) NOT NULL auto_increment,
1014 `terms` char(80) NOT NULL default '',
1015 `days_before_due` smallint(6) NOT NULL default '0',
1016 `day_in_following_month` smallint(6) NOT NULL default '0',
1017 `inactive` tinyint(1) NOT NULL default '0',
1018 PRIMARY KEY (`terms_indicator`),
1019 UNIQUE KEY `terms` (`terms`)
1020 ) TYPE=MyISAM AUTO_INCREMENT=5 ;
1023 ### Data of table `0_payment_terms` ###
1025 INSERT INTO `0_payment_terms` VALUES ('1', 'Due 15th Of the Following Month', '0', '17', '0');
1026 INSERT INTO `0_payment_terms` VALUES ('2', 'Due By End Of The Following Month', '0', '30', '0');
1027 INSERT INTO `0_payment_terms` VALUES ('3', 'Payment due within 10 days', '10', '0', '0');
1028 INSERT INTO `0_payment_terms` VALUES ('4', 'Cash Only', '1', '0', '0');
1031 ### Structure of table `0_prices` ###
1033 DROP TABLE IF EXISTS `0_prices`;
1035 CREATE TABLE `0_prices` (
1036 `id` int(11) NOT NULL auto_increment,
1037 `stock_id` varchar(20) NOT NULL default '',
1038 `sales_type_id` int(11) NOT NULL default '0',
1039 `curr_abrev` char(3) NOT NULL default '',
1040 `price` double NOT NULL default '0',
1042 UNIQUE KEY `price` (`stock_id`,`sales_type_id`,`curr_abrev`)
1043 ) TYPE=MyISAM AUTO_INCREMENT=5 ;
1046 ### Data of table `0_prices` ###
1048 INSERT INTO `0_prices` VALUES ('1', '3400', '1', 'USD', '100');
1049 INSERT INTO `0_prices` VALUES ('2', '102', '1', 'USD', '50');
1050 INSERT INTO `0_prices` VALUES ('3', '103', '1', 'USD', '55');
1051 INSERT INTO `0_prices` VALUES ('4', '104', '1', 'USD', '60');
1054 ### Structure of table `0_print_profiles` ###
1056 DROP TABLE IF EXISTS `0_print_profiles`;
1058 CREATE TABLE `0_print_profiles` (
1059 `id` smallint(6) unsigned NOT NULL auto_increment,
1060 `profile` varchar(30) NOT NULL,
1061 `report` varchar(5) default NULL,
1062 `printer` tinyint(3) unsigned default NULL,
1064 UNIQUE KEY `profile` (`profile`,`report`)
1065 ) TYPE=MyISAM AUTO_INCREMENT=10 ;
1068 ### Data of table `0_print_profiles` ###
1070 INSERT INTO `0_print_profiles` VALUES ('1', 'Out of office', '', '0');
1071 INSERT INTO `0_print_profiles` VALUES ('2', 'Sales Department', '', '0');
1072 INSERT INTO `0_print_profiles` VALUES ('3', 'Central', '', '2');
1073 INSERT INTO `0_print_profiles` VALUES ('4', 'Sales Department', '104', '2');
1074 INSERT INTO `0_print_profiles` VALUES ('5', 'Sales Department', '105', '2');
1075 INSERT INTO `0_print_profiles` VALUES ('6', 'Sales Department', '107', '2');
1076 INSERT INTO `0_print_profiles` VALUES ('7', 'Sales Department', '109', '2');
1077 INSERT INTO `0_print_profiles` VALUES ('8', 'Sales Department', '110', '2');
1078 INSERT INTO `0_print_profiles` VALUES ('9', 'Sales Department', '201', '2');
1081 ### Structure of table `0_printers` ###
1083 DROP TABLE IF EXISTS `0_printers`;
1085 CREATE TABLE `0_printers` (
1086 `id` tinyint(3) unsigned NOT NULL auto_increment,
1087 `name` varchar(20) NOT NULL,
1088 `description` varchar(60) NOT NULL,
1089 `queue` varchar(20) NOT NULL,
1090 `host` varchar(40) NOT NULL,
1091 `port` smallint(11) unsigned NOT NULL,
1092 `timeout` tinyint(3) unsigned NOT NULL,
1094 UNIQUE KEY `name` (`name`)
1095 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
1098 ### Data of table `0_printers` ###
1100 INSERT INTO `0_printers` VALUES ('1', 'QL500', 'Label printer', 'QL500', 'server', '127', '20');
1101 INSERT INTO `0_printers` VALUES ('2', 'Samsung', 'Main network printer', 'scx4521F', 'server', '515', '5');
1102 INSERT INTO `0_printers` VALUES ('3', 'Local', 'Local print server at user IP', 'lp', '', '515', '10');
1105 ### Structure of table `0_purch_data` ###
1107 DROP TABLE IF EXISTS `0_purch_data`;
1109 CREATE TABLE `0_purch_data` (
1110 `supplier_id` int(11) NOT NULL default '0',
1111 `stock_id` char(20) NOT NULL default '',
1112 `price` double NOT NULL default '0',
1113 `suppliers_uom` char(50) NOT NULL default '',
1114 `conversion_factor` double NOT NULL default '1',
1115 `supplier_description` char(50) NOT NULL default '',
1116 PRIMARY KEY (`supplier_id`,`stock_id`)
1120 ### Data of table `0_purch_data` ###
1122 INSERT INTO `0_purch_data` VALUES ('2', '102', '10', '', '1', '17inch VGA Monitor');
1123 INSERT INTO `0_purch_data` VALUES ('2', '103', '11', '', '1', '32MB VGA Card');
1124 INSERT INTO `0_purch_data` VALUES ('2', '104', '12', '', '1', '52x CD Drive');
1127 ### Structure of table `0_purch_order_details` ###
1129 DROP TABLE IF EXISTS `0_purch_order_details`;
1131 CREATE TABLE `0_purch_order_details` (
1132 `po_detail_item` int(11) NOT NULL auto_increment,
1133 `order_no` int(11) NOT NULL default '0',
1134 `item_code` varchar(20) NOT NULL default '',
1135 `description` tinytext,
1136 `delivery_date` date NOT NULL default '0000-00-00',
1137 `qty_invoiced` double NOT NULL default '0',
1138 `unit_price` double NOT NULL default '0',
1139 `act_price` double NOT NULL default '0',
1140 `std_cost_unit` double NOT NULL default '0',
1141 `quantity_ordered` double NOT NULL default '0',
1142 `quantity_received` double NOT NULL default '0',
1143 PRIMARY KEY (`po_detail_item`)
1144 ) TYPE=InnoDB AUTO_INCREMENT=6 ;
1147 ### Data of table `0_purch_order_details` ###
1149 INSERT INTO `0_purch_order_details` VALUES ('1', '1', '102', '17inch VGA Monitor', '2009-07-01', '100', '10', '10', '10', '100', '100');
1150 INSERT INTO `0_purch_order_details` VALUES ('2', '1', '103', '32MB VGA Card', '2009-07-01', '100', '11', '11', '11', '100', '100');
1151 INSERT INTO `0_purch_order_details` VALUES ('3', '1', '104', '52x CD Drive', '2009-07-01', '100', '12', '12', '12', '100', '100');
1152 INSERT INTO `0_purch_order_details` VALUES ('4', '2', '102', '17inch VGA Monitor', '2009-07-01', '0', '5', '0', '0', '1', '0');
1153 INSERT INTO `0_purch_order_details` VALUES ('5', '2', '103', '32MB VGA Card', '2009-07-01', '0', '5', '0', '0', '1', '0');
1156 ### Structure of table `0_purch_orders` ###
1158 DROP TABLE IF EXISTS `0_purch_orders`;
1160 CREATE TABLE `0_purch_orders` (
1161 `order_no` int(11) NOT NULL auto_increment,
1162 `supplier_id` int(11) NOT NULL default '0',
1163 `comments` tinytext,
1164 `ord_date` date NOT NULL default '0000-00-00',
1165 `reference` tinytext NOT NULL,
1166 `requisition_no` tinytext,
1167 `into_stock_location` varchar(5) NOT NULL default '',
1168 `delivery_address` tinytext NOT NULL,
1169 PRIMARY KEY (`order_no`)
1170 ) TYPE=InnoDB AUTO_INCREMENT=3 ;
1173 ### Data of table `0_purch_orders` ###
1175 INSERT INTO `0_purch_orders` VALUES ('1', '2', '', '2009-06-01', '1', '', 'DEF', 'Delivery 1\r\nDelivery 2\r\nDelivery 3');
1176 INSERT INTO `0_purch_orders` VALUES ('2', '3', '', '2009-06-21', '2', '', 'DEF', 'Delivery 1\r\nDelivery 2\r\nDelivery 3');
1179 ### Structure of table `0_quick_entries` ###
1181 DROP TABLE IF EXISTS `0_quick_entries`;
1183 CREATE TABLE `0_quick_entries` (
1184 `id` smallint(6) unsigned NOT NULL auto_increment,
1185 `type` tinyint(1) NOT NULL default '0',
1186 `description` varchar(60) NOT NULL,
1187 `base_amount` double NOT NULL default '0',
1188 `base_desc` varchar(60) default NULL,
1190 KEY `description` (`description`)
1191 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
1194 ### Data of table `0_quick_entries` ###
1196 INSERT INTO `0_quick_entries` VALUES ('1', '1', 'Maintenance', '0', 'Amount');
1197 INSERT INTO `0_quick_entries` VALUES ('2', '4', 'Phone', '0', 'Amount');
1198 INSERT INTO `0_quick_entries` VALUES ('3', '2', 'Cash Sales', '0', 'Amount');
1201 ### Structure of table `0_quick_entry_lines` ###
1203 DROP TABLE IF EXISTS `0_quick_entry_lines`;
1205 CREATE TABLE `0_quick_entry_lines` (
1206 `id` smallint(6) unsigned NOT NULL auto_increment,
1207 `qid` smallint(6) unsigned NOT NULL,
1208 `amount` double default '0',
1209 `action` varchar(2) NOT NULL,
1210 `dest_id` varchar(11) NOT NULL,
1211 `dimension_id` smallint(6) unsigned default NULL,
1212 `dimension2_id` smallint(6) unsigned default NULL,
1215 ) TYPE=MyISAM AUTO_INCREMENT=8 ;
1218 ### Data of table `0_quick_entry_lines` ###
1220 INSERT INTO `0_quick_entry_lines` VALUES ('1', '1', '0', 't-', '1', '0', '0');
1221 INSERT INTO `0_quick_entry_lines` VALUES ('2', '2', '0', 't-', '1', '0', '0');
1222 INSERT INTO `0_quick_entry_lines` VALUES ('3', '3', '0', 't-', '1', '0', '0');
1223 INSERT INTO `0_quick_entry_lines` VALUES ('4', '3', '0', '=', '4010', '0', '0');
1224 INSERT INTO `0_quick_entry_lines` VALUES ('5', '1', '0', '=', '5765', '0', '0');
1225 INSERT INTO `0_quick_entry_lines` VALUES ('6', '2', '0', '=', '5780', '0', '0');
1228 ### Structure of table `0_recurrent_invoices` ###
1230 DROP TABLE IF EXISTS `0_recurrent_invoices`;
1232 CREATE TABLE `0_recurrent_invoices` (
1233 `id` smallint(6) unsigned NOT NULL auto_increment,
1234 `description` varchar(60) NOT NULL default '',
1235 `order_no` int(11) unsigned NOT NULL,
1236 `debtor_no` int(11) unsigned default NULL,
1237 `group_no` smallint(6) unsigned default NULL,
1238 `days` int(11) NOT NULL default '0',
1239 `monthly` int(11) NOT NULL default '0',
1240 `begin` date NOT NULL default '0000-00-00',
1241 `end` date NOT NULL default '0000-00-00',
1242 `last_sent` date NOT NULL default '0000-00-00',
1244 UNIQUE KEY `description` (`description`)
1245 ) TYPE=InnoDB AUTO_INCREMENT=1 ;
1248 ### Data of table `0_recurrent_invoices` ###
1252 ### Structure of table `0_refs` ###
1254 DROP TABLE IF EXISTS `0_refs`;
1256 CREATE TABLE `0_refs` (
1257 `id` int(11) NOT NULL default '0',
1258 `type` int(11) NOT NULL default '0',
1259 `reference` varchar(100) NOT NULL default '',
1260 PRIMARY KEY (`id`,`type`)
1264 ### Data of table `0_refs` ###
1266 INSERT INTO `0_refs` VALUES ('18', '0', '1');
1267 INSERT INTO `0_refs` VALUES ('19', '0', '2');
1270 ### Structure of table `0_sales_order_details` ###
1272 DROP TABLE IF EXISTS `0_sales_order_details`;
1274 CREATE TABLE `0_sales_order_details` (
1275 `id` int(11) NOT NULL auto_increment,
1276 `order_no` int(11) NOT NULL default '0',
1277 `stk_code` varchar(20) NOT NULL default '',
1278 `description` tinytext,
1279 `qty_sent` double NOT NULL default '0',
1280 `unit_price` double NOT NULL default '0',
1281 `quantity` double NOT NULL default '0',
1282 `discount_percent` double NOT NULL default '0',
1284 ) TYPE=InnoDB AUTO_INCREMENT=6 ;
1287 ### Data of table `0_sales_order_details` ###
1289 INSERT INTO `0_sales_order_details` VALUES ('1', '1', '102', '17inch VGA Monitor', '2', '30.4', '2', '0');
1290 INSERT INTO `0_sales_order_details` VALUES ('2', '2', '102', '17inch VGA Monitor', '1', '50', '1', '0');
1291 INSERT INTO `0_sales_order_details` VALUES ('3', '3', '102', '17inch VGA Monitor', '1', '35.89', '1', '0');
1292 INSERT INTO `0_sales_order_details` VALUES ('4', '4', '102', '17inch VGA Monitor', '0', '21.28', '2', '0');
1293 INSERT INTO `0_sales_order_details` VALUES ('5', '5', '102', '17inch VGA Monitor', '1', '50', '1', '0');
1296 ### Structure of table `0_sales_orders` ###
1298 DROP TABLE IF EXISTS `0_sales_orders`;
1300 CREATE TABLE `0_sales_orders` (
1301 `order_no` int(11) NOT NULL auto_increment,
1302 `version` tinyint(1) unsigned NOT NULL default '0',
1303 `type` tinyint(1) NOT NULL default '0',
1304 `debtor_no` int(11) NOT NULL default '0',
1305 `branch_code` int(11) NOT NULL default '0',
1306 `customer_ref` tinytext NOT NULL,
1307 `comments` tinytext,
1308 `ord_date` date NOT NULL default '0000-00-00',
1309 `order_type` int(11) NOT NULL default '0',
1310 `ship_via` int(11) NOT NULL default '0',
1311 `delivery_address` tinytext NOT NULL,
1312 `contact_phone` varchar(30) default NULL,
1313 `contact_email` varchar(100) default NULL,
1314 `deliver_to` tinytext NOT NULL,
1315 `freight_cost` double NOT NULL default '0',
1316 `from_stk_loc` varchar(5) NOT NULL default '',
1317 `delivery_date` date NOT NULL default '0000-00-00',
1318 PRIMARY KEY (`order_no`)
1319 ) TYPE=InnoDB AUTO_INCREMENT=6 ;
1322 ### Data of table `0_sales_orders` ###
1324 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');
1325 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');
1326 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');
1327 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');
1328 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');
1331 ### Structure of table `0_sales_pos` ###
1333 DROP TABLE IF EXISTS `0_sales_pos`;
1335 CREATE TABLE `0_sales_pos` (
1336 `id` smallint(6) unsigned NOT NULL auto_increment,
1337 `pos_name` varchar(30) NOT NULL,
1338 `cash_sale` tinyint(1) NOT NULL,
1339 `credit_sale` tinyint(1) NOT NULL,
1340 `pos_location` varchar(5) NOT NULL,
1341 `pos_account` smallint(6) unsigned NOT NULL,
1342 `inactive` tinyint(1) NOT NULL default '0',
1344 UNIQUE KEY `pos_name` (`pos_name`)
1345 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
1348 ### Data of table `0_sales_pos` ###
1350 INSERT INTO `0_sales_pos` VALUES ('1', 'Default', '1', '1', 'DEF', '2', '0');
1353 ### Structure of table `0_sales_types` ###
1355 DROP TABLE IF EXISTS `0_sales_types`;
1357 CREATE TABLE `0_sales_types` (
1358 `id` int(11) NOT NULL auto_increment,
1359 `sales_type` char(50) NOT NULL default '',
1360 `tax_included` int(1) NOT NULL default '0',
1361 `factor` double NOT NULL default '1',
1362 `inactive` tinyint(1) NOT NULL default '0',
1364 UNIQUE KEY `sales_type` (`sales_type`)
1365 ) TYPE=MyISAM AUTO_INCREMENT=3 ;
1368 ### Data of table `0_sales_types` ###
1370 INSERT INTO `0_sales_types` VALUES ('1', 'Retail', '1', '1', '0');
1371 INSERT INTO `0_sales_types` VALUES ('2', 'Wholesale', '0', '0.7', '0');
1374 ### Structure of table `0_salesman` ###
1376 DROP TABLE IF EXISTS `0_salesman`;
1378 CREATE TABLE `0_salesman` (
1379 `salesman_code` int(11) NOT NULL auto_increment,
1380 `salesman_name` char(60) NOT NULL default '',
1381 `salesman_phone` char(30) NOT NULL default '',
1382 `salesman_fax` char(30) NOT NULL default '',
1383 `salesman_email` varchar(100) NOT NULL default '',
1384 `provision` double NOT NULL default '0',
1385 `break_pt` double NOT NULL default '0',
1386 `provision2` double NOT NULL default '0',
1387 `inactive` tinyint(1) NOT NULL default '0',
1388 PRIMARY KEY (`salesman_code`),
1389 UNIQUE KEY `salesman_name` (`salesman_name`)
1390 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
1393 ### Data of table `0_salesman` ###
1395 INSERT INTO `0_salesman` VALUES ('1', 'Sales Person', '', '', '', '5', '1000', '4', '0');
1398 ### Structure of table `0_shippers` ###
1400 DROP TABLE IF EXISTS `0_shippers`;
1402 CREATE TABLE `0_shippers` (
1403 `shipper_id` int(11) NOT NULL auto_increment,
1404 `shipper_name` varchar(60) NOT NULL default '',
1405 `phone` varchar(30) NOT NULL default '',
1406 `contact` tinytext NOT NULL,
1407 `address` tinytext NOT NULL,
1408 `inactive` tinyint(1) NOT NULL default '0',
1409 PRIMARY KEY (`shipper_id`),
1410 UNIQUE KEY `name` (`shipper_name`)
1411 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
1414 ### Data of table `0_shippers` ###
1416 INSERT INTO `0_shippers` VALUES ('1', 'Default', '', '', '', '0');
1419 ### Structure of table `0_sql_trail` ###
1421 DROP TABLE IF EXISTS `0_sql_trail`;
1423 CREATE TABLE `0_sql_trail` (
1424 `id` int(11) unsigned NOT NULL auto_increment,
1425 `sql` text NOT NULL,
1426 `result` tinyint(1) NOT NULL,
1427 `msg` varchar(255) NOT NULL,
1429 ) TYPE=MyISAM AUTO_INCREMENT=1 ;
1432 ### Data of table `0_sql_trail` ###
1436 ### Structure of table `0_stock_category` ###
1438 DROP TABLE IF EXISTS `0_stock_category`;
1440 CREATE TABLE `0_stock_category` (
1441 `category_id` int(11) NOT NULL auto_increment,
1442 `description` varchar(60) NOT NULL default '',
1443 `dflt_tax_type` int(11) NOT NULL default '1',
1444 `dflt_units` varchar(20) NOT NULL default 'each',
1445 `dflt_mb_flag` char(1) NOT NULL default 'B',
1446 `dflt_sales_act` varchar(11) NOT NULL default '',
1447 `dflt_cogs_act` varchar(11) NOT NULL default '',
1448 `dflt_inventory_act` varchar(11) NOT NULL default '',
1449 `dflt_adjustment_act` varchar(11) NOT NULL default '',
1450 `dflt_assembly_act` varchar(11) NOT NULL default '',
1451 `dflt_dim1` int(11) default NULL,
1452 `dflt_dim2` int(11) default NULL,
1453 `inactive` tinyint(1) NOT NULL default '0',
1454 `dflt_no_sale` tinyint(1) NOT NULL default '0',
1455 PRIMARY KEY (`category_id`),
1456 UNIQUE KEY `description` (`description`)
1457 ) TYPE=MyISAM AUTO_INCREMENT=5 ;
1459 ### Data of table `0_stock_category` ###
1461 INSERT INTO `0_stock_category` VALUES ('1', 'Components', '1', 'each', 'B', '4010', '1510', '5010', '5040', '1530', '0', '0', '0', '0');
1462 INSERT INTO `0_stock_category` VALUES ('2', 'Charges', '1', 'each', 'D', '4010', '1510', '5010', '5040', '1530', '0', '0', '0', '0');
1463 INSERT INTO `0_stock_category` VALUES ('3', 'Systems', '1', 'each', 'M', '4010', '1510', '5010', '5040', '1530', '0', '0', '0', '0');
1464 INSERT INTO `0_stock_category` VALUES ('4', 'Services', '1', 'hrs', 'D', '4010', '1510', '5010', '5040', '1530', '0', '0', '0', '0');
1467 ### Structure of table `0_stock_master` ###
1469 DROP TABLE IF EXISTS `0_stock_master`;
1471 CREATE TABLE `0_stock_master` (
1472 `stock_id` varchar(20) NOT NULL default '',
1473 `category_id` int(11) NOT NULL default '0',
1474 `tax_type_id` int(11) NOT NULL default '0',
1475 `description` varchar(200) NOT NULL default '',
1476 `long_description` tinytext NOT NULL,
1477 `units` varchar(20) NOT NULL default 'each',
1478 `mb_flag` char(1) NOT NULL default 'B',
1479 `sales_account` varchar(11) NOT NULL default '',
1480 `cogs_account` varchar(11) NOT NULL default '',
1481 `inventory_account` varchar(11) NOT NULL default '',
1482 `adjustment_account` varchar(11) NOT NULL default '',
1483 `assembly_account` varchar(11) NOT NULL default '',
1484 `dimension_id` int(11) default NULL,
1485 `dimension2_id` int(11) default NULL,
1486 `actual_cost` double NOT NULL default '0',
1487 `last_cost` double NOT NULL default '0',
1488 `material_cost` double NOT NULL default '0',
1489 `labour_cost` double NOT NULL default '0',
1490 `overhead_cost` double NOT NULL default '0',
1491 `inactive` tinyint(1) NOT NULL default '0',
1492 `no_sale` tinyint(1) NOT NULL default '0',
1493 PRIMARY KEY (`stock_id`)
1497 ### Data of table `0_stock_master` ###
1499 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', '0');
1500 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', '0');
1501 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', '0');
1502 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', '0');
1503 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', '0');
1506 ### Structure of table `0_stock_moves` ###
1508 DROP TABLE IF EXISTS `0_stock_moves`;
1510 CREATE TABLE `0_stock_moves` (
1511 `trans_id` int(11) NOT NULL auto_increment,
1512 `trans_no` int(11) NOT NULL default '0',
1513 `stock_id` char(20) NOT NULL default '',
1514 `type` smallint(6) NOT NULL default '0',
1515 `loc_code` char(5) NOT NULL default '',
1516 `tran_date` date NOT NULL default '0000-00-00',
1517 `person_id` int(11) default NULL,
1518 `price` double NOT NULL default '0',
1519 `reference` char(40) NOT NULL default '',
1520 `qty` double NOT NULL default '1',
1521 `discount_percent` double NOT NULL default '0',
1522 `standard_cost` double NOT NULL default '0',
1523 `visible` tinyint(1) NOT NULL default '1',
1524 PRIMARY KEY (`trans_id`),
1525 KEY `type` (`type`,`trans_no`)
1526 ) TYPE=InnoDB AUTO_INCREMENT=37 ;
1529 ### Data of table `0_stock_moves` ###
1531 INSERT INTO `0_stock_moves` VALUES ('1', '1', '102', '25', 'DEF', '2009-06-21', '2', '10', '', '100', '0', '10', '1');
1532 INSERT INTO `0_stock_moves` VALUES ('2', '1', '103', '25', 'DEF', '2009-06-21', '2', '11', '', '100', '0', '11', '1');
1533 INSERT INTO `0_stock_moves` VALUES ('3', '1', '104', '25', 'DEF', '2009-06-21', '2', '12', '', '100', '0', '12', '1');
1534 INSERT INTO `0_stock_moves` VALUES ('4', '1', '102', '26', 'DEF', '2009-06-21', '0', '0', '1', '-10', '0', '0', '1');
1535 INSERT INTO `0_stock_moves` VALUES ('5', '1', '103', '26', 'DEF', '2009-06-21', '0', '0', '1', '-10', '0', '0', '1');
1536 INSERT INTO `0_stock_moves` VALUES ('6', '1', '104', '26', 'DEF', '2009-06-21', '0', '0', '1', '-10', '0', '0', '1');
1537 INSERT INTO `0_stock_moves` VALUES ('7', '1', '3400', '26', 'DEF', '2009-06-21', '0', '0', '1', '10', '0', '0', '1');
1538 INSERT INTO `0_stock_moves` VALUES ('8', '2', '102', '13', 'DEF', '2009-06-21', '0', '30.4', '1', '-2', '0', '10', '1');
1539 INSERT INTO `0_stock_moves` VALUES ('9', '3', '102', '13', 'DEF', '2009-06-21', '0', '50', 'auto', '-1', '0', '10', '1');
1540 INSERT INTO `0_stock_moves` VALUES ('10', '4', '102', '13', 'DEF', '2009-06-21', '0', '35.89', 'auto', '-1', '0', '10', '1');
1541 INSERT INTO `0_stock_moves` VALUES ('11', '3', '102', '26', 'DEF', '2009-06-21', '0', '0', '3', '-2', '0', '0', '1');
1542 INSERT INTO `0_stock_moves` VALUES ('12', '3', '103', '26', 'DEF', '2009-06-21', '0', '0', '3', '-2', '0', '0', '1');
1543 INSERT INTO `0_stock_moves` VALUES ('13', '3', '104', '26', 'DEF', '2009-06-21', '0', '0', '3', '-2', '0', '0', '1');
1544 INSERT INTO `0_stock_moves` VALUES ('14', '3', '3400', '26', 'DEF', '2009-06-21', '0', '0', '3', '2', '0', '0', '1');
1545 INSERT INTO `0_stock_moves` VALUES ('15', '4', '102', '26', 'DEF', '2009-06-21', '0', '0', '4', '-4', '0', '0', '1');
1546 INSERT INTO `0_stock_moves` VALUES ('16', '4', '103', '26', 'DEF', '2009-06-21', '0', '0', '4', '-4', '0', '0', '1');
1547 INSERT INTO `0_stock_moves` VALUES ('17', '4', '104', '26', 'DEF', '2009-06-21', '0', '0', '4', '-4', '0', '0', '1');
1548 INSERT INTO `0_stock_moves` VALUES ('18', '4', '3400', '26', 'DEF', '2009-06-21', '0', '0', '4', '4', '0', '0', '1');
1549 INSERT INTO `0_stock_moves` VALUES ('19', '2', '102', '26', 'DEF', '2009-06-21', '0', '0', '', '-2', '0', '0', '1');
1550 INSERT INTO `0_stock_moves` VALUES ('20', '2', '103', '26', 'DEF', '2009-06-21', '0', '0', '', '-2', '0', '0', '1');
1551 INSERT INTO `0_stock_moves` VALUES ('21', '2', '104', '26', 'DEF', '2009-06-21', '0', '0', '', '-2', '0', '0', '1');
1552 INSERT INTO `0_stock_moves` VALUES ('22', '1', '3400', '29', 'DEF', '2009-06-21', '0', '0', '', '2', '0', '0', '1');
1553 INSERT INTO `0_stock_moves` VALUES ('23', '5', '102', '26', 'DEF', '2009-06-21', '0', '0', '5', '-5', '0', '0', '1');
1554 INSERT INTO `0_stock_moves` VALUES ('24', '5', '103', '26', 'DEF', '2009-06-21', '0', '0', '5', '-5', '0', '0', '1');
1555 INSERT INTO `0_stock_moves` VALUES ('25', '5', '104', '26', 'DEF', '2009-06-21', '0', '0', '5', '-5', '0', '0', '1');
1556 INSERT INTO `0_stock_moves` VALUES ('26', '5', '3400', '26', 'DEF', '2009-06-21', '0', '0', '5', '5', '0', '0', '1');
1557 INSERT INTO `0_stock_moves` VALUES ('27', '6', '102', '26', 'DEF', '2009-06-21', '0', '0', '6', '5', '0', '0', '1');
1558 INSERT INTO `0_stock_moves` VALUES ('28', '6', '103', '26', 'DEF', '2009-06-21', '0', '0', '6', '5', '0', '0', '1');
1559 INSERT INTO `0_stock_moves` VALUES ('29', '6', '104', '26', 'DEF', '2009-06-21', '0', '0', '6', '5', '0', '0', '1');
1560 INSERT INTO `0_stock_moves` VALUES ('30', '6', '3400', '26', 'DEF', '2009-06-21', '0', '0', '6', '-5', '0', '0', '1');
1561 INSERT INTO `0_stock_moves` VALUES ('31', '7', '102', '26', 'DEF', '2009-06-21', '0', '0', '7', '2', '0', '0', '1');
1562 INSERT INTO `0_stock_moves` VALUES ('32', '7', '103', '26', 'DEF', '2009-06-21', '0', '0', '7', '2', '0', '0', '1');
1563 INSERT INTO `0_stock_moves` VALUES ('33', '7', '104', '26', 'DEF', '2009-06-21', '0', '0', '7', '2', '0', '0', '1');
1564 INSERT INTO `0_stock_moves` VALUES ('34', '7', '3400', '26', 'DEF', '2009-06-21', '0', '0', '7', '-2', '0', '0', '1');
1565 INSERT INTO `0_stock_moves` VALUES ('35', '5', '102', '13', 'DEF', '2009-06-21', '0', '50', 'auto', '-1', '0', '10', '1');
1566 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');
1569 ### Structure of table `0_supp_allocations` ###
1571 DROP TABLE IF EXISTS `0_supp_allocations`;
1573 CREATE TABLE `0_supp_allocations` (
1574 `id` int(11) NOT NULL auto_increment,
1575 `amt` double unsigned default NULL,
1576 `date_alloc` date NOT NULL default '0000-00-00',
1577 `trans_no_from` int(11) default NULL,
1578 `trans_type_from` int(11) default NULL,
1579 `trans_no_to` int(11) default NULL,
1580 `trans_type_to` int(11) default NULL,
1582 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
1585 ### Data of table `0_supp_allocations` ###
1587 INSERT INTO `0_supp_allocations` VALUES ('1', '3465', '2009-06-21', '4', '22', '7', '20');
1590 ### Structure of table `0_supp_invoice_items` ###
1592 DROP TABLE IF EXISTS `0_supp_invoice_items`;
1594 CREATE TABLE `0_supp_invoice_items` (
1595 `id` int(11) NOT NULL auto_increment,
1596 `supp_trans_no` int(11) default NULL,
1597 `supp_trans_type` int(11) default NULL,
1598 `gl_code` varchar(11) NOT NULL default '0',
1599 `grn_item_id` int(11) default NULL,
1600 `po_detail_item_id` int(11) default NULL,
1601 `stock_id` varchar(20) NOT NULL default '',
1602 `description` tinytext,
1603 `quantity` double NOT NULL default '0',
1604 `unit_price` double NOT NULL default '0',
1605 `unit_tax` double NOT NULL default '0',
1608 ) TYPE=InnoDB AUTO_INCREMENT=6 ;
1611 ### Data of table `0_supp_invoice_items` ###
1613 INSERT INTO `0_supp_invoice_items` VALUES ('1', '7', '20', '0', '1', '1', '102', '17inch VGA Monitor', '100', '10', '0.5', '');
1614 INSERT INTO `0_supp_invoice_items` VALUES ('2', '7', '20', '0', '2', '2', '103', '32MB VGA Card', '100', '11', '0.55', '');
1615 INSERT INTO `0_supp_invoice_items` VALUES ('3', '7', '20', '0', '3', '3', '104', '52x CD Drive', '100', '12', '0.6', '');
1616 INSERT INTO `0_supp_invoice_items` VALUES ('4', '8', '20', '2150', '0', '0', '', '', '0', '0.95', '0', 'Phone');
1617 INSERT INTO `0_supp_invoice_items` VALUES ('5', '8', '20', '5780', '0', '0', '', '', '0', '19.05', '0', 'Phone');
1620 ### Structure of table `0_supp_trans` ###
1622 DROP TABLE IF EXISTS `0_supp_trans`;
1624 CREATE TABLE `0_supp_trans` (
1625 `trans_no` int(11) unsigned NOT NULL default '0',
1626 `type` smallint(6) unsigned NOT NULL default '0',
1627 `supplier_id` int(11) unsigned default NULL,
1628 `reference` tinytext NOT NULL,
1629 `supp_reference` varchar(60) NOT NULL default '',
1630 `tran_date` date NOT NULL default '0000-00-00',
1631 `due_date` date NOT NULL default '0000-00-00',
1632 `ov_amount` double NOT NULL default '0',
1633 `ov_discount` double NOT NULL default '0',
1634 `ov_gst` double NOT NULL default '0',
1635 `rate` double NOT NULL default '1',
1636 `alloc` double NOT NULL default '0',
1637 PRIMARY KEY (`trans_no`,`type`),
1638 KEY `supplier_id` (`supplier_id`),
1639 KEY `SupplierID_2` (`supplier_id`,`supp_reference`),
1644 ### Data of table `0_supp_trans` ###
1646 INSERT INTO `0_supp_trans` VALUES ('4', '22', '2', '1', '', '2009-06-21', '2009-06-21', '-3465', '0', '0', '1', '3465');
1647 INSERT INTO `0_supp_trans` VALUES ('7', '20', '2', '1', '5t', '2009-06-21', '2009-07-01', '3300', '0', '165', '1', '3465');
1648 INSERT INTO `0_supp_trans` VALUES ('8', '20', '2', '2', 'cc', '2009-06-21', '2009-07-01', '20', '0', '0', '1', '0');
1651 ### Structure of table `0_suppliers` ###
1653 DROP TABLE IF EXISTS `0_suppliers`;
1655 CREATE TABLE `0_suppliers` (
1656 `supplier_id` int(11) NOT NULL auto_increment,
1657 `supp_name` varchar(60) NOT NULL default '',
1658 `address` tinytext NOT NULL,
1659 `supp_address` tinytext NOT NULL,
1660 `phone` varchar(30) NOT NULL default '',
1661 `fax` varchar(30) NOT NULL default '',
1662 `gst_no` varchar(25) NOT NULL default '',
1663 `contact` varchar(60) NOT NULL default '',
1664 `supp_account_no` varchar(40) NOT NULL default '',
1665 `email` varchar(100) NOT NULL default '',
1666 `website` varchar(100) NOT NULL default '',
1667 `bank_account` varchar(60) NOT NULL default '',
1668 `curr_code` char(3) default NULL,
1669 `payment_terms` int(11) default NULL,
1670 `dimension_id` int(11) default '0',
1671 `dimension2_id` int(11) default '0',
1672 `tax_group_id` int(11) default NULL,
1673 `credit_limit` double NOT NULL default '0',
1674 `purchase_account` varchar(11) default NULL,
1675 `payable_account` varchar(11) default NULL,
1676 `payment_discount_account` varchar(11) default NULL,
1677 `notes` tinytext NOT NULL,
1678 `inactive` tinyint(1) NOT NULL default '0',
1679 PRIMARY KEY (`supplier_id`)
1680 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
1683 ### Data of table `0_suppliers` ###
1685 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');
1686 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');
1687 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');
1690 ### Structure of table `0_sys_types` ###
1692 DROP TABLE IF EXISTS `0_sys_types`;
1694 CREATE TABLE `0_sys_types` (
1695 `type_id` smallint(6) NOT NULL default '0',
1696 `type_name` varchar(60) NOT NULL default '',
1697 `type_no` int(11) NOT NULL default '1',
1698 `next_reference` varchar(100) NOT NULL default '',
1699 PRIMARY KEY (`type_id`)
1703 ### Data of table `0_sys_types` ###
1705 INSERT INTO `0_sys_types` VALUES ('0', 'Journal - GL', '19', '3');
1706 INSERT INTO `0_sys_types` VALUES ('1', 'Payment - GL', '8', '2');
1707 INSERT INTO `0_sys_types` VALUES ('2', 'Receipt - GL', '5', '2');
1708 INSERT INTO `0_sys_types` VALUES ('4', 'Funds Transfer', '3', '1');
1709 INSERT INTO `0_sys_types` VALUES ('10', 'Sales Invoice', '19', '4');
1710 INSERT INTO `0_sys_types` VALUES ('11', 'Credit Note', '3', '2');
1711 INSERT INTO `0_sys_types` VALUES ('12', 'Receipt', '6', '1');
1712 INSERT INTO `0_sys_types` VALUES ('13', 'Delivery', '5', '2');
1713 INSERT INTO `0_sys_types` VALUES ('16', 'Location Transfer', '2', '1');
1714 INSERT INTO `0_sys_types` VALUES ('17', 'Inventory Adjustment', '2', '1');
1715 INSERT INTO `0_sys_types` VALUES ('18', 'Purchase Order', '1', '3');
1716 INSERT INTO `0_sys_types` VALUES ('20', 'Supplier Invoice', '8', '3');
1717 INSERT INTO `0_sys_types` VALUES ('21', 'Supplier Credit Note', '1', '1');
1718 INSERT INTO `0_sys_types` VALUES ('22', 'Supplier Payment', '4', '2');
1719 INSERT INTO `0_sys_types` VALUES ('25', 'Purchase Order Delivery', '1', '2');
1720 INSERT INTO `0_sys_types` VALUES ('26', 'Work Order', '1', '8');
1721 INSERT INTO `0_sys_types` VALUES ('28', 'Work Order Issue', '1', '1');
1722 INSERT INTO `0_sys_types` VALUES ('29', 'Work Order Production', '1', '2');
1723 INSERT INTO `0_sys_types` VALUES ('30', 'Sales Order', '1', '1');
1724 INSERT INTO `0_sys_types` VALUES ('35', 'Cost Update', '1', '1');
1725 INSERT INTO `0_sys_types` VALUES ('40', 'Dimension', '1', '3');
1728 ### Structure of table `0_tax_group_items` ###
1730 DROP TABLE IF EXISTS `0_tax_group_items`;
1732 CREATE TABLE `0_tax_group_items` (
1733 `tax_group_id` int(11) NOT NULL default '0',
1734 `tax_type_id` int(11) NOT NULL default '0',
1735 `rate` double NOT NULL default '0',
1736 PRIMARY KEY (`tax_group_id`,`tax_type_id`)
1740 ### Data of table `0_tax_group_items` ###
1742 INSERT INTO `0_tax_group_items` VALUES ('1', '1', '5');
1745 ### Structure of table `0_tax_groups` ###
1747 DROP TABLE IF EXISTS `0_tax_groups`;
1749 CREATE TABLE `0_tax_groups` (
1750 `id` int(11) NOT NULL auto_increment,
1751 `name` varchar(60) NOT NULL default '',
1752 `tax_shipping` tinyint(1) NOT NULL default '0',
1753 `inactive` tinyint(1) NOT NULL default '0',
1755 UNIQUE KEY `name` (`name`)
1756 ) TYPE=InnoDB AUTO_INCREMENT=3 ;
1759 ### Data of table `0_tax_groups` ###
1761 INSERT INTO `0_tax_groups` VALUES ('1', 'Tax', '0', '0');
1762 INSERT INTO `0_tax_groups` VALUES ('2', 'Tax Exempt', '0', '0');
1764 ### Structure of table `0_tax_types` ###
1766 DROP TABLE IF EXISTS `0_tax_types`;
1768 CREATE TABLE `0_tax_types` (
1769 `id` int(11) NOT NULL auto_increment,
1770 `rate` double NOT NULL default '0',
1771 `sales_gl_code` varchar(11) NOT NULL default '',
1772 `purchasing_gl_code` varchar(11) NOT NULL default '',
1773 `name` varchar(60) NOT NULL default '',
1774 `inactive` tinyint(1) NOT NULL default '0',
1776 ) TYPE=InnoDB AUTO_INCREMENT=5 AUTO_INCREMENT=5 ;
1779 ### Data of table `0_tax_types` ###
1781 INSERT INTO `0_tax_types` VALUES ('1', '5', '2150', '2150', 'Tax', '0');
1783 ### Structure of table `0_trans_tax_details` ###
1785 DROP TABLE IF EXISTS `0_trans_tax_details`;
1787 CREATE TABLE `0_trans_tax_details` (
1788 `id` int(11) NOT NULL auto_increment,
1789 `trans_type` smallint(6) default NULL,
1790 `trans_no` int(11) default NULL,
1791 `tran_date` date NOT NULL,
1792 `tax_type_id` int(11) NOT NULL default '0',
1793 `rate` double NOT NULL default '0',
1794 `ex_rate` double NOT NULL default '1',
1795 `included_in_price` tinyint(1) NOT NULL default '0',
1796 `net_amount` double NOT NULL default '0',
1797 `amount` double NOT NULL default '0',
1800 ) TYPE=InnoDB AUTO_INCREMENT=12 ;
1803 ### Data of table `0_trans_tax_details` ###
1805 INSERT INTO `0_trans_tax_details` VALUES ('1', '20', '7', '2009-06-21', '1', '5', '1', '0', '3300', '165', '5t');
1806 INSERT INTO `0_trans_tax_details` VALUES ('2', '13', '3', '2009-06-21', '1', '5', '1', '0', '50', '2.5', 'auto');
1807 INSERT INTO `0_trans_tax_details` VALUES ('3', '10', '17', '2009-06-21', '1', '5', '1', '0', '50', '2.5', '1');
1808 INSERT INTO `0_trans_tax_details` VALUES ('4', '13', '4', '2009-06-21', '1', '5', '1.3932', '0', '35.89', '1.7945', 'auto');
1809 INSERT INTO `0_trans_tax_details` VALUES ('5', '10', '18', '2009-06-21', '1', '5', '1.3932', '0', '35.89', '1.7945', '2');
1810 INSERT INTO `0_trans_tax_details` VALUES ('6', '2', '5', '2009-06-21', '1', '5', '1', '0', '95.2', '4.76', '');
1811 INSERT INTO `0_trans_tax_details` VALUES ('7', '1', '8', '2009-06-21', '1', '5', '1', '0', '-47.6', '-2.38', '');
1812 INSERT INTO `0_trans_tax_details` VALUES ('8', '20', '8', '2009-06-21', '1', '5', '1', '0', '-19', '-0.95', 'cc');
1813 INSERT INTO `0_trans_tax_details` VALUES ('9', '13', '5', '2009-06-21', '1', '5', '1', '1', '47.619047619048', '2.3809523809524', 'auto');
1814 INSERT INTO `0_trans_tax_details` VALUES ('10', '10', '19', '2009-06-21', '1', '5', '1', '1', '47.619047619048', '2.3809523809524', '3');
1815 INSERT INTO `0_trans_tax_details` VALUES ('11', '11', '3', '2009-06-21', '1', '5', '1.3932', '0', '35.89', '1.7945', '1');
1817 ### Structure of table `0_users` ###
1819 DROP TABLE IF EXISTS `0_users`;
1821 CREATE TABLE `0_users` (
1822 `id` SMALLINT(6) AUTO_INCREMENT,
1823 `user_id` varchar(60) NOT NULL default '',
1824 `password` varchar(100) NOT NULL default '',
1825 `real_name` varchar(100) NOT NULL default '',
1826 `full_access` int(11) NOT NULL default '1',
1827 `phone` varchar(30) NOT NULL default '',
1828 `email` varchar(100) default NULL,
1829 `language` varchar(20) default NULL,
1830 `date_format` tinyint(1) NOT NULL default '0',
1831 `date_sep` tinyint(1) NOT NULL default '0',
1832 `tho_sep` tinyint(1) NOT NULL default '0',
1833 `dec_sep` tinyint(1) NOT NULL default '0',
1834 `theme` varchar(20) NOT NULL default 'default',
1835 `page_size` varchar(20) NOT NULL default 'A4',
1836 `prices_dec` smallint(6) NOT NULL default '2',
1837 `qty_dec` smallint(6) NOT NULL default '2',
1838 `rates_dec` smallint(6) NOT NULL default '4',
1839 `percent_dec` smallint(6) NOT NULL default '1',
1840 `show_gl` tinyint(1) NOT NULL default '1',
1841 `show_codes` tinyint(1) NOT NULL default '0',
1842 `show_hints` tinyint(1) NOT NULL default '0',
1843 `last_visit_date` datetime default NULL,
1844 `query_size` tinyint(1) default '10',
1845 `graphic_links` tinyint(1) default '1',
1846 `pos` smallint(6) default '1',
1847 `print_profile` varchar(30) NOT NULL default '1',
1848 `rep_popup` tinyint(1) default '1',
1849 `sticky_doc_date` tinyint(1) default '0',
1850 `inactive` tinyint(1) NOT NULL default '0',
1852 UNIQUE KEY (`user_id`)
1853 ) TYPE=MyISAM AUTO_INCREMENT=2;
1856 ### Data of table `0_users` ###
1858 INSERT INTO `0_users` VALUES ('1', 'admin', '5f4dcc3b5aa765d61d8327deb882cf99', 'Administrator', '2', '', 'adm@adm.com', 'en_US', '0', '0', '0', '0', 'default', 'Letter', '2', '2', '4', '1', '1', '0', '0', '2009-01-30 09:39:03', '10', '1', '1', '1', '1', '0', '0');
1859 INSERT INTO `0_users` VALUES ('2', 'demouser', '5f4dcc3b5aa765d61d8327deb882cf99', 'Demo User', '1', '999-999-999', 'demo@demo.nu', 'en_US', '0', '0', '0', '0', 'default', 'Letter', '2', '2', '3', '1', '1', '0', '0', '2008-02-06 19:02:35', '10', '1', '1', '1', '1', '0', '0');
1861 ### Structure of table `0_voided` ###
1863 DROP TABLE IF EXISTS `0_voided`;
1865 CREATE TABLE `0_voided` (
1866 `type` int(11) NOT NULL default '0',
1867 `id` int(11) NOT NULL default '0',
1868 `date_` date NOT NULL default '0000-00-00',
1869 `memo_` tinytext NOT NULL,
1870 UNIQUE KEY `id` (`type`,`id`)
1874 ### Data of table `0_voided` ###
1878 ### Structure of table `0_wo_issue_items` ###
1880 DROP TABLE IF EXISTS `0_wo_issue_items`;
1882 CREATE TABLE `0_wo_issue_items` (
1883 `id` int(11) NOT NULL auto_increment,
1884 `stock_id` varchar(40) default NULL,
1885 `issue_id` int(11) default NULL,
1886 `qty_issued` double default NULL,
1888 ) TYPE=InnoDB AUTO_INCREMENT=1 ;
1891 ### Data of table `0_wo_issue_items` ###
1895 ### Structure of table `0_wo_issues` ###
1897 DROP TABLE IF EXISTS `0_wo_issues`;
1899 CREATE TABLE `0_wo_issues` (
1900 `issue_no` int(11) NOT NULL auto_increment,
1901 `workorder_id` int(11) NOT NULL default '0',
1902 `reference` varchar(100) default NULL,
1903 `issue_date` date default NULL,
1904 `loc_code` varchar(5) default NULL,
1905 `workcentre_id` int(11) default NULL,
1906 PRIMARY KEY (`issue_no`)
1907 ) TYPE=InnoDB AUTO_INCREMENT=1 ;
1910 ### Data of table `0_wo_issues` ###
1914 ### Structure of table `0_wo_manufacture` ###
1916 DROP TABLE IF EXISTS `0_wo_manufacture`;
1918 CREATE TABLE `0_wo_manufacture` (
1919 `id` int(11) NOT NULL auto_increment,
1920 `reference` varchar(100) default NULL,
1921 `workorder_id` int(11) NOT NULL default '0',
1922 `quantity` double NOT NULL default '0',
1923 `date_` date NOT NULL default '0000-00-00',
1925 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
1928 ### Data of table `0_wo_manufacture` ###
1930 INSERT INTO `0_wo_manufacture` VALUES ('1', '1', '2', '2', '2009-06-21');
1933 ### Structure of table `0_wo_requirements` ###
1935 DROP TABLE IF EXISTS `0_wo_requirements`;
1937 CREATE TABLE `0_wo_requirements` (
1938 `id` int(11) NOT NULL auto_increment,
1939 `workorder_id` int(11) NOT NULL default '0',
1940 `stock_id` char(20) NOT NULL default '',
1941 `workcentre` int(11) NOT NULL default '0',
1942 `units_req` double NOT NULL default '1',
1943 `std_cost` double NOT NULL default '0',
1944 `loc_code` char(5) NOT NULL default '',
1945 `units_issued` double NOT NULL default '0',
1947 ) TYPE=InnoDB AUTO_INCREMENT=22 ;
1950 ### Data of table `0_wo_requirements` ###
1952 INSERT INTO `0_wo_requirements` VALUES ('1', '1', '102', '1', '1', '0', 'DEF', '10');
1953 INSERT INTO `0_wo_requirements` VALUES ('2', '1', '103', '1', '1', '0', 'DEF', '10');
1954 INSERT INTO `0_wo_requirements` VALUES ('3', '1', '104', '1', '1', '0', 'DEF', '10');
1955 INSERT INTO `0_wo_requirements` VALUES ('4', '2', '102', '1', '1', '0', 'DEF', '0');
1956 INSERT INTO `0_wo_requirements` VALUES ('5', '2', '103', '1', '1', '0', 'DEF', '0');
1957 INSERT INTO `0_wo_requirements` VALUES ('6', '2', '104', '1', '1', '0', 'DEF', '0');
1958 INSERT INTO `0_wo_requirements` VALUES ('7', '3', '102', '1', '1', '0', 'DEF', '2');
1959 INSERT INTO `0_wo_requirements` VALUES ('8', '3', '103', '1', '1', '0', 'DEF', '2');
1960 INSERT INTO `0_wo_requirements` VALUES ('9', '3', '104', '1', '1', '0', 'DEF', '2');
1961 INSERT INTO `0_wo_requirements` VALUES ('10', '4', '102', '1', '1', '0', 'DEF', '4');
1962 INSERT INTO `0_wo_requirements` VALUES ('11', '4', '103', '1', '1', '0', 'DEF', '4');
1963 INSERT INTO `0_wo_requirements` VALUES ('12', '4', '104', '1', '1', '0', 'DEF', '4');
1964 INSERT INTO `0_wo_requirements` VALUES ('13', '5', '102', '1', '1', '0', 'DEF', '5');
1965 INSERT INTO `0_wo_requirements` VALUES ('14', '5', '103', '1', '1', '0', 'DEF', '5');
1966 INSERT INTO `0_wo_requirements` VALUES ('15', '5', '104', '1', '1', '0', 'DEF', '5');
1967 INSERT INTO `0_wo_requirements` VALUES ('16', '6', '102', '1', '1', '0', 'DEF', '-5');
1968 INSERT INTO `0_wo_requirements` VALUES ('17', '6', '103', '1', '1', '0', 'DEF', '-5');
1969 INSERT INTO `0_wo_requirements` VALUES ('18', '6', '104', '1', '1', '0', 'DEF', '-5');
1970 INSERT INTO `0_wo_requirements` VALUES ('19', '7', '102', '1', '1', '0', 'DEF', '-2');
1971 INSERT INTO `0_wo_requirements` VALUES ('20', '7', '103', '1', '1', '0', 'DEF', '-2');
1972 INSERT INTO `0_wo_requirements` VALUES ('21', '7', '104', '1', '1', '0', 'DEF', '-2');
1975 ### Structure of table `0_workcentres` ###
1977 DROP TABLE IF EXISTS `0_workcentres`;
1979 CREATE TABLE `0_workcentres` (
1980 `id` int(11) NOT NULL auto_increment,
1981 `name` char(40) NOT NULL default '',
1982 `description` char(50) NOT NULL default '',
1983 `inactive` tinyint(1) NOT NULL default '0',
1985 UNIQUE KEY `name` (`name`)
1986 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
1989 ### Data of table `0_workcentres` ###
1991 INSERT INTO `0_workcentres` VALUES ('1', 'Workshop', 'Workshop in Alabama', '0');
1994 ### Structure of table `0_workorders` ###
1996 DROP TABLE IF EXISTS `0_workorders`;
1998 CREATE TABLE `0_workorders` (
1999 `id` int(11) NOT NULL auto_increment,
2000 `wo_ref` varchar(60) NOT NULL default '',
2001 `loc_code` varchar(5) NOT NULL default '',
2002 `units_reqd` double NOT NULL default '1',
2003 `stock_id` varchar(20) NOT NULL default '',
2004 `date_` date NOT NULL default '0000-00-00',
2005 `type` tinyint(4) NOT NULL default '0',
2006 `required_by` date NOT NULL default '0000-00-00',
2007 `released_date` date NOT NULL default '0000-00-00',
2008 `units_issued` double NOT NULL default '0',
2009 `closed` tinyint(1) NOT NULL default '0',
2010 `released` tinyint(1) NOT NULL default '0',
2011 `additional_costs` double NOT NULL default '0',
2013 UNIQUE KEY `wo_ref` (`wo_ref`)
2014 ) TYPE=InnoDB AUTO_INCREMENT=8 ;
2017 ### Data of table `0_workorders` ###
2019 INSERT INTO `0_workorders` VALUES ('1', '1', 'DEF', '10', '3400', '2009-06-21', '0', '2009-06-21', '2009-06-21', '10', '1', '1', '10');
2020 INSERT INTO `0_workorders` VALUES ('2', '2', 'DEF', '3', '3400', '2009-06-21', '2', '2009-07-11', '2009-06-21', '2', '0', '1', '0');
2021 INSERT INTO `0_workorders` VALUES ('3', '3', 'DEF', '2', '3400', '2009-06-21', '0', '2009-06-21', '2009-06-21', '2', '1', '1', '0');
2022 INSERT INTO `0_workorders` VALUES ('4', '4', 'DEF', '4', '3400', '2009-06-21', '0', '2009-06-21', '2009-06-21', '4', '1', '1', '0');
2023 INSERT INTO `0_workorders` VALUES ('5', '5', 'DEF', '5', '3400', '2009-06-21', '0', '2009-06-21', '2009-06-21', '5', '1', '1', '10');
2024 INSERT INTO `0_workorders` VALUES ('6', '6', 'DEF', '-5', '3400', '2009-06-21', '1', '2009-06-21', '2009-06-21', '-5', '1', '1', '0');
2025 INSERT INTO `0_workorders` VALUES ('7', '7', 'DEF', '-2', '3400', '2009-06-21', '1', '2009-06-21', '2009-06-21', '-2', '1', '1', '10');