INSERT INTO `comp_supplier_invoice` (`shippingMethodID`, `purchaserID`, `memo`, `locationID`, `currencyID`, `companyID`, `createdBy`, `purchaseInvoiceCodeID`, `supplierID`, `shipToID`, `formNo`, `invoiceDate`, `supplierInvoiceNo`, `projectID`, `termsID`, `exchangeRate`) VALUES ('', '', '', '14', 'MYR', '86', '19', 2, '43', '12', 'PI20140828', '2013-08-09', '435435', '28', '5', '1')