-- Dumping data for table `0_crm_contacts`
--
-
-- --------------------------------------------------------
--
`alloc` double NOT NULL default '0',
`rate` double NOT NULL default '1',
`ship_via` int(11) default NULL,
- `trans_link` int(11) NOT NULL default '0',
`dimension_id` int(11) NOT NULL default '0',
`dimension2_id` int(11) NOT NULL default '0',
`payment_terms` int(11) default NULL,
`discount_percent` double NOT NULL default '0',
`standard_cost` double NOT NULL default '0',
`qty_done` double NOT NULL default '0',
+ `src_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
- KEY `Transaction` (`debtor_trans_type`,`debtor_trans_no`)
+ KEY `Transaction` (`debtor_trans_type`,`debtor_trans_no`),
+ KEY (`src_id`)
) TYPE=InnoDB AUTO_INCREMENT=1 ;
--
INSERT INTO `0_fiscal_year` VALUES(1, '2008-01-01', '2008-12-31', 0);
INSERT INTO `0_fiscal_year` VALUES(2, '2009-01-01', '2009-12-31', 0);
-
--- --------------------------------------------------------
+INSERT INTO `0_fiscal_year` VALUES(3, '2010-01-01', '2010-12-31', 0);
--
-- Table structure for table `0_gl_trans`
`requisition_no` tinytext,
`into_stock_location` varchar(5) NOT NULL default '',
`delivery_address` tinytext NOT NULL,
+ `total` double NOT NULL default '0',
+ `tax_included` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`order_no`),
KEY `ord_date` (`ord_date`)
) TYPE=InnoDB AUTO_INCREMENT=1 ;
`from_stk_loc` varchar(5) NOT NULL default '',
`delivery_date` date NOT NULL default '0000-00-00',
`payment_terms` int(11) default NULL,
+ `total` double NOT NULL default '0',
PRIMARY KEY (`trans_type`,`order_no`)
) TYPE=InnoDB;
`bank_account` varchar(60) NOT NULL default '',
`curr_code` char(3) default NULL,
`payment_terms` int(11) default NULL,
+ `tax_included` tinyint(1) NOT NULL default '0',
`dimension_id` int(11) default '0',
`dimension2_id` int(11) default '0',
`tax_group_id` int(11) default NULL,
`ov_gst` double NOT NULL default '0',
`rate` double NOT NULL default '1',
`alloc` double NOT NULL default '0',
+ `tax_included` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`type`,`trans_no`),
KEY `supplier_id` (`supplier_id`),
KEY `SupplierID_2` (`supplier_id`,`supp_reference`),