added soft delete and change amount to decimal data type