Need to understand the significance of Display id field in ORPM
I need a clarification pertaining to the display id field which we are having in OPRM tables. RPM_CLEARANCE, RPM_PRICE_CHANGE,RPM_PROMOTION. In literal terms, its the id that would be used by the end user to search the respective price events. But i still want to understand the significance of having a seperate column for eg. clearance_display_id. Why can't we make the functionality only with clearance_id?
Based on my understanding, the clearance_display_id is getting used in the below way:
1. Create a clearance and don't approve. RPM_CLEARANCE table will have a record inserted.