ReleaseUpdateTransformDB50_Ledger.ledgerJournalTransDeltaPreUpgradeProcess 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_Ledger
Method	ledgerJournalTransDeltaPreUpgradeProcess
Description	Transforms data from fields that hold the account and dimension data to the fields that hold the new accounts and dimension model in Microsoft Dynamics AX 2012.
Script Type	Preprocessing 60: Delta
Microsoft Dynamics AX Source	Microsoft Dynamics AX 4.0 Microsoft Dynamics AX 2009

Affected Modules and Tables

Affected Modules
General ledger

Affected Tables
LedgerJournalTrans

Remarks

This upgrade is required in order to convert account and dimension data to the new accounts and dimension model for Microsoft Dynamics AX 2012.

Data Migration Section

From Table: LedgerJournalTrans	To Table: Shadow_LedgerJournalTrans
Dimension	DefaultDimension
AccountNum	LedgerDimension
Dimension	OffsetDefaultDimension
OffsetAccount, InterCoDimension	OffsetLedgerDimension

New Tables or Fields

Table	Field	Extended Data Type -or- Base Enum
LedgerJournalTrans	DefaultDimension	DimensionDefault
LedgerJournalTrans	LedgerDimension	DimensionDynamicAccount
LedgerJournalTrans	OffsetDefaultDimension	DimensionDefault
LedgerJournalTrans	OffsetLedgerDimension	DimensionDynamicAccount

Deleted Tables or Fields

Table	Field
LedgerJournalTrans	Dimension
LedgerJournalTrans	AccountNum
LedgerJournalTrans	OffsetAccount
LedgerJournalTrans	InterCoDimension