INSERT INTO `comp_sales_invoice` (`invoiceCodeID`, `customerID`, `currencyID`, `formNo`, `salesInvoiceDate`, `customerPoNo`, `projectID`, `agentID`, `termsID`, `shipToID`, `exchangeRate`, `locationID`, `totalTaxAmount`, `totalReceivable`, `totalamount`, `memo`, `employeeID`, `shippingMethodID`, `companyID`, `createdBy`, `showSaleAgent`) VALUES (2, '40', '1', 'INV', '2014-10-14', 'ere', '30', '', '2', '24', '1.00000', '15', 0, '10.6', '10.6', '', '', '', '93', '16', '0')