UpdateTableAndFieldIDs

This function updates table and optionally field IDs in list/library setups and related mappings. The main use is during upgrade – to fix the NavSherpa data, if some related tables change.

Parameters:

"_OldTableID" - Specifies the old ID of the table.
"_NewTableID" - Specifies the new ID of the table.
(Optional) "_FieldIDs" - Specifies the list of fields that have different IDs.
(Optional) "_ListSetupFilter" - Specifies the list/library setup filter. If not blank, the changes will be applied to selected setups only.

Code example:

var

NSPInterface: Codeunit "NSP Interface";

FieldIDs: Dictionary of [Integer, Integer];

//Table has new ID in AL, but the field IDs did not change

NSPInterface.UpdateTableAndFieldIDs(90828, 55028); //Asset Check Header

//Table has new ID in AL and some fields has a different ID, too

Clear(FieldIDs);

FieldIDs.Add(90819, 106); //Active

FieldIDs.Add(90820, 107); //Implementer By PR Type

NSPInterface.UpdateTableAndFieldIDs(90813, 55013, FieldIDs);

//Call the same operation, but for some list/library setups only

NSPInterface.UpdateTableAndFieldIDs(90813, 55013, FieldIDs, 'INCDOC_LIST|INCDOC_DOCS');