ReleaseUpdateDB60_Trv.updateDimensionsGlobalTables 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_Trv
Method	updateDimensionsGlobalTables
Description	Upgrades the Expense Management tables that are data area ID independent. It calls several private methods where the actual upgrade work is performed.

Affected Modules and Tables

Affected Modules
Expense management

Affected Tables
TrvExpTable
TrvExpTrans
TrvExpTrans_Proj
DimensionAttribute
DimensionAttributeDirCategory
DimensionAttributeLevelValue
DimensionAttributeValue
DimensionAttributeValueCombination
DimensionAttributeValueCombinationStatus
DimensionAttributeValueGroup
DimensionAttributeValueGroupCombination
DimensionAttributeValueGroupStatus
DimensionAttributeValueSet
DimensionAttributeValueSetItem
DimensionAttributeSet
DimensionAttributeSetItem
DimensionFinancialTag
DimensionHierarchy
DimensionHierarchyLevel
DimensionValueGroupJournalControlStatus
FinancialTagCategory
LedgerParameters
MainAccount

Remarks

The DEL_Dimension field of the TrvExpTable table is upgraded to the DefaultDimension field. The DEL_Dimension field of the TrvExpTrans table is upgraded to the DefaultDimension field. Currently, nothing is upgrade in the TrvExpTrans_Prok table.- TODO after completing the Expense and Project integration.

Data Migration Section

From Table: TrvExpTable	To Table: TrvExpTable
DEL_Dimension	DefaultDimension

From Table: TrvExpTrans	To Table: TrvExpTrans
DEL_Dimension	DefaultDimension

From Table: TrvExpTrans_Proj	To Table: TrvExpTrans_Proj