ReleaseUpdateTransformDB50_Bank.bankAccountTransDeltaPreUpgradeProcess 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 |
ReleaseUpdateTransformDB50_Bank |
Method |
bankAccountTransDeltaPreUpgradeProcess |
Description |
Transforms data from the Dimension field to the DefaultDimension field and from the LedgerAccountNum field and the Dimension field to the LedgerDimension field in the BankAccountTrans table. |
Script Type |
Preprocessing 60: Delta |
Microsoft Dynamics AX Source |
Microsoft Dynamics AX 4.0 Microsoft Dynamics AX 2009 |
Affected Modules and Tables
Affected Modules |
|---|
Bank |
Affected Tables |
|---|
BankAccountTrans |
Remarks
This upgrade is required in order to convert account and dimension data to the new accounts and dimension model for MSDAX6.
Data Migration Section
From Table: BankAccountTrans |
To Table: Shadow_BankAccountTrans |
|---|---|
Dimension |
DefaultDimension |
LedgerAccountNum, Dimension |
LedgerDimension |
New Tables or Fields
Table |
Field |
Extended Data Type -or- Base Enum |
|---|---|---|
BankAccountTrans |
DefaultDimension |
DimensionDefault |
BankAccountTrans |
LedgerDimension |
LedgerDimensionDefaultAccount |
Deleted Tables or Fields
Table |
Field |
|---|---|
BankAccountTrans |
Dimension |
BankAccountTrans |
LedgerAccountNum |