INSERT INTO `comp_sales_invoice` (`customerID`, `invoiceCodeID`, `formNo`, `salesInvoiceDate`, `customerPoNo`, `projectID`, `agentID`, `termsID`, `shipToID`, `exchangeRate`, `locationID`, `memo`, `employeeID`, `shippingMethodID`, `companyID`, `createdBy`, `currencyID`, `totalTaxAmount`, `totalReceivable`, `totalamount`, `showSaleAgent`) VALUES ('42', '1', 'SON', '2014-09-25', 'sds', '', '', '2', 'null', '1.00', '16', '', '', '', '93', '16', '1', '0.06', '1.06', '1.06', '0')