Ice.Lib.NextValue Database Table

Kinetic ERP
1

Does anyone know what table the values for Ice.Lib.NextValue are stored in?

1 Like
2

There are start values in Erp.XaSyst,

3

That is not the right table.

seinfeld GIF by HULU

2 Likes
4

Ice.SysSequence

5

That table does not exist! Or I can’t see it, which would be weird.

Awkward Season 4 GIF by The Office

1 Like
6

or erp.keylast contains various others

7

Nope, not there.

Swing Miss GIF by MOODMAN

8

It’s there in 2024.1 and 2023 sure it’s in others

9

Ah, could be a SaaS thing then. @klincecum , can you see that table in BAQ?

1 Like
10

I think this is it. For example, you won’t see Ice.SysUserFile and a few other Ice tables.

1 Like
11

I can see SysUserFile

12

Both of them? Ice and Erp?

13

Just Ice

1 Like
14

Can’t see SysSequence in 10.2.400.

15

Hmm. I couldn’t when I was on SaaS. It has more columns than the Erp.UserFile. Interesting.

16

Not in XXXChunk or XXXDef

17

Funny, can’t do a BAQ against SysSequence, but I could add it to my Function.

Confused What The GIF by Sesame Street

1 Like
18

When you say can’t see them, do you just mean in a baq? Some tables are excluded from baqs for technical and other reasons but can be accessed with the Db context.

Not at my pc right now or I’d poke around.

1 Like
19

Yeah, I meant in a BAQ. Trying to find out if the SysSequence table is where Ice.Lib.NextValue stores its info.

21

I think that table wont show up in BAQ, yep its where NextValue stores the next sequence. We create some Custom UD ones on-prem too.

2 Likes