INSERT INTO `comp_sales_invoice` (`invoiceCodeID`, `customerID`, `formNo`, `salesInvoiceDate`, `customerPoNo`, `projectID`, `agentID`, `termsID`, `shipToID`, `exchangeRate`, `locationID`, `currencyID`, `memo`, `employeeID`, `shippingMethodID`, `companyID`, `createdBy`, `totalTaxAmount`, `totalReceivable`, `totalamount`) VALUES (2, '12', 'SON20140811', '2014-08-11', 'sdw', '24', '1', '18', '1', '3.1305', '2', '1', 'cvx', '6', '5', '1', '1', 0, '12', '12')