ReleaseUpdateDB60_Ledger.allowDupClaimPerRGRegisterDateIdx_IN Upgrade Script

  • Article

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

allowDupClaimPerRGRegisterDateIdx_IN

Description

Updates the RGRegisterDateIdx index in the ClaimPercentage_IN table to allow for duplicate records.

Affected Modules and Tables

Affected Modules

Ledger

Affected Tables

ClaimPercentage_IN

Remarks

The TaxComponent field is replaced with the new TaxComponentTable surrogate key field in the RGRegisterDateIdx unique index. Also, the FromDate and ToDate fields are replaced with the DateEffectivity, ValidFrom and ValidTo fields. Initially these fields contain no values. So the index is set to allow for duplicates before the field is updated with the value of the record IDs of the corresponding tables.