Optional alternative translation object for duplicate entries

Hi Erwin,

Can you provide some examples where columns with the same ID should have different translations?

Two Real life Examples:

example 1:

On an inventory transactions screen you can change the current stock level. The transaction unit of measurement is not necessarily the same as the stock keeping unit of measurement (example the stock keeping unit is gram but the transaction unit is kilogram). To store the information for this there are 2 columns, transaction quantity and inventory quantity.

The problem with the naming is that inventory quantity suggest this column is giving you information about the total amount of inventory. In reality it is the transaction quantity corrected against the stock keeping unit of measurement.

During development the name inventory_quantity probably made sense, however now it does not. And then you are left with the only feasible option: to make a new expression column just to rename this one column. Renaming the column and changing every trigger, stored procedure, view, task, parameter etc. is not a feasible option.

example 2:

on a pick list screen there are a number of lines with items to pick. For each line there is a column quantity_needed. This is the amount needed to pick for this particular line (or article/item). However, it is also possible to process the picking list in parts(not every item has been picked entirely example: you need 100 items but only 50 have been picked so far). Doing this means the quantity needed (50) will be lower then the original quantity needed (100).

So when only processing pick lists that are completely done the name quantity needed makes sense. But with the option to process a pick list partially the name is a bit ambiguous. The name suggests it is the original amount, but in actually it is the amount still needed (original amount - already shipped amount).

Also in this case, when only processing complete pick lists the name quantity needed makes sense, but with the added option of processing lists partially the name is no longer correct. As with example 1 renaming the column would mean changing every trigger, stored procedure, view, task, parameter etc. so for this another expression column needs to be created.