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 `balance_sheet` tinyint(1) NOT NULL default '0',
199 `sign_convert` tinyint(1) NOT NULL default '0',
200 `inactive` tinyint(1) NOT NULL default '0',
205 ### Data of table `0_chart_class` ###
207 INSERT INTO `0_chart_class` VALUES ('1', 'Assets', '1', '0', '0');
208 INSERT INTO `0_chart_class` VALUES ('2', 'Liabilities', '1', '0', '0');
209 INSERT INTO `0_chart_class` VALUES ('3', 'Income', '0', '1', '0');
210 INSERT INTO `0_chart_class` VALUES ('4', 'Costs', '0', '1', '0');
213 ### Structure of table `0_chart_master` ###
215 DROP TABLE IF EXISTS `0_chart_master`;
217 CREATE TABLE `0_chart_master` (
218 `account_code` varchar(11) NOT NULL default '',
219 `account_code2` varchar(11) default '',
220 `account_name` varchar(60) NOT NULL default '',
221 `account_type` int(11) NOT NULL default '0',
222 `inactive` tinyint(1) NOT NULL default '0',
223 PRIMARY KEY (`account_code`),
224 KEY `account_code` (`account_code`),
225 KEY `account_name` (`account_name`)
229 ### Data of table `0_chart_master` ###
231 INSERT INTO `0_chart_master` VALUES ('1060', '', 'Checking Account', '1', '0');
232 INSERT INTO `0_chart_master` VALUES ('1065', '', 'Petty Cash', '1', '0');
233 INSERT INTO `0_chart_master` VALUES ('1200', '', 'Accounts Receivables', '1', '0');
234 INSERT INTO `0_chart_master` VALUES ('1205', '', 'Allowance for doubtful accounts', '1', '0');
235 INSERT INTO `0_chart_master` VALUES ('1510', '', 'Inventory', '2', '0');
236 INSERT INTO `0_chart_master` VALUES ('1520', '', 'Stocks of Raw Materials', '2', '0');
237 INSERT INTO `0_chart_master` VALUES ('1530', '', 'Stocks of Work In Progress', '2', '0');
238 INSERT INTO `0_chart_master` VALUES ('1540', '', 'Stocks of Finsihed Goods', '2', '0');
239 INSERT INTO `0_chart_master` VALUES ('1550', '', 'Goods Received Clearing account', '2', '0');
240 INSERT INTO `0_chart_master` VALUES ('1820', '', 'Office Furniture & Equipment', '3', '0');
241 INSERT INTO `0_chart_master` VALUES ('1825', '', 'Accum. Amort. -Furn. & Equip.', '3', '0');
242 INSERT INTO `0_chart_master` VALUES ('1840', '', 'Vehicle', '3', '0');
243 INSERT INTO `0_chart_master` VALUES ('1845', '', 'Accum. Amort. -Vehicle', '3', '0');
244 INSERT INTO `0_chart_master` VALUES ('2100', '', 'Accounts Payable', '4', '0');
245 INSERT INTO `0_chart_master` VALUES ('2110', '', 'Accrued Income Tax - Federal', '4', '0');
246 INSERT INTO `0_chart_master` VALUES ('2120', '', 'Accrued Income Tax - State', '4', '0');
247 INSERT INTO `0_chart_master` VALUES ('2130', '', 'Accrued Franchise Tax', '4', '0');
248 INSERT INTO `0_chart_master` VALUES ('2140', '', 'Accrued Real & Personal Prop Tax', '4', '0');
249 INSERT INTO `0_chart_master` VALUES ('2150', '', 'Sales Tax', '4', '0');
250 INSERT INTO `0_chart_master` VALUES ('2160', '', 'Accrued Use Tax Payable', '4', '0');
251 INSERT INTO `0_chart_master` VALUES ('2210', '', 'Accrued Wages', '4', '0');
252 INSERT INTO `0_chart_master` VALUES ('2220', '', 'Accrued Comp Time', '4', '0');
253 INSERT INTO `0_chart_master` VALUES ('2230', '', 'Accrued Holiday Pay', '4', '0');
254 INSERT INTO `0_chart_master` VALUES ('2240', '', 'Accrued Vacation Pay', '4', '0');
255 INSERT INTO `0_chart_master` VALUES ('2310', '', 'Accr. Benefits - 401K', '4', '0');
256 INSERT INTO `0_chart_master` VALUES ('2320', '', 'Accr. Benefits - Stock Purchase', '4', '0');
257 INSERT INTO `0_chart_master` VALUES ('2330', '', 'Accr. Benefits - Med, Den', '4', '0');
258 INSERT INTO `0_chart_master` VALUES ('2340', '', 'Accr. Benefits - Payroll Taxes', '4', '0');
259 INSERT INTO `0_chart_master` VALUES ('2350', '', 'Accr. Benefits - Credit Union', '4', '0');
260 INSERT INTO `0_chart_master` VALUES ('2360', '', 'Accr. Benefits - Savings Bond', '4', '0');
261 INSERT INTO `0_chart_master` VALUES ('2370', '', 'Accr. Benefits - Garnish', '4', '0');
262 INSERT INTO `0_chart_master` VALUES ('2380', '', 'Accr. Benefits - Charity Cont.', '4', '0');
263 INSERT INTO `0_chart_master` VALUES ('2620', '', 'Bank Loans', '5', '0');
264 INSERT INTO `0_chart_master` VALUES ('2680', '', 'Loans from Shareholders', '5', '0');
265 INSERT INTO `0_chart_master` VALUES ('3350', '', 'Common Shares', '6', '0');
266 INSERT INTO `0_chart_master` VALUES ('3590', '', 'Retained Earnings - prior years', '7', '0');
267 INSERT INTO `0_chart_master` VALUES ('4010', '', 'Sales', '8', '0');
268 INSERT INTO `0_chart_master` VALUES ('4430', '', 'Shipping & Handling', '9', '0');
269 INSERT INTO `0_chart_master` VALUES ('4440', '', 'Interest', '9', '0');
270 INSERT INTO `0_chart_master` VALUES ('4450', '', 'Foreign Exchange Gain', '9', '0');
271 INSERT INTO `0_chart_master` VALUES ('4500', '', 'Prompt Payment Discounts', '9', '0');
272 INSERT INTO `0_chart_master` VALUES ('4510', '', 'Discounts Given', '9', '0');
273 INSERT INTO `0_chart_master` VALUES ('5010', '', 'Cost of Goods Sold - Retail', '10', '0');
274 INSERT INTO `0_chart_master` VALUES ('5020', '', 'Material Usage Varaiance', '10', '0');
275 INSERT INTO `0_chart_master` VALUES ('5030', '', 'Consumable Materials', '10', '0');
276 INSERT INTO `0_chart_master` VALUES ('5040', '', 'Purchase price Variance', '10', '0');
277 INSERT INTO `0_chart_master` VALUES ('5050', '', 'Purchases of materials', '10', '0');
278 INSERT INTO `0_chart_master` VALUES ('5060', '', 'Discounts Received', '10', '0');
279 INSERT INTO `0_chart_master` VALUES ('5100', '', 'Freight', '10', '0');
280 INSERT INTO `0_chart_master` VALUES ('5410', '', 'Wages & Salaries', '11', '0');
281 INSERT INTO `0_chart_master` VALUES ('5420', '', 'Wages - Overtime', '11', '0');
282 INSERT INTO `0_chart_master` VALUES ('5430', '', 'Benefits - Comp Time', '11', '0');
283 INSERT INTO `0_chart_master` VALUES ('5440', '', 'Benefits - Payroll Taxes', '11', '0');
284 INSERT INTO `0_chart_master` VALUES ('5450', '', 'Benefits - Workers Comp', '11', '0');
285 INSERT INTO `0_chart_master` VALUES ('5460', '', 'Benefits - Pension', '11', '0');
286 INSERT INTO `0_chart_master` VALUES ('5470', '', 'Benefits - General Benefits', '11', '0');
287 INSERT INTO `0_chart_master` VALUES ('5510', '', 'Inc Tax Exp - Federal', '11', '0');
288 INSERT INTO `0_chart_master` VALUES ('5520', '', 'Inc Tax Exp - State', '11', '0');
289 INSERT INTO `0_chart_master` VALUES ('5530', '', 'Taxes - Real Estate', '11', '0');
290 INSERT INTO `0_chart_master` VALUES ('5540', '', 'Taxes - Personal Property', '11', '0');
291 INSERT INTO `0_chart_master` VALUES ('5550', '', 'Taxes - Franchise', '11', '0');
292 INSERT INTO `0_chart_master` VALUES ('5560', '', 'Taxes - Foreign Withholding', '11', '0');
293 INSERT INTO `0_chart_master` VALUES ('5610', '', 'Accounting & Legal', '12', '0');
294 INSERT INTO `0_chart_master` VALUES ('5615', '', 'Advertising & Promotions', '12', '0');
295 INSERT INTO `0_chart_master` VALUES ('5620', '', 'Bad Debts', '12', '0');
296 INSERT INTO `0_chart_master` VALUES ('5660', '', 'Amortization Expense', '12', '0');
297 INSERT INTO `0_chart_master` VALUES ('5685', '', 'Insurance', '12', '0');
298 INSERT INTO `0_chart_master` VALUES ('5690', '', 'Interest & Bank Charges', '12', '0');
299 INSERT INTO `0_chart_master` VALUES ('5700', '', 'Office Supplies', '12', '0');
300 INSERT INTO `0_chart_master` VALUES ('5760', '', 'Rent', '12', '0');
301 INSERT INTO `0_chart_master` VALUES ('5765', '', 'Repair & Maintenance', '12', '0');
302 INSERT INTO `0_chart_master` VALUES ('5780', '', 'Telephone', '12', '0');
303 INSERT INTO `0_chart_master` VALUES ('5785', '', 'Travel & Entertainment', '12', '0');
304 INSERT INTO `0_chart_master` VALUES ('5790', '', 'Utilities', '12', '0');
305 INSERT INTO `0_chart_master` VALUES ('5795', '', 'Registrations', '12', '0');
306 INSERT INTO `0_chart_master` VALUES ('5800', '', 'Licenses', '12', '0');
307 INSERT INTO `0_chart_master` VALUES ('5810', '', 'Foreign Exchange Loss', '12', '0');
308 INSERT INTO `0_chart_master` VALUES ('9990', '', 'Year Profit/Loss', '12', '0');
310 ### Structure of table `0_chart_types` ###
312 DROP TABLE IF EXISTS `0_chart_types`;
314 CREATE TABLE `0_chart_types` (
315 `id` int(11) NOT NULL auto_increment,
316 `name` varchar(60) NOT NULL default '',
317 `class_id` tinyint(1) NOT NULL default '0',
318 `parent` int(11) NOT NULL default '-1',
319 `inactive` tinyint(1) NOT NULL default '0',
322 ) TYPE=MyISAM AUTO_INCREMENT=13 ;
325 ### Data of table `0_chart_types` ###
327 INSERT INTO `0_chart_types` VALUES ('1', 'Current Assets', '1', '-1', '0');
328 INSERT INTO `0_chart_types` VALUES ('2', 'Inventory Assets', '1', '-1', '0');
329 INSERT INTO `0_chart_types` VALUES ('3', 'Capital Assets', '1', '-1', '0');
330 INSERT INTO `0_chart_types` VALUES ('4', 'Current Liabilities', '2', '-1', '0');
331 INSERT INTO `0_chart_types` VALUES ('5', 'Long Term Liabilities', '2', '-1', '0');
332 INSERT INTO `0_chart_types` VALUES ('6', 'Share Capital', '2', '-1', '0');
333 INSERT INTO `0_chart_types` VALUES ('7', 'Retained Earnings', '2', '-1', '0');
334 INSERT INTO `0_chart_types` VALUES ('8', 'Sales Revenue', '3', '-1', '0');
335 INSERT INTO `0_chart_types` VALUES ('9', 'Other Revenue', '3', '-1', '0');
336 INSERT INTO `0_chart_types` VALUES ('10', 'Cost of Goods Sold', '4', '-1', '0');
337 INSERT INTO `0_chart_types` VALUES ('11', 'Payroll Expenses', '4', '-1', '0');
338 INSERT INTO `0_chart_types` VALUES ('12', 'General & Administrative expenses', '4', '-1', '0');
341 ### Structure of table `0_comments` ###
343 DROP TABLE IF EXISTS `0_comments`;
345 CREATE TABLE `0_comments` (
346 `type` int(11) NOT NULL default '0',
347 `id` int(11) NOT NULL default '0',
348 `date_` date default '0000-00-00',
353 ### Data of table `0_comments` ###
357 ### Structure of table `0_company` ###
359 DROP TABLE IF EXISTS `0_company`;
361 CREATE TABLE `0_company` (
362 `coy_code` int(11) NOT NULL default '1',
363 `coy_name` varchar(60) NOT NULL default '',
364 `gst_no` varchar(25) NOT NULL default '',
365 `coy_no` varchar(25) NOT NULL default '0',
366 `tax_prd` int(11) NOT NULL default '1',
367 `tax_last` int(11) NOT NULL default '1',
368 `postal_address` tinytext NOT NULL,
369 `phone` varchar(30) NOT NULL default '',
370 `fax` varchar(30) NOT NULL default '',
371 `email` varchar(100) NOT NULL default '',
372 `coy_logo` varchar(100) NOT NULL default '',
373 `domicile` varchar(55) NOT NULL default '',
374 `curr_default` char(3) NOT NULL default '',
375 `debtors_act` varchar(11) NOT NULL default '',
376 `pyt_discount_act` varchar(11) NOT NULL default '',
377 `creditors_act` varchar(11) NOT NULL default '',
378 `grn_act` varchar(11) NOT NULL default '',
379 `exchange_diff_act` varchar(11) NOT NULL default '',
380 `profit_loss_year_act` varchar(11) NOT NULL default '',
381 `retained_earnings_act` varchar(11) NOT NULL default '',
382 `freight_act` varchar(11) NOT NULL default '',
383 `default_sales_act` varchar(11) NOT NULL default '',
384 `default_sales_discount_act` varchar(11) NOT NULL default '',
385 `default_prompt_payment_act` varchar(11) NOT NULL default '',
386 `default_inventory_act` varchar(11) NOT NULL default '',
387 `default_cogs_act` varchar(11) NOT NULL default '',
388 `default_adj_act` varchar(11) NOT NULL default '',
389 `default_inv_sales_act` varchar(11) NOT NULL default '',
390 `default_assembly_act` varchar(11) NOT NULL default '',
391 `payroll_act` varchar(11) NOT NULL default '',
392 `allow_negative_stock` tinyint(1) NOT NULL default '0',
393 `po_over_receive` int(11) NOT NULL default '10',
394 `po_over_charge` int(11) NOT NULL default '10',
395 `default_credit_limit` int(11) NOT NULL default '1000',
396 `default_workorder_required` int(11) NOT NULL default '20',
397 `default_dim_required` int(11) NOT NULL default '20',
398 `past_due_days` int(11) NOT NULL default '30',
399 `use_dimension` tinyint(1) default '0',
400 `f_year` int(11) NOT NULL default '1',
401 `no_item_list` tinyint(1) NOT NULL default '0',
402 `no_customer_list` tinyint(1) NOT NULL default '0',
403 `no_supplier_list` tinyint(1) NOT NULL default '0',
404 `base_sales` int(11) NOT NULL default '-1',
405 `foreign_codes` tinyint(1) NOT NULL default '0',
406 `accumulate_shipping` tinyint(1) NOT NULL default '0',
407 `legal_text` tinytext NOT NULL,
408 `default_delivery_required` smallint(6) NOT NULL default '1',
409 `version_id` varchar(11) NOT NULL default '',
410 `time_zone` tinyint(1) NOT NULL default '0',
411 PRIMARY KEY (`coy_code`)
414 ### Data of table `0_company` ###
416 INSERT INTO `0_company` VALUES ('1', 'Training Co.', '9876543', '123456789', '1', '1', 'Address 1\r\nAddress 2\r\nAddress 3', '(222) 111.222.333', '', 'delta@delta.com', 'logo_frontaccounting.jpg', '', 'USD', '1200', '5060', '2100', '1430', '4450', '4220', '2050', '4430', '4010', '4510', '4500', '1510', '5010', '5040', '4010', '1530', '5000', '', '', '', '', '', '', '0', '10', '10', '1000', '20', '20', '30', '1', '2', '0', '0', '0', '1', '0', '0', '', '1', '2.2', '0');
418 ### Structure of table `0_credit_status` ###
420 DROP TABLE IF EXISTS `0_credit_status`;
422 CREATE TABLE `0_credit_status` (
423 `id` int(11) NOT NULL auto_increment,
424 `reason_description` char(100) NOT NULL default '',
425 `dissallow_invoices` tinyint(1) NOT NULL default '0',
426 `inactive` tinyint(1) NOT NULL default '0',
428 UNIQUE KEY `reason_description` (`reason_description`)
429 ) TYPE=MyISAM AUTO_INCREMENT=5 ;
432 ### Data of table `0_credit_status` ###
434 INSERT INTO `0_credit_status` VALUES ('1', 'Good History', '0', '0');
435 INSERT INTO `0_credit_status` VALUES ('3', 'No more work until payment received', '1', '0');
436 INSERT INTO `0_credit_status` VALUES ('4', 'In liquidation', '1', '0');
439 ### Structure of table `0_currencies` ###
441 DROP TABLE IF EXISTS `0_currencies`;
443 CREATE TABLE `0_currencies` (
444 `currency` varchar(60) NOT NULL default '',
445 `curr_abrev` char(3) NOT NULL default '',
446 `curr_symbol` varchar(10) NOT NULL default '',
447 `country` varchar(100) NOT NULL default '',
448 `hundreds_name` varchar(15) NOT NULL default '',
449 `auto_update` tinyint(1) NOT NULL default '1',
450 `inactive` tinyint(1) NOT NULL default '0',
451 PRIMARY KEY (`curr_abrev`)
455 ### Data of table `0_currencies` ###
457 INSERT INTO `0_currencies` VALUES ('US Dollars', 'USD', '$', 'United States', 'Cents', '1', '0');
458 INSERT INTO `0_currencies` VALUES ('CA Dollars', 'CAD', '$', 'Canada', 'Cents', '1', '0');
459 INSERT INTO `0_currencies` VALUES ('Euro', 'EUR', '?', 'Europe', 'Cents', '1', '0');
460 INSERT INTO `0_currencies` VALUES ('Pounds', 'GBP', '?', 'England', 'Pence', '1', '0');
461 INSERT INTO `0_currencies` VALUES ('DK Kroner', 'DKK', '?', 'Denmark', 'Ore', '1', '0');
463 ### Structure of table `0_cust_allocations` ###
465 DROP TABLE IF EXISTS `0_cust_allocations`;
467 CREATE TABLE `0_cust_allocations` (
468 `id` int(11) NOT NULL auto_increment,
469 `amt` double unsigned default NULL,
470 `date_alloc` date NOT NULL default '0000-00-00',
471 `trans_no_from` int(11) default NULL,
472 `trans_type_from` int(11) default NULL,
473 `trans_no_to` int(11) default NULL,
474 `trans_type_to` int(11) default NULL,
476 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
479 ### Data of table `0_cust_allocations` ###
481 INSERT INTO `0_cust_allocations` VALUES ('1', '37.68', '2009-06-21', '3', '11', '18', '10');
484 ### Structure of table `0_cust_branch` ###
486 DROP TABLE IF EXISTS `0_cust_branch`;
488 CREATE TABLE `0_cust_branch` (
489 `branch_code` int(11) NOT NULL auto_increment,
490 `debtor_no` int(11) NOT NULL default '0',
491 `br_name` varchar(60) NOT NULL default '',
492 `br_address` tinytext NOT NULL,
493 `area` int(11) default NULL,
494 `salesman` int(11) NOT NULL default '0',
495 `phone` varchar(30) NOT NULL default '',
496 `fax` varchar(30) NOT NULL default '',
497 `contact_name` varchar(60) NOT NULL default '',
498 `email` varchar(100) NOT NULL default '',
499 `default_location` varchar(5) NOT NULL default '',
500 `tax_group_id` int(11) default NULL,
501 `sales_account` varchar(11) default NULL,
502 `sales_discount_account` varchar(11) default NULL,
503 `receivables_account` varchar(11) default NULL,
504 `payment_discount_account` varchar(11) default NULL,
505 `default_ship_via` int(11) NOT NULL default '1',
506 `disable_trans` tinyint(4) NOT NULL default '0',
507 `br_post_address` tinytext NOT NULL,
508 `group_no` int(11) NOT NULL default '0',
509 `inactive` tinyint(1) NOT NULL default '0',
510 PRIMARY KEY (`branch_code`,`debtor_no`),
511 KEY `branch_code` (`branch_code`),
512 KEY `br_name` (`br_name`)
513 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
516 ### Data of table `0_cust_branch` ###
518 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');
519 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');
520 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');
523 ### Structure of table `0_debtor_trans` ###
525 DROP TABLE IF EXISTS `0_debtor_trans`;
527 CREATE TABLE `0_debtor_trans` (
528 `trans_no` int(11) unsigned NOT NULL default '0',
529 `type` smallint(6) unsigned NOT NULL default '0',
530 `version` tinyint(1) unsigned NOT NULL default '0',
531 `debtor_no` int(11) unsigned default NULL,
532 `branch_code` int(11) NOT NULL default '-1',
533 `tran_date` date NOT NULL default '0000-00-00',
534 `due_date` date NOT NULL default '0000-00-00',
535 `reference` varchar(60) NOT NULL default '',
536 `tpe` int(11) NOT NULL default '0',
537 `order_` int(11) NOT NULL default '0',
538 `ov_amount` double NOT NULL default '0',
539 `ov_gst` double NOT NULL default '0',
540 `ov_freight` double NOT NULL default '0',
541 `ov_freight_tax` double NOT NULL default '0',
542 `ov_discount` double NOT NULL default '0',
543 `alloc` double NOT NULL default '0',
544 `rate` double NOT NULL default '1',
545 `ship_via` int(11) default NULL,
546 `trans_link` int(11) NOT NULL default '0',
547 `dimension_id` int(11) NOT NULL default '0',
548 `dimension2_id` int(11) NOT NULL default '0',
549 PRIMARY KEY (`trans_no`,`type`),
550 KEY `debtor_no` (`debtor_no`,`branch_code`)
554 ### Data of table `0_debtor_trans` ###
556 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');
557 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');
558 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');
559 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');
560 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');
561 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');
562 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');
563 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');
566 ### Structure of table `0_debtor_trans_details` ###
568 DROP TABLE IF EXISTS `0_debtor_trans_details`;
570 CREATE TABLE `0_debtor_trans_details` (
571 `id` int(11) NOT NULL auto_increment,
572 `debtor_trans_no` int(11) default NULL,
573 `debtor_trans_type` int(11) default NULL,
574 `stock_id` varchar(20) NOT NULL default '',
575 `description` tinytext,
576 `unit_price` double NOT NULL default '0',
577 `unit_tax` double NOT NULL default '0',
578 `quantity` double NOT NULL default '0',
579 `discount_percent` double NOT NULL default '0',
580 `standard_cost` double NOT NULL default '0',
581 `qty_done` double NOT NULL default '0',
583 ) TYPE=InnoDB AUTO_INCREMENT=9 ;
586 ### Data of table `0_debtor_trans_details` ###
588 INSERT INTO `0_debtor_trans_details` VALUES ('1', '2', '13', '102', '17inch VGA Monitor', '30.4', '0', '2', '0', '10', '0');
589 INSERT INTO `0_debtor_trans_details` VALUES ('2', '3', '13', '102', '17inch VGA Monitor', '50', '2.5', '1', '0', '10', '1');
590 INSERT INTO `0_debtor_trans_details` VALUES ('3', '17', '10', '102', '17inch VGA Monitor', '50', '2.5', '1', '0', '10', '0');
591 INSERT INTO `0_debtor_trans_details` VALUES ('4', '4', '13', '102', '17inch VGA Monitor', '35.89', '1.79', '1', '0', '10', '1');
592 INSERT INTO `0_debtor_trans_details` VALUES ('5', '18', '10', '102', '17inch VGA Monitor', '35.89', '1.79', '1', '0', '10', '1');
593 INSERT INTO `0_debtor_trans_details` VALUES ('6', '5', '13', '102', '17inch VGA Monitor', '50', '2.38', '1', '0', '10', '1');
594 INSERT INTO `0_debtor_trans_details` VALUES ('7', '19', '10', '102', '17inch VGA Monitor', '50', '2.38', '1', '0', '10', '0');
595 INSERT INTO `0_debtor_trans_details` VALUES ('8', '3', '11', '102', '17inch VGA Monitor', '35.89', '1.79', '1', '0', '10', '0');
598 ### Structure of table `0_debtors_master` ###
600 DROP TABLE IF EXISTS `0_debtors_master`;
602 CREATE TABLE `0_debtors_master` (
603 `debtor_no` int(11) NOT NULL auto_increment,
604 `name` varchar(80) NOT NULL default '',
606 `email` varchar(100) NOT NULL default '',
607 `tax_id` varchar(55) NOT NULL default '',
608 `curr_code` char(3) NOT NULL default '',
609 `sales_type` int(11) NOT NULL default '1',
610 `dimension_id` int(11) NOT NULL default '0',
611 `dimension2_id` int(11) NOT NULL default '0',
612 `credit_status` int(11) NOT NULL default '0',
613 `payment_terms` int(11) default NULL,
614 `discount` double NOT NULL default '0',
615 `pymt_discount` double NOT NULL default '0',
616 `credit_limit` float NOT NULL default '1000',
617 `inactive` tinyint(1) NOT NULL default '0',
618 PRIMARY KEY (`debtor_no`),
619 UNIQUE KEY `name` (`name`)
620 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
623 ### Data of table `0_debtors_master` ###
625 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');
626 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');
627 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');
630 ### Structure of table `0_dimensions` ###
632 DROP TABLE IF EXISTS `0_dimensions`;
634 CREATE TABLE `0_dimensions` (
635 `id` int(11) NOT NULL auto_increment,
636 `reference` varchar(60) NOT NULL default '',
637 `name` varchar(60) NOT NULL default '',
638 `type_` tinyint(1) NOT NULL default '1',
639 `closed` tinyint(1) NOT NULL default '0',
640 `date_` date NOT NULL default '0000-00-00',
641 `due_date` date NOT NULL default '0000-00-00',
643 UNIQUE KEY `reference` (`reference`)
644 ) TYPE=InnoDB AUTO_INCREMENT=3 ;
647 ### Data of table `0_dimensions` ###
649 INSERT INTO `0_dimensions` VALUES ('1', '1', 'Support', '1', '0', '2009-06-21', '2015-07-11');
650 INSERT INTO `0_dimensions` VALUES ('2', '2', 'Development', '1', '0', '2009-06-21', '2015-07-11');
653 ### Structure of table `0_exchange_rates` ###
655 DROP TABLE IF EXISTS `0_exchange_rates`;
657 CREATE TABLE `0_exchange_rates` (
658 `id` int(11) NOT NULL auto_increment,
659 `curr_code` char(3) NOT NULL default '',
660 `rate_buy` double NOT NULL default '0',
661 `rate_sell` double NOT NULL default '0',
662 `date_` date NOT NULL default '0000-00-00',
664 UNIQUE KEY `curr_code` (`curr_code`,`date_`)
665 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
668 ### Data of table `0_exchange_rates` ###
670 INSERT INTO `0_exchange_rates` VALUES ('1', 'DKK', '0.18717252868313', '0.18717252868313', '2009-06-21');
671 INSERT INTO `0_exchange_rates` VALUES ('2', 'GBP', '1.6445729799917', '1.6445729799917', '2009-06-21');
672 INSERT INTO `0_exchange_rates` VALUES ('3', 'EUR', '1.3932', '1.3932', '2009-06-21');
675 ### Structure of table `0_fiscal_year` ###
677 DROP TABLE IF EXISTS `0_fiscal_year`;
679 CREATE TABLE `0_fiscal_year` (
680 `id` int(11) NOT NULL auto_increment,
681 `begin` date default '0000-00-00',
682 `end` date default '0000-00-00',
683 `closed` tinyint(1) NOT NULL default '0',
685 ) TYPE=InnoDB AUTO_INCREMENT=3 ;
688 ### Data of table `0_fiscal_year` ###
690 INSERT INTO `0_fiscal_year` VALUES ('1', '2008-01-01', '2008-12-31', '0');
691 INSERT INTO `0_fiscal_year` VALUES ('2', '2009-01-01', '2009-12-31', '0');
694 ### Structure of table `0_gl_trans` ###
696 DROP TABLE IF EXISTS `0_gl_trans`;
698 CREATE TABLE `0_gl_trans` (
699 `counter` int(11) NOT NULL auto_increment,
700 `type` smallint(6) NOT NULL default '0',
701 `type_no` bigint(16) NOT NULL default '1',
702 `tran_date` date NOT NULL default '0000-00-00',
703 `account` varchar(11) NOT NULL default '',
704 `memo_` tinytext NOT NULL,
705 `amount` double NOT NULL default '0',
706 `dimension_id` int(11) NOT NULL default '0',
707 `dimension2_id` int(11) NOT NULL default '0',
708 `person_type_id` int(11) default NULL,
709 `person_id` tinyblob,
710 PRIMARY KEY (`counter`),
711 KEY `Type_and_Number` (`type`,`type_no`)
712 ) TYPE=InnoDB AUTO_INCREMENT=84 ;
715 ### Data of table `0_gl_trans` ###
717 INSERT INTO `0_gl_trans` VALUES ('1', '20', '7', '2009-06-21', '2100', '', '-3465', '0', '0', '3', '2');
718 INSERT INTO `0_gl_trans` VALUES ('2', '20', '7', '2009-06-21', '1510', '', '1000', '0', '0', '3', '2');
719 INSERT INTO `0_gl_trans` VALUES ('3', '20', '7', '2009-06-21', '1510', '', '1100', '0', '0', '3', '2');
720 INSERT INTO `0_gl_trans` VALUES ('4', '20', '7', '2009-06-21', '1510', '', '1200', '0', '0', '3', '2');
721 INSERT INTO `0_gl_trans` VALUES ('5', '20', '7', '2009-06-21', '2150', '', '165', '0', '0', '3', '2');
722 INSERT INTO `0_gl_trans` VALUES ('6', '22', '4', '2009-06-21', '2100', '', '3465', '0', '0', '3', '2');
723 INSERT INTO `0_gl_trans` VALUES ('7', '22', '4', '2009-06-21', '1060', '', '-3465', '0', '0', '3', '2');
724 INSERT INTO `0_gl_trans` VALUES ('8', '26', '1', '2009-06-21', '1510', '', '-100', '0', '0', '', '');
725 INSERT INTO `0_gl_trans` VALUES ('9', '26', '1', '2009-06-21', '1510', '', '-110', '0', '0', '', '');
726 INSERT INTO `0_gl_trans` VALUES ('10', '26', '1', '2009-06-21', '1510', '', '-120', '0', '0', '', '');
727 INSERT INTO `0_gl_trans` VALUES ('11', '26', '1', '2009-06-21', '1060', 'Overhead Cost', '-10', '0', '0', '1', '1');
728 INSERT INTO `0_gl_trans` VALUES ('12', '26', '1', '2009-06-21', '1530', 'Overhead Cost', '10', '0', '0', '1', '1');
729 INSERT INTO `0_gl_trans` VALUES ('13', '26', '1', '2009-06-21', '1060', 'Labour Cost', '-20', '0', '0', '1', '0');
730 INSERT INTO `0_gl_trans` VALUES ('14', '26', '1', '2009-06-21', '1530', 'Labour Cost', '20', '0', '0', '1', '0');
731 INSERT INTO `0_gl_trans` VALUES ('15', '26', '1', '2009-06-21', '1510', '', '330', '0', '0', '', '');
732 INSERT INTO `0_gl_trans` VALUES ('16', '13', '2', '2009-06-21', '5010', '', '20', '0', '0', '2', '1');
733 INSERT INTO `0_gl_trans` VALUES ('17', '13', '2', '2009-06-21', '1510', '', '-20', '0', '0', '2', '1');
734 INSERT INTO `0_gl_trans` VALUES ('18', '13', '3', '2009-06-21', '5010', '', '10', '0', '0', '2', '2');
735 INSERT INTO `0_gl_trans` VALUES ('19', '13', '3', '2009-06-21', '1510', '', '-10', '0', '0', '2', '2');
736 INSERT INTO `0_gl_trans` VALUES ('20', '10', '17', '2009-06-21', '4010', '', '-50', '0', '0', '2', '2');
737 INSERT INTO `0_gl_trans` VALUES ('21', '10', '17', '2009-06-21', '1200', '', '52.5', '0', '0', '2', '2');
738 INSERT INTO `0_gl_trans` VALUES ('22', '10', '17', '2009-06-21', '2150', '', '-2.5', '0', '0', '2', '2');
739 INSERT INTO `0_gl_trans` VALUES ('23', '13', '4', '2009-06-21', '5010', '', '10', '2', '0', '2', '3');
740 INSERT INTO `0_gl_trans` VALUES ('24', '13', '4', '2009-06-21', '1510', '', '-10', '0', '0', '2', '3');
741 INSERT INTO `0_gl_trans` VALUES ('25', '10', '18', '2009-06-21', '4010', '', '-50', '2', '0', '2', '3');
742 INSERT INTO `0_gl_trans` VALUES ('26', '10', '18', '2009-06-21', '1200', '', '52.5', '0', '0', '2', '3');
743 INSERT INTO `0_gl_trans` VALUES ('27', '10', '18', '2009-06-21', '2150', '', '-2.5', '0', '0', '2', '3');
744 INSERT INTO `0_gl_trans` VALUES ('28', '0', '18', '2009-02-20', '1060', '', '1000', '0', '0', '', '');
745 INSERT INTO `0_gl_trans` VALUES ('29', '0', '18', '2009-02-20', '3350', '', '-1000', '0', '0', '', '');
746 INSERT INTO `0_gl_trans` VALUES ('30', '0', '19', '2009-02-21', '1060', '', '4000', '0', '0', '', '');
747 INSERT INTO `0_gl_trans` VALUES ('31', '0', '19', '2009-02-21', '3350', '', '-4000', '0', '0', '', '');
748 INSERT INTO `0_gl_trans` VALUES ('32', '26', '3', '2009-06-21', '1510', '', '-20', '0', '0', '', '');
749 INSERT INTO `0_gl_trans` VALUES ('33', '26', '3', '2009-06-21', '1510', '', '-22', '0', '0', '', '');
750 INSERT INTO `0_gl_trans` VALUES ('34', '26', '3', '2009-06-21', '1510', '', '-24', '0', '0', '', '');
751 INSERT INTO `0_gl_trans` VALUES ('35', '26', '3', '2009-06-21', '1540', '', '66', '0', '0', '', '');
752 INSERT INTO `0_gl_trans` VALUES ('36', '2', '5', '2009-06-21', '2150', 'Cash Sales', '-4.76', '0', '0', '4', '3');
753 INSERT INTO `0_gl_trans` VALUES ('37', '2', '5', '2009-06-21', '4010', 'Cash Sales', '-95.24', '0', '0', '4', '3');
754 INSERT INTO `0_gl_trans` VALUES ('38', '2', '5', '2009-06-21', '1060', '', '100', '0', '0', '4', '3');
755 INSERT INTO `0_gl_trans` VALUES ('39', '1', '8', '2009-06-21', '2150', 'Maintenance', '2.38', '0', '0', '4', '1');
756 INSERT INTO `0_gl_trans` VALUES ('40', '1', '8', '2009-06-21', '5765', 'Maintenance', '47.62', '0', '0', '4', '1');
757 INSERT INTO `0_gl_trans` VALUES ('41', '1', '8', '2009-06-21', '1060', '', '-50', '0', '0', '4', '1');
758 INSERT INTO `0_gl_trans` VALUES ('42', '20', '8', '2009-06-21', '2100', '', '-20', '0', '0', '3', '2');
759 INSERT INTO `0_gl_trans` VALUES ('43', '20', '8', '2009-06-21', '2150', '', '0.95', '0', '0', '3', '2');
760 INSERT INTO `0_gl_trans` VALUES ('44', '20', '8', '2009-06-21', '5780', '', '19.05', '0', '0', '3', '2');
761 INSERT INTO `0_gl_trans` VALUES ('45', '26', '4', '2009-06-21', '1510', '', '-40', '0', '0', '', '');
762 INSERT INTO `0_gl_trans` VALUES ('46', '26', '4', '2009-06-21', '1510', '', '-44', '0', '0', '', '');
763 INSERT INTO `0_gl_trans` VALUES ('47', '26', '4', '2009-06-21', '1510', '', '-48', '0', '0', '', '');
764 INSERT INTO `0_gl_trans` VALUES ('48', '26', '4', '2009-06-21', '1540', '', '132', '0', '0', '', '');
765 INSERT INTO `0_gl_trans` VALUES ('49', '26', '2', '2009-06-21', '1510', '', '-20', '0', '0', '', '');
766 INSERT INTO `0_gl_trans` VALUES ('50', '26', '2', '2009-06-21', '1510', '', '-22', '0', '0', '', '');
767 INSERT INTO `0_gl_trans` VALUES ('51', '26', '2', '2009-06-21', '1510', '', '-24', '0', '0', '', '');
768 INSERT INTO `0_gl_trans` VALUES ('52', '26', '2', '2009-06-21', '1540', '', '66', '0', '0', '', '');
769 INSERT INTO `0_gl_trans` VALUES ('53', '26', '5', '2009-06-21', '1510', '', '-50', '0', '0', '', '');
770 INSERT INTO `0_gl_trans` VALUES ('54', '26', '5', '2009-06-21', '1510', '', '-55', '0', '0', '', '');
771 INSERT INTO `0_gl_trans` VALUES ('55', '26', '5', '2009-06-21', '1510', '', '-60', '0', '0', '', '');
772 INSERT INTO `0_gl_trans` VALUES ('56', '26', '5', '2009-06-21', '1060', 'Overhead Cost', '-10', '0', '0', '1', '1');
773 INSERT INTO `0_gl_trans` VALUES ('57', '26', '5', '2009-06-21', '1530', 'Overhead Cost', '10', '0', '0', '1', '1');
774 INSERT INTO `0_gl_trans` VALUES ('58', '26', '5', '2009-06-21', '1060', 'Labour Cost', '-20', '0', '0', '1', '0');
775 INSERT INTO `0_gl_trans` VALUES ('59', '26', '5', '2009-06-21', '1530', 'Labour Cost', '20', '0', '0', '1', '0');
776 INSERT INTO `0_gl_trans` VALUES ('60', '26', '5', '2009-06-21', '1540', '', '165', '0', '0', '', '');
777 INSERT INTO `0_gl_trans` VALUES ('61', '26', '6', '2009-06-21', '1510', '', '50', '0', '0', '', '');
778 INSERT INTO `0_gl_trans` VALUES ('62', '26', '6', '2009-06-21', '1510', '', '55', '0', '0', '', '');
779 INSERT INTO `0_gl_trans` VALUES ('63', '26', '6', '2009-06-21', '1510', '', '60', '0', '0', '', '');
780 INSERT INTO `0_gl_trans` VALUES ('64', '26', '6', '2009-06-21', '1540', '', '-165', '0', '0', '', '');
781 INSERT INTO `0_gl_trans` VALUES ('65', '26', '7', '2009-06-21', '1510', '', '20', '0', '0', '', '');
782 INSERT INTO `0_gl_trans` VALUES ('66', '26', '7', '2009-06-21', '1510', '', '22', '0', '0', '', '');
783 INSERT INTO `0_gl_trans` VALUES ('67', '26', '7', '2009-06-21', '1510', '', '24', '0', '0', '', '');
784 INSERT INTO `0_gl_trans` VALUES ('68', '26', '7', '2009-06-21', '1060', 'Overhead Cost', '-10', '0', '0', '1', '1');
785 INSERT INTO `0_gl_trans` VALUES ('69', '26', '7', '2009-06-21', '1530', 'Overhead Cost', '10', '0', '0', '1', '1');
786 INSERT INTO `0_gl_trans` VALUES ('70', '26', '7', '2009-06-21', '1060', 'Labour Cost', '-20', '0', '0', '1', '0');
787 INSERT INTO `0_gl_trans` VALUES ('71', '26', '7', '2009-06-21', '1530', 'Labour Cost', '20', '0', '0', '1', '0');
788 INSERT INTO `0_gl_trans` VALUES ('72', '26', '7', '2009-06-21', '1540', '', '-66', '0', '0', '', '');
789 INSERT INTO `0_gl_trans` VALUES ('73', '13', '5', '2009-06-21', '5010', '', '10', '0', '0', '2', '2');
790 INSERT INTO `0_gl_trans` VALUES ('74', '13', '5', '2009-06-21', '1510', '', '-10', '0', '0', '2', '2');
791 INSERT INTO `0_gl_trans` VALUES ('75', '10', '19', '2009-06-21', '4010', '', '-47.62', '0', '0', '2', '2');
792 INSERT INTO `0_gl_trans` VALUES ('76', '10', '19', '2009-06-21', '1200', '', '55', '0', '0', '2', '2');
793 INSERT INTO `0_gl_trans` VALUES ('77', '10', '19', '2009-06-21', '4430', '', '-5', '0', '0', '2', '2');
794 INSERT INTO `0_gl_trans` VALUES ('78', '10', '19', '2009-06-21', '2150', '', '-2.38', '0', '0', '2', '2');
795 INSERT INTO `0_gl_trans` VALUES ('79', '11', '3', '2009-06-21', '5010', '', '-10', '2', '0', '2', '3');
796 INSERT INTO `0_gl_trans` VALUES ('80', '11', '3', '2009-06-21', '1510', '', '10', '0', '0', '2', '3');
797 INSERT INTO `0_gl_trans` VALUES ('81', '11', '3', '2009-06-21', '4010', '', '50', '2', '0', '2', '3');
798 INSERT INTO `0_gl_trans` VALUES ('82', '11', '3', '2009-06-21', '1200', '', '-52.5', '0', '0', '2', '3');
799 INSERT INTO `0_gl_trans` VALUES ('83', '11', '3', '2009-06-21', '2150', '', '2.5', '0', '0', '2', '3');
802 ### Structure of table `0_grn_batch` ###
804 DROP TABLE IF EXISTS `0_grn_batch`;
806 CREATE TABLE `0_grn_batch` (
807 `id` int(11) NOT NULL auto_increment,
808 `supplier_id` int(11) NOT NULL default '0',
809 `purch_order_no` int(11) default NULL,
810 `reference` varchar(60) NOT NULL default '',
811 `delivery_date` date NOT NULL default '0000-00-00',
812 `loc_code` varchar(5) default NULL,
814 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
817 ### Data of table `0_grn_batch` ###
819 INSERT INTO `0_grn_batch` VALUES ('1', '2', '1', '1', '2009-06-21', 'DEF');
822 ### Structure of table `0_grn_items` ###
824 DROP TABLE IF EXISTS `0_grn_items`;
826 CREATE TABLE `0_grn_items` (
827 `id` int(11) NOT NULL auto_increment,
828 `grn_batch_id` int(11) default NULL,
829 `po_detail_item` int(11) NOT NULL default '0',
830 `item_code` varchar(20) NOT NULL default '',
831 `description` tinytext,
832 `qty_recd` double NOT NULL default '0',
833 `quantity_inv` double NOT NULL default '0',
835 ) TYPE=InnoDB AUTO_INCREMENT=4 ;
838 ### Data of table `0_grn_items` ###
840 INSERT INTO `0_grn_items` VALUES ('1', '1', '1', '102', '17inch VGA Monitor', '100', '100');
841 INSERT INTO `0_grn_items` VALUES ('2', '1', '2', '103', '32MB VGA Card', '100', '100');
842 INSERT INTO `0_grn_items` VALUES ('3', '1', '3', '104', '52x CD Drive', '100', '100');
845 ### Structure of table `0_groups` ###
847 DROP TABLE IF EXISTS `0_groups`;
849 CREATE TABLE `0_groups` (
850 `id` smallint(6) unsigned NOT NULL auto_increment,
851 `description` varchar(60) NOT NULL default '',
852 `inactive` tinyint(1) NOT NULL default '0',
854 UNIQUE KEY `description` (`description`)
855 ) TYPE=MyISAM AUTO_INCREMENT=4 AUTO_INCREMENT=4 ;
858 ### Data of table `0_groups` ###
860 INSERT INTO `0_groups` VALUES ('1', 'Small', '0');
861 INSERT INTO `0_groups` VALUES ('2', 'Medium', '0');
862 INSERT INTO `0_groups` VALUES ('3', 'Large', '0');
865 ### Structure of table `0_item_codes` ###
867 DROP TABLE IF EXISTS `0_item_codes`;
869 CREATE TABLE `0_item_codes` (
870 `id` int(11) unsigned NOT NULL auto_increment,
871 `item_code` varchar(20) NOT NULL,
872 `stock_id` varchar(20) NOT NULL,
873 `description` varchar(200) NOT NULL default '',
874 `category_id` smallint(6) unsigned NOT NULL,
875 `quantity` double NOT NULL default '1',
876 `is_foreign` tinyint(1) NOT NULL default '0',
877 `inactive` tinyint(1) NOT NULL default '0',
879 UNIQUE KEY `stock_id` (`stock_id`,`item_code`)
880 ) TYPE=MyISAM AUTO_INCREMENT=6 ;
883 ### Data of table `0_item_codes` ###
885 INSERT INTO `0_item_codes` VALUES ('1', '102', '102', '17inch VGA Monitor', '1', '1', '0', '0');
886 INSERT INTO `0_item_codes` VALUES ('2', '103', '103', '32MB VGA Card', '1', '1', '0', '0');
887 INSERT INTO `0_item_codes` VALUES ('3', '104', '104', '52x CD Drive', '1', '1', '0', '0');
888 INSERT INTO `0_item_codes` VALUES ('4', '3400', '3400', 'P4 Business System', '3', '1', '0', '0');
889 INSERT INTO `0_item_codes` VALUES ('5', '201', '201', 'Assembly Labour', '4', '1', '0', '0');
892 ### Structure of table `0_item_tax_type_exemptions` ###
894 DROP TABLE IF EXISTS `0_item_tax_type_exemptions`;
896 CREATE TABLE `0_item_tax_type_exemptions` (
897 `item_tax_type_id` int(11) NOT NULL default '0',
898 `tax_type_id` int(11) NOT NULL default '0',
899 PRIMARY KEY (`item_tax_type_id`,`tax_type_id`)
903 ### Data of table `0_item_tax_type_exemptions` ###
907 ### Structure of table `0_item_tax_types` ###
909 DROP TABLE IF EXISTS `0_item_tax_types`;
911 CREATE TABLE `0_item_tax_types` (
912 `id` int(11) NOT NULL auto_increment,
913 `name` varchar(60) [BNOT NULL default '',
914 `exempt` tinyint(1) NOT NULL default '0',
915 `inactive` tinyint(1) NOT NULL default '0',
917 UNIQUE KEY `name` (`name`)
918 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
921 ### Data of table `0_item_tax_types` ###
923 INSERT INTO `0_item_tax_types` VALUES ('1', 'Regular', '0', '0');
925 ### Structure of table `0_item_units` ###
927 DROP TABLE IF EXISTS `0_item_units`;
929 CREATE TABLE `0_item_units` (
930 `abbr` varchar(20) NOT NULL,
931 `name` varchar(40) NOT NULL,
932 `decimals` tinyint(2) NOT NULL,
933 `inactive` tinyint(1) NOT NULL default '0',
934 PRIMARY KEY (`abbr`),
935 UNIQUE KEY `name` (`name`)
939 ### Data of table `0_item_units` ###
941 INSERT INTO `0_item_units` VALUES ('ea.', 'Each', '0', '0');
942 INSERT INTO `0_item_units` VALUES ('hrs', 'Hours', '1', '0');
945 ### Structure of table `0_loc_stock` ###
947 DROP TABLE IF EXISTS `0_loc_stock`;
949 CREATE TABLE `0_loc_stock` (
950 `loc_code` char(5) NOT NULL default '',
951 `stock_id` char(20) NOT NULL default '',
952 `reorder_level` bigint(20) NOT NULL default '0',
953 PRIMARY KEY (`loc_code`,`stock_id`),
954 KEY `stock_id` (`stock_id`)
958 ### Data of table `0_loc_stock` ###
960 INSERT INTO `0_loc_stock` VALUES ('DEF', '102', '0');
961 INSERT INTO `0_loc_stock` VALUES ('DEF', '103', '0');
962 INSERT INTO `0_loc_stock` VALUES ('DEF', '104', '0');
963 INSERT INTO `0_loc_stock` VALUES ('DEF', '201', '0');
964 INSERT INTO `0_loc_stock` VALUES ('DEF', '3400', '0');
967 ### Structure of table `0_locations` ###
969 DROP TABLE IF EXISTS `0_locations`;
971 CREATE TABLE `0_locations` (
972 `loc_code` varchar(5) NOT NULL default '',
973 `location_name` varchar(60) NOT NULL default '',
974 `delivery_address` tinytext NOT NULL,
975 `phone` varchar(30) NOT NULL default '',
976 `fax` varchar(30) NOT NULL default '',
977 `email` varchar(100) NOT NULL default '',
978 `contact` varchar(30) NOT NULL default '',
979 `inactive` tinyint(1) NOT NULL default '0',
980 PRIMARY KEY (`loc_code`)
984 ### Data of table `0_locations` ###
986 INSERT INTO `0_locations` VALUES ('DEF', 'Default', 'Delivery 1\r\nDelivery 2\r\nDelivery 3', '', '', '', '', '0');
989 ### Structure of table `0_movement_types` ###
991 DROP TABLE IF EXISTS `0_movement_types`;
993 CREATE TABLE `0_movement_types` (
994 `id` int(11) NOT NULL auto_increment,
995 `name` varchar(60) NOT NULL default '',
996 `inactive` tinyint(1) NOT NULL default '0',
998 UNIQUE KEY `name` (`name`)
999 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
1002 ### Data of table `0_movement_types` ###
1004 INSERT INTO `0_movement_types` VALUES ('1', 'Adjustment', '0');
1007 ### Structure of table `0_payment_terms` ###
1009 DROP TABLE IF EXISTS `0_payment_terms`;
1011 CREATE TABLE `0_payment_terms` (
1012 `terms_indicator` int(11) NOT NULL auto_increment,
1013 `terms` char(80) NOT NULL default '',
1014 `days_before_due` smallint(6) NOT NULL default '0',
1015 `day_in_following_month` smallint(6) NOT NULL default '0',
1016 `inactive` tinyint(1) NOT NULL default '0',
1017 PRIMARY KEY (`terms_indicator`),
1018 UNIQUE KEY `terms` (`terms`)
1019 ) TYPE=MyISAM AUTO_INCREMENT=5 ;
1022 ### Data of table `0_payment_terms` ###
1024 INSERT INTO `0_payment_terms` VALUES ('1', 'Due 15th Of the Following Month', '0', '17', '0');
1025 INSERT INTO `0_payment_terms` VALUES ('2', 'Due By End Of The Following Month', '0', '30', '0');
1026 INSERT INTO `0_payment_terms` VALUES ('3', 'Payment due within 10 days', '10', '0', '0');
1027 INSERT INTO `0_payment_terms` VALUES ('4', 'Cash Only', '1', '0', '0');
1030 ### Structure of table `0_prices` ###
1032 DROP TABLE IF EXISTS `0_prices`;
1034 CREATE TABLE `0_prices` (
1035 `id` int(11) NOT NULL auto_increment,
1036 `stock_id` varchar(20) NOT NULL default '',
1037 `sales_type_id` int(11) NOT NULL default '0',
1038 `curr_abrev` char(3) NOT NULL default '',
1039 `price` double NOT NULL default '0',
1041 UNIQUE KEY `price` (`stock_id`,`sales_type_id`,`curr_abrev`)
1042 ) TYPE=MyISAM AUTO_INCREMENT=5 ;
1045 ### Data of table `0_prices` ###
1047 INSERT INTO `0_prices` VALUES ('1', '3400', '1', 'USD', '100');
1048 INSERT INTO `0_prices` VALUES ('2', '102', '1', 'USD', '50');
1049 INSERT INTO `0_prices` VALUES ('3', '103', '1', 'USD', '55');
1050 INSERT INTO `0_prices` VALUES ('4', '104', '1', 'USD', '60');
1053 ### Structure of table `0_print_profiles` ###
1055 DROP TABLE IF EXISTS `0_print_profiles`;
1057 CREATE TABLE `0_print_profiles` (
1058 `id` smallint(6) unsigned NOT NULL auto_increment,
1059 `profile` varchar(30) NOT NULL,
1060 `report` varchar(5) default NULL,
1061 `printer` tinyint(3) unsigned default NULL,
1063 UNIQUE KEY `profile` (`profile`,`report`)
1064 ) TYPE=MyISAM AUTO_INCREMENT=10 ;
1067 ### Data of table `0_print_profiles` ###
1069 INSERT INTO `0_print_profiles` VALUES ('1', 'Out of office', '', '0');
1070 INSERT INTO `0_print_profiles` VALUES ('2', 'Sales Department', '', '0');
1071 INSERT INTO `0_print_profiles` VALUES ('3', 'Central', '', '2');
1072 INSERT INTO `0_print_profiles` VALUES ('4', 'Sales Department', '104', '2');
1073 INSERT INTO `0_print_profiles` VALUES ('5', 'Sales Department', '105', '2');
1074 INSERT INTO `0_print_profiles` VALUES ('6', 'Sales Department', '107', '2');
1075 INSERT INTO `0_print_profiles` VALUES ('7', 'Sales Department', '109', '2');
1076 INSERT INTO `0_print_profiles` VALUES ('8', 'Sales Department', '110', '2');
1077 INSERT INTO `0_print_profiles` VALUES ('9', 'Sales Department', '201', '2');
1080 ### Structure of table `0_printers` ###
1082 DROP TABLE IF EXISTS `0_printers`;
1084 CREATE TABLE `0_printers` (
1085 `id` tinyint(3) unsigned NOT NULL auto_increment,
1086 `name` varchar(20) NOT NULL,
1087 `description` varchar(60) NOT NULL,
1088 `queue` varchar(20) NOT NULL,
1089 `host` varchar(40) NOT NULL,
1090 `port` smallint(11) unsigned NOT NULL,
1091 `timeout` tinyint(3) unsigned NOT NULL,
1093 UNIQUE KEY `name` (`name`)
1094 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
1097 ### Data of table `0_printers` ###
1099 INSERT INTO `0_printers` VALUES ('1', 'QL500', 'Label printer', 'QL500', 'server', '127', '20');
1100 INSERT INTO `0_printers` VALUES ('2', 'Samsung', 'Main network printer', 'scx4521F', 'server', '515', '5');
1101 INSERT INTO `0_printers` VALUES ('3', 'Local', 'Local print server at user IP', 'lp', '', '515', '10');
1104 ### Structure of table `0_purch_data` ###
1106 DROP TABLE IF EXISTS `0_purch_data`;
1108 CREATE TABLE `0_purch_data` (
1109 `supplier_id` int(11) NOT NULL default '0',
1110 `stock_id` char(20) NOT NULL default '',
1111 `price` double NOT NULL default '0',
1112 `suppliers_uom` char(50) NOT NULL default '',
1113 `conversion_factor` double NOT NULL default '1',
1114 `supplier_description` char(50) NOT NULL default '',
1115 PRIMARY KEY (`supplier_id`,`stock_id`)
1119 ### Data of table `0_purch_data` ###
1121 INSERT INTO `0_purch_data` VALUES ('2', '102', '10', '', '1', '17inch VGA Monitor');
1122 INSERT INTO `0_purch_data` VALUES ('2', '103', '11', '', '1', '32MB VGA Card');
1123 INSERT INTO `0_purch_data` VALUES ('2', '104', '12', '', '1', '52x CD Drive');
1126 ### Structure of table `0_purch_order_details` ###
1128 DROP TABLE IF EXISTS `0_purch_order_details`;
1130 CREATE TABLE `0_purch_order_details` (
1131 `po_detail_item` int(11) NOT NULL auto_increment,
1132 `order_no` int(11) NOT NULL default '0',
1133 `item_code` varchar(20) NOT NULL default '',
1134 `description` tinytext,
1135 `delivery_date` date NOT NULL default '0000-00-00',
1136 `qty_invoiced` double NOT NULL default '0',
1137 `unit_price` double NOT NULL default '0',
1138 `act_price` double NOT NULL default '0',
1139 `std_cost_unit` double NOT NULL default '0',
1140 `quantity_ordered` double NOT NULL default '0',
1141 `quantity_received` double NOT NULL default '0',
1142 PRIMARY KEY (`po_detail_item`)
1143 ) TYPE=InnoDB AUTO_INCREMENT=6 ;
1146 ### Data of table `0_purch_order_details` ###
1148 INSERT INTO `0_purch_order_details` VALUES ('1', '1', '102', '17inch VGA Monitor', '2009-07-01', '100', '10', '10', '10', '100', '100');
1149 INSERT INTO `0_purch_order_details` VALUES ('2', '1', '103', '32MB VGA Card', '2009-07-01', '100', '11', '11', '11', '100', '100');
1150 INSERT INTO `0_purch_order_details` VALUES ('3', '1', '104', '52x CD Drive', '2009-07-01', '100', '12', '12', '12', '100', '100');
1151 INSERT INTO `0_purch_order_details` VALUES ('4', '2', '102', '17inch VGA Monitor', '2009-07-01', '0', '5', '0', '0', '1', '0');
1152 INSERT INTO `0_purch_order_details` VALUES ('5', '2', '103', '32MB VGA Card', '2009-07-01', '0', '5', '0', '0', '1', '0');
1155 ### Structure of table `0_purch_orders` ###
1157 DROP TABLE IF EXISTS `0_purch_orders`;
1159 CREATE TABLE `0_purch_orders` (
1160 `order_no` int(11) NOT NULL auto_increment,
1161 `supplier_id` int(11) NOT NULL default '0',
1162 `comments` tinytext,
1163 `ord_date` date NOT NULL default '0000-00-00',
1164 `reference` tinytext NOT NULL,
1165 `requisition_no` tinytext,
1166 `into_stock_location` varchar(5) NOT NULL default '',
1167 `delivery_address` tinytext NOT NULL,
1168 PRIMARY KEY (`order_no`)
1169 ) TYPE=InnoDB AUTO_INCREMENT=3 ;
1172 ### Data of table `0_purch_orders` ###
1174 INSERT INTO `0_purch_orders` VALUES ('1', '2', '', '2009-06-01', '1', '', 'DEF', 'Delivery 1\r\nDelivery 2\r\nDelivery 3');
1175 INSERT INTO `0_purch_orders` VALUES ('2', '3', '', '2009-06-21', '2', '', 'DEF', 'Delivery 1\r\nDelivery 2\r\nDelivery 3');
1178 ### Structure of table `0_quick_entries` ###
1180 DROP TABLE IF EXISTS `0_quick_entries`;
1182 CREATE TABLE `0_quick_entries` (
1183 `id` smallint(6) unsigned NOT NULL auto_increment,
1184 `type` tinyint(1) NOT NULL default '0',
1185 `description` varchar(60) NOT NULL,
1186 `base_amount` double NOT NULL default '0',
1187 `base_desc` varchar(60) default NULL,
1189 KEY `description` (`description`)
1190 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
1193 ### Data of table `0_quick_entries` ###
1195 INSERT INTO `0_quick_entries` VALUES ('1', '1', 'Maintenance', '0', 'Amount');
1196 INSERT INTO `0_quick_entries` VALUES ('2', '4', 'Phone', '0', 'Amount');
1197 INSERT INTO `0_quick_entries` VALUES ('3', '2', 'Cash Sales', '0', 'Amount');
1200 ### Structure of table `0_quick_entry_lines` ###
1202 DROP TABLE IF EXISTS `0_quick_entry_lines`;
1204 CREATE TABLE `0_quick_entry_lines` (
1205 `id` smallint(6) unsigned NOT NULL auto_increment,
1206 `qid` smallint(6) unsigned NOT NULL,
1207 `amount` double default '0',
1208 `action` varchar(2) NOT NULL,
1209 `dest_id` varchar(11) NOT NULL,
1210 `dimension_id` smallint(6) unsigned default NULL,
1211 `dimension2_id` smallint(6) unsigned default NULL,
1214 ) TYPE=MyISAM AUTO_INCREMENT=8 ;
1217 ### Data of table `0_quick_entry_lines` ###
1219 INSERT INTO `0_quick_entry_lines` VALUES ('1', '1', '0', 't-', '1', '0', '0');
1220 INSERT INTO `0_quick_entry_lines` VALUES ('2', '2', '0', 't-', '1', '0', '0');
1221 INSERT INTO `0_quick_entry_lines` VALUES ('3', '3', '0', 't-', '1', '0', '0');
1222 INSERT INTO `0_quick_entry_lines` VALUES ('4', '3', '0', '=', '4010', '0', '0');
1223 INSERT INTO `0_quick_entry_lines` VALUES ('5', '1', '0', '=', '5765', '0', '0');
1224 INSERT INTO `0_quick_entry_lines` VALUES ('6', '2', '0', '=', '5780', '0', '0');
1227 ### Structure of table `0_recurrent_invoices` ###
1229 DROP TABLE IF EXISTS `0_recurrent_invoices`;
1231 CREATE TABLE `0_recurrent_invoices` (
1232 `id` smallint(6) unsigned NOT NULL auto_increment,
1233 `description` varchar(60) NOT NULL default '',
1234 `order_no` int(11) unsigned NOT NULL,
1235 `debtor_no` int(11) unsigned default NULL,
1236 `group_no` smallint(6) unsigned default NULL,
1237 `days` int(11) NOT NULL default '0',
1238 `monthly` int(11) NOT NULL default '0',
1239 `begin` date NOT NULL default '0000-00-00',
1240 `end` date NOT NULL default '0000-00-00',
1241 `last_sent` date NOT NULL default '0000-00-00',
1243 UNIQUE KEY `description` (`description`)
1244 ) TYPE=InnoDB AUTO_INCREMENT=1 ;
1247 ### Data of table `0_recurrent_invoices` ###
1251 ### Structure of table `0_refs` ###
1253 DROP TABLE IF EXISTS `0_refs`;
1255 CREATE TABLE `0_refs` (
1256 `id` int(11) NOT NULL default '0',
1257 `type` int(11) NOT NULL default '0',
1258 `reference` varchar(100) NOT NULL default '',
1259 PRIMARY KEY (`id`,`type`)
1263 ### Data of table `0_refs` ###
1265 INSERT INTO `0_refs` VALUES ('18', '0', '1');
1266 INSERT INTO `0_refs` VALUES ('19', '0', '2');
1269 ### Structure of table `0_sales_order_details` ###
1271 DROP TABLE IF EXISTS `0_sales_order_details`;
1273 CREATE TABLE `0_sales_order_details` (
1274 `id` int(11) NOT NULL auto_increment,
1275 `order_no` int(11) NOT NULL default '0',
1276 `stk_code` varchar(20) NOT NULL default '',
1277 `description` tinytext,
1278 `qty_sent` double NOT NULL default '0',
1279 `unit_price` double NOT NULL default '0',
1280 `quantity` double NOT NULL default '0',
1281 `discount_percent` double NOT NULL default '0',
1283 ) TYPE=InnoDB AUTO_INCREMENT=6 ;
1286 ### Data of table `0_sales_order_details` ###
1288 INSERT INTO `0_sales_order_details` VALUES ('1', '1', '102', '17inch VGA Monitor', '2', '30.4', '2', '0');
1289 INSERT INTO `0_sales_order_details` VALUES ('2', '2', '102', '17inch VGA Monitor', '1', '50', '1', '0');
1290 INSERT INTO `0_sales_order_details` VALUES ('3', '3', '102', '17inch VGA Monitor', '1', '35.89', '1', '0');
1291 INSERT INTO `0_sales_order_details` VALUES ('4', '4', '102', '17inch VGA Monitor', '0', '21.28', '2', '0');
1292 INSERT INTO `0_sales_order_details` VALUES ('5', '5', '102', '17inch VGA Monitor', '1', '50', '1', '0');
1295 ### Structure of table `0_sales_orders` ###
1297 DROP TABLE IF EXISTS `0_sales_orders`;
1299 CREATE TABLE `0_sales_orders` (
1300 `order_no` int(11) NOT NULL auto_increment,
1301 `version` tinyint(1) unsigned NOT NULL default '0',
1302 `type` tinyint(1) NOT NULL default '0',
1303 `debtor_no` int(11) NOT NULL default '0',
1304 `branch_code` int(11) NOT NULL default '0',
1305 `customer_ref` tinytext NOT NULL,
1306 `comments` tinytext,
1307 `ord_date` date NOT NULL default '0000-00-00',
1308 `order_type` int(11) NOT NULL default '0',
1309 `ship_via` int(11) NOT NULL default '0',
1310 `delivery_address` tinytext NOT NULL,
1311 `contact_phone` varchar(30) default NULL,
1312 `contact_email` varchar(100) default NULL,
1313 `deliver_to` tinytext NOT NULL,
1314 `freight_cost` double NOT NULL default '0',
1315 `from_stk_loc` varchar(5) NOT NULL default '',
1316 `delivery_date` date NOT NULL default '0000-00-00',
1317 PRIMARY KEY (`order_no`)
1318 ) TYPE=InnoDB AUTO_INCREMENT=6 ;
1321 ### Data of table `0_sales_orders` ###
1323 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');
1324 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');
1325 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');
1326 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');
1327 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');
1330 ### Structure of table `0_sales_pos` ###
1332 DROP TABLE IF EXISTS `0_sales_pos`;
1334 CREATE TABLE `0_sales_pos` (
1335 `id` smallint(6) unsigned NOT NULL auto_increment,
1336 `pos_name` varchar(30) NOT NULL,
1337 `cash_sale` tinyint(1) NOT NULL,
1338 `credit_sale` tinyint(1) NOT NULL,
1339 `pos_location` varchar(5) NOT NULL,
1340 `pos_account` smallint(6) unsigned NOT NULL,
1341 `inactive` tinyint(1) NOT NULL default '0',
1343 UNIQUE KEY `pos_name` (`pos_name`)
1344 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
1347 ### Data of table `0_sales_pos` ###
1349 INSERT INTO `0_sales_pos` VALUES ('1', 'Default', '1', '1', 'DEF', '2', '0');
1352 ### Structure of table `0_sales_types` ###
1354 DROP TABLE IF EXISTS `0_sales_types`;
1356 CREATE TABLE `0_sales_types` (
1357 `id` int(11) NOT NULL auto_increment,
1358 `sales_type` char(50) NOT NULL default '',
1359 `tax_included` int(1) NOT NULL default '0',
1360 `factor` double NOT NULL default '1',
1361 `inactive` tinyint(1) NOT NULL default '0',
1363 UNIQUE KEY `sales_type` (`sales_type`)
1364 ) TYPE=MyISAM AUTO_INCREMENT=3 ;
1367 ### Data of table `0_sales_types` ###
1369 INSERT INTO `0_sales_types` VALUES ('1', 'Retail', '1', '1', '0');
1370 INSERT INTO `0_sales_types` VALUES ('2', 'Wholesale', '0', '0.7', '0');
1373 ### Structure of table `0_salesman` ###
1375 DROP TABLE IF EXISTS `0_salesman`;
1377 CREATE TABLE `0_salesman` (
1378 `salesman_code` int(11) NOT NULL auto_increment,
1379 `salesman_name` char(60) NOT NULL default '',
1380 `salesman_phone` char(30) NOT NULL default '',
1381 `salesman_fax` char(30) NOT NULL default '',
1382 `salesman_email` varchar(100) NOT NULL default '',
1383 `provision` double NOT NULL default '0',
1384 `break_pt` double NOT NULL default '0',
1385 `provision2` double NOT NULL default '0',
1386 `inactive` tinyint(1) NOT NULL default '0',
1387 PRIMARY KEY (`salesman_code`),
1388 UNIQUE KEY `salesman_name` (`salesman_name`)
1389 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
1392 ### Data of table `0_salesman` ###
1394 INSERT INTO `0_salesman` VALUES ('1', 'Sales Person', '', '', '', '5', '1000', '4', '0');
1397 ### Structure of table `0_shippers` ###
1399 DROP TABLE IF EXISTS `0_shippers`;
1401 CREATE TABLE `0_shippers` (
1402 `shipper_id` int(11) NOT NULL auto_increment,
1403 `shipper_name` varchar(60) NOT NULL default '',
1404 `phone` varchar(30) NOT NULL default '',
1405 `contact` tinytext NOT NULL,
1406 `address` tinytext NOT NULL,
1407 `inactive` tinyint(1) NOT NULL default '0',
1408 PRIMARY KEY (`shipper_id`),
1409 UNIQUE KEY `name` (`shipper_name`)
1410 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
1413 ### Data of table `0_shippers` ###
1415 INSERT INTO `0_shippers` VALUES ('1', 'Default', '', '', '', '0');
1418 ### Structure of table `0_sql_trail` ###
1420 DROP TABLE IF EXISTS `0_sql_trail`;
1422 CREATE TABLE `0_sql_trail` (
1423 `id` int(11) unsigned NOT NULL auto_increment,
1424 `sql` text NOT NULL,
1425 `result` tinyint(1) NOT NULL,
1426 `msg` varchar(255) NOT NULL,
1428 ) TYPE=MyISAM AUTO_INCREMENT=1 ;
1431 ### Data of table `0_sql_trail` ###
1435 ### Structure of table `0_stock_category` ###
1437 DROP TABLE IF EXISTS `0_stock_category`;
1439 CREATE TABLE `0_stock_category` (
1440 `category_id` int(11) NOT NULL auto_increment,
1441 `description` varchar(60) NOT NULL default '',
1442 `dflt_tax_type` int(11) NOT NULL default '1',
1443 `dflt_units` varchar(20) NOT NULL default 'each',
1444 `dflt_mb_flag` char(1) NOT NULL default 'B',
1445 `dflt_sales_act` varchar(11) NOT NULL default '',
1446 `dflt_cogs_act` varchar(11) NOT NULL default '',
1447 `dflt_inventory_act` varchar(11) NOT NULL default '',
1448 `dflt_adjustment_act` varchar(11) NOT NULL default '',
1449 `dflt_assembly_act` varchar(11) NOT NULL default '',
1450 `dflt_dim1` int(11) default NULL,
1451 `dflt_dim2` int(11) default NULL,
1452 `inactive` tinyint(1) NOT NULL default '0',
1453 PRIMARY KEY (`category_id`),
1454 UNIQUE KEY `description` (`description`)
1455 ) TYPE=MyISAM AUTO_INCREMENT=5 ;
1457 ### Data of table `0_stock_category` ###
1459 INSERT INTO `0_stock_category` VALUES ('1', 'Components', '1', 'each', 'B', '3000', '4010', '1420', '4210', '1410', '1', '1', '0');
1460 INSERT INTO `0_stock_category` VALUES ('2', 'Charges', '1', 'each', 'D', '3000', '4010', '1420', '4210', '1410', '1', '1', '0');
1461 INSERT INTO `0_stock_category` VALUES ('3', 'Systems', '1', 'each', 'M', '3000', '4010', '1420', '4210', '1410', '1', '1', '0');
1462 INSERT INTO `0_stock_category` VALUES ('4', 'Services', '1', 'hrs', 'D', '3000', '4010', '1420', '4210', '1410', '1', '1', '0');
1465 ### Structure of table `0_stock_master` ###
1467 DROP TABLE IF EXISTS `0_stock_master`;
1469 CREATE TABLE `0_stock_master` (
1470 `stock_id` varchar(20) NOT NULL default '',
1471 `category_id` int(11) NOT NULL default '0',
1472 `tax_type_id` int(11) NOT NULL default '0',
1473 `description` varchar(200) NOT NULL default '',
1474 `long_description` tinytext NOT NULL,
1475 `units` varchar(20) NOT NULL default 'each',
1476 `mb_flag` char(1) NOT NULL default 'B',
1477 `sales_account` varchar(11) NOT NULL default '',
1478 `cogs_account` varchar(11) NOT NULL default '',
1479 `inventory_account` varchar(11) NOT NULL default '',
1480 `adjustment_account` varchar(11) NOT NULL default '',
1481 `assembly_account` varchar(11) NOT NULL default '',
1482 `dimension_id` int(11) default NULL,
1483 `dimension2_id` int(11) default NULL,
1484 `actual_cost` double NOT NULL default '0',
1485 `last_cost` double NOT NULL default '0',
1486 `material_cost` double NOT NULL default '0',
1487 `labour_cost` double NOT NULL default '0',
1488 `overhead_cost` double NOT NULL default '0',
1489 `inactive` tinyint(1) NOT NULL default '0',
1490 PRIMARY KEY (`stock_id`)
1494 ### Data of table `0_stock_master` ###
1496 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');
1497 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');
1498 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');
1499 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');
1500 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');
1503 ### Structure of table `0_stock_moves` ###
1505 DROP TABLE IF EXISTS `0_stock_moves`;
1507 CREATE TABLE `0_stock_moves` (
1508 `trans_id` int(11) NOT NULL auto_increment,
1509 `trans_no` int(11) NOT NULL default '0',
1510 `stock_id` char(20) NOT NULL default '',
1511 `type` smallint(6) NOT NULL default '0',
1512 `loc_code` char(5) NOT NULL default '',
1513 `tran_date` date NOT NULL default '0000-00-00',
1514 `person_id` int(11) default NULL,
1515 `price` double NOT NULL default '0',
1516 `reference` char(40) NOT NULL default '',
1517 `qty` double NOT NULL default '1',
1518 `discount_percent` double NOT NULL default '0',
1519 `standard_cost` double NOT NULL default '0',
1520 `visible` tinyint(1) NOT NULL default '1',
1521 PRIMARY KEY (`trans_id`),
1522 KEY `type` (`type`,`trans_no`)
1523 ) TYPE=InnoDB AUTO_INCREMENT=37 ;
1526 ### Data of table `0_stock_moves` ###
1528 INSERT INTO `0_stock_moves` VALUES ('1', '1', '102', '25', 'DEF', '2009-06-21', '2', '10', '', '100', '0', '10', '1');
1529 INSERT INTO `0_stock_moves` VALUES ('2', '1', '103', '25', 'DEF', '2009-06-21', '2', '11', '', '100', '0', '11', '1');
1530 INSERT INTO `0_stock_moves` VALUES ('3', '1', '104', '25', 'DEF', '2009-06-21', '2', '12', '', '100', '0', '12', '1');
1531 INSERT INTO `0_stock_moves` VALUES ('4', '1', '102', '26', 'DEF', '2009-06-21', '0', '0', '1', '-10', '0', '0', '1');
1532 INSERT INTO `0_stock_moves` VALUES ('5', '1', '103', '26', 'DEF', '2009-06-21', '0', '0', '1', '-10', '0', '0', '1');
1533 INSERT INTO `0_stock_moves` VALUES ('6', '1', '104', '26', 'DEF', '2009-06-21', '0', '0', '1', '-10', '0', '0', '1');
1534 INSERT INTO `0_stock_moves` VALUES ('7', '1', '3400', '26', 'DEF', '2009-06-21', '0', '0', '1', '10', '0', '0', '1');
1535 INSERT INTO `0_stock_moves` VALUES ('8', '2', '102', '13', 'DEF', '2009-06-21', '0', '30.4', '1', '-2', '0', '10', '1');
1536 INSERT INTO `0_stock_moves` VALUES ('9', '3', '102', '13', 'DEF', '2009-06-21', '0', '50', 'auto', '-1', '0', '10', '1');
1537 INSERT INTO `0_stock_moves` VALUES ('10', '4', '102', '13', 'DEF', '2009-06-21', '0', '35.89', 'auto', '-1', '0', '10', '1');
1538 INSERT INTO `0_stock_moves` VALUES ('11', '3', '102', '26', 'DEF', '2009-06-21', '0', '0', '3', '-2', '0', '0', '1');
1539 INSERT INTO `0_stock_moves` VALUES ('12', '3', '103', '26', 'DEF', '2009-06-21', '0', '0', '3', '-2', '0', '0', '1');
1540 INSERT INTO `0_stock_moves` VALUES ('13', '3', '104', '26', 'DEF', '2009-06-21', '0', '0', '3', '-2', '0', '0', '1');
1541 INSERT INTO `0_stock_moves` VALUES ('14', '3', '3400', '26', 'DEF', '2009-06-21', '0', '0', '3', '2', '0', '0', '1');
1542 INSERT INTO `0_stock_moves` VALUES ('15', '4', '102', '26', 'DEF', '2009-06-21', '0', '0', '4', '-4', '0', '0', '1');
1543 INSERT INTO `0_stock_moves` VALUES ('16', '4', '103', '26', 'DEF', '2009-06-21', '0', '0', '4', '-4', '0', '0', '1');
1544 INSERT INTO `0_stock_moves` VALUES ('17', '4', '104', '26', 'DEF', '2009-06-21', '0', '0', '4', '-4', '0', '0', '1');
1545 INSERT INTO `0_stock_moves` VALUES ('18', '4', '3400', '26', 'DEF', '2009-06-21', '0', '0', '4', '4', '0', '0', '1');
1546 INSERT INTO `0_stock_moves` VALUES ('19', '2', '102', '26', 'DEF', '2009-06-21', '0', '0', '', '-2', '0', '0', '1');
1547 INSERT INTO `0_stock_moves` VALUES ('20', '2', '103', '26', 'DEF', '2009-06-21', '0', '0', '', '-2', '0', '0', '1');
1548 INSERT INTO `0_stock_moves` VALUES ('21', '2', '104', '26', 'DEF', '2009-06-21', '0', '0', '', '-2', '0', '0', '1');
1549 INSERT INTO `0_stock_moves` VALUES ('22', '1', '3400', '29', 'DEF', '2009-06-21', '0', '0', '', '2', '0', '0', '1');
1550 INSERT INTO `0_stock_moves` VALUES ('23', '5', '102', '26', 'DEF', '2009-06-21', '0', '0', '5', '-5', '0', '0', '1');
1551 INSERT INTO `0_stock_moves` VALUES ('24', '5', '103', '26', 'DEF', '2009-06-21', '0', '0', '5', '-5', '0', '0', '1');
1552 INSERT INTO `0_stock_moves` VALUES ('25', '5', '104', '26', 'DEF', '2009-06-21', '0', '0', '5', '-5', '0', '0', '1');
1553 INSERT INTO `0_stock_moves` VALUES ('26', '5', '3400', '26', 'DEF', '2009-06-21', '0', '0', '5', '5', '0', '0', '1');
1554 INSERT INTO `0_stock_moves` VALUES ('27', '6', '102', '26', 'DEF', '2009-06-21', '0', '0', '6', '5', '0', '0', '1');
1555 INSERT INTO `0_stock_moves` VALUES ('28', '6', '103', '26', 'DEF', '2009-06-21', '0', '0', '6', '5', '0', '0', '1');
1556 INSERT INTO `0_stock_moves` VALUES ('29', '6', '104', '26', 'DEF', '2009-06-21', '0', '0', '6', '5', '0', '0', '1');
1557 INSERT INTO `0_stock_moves` VALUES ('30', '6', '3400', '26', 'DEF', '2009-06-21', '0', '0', '6', '-5', '0', '0', '1');
1558 INSERT INTO `0_stock_moves` VALUES ('31', '7', '102', '26', 'DEF', '2009-06-21', '0', '0', '7', '2', '0', '0', '1');
1559 INSERT INTO `0_stock_moves` VALUES ('32', '7', '103', '26', 'DEF', '2009-06-21', '0', '0', '7', '2', '0', '0', '1');
1560 INSERT INTO `0_stock_moves` VALUES ('33', '7', '104', '26', 'DEF', '2009-06-21', '0', '0', '7', '2', '0', '0', '1');
1561 INSERT INTO `0_stock_moves` VALUES ('34', '7', '3400', '26', 'DEF', '2009-06-21', '0', '0', '7', '-2', '0', '0', '1');
1562 INSERT INTO `0_stock_moves` VALUES ('35', '5', '102', '13', 'DEF', '2009-06-21', '0', '50', 'auto', '-1', '0', '10', '1');
1563 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');
1566 ### Structure of table `0_supp_allocations` ###
1568 DROP TABLE IF EXISTS `0_supp_allocations`;
1570 CREATE TABLE `0_supp_allocations` (
1571 `id` int(11) NOT NULL auto_increment,
1572 `amt` double unsigned default NULL,
1573 `date_alloc` date NOT NULL default '0000-00-00',
1574 `trans_no_from` int(11) default NULL,
1575 `trans_type_from` int(11) default NULL,
1576 `trans_no_to` int(11) default NULL,
1577 `trans_type_to` int(11) default NULL,
1579 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
1582 ### Data of table `0_supp_allocations` ###
1584 INSERT INTO `0_supp_allocations` VALUES ('1', '3465', '2009-06-21', '4', '22', '7', '20');
1587 ### Structure of table `0_supp_invoice_items` ###
1589 DROP TABLE IF EXISTS `0_supp_invoice_items`;
1591 CREATE TABLE `0_supp_invoice_items` (
1592 `id` int(11) NOT NULL auto_increment,
1593 `supp_trans_no` int(11) default NULL,
1594 `supp_trans_type` int(11) default NULL,
1595 `gl_code` varchar(11) NOT NULL default '0',
1596 `grn_item_id` int(11) default NULL,
1597 `po_detail_item_id` int(11) default NULL,
1598 `stock_id` varchar(20) NOT NULL default '',
1599 `description` tinytext,
1600 `quantity` double NOT NULL default '0',
1601 `unit_price` double NOT NULL default '0',
1602 `unit_tax` double NOT NULL default '0',
1605 ) TYPE=InnoDB AUTO_INCREMENT=6 ;
1608 ### Data of table `0_supp_invoice_items` ###
1610 INSERT INTO `0_supp_invoice_items` VALUES ('1', '7', '20', '0', '1', '1', '102', '17inch VGA Monitor', '100', '10', '0.5', '');
1611 INSERT INTO `0_supp_invoice_items` VALUES ('2', '7', '20', '0', '2', '2', '103', '32MB VGA Card', '100', '11', '0.55', '');
1612 INSERT INTO `0_supp_invoice_items` VALUES ('3', '7', '20', '0', '3', '3', '104', '52x CD Drive', '100', '12', '0.6', '');
1613 INSERT INTO `0_supp_invoice_items` VALUES ('4', '8', '20', '2150', '0', '0', '', '', '0', '0.95', '0', 'Phone');
1614 INSERT INTO `0_supp_invoice_items` VALUES ('5', '8', '20', '5780', '0', '0', '', '', '0', '19.05', '0', 'Phone');
1617 ### Structure of table `0_supp_trans` ###
1619 DROP TABLE IF EXISTS `0_supp_trans`;
1621 CREATE TABLE `0_supp_trans` (
1622 `trans_no` int(11) unsigned NOT NULL default '0',
1623 `type` smallint(6) unsigned NOT NULL default '0',
1624 `supplier_id` int(11) unsigned default NULL,
1625 `reference` tinytext NOT NULL,
1626 `supp_reference` varchar(60) NOT NULL default '',
1627 `tran_date` date NOT NULL default '0000-00-00',
1628 `due_date` date NOT NULL default '0000-00-00',
1629 `ov_amount` double NOT NULL default '0',
1630 `ov_discount` double NOT NULL default '0',
1631 `ov_gst` double NOT NULL default '0',
1632 `rate` double NOT NULL default '1',
1633 `alloc` double NOT NULL default '0',
1634 PRIMARY KEY (`trans_no`,`type`),
1635 KEY `supplier_id` (`supplier_id`),
1636 KEY `SupplierID_2` (`supplier_id`,`supp_reference`),
1641 ### Data of table `0_supp_trans` ###
1643 INSERT INTO `0_supp_trans` VALUES ('4', '22', '2', '1', '', '2009-06-21', '2009-06-21', '-3465', '0', '0', '1', '3465');
1644 INSERT INTO `0_supp_trans` VALUES ('7', '20', '2', '1', '5t', '2009-06-21', '2009-07-01', '3300', '0', '165', '1', '3465');
1645 INSERT INTO `0_supp_trans` VALUES ('8', '20', '2', '2', 'cc', '2009-06-21', '2009-07-01', '20', '0', '0', '1', '0');
1648 ### Structure of table `0_suppliers` ###
1650 DROP TABLE IF EXISTS `0_suppliers`;
1652 CREATE TABLE `0_suppliers` (
1653 `supplier_id` int(11) NOT NULL auto_increment,
1654 `supp_name` varchar(60) NOT NULL default '',
1655 `address` tinytext NOT NULL,
1656 `supp_address` tinytext NOT NULL,
1657 `phone` varchar(30) NOT NULL default '',
1658 `fax` varchar(30) NOT NULL default '',
1659 `gst_no` varchar(25) NOT NULL default '',
1660 `contact` varchar(60) NOT NULL default '',
1661 `supp_account_no` varchar(40) NOT NULL default '',
1662 `email` varchar(100) NOT NULL default '',
1663 `website` varchar(100) NOT NULL default '',
1664 `bank_account` varchar(60) NOT NULL default '',
1665 `curr_code` char(3) default NULL,
1666 `payment_terms` int(11) default NULL,
1667 `dimension_id` int(11) default '0',
1668 `dimension2_id` int(11) default '0',
1669 `tax_group_id` int(11) default NULL,
1670 `credit_limit` double NOT NULL default '0',
1671 `purchase_account` varchar(11) default NULL,
1672 `payable_account` varchar(11) default NULL,
1673 `payment_discount_account` varchar(11) default NULL,
1674 `notes` tinytext NOT NULL,
1675 `inactive` tinyint(1) NOT NULL default '0',
1676 PRIMARY KEY (`supplier_id`)
1677 ) TYPE=MyISAM AUTO_INCREMENT=4 ;
1680 ### Data of table `0_suppliers` ###
1682 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');
1683 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');
1684 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');
1687 ### Structure of table `0_sys_types` ###
1689 DROP TABLE IF EXISTS `0_sys_types`;
1691 CREATE TABLE `0_sys_types` (
1692 `type_id` smallint(6) NOT NULL default '0',
1693 `type_name` varchar(60) NOT NULL default '',
1694 `type_no` int(11) NOT NULL default '1',
1695 `next_reference` varchar(100) NOT NULL default '',
1696 PRIMARY KEY (`type_id`)
1700 ### Data of table `0_sys_types` ###
1702 INSERT INTO `0_sys_types` VALUES ('0', 'Journal - GL', '19', '3');
1703 INSERT INTO `0_sys_types` VALUES ('1', 'Payment - GL', '8', '2');
1704 INSERT INTO `0_sys_types` VALUES ('2', 'Receipt - GL', '5', '2');
1705 INSERT INTO `0_sys_types` VALUES ('4', 'Funds Transfer', '3', '1');
1706 INSERT INTO `0_sys_types` VALUES ('10', 'Sales Invoice', '19', '4');
1707 INSERT INTO `0_sys_types` VALUES ('11', 'Credit Note', '3', '2');
1708 INSERT INTO `0_sys_types` VALUES ('12', 'Receipt', '6', '1');
1709 INSERT INTO `0_sys_types` VALUES ('13', 'Delivery', '5', '2');
1710 INSERT INTO `0_sys_types` VALUES ('16', 'Location Transfer', '2', '1');
1711 INSERT INTO `0_sys_types` VALUES ('17', 'Inventory Adjustment', '2', '1');
1712 INSERT INTO `0_sys_types` VALUES ('18', 'Purchase Order', '1', '3');
1713 INSERT INTO `0_sys_types` VALUES ('20', 'Supplier Invoice', '8', '3');
1714 INSERT INTO `0_sys_types` VALUES ('21', 'Supplier Credit Note', '1', '1');
1715 INSERT INTO `0_sys_types` VALUES ('22', 'Supplier Payment', '4', '2');
1716 INSERT INTO `0_sys_types` VALUES ('25', 'Purchase Order Delivery', '1', '2');
1717 INSERT INTO `0_sys_types` VALUES ('26', 'Work Order', '1', '8');
1718 INSERT INTO `0_sys_types` VALUES ('28', 'Work Order Issue', '1', '1');
1719 INSERT INTO `0_sys_types` VALUES ('29', 'Work Order Production', '1', '2');
1720 INSERT INTO `0_sys_types` VALUES ('30', 'Sales Order', '1', '1');
1721 INSERT INTO `0_sys_types` VALUES ('35', 'Cost Update', '1', '1');
1722 INSERT INTO `0_sys_types` VALUES ('40', 'Dimension', '1', '3');
1725 ### Structure of table `0_tax_group_items` ###
1727 DROP TABLE IF EXISTS `0_tax_group_items`;
1729 CREATE TABLE `0_tax_group_items` (
1730 `tax_group_id` int(11) NOT NULL default '0',
1731 `tax_type_id` int(11) NOT NULL default '0',
1732 `rate` double NOT NULL default '0',
1733 PRIMARY KEY (`tax_group_id`,`tax_type_id`)
1737 ### Data of table `0_tax_group_items` ###
1739 INSERT INTO `0_tax_group_items` VALUES ('1', '1', '5');
1742 ### Structure of table `0_tax_groups` ###
1744 DROP TABLE IF EXISTS `0_tax_groups`;
1746 CREATE TABLE `0_tax_groups` (
1747 `id` int(11) NOT NULL auto_increment,
1748 `name` varchar(60) NOT NULL default '',
1749 `tax_shipping` tinyint(1) NOT NULL default '0',
1750 `inactive` tinyint(1) NOT NULL default '0',
1752 UNIQUE KEY `name` (`name`)
1753 ) TYPE=InnoDB AUTO_INCREMENT=3 ;
1756 ### Data of table `0_tax_groups` ###
1758 INSERT INTO `0_tax_groups` VALUES ('1', 'Tax', '0', '0');
1759 INSERT INTO `0_tax_groups` VALUES ('2', 'Tax Exempt', '0', '0');
1761 ### Structure of table `0_tax_types` ###
1763 DROP TABLE IF EXISTS `0_tax_types`;
1765 CREATE TABLE `0_tax_types` (
1766 `id` int(11) NOT NULL auto_increment,
1767 `rate` double NOT NULL default '0',
1768 `sales_gl_code` varchar(11) NOT NULL default '',
1769 `purchasing_gl_code` varchar(11) NOT NULL default '',
1770 `name` varchar(60) NOT NULL default '',
1771 `inactive` tinyint(1) NOT NULL default '0',
1773 ) TYPE=InnoDB AUTO_INCREMENT=5 AUTO_INCREMENT=5 ;
1776 ### Data of table `0_tax_types` ###
1778 INSERT INTO `0_tax_types` VALUES ('1', '5', '2150', '2150', 'Tax', '0');
1780 ### Structure of table `0_trans_tax_details` ###
1782 DROP TABLE IF EXISTS `0_trans_tax_details`;
1784 CREATE TABLE `0_trans_tax_details` (
1785 `id` int(11) NOT NULL auto_increment,
1786 `trans_type` smallint(6) default NULL,
1787 `trans_no` int(11) default NULL,
1788 `tran_date` date NOT NULL,
1789 `tax_type_id` int(11) NOT NULL default '0',
1790 `rate` double NOT NULL default '0',
1791 `ex_rate` double NOT NULL default '1',
1792 `included_in_price` tinyint(1) NOT NULL default '0',
1793 `net_amount` double NOT NULL default '0',
1794 `amount` double NOT NULL default '0',
1797 ) TYPE=InnoDB AUTO_INCREMENT=12 ;
1800 ### Data of table `0_trans_tax_details` ###
1802 INSERT INTO `0_trans_tax_details` VALUES ('1', '20', '7', '2009-06-21', '1', '5', '1', '0', '3300', '165', '5t');
1803 INSERT INTO `0_trans_tax_details` VALUES ('2', '13', '3', '2009-06-21', '1', '5', '1', '0', '50', '2.5', 'auto');
1804 INSERT INTO `0_trans_tax_details` VALUES ('3', '10', '17', '2009-06-21', '1', '5', '1', '0', '50', '2.5', '1');
1805 INSERT INTO `0_trans_tax_details` VALUES ('4', '13', '4', '2009-06-21', '1', '5', '1.3932', '0', '35.89', '1.7945', 'auto');
1806 INSERT INTO `0_trans_tax_details` VALUES ('5', '10', '18', '2009-06-21', '1', '5', '1.3932', '0', '35.89', '1.7945', '2');
1807 INSERT INTO `0_trans_tax_details` VALUES ('6', '2', '5', '2009-06-21', '1', '5', '1', '0', '95.2', '4.76', '');
1808 INSERT INTO `0_trans_tax_details` VALUES ('7', '1', '8', '2009-06-21', '1', '5', '1', '0', '-47.6', '-2.38', '');
1809 INSERT INTO `0_trans_tax_details` VALUES ('8', '20', '8', '2009-06-21', '1', '5', '1', '0', '-19', '-0.95', 'cc');
1810 INSERT INTO `0_trans_tax_details` VALUES ('9', '13', '5', '2009-06-21', '1', '5', '1', '1', '47.619047619048', '2.3809523809524', 'auto');
1811 INSERT INTO `0_trans_tax_details` VALUES ('10', '10', '19', '2009-06-21', '1', '5', '1', '1', '47.619047619048', '2.3809523809524', '3');
1812 INSERT INTO `0_trans_tax_details` VALUES ('11', '11', '3', '2009-06-21', '1', '5', '1.3932', '0', '35.89', '1.7945', '1');
1814 ### Structure of table `0_users` ###
1816 DROP TABLE IF EXISTS `0_users`;
1818 CREATE TABLE `0_users` (
1819 `id` SMALLINT(6) AUTO_INCREMENT,
1820 `user_id` varchar(60) NOT NULL default '',
1821 `password` varchar(100) NOT NULL default '',
1822 `real_name` varchar(100) NOT NULL default '',
1823 `full_access` int(11) NOT NULL default '1',
1824 `phone` varchar(30) NOT NULL default '',
1825 `email` varchar(100) default NULL,
1826 `language` varchar(20) default NULL,
1827 `date_format` tinyint(1) NOT NULL default '0',
1828 `date_sep` tinyint(1) NOT NULL default '0',
1829 `tho_sep` tinyint(1) NOT NULL default '0',
1830 `dec_sep` tinyint(1) NOT NULL default '0',
1831 `theme` varchar(20) NOT NULL default 'default',
1832 `page_size` varchar(20) NOT NULL default 'A4',
1833 `prices_dec` smallint(6) NOT NULL default '2',
1834 `qty_dec` smallint(6) NOT NULL default '2',
1835 `rates_dec` smallint(6) NOT NULL default '4',
1836 `percent_dec` smallint(6) NOT NULL default '1',
1837 `show_gl` tinyint(1) NOT NULL default '1',
1838 `show_codes` tinyint(1) NOT NULL default '0',
1839 `show_hints` tinyint(1) NOT NULL default '0',
1840 `last_visit_date` datetime default NULL,
1841 `query_size` tinyint(1) default '10',
1842 `graphic_links` tinyint(1) default '1',
1843 `pos` smallint(6) default '1',
1844 `print_profile` varchar(30) NOT NULL default '1',
1845 `rep_popup` tinyint(1) default '1',
1846 `sticky_doc_date` tinyint(1) default '0',
1847 `inactive` tinyint(1) NOT NULL default '0',
1849 UNIQUE KEY (`user_id`)
1850 ) TYPE=MyISAM AUTO_INCREMENT=2;
1853 ### Data of table `0_users` ###
1855 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');
1856 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');
1858 ### Structure of table `0_voided` ###
1860 DROP TABLE IF EXISTS `0_voided`;
1862 CREATE TABLE `0_voided` (
1863 `type` int(11) NOT NULL default '0',
1864 `id` int(11) NOT NULL default '0',
1865 `date_` date NOT NULL default '0000-00-00',
1866 `memo_` tinytext NOT NULL,
1867 UNIQUE KEY `id` (`type`,`id`)
1871 ### Data of table `0_voided` ###
1875 ### Structure of table `0_wo_issue_items` ###
1877 DROP TABLE IF EXISTS `0_wo_issue_items`;
1879 CREATE TABLE `0_wo_issue_items` (
1880 `id` int(11) NOT NULL auto_increment,
1881 `stock_id` varchar(40) default NULL,
1882 `issue_id` int(11) default NULL,
1883 `qty_issued` double default NULL,
1885 ) TYPE=InnoDB AUTO_INCREMENT=1 ;
1888 ### Data of table `0_wo_issue_items` ###
1892 ### Structure of table `0_wo_issues` ###
1894 DROP TABLE IF EXISTS `0_wo_issues`;
1896 CREATE TABLE `0_wo_issues` (
1897 `issue_no` int(11) NOT NULL auto_increment,
1898 `workorder_id` int(11) NOT NULL default '0',
1899 `reference` varchar(100) default NULL,
1900 `issue_date` date default NULL,
1901 `loc_code` varchar(5) default NULL,
1902 `workcentre_id` int(11) default NULL,
1903 PRIMARY KEY (`issue_no`)
1904 ) TYPE=InnoDB AUTO_INCREMENT=1 ;
1907 ### Data of table `0_wo_issues` ###
1911 ### Structure of table `0_wo_manufacture` ###
1913 DROP TABLE IF EXISTS `0_wo_manufacture`;
1915 CREATE TABLE `0_wo_manufacture` (
1916 `id` int(11) NOT NULL auto_increment,
1917 `reference` varchar(100) default NULL,
1918 `workorder_id` int(11) NOT NULL default '0',
1919 `quantity` double NOT NULL default '0',
1920 `date_` date NOT NULL default '0000-00-00',
1922 ) TYPE=InnoDB AUTO_INCREMENT=2 ;
1925 ### Data of table `0_wo_manufacture` ###
1927 INSERT INTO `0_wo_manufacture` VALUES ('1', '1', '2', '2', '2009-06-21');
1930 ### Structure of table `0_wo_requirements` ###
1932 DROP TABLE IF EXISTS `0_wo_requirements`;
1934 CREATE TABLE `0_wo_requirements` (
1935 `id` int(11) NOT NULL auto_increment,
1936 `workorder_id` int(11) NOT NULL default '0',
1937 `stock_id` char(20) NOT NULL default '',
1938 `workcentre` int(11) NOT NULL default '0',
1939 `units_req` double NOT NULL default '1',
1940 `std_cost` double NOT NULL default '0',
1941 `loc_code` char(5) NOT NULL default '',
1942 `units_issued` double NOT NULL default '0',
1944 ) TYPE=InnoDB AUTO_INCREMENT=22 ;
1947 ### Data of table `0_wo_requirements` ###
1949 INSERT INTO `0_wo_requirements` VALUES ('1', '1', '102', '1', '1', '0', 'DEF', '10');
1950 INSERT INTO `0_wo_requirements` VALUES ('2', '1', '103', '1', '1', '0', 'DEF', '10');
1951 INSERT INTO `0_wo_requirements` VALUES ('3', '1', '104', '1', '1', '0', 'DEF', '10');
1952 INSERT INTO `0_wo_requirements` VALUES ('4', '2', '102', '1', '1', '0', 'DEF', '0');
1953 INSERT INTO `0_wo_requirements` VALUES ('5', '2', '103', '1', '1', '0', 'DEF', '0');
1954 INSERT INTO `0_wo_requirements` VALUES ('6', '2', '104', '1', '1', '0', 'DEF', '0');
1955 INSERT INTO `0_wo_requirements` VALUES ('7', '3', '102', '1', '1', '0', 'DEF', '2');
1956 INSERT INTO `0_wo_requirements` VALUES ('8', '3', '103', '1', '1', '0', 'DEF', '2');
1957 INSERT INTO `0_wo_requirements` VALUES ('9', '3', '104', '1', '1', '0', 'DEF', '2');
1958 INSERT INTO `0_wo_requirements` VALUES ('10', '4', '102', '1', '1', '0', 'DEF', '4');
1959 INSERT INTO `0_wo_requirements` VALUES ('11', '4', '103', '1', '1', '0', 'DEF', '4');
1960 INSERT INTO `0_wo_requirements` VALUES ('12', '4', '104', '1', '1', '0', 'DEF', '4');
1961 INSERT INTO `0_wo_requirements` VALUES ('13', '5', '102', '1', '1', '0', 'DEF', '5');
1962 INSERT INTO `0_wo_requirements` VALUES ('14', '5', '103', '1', '1', '0', 'DEF', '5');
1963 INSERT INTO `0_wo_requirements` VALUES ('15', '5', '104', '1', '1', '0', 'DEF', '5');
1964 INSERT INTO `0_wo_requirements` VALUES ('16', '6', '102', '1', '1', '0', 'DEF', '-5');
1965 INSERT INTO `0_wo_requirements` VALUES ('17', '6', '103', '1', '1', '0', 'DEF', '-5');
1966 INSERT INTO `0_wo_requirements` VALUES ('18', '6', '104', '1', '1', '0', 'DEF', '-5');
1967 INSERT INTO `0_wo_requirements` VALUES ('19', '7', '102', '1', '1', '0', 'DEF', '-2');
1968 INSERT INTO `0_wo_requirements` VALUES ('20', '7', '103', '1', '1', '0', 'DEF', '-2');
1969 INSERT INTO `0_wo_requirements` VALUES ('21', '7', '104', '1', '1', '0', 'DEF', '-2');
1972 ### Structure of table `0_workcentres` ###
1974 DROP TABLE IF EXISTS `0_workcentres`;
1976 CREATE TABLE `0_workcentres` (
1977 `id` int(11) NOT NULL auto_increment,
1978 `name` char(40) NOT NULL default '',
1979 `description` char(50) NOT NULL default '',
1980 `inactive` tinyint(1) NOT NULL default '0',
1982 UNIQUE KEY `name` (`name`)
1983 ) TYPE=MyISAM AUTO_INCREMENT=2 ;
1986 ### Data of table `0_workcentres` ###
1988 INSERT INTO `0_workcentres` VALUES ('1', 'Workshop', 'Workshop in Alabama', '0');
1991 ### Structure of table `0_workorders` ###
1993 DROP TABLE IF EXISTS `0_workorders`;
1995 CREATE TABLE `0_workorders` (
1996 `id` int(11) NOT NULL auto_increment,
1997 `wo_ref` varchar(60) NOT NULL default '',
1998 `loc_code` varchar(5) NOT NULL default '',
1999 `units_reqd` double NOT NULL default '1',
2000 `stock_id` varchar(20) NOT NULL default '',
2001 `date_` date NOT NULL default '0000-00-00',
2002 `type` tinyint(4) NOT NULL default '0',
2003 `required_by` date NOT NULL default '0000-00-00',
2004 `released_date` date NOT NULL default '0000-00-00',
2005 `units_issued` double NOT NULL default '0',
2006 `closed` tinyint(1) NOT NULL default '0',
2007 `released` tinyint(1) NOT NULL default '0',
2008 `additional_costs` double NOT NULL default '0',
2010 UNIQUE KEY `wo_ref` (`wo_ref`)
2011 ) TYPE=InnoDB AUTO_INCREMENT=8 ;
2014 ### Data of table `0_workorders` ###
2016 INSERT INTO `0_workorders` VALUES ('1', '1', 'DEF', '10', '3400', '2009-06-21', '0', '2009-06-21', '2009-06-21', '10', '1', '1', '10');
2017 INSERT INTO `0_workorders` VALUES ('2', '2', 'DEF', '3', '3400', '2009-06-21', '2', '2009-07-11', '2009-06-21', '2', '0', '1', '0');
2018 INSERT INTO `0_workorders` VALUES ('3', '3', 'DEF', '2', '3400', '2009-06-21', '0', '2009-06-21', '2009-06-21', '2', '1', '1', '0');
2019 INSERT INTO `0_workorders` VALUES ('4', '4', 'DEF', '4', '3400', '2009-06-21', '0', '2009-06-21', '2009-06-21', '4', '1', '1', '0');
2020 INSERT INTO `0_workorders` VALUES ('5', '5', 'DEF', '5', '3400', '2009-06-21', '0', '2009-06-21', '2009-06-21', '5', '1', '1', '10');
2021 INSERT INTO `0_workorders` VALUES ('6', '6', 'DEF', '-5', '3400', '2009-06-21', '1', '2009-06-21', '2009-06-21', '-5', '1', '1', '0');
2022 INSERT INTO `0_workorders` VALUES ('7', '7', 'DEF', '-2', '3400', '2009-06-21', '1', '2009-06-21', '2009-06-21', '-2', '1', '1', '10');