INSERT INTO `comp_supplier_invoice` (`shippingMethodID`, `purchaserID`, `memo`, `locationID`, `currencyID`, `companyID`, `createdBy`, `purchaseInvoiceCodeID`, `supplierID`, `shipToID`, `formNo`, `invoiceDate`, `supplierInvoiceNo`, `projectID`, `termsID`, `exchangeRate`) VALUES ('', '', '', '1', '1', '1', '1', 2, '3', '', 'PI20150511', '2015-04-01', 'INV001', '', '3', '1.00000')