We are using the Export to Datalake capability of D365 to load up a data warehouse. To get the product item description in the current system language, we would like to join to the SystemParameters table, systemlanguageid column. However, our environment has 3 records in SystemParameters table. Using the systablebrowser, I can tell that the current record is the one with the most recent modified date time. I am looking for confirmation that using the MODIFIEDDATETIME, filtering to the most recent, is the right approach to obtaining the current SystemParameters record. Is there a different, more appropriate criteria? I could not find useful documentation online regarding this.
