INSERT INTO `supplier` (`companyID`, `supplierCode`, `supplierCompanyNo`, `supplierName`, `attention`, `line1`, `line2`, `line3`, `supplierPostCode`, `email`, `website`, `phoneNumber1`, `phoneNumber2`, `fax`, `generalNote`, `gstRegNo`, `termsID`, `supplierCountryID`, `supplierStateID`, `linkedAPAccountID`, `currencyID`, `creditLimit`, `termstatus`, `createdDate`) VALUES ('1', 'SAM-12345', 'samblaze1234', 'Sambolic', '', 'Address', 'Line1111', 'Line2222', '12291', '', '', '', '', '', 'General Note', 'A234-A', '5', '50', '278', '1', '1', '12345', '5', '2014-08-20')