How to differentiate between inherited fields and created in the same table.

[Anupriya1]

Hi All,

Can someone help me in identifying the fields created on a specific table and the fields inherited by that table from its parent table.

I am unable to find any specific column for the same.

Thanks in Advance!

[Mark Roethof]

Hi there,

One of the may ways could be:

On a field, you can right click and select "Show". For example:

On incident, number is actually from table task!

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark

---

LinkedIn
Community article list

[Mark Roethof]

Other option would be to go to the dictionary of the table. Something like below will be shown. Easily to spot which table the fields actually are on. 

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark

---

LinkedIn
Community article list

[Anupriya1]

Hi Mark,

Going to sys_dictionary table, will list all the fields present in the specific table(Inherited + Created). It is not giving me the information to identify between both.

Thanks!

[Mark Roethof]

Could you explain what other information you need then? I mean it does tell if a field is inherited (in the example, task), and does tell which field is on that specific table (in the example, incident).

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark

---

LinkedIn
Community article list