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`, `showSaleAgent`) VALUES (2, '202', 'BW', '2015-06-12', '', '', '', '2', 'null', '1.00000', '1', '1', '', '', '', '1', '1', 0, '27227.19', '27227.19', '0')