INSERT INTO `comp_supplier_invoice` (`companyID`, `purchaseInvoiceCodeID`, `purchaserID`, `formNo`, `invoiceDate`, `supplierID`, `supplierInvoiceNo`, `projectID`, `agentID`, `termsID`, `shipToID`, `exchangeRate`, `locationID`, `memo`, `employeeID`, `shippingMethodID`, `createdBy`, `totalTaxAmount`, `totalPayable`, `totalAmount`) VALUES ('111', '1', '76', 'PI', '2014-11-03', '64', 'asfdasdf888', '35', 0, '3', '20', '1.00000', 0, 'asdfasdfasd', '76', '8', '33', '2.4', '42.4', '42.4')