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

updateLedgerJournalTrans_IN

Description

Updates the LedgerJournalTrans table. The record IDs of the CustomsTariffCode, ExciseTariffCode and ServiceCode tables are now stored in place of the CustomsTariffCode_IN, ExciseTariffCode_IN and ServiceCode_IN values.

Affected Modules and Tables

Affected Modules

Ledger

Affected Tables

CustomsTariffCodeTable_IN

ExciseTariffCodes_IN

LedgerJournalTrans

ServiceCodeTable_IN

Data Migration Section

From Table: CustomsTariffCodeTable_IN

To Table: LedgerJournalTrans

RecId

CustomsTariffCodeTable_IN

From Table: ExciseTariffCodes_IN

To Table: LedgerJournalTrans

RecId

ExciseTariffCodes_IN

From Table: ServiceCodeTable_IN

To Table: LedgerJournalTrans

RecId

ServiceCodeTable_IN

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

LedgerJournalTrans

CustomsTariffCodeTable_IN

RefRecId

LedgerJournalTrans

ExciseTariffCodes_IN

RefRecId

LedgerJournalTrans

ServiceCodeTable_IN

RefRecId

Deleted Tables or Fields

Table

Field

LedgerJournalTrans

del_CustomsTariffCode_IN

LedgerJournalTrans

del_ExciseTariffCode_IN

LedgerJournalTrans

del_ServiceCode_IN