ReleaseUpdateDB60_Trv.updateTrvExpTransProj 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_Trv

Method

updateTrvExpTransProj

Description

Copies the ActivityNumber field from the DEL_TrvExpTrans_Proj table to the TrvExpTrans table.

Affected Modules and Tables

Affected Modules

Expense management

Affected Tables

DEL_TrvExpTrans_Proj

TrvExpTrans

ProjectAccountingDistribution

Remarks

Creates project distributions for the TrvExpTrans table by using the DEL_TrvExpTrans_proj table. Copies the ActivityNumber field from DEL_TrvExpTrans_proj table to the TrvExpTrans table.

Data Migration Section

From Table: DEL_TrvExpTrans_Proj

To Table: TrvExpTrans

ActivityNumber

ProjActivityNumber

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

TrvExpTrans

ProjActivityNumber

ProjActivityNumber