ReleaseUpdateTransformDB50_Basic.updateDirPartyRelationshipPreProcessing 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_Basic
Method	updateDirPartyRelationshipPreProcessing
Description	Updates the ParentParty and ChildParty fields in the DirPartyRelationship table and removes duplicate records.
Script Type	Preprocessing 60: Live
Microsoft Dynamics AX Source	Microsoft Dynamics AX 4.0 Microsoft Dynamics AX 2009

Affected Modules and Tables

Affected Modules
CRM

Affected Tables
DirPartyRelationship

Remarks

This upgrade is required to convert the ParentPartyId and ChildPartyId fields to the new party fields for Microsoft Dynamics AX 2012. The ParentParty and ChildParty fields in the DirPartyRelationship table will be kept as a reference to the DirPartyTable record. This script also removes the duplicate records as the DirPartyRelationship table becomes global table.

Data Migration Section

From Table: DirPartyRelationship	To Table: DirPartyRelationship
ParentPartyId	ParentParty
ChildPartyId	ChildParty
ValidFromDateTime	ValidFrom
ValidToDateTime	ValidTo

New Tables or Fields

Table	Field	Extended Data Type -or- Base Enum
DirPartyRelationship	ParentParty
DirPartyRelationship	ChildParty
DirPartyRelationship	ValidFrom
DirPartyRelationship	ValidTo

Deleted Tables or Fields

Table	Field
DirPartyRelationship	ParentPartyId
DirPartyRelationship	ChildPartyId
DirPartyRelationship	ValidFromDateTime
DirPartyRelationship	ValidToDateTime