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 ('93', '1', '38', 'PI', '2014-09-16', '48', 'xcx', '30', 0, '2', 0, '1', '15', 'xf', '38', '8', '16', '70.2', '1240.2', '1170')