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, '12', '1', 'SON20141008', '2014-10-08', 'jhkjl', '1', '15', '27', '8', '1.00000', '2', 0, '10', '10', '', '', '', '1', '16', '0')