Is it possible to have same RecId between header and line table ?

(0) Share

Report

Posted on by Ken Manhattan

552

Hi guys,

Recently I've been facing weird issue, whereby the RecId in Purchase Order (PurchTable) and its Line (PurchLine), are same. Could this be possible ? Cause all this while as per my understanding, Rec Id is always unique.

Is there any reason or it is just something wrong in my system ? and may I get advice how to check this ?

Thanks.

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Martin Dráb 237,976 Most Valuable Professional on at

Like (1)

Report

It's completely possible, because RecId is a unique ID of a record in a table, not unique ID regardless of a table.

For example, when you create the first record in PurchTable and in PurchLine, both may get the record ID of one.

Was this reply helpful? Yes No
Suggested answer

Bharani Preetham Pe... 3,634 Moderator on at

Like (2)

Report

Your understanding is right. RecId is always unique. But it doesn't mean that a RecId should be unique across all tables in D365. This is unique only at that table. So, this particular scenario can happen and it won't harm anything.

Was this reply helpful? Yes No
Suggested answer

Layan Jwei 8,118 Super User 2025 Season 2 on at

Like (1)

Report

Hi Ken,

Yes that's totally fine and it's a coincidence. PurchTable and PurchLine relates to each other with PurchId and not recid even if recids were similar. Also as Martin and Bharani said, recId is unique per table.

Thanks,

Layan Jweihan,

Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future

Was this reply helpful? Yes No
Ken Manhattan 552 on at

Like (0)

Report

Hi all,

Thanks you very much for the explanation. I, honestly just knew this, all this while I thought RecId is unique across the entire tables in the D365 FO system (or shall I say database). May I know is there any "formal" resource or document from Microsoft mentioned this ? Or some explanation about what is RecId and most importantly stated it is unique in scope of table, but not with other tables.

I tried to google it but unfortunately cannot find any.

Thanks in advance

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,976 Most Valuable Professional on at

Like (2)

Report

Giving you a "formal" resources may prove difficult, due to briefness of AX/F&O development documentation. Maybe Inside Dynamics AX books have it stated explicitly; unfortunately I'm not at home and can't consult them for you.

But you'll find it discussed at many places and you'll also proofs inside the application (if seeing that you have tables with identical record IDs isn't a sufficient proof for you). For instance, you can see that SystemSequences table holds information about record IDs by table ID.

Was this reply helpful? Yes No