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 ('84', '1', '29', 'PI20140813', '2014-08-11', '34', 'asdfasdf1234', '26', 0, '17', 0, '', '10', 'lorem ipsum dolor sit emet', '29', '73', '33', '7.38', '130.38', '123')