`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 ;
--
`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 ;
`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`),