ReleaseUpdateTransformDB40_Vend.purchLineDeltaPreUpgradeProcess 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

ReleaseUpdateTransformDB40_Vend

Method

purchLineDeltaPreUpgradeProcess

Description

Sets the line numbers and the reference to the SourceDocumentLine records for the PurchLine records.

Script Type

Preprocessing 60: Delta

Microsoft Dynamics AX Source

Microsoft Dynamics AX 4.0

Affected Modules and Tables

Affected Modules

Accounts payable

Affected Tables

SourceDocumentLine

Shadow_PurchLine_Vend

Shadow_PurchTable_Vend

Remarks

For each PurchLine record, a SourceDocumentLine record is created. The value of the SourceDocument field is set to the value of the same field in the Shadow_PurchTable_Vend table.

Data Migration Section

From Table: Shadow_PurchTable_Vend

To Table: SourceDocumentLine

SourceDocument

SourceDocument

From Table: SourceDocumentLine

To Table: Shadow_PurchLine_Vend

RecId

SourceDocumentLine

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

SourceDocumentLine

SourceDocument

RefRecId

PurchLine

SourceDocumentLine

RefRecId

PurchLine

LineNumber

TradeLineNumber

Deleted Tables or Fields

Table

Field

VendInvoiceTrans

Dimension

VendInvoiceTrans

LedgerAccount