I want to populate a BAM's table manually, but i need to provide three additional values, beyond that i can see in Architect, in the fields SysIterID, SysIterTrID and SysIterTotalsChild, present in every BAM' schema table.
I realized that the field SysIterID is an auto increment (starting in zero for each table) and SysIterTotalsChild is always zero. But as the SysIterTrID, it seems a global crosstable counter.
Anybody knows where can I get next SysIterTrID? I thought it was the field "value" in the table "SysIterSequence", but the SysIterTrID created after insert a record in a BAM's table on Architect has a different number.
Thanks a lot.
Is there some specialist that can help me with this problem?
I need to copy rows from one table to another, via table trigger, to consolidate information sent by BPM prrocesss through Process Analytics, but I need to know how to discover the next SyIterTrID I must use.
So, can you tell me where I find the next (or last) SysI'terTrID to use (used)?