ReleaseUpdateDB60_Basic.updateGDL_CA_BussinessNumber Upgrade Script

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

Class	ReleaseUpdateDB60_Basic
Method	updateGDL_CA_BussinessNumber
Description	Updates the CompanyInfo field in the table TaxRegistration_CA with the value from the RecId field of the CompanyInfo table.

Affected Modules and Tables

Affected Modules
Basic

Affected Tables
TaxRegistration_CA

Remarks

This upgrade is required in order to properly related records from the CompanyInfo and TaxRegistration_CA tables. In Microsoft Dynamics AX 2009 the BusinessNumber field was a foreign key field for the CompanyInfo table that was related to the TaxRegistration_CA table. In Microsoft Dynamics AX 2012 the CompanyInfo table on the TaxRegistration_CA table is a foreign key.

Data Migration Section

From Table: CompanyInfo	To Table: TaxRegistration_CA
RecId	CompanyInfo

New Tables or Fields

Table	Field	Extended Data Type -or- Base Enum
TaxRegistration_CA	CompanyInfo	RefRecId

Deleted Tables or Fields

Table	Field
CompanyInfo	BusinessNumber