ReleaseUpdateDB60_Basic.allowDupTaxRegistration_CAAccountTypeIdx 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	allowDupTaxRegistration_CAAccountTypeIdx
Description	Updates the AccountTypeIdx index in the TaxRegistration_CA table to allow duplicate records.

Affected Modules and Tables

Affected Modules
Basic

Affected Tables
TaxRegistration_CA

Remarks

The BusinessNumber field is replaced with the new surrogate key CompanyInfo field in the AccountTypeIdx unique index. Initially this field contains no value. So the index is set to allow duplicates before the field is updated with the value of the record ID field of the CompanyInfo table. After updating the CompanyInfo surrogate key field with the value of the record ID field of the CompanyInfo table, the AccountTypeIdx index is reset not to allow duplicate records.