INSERT INTO `comp_supplier_invoice` (`shippingMethodID`, `purchaserID`, `memo`, `locationID`, `currencyID`, `companyID`, `createdBy`, `purchaseInvoiceCodeID`, `supplierID`, `shipToID`, `formNo`, `invoiceDate`, `supplierInvoiceNo`, `projectID`, `termsID`, `exchangeRate`) VALUES ('8', '36', 'sds', '15', 'MYR', '93', '16', 2, '47', '13', 'PI', '2014-09-16', 'dd', '30', '3', '1')