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 |