Compartilhar via


ReleaseUpdateDB60_Srm.updatePurchReqLineUnitOfMeasure 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_Srm

Method

updatePurchReqLineUnitOfMeasure

Description

Responsible for handling upgrade of the references to the UnitOfMeasure table changing them to use the UnitOfMeasure primary key instead of natural key.

Affected Modules and Tables

Affected Modules

SRM

Affected Tables

PurchReqLine

Remarks

The string PurchUnit and ProjSalesUnitId fields have been renamed to “DEL_PurchUnit”, “DEL_ ProjSalesUnitId” respectively, replaced with RefRecId fields with the PurchUnitOfMeasure, ProjSalesUnitOfMeasure.

Data Migration Section

From Table: PurchReqLine

To Table: PurchReqLine

DEL_PurchUnit

PurchUnitOfMeasure

DEL_ ProjSalesUnitId

ProjSalesUnitOfMeasure

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

PurchReqLine

PurchUnitOfMeasure

RefRecId

PurchReqLine

ProjSalesUnitOfMeasure

RefRecId

Name Changes for Tables or Fields

Old Table Name: PurcReqLine

New Table Name: PurchReqLine

Old Field Name:

New Field Name:

PurchUnit

DEL_PurchUnit

ProjSalesUnitId

DEL_ ProjSalesUnitId