#AcumaticaTnT Translation Dictionaries (SM200540) screen - Translated Strings

When using the Translation Dictionaries (SM200540) screen in Acumatica to translate field labels into another language or simply to change what they say, the data gets stored in the database.

You can see in this screenshot that I've relabeled the standard Last Order Date label (in the Source Value column) to Last Invoice Date (in the English column).

Where does this get stored in the database? Well, Source Value gets stored in LocalizationValue.NeutralValue and English gets stored in LocalizationTranslation.Value.

One thing to note is that, as far as I can tell, the Source Value records are stored in LocalizationValue.NeutralValue with a CompanyID of 1 by default. But, if you click COLLECT STRINGS on the Translation Dictionaries (SM200540) screen which, WARNING, takes a long time to run (about an hour for me), then the records get copied to CompanyID for the Tenant that you're logged into. Also, any customizations that you've done get included in those records since CompanyID=1 is just standard Acumatica stuff without any Customizations.

That's important to note because I already pressed COLLECT STRINGS before running the following SQL statement:

SELECT LT.CompanyID,LV.NeutralValue,LT.Value
FROM LocalizationTranslation LT WITH(NOLOCK)
LEFT OUTER JOIN LocalizationValue LV WITH(NOLOCK)
	ON LT.CompanyID=LV.CompanyID
	AND LT.IdValue=LV.Id

Which returned the following result:

If you don't want to press COLLECT STRINGS since you don't have any custom strings that you want to translate, you can simply pickup the standard labels by hardcoding CompanyID=1 using this SQL statement:

SELECT LT.CompanyID,LV.NeutralValue,LT.Value
FROM LocalizationTranslation LT WITH(NOLOCK)
LEFT OUTER JOIN LocalizationValue LV WITH(NOLOCK)
	ON LV.CompanyID=1
	AND LT.IdValue=LV.Id