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 ('1', '1', '30', 'PI20141009MLK', '2014-10-09', '20', 'hvb', '2', 0, '1', '7', '1.00000', 0, '', '30', '4', '16', '0', '100', '100')