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 ('81', '1', '27', 'PI', '2014-08-05', '33', '1111', '23', 0, '17', '1', '1', '9', 'test', '27', '4', '29', '0', '670', '670')