Compartir a través de


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