Added sold status and lot revenue
Add private sequence generator