Sequence in PG&C Substance

Hi folks,

I'm looking for a way to create a sequence for PG&C's substances.

Substances in PG&C don't have a sequence generator like parts or changes, it uses the attribute called name as the primary key.

But I need to have a number to identify each substance, it's for a integration purposes.

On Agile's DB, Substance table, there is a column called ID that shows a number for each substance, this the kind of code that I need.

is there a way to retrieve this number with Groovy Script when I create a new substance?

My best

Carlos