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 ('41', '1', 'SON', '2014-09-19', 'asdf342', '', '', '2', '21', '1.00', '15', '', '', '', '93', '16', '1', '0.00', '0.00', 0, '0')