ReleaseUpdateDB60_Ledger.allowNoDupTaxSetOffRuleCompColumnIdx_IN 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_Ledger

Method

allowNoDupTaxSetOffRuleCompColumnIdx_IN

Description

Updates the ComponentColumnIdx and ComponentTypeSetOffComponentTypeIdx indexes in the TaxSetOffRule_IN table not to allow for duplicate records.

Affected Modules and Tables

Affected Modules

Ledger

Affected Tables

TaxSetOffRule_IN

Remarks

After updating the TaxComponentTable surrogate key field with the value of the RecId field in the TaxComponentTable_IN table, the ComponentColumnIdx and ComponentTypeSetOffComponentTypeIdx index is reset not to allow for duplicate records.