Benefit Record ID not available
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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