Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / What is a .RecId? Ref:...
Finance | Project Operations, Human Resources, ...
Answered

What is a .RecId? Ref: LogisticsLocation.RecId. LogisticsLocation table contains no such field.

(1) ShareShare
ReportReport
Posted on by jt1024 452
Hello,
 
I'm investigating how Logistics Location data is stored and related for a user functionality request.
 
I see this relation display name in the ProjTable: ProjTable.DeliveryLocation == LogisticsLocation.RecId
 
So I go to look at the LogisticsLocation table in the AOT, and I only see the following fields:
Fields in LogisticsLocation:
  • Description
  • DunsNumberRecId
  • IsPostalAddress
  • LocationId
  • ParentLocation
I'm thinking RecId is a D365 development concept of which I have not encountered in my training so far.
 
Can anyone help me understand this a bit better?
 
Thanks again.
  • jt1024 Profile Picture
    jt1024 452 on at
    What is a .RecId? Ref: LogisticsLocation.RecId. LogisticsLocation table contains no such field.
    Hello André,
     
    Ah yes of course! That makes sense.
     
    Thanks André!
     
     
  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,151 Super User 2024 Season 2 on at
    What is a .RecId? Ref: LogisticsLocation.RecId. LogisticsLocation table contains no such field.
    Hi Jt1024,
     

    No. The DeliveryLcation_FK is a relation, not a field. FYI, The LogisticsLocation has a LocationID field which is a reference to a record in the LogisticsPostalAddresses table. This table contains the actual delivery address details.
     
  • jt1024 Profile Picture
    jt1024 452 on at
    What is a .RecId? Ref: LogisticsLocation.RecId. LogisticsLocation table contains no such field.
    Hello again Mohit,
    I liked your explanation, especially this: even though it is in table, you can't see it in table fields but can access RecID field in code level or from SQL server
     
    I hope this isn't too much scope creep on this forum posting, but now I have to ask:
     
    So then this relation definition ProjTable.DeliveryLocation == LogisticsLocation.RecId found in relation named DeliveryLocation_FK in Application Suite Table: ProjTable, will hold what kind of data? The Primary Key RecID from LogisticsLocation?
    When I do a table browser on the Application Suite Table: ProjTable, I can't see a DeliveryLocation_FK column.  Shouldn't I be able to see that?
  • Suggested answer
    Hana Xue Profile Picture
    Hana Xue Microsoft Employee on at
    What is a .RecId? Ref: LogisticsLocation.RecId. LogisticsLocation table contains no such field.
    Hi,
    RecId stands for Record Identifier. It is often called RowId (row identifier). The RECID is a unique key for each record in each table. It can be used as a unique reference key throughout the complete database. So in a non-technical way: an internal, unique key for a record.
    RecId relation is used in many places in the system, for example in from many tables to LogisticsPostalAddress or LogisticsLocation.In forms, you can use ReferenceGroup to automatically show data from behind a RecId relation.
    You can also briefly check in the official MS documentation:
    LogisticsLocation in Main - Common Data Model - Common Data Model | Microsoft Learn

    Best Regards,
    Hana
  • Community member Profile Picture
    Community member 36 on at
    What is a .RecId? Ref: LogisticsLocation.RecId. LogisticsLocation table contains no such field.
    Hi,
     
    Refer to the below blog.
     
    Thanks,
    Girish S.
  • Suggested answer
    Mohit Rampal Profile Picture
    Mohit Rampal 12,547 Super User 2024 Season 1 on at
    What is a .RecId? Ref: LogisticsLocation.RecId. LogisticsLocation table contains no such field.
    Hi, Every record is associated with a RecId (Record ID). Whenever a record is inserted in a table, a recId is generated for that record. RecID is unique in every record. It is a system defined field, even though it is in table, you can't see it in table fields but can access RecID field in code level or from SQL server.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,151 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,963 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans