Special Instructions: Bumping M1 Tables to Force Field Population


Using Microsoft SQL SMS against your M1 database, run the following query:


The [TABLENAME] and [COLUMNAME] fields are expected to be replaced with appropriate data. The column that you use for this "bumping" is not important; it simply needs to be in that table. For example, if you wanted to "bump" the Parts table, your query could look like this:

Update Parts set impPartID = impPartID