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