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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / EnumIdTable and EnumVa...
Finance | Project Operations, Human Resources, ...
Suggested Answer

EnumIdTable and EnumValueTable

(0) ShareShare
ReportReport
Posted on by Tony zhong 903

Hi guys,

What refresh/populate EnumValueTable and EnumIdTable ? Since these table is not access in AOT.

I found my table EnumValueTable is not really populated with all exiting Enums, even with Standard enums.

Take example in EnumIdTable, for StatusIssue ->

pastedimage1635922243564v1.png

cannot find it in EnumValueTable ->

pastedimage1635922292498v2.png

But this is not the case for Enum InventTransType ->

pastedimage1635922457385v3.png

Thanks

I have the same question (0)
  • Suggested answer
    Suresh M. Parmar Profile Picture
    Suresh M. Parmar 340 on at

    Hello Tony,

    EnumValueTable, EnumIdTable is the standard table that contains enum information, when you add new enum and enum value at the time of database synchronization new changes will be reflected or added on those tables automatically.

    Thanks,

    Suresh Parmar

  • Tony zhong Profile Picture
    Tony zhong 903 on at

    Hi,

    Mean to say it is during Synchronization, right ? However I have synchronize it without error, also the example that I attached is standard Enums, I'm wondering why it does not have records for that Enum StatusIssue or StatusReceipt. I haven't take a look for all though, only happened to need this but cannot find it.

    May I know do you have this records in your DB ?

    Thanks,

  • Suggested answer
    Joris dG Profile Picture
    Joris dG 17,775 on at

    The only enums in the value table are extensible enums. This is because their value is not determined when you create the enum, but rather it depends on the environment (and so it has to be stored somewhere, which is the value table).

    Technically the F&O runtime creates the records. However, DB Sync starts part of the runtime and since it runs before the AOS comes back up, practically yes during db sync these values get created.

  • Tony zhong Profile Picture
    Tony zhong 903 on at

    Hi Joris, thanks,

    Means to says, there is actually no table info-ing the complete enums with their value (and perhaps the label, at least with the standard language defined in parameters) ?

    I'm finding that the list of enums with all this information is important when we're doing "integration part" when F&O wants to be used with other platform.

    There is another table contain this enums list, SRSAnalysisEnums, but this table also has some condition, that only listed enums that being used in Aggregate Measurements.

    And then there is another last one, RetailEnumValueTable, but looking into the name, is there any other condition, lets say it must be used in Retails or I must activate Retails features ? I'm guessing at least we need to activate it since I just tried to do SystableBrowser for this table and having error saying I have no authorization.

    Thanks,

  • Alex VN Profile Picture
    Alex VN 1,994 on at

    Hi Tony,

    As explained the information only show for extensible enum so with standard table query we might not get full list of the enum. Instead I can suggest you to use X++ to get the list of available enum as below:

    dynamicsaxtechstuff.wordpress.com/.../

    Hope this helps.

    Regards,

    Anh Ong

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

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

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 555 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 364

#3
Diego Mancassola Profile Picture

Diego Mancassola 259

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans