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

updateEximVendInvoiceTrans_IN

Description

Updates the EximVendInvoiceTrans_IN table. The values of the RecId field of the EximIncentiveSchemeGroup_IN, EximPorts_IN, and EximProductGroupTable_IN tables are now stored in place of the IncentiveSchemeGroup, PortId, and ProductGroup values.

Affected Modules and Tables

Affected Modules

Ledger

Affected Tables

EximIncentiveSchemeGroup_IN

EximPorts_IN

EximProductGroupTable_IN

EximVendInvoiceTrans_IN

Data Migration Section

From Table: EximIncentiveSchemeGroup_IN

To Table: EximVendInvoiceTrans_IN

RecId

EximIncentiveSchemeGroup

From Table: EximPorts_IN

To Table: EximVendInvoiceTrans_IN

RecId

EximPorts

From Table: EximProductGroupTable_IN

To Table: EximVendInvoiceTrans_IN

RecId

EximProductGroupTable

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

EximVendInvoiceTrans_IN

EximIncentiveSchemeGroup

RefRecId

EximVendInvoiceTrans_IN

EximPorts

RefRecId

EximVendInvoiceTrans_IN

EximProductGroupTable

RefRecId

Deleted Tables or Fields

Table

Field

EximVendInvoiceTrans_IN

del_IncentiveSchemeGroup

EximVendInvoiceTrans_IN

del_PortId

EximVendInvoiceTrans_IN

del_ProductGroup