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, '15', '2', 'SON20141008', '2014-10-08', 'po from maxis', '1', '', '27', '', '3.13050', '2', 0, '3180', '3180', '', '', '', '1', '16', '0')