ReleaseUpdateDB60_PurchReq.migrateVendReqJourandTrans 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_PurchReq

Method

migrateVendReqJourandTrans

Description

Moves data from the VendReqJour and VendReqTrans tables to the PurchReqTableHistory and PurchReqLineHistory tables, respectively. The PurchReqTableHistory and PurchReqLineHistory tables are new tables introduced in Microsoft Dynamics AX 2012.

Affected Modules and Tables

Affected Modules

SRM

Affected Tables

PurchReqTableHistory

PurchReqLineHistory

VendReqJour

VendReqTrans

Remarks

Moves data from the VendReqJour and VendReqTrans tables to the PurchReqTableHistory and PurchReqLineHistory tables, respectively. After the migration, history data for the purchase requisition would be available in the PurchReqTableHistory, PurchReqLineHistory, and other new tables.

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

PurchReqTableHistory

PurchReqLineHistory

Deleted Tables or Fields

Table

Field

VendReqJour

*

VendReqTrans

*