How do I fix the error: Cannot insert the value NULL into column 'AddressType' -- Microsoft Dynamics SL (Solomon) .NET Software by Catalina Technology a Microsoft Solomon ISV

How do I fix the error: Cannot insert the value NULL into column 'AddressType', table 'SOHeader'

Message - Cannot insert the value NULL into column 'AddressType', table 'SOHeader'; column does not allow nulls. INSERT fails.

There are certain update scenarios that don't redefine defaults for some of the distribution tables. This specific error can be fixed by manually redefining the defaults on soHeader.
Run the following procedure in query analyzer: exec Dmg_define_Table_defaults 'soheader'

If there are more tables getting this error, you can look at the apptableupgrade.sql script in the db directory of your solomon install. In there, you will see a whole section of code running these "exec define table defaults" for a lot of other distribution tables. Those are all ok to cut paste in Query Analyzer and run on an app db to define/reset the defaults.