INSERT INTO `comp_supplier_invoice` (`shippingMethodID`, `purchaserID`, `memo`, `locationID`, `currencyID`, `companyID`, `createdBy`, `purchaseInvoiceCodeID`, `supplierID`, `shipToID`, `formNo`, `invoiceDate`, `supplierInvoiceNo`, `projectID`, `termsID`, `exchangeRate`) VALUES ('3', '76', '', '34', '1', '111', '43', 2, '66', '22', 'PI', '2014-10-17', 'PSSB45678', '', '4', '1.00000')