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, '1', '1', 'INV20150511', '2015-04-30', '', '', '', '3', 'null', '1.00000', '1', 0, '63600', '63600', '', '', '', '1', '1', '0')