"Number" field in customer_contact table?

[aizawaken]

Hi Community members,

I have a simple question.

Contact[customer_contact] table does not have a "number" field as a formatted id field, even most of important tables have "number" field, for example Account[customer_account] table has "number" field.

I just feel strange this,,,
Does anyone know the reasons why not exist?

[Sai Kumar P · Accepted solution]

Hi @aizawaken ,

In ServiceNow, If you observe the "number" field is commonly used for tables that contain tracking and workflow focused data. This simplifies tracking by including a table-specific prefix and a sequential number. On the other hand, many other tables, such as User, Group, Role, Department, and Location, do not include a "number" field because they are designed as configurable or reference data. These tables are not intended for tracking purposes, unlike transactional tables like Incident (INC), Request (REQ), Change Request (CHG), or Case, which are specifically created for tracking and workflow-related purposes.

-----------------------------------------------------------------------------------------------------------------------------------

                               If this is working for you, Accept the solution and mark it as helpful

[aizawaken]

Hi @Sai Kumar P , thanks for your comment!
I got understand your point clearly!

[Sai Kumar P]

Hi @aizawaken ,

If your query is resolved, can you accept the solution and close this thread.

-----------------------------------------------------------------------------------------------------------------------------------

                               If this is working for you, Accept the solution and mark it as helpful