Benefit Record ID not available

Guru23
Kilo Contributor

‎11-05-2023 05:27 PM

Hi team,

 

I am looking to add  a unique ID  on benefit plan table that comes up as a related list in Project records, however there is no substantial ID  available that can correspond to the Benefit plan. In simple language, i would need a benefit plan number bnxxxxxx for referencing the records.

 

I can add a new field on the table but we are not looking to customize the table. Does benefit plan table comes without ID in OOB. Is there a way out ?

 

Looking forward for quick response.

 

Cheers

guru

0 Helpfuls
  • 256 Views
2 REPLIES 2

Tai Vu
Kilo Patron
Kilo Patron

‎11-05-2023 07:05 PM

Hi @Guru23 

You can activate Auto-number in the table configuration [sys_db_object]. Just be noticed that the numbering will only apply for new records.

Screenshot 2023-11-06 at 10.00.31.png

 

It'll create a new field Number in the Benefit Plan table, and create new Numbering in the Numbers [sys_number] table.

 

Cheers,

Tai Vu

 

 

 

0 Helpfuls

yogesh41
ServiceNow Employee
ServiceNow Employee

‎11-05-2023 08:27 PM

Hi Guru,

Unfortunately, there is NO out of box field available to satisfy your requirements.  There is internal unique id named 'Sys Id' but that is not human readable. Introducing custom field of type Number would be correct approach. 

 

Yogesh 

0 Helpfuls