web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

Why logistics location table doesn't have datareaId

(0) ShareShare
ReportReport
Posted on by 1,907

Hi some tables like logisticsLocation and dirPartyLocation doesn't have dataArea. Why is that?

I have the same question (0)
  • Suggested answer
    Gunjan Bhattachayya Profile Picture
    35,423 on at
    RE: Why logistics location table doesn't have datareaId

    Hi IntegrationBeginner,

    Both the tables have the property "Save Data Per Company" set to "No", which signifies that the data in these tables are shared across all companies. That's why these tables don't have DataAreaId field.

  • .. Profile Picture
    1,907 on at
    RE: Why logistics location table doesn't have datareaId

    Hi Gunjan,

    Would it be considered wrong to change their property to yes? I mean didn't they made it shared for a reason?

  • Gunjan Bhattachayya Profile Picture
    35,423 on at
    RE: Why logistics location table doesn't have datareaId

    Hi IntegrationBeginner,

    You won't be able to change this property as well. If you create an extension of either of these tables, this property will be greyed out.

    Any reason you are looking for the DataArea field in these tables?

  • .. Profile Picture
    1,907 on at
    RE: Why logistics location table doesn't have datareaId

    Hi Gunjan,

    True DirPartyTable, LogisitcsLocation and DirPartyLocation has this property saved to no and I can't change it when extending. But why DirPartyTable alone has a dataAreaId when selecting it in SQL?

  • Suggested answer
    Gunjan Bhattachayya Profile Picture
    35,423 on at
    RE: Why logistics location table doesn't have datareaId

    Hi IntegrationBeginner,

    The field you see in DirPartyTable is DataArea and not "DataAreaId" (which is the field name in other company specific tables). This field is from CompanyInfo table.

    pastedimage1646599007920v1.png

    CompanyInfo table extends OMInternalOrganization, which extends DirOrganizationBase, which in turn extends DirPartyTable. Hence you see this field in SQL while querying DirPartyTable.

  • .. Profile Picture
    1,907 on at
    RE: Why logistics location table doesn't have datareaId

    Hi Gunjan,

    1. So what does this mean? When company info is filled and not Null

    ?Does it mean that records in DirPartyTable can be used in different legal entities?

    2. for LogisticsLocation, and DirPartyLocation? When the property is set To No, does it mean that these records can be shared with different legal entities? And how?

    3. So if in DirPartyCDSEntity, if I extend it and add the dataArea field  then I have two options:

    a. Change the primary company Context property of the entity to DataArea. When inserting a record what will happen?

    b. I can leave the primary company Context empty, but when inserting a record in this entity, I can say entity.DataArea = usmf

    What's the difference between option a and b? What will happen in both cases?

  • André Arnaud de Calavon Profile Picture
    299,407 Super User 2025 Season 2 on at
    RE: Why logistics location table doesn't have datareaId

    Hi IntegrationBeginner,

    The DirParty table as well as LogisticsLocation and DirParty table global because they belong to  the Global address book which is non restricted to legal entities.

    I will try to provide answers to your questions:

    1) The DataArea field is filled in case there is a record in this table for a legal entity. It will then store the Legal entity ID. The Global address book contains records for all organizations and persons; including the legal entities.

    2) These tables are related to the address for the global address book records which is shared. For that reason, also these tables and some more are shared.

    3) Can you explain the background of this question? This entity is related to Dual Write. What do you want to achieve by changing something to this entity?  

  • .. Profile Picture
    1,907 on at
    RE: Why logistics location table doesn't have datareaId

    Hi Andre,

    1-a When u said data area will be filled when there is a record in this table for a legal entity? When will this happen? I tried to create a customer in usmf data area..the custTable dataArea was USMF but it's dirPartyTable was null. So I don't get it.

    1-b when u say it's shared because it belongs to the global address book which is not restricted to legal entities. What do u mean by this? Does that mean if there is a customer party record with certain name and certain field values. And if I go and create a customer in another legal entity with the same values, it will use this party record and not create a new one?

    2. For point 2 I have the same question as 1-b ..what does shared mean.. does it mean same customers in different legal entities can have the same dirParyTable, same logistics Location and same DirPartyLocation if all values are exactly the same?

    3. When a party record gets Inserted in CE, I want a party record to get inserted in F&O

    3-a I would like to know what will happen if I extend the entity, add company info DataArea field then fill the primary context property with DataArea. Then I insert into the this entity without filling dataArea with Anything? Or if I fill it with something?

    Example: entity.DataArea=usmf

    Entity.Insert

    Or entity.Insert without specifying dataArea

    What does each one mean?

    3-b if I extend the entity and dataArea field but leave the primary context empty

    If I do

    entity.DataArea=usmf

    Entity.Insert

    What does it mean?

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    299,407 Super User 2025 Season 2 on at
    RE: Why logistics location table doesn't have datareaId

    Hi IntegrationBeginner,

    First of all, it would be a good start to read the documentation about the Global Address Book: Global address book overview - Finance & Operations | Dynamics 365 | Microsoft Docs

    1-a. When you create a new legal entity, then also a record will be inserted in the DirPartyTable. The company ID will then be filled in the DataAreaID field. This field is only used for this type of internal organization. For external organizations like customers, this field in the DirPartyTable is not applicable. The customer has a reference only to the DirPartyTable record.

    1-b. Correct. When you create a new customer in another legal entity, you will get a popup if the name is the same or similar to an existing organization name in the global address book. You will then have the option to link it to an existing party or create a new one.

    2. This is correct. One party can be linked to multiple customers in multiple legal entities. It can also be linked to a vendor in the same legal entity. It will then have shared information about addresses and some more details.

    3. As the global address book does not have any legal entity context, it would not make sense to make any modifications to try to get a DataArea filled. The DataArea field on the DirPartyTable is not used for customers; only for DirPartyTable records linked to a legal entity.

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

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 1,933

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 793 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 537 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans