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 |