Condividi tramite


ReleaseUpdateDB60_Ledger.allowDupEximDEPBExportOrderTable_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

allowDupEximDEPBExportOrderTable_IN

Description

Updates the SchemeTableProductGroupIdx index in the EximDEPBExportOrderTable_IN table to allow for duplicate records.

Affected Modules and Tables

Affected Modules

Ledger

Affected Tables

EximDEPBExportOrderTable_IN

Remarks

The ProductGroup field is replaced with the new EximProductGroupTableis surrogate key field in the SchemeTableProductGroupIdx unique index. Initially the EximProductGroupTablefield field contains no value. So the index is set to allow for duplicates before the field is updated with the value of the record ID field in the EximProductGroupTable_IN table.