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, '53', '1', 'SI20141030', '2014-10-30', 'customer po no1', '', '', '3', '', '1.00000', '31', 0, '74200', '74200', '', '', '', '111', '16', '0')